public function sufficientReportAction()
{
$base_url = Zend_Registry::get('baseurl');
$this->view->inlineScript()->appendFile($base_url . '/js/all_level_combos.js');
$this->view->role_id = $this->_identity->getRoleId();
$stock_master = new Model_StockMaster();
$result = $stock_master->getSufficientProductReport();
$today_date = new DateTime(date("Y-m-d"));
$last_year = $today_date->modify("-1 year");
$this->view->from_date = $from_date = $last_year->format('d F, Y');
$this->view->to_date = $to_date = date("d F, Y");
$this->view->result = $result;
$this->view->headTitle("Stock Sufficiency Report, {$from_date} - {$to_date}");
$xmlstore = "<chart exportEnabled='1' exportAction='Download' bgColor='white' caption='Stock Sufficiency Graph'\n exportFileName='District wise percentage of UCs having wastage > 50% " . date('Y-m-d H:i:s') . "' yAxisName='MOS (Avg. Issuance)' showValues='1' formatNumberScale='0' theme='fint' numberSuffix=''>";
foreach ($result as $data) {
echo $data['avg_issue'];
$month6 = ROUND($data['soh'] / $data['amc'], 1);
$month = $month6 > 0 ? $month6 . " months" : '';
$xmlstore .= "<set label='{$data['item_name']}' value='" . $month . "' />";
}
$xmlstore .= "</chart>";
$this->view->xml_store = $xmlstore;
}
