From bc4d92f3c4c5f63fbf00a0ed6b52dd21929d9beb Mon Sep 17 00:00:00 2001
From: cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>
Date: Mon, 22 Dec 2008 19:55:00 +0000
Subject: implement ical export, bugfix schichtplan_beamer.php was not shown,
 add doku

git-svn-id: svn://svn.cccv.de/engel-system@323 29ba0400-6e00-0410-a75a-ca02368028f8
---
 www-ssl/nonpublic/myschichtplan_ical.php | 52 ++++++++++++++++++++++++++++++++
 1 file changed, 52 insertions(+)
 create mode 100755 www-ssl/nonpublic/myschichtplan_ical.php

(limited to 'www-ssl/nonpublic/myschichtplan_ical.php')

diff --git a/www-ssl/nonpublic/myschichtplan_ical.php b/www-ssl/nonpublic/myschichtplan_ical.php
new file mode 100755
index 00000000..dfe06f07
--- /dev/null
+++ b/www-ssl/nonpublic/myschichtplan_ical.php
@@ -0,0 +1,52 @@
+<?php
+include ("../../includes/header_start.php");
+
+include ("../../includes/funktion_schichtplan_aray.php");
+
+$SQL = "SELECT *, `ShiftEntry`.`Comment`, `ShiftEntry`.`TID` FROM `Shifts` ".
+       "INNER JOIN `ShiftEntry` ".
+       "ON `Shifts`.`SID`=`ShiftEntry`.`SID` ".
+       "WHERE `ShiftEntry`.`UID`='". $_SESSION['UID']. "' ".
+       "ORDER BY `DateS`";
+$erg = mysql_query($SQL, $con);
+
+
+//HEADER
+header("Content-Type: text/x-vCalendar");
+header("Content-Disposition: attachment; filename=\"Schichtplan.ics\"" );
+
+//DATA
+echo "BEGIN:VCALENDAR\n";
+echo "PRODID:-//Engelsystem//DE-EN\n";
+echo "VERSION:2.0\n";
+echo "PRODID:". md5('icalschichtplan:'.$_SESSION['UID']). "\n"; 
+echo "METHOD:PUBLISH\n";
+echo "CALSCALE:GREGORIAN\n";
+echo "METHOD:PUBLISH\n";
+echo "X-WR-CALNAME;VALUE=TEXT:". "Himmel - Schichtplan\n";
+
+for( $i=0; $i<mysql_num_rows( $erg ); $i++ ) 
+{
+	echo "BEGIN:VEVENT\n";
+	echo "UID:". md5(mysql_result( $erg, $i, "Man" ). mysql_result( $erg, $i, "DateS" ))."\n";
+	echo "METHOD:PUBLISH\n";
+	echo "DTSTART;TZID=Europe/Berlin:". date( 'Ymd\THis', strtotime( mysql_result( $erg, $i, "DateS" ) ) ). "\n";
+	echo "DTEND;TZID=Europe/Berlin:". date( 'Ymd\THis', strtotime( mysql_result( $erg, $i, "DateE" ) ) ). "\n";
+	echo "SUMMARY:". str_replace( ',', '\\,',mysql_result( $erg, $i, "Man" ) ). "\n";
+	echo "CLASS:PUBLIC\n";
+	echo "STATUS:CONFIRMED\n";
+	echo "URL:". $url. substr($ENGEL_ROOT,1). "nonpublic/myschichtplan.php\n";
+	echo "LOCATION:". $RoomID[mysql_result( $erg, $i, "RID" )]. "\n";
+	echo "BEGIN:VALARM\n";
+	echo "TRIGGER;VALUE=DURATION:-PT5M\n";
+	echo "DESCRIPTION:". str_replace( ',', '\\,',mysql_result( $erg, $i, "Man" ) ). "\n";
+	echo "ACTION:DISPLAY\n";
+	echo "END:VALARM\n";
+	echo "END:VEVENT\n";
+}
+echo "END:VCALENDAR\n";
+
+include( "../../includes/funktion_counter.php");
+
+?>
+
-- 
cgit v1.2.3-70-g09d2