sale_order.php (7436B)
1 <?php 2 class ControllerExtensionReportSaleOrder extends Controller { 3 public function index() { 4 $this->load->language('extension/report/sale_order'); 5 6 $this->document->setTitle($this->language->get('heading_title')); 7 8 $this->load->model('setting/setting'); 9 10 if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validate()) { 11 $this->model_setting_setting->editSetting('report_sale_order', $this->request->post); 12 13 $this->session->data['success'] = $this->language->get('text_success'); 14 15 $this->response->redirect($this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=report', true)); 16 } 17 18 if (isset($this->error['warning'])) { 19 $data['error_warning'] = $this->error['warning']; 20 } else { 21 $data['error_warning'] = ''; 22 } 23 24 $data['breadcrumbs'] = array(); 25 26 $data['breadcrumbs'][] = array( 27 'text' => $this->language->get('text_home'), 28 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'], true) 29 ); 30 31 $data['breadcrumbs'][] = array( 32 'text' => $this->language->get('text_extension'), 33 'href' => $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=report', true) 34 ); 35 36 $data['breadcrumbs'][] = array( 37 'text' => $this->language->get('heading_title'), 38 'href' => $this->url->link('extension/report/sale_order', 'user_token=' . $this->session->data['user_token'], true) 39 ); 40 41 $data['action'] = $this->url->link('extension/report/sale_order', 'user_token=' . $this->session->data['user_token'], true); 42 43 $data['cancel'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=report', true); 44 45 if (isset($this->request->post['report_sale_order_status'])) { 46 $data['report_sale_order_status'] = $this->request->post['report_sale_order_status']; 47 } else { 48 $data['report_sale_order_status'] = $this->config->get('report_sale_order_status'); 49 } 50 51 if (isset($this->request->post['report_sale_order_sort_order'])) { 52 $data['report_sale_order_sort_order'] = $this->request->post['report_sale_order_sort_order']; 53 } else { 54 $data['report_sale_order_sort_order'] = $this->config->get('report_sale_order_sort_order'); 55 } 56 57 $data['header'] = $this->load->controller('common/header'); 58 $data['column_left'] = $this->load->controller('common/column_left'); 59 $data['footer'] = $this->load->controller('common/footer'); 60 61 $this->response->setOutput($this->load->view('extension/report/sale_order_form', $data)); 62 } 63 64 protected function validate() { 65 if (!$this->user->hasPermission('modify', 'extension/report/sale_order')) { 66 $this->error['warning'] = $this->language->get('error_permission'); 67 } 68 69 return !$this->error; 70 } 71 72 public function report() { 73 $this->load->language('extension/report/sale_order'); 74 75 if (isset($this->request->get['filter_date_start'])) { 76 $filter_date_start = $this->request->get['filter_date_start']; 77 } else { 78 $filter_date_start = date('Y-m-d', strtotime(date('Y') . '-' . date('m') . '-01')); 79 } 80 81 if (isset($this->request->get['filter_date_end'])) { 82 $filter_date_end = $this->request->get['filter_date_end']; 83 } else { 84 $filter_date_end = date('Y-m-d'); 85 } 86 87 if (isset($this->request->get['filter_group'])) { 88 $filter_group = $this->request->get['filter_group']; 89 } else { 90 $filter_group = 'week'; 91 } 92 93 if (isset($this->request->get['filter_order_status_id'])) { 94 $filter_order_status_id = $this->request->get['filter_order_status_id']; 95 } else { 96 $filter_order_status_id = 0; 97 } 98 99 if (isset($this->request->get['page'])) { 100 $page = $this->request->get['page']; 101 } else { 102 $page = 1; 103 } 104 105 $this->load->model('extension/report/sale'); 106 107 $data['orders'] = array(); 108 109 $filter_data = array( 110 'filter_date_start' => $filter_date_start, 111 'filter_date_end' => $filter_date_end, 112 'filter_group' => $filter_group, 113 'filter_order_status_id' => $filter_order_status_id, 114 'start' => ($page - 1) * $this->config->get('config_limit_admin'), 115 'limit' => $this->config->get('config_limit_admin') 116 ); 117 118 $order_total = $this->model_extension_report_sale->getTotalOrders($filter_data); 119 120 $results = $this->model_extension_report_sale->getOrders($filter_data); 121 122 foreach ($results as $result) { 123 $data['orders'][] = array( 124 'date_start' => date($this->language->get('date_format_short'), strtotime($result['date_start'])), 125 'date_end' => date($this->language->get('date_format_short'), strtotime($result['date_end'])), 126 'orders' => $result['orders'], 127 'products' => $result['products'], 128 'tax' => $this->currency->format($result['tax'], $this->config->get('config_currency')), 129 'total' => $this->currency->format($result['total'], $this->config->get('config_currency')) 130 ); 131 } 132 133 $data['user_token'] = $this->session->data['user_token']; 134 135 $this->load->model('localisation/order_status'); 136 137 $data['order_statuses'] = $this->model_localisation_order_status->getOrderStatuses(); 138 139 $data['groups'] = array(); 140 141 $data['groups'][] = array( 142 'text' => $this->language->get('text_year'), 143 'value' => 'year', 144 ); 145 146 $data['groups'][] = array( 147 'text' => $this->language->get('text_month'), 148 'value' => 'month', 149 ); 150 151 $data['groups'][] = array( 152 'text' => $this->language->get('text_week'), 153 'value' => 'week', 154 ); 155 156 $data['groups'][] = array( 157 'text' => $this->language->get('text_day'), 158 'value' => 'day', 159 ); 160 161 $url = ''; 162 163 if (isset($this->request->get['filter_date_start'])) { 164 $url .= '&filter_date_start=' . $this->request->get['filter_date_start']; 165 } 166 167 if (isset($this->request->get['filter_date_end'])) { 168 $url .= '&filter_date_end=' . $this->request->get['filter_date_end']; 169 } 170 171 if (isset($this->request->get['filter_group'])) { 172 $url .= '&filter_group=' . $this->request->get['filter_group']; 173 } 174 175 if (isset($this->request->get['filter_order_status_id'])) { 176 $url .= '&filter_order_status_id=' . $this->request->get['filter_order_status_id']; 177 } 178 179 $pagination = new Pagination(); 180 $pagination->total = $order_total; 181 $pagination->page = $page; 182 $pagination->limit = $this->config->get('config_limit_admin'); 183 $pagination->url = $this->url->link('report/report', 'user_token=' . $this->session->data['user_token'] . '&code=sale_order' . $url . '&page={page}', true); 184 185 $data['pagination'] = $pagination->render(); 186 187 $data['results'] = sprintf($this->language->get('text_pagination'), ($order_total) ? (($page - 1) * $this->config->get('config_limit_admin')) + 1 : 0, ((($page - 1) * $this->config->get('config_limit_admin')) > ($order_total - $this->config->get('config_limit_admin'))) ? $order_total : ((($page - 1) * $this->config->get('config_limit_admin')) + $this->config->get('config_limit_admin')), $order_total, ceil($order_total / $this->config->get('config_limit_admin'))); 188 189 $data['filter_date_start'] = $filter_date_start; 190 $data['filter_date_end'] = $filter_date_end; 191 $data['filter_group'] = $filter_group; 192 $data['filter_order_status_id'] = $filter_order_status_id; 193 194 return $this->load->view('extension/report/sale_order_info', $data); 195 } 196 }