/**
* 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 getUserLoginLogGrid($sort, $by, $perPage, $pageNo, $searchData, $call, $p1, $p2, $p3, $p4, $p5)
{
$group_model = new Default_Model_Groups();
$role_model = new Default_Model_Roles();
$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 == 'userfullname' || $key == 'employeeId' || $key == 'emailaddress' || $key == 'empipaddress') {
$searchQuery .= " r." . $key . " like '%" . $val . "%' AND ";
} else {
if ($key == 'logindatetime') {
$searchQuery .= " " . $key . " like '%" . sapp_Global::change_date(urldecode($val), 'database') . "%' AND ";
} else {
if ($key == 'rolename') {
$searchQuery .= " ro." . $key . " like '%" . $val . "%' AND ";
} else {
$searchQuery .= " " . $key . " like '%" . $val . "%' AND ";
}
}
}
$searchArray[$key] = $val;
}
$searchQuery = rtrim($searchQuery, " AND");
}
}
$objName = 'userloginlog';
$tableFields = array('action' => 'Action', 'userfullname' => 'User', 'profileimg' => 'Profile', 'employeeId' => 'Employee ID', 'group_name' => 'Group', 'rolename' => 'Role', 'emailaddress' => 'Email', 'logindatetime' => 'Login Time', 'empipaddress' => 'Ip Address');
$tablecontent = $this->getUserLoginLogData($sort, $by, $pageNo, $perPage, $searchQuery);
$group_data = $group_model->getGroupsListForUserLoginLog();
$group_arr = array();
foreach ($group_data as $gkey => $gdata) {
$group_arr[$gdata['group_name']] = $gdata['group_name'];
}
$role_data = $role_model->getRoleListForUserLoginLog();
$role_arr = array();
foreach ($role_data as $gkey => $gdata) {
$role_arr[$gdata['rolename']] = $gdata['rolename'];
}
$dataTmp = array('sort' => $sort, 'by' => $by, 'pageNo' => $pageNo, 'perPage' => $perPage, 'tablecontent' => $tablecontent, 'objectname' => $objName, 'menuName' => 'User log', 'extra' => array(), 'tableheader' => $tableFields, 'jsGridFnName' => 'getAjaxgridData', 'jsFillFnName' => '', 'searchArray' => $searchArray, 'call' => $call, 'search_filters' => array('group_name' => array('type' => 'select', 'filter_data' => array('' => 'All') + $group_arr), 'rolename' => array('type' => 'select', 'filter_data' => array('' => 'All') + $role_arr), 'logindatetime' => array('type' => 'datepicker')));
return $dataTmp;
}
