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());
}
}
