public function save($holidaygroupsform)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
if ($holidaygroupsform->isValid($this->_request->getPost())) {
$id = $this->_request->getParam('id');
$groupname = $this->_request->getParam('title');
$description = $this->_request->getParam('description');
$date = new Zend_Date();
$holidaygroupsmodel = new Default_Model_Feedback();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('title' => $groupname, 'description' => trim($description), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('id=?' => $id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
}
$Id = $holidaygroupsmodel->SaveorUpdateGroupData($data, $where);
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Feedback updated successfully."));
} else {
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Feedback added successfully."));
}
$menuidArr = $menumodel->getMenuObjID('/feedback');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
//$this->_redirect('/feedback');
//$this->view->finalResult = $result;
return "Success...!";
} else {
$messages = $holidaygroupsform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
return $msgarray;
}
}
public function init()
{
$this->setMethod('post');
$this->setAttrib('action', BASE_URL . 'reports/activitylogreport');
$this->setAttrib('id', 'activitylog');
$this->setAttrib('name', 'activitylog');
$username = new Zend_Form_Element_Text('username');
$username->setAttrib('onblur', 'clearautoactivity(this)');
$username->addFilter(new Zend_Filter_StringTrim());
$username->setLabel("User Name");
$menu = new Zend_Form_Element_Select('menu');
$menu->setLabel('Menu');
$menu->setAttrib('onchange', 'changeelement(this)');
$menuModel = new Default_Model_Menu();
$menuList = $menuModel->getMenuArrayActivityLogReport();
$menu->addMultiOption('', 'Select Menu');
foreach ($menuList as $menuitem) {
$menu->addMultiOption($menuitem['id'], $menuitem['menuName']);
}
$useraction = new Zend_Form_Element_Select('useraction');
$useraction->setLabel('User Action');
$useraction->setAttrib('onchange', 'changeelement(this)');
$useraction->addMultiOption('', 'Select Action');
$useraction->addMultiOption('1', 'Add');
$useraction->addMultiOption('5', 'Cancel');
$useraction->addMultiOption('3', 'Delete');
$useraction->addMultiOption('2', 'Edit');
$modifieddate = new ZendX_JQuery_Form_Element_DatePicker('modifieddate');
$modifieddate->setAttrib('onblur', 'blurelement(this)');
$modifieddate->setLabel("Modified Date");
$modifieddate->setAttrib('readonly', 'true');
$modifieddate->setAttrib('onfocus', 'this.blur()');
$modifieddate->setOptions(array('class' => 'brdr_none'));
$this->addElements(array($username, $menu, $useraction, $modifieddate));
$this->setElementDecorators(array('ViewHelper'));
$this->setElementDecorators(array('UiWidgetElement'), array('modifieddate'));
}
public function updateAction()
{
$empDocuModel = new Default_Model_Employeedocs();
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('doc_id');
$name = $this->_request->getParam('doc_name');
$userid = $this->_request->getParam('userid');
// Get attachments
$file_original_names = $this->getRequest()->getParam('file_original_names');
$file_new_names = $this->getRequest()->getParam('file_new_names');
$org_names = explode(',', $file_original_names);
$new_names = explode(',', $file_new_names);
$attachment_array = array();
for ($i = 0; $i < count($org_names); $i++) {
if ($new_names[$i] != '') {
$attachment_array[] = array("original_name" => $org_names[$i], "new_name" => $new_names[$i]);
}
}
$data = array('name' => $name, 'attachments' => count($attachment_array) > 0 ? json_encode($attachment_array) : null, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
// Validate duplicate document name
$empDocuments = $empDocuModel->checkDocNameByUserIdAndDocId($userid, $name, $id);
$count_emp_docs = count($empDocuments);
if ($count_emp_docs == 0) {
$where = array('id=?' => $id);
$actionflag = 2;
$recordId = $empDocuModel->SaveorUpdateEmpDocuments($data, $where);
$menumodel = new Default_Model_Menu();
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $userid);
$this->_helper->json(array('result' => 'success'));
} else {
if ($count_emp_docs > 0) {
$this->_helper->json(array('result' => 'exists'));
} else {
$this->_helper->json(array('result' => 'error'));
}
}
}
public function multipleresumeAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginUserId = trim($loginUserId);
}
$priv_check = sapp_Global::_checkprivileges(CANDIDATEDETAILS, '', $auth->getStorage()->read()->emprole, 'add');
if ($priv_check == 'Yes') {
$msgarray = $req_options = array();
$form = new Default_Form_Multipleresume();
$form->setAction(DOMAIN . 'candidatedetails/multipleresume');
// To show list of requisitions to user
$req_model = new Default_Model_Requisition();
$req_data = $req_model->getRequisitionsForCV("'Approved','In process'");
foreach ($req_data as $req) {
$req_options[$req['id']] = $req['requisition_code'] . ' - ' . $req['jobtitlename'];
}
if (count($req_options) == 0) {
$msgarray['requisition_id'] = "No active requisitions are found.";
}
$form->requisition_id->addMultiOptions(array('' => 'Select Requisition ID') + $req_options);
$form_post_status = $this->_request->getPost();
if ($form_post_status) {
$candidate_firstname = $this->_getParam('candidate_firstname', null);
$candidate_lastname = $this->_getParam('candidate_lastname', null);
$cand_resumes = $this->_getParam('cand_resume', null);
if ($form->isValid($form_post_status)) {
$cand_details_model = new Default_Model_Candidatedetails();
$requisition_id = $this->_getParam('requisition_id', null);
$cand_status = $this->_getParam('cand_status', null);
$req_records = $cand_details_model->getcountofrecords($requisition_id);
$curr_date = gmdate("Y-m-d H:i:s");
if (empty($req_records)) {
$rdata = array('req_status' => 'In process', 'modifiedby' => $loginUserId, 'modifiedon' => $curr_date);
$rwhere = ' id = ' . $requisition_id;
$req_model->SaveorUpdateRequisitionData($rdata, $rwhere);
}
// To insert records in a single query
$records = array();
foreach ($candidate_firstname as $key => $candidate_fname) {
$cfull_name = $candidate_fname . ' ' . $candidate_lastname[$key];
$records[] = "({$requisition_id}, '{$candidate_fname}','{$candidate_lastname[$key]}','{$cfull_name}', '{$cand_resumes[$key]}', '{$cand_status}', 1, {$loginUserId}, {$loginUserId}, '{$curr_date}', '{$curr_date}')";
}
$data_fields = array('requisition_id', 'candidate_firstname', 'candidate_lastname', 'candidate_name', 'cand_resume', 'cand_status', 'isactive', 'createdby', 'modifiedby', 'createddate', 'modifieddate');
$last_insert_id = $cand_details_model->insertMultipleRecords($data_fields, $records);
// Log status to Log manager and redirect to Resource Pooling list page.
if ($last_insert_id != '') {
$menumodel = new Default_Model_Menu();
$objidArr = $menumodel->getMenuObjID('/candidatedetails');
$objID = $objidArr[0]['id'];
$log_status = sapp_Global::logManager($objID, 1, $loginUserId, $last_insert_id);
//$this->_helper->FlashMessenger()->setNamespace('success')->addMessage('Candidate details added successfully.');
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Candidate details added successfully."));
$this->_redirect('/candidatedetails');
}
} else {
// To handle server validation, when Javascript is disabled
$messages = $form->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
$form->setDefault('candidate_firstname', $candidate_firstname[0]);
$form->setDefault('cand_resume', '');
}
}
$this->view->form = $form;
$this->view->msgarray = $msgarray;
} else {
$this->_redirect('error');
}
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$actionflag = 3;
if ($id) {
$systempreferencemodel = new Default_Model_Sitepreference();
$menumodel = new Default_Model_Menu();
$data = array('isactive' => 0);
$where = array('id=?' => $id);
$Id = $systempreferencemodel->SaveorUpdateSystemPreferanceData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/sitepreference');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Site preferences deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Site preferences cannot be deleted.';
}
$messages['msgtype'] = 'error';
} else {
$messages['message'] = 'Site preferences cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
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'] : "");
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$actionflag = 3;
if ($id) {
$departmentsmodel = new Default_Model_Departments();
$checkemployees = $departmentsmodel->checkemployeestodepartment($id);
if ($checkemployees == 0) {
$menumodel = new Default_Model_Menu();
$data = array('isactive' => 0);
$where = array('id=?' => $id);
$Id = $departmentsmodel->SaveorUpdateDepartmentsUnits($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/departments');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Department deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Department cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Please re-assign the employees to another department';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Department cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function save($empsalarydetailsform, $userid)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
if ($empsalarydetailsform->isValid($this->_request->getPost())) {
$empsalarydetailsModal = new Default_Model_Empsalarydetails();
$id = $this->_request->getParam('id');
$user_id = $userid;
$currencyid = $this->_request->getParam('currencyid');
$salarytype = $this->_request->getParam('salarytype');
$salary = $this->_request->getParam('salary');
$bankname = trim($this->_request->getParam('bankname'));
$accountholder_name = trim($this->_request->getParam('accountholder_name'));
$accountclasstypeid = $this->_request->getParam('accountclasstypeid');
$bankaccountid = $this->_request->getParam('bankaccountid');
$accountnumber = trim($this->_request->getParam('accountnumber'));
$accountholding = $this->_request->getParam('accountholding');
$accountholding = sapp_Global::change_date($accountholding, 'database');
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('user_id' => $user_id, 'currencyid' => $currencyid, 'salarytype' => $salarytype, 'salary' => $salary, 'bankname' => $bankname != '' ? $bankname : NULL, 'accountholder_name' => $accountholder_name != '' ? $accountholder_name : NULL, 'accountclasstypeid' => $accountclasstypeid != '' ? $accountclasstypeid : NULL, 'bankaccountid' => $bankaccountid != '' ? $bankaccountid : NULL, 'accountnumber' => $accountnumber != '' ? $accountnumber : NULL, 'accountholding' => $accountholding != '' ? $accountholding : NULL, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('user_id=?' => $user_id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
}
$Id = $empsalarydetailsModal->SaveorUpdateEmpSalaryData($data, $where);
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee salary details updated successfully."));
} else {
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee salary details added successfully."));
}
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
$this->_redirect('empsalarydetails/edit/userid/' . $user_id);
} else {
$messages = $empsalarydetailsform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
return $msgarray;
}
}
/**
* @name viewAction
*
* This method is used to display the detail log info
*
* @author Deepthi
* @version 1.0
*/
public function viewAction()
{
$activitylog_model = new Default_Model_Activitylog();
$logmanager_model = new Default_Model_Logmanager();
$menu_model = new Default_Model_Menu();
//Pop up layout
Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/");
$perPage = PERPAGE;
$this->view->managemodule = 0;
if ($this->getRequest()) {
$id = $this->_request->getParam('id');
$viewLinkArray = array('101', '102');
// menu with view links
$logManagarRecord = $logmanager_model->getLogManagerDataByID($id);
$menuId = $logManagarRecord[0]['menuId'];
$action = $logManagarRecord[0]['user_action'];
switch ($action) {
case 1:
$userAction = 'add';
break;
case 2:
$userAction = 'edit';
break;
default:
$userAction = '';
break;
}
$url = $menu_model->getMenusDataById($menuId);
$modurl = ltrim($url[0]['url'], '/');
if (isset($logManagarRecord[0]['log_details']) && !empty($logManagarRecord[0]['log_details'])) {
$logdetails = '{"testjson":[' . $logManagarRecord[0]['log_details'] . ']}';
$logarr = @get_object_vars(json_decode($logdetails));
if (!empty($logarr)) {
$userArray = array();
$logarr['testjson'] = array_reverse($logarr['testjson']);
$this->logJsonCount = count($logarr['testjson']);
foreach ($logarr['testjson'] as $key => $curr) {
$currArray = @get_object_vars($curr);
$this->modArray[$key]['userid'] = $currArray['userid'];
if ($menuId != '142') {
if (in_array($menuId, $viewLinkArray)) {
$this->modArray[$key]['recordid'] = isset($currArray['recordid']) ? DOMAIN . $modurl . '/view/id/' . $currArray['recordid'] : '0';
} else {
$this->modArray[$key]['recordid'] = isset($currArray['recordid']) ? DOMAIN . $modurl . '/edit/id/' . $currArray['recordid'] : '0';
}
} else {
$this->view->managemodule = 1;
$this->modArray[$key]['recordid'] = $currArray['childrecordid'];
}
$this->modArray[$key]['date'] = $currArray['date'];
if (!in_array($currArray['userid'], $userArray)) {
array_push($userArray, $currArray['userid']);
}
}
$this->userNameArray = $activitylog_model->getuserNamesByIds($userArray);
if ($menuId != '61' && $menuId != '65') {
$this->view->viewrRecordFlag = true;
} else {
$this->view->viewrRecordFlag = false;
}
$this->view->mainArray = $this->modArray;
$this->view->userNameArray = $this->userNameArray;
$this->view->totalJsonCount = $this->logJsonCount;
$this->view->pageNo = 1;
$this->view->perPage = $perPage;
} else {
$this->view->message = "No records found";
exit;
}
}
}
}
public function save($appraisalconfigform)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$appraisalconfigmodel = new Default_Model_Appraisalconfig();
$departmentsmodel = new Default_Model_Departments();
$businessunitsmodel = new Default_Model_Businessunits();
$msgarray = array();
$resultArr = array();
$arrData = array();
$prevBusinessunit = '';
$errorflag = "true";
$id = $this->_request->getParam('id');
$businessunit_id = $this->_request->getParam('businessunit_id');
$performance_app_flag = $this->_request->getParam('performance_app_flag');
$department_id = $this->_request->getParam('department_id');
$appraisal_mode = $this->_request->getParam('appraisal_mode');
$approval_selection = $this->_request->getParam('approval_selection');
$appraisal_ratings = $this->_request->getParam('appraisal_ratings');
// Validation to check duplicate combinations
$arrData = array("business_unit_id" => $businessunit_id, "department_id" => $department_id, "id" => $id);
if ($appraisalconfigmodel->combinationExists($arrData)) {
$msgarray['businessunit_id'] = 'Business unit or department configuration already exists.';
$errorflag = "false";
}
/** Start
* Validating selection of department if implementaion is department wise
*/
if ($performance_app_flag == 0) {
if ($department_id == '') {
$msgarray['department_id'] = 'Please select department.';
$errorflag = "false";
}
}
/**
End validating selection of department
*/
/** Start
Validating unique service desk department
*/
if ($businessunit_id != '' && $id == '') {
$appraisalconigfArr = $appraisalconfigmodel->checkuniqueAppraisalConfigData($businessunit_id, $performance_app_flag, $department_id);
if (!empty($appraisalconigfArr)) {
if ($appraisalconigfArr[0]['count'] > 0) {
$msgarray['department_id'] = 'Please select a different department.';
$errorflag = "false";
}
}
}
/** End
* Validating uniques department
*/
$db = Zend_Db_Table::getDefaultAdapter();
$db->beginTransaction();
if ($appraisalconfigform->isValid($this->_request->getPost()) && $errorflag == 'true') {
try {
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('businessunit_id' => $businessunit_id, 'department_id' => $department_id != '' ? $department_id : NULL, 'performance_app_flag' => $performance_app_flag, 'appraisal_mode' => $appraisal_mode, 'appraisal_ratings' => $appraisal_ratings, 'module_flag' => 1, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
/* for Update record */
$where = array('id=?' => $id);
$actionflag = 2;
} else {
/* for Insert new record */
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
}
$Id = $appraisalconfigmodel->SaveorUpdateAppraisalConfigData($data, $where);
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Appraisal settings updated successfully"));
} else {
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Appraisal settings added successfully"));
}
$menuidArr = $menumodel->getMenuObjID('/appraisalconfig');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
/** Start
* Sending Mails to employees
*/
/* if($performance_app_flag == 0)
$employeeDetailsArr = $appraisalconfigmodel->getUserDetailsByID($businessunit_id,$department_id);
else
$employeeDetailsArr = $appraisalconfigmodel->getUserDetailsByID($businessunit_id,'');
$msg_add_update = ($Id == 'update') ? "updated" : "added" ;
//Sending mail to Super admin
$options['subject'] = APPLICATION_NAME.': Performance Appraisal Settings '.ucfirst($msg_add_update);
$options['header'] = 'Performance Appraisal Configuration';
$options['toEmail'] = SUPERADMIN_EMAIL;
$options['toName'] = 'Super Admin';
$options['message'] = 'Dear Super Admin, performance appraisal configuration '.$msg_add_update;
// $mail_id = sapp_Global::_sendEmail($options);
//sending mail to others
if(!empty($employeeDetailsArr))
{
foreach($employeeDetailsArr as $emp)
{
$options['subject'] = APPLICATION_NAME.': Performance Appraisal Settings Added.';
$options['header'] = 'Performance Appraisal Configuration';
$options['toEmail'] = $emp['emailaddress'];
$options['toName'] = $emp['userfullname'];
$options['message'] = 'Dear '.$emp['userfullname'].', performance appraisal configuration '.$msg_add_update;
// $mail_id = sapp_Global::_sendEmail($options);
}
}
/**
* End
*/
$db->commit();
$this->_redirect('appraisalconfig');
throw new Exception("Some error message");
} catch (Exception $e) {
$db->rollBack();
echo $e->getMessage();
echo $e->getTraceAsString();
return $msgarray;
}
} else {
$messages = $appraisalconfigform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
if (isset($businessunit_id) && $businessunit_id != '') {
if ($performance_app_flag == 0) {
$departmentlistArr = $departmentsmodel->getDepartmentList($businessunit_id);
if (!empty($departmentlistArr)) {
foreach ($departmentlistArr as $departmentlist) {
$appraisalconfigform->department_id->addMultiOption($departmentlist['id'], utf8_encode($departmentlist['deptname']));
}
}
}
if (isset($department_id) && $department_id != 0 && $department_id != '') {
$appraisalconfigform->setDefault('department_id', $department_id);
}
}
return $msgarray;
}
}
public function addpopupAction()
{
Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/");
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->getRequest()->getParam('id');
$controllername = 'nationality';
$nationalityform = new Default_Form_nationality();
$nationalitymodel = new Default_Model_Nationality();
$nationalityform->setAction(BASE_URL . 'nationality/addpopup');
if ($this->getRequest()->getPost()) {
if ($nationalityform->isValid($this->_request->getPost())) {
$nationalitycode = $this->_request->getParam('nationalitycode');
$description = $this->_request->getParam('description');
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('nationalitycode' => trim($nationalitycode), 'description' => trim($description), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('id=?' => $id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
}
$Id = $nationalitymodel->SaveorUpdateNationalityData($data, $where);
$tableid = $Id;
$menuidArr = $menumodel->getMenuObjID('/nationality');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$nationalitycodeData = $nationalitymodel->fetchAll('isactive = 1', 'nationalitycode')->toArray();
$opt = '';
foreach ($nationalitycodeData as $record) {
$opt .= sapp_Global::selectOptionBuilder($record['id'], $record['nationalitycode']);
}
$this->view->nationalitycodeData = $opt;
$this->view->eventact = 'added';
$close = 'close';
$this->view->popup = $close;
} else {
$messages = $nationalityform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
$this->view->msgarray = $msgarray;
}
}
$this->view->controllername = $controllername;
$this->view->form = $nationalityform;
}
public function addpopupAction()
{
Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/");
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$controllername = 'bgscreeningtype';
$msgarray = array();
$bgscreeningtypeform = new Default_Form_bgscreeningtype();
$bgscreeningtypeform->setAttrib('action', DOMAIN . 'bgscreeningtype/addpopup');
$this->view->form = $bgscreeningtypeform;
if ($this->getRequest()->getPost()) {
$id = $this->_request->getParam('id');
$type = $this->_request->getParam('type');
$bgscreeningtypemodel = new Default_Model_Bgscreeningtype();
$typeExistance = $bgscreeningtypemodel->checktypeduplicates($type, $id);
$flag = 'true';
if ($typeExistance) {
$msgarray['type'] = 'Screening type already exists.';
$flag = 'false';
}
if ($bgscreeningtypeform->isValid($this->_request->getPost()) && $flag == 'true') {
$id = $this->_request->getParam('id');
$type = $this->_request->getParam('type');
$description = $this->_request->getParam('description');
if (!$typeExistance) {
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('type' => $type, 'description' => $description, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('id=?' => $id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
}
$Id = $bgscreeningtypemodel->SaveorUpdateScreeningtype($data, $where);
$tableid = $Id;
$menuidArr = $menumodel->getMenuObjID('/bgscreeningtype');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$screeningData = $bgscreeningtypemodel->fetchAll('isactive = 1', 'type')->toArray();
$opt = '';
foreach ($screeningData as $record) {
$opt .= sapp_Global::selectOptionBuilder($record['id'], $record['type']);
}
$this->view->screeningData = $opt;
$this->view->eventact = 'added';
$close = 'close';
$this->view->popup = $close;
} else {
$msgarray['message'] = 'Screening type already exists.';
$msgarray['msgtype'] = 'error';
}
} else {
$messages = $bgscreeningtypeform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
}
}
$this->view->controllername = $controllername;
$this->view->msgarray = $msgarray;
$this->view->messages = $msgarray;
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$actionflag = 3;
if ($id) {
$assignmententryreasoncodemodel = new Default_Model_Assignmententryreasoncode();
$menumodel = new Default_Model_Menu();
$data = array('isactive' => 0);
$where = array('id=?' => $id);
$Id = $assignmententryreasoncodemodel->SaveorUpdateAssignmentEntryData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/assignmententryreasoncode');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Assignment entry reason code deleted successfully.';
} else {
$messages['message'] = 'Assignment entry reason code cannot be deleted.';
}
} else {
$messages['message'] = 'Assignment entry reason code cannot be deleted.';
}
$this->_helper->json($messages);
}
public function breadcrumbs($baseUrlString = '')
{
$request = Zend_Controller_Front::getInstance();
$params = $request->getRequest()->getParams();
$controllerName = $request->getRequest()->getControllerName();
$action_Name = $request->getRequest()->getActionName();
$tName = '';
$vName = '';
$tUrl = '';
$serviceUrl = '';
$burl = $controllerName . "/" . $action_Name;
/**
*
* For service request modifying the breadcrum based on t and v params
* @var t and @var v
*/
$param_t = isset($params['t']) ? sapp_Global::_decrypt($params['t']) : "";
$param_v = isset($params['v']) ? sapp_Global::_decrypt($params['v']) : "";
$service_menu = sapp_Helper::sd_menu_names();
$service_action_arr = sapp_Helper::sd_action_names();
if ($param_t != '' && isset($service_menu[$param_t])) {
$tName = $service_menu[$param_t] . ' Summary';
$tUrl = $baseUrlString . '/' . $controllerName . '/index/t/' . sapp_Global::_encrypt($param_t);
}
if ($param_v != '' && isset($service_action_arr[$param_v])) {
$vName = $service_action_arr[$param_v];
} else {
$vName = $action_Name != 'index' ? $action_Name : '';
}
if ($vName != '') {
if ($tName != '') {
$serviceUrl = '<a href=' . $tUrl . '>' . $tName . '</a><span class="arrows">›</span>';
}
$serviceUrl .= '<span>' . ucfirst($vName) . '</span>';
} else {
$serviceUrl = '<span>' . $tName . '</span>';
}
/**
* End modifying breadcrum for servicerequest.
*/
unset($params['module'], $params['controller'], $params['action']);
if (isset($params['error_handler'])) {
unset($params['error_handler']);
}
$id_name = '';
if (is_array($params) && !empty($params)) {
foreach ($params as $key => $value) {
if (!is_array($value)) {
$burl .= "/" . $key . "/" . $value;
}
}
$id_name = "yes";
}
$pageUrl = explode("/", $_SERVER['REQUEST_URI']);
$serverUrl = $_SERVER['HTTP_HOST'];
$reportsArr = array('leavesreport' => 'Leaves', 'holidaygroupreports' => 'Holidays', 'activeuser' => 'Active Users', 'employeereport' => 'Employees', 'rolesgroup' => 'Roles', 'emprolesgroup' => 'Employee Roles', 'userlogreport' => 'User Logs', 'activitylogreport' => 'Activity Logs', 'requisitionstatusreport' => 'Requisition');
$pageName = $controllerName;
$actionName = $action_Name;
$breadCrumbsData = '';
$mydetails_arr = array('jobhistory' => 'Employee Job History', 'certification' => 'Training & Certification Details', 'experience' => 'Experience Details', 'education' => 'Education Details', 'medicalclaims' => 'Medical Claims', 'leaves' => 'Employee Leaves', 'skills' => 'Employee Skills', 'communication' => 'Contact Details', 'communicationdetailsview' => 'Contact Details', 'disability' => 'Disability Details', 'disabilitydetailsview' => 'Disability Details', 'workeligibility' => 'Work Eligibility Details', 'workeligibilitydetailsview' => 'Work Eligibility Details', 'visa' => 'Visa and Immigration Details', 'visadetailsview' => 'Visa and Immigration Details', 'additionaldetails' => 'Additional Details', 'additionaldetailsview' => 'Additional Details', 'salarydetails' => 'Salary Details', 'salarydetailsview' => 'Salary Details', 'personal' => 'Personal Details', 'personaldetailsview' => 'Personal Details', 'creditcard' => 'Corporate Card Details', 'creditcarddetailsview' => 'Corporate Card Details', 'dependency' => 'Dependency Details', 'edit' => 'Edit');
$myemployees_arr = array('additionaldetailsview' => 'Additional Details', 'jobhistoryview' => 'Job History', 'perview' => 'Personal Details', 'expview' => 'Experience Details', 'eduview' => 'Education Details', 'skillsview' => 'Employee Skills', 'comview' => 'Contact Details', 'trainingview' => 'Training & Certification Details', 'view' => 'View');
if ($pageName == '' || $pageName == 'welcome') {
$breadCrumbsData .= '';
} else {
if ($pageName == 'dashboard') {
$breadCrumbsData = '<div class="breadcrumbs">';
if ($actionName == 'viewsettings') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Settings';
} else {
if ($actionName == 'viewprofile') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Profile';
} else {
if ($actionName == 'changepassword') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Change Password';
} else {
if ($actionName == 'emailsettings') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Email Settings';
} else {
if ($actionName == 'upgradeapplication') {
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Upgrade Application ';
}
}
}
}
}
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'configuresite') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Configure Site';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'managemenus') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Manage Modules';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'logmanager') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Activity Log';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'userloginlog') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> User Log';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'servicerequests') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span> Service Request Management<span class="arrows">›</span>' . $serviceUrl . '';
$breadCrumbsData .= '</div>';
} else {
if ($pageName == 'reports') {
$breadCrumbsData = '<div class="breadcrumbs">';
$breadCrumbsData .= '<a href="' . $baseUrlString . '">Home</a> <span class="arrows">›</span>';
if (isset($actionName) && $actionName != '') {
$breadCrumbsData .= '<span><a href="' . $baseUrlString . '/reports">Analytics</a></span>';
if ($actionName == 'userlogreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Audit Logs<span class="arrows">›</span><span>User log Report</span>';
} else {
if ($actionName == 'activitylogreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Audit Logs<span class="arrows">›</span><span>Activity log Report</span>';
} else {
if ($actionName == 'businessunits') {
$breadCrumbsData .= '<span class="arrows">›</span>Organization<span class="arrows">›</span><span>Business Units Report</span>';
} else {
if ($actionName == 'departments') {
$breadCrumbsData .= '<span class="arrows">›</span>Organization<span class="arrows">›</span><span>Departments Report</span>';
} else {
if ($actionName == 'leavesreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Leave Management<span class="arrows">›</span><span>Employee Leaves Summary Report</span>';
} else {
if ($actionName == 'leavemanagementreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Leave Management<span class="arrows">›</span><span>Leave Management Summary Report</span>';
} else {
if ($actionName == 'holidaygroupreports') {
$breadCrumbsData .= '<span class="arrows">›</span>Holiday Management<span class="arrows">›</span><span>Holiday Groups & Holidays Report</span>';
} else {
if ($actionName == 'employeereport') {
$breadCrumbsData .= '<span class="arrows">›</span><span>Employees Report</span> ';
} else {
if ($actionName == 'rolesgroup') {
$breadCrumbsData .= '<span class="arrows">›</span>User Management<span class="arrows">›</span><span>Groups & Roles Report</span>';
} else {
if ($actionName == 'emprolesgroup') {
$breadCrumbsData .= '<span class="arrows">›</span>User Management<span class="arrows">›</span><span>Groups, Roles & Employees Report</span>';
} else {
if ($actionName == 'activeuser') {
$breadCrumbsData .= '<span class="arrows">›</span>User Management<span class="arrows">›</span><span>Users & Employees Report</span>';
} else {
if ($actionName == 'requisitionstatusreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Resource Requisition<span class="arrows">›</span><span>Requisitions Report</span>';
} else {
if ($actionName == 'candidatesreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Resource Requisition<span class="arrows">›</span><span>Candidate Details Report</span>';
} else {
if ($actionName == 'interviewrounds') {
$breadCrumbsData .= '<span class="arrows">›</span>Resource Requisition<span class="arrows">›</span><span>Scheduled Interviews Report</span>';
} else {
if ($actionName == 'empscreening') {
$breadCrumbsData .= '<span class="arrows">›</span>Background Checks<span class="arrows">›</span><span>Employee / Candidate Screening Report</span>';
} else {
if ($actionName == 'agencylistreport') {
$breadCrumbsData .= '<span class="arrows">›</span>Background Checks<span class="arrows">›</span><span>Background Checks Agencies Report</span>';
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
} else {
$breadCrumbsData .= '<span>Analytics</span>';
}
$breadCrumbsData .= '</div>';
} else {
$breadCrumbsData = '<div class="breadcrumbs">';
$url = "/" . $pageName;
$breadCrumIds = $this->getBreadCrumDetails($url);
$breadCrumNames = array();
if (!empty($breadCrumIds)) {
$menu_model = new Default_Model_Menu();
$breadcrumstring = trim($breadCrumIds[0]['nav_ids'], ',');
$breadcrumArr = explode(",", $breadcrumstring);
$breadCrumNames = $breadCrumIds;
$breadCrumbsData .= '<span class="firstbreadcrumb" onclick="window.location=\'' . $baseUrlString . '\'">Home</span> <span class="arrows">›</span> ';
for ($b = 0; $b < sizeof($breadCrumNames); $b++) {
$breadCrumNames[$b]['menuName'] = $menu_model->getMenuText($breadCrumNames[$b]['menuName']);
if ($b == 0) {
if ($breadCrumNames[$b]['url'] == '/sitepreference') {
$breadCrumbsData .= '<span>' . $breadCrumNames[$b]['menuName'] . '</span>';
} else {
$breadCrumbsData .= '<span>' . $breadCrumNames[$b]['menuName'] . '</span> <span class="arrows">›</span> ';
}
} else {
if ($b == sizeof($breadCrumNames) - 1) {
if ($actionName == '') {
$breadCrumbsData .= '<span>' . $breadCrumNames[$b]['menuName'] . '</span>';
} else {
$breadCrumbsData .= '<a href="' . $baseUrlString . $breadCrumNames[$b]['url'] . '" >' . $breadCrumNames[$b]['menuName'] . '</a>';
}
} else {
$breadCrumbsData .= '<span>' . $breadCrumNames[$b]['menuName'] . '</span> <span class="arrows">›</span> ';
}
}
}
if ($actionName == 'add' || $actionName == 'edit' && $id_name == '' || $actionName != '' && $actionName != 'view') {
if ($actionName == 'edit' || $actionName != '') {
$idvalindex = '';
if (in_array('id', $pageUrl)) {
$idindex = array_search('id', $pageUrl);
$idvalindex = $idindex + 1;
} else {
if (in_array('userid', $pageUrl)) {
$idindex = array_search('userid', $pageUrl);
$idvalindex = $idindex + 1;
}
}
if ((in_array('id', $pageUrl) || in_array('userid', $pageUrl)) && $pageName != 'myemployees') {
$idval = intval($pageUrl[$idvalindex]);
if ($idval != 0) {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Edit</span>';
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
}
} else {
if ($pageName == 'mydetails') {
if (isset($actionName) && $actionName != '') {
if (array_key_exists($actionName, $mydetails_arr) !== false) {
$breadCrumbsData .= '<span class="arrows">›</span> <span>' . $mydetails_arr[$actionName] . '</span>';
}
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Edit</span>';
}
} else {
if ($pageName == 'myemployees') {
if (isset($actionName) && $actionName != '') {
if (array_key_exists($actionName, $myemployees_arr) !== false) {
$breadCrumbsData .= '<span class="arrows">›</span> <span>' . $myemployees_arr[$actionName] . '</span>';
}
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>View</span>';
}
} else {
if ($actionName == 'multipleresume') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add multiple CVs</span>';
}
if ($actionName == 'edit' && $pageName == 'heirarchy') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Edit</span>';
} else {
if ($actionName == 'edit' || $actionName == 'add') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
} else {
$breadCrumbsData .= '';
}
}
}
}
}
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
}
} else {
if ($actionName == 'edit') {
$idvalindex = '';
if (in_array('id', $pageUrl)) {
$idindex = array_search('id', $pageUrl);
$idvalindex = $idindex + 1;
} else {
if (in_array('userid', $pageUrl)) {
$idindex = array_search('userid', $pageUrl);
$idvalindex = $idindex + 1;
}
}
if (in_array('id', $pageUrl) || in_array('userid', $pageUrl)) {
$idval = intval($pageUrl[$idvalindex]);
if ($idval != '') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Edit</span>';
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
}
} else {
$breadCrumbsData .= '<span class="arrows">›</span> <span>Add</span>';
}
} else {
if ($actionName == 'view') {
$breadCrumbsData .= '<span class="arrows">›</span> <span>View</span>';
}
}
}
$breadCrumbsData .= '</div>';
} else {
$breadCrumbsData = '';
}
}
}
}
}
}
}
}
}
echo $breadCrumbsData;
}
/**
** 1. gets menudata from database
** 2. prepares the first and second level menuids array
** 3. builds the menu tree html
** 4. con = settings for settings menu
**/
public function menubuilder($con = "", $userRole = 2, $flag = "", $usergroup)
{
$uploadPath = BASE_URL . '/public/media/images/menuIcons/';
$menuheightclass = '';
$groupbasedclass = '';
$ulclass = '';
if ($usergroup == '' || $usergroup == MANAGEMENT_GROUP) {
$menuheightclass = '';
$groupbasedclass = '';
} else {
$menuheightclass = 'menuheight';
$groupbasedclass = '-common';
$ulclass = 'new-roles';
}
$menu_model = new Default_Model_Menu();
$marr = $menu_model->getgroup_formenu($usergroup, $userRole, '');
$menuarr = $marr['tmpArr'];
$parent_menu_class = array(SITECONFIGURATION => 'site-configuration', EMPLOYEECONFIGURATION => "employee-configuration", SITEPREFERENCE => "site-preferences", ORGANIZATION => "organization-menu", USERMANAGEMENT => "user-management", HUMANRESOURCE => "hr-module", RESOURCEREQUISITION => "req-module", EMPLOYEESELFSERVICE => "ess-module", BGCHECKS => "bg-module", REPORTS => "report-module", MANAGEMODULE => "manage-module", SERVICEDESK => 'service-desk', PERFORMANCEAPPRAISAL => "perf-app", FEED_FORWARD => "feed-forward", DASHBOARD_MENU => "dashboard");
$parent_menu_selected_class = array(SITECONFIGURATION => 'sitec-selected', EMPLOYEECONFIGURATION => "employeec-selected", SITEPREFERENCE => "sitep-selected", ORGANIZATION => "organization-selected", USERMANAGEMENT => "user-selected", HUMANRESOURCE => "hr-selected", RESOURCEREQUISITION => "req-selected", EMPLOYEESELFSERVICE => "ess-selected", BGCHECKS => "bg-selected", REPORTS => "report-selected", MANAGEMODULE => "manage-selected", SERVICEDESK => 'service-selected', PERFORMANCEAPPRAISAL => "perf-app-selected", FEED_FORWARD => 'feed-forward-selected', DASHBOARD_MENU => "dashboard-selected");
$tour_menu_class = array(SITECONFIGURATION => 'tour_siteconfiguration', EMPLOYEECONFIGURATION => "tour_employeeconfigurations", SITEPREFERENCE => "tour_sitepreferences", ORGANIZATION => "tour_organization", USERMANAGEMENT => "tour_usermanagement", HUMANRESOURCE => "tour_humanresource", RESOURCEREQUISITION => "tour_requisition", EMPLOYEESELFSERVICE => "tour_employeeselfservice", BGCHECKS => "tour_backgroundchecks", REPORTS => "tour_reports", MANAGEMODULE => "tour_managemodules", SERVICEDESK => 'tour_service', PERFORMANCEAPPRAISAL => "tour_performanceappraisal", FEED_FORWARD => 'tour_feedforward', DASHBOARD_MENU => "tour_dashboard");
$childs_menu = "";
$parent_menu = "<div class='home_menu'><div class='menu-head " . $menuheightclass . "' id='menu-shadow' style='display:none;'>\n\t\t\t\t<ul id='scroller' class='" . $ulclass . "'>";
$clas_drag = $con == 'settings' ? ' draggable-reports-li ' : '';
// Add draggable class for dashbord
$parent_menu .= "<li id='main_parent_" . DASHBOARD_MENU . "' super-parent = 'main_parent_" . DASHBOARD_MENU . "' class = '" . $clas_drag . "clickable_menu " . $parent_menu_selected_class[DASHBOARD_MENU] . "-main " . $tour_menu_class[DASHBOARD_MENU] . "' menu-url ='" . BASE_URL . "/welcome' selected-class = '" . $parent_menu_selected_class[DASHBOARD_MENU] . "' > <a id='" . DASHBOARD_MENU . "' ><span class='scroll-menu dashboard dashboard-selected-common super_selected'></span><b>Dashboard</b></a></li>";
foreach ($menuarr as $menuid => $data) {
$for_childs_str = "";
$parent_url = BASE_URL . $data['url'];
if (isset($data['childs']) && count($data['childs']) > 0) {
$for_childs_str = "div_mchilds_" . $menuid;
$parent_url = "";
$childs_menu .= "<div class='side-menu " . $for_childs_str . "' style='display:none;'>\n\t\t\t\t\t\t\t\t\t<ul>";
foreach ($data['childs'] as $ch_menu_id => $ch_menu_data) {
if (isset($ch_menu_data['childs']) && count($ch_menu_data['childs']) > 0) {
$childs_menu .= "<li class='acc_li'><span class='acc_li_toggle' id='acc_li_toggle_" . $ch_menu_data['id'] . "' onclick='togglesubmenus(" . $ch_menu_data['id'] . ");'><b>" . $ch_menu_data['menuName'] . "</b></span><ul>";
foreach ($ch_menu_data['childs'] as $ch2_menu_id => $ch2_menu_data) {
if ($con == 'settings') {
$childs_menu .= "<li class = 'clickable_menu' super-parent = 'main_parent_" . $menuid . "' menu-url = '" . BASE_URL . $ch2_menu_data['url'] . "' parent-div = '" . $for_childs_str . "'><a id=" . $ch2_menu_data['id'] . " href='javascript:void(0);'>" . $ch2_menu_data['menuName'] . "</a></li>";
} else {
$childs_menu .= "<li class = 'clickable_menu' primary_parent = '" . $ch2_menu_data['parent'] . "' super-parent = 'main_parent_" . $menuid . "' menu-url = '" . BASE_URL . $ch2_menu_data['url'] . "' parent-div = '" . $for_childs_str . "'><a id=" . $ch2_menu_data['id'] . " href='" . BASE_URL . $ch2_menu_data['url'] . "/'>" . $ch2_menu_data['menuName'] . "</a></li>";
}
}
$childs_menu .= "</ul></li>";
} else {
if ($con == 'settings') {
if ($menuid == SERVICEDESK && $ch_menu_id == SD_TRANS) {
$storage = new Zend_Auth_Storage_Session();
$sess_data = $storage->read();
$childs_menu .= sapp_Helper::service_header($sess_data, 'menusettings');
} else {
$childs_menu .= "<li class = 'clickable_menu single-menu' super-parent = 'main_parent_" . $menuid . "' menu-url = '" . BASE_URL . $ch_menu_data['url'] . "' parent-div = '" . $for_childs_str . "'><a id=" . $ch_menu_data['id'] . " href='javascript:void(0);'>" . $ch_menu_data['menuName'] . "</a></li>";
}
} else {
if ($menuid == SERVICEDESK && $ch_menu_id == SD_TRANS) {
$storage = new Zend_Auth_Storage_Session();
$sess_data = $storage->read();
$childs_menu .= sapp_Helper::service_header($sess_data, 'menu');
} else {
$condition = $ch_menu_data['id'] == 168 ? "<span class='beta_menu'></span>" : "";
$childs_menu .= "<li class = 'clickable_menu single-menu' super-parent = 'main_parent_" . $menuid . "' menu-url = '" . BASE_URL . $ch_menu_data['url'] . "' parent-div = '" . $for_childs_str . "'><a id=" . $ch_menu_data['id'] . " href='" . BASE_URL . $ch_menu_data['url'] . "/'>" . $ch_menu_data['menuName'] . $condition . "</a></li>";
}
}
}
}
$childs_menu .= "</ul></div>";
}
$super_str = "";
$dummy_parent_div = "";
if ($menuid == SITEPREFERENCE) {
$super_str = " super-parent = 'main_parent_" . $menuid . "' ";
$dummy_parent_div = "parent-div = 'dummy'";
}
if ($con == 'settings') {
$parent_menu .= "<li id='main_parent_" . $menuid . "' " . $dummy_parent_div . " " . $super_str . " super-parent = 'main_parent_" . $menuid . "' class = 'draggable-reports-li clickable_menu " . $parent_menu_selected_class[$menuid] . ($groupbasedclass != '' ? "-main-common " : "-main ") . $tour_menu_class[$menuid] . "' menu-url ='" . $parent_url . "' for-childs = '" . $for_childs_str . "' selected-class = '" . ($groupbasedclass != '' ? $parent_menu_selected_class[$menuid] . "-common" : $parent_menu_selected_class[$menuid]) . "'><a id='" . $menuid . "'><span class='scroll-menu " . ($groupbasedclass != '' ? $parent_menu_class[$menuid] . "-common" : $parent_menu_class[$menuid]) . "'></span><b>" . $data['menuName'] . "</b></a></li>";
} else {
$groupclass = "";
$parent_menu .= "<li id='main_parent_" . $menuid . "' " . $dummy_parent_div . " " . $super_str . " super-parent = 'main_parent_" . $menuid . "' class = 'clickable_menu " . $parent_menu_selected_class[$menuid] . ($groupbasedclass != '' ? "-main-common " : "-main ") . $tour_menu_class[$menuid] . "' menu-url ='" . $parent_url . "' for-childs = '" . $for_childs_str . "' selected-class = '" . ($groupbasedclass != '' ? $parent_menu_selected_class[$menuid] . "-common" : $parent_menu_selected_class[$menuid]) . "'><a id='" . $menuid . "'><span class='scroll-menu " . ($groupbasedclass != '' ? $parent_menu_class[$menuid] . "-common" : $parent_menu_class[$menuid]) . "'></span><b>" . $data['menuName'] . "</b></a></li>";
}
}
//end of for loop
if (($userRole == SUPERADMIN || $usergroup == MANAGEMENT_GROUP) && $con != 'settings') {
$parent_menu .= "<li selected-class='log-selected' id='main_parent_logs' class='clickable_menu log-selected-main tour_logs' menu-url='' for-childs = 'div_mchilds_logs'><span class='scroll-menu log-module'></span><b>Logs</b></li>";
$childs_menu .= "<div class='side-menu div_mchilds_logs' style='display:none;'>\n\t\t\t\t\t\t\t\t<ul>\n\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t<li super-parent = 'main_parent_logs' parent-div='div_mchilds_logs' class = 'clickable_menu single-menu' menu-url = '" . BASE_URL . "/logmanager'><a href='" . BASE_URL . "/logmanager'>Activity Log</a></li>\n\t\t\t\t\t\t\t\t<li super-parent = 'main_parent_logs' parent-div='div_mchilds_logs' class = 'clickable_menu single-menu' menu-url = '" . BASE_URL . "/userloginlog'><a href='" . BASE_URL . "/userloginlog'>User Log</a></li>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t</ul>\n\t\t\t\t\t\t\t </div>";
}
$parent_menu .= " </ul>\n\t\t\t </div></div>\n\t\t";
return array('parent_menu' => $parent_menu, 'childs_menu' => $childs_menu);
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$messages['flagtype'] = '';
$actionflag = 3;
if ($id) {
$positionsmodel = new Default_Model_Positions();
$menumodel = new Default_Model_Menu();
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$position_data = $positionsmodel->getsinglePositionData($id);
$Id = $positionsmodel->SaveorUpdatePositionData($data, $where);
if ($Id == 'update') {
sapp_Global::send_configuration_mail("Positions", $position_data[0]['positionname']);
$menuidArr = $menumodel->getMenuObjID('/positions');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Position deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Position cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Position cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
/**
* This function is used to check whether a menu is activated or inactivated.
* @param Integer $objectId = id of the menu item.
* @return string Returns true if isactive = 1 and false if isactive != 1
*/
public static function _isactivemodule($objectId)
{
$menuID = $objectId;
$menu_model = new Default_Model_Menu();
$menuobj = $menu_model->checkmenustatus($menuID);
if ($menuobj['isactive'] == '1') {
return true;
} else {
return false;
}
}
public function addnewstateAction()
{
Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/");
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$msgarray = array();
$controllername = 'states';
$statestring = '';
$id = $this->getRequest()->getParam('id');
$selectedcountryid = $this->_request->getParam('selectcountryid', null);
$statesform = new Default_Form_states();
$statesmodel = new Default_Model_States();
$countriesModel = new Default_Model_Countries();
/* Changing the form */
$statesform->setAction(BASE_URL . 'states/addnewstate/selectcountryid/' . $selectedcountryid);
$statesform->removeElement('state');
$statesform->addElement('text', 'state', array('label' => 'State', 'maxlength' => '20', 'required' => true, 'validators' => array(array('validator' => 'NotEmpty', 'options' => array('messages' => 'Please enter state name.')))));
/* END */
$countrieslistArr = $countriesModel->getTotalCountriesList('');
if (sizeof($countrieslistArr) > 0) {
$statesform->countryid->addMultiOption('', 'Select Country');
foreach ($countrieslistArr as $countrieslistres) {
if (isset($selectedcountryid)) {
if ($countrieslistres['id'] == $selectedcountryid) {
$statesform->countryid->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name']));
$statesform->setDefault('countryid', $selectedcountryid);
}
} else {
$statesform->countryid->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name']));
}
}
} else {
$msgarray['countryid'] = 'Countries are not configured yet';
}
if ($this->getRequest()->getPost()) {
$errorflag = "true";
$msgarray = array();
$id = $this->_request->getParam('id');
$dbstate = '';
$dbcountryid = '';
$state = trim($this->_request->getParam('state'));
$countryid = $this->_request->getParam('countryid');
if (isset($countryid) && $countryid != '') {
$isDuplicateStateNameArr = $statesmodel->getDuplicateStateName($state, $countryid);
if ($isDuplicateStateNameArr[0]['count'] > 0) {
$errorflag = "false";
$msgarray['state'] = "State already exists.";
}
} else {
$errorflag = "false";
$msgarray['countryid'] = "Please select country.";
}
if ($statesform->isValid($this->_request->getPost()) && $errorflag == "true") {
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$NewStateId = $statesmodel->SaveMainStateData($countryid, $state);
$tableid = $NewStateId;
$actionflag = 1;
$menuidArr = $menumodel->getMenuObjID('/states');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
if (isset($selectedcountryid)) {
$stateData = $statesmodel->getStatesList($selectedcountryid, '');
} else {
$stateData = array();
}
$opt = '';
foreach ($stateData as $record) {
$opt .= sapp_Global::selectOptionBuilder($record['id'], $record['state_name']);
}
$this->view->stateData = $opt;
$this->view->eventact = 'added';
$close = 'close';
$this->view->popup = $close;
} else {
$messages = $statesform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
}
}
$this->view->ermsg = '';
$this->view->form = $statesform;
$this->view->msgarray = $msgarray;
$this->view->controllername = $controllername;
}
public function save($creditcardDetailsform)
{
$result = "";
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$date = new Zend_Date();
if ($creditcardDetailsform->isValid($this->_request->getPost())) {
$post_values = $this->_request->getPost();
if (isset($post_values['id'])) {
unset($post_values['id']);
}
if (isset($post_values['user_id'])) {
unset($post_values['user_id']);
}
if (isset($post_values['submit'])) {
unset($post_values['submit']);
}
$new_post_values = array_filter($post_values);
$user_id = $this->_request->getParam('userid');
if (!empty($new_post_values)) {
$creditcardDetailsModel = new Default_Model_Creditcarddetails();
$id = $this->_request->getParam('id');
$card_type = $this->_request->getParam('card_type');
$card_number = $this->_request->getParam('card_number');
$card_name = $this->_request->getParam('nameoncard');
$card_expiry_1 = $this->_request->getParam('card_expiration', null);
$card_expiry = sapp_Global::change_date($card_expiry_1, 'database');
$card_issuedBy = $this->_request->getParam('card_issuedby');
$card_code = $this->_request->getParam('card_code');
$data = array('card_type' => $card_type, 'card_number' => $card_number, 'nameoncard' => $card_name, 'card_expiration' => $card_expiry, 'card_issued_comp' => $card_issuedBy, 'card_code' => $card_code, 'user_id' => $user_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('user_id=?' => $user_id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$where = '';
$actionflag = 1;
}
$Id = $creditcardDetailsModel->SaveorUpdateCreditcardDetails($data, $where);
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee corporate card details updated successfully."));
} else {
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee corporate card details added successfully."));
}
$menumodel = new Default_Model_Menu();
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => FIELDMSG));
}
$this->_redirect('creditcarddetails/edit/userid/' . $user_id);
} else {
$messages = $creditcardDetailsform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
return $msgarray;
}
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$count = 0;
$actionflag = 3;
if ($id) {
$appraisalquestionsmodel = new Default_Model_Appraisalquestions();
$menumodel = new Default_Model_Menu();
$appraisalquestionsdata = $appraisalquestionsmodel->getAppraisalQuestionbyID($id);
if ($appraisalquestionsdata[0]['isused'] == 0) {
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifiedby' => $loginUserId);
$where = array('id=?' => $id);
$Id = $appraisalquestionsmodel->SaveorUpdateAppraisalQuestionData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/appraisalquestions');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$configmail = sapp_Global::send_configuration_mail('Question', $appraisalquestionsdata[0]['question']);
$messages['message'] = 'Question deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Question cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Question cannot be deleted as its using in appraisal process.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Question cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function save($empleavesform, $userid, $used_leaves, $leavetransfercount, $isleavetrasnferset, $currentyearleavecount)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
if ($empleavesform->isValid($this->_request->getPost())) {
$employeeleavesModel = new Default_Model_Employeeleaves();
$id = $this->_request->getParam('id');
$user_id = $userid;
$emp_leave_limit = $this->_request->getParam('leave_limit');
if ($leavetransfercount != '' && $currentyearleavecount == '') {
$emp_leave_limit = $emp_leave_limit + $leavetransfercount;
} else {
$emp_leave_limit = $emp_leave_limit + $currentyearleavecount;
}
$isleavetrasnfer = 0;
if ($isleavetrasnferset == 1) {
$isleavetrasnfer = 1;
}
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
/* Save employee leaves in allotted leaves log */
$postedArr = array();
$postedArr = $_POST;
$saveID = $employeeleavesModel->saveallotedleaves($postedArr, $emp_leave_limit, $user_id, $loginUserId);
/* END */
$Id = $employeeleavesModel->SaveorUpdateEmployeeLeaves($user_id, $emp_leave_limit, $isleavetrasnfer, $loginUserId);
if ($id) {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee Leave details updated successfully."));
$actionflag = 2;
$tableid = $id;
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee Leave details added successfully."));
$actionflag = 1;
$tableid = $Id;
}
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
$this->_redirect('empleaves/edit/userid/' . $user_id);
} else {
$messages = $empleavesform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
return $msgarray;
}
}
public function savegroupedemployees()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$appraisalinitmodel = new Default_Model_Appraisalgroupemployeestemp();
$menumodel = new Default_Model_Menu();
$groupid = $this->_request->getParam('group_id');
$appraisalid = $this->_request->getParam('appraisalid');
$empids = $this->_request->getParam('empids');
$id = '';
$actionflag = '';
$tableid = '';
$msgarray = array();
if (!isset($groupid) && $groupid == '') {
$groupid = 0;
}
try {
$ifrecordexists = $appraisalinitmodel->checkAppraisalRecordexists($groupid, $appraisalid);
if (!empty($ifrecordexists)) {
$id = $ifrecordexists[0]['id'];
}
$insertdata = array('pa_initialization_id' => $appraisalid, 'group_id' => $groupid, 'employee_ids' => $empids, 'isactive' => 1, 'createdby' => $loginUserId, 'createdby_role' => $loginuserRole, 'createdby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$updatedata = array('employee_ids' => $empids, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('id=?' => $id);
$actionflag = 2;
$tableid = $id;
$appraisalinitmodel->SaveorUpdateAppraisalGroupsEmployeesTempData($updatedata, $where);
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employees updated successfully."));
} else {
$where = '';
$actionflag = 1;
$Id = $appraisalinitmodel->SaveorUpdateAppraisalGroupsEmployeesTempData($insertdata, $where);
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employees added successfully."));
}
$menuidArr = $menumodel->getMenuObjID('/appraisalinit');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$this->_redirect('appraisalinit/assigngroups/id/' . $appraisalid);
} catch (Exception $e) {
$msgarray = $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => $e->getMessage()));
}
return $msgarray;
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$actionflag = 3;
if ($id) {
$leavemanagementmodel = new Default_Model_Leavemanagement();
$menumodel = new Default_Model_Menu();
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$Id = $leavemanagementmodel->SaveorUpdateLeaveManagementData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/leavemanagement');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Leave management deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Leave management cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Leave management cannot be deleted.';
$messages['msgtype'] = 'succerroress';
}
$this->_helper->json($messages);
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$actionflag = 3;
if ($id) {
$numberformatsmodel = new Default_Model_Numberformats();
$menumodel = new Default_Model_Menu();
$numberformatdata = $numberformatsmodel->getNumberFormatDataByID($id);
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$Id = $numberformatsmodel->SaveorUpdateNumberFormatData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/numberformats');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$configmail = sapp_Global::send_configuration_mail('Number Format', $numberformatdata[0]['numberformattype']);
$messages['message'] = 'Number format deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Number format cannot be deleted.';
$messages['msgtype'] = 'success';
}
} else {
$messages['message'] = 'Number format cannot be deleted.';
$messages['msgtype'] = 'success';
}
$this->_helper->json($messages);
}
public function updatecontactnumberAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('id');
$contactnumber = $this->_request->getParam('contactnumber');
$messages['message'] = '';
$actionflag = 2;
if ($id) {
$usersModal = new Default_Model_Users();
$menumodel = new Default_Model_Menu();
$data = array('contactnumber' => $contactnumber);
$where = array('id=?' => $id);
$Id = $usersModal->addOrUpdateUserModel($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Contact number updated successfully.';
} else {
$messages['message'] = 'Contact number cannot be updated.';
}
} else {
$messages['message'] = 'Contact number cannot be updated.';
}
$this->_helper->json($messages);
}
public function updateempdetails($employeeform)
{
$emproleStr = '';
$roleArr = array();
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$usersModel = new Default_Model_Usermanagement();
$employeeModal = new Default_Model_Employee();
$businessunit_id = $this->_request->getParam('businessunit_id', null);
$department_id = $this->_request->getParam('department_id', null);
$reporting_manager = $this->_request->getParam('reporting_manager', null);
$jobtitle_id = $this->_request->getParam('jobtitle_id', null);
$position_id = $this->_request->getParam('position_id', null);
$user_id = $this->_getParam('user_id', null);
$prefix_id = $this->_getParam('prefix_id', null);
$extension_number = $this->_getParam('extension_number', null);
if ($employeeform->isValid($this->_request->getPost())) {
$id = $this->_request->getParam('id');
$emp_status_id = $this->_request->getParam('emp_status_id', null);
$date_of_joining = $this->_request->getParam('date_of_joining', null);
$date_of_joining = sapp_Global::change_date($date_of_joining, 'database');
$date_of_leaving = $this->_request->getParam('date_of_leaving', null);
$date_of_leaving = sapp_Global::change_date($date_of_leaving, 'database');
$years_exp = $this->_request->getParam('years_exp');
//FOR USER table
$employeeId = $this->_getParam('employeeId', null);
$modeofentry = $this->_getParam('modeofentry', null);
$hid_modeofentry = $this->_getParam('hid_modeofentry', null);
$other_modeofentry = $this->_getParam('other_modeofentry', null);
$userfullname = $this->_getParam('userfullname', null);
$candidatereferredby = $this->_getParam('candidatereferredby', null);
$rccandidatename = $this->_getParam('rccandidatename', null);
$emprole = $this->_getParam('emprole', null);
//roleid_group_id
if ($emprole != "") {
$roleArr = explode('_', $emprole);
if (!empty($roleArr)) {
$emproleStr = $roleArr[0];
}
}
$emailaddress = $this->_getParam('emailaddress', null);
$tmp_name = $this->_request->getParam('tmp_emp_name', null);
$act_inact = $this->_request->getParam("act_inact", null);
//end of user table
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$empstatusarray = array(8, 9, 10);
$actionflag = '';
$tableid = '';
if ($modeofentry == 'Direct' || $hid_modeofentry == 'Direct') {
$candidate_key = 'userfullname';
$candidate_value = $userfullname;
$emp_name = $userfullname;
$candidate_flag = 'no';
} else {
$candidate_key = 'rccandidatename';
$candidate_value = $rccandidatename;
$emp_name = $tmp_name;
$candidate_flag = 'yes';
}
$trDb = Zend_Db_Table::getDefaultAdapter();
// starting transaction
$trDb->beginTransaction();
try {
$emppassword = sapp_Global::generatePassword();
$user_data = array('emprole' => $emproleStr, $candidate_key => $candidate_value, 'emailaddress' => $emailaddress, 'modifiedby' => $loginUserId, 'modifieddate' => Zend_Registry::get('currentdate'), 'emppassword' => md5($emppassword), 'employeeId' => $employeeId, 'modeofentry' => $id == '' ? $modeofentry : "", 'selecteddate' => $date_of_joining, 'candidatereferredby' => $candidatereferredby, 'userstatus' => 'old', 'other_modeofentry' => $other_modeofentry);
if ($id != '') {
$where = array('user_id=?' => $user_id);
$actionflag = 2;
$user_where = "id = " . $user_id;
unset($user_data['candidatereferredby']);
unset($user_data['userstatus']);
unset($user_data['emppassword']);
unset($user_data['employeeId']);
unset($user_data['modeofentry']);
unset($user_data['other_modeofentry']);
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$user_data['createdby'] = $loginUserId;
$user_data['createddate'] = gmdate("Y-m-d H:i:s");
$user_data['isactive'] = 1;
if ($modeofentry != 'Direct') {
$user_data['userfullname'] = $emp_name;
}
$where = '';
$actionflag = 1;
$user_where = '';
}
$user_status = $usersModel->SaveorUpdateUserData($user_data, $user_where);
if ($id == '') {
$user_id = $user_status;
}
$data = array('user_id' => $user_id, 'reporting_manager' => $reporting_manager, 'emp_status_id' => $emp_status_id, 'businessunit_id' => $businessunit_id, 'department_id' => $department_id, 'jobtitle_id' => $jobtitle_id, 'position_id' => $position_id, 'prefix_id' => $prefix_id, 'extension_number' => $extension_number, 'date_of_joining' => $date_of_joining, 'date_of_leaving' => $date_of_leaving != '' ? $date_of_leaving : NULL, 'years_exp' => $years_exp == '' ? null : $years_exp, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$Id = $employeeModal->SaveorUpdateEmployeeData($data, $where);
$statuswhere = array('id=?' => $user_id);
if (in_array($emp_status_id, $empstatusarray)) {
$isactivestatus = '';
if ($emp_status_id == 8) {
$isactivestatus = 2;
} else {
if ($emp_status_id == 9) {
$isactivestatus = 3;
} else {
if ($emp_status_id == 10) {
$isactivestatus = 4;
}
}
}
$statusdata = array('isactive' => $isactivestatus);
$empstatusId = $usersModel->SaveorUpdateUserData($statusdata, $statuswhere);
} else {
$statusdata = array('isactive' => 1);
$empstatusId = $usersModel->SaveorUpdateUserData($statusdata, $statuswhere);
}
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee details updated successfully."));
} else {
//start of mailing
$base_url = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl();
$view = $this->getHelper('ViewRenderer')->view;
$this->view->emp_name = $emp_name;
$this->view->password = $emppassword;
$this->view->emp_id = $employeeId;
$this->view->base_url = $base_url;
$text = $view->render('mailtemplates/newpassword.phtml');
$options['subject'] = APPLICATION_NAME . ' login credentials';
$options['header'] = 'Greetings from Sentrifugo';
$options['toEmail'] = $emailaddress;
$options['toName'] = $this->view->emp_name;
$options['message'] = $text;
$result = sapp_Global::_sendEmail($options);
//end of mailing
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee details added successfully."));
}
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$menuidArr = $menumodel->getMenuObjID('/usermanagement');
$menuID_user = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
if ($act_inact == 1) {
if ($user_data['isactive'] == 1) {
$act_str = array("Activated" => Zend_Registry::get('currentdate'));
} else {
$act_str = array("Inactivated" => Zend_Registry::get('currentdate'));
}
$result = sapp_Global::logManager($menuID_user, 4, $loginUserId, $user_id, '', $act_str);
}
$trDb->commit();
$this->_redirect('employee/edit/id/' . $user_id);
} catch (Exception $e) {
$trDb->rollBack();
$msgarray['employeeId'] = "Something went wrong,please try again later.";
return $msgarray;
}
} else {
$messages = $employeeform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
$usersModel = new Default_Model_Users();
if (isset($businessunit_id) && $businessunit_id != 0 && $businessunit_id != '') {
$departmentsmodel = new Default_Model_Departments();
$departmentlistArr = $departmentsmodel->getDepartmentList($businessunit_id);
$employeeform->department_id->clearMultiOptions();
$employeeform->reporting_manager->clearMultiOptions();
$employeeform->department_id->addMultiOption('', 'Select Department');
foreach ($departmentlistArr as $departmentlistresult) {
$employeeform->department_id->addMultiOption($departmentlistresult['id'], utf8_encode($departmentlistresult['deptname']));
}
if (isset($department_id) && $department_id != 0 && $department_id != '') {
$employeeform->setDefault('department_id', $department_id);
}
}
if (isset($department_id) && $department_id != 0 && $department_id != '') {
$reportingManagerArr = $usersModel->getReportingManagerList($department_id, $user_id);
$employeeform->reporting_manager->addMultiOption('', 'Select Reporting Manager');
foreach ($reportingManagerArr as $reportingManagerresult) {
$employeeform->reporting_manager->addMultiOption($reportingManagerresult['id'], utf8_encode($reportingManagerresult['userfullname']));
}
if (isset($reporting_manager) && $reporting_manager != 0 && $reporting_manager != '') {
$employeeform->setDefault('reporting_manager', $reporting_manager);
}
}
if (isset($jobtitle_id) && $jobtitle_id != 0 && $jobtitle_id != '') {
$positionsmodel = new Default_Model_Positions();
$positionlistArr = $positionsmodel->getPositionList($jobtitle_id);
$employeeform->position_id->clearMultiOptions();
$employeeform->position_id->addMultiOption('', 'Select Position');
foreach ($positionlistArr as $positionlistRes) {
$employeeform->position_id->addMultiOption($positionlistRes['id'], utf8_encode($positionlistRes['positionname']));
}
if (isset($position_id) && $position_id != 0 && $position_id != '') {
$employeeform->setDefault('position_id', $position_id);
}
}
return $msgarray;
}
}
public function comsave($empcommdetailsform, $userid)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$perm_country = $this->_request->getParam('perm_country');
$perm_stateparam = $this->_request->getParam('perm_state');
$perm_stateArr = explode("!@#", $this->_request->getParam('perm_state'));
$perm_state = $perm_stateArr[0];
$perm_cityparam = $this->_request->getParam('perm_city');
$perm_cityArr = explode("!@#", $this->_request->getParam('perm_city'));
$perm_city = $perm_cityArr[0];
$address_flag = $this->_request->getParam('address_flag');
$current_country = $this->_request->getParam('current_country');
$current_stateparam = $this->_request->getParam('current_state');
$current_stateArr = explode("!@#", $this->_request->getParam('current_state'));
$current_state = $current_stateArr[0];
$current_cityparam = $this->_request->getParam('current_city');
$current_cityArr = explode("!@#", $this->_request->getParam('current_city'));
$current_city = $current_cityArr[0];
if ($empcommdetailsform->isValid($this->_request->getPost())) {
$post_values = $this->_request->getPost();
if (isset($post_values['id'])) {
unset($post_values['id']);
}
if (isset($post_values['user_id'])) {
unset($post_values['user_id']);
}
if (isset($post_values['submit'])) {
unset($post_values['submit']);
}
$new_post_values = array_filter($post_values);
if (!empty($new_post_values)) {
$empcommdetailsModal = new Default_Model_Empcommunicationdetails();
$id = $this->_request->getParam('id');
$user_id = $userid;
$personalemail = $this->_request->getParam('personalemail');
$perm_streetaddress = $this->_request->getParam('perm_streetaddress');
$perm_pincode = $this->_request->getParam('perm_pincode');
$current_streetaddress = $this->_request->getParam('current_streetaddress');
$current_pincode = $this->_request->getParam('current_pincode');
$emergency_number = $this->_request->getParam('emergency_number');
$emergency_name = $this->_request->getParam('emergency_name');
$emergency_email = $this->_request->getParam('emergency_email');
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('user_id' => $user_id, 'personalemail' => $personalemail, 'perm_streetaddress' => $perm_streetaddress, 'perm_country' => $perm_country != '' ? $perm_country : NULL, 'perm_state' => $perm_state != '' ? $perm_state : NULL, 'perm_city' => $perm_city != '' ? $perm_city : NULL, 'perm_pincode' => $perm_pincode, 'current_streetaddress' => $current_streetaddress != '' ? $current_streetaddress : NULL, 'current_country' => $current_country != '' ? $current_country : NULL, 'current_state' => $current_state != '' ? $current_state : NULL, 'current_city' => $current_city != '' ? $current_city : NULL, 'current_pincode' => $current_pincode != '' ? $current_pincode : NULL, 'emergency_number' => $emergency_number != '' ? $emergency_number : NULL, 'emergency_name' => $emergency_name != '' ? $emergency_name : NULL, 'emergency_email' => $emergency_email != '' ? $emergency_email : NULL, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('user_id=?' => $user_id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
}
$Id = $empcommdetailsModal->SaveorUpdateEmpcommData($data, $where);
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee contact details updated successfully."));
} else {
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee contact details added successfully."));
}
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => FIELDMSG));
}
$this->_redirect('myemployees/comedit/userid/' . $userid);
} else {
$messages = $empcommdetailsform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
if (isset($perm_country) && $perm_country != 0 && $perm_country != '') {
$statesmodel = new Default_Model_States();
$statesmodeldata = $statesmodel->getStatesList($perm_country);
$empcommdetailsform->perm_state->clearMultiOptions();
$empcommdetailsform->perm_city->clearMultiOptions();
$empcommdetailsform->perm_state->addMultiOption('', 'Select State');
foreach ($statesmodeldata as $res) {
$empcommdetailsform->perm_state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name']));
}
if (isset($perm_stateparam) && $perm_stateparam != 0 && $perm_stateparam != '') {
$empcommdetailsform->setDefault('perm_state', $perm_stateparam);
}
}
if (isset($perm_stateparam) && $perm_stateparam != 0 && $perm_stateparam != '') {
$citiesmodel = new Default_Model_Cities();
$citiesmodeldata = $citiesmodel->getCitiesList($perm_state);
$empcommdetailsform->perm_city->addMultiOption('', 'Select City');
foreach ($citiesmodeldata as $res) {
$empcommdetailsform->perm_city->addMultiOption($res['id'] . '!@#' . utf8_encode($res['city_name']), utf8_encode($res['city_name']));
}
if (isset($perm_cityparam) && $perm_cityparam != 0 && $perm_cityparam != '') {
$empcommdetailsform->setDefault('perm_city', $perm_cityparam);
}
}
if (isset($current_country) && $current_country != 0 && $current_country != '') {
$statesmodel = new Default_Model_States();
$statesmodeldata = $statesmodel->getStatesList($current_country);
$empcommdetailsform->current_state->addMultiOption('', 'Select State');
foreach ($statesmodeldata as $res) {
$empcommdetailsform->current_state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name']));
}
if (isset($current_stateparam) && $current_stateparam != 0 && $current_stateparam != '') {
$empcommdetailsform->setDefault('current_state', $current_stateparam);
}
}
if (isset($current_stateparam) && $current_stateparam != 0 && $current_stateparam != '') {
$citiesmodel = new Default_Model_Cities();
$citiesmodeldata = $citiesmodel->getCitiesList($current_state);
$empcommdetailsform->current_city->addMultiOption('', 'Select City');
foreach ($citiesmodeldata as $res) {
$empcommdetailsform->current_city->addMultiOption($res['id'] . '!@#' . utf8_encode($res['city_name']), utf8_encode($res['city_name']));
}
if (isset($current_cityparam) && $current_cityparam != 0 && $current_cityparam != '') {
$empcommdetailsform->setDefault('current_city', $current_cityparam);
}
}
return $msgarray;
}
}
public function savequestionpopupAction()
{
$ajaxContext = $this->_helper->getHelper('AjaxContext');
$ajaxContext->addActionContext('savequestionpopup', 'json')->initContext();
$this->_helper->layout->disableLayout();
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$appraisalquestionsmodel = new Default_Model_Appraisalquestions();
$result['result'] = '';
$result['id'] = '';
$result['question'] = '';
$result['description'] = '';
try {
$categoryval = $this->_request->getParam('categoryval');
$questionval = urldecode($this->_request->getParam('questionval'));
$description = trim($this->_request->getParam('description'));
$moduleflag = trim($this->_request->getParam('moduleflag'));
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('pa_category_id' => $categoryval, 'question' => $questionval, 'description' => $description != '' ? $description : NULL, 'module_flag' => $moduleflag, 'createdby_role' => $loginuserRole, 'createdby_group' => $loginuserGroup, 'createdby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = '';
$actionflag = 1;
if ($questionval != '' && $categoryval != '' && $moduleflag != '' && preg_match('/^[a-zA-Z0-9.\\- ?\',\\/#@$&*()!]+$/', $questionval)) {
$Id = $appraisalquestionsmodel->SaveorUpdateAppraisalQuestionData($data, $where);
$menuidArr = $menumodel->getMenuObjID('/appraisalquestions');
$menuID = $menuidArr[0]['id'];
$logresult = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$result['msg'] = 'success';
$result['id'] = $Id;
$result['question'] = $questionval;
$result['description'] = $description;
} else {
$result['msg'] = 'error';
$result['id'] = '';
$result['question'] = '';
$result['description'] = '';
}
} catch (Exception $e) {
$result['msg'] = $e->getMessage();
$result['id'] = '';
$result['question'] = '';
$result['description'] = '';
}
$this->_helper->json($result);
}
public function save_helper($is_active, $menu)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$menu_childs = $menumodel->getMenusWithChilds($menu);
$resArrString = implode(",", $menu_childs);
if ($resArrString != '') {
$where = " id in (" . $resArrString . ")";
$where_privi = " object in (" . $resArrString . ")";
$querystring_menu = "UPDATE main_menu SET isactive = " . $is_active . " where {$where} ";
$menumodel->UpdateMenus($querystring_menu);
$querystring_menu = "UPDATE main_privileges SET isactive = " . $is_active . " where {$where_privi} ";
$menumodel->UpdateMenus($querystring_menu);
if (defined('PERFORMANCEAPPRAISAL_M') && $menu == PERFORMANCEAPPRAISAL_M) {
$querystring_menu = "UPDATE main_menu SET isactive = " . $is_active . " where id in (" . MYPERFORMANCEAPPRAISAL . "," . MYTEAMPERFORMANCEAPPRAISAL . ") ";
$menumodel->UpdateMenus($querystring_menu);
$querystring_menu = "UPDATE main_privileges SET isactive = " . $is_active . " where object in (" . MYPERFORMANCEAPPRAISAL . "," . MYTEAMPERFORMANCEAPPRAISAL . ") ";
$menumodel->UpdateMenus($querystring_menu);
}
}
}
public function getMenusWithChilds($menu_id)
{
$menu_model = new Default_Model_Menu();
$res = $menu_model->getTotalMenuArray();
$tmpArr = array();
$tmpMenuArr = array();
$tmpMenuDataArr = array();
for ($i = 0; $i < sizeof($res); $i++) {
$tmpMenuArr[$res[$i]['id']] = $res[$i]['parent'];
$tmp = array();
$tmp['id'] = $res[$i]['id'];
$tmp["parent"] = $res[$i]['parent'];
$tmp["menuName"] = $res[$i]['menuName'];
$tmpMenuDataArr[$res[$i]['id']] = $tmp;
}
$emptyArr = array();
foreach ($tmpMenuArr as $key => $value) {
if ($value == 0 && !array_key_exists($value, $tmpArr)) {
$tmpArr[$key] = $emptyArr;
$tmpArr[$key] = $tmpMenuDataArr[$key];
} else {
if (array_key_exists($value, $tmpArr) && !array_key_exists($key, $tmpArr[$value])) {
$tmpArr[$value]['childs'][$key] = $tmpMenuDataArr[$key];
}
}
}
foreach ($tmpArr as $key => $value_arr) {
if (is_array($value_arr)) {
if (isset($value_arr['childs']) && is_array($value_arr['childs'])) {
foreach ($value_arr['childs'] as $c_key => $ch_value) {
foreach ($tmpMenuArr as $tkey => $tvalue) {
if ($tvalue == $c_key && !array_key_exists($tkey, $tmpArr)) {
$tmpArr[$key]['childs'][$c_key]['childs'][$tkey] = $tmpMenuDataArr[$tkey];
}
}
}
}
}
}
$childs_array = array();
if (array_key_exists($menu_id, $tmpArr)) {
$childs_array[] = $menu_id;
if (isset($tmpArr[$menu_id]['childs'])) {
foreach ($tmpArr[$menu_id]['childs'] as $chkey1 => $chvalue1) {
$childs_array[] = $chkey1;
if (isset($chvalue1['childs'])) {
foreach ($chvalue1['childs'] as $chkey2 => $chvalue2) {
$childs_array[] = $chkey2;
}
}
}
}
} else {
foreach ($tmpArr as $menuid => $menu_data) {
if (isset($tmpArr[$menuid]['childs'])) {
foreach ($tmpArr[$menuid]['childs'] as $chkey1 => $chvalue1) {
if ($chkey1 == $menu_id) {
$childs_array[] = $chkey1;
if (isset($chvalue1['childs'])) {
foreach ($chvalue1['childs'] as $chkey2 => $chvalue2) {
$childs_array[] = $chkey2;
}
}
}
}
}
}
}
return $childs_array;
}
