_google.php

<?php
function google_create_date($dateobj)
{
	if (property_exists($dateobj, "dateTime")) {
		return date_create($dateobj->dateTime);
	} else return date_create($dateobj->date);
}

function google_is_appointment($item)
{
	// TODO: and if in specific calendar
	return property_exists($item->start, "dateTime") && property_exists($item->end, "dateTime");
}

function google_get_next_events($config, $force_reload = false)
{
	// Get next Google events from now
	$now = date(DATE_RFC3339);
	if (property_exists($config, 'last_google_check')) {
		$from = $config->last_google_check;
		// check if last call to Google was less than caching time ago
		// TODO make configurable
		// weird code. Explanation: check if last check + 15min is in the future by checking if we need to go backwards from there to get to now.
		// note the PT that is necessary because weird PHP uses M for months and minutes whyyyyy it does not in date()
		if(!$force_reload && date_diff(date_add(date_create($from), new DateInterval("PT15M")), date_create($now))->invert == 1) {
			return [];
		}
	} else {
		$from = $now;
	}
	// @TODO limit to 4 weeks
	// @TODO handle multiple pages - Google returns plenty, but we must not rely on the first page to contain everything we need
	$items = [];
	for($i = 0; $i < count($config->google_calendars); $i++) {
		$url = 'https://www.googleapis.com/calendar/v3/calendars/' . $config->google_calendars[$i] . '/events';
		$params['singleEvents'] = 'true';
		$params['orderBy'] = 'startTime';
		$params['timeMin'] = $from;
		$json = get_json_google($url, $params);
		$items = array_merge($items, $json->items);
	}
	$config->last_google_check = $now;
	file_put_contents('data/config.json', json_encode($config));
	return $items;
}

function google_write_items_to_database(PDO $conn, $items)
{
	// Write events to database
	$ioi = $conn->prepare('INSERT OR IGNORE INTO tasks (description, duration, date, google_id, deadline_day) VALUES (:description, :duration, :date, :google_id, :deadline_day)');
	$conn->beginTransaction();
	foreach ($items as $item) {
		$start = google_create_date($item->start);
		$end = google_create_date($item->end);
		$duration = calculate_duration($start, $end);
		$ioi->bindValue(':description', $item->summary);
		$ioi->bindValue(':google_id', $item->id);
		if (google_is_appointment($item)) {
			$ioi->bindValue(':deadline_day', $end->format('Y-m-d'));
		} else {
			$ioi->bindValue(':deadline_day', null);
		}
		$ioi->bindValue(':duration', $duration, PDO::PARAM_INT);
		$ioi->bindValue(':date', $start->format('Y-m-d'));
		$ioi->execute();
	}
	return $conn->commit();
}