Файловый менеджер - Редактировать - /var/www/html/administrator/components/com_komento/models/activity.php
Ðазад
<?php /** * @package Komento * @copyright Copyright (C) Stack Ideas Sdn Bhd. All rights reserved. * @license GNU/GPL, see LICENSE.php * Komento is free software. This version may have been modified pursuant * to the GNU General Public License, and as distributed it includes or * is derivative of works licensed under the GNU General Public License or * other free or open source software licenses. * See COPYRIGHT.php for copyright notices and details. */ defined('_JEXEC') or die('Unauthorized Access'); class KomentoModelActivity extends KomentoModel { protected $element = 'activity'; public $_total = null; public function add($type, $comment_id, $uid) { $table = KT::table('Activities'); $table->type = $type; $table->comment_id = $comment_id; $table->uid = $uid; $table->created = JFactory::getDate()->toSql(); $table->published = 1; return $table->store(); } public function delete(&$comment_id) { $sql = KT::sql(); $sql->delete('#__komento_activities'); $sql->where('comment_id', $comment_id); return $sql->query(); } public function getUserActivities($id, $options = array()) { // define default values $defaultOptions = [ 'type' => 'like,comment,reply', 'sort' => 'latest', 'start' => 0, 'limit' => 10, 'published' => 1, 'component' => 'all', 'cid' => 'all' ]; // take the input values and clear unexisting keys $options = array_merge($defaultOptions, $options); $sql = $this->buildQuery($id, $options); return $sql->loadObjectList(); } public function getTotalUserActivities($id, $options = array()) { if (empty($this->_total)) { // define default values $defaultOptions = [ 'type' => 'like,comment,reply', 'published' => 1, 'component' => 'all', 'cid' => 'all' ]; $options = array_merge($defaultOptions, $options); $sql = $this->buildQuery($id, $options); $query = $sql->getTotalSql(); $sql->db->setQuery($query); $this->_total = $sql->db->loadResult(); } return $this->_total; } private function buildQuery($id, $options) { $sql = KT::sql(); $sql->select('#__komento_activities', 'a') ->column('a.*') ->column('b.component') ->column('b.cid') ->column('b.comment') ->column('b.name') ->column('b.created_by') ->column('b.parent_id') ->leftjoin('#__komento_comments', 'b') ->on('a.comment_id', 'b.id'); if ($id !== 'all') { $sql->where('a.uid', $id); } $sql->where('a.published', $options['published']); $sql->where('b.published', 1); if ($options['component'] !== 'all') { $sql->where('b.component', $options['component']); } if ($options['cid'] !== 'all') { if (!is_array($options['cid'])) { $options['cid'] = explode(',', $options['cid']); } if (count($options['cid']) > 1) { $sql->where('b.cid', $options['cid'], 'in'); } else { $sql->where('b.cid', $options['cid'][0]); } } if ($options['type'] !== 'all') { if (!is_array($options['type'])) { $options['type'] = explode(',', $options['type']); } if (count($options['type']) > 1) { $sql->where('a.type', $options['type'], 'in'); } else { $sql->where('a.type', $options['type'][0]); } } if (isset($options['sort'])) { switch ($options['sort']) { case 'oldest': $sql->order('a.created'); break; case 'latest': default: $sql->order('a.created', 'desc'); break; } } if (isset($options['start']) && isset($options['limit'])) { $sql->limit($options['start'], $options['limit']); } return $sql; } }
| ver. 1.1 | |
.
| PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка