public function loadLastReportedDate($wh_id)
{
$reports = new Model_Reports();
$reports->form_values = array("wh_id" => $wh_id);
$max_date = $reports->getLastCreatedDate();
//echo $max_date;
if (!empty($max_date)) {
return date("d/m/Y", strtotime($max_date));
} else {
return '-';
}
}
public function ajaxConsumption2Action()
{
$this->_helper->layout->setLayout('ajax');
if (isset($this->_request->do) && !empty($this->_request->do)) {
$base_url = Zend_Registry::get('baseurl');
$this->view->headLink()->appendStylesheet($base_url . '/common/assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.css');
$this->view->headLink()->appendStylesheet($base_url . '/common/assets/global/plugins/datatables/media/css/jquery.dataTables.css');
$this->view->inlineScript()->appendFile($base_url . '/common/theme/scripts/plugins/tables/DataTables/media/js/jquery.dataTables_1.js');
$this->view->inlineScript()->appendFile($base_url . '/common/theme/scripts/plugins/tables/DataTables/extras/TableTools/media/js/TableTools.js');
$this->view->inlineScript()->appendFile($base_url . '/common/theme/scripts/demo/tables.js');
$temp = $this->_request->do;
$warehouse_data = new Model_WarehousesData();
$warehouse_data->temp = $temp;
$arr_temp = $warehouse_data->monthlyConsumtionTemp();
$this->view->month = $arr_temp['month'];
$this->view->mm = $arr_temp['mm'];
$this->view->year = $arr_temp['yy'];
$this->view->is_new_report = $arr_temp['is_new_rpt'];
$this->view->prev_month_date = $arr_temp['prev_month_date'];
$this->view->check_date = $arr_temp['check_date'];
$this->view->first_month = Zend_Registry::get('first_month');
$item_pack_sizes = new Model_ItemPackSizes();
$item_pack_sizes->form_values = array('month' => $arr_temp['mm'], 'year' => $arr_temp['yy'], 'wh_id' => $arr_temp['wh_id']);
$items = $item_pack_sizes->monthlyConsumtion2();
$items_non_vaccines = $item_pack_sizes->monthlyConsumtion2_non_vaccinces();
$items_tt = $item_pack_sizes->monthlyConsumtion2_tt();
$this->view->rpt_date = $arr_temp['rpt_date'];
$this->view->wh_id = $arr_temp['wh_id'];
$this->view->items = $items;
$this->view->items_non_vaccinces = $items_non_vaccines;
$this->view->items_tt = $items_tt;
$reports = new Model_Reports();
$reports->form_values = array("wh_id" => $arr_temp['wh_id']);
$max_date = $reports->getLastModifiedDate();
if (!empty($max_date)) {
$this->view->modified_date = date("d/m/Y", strtotime($max_date));
}
}
}
public function simpleGraphsAction()
{
if ($this->_request->isPost()) {
$post = $this->_request->getPost();
$graphs = new Model_Graphs();
$graphs->form_values = $post;
$optvals = $post['optvals'];
if (in_array($optvals, array(9, 10, 11))) {
$xmlstore = $graphs->simpleGraphOptionYearNational();
}
$this->view->xmlstore = $xmlstore;
//print_r($post);
$this->view->chart_type = $post['ctype'];
$this->view->sel_indicator = $post['indicators'];
$this->view->sel_product = $post['products'];
$this->view->sel_optvals = $post['optvals'];
$this->view->sel_period = $post['period'];
$this->view->sel_year = $post['yearcomp'];
$this->view->sel_province = $post['all_provinces'];
$this->view->sel_district = $post['all_districts'];
if (in_array($optvals, array(10, 11))) {
$locations = new Model_Locations();
$locations->form_values = array('parent_id' => 10, 'geo_level_id' => 2);
$this->view->combo_provinces = $locations->getLocationsByLevel();
}
if ($optvals == 11) {
$location = new Model_Locations();
$location->form_values = array('province_id' => $post['all_provinces'], 'geo_level_id' => 4);
$this->view->combo_districts = $location->getLocationsByLevelByProvince();
}
} else {
$this->view->sel_optvals = 9;
}
$reports = new Model_Reports();
$indicators = $reports->getIndicators();
$this->view->indicators = $indicators;
$products = new Model_ItemPackSizes();
$product = $products->getAllItemsNonDil();
$this->view->product = $product;
$compare_option = array("Geographical" => array("9" => "National", "10" => "Provincial", "11" => "District"));
$this->view->compare_option = $compare_option;
$period = new Model_Period();
$time_intervals = $period->getTimeIntervals();
$this->view->time_intervals = $time_intervals;
$this->view->quarter = Model_Period::QUARTER;
$this->view->halfyear = Model_Period::HALFYEAR;
$this->view->annual = Model_Period::ANNUAL;
$years = array();
for ($i = 2013; $i <= date("Y"); $i++) {
$years[] = $i;
}
$this->view->years = $years;
$chart_type = array('Line' => "Line", 'Column3D' => "Bar");
$this->view->chart_types = $chart_type;
$this->view->main_heading = "Simple Graphs";
}
public function indexAction()
{
$request = $this->getRequest();
if ($request->getQuery('from')) {
$this->view->from = $request->getQuery('from');
} else {
$date = new JO_Date(null, 'yy-mm-01');
$this->view->from = $date->toString();
}
if ($request->getQuery('to')) {
$this->view->to = $request->getQuery('to');
} else {
$date = new JO_Date(null, 'yy-mm-t');
$this->view->to = $date->toString();
}
$reportData = Model_Reports::getReport($this->view->from, $this->view->to);
$depositData = Model_Reports::getDeposits($this->view->from, $this->view->to);
$withdrawData = Model_Reports::getWithdraws($this->view->from, $this->view->to);
$data = array();
foreach ($reportData as $date => $v) {
$data[$date] = array();
}
foreach ($depositData as $date => $v) {
$data[$date] = array();
}
foreach ($withdrawData as $date => $v) {
$data[$date] = array();
}
foreach ($data as $k => $v) {
if (isset($reportData[$k])) {
$data[$k]['total'] = $reportData[$k]['total'];
$data[$k]['receive'] = $reportData[$k]['receive'];
$data[$k]['referal'] = $reportData[$k]['referal'];
$data[$k]['win'] = $reportData[$k]['win'];
$data[$k]['total_for'] = WM_Currency::format($reportData[$k]['total']);
$data[$k]['receive_for'] = WM_Currency::format($reportData[$k]['receive']);
$data[$k]['referal_for'] = WM_Currency::format($reportData[$k]['referal']);
$data[$k]['win_for'] = WM_Currency::format($reportData[$k]['win']);
} else {
$data[$k]['total'] = 0;
$data[$k]['receive'] = 0;
$data[$k]['referal'] = 0;
$data[$k]['win'] = 0;
$data[$k]['total_for'] = WM_Currency::format(0);
$data[$k]['receive_for'] = WM_Currency::format(0);
$data[$k]['referal_for'] = WM_Currency::format(0);
$data[$k]['win_for'] = WM_Currency::format(0);
}
if (isset($depositData[$k])) {
$data[$k]['deposit'] = $depositData[$k]['deposit'];
$data[$k]['deposit_for'] = WM_Currency::format($depositData[$k]['deposit']);
} else {
$data[$k]['deposit'] = 0;
$data[$k]['deposit_for'] = WM_Currency::format(0);
}
if (isset($withdrawData[$k])) {
$data[$k]['withdraw'] = $withdrawData[$k]['amount'];
$data[$k]['withdraw_for'] = WM_Currency::format($withdrawData[$k]['amount']);
} else {
$data[$k]['withdraw'] = 0;
$data[$k]['withdraw_for'] = WM_Currency::format(0);
}
}
$this->view->reports = $data;
}
public function generateStockAvailabilityReport()
{
//$reports = new Model_Reports();
$reports = new Model_Reports();
$rs_warehouse_data = array();
$request_array = $this->temp;
if (!empty($request_array['tp']) && !empty($request_array['go'])) {
if (isset($request_array['item_id']) && !empty($request_array['item_id'])) {
$sel_item = $request_array['item_id'];
$q_str_pro = " AND warehouses_data.item_pack_size_id = " . $request_array['item_id'];
}
if (isset($request_array['stk_id']) && !empty($request_array['stk_id'])) {
if ($request_array['stk_id'] != 'all') {
$sel_stk = $request_array['stk_id'];
$q_str_stk = " AND warehouses.stakeholder_id = " . $request_array['stk_id'];
} else {
$q_str_stk = " ";
$sel_stk = $request_array['stk_id'];
}
}
if (isset($request_array['prov_sel']) && !empty($request_array['prov_sel'])) {
if ($request_array['prov_sel'] != 'all') {
$sel_prov = $request_array['prov_sel'];
$q_str_prov = " AND warehouses.province_id = " . $request_array['prov_sel'];
} else {
$sel_prov = $request_array['prov_sel'];
$q_str_prov = "";
}
}
} else {
if (!empty($request_array['go'])) {
if (isset($request_array['prod_sel']) && !empty($request_array['prod_sel']) && $request_array['prod_sel'] != 'all') {
$sel_item = $request_array['prod_sel'];
$q_str_pro = " AND warehouses_data.item_pack_size_id = " . $request_array['prod_sel'];
}
if (isset($request_array['stk_sel']) && !empty($request_array['stk_sel']) && $request_array['stk_sel'] != 'all') {
$sel_stk = $request_array['stk_sel'];
$q_str_stk = " AND warehouses.stakeholder_id = " . $request_array['stk_sel'];
} else {
$q_str_stk = " ";
$sel_stk = 1;
}
if (isset($request_array['prov_sel']) && !empty($request_array['prov_sel']) && $request_array['prov_sel'] != 'all') {
$sel_prov = $request_array['prov_sel'];
$q_str_prov = " AND warehouses.province_id = " . $request_array['prov_sel'];
} else {
$sel_prov = !isset($request_array['prov_id']) ? 0 : $request_array['prov_id'];
$q_str_prov = "";
}
} else {
$row_max_date = $reports->getMaxReportDate();
$this->temp['month_sel'] = $row_max_date[0]['report_month'];
$this->temp['year_sel'] = $row_max_date[0]['report_year'];
$sel_stk = '1';
$q_str_stk = " AND warehouses.stakeholder_id = 1";
$sel_item = '1';
$q_str_pro = " AND warehouses_data.item_pack_size_id = 1";
$sel_prov = '1';
$q_str_prov = " AND warehouses.province_id = 1";
}
}
$rs_warehouse_data['national'] = $this->getWarehouseDataByMonthAndYearForNational($q_str_pro, $q_str_stk);
$rs_warehouse_data['provincial'] = $this->getWarehouseDataByMonthAndYearForProvince($q_str_pro, $q_str_stk, $q_str_prov);
$rs_warehouse_data['district'] = $this->getWarehouseDataByMonthAndYearForDistrict($q_str_pro, $q_str_stk, $q_str_prov);
return $rs_warehouse_data;
}
