public function pageListBody($p, $z) { $where = Filter::jsonToSql($_GET['filterData']); $sql = "SELECT\n\t\t\t\t\t*\n\t\t\t\tfrom\n\t\t\t\t\trequest\n\t\t\t\twhere\n\t\t\t\t\t{$where}"; $requests = DbObject::_findBySql('request', $sql, array()); $this->assign('requests', $requests); $this->layout = false; $this->display('list_body'); }
public function pageQuery() { $jane = DbObject::_getOne('PersonStuff', array('firstname' => 'Jane', 'lastname' => 'Doe')); $all = DbObject::_find('PersonStuff'); $this->assign('all', $all); $odd = DbObject::_findByWhere('PersonStuff', "id % 2 == 0", array()); $this->assign('odd', $odd); $sqled = DbObject::_findBySql('PersonStuff', "select id from person_stuff where firstname like 'J%'", array()); $this->assign('sqled', $sqled); $one = DbObject::_findOne('PersonStuff', array('firstname' => 'Jane')); $this->assign('one', $one); }
public static function getDrafts() { $sql = "SELECT * from entry where published_date is null order by id desc"; $entries = DbObject::_findBySql('Entry', $sql, array()); return $entries; }