protected function getInput() { $id = JRequest::getInt('id'); $class = !empty($this->class) ? ' ' . $this->class : ''; $session = JFactory::getSession(); $datesDB = $session->get('ic_submit_dates', ''); if ($id && empty($datesDB)) { $db = JFactory::getDBO(); $db->setQuery('SELECT a.dates' . ' FROM #__icagenda_events AS a' . ' WHERE a.id = ' . (int) $id); $datesDB = $db->loadResult(); } $dates = iCString::isSerialized($datesDB) ? unserialize($datesDB) : false; $html = '<table id="dTable" style="border:0px">'; $html .= '<thead>'; $html .= '<tr>'; $html .= '<th width="70%">'; $html .= JText::_('COM_ICAGENDA_TB_DATE'); $html .= '</th>'; $html .= '<th width="30%">'; // $html.= JText::_('COM_ICAGENDA_TB_ACT'); $html .= '</th>'; $html .= '</tr>'; $html .= '</thead>'; if ($dates && $dates != array('0000-00-00 00:00')) { foreach ($dates as $date) { $html .= '<tr>'; $html .= '<td>'; $html .= '<input class="ic-date-input" type="text" name="d" value="' . $date . '" />'; $html .= '</td>'; $html .= '<td>'; $html .= '<a class="del btn btn-danger btn-mini" href="#">' . JText::_('COM_ICAGENDA_DELETE_DATE') . '</a>'; $html .= '</td>'; $html .= '</tr>'; } // clear the data so we don't process it again $session->clear('ic_submit_dates'); } else { $html .= '<tr>'; $html .= '<td>'; $html .= '<input class="ic-date-input" type="text" name="d" value="0000-00-00 00:00" />'; $html .= '</td>'; $html .= '<td>'; $html .= '<a class="del btn btn-danger btn-mini" href="#">' . JText::_('COM_ICAGENDA_DELETE_DATE') . '</a>'; $html .= '</td>'; $html .= '</tr>'; } $html .= '</table>'; $html .= '<a id="add" href="#"><span class="btn btn-success btn-small input-medium" style="float:left"><strong>' . JText::_('COM_ICAGENDA_ADD_DATE') . '</strong></span></a><br/>'; $html .= '<input type="hidden"'; $html .= ' class="date' . $class . '"'; $html .= ' id="' . $this->id . '_id"'; $html .= ' name="' . $this->name . '"'; $html .= ' value=\'' . $datesDB . '\''; $html .= '/>'; return $html; }
/** * Single Dates list for one event */ private function getDatelist($dates, $next) { $dates = iCString::isSerialized($dates) ? unserialize($dates) : array(); $da = array(); foreach ($dates as $d) { if (strtotime($d) >= strtotime($next) && iCDate::isDate($d)) { array_push($da, date('Y-m-d H:i', strtotime($d))); } } return $da; }
protected function getInput() { $lang = JFactory::getLanguage(); $id_suffix = $lang->getTag() == 'fa-IR' ? '_jalali' : ''; if ($lang->getTag() == 'fa-IR') { // Including fallback code for HTML5 non supported browsers. JHtml::_('jquery.framework'); JHtml::_('script', 'system/html5fallback.js', false, true); } $id = JRequest::getInt('id'); $class = !empty($this->class) ? ' ' . $this->class : ''; $session = JFactory::getSession(); $datesDB = $session->get('ic_submit_dates', ''); if ($id && empty($datesDB)) { $db = JFactory::getDBO(); $db->setQuery('SELECT a.dates' . ' FROM #__icagenda_events AS a' . ' WHERE a.id = ' . (int) $id); $datesDB = $db->loadResult(); } $dates = iCString::isSerialized($datesDB) ? unserialize($datesDB) : false; // if ($lang->getTag() == 'fa-IR' // && $dates // && $dates != array('0000-00-00 00:00')) // { // $dates_to_sql = array(); // foreach ($dates AS $date) // { // if (iCDate::isDate($date)) // { // $year = date('Y', strtotime($date)); // $month = date('m', strtotime($date)); // $day = date('d', strtotime($date)); // $time = date('H:i', strtotime($date)); // $dates_to_sql[] = iCGlobalizeConvert::gregorianToJalali($year, $month, $day, true) . ' ' . $time; // } // } // $dates = $dates_to_sql; // } $html = '<table id="dTable' . $id_suffix . '" style="border:0px">'; $html .= '<thead>'; $html .= '<tr>'; $html .= '<th width="70%">'; $html .= JText::_('COM_ICAGENDA_TB_DATE'); $html .= '</th>'; $html .= '<th width="30%">'; // $html.= JText::_('COM_ICAGENDA_TB_ACT'); $html .= '</th>'; $html .= '</tr>'; $html .= '</thead>'; $add_counter = 0; if ($dates && $dates != array('0000-00-00 00:00')) { foreach ($dates as $date) { $html .= '<tr>'; $html .= '<td>'; if ($lang->getTag() == 'fa-IR') { $add_counter = $add_counter + 1; // $this_number = $add_counter ? $add_counter : ''; $html .= JHtml::_('calendar', $date, 'd', 'date_jalali' . $add_counter, '%Y-%m-%d %H:%M', ' class="ic-date-input' . $id_suffix . '"'); } else { $html .= '<input class="ic-date-input' . $id_suffix . '" type="text" name="d" value="' . $date . '" />'; } $html .= '</td>'; $html .= '<td>'; $html .= '<a class="del btn btn-danger btn-mini" href="#">' . JText::_('COM_ICAGENDA_DELETE_DATE') . '</a>'; $html .= '</td>'; $html .= '</tr>'; } // clear the data so we don't process it again $session->clear('ic_submit_dates'); } else { $html .= '<tr>'; $html .= '<td>'; if ($lang->getTag() == 'fa-IR') { $html .= JHtml::_('calendar', '0000-00-00 00:00', 'd', 'date_jalali', '%Y-%m-%d %H:%M', ' class="ic-date-input' . $id_suffix . '"'); } else { $html .= '<input class="ic-date-input' . $id_suffix . '" type="text" name="d" value="0000-00-00 00:00" />'; } $html .= '</td>'; $html .= '<td>'; $html .= '<a class="del btn btn-danger btn-mini" href="#">' . JText::_('COM_ICAGENDA_DELETE_DATE') . '</a>'; $html .= '</td>'; $html .= '</tr>'; } $html .= '</table>'; $html .= '<a id="add" href="#"><span class="btn btn-success btn-small input-medium" style="float:left"><strong>' . JText::_('COM_ICAGENDA_ADD_DATE') . '</strong></span></a><br/>'; $html .= '<input type="hidden"'; $html .= ' class="date' . $class . '"'; $html .= ' id="' . $this->id . '_id"'; $html .= ' name="' . $this->name . '"'; $html .= ' value=\'' . $datesDB . '\''; $html .= '/>'; return $html; }
public static function nextDate($evt, $i) { $eventTimeZone = null; $singledates = iCString::isSerialized($i->dates) ? unserialize($i->dates) : array(); // returns array $period = iCString::isSerialized($i->period) ? unserialize($i->period) : array(); // returns array $startdatetime = $i->startdatetime; $enddatetime = $i->enddatetime; $weekdays = $i->weekdays; $site_today_date = JHtml::date('now', 'Y-m-d'); $UTC_today_date = JHtml::date('now', 'Y-m-d', $eventTimeZone); $next_date = JHtml::date($evt, 'Y-m-d', $eventTimeZone); $next_datetime = JHtml::date($evt, 'Y-m-d H:i', $eventTimeZone); $start_date = JHtml::date($i->startdatetime, 'Y-m-d', $eventTimeZone); $end_date = JHtml::date($i->enddatetime, 'Y-m-d', $eventTimeZone); // Check if date from a period with weekdays has end time of the period set in next. // $time_next_datetime = JHtml::date($next_datetime, 'H:i', $eventTimeZone); $time_next_datetime = date('H:i', strtotime($next_datetime)); $time_startdate = JHtml::date($i->startdatetime, 'H:i', $eventTimeZone); $time_enddate = JHtml::date($i->enddatetime, 'H:i', $eventTimeZone); $data_next_datetime = date('Y-m-d H:i', strtotime($evt)); if ($next_date == $site_today_date && $time_next_datetime == $time_enddate) { $next_datetime = $next_date . ' ' . $time_startdate; } if ($period != NULL && in_array($data_next_datetime, $period)) { $next_is_in_period = true; } else { $next_is_in_period = false; } // Highlight event in progress if ($next_date == $site_today_date) { $start_span = '<span class="ic-next-today">'; $end_span = '</span>'; } else { $start_span = $end_span = ''; } $separator = '<span class="ic-datetime-separator"> - </span>'; // Format Next Date if ($next_is_in_period && ($start_date == $end_date || $weekdays != null)) { // Next in the period & (same start/end date OR one or more weekday selected) $nextDate = $start_span; $nextDate .= '<span class="ic-period-startdate">'; $nextDate .= self::formatDate($evt); $nextDate .= '</span>'; if ($i->displaytime == 1) { $nextDate .= ' <span class="ic-single-starttime">' . icagendaEvents::dateToTimeFormat($startdatetime) . '</span>'; if (icagendaEvents::dateToTimeFormat($startdatetime) != icagendaEvents::dateToTimeFormat($enddatetime)) { $nextDate .= $separator . '<span class="ic-single-endtime">' . icagendaEvents::dateToTimeFormat($enddatetime) . '</span>'; } } $nextDate .= $end_span; } elseif ($next_is_in_period && $weekdays == null) { // Next in the period & different start/end date & no weekday selected $start = '<span class="ic-period-startdate">'; $start .= self::formatDate($startdatetime); $start .= '</span>'; $end = '<span class="ic-period-enddate">'; $end .= self::formatDate($enddatetime); $end .= '</span>'; if ($i->displaytime == 1) { $start .= ' <span class="ic-period-starttime">' . icagendaEvents::dateToTimeFormat($startdatetime) . '</span>'; $end .= ' <span class="ic-period-endtime">' . icagendaEvents::dateToTimeFormat($enddatetime) . '</span>'; } $nextDate = $start_span . $start . $separator . $end . $end_span; } else { // Next is a single date $nextDate = $start_span; $nextDate .= '<span class="ic-single-next">'; $nextDate .= self::formatDate($evt); $nextDate .= '</span>'; if ($i->displaytime == 1) { $nextDate .= ' <span class="ic-single-starttime">' . icagendaEvents::dateToTimeFormat($evt) . '</span>'; } $nextDate .= $end_span; } return $nextDate; }
protected function AllDates($saved_date, $saved_time, $event_id, $saveddate, $data_eventid, $date_is_datetime_sql) { // Preparing connection to db $db = JFactory::getDbo(); // Preparing the query $query = $db->getQuery(true); // Selectable items $query->select('next AS next, dates AS dates, startdate AS startdate, enddate AS enddate, weekdays AS weekdays, id AS id, state AS state, access AS access, params AS params'); $query->from('`#__icagenda_events` AS e'); // $query->where(' e.id = '.$event_id); $list_of_dates_id = $event_id ? $event_id : $data_eventid; if ($list_of_dates_id) { $query->where('(' . $list_of_dates_id . ' = e.id)'); } $db->setQuery($query); $allnext = $db->loadObjectList(); foreach ($allnext as $i) { // Set Event Params $eventparam = new JRegistry($i->params); $typeReg = $eventparam->get('typeReg'); // Declare AllDates array $AllDates = array(); // Get WeekDays setting $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(); foreach ($singledates as $sd) { $isValid = iCDate::isDate($sd); if ($isValid) { array_push($AllDates, $sd); } } // 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); $onlyStDate = isset($this->onlyStDate) ? $this->onlyStDate : ''; if (isset($perioddates) && is_array($perioddates)) { foreach ($perioddates as $Dat) { if (in_array(date('w', strtotime($Dat)), $WeeksDays)) { // May not work in php < 5.2.3 (should return false if date null since 5.2.4) $isValid = iCDate::isDate($Dat); if ($isValid) { $SingleDate = date('Y-m-d H:i', strtotime($Dat)); array_push($AllDates, $SingleDate); } } } } } $today = time(); // get Time Format $timeformat = JComponentHelper::getParams('com_icagenda')->get('timeformat', '1'); $lang_time = $timeformat == 1 ? 'H:i' : 'h:i A'; if (!empty($AllDates)) { sort($AllDates); } $eventid_url = JRequest::getVar('eventid', ''); echo '<div>'; echo '<select type="hidden" name="' . $this->name . '">'; if (!$eventid_url || $eventid_url == $data_eventid) { $date_value = $saveddate; } else { $date_value = ''; } $selected = !strtotime($saveddate) ? ' selected="selected"' : ''; $reg_datetime = date('Y-m-d H:i:s', strtotime($saved_date . ' ' . $saved_time)); $is_valid = date('Y-m-d H:i:s', strtotime($reg_datetime)) == $saveddate; $if_old_value = !$is_valid ? $saveddate : ''; echo '<option value="' . $if_old_value . '">- ' . JText::_('COM_ICAGENDA_REGISTRATION_NO_DATE_SELECTED') . ' -</option>'; $date_exist = false; if ($list_of_dates_id) { foreach ($AllDates as $date) { if ($date && $date != '0000-00-00 00:00' && $date != '0000-00-00 00:00:00') { $value_datetime = date('Y-m-d H:i:s', strtotime($date)); echo '<option value="' . $value_datetime . '"'; if ($reg_datetime == $value_datetime) { $date_exist = true; echo ' selected="selected"'; } echo '>' . $this->formatDate($date) . ' - ' . date($lang_time, strtotime($date)) . '</option>'; } } } echo '</select>'; echo '</div>'; if (!empty($AllDates) && !in_array(date('Y-m-d H:i', strtotime($saveddate)), $AllDates) && $date_is_datetime_sql) { $date_no_longer_exists = '<strong>"' . $saveddate . '"</strong>'; echo '<div class="alert alert-error"><strong>' . JText::_('COM_ICAGENDA_FORM_WARNING') . '</strong><br /><small>' . JText::sprintf('COM_ICAGENDA_REGISTRATION_DATE_NO_LONGER_EXISTS', $date_no_longer_exists) . '</small></div>'; } }
protected function wlivecalendarUrl($i) { $text = $i->title . ' (' . $i->cat_title . ')'; $details = $i->desc; $venue = $i->place_name; $s_dates = $i->dates; // $single_dates = unserialize($s_dates); $single_dates = iCString::isSerialized($i->dates) ? unserialize($i->dates) : array(); // returns array $website = $this->Event_Link($i); $location = $venue ? $venue . ' - ' . $i->address : $i->address; $get_date = ''; $href = '#'; $endday = ''; if (JRequest::getVar('date')) { // if 'All Dates' set $get_date = JRequest::getVar('date'); } else { // if 'Only Next/Last Date' set $get_date = date('Y-m-d-H-i', strtotime($i->next)); } $ex = explode('-', $get_date); $this_date = $ex['0'] . '-' . $ex['1'] . '-' . $ex['2'] . ' ' . $ex['3'] . ':' . $ex['4']; $startdate = date('Y-m-d-H-i', strtotime($i->startdate)); $enddate = date('Y-m-d-H-i', strtotime($i->enddate)); if ($this->eventHasPeriod($i) && $get_date >= $startdate && $get_date <= $enddate && !in_array($this_date, $single_dates)) { $weekdays = $i->weekdays || $i->weekdays == '0' ? true : false; if ($weekdays) { $startdate = date('Y-m-d-H-i', strtotime($this_date)); $enddate = date('Y-m-d', strtotime($this_date)) . '-' . date('H-i', strtotime($i->enddate)); } $ex_S = explode('-', $startdate); $ex_E = explode('-', $enddate); $dateday = $ex_S['0'] . $ex_S['1'] . $ex_S['2'] . 'T' . $ex_S['3'] . $ex_S['4'] . '00'; $endday = $ex_E['0'] . $ex_E['1'] . $ex_E['2'] . 'T' . $ex_E['3'] . $ex_E['4'] . '00'; } else { $dateday = $ex['0'] . $ex['1'] . $ex['2'] . 'T' . $ex['3'] . $ex['4'] . '00'; } $href = "http://calendar.live.com/calendar/calendar.aspx?rru=addevent"; $href .= "&dtstart=" . $dateday; $href .= isset($endday) ? "&dtend=" . $endday : ''; $href .= "&summary=" . urlencode($text); $href .= "&location=" . urlencode($location); // Shortens the description, if more than 1000 characters $lengthMax = '1000'; $details = urlencode(strip_tags($details)); $details = substr($details, 0, $lengthMax); $shortenedDetails = strrpos($details, '+'); $details = substr($details, 0, $shortenedDetails); $href .= "&description=" . substr($details, 0, $lengthMax) . '...'; return $href; }
public function getData() { $app = JFactory::getApplication(); $eventTimeZone = null; $error_messages = array(); jimport('joomla.filter.output'); // Get Params $params = $app->getParams(); $submitAccess = $params->get('submitAccess', ''); $approvalGroups = $params->get('approvalGroups', array("8")); // Get User $user = JFactory::getUser(); // Get User Groups // Joomla 3.x/2.5 SWITCH if (version_compare(JVERSION, '3.0', 'ge')) { $userGroups = $user->groups; } else { $userGroups = $user->getAuthorisedGroups(); } $user_id = $user->get('id'); // logged-in Users: Name/User Name Option $nameJoomlaUser = $params->get('nameJoomlaUser', 1); $u_name = $nameJoomlaUser == 1 ? $user->get('name') : $user->get('username'); $this->data = new stdClass(); $this->data->id = null; $this->data->asset_id = JRequest::getVar('asset_id', '', 'post'); $this->data->ordering = 0; $this->data->state = 1; // Control: if Manager jimport('joomla.access.access'); $adminUsersArray = array(); foreach ($approvalGroups as $ag) { $adminUsers = JAccess::getUsersByGroup($ag, False); $adminUsersArray = array_merge($adminUsersArray, $adminUsers); } $this->data->approval = in_array($user_id, $adminUsersArray) ? '0' : '1'; $this->data->access = 1; $this->data->language = '*'; // $menuID = JRequest::getVar('menuID', '', 'post'); // USER NAME $this->data->username = JRequest::getVar('username', '', 'post'); if (!$this->data->username) { $error_messages[] = JText::sprintf('COM_ICAGENDA_FORM_VALIDATE_FIELD_REQUIRED_NAME', JText::_('COM_ICAGENDA_SUBMIT_FORM_USER_NAME')); } // USER EMAIL $this->data->created_by_email = JRequest::getVar('created_by_email', '', 'post'); if (!$this->data->created_by_email) { $error_messages[] = JText::sprintf('COM_ICAGENDA_FORM_VALIDATE_FIELD_REQUIRED_NAME', JText::_('COM_ICAGENDA_SUBMIT_FORM_USER_EMAIL')); } // EVENT TITLE $this->data->title = JRequest::getVar('title', '', 'post'); if (!$this->data->title) { $error_messages[] = JText::sprintf('COM_ICAGENDA_FORM_VALIDATE_FIELD_REQUIRED_NAME', JText::_('COM_ICAGENDA_FORM_LBL_EVENT_TITLE')); } // EVENT CATEGORY $this->data->catid = JRequest::getVar('catid', '', 'post'); if (!$this->data->catid) { $error_messages[] = JText::sprintf('COM_ICAGENDA_FORM_VALIDATE_FIELD_REQUIRED_NAME', JText::_('COM_ICAGENDA_FORM_LBL_EVENT_CATID')); } // EVENT IMAGE - Get and Upload Image $image = JRequest::getVar('image', null, 'files', 'array'); $image_session = JRequest::getVar('image_session', '', 'post'); if ($image_session && empty($image)) { $this->data->image = $image_session; } else { $this->data->image = $image; // Process upload of files $this->data->image = $this->frontendImageUpload($this->data->image); } $noDateTime = '0000-00-00 00:00:00'; $noDateTimeShort = '0000-00-00 00:00'; // Get Single Dates $single_dates = JRequest::getVar('dates', '', 'post'); $dates = iCString::isSerialized($single_dates) ? unserialize($single_dates) : $this->getDates($single_dates); // $dates = !empty($dates[0]) ? $dates : array($noDateTime); rsort($dates); $datesall = iCDate::isDate($dates[0]) ? $dates[0] : $noDateTimeShort; if ($datesall != $noDateTimeShort) { $this->data->dates = serialize($dates); } else { $no_date_array = array($noDateTimeShort); $this->data->dates = serialize($no_date_array); } // Set Next Date from Single Dates $dates_array = unserialize($this->data->dates); $today = JHtml::date('now', 'Y-m-d H:i:s', $eventTimeZone); $next = JHtml::date($this->data->dates[0], 'Y-m-d H:i:s', $eventTimeZone); rsort($dates_array); $nextDate = $next; if ($next <= $today) { foreach ($dates_array as $date) { $single_date = JHtml::date($date, 'Y-m-d H:i:s', $eventTimeZone); if ($single_date >= $today) { $nextDate = $single_date; } } } $single_dates_next = $nextDate; // PERIOD DATES $this->data->startdate = JRequest::getVar('startdate', '', 'post'); $this->data->enddate = JRequest::getVar('enddate', '', 'post'); $isDate_startdate = iCDate::isDate($this->data->startdate); $isDate_enddate = iCDate::isDate($this->data->enddate); $this->data->startdate = $isDate_startdate ? $this->data->startdate : $noDateTime; $this->data->enddate = $isDate_enddate ? $this->data->enddate : $noDateTime; // Dates from the period if ($isDate_startdate && $isDate_enddate) { $startdate = $this->data->startdate; $enddate = $this->data->enddate; if ($startdate == $noDateTime && $enddate != $noDateTime) { $enddate = $noDateTime; } $startcontrol = JHtml::date($startdate, 'Y-m-d H:i', $eventTimeZone); $endcontrol = JHtml::date($enddate, 'Y-m-d H:i', $eventTimeZone); $errorperiod = ''; if ($startcontrol > $endcontrol) { $errorperiod = '1'; } else { $period_all_dates_array = iCDatePeriod::listDates($startdate, $enddate); } // Serialize Dates of the Period if ($isDate_startdate && $isDate_enddate) { if ($errorperiod != '1') { $this->data->period = serialize($period_all_dates_array); $ctrl = unserialize($this->data->period); if (is_array($ctrl)) { $period = unserialize($this->data->period); } else { $period = $this->getPeriod($this->data->period); } rsort($period); $this->data->period = serialize($period); } else { $this->data->period = ''; } } $period_dates_next = $this->data->startdate; $dates_next = JHtml::date($single_dates_next, 'Y-m-d H:i:s', $eventTimeZone); $period_next = JHtml::date($period_dates_next, 'Y-m-d H:i:s', $eventTimeZone); if ($dates_next < $period_next) { $this->data->next = $period_next; } else { $this->data->next = $dates_next; } } else { $this->data->period = ''; $this->data->next = $single_dates_next; } // Period and Single Dates not displayed if ((in_array($noDateTime, $dates_array) || in_array($noDateTimeShort, $dates_array)) && (!$isDate_startdate || !$isDate_enddate)) { $this->data->state = '0'; $this->data->next = $today; // Error message if no valid dates $error_messages[] = JText::sprintf('COM_ICAGENDA_FORM_WARNING', JText::_('COM_ICAGENDA_FORM_ERROR_NO_DATES')); } // WEEK DAYS $this->data->weekdays = JRequest::getVar('weekdays', '', 'post'); if (!isset($this->data->weekdays) && !is_array($this->data->weekdays)) { $this->data->weekdays = ''; } if (isset($this->data->weekdays) && is_array($this->data->weekdays)) { $this->data->weekdays = implode(",", $this->data->weekdays); } // Joomla 3.x/2.5 SWITCH if (version_compare(JVERSION, '3.0', 'ge')) { $this->data->desc = JFactory::getApplication()->input->get('desc', '', 'RAW'); } else { $this->data->desc = JRequest::getVar('desc', '', 'post', 'string', JREQUEST_ALLOWHTML); } $this->data->shortdesc = JRequest::getVar('shortdesc', '', 'post'); $this->data->metadesc = JRequest::getVar('metadesc', '', 'post'); $this->data->place = JRequest::getVar('place', '', 'post'); $this->data->email = JRequest::getVar('email', '', 'post'); $this->data->phone = JRequest::getVar('phone', '', 'post'); $this->data->website = JRequest::getVar('website', '', 'post'); // ATTACHMENT FILE $file = JRequest::getVar('file', null, 'files', 'array'); $file_session = JRequest::getVar('file_session', '', 'post'); if ($file_session && empty($file)) { $this->data->file = $file_session; } else { $this->data->file = $file; // Process upload of files $this->data->file = $this->frontendFileUpload($this->data->file); } $this->data->address = JRequest::getVar('address', '', 'post'); $this->data->city = JRequest::getVar('city', '', 'post'); $this->data->country = JRequest::getVar('country', '', 'post'); $this->data->lat = JRequest::getVar('lat', '', 'post'); $this->data->lng = JRequest::getVar('lng', '', 'post'); $this->data->created_by = $user_id; $this->data->created_by_alias = JRequest::getVar('created_by_alias', '', 'post'); $this->data->created = JHtml::Date('now', 'Y-m-d H:i:s'); $this->data->checked_out = JRequest::getVar('checked_out', '', 'post'); $this->data->checked_out_time = JRequest::getVar('checked_out_time', '', 'post'); $this->data->params = JRequest::getVar('params', '', 'post'); $this->data->site_itemid = JRequest::getVar('site_itemid', '0', 'post'); $site_menu_title = JRequest::getVar('site_menu_title', '', 'post'); // Generate Alias $this->data->alias = JFilterOutput::stringURLSafe($this->data->title); // Alias is not generated if non-latin characters, so we fix it by using created date, or title if unicode is activated, as alias if ($this->data->alias == null) { if (JFactory::getConfig()->get('unicodeslugs') == 1) { $this->data->alias = JFilterOutput::stringURLUnicodeSlug($this->data->title); } else { $this->data->alias = JFilterOutput::stringURLSafe($this->data->created); } } // Convert the params field to a string. if (isset($this->data->params) && is_array($this->data->params)) { $parameter = new JRegistry(); $parameter->loadArray($this->data->params); $this->data->params = (string) $parameter; } $this->data->asset_id = null; $custom_fields = JRequest::getVar('custom_fields', '', 'post'); // Check if Custom Fields required not empty $customfields_list = icagendaCustomfields::getListCustomFields($this->data->id, 2, 1); if ($customfields_list) { foreach ($customfields_list as $cf) { if (isset($custom_fields[$cf->cf_slug]) && $cf->cf_required == 1 && $custom_fields[$cf->cf_slug] == '') { $options_required = array('list', 'radio'); // If type is list or radio, should have options if (in_array($cf->cf_type, $options_required) && $cf->cf_options || !in_array($cf->cf_type, $options_required)) { $error_messages[] = JText::_('COM_ICAGENDA_FORM_VALIDATE_FIELD_REQUIRED') . ' ' . $cf->cf_title; } } } } $address_session = JRequest::getVar('address_session', '', 'post'); $submit_tos = JRequest::getVar('submit_tos', '', 'post'); // Set Form Data to Session $session = JFactory::getSession(); $session->set('ic_submit', $this->data); $session->set('custom_fields', $custom_fields); $session->set('ic_submit_dates', $this->data->dates); $session->set('ic_submit_catid', $this->data->catid); $session->set('ic_submit_shortdesc', $this->data->shortdesc); $session->set('ic_submit_metadesc', $this->data->metadesc); $session->set('ic_submit_city', $this->data->city); $session->set('ic_submit_country', $this->data->country); $session->set('ic_submit_lat', $this->data->lat); $session->set('ic_submit_lng', $this->data->lng); $session->set('ic_submit_address', $this->data->address); $session->set('ic_submit_tos', $submit_tos); // Captcha Control $captcha = JRequest::getVar('recaptcha_response_field', '', 'post'); $captcha_plugin = $params->get('captcha') ? $params->get('captcha') : $app->getCfg('captcha'); $submit_captcha = $params->get('submit_captcha', 1); if ($captcha_plugin && $submit_captcha != '0') { JPluginHelper::importPlugin('captcha'); // JOOMLA 3.x/2.5 SWITCH if (version_compare(JVERSION, '3.0', 'ge')) { $dispatcher = JEventDispatcher::getInstance(); } else { $dispatcher = JDispatcher::getInstance(); } $res = $dispatcher->trigger('onCheckAnswer', $captcha); if (!$res[0]) { // message if captcha is invalid $error_messages[] = JText::sprintf('COM_ICAGENDA_FORM_ERROR', JText::_('COM_ICAGENDA_FORM_ERROR_INCORRECT_CAPTCHA_SOL')); } } // Get the message queue if (count($error_messages)) { $app->enqueueMessage('<strong>' . JText::_('COM_ICAGENDA_FORM_NC') . '</strong>', 'error'); foreach ($error_messages as $msg) { $app->enqueueMessage($msg, 'error'); } return false; } // clear the data so we don't process it again $session->clear('ic_submit'); $session->clear('custom_fields'); $session->clear('ic_submit_dates'); $session->clear('ic_submit_catid'); $session->clear('ic_submit_shortdesc'); $session->clear('ic_submit_metadesc'); $session->clear('ic_submit_city'); $session->clear('ic_submit_country'); $session->clear('ic_submit_lat'); $session->clear('ic_submit_lat'); $session->clear('ic_submit_address'); $session->clear('ic_submit_tos'); // insert Event in Database $db = JFactory::getDbo(); if ($this->data->username != NULL && $this->data->title != NULL && $this->data->created_by_email != NULL) { $db->insertObject('#__icagenda_events', $this->data, id); } else { JError::raiseError(500, implode('<br />', $errors)); return false; } // Save Custom Fields to database if (isset($custom_fields) && is_array($custom_fields)) { icagendaCustomfields::saveToData($custom_fields, $this->data->id, 2); } // Get the "event" URL $baseURL = JURI::base(); $subpathURL = JURI::base(true); $baseURL = str_replace('/administrator', '', $baseURL); $subpathURL = str_replace('/administrator', '', $subpathURL); $urlsend = str_replace('&', '&', JRoute::_('index.php?option=com_icagenda&view=submit&layout=send')); // Sub Path filtering $subpathURL = ltrim($subpathURL, '/'); // URL List filtering $urlsend = ltrim($urlsend, '/'); if (substr($urlsend, 0, strlen($subpathURL) + 1) == "{$subpathURL}/") { $urlsend = substr($urlsend, strlen($subpathURL) + 1); } $urlsend = rtrim($baseURL, '/') . '/' . ltrim($urlsend, '/'); if (isset($this->data->id) and $this->data->id != '0' and $this->data->username != NULL and $this->data->title != NULL) { self::notificationManagerEmail($this->data, $site_menu_title, $user_id); if (!in_array($user_id, $adminUsersArray)) { self::notificationUserEmail($this->data, $urlsend); } } else { JError::raiseError(500, implode('<br />', $errors)); return false; } // redirect after successful submission $submit_return = $params->get('submitReturn', ''); $submit_return_article = $params->get('submitReturn_Article', $urlsend); $submit_return_url = $params->get('submitReturn_Url', $urlsend); if ($submit_return == 1 && is_numeric($submit_return_article)) { $url_return = JURI::root() . 'index.php?option=com_content&view=article&id=' . $submit_return_article; } elseif ($submit_return == 2) { $url_return = $submit_return_url; } else { $url_return = $urlsend; } $alert_title = $params->get('alert_title', ''); $alert_body = $params->get('alert_body', ''); $url_redirect = $urlsend_custom ? $urlsend_custom : $urlsend; $alert_title_redirect = $alert_title ? $alert_title : JText::_('COM_ICAGENDA_EVENT_SUBMISSION'); $alert_body_redirect = $alert_body ? $alert_body : JText::_('COM_ICAGENDA_EVENT_SUBMISSION_CONFIRMATION'); if ($submit_return != 2) { $app->enqueueMessage($alert_body_redirect, $alert_title_redirect); $app->redirect(htmlspecialchars_decode($url_return)); } else { $url_return = iCUrl::urlParsed($url_return, 'scheme'); $app->redirect($url_return); } }
/** * Overloaded bind function to pre-process the params. * * @param array Named array * @return null|string null is operation was satisfactory, otherwise returns an error * @see JTable:bind * @since 1.3 */ public function bind($array, $ignore = '') { // Serialize Single Dates $dev_option = '0'; // Set Vars $eventTimeZone = null; $nodate = '0000-00-00 00:00:00'; $date_today = JHtml::date('now', 'Y-m-d'); // Joomla Time Zone if (iCString::isSerialized($array['dates'])) { $dates = unserialize($array['dates']); } elseif ($dev_option == '1') { $dates = $this->setDatesOptions($array['dates']); } else { $dates = $this->getDates($array['dates']); } $dates = $dates == array('') ? array('0000-00-00 00:00') : $dates; rsort($dates); if ($dev_option == '1') { $array['dates'] = $array['dates']; } else { $array['dates'] = serialize($dates); } /** * Set Week Days */ if (!isset($array['weekdays'])) { $array['weekdays'] = ''; } elseif (is_array($array['weekdays'])) { $array['weekdays'] = implode(',', $array['weekdays']); } // Return the dates of the period. $startdate = $array['startdate'] == NULL ? $nodate : $array['startdate']; $enddate = $array['enddate'] == NULL ? $nodate : $array['enddate']; if ($startdate == $nodate && $enddate != $nodate) { $enddate = $nodate; } if (strtotime($startdate) > strtotime($enddate)) { $errorperiod = '1'; } else { $errorperiod = ''; $period_all_dates_array = iCDatePeriod::listDates($startdate, $enddate, $eventTimeZone); $WeeksDays = iCDatePeriod::weekdaysToArray($array['weekdays']); $period_array = array(); foreach ($period_all_dates_array as $date_in_weekdays) { $datetime_period_date = JHtml::date($date_in_weekdays, 'Y-m-d H:i', $eventTimeZone); if (in_array(date('w', strtotime($datetime_period_date)), $WeeksDays)) { array_push($period_array, $datetime_period_date); } } } // Serialize Period Dates if ($startdate != $nodate && $enddate != $nodate) { if ($errorperiod != '1') { $array['period'] = serialize($period_array); if (iCString::isSerialized($array['period'])) { $period = unserialize($array['period']); } else { $period = $this->getPeriod($array['period']); } rsort($period); $array['period'] = serialize($period); } else { $array['period'] = ''; } } else { $array['period'] = ''; } // Set Next Date $NextDates = $this->getNextDates($dates); $NextPeriod = isset($period) ? $this->getNextPeriod($period, $array['weekdays']) : $this->getNextDates($dates); $date_NextDates = JHtml::date($NextDates, 'Y-m-d', $eventTimeZone); $date_NextPeriod = JHtml::date($NextPeriod, 'Y-m-d', $eventTimeZone); $time_NextDates = JHtml::date($NextDates, 'H:i', $eventTimeZone); $time_NextPeriod = JHtml::date($NextPeriod, 'H:i', $eventTimeZone); // Control the next date if (strtotime($date_NextDates) >= strtotime($date_today) && strtotime($date_NextPeriod) >= strtotime($date_today)) { if (strtotime($date_NextDates) < strtotime($date_NextPeriod)) { $array['next'] = $this->getNextDates($dates); } if (strtotime($date_NextDates) > strtotime($date_NextPeriod)) { $array['next'] = $this->getNextPeriod($period, $array['weekdays']); } if (strtotime($date_NextDates) == strtotime($date_NextPeriod)) { if (strtotime($time_NextDates) >= strtotime($time_NextPeriod)) { if (isset($period)) { $array['next'] = $this->getNextPeriod($period, $array['weekdays']); } else { $array['next'] = $this->getNextDates($dates); } } else { $array['next'] = $this->getNextDates($dates); } } } elseif (strtotime($date_NextDates) < strtotime($date_today) && strtotime($date_NextPeriod) >= strtotime($date_today)) { $array['next'] = $this->getNextPeriod($period, $array['weekdays']); } elseif (strtotime($date_NextDates) >= strtotime($date_today) && strtotime($date_NextPeriod) < strtotime($date_today)) { $array['next'] = $this->getNextDates($dates); } elseif (strtotime($date_NextDates) < strtotime($date_today) && strtotime($date_NextPeriod) < strtotime($date_today)) { if (strtotime($date_NextDates) < strtotime($date_NextPeriod)) { $array['next'] = $this->getNextPeriod($period, $array['weekdays']); } else { $array['next'] = $this->getNextDates($dates); } } // Control of dates if valid (EDIT SINCE VERSION 3.0 - update 3.1.4) if (strtotime($NextDates) >= '943916400' && strtotime($NextDates) <= '944002800' && $errorperiod == '1') { $array['next'] = '-3600'; } if ((strtotime($NextDates) == '943916400' || strtotime($NextDates) == '943920000') && (strtotime($NextPeriod) == '943916400' || strtotime($NextPeriod) == '943920000')) { $array['next'] = '-3600'; } if ($array['next'] == '-3600') { $state = 0; $this->_db->setQuery('UPDATE `#__icagenda_events`' . ' SET `state` = ' . (int) $state . ' WHERE `id` = ' . (int) $array['id']); if (version_compare(JVERSION, '3.0', 'lt')) { $this->_db->query(); } else { $this->_db->execute(); } } $return[] = parent::bind($array, $ignore); // ==================================== // START : HACK FOR A FEW PRO USERS !!! // ==================================== $mail_new_event = JComponentHelper::getParams('com_icagenda')->get('mail_new_event', '0'); if ($mail_new_event == 1) { $title = $array['title']; $id_event = $array['id']; $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('id AS eventID')->from('#__icagenda_events')->order('id DESC'); $db->setQuery($query); $eventID = $db->loadResult(); $new_event = JRequest::getVar('new_event'); $title = $array['title']; $description = $array['desc']; $venue = ''; if ($array['place']) { $venue .= $array['place'] . ' - '; } if ($array['city']) { $venue .= $array['city']; } if ($array['city'] && $array['country']) { $venue .= ', '; } if ($array['country']) { $venue .= $array['country']; } if (strtotime($array['startdate'])) { $date = 'Du ' . $array['startdate'] . ' au ' . $array['startdate']; } else { $date = $array['next']; } $baseURL = JURI::base(); $baseURL = str_replace('/administrator', '', $baseURL); $baseURL = ltrim($baseURL, '/'); if ($array['image']) { $image = '<img src="' . $baseURL . '/' . $array['image'] . '" />'; } if ($new_event == '1' && $eventID && $array['state'] == '1' && $array['approval'] == '0') { $return[] = self::notificationNewEvent($eventID + 1, $title, $description, $venue, $date, $image, $new_event); } } // ==================================== // END : HACK FOR A FEW PRO USERS !!! // ==================================== return $return; }
public static function getOptionsAllDates($i, $view = null, $reg_date = null, $reg_period = null) { $options = ''; if ($i) { // Set Event Params $eventparam = new JRegistry($i->params); $typeReg = $eventparam->get('typeReg'); // Registration type for event is set to "All dates of the event" if ($typeReg == '2') { if ($reg_period != 1) { $options .= '<option value="' . $reg_date . '" selected="selected">' . JText::_('COM_ICAGENDA_SELECT_DATE') . '</option>'; $options .= '<option value="update"'; $options .= '>' . JText::_('COM_ICAGENDA_ADMIN_REGISTRATION_FOR_ALL_DATES') . '</option>'; } else { $options .= '<option value=""'; $options .= ' selected="selected"'; $options .= '>' . JText::_('COM_ICAGENDA_ADMIN_REGISTRATION_FOR_ALL_DATES') . '</option>'; } } else { if (!$reg_date && $reg_period == 1 || $reg_date && !iCDate::isDate($reg_date) || !$reg_date && $reg_period == 0 || iCDate::isDate($reg_date) && $reg_period == 1) { $options .= '<option value="' . $reg_date . '"'; $options .= ' selected="selected"'; $options .= '>' . JText::_('COM_ICAGENDA_SELECT_DATE') . '</option>'; } // Declare AllDates array $AllDates = array(); // Get WeekDays setting $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(); foreach ($singledates as $sd) { if (iCDate::isDate($sd)) { array_push($AllDates, $sd); } } // 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); if (isset($perioddates) && is_array($perioddates)) { // Check the period if is separated into individual dates $is_full_period = $i->weekdays || $i->weekdays == '0' ? false : true; if ($is_full_period && iCDate::isDate($i->startdate) && iCDate::isDate($i->enddate)) { $value_datetime = ''; $options .= '<option value="' . $value_datetime . '"'; if ($reg_date == '' && $reg_period != 1) { $date_exist = true; $options .= ' selected="selected"'; } $options .= '>' . self::formatDate($i->startdate) . ' ➜ ' . self::formatDate($i->startdate) . '</option>'; } else { foreach ($perioddates as $Dat) { if (in_array(date('w', strtotime($Dat)), $WeeksDays)) { // May not work in php < 5.2.3 (should return false if date null since 5.2.4) $isValid = iCDate::isDate($Dat); if ($isValid) { $SingleDate = date('Y-m-d H:i', strtotime($Dat)); array_push($AllDates, $SingleDate); } } } } } // get Time Format $timeformat = JComponentHelper::getParams('com_icagenda')->get('timeformat', '1'); $lang_time = $timeformat == 1 ? 'H:i' : 'h:i A'; if (!empty($AllDates)) { sort($AllDates); } foreach ($AllDates as $date) { if (iCDate::isDate($date)) { $value_datetime = date('Y-m-d H:i:s', strtotime($date)); $options .= '<option value="' . $value_datetime . '"'; if ($reg_date == $value_datetime) { $date_exist = true; $options .= ' selected="selected"'; } $options .= '>' . self::formatDate($date) . ' - ' . date($lang_time, strtotime($date)) . '</option>'; } } } return $options; } return false; }
/** * 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; } 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; } 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; } 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; } } } 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); } } }