Of course I tasted. However, the working version was never found. Here's my
attempt:
Variant 1:
$result = $this->Models->find()
->where(function ($exp) {
$notz = $exp->or_(['kw LIKE' =>
$word_7])
->eq('kw LIKE', $word_8)
->eq('kw LIKE', $word_9
);
$and = $exp->and_(['kw LIKE' =>
$word_1])
->eq('kw LIKE', $word_2)
->eq('kw LIKE', $word_3
);
$and2= $exp->and_(['kw LIKE' =>
$word_4])
->eq('kw LIKE', $word_5)
->eq('kw LIKE', $word_6
);
return $exp->add($and)
->add($and2)
->not($notz);
});
Variant 2:
$result = $this->Models->find()
->where([
'OR' => [
['AND' => [['kw LIKE' => $word_1],['kw LIKE' =>
$word_2],['kw LIKE' => $word_3]]],
['AND' => [['kw LIKE' => $word_4],['kw LIKE' =>
$word_5],['kw LIKE' => $word_6]]]],
['NOT' => [['kw LIKE' => $word_7],['kw LIKE' => $word_8
],['kw LIKE' => $word_9]]]
]);
четверг, 4 июня 2015 г., 1:42:04 UTC+5 пользователь José Lorenzo написал:
>
> What have you tried so far? Did you read the documentation on creating
> queries in cake 3?
>
> On Wednesday, June 3, 2015 at 7:58:44 AM UTC+2, InYan wrote:
>>
>> in cakephp v.1.3.x I used $this->Model->query($q);
>>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
