public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$messages['flagtype'] = '';
$actionflag = 3;
if ($id) {
$payfrequencymodel = new Default_Model_Payfrequency();
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$pay_data = $payfrequencymodel->getsinglePayfrequencyData($id);
$Id = $payfrequencymodel->SaveorUpdatePayFrequencyData($data, $where);
if ($Id == 'update') {
sapp_Global::send_configuration_mail("Pay Frequency", $pay_data[0]['freqtype']);
$menuID = PAYFREQUENCY;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Pay frequency deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Pay frequency Status cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Pay frequency cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function comsave($empcommdetailsform, $userid)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$perm_country = $this->_request->getParam('perm_country');
$perm_stateparam = $this->_request->getParam('perm_state');
$perm_stateArr = explode("!@#", $this->_request->getParam('perm_state'));
$perm_state = $perm_stateArr[0];
$perm_cityparam = $this->_request->getParam('perm_city');
$perm_cityArr = explode("!@#", $this->_request->getParam('perm_city'));
$perm_city = $perm_cityArr[0];
$address_flag = $this->_request->getParam('address_flag');
$current_country = $this->_request->getParam('current_country');
$current_stateparam = $this->_request->getParam('current_state');
$current_stateArr = explode("!@#", $this->_request->getParam('current_state'));
$current_state = $current_stateArr[0];
$current_cityparam = $this->_request->getParam('current_city');
$current_cityArr = explode("!@#", $this->_request->getParam('current_city'));
$current_city = $current_cityArr[0];
if ($empcommdetailsform->isValid($this->_request->getPost())) {
$post_values = $this->_request->getPost();
if (isset($post_values['id'])) {
unset($post_values['id']);
}
if (isset($post_values['user_id'])) {
unset($post_values['user_id']);
}
if (isset($post_values['submit'])) {
unset($post_values['submit']);
}
$new_post_values = array_filter($post_values);
if (!empty($new_post_values)) {
$empcommdetailsModal = new Default_Model_Empcommunicationdetails();
$id = $this->_request->getParam('id');
$user_id = $userid;
$personalemail = $this->_request->getParam('personalemail');
$perm_streetaddress = $this->_request->getParam('perm_streetaddress');
$perm_pincode = $this->_request->getParam('perm_pincode');
$current_streetaddress = $this->_request->getParam('current_streetaddress');
$current_pincode = $this->_request->getParam('current_pincode');
$emergency_number = $this->_request->getParam('emergency_number');
$emergency_name = $this->_request->getParam('emergency_name');
$emergency_email = $this->_request->getParam('emergency_email');
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('user_id' => $user_id, 'personalemail' => $personalemail, 'perm_streetaddress' => $perm_streetaddress, 'perm_country' => $perm_country != '' ? $perm_country : NULL, 'perm_state' => $perm_state != '' ? $perm_state : NULL, 'perm_city' => $perm_city != '' ? $perm_city : NULL, 'perm_pincode' => $perm_pincode, 'current_streetaddress' => $current_streetaddress != '' ? $current_streetaddress : NULL, 'current_country' => $current_country != '' ? $current_country : NULL, 'current_state' => $current_state != '' ? $current_state : NULL, 'current_city' => $current_city != '' ? $current_city : NULL, 'current_pincode' => $current_pincode != '' ? $current_pincode : NULL, 'emergency_number' => $emergency_number != '' ? $emergency_number : NULL, 'emergency_name' => $emergency_name != '' ? $emergency_name : NULL, 'emergency_email' => $emergency_email != '' ? $emergency_email : NULL, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('user_id=?' => $user_id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
}
$Id = $empcommdetailsModal->SaveorUpdateEmpcommData($data, $where);
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee contact details updated successfully."));
} else {
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee contact details added successfully."));
}
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => FIELDMSG));
}
$this->_redirect('myemployees/comedit/userid/' . $userid);
} else {
$messages = $empcommdetailsform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
if (isset($perm_country) && $perm_country != 0 && $perm_country != '') {
$statesmodel = new Default_Model_States();
$statesmodeldata = $statesmodel->getStatesList($perm_country);
$empcommdetailsform->perm_state->clearMultiOptions();
$empcommdetailsform->perm_city->clearMultiOptions();
$empcommdetailsform->perm_state->addMultiOption('', 'Select State');
foreach ($statesmodeldata as $res) {
$empcommdetailsform->perm_state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name']));
}
if (isset($perm_stateparam) && $perm_stateparam != 0 && $perm_stateparam != '') {
$empcommdetailsform->setDefault('perm_state', $perm_stateparam);
}
}
if (isset($perm_stateparam) && $perm_stateparam != 0 && $perm_stateparam != '') {
$citiesmodel = new Default_Model_Cities();
$citiesmodeldata = $citiesmodel->getCitiesList($perm_state);
$empcommdetailsform->perm_city->addMultiOption('', 'Select City');
foreach ($citiesmodeldata as $res) {
$empcommdetailsform->perm_city->addMultiOption($res['id'] . '!@#' . utf8_encode($res['city_name']), utf8_encode($res['city_name']));
}
if (isset($perm_cityparam) && $perm_cityparam != 0 && $perm_cityparam != '') {
$empcommdetailsform->setDefault('perm_city', $perm_cityparam);
}
}
if (isset($current_country) && $current_country != 0 && $current_country != '') {
$statesmodel = new Default_Model_States();
$statesmodeldata = $statesmodel->getStatesList($current_country);
$empcommdetailsform->current_state->addMultiOption('', 'Select State');
foreach ($statesmodeldata as $res) {
$empcommdetailsform->current_state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name']));
}
if (isset($current_stateparam) && $current_stateparam != 0 && $current_stateparam != '') {
$empcommdetailsform->setDefault('current_state', $current_stateparam);
}
}
if (isset($current_stateparam) && $current_stateparam != 0 && $current_stateparam != '') {
$citiesmodel = new Default_Model_Cities();
$citiesmodeldata = $citiesmodel->getCitiesList($current_state);
$empcommdetailsform->current_city->addMultiOption('', 'Select City');
foreach ($citiesmodeldata as $res) {
$empcommdetailsform->current_city->addMultiOption($res['id'] . '!@#' . utf8_encode($res['city_name']), utf8_encode($res['city_name']));
}
if (isset($current_cityparam) && $current_cityparam != 0 && $current_cityparam != '') {
$empcommdetailsform->setDefault('current_city', $current_cityparam);
}
}
return $msgarray;
}
}
public function saveorginfo($form, $loginUserId, $wizardData)
{
$orgInfoModel = new Default_Model_Organisationinfo();
$wizard_model = new Default_Model_Wizard();
$id = $this->getRequest()->getParam('id');
$imagerror = $this->_request->getParam('imgerr');
$imagepath = $this->_request->getParam('org_image_value');
$imgerrmsg = $this->_request->getParam('imgerrmsg');
$pphnumber = $this->_request->getParam('phonenumber');
$sphnumber = $this->_request->getParam('secondaryphone');
$org_startdate = sapp_Global::change_date($this->_request->getParam('org_startdate'), 'database');
$flag = 'true';
if (isset($imagepath) && $imagepath != '') {
$imageArr = explode('.', $imagepath);
if (sizeof($imageArr) > 1) {
$imagename = $imageArr[0];
$imageext = $imageArr[1];
$extArr = array('gif', 'jpg', 'jpeg', 'png');
if (!in_array($imageext, $extArr)) {
$msgarray['org_image_value'] = 'Please upload an appropriate image file.';
$flag = 'false';
}
} else {
$msgarray['org_image_value'] = 'Please upload an appropriate image file.';
$flag = 'false';
}
}
if ($imagerror == 'error') {
if ($imgerrmsg != '' && $imgerrmsg != 'undefined') {
$msgarray['org_image_value'] = $imgerrmsg;
} else {
$msgarray['org_image_value'] = 'Please upload an appropriate image file.';
}
$flag = 'false';
}
if ($pphnumber == $sphnumber && $sphnumber != '' && $pphnumber != '') {
$msgarray['secondaryphone'] = 'Please enter different phone number.';
$flag = 'false';
}
if ($form->isValid($this->_request->getPost()) && $flag != 'false') {
$domain = $this->_request->getParam('domain');
$domain = implode(',', $domain);
$date = new Zend_Date();
$data = array('organisationname' => trim($this->_request->getParam('organisationname')), 'domain' => trim($domain), 'website' => trim($this->_request->getParam('website')), 'org_image' => $imagepath, 'orgdescription' => trim($this->_request->getParam('orgdescription')), 'totalemployees' => trim($this->_request->getParam('totalemployees')), 'org_startdate' => $org_startdate != '' ? $org_startdate : NULL, 'phonenumber' => trim($this->_request->getParam('phonenumber')), 'secondaryphone' => trim($this->_request->getParam('secondaryphone')), 'faxnumber' => trim($this->_request->getParam('faxnumber')), 'country' => trim((int) $this->_request->getParam('country')), 'state' => trim(intval($this->_request->getParam('state'))), 'city' => trim(intval($this->_request->getParam('city'))), 'address1' => trim($this->_request->getParam('address1')), 'address2' => trim($this->_request->getParam('address2')), 'address3' => trim($this->_request->getParam('address3')), 'description' => trim($this->_request->getParam('description')), 'designation' => trim($this->_request->getParam('jobtitle_id', null)), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$db = Zend_Db_Table::getDefaultAdapter();
$db->beginTransaction();
try {
$path = IMAGE_UPLOAD_PATH;
$imagepath = $this->_request->getParam('org_image_value');
$filecopy = 'success';
if ($imagepath != '') {
$filecopy = 'error';
if (file_exists(USER_PREVIEW_UPLOAD_PATH . '//' . $imagepath)) {
try {
if (copy(USER_PREVIEW_UPLOAD_PATH . '//' . $imagepath, $path . '//' . $imagepath)) {
$filecopy = 'success';
}
unlink(USER_PREVIEW_UPLOAD_PATH . '//' . $imagepath);
} catch (Exception $e) {
echo $msgarray['org_image_value'] = $e->getMessage();
exit;
}
}
}
$where = array('id=?' => $id);
if ($imagepath == '') {
unset($data['org_image']);
} else {
if ($filecopy == 'error') {
unset($data['org_image']);
}
}
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 = $orgInfoModel->SaveorUpdateData($data, $where);
$menuID = ORGANISATIONINFO;
try {
if ($Id != '' && $Id != 'update') {
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $Id);
} else {
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
}
} catch (Exception $e) {
echo $e->getMessage();
}
$wizardarray = array('org_details' => 2, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($wizardData['site_config'] == 2) {
$wizardarray['iscomplete'] = 2;
}
$wizard_model->SaveorUpdateWizardData($wizardarray, '');
$location_data = array('country' => trim((int) $this->_request->getParam('country')), 'state' => trim(intval($this->_request->getParam('state'))), 'city' => trim(intval($this->_request->getParam('city'))), 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$LocationId = $wizard_model->SaveorUpdateWizardData($location_data, '');
$db->commit();
if ($filecopy == 'success') {
$this->_helper->getHelper("FlashMessenger")->addMessage("Organization information saved successfully.");
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage("Organization information saved successfully but failed to upload the logo.");
}
$this->_redirect('wizard/configureorganisation');
} catch (Exception $e) {
$db->rollBack();
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong,please try again later."));
$this->_redirect('wizard/configureorganisation');
}
} else {
$messages = $form->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
//echo '<pre>';print_r($messages);exit;
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) {
$systempreferencemodel = new Default_Model_Sitepreference();
$menumodel = new Default_Model_Menu();
$data = array('isactive' => 0);
$where = array('id=?' => $id);
$Id = $systempreferencemodel->SaveorUpdateSystemPreferanceData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/sitepreference');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Site preferences deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Site preferences cannot be deleted.';
}
$messages['msgtype'] = 'error';
} else {
$messages['message'] = 'Site preferences cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function updatecontactnumberAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('id');
$contactnumber = $this->_request->getParam('contactnumber');
$messages['message'] = '';
$actionflag = 2;
if ($id) {
$usersModal = new Default_Model_Users();
$menumodel = new Default_Model_Menu();
$data = array('contactnumber' => $contactnumber);
$where = array('id=?' => $id);
$Id = $usersModal->addOrUpdateUserModel($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Contact number updated successfully.';
} else {
$messages['message'] = 'Contact number cannot be updated.';
}
} else {
$messages['message'] = 'Contact number cannot be updated.';
}
$this->_helper->json($messages);
}
public function save($empleavesform, $userid, $used_leaves, $leavetransfercount, $isleavetrasnferset, $currentyearleavecount)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
if ($empleavesform->isValid($this->_request->getPost())) {
$employeeleavesModel = new Default_Model_Employeeleaves();
$id = $this->_request->getParam('id');
$user_id = $userid;
$emp_leave_limit = $this->_request->getParam('leave_limit');
if ($leavetransfercount != '' && $currentyearleavecount == '') {
$emp_leave_limit = $emp_leave_limit + $leavetransfercount;
} else {
$emp_leave_limit = $emp_leave_limit + $currentyearleavecount;
}
$isleavetrasnfer = 0;
if ($isleavetrasnferset == 1) {
$isleavetrasnfer = 1;
}
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
/* Save employee leaves in allotted leaves log */
$postedArr = array();
$postedArr = $_POST;
$saveID = $employeeleavesModel->saveallotedleaves($postedArr, $emp_leave_limit, $user_id, $loginUserId);
/* END */
$Id = $employeeleavesModel->SaveorUpdateEmployeeLeaves($user_id, $emp_leave_limit, $isleavetrasnfer, $loginUserId);
if ($id) {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee Leave details updated successfully."));
$actionflag = 2;
$tableid = $id;
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee Leave details added successfully."));
$actionflag = 1;
$tableid = $Id;
}
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
$this->_redirect('empleaves/edit/userid/' . $user_id);
} else {
$messages = $empleavesform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
return $msgarray;
}
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$actionflag = 3;
if ($id) {
$leavemanagementmodel = new Default_Model_Leavemanagement();
$menumodel = new Default_Model_Menu();
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$Id = $leavemanagementmodel->SaveorUpdateLeaveManagementData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/leavemanagement');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Leave management deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Leave management cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Leave management cannot be deleted.';
$messages['msgtype'] = 'succerroress';
}
$this->_helper->json($messages);
}
public function updateempdetails($employeeform)
{
$emproleStr = '';
$roleArr = array();
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$usersModel = new Default_Model_Usermanagement();
$employeeModal = new Default_Model_Employee();
$businessunit_id = $this->_request->getParam('businessunit_id', null);
$department_id = $this->_request->getParam('department_id', null);
$reporting_manager = $this->_request->getParam('reporting_manager', null);
$jobtitle_id = $this->_request->getParam('jobtitle_id', null);
$position_id = $this->_request->getParam('position_id', null);
$user_id = $this->_getParam('user_id', null);
$prefix_id = $this->_getParam('prefix_id', null);
$extension_number = $this->_getParam('extension_number', null);
if ($employeeform->isValid($this->_request->getPost())) {
$id = $this->_request->getParam('id');
$emp_status_id = $this->_request->getParam('emp_status_id', null);
$date_of_joining = $this->_request->getParam('date_of_joining', null);
$date_of_joining = sapp_Global::change_date($date_of_joining, 'database');
$date_of_leaving = $this->_request->getParam('date_of_leaving', null);
$date_of_leaving = sapp_Global::change_date($date_of_leaving, 'database');
$years_exp = $this->_request->getParam('years_exp');
//FOR USER table
$employeeId = $this->_getParam('employeeId', null);
$modeofentry = $this->_getParam('modeofentry', null);
$hid_modeofentry = $this->_getParam('hid_modeofentry', null);
$other_modeofentry = $this->_getParam('other_modeofentry', null);
$userfullname = $this->_getParam('userfullname', null);
$candidatereferredby = $this->_getParam('candidatereferredby', null);
$rccandidatename = $this->_getParam('rccandidatename', null);
$emprole = $this->_getParam('emprole', null);
//roleid_group_id
if ($emprole != "") {
$roleArr = explode('_', $emprole);
if (!empty($roleArr)) {
$emproleStr = $roleArr[0];
}
}
$emailaddress = $this->_getParam('emailaddress', null);
$tmp_name = $this->_request->getParam('tmp_emp_name', null);
$act_inact = $this->_request->getParam("act_inact", null);
//end of user table
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$empstatusarray = array(8, 9, 10);
$actionflag = '';
$tableid = '';
if ($modeofentry == 'Direct' || $hid_modeofentry == 'Direct') {
$candidate_key = 'userfullname';
$candidate_value = $userfullname;
$emp_name = $userfullname;
$candidate_flag = 'no';
} else {
$candidate_key = 'rccandidatename';
$candidate_value = $rccandidatename;
$emp_name = $tmp_name;
$candidate_flag = 'yes';
}
$trDb = Zend_Db_Table::getDefaultAdapter();
// starting transaction
$trDb->beginTransaction();
try {
$emppassword = sapp_Global::generatePassword();
$user_data = array('emprole' => $emproleStr, $candidate_key => $candidate_value, 'emailaddress' => $emailaddress, 'modifiedby' => $loginUserId, 'modifieddate' => Zend_Registry::get('currentdate'), 'emppassword' => md5($emppassword), 'employeeId' => $employeeId, 'modeofentry' => $id == '' ? $modeofentry : "", 'selecteddate' => $date_of_joining, 'candidatereferredby' => $candidatereferredby, 'userstatus' => 'old', 'other_modeofentry' => $other_modeofentry);
if ($id != '') {
$where = array('user_id=?' => $user_id);
$actionflag = 2;
$user_where = "id = " . $user_id;
unset($user_data['candidatereferredby']);
unset($user_data['userstatus']);
unset($user_data['emppassword']);
unset($user_data['employeeId']);
unset($user_data['modeofentry']);
unset($user_data['other_modeofentry']);
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$user_data['createdby'] = $loginUserId;
$user_data['createddate'] = gmdate("Y-m-d H:i:s");
$user_data['isactive'] = 1;
if ($modeofentry != 'Direct') {
$user_data['userfullname'] = $emp_name;
}
$where = '';
$actionflag = 1;
$user_where = '';
}
$user_status = $usersModel->SaveorUpdateUserData($user_data, $user_where);
if ($id == '') {
$user_id = $user_status;
}
$data = array('user_id' => $user_id, 'reporting_manager' => $reporting_manager, 'emp_status_id' => $emp_status_id, 'businessunit_id' => $businessunit_id, 'department_id' => $department_id, 'jobtitle_id' => $jobtitle_id, 'position_id' => $position_id, 'prefix_id' => $prefix_id, 'extension_number' => $extension_number, 'date_of_joining' => $date_of_joining, 'date_of_leaving' => $date_of_leaving != '' ? $date_of_leaving : NULL, 'years_exp' => $years_exp == '' ? null : $years_exp, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$Id = $employeeModal->SaveorUpdateEmployeeData($data, $where);
$statuswhere = array('id=?' => $user_id);
if (in_array($emp_status_id, $empstatusarray)) {
$isactivestatus = '';
if ($emp_status_id == 8) {
$isactivestatus = 2;
} else {
if ($emp_status_id == 9) {
$isactivestatus = 3;
} else {
if ($emp_status_id == 10) {
$isactivestatus = 4;
}
}
}
$statusdata = array('isactive' => $isactivestatus);
$empstatusId = $usersModel->SaveorUpdateUserData($statusdata, $statuswhere);
} else {
$statusdata = array('isactive' => 1);
$empstatusId = $usersModel->SaveorUpdateUserData($statusdata, $statuswhere);
}
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee details updated successfully."));
} else {
//start of mailing
$base_url = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl();
$view = $this->getHelper('ViewRenderer')->view;
$this->view->emp_name = $emp_name;
$this->view->password = $emppassword;
$this->view->emp_id = $employeeId;
$this->view->base_url = $base_url;
$text = $view->render('mailtemplates/newpassword.phtml');
$options['subject'] = APPLICATION_NAME . ' login credentials';
$options['header'] = 'Greetings from Sentrifugo';
$options['toEmail'] = $emailaddress;
$options['toName'] = $this->view->emp_name;
$options['message'] = $text;
$result = sapp_Global::_sendEmail($options);
//end of mailing
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee details added successfully."));
}
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$menuidArr = $menumodel->getMenuObjID('/usermanagement');
$menuID_user = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
if ($act_inact == 1) {
if ($user_data['isactive'] == 1) {
$act_str = array("Activated" => Zend_Registry::get('currentdate'));
} else {
$act_str = array("Inactivated" => Zend_Registry::get('currentdate'));
}
$result = sapp_Global::logManager($menuID_user, 4, $loginUserId, $user_id, '', $act_str);
}
$trDb->commit();
$this->_redirect('employee/edit/id/' . $user_id);
} catch (Exception $e) {
$trDb->rollBack();
$msgarray['employeeId'] = "Something went wrong,please try again later.";
return $msgarray;
}
} else {
$messages = $employeeform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
$usersModel = new Default_Model_Users();
if (isset($businessunit_id) && $businessunit_id != 0 && $businessunit_id != '') {
$departmentsmodel = new Default_Model_Departments();
$departmentlistArr = $departmentsmodel->getDepartmentList($businessunit_id);
$employeeform->department_id->clearMultiOptions();
$employeeform->reporting_manager->clearMultiOptions();
$employeeform->department_id->addMultiOption('', 'Select Department');
foreach ($departmentlistArr as $departmentlistresult) {
$employeeform->department_id->addMultiOption($departmentlistresult['id'], utf8_encode($departmentlistresult['deptname']));
}
if (isset($department_id) && $department_id != 0 && $department_id != '') {
$employeeform->setDefault('department_id', $department_id);
}
}
if (isset($department_id) && $department_id != 0 && $department_id != '') {
$reportingManagerArr = $usersModel->getReportingManagerList($department_id, $user_id);
$employeeform->reporting_manager->addMultiOption('', 'Select Reporting Manager');
foreach ($reportingManagerArr as $reportingManagerresult) {
$employeeform->reporting_manager->addMultiOption($reportingManagerresult['id'], utf8_encode($reportingManagerresult['userfullname']));
}
if (isset($reporting_manager) && $reporting_manager != 0 && $reporting_manager != '') {
$employeeform->setDefault('reporting_manager', $reporting_manager);
}
}
if (isset($jobtitle_id) && $jobtitle_id != 0 && $jobtitle_id != '') {
$positionsmodel = new Default_Model_Positions();
$positionlistArr = $positionsmodel->getPositionList($jobtitle_id);
$employeeform->position_id->clearMultiOptions();
$employeeform->position_id->addMultiOption('', 'Select Position');
foreach ($positionlistArr as $positionlistRes) {
$employeeform->position_id->addMultiOption($positionlistRes['id'], utf8_encode($positionlistRes['positionname']));
}
if (isset($position_id) && $position_id != 0 && $position_id != '') {
$employeeform->setDefault('position_id', $position_id);
}
}
return $msgarray;
}
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$messages['flagtype'] = '';
$actionflag = 3;
if ($id) {
$empadditionaldetailsModal = new Default_Model_Empadditionaldetails();
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$Id = $empadditionaldetailsModal->SaveorUpdateEmpAdditionalData($data, $where);
if ($Id == 'update') {
$menuID = EMPLOYEE;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Employee additional details deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Employee additional details cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Employee additional details cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$actionflag = 3;
if ($id) {
$currencyconvertermodel = new Default_Model_Currencyconverter();
$currencyconverterdata = $currencyconvertermodel->getCurrencyConverterDatabyID($id);
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$Id = $currencyconvertermodel->SaveorUpdateCurrencyConverterData($data, $where);
if ($Id == 'update') {
$menuID = CURRENCYCONVERTER;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$configmail = sapp_Global::send_configuration_mail('Base Currency', $currencyconverterdata[0]['basecurrtext']);
$messages['message'] = 'Currency converter deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Currency converter cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Currency converter cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$actionflag = 3;
if ($id) {
$numberformatsmodel = new Default_Model_Numberformats();
$menumodel = new Default_Model_Menu();
$numberformatdata = $numberformatsmodel->getNumberFormatDataByID($id);
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$Id = $numberformatsmodel->SaveorUpdateNumberFormatData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/numberformats');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$configmail = sapp_Global::send_configuration_mail('Number Format', $numberformatdata[0]['numberformattype']);
$messages['message'] = 'Number format deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Number format cannot be deleted.';
$messages['msgtype'] = 'success';
}
} else {
$messages['message'] = 'Number format cannot be deleted.';
$messages['msgtype'] = 'success';
}
$this->_helper->json($messages);
}
public function savegroupedemployees()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$appraisalinitmodel = new Default_Model_Appraisalgroupemployeestemp();
$menumodel = new Default_Model_Menu();
$groupid = $this->_request->getParam('group_id');
$appraisalid = $this->_request->getParam('appraisalid');
$empids = $this->_request->getParam('empids');
$id = '';
$actionflag = '';
$tableid = '';
$msgarray = array();
if (!isset($groupid) && $groupid == '') {
$groupid = 0;
}
try {
$ifrecordexists = $appraisalinitmodel->checkAppraisalRecordexists($groupid, $appraisalid);
if (!empty($ifrecordexists)) {
$id = $ifrecordexists[0]['id'];
}
$insertdata = array('pa_initialization_id' => $appraisalid, 'group_id' => $groupid, 'employee_ids' => $empids, 'isactive' => 1, 'createdby' => $loginUserId, 'createdby_role' => $loginuserRole, 'createdby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$updatedata = array('employee_ids' => $empids, 'modifiedby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('id=?' => $id);
$actionflag = 2;
$tableid = $id;
$appraisalinitmodel->SaveorUpdateAppraisalGroupsEmployeesTempData($updatedata, $where);
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employees updated successfully."));
} else {
$where = '';
$actionflag = 1;
$Id = $appraisalinitmodel->SaveorUpdateAppraisalGroupsEmployeesTempData($insertdata, $where);
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employees added successfully."));
}
$menuidArr = $menumodel->getMenuObjID('/appraisalinit');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$this->_redirect('appraisalinit/assigngroups/id/' . $appraisalid);
} catch (Exception $e) {
$msgarray = $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => $e->getMessage()));
}
return $msgarray;
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginUserEmail = $auth->getStorage()->read()->emailaddress;
$loginUserName = $auth->getStorage()->read()->userfullname;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$actionflag = 5;
$businessunitid = '';
$leavetypetext = '';
if ($id) {
$leaverequestmodel = new Default_Model_Leaverequest();
$usersmodel = new Default_Model_Users();
$employeesmodel = new Default_Model_Employees();
$employeeleavetypesmodel = new Default_Model_Employeeleavetypes();
$loggedInEmployeeDetails = $employeesmodel->getLoggedInEmployeeDetails($loginUserId);
if ($loggedInEmployeeDetails[0]['businessunit_id'] != '') {
$businessunitid = $loggedInEmployeeDetails[0]['businessunit_id'];
}
$dataarr = array('leavestatus' => 4, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => $loginUserId);
$where = array('id=?' => $id);
$Id = $leaverequestmodel->SaveorUpdateLeaveRequest($dataarr, $where);
$data = $leaverequestmodel->getsinglePendingLeavesData($id);
$data = $data[0];
$appliedleavesdaycount = $data['appliedleavescount'];
$to_date = $data['to_date'];
$from_date = $data['from_date'];
$reason = $data['reason'];
$leavetypeid = $data['leavetypeid'];
$repmngrnameArr = $usersmodel->getUserDetailsByID($data['rep_mang_id']);
$reportingmanageremail = $repmngrnameArr[0]['emailaddress'];
$reportingmanagername = $repmngrnameArr[0]['userfullname'];
if ($Id == 'update') {
$menuID = PENDINGLEAVES;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
/** MAILING CODE **/
if ($to_date == '' || $to_date == NULL) {
$to_date = $from_date;
}
/* Mail to Employee */
$options['subject'] = 'Leave request cancelled';
$options['header'] = 'Leave Request';
$options['toEmail'] = $loginUserEmail;
$options['toName'] = $loginUserName;
$options['message'] = '<div>Hi,</div>
<div>The below leave(s) has been cancelled.</div>
<div>
<table width="100%" cellspacing="0" cellpadding="15" border="0" style="border:3px solid #BBBBBB; font-size:16px; font-family:Arial, Helvetica, sans-serif; margin:30px 0 30px 0;" bgcolor="#ffffff">
<tbody><tr>
<td width="28%" style="border-right:2px solid #BBBBBB;">Employee Name</td>
<td width="72%">' . $loginUserName . '</td>
</tr>
<tr bgcolor="#e9f6fc">
<td style="border-right:2px solid #BBBBBB;">No. of Day(s)</td>
<td>' . $appliedleavesdaycount . '</td>
</tr>
<tr>
<td style="border-right:2px solid #BBBBBB;">From</td>
<td>' . $from_date . '</td>
</tr>
<tr bgcolor="#e9f6fc">
<td style="border-right:2px solid #BBBBBB;">To</td>
<td>' . $to_date . '</td>
</tr>
<tr bgcolor="#e9f6fc">
<td style="border-right:2px solid #BBBBBB;">Reason for Leave</td>
<td>' . $reason . '</td>
</tr>
</tbody></table>
</div>
<div style="padding:20px 0 10px 0;">Please <a href="' . BASE_URL . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the leave details.</div>';
$result = sapp_Global::_sendEmail($options);
/* End */
/* Mail to Reporting Manager */
$options['subject'] = 'Leave request cancelled';
$options['header'] = 'Leave Request';
$options['toEmail'] = $reportingmanageremail;
$options['toName'] = $reportingmanagername;
$options['message'] = '<div>Hi,</div>
<div>The below leave(s) has been cancelled.</div>
<div>
<table width="100%" cellspacing="0" cellpadding="15" border="0" style="border:3px solid #BBBBBB; font-size:16px; font-family:Arial, Helvetica, sans-serif; margin:30px 0 30px 0;" bgcolor="#ffffff">
<tbody><tr>
<td width="28%" style="border-right:2px solid #BBBBBB;">Employee Name</td>
<td width="72%">' . $loginUserName . '</td>
</tr>
<tr bgcolor="#e9f6fc">
<td style="border-right:2px solid #BBBBBB;">No. of Day(s)</td>
<td>' . $appliedleavesdaycount . '</td>
</tr>
<tr>
<td style="border-right:2px solid #BBBBBB;">From</td>
<td>' . $from_date . '</td>
</tr>
<tr bgcolor="#e9f6fc">
<td style="border-right:2px solid #BBBBBB;">To</td>
<td>' . $to_date . '</td>
</tr>
<tr bgcolor="#e9f6fc">
<td style="border-right:2px solid #BBBBBB;">Reason for Leave</td>
<td>' . $reason . '</td>
</tr>
</tbody></table>
</div>
<div style="padding:20px 0 10px 0;">Please <a href="' . BASE_URL . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the leave details.</div>';
$result = sapp_Global::_sendEmail($options);
/* End */
/* Mail to HR */
if (defined('LV_HR_' . $businessunitid) && $businessunitid != '') {
$options['subject'] = 'Leave request cancelled';
$options['header'] = 'Leave Request';
$options['toEmail'] = constant('LV_HR_' . $businessunitid);
$options['toName'] = 'Leave management';
$options['message'] = '<div>Hi,</div>
<div>The below leave(s) has been cancelled by the Employee.</div>
<div>
<table width="100%" cellspacing="0" cellpadding="15" border="0" style="border:3px solid #BBBBBB; font-size:16px; font-family:Arial, Helvetica, sans-serif; margin:30px 0 30px 0;" bgcolor="#ffffff">
<tbody><tr>
<td width="28%" style="border-right:2px solid #BBBBBB;">Employee Name</td>
<td width="72%">' . $loginUserName . '</td>
</tr>
<tr bgcolor="#e9f6fc">
<td style="border-right:2px solid #BBBBBB;">No. of Day(s)</td>
<td>' . $appliedleavesdaycount . '</td>
</tr>
<tr>
<td style="border-right:2px solid #BBBBBB;">From</td>
<td>' . $from_date . '</td>
</tr>
<tr bgcolor="#e9f6fc">
<td style="border-right:2px solid #BBBBBB;">To</td>
<td>' . $to_date . '</td>
</tr>
<tr bgcolor="#e9f6fc">
<td style="border-right:2px solid #BBBBBB;">Reason for Leave</td>
<td>' . $reason . '</td>
</tr>
</tbody></table>
</div>
<div style="padding:20px 0 10px 0;">Please <a href="' . BASE_URL . '/index/popup" target="_blank" style="color:#b3512f;">click here</a> to login and check the leave details.</div>';
$options['cron'] = 'yes';
$result = sapp_Global::_sendEmail($options);
}
$messages['message'] = 'Leave request cancelled';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Leave request cannot be cancelled';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Leave request cannot be cancelled';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$count = 0;
$actionflag = 3;
if ($id) {
$appraisalquestionsmodel = new Default_Model_Appraisalquestions();
$menumodel = new Default_Model_Menu();
$appraisalquestionsdata = $appraisalquestionsmodel->getAppraisalQuestionbyID($id);
if ($appraisalquestionsdata[0]['isused'] == 0) {
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"), 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifiedby' => $loginUserId);
$where = array('id=?' => $id);
$Id = $appraisalquestionsmodel->SaveorUpdateAppraisalQuestionData($data, $where);
if ($Id == 'update') {
$menuidArr = $menumodel->getMenuObjID('/appraisalquestions');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$configmail = sapp_Global::send_configuration_mail('Question', $appraisalquestionsdata[0]['question']);
$messages['message'] = 'Question deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Question cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Question cannot be deleted as its using in appraisal process.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Question cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function savepopupAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$feedforwardquestionsmodel = new Default_Model_Feedforwardquestions();
$msgarray = array();
$result['msg'] = '';
$result['id'] = '';
$result['question'] = '';
$result['description'] = '';
try {
$question = trim($this->_request->getParam('question'));
$description = trim($this->_request->getParam('description'));
$actionflag = '';
$data = array('question' => $question, 'description' => $description != '' ? $description : NULL, 'module_flag' => 2, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$data['createdby_role'] = $loginuserRole;
$data['createdby_group'] = $loginuserGroup;
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
$Id = $feedforwardquestionsmodel->SaveorUpdateFeedforwardQuestionData($data, $where);
$menuID = FEEDFORWARDQUESTIONS;
sapp_Global::logManager($menuID, $actionflag, $loginUserId, $Id);
$result['msg'] = 'success';
$result['id'] = $Id;
$result['question'] = $question;
$result['description'] = $description;
} catch (Exception $e) {
$result['msg'] = $e->getMessage();
$result['id'] = '';
$result['question'] = '';
$result['description'] = '';
}
$this->_helper->json($result);
}
public function savequestionpopupAction()
{
$ajaxContext = $this->_helper->getHelper('AjaxContext');
$ajaxContext->addActionContext('savequestionpopup', 'json')->initContext();
$this->_helper->layout->disableLayout();
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$appraisalquestionsmodel = new Default_Model_Appraisalquestions();
$result['result'] = '';
$result['id'] = '';
$result['question'] = '';
$result['description'] = '';
try {
$categoryval = $this->_request->getParam('categoryval');
$questionval = urldecode($this->_request->getParam('questionval'));
$description = trim($this->_request->getParam('description'));
$moduleflag = trim($this->_request->getParam('moduleflag'));
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('pa_category_id' => $categoryval, 'question' => $questionval, 'description' => $description != '' ? $description : NULL, 'module_flag' => $moduleflag, 'createdby_role' => $loginuserRole, 'createdby_group' => $loginuserGroup, 'createdby' => $loginUserId, 'modifiedby_role' => $loginuserRole, 'modifiedby_group' => $loginuserGroup, 'modifiedby' => $loginUserId, 'isactive' => 1, 'createddate' => gmdate("Y-m-d H:i:s"), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = '';
$actionflag = 1;
if ($questionval != '' && $categoryval != '' && $moduleflag != '' && preg_match('/^[a-zA-Z0-9.\\- ?\',\\/#@$&*()!]+$/', $questionval)) {
$Id = $appraisalquestionsmodel->SaveorUpdateAppraisalQuestionData($data, $where);
$menuidArr = $menumodel->getMenuObjID('/appraisalquestions');
$menuID = $menuidArr[0]['id'];
$logresult = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
$result['msg'] = 'success';
$result['id'] = $Id;
$result['question'] = $questionval;
$result['description'] = $description;
} else {
$result['msg'] = 'error';
$result['id'] = '';
$result['question'] = '';
$result['description'] = '';
}
} catch (Exception $e) {
$result['msg'] = $e->getMessage();
$result['id'] = '';
$result['question'] = '';
$result['description'] = '';
}
$this->_helper->json($result);
}
public function editAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$sess_vals = $auth->getStorage()->read();
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$timesheetDay = date('d-m-Y');
$id = $this->getRequest()->getParam('id', null);
$timeSheetModel = new Default_Model_Fillintimesheet();
$nonProjecttimeSheetModel = new Default_Model_Fillintimesheetnonproject();
$where = "";
$actionflag = 1;
$form = new Default_Form_createprojects();
//$form->setAttrib('action', DOMAIN . 'fillintimesheet/edit/id/' . $id);
if ($this->getRequest()->getPost()) {
$trDb = Zend_Db_Table::getDefaultAdapter();
try {
//Task Details
//$tprojectSelected = $this->_getParam('projectSelected', null);
//$ttaskSelected = $this->_getParam('taskSelected', null);
$thid_status = $this->_getParam('hid_status', null);
$timesheetDay = $this->_getParam('timesheetDay', null);
if ($thid_status == "0") {
// starting transaction
$trDb->beginTransaction();
//record Project Timesheet
$thid_allocationkeyids = $this->_getParam('hid_allocationkeyid', null);
$thid_actualeffort = $this->_getParam('hid_actualeffort', null);
$thid_actualeffortcomments = $this->_getParam('hid_actualeffortcomments', null);
$ttimesheetDay = $this->_getParam('timesheetDay', null);
$ttimesheetDay = sapp_Global::change_date(trim($ttimesheetDay), 'database');
$curRow = 0;
foreach ($thid_allocationkeyids as $thid_allocationkeyid) {
$curActualEffort = $thid_actualeffort[$curRow];
if (is_numeric($curActualEffort)) {
if ($curActualEffort > 0) {
$existingID = $timeSheetModel->isTimeAlreadySubmitted($thid_allocationkeyid, $ttimesheetDay);
if ($existingID == "0") {
$mpolicydata = array('resourcetaskactivityid' => trim($thid_allocationkeyid), 'effort' => trim($curActualEffort), 'comments' => trim($thid_actualeffortcomments[$curRow]), 'workdate' => $ttimesheetDay, 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = "";
$Id = $timeSheetModel->SaveorUpdateData($mpolicydata, $where);
} else {
$where = array('id=?' => $existingID);
$mpolicydata = array('effort' => trim($curActualEffort), 'comments' => trim($thid_actualeffortcomments[$curRow]), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$Id = $timeSheetModel->SaveorUpdateData($mpolicydata, $where);
}
}
}
$curRow = $curRow + 1;
}
//record Non-Project Timesheet
$tnonprojectrowremoves = $this->_getParam('nonprojectrowremove', null);
$tnonprojectrowids = $this->_getParam('nonprojectrowid', null);
$tcategorySelecteds = $this->_getParam('categorySelected', null);
$tcategoryactivityselected = $this->_getParam('categoryactivityselected', null);
$tcategoryreference = $this->_getParam('categoryreference', null);
$tcategoryreferencedescription = $this->_getParam('categoryreferencedescription', null);
$tcategoryactualeffort = $this->_getParam('categoryactualeffort', null);
$tcategoryactualeffortcomments = $this->_getParam('categoryactualeffortcomments', null);
$curRow = 0;
//Insert or update
foreach ($tcategorySelecteds as $tcategorySelected) {
$categoryActualEffort = $tcategoryactualeffort[$curRow];
$categoryactivityselected = $tcategoryactivityselected[$curRow];
if (is_numeric($categoryActualEffort)) {
if ($categoryActualEffort > 0) {
//$existingID = $nonProjecttimeSheetModel->isTimeAlreadySubmitted($tcategorySelected, $categoryactivityselected, $loginUserId, $ttimesheetDay1);
$existingID = $tnonprojectrowids[$curRow];
if ($existingID == "0") {
$mpolicydata = array('categoryid' => trim($tcategorySelected), 'activityid' => trim($categoryactivityselected), 'resourceid' => trim($loginUserId), 'workdate' => $ttimesheetDay, 'reference' => trim($tcategoryreference[$curRow]), 'referencedescription' => trim($tcategoryreferencedescription[$curRow]), 'effort' => trim($categoryActualEffort), 'comments' => trim($tcategoryactualeffortcomments[$curRow]), 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = "";
$Id = $nonProjecttimeSheetModel->SaveorUpdateData($mpolicydata, $where);
} else {
$where = array('id=?' => $existingID);
$mpolicydata = array('categoryid' => trim($tcategorySelected), 'activityid' => trim($categoryactivityselected), 'reference' => trim($tcategoryreference[$curRow]), 'referencedescription' => trim($tcategoryreferencedescription[$curRow]), 'effort' => trim($categoryActualEffort), 'comments' => trim($tcategoryactualeffortcomments[$curRow]), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$Id = $nonProjecttimeSheetModel->SaveorUpdateData($mpolicydata, $where);
}
}
}
$curRow = $curRow + 1;
}
//Soft Delete
foreach ($tnonprojectrowremoves as $tnonprojectrowremove) {
$where = array('id=?' => $tnonprojectrowremove);
$mpolicydata = array('isactive' => 0, 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$Id = $nonProjecttimeSheetModel->SaveorUpdateData($mpolicydata, $where);
}
//if ($Id > 0 && is_numeric($Id)) {
$menuID = -999;
sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Timesheet details successfully added."));
//} else {
// $this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Error while adding Timesheet details."));
//}
$trDb->commit();
//$this->view->messages = $this->_helper->flashMessenger->getMessages();
$this->_redirect('/fillintimesheet');
}
} catch (Exception $e) {
$trDb->rollBack();
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later."));
//$this->view->messages = $this->_helper->flashMessenger->getMessages();
$this->_redirect('/fillintimesheet');
}
}
$form->submit->setLabel('Submit');
$this->view->loginuserGroup = $loginuserGroup;
$this->view->form = $form;
$ttimesheetDay = sapp_Global::change_date(trim($timesheetDay), 'database');
$this->view->sess_vals = $sess_vals;
$this->view->loginUserId = $loginUserId;
$this->view->loginuserRole = $loginuserRole;
$this->view->loginuserGroup = $loginuserGroup;
$this->view->selDate = $ttimesheetDay;
$this->view->projectcategories = $timeSheetModel->getProjectCategories();
$this->view->categoryActivities = $timeSheetModel->AllCategoryActivities();
$timesheetGrid = $timeSheetModel->getEmployeeTimesheetGrid($ttimesheetDay, $loginUserId);
$nonprojecttimesheetGrid = $timeSheetModel->getEmployeeNonProjectTimesheetGrid($ttimesheetDay, $loginUserId);
$this->view->timesheetGrid = $timesheetGrid;
$this->view->nonprojecttimesheetGrid = $nonprojecttimesheetGrid;
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$messages['flagtype'] = '';
$actionflag = 3;
if ($id) {
$positionsmodel = new Default_Model_Positions();
$menumodel = new Default_Model_Menu();
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$position_data = $positionsmodel->getsinglePositionData($id);
$Id = $positionsmodel->SaveorUpdatePositionData($data, $where);
if ($Id == 'update') {
sapp_Global::send_configuration_mail("Positions", $position_data[0]['positionname']);
$menuidArr = $menumodel->getMenuObjID('/positions');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Position deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Position cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Position cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$actionflag = 3;
if ($id) {
$departmentsmodel = new Default_Model_Departments();
$checkemployees = $departmentsmodel->checkemployeestodepartment($id);
if ($checkemployees == 0) {
$data = array('isactive' => 0);
$where = array('id=?' => $id);
$Id = $departmentsmodel->SaveorUpdateDepartmentsUnits($data, $where);
if ($Id == 'update') {
$menuID = DEPARTMENTS;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Department deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Department cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Please re-assign the employees to another department';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Department cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$messages['msgtype'] = '';
$messages['flagtype'] = '';
$weekname = '';
$actionflag = 3;
if ($id) {
$weekdaysmodel = new Default_Model_Weekdays();
$weekname = $weekdaysmodel->getcombinedweekname($id);
$data = array('isactive' => 0, 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$Id = $weekdaysmodel->SaveorUpdateWeekdaysdataData($data, $where);
if ($Id == 'update') {
$menuID = WEEKDAYS;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
if (!empty($weekname)) {
$configmail = sapp_Global::send_configuration_mail('Days List', $weekname[0]['week_name']);
}
$messages['message'] = 'Day deleted successfully.';
$messages['msgtype'] = 'success';
} else {
$messages['message'] = 'Day cannot be deleted.';
$messages['msgtype'] = 'error';
}
} else {
$messages['message'] = 'Day cannot be deleted.';
$messages['msgtype'] = 'error';
}
$this->_helper->json($messages);
}
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 deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$actionflag = 3;
if ($id) {
$leaverequestmodel = new Default_Model_Leaverequest();
$data = array('leavestatus' => 4);
$where = array('id=?' => $id);
$Id = $leaverequestmodel->SaveorUpdateLeaveRequest($data, $where);
if ($Id == 'update') {
$menuID = PENDINGLEAVES;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Leave request cancelled.';
} else {
$messages['message'] = 'Leave request cannot be cancelled.';
}
} else {
$messages['message'] = 'Leave request cannot be cancelled.';
}
$this->_helper->json($messages);
}
public function editAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$sess_vals = $auth->getStorage()->read();
$loginUserId = $auth->getStorage()->read()->id;
$loginuserRole = $auth->getStorage()->read()->emprole;
$loginuserGroup = $auth->getStorage()->read()->group_id;
}
$messages['message'] = '';
$id = $this->getRequest()->getParam('id', null);
$taskModel = new Default_Model_Createtasks();
$currprojectsModel = new Default_Model_Createprojects();
$activityModel = new Default_Model_Createactivities();
$requi_model = new Default_Model_Requisition();
$usersModel = new Default_Model_Users();
$currentUserSummary = $usersModel->getEmployeeSummaryByID($loginUserId);
$taskAllocationModel = new Default_Model_Tasksallocation();
$where = "";
$actionflag = 1;
$form = new Default_Form_createprojects();
$form->setAttrib('action', DOMAIN . 'createtasks/edit/id/' . $id);
//$this->view->activeprojects = $taskModel->getActiveProjects();
$this->view->activeprojects = $taskAllocationModel->getActiveProjectsForTasksForUser($currentUserSummary['businessunit_id'], $loginUserId, $loginuserGroup);
$this->view->projectCategories = $taskModel->getProjectCategories();
$this->view->business_units_list = $requi_model->getBusinessUnits();
$this->view->allusers = array();
//$this->view->allusers = $usersModel->getAllActiveUsers();
try {
if ($id > 0 && is_numeric($id)) {
//update code
$where = "";
$actionflag = 2;
$id = abs($id);
$taskdata = $taskModel->getTaskDataByID($id);
$Currprojectdata = $currprojectsModel->getProjectDataByID($taskdata['projectid']);
$form->submit->setLabel('Update Task');
$this->view->taskpagerefresh = '0';
$this->view->TaskID = $id;
$this->view->loginuserGroup = $loginuserGroup;
$this->view->form = $form;
$this->view->isEdit = "1";
$this->view->data = $taskdata;
$this->view->BUUsers = $usersModel->getAllActiveUsersByBU($Currprojectdata['businessunit']);
$this->view->TrackingCodes = $currprojectsModel->getTrackingCodesByCategory($Currprojectdata['category']);
if ($this->getRequest()->getPost()) {
$trDb = Zend_Db_Table::getDefaultAdapter();
// starting transaction
$trDb->beginTransaction();
try {
$bFlag = true;
//Task Details
$tprojectSelected = $this->_getParam('projectSelected', null);
$ttaskName = $this->_getParam('taskName', null);
$ttaskDescription = $this->_getParam('taskDescription', null);
$ttaskStartDate = $this->_getParam('taskStartDate', null);
$ttaskEndDate = $this->_getParam('taskEndDate', null);
$ttaskStatus = $this->_getParam('taskStatus', null);
$ttaskPrimaryLead = $this->_getParam('taskPrimaryLead', null);
$ttaskSecondaryLead = $this->_getParam('taskSecondaryLead', null);
$ttaskEffort = $this->_getParam('taskEffort', null);
//Task Activity Details
$tprjactivitytaskid = $this->_getParam('prjactivitytaskid', null);
$tprjactivityid = $this->_getParam('prjactivityid', null);
$tprjactivitysdate = $this->_getParam('prjactivitysdate', null);
$tprjactivityedate = $this->_getParam('prjactivityedate', null);
$tprjactivityeffort = $this->_getParam('prjactivityeffort', null);
$tprojectStartDate1 = sapp_Global::change_date(trim($ttaskStartDate), 'database');
$tprojectEndDate1 = sapp_Global::change_date(trim($ttaskEndDate), 'database');
$tprojectStartDate2 = sapp_Global::change_date(trim($taskdata['startdate']), 'database');
$tprojectEndDate2 = sapp_Global::change_date(trim($taskdata['enddate']), 'database');
//get tracking codes for edits
$ttrackingcodestartdate = $this->_getParam('trackingcodestartdate', null);
$ttrackingcodeenddate = $this->_getParam('trackingcodeenddate', null);
$ttrackingcodeeffort = $this->_getParam('trackingcodeenddate', null);
$mtaskactivitytrackingdata = array('startdate' => implode(',', $ttrackingcodestartdate), 'enddate' => implode(',', $ttrackingcodeenddate), 'effort' => implode(',', $ttrackingcodeeffort));
$this->view->taskactivitytrackingdata = $mtaskactivitytrackingdata;
$this->view->taskpagerefresh = '1';
if ($tprojectStartDate2 != $tprojectStartDate1 && ($ttrackingcodestartdate <= 0 || $ttrackingcodestartdate == '')) {
//$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned Start Date."));
$validationMsg['message'] = 'Tracking code due to change in Task Planned Start Date.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if ($tprojectEndDate2 != $tprojectEndDate1 && ($ttrackingcodeenddate <= 0 || $ttrackingcodeenddate == '')) {
//$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned End Date."));
$validationMsg['message'] = 'Tracking code due to change in Task Planned End Date.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if ($taskdata['effort'] != $ttaskEffort && ($ttrackingcodeeffort <= 0 || $ttrackingcodeeffort == '')) {
//$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Tracking code due to change in Project Planned Effort."));
$validationMsg['message'] = 'Tracking code due to change in Task Planned Effort.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if ($tprojectSelected <= 0) {
$validationMsg['message'] = 'Please select project.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskName)) <= 0) {
$validationMsg['message'] = 'Task name cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskDescription)) <= 0) {
$validationMsg['message'] = 'Task description cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskStartDate)) <= 0) {
$validationMsg['message'] = 'Task startdate cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskEndDate)) <= 0) {
$validationMsg['message'] = 'Task enddate cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskEffort)) <= 0) {
$validationMsg['message'] = 'Task effort cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if ($ttaskPrimaryLead <= 0) {
$validationMsg['message'] = 'Please select primary lead.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if ($ttaskSecondaryLead <= 0) {
$validationMsg['message'] = 'Please select secondary lead.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
}
}
}
}
}
}
}
}
}
}
}
if ($bFlag) {
$mpolicydata = array('projectid' => trim($tprojectSelected), 'taskname' => trim($ttaskName), 'description' => trim($ttaskDescription), 'status' => trim($ttaskStatus), 'effort' => trim($ttaskEffort), 'startdate' => sapp_Global::change_date(trim($ttaskStartDate), 'database'), 'enddate' => sapp_Global::change_date(trim($ttaskEndDate), 'database'), 'primarylead' => trim($ttaskPrimaryLead), 'secondarylead' => trim($ttaskSecondaryLead), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $id);
$Id = $taskModel->SaveorUpdateData($mpolicydata, $where);
if ($tprojectStartDate2 != $tprojectStartDate1 || $tprojectEndDate2 != $tprojectEndDate1 || $taskdata['effort'] != $ttaskEffort) {
$taskslogModel = new Default_Model_Createtaskslog();
$mprojectlogdata = array('taskid' => trim($taskdata['id']), 'startdatetrackingcodeid' => trim($ttrackingcodestartdate), 'enddatetrackingcodeid' => trim($ttrackingcodeenddate), 'efforttrackingcodeid' => trim($ttrackingcodeeffort), 'effortold' => trim($taskdata['effort']), 'startdateold' => $tprojectStartDate2, 'enddateold' => $tprojectEndDate2, 'effortnew' => $ttaskEffort, 'startdatenew' => $tprojectStartDate1, 'enddatenew' => $tprojectEndDate1, 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"));
$where = "";
$Id = $taskslogModel->SaveorUpdateData($mprojectlogdata, $where);
}
//update Task Activities
$currRow = 0;
foreach ($tprjactivityid as $tprjactid) {
$mactivitydata = array('effort' => trim($tprjactivityeffort[$currRow]), 'startdate' => sapp_Global::change_date(trim($tprjactivitysdate[$currRow]), 'database'), 'enddate' => sapp_Global::change_date(trim($tprjactivityedate[$currRow]), 'database'), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$where = array('id=?' => $tprjactivitytaskid[$currRow]);
$Id1 = $activityModel->SaveorUpdateData($mactivitydata, $where);
$currRow = $currRow + 1;
}
$menuID = -999;
sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Task details successfully modified."));
$trDb->commit();
$this->_redirect('/createtasks');
}
} catch (Exception $e) {
$trDb->rollBack();
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later."));
$this->_redirect('/createtasks');
}
}
} else {
//Insert code
$actionflag = 1;
if ($this->getRequest()->getPost()) {
#$result = $this->save($form, $policydata);
$trDb = Zend_Db_Table::getDefaultAdapter();
// starting transaction
$trDb->beginTransaction();
try {
$bFlag = true;
//Task Details
$tprojectSelected = $this->_getParam('projectSelected', null);
$ttaskName = $this->_getParam('taskName', null);
$ttaskDescription = $this->_getParam('taskDescription', null);
$ttaskStartDate = $this->_getParam('taskStartDate', null);
$ttaskEndDate = $this->_getParam('taskEndDate', null);
$ttaskStatus = $this->_getParam('taskStatus', null);
$ttaskPrimaryLead = $this->_getParam('taskPrimaryLead', null);
$ttaskSecondaryLead = $this->_getParam('taskSecondaryLead', null);
$ttaskEffort = $this->_getParam('taskEffort', null);
//Task Activity Details
$tprjactivityid = $this->_getParam('prjactivityid', null);
$tprjactivitysdate = $this->_getParam('prjactivitysdate', null);
$tprjactivityedate = $this->_getParam('prjactivityedate', null);
$tprjactivityeffort = $this->_getParam('prjactivityeffort', null);
$tprjactivitysdate1 = implode(',', $tprjactivitysdate);
$mtaskactivitytrackingdata = array('startdate' => implode(',', $tprjactivitysdate), 'enddate' => implode(',', $tprjactivityedate), 'effort' => implode(',', $tprjactivityeffort));
$this->view->taskactivitytrackingdata = $mtaskactivitytrackingdata;
$this->view->taskpagerefresh = '1';
if ($tprojectSelected <= 0) {
$validationMsg['message'] = 'Please select project.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskName)) <= 0) {
$validationMsg['message'] = 'Task name cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskDescription)) <= 0) {
$validationMsg['message'] = 'Task description cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskStartDate)) <= 0) {
$validationMsg['message'] = 'Task startdate cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskEndDate)) <= 0) {
$validationMsg['message'] = 'Task enddate cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if (strlen(trim($ttaskEffort)) <= 0) {
$validationMsg['message'] = 'Task effort cannot be empty.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if ($ttaskPrimaryLead <= 0) {
$validationMsg['message'] = 'Please select primary lead.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
} else {
if ($ttaskSecondaryLead <= 0) {
$validationMsg['message'] = 'Please select secondary lead.';
$validationMsg['msgtype'] = 'error';
$this->view->validationMsg = $validationMsg;
$bFlag = false;
}
}
}
}
}
}
}
}
$mpolicydata = array('projectid' => trim($tprojectSelected), 'taskname' => trim($ttaskName), 'description' => trim($ttaskDescription), 'status' => trim($ttaskStatus), 'effort' => trim($ttaskEffort), 'startdate' => sapp_Global::change_date(trim($ttaskStartDate), 'database'), 'enddate' => sapp_Global::change_date(trim($ttaskEndDate), 'database'), 'primarylead' => trim($ttaskPrimaryLead), 'secondarylead' => trim($ttaskSecondaryLead), 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($bFlag) {
$Id = $taskModel->SaveorUpdateData($mpolicydata, $where);
if ($Id > 0 && is_numeric($Id)) {
//Insert Task Activities
$currRow = 0;
foreach ($tprjactivityid as $tprjactid) {
$mactivitydata = array('taskid' => trim($Id), 'activityid' => trim($tprjactid), 'status' => trim($ttaskStatus), 'effort' => trim($tprjactivityeffort[$currRow]), 'startdate' => sapp_Global::change_date(trim($tprjactivitysdate[$currRow]), 'database'), 'enddate' => sapp_Global::change_date(trim($tprjactivityedate[$currRow]), 'database'), 'primarylead' => trim($ttaskPrimaryLead), 'secondarylead' => trim($ttaskSecondaryLead), 'createdby' => trim($loginUserId), 'createddate' => gmdate("Y-m-d H:i:s"), 'modifiedby' => trim($loginUserId), 'modifieddate' => gmdate("Y-m-d H:i:s"));
$currRow = $currRow + 1;
$Id1 = $activityModel->SaveorUpdateData($mactivitydata, $where);
}
$menuID = -999;
sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Project details successfully added."));
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => "Error while adding project details."));
}
$trDb->commit();
$this->_redirect('/createtasks');
}
} catch (Exception $e) {
$trDb->rollBack();
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Something went wrong, please try again later."));
$this->_redirect('/createtasks');
}
}
if ($tprojectSelected > 0) {
$Currprojectdata = $currprojectsModel->getProjectDataByID($tprojectSelected);
$this->view->BUUsers = $usersModel->getAllActiveUsersByBU($Currprojectdata['businessunit']);
}
$form->submit->setLabel('Add Task');
$this->view->loginuserGroup = $loginuserGroup;
$this->view->TaskID = "0";
$this->view->form = $form;
$this->view->isEdit = "0";
$this->view->data = $mpolicydata;
}
} catch (Exception $e) {
$this->view->nodata = 'nodata';
}
}
public function save($workeligibilityform)
{
$result = "";
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$date = new Zend_Date();
$workeligibilitydoctypesmodel = new Default_Model_Workeligibilitydoctypes();
$documenttype_id = $this->_request->getParam('documenttype_id');
if ($documenttype_id != '') {
$issuingauthorityArr = $workeligibilitydoctypesmodel->getIssuingAuthority($documenttype_id);
}
if (!empty($issuingauthorityArr)) {
$issuingauthority = $issuingauthorityArr[0]['issuingauthority'];
if ($issuingauthority == 2) {
$workeligibilityform->issuingauth_state->setRequired(true)->addErrorMessage('Please select state.');
$workeligibilityform->issuingauth_state->addValidator('NotEmpty', false, array('messages' => 'Please select state.'));
} else {
if ($issuingauthority == 3) {
$workeligibilityform->issuingauth_state->setRequired(true)->addErrorMessage('Please select state.');
$workeligibilityform->issuingauth_state->addValidator('NotEmpty', false, array('messages' => 'Please select state.'));
$workeligibilityform->issuingauth_city->setRequired(true)->addErrorMessage('Please select city.');
$workeligibilityform->issuingauth_city->addValidator('NotEmpty', false, array('messages' => 'Please select city.'));
}
}
}
if ($workeligibilityform->isValid($this->_request->getPost())) {
$post_values = $this->_request->getPost();
if (isset($post_values['id'])) {
unset($post_values['id']);
}
if (isset($post_values['user_id'])) {
unset($post_values['user_id']);
}
if (isset($post_values['submit'])) {
unset($post_values['submit']);
}
$new_post_values = array_filter($post_values);
$user_id = $this->_request->getParam('userid');
if (!empty($new_post_values)) {
$workeligibilityModel = new Default_Model_Workeligibilitydetails();
$id = $this->_request->getParam('id');
$doc_issue_date = $this->_request->getParam('doc_issue_date', null);
$doc_expiry_date = $this->_request->getParam('doc_expiry_date', null);
$issuingauth_name = $this->_request->getParam('issuingauth_name');
$issuingauth_country = $this->_request->getParam('issuingauth_country');
$issuingauth_state = $this->_request->getParam('issuingauth_state');
$issuingauth_city = $this->_request->getParam('issuingauth_city');
$issuingauth_postalcode = $this->_request->getParam('issuingauth_postalcode');
$docissueDate = sapp_Global::change_date($doc_issue_date, 'database');
$docexpiryDate = sapp_Global::change_date($doc_expiry_date, 'database');
$data = array('documenttype_id' => $documenttype_id, 'doc_issue_date' => $docissueDate, 'doc_expiry_date' => $docexpiryDate, 'issuingauth_name' => $issuingauth_name, 'issuingauth_country' => $issuingauth_country, 'issuingauth_state' => $issuingauth_state, 'issuingauth_city' => $issuingauth_city, 'issuingauth_postalcode' => $issuingauth_postalcode, 'user_id' => $user_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('user_id=?' => $user_id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$where = '';
$actionflag = 1;
}
$Id = $workeligibilityModel->SaveorUpdateWorkEligibilityDetails($data, $where);
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee work eligibility details updated successfully."));
} else {
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee work eligibility details added successfully."));
}
$menuID = EMPLOYEE;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => FIELDMSG));
}
$this->_redirect('workeligibilitydetails/edit/userid/' . $user_id);
} else {
$messages = $workeligibilityform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
if ($this->_request->getPost()) {
$issuingauth_country = $this->_request->getParam('issuingauth_country');
$issuingauth_state = $this->_request->getParam('issuingauth_state');
$stateArr = explode("!@#", $issuingauth_state);
$stateStr = $stateArr[0];
$issuingauth_city = $this->_request->getParam('issuingauth_city');
$cityArr = explode("!@#", $issuingauth_city);
$cityStr = $cityArr[0];
} else {
$issuingauth_country = '';
$issuingauth_state = '';
$issuingauth_city = '';
}
if (isset($issuingauth_country) && $issuingauth_country != 0 && $issuingauth_country != '') {
$statesmodel = new Default_Model_States();
$statesmodeldata = $statesmodel->getStatesList($issuingauth_country);
$workeligibilityform->issuingauth_state->addMultiOption('', 'Select State');
foreach ($statesmodeldata as $res) {
$workeligibilityform->issuingauth_state->addMultiOption($res['id'] . '!@#' . utf8_encode($res['state_name']), utf8_encode($res['state_name']));
}
if (isset($issuingauth_state) && $issuingauth_state != 0 && $issuingauth_state != '') {
$workeligibilityform->setDefault('issuingauth_state', $issuingauth_state);
}
}
if (isset($issuingauth_state) && $issuingauth_state != 0 && $issuingauth_state != '') {
$citiesmodel = new Default_Model_Cities();
$citiesmodeldata = $citiesmodel->getCitiesList($stateStr);
$workeligibilityform->issuingauth_city->addMultiOption('', 'Select City');
foreach ($citiesmodeldata as $res) {
$workeligibilityform->issuingauth_city->addMultiOption($res['id'] . '!@#' . utf8_encode($res['city_name']), utf8_encode($res['city_name']));
}
if (isset($issuingauth_city) && $issuingauth_city != 0 && $issuingauth_city != '') {
$workeligibilityform->setDefault('issuingauth_city', $issuingauth_city);
}
}
return $msgarray;
}
}
public function multipleresumeAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
$loginUserId = trim($loginUserId);
}
$priv_check = sapp_Global::_checkprivileges(CANDIDATEDETAILS, '', $auth->getStorage()->read()->emprole, 'add');
if ($priv_check == 'Yes') {
$msgarray = $req_options = array();
$form = new Default_Form_Multipleresume();
$form->setAction(DOMAIN . 'candidatedetails/multipleresume');
// To show list of requisitions to user
$req_model = new Default_Model_Requisition();
$req_data = $req_model->getRequisitionsForCV("'Approved','In process'");
foreach ($req_data as $req) {
$req_options[$req['id']] = $req['requisition_code'] . ' - ' . $req['jobtitlename'];
}
if (count($req_options) == 0) {
$msgarray['requisition_id'] = "No active requisitions are found.";
}
$form->requisition_id->addMultiOptions(array('' => 'Select Requisition ID') + $req_options);
$form_post_status = $this->_request->getPost();
if ($form_post_status) {
$candidate_firstname = $this->_getParam('candidate_firstname', null);
$candidate_lastname = $this->_getParam('candidate_lastname', null);
$cand_resumes = $this->_getParam('cand_resume', null);
if ($form->isValid($form_post_status)) {
$cand_details_model = new Default_Model_Candidatedetails();
$requisition_id = $this->_getParam('requisition_id', null);
$cand_status = $this->_getParam('cand_status', null);
$req_records = $cand_details_model->getcountofrecords($requisition_id);
$curr_date = gmdate("Y-m-d H:i:s");
if (empty($req_records)) {
$rdata = array('req_status' => 'In process', 'modifiedby' => $loginUserId, 'modifiedon' => $curr_date);
$rwhere = ' id = ' . $requisition_id;
$req_model->SaveorUpdateRequisitionData($rdata, $rwhere);
}
// To insert records in a single query
$records = array();
foreach ($candidate_firstname as $key => $candidate_fname) {
$cfull_name = $candidate_fname . ' ' . $candidate_lastname[$key];
$records[] = "({$requisition_id}, '{$candidate_fname}','{$candidate_lastname[$key]}','{$cfull_name}', '{$cand_resumes[$key]}', '{$cand_status}', 1, {$loginUserId}, {$loginUserId}, '{$curr_date}', '{$curr_date}')";
}
$data_fields = array('requisition_id', 'candidate_firstname', 'candidate_lastname', 'candidate_name', 'cand_resume', 'cand_status', 'isactive', 'createdby', 'modifiedby', 'createddate', 'modifieddate');
$last_insert_id = $cand_details_model->insertMultipleRecords($data_fields, $records);
// Log status to Log manager and redirect to Resource Pooling list page.
if ($last_insert_id != '') {
$menumodel = new Default_Model_Menu();
$objidArr = $menumodel->getMenuObjID('/candidatedetails');
$objID = $objidArr[0]['id'];
$log_status = sapp_Global::logManager($objID, 1, $loginUserId, $last_insert_id);
//$this->_helper->FlashMessenger()->setNamespace('success')->addMessage('Candidate details added successfully.');
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Candidate details added successfully."));
$this->_redirect('/candidatedetails');
}
} else {
// To handle server validation, when Javascript is disabled
$messages = $form->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
$form->setDefault('candidate_firstname', $candidate_firstname[0]);
$form->setDefault('cand_resume', '');
}
}
$this->view->form = $form;
$this->view->msgarray = $msgarray;
} else {
$this->_redirect('error');
}
}
public function save($empsalarydetailsform, $userid)
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
if ($empsalarydetailsform->isValid($this->_request->getPost())) {
$empsalarydetailsModal = new Default_Model_Empsalarydetails();
$id = $this->_request->getParam('id');
$user_id = $userid;
$currencyid = $this->_request->getParam('currencyid');
$salarytype = $this->_request->getParam('salarytype');
$salary = $this->_request->getParam('salary');
$bankname = trim($this->_request->getParam('bankname'));
$accountholder_name = trim($this->_request->getParam('accountholder_name'));
$accountclasstypeid = $this->_request->getParam('accountclasstypeid');
$bankaccountid = $this->_request->getParam('bankaccountid');
$accountnumber = trim($this->_request->getParam('accountnumber'));
$accountholding = $this->_request->getParam('accountholding');
$accountholding = sapp_Global::change_date($accountholding, 'database');
$date = new Zend_Date();
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$data = array('user_id' => $user_id, 'currencyid' => $currencyid, 'salarytype' => $salarytype, 'salary' => $salary, 'bankname' => $bankname != '' ? $bankname : NULL, 'accountholder_name' => $accountholder_name != '' ? $accountholder_name : NULL, 'accountclasstypeid' => $accountclasstypeid != '' ? $accountclasstypeid : NULL, 'bankaccountid' => $bankaccountid != '' ? $bankaccountid : NULL, 'accountnumber' => $accountnumber != '' ? $accountnumber : NULL, 'accountholding' => $accountholding != '' ? $accountholding : NULL, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('user_id=?' => $user_id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$data['isactive'] = 1;
$where = '';
$actionflag = 1;
}
$Id = $empsalarydetailsModal->SaveorUpdateEmpSalaryData($data, $where);
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee salary details updated successfully."));
} else {
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee salary details added successfully."));
}
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
$this->_redirect('empsalarydetails/edit/userid/' . $user_id);
} else {
$messages = $empsalarydetailsform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
return $msgarray;
}
}
public function updateAction()
{
$empDocuModel = new Default_Model_Employeedocs();
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('doc_id');
$name = $this->_request->getParam('doc_name');
$userid = $this->_request->getParam('userid');
// Get attachments
$file_original_names = $this->getRequest()->getParam('file_original_names');
$file_new_names = $this->getRequest()->getParam('file_new_names');
$org_names = explode(',', $file_original_names);
$new_names = explode(',', $file_new_names);
$attachment_array = array();
for ($i = 0; $i < count($org_names); $i++) {
if ($new_names[$i] != '') {
$attachment_array[] = array("original_name" => $org_names[$i], "new_name" => $new_names[$i]);
}
}
$data = array('name' => $name, 'attachments' => count($attachment_array) > 0 ? json_encode($attachment_array) : null, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
// Validate duplicate document name
$empDocuments = $empDocuModel->checkDocNameByUserIdAndDocId($userid, $name, $id);
$count_emp_docs = count($empDocuments);
if ($count_emp_docs == 0) {
$where = array('id=?' => $id);
$actionflag = 2;
$recordId = $empDocuModel->SaveorUpdateEmpDocuments($data, $where);
$menumodel = new Default_Model_Menu();
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $userid);
$this->_helper->json(array('result' => 'success'));
} else {
if ($count_emp_docs > 0) {
$this->_helper->json(array('result' => 'exists'));
} else {
$this->_helper->json(array('result' => 'error'));
}
}
}
public function save($creditcardDetailsform)
{
$result = "";
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$date = new Zend_Date();
if ($creditcardDetailsform->isValid($this->_request->getPost())) {
$post_values = $this->_request->getPost();
if (isset($post_values['id'])) {
unset($post_values['id']);
}
if (isset($post_values['user_id'])) {
unset($post_values['user_id']);
}
if (isset($post_values['submit'])) {
unset($post_values['submit']);
}
$new_post_values = array_filter($post_values);
$user_id = $this->_request->getParam('userid');
if (!empty($new_post_values)) {
$creditcardDetailsModel = new Default_Model_Creditcarddetails();
$id = $this->_request->getParam('id');
$card_type = $this->_request->getParam('card_type');
$card_number = $this->_request->getParam('card_number');
$card_name = $this->_request->getParam('nameoncard');
$card_expiry_1 = $this->_request->getParam('card_expiration', null);
$card_expiry = sapp_Global::change_date($card_expiry_1, 'database');
$card_issuedBy = $this->_request->getParam('card_issuedby');
$card_code = $this->_request->getParam('card_code');
$data = array('card_type' => $card_type, 'card_number' => $card_number, 'nameoncard' => $card_name, 'card_expiration' => $card_expiry, 'card_issued_comp' => $card_issuedBy, 'card_code' => $card_code, 'user_id' => $user_id, 'modifiedby' => $loginUserId, 'modifieddate' => gmdate("Y-m-d H:i:s"));
if ($id != '') {
$where = array('user_id=?' => $user_id);
$actionflag = 2;
} else {
$data['createdby'] = $loginUserId;
$data['createddate'] = gmdate("Y-m-d H:i:s");
$where = '';
$actionflag = 1;
}
$Id = $creditcardDetailsModel->SaveorUpdateCreditcardDetails($data, $where);
if ($Id == 'update') {
$tableid = $id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee corporate card details updated successfully."));
} else {
$tableid = $Id;
$this->_helper->getHelper("FlashMessenger")->addMessage(array("success" => "Employee corporate card details added successfully."));
}
$menumodel = new Default_Model_Menu();
$menuidArr = $menumodel->getMenuObjID('/employee');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $user_id);
} else {
$this->_helper->getHelper("FlashMessenger")->addMessage(array("error" => FIELDMSG));
}
$this->_redirect('creditcarddetails/edit/userid/' . $user_id);
} else {
$messages = $creditcardDetailsform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
return $msgarray;
}
}
public function deleteAction()
{
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$id = $this->_request->getParam('objid');
$messages['message'] = '';
$actionflag = 3;
if ($id) {
$assignmententryreasoncodemodel = new Default_Model_Assignmententryreasoncode();
$data = array('isactive' => 0);
$where = array('id=?' => $id);
$Id = $assignmententryreasoncodemodel->SaveorUpdateAssignmentEntryData($data, $where);
if ($Id == 'update') {
$menuID = ASSIGNMENTENTRYREASONCODE;
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id);
$messages['message'] = 'Assignment entry reason code deleted successfully.';
} else {
$messages['message'] = 'Assignment entry reason code cannot be deleted.';
}
} else {
$messages['message'] = 'Assignment entry reason code cannot be deleted.';
}
$this->_helper->json($messages);
}
public function addnewstateAction()
{
Zend_Layout::getMvcInstance()->setLayoutPath(APPLICATION_PATH . "/layouts/scripts/popup/");
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$msgarray = array();
$controllername = 'states';
$statestring = '';
$id = $this->getRequest()->getParam('id');
$selectedcountryid = $this->_request->getParam('selectcountryid', null);
$statesform = new Default_Form_states();
$statesmodel = new Default_Model_States();
$countriesModel = new Default_Model_Countries();
/* Changing the form */
$statesform->setAction(BASE_URL . 'states/addnewstate/selectcountryid/' . $selectedcountryid);
$statesform->removeElement('state');
$statesform->addElement('text', 'state', array('label' => 'State', 'maxlength' => '20', 'required' => true, 'validators' => array(array('validator' => 'NotEmpty', 'options' => array('messages' => 'Please enter state name.')))));
/* END */
$countrieslistArr = $countriesModel->getTotalCountriesList('');
if (sizeof($countrieslistArr) > 0) {
$statesform->countryid->addMultiOption('', 'Select Country');
foreach ($countrieslistArr as $countrieslistres) {
if (isset($selectedcountryid)) {
if ($countrieslistres['id'] == $selectedcountryid) {
$statesform->countryid->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name']));
$statesform->setDefault('countryid', $selectedcountryid);
}
} else {
$statesform->countryid->addMultiOption($countrieslistres['id'], utf8_encode($countrieslistres['country_name']));
}
}
} else {
$msgarray['countryid'] = 'Countries are not configured yet';
}
if ($this->getRequest()->getPost()) {
$errorflag = "true";
$msgarray = array();
$id = $this->_request->getParam('id');
$dbstate = '';
$dbcountryid = '';
$state = trim($this->_request->getParam('state'));
$countryid = $this->_request->getParam('countryid');
if (isset($countryid) && $countryid != '') {
$isDuplicateStateNameArr = $statesmodel->getDuplicateStateName($state, $countryid);
if ($isDuplicateStateNameArr[0]['count'] > 0) {
$errorflag = "false";
$msgarray['state'] = "State already exists.";
}
} else {
$errorflag = "false";
$msgarray['countryid'] = "Please select country.";
}
if ($statesform->isValid($this->_request->getPost()) && $errorflag == "true") {
$menumodel = new Default_Model_Menu();
$actionflag = '';
$tableid = '';
$NewStateId = $statesmodel->SaveMainStateData($countryid, $state);
$tableid = $NewStateId;
$actionflag = 1;
$menuidArr = $menumodel->getMenuObjID('/states');
$menuID = $menuidArr[0]['id'];
$result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $tableid);
if (isset($selectedcountryid)) {
$stateData = $statesmodel->getStatesList($selectedcountryid, '');
} else {
$stateData = array();
}
$opt = '';
foreach ($stateData as $record) {
$opt .= sapp_Global::selectOptionBuilder($record['id'], $record['state_name']);
}
$this->view->stateData = $opt;
$this->view->eventact = 'added';
$close = 'close';
$this->view->popup = $close;
} else {
$messages = $statesform->getMessages();
foreach ($messages as $key => $val) {
foreach ($val as $key2 => $val2) {
$msgarray[$key] = $val2;
break;
}
}
}
}
$this->view->ermsg = '';
$this->view->form = $statesform;
$this->view->msgarray = $msgarray;
$this->view->controllername = $controllername;
}
