public function updatebgstatus($con, $specimenid, $flag) { $db = Zend_Db_Table::getDefaultAdapter(); $screeningmodel = new Default_Model_Empscreening(); $usermodel = new Default_Model_Users(); $candmodel = new Default_Model_Candidatedetails(); if ($con == 'onhold') { $userdata = array('backgroundchk_status' => 'On hold', 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $this->getLoginUserId()); $userwhere = "id=" . $specimenid; if ($flag == 1) { $usermodel->addOrUpdateUserModel($userdata, $userwhere); } else { $candmodel->SaveorUpdateCandidateData($userdata, $userwhere); } $data = array('bgcheck_status' => 'On hold', 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $this->getLoginUserId()); $where = "flag = " . $flag . " AND specimen_id=" . $specimenid; $screeningmodel->SaveorUpdateDetails($data, $where); } if ($con == 'complete') { $userdata = array('backgroundchk_status' => 'Completed', 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $this->getLoginUserId()); $userwhere = "id=" . $specimenid; if ($flag == 1) { $usermodel->addOrUpdateUserModel($userdata, $userwhere); } else { $candmodel->SaveorUpdateCandidateData($userdata, $userwhere); } $data = array('bgcheck_status' => 'Complete', 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $this->getLoginUserId()); $where = "flag = " . $flag . " AND specimen_id=" . $specimenid; $screeningmodel->SaveorUpdateDetails($data, $where); } }
public function updatethemeAction() { $this->_helper->layout->disableLayout(); if ($this->getRequest()->isPost()) { $theme_name = $this->getRequest()->getParam('theme_name'); $usersModel = new Default_Model_Users(); $user_id = sapp_Global::_readSession('id'); $where = array('id = ?' => $user_id); $data = array('themes' => $theme_name, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s")); $usersModel->addOrUpdateUserModel($data, $where); sapp_Global::_writeSession('themes', $theme_name); $this->_helper->json(array('result' => 'success')); } }
/** * @name save * * This function is used to save the data that comes from add and edit actions. * @author Asma * @version 1.0 */ public function save($agencylistform) { $baseUrl = BASE_URL; $baseUrl = rtrim($baseUrl, '/'); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $id = $this->_request->getParam('id'); $agencyEmail = ''; $agencyContactNum = ''; $agencyuserid = ''; $agencylistmodel = new Default_Model_Agencylist(); $pocModel = new Default_Model_Bgpocdetails(); $usersModel = new Default_Model_Users(); $statesmodel = new Default_Model_States(); $citiesmodel = new Default_Model_Cities(); $pocData_1 = array(); $pocData_2 = array(); $pocData_3 = array(); $contact_type_1 = $this->_request->getParam('contact_type_1'); $contact_type_2 = $this->_request->getParam('contact_type_2'); $contact_type_3 = $this->_request->getParam('contact_type_3'); $checktypeModal = new Default_Model_Bgscreeningtype(); $errorflag = "true"; $primaryphone = $this->_request->getParam('primaryphone'); $secondaryphone = $this->_request->getParam('secondaryphone'); if ($primaryphone == $secondaryphone && $secondaryphone != '' && $primaryphone != '') { $msgarray['secondaryphone'] = 'Primary and secondary phone numbers must not be same.'; $errorflag = 'false'; } if ($agencylistform->isValid($this->_request->getPost())) { if ($contact_type_1 == 1 || $contact_type_2 == 1 || $contact_type_3 == 1) { if ($contact_type_1 == 1 && $contact_type_2 == 1 || $contact_type_1 == 1 && $contact_type_3 == 1 || $contact_type_2 == 1 && $contact_type_3 == 1 || $contact_type_1 == 1 && $contact_type_2 == 1 && $contact_type_3 == 1) { $msgarray['contacttype'] = "Please set one contact type as primary."; $errorflag = "false"; } } else { $msgarray['contacttype'] = "Please set one contact type as primary."; $errorflag = "false"; } } /* Check for duplicate entry of mobile and email*/ $pocid_1 = $this->_request->getParam('pocid_1'); $mobile_1 = $this->_request->getParam('mobile_1'); $email_1 = $this->_request->getParam('email_1'); if ($mobile_1 != '' && $email_1 != '') { $exists_M1 = $pocModel->checkMobileDuplicates($pocid_1, $mobile_1); if ($exists_M1) { $msgarray['mobile_1'] = "Mobile number already exists."; $errorflag = "false"; } $exists_E1 = $pocModel->checkEmailDuplicates($pocid_1, $email_1); if ($exists_E1) { $msgarray['email_1'] = "Email already exists."; $errorflag = "false"; } } $pocid_2 = $this->_request->getParam('pocid_2'); $mobile_2 = $this->_request->getParam('mobile_2'); $email_2 = $this->_request->getParam('email_2'); if ($mobile_2 != '' && $email_2 != '') { $exists_M2 = $pocModel->checkMobileDuplicates($pocid_2, $mobile_2); if ($exists_M2) { $msgarray['mobile_2'] = "Mobile number already exists."; $errorflag = "false"; } $exists_E2 = $pocModel->checkEmailDuplicates($pocid_2, $email_2); if ($exists_E2) { $msgarray['email_2'] = "Email already exists."; $errorflag = "false"; } } $pocid_3 = $this->_request->getParam('pocid_3'); $mobile_3 = $this->_request->getParam('mobile_3'); $email_3 = $this->_request->getParam('email_3'); if ($mobile_3 != '' && $email_3 != '') { $exists_M3 = $pocModel->checkMobileDuplicates($pocid_3, $mobile_3); if ($exists_M3) { $msgarray['mobile_3'] = "Mobile number already exists."; $errorflag = "false"; } $exists_E3 = $pocModel->checkEmailDuplicates($pocid_3, $email_3); if ($exists_E3) { $msgarray['email_3'] = "Email already exists."; $errorflag = "false"; } } $contact_type_1 = $this->_request->getParam('contact_type_1'); $contact_type_2 = $this->_request->getParam('contact_type_2'); $contact_type_3 = $this->_request->getParam('contact_type_3'); if ($contact_type_1 == 1) { $agid = $id; $agencyEmail = $email_1; $agencyContactNum = $mobile_1; $pocuseremail = $pocModel->checkEmailInUsers($email_1, $agid); if (!empty($pocuseremail)) { $msgarray['email_1'] = "Email already exists."; $errorflag = "false"; } } else { if ($contact_type_2 == 1) { $agencyEmail = $email_2; $agencyContactNum = $mobile_2; $pocuseremail = $pocModel->checkEmailInUsers($email_2, $agid); if (!empty($pocuseremail)) { $msgarray['email_2'] = "Email already exists."; $errorflag = "false"; } } else { if ($contact_type_3 == 1) { $agencyEmail = $email_3; $agencyContactNum = $mobile_3; $pocuseremail = $pocModel->checkEmailInUsers($email_3, $agid); if (!empty($pocuseremail)) { $msgarray['email_3'] = "Email already exists."; $errorflag = "false"; } } } } if ($mobile_1 != '' && ($mobile_2 != '' || $mobile_3 != '')) { if ($mobile_2 != '' && $mobile_1 == $mobile_2) { $msgarray['mobile_2'] = "Contact 1 and contact 2 mobile numbers cannot be same."; $errorflag = "false"; } if ($mobile_3 != '' && $mobile_1 == $mobile_3) { $msgarray['mobile_3'] = "Contact 1 and contact 3 mobile numbers cannot be same."; $errorflag = "false"; } if ($mobile_3 != '' && $mobile_2 != '' && $mobile_2 == $mobile_3) { $msgarray['mobile_3'] = "Contact 2 and contact 3 mobile numbers cannot be same."; $errorflag = "false"; } } if ($email_1 != '' && ($email_2 != '' || $email_3 != '')) { if ($email_2 != '' && $email_1 == $email_2) { $msgarray['email_2'] = "Contact 1 and contact 2 emails cannot be same."; $errorflag = "false"; } if ($email_3 != '' && $email_1 == $email_3) { $msgarray['email_3'] = "Contact 1 and contact 3 emails cannot be same."; $errorflag = "false"; } if ($email_3 != '' && $email_2 != '' && $email_2 == $email_3) { $msgarray['email_3'] = "Contact 2 and contact 3 emails cannot be same."; $errorflag = "false"; } } /* Duplicate check END */ $country_1 = $this->_request->getParam('country_1'); $state_1 = intVal($this->_request->getParam('state_1')); $city_1 = intVal($this->_request->getParam('city_1')); if (isset($country_1) && $country_1 != 0 && $country_1 != '') { $statesData = $statesmodel->getStatesList($country_1); foreach ($statesData as $res) { $agencylistform->state_1->addMultiOption($res['id'], utf8_encode($res['state_name'])); } if (isset($state_1) && $state_1 != 0 && $state_1 != '') { $agencylistform->setDefault('state_1', $state_1); } } if (isset($state_1) && $state_1 != 0 && $state_1 != '') { $citiesData = $citiesmodel->getCitiesList($state_1); foreach ($citiesData as $res) { $agencylistform->city_1->addMultiOption($res['id'], utf8_encode($res['city_name'])); } if (isset($city_1) && $city_1 != 0 && $city_1 != '') { $agencylistform->setDefault('city_1', $city_1); } } $country_2 = $this->_request->getParam('country_2'); $state_2 = intVal($this->_request->getParam('state_2')); $city_2 = intVal($this->_request->getParam('city_2')); if (isset($country_2) && $country_2 != 0 && $country_2 != '') { $statesData = $statesmodel->getStatesList($country_2); foreach ($statesData as $res) { $agencylistform->state_2->addMultiOption($res['id'], utf8_encode($res['state_name'])); } if (isset($state_2) && $state_2 != 0 && $state_2 != '') { $agencylistform->setDefault('state_2', $state_2); } } if (isset($state_2) && $state_2 != 0 && $state_2 != '') { $citiesData = $citiesmodel->getCitiesList($state_2); foreach ($citiesData as $res) { $agencylistform->city_2->addMultiOption($res['id'], utf8_encode($res['city_name'])); } if (isset($city_2) && $city_2 != 0 && $city_2 != '') { $agencylistform->setDefault('city_2', $city_2); } } $country_3 = $this->_request->getParam('country_3'); $state_3 = intVal($this->_request->getParam('state_3')); $city_3 = intVal($this->_request->getParam('city_3')); if (isset($country_3) && $country_3 != 0 && $country_3 != '') { $statesData = $statesmodel->getStatesList($country_3); foreach ($statesData as $res) { $agencylistform->state_3->addMultiOption($res['id'], utf8_encode($res['state_name'])); } if (isset($state_3) && $state_3 != 0 && $state_3 != '') { $agencylistform->setDefault('state_3', $state_3); } } if (isset($state_3) && $state_3 != 0 && $state_3 != '') { $citiesData = $citiesmodel->getCitiesList($state_3); foreach ($citiesData as $res) { $agencylistform->city_3->addMultiOption($res['id'], utf8_encode($res['city_name'])); } if (isset($city_3) && $city_3 != 0 && $city_3 != '') { $agencylistform->setDefault('city_3', $city_3); } } $typesData = $checktypeModal->fetchAll('isactive=1', 'type')->toArray(); if (!empty($typesData)) { $this->view->configure = ''; } else { $msgarray['bg_checktype'] = 'Screening types are not configured yet.'; $errorflag = 'false'; $this->view->configure = 'notconfigured'; } $rolesData = $agencylistmodel->getagencyrole(); if (!empty($rolesData)) { $this->view->rolesconfigure = ''; } else { $msgarray['emprole'] = 'Roles are not configured yet.'; $errorflag = 'false'; $this->view->rolesconfigure = 'notconfigured'; } /* Email address validation */ $email_1 = $this->_request->getParam('email_1'); $isvalidemail = filter_var($email_1, FILTER_VALIDATE_EMAIL); if ($email_1 == $isvalidemail) { } else { $msgarray['email_1'] = "Please enter valid email."; $errorflag = "false"; } $email_2 = $this->_request->getParam('email_2'); if ($email_2 != '') { $isvalidemail = filter_var($email_2, FILTER_VALIDATE_EMAIL); if ($email_2 == $isvalidemail) { } else { $msgarray['email_2'] = "Please enter valid email."; $errorflag = "false"; } } $email_3 = $this->_request->getParam('email_3'); if ($email_3 != '') { $isvalidemail = filter_var($email_3, FILTER_VALIDATE_EMAIL); if ($email_3 == $isvalidemail) { } else { $msgarray['email_3'] = "Please enter valid email."; $errorflag = "false"; } } /* Email address validation END */ /* Website validation */ $id = $this->_request->getParam('id'); $website_url = $this->_request->getParam('website_url'); $websiteExistance = $agencylistmodel->checkSiteDuplicates($website_url, $id); if (!empty($websiteExistance)) { $eid = isset($websiteExistance['employeeId']) ? $websiteExistance['employeeId'] : 'An agency'; if ($websiteExistance['isactive'] == '1') { $msgarray['website_url'] = $eid . " with the given website URL already exists."; } else { $msgarray['website_url'] = $eid . " with the given website URL already exists but it might be inactive. Please activate it from manage external users."; } $errorflag = "false"; } /* Website validation END */ if ($agencylistform->isValid($this->_request->getPost()) && $errorflag != 'false') { $agencyname = $this->_request->getParam('agencyname'); $address = $this->_request->getParam('address'); $primaryphone = $this->_request->getParam('primaryphone'); $secondaryphone = $this->_request->getParam('secondaryphone'); $bg_checktype = $this->_request->getParam('bg_checktype'); $bg_checktype = implode(',', $bg_checktype); $website_url = $this->_request->getParam('website_url'); $pocid_1 = $this->_request->getParam('pocid_1'); $firstname_1 = $this->_request->getParam('firstname_1'); $lastname_1 = $this->_request->getParam('lastname_1'); $mobile_1 = $this->_request->getParam('mobile_1'); $email_1 = $this->_request->getParam('email_1'); $location_1 = $this->_request->getParam('location_1'); $country_1 = $this->_request->getParam('country_1'); $state_1 = $this->_request->getParam('state_1'); $city_1 = $this->_request->getParam('city_1'); $contact_type_1 = $this->_request->getParam('contact_type_1'); $pocid_2 = $this->_request->getParam('pocid_2'); $firstname_2 = $this->_request->getParam('firstname_2'); $lastname_2 = $this->_request->getParam('lastname_2'); $mobile_2 = $this->_request->getParam('mobile_2'); $email_2 = $this->_request->getParam('email_2'); $location_2 = $this->_request->getParam('location_2'); $country_2 = $this->_request->getParam('country_2'); $state_2 = $this->_request->getParam('state_2'); $city_2 = $this->_request->getParam('city_2'); $contact_type_2 = $this->_request->getParam('contact_type_2'); $pocid_3 = $this->_request->getParam('pocid_3'); $firstname_3 = $this->_request->getParam('firstname_3'); $lastname_3 = $this->_request->getParam('lastname_3'); $mobile_3 = $this->_request->getParam('mobile_3'); $email_3 = $this->_request->getParam('email_3'); $location_3 = $this->_request->getParam('location_3'); $country_3 = $this->_request->getParam('country_3'); $state_3 = $this->_request->getParam('state_3'); $city_3 = $this->_request->getParam('city_3'); $contact_type_3 = $this->_request->getParam('contact_type_3'); $emprole = $this->_request->getParam('emprole'); if (empty($websiteExistance)) { $date = new Zend_Date(); if ($contact_type_1 == 1) { $agencyEmail = $email_1; $agencyContactNum = $mobile_1; $pocfn = $firstname_1; $pocln = $lastname_1; } else { if ($contact_type_2 == 1) { $agencyEmail = $email_2; $agencyContactNum = $mobile_2; $pocfn = $firstname_2; $pocln = $lastname_2; } else { if ($contact_type_3 == 1) { $agencyEmail = $email_3; $agencyContactNum = $mobile_3; $pocfn = $firstname_3; $pocln = $lastname_3; } } } $primary_poc_name = ucfirst($pocfn); /* Create user for the agency */ if ($id == '') { $pswd = uniqid(); $userdata = array('emprole' => $emprole, 'userstatus' => 'old', 'firstname' => $firstname_1, 'lastname' => $lastname_1, 'userfullname' => $firstname_1 . ' ' . $lastname_1, 'emailaddress' => $agencyEmail, 'contactnumber' => $agencyContactNum, 'emppassword' => md5($pswd), 'isactive' => 1, 'createdby' => $loginUserId, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $userWhere = ''; $usersModel = new Default_Model_Users(); $usersTableId = $usersModel->addOrUpdateUserModel($userdata, $userWhere); $agencyuserid = $usersTableId; $idcodeModel = new Default_Model_Identitycodes(); $idcode = $idcodeModel->getallcodes('bgcheck'); $userdata = array('employeeId' => $idcode . $usersTableId, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $userWhere = array('id=?' => $usersTableId); $usersTableId = $usersModel->addOrUpdateUserModel($userdata, $userWhere); $options['subject'] = APPLICATION_NAME . ' :: Agency is created'; $options['header'] = 'Greetings from ' . APPLICATION_NAME; $options['toEmail'] = $agencyEmail; $options['toName'] = $pocfn . ' ' . $pocln; $options['message'] = '<div>Dear ' . $pocfn . ',</div> <div>' . ucfirst($agencyname) . ' agency has been created. The credentials to login to your ' . APPLICATION_NAME . ' account are: <div>Login ID : ' . $idcode . $agencyuserid . ' </div> <div>Password : '******'</div> <div></div> <div style="padding:20px 0 10px 0;">Please <a href="' . $baseUrl . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the agency details.</div> </div>'; $result = sapp_Global::_sendEmail($options); $emailids = $agencylistmodel->getAllHRManagementEMails(); foreach ($emailids as $email) { $options['subject'] = APPLICATION_NAME . ' :: Agency is created'; $options['header'] = 'Agency created'; $options['toEmail'] = $email['groupEmail']; $options['toName'] = $email['group_name']; if ($email['group_id'] == 4) { $salutation = 'Dear HR,'; $options['toName'] = 'HR'; } else { $salutation = 'Dear Management,'; $options['toName'] = 'Management'; } $options['message'] = '<div> <div>' . $salutation . ' </div> <div></div> ' . ucfirst($agencyname) . ' agency has been created with ' . $pocfn . ' ' . $pocln . ' as primary point of contact. <div></div> <div style="padding:20px 0 10px 0;">Please <a href="' . $baseUrl . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the agency details.</div> </div>'; $options['cron'] = 'yes'; $result = sapp_Global::_sendEmail($options); } } else { $agencyInfo = $agencylistmodel->getSingleagencyPOCData($id); $userid = $agencyInfo[0]['user_id']; $agencyoldname = $agencyInfo[0]['agencyname']; $userdata = array('emprole' => $emprole, 'userfullname' => $agencyname, 'emailaddress' => $agencyEmail, 'contactnumber' => $agencyContactNum, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $userWhere = array('id=?' => $userid); $usersModel->addOrUpdateUserModel($userdata, $userWhere); if ($agencyoldname != $agencyname) { $agencynamemsg = '<div>Hello ' . ucfirst($primary_poc_name) . ',</div><div>Your agency name is changed to ' . ucfirst($agencyname) . '.</div>'; } else { $agencynamemsg = '<div>Hello ' . ucfirst($primary_poc_name) . ',</div><div>Your agency information has been modified. Please find the details below:</div>'; } $options['subject'] = APPLICATION_NAME . ' :: Agency details are updated'; $options['header'] = 'Agency information'; $options['toEmail'] = $agencyEmail; $options['toName'] = $pocfn . ' ' . $pocln; $options['message'] = '<div>' . $agencynamemsg . ' <div><table border="1" style="border-collapse:collapse;"><tr><td>Primary email</td><td>' . $agencyEmail . '</td></tr><tr><td>Primary Contact Number</td><td>' . $agencyContactNum . '</td></tr></table></div> <div style="padding:20px 0 10px 0;">Please <a href="' . $baseUrl . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the agency details. </div> </div>'; $options['cron'] = 'yes'; $result = sapp_Global::_sendEmail($options); } $actionflag = ''; $tableid = ''; $data = array('user_id' => $agencyuserid, 'agencyname' => $agencyname, 'address' => $address, 'primaryphone' => $primaryphone, 'secondaryphone' => $secondaryphone, 'bg_checktype' => $bg_checktype, 'website_url' => $website_url, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($id != '') { unset($data['user_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; } $agencyId = $agencylistmodel->SaveorUpdateAgency($data, $where); if ($agencyId == 'update') { $tableid = $id; } else { $tableid = $agencyId; } $menuID = AGENCYLIST; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); if ($firstname_1 != '' && $mobile_1 != '') { $pocData_1 = array('bg_agencyid' => $tableid, 'first_name' => $firstname_1, 'last_name' => $lastname_1, 'contact_no' => $mobile_1, 'email' => $email_1, 'location' => $location_1, 'country' => $country_1, 'state' => $state_1, 'city' => $city_1, 'contact_type' => $contact_type_1, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($pocid_1 != '') { $pocWhere_1 = array('id=?' => $pocid_1); $actionflag = 2; } else { $pocData_1['createdby'] = $loginUserId; $pocData_1['createddate'] = gmdate("Y-m-d H:i:s"); $pocData_1['isactive'] = 1; $pocWhere_1 = ''; $actionflag = 1; } $savedpocId_1 = $pocModel->SaveorUpdatePOCDetails($pocData_1, $pocWhere_1); if ($savedpocId_1 == 'update') { $newpocid_1 = $pocid_1; } else { $newpocid_1 = $savedpocId_1; } } if ($firstname_2 != '' && $mobile_2 != '') { $pocData_2 = array('bg_agencyid' => $tableid, 'first_name' => $firstname_2, 'last_name' => $lastname_2, 'contact_no' => $mobile_2, 'email' => $email_2, 'location' => $location_2, 'country' => $country_2, 'state' => $state_2, 'city' => $city_2, 'contact_type' => $contact_type_2, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($pocid_2 != '') { $pocWhere_2 = array('id=?' => $pocid_2); $actionflag = 2; } else { $pocData_2['createdby'] = $loginUserId; $pocData_2['createddate'] = gmdate("Y-m-d H:i:s"); $pocData_2['isactive'] = 1; $pocWhere_2 = ''; $actionflag = 1; } $savedpocId_2 = $pocModel->SaveorUpdatePOCDetails($pocData_2, $pocWhere_2); if ($savedpocId_2 == 'update') { $newpocid_2 = $pocid_2; } else { $newpocid_2 = $savedpocId_2; } } if ($firstname_3 != '' && $mobile_3 != '') { $pocData_3 = array('bg_agencyid' => $tableid, 'first_name' => $firstname_3, 'last_name' => $lastname_3, 'contact_no' => $mobile_3, 'email' => $email_3, 'location' => $location_3, 'country' => $country_3, 'state' => $state_3, 'city' => $city_3, 'contact_type' => $contact_type_3, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($pocid_3 != '') { $pocWhere_3 = array('id=?' => $pocid_3); $actionflag = 2; } else { $pocData_3['createdby'] = $loginUserId; $pocData_3['createddate'] = gmdate("Y-m-d H:i:s"); $pocData_3['isactive'] = 1; $pocWhere_3 = ''; $actionflag = 1; } $savedpocId_3 = $pocModel->SaveorUpdatePOCDetails($pocData_3, $pocWhere_3); if ($savedpocId_3 == 'update') { $newpocid_3 = $pocid_3; } else { $newpocid_3 = $savedpocId_3; } } if ($agencyId == 'update') { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Agency data updated successfully.")); } else { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Agency data added successfully.")); } $this->_redirect('agencylist'); } else { $msgarray['message'] = 'An Agency, with the given website address, already exists.'; $msgarray['msgtype'] = 'error'; return $msgarray; } } else { $messages = $agencylistform->getMessages(); if (isset($msgarray['mobile_1']) && !isset($messages['mobile_1'])) { $messages['mobile_1'] = $msgarray['mobile_1']; } if (isset($msgarray['email_1']) && !isset($messages['email_1'])) { $messages['email_1'] = $msgarray['email_1']; } if (isset($msgarray['mobile_2']) && !isset($messages['mobile_2'])) { $messages['mobile_2'] = $msgarray['mobile_2']; } if (isset($msgarray['email_2']) && !isset($messages['email_2'])) { $messages['email_2'] = $msgarray['email_2']; } if (isset($msgarray['mobile_3']) && !isset($messages['mobile_3'])) { $messages['mobile_3'] = $msgarray['mobile_3']; } if (isset($msgarray['email_3']) && !isset($messages['email_3'])) { $messages['email_3'] = $msgarray['email_3']; } $i = 0; $msgarray['error1dv'] = ''; $msgarray['error2dv'] = ''; $msgarray['error3dv'] = ''; foreach ($messages as $key => $val) { if (strpos($key, '_1') !== false) { $msgarray['error1dv'] = 'first'; } if (strpos($key, '_2') !== false) { $msgarray['error2dv'] = 'second'; } if (strpos($key, '_3') !== false) { $msgarray['error3dv'] = 'third'; } if (!isset($msgarray[$key])) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } $i = $i + 1; if (empty($typesData)) { $msgarray['bg_checktype'] = 'Screening types are not configured yet.'; } if (empty($rolesData)) { $msgarray['emprole'] = 'Roles are not configured yet.'; } } return $msgarray; } }
public function saveProfileDetails($viewprofileform) { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } if ($viewprofileform->isValid($this->_request->getPost())) { $id = $this->_request->getParam('id'); $userfullname = $this->_request->getParam('userfullname'); $emailaddress = $this->_request->getParam('emailaddress'); $usersModel = new Default_Model_Users(); $date = new Zend_Date(); $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; $data = array('userfullname' => $userfullname, 'emailaddress' => $emailaddress, '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 = $usersModel->addOrUpdateUserModel($data, $where); sapp_Global::writeApplicationConstants($emailaddress, APPLICATION_NAME); if ($Id == 'update') { $tableid = $id; $this->_helper->getHelper("FlashMessenger")->addMessage("Profile details updated successfully."); } else { $tableid = $Id; $this->_helper->getHelper("FlashMessenger")->addMessage("Profile details saved successfully."); } $this->_redirect('dashboard/viewprofile'); } else { $messages = $viewprofileform->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; } $id = $this->_request->getParam('objid'); $messages['message'] = ''; $messages['msgtype'] = ''; $actionflag = 3; if ($id) { $employeemodel = new Default_Model_Employee(); $usersModel = new Default_Model_Users(); $menumodel = new Default_Model_Menu(); $empdata = array('isactive' => 5); $empwhere = array('user_id=?' => $id); $userdata = array('isactive' => 5); $userwhere = array('id=?' => $id); $empId = $employeemodel->SaveorUpdateEmployeeData($empdata, $empwhere); $userId = $usersModel->addOrUpdateUserModel($userdata, $userwhere); if ($empId == 'update' && $userId == 'update') { $menuidArr = $menumodel->getMenuObjID('/employee'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); $messages['message'] = 'Employee deleted successfully.'; $messages['msgtype'] = 'success'; } else { $messages['message'] = 'Employee cannot be deleted.'; $messages['msgtype'] = 'error'; } } else { $messages['message'] = 'Employee cannot be deleted.'; $messages['msgtype'] = 'error'; } $this->_helper->json($messages); }
public function save($processesform, $processdata) { $baseUrl = DOMAIN; $baseUrl = rtrim($baseUrl, '/'); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; $loginuserRole = $auth->getStorage()->read()->emprole; } $usermodel = new Default_Model_Users(); $hrem = 'true'; $mngmntem = 'true'; $agencyEmail = ''; $lmanager1Email = ''; $lmanager1Name = 'Manager'; $agencysalutationName = 'Agency'; $id = $this->getRequest()->getParam('id'); $idData = $this->getRequest()->getParam('unitId'); $idArr = array(); $idArr = explode('-', $idData); $specimen_id = $idArr[0]; $userflag = $idArr[1]; $msgarray = array(); if ($idArr[1] == 2) { $flag = 'cand'; $person = 'candidate'; } else { $flag = 'emp'; $person = 'employee'; } $processesmodel = new Default_Model_Processes(); $empscreeningModel = new Default_Model_Empscreening(); $statusFlag = ''; $close = ''; $controllername = 'processes'; $errorflag = 'true'; $BGStatus = ''; $oldbgstatus = ''; $mailsentflag = 0; if (!empty($processdata)) { $newStatus = $this->getRequest()->getParam('process_status'); $previousstatus = $processdata[0]['process_status']; $agencyid = $processdata[0]['agencyid']; $checktype = $processdata[0]['checktypeid']; $processStatus = $processesmodel->getProcessStatus($specimen_id, $userflag, $agencyid, $checktype); if (!empty($processStatus) && sizeof($processStatus) > 0) { $oldstatus = $processStatus[0]['process_status']; $BGStatus = $processStatus[0]['bgcheck_status']; /* Check - Adding a record with same userid, agencyid and check type */ $exists = 'false'; for ($i = 0; $i < sizeof($processStatus); $i++) { if (($processStatus[$i]['process_status'] == 'On hold' || $processStatus[$i]['process_status'] == 'In process') && $processStatus[$i]['process_status'] == $newStatus) { $exists = 'true'; } } if ($newStatus == $previousstatus) { $msgarray['StatusError'] = "Please change the status."; $errorflag = "false"; } else { if ($BGStatus != 'Complete' && $exists == 'true') { $msgarray['StatusError'] = "The " . $person . " is already assigned to the selected agency. Please re-assign the " . $person . " to another agency."; $errorflag = "false"; } } /* END */ } } else { $checktype = $this->_request->getParam('checktype'); $radio_pocId = $this->_request->getParam('contactRadio'); $agencyid = $this->_request->getParam('agencyids'); $newStatus = 'In process'; $agencyData = array(); $agencyPOCData = array(); if (empty($checktype) && $checktype == '') { $msgarray['checktype'] = "Please check atleast one screening type"; $errorflag = "false"; } else { if (empty($radio_pocId) || $radio_pocId == '') { $msgarray['contactRadio'] = "Please select point of contact"; $errorflag = "false"; } } if ($checktype) { $agencyArr = array(); $agencyArr = $checktype; $agencyData = $empscreeningModel->getAgencyData($agencyArr, '', ''); } if (!isset($agencyid) || $agencyid == '') { $agencyid = $this->getRequest()->getParam('defaultagencyid'); } if (!isset($agencyid) || $agencyid == '') { $msgarray['agencyids'] = "Please select agency."; $errorflag = "false"; } if ($agencyid) { $agencyPOCData = $empscreeningModel->getAgencyPOCData($agencyid); } $this->view->agencyData = $agencyData; $this->view->agencyPOCData = $agencyPOCData; /* Checking for configurations - screening type and agencies */ $checktypeModal = new Default_Model_Bgscreeningtype(); $agencymodel = new Default_Model_Agencylist(); $typesData = $checktypeModal->fetchAll('isactive=1', 'type')->toArray(); $agencyData = $agencymodel->fetchAll('isactive=1', 'agencyname')->toArray(); for ($i = 0; $i < sizeof($agencyPOCData); $i++) { if ($agencyPOCData[$i]['id'] == $radio_pocId) { $agencyEmail = $agencyPOCData[$i]['email']; $agencyfname = $agencyPOCData[$i]['first_name']; $agencylname = $agencyPOCData[$i]['last_name']; $agencysalutationName = $agencyfname . ' ' . $agencylname; } } if (empty($typesData)) { $msgarray['checktype'] = 'Screening types are not configured yet.'; $errorflag = 'false'; } if (empty($agencyData)) { $msgarray['agencyids'] = 'Agencies are not added yet.'; $errorflag = 'false'; } $this->view->msgarray = $msgarray; /* */ /* Check - Adding a record with same userid, agencyid and check type (for each check type ) */ if (is_array($checktype) && $errorflag != "false") { for ($i = 0; $i < sizeof($checktype); $i++) { $processStatus = array(); $processStatus = $processesmodel->getProcessStatus($specimen_id, $userflag, $agencyid, $checktype[$i]); if (!empty($processStatus) && sizeof($processStatus > 0)) { $exists = 'false'; for ($i = 0; $i < sizeof($processStatus); $i++) { if ($processStatus[$i]['process_status'] == 'On hold' || $processStatus[$i]['process_status'] == 'In process') { $exists = 'true'; } } $oldstatus = $processStatus[0]['process_status']; $BGStatus = $processStatus[0]['bgcheck_status']; if ($exists == 'true' && $BGStatus != 'Complete') { $msgarray['StatusError'] = "The " . $person . " is already assigned to the selected agency. Please re-assign the " . $person . " to another agency."; $errorflag = "false"; } } $oldbgstatusData = $processesmodel->getProcessStatus($specimen_id, $userflag, '', ''); if (!empty($oldbgstatusData)) { $oldbgstatus = $oldbgstatusData[0]['bgcheck_status']; } else { $oldbgstatus = ''; } } } /* END */ } if ($processesform->isValid($this->_request->getPost()) && $errorflag != 'false') { $date = new Zend_Date(); $menumodel = new Default_Model_Menu(); $actionflag = ''; $tableid = ''; /* A New process is created for a user whose background check status is in 'Complete' status. Then updating the bg status to 'In process' */ if (($BGStatus == 'Complete' || $oldbgstatus == 'Complete' || $BGStatus == 'On hold' || $oldbgstatus == 'On hold') && $newStatus == 'In process') { $totalstatusData = array('bgcheck_status' => 'In process', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $totalstatusWhere = array('specimen_id=?' => $specimen_id, 'flag=?' => $userflag); $empscreeningModel->SaveorUpdateDetails($totalstatusData, $totalstatusWhere); /* Updating back ground check status to In process in employees/candidates status */ if ($userflag == 1) { $empData = array('backgroundchk_status' => 'In process', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $empWhere = array('id=?' => $specimen_id); $usermodel->addOrUpdateUserModel($empData, $empWhere); } else { $candModel = new Default_Model_Candidatedetails(); $candData = array('backgroundchk_status' => 'In process', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $candWhere = array('id=?' => $specimen_id); $candModel->SaveorUpdateUserData($candData, $candWhere); } /* END */ /* Mail to HRD, Line 1 and Line 2 managers that the background checks has been re-opened */ if ($BGStatus != 'On hold' && $oldbgstatus != 'On hold') { $empData = $empscreeningModel->getEmpPersonalData($specimen_id, $userflag); if ($userflag == 1) { $username = $empData[0]['name']; $lmanager1Email = $empData[0]['rmanager_email']; $lmanager1Name = $empData[0]['reporting_manager']; } else { $username = $empData[0]['candidate_name']; $lmanager1Email = ''; } $bid = ''; if (isset($empData[0]['businessid'])) { $bid = $empData[0]['businessid']; } if (isset($lmanager1Email) && $lmanager1Email != '') { $manager1 = array($lmanager1Email); } else { $manager1 = array(); } if (isset($agencyEmail) && $agencyEmail != '') { $agencyemail1 = array($agencyEmail); } else { $agencyemail1 = array(); } if (defined('BG_CHECKS_MNGMNT_' . $bid) && $bid != '') { $mngmntemailId = explode(",", constant('BG_CHECKS_MNGMNT_' . $bid)); } else { $mngmntem = 'false'; $mngmntemailId = array(); } if (defined('BG_CHECKS_HR_' . $bid) && $bid != '') { $hremailId = explode(",", constant('BG_CHECKS_HR_' . $bid)); } else { $hrem = 'false'; $hremailId = array(); } $emailArr = array_merge($agencyemail1, $manager1, $mngmntemailId, $hremailId); for ($i = 0; $i < sizeof($emailArr); $i++) { $salutation = 'Dear Sir/Madam,'; if ($i == 0) { $salutation = 'Dear ' . ucfirst($agencysalutationName) . ','; $options['toName'] = ucfirst($agencysalutationName); } if ($i == 1) { $salutation = 'Dear ' . ucfirst($lmanager1Name) . ','; $options['toName'] = ucfirst($lmanager1Name); } if ($i == 2) { $salutation = 'Dear Management,'; $options['toName'] = 'Management'; } if ($i == 3) { $salutation = 'Dear HR,'; $options['toName'] = 'HR'; } $options['subject'] = APPLICATION_NAME . ' : Background checks re-opened'; $options['header'] = 'Background checks re-opened'; $options['toEmail'] = $emailArr[$i]; $createdbyName = $usermodel->getUserDetails($loginUserId); if ($i == 0) { $mailsentflag = 1; $options['message'] = '<div>' . $salutation . '<div>The background check for ' . ucfirst($username) . ' has been re-opened by ' . $createdbyName[0]['userfullname'] . '. </div> <div style="padding:20px 0 10px 0;">Please <a href="' . $baseUrl . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the details.</div> </div>'; } else { $options['message'] = '<div>' . $salutation . '<div>The background check for ' . ucfirst($username) . ' has been re-opened by ' . $createdbyName[0]['userfullname'] . '. </div> <div style="padding:20px 0 10px 0;">Please <a href="' . $baseUrl . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the details.</div> </div>'; } $options['cron'] = 'yes'; sapp_Global::_sendEmail($options); } } /* END */ } /* END */ $data = array('specimen_id' => $specimen_id, 'flag' => $userflag, 'bgagency_id' => $agencyid, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); if ($id != '') { $data['process_status'] = $newStatus; $data['explanation'] = NULL; $where = array('id=?' => $id); $actionflag = 2; } else { $data['process_status'] = $newStatus; $data['bgagency_pocid'] = $radio_pocId; $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $data['isactive'] = 1; $where = ''; $actionflag = 1; if ($newStatus == 'In process' && ($BGStatus != 'Complete' || $oldbgstatus != 'Complete' || $BGStatus != 'On hold' || $oldbgstatus != 'On hold') && $mailsentflag == 0) { $empData = $empscreeningModel->getEmpPersonalData($specimen_id, $userflag); $table = ''; if ($userflag == 1) { $username = $empData[0]['name']; $lmanager1Email = $empData[0]['rmanager_email']; $lmanager1Name = $empData[0]['reporting_manager']; $table = '<div> <table border="1" style="border-collapse:collapse;"> <tr><td>Employee ID</td><td>' . $empData[0]['employee_id'] . '</td></tr> <tr><td>Employee Email</td><td>' . $empData[0]['email_id'] . '</td></tr> <tr><td>Employee Designation</td><td>' . $empData[0]['designation'] . '</td></tr> </table> </div>'; } else { $username = $empData[0]['candidate_name']; $lmanager1Email = ''; $table = '<div>Candidate Email : ' . $empData[0]['email'] . '</div>'; } if ($agencysalutationName != '') { $salutation = 'Dear ' . ucfirst($agencysalutationName) . ','; $options['toName'] = ucfirst($agencysalutationName); } else { $salutation = 'Dear Sir/Madam,'; $options['toName'] = 'Agency'; } $createdbyName = $usermodel->getUserDetails($loginUserId); $options['subject'] = APPLICATION_NAME . ' : Background checks initiated'; $options['header'] = 'Background checks initiated'; $options['toEmail'] = $agencyEmail; $options['message'] = '<div>' . $salutation . '<div>' . ucfirst($username) . ' has been sent for background checks by ' . ucfirst($createdbyName[0]['userfullname']) . '. Please find the details below.</div>' . $table . ' <div style="padding:20px 0 10px 0;">Please <a href="' . $baseUrl . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the details.</div> </div>'; $options['cron'] = 'yes'; sapp_Global::_sendEmail($options); } } if (is_array($checktype)) { for ($i = 0; $i < sizeof($checktype); $i++) { $data['bgcheck_type'] = $checktype[$i]; $detailId = $empscreeningModel->SaveorUpdateDetails($data, $where); } } else { $data['bgcheck_type'] = $checktype; $detailId = $empscreeningModel->SaveorUpdateDetails($data, $where); } /* If all the processes are in 'Complete' status, then updating the background check status to 'Complete' and sending mail to HR, reporting manager */ $checkAllprocesses = $processesmodel->getProcessStatus($specimen_id, $userflag); $completecount = 0; $onholdcount = 0; for ($i = 0; $i < sizeof($checkAllprocesses); $i++) { if ($checkAllprocesses[$i]['process_status'] == 'Complete') { $completecount = $completecount + 1; } } if ($completecount == sizeof($checkAllprocesses)) { $totalstatusData = array('bgcheck_status' => 'Complete', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $totalstatusWhere = array('specimen_id=?' => $specimen_id, 'flag=?' => $userflag); $empscreeningModel->SaveorUpdateDetails($totalstatusData, $totalstatusWhere); /* Updating back ground check status to Completed in employees/candidates status */ if ($userflag == 1) { $usermodel = new Default_Model_Users(); $empData = array('backgroundchk_status' => 'Completed', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $empWhere = array('id=?' => $specimen_id); $usermodel->addOrUpdateUserModel($empData, $empWhere); } else { $candModel = new Default_Model_Candidatedetails(); $candData = array('backgroundchk_status' => 'Completed', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $candWhere = array('id=?' => $specimen_id); $candModel->SaveorUpdateUserData($candData, $candWhere); } /* END */ /* Mail to HRD, Line 1 and Line 2 managers */ if ($newStatus == 'Complete') { $empData = $empscreeningModel->getEmpPersonalData($specimen_id, $userflag); if ($userflag == 1) { $username = $empData[0]['name']; $lmanager1Email = $empData[0]['rmanager_email']; $lmanager1Name = $empData[0]['reporting_manager']; } else { $username = $empData[0]['name']; $lmanager1Email = ''; } $bid = ''; if (isset($empData[0]['businessid'])) { $bid = $empData[0]['businessid']; } if (isset($lmanager1Email) && $lmanager1Email != '') { $manager1 = array($lmanager1Email); } else { $manager1 = array(); } if (defined('BG_CHECKS_MNGMNT_' . $bid) && $bid != '') { $mngmntemailId = explode(",", constant('BG_CHECKS_MNGMNT_' . $bid)); } else { $mngmntemailId = array(); } if (defined('BG_CHECKS_HR_' . $bid) && $bid != '') { $hremailId = explode(",", constant('BG_CHECKS_HR_' . $bid)); } else { $hremailId = array(); } $emailArr = array_merge($manager1, $mngmntemailId, $hremailId); for ($i = 0; $i < sizeof($emailArr); $i++) { $salutation = 'Dear Sir/Madam,'; if ($i == 0) { $salutation = 'Dear ' . ucfirst($lmanager1Name) . ','; $options['toName'] = ucfirst($lmanager1Name); } else { if ($i == 1) { $salutation = 'Dear Management,'; $options['toName'] = 'Management'; } else { $salutation = 'Dear HR,'; $options['toName'] = 'HR'; } } $options['subject'] = APPLICATION_NAME . ' : Background checks completed'; $options['header'] = 'Background checks completed'; $options['toEmail'] = $emailArr[$i]; $options['message'] = '<div>' . $salutation . '<div>The background check for ' . ucfirst($username) . ' has been completed.</div> <div style="padding:20px 0 10px 0;">Please <a href="' . $baseUrl . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the details.</div> </div>'; $options['cron'] = 'yes'; sapp_Global::_sendEmail($options); } } /* END */ } /* End */ /* If all the processes are in 'On hold' status, then updating the background check status to 'On hold' */ for ($i = 0; $i < sizeof($checkAllprocesses); $i++) { if ($checkAllprocesses[$i]['process_status'] == 'On hold') { $onholdcount = $onholdcount + 1; } } if ($onholdcount == sizeof($checkAllprocesses)) { $totalstatusData = array('bgcheck_status' => 'On hold', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $totalstatusWhere = array('specimen_id=?' => $specimen_id, 'flag=?' => $userflag); $empscreeningModel->SaveorUpdateDetails($totalstatusData, $totalstatusWhere); /* Updating back ground check status to Completed in employees/candidates status */ if ($userflag == 1) { $usermodel = new Default_Model_Users(); $empData = array('backgroundchk_status' => 'On hold', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $empWhere = array('id=?' => $specimen_id); $usermodel->addOrUpdateUserModel($empData, $empWhere); } else { $candModel = new Default_Model_Candidatedetails(); $candData = array('backgroundchk_status' => 'On hold', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $candWhere = array('id=?' => $specimen_id); $candModel->SaveorUpdateUserData($candData, $candWhere); } /* END */ } /* END */ if ($detailId == 'update') { $tableid = $id; $this->view->eventact = 'updated'; } else { $tableid = $detailId; $this->view->eventact = 'added'; } $actionflag = 2; //Edit of the candidate or employee $menuidArr = $menumodel->getMenuObjID('/empscreening'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $specimen_id . '-' . $userflag); $close = 'close'; $this->view->popup = $close; } else { $messages = $processesform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } if (empty($checktypesData)) { $msgarray['checktype'] = 'Screening types are not configured yet.'; } if (empty($checkagencyData)) { $msgarray['agencyids'] = 'Agencies are not added yet.'; } } return $msgarray; } $this->view->statusFlag = $statusFlag; }
public function forcedfullupdateAction() { $baseUrl = BASE_URL; $baseUrl = rtrim($baseUrl, '/'); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/"); $specimenId = $this->_request->getParam('specimenId'); $empFlag = $this->_request->getParam('empFlag'); $count = intval($this->_request->getParam('count')); $username = ''; $empscreeningModel = new Default_Model_Empscreening(); $getAllRecords = $empscreeningModel->checkbgstatus($specimenId, $empFlag, 'completedata'); $username = $getAllRecords[0]['username']; if (isset($getAllRecords[0]['rmanager_email'])) { $reportmanagerEmail = $getAllRecords[0]['rmanager_email']; } else { $reportmanagerEmail = ''; } if (isset($getAllRecords[0]['reporting_manager'])) { $reportmanagername = $getAllRecords[0]['reporting_manager']; } else { $reportmanagername = ''; } if ($count == '') { $this->view->dataArray = $getAllRecords; } $close = ''; if ($count != '') { for ($i = 0; $i < $count; $i++) { $id = intval($this->_request->getParam('id' . $i)); $explanation = $this->_request->getParam('text' . $i); $date = new Zend_Date(); $data = array('process_status' => 'Complete', 'explanation' => $explanation, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('specimen_id=?' => $specimenId, 'flag=?' => $empFlag, 'process_status=?' => 'In process', 'id=?' => $id); $detailId = $empscreeningModel->SaveorUpdateDetails($data, $where); $where = array('specimen_id=?' => $specimenId, 'flag=?' => $empFlag, 'process_status' => 'On hold', 'id=?' => $id); $detailId = $empscreeningModel->SaveorUpdateDetails($data, $where); if ($detailId == 'update') { $tableid = $id; } else { $tableid = $detailId; } $actionflag = 2; $menuID = EMPSCREENING; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $specimenId . '-' . $empFlag); } $bgdata = array('bgcheck_status' => 'Complete', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $where = array('specimen_id=?' => $specimenId, 'flag=?' => $empFlag, 'isactive = 1'); $actionflag = 2; $detailId = $empscreeningModel->SaveorUpdateDetails($bgdata, $where); /* Updating back ground check status to Completed in employees/candidates status */ if ($empFlag == 1) { $usermodel = new Default_Model_Users(); $empData = array('backgroundchk_status' => 'Completed', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $empWhere = array('id=?' => $specimenId); $usermodel->addOrUpdateUserModel($empData, $empWhere, $specimenId); } else { $candModel = new Default_Model_Candidatedetails(); $candData = array('backgroundchk_status' => 'Completed', 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); $candWhere = array('id=?' => $specimenId); $candModel->SaveorUpdateUserData($candData, $candWhere); } /* END */ /* Mail to HRD, L1 and L2 managers*/ $personalData = $empscreeningModel->getEmpPersonalData($specimenId, $empFlag); $bid = ''; if (isset($personalData[0]['businessid'])) { $bid = $personalData[0]['businessid']; } if (isset($reportmanagerEmail) && $reportmanagerEmail != '') { $manager1 = array($reportmanagerEmail); } else { $manager1 = array(); } if (defined('BG_CHECKS_MNGMNT_' . $bid) && $bid != '') { $mngmntemailId = explode(",", constant('BG_CHECKS_MNGMNT_' . $bid)); } else { $mngmntemailId = array(); } if (defined('BG_CHECKS_HR_' . $bid) && $bid != '') { $hremailId = explode(",", constant('BG_CHECKS_HR_' . $bid)); } else { $hremailId = array(); } $emailArr = array_merge($manager1, $mngmntemailId, $hremailId); for ($i = 0; $i < sizeof($emailArr); $i++) { $salutation = 'Dear Sir/Madam,'; if ($i == 0) { $salutation = 'Dear ' . ucfirst($reportmanagername) . ','; $options['toName'] = ucfirst($reportmanagername); } else { if ($i == 1) { $salutation = 'Dear Management,'; $options['toName'] = 'Management'; } else { if ($i == 2) { $salutation = 'Dear HR,'; $options['toName'] = 'HR'; } } } $options['subject'] = APPLICATION_NAME . ' :: Background check'; $options['header'] = 'Background check completed'; $options['toEmail'] = $emailArr[$i]; $options['message'] = '<div>' . $salutation . '<div>The background check for ' . ucfirst($username) . ' has been completed.'; if (!empty($personalData[0]['employee_id'])) { $options['message'] .= ' Please find the details below.</div> <div> <table border="1" style="border-collapse:collapse;"> <tr><td>Employee ID</td><td>' . $getAllRecords[0]['employee_id'] . '</td></tr> <tr><td>Employee Email</td><td>' . $getAllRecords[0]['email_id'] . '</td></tr> <tr><td>Employee Designation</td><td>' . $getAllRecords[0]['designation'] . '</td></tr> </table> </div>'; } $options['message'] .= '<div style="padding:20px 0 10px 0;">Please <a href="' . $baseUrl . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the details.</div> </div>'; $options['cron'] = 'yes'; $result = sapp_Global::_sendEmail($options); } /* END */ $updateresult['result'] = 'saved'; $updateresult['popup'] = 'close'; $this->_helper->json($updateresult); } }