/** * 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'); } }