1: <?php
2: namespace Opencart\Admin\Controller\Extension\Opencart\Dashboard;
3: /**
4: * Class Chart
5: *
6: * @package Opencart\Admin\Controller\Extension\Opencart\Dashboard
7: */
8: class Chart extends \Opencart\System\Engine\Controller {
9: /**
10: * Index
11: *
12: * @return void
13: */
14: public function index(): void {
15: $this->load->language('extension/opencart/dashboard/chart');
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=dashboard')
29: ];
30:
31: $data['breadcrumbs'][] = [
32: 'text' => $this->language->get('heading_title'),
33: 'href' => $this->url->link('extension/opencart/dashboard/chart', 'user_token=' . $this->session->data['user_token'])
34: ];
35:
36: $data['save'] = $this->url->link('extension/opencart/dashboard/chart.save', 'user_token=' . $this->session->data['user_token']);
37: $data['back'] = $this->url->link('marketplace/extension', 'user_token=' . $this->session->data['user_token'] . '&type=dashboard');
38:
39: $data['dashboard_chart_width'] = $this->config->get('dashboard_chart_width');
40:
41: $data['columns'] = [];
42:
43: for ($i = 3; $i <= 12; $i++) {
44: $data['columns'][] = $i;
45: }
46:
47: $data['dashboard_chart_status'] = $this->config->get('dashboard_chart_status');
48: $data['dashboard_chart_sort_order'] = $this->config->get('dashboard_chart_sort_order');
49:
50: $data['header'] = $this->load->controller('common/header');
51: $data['column_left'] = $this->load->controller('common/column_left');
52: $data['footer'] = $this->load->controller('common/footer');
53:
54: $this->response->setOutput($this->load->view('extension/opencart/dashboard/chart_form', $data));
55: }
56:
57: /**
58: * Save
59: *
60: * @return void
61: */
62: public function save(): void {
63: $this->load->language('extension/opencart/dashboard/chart');
64:
65: $json = [];
66:
67: if (!$this->user->hasPermission('modify', 'extension/opencart/dashboard/chart')) {
68: $json['error'] = $this->language->get('error_permission');
69: }
70:
71: if (!$json) {
72: $this->load->model('setting/setting');
73:
74: $this->model_setting_setting->editSetting('dashboard_chart', $this->request->post);
75:
76: $json['success'] = $this->language->get('text_success');
77: }
78:
79: $this->response->addHeader('Content-Type: application/json');
80: $this->response->setOutput(json_encode($json));
81: }
82:
83: /**
84: * Dashboard
85: *
86: * @return string
87: */
88: public function dashboard(): string {
89: $this->load->language('extension/opencart/dashboard/chart');
90:
91: $data['user_token'] = $this->session->data['user_token'];
92:
93: return $this->load->view('extension/opencart/dashboard/chart_info', $data);
94: }
95:
96: /**
97: * Chart
98: *
99: * @return void
100: */
101: public function chart(): void {
102: $this->load->language('extension/opencart/dashboard/chart');
103:
104: $json = [];
105:
106: $this->load->model('extension/opencart/report/customer');
107: $this->load->model('extension/opencart/report/sale');
108:
109: $json['order'] = [];
110: $json['customer'] = [];
111: $json['xaxis'] = [];
112:
113: $json['order']['label'] = $this->language->get('text_order');
114: $json['customer']['label'] = $this->language->get('text_customer');
115: $json['order']['data'] = [];
116: $json['customer']['data'] = [];
117:
118: if (isset($this->request->get['range'])) {
119: $range = $this->request->get['range'];
120: } else {
121: $range = 'day';
122: }
123:
124: switch ($range) {
125: default:
126: case 'day':
127: $results = $this->model_extension_opencart_report_sale->getTotalOrdersByDay();
128:
129: foreach ($results as $key => $value) {
130: $json['order']['data'][] = [$key, $value['total']];
131: }
132:
133: $results = $this->model_extension_opencart_report_customer->getTotalCustomersByDay();
134:
135: foreach ($results as $key => $value) {
136: $json['customer']['data'][] = [$key, $value['total']];
137: }
138:
139: for ($i = 0; $i < 24; $i++) {
140: $json['xaxis'][] = [$i, $i];
141: }
142: break;
143: case 'week':
144: $results = $this->model_extension_opencart_report_sale->getTotalOrdersByWeek();
145:
146: foreach ($results as $key => $value) {
147: $json['order']['data'][] = [$key, $value['total']];
148: }
149:
150: $results = $this->model_extension_opencart_report_customer->getTotalCustomersByWeek();
151:
152: foreach ($results as $key => $value) {
153: $json['customer']['data'][] = [$key, $value['total']];
154: }
155:
156: $date_start = strtotime('-' . date('w') . ' days');
157:
158: for ($i = 0; $i < 7; $i++) {
159: $date = date('Y-m-d', $date_start + ($i * 86400));
160:
161: $json['xaxis'][] = [date('w', strtotime($date)), date('D', strtotime($date))];
162: }
163: break;
164: case 'month':
165: $results = $this->model_extension_opencart_report_sale->getTotalOrdersByMonth();
166:
167: foreach ($results as $key => $value) {
168: $json['order']['data'][] = [$key, $value['total']];
169: }
170:
171: $results = $this->model_extension_opencart_report_customer->getTotalCustomersByMonth();
172:
173: foreach ($results as $key => $value) {
174: $json['customer']['data'][] = [$key, $value['total']];
175: }
176:
177: for ($i = 1; $i <= date('t'); $i++) {
178: $date = date('Y') . '-' . date('m') . '-' . $i;
179:
180: $json['xaxis'][] = [date('j', strtotime($date)), date('d', strtotime($date))];
181: }
182: break;
183: case 'year':
184: $results = $this->model_extension_opencart_report_sale->getTotalOrdersByYear();
185:
186: foreach ($results as $key => $value) {
187: $json['order']['data'][] = [$key, $value['total']];
188: }
189:
190: $results = $this->model_extension_opencart_report_customer->getTotalCustomersByYear();
191:
192: foreach ($results as $key => $value) {
193: $json['customer']['data'][] = [$key, $value['total']];
194: }
195:
196: for ($i = 1; $i <= 12; $i++) {
197: $json['xaxis'][] = [$i, date('M', mktime(0, 0, 0, $i, 1))];
198: }
199: break;
200: }
201:
202: $this->response->addHeader('Content-Type: application/json');
203: $this->response->setOutput(json_encode($json));
204: }
205: }
206: