/** * * Show auto suggestions to filters in report */ public function empautoAction() { $params = $this->_getAllParams(); $output = array(array('id' => '', 'value' => 'No records', 'label' => 'No records')); $emp_model = new Default_Model_Employee(); if ($params['term'] != '') { // Get reporting manager ID $myEmployees_model = new Default_Model_Myemployees(); $params['reporting_manager'] = $myEmployees_model->getLoginUserId(); // Get employees data by search criteria and reporting manager $emp_arr = $emp_model->getAutoReportEmployee($params); if (count($emp_arr) > 0) { $output = array(); foreach ($emp_arr as $emp) { $output[] = array('id' => $emp['user_id'], 'value' => $emp[$params['field']], 'label' => $emp[$params['field']], 'profile_img' => $emp['profileimg']); } } } $this->_helper->json($output); }