Restart sequence about cakephp-sequence HOT 4 CLOSED

There's already start config for your option 2.

from cakephp-sequence.

Thank you for your reply!

I have set this to 1 but even though it does not start with 1 in database

expected is 'blue' 1,2,3 but sequence is 5,15,16 .. well for order query it does work fine, but for my special usecase when I wanna retrieve just 3rd item of the member_id = 12 it does not work as the 3rd item has value 16

hope it makes sense?

from cakephp-sequence.

Starting with a "clean" table the behavior will set number in continuous sequence starting with the value specified for start. I don't know how you ended up with those values.

from cakephp-sequence.

I found workaround for my case.

Probably not that often issue so you can ignore that. But thank you for you help and for this plugin!

    /**
     * Method: beforeSave
     *
     * Refresh order to be 1,2,3 .. after save
     *
     * @param Event $event Event
     * @param EntityInterface $entity Entity
     * @param ArrayObject $options Options
     * @return void
     */
    public function afterSaveCommit(Event $event, EntityInterface $entity, \ArrayObject $options)
    {
        if (!empty($entity->member_id)) {
            $sort = $this
                ->find('list', [
                    'keyField' => 'id',
                    'valueField' => 'id'
                ])
                ->where(['member_id' => $entity->member_id])
                ->order(['member_sort' => 'desc'])
            ->toArray();  

            $this->setOrder($sort);
        }
    }

from cakephp-sequence.