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);
}
