function processPost($formvalues) { $config = Zend_Registry::get("config"); // trim spaces from the name field if (isArrayKeyAnEmptyString('status', $formvalues)) { unset($formvalues['status']); } if (isArrayKeyAnEmptyString('ledgertype', $formvalues)) { unset($formvalues['ledgertype']); } else { if ($formvalues['ledgertype'] == 1) { $formvalues['leaveid'] = NULL; $formvalues['leavelength'] = NULL; $formvalues['lengthtype'] = NULL; $formvalues['debitpayroll'] = NULL; } if ($formvalues['ledgertype'] == 2) { $formvalues['amount'] = NULL; $formvalues['benefitid'] = NULL; } } if (isArrayKeyAnEmptyString('trxntype', $formvalues)) { unset($formvalues['trxntype']); } if (isArrayKeyAnEmptyString('companyid', $formvalues)) { $formvalues['companyid'] = 1; } if (isArrayKeyAnEmptyString('benefitid', $formvalues)) { unset($formvalues['benefitid']); } if (isArrayKeyAnEmptyString('leaveid', $formvalues)) { unset($formvalues['leaveid']); } if (isArrayKeyAnEmptyString('trxndate', $formvalues)) { unset($formvalues['trxndate']); } if (isArrayKeyAnEmptyString('startdate', $formvalues)) { unset($formvalues['startdate']); } if (isArrayKeyAnEmptyString('enddate', $formvalues)) { unset($formvalues['enddate']); } if (isArrayKeyAnEmptyString('leavelength', $formvalues)) { unset($formvalues['leavelength']); } if (isArrayKeyAnEmptyString('lengthtype', $formvalues)) { unset($formvalues['lengthtype']); } else { if ($formvalues['lengthtype'] == 2) { $formvalues['leavelength'] = $formvalues['leavelength'] * getHoursInDay(); $formvalues['lengthtype'] = 1; } } if (isArrayKeyAnEmptyString('amount', $formvalues)) { unset($formvalues['amount']); } if (isArrayKeyAnEmptyString('debitpayroll', $formvalues)) { unset($formvalues['debitpayroll']); } if (isArrayKeyAnEmptyString('istaxable', $formvalues)) { unset($formvalues['istaxable']); } if (isArrayKeyAnEmptyString('taxabletype', $formvalues)) { unset($formvalues['taxabletype']); } if (!isArrayKeyAnEmptyString('istaxable', $formvalues)) { $formvalues['istaxable'] = 1; } else { $formvalues['istaxable'] = NULL; } if (isArrayKeyAnEmptyString('payrollid', $formvalues)) { unset($formvalues['payrollid']); } if (isArrayKeyAnEmptyString('payrolltrigger', $formvalues)) { unset($formvalues['payrolltrigger']); } if (isArrayKeyAnEmptyString('isrequest', $formvalues)) { unset($formvalues['isrequest']); } // debugMessage($formvalues); exit(); parent::processPost($formvalues); }
function sendApprovalConfirmationNotification() { $template = new EmailTemplate(); # create mail object $mail = getMailInstance(); $view = new Zend_View(); $session = SessionWrapper::getInstance(); // assign values $template->assign('firstname', $this->getUser()->getFirstName()); $statuslabel = $this->isApproved() ? "Approved" : "Rejected"; $subject = "Leave " . $statuslabel; $save_toinbox = true; $type = "leave"; $subtype = "leave_" . strtolower($statuslabel); $viewurl = $template->serverUrl($template->baseUrl('leave/view/id/' . encode($this->getID()))); $rejectreason = ""; if ($this->isRejected()) { $rejectreason = "<br><b>Synopsis:</b> " . $this->getComments() . ""; } $days = $this->getDuration() / getHoursInDay(); $message_contents = "<p>This is to confirm that your Leave Request from <b>" . changeMySQLDateToPageFormat($this->getStartDate()) . "</b> to <b> " . changeMySQLDateToPageFormat($this->getEndDate()) . "</b> has been successfully " . $statuslabel . $rejectreason . ".</p>\n\t\t<p>To view your request online <a href='" . $viewurl . "'>click here<a></p>\n\t\t<br />\n\t\t<p>" . $this->getApprover()->getName() . "<br />\n\t\t" . getAppName() . "</p>\n\t\t"; $template->assign('contents', $message_contents); $mail->clearRecipients(); $mail->clearSubject(); $mail->setBodyHtml(''); // configure base stuff $mail->addTo($this->getUser()->getEmail(), $this->getUser()->getName()); // set the send of the email address $mail->setFrom(getDefaultAdminEmail(), getDefaultAdminName()); $mail->setSubject($subject); // render the view as the body of the email $html = $template->render('default.phtml'); $mail->setBodyHtml($html); // debugMessage($html); exit(); if ($this->getUser()->allowEmailForTimesheetApproval() && !isEmptyString($this->getUser()->getEmail())) { try { $mail->send(); $session->setVar("custommessage1", "Email sent to " . $this->getUser()->getEmail()); } catch (Exception $e) { $session->setVar(ERROR_MESSAGE, 'Email notification not sent! ' . $e->getMessage()); } } $mail->clearRecipients(); $mail->clearSubject(); $mail->setBodyHtml(''); $mail->clearFrom(); if ($save_toinbox) { # save copy of message to user's application inbox $message_dataarray = array("senderid" => DEFAULT_ID, "subject" => $subject, "contents" => $message_contents, "html" => $html, "type" => $type, "subtype" => $subtype, "refid" => $this->getID(), "recipients" => array(md5(1) => array("recipientid" => $this->getUserID()))); // debugMessage($message_dataarray); // process message data $message = new Message(); $message->processPost($message_dataarray); $message->save(); } return true; }
function completeAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(TRUE); $session = SessionWrapper::getInstance(); $formvalues = $this->_getAllParams(); // debugMessage($formvalues); exit; $config = Zend_Registry::get("config"); $payroll = new Payroll(); $payroll->populate($this->_getParam('id')); $payroll->setStatus($this->_getParam('status')); // debugMessage($payroll->getStartDate()." - ".$payroll->getEndDate()); $ledger_collection = new Doctrine_Collection(Doctrine_Core::getTable("Ledger")); $timesheet_collection = new Doctrine_Collection(Doctrine_Core::getTable("Timesheet")); $leave_collection = new Doctrine_Collection(Doctrine_Core::getTable("Ledger")); $employees = $payroll->getdetails(); // debugMessage($employees->toArray()); foreach ($employees as $employee) { $results_credits_array = array(); // check of benefit additions if (decode($employee->getbenefitdetails()) != "[]" && $employee->getbenefitdetails() != "W10=") { $results_credits_array = objectToArray(json_decode(decode($employee->getbenefitdetails()))); // debugMessage($results_credits_array); foreach ($results_credits_array as $line) { if (!isArrayKeyAnEmptyString('ids', $line)) { $ids_array = explode(',', $line['ids']); if (count($ids_array) > 0) { foreach ($ids_array as $id) { $ledger = new Ledger(); $ledger->populate($id); $ledger->setPayrollID($employee->getPayrollID()); $ledger_collection->add($ledger); // debugMessage($ledger->toArray()); } } } } } // check for deductions if (decode($employee->getdeductiondetails()) != "[]" && $employee->getdeductiondetails() != "W10=") { $results_debits_array = objectToArray(json_decode(decode($employee->getdeductiondetails()))); // debugMessage($results_credits_array); foreach ($results_debits_array as $line) { if (!isArrayKeyAnEmptyString('ids', $line)) { $ids_array = explode(',', $line['ids']); if (count($ids_array) > 0) { foreach ($ids_array as $id) { $ledger = new Ledger(); $ledger->populate($id); $ledger->setPayrollID($employee->getPayrollID()); $ledger_collection->add($ledger); // debugMessage($ledger->toArray()); } } } } } // fetch timesheets for each employeee $timesheets = $employee->getUser()->getTimesheetDetails($payroll->getStartDate(), $payroll->getEndDate()); if ($timesheets->count() > 0) { // debugMessage($timesheets->toArray()); foreach ($timesheets as $timesheet) { $timesheet->setPayrollID($employee->getPayrollID()); $timesheet_collection->add($timesheet); } } // generate leave accruals for period if ($employee->getLeaveHrs() > '0.00' && $employee->getUser()->getIsTimesheetuser() == 1) { // debugMessage('>'.$employee->getLeaveHrs()); $leave = new Ledger(); $leave_array = array("payrollid" => $payroll->getID(), "userid" => $employee->getUserID(), "ledgertype" => 2, "trxntype" => 1, "leaveid" => 1, "trxndate" => $payroll->getEndDate(), "startdate" => $payroll->getStartDate(), "enddate" => $payroll->getEndDate(), "leavelength" => $employee->getLeaveHrs() * getHoursInDay(), "lengthtype" => 1, "status" => 1, "remarks" => "Auto Accrual from Payroll (" . changeMySQLDateToPageFormat($payroll->getStartDate()) . " - " . changeMySQLDateToPageFormat($payroll->getEndDate()) . ") ", "createdby" => $session->getVar("userid"), "approvedbyid" => $session->getVar("userid"), "dateapproved" => date('Y-m-d'), "payrolltrigger" => 1); $leave->processPost($leave_array); /* debugMessage($leave->toArray()); debugMessage('errors are '.$leave->getErrorStackAsString()); */ if (!$leave->hasError()) { $leave_collection->add($leave); } } if ($employee->getSickHrs() > '0.00' && $employee->getUser()->getIsTimesheetuser() == 1) { // debugMessage('>'.$employee->getLeaveHrs()); $leave = new Ledger(); $leave_array = array("payrollid" => $payroll->getID(), "userid" => $employee->getUserID(), "ledgertype" => 2, "trxntype" => 1, "leaveid" => 2, "trxndate" => $payroll->getEndDate(), "startdate" => $payroll->getStartDate(), "enddate" => $payroll->getEndDate(), "leavelength" => $employee->getSickHrs() * getHoursInDay(), "lengthtype" => 1, "status" => 1, "remarks" => "Auto Accrued from Payroll (" . changeMySQLDateToPageFormat($payroll->getStartDate()) . " - " . changeMySQLDateToPageFormat($payroll->getEndDate()) . ") ", "createdby" => $session->getVar("userid"), "approvedbyid" => $session->getVar("userid"), "dateapproved" => date('Y-m-d'), "payrolltrigger" => 1); $leave->processPost($leave_array); /*debugMessage($leave->toArray()); debugMessage('errors are '.$leave->getErrorStackAsString()); */ if (!$leave->hasError()) { $leave_collection->add($leave); } } // generate recurring monthly benefits $newledgertrxns = array(); if (decode($employee->getrecurringtrxns()) != "[]" && $employee->getrecurringtrxns() != "W10=") { $newledgertrxns = objectToArray(json_decode(decode($employee->getrecurringtrxns()))); // debugMessage($newledgertrxns); foreach ($newledgertrxns as $line) { // debugMessage($line); foreach ($line as $key => $value) { $ledger = new Ledger(); $ledger_array = array("payrollid" => $payroll->getID(), "payrolltrigger" => 1, "userid" => $employee->getUserID(), "ledgertype" => 1, "trxntype" => $value['trxntype'], "benefitid" => $value['benefitid'], "trxndate" => $payroll->getEndDate(), "startdate" => $payroll->getStartDate(), "enddate" => $payroll->getEndDate(), "amount" => $value['amount'], "status" => 1, "remarks" => "Auto Accrued from Payroll (" . changeMySQLDateToPageFormat($payroll->getStartDate()) . " - " . changeMySQLDateToPageFormat($payroll->getEndDate()) . ") ", "createdby" => $session->getVar("userid"), "approvedbyid" => $session->getVar("userid"), "dateapproved" => date('Y-m-d'), "istaxable" => isArrayKeyAnEmptyString('istaxable', $value) ? 0 : $value['istaxable']); $ledger->processPost($ledger_array); /* debugMessage($ledger->toArray()); debugMessage('errors are '.$ledger->getErrorStackAsString()); */ if (!$ledger->hasError()) { $ledger_collection->add($ledger); } } } } // add nssf to benefits if it exists if ($employee->getNssf() > 0) { $ledger = new Ledger(); $ledger_array = array("payrollid" => $payroll->getID(), "payrolltrigger" => 1, "userid" => $employee->getUserID(), "ledgertype" => 1, "trxntype" => 2, "benefitid" => 19, "trxndate" => $payroll->getEndDate(), "startdate" => $payroll->getStartDate(), "enddate" => $payroll->getEndDate(), "amount" => $employee->getNssf(), "status" => 1, "remarks" => "Auto Accrued from Payroll (" . changeMySQLDateToPageFormat($payroll->getStartDate()) . " - " . changeMySQLDateToPageFormat($payroll->getEndDate()) . ") ", "createdby" => $session->getVar("userid"), "approvedbyid" => $session->getVar("userid"), "dateapproved" => date('Y-m-d')); $ledger->processPost($ledger_array); /* debugMessage($ledger->toArray()); debugMessage('errors are '.$ledger->getErrorStackAsString()); */ if (!$ledger->hasError()) { $ledger_collection->add($ledger); } } // add paye to benefits if it exists if ($employee->getPaye() > 0) { $ledger = new Ledger(); $ledger_array = array("payrollid" => $payroll->getID(), "payrolltrigger" => 1, "userid" => $employee->getUserID(), "ledgertype" => 1, "trxntype" => 2, "benefitid" => 20, "trxndate" => $payroll->getEndDate(), "startdate" => $payroll->getStartDate(), "enddate" => $payroll->getEndDate(), "amount" => $employee->getPaye(), "status" => 1, "remarks" => "Auto Accrued from Payroll (" . changeMySQLDateToPageFormat($payroll->getStartDate()) . " - " . changeMySQLDateToPageFormat($payroll->getEndDate()) . ") ", "createdby" => $session->getVar("userid"), "approvedbyid" => $session->getVar("userid"), "dateapproved" => date('Y-m-d')); $ledger->processPost($ledger_array); /* debugMessage($ledger->toArray()); debugMessage('errors are '.$ledger->getErrorStackAsString()); */ if (!$ledger->hasError()) { $ledger_collection->add($ledger); } } } // debugMessage('exiting here'); // exit; // save collection try { // update payroll status $payroll->save(); // update benefits on the payroll if ($ledger_collection->count() > 0) { // debugMessage($ledger_collection->toArray()); $ledger_collection->save(); } // update timesheets on the payroll if ($timesheet_collection->count() > 0) { // debugMessage($timesheet_collection->toArray()); $timesheet_collection->save(); } // assign leave benefits if ($leave_collection->count() > 0) { // debugMessage($leave_collection->toArray()); $leave_collection->save(); } // set success message $msg = "Payroll Successfully Completed and Approved. Please note that this has been locked from any further updates. "; if (!isEmptyString($this->_getParam(SUCCESS_MESSAGE))) { $msg = $this->_getParam($this->_translate->translate($this->_getParam(SUCCESS_MESSAGE))); } $session->setVar(SUCCESS_MESSAGE, $msg); // debugMessage('success '); exit; } catch (Exception $e) { $session->setVar(ERROR_MESSAGE, "Error in saving Payroll. " . $e->getMessage()); // debugMessage('Error in completing payroll. '.$e->getMessage()); exit; } $url = $this->view->baseUrl('payroll/list/id/' . encode($payroll->getID()) . '/issuepayslips/1'); if (!isEmptyString($this->_getParam(URL_SUCCESS))) { $url = decode($this->_getParam(URL_SUCCESS)); } $session->setVar("issuepayslips", '1'); $this->_helper->redirector->gotoUrl($url); }