1: <?php
2: namespace Opencart\Admin\Controller\Extension\Opencart\Report;
3: /**
4: * Class Sale Return
5: *
6: * @package Opencart\Admin\Controller\Extension\Opencart\Report
7: */
8: class SaleReturn extends \Opencart\System\Engine\Controller {
9: /**
10: * Index
11: *
12: * @return void
13: */
14: public function index(): void {
15: $this->load->language('extension/opencart/report/sale_return');
16:
17: $this->document->setTitle($this->language->get('heading_title'));
18:
19: $data['breadcrumbs'] = [];
20:
21: $data['breadcrumbs'][] = [
22: 'text' => $this->language->get('text_home'),
23: 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'])
24: ];
25:
26: $data['breadcrumbs'][] = [
27: 'text' => $this->language->get('text_extension'),
28: 'href' => $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=report')
29: ];
30:
31: $data['breadcrumbs'][] = [
32: 'text' => $this->language->get('heading_title'),
33: 'href' => $this->url->link('extension/opencart/report/sale_return', 'user_token=' . $this->session->data['user_token'])
34: ];
35:
36: $data['save'] = $this->url->link('extension/opencart/report/sale_return.save', 'user_token=' . $this->session->data['user_token']);
37: $data['back'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=report');
38:
39: $data['report_sale_return_status'] = $this->config->get('report_sale_return_status');
40: $data['report_sale_return_sort_order'] = $this->config->get('report_sale_return_sort_order');
41:
42: $data['header'] = $this->load->controller('common/header');
43: $data['column_left'] = $this->load->controller('common/column_left');
44: $data['footer'] = $this->load->controller('common/footer');
45:
46: $this->response->setOutput($this->load->view('extension/opencart/report/sale_return_form', $data));
47: }
48:
49: /**
50: * Save
51: *
52: * @return void
53: */
54: public function save(): void {
55: $this->load->language('extension/opencart/report/sale_coupon');
56:
57: $json = [];
58:
59: if (!$this->user->hasPermission('modify', 'extension/opencart/report/sale_return')) {
60: $json['error'] = $this->language->get('error_permission');
61: }
62:
63: if (!$json) {
64: $this->load->model('setting/setting');
65:
66: $this->model_setting_setting->editSetting('report_sale_return', $this->request->post);
67:
68: $json['success'] = $this->language->get('text_success');
69: }
70:
71: $this->response->addHeader('Content-Type: application/json');
72: $this->response->setOutput(json_encode($json));
73: }
74:
75: /**
76: * Report
77: *
78: * @return void
79: */
80: public function report(): void {
81: $this->load->language('extension/opencart/report/sale_return');
82:
83: $data['list'] = $this->getReport();
84:
85: $this->load->model('localisation/return_status');
86:
87: $data['return_statuses'] = $this->model_localisation_return_status->getReturnStatuses();
88:
89: $data['groups'] = [];
90:
91: $data['groups'][] = [
92: 'text' => $this->language->get('text_year'),
93: 'value' => 'year',
94: ];
95:
96: $data['groups'][] = [
97: 'text' => $this->language->get('text_month'),
98: 'value' => 'month',
99: ];
100:
101: $data['groups'][] = [
102: 'text' => $this->language->get('text_week'),
103: 'value' => 'week',
104: ];
105:
106: $data['groups'][] = [
107: 'text' => $this->language->get('text_day'),
108: 'value' => 'day',
109: ];
110:
111: $data['user_token'] = $this->session->data['user_token'];
112:
113: $this->response->setOutput($this->load->view('extension/opencart/report/sale_return', $data));
114: }
115:
116: /**
117: * List
118: *
119: * @return void
120: */
121: public function list(): void {
122: $this->load->language('extension/opencart/report/sale_return');
123:
124: $this->response->setOutput($this->getReport());
125: }
126:
127: /**
128: * Get Report
129: *
130: * @return string
131: */
132: public function getReport(): string {
133: if (isset($this->request->get['filter_date_start'])) {
134: $filter_date_start = $this->request->get['filter_date_start'];
135: } else {
136: $filter_date_start = '';
137: }
138:
139: if (isset($this->request->get['filter_date_end'])) {
140: $filter_date_end = $this->request->get['filter_date_end'];
141: } else {
142: $filter_date_end = '';
143: }
144:
145: if (isset($this->request->get['filter_group'])) {
146: $filter_group = $this->request->get['filter_group'];
147: } else {
148: $filter_group = 'week';
149: }
150:
151: if (isset($this->request->get['filter_return_status_id'])) {
152: $filter_return_status_id = (int)$this->request->get['filter_return_status_id'];
153: } else {
154: $filter_return_status_id = 0;
155: }
156:
157: if (isset($this->request->get['page'])) {
158: $page = (int)$this->request->get['page'];
159: } else {
160: $page = 1;
161: }
162:
163: $data['returns'] = [];
164:
165: $filter_data = [
166: 'filter_date_start' => $filter_date_start,
167: 'filter_date_end' => $filter_date_end,
168: 'filter_group' => $filter_group,
169: 'filter_return_status_id' => $filter_return_status_id,
170: 'start' => ($page - 1) * $this->config->get('config_pagination'),
171: 'limit' => $this->config->get('config_pagination')
172: ];
173:
174: $this->load->model('extension/opencart/report/returns');
175:
176: $return_total = $this->model_extension_opencart_report_returns->getTotalReturns($filter_data);
177:
178: $results = $this->model_extension_opencart_report_returns->getReturns($filter_data);
179:
180: foreach ($results as $result) {
181: $data['returns'][] = [
182: 'date_start' => date($this->language->get('date_format_short'), strtotime($result['date_start'])),
183: 'date_end' => date($this->language->get('date_format_short'), strtotime($result['date_end'])),
184: 'returns' => $result['returns']
185: ];
186: }
187:
188: $url = '';
189:
190: if (isset($this->request->get['filter_date_start'])) {
191: $url .= '&filter_date_start=' . $this->request->get['filter_date_start'];
192: }
193:
194: if (isset($this->request->get['filter_date_end'])) {
195: $url .= '&filter_date_end=' . $this->request->get['filter_date_end'];
196: }
197:
198: if (isset($this->request->get['filter_group'])) {
199: $url .= '&filter_group=' . $this->request->get['filter_group'];
200: }
201:
202: if (isset($this->request->get['filter_return_status_id'])) {
203: $url .= '&filter_return_status_id=' . $this->request->get['filter_return_status_id'];
204: }
205:
206: $data['pagination'] = $this->load->controller('common/pagination', [
207: 'total' => $return_total,
208: 'page' => $page,
209: 'limit' => $this->config->get('config_pagination'),
210: 'url' => $this->url->link('extension/opencart/report/sale_return.report', 'user_token=' . $this->session->data['user_token'] . '&code=sale_return' . $url . '&page={page}')
211: ]);
212:
213: $data['results'] = sprintf($this->language->get('text_pagination'), ($return_total) ? (($page - 1) * $this->config->get('config_pagination')) + 1 : 0, ((($page - 1) * $this->config->get('config_pagination')) > ($return_total - $this->config->get('config_pagination'))) ? $return_total : ((($page - 1) * $this->config->get('config_pagination')) + $this->config->get('config_pagination')), $return_total, ceil($return_total / $this->config->get('config_pagination')));
214:
215: $data['filter_date_start'] = $filter_date_start;
216: $data['filter_date_end'] = $filter_date_end;
217: $data['filter_group'] = $filter_group;
218: $data['filter_return_status_id'] = $filter_return_status_id;
219:
220: $data['user_token'] = $this->session->data['user_token'];
221:
222: return $this->load->view('extension/opencart/report/sale_return_list', $data);
223: }
224: }
225: