Log message #4157936

# At Username Text
# Jul 11th 2018, 09:03 Martin` I like the tree's in this usage, I need to make groups where stores are in. as I see now it is up to 2 deep
# Jul 11th 2018, 09:03 lorenzo yeah, plenty
# Jul 11th 2018, 09:03 josbeir but that has issues too
# Jul 11th 2018, 09:03 josbeir theres adjenceny lists...
# Jul 11th 2018, 09:03 lorenzo josbeir do you know a better representation for trees in sql? I know of one, but not all database support them
# Jul 11th 2018, 09:02 Martin` lorenzo: Yes al the parents up the root
# Jul 11th 2018, 09:02 slackebot4 Action: josbeir shouts his humble opinion
# Jul 11th 2018, 09:01 josbeir nested sets are so pasé
# Jul 11th 2018, 09:01 josbeir talking about tree's, why is that stuff still in core :)
# Jul 11th 2018, 08:59 lorenzo or just the immediate parent?
# Jul 11th 2018, 08:58 lorenzo Martin` you want all parents up to the root of the tree?
# Jul 11th 2018, 08:58 josbeir read up on this over here: https://book.cakephp.org/2.0/en/development/routing.html#route-elements
# Jul 11th 2018, 08:57 josbeir ok
# Jul 11th 2018, 08:57 prasanna.venkat ok i will try this out
# Jul 11th 2018, 08:57 josbeir router would look at the specialpage argument and would try to match it to the argument you provided when building your route
# Jul 11th 2018, 08:57 josbeir i'm just typing this stuff out of my head but it would probably point you in the right direction
# Jul 11th 2018, 08:56 josbeir $this->Paginator->options('url' => [ 'controller' => 'allpages', 'specialpage' => 'scrapbookingpages' ]);
# Jul 11th 2018, 08:56 Martin` think the easiest way to get the parents is to always show all parents
# Jul 11th 2018, 08:56 josbeir then in your route pass that argument
# Jul 11th 2018, 08:55 josbeir @prasanna.venkat you could try something using a special key: Router::connect('/:specialpage', [ 'controller' => 'allpages' ], [ 'specialPage' => 'scrapbookingpages' ])
# Jul 11th 2018, 08:55 Martin` I'm sorting on lft to get the right order so I can simple build the tree in the view.
# Jul 11th 2018, 08:54 Martin` lorenzo: I've a tree with stores, not I want to search the stores, but I also need the parents of the stores
# Jul 11th 2018, 08:53 prasanna.venkat with uniqueness
# Jul 11th 2018, 08:52 prasanna.venkat then how to create such route
# Jul 11th 2018, 08:52 lorenzo Martin` you need to add more context yo your question, it is not clear what you want to do
# Jul 11th 2018, 08:52 josbeir will cause issues tho
# Jul 11th 2018, 08:51 josbeir i forgot if its in request or not
# Jul 11th 2018, 08:51 josbeir $this->Paginator->pagination(array(‘ul’ => $this->here)); or $this->Paginator->pagination(array(‘ul’ => $this->request->here));
# Jul 11th 2018, 08:51 josbeir you could try this but i forgot it it would work in cake 2
# Jul 11th 2018, 08:51 josbeir there is no way to match the uniqueness of your current route
# Jul 11th 2018, 08:50 josbeir it should but the issue also lies with your routes
# Jul 11th 2018, 08:50 prasanna.venkat is this explained in documentation
# Jul 11th 2018, 08:49 josbeir you must generate an url array that matches the route you want
# Jul 11th 2018, 08:49 josbeir $this->Paginator->pagination(array(‘url' => ...
# Jul 11th 2018, 08:47 prasanna.venkat @josbeir how to add url in paginator
# Jul 11th 2018, 08:46 Martin` :P
# Jul 11th 2018, 08:46 Martin` I've ask this question already yesterday, but I did not solved my problem yet. I'm using crud plugin with the search plugin. Now I want to search, but I always want the groups of the items what i'm searching. how can I add something to query that I always find the groups? I already tried in beforePaginate to add ->orWhere(['folder' => 1]); to query, but that does not work, I only found the groups/folders
# Jul 11th 2018, 08:37 josbeir so you need to pass your context somewhere so the url's that are built in your view are aware of the current name
# Jul 11th 2018, 08:37 josbeir the issue is also, you are creating multiple routes that all point to the same action, paginator wants to build a url based on current controller/action, it will check the routes you defined and return the first match
# Jul 11th 2018, 08:36 prasanna.venkat $this->Paginator->pagination(array(‘ul’ => ‘pagination’)); in view how to add options to this
# Jul 11th 2018, 08:34 josbeir $this->Paginator->options(array('url' => ... ))