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 viewAction() { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $loginUserId = $auth->getStorage()->read()->id; } $leaverequestmodel = new Default_Model_Leaverequest(); $id = $this->getRequest()->getParam('id'); try { $useridArr = $leaverequestmodel->getUserID($id); if (!empty($useridArr)) { $user_id = $useridArr[0]['user_id']; if ($user_id == $loginUserId) { $callval = $this->getRequest()->getParam('call'); if ($callval == 'ajaxcall') { $this->_helper->layout->disableLayout(); } $objName = 'pendingleaves'; $leaverequestform = new Default_Form_leaverequest(); $leaverequestform->removeElement("submit"); $elements = $leaverequestform->getElements(); if (count($elements) > 0) { foreach ($elements as $key => $element) { if ($key != "Cancel" && $key != "Edit" && $key != "Delete" && $key != "Attachments") { $element->setAttrib("disabled", "disabled"); } } } $data = $leaverequestmodel->getsinglePendingLeavesData($id); $data = $data[0]; $getavailbaleleaves = $leaverequestmodel->getAvailableLeaves($loginUserId); if (!empty($data) && $data['leavestatus'] == 'Approved') { $employeeleavetypemodel = new Default_Model_Employeeleavetypes(); $usersmodel = new Default_Model_Users(); $employeeleavetypeArr = $employeeleavetypemodel->getsingleEmployeeLeavetypeData($data['leavetypeid']); if ($employeeleavetypeArr != 'norows') { $leaverequestform->leavetypeid->addMultiOption($employeeleavetypeArr[0]['id'], utf8_encode($employeeleavetypeArr[0]['leavetype'])); } if ($data['leaveday'] == 1) { $leaverequestform->leaveday->addMultiOption($data['leaveday'], 'Full Day'); } else { $leaverequestform->leaveday->addMultiOption($data['leaveday'], 'Half Day'); } $repmngrnameArr = $usersmodel->getUserDetailsByID($data['rep_mang_id'], 'all'); $leaverequestform->populate($data); $from_date = sapp_Global::change_date($data["from_date"], 'view'); $to_date = sapp_Global::change_date($data["to_date"], 'view'); $appliedon = sapp_Global::change_date($data["createddate"], 'view'); $leaverequestform->from_date->setValue($from_date); $leaverequestform->to_date->setValue($to_date); $leaverequestform->createddate->setValue($appliedon); $leaverequestform->appliedleavesdaycount->setValue($data['appliedleavescount']); $leaverequestform->comments->setValue($data['approver_comments']); if (!empty($repmngrnameArr)) { $leaverequestform->rep_mang_id->setValue($repmngrnameArr[0]['userfullname']); } else { $leaverequestform->rep_mang_id->setValue(''); } /* if(!empty($getavailbaleleaves)) { $leaverequestform->no_of_days->setValue($getavailbaleleaves[0]['remainingleaves']); } */ $this->view->controllername = $objName; $this->view->id = $id; $this->view->form = $leaverequestform; $this->view->data = $data; $leaverequestform->setDefault('leavetypeid', $data['leavetypeid']); $leaverequestform->setDefault('leaveday', $data['leaveday']); $this->view->reportingmanagerStatus = !empty($repmngrnameArr) ? $repmngrnameArr[0]['isactive'] : ''; } else { $this->view->rowexist = "rows"; } } else { $this->view->rowexist = "rows"; } } else { $this->view->rowexist = "norows"; } } catch (Exception $e) { $this->view->rowexist = "norows"; } }
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(); $menumodel = new Default_Model_Menu(); $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') { $menuidArr = $menumodel->getMenuObjID('/manageremployeevacations'); $menuID = $menuidArr[0]['id']; $result = sapp_Global::logManager($menuID, $actionflag, $loginUserId, $id); /** MAILING CODE * */ if ($to_date == '' || $to_date == NULL) { $to_date = $from_date; } /* Mail to Employee */ $view = $this->getHelper('ViewRenderer')->view; $base_URL = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl(); $mailpurpose = "The below leave(s) has been cancelled by your manager."; $this->view->base_url = $base_URL; $this->view->application_name = APPLICATION_NAME; $this->view->type = "New"; $this->view->emp_name = $loginUserName; $this->view->mailpurpose = $mailpurpose; $this->view->requester_name = $loginUserName; $this->view->NoOfDays = $appliedleavesdaycount; $this->view->leave_from = $from_date; $this->view->leave_to = $to_date; $this->view->reason_for_leave = $reason; $this->view->reporting_manager = $reportingmanagername; $options['subject'] = APPLICATION_NAME . ':Leave request cancelled by your manager'; $options['header'] = 'Leave Request'; $options['toEmail'] = $loginUserEmail; $options['toName'] = $loginUserName; $options['message'] = $view->render('mailtemplates/leaves.phtml'); sapp_Global::_sendEmail($options, "new"); /* End */ /* Mail to Reporting Manager */ $view = $this->getHelper('ViewRenderer')->view; $base_URL = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl(); $mailpurpose = "The below leave(s) has been cancelled by your manager."; $this->view->base_url = $base_URL; $this->view->application_name = APPLICATION_NAME; $this->view->type = "New"; $this->view->emp_name = $reportingmanagername; $this->view->mailpurpose = $mailpurpose; $this->view->requester_name = $loginUserName; $this->view->NoOfDays = $appliedleavesdaycount; $this->view->leave_from = $from_date; $this->view->leave_to = $to_date; $this->view->reason_for_leave = $reason; $this->view->reporting_manager = $reportingmanagername; $options['subject'] = APPLICATION_NAME . ':Leave request cancelled by your manager'; $options['header'] = 'Leave Request'; $options['toEmail'] = $reportingmanageremail; $options['toName'] = $reportingmanagername; $options['message'] = $view->render('mailtemplates/leaves.phtml'); //$options['message'] = '<div>Hi,</div><div>The below leave(s) has been cancelled.</div><div><table ><tbody><tr><td width="28%" >Employee Name</td><td width="72%">' . $loginUserName . '</td></tr><tr ><td >No. of Day(s)</td><td>' . $appliedleavesdaycount . '</td>/tr><tr><td >From</td><td>' . $from_date . '</td></tr><tr ><td >To</td><td>' . $to_date . '</td></tr><tr ><td >Reason for Leave</td><td>' . $reason . '</td></tr></tbody></table></div>'; sapp_Global::_sendEmail($options, "new"); /* End */ /* Mail to HR */ $view = $this->getHelper('ViewRenderer')->view; $base_URL = 'http://' . $this->getRequest()->getHttpHost() . $this->getRequest()->getBaseUrl(); $mailpurpose = "The below leave(s) has been cancelled by your manager."; $this->view->base_url = $base_URL; $this->view->application_name = APPLICATION_NAME; $this->view->type = "New"; $this->view->emp_name = 'Leave management'; $this->view->mailpurpose = $mailpurpose; $this->view->requester_name = $loginUserName; $this->view->NoOfDays = $appliedleavesdaycount; $this->view->leave_from = $from_date; $this->view->leave_to = $to_date; $this->view->reason_for_leave = $reason; $this->view->reporting_manager = $reportingmanagername; $options['subject'] = APPLICATION_NAME . ':Leave request cancelled by your manager'; $options['header'] = 'Leave Request'; $options['toEmail'] = constant('LV_HR_0'); $options['toName'] = 'Leave management'; $options['message'] = $view->render('mailtemplates/leaves.phtml'); sapp_Global::_sendEmail($options, "new"); $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); $this->_redirect(sapp_Global::_curPageURL()); //$this->_redirect('/manageremployeevacations'); }