/**
* (non-PHPdoc)
* @see \Simplify\Form\Repository::delete()
*/
public function delete($id = null, $params = array())
{
$table = $this->table;
$pk = $this->pk;
$sort = $this->sortColumn;
$old = \Simplify::db()->query()->from($table)->select("{$sort}")->where($this->filter())->where("{$pk} = ?")->execute($id)->fetchOne();
\Simplify::db()->query("UPDATE {$table} SET {$sort} = {$sort} - 1 WHERE {$this->filter()} AND {$sort} > {$old}")->execute();
return parent::delete($id, $params);
}
/**
* (non-PHPdoc)
* @see \Simplify\Form\Repository::update()
*/
public function update(&$data)
{
$row = $this->find($data[$this->pk]);
if ($row[$this->parent] != $data[$this->parent]) {
$this->mptt()->move($data[$this->pk], $data[$this->parent], \Simplify\Db\MPTT::LAST_CHILD);
}
return parent::update($data);
}
