function getPayrolls($start, $end) { $companyid = getCompanyID(); $conn = Doctrine_Manager::connection(); $query = "SELECT * FROM payroll AS p where p.`companyid` = '" . $companyid . "' AND MONTH(p.startdate) = MONTH('" . $start . "') "; // debugMessage($query); $result = $conn->fetchRow($query); if (!$result) { $payroll = new Payroll(); $result = $payroll->toArray(); } // debugMessage($result); return $result; }
public function deleteAction() { $this->_setParam("action", ACTION_DELETE); $session = SessionWrapper::getInstance(); $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(TRUE); $formvalues = $this->_getAllParams(); // debugMessage($formvalues); // exit; $successurl = decode($formvalues[URL_SUCCESS]); if (!isArrayKeyAnEmptyString(SUCCESS_MESSAGE, $formvalues)) { $successmessage = decode($formvalues[SUCCESS_MESSAGE]); } // debugMessage($successurl); $payroll = new Payroll(); $id = is_numeric($formvalues['id']) ? $formvalues['id'] : decode($formvalues['id']); // debugMessage($id); $payroll->populate($id); debugMessage($payroll->toArray()); $deletetrxns = $payroll->getLedgerDeleteTrxns(); if ($deletetrxns->count() > 0) { $deletetrxns->delete(); } /* debugMessage($payroll->getLedgerDeleteTrxns()->toArray()); exit(); */ if ($payroll->delete()) { $session->setVar(SUCCESS_MESSAGE, $this->_translate->translate("global_delete_success")); $successmessage = $this->_getParam(SUCCESS_MESSAGE); if (!isEmptyString($successmessage)) { $session->setVar(SUCCESS_MESSAGE, $successmessage); } } $this->_helper->redirector->gotoUrl($successurl); }