public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $dashboardcall, $exParam1 = '', $exParam2 = '', $exParam3 = '', $exParam4 = '')
{
$searchQuery = '';
$tablecontent = '';
$searchArray = array();
$data = array();
$id = '';
$dataTmp = array();
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
foreach ($searchValues as $key => $val) {
if ($key == "userfullname") {
$searchQuery .= " e." . $key . " like '%" . $val . "%' AND ";
} else {
if ($key == "rm") {
$searchQuery .= " e.userfullname like '%" . $val . "%' AND ";
} else {
if ($key == "jobtitle_name") {
$searchQuery .= " e.jobtitle_name like '%" . $val . "%' AND ";
} else {
if ($key == 'extn') {
$searchQuery .= " concat(e.office_number,' (ext ',e.extension_number,')') like '%" . $val . "%' AND ";
} else {
if ($key == 'astatus') {
$searchQuery .= " e.isactive like '%" . $val . "%' AND ";
} else {
$searchQuery .= " e." . $key . " like '%" . $val . "%' AND ";
}
}
}
}
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
$objName = 'myemployees';
$emptyroles = 0;
$tableFields = array('action' => 'Action', 'firstname' => 'First Name', 'lastname' => 'Last Name', 'emailaddress' => 'E-mail', 'employeeId' => 'Employee ID', 'astatus' => 'User Status', 'extn' => ' Work Phone', 'jobtitle_name' => 'Job Title', 'contactnumber' => 'Contact Number');
$employeeModel = new Default_Model_Employee();
$tablecontent = $employeeModel->getEmployeesData($sort, $by, $pageNo, $perPage, $searchQuery, $exParam1, $exParam1);
if ($tablecontent == "emptyroles") {
$emptyroles = 1;
} else {
$emptyroles = 0;
}
$dataTmp = array('dashboardcall' => $dashboardcall, 'emptyroles' => $emptyroles, 'sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'menuName' => 'My Team', 'add' => 'add', 'call' => $call, 'sortStr' => $by, 'context' => 'myteam', 'search_filters' => array('astatus' => array('type' => 'select', 'filter_data' => array('' => 'All', 1 => 'Active', 0 => 'Inactive', 2 => 'Resigned', 3 => 'Left', 4 => 'Suspended'))));
return $dataTmp;
}
