/** * appends sql to given select statement * * @param Zend_Db_Select $_select * @param Tinebase_Backend_Sql_Abstract $_backend */ public function appendFilterSql($_select, $_backend) { // prepare value $value = (array) $this->_getDateValues($this->_operator, $this->_value); // quote field identifier $field = $this->_getQuotedFieldName($_backend); // db $this->_db = Tinebase_Core::getDb(); // append query to select object foreach ((array) $this->_opSqlMap[$this->_operator]['sqlop'] as $num => $operator) { if (array_key_exists($num, $value)) { if (get_parent_class($this) === 'Tinebase_Model_Filter_Date' || in_array($this->_operator, array('isnull', 'notnull'))) { $_select->where($field . $operator, $value[$num]); } else { $value = Tinebase_Backend_Sql_Command::setDateValue($this->_db, $value[$num]); $_select->where(Tinebase_Backend_Sql_Command::setDate($this->_db, $field) . $operator, $value); } } else { if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) { Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' No filter value found, skipping operator: ' . $operator); } } } }