| # |
Jul 11th 2018, 09:11 |
 prasanna.venkat |
:+1: thanks |
| # |
Jul 11th 2018, 09:11 |
lorenzo |
Martin` collect all children you need with the search, and the fetch again parents for those, I cannot come up right now with a query to collect all parents, so I’ll let you figure that out for yourself |
| # |
Jul 11th 2018, 09:11 |
josbeir |
you are mixing caps :P |
| # |
Jul 11th 2018, 09:11 |
josbeir |
use specialPage, not specialpage |
| # |
Jul 11th 2018, 09:10 |
prasanna.venkat |
$this->Paginator->options(array(‘url’ => [ ‘controller’ => ‘allpages’, ‘specialpage’ => $page_template_name ])); echo $this->element(‘pagination’); |
| # |
Jul 11th 2018, 09:10 |
prasanna.venkat |
current route $pages = array(‘scrapbookingpages’, ‘comicpages’, ‘addtoscenepages’, ‘colouringpages’, ‘gamepages’, ‘parentpage’); foreach ($pages as $page) { Router::connect(‘/:specialPage/:action/*’, array(‘controller’ => ‘allpages’), array(‘specialPage’ => $page)); Router::connect(‘/:controller/‘.$page.‘/*’, array(‘controller’ => ‘user_created_pages’, ‘action’ => |
| # |
Jul 11th 2018, 09:09 |
josbeir |
show me your route and the paginator options |
| # |
Jul 11th 2018, 09:08 |
prasanna.venkat |
@josbeir the url becomes /allpages/index/specialpage:comicpages/page:2 but i need /comicpages/index/page:2 |
| # |
Jul 11th 2018, 09:08 |
lorenzo |
Martin` I think you should start simple and use 2 queries |
| # |
Jul 11th 2018, 09:07 |
Martin` |
walmart is just an exemple, don't sure if they have different owners per store :P |
| # |
Jul 11th 2018, 09:06 |
Martin` |
Owner is optional, because not all walmarts owners have multiple stores :P |
| # |
Jul 11th 2018, 09:06 |
Martin` |
it is not a difficult tree, just something like 'Walmart' > 'Owner' > 'Store' |
| # |
Jul 11th 2018, 09:06 |
josbeir |
ignore me |
| # |
Jul 11th 2018, 09:06 |
josbeir |
i'm just not a fan :) |
| # |
Jul 11th 2018, 09:06 |
josbeir |
en rebuilding a tree of very large datasets is not always convenient |
| # |
Jul 11th 2018, 09:05 |
josbeir |
but sometimes that is not enough |
| # |
Jul 11th 2018, 09:05 |
josbeir |
thats the go to solution yes |
| # |
Jul 11th 2018, 09:05 |
Martin` |
then you have to rebuild the full tree? |
| # |
Jul 11th 2018, 09:04 |
josbeir |
its just, when trees fail, they fail hard |
| # |
Jul 11th 2018, 09:04 |
josbeir |
i always try to avoid trees when i'm developing something |
| # |
Jul 11th 2018, 09:04 |
lorenzo |
i think nested set is a good trade off for most web applications |
| # |
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' ]) |