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