/**
* This function gives all content for grid view.
* @parameters
* @param $sort = ascending or descending
* @param $by = name of field which to be sort
* @param $pageNo = page number
* @param $perPage = no.of records per page
* @param $searchData = search string
* @param $call = type of call like ajax.
* @return Array;
*/
public function getGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $p1, $p2, $p3, $p4, $p5)
{
$menu_model = new Default_Model_Menu();
$user_model = new Default_Model_Users();
$searchQuery = '';
$searchArray = array();
$data = array();
if ($searchData != '' && $searchData != 'undefined') {
$searchValues = json_decode($searchData);
if (count($searchValues) > 0) {
foreach ($searchValues as $key => $val) {
if ($key == 'last_modifieddate') {
$searchQuery .= " " . $key . " like '%" . sapp_Global::getGMTformatdate(urldecode($val)) . "%' AND ";
} else {
$searchQuery .= " " . $key . " like '%" . $val . "%' AND ";
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
}
$objName = 'logmanager';
$tableFields = array('action' => 'Action', 'menuName' => 'Menu Name', 'id' => 'ID', 'userfullname' => 'Last Modified By', 'profileimg' => 'Profile', 'employeeId' => 'Employee ID', 'menuUrl' => 'Url', 'user_action' => 'Action', 'key_flag' => 'Last Modified Record', 'last_modifieddate' => 'Last Modified Date');
$tablecontent = $this->getActivitylogData($sort, $by, $pageNo, $perPage, $searchQuery);
$menu_data = $menu_model->getMenusListForActivitylog();
$menu_arr = array();
foreach ($menu_data as $gkey => $gdata) {
$menu_arr[$gdata['menuname']] = $gdata['menuname'];
}
$user_data = $user_model->getUserListForActivitylog();
$user_arr = array();
foreach ($user_data as $gkey => $gdata) {
$user_arr[$gdata['userfullname']] = $gdata['userfullname'];
}
$useractionArray = array('1' => 'Add', '5' => 'Cancel', '3' => 'Delete', '2' => 'Edit');
$dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'menuName' => 'Activity log', 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'call' => $call, 'search_filters' => array('menuname' => array('type' => 'select', 'filter_data' => array('' => 'All') + $menu_arr), 'userfullname' => array('type' => 'select', 'filter_data' => array('' => 'All') + $user_arr), 'last_modifieddate' => array('type' => 'datepicker'), 'user_action' => array('type' => 'select', 'filter_data' => array('' => 'All') + $useractionArray)));
return $dataTmp;
}
