1: | <?php
|
2: | namespace Opencart\Admin\Controller\Marketing;
|
3: | |
4: | |
5: | |
6: | |
7: |
|
8: | class Marketing extends \Opencart\System\Engine\Controller {
|
9: | |
10: | |
11: | |
12: | |
13: |
|
14: | public function index(): void {
|
15: | $this->load->language('marketing/marketing');
|
16: |
|
17: | $this->document->setTitle($this->language->get('heading_title'));
|
18: |
|
19: | if (isset($this->request->get['filter_name'])) {
|
20: | $filter_name = $this->request->get['filter_name'];
|
21: | } else {
|
22: | $filter_name = '';
|
23: | }
|
24: |
|
25: | if (isset($this->request->get['filter_code'])) {
|
26: | $filter_code = $this->request->get['filter_code'];
|
27: | } else {
|
28: | $filter_code = '';
|
29: | }
|
30: |
|
31: | if (isset($this->request->get['filter_date_from'])) {
|
32: | $filter_date_from = $this->request->get['filter_date_from'];
|
33: | } else {
|
34: | $filter_date_from = '';
|
35: | }
|
36: |
|
37: | if (isset($this->request->get['filter_date_to'])) {
|
38: | $filter_date_to = $this->request->get['filter_date_to'];
|
39: | } else {
|
40: | $filter_date_to = '';
|
41: | }
|
42: |
|
43: | $url = '';
|
44: |
|
45: | if (isset($this->request->get['filter_name'])) {
|
46: | $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
|
47: | }
|
48: |
|
49: | if (isset($this->request->get['filter_code'])) {
|
50: | $url .= '&filter_code=' . $this->request->get['filter_code'];
|
51: | }
|
52: |
|
53: | if (isset($this->request->get['filter_date_from'])) {
|
54: | $url .= '&filter_date_from=' . $this->request->get['filter_date_from'];
|
55: | }
|
56: |
|
57: | if (isset($this->request->get['filter_date_to'])) {
|
58: | $url .= '&filter_date_to=' . $this->request->get['filter_date_to'];
|
59: | }
|
60: |
|
61: | if (isset($this->request->get['sort'])) {
|
62: | $url .= '&sort=' . $this->request->get['sort'];
|
63: | }
|
64: |
|
65: | if (isset($this->request->get['order'])) {
|
66: | $url .= '&order=' . $this->request->get['order'];
|
67: | }
|
68: |
|
69: | if (isset($this->request->get['page'])) {
|
70: | $url .= '&page=' . $this->request->get['page'];
|
71: | }
|
72: |
|
73: | $data['breadcrumbs'] = [];
|
74: |
|
75: | $data['breadcrumbs'][] = [
|
76: | 'text' => $this->language->get('text_home'),
|
77: | 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'])
|
78: | ];
|
79: |
|
80: | $data['breadcrumbs'][] = [
|
81: | 'text' => $this->language->get('heading_title'),
|
82: | 'href' => $this->url->link('marketing/marketing', 'user_token=' . $this->session->data['user_token'] . $url)
|
83: | ];
|
84: |
|
85: | $data['add'] = $this->url->link('marketing/marketing.form', 'user_token=' . $this->session->data['user_token'] . $url);
|
86: | $data['delete'] = $this->url->link('marketing/marketing.delete', 'user_token=' . $this->session->data['user_token']);
|
87: |
|
88: | $data['list'] = $this->getList();
|
89: |
|
90: | $data['filter_name'] = $filter_name;
|
91: | $data['filter_code'] = $filter_code;
|
92: | $data['filter_date_from'] = $filter_date_from;
|
93: | $data['filter_date_to'] = $filter_date_to;
|
94: |
|
95: | $data['user_token'] = $this->session->data['user_token'];
|
96: |
|
97: | $data['header'] = $this->load->controller('common/header');
|
98: | $data['column_left'] = $this->load->controller('common/column_left');
|
99: | $data['footer'] = $this->load->controller('common/footer');
|
100: |
|
101: | $this->response->setOutput($this->load->view('marketing/marketing', $data));
|
102: | }
|
103: |
|
104: | |
105: | |
106: | |
107: | |
108: |
|
109: | public function list(): void {
|
110: | $this->load->language('marketing/marketing');
|
111: |
|
112: | $this->response->setOutput($this->getList());
|
113: | }
|
114: |
|
115: | |
116: | |
117: | |
118: | |
119: |
|
120: | protected function getList(): string {
|
121: | if (isset($this->request->get['filter_name'])) {
|
122: | $filter_name = $this->request->get['filter_name'];
|
123: | } else {
|
124: | $filter_name = '';
|
125: | }
|
126: |
|
127: | if (isset($this->request->get['filter_code'])) {
|
128: | $filter_code = $this->request->get['filter_code'];
|
129: | } else {
|
130: | $filter_code = '';
|
131: | }
|
132: |
|
133: | if (isset($this->request->get['filter_date_from'])) {
|
134: | $filter_date_from = (string)$this->request->get['filter_date_from'];
|
135: | } else {
|
136: | $filter_date_from = '';
|
137: | }
|
138: |
|
139: | if (isset($this->request->get['filter_date_to'])) {
|
140: | $filter_date_to = (string)$this->request->get['filter_date_to'];
|
141: | } else {
|
142: | $filter_date_to = '';
|
143: | }
|
144: |
|
145: | if (isset($this->request->get['sort'])) {
|
146: | $sort = (string)$this->request->get['sort'];
|
147: | } else {
|
148: | $sort = 'm.name';
|
149: | }
|
150: |
|
151: | if (isset($this->request->get['order'])) {
|
152: | $order = (string)$this->request->get['order'];
|
153: | } else {
|
154: | $order = 'ASC';
|
155: | }
|
156: |
|
157: | if (isset($this->request->get['page'])) {
|
158: | $page = (int)$this->request->get['page'];
|
159: | } else {
|
160: | $page = 1;
|
161: | }
|
162: |
|
163: | $url = '';
|
164: |
|
165: | if (isset($this->request->get['filter_name'])) {
|
166: | $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
|
167: | }
|
168: |
|
169: | if (isset($this->request->get['filter_code'])) {
|
170: | $url .= '&filter_code=' . $this->request->get['filter_code'];
|
171: | }
|
172: |
|
173: | if (isset($this->request->get['filter_date_from'])) {
|
174: | $url .= '&filter_date_from=' . $this->request->get['filter_date_from'];
|
175: | }
|
176: |
|
177: | if (isset($this->request->get['filter_date_to'])) {
|
178: | $url .= '&filter_date_to=' . $this->request->get['filter_date_to'];
|
179: | }
|
180: |
|
181: | if (isset($this->request->get['sort'])) {
|
182: | $url .= '&sort=' . $this->request->get['sort'];
|
183: | }
|
184: |
|
185: | if (isset($this->request->get['order'])) {
|
186: | $url .= '&order=' . $this->request->get['order'];
|
187: | }
|
188: |
|
189: | if (isset($this->request->get['page'])) {
|
190: | $url .= '&page=' . $this->request->get['page'];
|
191: | }
|
192: |
|
193: | $data['action'] = $this->url->link('marketing/marketing.list', 'user_token=' . $this->session->data['user_token'] . $url);
|
194: |
|
195: | $data['marketings'] = [];
|
196: |
|
197: | $filter_data = [
|
198: | 'filter_name' => $filter_name,
|
199: | 'filter_code' => $filter_code,
|
200: | 'filter_date_from' => $filter_date_from,
|
201: | 'filter_date_to' => $filter_date_to,
|
202: | 'sort' => $sort,
|
203: | 'order' => $order,
|
204: | 'start' => ($page - 1) * $this->config->get('config_pagination_admin'),
|
205: | 'limit' => $this->config->get('config_pagination_admin')
|
206: | ];
|
207: |
|
208: | $this->load->model('marketing/marketing');
|
209: |
|
210: | $results = $this->model_marketing_marketing->getMarketings($filter_data);
|
211: |
|
212: | foreach ($results as $result) {
|
213: | $data['marketings'][] = [
|
214: | 'marketing_id' => $result['marketing_id'],
|
215: | 'name' => $result['name'],
|
216: | 'code' => $result['code'],
|
217: | 'clicks' => $result['clicks'],
|
218: | 'orders' => $result['orders'],
|
219: | 'date_added' => date($this->language->get('date_format_short'), strtotime($result['date_added'])),
|
220: | 'edit' => $this->url->link('marketing/marketing.form', 'user_token=' . $this->session->data['user_token'] . '&marketing_id=' . $result['marketing_id'] . $url)
|
221: | ];
|
222: | }
|
223: |
|
224: | $url = '';
|
225: |
|
226: | if (isset($this->request->get['filter_name'])) {
|
227: | $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
|
228: | }
|
229: |
|
230: | if (isset($this->request->get['filter_code'])) {
|
231: | $url .= '&filter_code=' . $this->request->get['filter_code'];
|
232: | }
|
233: |
|
234: | if (isset($this->request->get['filter_date_from'])) {
|
235: | $url .= '&filter_date_from=' . $this->request->get['filter_date_from'];
|
236: | }
|
237: |
|
238: | if (isset($this->request->get['filter_date_to'])) {
|
239: | $url .= '&filter_date_to=' . $this->request->get['filter_date_to'];
|
240: | }
|
241: |
|
242: | if ($order == 'ASC') {
|
243: | $url .= '&order=DESC';
|
244: | } else {
|
245: | $url .= '&order=ASC';
|
246: | }
|
247: |
|
248: | $data['sort_name'] = $this->url->link('marketing/marketing.list', 'user_token=' . $this->session->data['user_token'] . '&sort=m.name' . $url);
|
249: | $data['sort_code'] = $this->url->link('marketing/marketing.list', 'user_token=' . $this->session->data['user_token'] . '&sort=m.code' . $url);
|
250: | $data['sort_date_added'] = $this->url->link('marketing/marketing.list', 'user_token=' . $this->session->data['user_token'] . '&sort=m.date_added' . $url);
|
251: |
|
252: | $url = '';
|
253: |
|
254: | if (isset($this->request->get['filter_name'])) {
|
255: | $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
|
256: | }
|
257: |
|
258: | if (isset($this->request->get['filter_code'])) {
|
259: | $url .= '&filter_code=' . $this->request->get['filter_code'];
|
260: | }
|
261: |
|
262: | if (isset($this->request->get['filter_date_from'])) {
|
263: | $url .= '&filter_date_from=' . $this->request->get['filter_date_from'];
|
264: | }
|
265: |
|
266: | if (isset($this->request->get['filter_date_to'])) {
|
267: | $url .= '&filter_date_to=' . $this->request->get['filter_date_to'];
|
268: | }
|
269: |
|
270: | if (isset($this->request->get['sort'])) {
|
271: | $url .= '&sort=' . $this->request->get['sort'];
|
272: | }
|
273: |
|
274: | if (isset($this->request->get['order'])) {
|
275: | $url .= '&order=' . $this->request->get['order'];
|
276: | }
|
277: |
|
278: | $marketing_total = $this->model_marketing_marketing->getTotalMarketings($filter_data);
|
279: |
|
280: | $data['pagination'] = $this->load->controller('common/pagination', [
|
281: | 'total' => $marketing_total,
|
282: | 'page' => $page,
|
283: | 'limit' => $this->config->get('config_pagination_admin'),
|
284: | 'url' => $this->url->link('marketing/marketing.list', 'user_token=' . $this->session->data['user_token'] . $url . '&page={page}')
|
285: | ]);
|
286: |
|
287: | $data['results'] = sprintf($this->language->get('text_pagination'), ($marketing_total) ? (($page - 1) * $this->config->get('config_pagination_admin')) + 1 : 0, ((($page - 1) * $this->config->get('config_pagination_admin')) > ($marketing_total - $this->config->get('config_pagination_admin'))) ? $marketing_total : ((($page - 1) * $this->config->get('config_pagination_admin')) + $this->config->get('config_pagination_admin')), $marketing_total, ceil($marketing_total / $this->config->get('config_pagination_admin')));
|
288: |
|
289: | $data['sort'] = $sort;
|
290: | $data['order'] = $order;
|
291: |
|
292: | return $this->load->view('marketing/marketing_list', $data);
|
293: | }
|
294: |
|
295: | |
296: | |
297: | |
298: | |
299: |
|
300: | public function form(): void {
|
301: | $this->load->language('marketing/marketing');
|
302: |
|
303: | $this->document->setTitle($this->language->get('heading_title'));
|
304: |
|
305: | $data['text_form'] = !isset($this->request->get['marketing_id']) ? $this->language->get('text_add') : $this->language->get('text_edit');
|
306: |
|
307: | $url = '';
|
308: |
|
309: | if (isset($this->request->get['filter_name'])) {
|
310: | $url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
|
311: | }
|
312: |
|
313: | if (isset($this->request->get['filter_code'])) {
|
314: | $url .= '&filter_code=' . $this->request->get['filter_code'];
|
315: | }
|
316: |
|
317: | if (isset($this->request->get['filter_date_from'])) {
|
318: | $url .= '&filter_date_from=' . $this->request->get['filter_date_from'];
|
319: | }
|
320: |
|
321: | if (isset($this->request->get['filter_date_to'])) {
|
322: | $url .= '&filter_date_to=' . $this->request->get['filter_date_to'];
|
323: | }
|
324: |
|
325: | if (isset($this->request->get['sort'])) {
|
326: | $url .= '&sort=' . $this->request->get['sort'];
|
327: | }
|
328: |
|
329: | if (isset($this->request->get['order'])) {
|
330: | $url .= '&order=' . $this->request->get['order'];
|
331: | }
|
332: |
|
333: | if (isset($this->request->get['page'])) {
|
334: | $url .= '&page=' . $this->request->get['page'];
|
335: | }
|
336: |
|
337: | $data['breadcrumbs'] = [];
|
338: |
|
339: | $data['breadcrumbs'][] = [
|
340: | 'text' => $this->language->get('text_home'),
|
341: | 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'])
|
342: | ];
|
343: |
|
344: | $data['breadcrumbs'][] = [
|
345: | 'text' => $this->language->get('heading_title'),
|
346: | 'href' => $this->url->link('marketing/marketing', 'user_token=' . $this->session->data['user_token'] . $url)
|
347: | ];
|
348: |
|
349: | $data['save'] = $this->url->link('marketing/marketing.save', 'user_token=' . $this->session->data['user_token']);
|
350: | $data['back'] = $this->url->link('marketing/marketing', 'user_token=' . $this->session->data['user_token'] . $url);
|
351: |
|
352: | if (isset($this->request->get['marketing_id'])) {
|
353: | $this->load->model('marketing/marketing');
|
354: |
|
355: | $marketing_info = $this->model_marketing_marketing->getMarketing($this->request->get['marketing_id']);
|
356: | }
|
357: |
|
358: | if (isset($this->request->get['marketing_id'])) {
|
359: | $data['marketing_id'] = (int)$this->request->get['marketing_id'];
|
360: | } else {
|
361: | $data['marketing_id'] = 0;
|
362: | }
|
363: |
|
364: | $data['store'] = HTTP_CATALOG;
|
365: |
|
366: | if (!empty($marketing_info)) {
|
367: | $data['name'] = $marketing_info['name'];
|
368: | } else {
|
369: | $data['name'] = '';
|
370: | }
|
371: |
|
372: | if (!empty($marketing_info)) {
|
373: | $data['description'] = $marketing_info['description'];
|
374: | } else {
|
375: | $data['description'] = '';
|
376: | }
|
377: |
|
378: | if (!empty($marketing_info)) {
|
379: | $data['code'] = $marketing_info['code'];
|
380: | } else {
|
381: | $data['code'] = uniqid();
|
382: | }
|
383: |
|
384: | $data['report'] = $this->getReport();
|
385: |
|
386: | $data['user_token'] = $this->session->data['user_token'];
|
387: |
|
388: | $data['header'] = $this->load->controller('common/header');
|
389: | $data['column_left'] = $this->load->controller('common/column_left');
|
390: | $data['footer'] = $this->load->controller('common/footer');
|
391: |
|
392: | $this->response->setOutput($this->load->view('marketing/marketing_form', $data));
|
393: | }
|
394: |
|
395: | |
396: | |
397: | |
398: | |
399: |
|
400: | public function save(): void {
|
401: | $this->load->language('marketing/marketing');
|
402: |
|
403: | $json = [];
|
404: |
|
405: | if (!$this->user->hasPermission('modify', 'marketing/marketing')) {
|
406: | $json['error']['warning'] = $this->language->get('error_permission');
|
407: | }
|
408: |
|
409: | if (!oc_validate_length($this->request->post['name'], 1, 32)) {
|
410: | $json['error']['name'] = $this->language->get('error_name');
|
411: | }
|
412: |
|
413: | if (!$this->request->post['code']) {
|
414: | $json['error']['code'] = $this->language->get('error_code');
|
415: | }
|
416: |
|
417: | $this->load->model('marketing/marketing');
|
418: |
|
419: | $marketing_info = $this->model_marketing_marketing->getMarketingByCode($this->request->post['code']);
|
420: |
|
421: | if ($marketing_info && (!isset($this->request->post['marketing_id']) || ($this->request->post['marketing_id'] != $marketing_info['marketing_id']))) {
|
422: | $json['error']['code'] = $this->language->get('error_exists');
|
423: | }
|
424: |
|
425: | if (!$json) {
|
426: | if (!$this->request->post['marketing_id']) {
|
427: | $json['marketing_id'] = $this->model_marketing_marketing->addMarketing($this->request->post);
|
428: | } else {
|
429: | $this->model_marketing_marketing->editMarketing($this->request->post['marketing_id'], $this->request->post);
|
430: | }
|
431: |
|
432: | $json['success'] = $this->language->get('text_success');
|
433: | }
|
434: |
|
435: | $this->response->addHeader('Content-Type: application/json');
|
436: | $this->response->setOutput(json_encode($json));
|
437: | }
|
438: |
|
439: | |
440: | |
441: | |
442: | |
443: |
|
444: | public function delete(): void {
|
445: | $this->load->language('marketing/marketing');
|
446: |
|
447: | $json = [];
|
448: |
|
449: | if (isset($this->request->post['selected'])) {
|
450: | $selected = $this->request->post['selected'];
|
451: | } else {
|
452: | $selected = [];
|
453: | }
|
454: |
|
455: | if (!$this->user->hasPermission('modify', 'marketing/marketing')) {
|
456: | $json['error'] = $this->language->get('error_permission');
|
457: | }
|
458: |
|
459: | if (!$json) {
|
460: | $this->load->model('marketing/marketing');
|
461: |
|
462: | foreach ($selected as $marketing_id) {
|
463: | $this->model_marketing_marketing->deleteMarketing($marketing_id);
|
464: | }
|
465: |
|
466: | $json['success'] = $this->language->get('text_success');
|
467: | }
|
468: |
|
469: | $this->response->addHeader('Content-Type: application/json');
|
470: | $this->response->setOutput(json_encode($json));
|
471: | }
|
472: |
|
473: | |
474: | |
475: | |
476: | |
477: |
|
478: | public function report(): void {
|
479: | $this->load->language('marketing/marketing');
|
480: |
|
481: | $this->response->setOutput($this->getReport());
|
482: | }
|
483: |
|
484: | |
485: | |
486: | |
487: | |
488: |
|
489: | public function getReport(): string {
|
490: | if (isset($this->request->get['marketing_id'])) {
|
491: | $marketing_id = (int)$this->request->get['marketing_id'];
|
492: | } else {
|
493: | $marketing_id = 0;
|
494: | }
|
495: |
|
496: | if (isset($this->request->get['page']) && $this->request->get['route'] == 'marketing/marketing.report') {
|
497: | $page = (int)$this->request->get['page'];
|
498: | } else {
|
499: | $page = 1;
|
500: | }
|
501: |
|
502: | $limit = 10;
|
503: |
|
504: | $data['reports'] = [];
|
505: |
|
506: | $this->load->model('marketing/marketing');
|
507: | $this->load->model('customer/customer');
|
508: | $this->load->model('setting/store');
|
509: |
|
510: | $results = $this->model_marketing_marketing->getReports($marketing_id, ($page - 1) * $limit, $limit);
|
511: |
|
512: | foreach ($results as $result) {
|
513: | $store_info = $this->model_setting_store->getStore($result['store_id']);
|
514: |
|
515: | if ($store_info) {
|
516: | $store = $store_info['name'];
|
517: | } elseif (!$result['store_id']) {
|
518: | $store = $this->config->get('config_name');
|
519: | } else {
|
520: | $store = '';
|
521: | }
|
522: |
|
523: | $data['reports'][] = [
|
524: | 'ip' => $result['ip'],
|
525: | 'account' => $this->model_customer_customer->getTotalCustomersByIp($result['ip']),
|
526: | 'store' => $store,
|
527: | 'country' => $result['country'],
|
528: | 'date_added' => date($this->language->get('datetime_format'), strtotime($result['date_added'])),
|
529: | 'filter_ip' => $this->url->link('customer/customer', 'user_token=' . $this->session->data['user_token'] . '&filter_ip=' . $result['ip'])
|
530: | ];
|
531: | }
|
532: |
|
533: | $report_total = $this->model_marketing_marketing->getTotalReports($marketing_id);
|
534: |
|
535: | $data['pagination'] = $this->load->controller('common/pagination', [
|
536: | 'total' => $report_total,
|
537: | 'page' => $page,
|
538: | 'limit' => $limit,
|
539: | 'url' => $this->url->link('marketing/marketing.report', 'user_token=' . $this->session->data['user_token'] . '&marketing_id=' . $marketing_id . '&page={page}')
|
540: | ]);
|
541: |
|
542: | $data['results'] = sprintf($this->language->get('text_pagination'), ($report_total) ? (($page - 1) * $limit) + 1 : 0, ((($page - 1) * $limit) > ($report_total - $limit)) ? $report_total : ((($page - 1) * $limit) + $limit), $report_total, ceil($report_total / $limit));
|
543: |
|
544: | return $this->load->view('marketing/marketing_report', $data);
|
545: | }
|
546: |
|
547: | |
548: | |
549: | |
550: | |
551: |
|
552: | public function autocomplete(): void {
|
553: | $json = [];
|
554: |
|
555: | if (isset($this->request->get['filter_name'])) {
|
556: | $filter_name = $this->request->get['filter_name'];
|
557: | } else {
|
558: | $filter_name = '';
|
559: | }
|
560: |
|
561: | if (isset($this->request->get['filter_code'])) {
|
562: | $filter_code = $this->request->get['filter_code'];
|
563: | } else {
|
564: | $filter_code = '';
|
565: | }
|
566: |
|
567: | $filter_data = [
|
568: | 'filter_name' => $filter_name,
|
569: | 'filter_code' => $filter_code,
|
570: | 'start' => 0,
|
571: | 'limit' => 5
|
572: | ];
|
573: |
|
574: | $this->load->model('marketing/marketing');
|
575: |
|
576: | $results = $this->model_marketing_marketing->getMarketings($filter_data);
|
577: |
|
578: | foreach ($results as $result) {
|
579: | $json[] = [
|
580: | 'marketing_id' => $result['marketing_id'],
|
581: | 'name' => strip_tags(html_entity_decode($result['name'], ENT_QUOTES, 'UTF-8')),
|
582: | 'code' => $result['code']
|
583: | ];
|
584: | }
|
585: |
|
586: | $sort_order = [];
|
587: |
|
588: | foreach ($json as $key => $value) {
|
589: | $sort_order[$key] = $value['name'];
|
590: | }
|
591: |
|
592: | array_multisort($sort_order, SORT_ASC, $json);
|
593: |
|
594: | $this->response->addHeader('Content-Type: application/json');
|
595: | $this->response->setOutput(json_encode($json));
|
596: | }
|
597: | }
|
598: | |