/**
*
* @param type $dataArray
* @return type
*/
public function servicegrid($dataArray)
{
$actnArr = array();
$sortStr = isset($dataArray['by']) ? $dataArray['by'] : "";
if (isset($dataArray['menuName']) && $dataArray['menuName'] != '') {
$menuName = $dataArray['menuName'];
}
$gridFieldsArr = array();
$tmpActionsArr = array();
array_pop($tmpActionsArr);
//last element of actions array is menuname so delete that & check the privileges are empty or not...
$actnArr = $tmpActionsArr;
if (($key = array_search('add', $actnArr)) !== false) {
unset($actnArr[$key]);
}
if (empty($tmpActionsArr)) {
unset($gridFieldsArr['action']);
$gridFieldsArr = $dataArray['tableheader'];
$dataArray['tableheader'] = $gridFieldsArr;
}
if (isset($dataArray['menuName'])) {
$menuName = $dataArray['menuName'];
}
$page_adapter = new Zend_Paginator_Adapter_DbSelect($dataArray['tablecontent']);
$page_adapter->setRowCount($dataArray['row_count']);
$paginator = new Zend_Paginator($page_adapter);
$paginator->setItemCountPerPage($dataArray['perPage'])->setCurrentPageNumber($dataArray['pageNo']);
if (empty($dataArray['tableheader'])) {
$widgetsModel = new Default_Model_Widgets();
$columnData = $widgetsModel->getTableFields('/' . $dataArray['objectname']);
$dataArray['tableheader'] = json_decode($columnData['menufields'], true);
}
$msgtitle = $dataArray['objectname'] . '_delete';
$msgtitle = strtoupper($msgtitle);
$formgridVal = '';
$extra['action'] = array();
$extra['options'] = array();
$addaction = '';
if (isset($dataArray['add']) && $dataArray['add'] != '') {
$addaction = $dataArray['add'];
$addpermission = "true";
} else {
$addaction = '';
$addpermission = "false";
}
return $this->generateGrid($dataArray, $paginator, $extra, true, $formgridVal, $addaction, $menuName, $addpermission, $sortStr, $actnArr);
}
/**
*
* @param type $dataArray
* @param type $ViewOnly
* @return type
*/
public function employeegrid($dataArray, $ViewOnly = null)
{
$request = Zend_Controller_Front::getInstance();
$params = $request->getRequest()->getParams();
$employeeTabs = array('employee', 'dependencydetails', 'creditcarddetails', 'visaandimmigrationdetails', 'workeligibilitydetails', 'disabilitydetails', 'empcommunicationdetails', 'empskills', 'empleaves', 'empholidays', 'medicalclaims', 'educationdetails', 'experiencedetails', 'trainingandcertificationdetails', 'emppersonaldetails', 'myemployees', 'empperformanceappraisal', 'emppayslips', 'empbenefits', 'emprenumerationdetails', 'emprequisitiondetails', 'empadditionaldetails', 'empsecuritycredentials', 'empsalarydetails', 'empjobhistory');
$controllerNamesArr = array('empleaves', 'empholidays', 'myemployees');
$request = Zend_Controller_Front::getInstance();
$dynamiccontrollerName = $request->getRequest()->getControllerName();
//Give all 24tabs of employee.
$view = Zend_Layout::getMvcInstance()->getView();
$session = new Zend_Auth_Storage_Session();
$data = $session->read();
$role_id = $data['emprole'];
$group_id = $data['group_id'];
$loggedinEmpId = $data['id'];
$useridFromURL = $dataArray['userid'];
$controllerName = $dataArray['objectname'];
$menunamestr = '';
$sortStr = "";
$objId = '';
$context = "";
$actnArr = array();
$sortStr = $dataArray['by'];
$actions_arr = array();
$privilegesofObj = array();
if (in_array($dataArray['objectname'], $employeeTabs)) {
if (array_key_exists("context", $dataArray)) {
$context = $dataArray['context'];
if ($dataArray['context'] == "mydetails") {
$objId = MYDETAILS;
} else {
if ($dataArray['context'] == "myteam") {
$objId = MYEMPLOYEES;
} else {
if ($dataArray['context'] == "") {
$objId = EMPLOYEE;
}
}
}
} else {
$objId = EMPLOYEE;
}
if ($role_id != "") {
$privilege_model = new Default_Model_Privileges();
//For grids... From mydetails controller,privileges are sending to grid in dataArray
if (array_key_exists("actions_arr", $dataArray)) {
$actions_arr = $dataArray['actions_arr'];
array_push($actions_arr, $dataArray['menuName']);
} else {
$idCsv = 0;
//flag - No id is single id not Csv... in dashboard we are sending CSV....
$privilegesofObj = $privilege_model->getObjPrivileges($objId, "", $role_id, $idCsv);
if (!empty($privilegesofObj)) {
//If the logged in employee is HR or Superadmin(role =1) or Employee himself want to edit his record.....
if ($privilegesofObj['viewpermission'] == 'Yes') {
array_push($actions_arr, 'view');
}
//For Leaves,Holidays there shoould be only view privilege.....
if (!in_array($controllerName, $controllerNamesArr)) {
if ($privilegesofObj['editpermission'] == 'Yes') {
array_push($actions_arr, 'edit');
}
if ($privilegesofObj['deletepermission'] == 'Yes') {
array_push($actions_arr, 'delete');
}
if ($privilegesofObj['addpermission'] == 'Yes') {
array_push($actions_arr, 'add');
}
if ($privilegesofObj['uploadattachments'] == 'Yes') {
array_push($actions_arr, 'upload');
}
if ($privilegesofObj['viewattachments'] == 'Yes') {
array_push($actions_arr, 'uploadview');
}
}
array_push($actions_arr, $dataArray['menuName']);
} else {
$actions_arr[0] = 'view';
$actions_arr[1] = $dataArray['menuName'];
}
}
}
} else {
$actions_arr = array();
}
$gridFieldsArr = array();
$tmpActionsArr = array();
$tmpActionsArr = $actions_arr;
array_pop($tmpActionsArr);
//last element of actions array is menuname so delete that & check the privileges are empty or not...
$actnArr = $tmpActionsArr;
if (($key = array_search('add', $actnArr)) !== false) {
unset($actnArr[$key]);
}
if (empty($tmpActionsArr)) {
$gridFieldsArr = $dataArray['tableheader'];
unset($gridFieldsArr['action']);
$dataArray['tableheader'] = $gridFieldsArr;
}
if (isset($dataArray['menuName'])) {
$menuName = $dataArray['menuName'];
}
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbSelect($dataArray['tablecontent']));
$paginator->setItemCountPerPage($dataArray['perPage'])->setCurrentPageNumber($dataArray['pageNo']);
if (empty($dataArray['tableheader'])) {
$widgetsModel = new Default_Model_Widgets();
$columnData = $widgetsModel->getTableFields('/' . $dataArray['objectname']);
$dataArray['tableheader'] = json_decode($columnData['menufields'], true);
}
$msgtitle = $dataArray['objectname'] . '_delete';
$msgtitle = strtoupper($msgtitle);
$msgflag = constant($msgtitle);
$msgAr = explode(' ', $msgflag);
$msgdta = implode('@#$', $msgAr);
if (isset($dataArray['formgrid']) && $dataArray['formgrid'] == 'true') {
$urlString = $_SERVER['REQUEST_URI'];
$urlData = explode('/', $urlString);
$con = '';
if (isset($dataArray['unitId'])) {
$con = '/unitId/' . $dataArray['unitId'];
} else {
if (isset($params['id'])) {
$con = '/unitId/' . $params['id'];
}
}
$formgridVal = $dataArray['formgrid'];
if ($dataArray['objectname'] == 'departments') {
$viewaction = 'view';
} else {
$viewaction = 'viewpopup';
}
$editaction = 'editpopup';
if ($dataArray['menuName'] != '') {
$menunamestr = $dataArray['menuName'];
}
$viewpopup_str = '<a onclick="displaydeptform(\'' . DOMAIN . $dataArray['objectname'] . '/' . $viewaction . '/id/{{id}}' . $con . '/popup/1\',\'' . $menunamestr . '\')" name="{{id}}" class="sprite view" title=\'View\'></a>';
$editpopup_str = '<a onclick="displaydeptform(\'' . DOMAIN . $dataArray['objectname'] . '/' . $editaction . '/id/{{id}}' . $con . '/popup/1\',\'' . $menunamestr . '\')" name="{{id}}" class="sprite edit" title=\'Edit\' ></a>';
$deletepopup_str = '<a name="{{id}}" onclick= changeEmployeestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\',\'' . $dataArray['userid'] . '\') href= javascript:void(0) title=\'Delete\' class="sprite delete" ></a>';
if (!in_array('view', $actions_arr) && !in_array('edit', $actions_arr) && !in_array('delete', $actions_arr)) {
if ($dataArray['objectname'] == 'processes') {
$extra['action'] = array('name' => 'edit', 'value' => '<div class="grid-action-align">
<a onclick="displaydeptform(\'' . DOMAIN . $dataArray['objectname'] . '/' . $viewaction . '/id/{{id}}' . $con . '/popup/1\',\'' . $menunamestr . '\')" name="{{id}}" class="sprite view" title=\'View\'></a>
<a onclick="displaydeptform(\'' . DOMAIN . $dataArray['objectname'] . '/' . $editaction . '/id/{{id}}' . $con . '/popup/1\',\'' . $menunamestr . '\')" name="{{id}}" class="sprite edit" title=\'Edit\' ></a>
<a name="{{id}}" onclick= changeEmployeestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\',\'' . $dataArray['userid'] . '\') href= javascript:void(0) title=\'Delete\' class="sprite delete" ></a>
</div>');
} else {
$extra['action'] = array();
}
} else {
$extra['action'] = array('name' => 'edit', 'value' => '<div class="grid-action-align">
' . (in_array('view', $actions_arr) ? $viewpopup_str : '') . '
' . (in_array('edit', $actions_arr) ? $editpopup_str : '') . '
' . (in_array('delete', $actions_arr) ? $deletepopup_str : '') . '
</div>');
}
} else {
$formgridVal = '';
$view_str = '<a href= "' . DOMAIN . $dataArray['objectname'] . '/view/id/{{id}}" name="{{id}}" class="sprite view" title=\'View\'></a>';
$edit_str = '<a href= "' . DOMAIN . $dataArray['objectname'] . '/edit/id/{{id}}" name="{{id}}" class="sprite edit" title=\'Edit\'></a>';
if ($dataArray['objectname'] == 'employee') {
$delete_str = '';
} else {
$delete_str = '<a name="{{id}}" onclick= changeEmployeestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\',\'' . $dataArray['userid'] . '\') href= javascript:void(0) title=\'Delete\' class="sprite delete" ></a>';
}
if (!in_array('view', $actions_arr) && !in_array('edit', $actions_arr) && !in_array('delete', $actions_arr)) {
$extra['action'] = array();
} else {
$extra['action'] = array('name' => 'edit', 'value' => '<div class="grid-action-align">
' . (in_array('view', $actions_arr) ? $view_str : '') . '
' . (in_array('edit', $actions_arr) ? $edit_str : '') . '
' . (in_array('delete', $actions_arr) ? $delete_str : '') . '
</div>');
}
}
$extra['options'] = array();
$addaction = '';
if (isset($dataArray['add']) && $dataArray['add'] != '') {
$addaction = $dataArray['add'];
} else {
$addaction = '';
}
$unitId = '';
if (in_array('add', $actions_arr)) {
if ($ViewOnly == 1) {
$addpermission = "false";
} else {
$addpermission = "true";
}
} else {
$addpermission = "false";
}
if (isset($dataArray['unitId'])) {
$unitId = $dataArray['unitId'];
}
return $this->generateGrid($dataArray['objectname'], $dataArray['tableheader'], $paginator, $extra, true, $dataArray['jsGridFnName'], $dataArray['perPage'], $dataArray['pageNo'], $dataArray['jsFillFnName'], $dataArray['searchArray'], $formgridVal, $addaction, $menuName, $unitId, $addpermission, $menunamestr, isset($dataArray['call']) ? $dataArray['call'] : "", $sortStr, $context, isset($dataArray['search_filters']) ? $dataArray['search_filters'] : "", isset($dataArray['dashboardcall']) ? $dataArray['dashboardcall'] : "No", $actnArr, isset($dataArray['sort']) ? $dataArray['sort'] : "", isset($dataArray['by']) ? $dataArray['by'] : "", $ViewOnly);
}
public function grid($dataArray)
{
$request = Zend_Controller_Front::getInstance();
$params = $request->getRequest()->getParams();
$menu_model = new Default_Model_Menu();
$session = new Zend_Auth_Storage_Session();
$data = $session->read();
$role_id = $data['emprole'];
$menunamestr = '';
$sortStr = '';
$actnArr = array();
$sortStr = $dataArray['by'];
$controllers_arr = $menu_model->getControllersByRole($role_id);
if ($dataArray['objectname'] == 'processes') {
$actionsobjname = 'empscreening';
} else {
$actionsobjname = $dataArray['objectname'];
}
if (isset($controllers_arr[$actionsobjname . "controller.php"])) {
$actions_arr = $controllers_arr[$actionsobjname . "controller.php"]['actions'];
$menuName = $actions_arr[sizeof($actions_arr) - 1];
} else {
$actions_arr = array();
}
$gridFieldsArr = array();
$tmpActionsArr = array();
$tmpActionsArr = $actions_arr;
array_pop($tmpActionsArr);
//last element of actions array is menuname so delete that & check the privileges are empty or not...
$actnArr = $tmpActionsArr;
if (($key = array_search('add', $actnArr)) !== false) {
unset($actnArr[$key]);
}
if (empty($tmpActionsArr)) {
$gridFieldsArr = $dataArray['tableheader'];
unset($gridFieldsArr['action']);
$dataArray['tableheader'] = $gridFieldsArr;
}
if (isset($dataArray['menuName'])) {
$menuName = $dataArray['menuName'];
}
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbSelect($dataArray['tablecontent']));
$paginator->setItemCountPerPage($dataArray['perPage'])->setCurrentPageNumber($dataArray['pageNo']);
if (empty($dataArray['tableheader'])) {
$widgetsModel = new Default_Model_Widgets();
$columnData = $widgetsModel->getTableFields('/' . $dataArray['objectname']);
$dataArray['tableheader'] = json_decode($columnData['menufields'], true);
}
$msgtitle = $dataArray['objectname'] . '_delete';
$msgtitle = strtoupper($msgtitle);
$msgflag = constant($msgtitle);
$msgAr = explode(' ', $msgflag);
$msgdta = implode('@#$', $msgAr);
if (isset($dataArray['formgrid']) && $dataArray['formgrid'] == 'true') {
if (isset($dataArray['unitId'])) {
$con = '/unitId/' . $dataArray['unitId'];
} else {
if (isset($params['id'])) {
$con = '/unitId/' . $params['id'];
}
}
$formgridVal = $dataArray['formgrid'];
if ($dataArray['objectname'] == 'departments') {
$viewaction = 'view';
} else {
$viewaction = 'viewpopup';
}
$editaction = 'editpopup';
if (isset($dataArray['menuName']) && $dataArray['menuName'] != '') {
$menunamestr = $dataArray['menuName'];
}
$viewpopup_str = '<a onclick="displaydeptform(\'' . DOMAIN . $dataArray['objectname'] . '/' . $viewaction . '/id/{{id}}' . $con . '/popup/1\',\'' . $menunamestr . '\')" name="{{id}}" class="sprite view" title=\'View\'></a>';
$editpopup_str = '<a id="edit{{id}}" onclick="displaydeptform(\'' . DOMAIN . $dataArray['objectname'] . '/' . $editaction . '/id/{{id}}' . $con . '/popup/1\',\'' . $menunamestr . '\')" name="{{id}}" class="sprite edit" title=\'Edit\' ></a>';
$deletepopup_str = '<a name="{{id}}" id="del{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Delete\' class="sprite delete" ></a>';
if (!in_array('view', $actions_arr) && !in_array('edit', $actions_arr) && !in_array('delete', $actions_arr)) {
if ($dataArray['objectname'] == 'processes') {
$extra['action'] = array('name' => 'edit', 'value' => '<div class="grid-action-align">
<a onclick="displaydeptform(\'' . DOMAIN . $dataArray['objectname'] . '/' . $viewaction . '/id/{{id}}' . $con . '/popup/1\',\'' . $menunamestr . '\')" name="{{id}}" class="sprite view" title=\'View\'></a>
<a onclick="displaydeptform(\'' . DOMAIN . $dataArray['objectname'] . '/' . $editaction . '/id/{{id}}' . $con . '/popup/1\',\'' . $menunamestr . '\')" name="{{id}}" class="sprite edit" title=\'Edit\' ></a>
<a name="{{id}}" id="{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Delete\' class="sprite delete" ></a>
</div>');
} else {
$extra['action'] = array();
}
} else {
if ($dataArray['objectname'] == 'empleavesummary' || $dataArray['objectname'] == 'empscreening') {
$view_str = '<a href= "' . DOMAIN . $dataArray['objectname'] . '/view/id/{{id}}" name="{{id}}" class="sprite view" title=\'View\'></a>';
$edit_str = '<a href= "' . DOMAIN . $dataArray['objectname'] . '/edit/id/{{id}}" name="{{id}}" class="sprite edit" title=\'Edit\'></a>';
$delete_str = '<a name="{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Delete\' class="sprite delete" ></a>';
$extra['action'] = array('name' => 'edit', 'value' => '<div class="grid-action-align">
' . (in_array('view', $actions_arr) ? $view_str : '') . '
' . (in_array('edit', $actions_arr) ? $edit_str : '') . '
' . (in_array('delete', $actions_arr) ? $delete_str : '') . '
</div>');
} else {
$extra['action'] = array('name' => 'edit', 'value' => '<div class="grid-action-align">
' . (in_array('view', $actions_arr) ? $viewpopup_str : '') . '
' . (in_array('edit', $actions_arr) ? $editpopup_str : '') . '
' . (in_array('delete', $actions_arr) ? $deletepopup_str : '') . '
</div>');
}
}
} else {
$formgridVal = '';
$view_str = '<a href= "' . DOMAIN . $dataArray['objectname'] . '/view/id/{{id}}" name="{{id}}" class="sprite view" title=\'View\'></a>';
$edit_str = '<a href= "' . DOMAIN . $dataArray['objectname'] . '/edit/id/{{id}}" name="{{id}}" class="sprite edit" title=\'Edit\'></a>';
if ($dataArray['objectname'] == 'pendingleaves') {
$delete_str = '<a name="{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Cancel Leave\' class="sprite cancel-lev" ></a>';
} else {
if ($dataArray['objectname'] == 'createprojects') {
$delete_str = '<a name="{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Cancel Project\' class="sprite cancel-lev" ></a>';
} else {
if ($dataArray['objectname'] == 'createtasks') {
$delete_str = '<a name="{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Cancel Tasks\' class="sprite cancel-lev" ></a>';
} else {
if ($dataArray['objectname'] == 'approvedleaves') {
$delete_str = '<a name="{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Cancel Approved Leave\' class="sprite cancel-lev" ></a>';
} else {
if ($dataArray['objectname'] == 'manageremployeevacations') {
if ($params['action'] == "approved" || $_SESSION["manageremployeevacations_view"] == "2") {
$delete_str = '<a name="{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Cancel Approved Leave\' class="sprite cancel-lev" ></a>';
}
} else {
if ($dataArray['objectname'] == 'usermanagement') {
$delete_str = '<a id="del{{id}}" name="{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Delete\' class="sprite delete" ></a>';
} else {
$delete_str = '<a name="{{id}}" onclick= changestatus(\'' . $dataArray['objectname'] . '\',\'{{id}}\',\'' . $msgdta . '\') href= javascript:void(0) title=\'Delete\' class="sprite delete" ></a>';
}
}
}
}
}
}
if (!in_array('view', $actions_arr) && !in_array('edit', $actions_arr) && !in_array('delete', $actions_arr)) {
$extra['action'] = array();
} else {
$extra['action'] = array('name' => 'edit', 'value' => '<div class="grid-action-align">
' . (in_array('view', $actions_arr) ? $view_str : '') . '
' . (in_array('edit', $actions_arr) ? $edit_str : '') . '
' . (in_array('delete', $actions_arr) ? $delete_str : '') . '
</div>');
//onclick ="javascript:editlocdata(\'{{id}}\')"
}
}
$extra['options'] = array();
$addaction = '';
if (isset($dataArray['add']) && $dataArray['add'] != '') {
$addaction = $dataArray['add'];
} else {
$addaction = '';
}
$unitId = '';
if (in_array('add', $actions_arr)) {
$addpermission = "true";
} else {
$addpermission = "false";
}
if (isset($dataArray['unitId'])) {
$unitId = $dataArray['unitId'];
}
return $this->generateGrid($dataArray['objectname'], $dataArray['tableheader'], $paginator, $extra, true, $dataArray['jsGridFnName'], $dataArray['perPage'], $dataArray['pageNo'], $dataArray['jsFillFnName'], $dataArray['searchArray'], $formgridVal, $addaction, $menuName, $unitId, $addpermission, $menunamestr, isset($dataArray['call']) ? $dataArray['call'] : "", $sortStr, isset($dataArray['search_filters']) ? $dataArray['search_filters'] : "", isset($dataArray['dashboardcall']) ? $dataArray['dashboardcall'] : "No", isset($dataArray['empstatus']) ? $dataArray['empstatus'] : "", $actnArr, isset($dataArray['empscreentotalcount']) ? $dataArray['empscreentotalcount'] : "", isset($dataArray['sort']) ? $dataArray['sort'] : "", isset($dataArray['by']) ? $dataArray['by'] : "");
}
