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