public function vvmStageStatusAction()
{
$district = $this->_request->getParam("district");
$province = $this->_request->getParam("province");
$date = $this->_request->getParam("date");
$item = $this->_request->getParam("item");
$level = $this->_request->getParam("level");
$warehouse = new Model_Locations();
$warehouse->form_values = array('level' => $level, 'prov_id' => $province, 'loc_id' => $district);
$wh_id = $warehouse->getWarehouseByLevel();
$wh_data = new Model_WarehousesData();
$params["date"] = $date;
$params["item"] = $item;
$params["wh_id"] = $wh_id;
$params["type"] = 1;
$wh_data->form_values = $params;
$xmlstore = $wh_data->vvmStageStatus();
$this->view->xmlstore = $xmlstore;
$data = $wh_data->vvmStageStatusByVvmStage();
$this->view->data = $data;
}
public function stockIssue()
{
$where = "";
if (!empty($this->form_values['item'])) {
$where = " AND stock_batch.item_pack_size_id = " . $this->form_values['item'] . "";
}
$level = $this->form_values['level'];
$loc_id = $this->form_values['loc_id'];
$prov_id = $this->form_values['prov_id'];
$warehouse = new Model_Locations();
$warehouse->form_values = array('level' => $level, 'prov_id' => $prov_id, 'loc_id' => $loc_id);
$wh_id = $warehouse->getWarehouseByLevel();
$str_sql = "SELECT\n item_pack_sizes.item_name,\n SUM(ABS(stock_detail.quantity)) AS Qty,\n warehouses.warehouse_name,\n stock_master.transaction_date\n FROM\n stock_batch\n INNER JOIN stock_detail ON stock_detail.stock_batch_id = stock_batch.pk_id\n INNER JOIN stock_master ON stock_detail.stock_master_id = stock_master.pk_id\n INNER JOIN item_pack_sizes ON stock_batch.item_pack_size_id = item_pack_sizes.pk_id\n INNER JOIN warehouses ON stock_master.to_warehouse_id = warehouses.pk_id\n INNER JOIN stakeholders ON warehouses.stakeholder_office_id = stakeholders.pk_id\n WHERE\n stock_master.transaction_type_id = 2\n AND warehouses.status = 1\n AND DATE_FORMAT(stock_master.transaction_date, '%Y-%m') = '" . $this->form_values['date'] . "' AND\n stock_master.from_warehouse_id = {$wh_id}\n {$where}\n GROUP BY\n stock_batch.item_pack_size_id,\n warehouses.pk_id\n ORDER BY\n Qty DESC\n LIMIT 30";
$row = $this->_em->getConnection()->prepare($str_sql);
$row->execute();
$result = $row->fetchAll();
if ($this->form_values['level'] = 1) {
$level = 'National Level';
} else {
if ($this->form_values['level'] = 2) {
$level = 'Provincial Level';
} else {
if ($this->form_values['level'] = 3) {
$level = 'District Level';
}
}
}
$item_pack_sizes = new Model_ItemPackSizes();
$item_pack_sizes->form_values['pk_id'] = $this->form_values['item'];
$item = $item_pack_sizes->getProductName();
$xmlstore = "<chart labelDisplay='rotate' slantLabels='1' exportEnabled='1' exportAction='Download' caption='National Level - Stock Issue Status(Vials)' subCaption = '{$item} " . ("(" . date('M Y', strtotime($this->form_values['date'])) . ")") . "' exportFileName='Stock Issue " . date('Y-m-d H:i:s') . "' yAxisName='Vials' showValues='1' formatNumberScale='0'>";
foreach ($result as $row) {
$xmlstore .= "<set label='{$row['warehouse_name']}' value='{$row['Qty']}' />";
}
$xmlstore .= "</chart>";
return $xmlstore;
}
