/** * (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); }