示例#1
0
 /**
  * appends custom filters to a given select object
  * - add user phone ids to filter
  * 
  * @param  Zend_Db_Select                    $_select
  * @param  Tinebase_Backend_Sql_Abstract     $_backend
  * @return void
  */
 public function appendFilterSql($_select, $_backend)
 {
     $accountIdFilter = $this->_findFilter('account_id');
     if ($accountIdFilter !== NULL) {
         $db = Tinebase_Core::getDb();
         $backend = new Voipmanager_Backend_Snom_Phone();
         $_validPhoneIds = $backend->getValidPhoneIds($accountIdFilter->getValue());
         if (empty($_validPhoneIds)) {
             $_select->where('1=0');
         } else {
             $_select->where($db->quoteInto($db->quoteIdentifier($_backend->getTableName() . '.id') . ' IN (?)', $_validPhoneIds));
         }
         // remove filter
         $this->_removeFilter('account_id');
     }
 }