Adding pagination after merging two PageArrays?

[landitus]

Is it possible to add pagination limit after merging to PageArrays? I'm querying pages for an event calendar where there are two conditions:

• Events that are starting in the future
• Events that started in the past but are ending in the future (aka are current)

I've coded the following but I want to limit the results to trigger the pagination, but my code is not working.

What can I do?

$events = $pages->find("template=event, date>=today, sort=date");
$events = $events->append($pages->find("template=event, date<=today, date_end>=today,sort=date"));
$events = $events->find("limit=15");

[adrian]

A couple of posts that might help you out:

http://processwire.com/talk/topic/3384-search-with-merged-pagearrays-pagination-not-working/?p=33360

http://processwire.com/talk/topic/4257-ordering-by-date-reversed-then-time-normal-order/?p=42365

[Soma]

There's a couple threads about this. This is where my solutions are: https://gist.github.com/somatonic/5420536

Pagination module works only for a single find. You can set the start limit and total yourself to get a working pager, but you have to load all pages everytime. Means it works better for smaller amounts.

[diogo]

I like this solution:

$events1 = $pages->find("template=event, date>=today");
$events2 = $pages->find("template=event, date<=today, date_end>=today");
$events = $pages->find("id=$events1|$events2, sort=date, limit=15");

// now you can paginate $events
 

[landitus]

Well, what can say... What an awesome amount of responses!! I was able to do it Diogo's way but all 3 are excellent answers. You all saved my day, so thank you!

[Soma]

That's also a nice solution by diogo. But will increase loading all pages even more along with memory.

[landitus]

With more time, I may try the other more elaborated solutions and keep an eye on performance. 

[Soma]

Also depending how many events there are you'll run into a max length of selector with digo solution no? Isn't it limited to a length?

[diogo]

Also depending how many events there are you'll run into a max length of selector with digo solution no? Isn't it limited to a length?

hm, not sure... is it?

[landitus]

I will be displaying all events in the future and there will be 150/200 for the current year. It only has events for the current year. Do you think this will be a problem? 

[diogo]

Also depending how many events there are you'll run into a max length of selector with digo solution no? Isn't it limited to a length?

I tried with more than 5000 IDs and it worked (they were the same IDs repeated, but I don't think it makes a difference)

Edit: With 8000 still works, but with short more than that it breaks

Edit2: false alarm, it was a mistake in my code. With more than 25.000 IDs it takes long but still works. With much more than that it doesn't, but I'm guessing it's because of PHP time limit.

Edit3: "Maximum execution time of 30 seconds exceeded"

[videokid]

Funny, today I stumbled on a similar issue.... 

"show me 15 messages where end date is greater then today, or if there's no end date, give me the ones created at least month ago"

in another cms you could do something like this:

$events = $pages->find("template=event,(date>=$today)|(created>=$lastmonth,date=''),sort=-created,limit=15)");

seems 'date' in this case is not unique, which results in an error...

IF that would work, pagination should work as supposed, no?