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

Файловый менеджер - Редактировать - /home/wuectly/www/administrator/components/com_icagenda/utilities/events/data.php

Назад
<?php /** ------------------------------------------------------------------------------ iCagenda v3 by Jooml!C - Events Management Extension for Joomla! 2.5 / 3.x ------------------------------------------------------------------------------ @package iCagenda * @subpackage utilities * @copyright Copyright (c)2014-2015 Cyril Rezé, Jooml!C - All rights reserved * * @license GNU General Public License version 3 or later; see LICENSE.txt * @author Cyril Rezé (Lyr!C) * @link http://www.joomlic.com * * @version 3.5.7 2015-07-14 * @since 3.5.0 ------------------------------------------------------------------------------ / // No direct access to this file defined('_JEXEC') or die(); /** * class icagendaEventsData * Transitional class and functions * * DEPRECATED and TO BE REMOVED in 3.7.x / class icagendaEventsData { /* * ALL DATES * * @since 3.5.0 / public static function getAllDates($filterTime = null, $datesDisplay = null, $orderby = null, $mcatid = null, $module = null) { $app = JFactory::getApplication(); $jinput = $app->input; $params = $app->getParams(); // Get Settings $filterTime = ($filterTime == 'no') ? '0' : $filterTime; $filterTime = (isset($filterTime) \|\| $filterTime == '0') ? $filterTime : $params->get('time', 1); $datesDisplay = $datesDisplay ? $datesDisplay : $params->get('datesDisplay', 1); $orderby = $orderby ? $orderby : $params->get('orderby', 2); $mcatid = ($mcatid == 'no') ? array() : $params->get('mcatid'); // $module = ($module == 'calendar') ? $module : false; // Set vars $nodate = '0000-00-00 00:00:00'; $ic_nodate = '0000-00-00 00:00'; $eventTimeZone = null; $datetime_today = JHtml::date('now', 'Y-m-d H:i'); // Joomla Time Zone $date_today = JHtml::date('now', 'Y-m-d'); // Joomla Time Zone // $datetime_today = date('Y-m-d H:i'); // $date_today = date('Y-m-d'); // Get Data $db = Jfactory::getDbo(); $query = $db->getQuery(true); $query->select('e.next, e.dates, e.startdate, e.enddate, e.period, e.weekdays, e.displaytime, e.id, e.catid'); $query->from('#__icagenda_events AS e'); $query->leftJoin('`#__icagenda_category` AS c ON c.id = e.catid'); // CATEGORY STATE Filtering $query->where('c.state = 1'); // EVENT STATE Filtering $query->where('e.state = 1'); // CATEGORY Filtering // $mcatid = is_array($mcatid) ? $mcatid : array(); // $selcat = implode(', ', $mcatid); // if ( ! in_array('0', $mcatid) // && count($mcatid) // ) // { // $query->where('e.catid IN (' . $selcat . ')'); // } // Filter by categories. $categoryId = $mcatid; if (is_numeric($categoryId) && ! empty($categoryId)) { $query->where('e.catid = ' . $categoryId . ''); } elseif (is_array($categoryId) && ! empty($categoryId) && ! in_array('0', $categoryId)) { JArrayHelper::toInteger($categoryId); $categoryId = implode(',', $categoryId); $query->where('e.catid IN (' . $categoryId . ')'); } // FRONTEND FILTERS // Filter by published state $published = $jinput->get('filter_state'); // $published = $this->state->get('filter.state'); if (is_numeric($published)) { $query->where('e.state = '.(int) $published); } elseif ($published === '') { $query->where('(e.state IN (0, 1))'); } // Filter by category $category = $jinput->get('filter_category'); // $category = $this->state->get('filter.category'); if (is_numeric($category)) { $query->where('e.catid = '.(int) $category); } $filter_startdate = $jinput->get('filter_startdate'); $filter_enddate = $jinput->get('filter_enddate'); $filter_year = $jinput->get('filter_year'); // FEATURES Filtering $query->where(self::getFeaturesFilter()); // LANGUAGE Filtering $query->where('e.language IN (' . $db->q(JFactory::getLanguage()->getTag()) . ',' . $db->q('') . ')'); // ACCESS Filtering $user = JFactory::getUser(); $userID = $user->id; $userLevels = $user->getAuthorisedViewLevels(); $userGroups = $user->groups; $groupid = JComponentHelper::getParams('com_icagenda')->get('approvalGroups', array("8")); $groupid = is_array($groupid) ? $groupid : array($groupid); if (!in_array('8', $userGroups) ) { $useraccess = implode(', ', $userLevels); $query->where('e.access IN (' . $useraccess . ')'); } // APPROVAL RIGHTS Filtering if (!array_intersect($userGroups, $groupid) && !in_array('8', $userGroups)) { $query->where('e.approval <> 1'); } else { $query->where('e.approval < 2'); } $db->setQuery($query); $list = $db->loadObjectList(); $list_all_dates = array(); foreach ($list AS $i) { $i_id = $i->id; $i_startdate = $i->startdate; $i_enddate = $i->enddate; $i_weekdays = $i->weekdays; $i_dates = $i->dates; $i_displaytime = $i->displaytime; // Declare AllDates array $AllDatesDisplay = array(); // Get WeekDays Array $WeeksDays = iCDatePeriod::weekdaysToArray($i_weekdays); // If Single Dates, added each one to All Dates for this event $singledates = iCString::isSerialized($i_dates) ? unserialize($i_dates) : array(); $singleDatesArray = array(); $no_filtering = '0'; foreach ($singledates as $sd) { $isValid = iCDate::isDate($sd); if ($isValid) { $date_Dat = JHtml::date($sd, 'Y-m-d', $eventTimeZone); $SingleDate = JHtml::date($sd, 'Y-m-d H:i', $eventTimeZone); $data_SingleDate = date('Y-m-d H:i', strtotime($sd)); // Frontend Filtering if ( ! empty($filter_year)) { if (date('Y', strtotime($date_Dat)) == $filter_year) { $singleDatesArray[] = $data_SingleDate . '_' . $i_id; } } elseif ( ! empty($filter_startdate) && ! empty($filter_enddate)) { if (strtotime($date_Dat) >= strtotime($filter_startdate) && strtotime($date_Dat) <= strtotime($filter_enddate) ) { $singleDatesArray[] = $data_SingleDate . '_' . $i_id; } } // All Dates for each event elseif ($datesDisplay == 1) { $singleDatesArray[] = $data_SingleDate . '_' . $i_id; } // Current Today elseif ($filterTime == 4 && strtotime($SingleDate) >= strtotime($date_today) ) { $singleDatesArray[] = $data_SingleDate . '_' . $i_id; } // Upcoming Events elseif ($filterTime == 3 && strtotime($SingleDate) > strtotime($datetime_today) ) { $singleDatesArray[] = $data_SingleDate . '_' . $i_id; } // Past event elseif ($filterTime == 2 && strtotime($SingleDate) < strtotime($datetime_today) ) { $singleDatesArray[] = $data_SingleDate . '_' . $i_id; } // Current and Upcoming Events elseif ($filterTime == 1 && strtotime($SingleDate) > strtotime($datetime_today) ) { $singleDatesArray[] = $data_SingleDate . '_' . $i_id; } // All Dates elseif (!$filterTime) { // All Upcoming dates if (strtotime($SingleDate) >= strtotime($datetime_today)) { $no_filtering = $no_filtering + 1; $singleDatesArray[] = $data_SingleDate . '_' . $i_id; } // If no Upcoming dates, get the last date elseif ($no_filtering == 0 && strtotime($SingleDate) < strtotime($datetime_today)) { $no_filtering = $no_filtering + 1; $singleDatesArray[] = $data_SingleDate . '_' . $i_id; } } } } if ($datesDisplay == 2 && $filterTime == 2 && count($singleDatesArray) > 0) // Past Events { $AllDatesDisplay[] = max($singleDatesArray); } elseif ($datesDisplay == 2 && count($singleDatesArray) > 0) { $AllDatesDisplay[] = min($singleDatesArray); } else { $AllDatesDisplay = array_merge($AllDatesDisplay, $singleDatesArray); } // If Period Dates, added each one to All Dates for this event (filter week Days, and if date not null) // $perioddates = iCDatePeriod::listDates($i_startdate, $i_enddate, $eventTimeZone); $perioddates = iCDatePeriod::listDates($i_startdate, $i_enddate); $period_array = array(); foreach ($perioddates AS $date_in_weekdays) { // $datetime_period_date = JHtml::date($date_in_weekdays, 'Y-m-d H:i', $eventTimeZone); // $datetime_period_date = date('Y-m-d H:i', strtotime($date_in_weekdays)); // $datetime_period_date = $date_in_weekdays; if (in_array(date('w', strtotime($date_in_weekdays)), $WeeksDays) && iCDate::isDate($date_in_weekdays)) { $period_array[] = $date_in_weekdays; } } $only_startdate = ($i_weekdays \|\| $i_weekdays == '0') ? false : true; // $only_startdate = ! $module ? $only_startdate : false; $StDate = JHtml::date($i_startdate, 'Y-m-d H:i', $eventTimeZone); $EnDate = JHtml::date($i_enddate, 'Y-m-d H:i', $eventTimeZone); $date_startdate = JHtml::date($i_startdate, 'Y-m-d', $eventTimeZone); $date_enddate = JHtml::date($i_enddate, 'Y-m-d', $eventTimeZone); $time_startdate = JHtml::date($i_startdate, 'H:i', $eventTimeZone); $time_enddate = JHtml::date($i_enddate, 'H:i', $eventTimeZone); $data_StDate = date('Y-m-d H:i', strtotime($i_startdate)); $data_time_startdate = date('H:i', strtotime($i_startdate)); // $StDate = date('Y-m-d H:i', strtotime($i_startdate)); // $EnDate = date('Y-m-d H:i', strtotime($i_enddate)); // $date_startdate = date('Y-m-d', strtotime($i_startdate)); // $date_enddate = date('Y-m-d', strtotime($i_enddate)); // $time_startdate = date('H:i', strtotime($i_startdate)); // $time_enddate = date('H:i', strtotime($i_enddate)); if (isset($period_array) && ($period_array != NULL && $period_array) ) { if ($only_startdate) { $AllDatesDisplay[] = $data_StDate . '_' . $i_id; } else { $dp = 0; $count_period = count($period_array); $cp = 0; $no_filtering = 0; foreach ($period_array as $Dat) { $date_Dat = JHtml::date($Dat, 'Y-m-d', $eventTimeZone); $SingleDate = JHtml::date($Dat, 'Y-m-d H:i', $eventTimeZone); $data_date_Dat = date('Y-m-d', strtotime($Dat)); $data_SingleDate = date('Y-m-d H:i', strtotime($Dat)); // $date_Dat = date('Y-m-d', strtotime($Dat)); // $SingleDate = date('Y-m-d H:i', strtotime($Dat)); if (in_array(date('w', strtotime($Dat)), $WeeksDays) && $dp == 0 ) { // Frontend Filtering if ( ! empty($filter_year)) { if (date('Y', strtotime($date_Dat)) == $filter_year) { $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } } elseif ( ! empty($filter_startdate) && ! empty($filter_enddate)) { if (strtotime($date_Dat) >= strtotime($filter_startdate) && strtotime($date_Dat) <= strtotime($filter_enddate) ) { $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } } // Current Today and Upcoming Today elseif ($filterTime == 4 && strtotime($date_Dat) == strtotime($date_today)) { if ($i_displaytime == 1 && strtotime($date_Dat . ' ' . $time_enddate) >= strtotime($datetime_today)) { $dp = ($datesDisplay == 2) ? $dp+1 : 0; $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } else { $dp = ($datesDisplay == 2) ? $dp+1 : 0; $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } } // Upcoming elseif ($filterTime == 3 && strtotime($SingleDate) > strtotime($datetime_today)) { $dp = ($datesDisplay == 2) ? $dp+1 : 0; $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } // Past elseif ($filterTime == 2 && strtotime($date_Dat) < strtotime($date_today)) { $dp = ($datesDisplay == 2) ? $dp+1 : 0; $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } // Current Today and Upcoming elseif ($filterTime == 1) { if ($i_displaytime == 1 && strtotime($date_Dat . ' ' . $time_enddate) >= strtotime($datetime_today)) { $dp = ($datesDisplay == 2) ? $dp+1 : 0; $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } elseif ($i_displaytime != 1 && strtotime($date_Dat) >= strtotime($date_today)) { $dp = ($datesDisplay == 2) ? $dp+1 : 0; $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } } // No Filtering elseif ( ! $filterTime) { // All Upcoming dates if (strtotime($SingleDate) >= strtotime($datetime_today)) { $dp = ($datesDisplay == 2) ? $dp+1 : 0; $no_filtering = ($datesDisplay == 2) ? $no_filtering+1 : 0; $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } // If no Upcoming dates, get the last date elseif ($no_filtering == 0 && $datesDisplay == 2 && strtotime($SingleDate) < strtotime($datetime_today)) { $dp = $dp+1; $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } // If display All Dates, get the last dates elseif ( $datesDisplay == 1 && strtotime($SingleDate) < strtotime($datetime_today)) { $dp = 0; $AllDatesDisplay[] = $data_SingleDate . '_' . $i_id; } } } } } } // If not All Dates display (select only one date for each event) if ( $datesDisplay == 2 && count($AllDatesDisplay) > 0 ) { $ex_min = explode('_', min($AllDatesDisplay)); // $min_date = $ex_min[0]; $min_date = JHtml::date($ex_min[0], 'Y-m-d H:i', null); $ex_max = explode('_', max($AllDatesDisplay)); // $max_date = $ex_max[0]; $max_date = JHtml::date($ex_max[0], 'Y-m-d H:i', null); if ($filterTime != '4') { // min date is upcoming if ( $min_date >= $datetime_today ) { $AllDatesDisplay = array(min($AllDatesDisplay)); } // All events elseif ($filterTime == '0') { // min date in Period and upcoming if (in_array($min_date, $period_array) && $min_date >= $datetime_today ) { $AllDatesDisplay = array(min($AllDatesDisplay)); } // min date is Single date and not past elseif ( ! in_array($min_date, $period_array) && ($min_date > $datetime_today) ) { $AllDatesDisplay = array(min($AllDatesDisplay)); } // min date is Single date and past else { $AllDatesDisplay = array(max($AllDatesDisplay)); } } else { $AllDatesDisplay = array(max($AllDatesDisplay)); } } else { $AllDatesDisplay = array(min($AllDatesDisplay)); } } $AllDatesFilterTime = array(); foreach ($AllDatesDisplay as $fD) { $ex_date = explode('_', $fD); $get_date = $ex_date['0']; $date_get_date = JHtml::date($get_date, 'Y-m-d', $eventTimeZone); $data_date_get_date = date('Y-m-d', strtotime($get_date)); // Frontend Filtering if ( ! empty($filter_year)) { if (date('Y', strtotime($get_date)) == $filter_year) { $AllDatesFilterTime[] = $fD; } } elseif ( ! empty($filter_startdate) && ! empty($filter_enddate)) { if (strtotime($get_date) >= strtotime($filter_startdate) && strtotime($get_date) <= strtotime($filter_enddate) ) { $AllDatesFilterTime[] = $fD; } } // (0) Filter Dates : All Dates elseif ($filterTime == 0) { // Period with no weekdays selected if ( in_array($get_date, $perioddates) && $only_startdate && ! in_array($StDate . '_' . $i_id, $AllDatesFilterTime) ) { $AllDatesFilterTime[] = $data_StDate . '_' . $i_id; } // Period with weekdays selected elseif ( in_array($get_date, $perioddates) && ! $only_startdate ) { $AllDatesFilterTime[] = $fD; } // Single Dates elseif ( ! in_array($get_date, $perioddates) ) { $AllDatesFilterTime[] = $fD; } } // (1) Filter Dates : Ongoing and Upcoming elseif ($filterTime == 1) { // Period with no weekdays selected if (in_array($get_date, $perioddates) && $only_startdate && strtotime($EnDate) >= strtotime($datetime_today) && !in_array($StDate . '_' . $i_id, $AllDatesFilterTime) ) { $AllDatesFilterTime[] = $data_StDate . '_' . $i_id; } // Period with weekdays selected elseif (in_array($get_date, $perioddates) && !$only_startdate ) { // If display time, control end time of the day if ($i_displaytime == 1 && strtotime($date_get_date . ' ' . $time_enddate) >= strtotime($datetime_today)) { $AllDatesFilterTime[] = $fD; } // If do not display time, control start time of the day elseif ($i_displaytime != 1 && strtotime($date_get_date) >= strtotime($date_today)) { $AllDatesFilterTime[] = $fD; } } // Single Dates elseif (!in_array($get_date, $perioddates) // && strtotime($get_date) >= strtotime($datetime_today) // Changed because single dates have no end time, so admitted end time is midnight. && strtotime($get_date) >= strtotime($date_today) ) { $AllDatesFilterTime[] = $fD; } } // (2) Filter Dates : Past Dates elseif ($filterTime == 2) { // Period with no weekdays selected if ( in_array($get_date, $perioddates) && $only_startdate && (strtotime($EnDate) < strtotime($datetime_today)) ) { $AllDatesFilterTime[] = $fD; } // Period with weekdays selected elseif ( in_array($get_date, $perioddates) && !$only_startdate && strtotime($get_date) < strtotime($datetime_today) && strtotime($date_get_date . ' ' . $time_enddate) < strtotime($datetime_today) ) { $AllDatesFilterTime[] = $fD; } // Single Dates elseif ( !in_array($get_date, $perioddates) && strtotime($get_date) < strtotime($datetime_today) ) { $AllDatesFilterTime[] = $fD; } } // (3) Filter Dates : Upcoming elseif ($filterTime == 3) { // Period with no weekdays selected if (in_array($get_date, $perioddates) && $only_startdate && (strtotime($StDate) > strtotime($datetime_today)) ) { $AllDatesFilterTime[] = $fD; } // Period with weekdays selected elseif (in_array($get_date, $perioddates) && ! $only_startdate && strtotime($get_date) > strtotime($datetime_today) && strtotime($date_get_date . ' ' . $time_startdate) > strtotime($datetime_today) ) { $AllDatesFilterTime[] = $fD; } // Single Dates elseif ( ! in_array($get_date, $perioddates) && strtotime($get_date) > strtotime($datetime_today) ) { $AllDatesFilterTime[] = $fD; } } // (4) Filter Dates : Ongoing Events today elseif ($filterTime == 4) { // Period with no weekdays selected if (in_array($get_date, $perioddates) && $only_startdate && strtotime($EnDate) > strtotime($datetime_today) && strtotime($StDate) < (strtotime($date_today) + 86400) ) { $AllDatesFilterTime[] = $data_date_get_date . ' ' . $data_time_startdate . '_' . $i_id; } // Period with weekdays selected elseif ( in_array($get_date, $perioddates) && ! $only_startdate && ( strtotime($date_get_date) == strtotime($date_today) && strtotime($date_get_date . ' ' . $time_enddate) < (strtotime($date_today) + 86400) ) ) { $AllDatesFilterTime[] = $fD; } // Single Dates elseif ( !in_array($get_date, $perioddates) // && ( strtotime($get_date) >= strtotime($datetime_today) // Changed because single dates have no end time, so admitted end time is midnight. && ( strtotime($get_date) >= strtotime($date_today) && strtotime($get_date) < (strtotime($date_today) + 86400) ) ) { $AllDatesFilterTime[] = $fD; } } } $list_all_dates = array_merge($list_all_dates, $AllDatesFilterTime); } if ($orderby == 2) { sort($list_all_dates); } else { rsort($list_all_dates); } return $list_all_dates; } /** * Get and update NEXT DATE * * @since 3.5.4 / public static function getNext() { $app = JFactory::getApplication(); $params = $app->getParams(); // Get Settings $filterTime = $params->get('time', 1); // Set vars $nodate = '0000-00-00 00:00:00'; $eventTimeZone = null; $datetime_today = JHtml::date('now', 'Y-m-d H:i:s'); // Joomla Time Zone $date_today = JHtml::date('now', 'Y-m-d'); // Joomla Time Zone $time_today = JHtml::date('now', 'H:i:s'); // Joomla Time Zone // $datetime_today = date('Y-m-d H:i:s'); // $date_today = date('Y-m-d'); // $time_today = date('H:i:s'); // Preparing connection to db $db = Jfactory::getDbo(); // Preparing the query $query = $db->getQuery(true); $query->select('next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess'); $query->from('`#__icagenda_events` AS e'); $query->where(' e.state = 1 OR e.state = 0 '); $db->setQuery($query); $all_next_dates = $db->loadObjectList(); foreach ($all_next_dates as $nd) { $nd_next = $nd->tNext; $nd_id = $nd->tId; $nd_state = $nd->tState; $nd_dates = $nd->tDates; $nd_startdate = $nd->tStartdate; $nd_enddate = $nd->tEnddate; $nd_weekdays = $nd->tWeekdays; // If Single Dates, added to all dates for this event $singleDates = iCString::isSerialized($nd_dates) ? unserialize($nd_dates) : array(); $AllDates = array(); // Get WeekDays Array $WeeksDays = iCDatePeriod::weekdaysToArray($nd_weekdays); if (isset ($singleDates) && $singleDates != NULL && !in_array($nodate, $singleDates) && !in_array('', $singleDates) ) { $AllDates = array_merge($AllDates, $singleDates); } elseif (in_array('', $singleDates)) { $datesarray = array(); $nodate = array('0000-00-00 00:00'); $datesmerger = array_push($datesarray, $nodate); $DatesUpdate = serialize($nodate); $query = $db->getQuery(true); $query->update('#__icagenda_events'); $query->set("`dates`='" . (string)$DatesUpdate . "'"); $query->where('`id`=' . (int)$nd_id); $db->setQuery($query); $db->query($query); $nosingledates = unserialize($DatesUpdate); $AllDates = array_merge($AllDates, $nosingledates); } // $StDate = JHtml::date($nd_startdate, 'Y-m-d H:i', $eventTimeZone); // $EnDate = JHtml::date($nd_enddate, 'Y-m-d H:i', $eventTimeZone); // $date_enddate = JHtml::date($nd_enddate, 'Y-m-d', $eventTimeZone); // $time_enddate = JHtml::date($nd_enddate, 'H:i', $eventTimeZone); // $date_startdate = JHtml::date($nd_startdate, 'Y-m-d', $eventTimeZone); // $time_startdate = JHtml::date($nd_startdate, 'H:i', $eventTimeZone); $StDate = date('Y-m-d H:i', strtotime($nd_startdate)); $EnDate = date('Y-m-d H:i', strtotime($nd_enddate)); $date_enddate = date('Y-m-d', strtotime($nd_enddate)); $time_enddate = date('H:i', strtotime($nd_enddate)); $date_startdate = date('Y-m-d', strtotime($nd_startdate)); $time_startdate = date('H:i', strtotime($nd_startdate)); // $perioddates = iCDatePeriod::listDates($nd_startdate, $nd_enddate, $eventTimeZone); $perioddates = iCDatePeriod::listDates($nd_startdate, $nd_enddate); $only_startdate = ($nd_weekdays \|\| $nd_weekdays == '0') ? false : true; if (isset($perioddates) && $perioddates != NULL ) { // Period with no weekdays in Upcoming and Past options if ($only_startdate && ($filterTime == '3' \|\| $filterTime == '2') ) { array_push($AllDates, $StDate); } else { foreach ($perioddates as $Dat) { if (in_array(date('w', strtotime($Dat)), $WeeksDays)) { $date_Dat = date('Y-m-d', strtotime($Dat)); $SingleDate = date('Y-m-d H:i', strtotime($Dat)); if ( $date_Dat == $date_today && $filterTime != 3 ) { // Next in Period is today, so set end time array_push($AllDates, $date_Dat . ' ' .$time_startdate); } else { array_push($AllDates, $SingleDate); } } } } } rsort($AllDates); if ($AllDates == NULL) { $next ='0000-00-00 00:00:00'; } else { $date_lastdate = date('Y-m-d', strtotime($AllDates[0])); $datetime_lastdate = date('Y-m-d H:i:s', strtotime($AllDates[0])); $date_startdate = date('Y-m-d', strtotime($nd_startdate)); $date_enddate = date('Y-m-d', strtotime($nd_enddate)); $time_startdate = date('H:i:s', strtotime($nd_startdate)); $time_enddate = date('H:i:s', strtotime($nd_enddate)); $returnNext = $nd_next; $next_is_set = '0'; // $today_SD = '0'; $today_upcoming_SD = '0'; $upcoming_SD = '0'; foreach ($AllDates as $a) { $tsdate_a = date('Y-m-d', strtotime($a)); if ($tsdate_a == $date_today) { // All single dates today // $today_SD = $today_SD + 1; // All single dates today and not yet started $today_upcoming_SD = (strtotime($a) > strtotime($datetime_today)) ? ($today_upcoming_SD + 1) : $today_upcoming_SD; } if ($tsdate_a >= $datetime_today) { // All upcoming single dates $upcoming_SD = $upcoming_SD + 1; } } $total_today_SD = $today_upcoming_SD; foreach ($AllDates as $a) { $tsdatetime_a = date('Y-m-d H:i:s', strtotime($a)); $tsdate_a = date('Y-m-d', strtotime($a)); // Only past single dates if ($datetime_lastdate < $datetime_today && $date_lastdate != $date_today && $next_is_set == '0') { $returnNext = date('Y-m-d H:i:s', strtotime($AllDates[0])); $next_is_set = $next_is_set + 1; } // The last date is today elseif ($date_lastdate == $date_today && $next_is_set == '0' && $total_today_SD == 1) { // Period divided into days if ($nd_startdate != $nodate && $nd_enddate != $nodate && in_array($a, $perioddates) && !$only_startdate ) { $returnNext = date('Y-m-d', strtotime($nd_enddate)) . ' ' . $time_startdate; $next_is_set = $next_is_set + 1; } // Full period (from ... to ...) elseif ($nd_startdate != $nodate && $nd_enddate != $nodate && in_array($a, $perioddates) && $only_startdate ) { $returnNext = date('Y-m-d', strtotime($nd_startdate)) . ' ' . $time_startdate; $next_is_set = $next_is_set + 1; } // Single date else { if ($datetime_lastdate > $datetime_today) { $today_upcoming_SD = $today_upcoming_SD - 1; } if ($datetime_lastdate > $datetime_today && $today_upcoming_SD == '0') { $returnNext = date('Y-m-d H:i:s', strtotime($AllDates[0])); $next_is_set = $next_is_set + 1; } } } // Multiple upcoming single dates // elseif ($tsdatetime_a > $datetime_today) // Changed because single dates have no end time, so admitted end time is midnight. elseif ($tsdatetime_a > $date_today && $next_is_set == '0') { // Remaining Today's upcoming dates if ($tsdate_a == $date_today) { if ($tsdatetime_a > $datetime_today) { $today_upcoming_SD = $today_upcoming_SD - 1; } } // Remaining Upcoming dates if ($tsdate_a >= $datetime_today) { $upcoming_SD = $upcoming_SD - 1; } if ($today_upcoming_SD == '0' && $upcoming_SD == '0') { $returnNext = date('Y-m-d H:i:s', strtotime($a)); $next_is_set = $next_is_set + 1; } } } // Test End Date if Next Date or Last Date (3.1.5) $date_returnNext = date('Y-m-d', strtotime($returnNext)); $time_returnNext = date('H:i:s', strtotime($returnNext)); if ( ($date_enddate != '0000-00-00') && ( $date_today == $date_enddate \|\| $date_today == $date_returnNext) ) { $time_LastTime = $time_startdate; } else { $time_LastTime = $time_returnNext; } // Fix 3.1.12 (removed isset($tPeriod)) if ( ($nd_enddate != $nodate) && ($date_startdate < $date_today) && ($date_enddate == $date_today) && ($time_LastTime >= $time_today) ) { // $returnNextPediod = JHtml::date($nd_enddate, 'Y-m-d', $eventTimeZone) . ' ' . $time_startdate; $returnNextPediod = date('Y-m-d', strtotime($nd_enddate)) . ' ' . $time_startdate; } else { $returnNextPediod = $returnNext; } // Set next var if ( ($date_returnNext == $date_enddate) && ($date_enddate == $date_today) ) { $next = $returnNextPediod; } elseif (strtotime($date_startdate) < strtotime($date_today) && strtotime($date_enddate) >= strtotime($date_today) && strtotime($time_enddate) != strtotime($time_returnNext) && strtotime($time_LastTime) > strtotime($time_today) ) { $next = $date_returnNext . ' ' . date('H:i:s', strtotime($time_LastTime)); } else { $next = $returnNext; } } // 3.1.12 Fixed and update events with bug if ($nd_next == $nodate && $nd_state == 0 && $nd_startdate != $nodate && $nd_enddate != $nodate && strtotime($nd_enddate) >= strtotime($nd_startdate) ) { $next = $returnNext; $query = $db->getQuery(true); $query->update('#__icagenda_events'); $query->set('`state`=1'); $query->where('`id`='.(int)$nd_id); $db->setQuery($query); $db->query($query); } if ($next != $nd_next) { $query = $db->getQuery(true); $query->update('#__icagenda_events'); $query->set("`next`='".$next."'"); $query->where('`id`='.(int)$nd_id); $db->setQuery($query); $db->query($query); } } } /* * Returns the element of a SQL query WHERE clause to support filtering the selection of Events using Event Features * * Controlled by menu parameters: * features_filter - array of Feature IDs * features_incl_excl - indicates whether the Feature IDs are to be used to include or exclude Events * features_any_all - indicates whether any Feature ID or all Feature IDs required to include or exclude an Event * * One or more sub-queries is referenced in a WHERE clause with IN() or NOT IN() to include or exclude Events. * * If any Feature ID in isolation is to include or exclude Event records then a single sub-query is used that * uses a simple inner join between the feature and feature_xref tables to identify the distinct set of Event IDs * linked to any one of the spacific Feature IDs. * * If all Feature IDs combined are required to include or exclude Events then separate sub-queries are used for * each of the spacific Feature IDs. For this case, a more efficient option is available involving a direct join * with either an inner or outer join, according to whether records are being included or excluded but this * puts an unreasonable constraint on the overall syntax of the query. / public static function getFeaturesFilter() { // get the application object $app = JFactory::getApplication(); $params = $app->getParams(); // Initialise a return value that can be included harmlessly in a WHERE clause, if necessary $filter = ' TRUE '; $featureids = $params->get('features_filter', ''); if (is_array($featureids) && !empty($featureids)) { $db = Jfactory::getDbo(); $incl_excl = $params->get('features_incl_excl', '1') == '1' ? '' : 'NOT'; if ($params->get('features_any_all', '1') == '1') { // Any single Feature ID will include or exclude events // Create comma separated list of Feature IDs $featureids = implode(',', $featureids); // Create a single sub-query $sub_query = $db->getQuery(true); $sub_query->select('fx.event_id') ->from('#__icagenda_feature_xref AS fx') ->innerJoin("#__icagenda_feature AS f ON fx.feature_id=f.id AND f.state=1 AND f.show_filter=1 AND f.id IN($featureids)"); // Join the sub-query to the main query $filter = "(e.id $incl_excl IN(" . (string) $sub_query . '))'; } else { // All Feature IDs combined will include or exclude events // Create a separate sub-query for each of the Feature IDs $sub_queries = array(); foreach ($featureids as $featureid) { $sub_query = $db->getQuery(true); $sub_query->select('fx.event_id') ->from('#__icagenda_feature_xref AS fx') ->innerJoin("#__icagenda_feature AS f ON fx.feature_id=f.id AND f.state=1 AND f.show_filter=1 AND f.id=$featureid"); $sub_queries[] = "e.id $incl_excl IN(" . (string) $sub_query . ')'; } // Combine the sub-queries depending on inclusion or exclusion of events $filter = "(" . implode($incl_excl == 'NOT' ? " \nOR " : " \nAND ", $sub_queries) . ')'; } } return $filter; } /* * Return Array of all registrations from an event (date@@people) * date : registered date * people : nb of tickets for this registration * * @since 3.5.0 / public static function registeredList($id = null) { // Registrations total $db = Jfactory::getDbo(); $query = $db->getQuery(true); $query->select('r.date AS date, r.eventid AS eventid, r.people AS people'); $query->from('`#__icagenda_registration` AS r'); $query->where('r.state = 1'); if ($id) { $query->where('r.eventid = ' . $db->q($id)); } $db->setQuery($query); $result = $db->loadObjectList(); $registeredList = array(); foreach ($result AS $r) { $reg_date = $r->date ? $r->date : 'period'; $registeredList[] = $r->eventid . '@@' . $reg_date . '@@' . $r->people; } return $registeredList; } /* * Return list of all dates (singles and period) from an event * * @since 3.5.0 (Not Yet Used) */ public static function thisEventDates($id) { // Set vars $nodate = '0000-00-00 00:00:00'; $ic_nodate = '0000-00-00 00:00'; $eventTimeZone = null; // Get Data $db = Jfactory::getDbo(); $query = $db->getQuery(true); $query->select('e.next, e.dates, e.startdate, e.enddate, e.period, e.weekdays, e.displaytime, e.id'); $query->from('#__icagenda_events AS e'); $query->leftJoin('`#__icagenda_category` AS c ON c.id = e.catid'); $query->where('c.state = 1'); $query->where('e.id = ' . $db->q($id)); $db->setQuery($query); $result = $db->loadObjectList(); // Get Data $tId = $id; $tDates = $result->dates; $tStartdate = $result->startdate; $tEnddate = $result->enddate; $tWeekdays = $result->weekdays; // Declare AllDates array $thisEventDates = array(); // Get WeekDays Array $WeeksDays = iCDatePeriod::weekdaysToArray($tWeekdays); // If Single Dates, added each one to All Dates for this event $singledates = unserialize($tDates); foreach ($singledates as $sd) { $isValid = iCDate::isDate($sd); if ($isValid) { array_push($thisEventDates, $sd); } } $perioddates = iCDatePeriod::listDates($tStartdate, $tEnddate, $eventTimeZone); if (isset ($perioddates) && $perioddates != NULL) { foreach ($perioddates as $Dat) { if (in_array(date('w', strtotime($Dat)), $WeeksDays)) { $isValid = iCDate::isDate($Dat); if ($isValid) { // $SingleDate = JHtml::date($Dat, 'Y-m-d H:i:s', $eventTimeZone); $SingleDate = date('Y-m-d H:i:s', strtotime($Dat)); array_push($thisEventDates, $SingleDate); } } } } return $thisEventDates; } }

| ver. 1.4 | Github | . | PHP 8.1.34 | Генерация страницы: 0 | proxy | phpinfo | Настройка