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