/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. 

  2. namespace Opencart\Admin\Controller\Catalog;
    3. 

  3. class Review extends \Opencart\System\Engine\Controller {
    4. 

  4. 	public function index(): void {
    5. 

  5. 		$this->load->language('catalog/review');
    6. 

  6. 

  7. 		$this->document->setTitle($this->language->get('heading_title'));
    8. 

  8. 

  9. 		$url = '';
    10. 

  10. 

  11. 		if (isset($this->request->get['filter_product'])) {
    12. 

  12. 			$url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
    13. 

  13. 		}
    14. 

  14. 

  15. 		if (isset($this->request->get['filter_author'])) {
    16. 

  16. 			$url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
    17. 

  17. 		}
    18. 

  18. 

  19. 		if (isset($this->request->get['filter_status'])) {
    20. 

  20. 			$url .= '&filter_status=' . $this->request->get['filter_status'];
    21. 

  21. 		}
    22. 

  22. 

  23. 		if (isset($this->request->get['filter_date_added'])) {
    24. 

  24. 			$url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
    25. 

  25. 		}
    26. 

  26. 

  27. 		if (isset($this->request->get['sort'])) {
    28. 

  28. 			$url .= '&sort=' . $this->request->get['sort'];
    29. 

  29. 		}
    30. 

  30. 

  31. 		if (isset($this->request->get['order'])) {
    32. 

  32. 			$url .= '&order=' . $this->request->get['order'];
    33. 

  33. 		}
    34. 

  34. 

  35. 		if (isset($this->request->get['page'])) {
    36. 

  36. 			$url .= '&page=' . $this->request->get['page'];
    37. 

  37. 		}
    38. 

  38. 

  39. 		$data['breadcrumbs'] = [];
    40. 

  40. 

  41. 		$data['breadcrumbs'][] = [
    42. 

  42. 			'text' => $this->language->get('text_home'),
    43. 

  43. 			'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'])
    44. 

  44. 		];
    45. 

  45. 

  46. 		$data['breadcrumbs'][] = [
    47. 

  47. 			'text' => $this->language->get('heading_title'),
    48. 

  48. 			'href' => $this->url->link('catalog/review', 'user_token=' . $this->session->data['user_token'] . $url)
    49. 

  49. 		];
    50. 

  50. 

  51. 		$data['add'] = $this->url->link('catalog/review|form', 'user_token=' . $this->session->data['user_token'] . $url);
    52. 

  52. 		$data['delete'] = $this->url->link('catalog/review|delete', 'user_token=' . $this->session->data['user_token']);
    53. 

  53. 

  54. 		$data['list'] = $this->getList();
    55. 

  55. 

  56. 		$data['user_token'] = $this->session->data['user_token'];
    57. 

  57. 

  58. 		$data['header'] = $this->load->controller('common/header');
    59. 

  59. 		$data['column_left'] = $this->load->controller('common/column_left');
    60. 

  60. 		$data['footer'] = $this->load->controller('common/footer');
    61. 

  61. 

  62. 		$this->response->setOutput($this->load->view('catalog/review', $data));
    63. 

  63. 	}
    64. 

  64. 

  65. 	public function list(): void {
    66. 

  66. 		$this->load->language('catalog/review');
    67. 

  67. 

  68. 		$this->response->setOutput($this->getList());
    69. 

  69. 	}
    70. 

  70. 

  71. 	protected function getList(): string {
    72. 

  72. 		if (isset($this->request->get['filter_product'])) {
    73. 

  73. 			$filter_product = $this->request->get['filter_product'];
    74. 

  74. 		} else {
    75. 

  75. 			$filter_product = '';
    76. 

  76. 		}
    77. 

  77. 

  78. 		if (isset($this->request->get['filter_author'])) {
    79. 

  79. 			$filter_author = $this->request->get['filter_author'];
    80. 

  80. 		} else {
    81. 

  81. 			$filter_author = '';
    82. 

  82. 		}
    83. 

  83. 

  84. 		if (isset($this->request->get['filter_status'])) {
    85. 

  85. 			$filter_status = $this->request->get['filter_status'];
    86. 

  86. 		} else {
    87. 

  87. 			$filter_status = '';
    88. 

  88. 		}
    89. 

  89. 

  90. 		if (isset($this->request->get['filter_date_added'])) {
    91. 

  91. 			$filter_date_added = $this->request->get['filter_date_added'];
    92. 

  92. 		} else {
    93. 

  93. 			$filter_date_added = '';
    94. 

  94. 		}
    95. 

  95. 

  96. 		if (isset($this->request->get['order'])) {
    97. 

  97. 			$order = $this->request->get['order'];
    98. 

  98. 		} else {
    99. 

  99. 			$order = 'DESC';
    100. 

  100. 		}
    101. 

  101. 

  102. 		if (isset($this->request->get['sort'])) {
    103. 

  103. 			$sort = $this->request->get['sort'];
    104. 

  104. 		} else {
    105. 

  105. 			$sort = 'r.date_added';
    106. 

  106. 		}
    107. 

  107. 

  108. 		if (isset($this->request->get['page'])) {
    109. 

  109. 			$page = (int)$this->request->get['page'];
    110. 

  110. 		} else {
    111. 

  111. 			$page = 1;
    112. 

  112. 		}
    113. 

  113. 

  114. 		$url = '';
    115. 

  115. 

  116. 		if (isset($this->request->get['filter_product'])) {
    117. 

  117. 			$url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
    118. 

  118. 		}
    119. 

  119. 

  120. 		if (isset($this->request->get['filter_author'])) {
    121. 

  121. 			$url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
    122. 

  122. 		}
    123. 

  123. 

  124. 		if (isset($this->request->get['filter_status'])) {
    125. 

  125. 			$url .= '&filter_status=' . $this->request->get['filter_status'];
    126. 

  126. 		}
    127. 

  127. 

  128. 		if (isset($this->request->get['filter_date_added'])) {
    129. 

  129. 			$url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
    130. 

  130. 		}
    131. 

  131. 

  132. 		if (isset($this->request->get['sort'])) {
    133. 

  133. 			$url .= '&sort=' . $this->request->get['sort'];
    134. 

  134. 		}
    135. 

  135. 

  136. 		if (isset($this->request->get['order'])) {
    137. 

  137. 			$url .= '&order=' . $this->request->get['order'];
    138. 

  138. 		}
    139. 

  139. 

  140. 		if (isset($this->request->get['page'])) {
    141. 

  141. 			$url .= '&page=' . $this->request->get['page'];
    142. 

  142. 		}
    143. 

  143. 

  144. 		$data['action'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . $url);
    145. 

  145. 

  146. 		$data['reviews'] = [];
    147. 

  147. 

  148. 		$filter_data = [
    149. 

  149. 			'filter_product'    => $filter_product,
    150. 

  150. 			'filter_author'     => $filter_author,
    151. 

  151. 			'filter_status'     => $filter_status,
    152. 

  152. 			'filter_date_added' => $filter_date_added,
    153. 

  153. 			'sort'              => $sort,
    154. 

  154. 			'order'             => $order,
    155. 

  155. 			'start'             => ($page - 1) * $this->config->get('config_pagination_admin'),
    156. 

  156. 			'limit'             => $this->config->get('config_pagination_admin')
    157. 

  157. 		];
    158. 

  158. 

  159. 		$this->load->model('catalog/review');
    160. 

  160. 

  161. 		$review_total = $this->model_catalog_review->getTotalReviews($filter_data);
    162. 

  162. 

  163. 		$results = $this->model_catalog_review->getReviews($filter_data);
    164. 

  164. 

  165. 		foreach ($results as $result) {
    166. 

  166. 			$data['reviews'][] = [
    167. 

  167. 				'review_id'  => $result['review_id'],
    168. 

  168. 				'name'       => $result['name'],
    169. 

  169. 				'author'     => $result['author'],
    170. 

  170. 				'rating'     => $result['rating'],
    171. 

  171. 				'status'     => ($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
    172. 

  172. 				'date_added' => date($this->language->get('date_format_short'), strtotime($result['date_added'])),
    173. 

  173. 				'edit'       => $this->url->link('catalog/review|form', 'user_token=' . $this->session->data['user_token'] . '&review_id=' . $result['review_id'] . $url)
    174. 

  174. 			];
    175. 

  175. 		}
    176. 

  176. 

  177. 		$url = '';
    178. 

  178. 

  179. 		if (isset($this->request->get['filter_product'])) {
    180. 

  180. 			$url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
    181. 

  181. 		}
    182. 

  182. 

  183. 		if (isset($this->request->get['filter_author'])) {
    184. 

  184. 			$url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
    185. 

  185. 		}
    186. 

  186. 

  187. 		if (isset($this->request->get['filter_status'])) {
    188. 

  188. 			$url .= '&filter_status=' . $this->request->get['filter_status'];
    189. 

  189. 		}
    190. 

  190. 

  191. 		if (isset($this->request->get['filter_date_added'])) {
    192. 

  192. 			$url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
    193. 

  193. 		}
    194. 

  194. 

  195. 		if ($order == 'ASC') {
    196. 

  196. 			$url .= '&order=DESC';
    197. 

  197. 		} else {
    198. 

  198. 			$url .= '&order=ASC';
    199. 

  199. 		}
    200. 

  200. 

  201. 		if (isset($this->request->get['page'])) {
    202. 

  202. 			$url .= '&page=' . $this->request->get['page'];
    203. 

  203. 		}
    204. 

  204. 

  205. 		$data['sort_product'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=pd.name' . $url);
    206. 

  206. 		$data['sort_author'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=r.author' . $url);
    207. 

  207. 		$data['sort_rating'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=r.rating' . $url);
    208. 

  208. 		$data['sort_status'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=r.status' . $url);
    209. 

  209. 		$data['sort_date_added'] = $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . '&sort=r.date_added' . $url);
    210. 

  210. 

  211. 		$url = '';
    212. 

  212. 

  213. 		if (isset($this->request->get['filter_product'])) {
    214. 

  214. 			$url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
    215. 

  215. 		}
    216. 

  216. 

  217. 		if (isset($this->request->get['filter_author'])) {
    218. 

  218. 			$url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
    219. 

  219. 		}
    220. 

  220. 

  221. 		if (isset($this->request->get['filter_status'])) {
    222. 

  222. 			$url .= '&filter_status=' . $this->request->get['filter_status'];
    223. 

  223. 		}
    224. 

  224. 

  225. 		if (isset($this->request->get['filter_date_added'])) {
    226. 

  226. 			$url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
    227. 

  227. 		}
    228. 

  228. 

  229. 		if (isset($this->request->get['sort'])) {
    230. 

  230. 			$url .= '&sort=' . $this->request->get['sort'];
    231. 

  231. 		}
    232. 

  232. 

  233. 		if (isset($this->request->get['order'])) {
    234. 

  234. 			$url .= '&order=' . $this->request->get['order'];
    235. 

  235. 		}
    236. 

  236. 

  237. 		$data['pagination'] = $this->load->controller('common/pagination', [
    238. 

  238. 			'total' => $review_total,
    239. 

  239. 			'page'  => $page,
    240. 

  240. 			'limit' => $this->config->get('config_pagination_admin'),
    241. 

  241. 			'url'   => $this->url->link('catalog/review|list', 'user_token=' . $this->session->data['user_token'] . $url . '&page={page}')
    242. 

  242. 		]);
    243. 

  243. 

  244. 		$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')));
    245. 

  245. 

  246. 		$data['filter_product'] = $filter_product;
    247. 

  247. 		$data['filter_author'] = $filter_author;
    248. 

  248. 		$data['filter_status'] = $filter_status;
    249. 

  249. 		$data['filter_date_added'] = $filter_date_added;
    250. 

  250. 

  251. 		$data['sort'] = $sort;
    252. 

  252. 		$data['order'] = $order;
    253. 

  253. 

  254. 		return $this->load->view('catalog/review_list', $data);
    255. 

  255. 	}
    256. 

  256. 

  257. 	public function form(): void {
    258. 

  258. 		$this->load->language('catalog/review');
    259. 

  259. 

  260. 		$this->document->setTitle($this->language->get('heading_title'));
    261. 

  261. 

  262. 		$data['text_form'] = !isset($this->request->get['review_id']) ? $this->language->get('text_add') : $this->language->get('text_edit');
    263. 

  263. 

  264. 		$url = '';
    265. 

  265. 

  266. 		if (isset($this->request->get['filter_product'])) {
    267. 

  267. 			$url .= '&filter_product=' . urlencode(html_entity_decode($this->request->get['filter_product'], ENT_QUOTES, 'UTF-8'));
    268. 

  268. 		}
    269. 

  269. 

  270. 		if (isset($this->request->get['filter_author'])) {
    271. 

  271. 			$url .= '&filter_author=' . urlencode(html_entity_decode($this->request->get['filter_author'], ENT_QUOTES, 'UTF-8'));
    272. 

  272. 		}
    273. 

  273. 

  274. 		if (isset($this->request->get['filter_status'])) {
    275. 

  275. 			$url .= '&filter_status=' . $this->request->get['filter_status'];
    276. 

  276. 		}
    277. 

  277. 

  278. 		if (isset($this->request->get['filter_date_added'])) {
    279. 

  279. 			$url .= '&filter_date_added=' . $this->request->get['filter_date_added'];
    280. 

  280. 		}
    281. 

  281. 

  282. 		if (isset($this->request->get['sort'])) {
    283. 

  283. 			$url .= '&sort=' . $this->request->get['sort'];
    284. 

  284. 		}
    285. 

  285. 

  286. 		if (isset($this->request->get['order'])) {
    287. 

  287. 			$url .= '&order=' . $this->request->get['order'];
    288. 

  288. 		}
    289. 

  289. 

  290. 		if (isset($this->request->get['page'])) {
    291. 

  291. 			$url .= '&page=' . $this->request->get['page'];
    292. 

  292. 		}
    293. 

  293. 

  294. 		$data['breadcrumbs'] = [];
    295. 

  295. 

  296. 		$data['breadcrumbs'][] = [
    297. 

  297. 			'text' => $this->language->get('text_home'),
    298. 

  298. 			'href' => $this->url->link('common/dashboard', 'user_token=' . $this->session->data['user_token'])
    299. 

  299. 		];
    300. 

  300. 

  301. 		$data['breadcrumbs'][] = [
    302. 

  302. 			'text' => $this->language->get('heading_title'),
    303. 

  303. 			'href' => $this->url->link('catalog/review', 'user_token=' . $this->session->data['user_token'] . $url)
    304. 

  304. 		];
    305. 

  305. 

  306. 		$data['save'] = $this->url->link('catalog/review|save', 'user_token=' . $this->session->data['user_token']);
    307. 

  307. 		$data['back'] = $this->url->link('catalog/review', 'user_token=' . $this->session->data['user_token'] . $url);
    308. 

  308. 

  309. 		if (isset($this->request->get['review_id'])) {
    310. 

  310. 			$this->load->model('catalog/review');
    311. 

  311. 

  312. 			$review_info = $this->model_catalog_review->getReview($this->request->get['review_id']);
    313. 

  313. 		}
    314. 

  314. 

  315. 		if (isset($this->request->get['review_id'])) {
    316. 

  316. 			$data['review_id'] = (int)$this->request->get['review_id'];
    317. 

  317. 		} else {
    318. 

  318. 			$data['review_id'] = 0;
    319. 

  319. 		}
    320. 

  320. 

  321. 		$this->load->model('catalog/product');
    322. 

  322. 

  323. 		if (!empty($review_info)) {
    324. 

  324. 			$data['product_id'] = $review_info['product_id'];
    325. 

  325. 		} else {
    326. 

  326. 			$data['product_id'] = '';
    327. 

  327. 		}
    328. 

  328. 

  329. 		if (!empty($review_info)) {
    330. 

  330. 			$data['product'] = $review_info['product'];
    331. 

  331. 		} else {
    332. 

  332. 			$data['product'] = '';
    333. 

  333. 		}
    334. 

  334. 

  335. 		if (!empty($review_info)) {
    336. 

  336. 			$data['author'] = $review_info['author'];
    337. 

  337. 		} else {
    338. 

  338. 			$data['author'] = '';
    339. 

  339. 		}
    340. 

  340. 

  341. 		if (!empty($review_info)) {
    342. 

  342. 			$data['text'] = $review_info['text'];
    343. 

  343. 		} else {
    344. 

  344. 			$data['text'] = '';
    345. 

  345. 		}
    346. 

  346. 

  347. 		if (!empty($review_info)) {
    348. 

  348. 			$data['rating'] = $review_info['rating'];
    349. 

  349. 		} else {
    350. 

  350. 			$data['rating'] = '';
    351. 

  351. 		}
    352. 

  352. 

  353. 		if (!empty($review_info)) {
    354. 

  354. 			$data['date_added'] = ($review_info['date_added'] != '0000-00-00 00:00' ? $review_info['date_added'] : date('Y-m-d'));
    355. 

  355. 		} else {
    356. 

  356. 			$data['date_added'] = date('Y-m-d');
    357. 

  357. 		}
    358. 

  358. 

  359. 		if (!empty($review_info)) {
    360. 

  360. 			$data['status'] = $review_info['status'];
    361. 

  361. 		} else {
    362. 

  362. 			$data['status'] = '';
    363. 

  363. 		}
    364. 

  364. 

  365. 		$data['user_token'] = $this->session->data['user_token'];
    366. 

  366. 

  367. 		$data['header'] = $this->load->controller('common/header');
    368. 

  368. 		$data['column_left'] = $this->load->controller('common/column_left');
    369. 

  369. 		$data['footer'] = $this->load->controller('common/footer');
    370. 

  370. 

  371. 		$this->response->setOutput($this->load->view('catalog/review_form', $data));
    372. 

  372. 	}
    373. 

  373. 

  374. 	public function save(): void {
    375. 

  375. 		$this->load->language('catalog/review');
    376. 

  376. 

  377. 		$json = [];
    378. 

  378. 

  379. 		if (!$this->user->hasPermission('modify', 'catalog/review')) {
    380. 

  380. 			$json['error']['warning'] = $this->language->get('error_permission');
    381. 

  381. 		}
    382. 

  382. 

  383. 		if ((utf8_strlen($this->request->post['author']) < 3) || (utf8_strlen($this->request->post['author']) > 64)) {
    384. 

  384. 			$json['error']['author'] = $this->language->get('error_author');
    385. 

  385. 		}
    386. 

  386. 

  387. 		if (!$this->request->post['product_id']) {
    388. 

  388. 			$json['error']['product'] = $this->language->get('error_product');
    389. 

  389. 		}
    390. 

  390. 

  391. 		if (utf8_strlen($this->request->post['text']) < 1) {
    392. 

  392. 			$json['error']['text'] = $this->language->get('error_text');
    393. 

  393. 		}
    394. 

  394. 

  395. 		if (!isset($this->request->post['rating']) || $this->request->post['rating'] < 0 || $this->request->post['rating'] > 5) {
    396. 

  396. 			$json['error']['rating'] = $this->language->get('error_rating');
    397. 

  397. 		}
    398. 

  398. 

  399. 		if (isset($json['error']) && !isset($json['error']['warning'])) {
    400. 

  400. 			$json['error']['warning'] = $this->language->get('error_warning');
    401. 

  401. 		}
    402. 

  402. 

  403. 		if (!$json) {
    404. 

  404. 			$this->load->model('catalog/review');
    405. 

  405. 

  406. 			if (!$this->request->post['review_id']) {
    407. 

  407. 				$json['review_id'] = $this->model_catalog_review->addReview($this->request->post);
    408. 

  408. 			} else {
    409. 

  409. 				$this->model_catalog_review->editReview($this->request->post['review_id'], $this->request->post);
    410. 

  410. 			}
    411. 

  411. 

  412. 			$json['success'] = $this->language->get('text_success');
    413. 

  413. 		}
    414. 

  414. 

  415. 		$this->response->addHeader('Content-Type: application/json');
    416. 

  416. 		$this->response->setOutput(json_encode($json));
    417. 

  417. 	}
    418. 

  418. 

  419. 	public function delete(): void {
    420. 

  420. 		$this->load->language('catalog/review');
    421. 

  421. 

  422. 		$json = [];
    423. 

  423. 

  424. 		if (isset($this->request->post['selected'])) {
    425. 

  425. 			$selected = $this->request->post['selected'];
    426. 

  426. 		} else {
    427. 

  427. 			$selected = [];
    428. 

  428. 		}
    429. 

  429. 

  430. 		if (!$this->user->hasPermission('modify', 'catalog/review')) {
    431. 

  431. 			$json['error'] = $this->language->get('error_permission');
    432. 

  432. 		}
    433. 

  433. 

  434. 		if (!$json) {
    435. 

  435. 			$this->load->model('catalog/review');
    436. 

  436. 

  437. 			foreach ($selected as $review_id) {
    438. 

  438. 				$this->model_catalog_review->deleteReview($review_id);
    439. 

  439. 			}
    440. 

  440. 

  441. 			$json['success'] = $this->language->get('text_success');
    442. 

  442. 		}
    443. 

  443. 

  444. 		$this->response->addHeader('Content-Type: application/json');
    445. 

  445. 		$this->response->setOutput(json_encode($json));
    446. 

  446. 	}
    447. 

  447. }
    448.