/** * Fix order before update * @param IRecord record */ public function fixOrderBeforeUpdate(IRecord $record) { if ($record->isValueModified($this->orderColumn) || isset($this->groupColumn) && $record->isValueModified($this->groupColumn)) { $original = $record->find($record->getPrimary()); $columns[] = $this->orderColumn; if (isset($this->groupColumn)) { $columns[] = $this->groupColumn; } $original->loadValues($columns); $db = $record->getMapper()->getDb(); $fluent = $db->update($record->getMapper()->getTable(), array($this->orderColumn . "%sql" => array("%n - 1", $this->orderColumn)))->where("%n > %i", $this->orderColumn, $original->{$this->orderColumn}); if (isset($this->groupColumn)) { $type = $record->getConfig()->getType($this->groupColumn); $fluent->where("%n = %{$type}", $this->groupColumn, $original->{$this->groupColumn}); } $fluent->execute(); $fluent = $db->update($record->getMapper()->getTable(), array($this->orderColumn . "%sql" => array("%n + 1", $this->orderColumn)))->where("%n >= %i", $this->orderColumn, $record->{$this->orderColumn}); if (isset($this->groupColumn)) { $fluent->where("%n = %" . $record->getConfig()->getType($this->groupColumn), $this->groupColumn, $record->{$this->groupColumn}); } $fluent->execute(); } }