/admin/controller/report/marketing.php

https://github.com/arastta/arastta · PHP · 204 lines · 155 code · 42 blank · 7 comment · 15 complexity · 5bf02b0263f30802f41b2bba0289e134 MD5 · raw file

  1. <?php
  2. /**
  3. * @package Arastta eCommerce
  4. * @copyright 2015-2018 Arastta Association. All rights reserved.
  5. * @copyright See CREDITS.txt for credits and other copyright notices.
  6. * @license GNU GPL version 3; see LICENSE.txt
  7. * @link https://arastta.org
  8. */
  9. class ControllerReportMarketing extends Controller {
  10. public function index() {
  11. $this->load->language('report/marketing');
  12. $this->document->setTitle($this->language->get('heading_title'));
  13. if (isset($this->request->get['filter_date_start'])) {
  14. $filter_date_start = $this->request->get['filter_date_start'];
  15. } else {
  16. $filter_date_start = '';
  17. }
  18. if (isset($this->request->get['filter_date_end'])) {
  19. $filter_date_end = $this->request->get['filter_date_end'];
  20. } else {
  21. $filter_date_end = '';
  22. }
  23. if (isset($this->request->get['filter_order_status_id'])) {
  24. $filter_order_status_id = $this->request->get['filter_order_status_id'];
  25. } else {
  26. $filter_order_status_id = 0;
  27. }
  28. if (isset($this->request->get['page'])) {
  29. $page = $this->request->get['page'];
  30. } else {
  31. $page = 1;
  32. }
  33. $url = '';
  34. if (isset($this->request->get['filter_date_start'])) {
  35. $url .= '&filter_date_start=' . $this->request->get['filter_date_start'];
  36. }
  37. if (isset($this->request->get['filter_date_end'])) {
  38. $url .= '&filter_date_end=' . $this->request->get['filter_date_end'];
  39. }
  40. if (isset($this->request->get['filter_order_status_id'])) {
  41. $url .= '&filter_order_status_id=' . $this->request->get['filter_order_status_id'];
  42. }
  43. if (isset($this->request->get['page'])) {
  44. $url .= '&page=' . $this->request->get['page'];
  45. }
  46. $data['breadcrumbs'] = array();
  47. $data['breadcrumbs'][] = array(
  48. 'text' => $this->language->get('text_home'),
  49. 'href' => $this->url->link('common/dashboard', 'token=' . $this->session->data['token'], 'SSL')
  50. );
  51. $data['breadcrumbs'][] = array(
  52. 'text' => $this->language->get('heading_title'),
  53. 'href' => $this->url->link('report/marketing', 'token=' . $this->session->data['token'] . $url, 'SSL')
  54. );
  55. $this->load->model('report/marketing');
  56. $data['marketings'] = array();
  57. $filter_data = array(
  58. 'filter_date_start' => $filter_date_start,
  59. 'filter_date_end' => $filter_date_end,
  60. 'filter_order_status_id' => $filter_order_status_id,
  61. 'start' => ($page - 1) * $this->config->get('config_limit_admin'),
  62. 'limit' => $this->config->get('config_limit_admin')
  63. );
  64. $marketing_total = $this->model_report_marketing->getTotalMarketing($filter_data);
  65. $results = $this->model_report_marketing->getMarketing($filter_data);
  66. foreach ($results as $result) {
  67. $action = array();
  68. $action[] = array(
  69. 'text' => $this->language->get('text_edit'),
  70. 'href' => $this->url->link('marketing/marketing/edit', 'token=' . $this->session->data['token'] . '&marketing_id=' . $result['marketing_id'] . $url, 'SSL')
  71. );
  72. $data['marketings'][] = array(
  73. 'campaign' => $result['campaign'],
  74. 'code' => $result['code'],
  75. 'clicks' => $result['clicks'],
  76. 'orders' => $result['orders'],
  77. 'total' => $this->currency->format($result['total'], $this->config->get('config_currency')),
  78. 'action' => $action
  79. );
  80. }
  81. $data['heading_title'] = $this->language->get('heading_title');
  82. $data['text_list'] = $this->language->get('text_list');
  83. $data['text_no_results'] = $this->language->get('text_no_results');
  84. $data['text_confirm'] = $this->language->get('text_confirm');
  85. $data['text_all_status'] = $this->language->get('text_all_status');
  86. $data['text_filter'] = $this->language->get('text_filter');
  87. $data['column_campaign'] = $this->language->get('column_campaign');
  88. $data['column_code'] = $this->language->get('column_code');
  89. $data['column_clicks'] = $this->language->get('column_clicks');
  90. $data['column_orders'] = $this->language->get('column_orders');
  91. $data['column_total'] = $this->language->get('column_total');
  92. $data['column_action'] = $this->language->get('column_action');
  93. $data['entry_date_start'] = $this->language->get('entry_date_start');
  94. $data['entry_date_end'] = $this->language->get('entry_date_end');
  95. $data['entry_status'] = $this->language->get('entry_status');
  96. $data['button_filter'] = $this->language->get('button_filter');
  97. $data['button_output'] = $this->language->get('button_output');
  98. $data['button_export'] = $this->language->get('button_export');
  99. $data['button_show_filter'] = $this->language->get('button_show_filter');
  100. $data['button_hide_filter'] = $this->language->get('button_hide_filter');
  101. $data['token'] = $this->session->data['token'];
  102. $this->load->model('localisation/order_status');
  103. $data['order_statuses'] = $this->model_localisation_order_status->getOrderStatuses();
  104. $url = '';
  105. if (isset($this->request->get['filter_date_start'])) {
  106. $url .= '&filter_date_start=' . $this->request->get['filter_date_start'];
  107. }
  108. if (isset($this->request->get['filter_date_end'])) {
  109. $url .= '&filter_date_end=' . $this->request->get['filter_date_end'];
  110. }
  111. if (isset($this->request->get['filter_order_status_id'])) {
  112. $url .= '&filter_order_status_id=' . $this->request->get['filter_order_status_id'];
  113. }
  114. $pagination = new Pagination();
  115. $pagination->total = $marketing_total;
  116. $pagination->page = $page;
  117. $pagination->limit = $this->config->get('config_limit_admin');
  118. $pagination->url = $this->url->link('report/marketing', 'token=' . $this->session->data['token'] . $url . '&page={page}', 'SSL');
  119. $data['pagination'] = $pagination->render();
  120. $data['results'] = sprintf($this->language->get('text_pagination'), ($marketing_total) ? (($page - 1) * $this->config->get('config_limit_admin')) + 1 : 0, ((($page - 1) * $this->config->get('config_limit_admin')) > ($marketing_total - $this->config->get('config_limit_admin'))) ? $marketing_total : ((($page - 1) * $this->config->get('config_limit_admin')) + $this->config->get('config_limit_admin')), $marketing_total, ceil($marketing_total / $this->config->get('config_limit_admin')));
  121. $data['filter_date_start'] = $filter_date_start;
  122. $data['filter_date_end'] = $filter_date_end;
  123. $data['filter_order_status_id'] = $filter_order_status_id;
  124. $graph = array(
  125. 'sales' => array(
  126. 'model' => 'marketing',
  127. 'function' => 'marketing',
  128. 'title' => $this->language->get('text_sale'),
  129. 'link' => str_replace('&amp;', '&', $this->url->link('report/graph/graph', 'title=campaign&range=special&token=' . $this->session->data['token'] . '&' . http_build_query($filter_data) . '&page=' . $page, 'SSL')),
  130. 'color' => '#008db9',
  131. 'background-color' => '#FFFFFF',
  132. 'total' => 'total',
  133. 'price' => true
  134. ),
  135. 'orders' => array(
  136. 'model' => 'marketing',
  137. 'function' => 'marketing',
  138. 'title' => $this->language->get('text_order'),
  139. 'link' => str_replace('&amp;', '&', $this->url->link('report/graph/graph', 'title=campaign&range=special&token=' . $this->session->data['token'] . '&' . http_build_query($filter_data) . '&page=' . $page, 'SSL')),
  140. 'color' => '#5cb85c',
  141. 'background-color' => '#FFFFFF',
  142. 'total' => 'orders',
  143. 'price' => false
  144. ),
  145. 'clicks' => array(
  146. 'model' => 'marketing',
  147. 'function' => 'marketing',
  148. 'title' => $this->language->get('text_click'),
  149. 'link' => str_replace('&amp;', '&', $this->url->link('report/graph/graph', 'title=campaign&range=special&token=' . $this->session->data['token'] . '&' . http_build_query($filter_data) . '&page=' . $page, 'SSL')),
  150. 'color' => '#d9534f',
  151. 'background-color' => '#FFFFFF',
  152. 'total' => 'clicks',
  153. 'price' => false
  154. )
  155. );
  156. $data['graph'] = $this->load->controller('report/graph', $graph);
  157. $data['header'] = $this->load->controller('common/header');
  158. $data['column_left'] = $this->load->controller('common/column_left');
  159. $data['footer'] = $this->load->controller('common/footer');
  160. $this->response->setOutput($this->load->view('report/marketing.tpl', $data));
  161. }
  162. }