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();
}
public function __construct(Am_Table $table = null)
{
$this->table = $table;
if (!empty($table->_importNested)) {
foreach ($table->_importNested as $t) {
$this->nested[] = new self($t);
}
}
$this->id = $this->table ? $table->getName(true) : 'NULL';
}
public function addFieldSelect($name, Am_Table $table, $title, array $options)
{
$fs = $this->form->addFieldset()->setLabel($title . ' Columns: ' . $table->getName(true));
$sampleRows = $table->getAdapter()->select("SELECT * FROM ?#\n LIMIT ?d,3", $table->getName(true), max($table->countBy() - 3, 0));
$sample = "<div style='color: lightgray'>";
foreach ($sampleRows as $r) {
$sample .= nl2br(Am_Controller::escape(substr(print_r($r, true), 0, 1024))) . "\n";
}
$sample .= "</div>";
$fs->addStatic()->setLabel('Sample Rows')->setContent($sample);
$fields = $table->getFields(true);
$fields = array_merge(array(''), $fields);
foreach ($options as $k => $v) {
$el = $fs->addSelect('field[' . $name . '][' . $k . ']')->setLabel($v)->loadOptions(array_combine($fields, $fields));
if (!in_array($k, array('Am_Protect_SessionTable::FIELD_UID', 'Am_Protect_SessionTable::FIELD_IP', 'Am_Protect_SessionTable::FIELD_UA', 'Am_Protect_SessionTable::FIELD_CREATED', 'Am_Protect_SessionTable::FIELD_CHANGED'))) {
$el->addRule('required');
}
}
}
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);
}
}
