# |
Jul 19th 2017, 13:28 |
sauvaget |
which of course contain entries |
# |
Jul 19th 2017, 13:27 |
sauvaget |
Favorites are are individual lists |
# |
Jul 19th 2017, 13:26 |
sauvaget |
sorry the Database Design is a absolut mess |
# |
Jul 19th 2017, 13:26 |
sauvaget |
yeah, but i only want to filter the FavoriteEntries not the Favorites |
# |
Jul 19th 2017, 13:25 |
hmic |
by the projects |
# |
Jul 19th 2017, 13:25 |
sauvaget |
but wouldn't I then be filtering the Favorites? |
# |
Jul 19th 2017, 13:22 |
hmic |
dont put the matching FavoriteEntries.Projects inside the FavoriteEntries but next to it |
# |
Jul 19th 2017, 13:22 |
neon1024 |
But this change would be strictly for debugging and development purposes! |
# |
Jul 19th 2017, 13:22 |
VersadrillCanada |
thx |
# |
Jul 19th 2017, 13:22 |
hmic |
yes |
# |
Jul 19th 2017, 13:22 |
neon1024 |
@VersadrillCanada, I would just have your `isAuthorized()` method always return true |
# |
Jul 19th 2017, 13:21 |
sauvaget |
thanks! |
# |
Jul 19th 2017, 13:21 |
sauvaget |
that's what I'll do then |
# |
Jul 19th 2017, 13:21 |
neon1024 |
As matching filters associations by a parent, so you’d contain, then matching afterwards. At least, that’s what I do |
# |
Jul 19th 2017, 13:21 |
VersadrillCanada |
im doing the bookmark exercise on the web site and i implement the authorization and i want to turn it off without removing all the code i made to access something without the user authorizatrion. thx |
# |
Jul 19th 2017, 13:21 |
sauvaget |
that's the question ;) |
# |
Jul 19th 2017, 13:21 |
neon1024 |
Plus, I’m not sure you can use matching inside a contain |
# |
Jul 19th 2017, 13:20 |
sauvaget |
same error |
# |
Jul 19th 2017, 13:20 |
sauvaget |
yeah, just tried that aswell |
# |
Jul 19th 2017, 13:20 |
neon1024 |
It’s just ‘Projects’ |
# |
Jul 19th 2017, 13:19 |
sauvaget |
as soon as I integrate the matching() I receive a "FavoriteEntries is not associated with" |
# |
Jul 19th 2017, 13:17 |
hmic |
whats the problem? |
# |
Jul 19th 2017, 13:17 |
hmic |
looks like it is |
# |
Jul 19th 2017, 13:15 |
sauvaget |
I've added the whole query. Just wanted to ask in general if it is possible to do something like that? |
# |
Jul 19th 2017, 13:14 |
sauvaget |
sry ;) https://gist.github.com/l0rdseth/d8676a93f64311cd66a9a3ba985c1400 |
# |
Jul 19th 2017, 13:12 |
hmic |
!tell sauvaget about gist |
# |
Jul 19th 2017, 13:09 |
sauvaget |
unfortunatly, I am getting some association error. :( |
# |
Jul 19th 2017, 13:09 |
slackebot |
return $q->where(['active' => 1]); } ]) ->order(['created' => 'DESC']); }, ]) ``` |
# |
Jul 19th 2017, 13:09 |
sauvaget |
Hey guys, can I use a matching within a contain? ``` ->contain([ 'FavoriteEntries' => function ($q) { return $q ->select([ 'id', 'projectId', 'favoriteListId', ]) ->matching([ 'FavoriteEntries.Projects' => function ($q) { |
# |
Jul 19th 2017, 12:58 |
hmic |
welcome |
# |
Jul 19th 2017, 12:58 |
Ecorce |
Ok, thank you very much everyone :) |
# |
Jul 19th 2017, 12:58 |
hmic |
with none of that, you are right, it would look in the current namespace/dir only |
# |
Jul 19th 2017, 12:57 |
hmic |
or you explicitely use it with that namespace |
# |
Jul 19th 2017, 12:57 |
hmic |
you eighter have a use statement in the top of the controller importing it |
# |
Jul 19th 2017, 12:57 |
Ecorce |
yep, I didn't write the namespace of the AppController to use. I guess it extended that App\Controller\AppController, by default |
# |
Jul 19th 2017, 12:54 |
hmic |
no, you need to use the correct one too - that what the namespaces are good for :p |
# |
Jul 19th 2017, 12:54 |
adriencs |
you extended the wrong AppController ? |
# |
Jul 19th 2017, 12:52 |
Ecorce |
ouch I've found... needed to use App\Controller\Api\AppController in every Controller using it... I thought it would be enough just to create an AppController (the extended class) inside the same folder. |
# |
Jul 19th 2017, 12:47 |
Ecorce |
However, in the beforeFilter of that controller (my second page), there's a $this->Auth->allow() and no error thrown... |
# |
Jul 19th 2017, 12:46 |
Ecorce |
In the second page, that session data is unset (confirmation in debugkit= |
# |
Jul 19th 2017, 12:45 |
Ecorce |
I check in the beforeFilter of the Api/AppController is $this->Auth->user('id') is set. If not, I throw an exception (except for login, obviously). |