public function getAllCotactUsdeatils($offset, Administrator_Model_ContactUs $contSummary) { try { $limit = 10; $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('cont' => 'rd.contactus'), array('id', 'contactname', 'address', 'email', 'phone', 'postedon', 'moreinformation', 'status', 'contacttype', 'city', 'enquiry_status_id', 'company_id', 'ipaddress'))->joinLeft(array('esbd' => 'rd.enquiry_status_bd'), 'esbd.id = cont.enquiry_status_id', array('description')); if ($contSummary->getId()) { $select->where('cont.id = ?', $contSummary->getId()); } if ($contSummary->getcontactname()) { $select->where('cont.contactname Ilike ?', '%' . trim($contSummary->getcontactname()) . '%'); } if ($contSummary->getStartDate()) { $select->where('cont.postedon >= ?', $contSummary->getStartDate()); } if ($contSummary->getEndDate()) { $select->where('cont.postedon <= ?', $contSummary->getEndDate()); } if ($contSummary->getStatus()) { $select->where('cont.enquiry_status_id = ?', $contSummary->getStatus()); } else { $select->where('cont.enquiry_status_id != ?', 6); } // else if($contSummary->getStatus() != ""){ // $select->where('cont.status = ?',$contSummary->getStatus()); // } if ($contSummary->getCompanyId() != 1) { $select->where('cont.company_id = ?', $contSummary->getCompanyId()); } $select->where('contacttype != ?', 'resContact'); $select->order('cont.id Desc'); //$rowset = $table->fetchAll($select); $resultSet = new Zend_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select)); $resultSet->setItemCountPerPage($limit); $resultSet->setCurrentPageNumber($offset); return $resultSet; } catch (Exception $ex) { throw new Exception($ex->getMessage()); } }