Exemple #1
0
 /**
  * method to get requests by field
  * @param type $by
  */
 public static function getRequests($filterValue, $filterBy = 'request_id', $fields = array(), $where = array(), $orderBy = 'id DESC', $limit = 1)
 {
     $tbl = new Application_Model_DbTable_Requests(Np_Db::slave());
     $select = $tbl->select()->from($tbl->info(Zend_Db_Table_Abstract::NAME), $fields);
     $select->where($tbl->getAdapter()->quoteIdentifier($filterBy) . ' = ?', $filterValue)->order($orderBy)->limit(intval($limit));
     foreach ($where as $cond => $value) {
         $select->where($cond, $value);
     }
     //		print($select);
     return $select->query()->fetchAll();
 }