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

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

Имя файла	RestoranNews.php
Содержимое	<?php namespace app\restoran; /** * РќРѕРІРѕСЃС‚Рё СЂРµСЃС‚РѕСЂР°РЅР°. * Class RestoranNews * @package app\restoran / class RestoranNews { private $_pdo; public function __construct() { $this->_pdo = \App::getRestoranPdo(); } public function getNews($restoranId) { $sth = $this->_pdo->prepare(' SELECT `restoran`.`name`, `id_restoran`, `restoran_news`.`data` AS `date`, restoran_news.id as news_id, `news_header`, `news_short`, `news_full`, restoran_news.img_index, restoran_news.pokaz_img FROM `restoran`.`restoran`, `restoran`.`restoran_news` WHERE (restoran.status=3 or restoran.status=4) and `restoran`.`id`=`restoran_news`.`id_restoran` and (restoran_news.status=3 or restoran_news.status=4) and NOW() >= restoran_news.data_public and id_restoran=:restoran_id order by `restoran_news`.`data` desc '); $sth->execute([ ':restoran_id' => $restoranId ]); return $sth->fetchAll(); } /* * Р¤СѓРЅРєС†РёСЏ РІРѕР·РІСЂР°С‰Р°РµС‚ СЃРїРёСЃРѕРє РЅРѕРІРѕСЃС‚РµР№ СЂРµСЃС‚РѕСЂР°РЅРѕРІ РґР»СЏ СЃС‚СЂР°РЅРёС†С‹ $pageId РІ РєРѕР»РёС‡РµСЃС‚РІРµ $limit * @param int $pageId * @param int $limit * @return array / public function getNewsList($restoranId = null, $pageId = 1, $limit = 15, array $excludedNewsIds = []) { $restoranIdWhereFragment = ''; if ($restoranId !== null && is_numeric($restoranId)) { $restoranId = (int)$restoranId; $restoranIdWhereFragment = ' AND news.id_restoran = ' . $restoranId; } $excludedNewsIdsFragment = ''; if (count($excludedNewsIds) > 0) { $excludedNewsIdsFragment = ' AND news.id NOT IN (' . implode(',', $excludedNewsIds) . ')'; } $sth = $this->_pdo->prepare(' SELECT news.id, news.data, news.id_restoran, news.news_header, news.news_short, news.img_index, news.news_url, restoran.name as restoran_name, restoran.restoran_url FROM restoran_news news LEFT JOIN restoran ON restoran.id = news.id_restoran WHERE news.`status` = 3 '.$restoranIdWhereFragment.' '.$excludedNewsIdsFragment.' AND NOW() >= news.data_public ORDER BY news.id DESC LIMIT '.((int)$pageId - 1) (int)$limit.', '.(int)$limit.' '); $sth->execute(); return $sth->fetchAll(); } /** * Р¤СѓРЅРєС†РёСЏ РІРѕР·РІСЂР°С‰Р°РµС‚ РѕР±С‰РµРµ РєРѕР»РёС‡РµСЃС‚РІРѕ РІСЃРµС… Р°РєС‚РёРІРЅС‹С… РЅРѕРІРѕСЃС‚РµР№. * @return int / public function getTotalNewsList($restoranId = null) { $restoranIdWhereFragment = ''; if ($restoranId !== null && is_numeric($restoranId)) { $restoranId = (int)$restoranId; $restoranIdWhereFragment = ' AND restoran_news.id_restoran = ' . $restoranId; } $sth = $this->_pdo->prepare(' SELECT COUNT() as total FROM restoran_news WHERE status = 3 '.$restoranIdWhereFragment.' AND NOW() >= restoran_news.data_public; '); $sth->execute(); return $sth->fetch()['total']; } public function getNewsByUrl($url) { $sth = $this->_pdo->prepare('SELECT `restoran`.`name`, `id_restoran`, `restoran_news`.`data` AS `date`, restoran_news.id as news_id, `news_header`, `news_short`, `news_full`, restoran_news.img_index, restoran_news.pokaz_img FROM `restoran`.`restoran`, `restoran`.`restoran_news` WHERE (restoran.status=3 or restoran.status=4) and `restoran`.`id`=`restoran_news`.`id_restoran` and (restoran_news.status=3 or restoran_news.status=4) and restoran_news.news_url = :url AND NOW() >= restoran_news.data_public LIMIT 1 '); $sth->execute([ ':url' => $url ]); $data = $sth->fetch(); if (isset($data['news_id'])) { return $data; } return null; } /** * Р¤СѓРЅРєС†РёСЏ РІРѕР·РІСЂР°С‰Р°РµС‚ РЅРѕРІРѕСЃС‚СЊ РїРѕ РµРµ ID * @param $newsId * @return array / public function getNewsById($newsId) { $sth = $this->_pdo->prepare('SELECT `restoran`.`name`, `id_restoran`, `restoran_news`.`data` AS `date`, restoran_news.id as news_id, `news_header`, `news_short`, `news_full`, restoran_news.img_index, restoran_news.pokaz_img, restoran_news.news_url FROM `restoran`.`restoran`, `restoran`.`restoran_news` WHERE (restoran.status=3 or restoran.status=4) and `restoran`.`id`=`restoran_news`.`id_restoran` and (restoran_news.status=3 or restoran_news.status=4) and restoran_news.id=:news_id AND NOW() >= restoran_news.data_public LIMIT 1 '); $sth->execute([ ':news_id' => $newsId ]); $data = $sth->fetch(); if (isset($data['news_id'])) { return $data; } return null; } /* * Р¤СѓРЅРєС†РёСЏ РІРѕР·РІСЂР°С‰Р°РµС‚ URL РЅРѕРІРѕСЃС‚Рё, Р·РЅР°СЏ РµРµ ID * @param $newsId * @return null\|string / public function getUrl($newsId) { $sth = $this->_pdo->prepare(' SELECT news_url FROM `restoran`.restoran_news WHERE id = :id '); $sth->execute([ ':id' => $newsId ]); $data = $sth->fetch(); if (isset($data['news_url'])) { return $data['news_url']; } return null; } /* * Р¤СѓРЅРєС†РёСЏ РІРѕР·РІСЂР°С‰Р°РµС‚ Р·Р°РіРѕР»РѕРІРѕРє РЅРѕРІРѕСЃС‚Рё * @param $id * @return null\|string */ public function getHeader($id) { $sth = $this->_pdo->prepare(' SELECT news_header FROM `restoran`.`restoran_news` WHERE id = :id '); $sth->execute([ ':id' => $id ]); $data = $sth->fetch(); if (isset($data['news_header'])) { return $data['news_header']; } return null; } }

/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