Context Navigation

source: trunk/prototype/services/iCal.php @ 6094

Revision 6094, 58.7 KB checked in by cristiano, 12 years ago (diff)
Ticket #2688 - Implementado importação e exportação de alarmes

Line
1	<?php
2
3	require_once ROOTPATH . '/plugins/icalcreator/iCalUtilityFunctions.class.php';
4	require_once ROOTPATH . '/plugins/icalcreator/iCalcreator.class.php';
5	require_once ROOTPATH . '/modules/calendar/constants.php';
6
7	//TODO:Timeout request
8	set_time_limit(600);
9
10	class iCal implements Formatter {
11
12	static $timezonesMap = array('(GMT-12.00) International Date Line West' => 'Etc/GMT+12', '(GMT-11.00) Midway Island / Samoa' => 'Pacific/Midway', '(GMT-10.00) Hawaii' => 'Pacific/Honolulu', '(GMT-09.00) Alaska' => 'America/Anchorage', '(GMT-08.00) Pacific Time (US & Canada) / Tijuana' => 'America/Los_Angeles', '(GMT-08.00) Tijuana / Baja California' => 'America/Tijuana', '(GMT-07.00) Arizona' => 'America/Phoenix', '(GMT-07.00) Chihuahua / La Paz / Mazatlan - Old' => 'America/Chihuahua', '(GMT-07.00) Mountain Time (US & Canada)' => 'America/Denver', '(GMT-06.00) Central America' => 'America/Guatemala', '(GMT-06.00) Central Time (US & Canada)' => 'America/Chicago', '(GMT-06.00) Guadalajara / Mexico City / Monterrey - Old' => 'America/Mexico_City', '(GMT-06.00) Saskatchewan' => 'America/Regina', '(GMT-05.00) Bogota / Lima / Quito' => 'America/Bogota', '(GMT-05.00) Eastern Time (US & Canada)' => 'America/New_York', '(GMT-05.00) Indiana (East)' => 'America/Indiana/Indianapolis', '(GMT-04.30) Caracas' => 'America/Caracas', '(GMT-04.00) Atlantic Time (Canada)' => 'America/Halifax', '(GMT-04.00) Georgetown' => 'America/Guyana', '(GMT-04.00) Caracas / La Paz' => 'America/La_Paz', '(GMT-04.00) Manaus' => 'America/Manaus', '(GMT-04.00) Santiago' => 'America/Santiago', '(GMT-03.30) Newfoundland' => 'America/St_Johns', '(GMT-03.00) Brasilia' => 'America/Sao_Paulo', 'GMT -0300 (Standard) / GMT -0200 (Daylight)' => 'America/Sao_Paulo', '(GMT-03.00) Buenos Aires / Georgetown' => 'America/Argentina/Buenos_Aires', '(GMT-03.00) Greenland' => 'America/Godthab', '(GMT-03.00) Montevideo' => 'America/Montevideo', '(GMT-02.00) Mid-Atlantic' => 'Atlantic/South_Georgia', '(GMT-01.00) Azores' => 'Atlantic/Azores', '(GMT-01.00) Cape Verde Is.' => 'Atlantic/Cape_Verde', '(GMT) Casablanca' => 'Africa/Casablanca', '(GMT) Greenwich Mean Time - Dublin / Edinburgh / Lisbon / London' => 'Europe/London', '(GMT) Casablanca / Monrovia' => 'Africa/Monrovia', '(GMT+01.00) Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna' => 'Europe/Berlin', '(GMT+01.00) Belgrade / Bratislava / Budapest / Ljubljana / Prague' => 'Europe/Belgrade', '(GMT+01.00) Brussels / Copenhagen / Madrid / Paris' => 'Europe/Brussels', '(GMT+01.00) Sarajevo / Skopje / Warsaw / Zagreb' => 'Europe/Warsaw', '(GMT+01.00) West Central Africa' => 'Africa/Algiers', '(GMT+02.00) Windhoek' => 'Africa/Windhoek', '(GMT+02.00) Amman' => 'Asia/Amman', '(GMT+02.00) Bucharest' => 'Europe/Athens', '(GMT+02.00) Beirut' => 'Asia/Beirut', '(GMT+02.00) Cairo' => 'Africa/Cairo', '(GMT+02.00) Harare / Pretoria' => 'Africa/Harare', '(GMT+02.00) Helsinki / Kyiv / Riga / Sofia / Tallinn / Vilnius' => 'Europe/Helsinki', '(GMT+02.00) Jerusalem' => 'Asia/Jerusalem', '(GMT+02.00) Minsk' => 'Europe/Minsk', '(GMT+03.00) Baghdad' => 'Asia/Baghdad', '(GMT+03.00) Kuwait / Riyadh' => 'Asia/Kuwait', '(GMT+03.00) Moscow / St. Petersburg / Volgograd' => 'Europe/Moscow', '(GMT+03.00) Nairobi' => 'Africa/Nairobi', '(GMT+04.00) Caucasus Standard Time' => 'Asia/Tbilisi', '(GMT+03.30) Tehran' => 'Asia/Tehran', '(GMT+04.00) Abu Dhabi / Muscat' => 'Asia/Muscat', '(GMT+04.00) Baku / Tbilisi / Yerevan' => 'Asia/Baku', '(GMT+04.00) Yerevan' => 'Asia/Yerevan', '(GMT+04.30) Kabul' => 'Asia/Kabul', '(GMT+05.00) Ekaterinburg' => 'Asia/Yekaterinburg', '(GMT+05.00) Islamabad / Karachi / Tashkent' => 'Asia/Karachi', '(GMT+05.00) Tashkent' => 'Asia/Tashkent', '(GMT+05.30) Chennai / Kolkata / Mumbai / New Delhi' => 'Asia/Kolkata', '(GMT+06.00) Sri Jayawardenepura' => 'Asia/Colombo', '(GMT+05.45) Kathmandu' => 'Asia/Katmandu', '(GMT+06.00) Almaty / Novosibirsk' => 'Asia/Novosibirsk', '(GMT+06.00) Astana / Dhaka' => 'Asia/Dhaka', '(GMT+06.30) Rangoon' => 'Asia/Rangoon', '(GMT+07.00) Bangkok / Hanoi / Jakarta' => 'Asia/Bangkok', '(GMT+07.00) Krasnoyarsk' => 'Asia/Krasnoyarsk', '(GMT+08.00) Beijing / Chongqing / Hong Kong / Urumqi' => 'Asia/Hong_Kong', '(GMT+08.00) Irkutsk / Ulaan Bataar' => 'Asia/Irkutsk', '(GMT+08.00) Kuala Lumpur / Singapore' => 'Asia/Kuala_Lumpur', '(GMT+08.00) Perth' => 'Australia/Perth', '(GMT+08.00) Taipei' => 'Asia/Taipei', '(GMT+09.00) Osaka / Sapporo / Tokyo' => 'Asia/Tokyo', '(GMT+09.00) Seoul' => 'Asia/Seoul', '(GMT+09.00) Yakutsk' => 'Asia/Yakutsk', '(GMT+09.30) Adelaide' => 'Australia/Adelaide', '(GMT+09.30) Darwin' => 'Australia/Darwin', '(GMT+10.00) Brisbane' => 'Australia/Brisbane', '(GMT+10.00) Canberra / Melbourne / Sydney' => 'Australia/Sydney', '(GMT+10.00) Guam / Port Moresby' => 'Pacific/Guam', '(GMT+10.00) Hobart' => 'Australia/Hobart', '(GMT+10.00) Vladivostok' => 'Asia/Vladivostok', '(GMT+11.00) Magadan / Solomon Is. / New Caledonia' => 'Asia/Magadan', '(GMT+12.00) Auckland / Wellington' => 'Pacific/Auckland', '(GMT+12.00) Fiji / Kamchatka / Marshall Is.' => 'Pacific/Fiji', '(GMT+13.00) Nuku\'alofa' => 'Pacific/Tongatapu', 'E. South America Standard Time' => 'America/Sao_Paulo', 'E. South America' => 'America/Sao_Paulo');
13	// static $timezonesOutlookID = array('Europe/London' => '1' ,'Europe/Brussels' => '3' ,'Europe/Berlin' => '4' ,'America/New_York' => '5' ,'Europe/Belgrade' => '6' ,'Europe/Minsk' => '7' ,'America/Sao_Paulo' => '8' ,'America/Halifax' => '9' ,'America/New_York' => '10' ,'America/Chicago' => '11' ,'America/Denver' => '12' ,'America/Los_Angeles' => '13' ,'America/Anchorage' => '14' ,'Pacific/Honolulu' => '15' ,'Pacific/Midway' => '16' ,'Pacific/Auckland' => '17' ,'Australia/Brisbane' => '18' ,'Australia/Adelaide' => '19' ,'Asia/Tokyo' => '20' ,'Asia/Hong_Kong' => '21' ,'Asia/Bangkok' => '22' ,'Asia/Kolkata' => '23' ,'Asia/Muscat' => '24' ,'Asia/Tehran' => '25' ,'Asia/Baghdad' => '26' ,'Asia/Jerusalem' => '27' ,'America/St_Johns' => '28' ,'Atlantic/Azores' => '29' ,'Atlantic/South_Georgia' => '30' ,'Africa/Casablanca' => '31' ,'America/La_Paz' => '33' ,'America/Indiana/Indianapolis' => '34' ,'America/Bogota' => '35' ,'America/Regina' => '36' ,'America/Mexico_City' => '37' ,'America/Phoenix' => '38' ,'Etc/GMT+12' => '39' ,'Pacific/Fiji' => '40' ,'Asia/Magadan' => '41' ,'Australia/Hobart' => '42' ,'Pacific/Guam' => '43' ,'Australia/Darwin' => '44' ,'Asia/Hong_Kong' => '45' ,'Asia/Novosibirsk' => '46' ,'Asia/Kabul' => '48' ,'Africa/Cairo' => '49' ,'Africa/Harare' => '50' ,'Europe/Moscow' => '51' ,'Australia/Sydney' => '52' ,'Australia/Sydney' => '53' ,'Australia/Adelaide' => '54' ,'Australia/Hobart' => '55' ,'America/Santiago' => '56' ,'Australia/Pert' => '57' ,'America/Tijuana' => '59' ,'Asia/Tbilisi' => '60' ,'Australia/Sydney' => '61' ,'America/Caracas' => '62' ,'Asia/Amman' => '63' ,'Asia/Baku' => '64' ,'Asia/Yerevan' => '65' ,'Europe/Moscow' => '66' ,'America/Argentina/Buenos_Aires' => '67' ,'America/Montevideo' => '72');
14	static $suportedTimzones = array('Africa/Abidjan', 'Africa/Accra', 'Africa/Addis_Ababa', 'Africa/Algiers', 'Africa/Asmara', 'Africa/Asmera', 'Africa/Bamako', 'Africa/Bangui', 'Africa/Banjul', 'Africa/Bissau', 'Africa/Blantyre', 'Africa/Brazzaville', 'Africa/Bujumbura', 'Africa/Cairo', 'Africa/Casablanca', 'Africa/Ceuta', 'Africa/Conakry', 'Africa/Dakar', 'Africa/Dar_es_Salaam', 'Africa/Djibouti', 'Africa/Douala', 'Africa/El_Aaiun', 'Africa/Freetown', 'Africa/Gaborone', 'Africa/Harare', 'Africa/Johannesburg', 'Africa/Kampala', 'Africa/Khartoum', 'Africa/Kigali', 'Africa/Kinshasa', 'Africa/Lagos', 'Africa/Libreville', 'Africa/Lome', 'Africa/Luanda', 'Africa/Lubumbashi', 'Africa/Lusaka', 'Africa/Malabo', 'Africa/Maputo', 'Africa/Maseru', 'Africa/Mbabane', 'Africa/Mogadishu', 'Africa/Monrovia', 'Africa/Nairobi', 'Africa/Ndjamena', 'Africa/Niamey', 'Africa/Nouakchott', 'Africa/Ouagadougou', 'Africa/Porto-Novo', 'Africa/Sao_Tome', 'Africa/Timbuktu', 'Africa/Tripoli', 'Africa/Tunis', 'Africa/Windhoek', 'America/Adak', 'America/Anchorage', 'America/Anguilla', 'America/Antigua', 'America/Araguaina', 'America/Argentina/Buenos_Aires', 'America/Argentina/Catamarca', 'America/Argentina/ComodRivadavia', 'America/Argentina/Cordoba', 'America/Argentina/Jujuy', 'America/Argentina/La_Rioja', 'America/Argentina/Mendoza', 'America/Argentina/Rio_Gallegos', 'America/Argentina/Salta', 'America/Argentina/San_Juan', 'America/Argentina/San_Luis', 'America/Argentina/Tucuman', 'America/Argentina/Ushuaia', 'America/Aruba', 'America/Asuncion', 'America/Atikokan', 'America/Atka', 'America/Bahia', 'America/Barbados', 'America/Belem', 'America/Belize', 'America/Blanc-Sablon', 'America/Boa_Vista', 'America/Bogota', 'America/Boise', 'America/Buenos_Aires', 'America/Cambridge_Bay', 'America/Campo_Grande', 'America/Cancun', 'America/Caracas', 'America/Catamarca', 'America/Cayenne', 'America/Cayman', 'America/Chicago', 'America/Chihuahua', 'America/Coral_Harbour', 'America/Cordoba', 'America/Costa_Rica', 'America/Cuiaba', 'America/Curacao', 'America/Danmarkshavn', 'America/Dawson_Creek', 'America/Dawson', 'America/Denver', 'America/Detroit', 'America/Dominica', 'America/Edmonton', 'America/Eirunepe', 'America/El_Salvador', 'America/Ensenada', 'America/Fort_Wayne', 'America/Fortaleza', 'America/Glace_Bay', 'America/Godthab', 'America/Goose_Bay', 'America/Grand_Turk', 'America/Grenada', 'America/Guadeloupe', 'America/Guatemala', 'America/Guayaquil', 'America/Guyana', 'America/Halifax', 'America/Havana', 'America/Hermosillo', 'America/Indiana/Indianapolis', 'America/Indiana/Knox', 'America/Indiana/Marengo', 'America/Indiana/Petersburg', 'America/Indiana/Tell_City', 'America/Indiana/Vevay', 'America/Indiana/Vincennes', 'America/Indiana/Winamac', 'America/Indianapolis', 'America/Inuvik', 'America/Iqaluit', 'America/Jamaica', 'America/Jujuy', 'America/Juneau', 'America/Kentucky/Louisville', 'America/Kentucky/Monticello', 'America/Knox_IN', 'America/La_Paz', 'America/Lima', 'America/Los_Angeles', 'America/Louisville', 'America/Maceio', 'America/Managua', 'America/Manaus', 'America/Marigot', 'America/Martinique', 'America/Matamoros', 'America/Mazatlan', 'America/Mendoza', 'America/Menominee', 'America/Merida', 'America/Mexico_City', 'America/Miquelon', 'America/Moncton', 'America/Monterrey', 'America/Montevideo', 'America/Montreal', 'America/Montserrat', 'America/Nassau', 'America/New_York', 'America/Nipigon', 'America/Nome', 'America/Noronha', 'America/North_Dakota/Center', 'America/North_Dakota/New_Salem', 'America/Ojinaga', 'America/Panama', 'America/Pangnirtung', 'America/Paramaribo', 'America/Phoenix', 'America/Port_of_Spain', 'America/Port-au-Prince', 'America/Porto_Acre', 'America/Porto_Velho', 'America/Puerto_Rico', 'America/Rainy_River', 'America/Rankin_Inlet', 'America/Recife', 'America/Regina', 'America/Resolute', 'America/Rio_Branco', 'America/Rosario', 'America/Santa_Isabel', 'America/Santarem', 'America/Santiago', 'America/Santo_Domingo', 'America/Sao_Paulo', 'America/Scoresbysund', 'America/Shiprock', 'America/St_Barthelemy', 'America/St_Johns', 'America/St_Kitts', 'America/St_Lucia', 'America/St_Thomas', 'America/St_Vincent', 'America/Swift_Current', 'America/Tegucigalpa', 'America/Thule', 'America/Thunder_Bay', 'America/Tijuana', 'America/Toronto', 'America/Tortola', 'America/Vancouver', 'America/Virgin', 'America/Whitehorse', 'America/Winnipeg', 'America/Yakutat', 'America/Yellowknife', 'Antarctica/Casey', 'Antarctica/Davis', 'Antarctica/DumontDUrville', 'Antarctica/Macquarie', 'Antarctica/Mawson', 'Antarctica/McMurdo', 'Antarctica/Palmer', 'Antarctica/Rothera', 'Antarctica/South_Pole', 'Antarctica/Syowa', 'Antarctica/Vostok', 'Arctic/Longyearbyen', 'Asia/Aden', 'Asia/Almaty', 'Asia/Amman', 'Asia/Anadyr', 'Asia/Aqtau', 'Asia/Aqtobe', 'Asia/Ashgabat', 'Asia/Ashkhabad', 'Asia/Baghdad', 'Asia/Bahrain', 'Asia/Baku', 'Asia/Bangkok', 'Asia/Beirut', 'Asia/Bishkek', 'Asia/Brunei', 'Asia/Calcutta', 'Asia/Choibalsan', 'Asia/Chongqing', 'Asia/Chungking', 'Asia/Colombo', 'Asia/Dacca', 'Asia/Damascus', 'Asia/Dhaka', 'Asia/Dili', 'Asia/Dubai', 'Asia/Dushanbe', 'Asia/Gaza', 'Asia/Harbin', 'Asia/Ho_Chi_Minh', 'Asia/Hong_Kong', 'Asia/Hovd', 'Asia/Irkutsk', 'Asia/Istanbul', 'Asia/Jakarta', 'Asia/Jayapura', 'Asia/Jerusalem', 'Asia/Kabul', 'Asia/Kamchatka', 'Asia/Karachi', 'Asia/Kashgar', 'Asia/Kathmandu', 'Asia/Katmandu', 'Asia/Kolkata', 'Asia/Krasnoyarsk', 'Asia/Kuala_Lumpur', 'Asia/Kuching', 'Asia/Kuwait', 'Asia/Macao', 'Asia/Macau', 'Asia/Magadan', 'Asia/Makassar', 'Asia/Manila', 'Asia/Muscat', 'Asia/Nicosia', 'Asia/Novokuznetsk', 'Asia/Novosibirsk', 'Asia/Omsk', 'Asia/Oral', 'Asia/Phnom_Penh', 'Asia/Pontianak', 'Asia/Pyongyang', 'Asia/Qatar', 'Asia/Qyzylorda', 'Asia/Rangoon', 'Asia/Riyadh', 'Asia/Saigon', 'Asia/Sakhalin', 'Asia/Samarkand', 'Asia/Seoul', 'Asia/Shanghai', 'Asia/Singapore', 'Asia/Taipei', 'Asia/Tashkent', 'Asia/Tbilisi', 'Asia/Tehran', 'Asia/Tel_Aviv', 'Asia/Thimbu', 'Asia/Thimphu', 'Asia/Tokyo', 'Asia/Ujung_Pandang', 'Asia/Ulaanbaatar', 'Asia/Ulan_Bator', 'Asia/Urumqi', 'Asia/Vientiane', 'Asia/Vladivostok', 'Asia/Yakutsk', 'Asia/Yekaterinburg', 'Asia/Yerevan', 'Atlantic/Azores', 'Atlantic/Bermuda', 'Atlantic/Canary', 'Atlantic/Cape_Verde', 'Atlantic/Faeroe', 'Atlantic/Faroe', 'Atlantic/Jan_Mayen', 'Atlantic/Madeira', 'Atlantic/Reykjavik', 'Atlantic/South_Georgia', 'Atlantic/St_Helena', 'Atlantic/Stanley', 'Australia/ACT', 'Australia/Adelaide', 'Australia/Brisbane', 'Australia/Broken_Hill', 'Australia/Canberra', 'Australia/Currie', 'Australia/Darwin', 'Australia/Eucla', 'Australia/Hobart', 'Australia/LHI', 'Australia/Lindeman', 'Australia/Lord_Howe', 'Australia/Melbourne', 'Australia/NSW', 'Australia/North', 'Australia/Perth', 'Australia/Queensland', 'Australia/South', 'Australia/Sydney', 'Australia/Tasmania', 'Australia/Victoria', 'Australia/West', 'Australia/Yancowinna', 'Europe/Amsterdam', 'Europe/Andorra', 'Europe/Athens', 'Europe/Belfast', 'Europe/Belgrade', 'Europe/Berlin', 'Europe/Bratislava', 'Europe/Brussels', 'Europe/Bucharest', 'Europe/Budapest', 'Europe/Chisinau', 'Europe/Copenhagen', 'Europe/Dublin', 'Europe/Gibraltar', 'Europe/Guernsey', 'Europe/Helsinki', 'Europe/Isle_of_Man', 'Europe/Istanbul', 'Europe/Jersey', 'Europe/Kaliningrad', 'Europe/Kiev', 'Europe/Lisbon', 'Europe/Ljubljana', 'Europe/London', 'Europe/Luxembourg', 'Europe/Madrid', 'Europe/Malta', 'Europe/Mariehamn', 'Europe/Minsk', 'Europe/Monaco', 'Europe/Moscow', 'Europe/Nicosia', 'Europe/Oslo', 'Europe/Paris', 'Europe/Podgorica', 'Europe/Prague', 'Europe/Riga', 'Europe/Rome', 'Europe/Samara', 'Europe/San_Marino', 'Europe/Sarajevo', 'Europe/Simferopol', 'Europe/Skopje', 'Europe/Sofia', 'Europe/Stockholm', 'Europe/Tallinn', 'Europe/Tirane', 'Europe/Tiraspol', 'Europe/Uzhgorod', 'Europe/Vaduz', 'Europe/Vatican', 'Europe/Vienna', 'Europe/Vilnius', 'Europe/Volgograd', 'Europe/Warsaw', 'Europe/Zagreb', 'Europe/Zaporozhye', 'Europe/Zurich', 'Indian/Antananarivo', 'Indian/Chagos', 'Indian/Christmas', 'Indian/Cocos', 'Indian/Comoro', 'Indian/Kerguelen', 'Indian/Mahe', 'Indian/Maldives', 'Indian/Mauritius', 'Indian/Mayotte', 'Indian/Reunion', 'Pacific/Apia', 'Pacific/Auckland', 'Pacific/Chatham', 'Pacific/Easter', 'Pacific/Efate', 'Pacific/Enderbury', 'Pacific/Fakaofo', 'Pacific/Fiji', 'Pacific/Funafuti', 'Pacific/Galapagos', 'Pacific/Gambier', 'Pacific/Guadalcanal', 'Pacific/Guam', 'Pacific/Honolulu', 'Pacific/Johnston', 'Pacific/Kiritimati', 'Pacific/Kosrae', 'Pacific/Kwajalein', 'Pacific/Majuro', 'Pacific/Marquesas', 'Pacific/Midway', 'Pacific/Nauru', 'Pacific/Niue', 'Pacific/Norfolk', 'Pacific/Noumea', 'Pacific/Pago_Pago', 'Pacific/Palau', 'Pacific/Pitcairn', 'Pacific/Ponape', 'Pacific/Port_Moresby', 'Pacific/Rarotonga', 'Pacific/Saipan', 'Pacific/Samoa', 'Pacific/Tahiti', 'Pacific/Tarawa', 'Pacific/Tongatapu', 'Pacific/Truk', 'Pacific/Wake', 'Pacific/Wallis', 'Pacific/Yap', 'UTC');
15
16	public function format($data, $params = false) {
17	$timezones = array_flip(self::$timezonesMap);
18
19	$ical = new icalCreator();
20
21	$ical->setProperty('method', isset($params['method']) ? $params['method'] : 'PUBLISH' );
22	$sytemTimezone = (date_default_timezone_get()) ? date_default_timezone_get() : 'America/Sao_Paulo';
23	$params['defaultTZI'] = self::nomalizeTZID((isset($params['defaultTZI']) && $params['defaultTZI'] != 'null') ? $params['defaultTZI'] : $sytemTimezone );
24
25	/*
26	* Seta propiedades obrigatorias para alguns softwares (Outlook)
27	*/
28	$ical->setProperty('x-wr-calname', 'Calendar Expresso');
29	$ical->setProperty('X-WR-CALDESC', 'Calendar Expresso');
30	$ical->setProperty('X-WR-TIMEZONE', isset($timezones[$params['defaultTZI']]) ? $timezones[$params['defaultTZI']] : $params['defaultTZI']);
31
32	foreach ($data as $i => $v) {
33
34	switch ($v['type']) {
35	case EVENT_ID:
36
37	$vevent = $ical->newComponent('vevent');
38
39	$vevent->setProperty('summary', $v['summary']);
40	$vevent->setProperty('description', isset($v['description']) ? $v['description'] : '');
41	$vevent->setProperty('location', $v['location']);
42	$vevent->setProperty('tranp', (isset($v['tranparent']) && $v['tranparent'] == TRANSP_TRANSPARENT ) ? 'TRANSPARENT' : 'OPAQUE' );
43
44	$timezone = new DateTimeZone('UTC');
45	$apTimezone = self::nomalizeTZID(( isset($v['timezone']) && $v['timezone'] != 'null' ) ? $v['timezone'] : $params['defaultTZI']);
46	$apTimezoneOBJ = new DateTimeZone($apTimezone);
47
48	$sTime = new DateTime('@' . (int) ($v['startTime'] / 1000), $timezone);
49	$sTime->setTimezone($apTimezoneOBJ);
50	$eTime = new DateTime('@' . (int) ($v['endTime'] / 1000), $timezone);
51	$eTime->setTimezone($apTimezoneOBJ);
52
53	if (( isset($v['repeat']) ) && ( $v['repeat']['frequency'] != 'none' )) {
54	$repeat = array();
55
56	foreach ($v['repeat'] as $ir => $rv) {
57	if ($rv) {
58	if ($ir == 'frequency' && $rv !== 'none')
59	$repeat['FREQ'] = $rv;
60	else if ($ir == 'endTime') {
61	$time = new DateTime('@' . (int) ($rv / 1000), $timezone);
62	$time->setTimezone($apTimezoneOBJ);
63	$repeat['until'] = $time->format(DATE_RFC822);
64	} else if ($ir == 'count')
65	$repeat[$ir] = $rv;
66	else if ($ir !== 'schedulable' && $ir !== 'id' && $ir !== 'startTime')
67	$repeat[$ir] = explode(',', $rv);
68	}
69	}
70
71	if (isset($repeat['FREQ']))
72	$vevent->setProperty('rrule', $repeat);
73	}
74
75	if (isset($v['allDay']) && $v['allDay'] == 1) {
76	$vevent->setProperty('dtstart', $sTime->format(DATE_RFC822), array("VALUE" => "DATE"));
77	$vevent->setProperty('dtend', $eTime->format(DATE_RFC822), array("VALUE" => "DATE"));
78	$vevent->setProperty('X-MICROSOFT-CDO-ALLDAYEVENT', 'TRUE');
79	} else {
80	$vevent->setProperty('dtstart', $sTime->format(DATE_RFC822), array('TZID' => $apTimezone));
81	$vevent->setProperty('dtend', $eTime->format(DATE_RFC822), array('TZID' => $apTimezone));
82	$vevent->setProperty('X-MICROSOFT-CDO-ALLDAYEVENT', 'FALSE');
83	}
84
85	if (isset($v['participants']) && is_array($v['participants']) && count($v['participants']) > 0)
86	$participants = $v['participants'];
87	else
88	$participants = Controller::find(array('concept' => 'participant'), false, array('filter' => array('=', 'schedulable', $v['id'])));
89
90	if (is_array($participants) && count($participants) > 0)
91	foreach ($participants as $ii => $vv) {
92
93	if(isset($participants[$ii]['user']) && !is_array($participants[$ii]['user']))
94	{
95	if ($vv['isExternal'] == 1)
96	$participants[$ii]['user'] = Controller::read(array('concept' => 'user', 'id' => $vv['user'], 'service' => 'PostgreSQL'));
97	else
98	$participants[$ii]['user'] = Controller::read(array('concept' => 'user', 'id' => $vv['user']));
99	}
100
101	if ($participants[$ii]['user']['id'] == Config::me('uidNumber'))
102	{
103	$alarms = (isset($participants[$ii]['alarms'])) ? $participants[$ii]['alarms'] : Controller::find(array('concept' => 'alarm'), null, array('filter' => array('AND', array('=', 'participant', $vv['id']), array('=', 'schedulable', $v['id']))));
104	self::createAlarms($alarms, $vevent);
105	}
106
107	}
108
109
110	if (isset($v['participants']) && is_array($v['participants']) && count($v['participants']) > 0)
111	$this->createAttendee($v['participants'], $vevent);
112
113	if (isset($v['attachments']) && is_array($v['attachments']) && count($v['attachments']) > 0)
114	$this->createAttachment($v['attachments'], $vevent);
115
116	$vevent->setProperty('uid', $v['uid']);
117
118	break;
119
120	default:
121	break;
122	}
123	}
124
125	return $ical->createCalendar();
126	}
127
128	public function createAlarms($alarms, &$vevent)
129	{
130	foreach ($alarms as $ia => $va)
131	{
132	$valarm = new valarm();
133	$valarm->setProperty('ACTION' , self::codeAlarmAction($va['type']));
134
135	$duration = array();
136
137	switch ($va['unit'])
138	{
139	case 'h':
140	$duration['hour'] = $va['time'];
141	break;
142	case 'm':
143	$duration['min'] = $va['time'];
144	break;
145	case 's':
146	$duration['sec'] = $va['time'];
147	break;
148	}
149
150	$valarm->setProperty('trigger' ,$duration);
151	$vevent->setComponent($valarm);
152	}
153
154	}
155
156	//Trata a criacao de anexos do ics
157	public function createAttachment($attachments, &$vevent) {
158	foreach ($attachments as $key => $attachment) {
159	$pParams = array("ENCODING" => "BASE64", "VALUE" => "BINARY",
160	"X-FILENAME" => $attachment['name']);
161
162	$vevent->setProperty("attach", $attachment['source'], $pParams);
163	}
164	}
165
166	//Trata a criacao de attendees com tratamento de delegate
167	public function createAttendee($attendees, &$vevent) {
168	$delegate = array();
169	foreach ($attendees as $di => $dv) {
170	if (isset($dv['delegatedFrom']) && $dv['delegatedFrom'] != 0) {
171	$delegate[$dv['delegatedFrom']] = $dv;
172	}
173	}
174
175	foreach ($attendees as $pi => $pv) {
176	$isResponseDelegated = false;
177	if (isset($pv['delegatedFrom']) && $pv['delegatedFrom'] == 0) {
178	if ($pv['isOrganizer'] == 1)
179	$vevent->setProperty('organizer', $pv['user']['mail'], array('CN' => $pv['user']['name']));
180	else {
181	$pParams = array();
182	$pParams['CN'] = $pv['user']['name'];
183	$pParams['PARTSTAT'] = self::_getStatus($pv['status']);
184
185	if (isset($pv['id']) && isset($delegate[$pv['id']])) {
186	$pParams['PARTSTAT'] = self::_getStatus($delegate[$pv['id']]['status']);
187	$pParams['DELEGATED-TO'] = $delegate[$pv['id']]['user']['mail'];
188	$pParams['CN'] = $pv['user']['name'];
189
190	$vevent->setProperty('attendee', $pv['user']['mail'], $pParams);
191
192	if ($delegate[$pv['id']]['status'] == STATUS_UNANSWERED) {
193	$pParams['RSVP'] = $pv['receiveNotification'] == 1 ? 'TRUE' : 'FALSE';
194	unset($pParams['PARTSTAT']);
195	}else
196	$pParams['PARTSTAT'] = self::_getStatus($delegate[$pv['id']]['status']);
197
198	unset($pParams['DELEGATED-TO']);
199	$pParams['DELEGATED-FROM'] = $pv['user']['mail'];
200
201	$vevent->setProperty('attendee', $delegate[$pv['id']]['user']['mail'], $pParams);
202	continue;
203	}
204	$pParams['RSVP'] = 'TRUE';
205
206	$vevent->setProperty('attendee', $pv['user']['mail'], $pParams);
207
208	}
209	}
210
211
212	}
213	}
214
215	public function parse($data, $params = false) {
216	Config::regSet('noAlarm', TRUE); //Evita o envio de notificação
217	$vcalendar = new icalCreator( );
218	$vcalendar->parse(trim($data));
219	$vcalendar->sort();
220
221	$return = array();
222	$method = $vcalendar->getProperty('method', FALSE, FALSE);
223	$params['prodid'] = $vcalendar->getProperty('prodid', false, false);
224
225	while ($component = $vcalendar->getComponent()) {
226	$interation = array();
227	$uid = $component->getProperty('uid', false, false); //Resgata o uid do componente
228
229	switch (strtoupper($component->objName)) {
230	case 'VEVENT':
231
232	switch ($method) {
233	case 'PUBLISH':
234	if (!$schedulable = self::_getSchedulable($uid))
235	$interation = self::_makeVEVENT($schedulable, $component, $params);
236	break;
237
238	case 'REQUEST':
239	$schedulable = self::_getSchedulable($uid);
240
241	if ($schedulable) { //Caso o evento exista
242	if (!self::_existInMyCalendars($schedulable['id'])) {
243	$calendarToSchedulable = array();
244	$calendarToSchedulable['calendar'] = $params['calendar'];
245	$calendarToSchedulable['schedulable'] = $schedulable['id'];
246	$interation['calendarToSchedulable://' . mt_rand() . '(Formatter)'] = $calendarToSchedulable;
247
248	if (isset($params['status'])) {
249	$pID = self::_getParticipantByMail(Config::me('mail'), $schedulable['participants']);
250	$interation['participant://' . $pID]['status'] = $params['status'];
251	}
252
253	Config::regSet('noAlarm', FALSE); //reativa notificação
254	} else {
255
256	if (self::_getTime($component, 'dtstamp') > $schedulable['dtstamp'] \|\| $component->getProperty('sequence', false, false) > $schedulable['sequence']) //Organizador esta requisitando que você atualize o evento
257	$interation = self::_makeVEVENT($schedulable, $component, $params);
258	else if ($component->getProperty('sequence', false, false) === $schedulable['sequence']) {
259	//Ler melhor rfc sobre isto 3.2.2.2
260	//Aparentemente é para retornar um ical com o evento atualizado para o attende
261	}
262
263	if (isset($params['status'])) {
264	$pID = self::_getParticipantByMail(Config::me('mail'), $schedulable['participants']);
265	//Verifica a importação de eventos em que não participo
266	if ($pID) {
267	$interation['participant://' . $pID]['status'] = $params['status'];
268	}
269	}
270	}
271	} else { // Importar evento
272	$interation = self::_makeVEVENT(array(), $component, $params);
273
274	if (strpos($params['prodid'], 'kigkonsult.se') !== false) { //envia notificação para fora
275
276	/* Data de Inicio */
277	$startTime = $component->getProperty('dtstart', false, true);
278
279	/* Tiem zone do evento */
280	if (isset($startTime['params']['TZID']))
281	$sc['timezone'] = self::nomalizeTZID($startTime['params']['TZID']);
282	else
283	$sc['timezone'] = isset($params['calendar_timezone']) ? $params['calendar_timezone'] : 'America/Sao_Paulo';
284
285	$objTimezone = new DateTimeZone($sc['timezone']);
286
287	if (isset($startTime['params']['VALUE']) && $startTime['params']['VALUE'] === 'DATE' && isset($params['calendar_timezone'])) {
288	$sc['allDay'] = 1;
289	$sc['startTime'] = self::date2timestamp($startTime['value']) - self::_getTzOffset('UTC', $sc['timezone']) . '000';
290	} elseif (isset($startTime['params']['TZID']) && !isset($startTime['value']['tz']))/* Caso não tenha um tz na data mais exista um parametro TZID deve ser aplicado o timezone do TZID a data */
291	$sc['startTime'] = self::date2timestamp($startTime['value']) - self::_getTzOffset('UTC', $startTime['params']['TZID']) . '000';
292	else {
293	$sc['startTime'] = self::date2timestamp($startTime['value']) . '000';
294	if (strpos($params['prodid'], 'Outlook') !== false) {
295	//Se o ics veio em utc não aplicar horario de verão
296	$sTime = new DateTime('@' . (int) ($sc['startTime'] / 1000), new DateTimeZone('UTC'));
297	$sTime->setTimezone($objTimezone);
298	if ($sTime->format('I')) //Se o ics veio em utc não aplicar horario de verão
299	$sc['startTime'] = $sc['startTime'] - 3600000;
300	}
301	}
302
303
304	/* Data de Termino */
305	$endTime = $component->getProperty('dtend', false, true);
306
307	if (isset($endTime['params']['VALUE']) && $endTime['params']['VALUE'] === 'DATE')
308	$sc['endTime'] = self::date2timestamp($endTime['value']) - self::_getTzOffset('UTC', $sc['timezone']) . '000';
309	else if (isset($endTime['params']['TZID']) && !isset($endTime['value']['tz'])) /* Caso não tenha um tz na data mais exista um parametro TZID deve ser aplicado o timezone do TZID a data */
310	$sc['endTime'] = self::date2timestamp($endTime['value']) - self::_getTzOffset('UTC', $endTime['params']['TZID']) . '000';
311	else {
312	$sc['endTime'] = self::date2timestamp($endTime['value']) . '000';
313	if (strpos($params['prodid'], 'Outlook') !== false) {
314	//Se o ics veio em utc não aplicar horario de verão
315	$eTime = new DateTime('@' . (int) ($sc['endTime'] / 1000), new DateTimeZone('UTC'));
316	$eTime->setTimezone($objTimezone);
317	if ($eTime->format('I'))
318	$sc['endTime'] = $sc['endTime'] - 3600000;
319	}
320	}
321
322
323	if ($uid = $component->getProperty('uid', false, false))
324	;
325	$sc['uid'] = $uid;
326
327
328	$sc['summary'] = mb_convert_encoding($component->getProperty('summary', false, false), 'UTF-8', 'UTF-8,ISO-8859-1');
329
330	/* Definindo Description */
331	if ($desc = $component->getProperty('description', false, false))
332	$sc['description'] = mb_convert_encoding(str_ireplace(array('\n', '\t'), array("\n", "\t"), $desc), 'UTF-8', 'UTF-8,ISO-8859-1');
333
334	/* Definindo location */
335	if ($location = $component->getProperty('location', false, false))
336	$sc['location'] = mb_convert_encoding($location, 'UTF-8', 'UTF-8,ISO-8859-1');
337
338
339
340	if ($property = $component->getProperty('organizer', FALSE, TRUE)) {
341	$participant = array();
342	$mailUser = trim(str_replace('MAILTO:', '', $property['value']));
343
344	$participantID = mt_rand() . '2(Formatter)';
345
346	$participant['isOrganizer'] = '1';
347
348	$user = null;
349
350	$participant['isExternal'] = 1;
351	/* Gera um randon id para o contexto formater */
352	$userID = mt_rand() . '4(Formatter)';
353
354	$user['mail'] = $mailUser;
355	$organizerMail = $mailUser;
356
357	$user['name'] = ( isset($property['params']['CN']) ) ? $property['params']['CN'] : '';
358	$user['isExternal'] = '1';
359	$participant['user'] = $user;
360
361	$sc['participants'][] = $participant;
362	}
363
364
365	$participant['status'] = isset($params['status']) ? $params['status'] : STATUS_ACCEPTED;
366	$participant['isOrganizer'] = '0';
367	$participant['isExternal'] = 0;
368	$participant['user'] = array('mail' => Config::me('mail'), 'name' => Config::me('cn'));
369	$sc['participants'][] = $participant;
370	$sc['type'] = EVENT_ID;
371
372
373	$ical['source'] = Controller::format(array('service' => 'iCal'), array($sc), array('method' => 'REPLY'));
374	$ical['type'] = 'application/ics';
375	$ical['name'] = 'outlook.ics';
376
377	$ical2['source'] = $ical['source'];
378	$ical2['type'] = 'text/calendar; method=REPLY';
379	$ical2['name'] = 'thunderbird.ics';
380
381	$timezone = new DateTimeZone('UTC');
382	$sTime = new DateTime('@' . (int) ($sc['startTime'] / 1000), $timezone);
383	$eTime = new DateTime('@' . (int) ($sc['endTime'] / 1000), $timezone);
384
385	if (isset($sc['timezone'])) {
386	$sTime->setTimezone(new DateTimeZone($sc['timezone']));
387	$eTime->setTimezone(new DateTimeZone($sc['timezone']));
388	}
389
390	$data = array('startDate' => date_format($sTime, 'd/m/Y'),
391	'startTime' => (isset($sc['allDay']) && $sc['allDay'] ) ? '' : date_format($sTime, 'H:i'),
392	'endDate' => date_format($eTime, 'd/m/Y'),
393	'endTime' => isset($sc['allDay']) ? '' : date_format($eTime, 'H:i'),
394	'eventTitle' => $sc['summary'],
395	'eventLocation' => isset($sc['location']) ? $sc['location'] : '',
396	'timezone' => ($sc['timezone']) ? $sc['timezone'] : 'UTC',
397	'participant' => (isset($part['user']['name']) ? $part['user']['name'] : $part['user']['mail']));
398
399	$subject['notificationType'] = 'Convite Aceito';
400	$subject['eventTitle'] = mb_convert_encoding($sc['summary'], 'ISO-8859-1', 'ISO-8859-1,UTF-8');
401	$subject['startDate'] = date_format($sTime, 'd/m/Y');
402	$subject['startTime'] = ($sc['allDay']) ? '' : date_format($sTime, 'H:i');
403	$subject['endDate'] = date_format($eTime, 'd/m/Y');
404	$subject['endTime'] = ($sc['allDay']) ? '' : date_format($eTime, 'H:i');
405	$subject['participant'] = Config::me('uid');
406
407	$params['status'] = isset($params['status']) ? $params['status'] : STATUS_ACCEPTED;
408
409	switch ($params['status']) {
410	case STATUS_ACCEPTED:
411	$tpl = 'notify_accept_body';
412	$subject['notificationType'] = 'Convite Aceito';
413	break;
414	case STATUS_TENTATIVE:
415	$tpl = 'notify_attempt_body';
416	$subject['notificationType'] = 'Convite aceito provisoriamente';
417	break;
418	case STATUS_CANCELLED:
419	$tpl = 'notify_reject_body';
420	$subject['notificationType'] = 'Convite rejeitado';
421	break;
422	}
423	require_once ROOTPATH . '/api/parseTPL.php';
424
425	$mail = array();
426	$mail['attachments'][] = $ical;
427	$mail['attachments'][] = $ical2;
428
429	$mail['isHtml'] = true;
430	$mail['body'] = parseTPL::load_tpl($data, ROOTPATH . '/modules/calendar/templates/' . $tpl . '.tpl');
431	$mail['subject'] = parseTPL::load_tpl($subject, ROOTPATH . '/modules/calendar/templates/notify_subject.tpl');
432	;
433	$mail['from'] = '"' . Config::me('cn') . '" <' . Config::me('mail') . '>';
434	$mail['to'] = $organizerMail;
435
436
437	Controller::create(array('service' => 'SMTP'), $mail);
438	}
439	}
440	break;
441
442	case 'REFRESH':
443	break;
444
445	case 'CANCEL':
446	if ($schedulable = self::_getSchedulable($uid))
447	$interation['schedulable://' . $schedulable['id']] = false;
448	break;
449
450	case 'ADD':
451	break;
452
453	case 'REPLY':
454	if ($schedulable = self::_getSchedulable($uid)) {
455	while ($property = $component->getProperty('attendee', FALSE, TRUE))
456	if ($pID = self::_getParticipantByMail(str_replace('MAILTO:', '', $property['value']), $schedulable['participants']))
457	$interation['participant://' . $pID] = array('id' => $pID, 'status' => constant('STATUS_' . strtoupper($property['params']['PARTSTAT'])));
458
459	$interation['schedulable://' . $schedulable['id']]['sequence'] = $schedulable['sequence'] + 1;
460	}
461	break;
462
463	case 'COUNTER':
464	if ($params['acceptedSuggestion'] !== 'false') {
465
466	$schedulable = self::_getSchedulable($uid);
467	$params['calendar'] = self::_existInMyCalendars($schedulable['id']);
468
469	$interation = self::_makeCOUNTER($schedulable, $component, $params);
470	Config::regSet('noAlarm', FALSE);
471	} else {
472	$response = array();
473	$response['from'] = $params['from'];
474	$response['type'] = 'suggestionResponse';
475	$response['status'] = 'DECLINECOUNTER';
476	$response['schedulable'] = self::_getSchedulable($uid);
477
478	Controller::create(array('concept' => 'notification'), $response);
479	}
480	break;
481
482	case 'DECLINECOUNTER':
483	break;
484
485	default:
486
487	$schedulable = self::_getSchedulable($uid);
488
489	if ($schedulable && ( self::_getTime($component, 'dtstamp') > $schedulable['dtstamp'] \|\| $component->getProperty('sequence', false, false) > $schedulable['sequence'])) { //Caso o evento exista
490	$interation = self::_makeVEVENT($schedulable, $component, $params);
491
492	if (!self::_existInMyCalendars($schedulable['id'])) {
493	$calendarToSchedulable = array();
494	$calendarToSchedulable['calendar'] = $params['calendar'];
495	$calendarToSchedulable['schedulable'] = $schedulable['id'];
496	$interation['calendarToSchedulable://' . mt_rand() . '(Formatter)'] = $calendarToSchedulable;
497	}
498	}
499	else // Importar evento
500	$interation = self::_makeVEVENT(array(), $component, $params);
501
502
503
504	break;
505	}
506
507
508	$return[] = $interation;
509	break;
510	case 'VTIMEZONE':
511
512
513	break;
514	}
515	}
516
517	return $return;
518	}
519
520	public function analize($data, $params = false) {
521	$vcalendar = new icalCreator( );
522	$vcalendar->parse(trim($data));
523	$vcalendar->sort();
524
525	$return = array();
526	$method = $vcalendar->getProperty('method', FALSE, FALSE);
527
528	while ($component = $vcalendar->getComponent()) {
529	$interation = array();
530	$uid = $component->getProperty('uid', false, false); //Resgata o uid do componente
531
532	switch (strtoupper($component->objName)) {
533	case 'VEVENT':
534
535	switch ($method) {
536	case 'PUBLISH':
537	$interation = ICAL_ACTION_IMPORT;
538	break;
539
540	case 'REQUEST':
541	$schedulable = self::_getSchedulable($uid);
542	if ($schedulable) { //Caso o evento exista
543	$isOrganizer = false;
544	$isParticipant = false;
545
546	foreach ($schedulable['participants'] as $value)
547	if ($value['user']['id'] == Config::me('uidNumber')) {
548	$isParticipant = true;
549	if ($value['isOrganizer'])
550	$isOrganizer = true;
551
552	if (!self::_existInMyCalendars($schedulable['id'])) {
553	$interation = ICAL_ACTION_UPDATE;
554	$interation = ( strrpos($value['acl'], ATTENDEE_ACL_PARTICIPATION_REQUIRED) ) ? ICAL_ACTION_IMPORT_REQUIRED : ICAL_ACTION_IMPORT;
555	break;
556	}
557	} else {
558	if (self::_getTime($component, 'dtstamp') > $schedulable['dtstamp'] \|\| $component->getProperty('sequence', false, false) > $schedulable['sequence']) //Organizador esta requisitando que você atualize o evento
559	$interation = ($isOrganizer) ? ICAL_ACTION_ORGANIZER_UPDATE : ICAL_ACTION_UPDATE;
560	else
561	$interation = ($isOrganizer) ? ICAL_ACTION_ORGANIZER_NONE : ICAL_ACTION_NONE;
562	}
563	if (!$isParticipant)
564	$interation = ICAL_ACTION_ORGANIZER_NONE;
565	}else
566	$interation = ICAL_ACTION_IMPORT;
567
568	break;
569
570	case 'REFRESH':
571	break;
572
573	case 'CANCEL':
574	$interation = ICAL_ACTION_DELETE;
575	break;
576
577	case 'ADD':
578	break;
579
580	case 'REPLY':
581	$interation = ICAL_ACTION_REPLY;
582	break;
583
584	case 'COUNTER':
585	$interation = ICAL_ACTION_SUGGESTION;
586	break;
587
588	case 'DECLINECOUNTER':
589	$interation = ICAL_ACTION_NONE;
590	break;
591
592	default:
593	$schedulable = self::_getSchedulable($uid);
594
595	if ($schedulable && ( self::_getTime($component, 'dtstamp') > $schedulable['dtstamp'] \|\| $component->getProperty('sequence', false, false) > $schedulable['sequence'])) //Caso o evento exista
596	$interation = ICAL_ACTION_UPDATE;
597	else if ($schedulable)
598	$interation = ICAL_ACTION_NONE;
599	else // Importar evento
600	$interation = ICAL_ACTION_IMPORT;
601
602	break;
603	}
604
605	$return[$uid] = $interation;
606	break;
607	case 'VTIMEZONE':
608
609
610	break;
611	}
612	}
613
614	return $return;
615	}
616
617	/* Helpers */
618
619	private static function _getTzOffset($rTz, $oTz = null, $time = 'now') {
620	if ($oTz === null) {
621	if (!is_string($oTz = date_default_timezone_get())) {
622	return false; // A UTC timestamp was returned -- bail out!
623	}
624	}
625	$origin_dtz = new DateTimeZone(self::nomalizeTZID($oTz));
626	$remote_dtz = new DateTimeZone(self::nomalizeTZID($rTz));
627	$origin_dt = new DateTime($time, $origin_dtz);
628	$remote_dt = new DateTime("now", $remote_dtz);
629
630	$offset = $origin_dtz->getOffset($origin_dt) - $remote_dtz->getOffset($remote_dt);
631
632
633	return $offset;
634	}
635
636	private function _getStatus($id) {
637	$a = array(
638	STATUS_CONFIRMED => 'ACCEPTED',
639	STATUS_CANCELLED => 'CANCELLED',
640	STATUS_TENTATIVE => 'TENTATIVE',
641	STATUS_UNANSWERED => 'NEEDS-ACTION',
642	STATUS_DELEGATED => 'DELEGATED'
643	);
644
645	return isset($a[$id]) ? $a[$id] : 'NEEDS-ACTION';
646	}
647
648	private static function _getParticipantByMail($mail, &$participants) {
649	if ($participants && $participants != '')
650	foreach ($participants as $i => $v)
651	if ((is_array($v) && isset($v['user'])) && ($v['user']['mail'] == $mail \|\| (isset($v['user']['mailAlternateAddress']) && in_array($mail, $v['user']['mailAlternateAddress']))))
652	return $v['id'];
653	return false;
654	}
655
656	static private function nomalizeTZID($TZID) {
657	if (isset(self::$timezonesMap[$TZID]))
658	return self::$timezonesMap[$TZID];
659	else if (in_array($TZID, self::$suportedTimzones))
660	return $TZID;
661	else
662	return date_default_timezone_get();
663	}
664
665	static private function date2timestamp($datetime, $tz = null) {
666	if (!isset($datetime['hour']))
667	$datetime['hour'] = '0';
668	if (!isset($datetime['min']))
669	$datetime['min'] = '0';
670	if (!isset($datetime['sec']))
671	$datetime['sec'] = '0';
672
673	foreach ($datetime as $dkey => $dvalue)
674	if ('tz' != $dkey)
675	$datetime[$dkey] = (integer) $dvalue;
676
677	if ($tz)
678	$datetime['tz'] = $tz;
679
680	$offset = ( isset($datetime['tz']) && ( '' < trim($datetime['tz']))) ? iCalUtilityFunctions::_tz2offset($datetime['tz']) : 0;
681
682	return gmmktime($datetime['hour'], $datetime['min'], ($datetime['sec'] + $offset), $datetime['month'], $datetime['day'], $datetime['year']);
683	}
684
685	static private function _makeCOUNTER($schedulable, $component, $params) {
686	$interation = array();
687	$eventID = isset($schedulable['id']) ? $schedulable['id'] : mt_rand() . '(Formatter)';
688
689	/* Data de Inicio */
690	$startTime = $component->getProperty('dtstart', false, true);
691
692	/* Tiem zone do evento */
693	if (isset($startTime['params']['TZID']))
694	$schedulable['timezone'] = self::nomalizeTZID($startTime['params']['TZID']);
695	else
696	$schedulable['timezone'] = isset($params['calendar_timezone']) ? $params['calendar_timezone'] : 'America/Sao_Paulo';
697
698	$objTimezone = new DateTimeZone($schedulable['timezone']);
699
700	if ($startTime['params']['VALUE'] === 'DATE' && isset($params['calendar_timezone'])) {
701	$schedulable['allDay'] = 1;
702	$schedulable['startTime'] = self::date2timestamp($startTime['value']) - self::_getTzOffset('UTC', $schedulable['timezone'], '@' . self::date2timestamp($startTime['value'])) . '000';
703	} elseif (isset($startTime['params']['TZID']) && !isset($startTime['value']['tz'])) {/* Caso não tenha um tz na data mais exista um parametro TZID deve ser aplicado o timezone do TZID a data */
704	$schedulable['startTime'] = self::date2timestamp($startTime['value']) - self::_getTzOffset('UTC', $startTime['params']['TZID'], '@' . self::date2timestamp($startTime['value'])) . '000';
705	$schedulable['allDay'] = 0;
706	} else {
707	$schedulable['startTime'] = self::date2timestamp($startTime['value']) . '000';
708	if (strpos($params['prodid'], 'Outlook') !== false) {
709	//Se o ics veio em utc não aplicar horario de verão
710	$sTime = new DateTime('@' . (int) ($schedulable['startTime'] / 1000), new DateTimeZone('UTC'));
711	$sTime->setTimezone($objTimezone);
712	if ($sTime->format('I')) //Se o ics veio em utc não aplicar horario de verão
713	$schedulable['startTime'] = $schedulable['startTime'] - 3600000;
714	}
715	}
716
717
718	/* Data de Termino */
719	$endTime = $component->getProperty('dtend', false, true);
720
721	if ($endTime['params']['VALUE'] === 'DATE')
722	$schedulable['endTime'] = self::date2timestamp($endTime['value']) - self::_getTzOffset('UTC', $schedulable['timezone'], '@' . self::date2timestamp($endTime['value'])) . '000';
723	else if (isset($endTime['params']['TZID']) && !isset($endTime['value']['tz'])) /* Caso não tenha um tz na data mais exista um parametro TZID deve ser aplicado o timezone do TZID a data */
724	$schedulable['endTime'] = self::date2timestamp($endTime['value']) - self::_getTzOffset('UTC', $endTime['params']['TZID'], '@' . self::date2timestamp($endTime['value'])) . '000';
725	else {
726	$schedulable['endTime'] = self::date2timestamp($endTime['value']) . '000';
727	if (strpos($params['prodid'], 'Outlook') !== false) {
728	//Se o ics veio em utc não aplicar horario de verão
729	$eTime = new DateTime('@' . (int) ($schedulable['endTime'] / 1000), new DateTimeZone('UTC'));
730	$eTime->setTimezone($objTimezone);
731	if ($eTime->format('I'))
732	$schedulable['endTime'] = $schedulable['endTime'] - 3600000;
733	}
734	}
735	unset($schedulable['participants']);
736	$interation['schedulable://' . $eventID] = $schedulable;
737
738	return $interation;
739	}
740
741	static private function _makeVEVENT($schedulable, $component, $params) {
742
743	$interation = array();
744	$eventID = isset($schedulable['id']) ? $schedulable['id'] : mt_rand() . '(Formatter)';
745
746	/* Data de Inicio */
747	$startTime = $component->getProperty('dtstart', false, true);
748
749	/* Tiem zone do evento */
750	if (isset($startTime['params']['TZID']))
751	$schedulable['timezone'] = self::nomalizeTZID($startTime['params']['TZID']);
752	else
753	$schedulable['timezone'] = isset($params['calendar_timezone']) ? $params['calendar_timezone'] : 'America/Sao_Paulo';
754
755	$objTimezone = new DateTimeZone($schedulable['timezone']);
756
757	if (isset($startTime['params']['VALUE']) && $startTime['params']['VALUE'] === 'DATE' && isset($params['calendar_timezone'])) {
758	$schedulable['allDay'] = 1;
759	$schedulable['startTime'] = self::date2timestamp($startTime['value']) - self::_getTzOffset('UTC', $schedulable['timezone'], '@' . self::date2timestamp($startTime['value'])) . '000';
760	} elseif (isset($startTime['params']['TZID']) && !isset($startTime['value']['tz'])) {/* Caso não tenha um tz na data mais exista um parametro TZID deve ser aplicado o timezone do TZID a data */
761	$schedulable['startTime'] = self::date2timestamp($startTime['value']) - self::_getTzOffset('UTC', $startTime['params']['TZID'], '@' . self::date2timestamp($startTime['value'])) . '000';
762	$schedulable['allDay'] = 0;
763	} else {
764	$schedulable['startTime'] = self::date2timestamp($startTime['value']) . '000';
765	if (strpos($params['prodid'], 'Outlook') !== false) {
766	//Se o ics veio em utc não aplicar horario de verão
767	$sTime = new DateTime('@' . (int) ($schedulable['startTime'] / 1000), new DateTimeZone('UTC'));
768	$sTime->setTimezone($objTimezone);
769	if ($sTime->format('I')) //Se o ics veio em utc não aplicar horario de verão
770	$schedulable['startTime'] = $schedulable['startTime'] - 3600000;
771	}
772	}
773
774
775	/* Data de Termino */
776	$endTime = $component->getProperty('dtend', false, true);
777
778	if (isset($endTime['params']['VALUE']) && $endTime['params']['VALUE'] === 'DATE')
779	$schedulable['endTime'] = self::date2timestamp($endTime['value']) - self::_getTzOffset('UTC', $schedulable['timezone'], '@' . self::date2timestamp($endTime['value'])) . '000';
780	else if (isset($endTime['params']['TZID']) && !isset($endTime['value']['tz'])) /* Caso não tenha um tz na data mais exista um parametro TZID deve ser aplicado o timezone do TZID a data */
781	$schedulable['endTime'] = self::date2timestamp($endTime['value']) - self::_getTzOffset('UTC', $endTime['params']['TZID'], '@' . self::date2timestamp($endTime['value'])) . '000';
782	else {
783	$schedulable['endTime'] = self::date2timestamp($endTime['value']) . '000';
784	if (strpos($params['prodid'], 'Outlook') !== false) {
785	//Se o ics veio em utc não aplicar horario de verão
786	$eTime = new DateTime('@' . (int) ($schedulable['endTime'] / 1000), new DateTimeZone('UTC'));
787	$eTime->setTimezone($objTimezone);
788	if ($eTime->format('I'))
789	$schedulable['endTime'] = $schedulable['endTime'] - 3600000;
790	}
791	}
792
793
794	$schedulable['summary'] = mb_convert_encoding($component->getProperty('summary', false, false), 'ISO-8859-1', 'UTF-8,ISO-8859-1');
795
796	/* Definindo Description */
797	if ($desc = $component->getProperty('description', false, false))
798	$schedulable['description'] = mb_convert_encoding(str_ireplace(array('\n', '\t'), array("\n", "\t"), $desc), 'ISO-8859-1', 'UTF-8,ISO-8859-1');
799
800	/* Definindo location */
801	if ($location = $component->getProperty('location', false, false))
802	$schedulable['location'] = mb_convert_encoding($location, 'ISO-8859-1', 'UTF-8,ISO-8859-1');
803
804
805	/* Definindo Class */
806	$class = $component->getProperty('class', false, false);
807	if ($class && defined(constant(strtoupper('CLASS_' . $class))))
808	$schedulable['class'] = constant(strtoupper('CLASS_' . $class));
809	else if (!isset($schedulable['class']))
810	$schedulable['class'] = CLASS_PRIVATE; // padrão classe private
811
812	/* Definindo RRULE */
813	if ($rrule = $component->getProperty('rrule', false, false)) {
814	/* Gera um randon id para o contexto formater */
815	$repeatID = mt_rand() . '3(Formatter)';
816
817	$repeat = array();
818	$repeat['schedulable'] = $eventID;
819	foreach ($rrule as $i => $v) {
820	if (strtolower($i) == 'freq')
821	$repeat['frequency'] = $v;
822	else if (strtolower($i) == 'until')
823	$repeat['endTime'] = $v;
824	else
825	$repeat[strtolower($i)] = $v;
826	}
827
828	$interation['repeat://' . $repeatID] = $repeat;
829	}
830
831
832	$schedulable['calendar'] = $params['calendar'];
833
834	$participantsInEvent = array();
835
836	//TODO: Participants com delegated não estao sendo levados em conta
837	while ($property = $component->getProperty('attendee', FALSE, TRUE)) {
838	$participant = array();
839
840	$mailUser = trim(str_replace('MAILTO:', '', $property['value']));
841
842	$participantID = ($tpID = self::_getParticipantByMail($mailUser, $schedulable['participants'])) ? $tpID : mt_rand() . '2(Formatter)';
843	$participant['schedulable'] = $eventID;
844
845	if (isset($params['status']) && $mailUser == Config::me('mail'))
846	$participant['status'] = $params['status'];
847	else
848	$participant['status'] = (isset($property['params']['PARTSTAT']) && constant('STATUS_' . $property['params']['PARTSTAT']) !== null ) ? constant('STATUS_' . $property['params']['PARTSTAT']) : STATUS_UNANSWERED;
849
850
851	$participant['isOrganizer'] = '0';
852
853	/* Verifica se este usuario é um usuario interno do ldap */
854	$intUser = Controller::find(array('concept' => 'user'), array('id', 'isExternal'), array('filter' => array('OR', array('=', 'mail', $mailUser), array('=', 'mailAlternateAddress', $mailUser))));
855
856	$user = null;
857	if ($intUser && count($intUser) > 0) {
858	$participant['isExternal'] = isset($intUser[0]['isExternal']) ? $intUser[0]['isExternal'] : 0;
859	$participant['user'] = $intUser[0]['id'];
860	} else {
861	$participant['isExternal'] = 1;
862	/* Gera um randon id para o contexto formater */
863	$userID = mt_rand() . '4(Formatter)';
864
865	$user['mail'] = $mailUser;
866	$user['isExternal'] = '1';
867	$user['name'] = ( isset($property['params']['CN']) ) ? $property['params']['CN'] : '';
868	$user['participants'] = array($participantID);
869	$participant['user'] = $userID;
870	$interation['user://' . $userID] = $user;
871	}
872
873	$interation['participant://' . $participantID] = $participant;
874	$schedulable['participants'][] = $participantID;
875	};
876
877	if ($property = $component->getProperty('organizer', FALSE, TRUE)) {
878	$participant = array();
879	$mailUser = trim(str_replace('MAILTO:', '', $property['value']));
880
881	$participantID = mt_rand() . '2(Formatter)';
882
883	$participant['schedulable'] = $eventID;
884	$participant['status'] = (isset($property['params']['PARTSTAT']) && constant('STATUS_' . $property['params']['PARTSTAT']) !== null ) ? constant('STATUS_' . $property['params']['PARTSTAT']) : STATUS_UNANSWERED;
885	$participant['isOrganizer'] = '1';
886	$participant['acl'] = 'rowi';
887
888	/* Verifica se este usuario é um usuario interno do ldap */
889	$intUser = Controller::find(array('concept' => 'user'), array('id', 'isExternal'), array('filter' => array('OR', array('=', 'mail', $mailUser), array('=', 'mailAlternateAddress', $mailUser))));
890
891	$user = null;
892	if ($intUser && count($intUser) > 0) {
893	$participant['isExternal'] = isset($intUser[0]['isExternal']) ? $intUser[0]['isExternal'] : 0;
894	$participant['user'] = $intUser[0]['id'];
895	} else {
896	$participant['isExternal'] = 1;
897	/* Gera um randon id para o contexto formater */
898	$userID = mt_rand() . '4(Formatter)';
899
900	$user['mail'] = $mailUser;
901	$user['name'] = ( isset($property['params']['CN']) ) ? $property['params']['CN'] : '';
902	$user['participants'] = array($participantID);
903	$user['isExternal'] = '1';
904	$participant['user'] = $userID;
905	$interation['user://' . $userID] = $user;
906	}
907
908	$interation['participant://' . $participantID] = $participant;
909	$schedulable['participants'][] = $participantID;
910	} else if (!is_array($schedulable['participants']) \|\| count($schedulable['participants']) < 1) {//caso não tenha organizador o usuario se torna organizador
911	$user = Controller::read(array('concept' => 'user', 'id' => $params['owner']), array('mail'));
912
913	if (!self::_getParticipantByMail($user['mail'], $schedulable['participants'])) {
914	$participantID = mt_rand() . '2(Formatter)';
915
916	$participant['schedulable'] = $eventID;
917	$participant['status'] = STATUS_CONFIRMED;
918	$participant['isOrganizer'] = '1';
919	$participant['acl'] = 'rowi';
920	$participant['isExternal'] = 0;
921	$participant['user'] = $params['owner'];
922	$interation['participant://' . $participantID] = $participant;
923	$schedulable['participants'][] = $participantID;
924	}
925	}
926
927	$alarms = array();
928
929	/* Definindo ALARMES */
930	while ($alarmComp = $component->getComponent('valarm'))
931	{
932	$alarm = array();
933	$alarmID = mt_rand() . '6(Formatter)';
934	$action = $alarmComp->getProperty('action', false, true);
935	$trygger = $alarmComp->getProperty('trigger', false, true);
936	$alarm['type'] = self::decodeAlarmAction($action['value']);
937
938	if(isset($trygger['value']['day']))
939	{
940	$alarm['time'] = $trygger['value']['day'];
941	$alarm['unit'] = 'd';
942	}
943	else if(isset($trygger['value']['hour']))
944	{
945	$alarm['time'] = $trygger['value']['hour'];
946	$alarm['unit'] = 'h';
947	}
948	else if(isset($trygger['value']['min']))
949	{
950	$alarm['time'] = $trygger['value']['min'];
951	$alarm['unit'] = 'm';
952	}
953
954	foreach ($interation as $iint => &$vint)
955	{
956	if(isset($vint['user']) && $vint['user'] == Config::me('uidNumber'))
957	{
958	$alarm['participant'] = str_replace('participant://', '', $iint);
959	$vint['alarms'][] = $alarmID;
960	}
961	}
962	$alarm['schedulable'] = $eventID;
963
964	$interation['alarm://' . $alarmID ] = $alarm;
965
966	}
967
968
969	/* Definindo DTSTAMP */
970	if ($dtstamp = self::_getTime($component, 'dtstamp'))
971	$schedulable['dtstamp'] = $dtstamp;
972
973	/* Definindo TRANSP */
974	if (($tranp = $component->getProperty('transp', false, true)) && $tranp && is_string($tranp) && strtoupper($tranp) == 'OPAQUE')
975	$schedulable['transparent'] = 1;
976
977	/* Definindo last_update */
978	if ($lastUpdate = self::_getTime($component, 'LAST-MODIFIED'))
979	$schedulable['lastUpdate'] = $lastUpdate;
980
981
982	if ($sequence = $component->getProperty('SEQUENCE', false, false))
983	$schedulable['sequence'] = $sequence;
984
985	if ($uid = $component->getProperty('uid', false, false))
986	;
987	$schedulable['uid'] = $uid;
988
989	while ($attach = $component->getProperty('ATTACH', FALSE, TRUE)) {
990
991	$attachCurrent = array('name' => $attach['params']['X-FILENAME'],
992	'size' => strlen($attach['value']),
993	'type' => self::_getContentType($attach['params']['X-FILENAME'])
994	);
995
996	$ids = Controller::find(array('concept' => 'attachment'), array('id'), array('filter' => array('AND', array('=', 'name', $attachCurrent['name']), array('=', 'size', $attachCurrent['size']), array('=', 'type', $attachCurrent['type']))));
997
998	if (!is_array($ids)) {
999	$attachCurrent['source'] = $attach['value'];
1000	//insere o anexo no banco e pega id para colcar no relacionamento
1001	$idAttachment = Controller::create(array('concept' => 'attachment'), $attachCurrent);
1002	}else
1003	$idAttachment = array('id' => $ids[0]['id']);
1004
1005	$calendarToAttachmentId = mt_rand() . '2(Formatter)';
1006	$calendarToAttachment['attachment'] = $idAttachment['id'];
1007	$calendarToAttachment['schedulable'] = $eventID;
1008	$interation['schedulableToAttachment://' . $calendarToAttachmentId] = $calendarToAttachment;
1009
1010	$schedulable['attachments'][] = $calendarToAttachmentId;
1011	}
1012
1013	$interation['schedulable://' . $eventID] = $schedulable;
1014
1015	return $interation;
1016	}
1017
1018	static private function _getSchedulable($uid) {
1019	$schedulable = Controller::find(array('concept' => 'schedulable'), false, array('filter' => array('=', 'uid', $uid), 'deepness' => 2));
1020	return (isset($schedulable[0])) ? $schedulable[0] : false;
1021	}
1022
1023	static private function _existInMyCalendars($id) {
1024	$sig = Controller::find(array('concept' => 'calendarSignature'), array('user', 'calendar', 'isOwner'), array('filter' => array('AND', array('=', 'user', Config::me('uidNumber')), array('=', 'isOwner', '1'))));
1025	$calendars = array();
1026	foreach ($sig as $val)
1027	$calendars[] = $val['calendar'];
1028
1029	$return = Controller::find(array('concept' => 'calendarToSchedulable'), null, array('filter' => array('AND', array('IN', 'calendar', $calendars), array('=', 'schedulable', $id))));
1030
1031	return (isset($return[0])) ? $return[0]['calendar'] : false;
1032	}
1033
1034	static private function _getTime(&$component, $property) {
1035	if ($date = $component->getProperty($property, false, true))
1036	return (isset($date['params']['TZID']) && !isset($date['value']['tz'])) ? (self::date2timestamp($date['value']) - self::_getTzOffset('UTC', $date['params']['TZID'], '@' . self::date2timestamp($date['value']))) . '000' : self::date2timestamp($date['value']) . '000';
1037
1038	return false;
1039	}
1040
1041	static private function _getContentType($fileName) {
1042	$strFileType = strtolower(substr($fileName, strrpos($fileName, '.')));
1043
1044	switch ($strFileType) {
1045	case ".asf": return "video/x-ms-asf";
1046	case ".avi": return "video/avi";
1047	case ".doc": return "application/msword";
1048	case ".zip": return "application/zip";
1049	case ".xls": return "application/vnd.ms-excel";
1050	case ".gif": return "image/gif";
1051	case ".bmp": return "image/bmp";
1052	case ".jpeg":
1053	case ".jpg": return "image/jpeg";
1054	case ".wav": return "audio/wav";
1055	case ".mp3": return "audio/mpeg3";
1056	case ".mpeg":
1057	case ".mpg": return "video/mpeg";
1058	case ".rtf": return "application/rtf";
1059	case ".html":
1060	case ".htm": return "text/html";
1061	case ".xml": return "text/xml";
1062	case ".xsl": return "text/xsl";
1063	case ".css": return "text/css";
1064	case ".php": return "text/php";
1065	case ".asp": return "text/asp";
1066	case ".pdf": return "application/pdf";
1067	case ".png": return "image/png";
1068	case ".txt": return "text/plain";
1069	case ".log": return "text/plain";
1070	case ".wmv": return "video/x-ms-wmv";
1071	case ".sxc": return "application/vnd.sun.xml.calc";
1072	case ".odt": return "application/vnd.oasis.opendocument.text";
1073	case ".stc": return "application/vnd.sun.xml.calc.template";
1074	case ".sxd": return "application/vnd.sun.xml.draw";
1075	case ".std": return "application/vnd.sun.xml.draw.template";
1076	case ".sxi": return "application/vnd.sun.xml.impress";
1077	case ".sti": return "application/vnd.sun.xml.impress.template";
1078	case ".sxm": return "application/vnd.sun.xml.math";
1079	case ".sxw": return "application/vnd.sun.xml.writer";
1080	case ".sxq": return "application/vnd.sun.xml.writer.global";
1081	case ".stw": return "application/vnd.sun.xml.writer.template";
1082	case ".pps": return "application/vnd.ms-powerpoint";
1083	case ".odt": return "application/vnd.oasis.opendocument.text";
1084	case ".ott": return "application/vnd.oasis.opendocument.text-template";
1085	case ".oth": return "application/vnd.oasis.opendocument.text-web";
1086	case ".odm": return "application/vnd.oasis.opendocument.text-master";
1087	case ".odg": return "application/vnd.oasis.opendocument.graphics";
1088	case ".otg": return "application/vnd.oasis.opendocument.graphics-template";
1089	case ".odp": return "application/vnd.oasis.opendocument.presentation";
1090	case ".otp": return "application/vnd.oasis.opendocument.presentation-template";
1091	case ".ods": return "application/vnd.oasis.opendocument.spreadsheet";
1092	case ".ots": return "application/vnd.oasis.opendocument.spreadsheet-template";
1093	case ".odc": return "application/vnd.oasis.opendocument.chart";
1094	case ".odf": return "application/vnd.oasis.opendocument.formula";
1095	case ".odi": return "application/vnd.oasis.opendocument.image";
1096	case ".ndl": return "application/vnd.lotus-notes";
1097	case ".eml": return "text/plain";
1098	case ".ps" : return "application/postscript";
1099	default : return "application/octet-stream";
1100	}
1101	}
1102
1103	public function codeAlarmAction( $action )
1104	{
1105	switch ($action)
1106	{
1107	case ALARM_MAIL :
1108	return 'EMAIL';
1109	break;
1110	case ALARM_ALERT :
1111	return 'DISPLAY';
1112	break;
1113	case 'mail' :
1114	return 'EMAIL';
1115	break;
1116	case 'alert' :
1117	return 'DISPLAY';
1118	break;
1119	}
1120
1121	}
1122
1123	public function decodeAlarmAction( $action )
1124	{
1125	switch ( $action )
1126	{
1127	case 'EMAIL' :
1128	return 'mail';
1129	break;
1130	case 'DISPLAY' :
1131	return 'alert';
1132	break;
1133
1134	}
1135
1136	}
1137
1138	}
1139
1140	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: