echo date('H:i', strtotime($event->getRemindMeTime())); } else { echo $event->getRemindMeTime(); } echo ' '; } echo '<i class="fa fa-clock-o"></i> '; if ($event->getAllDay() == '1') { echo "all day"; } else { echo $start_time . '-' . $end_time; } echo '</small>'; echo ' <i class="fa fa-info-circle"></i> '; echo $event->getDescription() . ' <small><a href="/edit_evt.php?id=' . $event->getId() . '">edit</a>'; if ($event->getUserId() == Authentication::get_user() || PermissionMgr::groupHasPermission(Authentication::getUserObject()->getGroupId(), 'is_administrator')) { echo ' <a href="#" onclick="deleteEvt(' . $event->getId() . ', \'' . htmlspecialchars($event->getDescription()) . '\')">delete</a>'; } echo '</small></h5>'; $number += 1; } if ($number == 0) { echo '<i>No events on this date.</i>'; } $date = date("Y-m-d", strtotime("+1 day", strtotime($date))); echo '<hr>'; } ?>
public function update(Event $event) { global $PDO; if (!$event->getEventId()) { throw new Exception("Event don't have eventId when event don't exists"); } else { update("event", ["title" => $event->getTitle(), "description" => $event->getDescription(), "type" => $event->getType(), "location" => $event->getLocation(), "start_hour" => $event->getStartHour(), "final_hour" => $event->getFinalHour(), "color" => $event->getColor(), "status" => $event->getStatus(), "date_create" => $event->getDateCreate(), "user_id" => $event->getUserId(), "google_calendar_event_id" => $event->getGoogleCalendarEventId(), "notify_status" => $event->getNotifyStatus(), "parent_event_id" => $event->getParentEventId(), "calendar_id" => $event->getCalendarId()], ["Codigo" => $event->getEventId()]); //Event::eventId exits when not problem $eventMeta = $event->getEventMeta(); update("event_meta", ["event_id" => $eventMeta->getEventId(), "date_start" => $eventMeta->getDateStart(), "interval_case" => $eventMeta->getIntervalCase(), "interval_value" => $eventMeta->getIntervalValue(), "week" => $eventMeta->getWeek(), "week_day" => $eventMeta->getWeekDay()], ["Codigo" => $eventMeta->getEventMetaId()]); //verify if exists attendees $childEventsId = $event->childEventsId(); if ($childEventsId) { $filterOfChildEventsId = implode(",", $childEventsId); $rowsAffected = $PDO->exec("\n UPDATE event \n SET title = '{$event->getTitle()}',\n description = '{$event->getDescription()}',\n type = '{$event->getType()}',\n location = '{$event->getLocation()}',\n start_hour = '{$event->getStartHour()}',\n final_hour = '{$event->getFinalHour()}',\n color = '{$event->getColor()}'\n WHERE Codigo IN ({$filterOfChildEventsId})"); $rowsAffected = $PDO->exec("\n UPDATE event_meta \n SET date_start = '{$eventMeta->getDateStart()}',\n interval_case = '{$eventMeta->getIntervalCase()}',\n interval_value = '{$eventMeta->getIntervalValue()}',\n week = '{$eventMeta->getWeek()}',\n week_day = '{$eventMeta->getWeekDay()}'\n WHERE event_id IN ({$filterOfChildEventsId})"); } if ($event->getGoogleCalendarEventId()) { //verify google access $myGoogleClient = get_my_google_client($event->getUserId()); if ($myGoogleClient) { $client = $myGoogleClient->client; $service = new Google_Service_Calendar($client); $googleEvent = $service->events->get('primary', $event->getGoogleCalendarEventId()); $googleEvent->setSummary($event->getTitle()); $googleEvent->setDescription($event->getDescription()); $googleEvent->setLocation($event->getLocation()); //////////////////////////////////////////////////////////////////////// //create google calendar datetime $dateStart = $eventMeta->getDateStart(); $dateEnd = new DateTime($eventMeta->getDateStart()); $startHour = $event->getStartHour(); $finalHour = $event->getFinalHour(); //dateEnd $intervalValue = $eventMeta->getIntervalValue(); $dateEnd->add(new DateInterval("P{$intervalValue}D")); $dateEnd = $dateEnd->format("Y-m-d"); $start_event_date_time = new Google_Service_Calendar_EventDateTime(); $start_event_date_time->setDateTime("{$dateStart}T{$startHour}"); $start_event_date_time->setTimeZone("America/Lima"); $end_event_date_time = new Google_Service_Calendar_EventDateTime(); $end_event_date_time->setDateTime("{$dateEnd}T{$finalHour}"); $end_event_date_time->setTimeZone("America/Lima"); //////////////////////////////////////////////////////////////////////// $googleEvent->setStart($start_event_date_time); $googleEvent->setEnd($end_event_date_time); $service->events->update('primary', $googleEvent->getId(), $googleEvent); } } } return $event; }