function __construct(Am_Table $table, $alias = 't')
{
$this->db = $table->getAdapter();
$this->table = $table;
$this->alias = $alias;
$this->tableName = $table->getName();
$this->keyField = $table->getKeyField();
}
/**
* Replaces only already exists fields, except the PK
* @param array $vars
* @return Am_Record provides flient interface
*/
public function setForUpdate($vars)
{
$keyField = $this->_table->getKeyField();
foreach ($vars as $key => $value) {
if ($key != $keyField && $this->_isValidField($key) && property_exists($this, $key)) {
$this->{$key} = $value;
}
}
return $this;
}
protected function _simpleSort(Am_Table $table, $item, $after, $before)
{
$after = $after ? $after['id'] : null;
$before = $before ? $before['id'] : null;
$id = $item['id'];
$table_name = $table->getName();
$pk = $table->getKeyField();
$db = Am_Di::getInstance()->db;
$item = $table->load($id);
if ($before) {
$beforeItem = $table->load($before);
$sign = $beforeItem->sort_order > $item->sort_order ? '-' : '+';
$newSortOrder = $beforeItem->sort_order > $item->sort_order ? $beforeItem->sort_order - 1 : $beforeItem->sort_order;
$db->query("UPDATE {$table_name}\n SET sort_order=sort_order{$sign}1 WHERE\n sort_order BETWEEN ? AND ? AND {$pk}<>?", min($newSortOrder, $item->sort_order), max($newSortOrder, $item->sort_order), $id);
$db->query("UPDATE {$table_name} SET sort_order=? WHERE {$pk}=?", $newSortOrder, $id);
} elseif ($after) {
$afterItem = $table->load($after);
$sign = $afterItem->sort_order > $item->sort_order ? '-' : '+';
$newSortOrder = $afterItem->sort_order > $item->sort_order ? $afterItem->sort_order : $afterItem->sort_order + 1;
$db->query("UPDATE {$table_name}\n SET sort_order=sort_order{$sign}1 WHERE\n sort_order BETWEEN ? AND ? AND {$pk}<>?", min($newSortOrder, $item->sort_order), max($newSortOrder, $item->sort_order), $id);
$db->query("UPDATE {$table_name} SET sort_order=? WHERE {$pk}=?", $newSortOrder, $id);
}
}
