>
>
>
>
>
>
RestoranReader.php
<?php namespace app\restoran; use app\restoran\filters\Entertainment; use app\restoran\filters\Interes; use app\restoran\filters\Kitchen; use app\restoran\filters\Music; /** * Ридер для ресторана. * Class RestoranReader * @package app\restoran */ class RestoranReader { /** * Массив с ID районами. * @var array */ private $_area = []; /** * Массив развлечений * @var array */ private $_entertainment = []; /** * Интересы. * @var array */ private $_interes = []; /** * Кухня. * @var array */ private $_kitchen = []; /** * Музыка * @var array */ private $_music = []; /** * Массив с ID рейтингами. * @var array */ private $_rating = []; /** * Список всех кухонь. * @var array */ private $_kitchenItems = []; private $_interesItems = []; private $_restoranClass = null; /** * С какой страницы выводить данные * @var int */ private $_page = 1; /** * Количество записей на страницу. * @var */ private $_limit; /** * Всего найдено записей (без учета лимита) * @var int */ private $_total = 0; /** * Всего найдено записей * @var array */ private $_items = []; private $_random = false; private $_noAlcoholAndSmoke; public function __construct() { $this->_kitchenItems = (new Kitchen())->getItems(); $this->_interesItems = (new Interes())->getItems(); $this->_restoranClass = new Restoran(); } public function setArea($area) { if ($area == "") { return $this; } $this->_area[] = $area; return $this; } public function noAlcoholAndSmoke() { $this->_noAlcoholAndSmoke = true; return $this; } public function setEntertainment($entertainment) { $this->_entertainment[] = $entertainment; return $this; } public function setInteres($interes) { $this->_interes[] = $interes; return $this; } public function setKitchen($kitchen) { $this->_kitchen[] = $kitchen; return $this; } public function setMusic($music) { $this->_music[] = $music; return $this; } public function setRating($rating) { $this->_rating[] = $rating; return $this; } public function setPage($page) { $this->_page = (int)$page; return $this; } public function setLimit($limit) { $this->_limit = (int)$limit; return $this; } public function getKitchenArray($kitchenString) { $kitchenString = explode(';', $kitchenString); $array = []; foreach ($kitchenString as $item) { foreach ($this->_kitchenItems as $kitchenItem) { if ($kitchenItem['name'] == $item) { $array[] = $kitchenItem; } } } return $array; } public function getInteresArray($interesString) { $interesString = explode(';', $interesString); $array = []; foreach ($interesString as $item) { foreach ($this->_interesItems as $interesItem) { if ($interesItem['name'] == $item) { $array[] = $interesItem; } } } return $array; } private function generateWhereFragment() { $whereFragment = []; // район if (count($this->_area) > 0) { $whereFragment[] = 'restoran.id_area IN (' . implode(',', $this->_area) . ')'; } // кухня if (count($this->_kitchen) > 0) { $kitchenFragment = []; foreach ((new Kitchen())->getNamesByIds($this->_kitchen) as $kitchen) { $kitchenFragment[] = 'restoran.kitchen LIKE "%' . $kitchen . '%"'; } if (count($kitchenFragment) > 0) { $whereFragment[] = '(' . implode(' OR ', $kitchenFragment) . ')'; } } // тип if (count($this->_interes) > 0) { $interesFragment = []; foreach ((new Interes())->getNamesByIds($this->_interes) as $interes) { $interesFragment[] = 'restoran.type LIKE "%'.$interes.'%"'; } if (count($interesFragment) > 0) { $whereFragment[] = '(' . implode(' OR ', $interesFragment) . ')'; } } // музыка if (count($this->_music) > 0) { $musicFragment = []; foreach ((new Music())->getNamesByIds($this->_music) as $music) { $musicFragment[] = 'restoran.music LIKE "%'.$music.'%"'; } if (count($musicFragment) > 0) { $whereFragment[] = '(' . implode(' OR ', $musicFragment) . ')'; } } // развлечения if (count($this->_entertainment) > 0) { $entertainment = []; foreach ((new Entertainment())->getNamesByIds($this->_entertainment) as $item) { $entertainment[] = 'restoran.entertainment LIKE "%'.$item.'%"'; } if (count($entertainment) > 0) { $whereFragment[] = '(' . implode(' OR ', $entertainment) . ')'; } } if ($this->_noAlcoholAndSmoke) { $whereFragment[] = '(`type` NOT LIKE "%Кальянная%" AND `type` NOT LIKE "%Бар%" AND `type` NOT LIKE "%Пивной%")'; } $whereString = ''; if (count($whereFragment) > 0) { $whereString = ' AND ' . implode(' AND ', $whereFragment); } return $whereString; } public function getTotal() { return $this->_total; } public function random() { $this->_random = true; return $this; } public function query() { $whereString = $this->generateWhereFragment(); if ($this->_limit == null) { $this->_limit = 10; } $offset = ($this->_page-1) * $this->_limit; $defaultOrder =' `restoran`.`position` DESC '; if ($this->_random == true) { $defaultOrder = ' rand() '; } $sql = " SELECT `restoran`.`id`, registr, `restoran`.`name` as name, `phone`, restoran.work_hours, restoran.cost, `kitchen`, `address`, logo, foto_485, `x`, `y`, `type`, `restoran`.`restoran_area`.in_city, COUNT(comment.id) as total_comments, restoran.restoran_url FROM `restoran`.`restoran` LEFT JOIN `infoorel`.`map_home` ON `restoran`.`id_home`=`infoorel`.`map_home`.`id` LEFT JOIN `restoran`.`restoran_area` ON restoran.restoran.id_area = `restoran`.`restoran_area`.id LEFT JOIN `restoran`.`restoran_comment` comment ON comment.id_restoran = restoran.id AND comment.status = 3 WHERE (restoran.restoran.status='3' or restoran.restoran.status='4') {$whereString} GROUP BY restoran.restoran.id ORDER BY {$defaultOrder} LIMIT {$offset}, {$this->_limit} "; $pdo = \App::getRestoranPdo(); $sth = $pdo->prepare($sql); $sth->execute(); $items = $sth->fetchAll(); foreach ($items as $key => $item) { $items[$key]['kitchen_items'] = $this->getKitchenArray($item['kitchen']); $items[$key]['interes_items'] = $this->getInteresArray($item['type']); $items[$key]['rating'] = $this->_restoranClass->getRating($item['id']); $items[$key]['registr'] = 1;//$this->_restoranClass->getRating($item['id']); } $this->_items = $items; // подсчет общего количества строк $sth = $pdo->prepare(" SELECT COUNT(id) as total FROM `restoran`.`restoran` WHERE (status='3' or status='4') {$whereString} "); $sth->execute(); $this->_total = $sth->fetch()['total']; return $this; } public function all() { return $this->_items; } }
/app/restoran/
..
2026-10-01
entity
2019-01-18
filters
2019-01-18
forms
2017-01-30
repository
2019-01-18
request
2019-01-18
utils
2019-01-18
CommentImages.php
2017-08-17
2 .
Comments.php
2018-07-10
7 .
Entertainment.php
2016-12-22
1 .
Interes.php
2016-12-22
1 .
Kitchen.php
2016-12-22
1 .
Music.php
2016-12-22
982
Panorams.php
2017-01-18
484
Photos.php
2017-03-24
2 .
Restoran.php
2018-07-12
10 .
RestoranMenu.php
2017-07-20
3 .
RestoranNews.php
2017-09-11
6 .
RestoranReader.php
2022-02-25
8 .
RestoranReader.php~
2018-07-11
8 .
RestoranViews.php
2017-03-21
2 .
RestoranVote.php
2017-09-11
2 .
Video.php
2017-01-30
889
/app/restoran
1
2
3
..
