protected function getWhereClauseByFilter(Model_Rate_Filter $filter) { $where = "1=1 "; $and = " AND "; $adapter = $this->getDbTable()->getAdapter(); if ($filter->getId()) { $where = $adapter->quoteInto(Model_DB_Rate_Table::FIELDS_ID . " = ?", $filter->getId()); } else { $value = $filter->getIdUser(); if (!empty($value)) { $where .= $and . $adapter->quoteInto(Model_DB_Rate_Table::FIELDS_ID_USER_FK . " LIKE ?", "%{$value}%"); } $value = $filter->getIdYear(); if (!empty($value)) { $where .= $and . $adapter->quoteInto(Model_DB_Rate_Table::FIELDS_ID_YEAR_FK . " LIKE ?", "%{$value}%"); } } return $where; }