/**
* List action
*/
public function contactListAction()
{
$page = $this->_request->getParam('page');
$perPage = $this->_request->getParam('perPage');
$langFilter = $this->_request->getParam('langFilter');
$searchFilter = $this->_request->getParam('searchFilter');
$fromFilter = $this->_request->getParam('fromFilter');
$toFilter = $this->_request->getParam('toFilter');
$orderFilter = $this->_request->getParam('order');
if (isset($fromFilter) && !empty($fromFilter)) {
$fromFilter = HCMS_Utils_Date::dateLocalToCustom($fromFilter);
}
if (isset($toFilter) && !empty($toFilter)) {
$toFilter = HCMS_Utils_Date::dateLocalToCustom($toFilter);
}
if (isset($orderFilter) && !empty($orderFilter)) {
$orderBy = array($orderFilter);
} else {
$orderBy = array('c.posted DESC');
}
if (!isset($page) || $page < 1) {
$page = 1;
}
if (!isset($perPage) || $perPage < 1 || $perPage > 100) {
$perPage = 100;
}
$paging = array('page' => $page, 'perPage' => $perPage);
$criteria = array('application_id' => $this->_applicationId);
if (isset($searchFilter) && $searchFilter != "") {
$criteria['search_filter'] = $searchFilter;
}
if (isset($langFilter) && $langFilter != "") {
$criteria['lang_filter'] = $langFilter;
}
if (isset($fromFilter) && $fromFilter != "") {
$criteria['from_filter'] = $fromFilter;
}
if (isset($toFilter) && $toFilter != "") {
$criteria['to_filter'] = $toFilter;
}
$records = Contact_Model_ContactMapper::getInstance()->fetchAll($criteria, $orderBy, $paging);
$data = array('total' => $paging['total'], 'page' => $paging['page'], 'records' => $paging['records'], 'perPage' => $paging['perPage'], 'rows' => array());
$languages = Application_Model_TranslateMapper::getInstance()->getLanguages();
/* @var $record Application_Model_Candidate */
foreach ($records as $record) {
$data['rows'][] = array('id' => $record->get_id(), 'posted' => HCMS_Utils_Time::timeMysql2Local($record->get_posted()), 'first_name' => $record->get_first_name(), 'last_name' => $record->get_last_name(), 'email' => $record->get_email(), 'street' => $record->get_street(), 'country' => $record->get_country(), 'phone' => $record->get_phone(), 'mobile' => $record->get_mobile(), 'fax' => $record->get_fax(), 'zip' => $record->get_zip(), 'city' => $record->get_city(), 'gender' => $this->translate($record->get_gender()), 'description' => $record->get_description(), 'description_short' => $this->view->abbreviate($record->get_description(), 150), 'message' => $record->get_message(), 'message_short' => $this->view->abbreviate($record->get_message(), 150), 'language' => $languages[$record->get_language()]['name']);
}
$this->_helper->json->sendJson($data);
}
protected function populateCriteria(&$criteria, &$orderBy, &$paging)
{
$page = $this->_request->getParam('page');
$form_id = $this->_request->getParam('form_id');
$perPage = $this->_request->getParam('perPage');
$langFilter = $this->_request->getParam('langFilter');
$searchFilter = $this->_request->getParam('searchFilter');
$fromFilter = $this->_request->getParam('fromFilter');
$toFilter = $this->_request->getParam('toFilter');
$orderFilter = $this->_request->getParam('order');
if (isset($fromFilter) && !empty($fromFilter)) {
$fromFilter = HCMS_Utils_Date::dateLocalToCustom($fromFilter);
}
if (isset($toFilter) && !empty($toFilter)) {
$toFilter = HCMS_Utils_Date::dateLocalToCustom($toFilter);
}
if (isset($orderFilter) && !empty($orderFilter)) {
$orderBy = array($orderFilter);
} else {
$orderBy = array('c.posted DESC');
}
if (!isset($page) || $page < 1) {
$page = 1;
}
if (!isset($perPage) || $perPage < 1 || $perPage > 100) {
$perPage = 100;
}
$paging = array('page' => $page, 'perPage' => $perPage);
$criteria = array('application_id' => $this->_applicationId);
if (isset($searchFilter) && $searchFilter != "") {
$criteria['search_filter'] = $searchFilter;
}
if (isset($form_id) && $form_id != "") {
$criteria['form_id'] = $form_id;
}
if (isset($langFilter) && $langFilter != "") {
$criteria['lang_filter'] = $langFilter;
}
if (isset($fromFilter) && $fromFilter != "") {
$criteria['from_filter'] = $fromFilter;
}
if (isset($toFilter) && $toFilter != "") {
$criteria['to_filter'] = $toFilter;
}
return;
}