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);
}
}
