Управление сайтом

Файловый менеджер

Имя файла	Photos.php
Содержимое	<?php namespace app\restoran; use App; /** * РљР»Р°СЃСЃ РґР»СЏ СЂР°Р±РѕС‚С‹ СЃ С„РѕС‚РѕРіР°Р»Р»РµСЂРµРµР№ СЂРµСЃС‚РѕСЂР°РЅР° * Class Photos * @package app\restoran / class Photos { /* * @var \PDO / private $_pdo; public function __construct() { $this->_pdo = App::getRestoranPdo(); return $this; } public function getAll($restoranId, $big = true) { $sth = $this->_pdo->prepare(' SELECT id, img_index, album FROM restoran.restoran_photo WHERE id_restoran=:restoran_id and status = 3 ORDER BY `position` DESC '); $sth->execute([ ':restoran_id' => $restoranId ]); return $sth->fetchAll(); } public function getCaruselPhotos($restoranId) { $sth = $this->_pdo->prepare(' SELECT FROM restoran.restoran_carousel WHERE id_restoran=:id '); $sth->execute([ ':id' => $restoranId ]); $photos = $sth->fetchAll(); foreach ($photos as $key => $photo) { if (file_exists($_SERVER['DOCUMENT_ROOT'] . '/' . str_replace('_sm', '', $photo['img_index']))) { $photos[$key]['img_index'] = $photo['img_index']; } else { $photos[$key]['img_index'] = str_replace('/interier/', '/restoran/', $photo['img_index']); } } return $photos; } public function getAlbums($restoranId) { $sth = $this->_pdo->prepare(' SELECT * FROM restoran_albums WHERE id_rest = :restoran_id ORDER BY position ASC '); $sth->execute([ ':restoran_id' => $restoranId ]); return $sth->fetchAll(); } }

/app/restoran/

/app/restoran