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

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

Имя файла	Comments.php
Содержимое	<?php namespace app\organizations; use App; use app\core\http\Request; use app\core\models\Command; use app\organizations\interfaces\IComment; use app\users\User; /** * РљР»Р°СЃСЃ РґР»СЏ СЂР°Р±РѕС‹ СЃ РєРѕРјРјРµРЅС‚Р°СЂРёСЏС‹РјРё РѕСЂРіР°РЅРёР·Р°С†РёР№ * Р”Р»СЏ С‡С‚РµРЅРёСЏ РєРѕРјРјРµРЅС‚Р°СЂРёРµРІ РёСЃРїРѕР»СЊР·СѓР№С‚Рµ OrganizationCommentsReader * Class OrganizationComments * @package app\organizations / class Comments implements IComment { /* * @var Command / private $_command; public function __construct(Command $command) { $this->_command = $command; } /* * Р¤СѓРЅРєС†РёСЏ РїСЂРѕРІРµСЂСЏРµС‚, СЃСѓС‰РµСЃС‚РІСѓРµС‚ Р»Рё С‚Р°РєРѕР№ РєРѕРјРјРµРЅС‚Р°СЂРёР№ * @param $commentId * @return bool / public function isExist($commentId) { return $this->_command ->createCommand(' SELECT COUNT(id) as total FROM `firma_otzyv` WHERE id = :comment_id ') ->bindValue(':comment_id', $commentId) ->queryOne('total', 0) > 0; } /* * Р¤СѓРЅРєС†РёСЏ РґРѕР±Р°РІР»РµРЅРёСЏ РєРѕРјРјРµРЅС‚Р°СЂРёСЏ * @param User $user * @param Request $request * @param $userName * @param $organizationId * @param $karma * @param $text * @param $image * @return bool / public function addComment(User $user, Request $request, $userName, $organizationId, $karma, $text, $image) { if (in_array($karma, [1, 0, -1]) == false) { $karma = 0; } if ($image == null) { $image = ''; } $userId = $user->getId(); if ($user->isGuest()) { $userId = 0; } return $this->_command ->createCommand(' INSERT INTO `firma_otzyv` (id_user, id_firm, name_user, note, data, ip, ip2, karma, image, sids, from_form) VALUES(:id_user, :id_firm, :name_user, :note, NOW(), :ip, :ip2, :karma, :image, :sids, 1) ') ->bindValues([ ':id_user' => $userId, ':id_firm' => $organizationId, ':name_user' => htmlspecialchars($userName), ':note' => htmlspecialchars($text), ':ip' => $request->getIp(), ':ip2' => $request->getIpFromProxy(), ':karma' => $karma, ':image' => $image, ':sids' => $user->getSid() ]) ->query(); } /* * Р¤СѓРЅРєС†РёСЏ РїСЂРѕРІРµСЂСЏРµС‚, СЏРІР»СЏРµС‚СЃСЏ Р»Рё РїРѕР»СЊР·РѕРІР°С‚РµР»СЊ Р°РІС‚РѕСЂРѕРј РєРѕРјРјРµРЅС‚Р°СЂРёСЏ * @param User $user * @return bool / public function isOwner($commentId, User $user) { return $this->_command ->createCommand(' SELECT COUNT(id) as total FROM `firma_otzyv` WHERE sids = :sid AND id = :comment_id ') ->bindValue(':sid', $user->getSid()) ->bindValue(':comment_id', $commentId) ->queryOne('total', 0) > 0; } public static function isShow($commentId) { return App::$command ->createCommand(' SELECT hidden FROM firma_otzyv WHERE id = :id ') ->bindValue(':id', $commentId) ->queryOne('hidden', 0) == false; } public static function isOwnerByOrganization($commentId, $organizationId) { return App::$command ->createCommand(' SELECT COUNT(id) as total FROM `firma_otzyv` WHERE id = :id AND id_firm = :organization_id ') ->bindValue(':id', $commentId) ->bindValue(':organization_id', $organizationId) ->queryOne('total') > 0; } public static function hideComment($commentId) { return App::$command ->createCommand(' UPDATE firma_otzyv SET hidden = 1 WHERE id = :id ') ->bindValue(':id', $commentId) ->query(); } public static function showComment($commentId) { return App::$command ->createCommand(' UPDATE firma_otzyv SET hidden = 0 WHERE id = :id ') ->bindValue(':id', $commentId) ->query(); } /* * Р¤СѓРЅРєС†РёСЏ СѓРґР°Р»СЏРµС‚ РєРѕРјРјРµРЅС‚Р°СЂРёР№. * @param $commentId * @return bool / public static function deleteComment($commentId) { return App::$command ->createCommand(' UPDATE `firma_otzyv` SET status = 1 WHERE id = :id ') ->bindValue(':id', $commentId) ->query(); } public static function getLastCommentByOrganizationId($id) { return App::$command ->createCommand(' SELECT otz.id, otz.id_user, otz.id_firm, otz.karma, otz.name_user, otz.note, otz.data, user.name as user_login, user.avatar FROM firma_otzyv otz LEFT JOIN user ON user.id = otz.id_user WHERE otz.status = 3 AND otz.id_firm = :id ORDER BY otz.ID DESC ') ->bindValue(':id', $id) ->queryOne(); } public static function getLastComments($limit = 15) { return App::$command ->createCommand(' SELECT otz.id, otz.id_user, otz.id_firm, otz.karma, otz.name_user, otz.note, otz.data, user.name as user_login, firma.name, firma.firma_url FROM firma_otzyv otz LEFT JOIN user ON user.id = otz.id_user LEFT JOIN firma ON firma.id = otz.id_firm WHERE otz.status = 3 ORDER BY otz.ID DESC LIMIT '.(int)$limit.' ') ->queryAll(); } public static function total($organizationId) { return App::$command ->createCommand(' SELECT COUNT() as total FROM firma_otzyv WHERE id_firm = :id AND hidden = 0 AND status = 3 ') ->bindValue(':id', $organizationId) ->queryOne('total'); } }

/app/organizations/

Имя	Дата	Размер
..	2026-10-01
activerecord	2017-03-23
banners	2017-03-20
entity	2019-02-11
form	2020-04-06
helpers	2019-02-08
interfaces	2017-01-26
regions	2017-02-02
search	2019-02-12
shop	2020-04-06
statistic	2019-01-29
utils	2018-01-12
validators	2020-02-11
views	2018-01-16
Categories.php	2019-02-13	6 кб.
CommentVote.php	2024-08-23	5 кб.
CommentVote.php~	2017-01-26	5 кб.
Comments.php	2019-02-26	6 кб.
CommentsKarma.php	2017-01-26	308 байт
OrganizationCategory.php	2019-02-11	896 байт
OrganizationCategoryFactory.php	2018-01-12	1 кб.
OrganizationCategoryRepository.php	2019-02-12	2 кб.
OrganizationCommentsReader.php	2019-02-18	5 кб.
OrganizationEmails.php	2017-03-09	1 кб.
OrganizationFactory.php	2016-12-13	277 байт
OrganizationFiles.php	2017-02-15	645 байт
OrganizationIndexator.php	2017-08-18	349 байт
OrganizationNews.php	2019-08-23	2 кб.
OrganizationPhones.php	2019-02-11	7 кб.
OrganizationPhotos.php	2017-08-15	2 кб.
OrganizationRepository.php	2019-02-12	433 байт
OrganizationRubriks.php	2017-03-09	2 кб.
OrganizationSchedule.php	2018-01-12	2 кб.
OrganizationScheduleFactory.php	2018-01-12	844 байт
OrganizationSites.php	2020-04-09	1 кб.
OrganizationSlider.php	2019-08-12	1 кб.
OrganizationStatistics.php	2019-04-01	2 кб.
OrganizationVideos.php	2017-01-25	1 кб.
Organizations.php	2020-04-17	34 кб.
OrganizationsReader.php	2019-02-11	4 кб.
PhoneRepository.php	2019-02-11	1 кб.
Rating.php	2024-08-23	2 кб.
Rating.php~	2019-02-15	1 кб.

/app/organizations