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; }