public function rentGuaranteeAction() { $request = $this->getRequest(); $livergreport = new Connect_Form_LiveRGPoliciesReport(); $lapsedrgreport = new Connect_Form_LapsedRGPoliciesReport(); $this->view->livergreport = $livergreport; $this->view->lapsedrgreport = $lapsedrgreport; if ($request->isPost()) { $formdata = $request->getPost(); $livergreport->populate($formdata); $lapsedrgreport->populate($formdata); if ($livergreport->isValid($formdata) && isset($formdata['livergreport_producereport'])) { $startdate = new Zend_Date($livergreport->getElement('livergreport_start')->getValue(), Zend_Date::DAY . '/' . Zend_Date::MONTH . '/' . Zend_Date::YEAR); $enddate = new Zend_Date($livergreport->getElement('livergreport_end')->getValue(), Zend_Date::DAY . '/' . Zend_Date::MONTH . '/' . Zend_Date::YEAR); $report = new Datasource_Connect_Mi_InsuranceSales(); $this->view->reportdata = $report->liveRGPolicyForMonthYear($this->_agentSchemeNumber, $startdate, $enddate); $this->view->headLink()->appendStylesheet('/assets/connect/css/print.css', 'print'); $this->render('livergpolicies_report'); } else { if ($livergreport->isValid($formdata) && isset($formdata['livergreport_exporttoexcel'])) { $startdate = new Zend_Date($livergreport->getElement('livergreport_start')->getValue(), Zend_Date::DAY . '/' . Zend_Date::MONTH . '/' . Zend_Date::YEAR); $enddate = new Zend_Date($livergreport->getElement('livergreport_end')->getValue(), Zend_Date::DAY . '/' . Zend_Date::MONTH . '/' . Zend_Date::YEAR); $this->_sendCsvHeaders('live-rg-policies-report.csv'); $report = new Datasource_Connect_Mi_InsuranceSales(); $this->view->reportdata = $report->liveRGPolicyForMonthYear($this->_agentSchemeNumber, $startdate, $enddate); $this->_helper->getHelper('layout')->disableLayout(); $this->render('livergpolicies_csv'); } else { if ($lapsedrgreport->isValid($formdata) && isset($formdata['lapsedrgreport_producereport'])) { $startdate = new Zend_Date($lapsedrgreport->getElement('lapsedrgreport_start')->getValue(), Zend_Date::DAY . '/' . Zend_Date::MONTH . '/' . Zend_Date::YEAR); $enddate = new Zend_Date($lapsedrgreport->getElement('lapsedrgreport_end')->getValue(), Zend_Date::DAY . '/' . Zend_Date::MONTH . '/' . Zend_Date::YEAR); $report = new Datasource_Connect_Mi_InsuranceSales(); $this->view->reportdata = $report->lapsedRGPolicyForMonthYear($this->_agentSchemeNumber, $startdate, $enddate); $this->view->headLink()->appendStylesheet('/assets/connect/css/print.css', 'print'); $this->render('lapsedrgpolicies_report'); } else { if ($lapsedrgreport->isValid($formdata) && isset($formdata['lapsedrgreport_exporttoexcel'])) { $startdate = new Zend_Date($lapsedrgreport->getElement('lapsedrgreport_start')->getValue(), Zend_Date::DAY . '/' . Zend_Date::MONTH . '/' . Zend_Date::YEAR); $enddate = new Zend_Date($lapsedrgreport->getElement('lapsedrgreport_end')->getValue(), Zend_Date::DAY . '/' . Zend_Date::MONTH . '/' . Zend_Date::YEAR); $this->_sendCsvHeaders('lapsed-rg-policies-report.csv'); $report = new Datasource_Connect_Mi_InsuranceSales(); $this->view->reportdata = $report->lapsedRGPolicyForMonthYear($this->_agentSchemeNumber, $startdate, $enddate); $this->_helper->getHelper('layout')->disableLayout(); $this->render('lapsedrgpolicies_csv'); } } } } } }