Digital Fashion - Zend Framework Pagination, third strike - Comments

Zend Framework Pagination, third strike - Geoffrey

Geoffrey — Tue, 01 Jan 2008 14:35:07 +0100

Hi brandon, there's no way atm to set the items per page property, I'm aware of this and this will be fixed in the next release, as well as the html syntax quirk you're pointing.

thanks for your feedback

Zend Framework Pagination, third strike - brandon

brandon — Fri, 28 Dec 2007 18:33:44 +0100

Great job on the pager. One thing that i am not clear on however, is there a way to set the _itemsPerPage property in Riskle_Db_Table_Paginate class?

I noticed also in the view helper that there was a syntax error in the default html. you start with a <p> but end with a </li> for the previous and next functions.

Zend Framework Pagination, third strike - jude

jude — Sun, 16 Dec 2007 22:37:33 +0100

i am a newbie. where do i place the library files?

Zend Framework Pagination, third strike - Erik

Erik — Mon, 24 Sep 2007 14:45:25 +0200

As far as I know the problem stems from a MySQL limitation, not supporting FULL OUTER JOIN. I've seen some hacks that use UNIONs to get the desired result but I'm not sure how well it would translate to the framework and unfortunately don't have the time to investigate right now. If I get some free time and find a better method I'll post it. :-)

Zend Framework Pagination, third strike - Geoffrey

Geoffrey — Mon, 24 Sep 2007 11:18:59 +0200

Once again thanks for the patch :-) While I not found this a very clean way of doing things, it'll do the job for the moment as I can't think (did not take the time to think actually) of another way to fix the problem.

Concerning the _fetch thing, I can't believe I did not think of it earlier. Patching at the lower level seems the way to go.

Zend Framework Pagination, third strike - Rumeurs

Rumeurs — Mon, 24 Sep 2007 09:12:01 +0200

tu composes tes articles àune heure ben tardive ! :)

Zend Framework Pagination, third strike - Erik

Erik — Sun, 23 Sep 2007 11:18:27 +0200

Once again thanks for the code. I think you mean previous() instead of prev() though.

Another small fix, if you have 2 tables that don’t completely map together (ex: you have a log table that maps it’s user id to a user table, if one of the user ids doesn’t exist the log row will get ignored) the fetchAll will return the filtered rows and the fetchCount will return them all (in my case fetchAll returned 260 and fetchCount returned 262, so I had 1 extra page that had no entries)

To fix it you just need to apply the parent mapping to fetchCount, I had to also add a variable to _applyParentMap so it didn’t try to select the mapped fields when selecting the count.

http://code.ryvondesigns.com/riskle...
http://code.ryvondesigns.com/riskle...

Also, while I was attempting to fix this I might’ve stumbled upon an easier way to apply the parent map to fetchRow and fetchAll. First I removed fetchAll , fetchRow, and _makeRowset. Then I added a copy of Zend_Db_Table_Abstract’s _fetch method with _applyParentMap inside it. It seemed to work fine in my tests, I didn’t include it in the patch since I haven’t tested it much but you might want to look at it sometime.