Esempio n. 1
0
 function fetch()
 {
     $this->setSort('createdAt DESC');
     $this->db->select("DATE_FORMAT(`createdAt`,'%e %b %Y') as 'createdDate'", false);
     $this->db->select("DATE_FORMAT(`sentAt`,'%e %b %Y') as 'sentDate'", false);
     return parent::fetch();
 }
Esempio n. 2
0
 function fetchPhoneJSON()
 {
     $this->setSort('userMetas.sort');
     //	$this->db->select('clientMetaID as entityID');
     $this->schemaName = 'phone';
     $result = parent::fetch();
     return json_encode($result);
 }
Esempio n. 3
0
 private function getOne()
 {
     $this->db->select('clients.*');
     $this->db->join('clients', 'clientID = clientsID', 'left outer');
     return reset(parent::fetch());
 }
Esempio n. 4
0
 function fetchJSON()
 {
     $result = parent::fetch();
     return json_encode($result);
 }
Esempio n. 5
0
 function fetch()
 {
     $this->setSort('metas.sort');
     $this->setSort('metas.schemaName');
     return parent::fetch();
 }
Esempio n. 6
0
 function fetch()
 {
     $this->setSort('page_uri');
     return parent::fetch();
 }
Esempio n. 7
0
 function fetch()
 {
     $this->setSort('createdAt DESC');
     return parent::fetch();
 }
Esempio n. 8
0
 function fetch()
 {
     $this->setSort('lastName, firstName');
     return parent::fetch();
 }