Файловый менеджер - Редактировать - /var/www/html/components/com_community/libraries/engagement.php
Ðазад
<?php /** * @copyright (C) 2013 iJoomla, Inc. - All rights reserved. * @license GNU General Public License, version 2 (http://www.gnu.org/licenses/gpl-2.0.html) * @author iJoomla.com <webmaster@ijoomla.com> * @url https://www.jomsocial.com/license-agreement * The PHP code portions are distributed under the GPL license. If not otherwise stated, all images, manuals, cascading style sheets, and included JavaScript *are NOT GPL, and are released under the IJOOMLA Proprietary Use License v1.0 * More info at https://www.jomsocial.com/license-agreement */ use Joomla\CMS\Date\Date; use Joomla\CMS\Factory; use Joomla\CMS\Table\Table; defined('_JEXEC') or die('Restricted access'); class CTableEngagement extends Table { var $id = null; var $action = null; var $user_id = null; var $created = null; var $week = null; public function __construct( &$db ) { parent::__construct( '#__community_engagement', 'id', $db ); } } class CEngagement { public static function log($action, $user_id = null) { $table = Table::getInstance('', 'CTableEngagement'); $table->action = $action; $table->user_id = $user_id; $date = new Date(); $table->created = $date->toSql(); $table->week = $date->format('W'); $table->store(); } public static function getData($actions, $time, $user_id = null, $range = null) { $db = Factory::getDbo(); $actions = "'". implode("','", $actions). "'"; switch ($time) { case 'week': $query = 'SELECT DATE('.$db->quoteName('created').') as created, COUNT('.$db->quoteName('created').') as count FROM '.$db->quoteName('#__community_engagement') .' WHERE ' . $db->quoteName('action') ." IN (". $actions .") " .' AND WEEK('.$db->quoteName('created').') = WEEK(curdate())' .' GROUP BY DATE('.$db->quoteName('created').')'; break; case 'lastweek': $query = 'SELECT DATE('.$db->quoteName('created').') as created, COUNT('.$db->quoteName('created').') as count FROM '.$db->quoteName('#__community_engagement') .' WHERE ' . $db->quoteName('action') ." IN (". $actions .") " .' AND WEEK('.$db->quoteName('created').') = WEEK(curdate() - INTERVAL 7 DAY)' .' GROUP BY DATE('.$db->quoteName('created').')'; break; case 'month': $query = 'SELECT DATE('.$db->quoteName('created').') as created, COUNT('.$db->quoteName('created').') as count FROM '.$db->quoteName('#__community_engagement') .' WHERE ' . $db->quoteName('action') ." IN (". $actions .") " .' AND YEAR('.$db->quoteName('created').') = YEAR(CURDATE()) AND MONTH('.$db->quoteName('created').') = MONTH(CURDATE())' .' GROUP BY DATE('.$db->quoteName('created').')'; break; case 'lastmonth': $query = 'SELECT DATE('.$db->quoteName('created').') as created, COUNT('.$db->quoteName('created').') as count FROM '.$db->quoteName('#__community_engagement') .' WHERE ' . $db->quoteName('action') ." IN (". $actions .") " .' AND YEAR('.$db->quoteName('created').') = YEAR(CURDATE() - INTERVAL 1 MONTH) AND MONTH('.$db->quoteName('created').') = MONTH(CURDATE() - INTERVAL 1 MONTH)' .' GROUP BY DATE('.$db->quoteName('created').')'; break; default: $query = ''; } $db->setQuery($query); try { $result = $db->loadObjectList(); } catch (Exception $e) { Factory::getApplication()->enqueueMessage($e->getMessage(), 'error'); } return $result; } }
| ver. 1.1 | |
.
| PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка