[PATCH] Add support for sorting objects in categories

Just done it. I'll release patch soon.

Hi ! So did you do the patch ? I would be interested. I thought it was a native feature of the plugin, i've got the same problem as i want to rank my objects by user.

key support in lib/model/Item.php

class Item extends BaseItem
{
  // whatever
}

sfPropelBehavior::add('Item', array('act_as_sortable' => array(
  'column' => 'rank',
  'key' => 'key_id',
  'new_element_position' => 'bottom'
)));

Patch for ticket:3240 - added optional key value sorting on top of latest svn revision

I took the class file from the svn repository (so latest version) and added optional key support.

sfPropelBehavior::add('Item', array('act_as_sortable' => array(
  'column' => 'rank',
  'key' => 'key_id',
  'new_element_position' => 'bottom'
)));

key is optional here, if you have no key to sort by in your table - then don't set this option. It defaults to null, and sorts as normal.

If you do have a key to sort by, such as album_id, then add it here, and it will sort within the album.

NOTE: You may need to reset any existing sorting, otherwise the decremented on move can produce minus numbers :)

I've tested with and without keys, and have had no problems.

Added support for multiple keys...

If you want to sort by multiple keys, just add key as an array of keys. Just have a look at the next exemple:

sfPropelBehavior::add('Category', array('act_as_sortable' => array(
  'column' => 'rank',
  'key' => array('shop_id', 'category_id'),
  'new_element_position' => 'bottom'
)));

Array for multiple keys supported

Hi.. Do you guys have plan to release this patch in the near future?? I guess a lot of people would be interested in this.....

Carlos

+1, please apply the patch.. I don't see any reason why it shouldn't be included ?

I'll check both patches but probably I'll apply only single-scope version for Propel 1.2 and Propel 1.3 (which will be available really soon, so keep checking ;). Also, I've written myself single scope support so I'll compare, take best of them and apply it. Version for Propel 1.4 will be done soon also. Propel 1.5 comes with Sortable Behavior so plugin won't be needed then. I'd like to make it stable so please post any bugs and ideas. Cheers, rozwell

Dang, I'm always forgetting about this WikiFormatting :p
I've just added Propel 1.3 branch for syfony 1.2 with single scope support, so you can try it out.
Setting as fixed for now.
rozwell