chart.php
3.45 KB
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
<?php
class ControllerDashboardChart extends Controller {
public function index() {
$this->load->language('dashboard/chart');
$data['heading_title'] = $this->language->get('heading_title');
$data['text_day'] = $this->language->get('text_day');
$data['text_week'] = $this->language->get('text_week');
$data['text_month'] = $this->language->get('text_month');
$data['text_year'] = $this->language->get('text_year');
$data['text_view'] = $this->language->get('text_view');
$data['token'] = $this->session->data['token'];
return $this->load->view('dashboard/chart', $data);
}
public function chart() {
$this->load->language('dashboard/chart');
$json = array();
$this->load->model('report/sale');
$this->load->model('report/customer');
$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_report_sale->getTotalOrdersByDay();
foreach ($results as $key => $value) {
$json['order']['data'][] = array($key, $value['total']);
}
$results = $this->model_report_customer->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_report_sale->getTotalOrdersByWeek();
foreach ($results as $key => $value) {
$json['order']['data'][] = array($key, $value['total']);
}
$results = $this->model_report_customer->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_report_sale->getTotalOrdersByMonth();
foreach ($results as $key => $value) {
$json['order']['data'][] = array($key, $value['total']);
}
$results = $this->model_report_customer->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_report_sale->getTotalOrdersByYear();
foreach ($results as $key => $value) {
$json['order']['data'][] = array($key, $value['total']);
}
$results = $this->model_report_customer->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));
}
}