public function getgroupEmails($sort, $by, $pageNo, $perPage, $searchQuery) { $where = "e.isactive = 1"; if ($searchQuery) { $where .= " AND " . $searchQuery; } if (!sapp_Global::_isactivemodule(RESOURCEREQUISITION)) { $where .= " AND eg.group_code <> 'REQ_HR' AND eg.group_code <> 'REQ_MGMT' "; } if (!sapp_Global::_isactivemodule(BGCHECKS)) { $where .= " AND eg.group_code <> 'BG_CHECKS_HR' AND eg.group_code <> 'BG_CHECKS_MNGMNT' "; } $emailContactsdata = $this->select()->setIntegrityCheck(false)->from(array('e' => 'main_emailcontacts'))->joinInner(array('eg' => 'main_emailgroups'), "eg.id = e.group_id and eg.isactive = 1", array('group_name' => 'eg.group_name'))->joinInner(array('bu' => 'main_businessunits'), "bu.id = e.business_unit_id and bu.isactive = 1", array('unitname' => "if(bu.id = 0,'',bu.unitname)"))->where($where)->order("{$by} {$sort}")->limitPage($pageNo, $perPage); return $emailContactsdata; }
public function save($IdentityCodesform, $redirect_flag = '') { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $date = new Zend_Date(); if ($IdentityCodesform->isValid($this->_request->getPost())) { $IdentityCodesModel = new Default_Model_Identitycodes(); $id = $this->_request->getParam('id'); $employeeCode = $this->_request->getParam('employee_code'); $bgAgencyCode = $this->_request->getParam('bg_code'); $vendorCode = $this->_request->getParam('vendor_code'); $staffingCode = $this->_request->getParam('staffing_code'); $users_code = $this->_request->getParam('users_code'); $requisition_code = $this->_request->getParam('requisition_code'); $data = array('employee_code' => $employeeCode, 'backgroundagency_code' => $bgAgencyCode, 'vendor_code' => $vendorCode, 'staffing_code' => $staffingCode, 'users_code' => $users_code, 'requisition_code' => $requisition_code, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s")); /* Removing the codes which we are not being using for the first phase*/ unset($data['vendor_code']); unset($data['staffing_code']); if (!sapp_Global::_isactivemodule(RESOURCEREQUISITION)) { unset($data['requisition_code']); } if (!sapp_Global::_isactivemodule(BGCHECKS)) { unset($data['backgroundagency_code']); } if ($id != '') { $where = array('id=?' => $id); $actionflag = 2; } else { $data['createdby'] = $loginUserId; $data['createddate'] = gmdate("Y-m-d H:i:s"); $where = ''; $actionflag = 1; } $Id = $IdentityCodesModel->SaveorUpdateIdentitycodesData($data, $where); if ($Id == 'update') { $tableid = $id; if ($redirect_flag == '') { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Identity codes updated successfully.")); } $smessage = "Identity codes updated successfully."; } else { $tableid = $Id; if ($redirect_flag == '') { $this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Identity codes added successfully.")); } $smessage = "Identity codes added successfully."; } $menuID = IDENTITYCODES; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid); if ($redirect_flag == '') { $this->_redirect('identitycodes'); } else { return array('msg' => $smessage); } } else { $messages = $IdentityCodesform->getMessages(); foreach ($messages as $key => $val) { foreach ($val as $key2 => $val2) { $msgarray[$key] = $val2; break; } } return $msgarray; } }
public function viewAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $idData = $this->getRequest()->getParam('id'); $empscreeningform = new Default_Form_empscreening(); $empscreeningModel = new Default_Model_Empscreening(); $processData = array(); $idArr = array(); $idArr = explode('-', $idData); if (sizeof($idArr) > 1) { $id = intVal($idArr[0]); $userflag = intVal($idArr[1]); $idData = $id . '-' . $userflag; } else { $id = ''; $userflag = ''; $idData = ''; } if ($userflag == 2) { $flag = 'cand'; } else { $flag = 'emp'; } if ($userflag == 1 || $userflag == 2 && sapp_Global::_isactivemodule(RESOURCEREQUISITION)) { if ($id && $id != $loginUserId) { $data = $empscreeningModel->getsingleEmpscreeningData($id, $userflag); if (!empty($data) && $data != 'norows') { $empscreeningform->setAttrib('action', BASE_URL . 'empscreening/edit/id/' . $idData); $empscreeningform->removeElement("employee"); $empscreeningform->removeElement("checktype"); $empscreeningform->removeElement("checkagency"); $empscreeningform->populate($data); $elements = $empscreeningform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } $specimenId = $data['specimen_id']; $empData = array(); if (isset($specimenId) && isset($flag)) { $personalData = $empscreeningModel->getEmpPersonalData($specimenId, $flag); $addressData = $empscreeningModel->getEmpAddressData($specimenId, $flag); $companyData = $empscreeningModel->getEmpCompanyData($specimenId, $flag); } $this->view->personalData = $personalData; $this->view->addressData = $addressData; $this->view->companyData = $companyData; $this->view->ermsg = ''; if ($idData != '') { $processData = $this->processesGrid($idData, $personalData[0]['ustatus']); } $this->view->dataArray = $processData; $this->view->form = $empscreeningform; } else { $this->view->ermsg = 'nodata'; } } else { $this->view->ermsg = 'nodata'; } } else { $this->view->ermsg = 'nodata'; } }
public function viewAction() { $id = abs(intval($this->getRequest()->getParam('id'))); $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $emailContactsform = new Default_Form_emailcontacts(); $emailContactsModel = new Default_Model_Emailcontacts(); if ($id && $id > 0) { try { $data = $emailContactsModel->getdataforview($id); if (count($data) > 0) { if (sapp_Global::_isactivemodule(RESOURCEREQUISITION) && ($data['group_code'] == 'REQ_HR' || $data['group_code'] == 'REQ_MGMT') || sapp_Global::_isactivemodule(BGCHECKS) && ($data['group_code'] == 'BG_CHECKS_HR' || $data['group_code'] == 'BG_CHECKS_MNGMNT')) { $emailContactsform->setDefault("id", $id); $emailContactsform->setDefault("groupEmail", $data["groupEmail"]); $emailContactsform->group_id->addMultiOptions(array('' => $data['group_name'])); $emailContactsform->business_unit_id->addMultiOptions(array('' => $data['unitname'])); $emailContactsform->group_id->setAttrib('disabled', 'disabled'); $emailContactsform->groupEmail->setAttrib('disabled', 'disabled'); $emailContactsform->business_unit_id->setAttrib('disabled', 'disabled'); $this->view->emailContactsData = $data; } else { $this->view->nodata = "nodata"; } } else { $this->view->nodata = "nodata"; } } catch (Exception $e) { $this->view->nodata = "nodata"; } } else { $this->view->nodata = "nodata"; } $this->view->form = $emailContactsform; $this->view->id = $id; $this->view->controllername = "emailcontacts"; }