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