InfoFrame: Digitaler Bilderrahmen (Anzeige von Anrufen, E-Mails, Termine, Wetter...)

$calendarList = $service->calendarList->listCalendarList();

$listParams = array ('minAccessRole' => 'reader');
$calendarList = $service->calendarList->listCalendarList($listParams);

<?php
// Includes & Settings
error_reporting (E_ERROR);
$loc = setlocale (LC_ALL, 'de_DE.UTF8', 'de_DE', 'de', 'ge');

// Config lesen
$config = parse_ini_file ("config.ini", true);
$num_days = $config['CalendarPlugin']['number_of_days'];

// Passwort und Login für ClientLogin Authentication
$user = $config['System']['google_user'];
$pass = $config['System']['google_pass'];
if ($config['System']['zendfw_path'] != "") set_include_path (get_include_path() . PATH_SEPARATOR . $config['System']['zendfw_path']);

// teste Datenbank Verbindung
$dbconn = new PDO('mysql:host=' . $config['System']['db_host'] . ';dbname=' . $config['System']['db_name'], $config['System']['db_user'], $config['System']['db_password']);

// Zend Gdata libs
require_once 'Zend/Loader.php';
Zend_Loader::loadClass ('Zend_Gdata');
Zend_Loader::loadClass ('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass ('Zend_Http_Client');
Zend_Loader::loadClass ('Zend_Gdata_Query');
Zend_Loader::loadClass ('Zend_Gdata_Feed');

try
{
	// login und setze Protokol auf Version 3.0
	$client = Zend_Gdata_ClientLogin::getHttpClient ($user, $pass, 'cp');
	$gdata = new Zend_Gdata ($client);
	$gdata->setMajorProtocolVersion (3);
	
	// query Ausführen und Ergebnis nach feed
	$query = new Zend_Gdata_Query ('http://www.google.com/m8/feeds/contacts/default/full');
	$query->maxResults = 99999;
	// "My Contacts" only
	$query->setParam( 'group', 'http://www.google.com/m8/feeds/groups/' . urlencode($user) . '/base/6' );
	$feed = $gdata->getFeed ($query);
	
	// parse feed und extraiere Kontakt Informationen
	$contacts = array ();
	foreach ($feed as $entry)
	{
		$xml = simplexml_load_string ($entry->getXML ());
		$obj = new stdClass;
		if (($b = (string) $xml->birthday['when']) != '')
			// 1970 falls kein Jarh angegeben ist
			$obj->birthday = preg_replace ("/^--/", "1970-", $b);
		else
			$obj->birthday = null;
		$obj->name = (string) $xml->name->fullName;
		$contacts[] = $obj;
	}
}
catch (Exception $e)
{
	die ('ERROR:' . $e->getMessage ());
}

// nur Geburtstage aus contacts löschen
$sql = "DELETE FROM `if_calendar` WHERE `color`='#000000'";
$dbconn->query ($sql) or die ('DELETE gescheitert: ' . $dbconn->errorInfo()[2]);

// alle Daten in results, los gehts
foreach ($contacts as $r)
{
	$na = utf8_decode ($r->name);
	if ($r->birthday)
	{
		// Geburtstag in unixtime, Termin ist Monat, Tag mit aktuellem Jahr
		$n1 = strtotime (date('o') . '-' . substr ($r->birthday, 5, 5));
		// dauert einen Tag
		$n2 = $n1 + 60 * 60 * 24;
		// liegt Geburtstag in der Vergangenheit? dann Termin plus ein Jahr
		if ($n2 < strtotime('now'))
		{	
			$n1 = strtotime ('+ 1 year', $n1);
			$n2 = strtotime ('+ 1 year', $n2);
		}
		// liegt Geburtstag ausserhalb der Anbzeigezeitspanne, dann ignorieren.
		if ($n1 < strtotime('+ ' . $num_days . ' days')) 
		{
			$sql = "INSERT INTO `if_calendar` (`color`, `begin`, `end`, `title`, `location`) VALUES ('#000000', FROM_UNIXTIME($n1) , FROM_UNIXTIME($n2) ,'" . $na . " hat Geburtstag','')";
			$dbconn->query($sql) or die ('INSERT gescheitert: ' . $dbconn->errorInfo()[2]);
		}
	}
}
?>

;====================================================================
[System]
;====================================================================
;für google contacts update
google_user = "[email protected]"
google_pass = "secret"

;====================================================================
[CalendarPlugin]
;====================================================================
client_id = "blah"
account_name = "Blah"
project_name = "Projekt"
key_file= "cache/KeyFile.p12"

calendar_ID_1 = "de.german#[email protected]"
calendar_ID_color_1 = "#ffff00"

number_of_days = 7
;number_of_lines = 7

public function doUpdate()
	{
		require_once '/usr/share/google-api-php-client-master/autoload.php';
		session_start();
		$client_id = $this->config['client_id'];
		$service_account_name = $this->config['account_name'];
		
		try
		{
			$client = new Google_Client();
			$client->setApplicationName($this->config['project_name']);
			$service = new Google_Service_Calendar($client);
		}
		catch (Exception $e)
		{
			die ('Folgender Fehler trat auf: ' . $e->getMessage());
		}
		
		if (isset($_SESSION['service_token']))
			$client->setAccessToken($_SESSION['service_token']);
		$key = file_get_contents($this->config['key_file']);
		$cred = new Google_Auth_AssertionCredentials($service_account_name, array('https://www.googleapis.com/auth/calendar'), $key);

		$client->setAssertionCredentials($cred);
		if ($client->getAuth()->isAccessTokenExpired())
			$client->getAuth()->refreshTokenWithAssertion($cred);

		$_SESSION['service_token'] = $client->getAccessToken();
		
		//set startDate, endDate, eventParams
		$cal_date = new DateTime('NOW');
		$startDate = date_format($cal_date, DateTime::W3C);
		$cal_date = date_modify($cal_date, "+".$this->config['number_of_days']." day");
		$endDate = date_format($cal_date, DateTime::W3C);
		
		$eventParams = array('timeMin' => $startDate,
							 'timeMax' => $endDate,
							 'singleEvents' => 'true');

		//get Calendar Id´s	
		$listParams = array ('minAccessRole' => 'reader');
		$calendarList = $service->calendarList->listCalendarList($listParams);
		
		// delete all old calendar entries
		mysql_query("START TRANSACTION", $this->dbconn);
		$query = "Delete from if_calendar where `color`<>'#000000'";
		mysql_query($query, $this->dbconn) or die('Error, delete query failed');
		
		// get all calendars
		while(true)
		{
			foreach ($calendarList->getItems() as $calendar)
			{
				$calendarID = $calendar->getID();
				$color = $calendar->getBackgroundColor();
				$events = $service->events->listEvents($calendarID, $eventParams);	    
				while(true)
				{
					foreach ($events->getItems() as $event)
					{
						if (!empty($event['modelData']['start']['dateTime']))
						{
							$begin = strtotime($event['modelData']['start']['dateTime']);
							$end = strtotime($event['modelData']['end']['dateTime']);
						}
						else
						{
							$begin = strtotime($event['modelData']['start']['date']);
							$end = strtotime($event['modelData']['end']['date']);
						}			  	
						$title = $event->getSummary();	
						$location = $event->getLocation();
						$this->addCalendar($color, $begin, $end, $title, $location);
					}
					// next event page if there is one
					$pageToken = $events->getNextPageToken();
					if ($pageToken)
					{
						$optParams = array('pageToken' => $pageToken);
						$events = $service->events->listEvents($calendarID, $optParams);
					}
					else
					{
						break;
					}
				}
			}
			// next calendar page if there is one
			$pageToken = $calendarList->getNextPageToken();
			if ($pageToken)
			{
				$optParams = array('pageToken' => $pageToken);
				$calendarList = $service->calendarList->listCalendarList($optParams);
			}
			else
			{
				break;
			}
		}
		
		// get all public calendars
		$calender_num = 0;
		while ($calendarID = $this->config['calendar_ID_' . ++$calender_num])
		{	
			$color = $this->config['calendar_ID_color_' . $calender_num];
			$events = $service->events->listEvents($calendarID, $eventParams);	    
			while (true)
			{
				foreach ($events->getItems() as $event)
				{
					if (!empty($event['modelData']['start']['dateTime']))
					{
						$begin = strtotime($event['modelData']['start']['dateTime']);
						$end = strtotime($event['modelData']['end']['dateTime']);
					}
					else
					{
						$begin = strtotime($event['modelData']['start']['date']);
						$end = strtotime($event['modelData']['end']['date']);
					}			  	
					$title = $event->getSummary();	
					$location = $event->getLocation();
					$this->addCalendar($color, $begin, $end, $title, $location);
				}
				// next event page if there is one
				$pageToken = $events->getNextPageToken();
				if ($pageToken)
				{
					$optParams = array('pageToken' => $pageToken);
					$events = $service->events->listEvents($calendarID, $optParams);
				}
				else
				{
					break;
				}
			}
		}
		mysql_query("COMMIT", $this->dbconn);
	}

						foreach ($events->getItems() as $event) {
						  	//print_r($event);
					  		if (!empty($event['modelData']['start']['dateTime'])) {
					  			$begin = date_format(date_create($event['modelData']['start']['dateTime']), 'Y-m-d H:i:s');
					  			$end = date_format(date_create($event['modelData']['end']['dateTime']), 'Y-m-d H:i:s');
					  		}else{
					  			$begin = $event['modelData']['start']['date'];
					  			$end = $event['modelData']['end']['date'];
					  		}
					  		$location = $event->getLocation();		// DAS HIER EINFUEGEN	  	
					  		$title = $event->getSummary();
					  		$name = $event['modelData']['organizer']['displayName'];
					  		$color = $event->getColorID();	
					 	       //$insertCalendarData .= "('".$name."','".$color."','".$begin."','".$end."','".$title."',''), "; // SO WAR ES
					 	       $insertCalendarData .= "('".$name."','".$color."','".$begin."','".$end."','".$title."','".$location."'), "; // DAS HIER AENDERN, ABER NICHT 1zu1 UEBERNEMHEN, SONDERN NUR DAS $location WIE HIER GEZEIGT ANSTELLE VON '' EINFUEGEN. SIEHE DAS AUSKOMMENTIERTE DRUEBER UND DAS AKTIVE HIER!!!
					  }

$location = $event->getLocation();

$insertCalendarData .= "('".$color."','".$begin."','".$end."','".$title."',''), ";

$insertCalendarData .= "('".$color."','".$begin."','".$end."','".$title."','".$location."'), ";