PageRenderTime 27ms CodeModel.GetById 26ms RepoModel.GetById 0ms app.codeStats 1ms

/upload/admin/controller/catalog/review.php

https://github.com/ocStore/ocStore
PHP | 447 lines | 337 code | 110 blank | 0 comment | 84 complexity | 25b8a9dd7884955f2277d19718ec564a MD5 | raw file
  1. <?php
  2. namespace Opencart\Admin\Controller\Catalog;
  3. class Review extends \Opencart\System\Engine\Controller {
  4. public function index(): void {
  5. $this->load->language('catalog/review');
  6. $this->document->setTitle($this->language->get('heading_title'));
  7. $url = '';
  8. if (isset($this->request->get['filter_product'])) {
  9. $url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
  10. }
  11. if (isset($this->request->get['filter_author'])) {
  12. $url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
  13. }
  14. if (isset($this->request->get['filter_status'])) {
  15. $url .= '&filter_status=' . $this->request->get['filter_status'];
  16. }
  17. if (isset($this->request->get['filter_date_added'])) {
  18. $url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
  19. }
  20. if (isset($this->request->get['sort'])) {
  21. $url .= '&sort=' . $this->request->get['sort'];
  22. }
  23. if (isset($this->request->get['order'])) {
  24. $url .= '&order=' . $this->request->get['order'];
  25. }
  26. if (isset($this->request->get['page'])) {
  27. $url .= '&page=' . $this->request->get['page'];
  28. }
  29. $data['breadcrumbs'] = [];
  30. $data['breadcrumbs'][] = [
  31. 'text' => $this->language->get('text_home'),
  32. 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'])
  33. ];
  34. $data['breadcrumbs'][] = [
  35. 'text' => $this->language->get('heading_title'),
  36. 'href' => $this->url->link('catalog/review', 'user_token=' . $this->session->data['user_token'] . $url)
  37. ];
  38. $data['add'] = $this->url->link('catalog/review|form', 'user_token=' . $this->session->data['user_token'] . $url);
  39. $data['delete'] = $this->url->link('catalog/review|delete', 'user_token=' . $this->session->data['user_token']);
  40. $data['list'] = $this->getList();
  41. $data['user_token'] = $this->session->data['user_token'];
  42. $data['header'] = $this->load->controller('common/header');
  43. $data['column_left'] = $this->load->controller('common/column_left');
  44. $data['footer'] = $this->load->controller('common/footer');
  45. $this->response->setOutput($this->load->view('catalog/review', $data));
  46. }
  47. public function list(): void {
  48. $this->load->language('catalog/review');
  49. $this->response->setOutput($this->getList());
  50. }
  51. protected function getList(): string {
  52. if (isset($this->request->get['filter_product'])) {
  53. $filter_product = $this->request->get['filter_product'];
  54. } else {
  55. $filter_product = '';
  56. }
  57. if (isset($this->request->get['filter_author'])) {
  58. $filter_author = $this->request->get['filter_author'];
  59. } else {
  60. $filter_author = '';
  61. }
  62. if (isset($this->request->get['filter_status'])) {
  63. $filter_status = $this->request->get['filter_status'];
  64. } else {
  65. $filter_status = '';
  66. }
  67. if (isset($this->request->get['filter_date_added'])) {
  68. $filter_date_added = $this->request->get['filter_date_added'];
  69. } else {
  70. $filter_date_added = '';
  71. }
  72. if (isset($this->request->get['order'])) {
  73. $order = $this->request->get['order'];
  74. } else {
  75. $order = 'DESC';
  76. }
  77. if (isset($this->request->get['sort'])) {
  78. $sort = $this->request->get['sort'];
  79. } else {
  80. $sort = 'r.date_added';
  81. }
  82. if (isset($this->request->get['page'])) {
  83. $page = (int)$this->request->get['page'];
  84. } else {
  85. $page = 1;
  86. }
  87. $url = '';
  88. if (isset($this->request->get['filter_product'])) {
  89. $url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
  90. }
  91. if (isset($this->request->get['filter_author'])) {
  92. $url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
  93. }
  94. if (isset($this->request->get['filter_status'])) {
  95. $url .= '&filter_status=' . $this->request->get['filter_status'];
  96. }
  97. if (isset($this->request->get['filter_date_added'])) {
  98. $url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
  99. }
  100. if (isset($this->request->get['sort'])) {
  101. $url .= '&sort=' . $this->request->get['sort'];
  102. }
  103. if (isset($this->request->get['order'])) {
  104. $url .= '&order=' . $this->request->get['order'];
  105. }
  106. if (isset($this->request->get['page'])) {
  107. $url .= '&page=' . $this->request->get['page'];
  108. }
  109. $data['action'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . $url);
  110. $data['reviews'] = [];
  111. $filter_data = [
  112. 'filter_product' => $filter_product,
  113. 'filter_author' => $filter_author,
  114. 'filter_status' => $filter_status,
  115. 'filter_date_added' => $filter_date_added,
  116. 'sort' => $sort,
  117. 'order' => $order,
  118. 'start' => ($page - 1) * $this->config->get('config_pagination_admin'),
  119. 'limit' => $this->config->get('config_pagination_admin')
  120. ];
  121. $this->load->model('catalog/review');
  122. $review_total = $this->model_catalog_review->getTotalReviews($filter_data);
  123. $results = $this->model_catalog_review->getReviews($filter_data);
  124. foreach ($results as $result) {
  125. $data['reviews'][] = [
  126. 'review_id' => $result['review_id'],
  127. 'name' => $result['name'],
  128. 'author' => $result['author'],
  129. 'rating' => $result['rating'],
  130. 'status' => ($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
  131. 'date_added' => date($this->language->get('date_format_short'), strtotime($result['date_added'])),
  132. 'edit' => $this->url->link('catalog/review|form', 'user_token=' . $this->session->data['user_token'] . '&review_id=' . $result['review_id'] . $url)
  133. ];
  134. }
  135. $url = '';
  136. if (isset($this->request->get['filter_product'])) {
  137. $url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
  138. }
  139. if (isset($this->request->get['filter_author'])) {
  140. $url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
  141. }
  142. if (isset($this->request->get['filter_status'])) {
  143. $url .= '&filter_status=' . $this->request->get['filter_status'];
  144. }
  145. if (isset($this->request->get['filter_date_added'])) {
  146. $url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
  147. }
  148. if ($order == 'ASC') {
  149. $url .= '&order=DESC';
  150. } else {
  151. $url .= '&order=ASC';
  152. }
  153. if (isset($this->request->get['page'])) {
  154. $url .= '&page=' . $this->request->get['page'];
  155. }
  156. $data['sort_product'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=pd.name' . $url);
  157. $data['sort_author'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=r.author' . $url);
  158. $data['sort_rating'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=r.rating' . $url);
  159. $data['sort_status'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=r.status' . $url);
  160. $data['sort_date_added'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=r.date_added' . $url);
  161. $url = '';
  162. if (isset($this->request->get['filter_product'])) {
  163. $url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
  164. }
  165. if (isset($this->request->get['filter_author'])) {
  166. $url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
  167. }
  168. if (isset($this->request->get['filter_status'])) {
  169. $url .= '&filter_status=' . $this->request->get['filter_status'];
  170. }
  171. if (isset($this->request->get['filter_date_added'])) {
  172. $url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
  173. }
  174. if (isset($this->request->get['sort'])) {
  175. $url .= '&sort=' . $this->request->get['sort'];
  176. }
  177. if (isset($this->request->get['order'])) {
  178. $url .= '&order=' . $this->request->get['order'];
  179. }
  180. $data['pagination'] = $this->load->controller('common/pagination', [
  181. 'total' => $review_total,
  182. 'page' => $page,
  183. 'limit' => $this->config->get('config_pagination_admin'),
  184. 'url' => $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . $url . '&page={page}')
  185. ]);
  186. $data['results'] = sprintf($this->language->get('text_pagination'), ($review_total) ? (($page - 1) * $this->config->get('config_pagination_admin')) + 1 : 0, ((($page - 1) * $this->config->get('config_pagination_admin')) > ($review_total - $this->config->get('config_pagination_admin'))) ? $review_total : ((($page - 1) * $this->config->get('config_pagination_admin')) + $this->config->get('config_pagination_admin')), $review_total, ceil($review_total / $this->config->get('config_pagination_admin')));
  187. $data['filter_product'] = $filter_product;
  188. $data['filter_author'] = $filter_author;
  189. $data['filter_status'] = $filter_status;
  190. $data['filter_date_added'] = $filter_date_added;
  191. $data['sort'] = $sort;
  192. $data['order'] = $order;
  193. return $this->load->view('catalog/review_list', $data);
  194. }
  195. public function form(): void {
  196. $this->load->language('catalog/review');
  197. $this->document->setTitle($this->language->get('heading_title'));
  198. $data['text_form'] = !isset($this->request->get['review_id']) ? $this->language->get('text_add') : $this->language->get('text_edit');
  199. $url = '';
  200. if (isset($this->request->get['filter_product'])) {
  201. $url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
  202. }
  203. if (isset($this->request->get['filter_author'])) {
  204. $url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
  205. }
  206. if (isset($this->request->get['filter_status'])) {
  207. $url .= '&filter_status=' . $this->request->get['filter_status'];
  208. }
  209. if (isset($this->request->get['filter_date_added'])) {
  210. $url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
  211. }
  212. if (isset($this->request->get['sort'])) {
  213. $url .= '&sort=' . $this->request->get['sort'];
  214. }
  215. if (isset($this->request->get['order'])) {
  216. $url .= '&order=' . $this->request->get['order'];
  217. }
  218. if (isset($this->request->get['page'])) {
  219. $url .= '&page=' . $this->request->get['page'];
  220. }
  221. $data['breadcrumbs'] = [];
  222. $data['breadcrumbs'][] = [
  223. 'text' => $this->language->get('text_home'),
  224. 'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'])
  225. ];
  226. $data['breadcrumbs'][] = [
  227. 'text' => $this->language->get('heading_title'),
  228. 'href' => $this->url->link('catalog/review', 'user_token=' . $this->session->data['user_token'] . $url)
  229. ];
  230. $data['save'] = $this->url->link('catalog/review|save', 'user_token=' . $this->session->data['user_token']);
  231. $data['back'] = $this->url->link('catalog/review', 'user_token=' . $this->session->data['user_token'] . $url);
  232. if (isset($this->request->get['review_id'])) {
  233. $this->load->model('catalog/review');
  234. $review_info = $this->model_catalog_review->getReview($this->request->get['review_id']);
  235. }
  236. if (isset($this->request->get['review_id'])) {
  237. $data['review_id'] = (int)$this->request->get['review_id'];
  238. } else {
  239. $data['review_id'] = 0;
  240. }
  241. $this->load->model('catalog/product');
  242. if (!empty($review_info)) {
  243. $data['product_id'] = $review_info['product_id'];
  244. } else {
  245. $data['product_id'] = '';
  246. }
  247. if (!empty($review_info)) {
  248. $data['product'] = $review_info['product'];
  249. } else {
  250. $data['product'] = '';
  251. }
  252. if (!empty($review_info)) {
  253. $data['author'] = $review_info['author'];
  254. } else {
  255. $data['author'] = '';
  256. }
  257. if (!empty($review_info)) {
  258. $data['text'] = $review_info['text'];
  259. } else {
  260. $data['text'] = '';
  261. }
  262. if (!empty($review_info)) {
  263. $data['rating'] = $review_info['rating'];
  264. } else {
  265. $data['rating'] = '';
  266. }
  267. if (!empty($review_info)) {
  268. $data['date_added'] = ($review_info['date_added'] != '0000-00-00 00:00' ? $review_info['date_added'] : date('Y-m-d'));
  269. } else {
  270. $data['date_added'] = date('Y-m-d');
  271. }
  272. if (!empty($review_info)) {
  273. $data['status'] = $review_info['status'];
  274. } else {
  275. $data['status'] = '';
  276. }
  277. $data['user_token'] = $this->session->data['user_token'];
  278. $data['header'] = $this->load->controller('common/header');
  279. $data['column_left'] = $this->load->controller('common/column_left');
  280. $data['footer'] = $this->load->controller('common/footer');
  281. $this->response->setOutput($this->load->view('catalog/review_form', $data));
  282. }
  283. public function save(): void {
  284. $this->load->language('catalog/review');
  285. $json = [];
  286. if (!$this->user->hasPermission('modify', 'catalog/review')) {
  287. $json['error']['warning'] = $this->language->get('error_permission');
  288. }
  289. if ((utf8_strlen($this->request->post['author']) < 3) || (utf8_strlen($this->request->post['author']) > 64)) {
  290. $json['error']['author'] = $this->language->get('error_author');
  291. }
  292. if (!$this->request->post['product_id']) {
  293. $json['error']['product'] = $this->language->get('error_product');
  294. }
  295. if (utf8_strlen($this->request->post['text']) < 1) {
  296. $json['error']['text'] = $this->language->get('error_text');
  297. }
  298. if (!isset($this->request->post['rating']) || $this->request->post['rating'] < 0 || $this->request->post['rating'] > 5) {
  299. $json['error']['rating'] = $this->language->get('error_rating');
  300. }
  301. if (isset($json['error']) && !isset($json['error']['warning'])) {
  302. $json['error']['warning'] = $this->language->get('error_warning');
  303. }
  304. if (!$json) {
  305. $this->load->model('catalog/review');
  306. if (!$this->request->post['review_id']) {
  307. $json['review_id'] = $this->model_catalog_review->addReview($this->request->post);
  308. } else {
  309. $this->model_catalog_review->editReview($this->request->post['review_id'], $this->request->post);
  310. }
  311. $json['success'] = $this->language->get('text_success');
  312. }
  313. $this->response->addHeader('Content-Type: application/json');
  314. $this->response->setOutput(json_encode($json));
  315. }
  316. public function delete(): void {
  317. $this->load->language('catalog/review');
  318. $json = [];
  319. if (isset($this->request->post['selected'])) {
  320. $selected = $this->request->post['selected'];
  321. } else {
  322. $selected = [];
  323. }
  324. if (!$this->user->hasPermission('modify', 'catalog/review')) {
  325. $json['error'] = $this->language->get('error_permission');
  326. }
  327. if (!$json) {
  328. $this->load->model('catalog/review');
  329. foreach ($selected as $review_id) {
  330. $this->model_catalog_review->deleteReview($review_id);
  331. }
  332. $json['success'] = $this->language->get('text_success');
  333. }
  334. $this->response->addHeader('Content-Type: application/json');
  335. $this->response->setOutput(json_encode($json));
  336. }
  337. }