// if ($p->count() == 0) {
// $title[] = 'Contacts';
// } else {
// $a_id = $p->getItem(1)->name;
// $z_id = $p->getItem($p->getCurrentItemCount())->name;
//
// $title[] = sprintf('%s through %s',$a_id,$z_id);
// }
// $title[] = sprintf('Page %d of %d',$page->getCurrentPageNumber(),$page->count());
$_ENV['title'] = $title;
// $this->view->Page = $p;
/*
$rq = $this->getRequest();
// Automatic Query?
if ($a = $rq->getQuery('a')) {
}
//$ss->where('kind_id in (100,300)');
$sql->order(array('contact','company'));
$sql->limitPage($this->view->Paginator->page,$this->view->Paginator->limit);
// View!
$this->view->ContactList = $db->fetchAll($sql);
$this->view->title = array(
'Contacts',
'Page ' . $this->view->Paginator->page . ' of ' . $this->view->Paginator->pmax,
);
*/
$this->ContactList = SQL::fetch_all($sql, $arg);
Session::flash('fail', SQL::lastError());
/**
AppModel Save
@todo use the _data interface, check for dirty
*/
function save()
{
// Set Sane Defaults
// if (empty($this->_data['auth_user_id'])) {
// $this->_data['auth_user_id'] = $_SESSION['uid']; // $cu->id;
// }
// if (empty($this->_data['hash'])) $this->_data['hash'] = $this->hash();
// Set some Fields to Null
// if (empty($this->_data['link_to'])) $this->_data['link_to'] = null;
// if (empty($this->_data['link_id'])) $this->_data['link_id'] = null;
if (isset($this->_data['link_to'])) {
if (empty($this->_data['link_to'])) {
$this->_data['link_to'] = null;
}
}
if (isset($this->_data['link_id'])) {
if (empty($this->_data['link_id'])) {
$this->_data['link_id'] = null;
}
}
// Convert to Array
// $rec = array();
// foreach ($this->_properties as $k) {
// if (empty($this->$k)) {
// $rec[$k] = new Zend_Db_Expr('null');
// } else {
// $rec[$k] = $this->$k;
// }
// }
// unset($rec['id']);
$rec = array();
foreach ($this->_data as $k => $v) {
$rec[$k] = $v;
}
// @todo implement ts_vector
// update vendors set fulltext = to_tsvector('english',name || ' ' || coalesce(description,''))
if (isset($this->_properties['fulltext'])) {
// Build Full Text
// foreach ($this->_properties as $k=>$v) {
//
// }
}
if ($this->_data['id']) {
// if ($this->_diff) Base_Diff::diff($this);
SQL::update($this->_table, $rec, "id={$this->_data['id']}");
} else {
$this->_data['id'] = SQL::insert($this->_table, $rec);
if (intval($this->_data['id']) == 0) {
Radix::dump($this);
Radix::dump(SQL::lastError());
Radix::trace('Unexpected error saving: ' . get_class($this));
}
// if ($this->_diff) Base_Diff::diff($this);
}
}
