public function getpositionsAction()
{
$ajaxContext = $this->_helper->getHelper('AjaxContext');
$ajaxContext->addActionContext('getpositions', 'html')->initContext();
$jobtitle_id = $this->_request->getParam('jobtitle_id');
$con = $this->_request->getParam('con');
$employeeform = new Default_Form_employee();
$positionsmodel = new Default_Model_Positions();
$flag = '';
$positionlistArr = $positionsmodel->getPositionList($jobtitle_id);
if (empty($positionlistArr)) {
$flag = 'true';
}
$this->view->positionlistArr = $positionlistArr;
$this->view->employeeform = $employeeform;
$this->view->flag = $flag;
if ($con != '') {
$this->view->con = $con;
}
}
public function editAction()
{
$auth = Zend_Auth::getInstance();
$role_datap = array();
$empGroup = "";
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
$loginuserUnitID = $auth->getStorage()->read()->businessunit_id;
$loginuserDeptID = $auth->getStorage()->read()->department_id;
}
$id = (int) $this->getRequest()->getParam('id');
$id = abs($id);
if ($id == '') {
$id = $loginUserId;
}
$callval = $this->getRequest()->getParam('call');
if ($callval == 'ajaxcall') {
$this->_helper->layout->disableLayout();
}
$employeeform = new Default_Form_Myteamemployee();
try {
if ($id != '' && is_numeric($id) && $id > 0 && $id != $loginUserId) {
$employeeModal = new Default_Model_Employee();
$usersModel = new Default_Model_Users();
$employmentstatusModel = new Default_Model_Employmentstatus();
$busineesUnitModel = new Default_Model_Businessunits();
$deptModel = new Default_Model_Departments();
$role_model = new Default_Model_Roles();
$user_model = new Default_Model_Usermanagement();
$candidate_model = new Default_Model_Candidatedetails();
$jobtitlesModel = new Default_Model_Jobtitles();
$positionsmodel = new Default_Model_Positions();
$prefixModel = new Default_Model_Prefix();
$data = array();
$empDeptId = "";
$empRoleId = "";
$data = $employeeModal->getsingleEmployeeData($id);
if ($data == 'norows') {
$this->view->rowexist = "norows";
} else {
if (!empty($data)) {
$this->view->rowexist = "rows";
$employeeform->submit->setLabel('Update');
$data = $data[0];
/* Earlier code to fetch employee details */
$employeeData = $employeeModal->getsingleEmployeeData($id);
$roles_arr = $role_model->getRolesListByGroupID(EMPLOYEE_GROUP);
if (sizeof($roles_arr) > 0) {
$employeeform->emprole->addMultiOptions(array('' => 'Select Role') + $roles_arr);
}
$employmentStatusData = $employmentstatusModel->getempstatuslist();
if (sizeof($employmentStatusData) > 0) {
$employeeform->emp_status_id->addMultiOption('', 'Select Employment Status');
foreach ($employmentStatusData as $employmentStatusres) {
$employeeform->emp_status_id->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']);
}
}
$businessunitData = $busineesUnitModel->getDeparmentList();
if (sizeof($businessunitData) > 0) {
foreach ($businessunitData as $businessunitres) {
if ($businessunitres['id'] == $loginuserUnitID) {
$employeeform->businessunit_id->addMultiOption($businessunitres['id'], $businessunitres['unitname']);
}
}
}
$departmentsData = $deptModel->getDepartmentList($data['businessunit_id']);
if (sizeof($departmentsData) > 0) {
foreach ($departmentsData as $departmentsres) {
if ($departmentsres['id'] == $loginuserDeptID) {
$employeeform->department_id->addMultiOption($departmentsres['id'], $departmentsres['deptname']);
}
}
}
$jobtitleData = $jobtitlesModel->getJobTitleList();
if (sizeof($jobtitleData) > 0) {
$employeeform->jobtitle_id->addMultiOption('', 'Select Job Title');
foreach ($jobtitleData as $jobtitleres) {
$employeeform->jobtitle_id->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']);
}
}
$positionlistArr = $positionsmodel->getPositionList($data['jobtitle_id']);
if (sizeof($positionlistArr) > 0) {
$employeeform->position_id->addMultiOption('', 'Select Position');
foreach ($positionlistArr as $positionlistres) {
$employeeform->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']);
}
}
$prefixData = $prefixModel->getPrefixList();
if (!empty($prefixData)) {
foreach ($prefixData as $prefixres) {
$employeeform->prefix_id->addMultiOption($prefixres['id'], $prefixres['prefix']);
}
}
$userData = $usersModel->getUserDetails($loginUserId);
if (count($userData) > 0) {
$employeeform->reporting_manager->addMultiOption($userData[0]['id'], $userData[0]['userfullname']);
}
$employeeform->populate($data);
$employeeform->setDefault('user_id', $data['user_id']);
$employeeform->setDefault('emp_status_id', $data['emp_status_id']);
$employeeform->setDefault('businessunit_id', $data['businessunit_id']);
$employeeform->setDefault('jobtitle_id', $data['jobtitle_id']);
$employeeform->setDefault('department_id', $data['department_id']);
$employeeform->setDefault('position_id', $data['position_id']);
$employeeform->setDefault('prefix_id', $data['prefix_id']);
$date_of_joining = sapp_Global::change_date($data['date_of_joining'], 'view');
$employeeform->date_of_joining->setValue($date_of_joining);
if ($data['date_of_leaving'] != '' && $data['date_of_leaving'] != '0000-00-00') {
$date_of_leaving = sapp_Global::change_date($data['date_of_leaving'], 'view');
$employeeform->date_of_leaving->setValue($date_of_leaving);
}
$role_data = $role_model->getRoleDataById($data['emprole']);
$employeeform->emprole->setValue($data['emprole'] . "_" . $role_data['group_id']);
$employeeform->setAttrib('action', DOMAIN . 'myemployees/edit/id/' . $id);
$this->view->id = $id;
$this->view->form = $employeeform;
$this->view->employeedata = !empty($employeeData) ? $employeeData[0] : "";
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$this->view->data = $data;
}
}
} else {
$this->view->rowexist = "norows";
}
if ($this->getRequest()->getPost()) {
$result = $this->save($employeeform);
$this->view->msgarray = $result;
$employeeform->modeofentry->setValue($data['modeofentry']);
}
} catch (Exception $e) {
$this->view->rowexist = "norows";
}
}
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 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);
}
public function addemppopupAction()
{
$flag = 'true';
$controllername = 'employee';
$msgarray = array();
$emptyFlag = 0;
Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/");
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$deptidforhead = $this->_getParam('deptidforhead', null);
$report_opt = array();
$emp_form = new Default_Form_employee();
$user_model = new Default_Model_Usermanagement();
$role_model = new Default_Model_Roles();
$prefixModel = new Default_Model_Prefix();
$identity_code_model = new Default_Model_Identitycodes();
$jobtitlesModel = new Default_Model_Jobtitles();
$deptModel = new Default_Model_Departments();
$positionsmodel = new Default_Model_Positions();
$employeeModal = new Default_Model_Employee();
$usersModel2 = new Default_Model_Users();
$employmentstatusModel = new Default_Model_Employmentstatus();
$emp_form->setAction(BASE_URL . 'employee/addemppopup/deptidforhead/' . $deptidforhead);
$emp_form->removeElement('department_id');
$emp_form->removeElement('modeofentry');
$identity_codes = $identity_code_model->getIdentitycodesRecord();
$emp_identity_code = isset($identity_codes[0]) ? $identity_codes[0]['employee_code'] : "";
if ($emp_identity_code != '') {
$emp_id = $emp_identity_code . str_pad($user_model->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT);
} else {
$emp_id = '';
$msgarray['employeeId'] = 'Identity codes are not configured yet.';
$flag = 'false';
}
$emp_form->employeeId->setValue($emp_id);
$role_data = $role_model->getRolesList_Dept();
$emp_form->emprole->addMultiOptions(array('' => 'Select Role') + $role_data);
if (empty($role_data)) {
$msgarray['emprole'] = 'Roles are not configured yet.';
$flag = 'false';
}
$prefixData = $prefixModel->getPrefixList();
$emp_form->prefix_id->addMultiOption('', 'Select Prefix');
if (!empty($prefixData)) {
foreach ($prefixData as $prefixres) {
$emp_form->prefix_id->addMultiOption($prefixres['id'], $prefixres['prefix']);
}
} else {
$msgarray['prefix_id'] = 'Prefixes are not configured yet.';
//$flag = 'false';
}
$jobtitleData = $jobtitlesModel->getJobTitleList();
if (!empty($jobtitleData)) {
foreach ($jobtitleData as $jobtitleres) {
$emp_form->jobtitle_id->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']);
}
} else {
$msgarray['jobtitle_id'] = 'Job titles are not configured yet.';
$msgarray['position_id'] = 'Positions are not configured yet.';
//$flag = 'false';
}
if (isset($_POST['jobtitle_id']) && $_POST['jobtitle_id'] != '') {
$positionlistArr = $positionsmodel->getPositionList($_POST['jobtitle_id']);
if (sizeof($positionlistArr) > 0) {
$emp_form->position_id->addMultiOption('', 'Select Position');
foreach ($positionlistArr as $positionlistres) {
$emp_form->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']);
}
}
}
$employmentStatusData = $employmentstatusModel->getempstatusActivelist();
$emp_form->emp_status_id->addMultiOption('', 'Select Employment Status');
if (!empty($employmentStatusData)) {
foreach ($employmentStatusData as $employmentStatusres) {
$emp_form->emp_status_id->addMultiOption($employmentStatusres['workcodename'], $employmentStatusres['statusname']);
}
} else {
$msgarray['emp_status_id'] = 'Employment status is not configured yet.';
$emptyFlag++;
}
$reportingManagerData = $usersModel2->getReportingManagerList_employees('', '', MANAGEMENT_GROUP);
if (!empty($reportingManagerData)) {
$report_opt = $reportingManagerData;
if (isset($_POST['reporting_manager']) && $_POST['reporting_manager'] != '') {
$emp_form->setDefault('reporting_manager', $_POST['reporting_manager']);
}
} else {
$msgarray['reporting_manager'] = 'Reporting managers are not added yet.';
$flag = 'false';
}
if ($this->getRequest()->getPost()) {
if ($emp_form->isValid($this->_request->getPost()) && $flag == 'true') {
$jobtitle_id = $this->_request->getParam('jobtitle_id', null);
$position_id = $this->_request->getParam('position_id', null);
$date_of_joining = sapp_Global::change_date($this->_request->getParam('date_of_joining', null), 'database');
$date_of_leaving = $this->_request->getParam('date_of_leaving', null);
$date_of_leaving = sapp_Global::change_date($date_of_leaving, 'database');
$employeeId = $this->_getParam('employeeId', null);
$emprole = $this->_getParam('emprole', null);
$reporting_manager = $this->_getParam('reporting_manager', null);
$emailaddress = $this->_getParam('emailaddress', null);
$emppassword = sapp_Global::generatePassword();
$firstname = trim($this->_getParam('firstname', null));
$lastname = trim($this->_getParam('lastname', null));
$userfullname = $firstname . ' ' . $lastname;
//$userfullname = trim($this->_request->getParam('userfullname',null));
$prefix_id = $this->_getParam('prefix_id', null);
$user_id = $this->_getParam('user_id', null);
$emp_status_id = $this->_getParam('emp_status_id', null);
$user_data = array('emprole' => $emprole, 'firstname' => $firstname != '' ? $firstname : NULL, 'lastname' => $lastname != '' ? $lastname : NULL, 'userfullname' => $userfullname, 'emailaddress' => $emailaddress, 'jobtitle_id' => $jobtitle_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'emppassword' => md5($emppassword), 'employeeId' => $employeeId, 'modeofentry' => 'Direct', 'selecteddate' => $date_of_joining, 'userstatus' => 'old');
$emp_data = array('user_id' => $user_id, 'jobtitle_id' => $jobtitle_id, 'position_id' => $position_id, 'prefix_id' => $prefix_id, 'department_id' => $deptidforhead, 'reporting_manager' => $reporting_manager, 'date_of_joining' => $date_of_joining, 'date_of_leaving' => $date_of_leaving != '' ? $date_of_leaving : NULL, 'emp_status_id' => $emp_status_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$user_data['createdby'] = $loginUserId;
$user_data['createddate'] = gmdate("Y-m-d H:i:s");
$user_data['isactive'] = 1;
if ($emp_identity_code != '') {
$emp_id = $emp_identity_code . str_pad($user_model->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT);
} else {
$emp_id = '';
}
$user_data['employeeId'] = $emp_id;
$user_id = $user_model->SaveorUpdateUserData($user_data, '');
$emp_data['user_id'] = $user_id;
$emp_data['createdby'] = $loginUserId;
$emp_data['createddate'] = gmdate("Y-m-d H:i:s");
$emp_data['isactive'] = 1;
$employeeModal->SaveorUpdateEmployeeData($emp_data, '');
//end of saving into employee table.
$tableid = $user_id;
$actionflag = 1;
$menuID = ORGANISATIONINFO;
try {
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
} catch (Exception $e) {
}
$managementUsersData = $deptModel->getDeptHeads();
$opt = '';
foreach ($managementUsersData as $record) {
$opt .= sapp_Global::selectOptionBuilder($record['id'], $record['userfullname']);
}
$this->view->managementUsersData = $opt;
/* Send Mail to the user */
$base_url = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl();
$view = $this->getHelper('ViewRenderer')->view;
$this->view->emp_name = $userfullname;
$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 */
$this->view->eventact = 'added';
$close = 'close';
$this->view->popup = $close;
} else {
$messages = $emp_form->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
$this->view->msgarray = $msgarray;
}
}
$this->view->msgarray = $msgarray;
$this->view->report_opt = $report_opt;
$this->view->controllername = $controllername;
$this->view->emp_form = $emp_form;
}
/**
* This function is used for ajax call to get positions based on
* business unit id and department id.
* @parameters
* @param {Integer} bunitid = id of business unit.
*
* @return Array of departments in json format.
*/
public function getpositionsAction()
{
$bunit_id = $this->_getParam('bunitid', null);
$dept_id = $this->_getParam('dept_id', null);
$job_id = $this->_getParam('job_id', null);
$position_model = new Default_Model_Positions();
$options_data = "";
$options_data .= sapp_Global::selectOptionBuilder('', 'Select Position');
if ($job_id != '') {
$dept_data = $position_model->getPositionOptions($bunit_id, $dept_id, $job_id);
foreach ($dept_data as $dept) {
$options_data .= sapp_Global::selectOptionBuilder($dept['id'], $dept['positionname']);
}
}
$this->_helper->json(array('options' => $options_data));
}
public function editpopupAction()
{
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');
$userid = $this->getRequest()->getParam('unitId');
if ($id == '') {
$id = $loginUserId;
}
// For open the form in popup...
$empjobhistoryform = new Default_Form_empjobhistory();
$empjobhistoryModel = new Default_Model_Empjobhistory();
$employeeModel = new Default_Model_Employee();
$positionModel = new Default_Model_Positions();
$departmentModel = new Default_Model_Departments();
$jobtitleModel = new Default_Model_Jobtitles();
$clientsModel = new Timemanagement_Model_Clients();
if ($id) {
$employeeArr = $employeeModel->getActiveEmployeeData($userid);
if (!empty($employeeArr)) {
if (isset($employeeArr[0]['businessunit_id']) && $employeeArr[0]['businessunit_id'] != '') {
$departmentArr = $departmentModel->getDepartmentList($employeeArr[0]['businessunit_id']);
if (!empty($departmentArr)) {
$empjobhistoryform->department->addMultiOption('', 'Select Department');
foreach ($departmentArr as $departmentres) {
$empjobhistoryform->department->addMultiOption($departmentres['id'], $departmentres['deptname']);
}
}
} else {
$departmentArr = $departmentModel->getTotalDepartmentList();
if (!empty($departmentArr)) {
$empjobhistoryform->department->addMultiOption('', 'Select Department');
foreach ($departmentArr as $departmentres) {
$empjobhistoryform->department->addMultiOption($departmentres['id'], $departmentres['deptname']);
}
}
}
}
$positionArr = $positionModel->getTotalPositionList();
if (!empty($positionArr)) {
$empjobhistoryform->positionheld->addMultiOption('', 'Select Position');
foreach ($positionArr as $positionres) {
$empjobhistoryform->positionheld->addMultiOption($positionres['id'], $positionres['positionname']);
}
}
$jobtitleArr = $jobtitleModel->getJobTitleList();
if (!empty($jobtitleArr)) {
$empjobhistoryform->jobtitleid->addMultiOption('', 'Select Job Title');
foreach ($jobtitleArr as $jobtitleres) {
$empjobhistoryform->jobtitleid->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']);
}
}
$clientsArr = $clientsModel->getActiveClientsData();
if (!empty($clientsArr)) {
$empjobhistoryform->client->addMultiOption('', 'Select a Client');
foreach ($clientsArr as $clientsres) {
$empjobhistoryform->client->addMultiOption($clientsres['id'], $clientsres['client_name']);
}
}
$data = $empjobhistoryModel->getsingleEmpJobHistoryData($id);
if (!empty($data)) {
$empjobhistoryform->populate($data[0]);
$empjobhistoryform->setDefault('department', $data[0]['department']);
$empjobhistoryform->setDefault('positionheld', $data[0]['positionheld']);
$empjobhistoryform->setDefault('jobtitleid', $data[0]['jobtitleid']);
$empjobhistoryform->setDefault('client', $data[0]['client_id']);
if (isset($data[0]['start_date']) && $data[0]['start_date'] != '') {
$start_date = sapp_Global::change_date($data[0]['start_date'], 'view');
$empjobhistoryform->start_date->setValue($start_date);
}
if (isset($data[0]['end_date']) && $data[0]['end_date'] != '') {
$end_date = sapp_Global::change_date($data[0]['end_date'], 'view');
$empjobhistoryform->end_date->setValue($end_date);
}
}
}
$empjobhistoryform->setAttrib('action', BASE_URL . 'empjobhistory/editpopup/unitId/' . $userid);
$this->view->form = $empjobhistoryform;
$this->view->controllername = 'empjobhistory';
if ($this->getRequest()->getPost()) {
$result = $this->save($empjobhistoryform, $userid);
$this->view->msgarray = $result;
}
}
public function addorgheadAction()
{
Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/");
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$org_id = $this->_request->getParam('orgid', null);
$msgarray = array();
$prevorgheadId = '';
$posted_prevorghead_rm = '';
try {
$user_model = new Default_Model_Usermanagement();
$orgInfoModel = new Default_Model_Organisationinfo();
$countriesModel = new Default_Model_Countries();
$statesmodel = new Default_Model_States();
$citiesmodel = new Default_Model_Cities();
$role_model = new Default_Model_Roles();
$prefixModel = new Default_Model_Prefix();
$identity_code_model = new Default_Model_Identitycodes();
$jobtitlesModel = new Default_Model_Jobtitles();
$employeeModal = new Default_Model_Employee();
$positionsmodel = new Default_Model_Positions();
$form = new Default_Form_Organisationhead();
$form->setAttrib('action', BASE_URL . 'organisationinfo/addorghead/orgid/' . $org_id);
$identity_codes = $identity_code_model->getIdentitycodesRecord();
$role_data = $role_model->getRolesList_orginfo();
$flag = 'true';
$emp_identity_code = isset($identity_codes[0]) ? $identity_codes[0]['employee_code'] : "";
if ($emp_identity_code != '') {
$emp_id = $emp_identity_code . str_pad($user_model->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT);
} else {
$emp_id = '';
$msgarray['employeeId'] = 'Identity codes are not configured yet.';
$flag = 'false';
}
$form->employeeId->setValue($emp_id);
$form->emprole->addMultiOptions(array('' => 'Select Role') + $role_data);
if (empty($role_data)) {
$msgarray['emprole'] = 'Roles are not added yet.';
$flag = 'false';
}
$prefixData = $prefixModel->getPrefixList();
$form->prefix_id->addMultiOption('', 'Select Prefix');
if (!empty($prefixData)) {
foreach ($prefixData as $prefixres) {
$form->prefix_id->addMultiOption($prefixres['id'], $prefixres['prefix']);
}
} else {
$msgarray['prefix_id'] = 'Prefixes are not configured yet.';
}
$jobtitleData = $jobtitlesModel->getJobTitleList();
if (!empty($jobtitleData)) {
foreach ($jobtitleData as $jobtitleres) {
$form->jobtitle_id->addMultiOption($jobtitleres['id'], $jobtitleres['jobtitlename']);
}
} else {
$msgarray['jobtitle_id'] = 'Job titles are not configured yet.';
$msgarray['position_id'] = 'Positions are not configured yet.';
}
$form->position_id->addMultiOption('', 'Select a Position');
if (isset($_POST['jobtitle_id']) && $_POST['jobtitle_id'] != '') {
$jobtitle_id = $_POST['jobtitle_id'];
$positionlistArr = $positionsmodel->getPositionList($jobtitle_id);
if (sizeof($positionlistArr) > 0) {
foreach ($positionlistArr as $positionlistres) {
$form->position_id->addMultiOption($positionlistres['id'], $positionlistres['positionname']);
}
}
}
if (isset($_POST['prevorghead_rm']) && $_POST['prevorghead_rm'] != '') {
$posted_prevorghead_rm = $_POST['prevorghead_rm'];
}
$orgheadsData = $employeeModal->getEmployeesForOrgHead();
$emp_data = $employeeModal->fetchRow("is_orghead = 1");
if (!empty($emp_data)) {
$user_data = $user_model->fetchRow("id = " . $emp_data->user_id);
if (!empty($user_data)) {
$prevorgheadId = $user_data->id;
} else {
$form->removeElement('prevorghead_rm');
}
} else {
$form->removeElement('prevorghead_rm');
}
if ($this->getRequest()->getPost()) {
if ($form->isValid($this->_request->getPost()) && $flag != 'false') {
$jobtitle_id = $this->_request->getParam('jobtitle_id', null);
$position_id = $this->_request->getParam('position_id', null);
$date_of_joining = sapp_Global::change_date($this->_request->getParam('date_of_joining_head', null), 'database');
$employeeId = $this->_request->getParam('employeeId', null);
$emprole = $this->_request->getParam('emprole', null);
$emailaddress = $this->_request->getParam('emailaddress', null);
$emppassword = sapp_Global::generatePassword();
$first_name = trim($this->_request->getParam('firstname_orghead', null));
$last_name = trim($this->_request->getParam('lastname_orghead', null));
//$userfullname = trim($this->_request->getParam('orghead',null));
$userfullname = $first_name . ' ' . $last_name;
$prefix_id = $this->_request->getParam('prefix_id', null);
$user_id = $this->_request->getParam('user_id', null);
$prevorghead_rm = $this->_request->getParam('prevorghead_rm', null);
$prevheadid = $this->_request->getParam('prevheadid', null);
$user_data = array('emprole' => $emprole, 'firstname' => $first_name, 'lastname' => $last_name, 'userfullname' => $userfullname, 'emailaddress' => $emailaddress, 'jobtitle_id' => $jobtitle_id, 'emppassword' => md5($emppassword), 'employeeId' => $employeeId, 'selecteddate' => $date_of_joining, 'userstatus' => 'old', 'modeofentry' => 'Direct', 'createdby' => $loginUserId, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'isactive' => 1);
$emp_data = array('jobtitle_id' => $jobtitle_id, 'position_id' => $position_id, 'prefix_id' => $prefix_id, 'reporting_manager' => 0, 'date_of_joining' => $date_of_joining, 'createdby' => $loginUserId, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'isactive' => 1, 'is_orghead' => 1);
$org_data = array('modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($emp_identity_code != '') {
$emp_id = $emp_identity_code . str_pad($user_model->getMaxEmpId($emp_identity_code), 4, '0', STR_PAD_LEFT);
} else {
$emp_id = '';
}
$user_data['employeeId'] = $emp_id;
$db = Zend_Db_Table::getDefaultAdapter();
$db->beginTransaction();
try {
$user_id = $user_model->SaveorUpdateUserData($user_data, '');
$emp_data['user_id'] = $user_id;
$employeeModal->SaveorUpdateEmployeeData($emp_data, '');
if (isset($prevheadid) && $prevheadid != '') {
$org_data['orghead'] = $user_id;
$orgwhere = array('id=?' => $org_id);
$orgInfoModel->SaveorUpdateData($org_data, $orgwhere);
$orgInfoModel->changeOrgHead($prevheadid, $user_id, $prevorghead_rm);
$this->sendmailstoemployees($prevheadid, $user_id);
}
$tableid = $user_id;
$actionflag = 1;
$menuID = EMPLOYEE;
try {
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
} catch (Exception $e) {
echo $e->getMessage();
}
$close = 'close';
$this->view->popup = $close;
$this->view->eventact = 'added';
$db->commit();
} catch (Exception $e) {
$db->rollBack();
}
} else {
$messages = $form->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
}
}
$this->view->prevorgheadId = $prevorgheadId;
$this->view->form = $form;
$this->view->msgarray = $msgarray;
$this->view->orgheadsData = $orgheadsData;
$this->view->posted_prevorghead_rm = $posted_prevorghead_rm;
} catch (Exception $e) {
echo $e->getMessage();
die;
}
}
/**
* This function acts as a service for onchange of job title to get positions.
* @param array $params_arr = array of parameters
* @return array Array of positions options.
*/
public function jobtitleOnchange($params_arr)
{
$result = array();
$status = 0;
$message = "Invalid job title.";
if (isset($params_arr['role_id']) && $params_arr['role_id'] != '' && isset($params_arr['group_id']) && $params_arr['group_id'] != '' && isset($params_arr['jobtitle_id']) && $params_arr['jobtitle_id'] != '' && isset($params_arr['userid']) && $params_arr['userid'] != '') {
$role_id = $params_arr['role_id'];
$group_id = $params_arr['group_id'];
$userid = $params_arr['userid'];
$jobtitle_id = $params_arr['jobtitle_id'];
if ($role_id == SUPERADMINROLE || $group_id == MANAGEMENT_GROUP || $group_id == HR_GROUP) {
$privilege_flag = sapp_Global::_checkprivileges(EMPLOYEE, $group_id, $role_id, 'add');
if ($privilege_flag == 'Yes') {
$status = 1;
$message = "success";
$positionsmodel = new Default_Model_Positions();
$positionlistArr = $positionsmodel->getPositionList($jobtitle_id);
$positions_str = sapp_Global::selectOptionBuilder("", "Select Position");
//echo "<pre>";print_r($positionlistArr);echo "</pre>";
if (!empty($positionlistArr)) {
foreach ($positionlistArr as $data) {
$positions_str .= sapp_Global::selectOptionBuilder($data['id'], $data['positionname']);
}
$result['positions'] = $positions_str;
} else {
$status = 0;
$message = "Positions are not configured yet.";
}
}
}
}
return array('status' => $status, 'message' => $message, 'result' => $result);
}
