113 lines
3.5 KiB
PHP
113 lines
3.5 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
define('_BENNU_VERSION', '0.1');
|
||
|
|
|
||
|
|
require_once('include/utils/utils.php');
|
||
|
|
require_once('modules/Calendar/CalendarCommon.php');
|
||
|
|
include('modules/Calendar/iCal/iCalendar_rfc2445.php');
|
||
|
|
include('modules/Calendar/iCal/iCalendar_components.php');
|
||
|
|
include('modules/Calendar/iCal/iCalendar_properties.php');
|
||
|
|
include('modules/Calendar/iCal/iCalendar_parameters.php');
|
||
|
|
|
||
|
|
//$ical_query = "SELECT * FROM vtiger_activity WHERE (( STATUS != 'Completed' AND STATUS != 'Deferred' ) OR STATUS IS NULL)
|
||
|
|
// AND (( eventstatus != 'Held' AND eventstatus != 'Not Held' ) OR eventstatus IS NULL )";
|
||
|
|
|
||
|
|
global $current_user,$adb,$default_timezone;
|
||
|
|
$filename = $_REQUEST['filename'];
|
||
|
|
$ical_query = "select vtiger_activity.*,vtiger_crmentity.description,vtiger_activity_reminder.reminder_time from vtiger_activity inner join vtiger_crmentity on vtiger_activity.activityid = vtiger_crmentity.crmid " .
|
||
|
|
" LEFT JOIN vtiger_activity_reminder ON vtiger_activity_reminder.activity_id=vtiger_activity.activityid AND vtiger_activity_reminder.recurringid=0" .
|
||
|
|
" where vtiger_crmentity.deleted = 0 and vtiger_crmentity.smownerid = " . $current_user->id .
|
||
|
|
" and vtiger_activity.activitytype NOT IN ('Emails')";
|
||
|
|
|
||
|
|
$calendar_results = $adb->query($ical_query);
|
||
|
|
|
||
|
|
// Send the right content type and filename
|
||
|
|
header ("Content-type: text/calendar");
|
||
|
|
header('Content-Disposition: attachment; '."filename={$filename}.ics");
|
||
|
|
|
||
|
|
$todo_fields = getColumnFields('Calendar');
|
||
|
|
$event_fields = getColumnFields('Events');
|
||
|
|
$event = $todo = array();
|
||
|
|
$keys_to_replace = array(
|
||
|
|
'events'=>array('taskpriority'),
|
||
|
|
'todo'=>array('taskpriority','taskstatus')
|
||
|
|
);
|
||
|
|
$keyvals_to_replace = array(
|
||
|
|
'events'=>array('taskpriority'=>'priority'),
|
||
|
|
'todo'=>array('taskpriority'=>'priority','taskstatus'=>'status')
|
||
|
|
);
|
||
|
|
foreach($todo_fields as $key=>$val){
|
||
|
|
if(getFieldVisibilityPermission('Calendar',$current_user->id,$key)==0){
|
||
|
|
if(!in_array($key,$keys_to_replace['todo'])){
|
||
|
|
$todo[$key] = 'yes';
|
||
|
|
} else {
|
||
|
|
$todo[$keyvals_to_replace['todo'][$key]] = 'yes';
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
foreach($event_fields as $key=>$val){
|
||
|
|
if(getFieldVisibilityPermission('Events',$current_user->id,$key)==0){
|
||
|
|
if(!in_array($key,$keys_to_replace['events'])){
|
||
|
|
$event[$key] = 'yes';
|
||
|
|
} else {
|
||
|
|
$event[$keyvals_to_replace['events'][$key]] = 'yes';
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
$tz = new iCalendar_timezone;
|
||
|
|
if(!empty($default_timezone)){
|
||
|
|
$tzid = split('/',$default_timezone);
|
||
|
|
} else {
|
||
|
|
$default_timezone = date_default_timezone_get();
|
||
|
|
$tzid = split('/',$default_timezone);
|
||
|
|
}
|
||
|
|
|
||
|
|
if(!empty($tzid[1])){
|
||
|
|
$tz->add_property('TZID', $tzid[1]);
|
||
|
|
} else {
|
||
|
|
$tz->add_property('TZID', $tzid[0]);
|
||
|
|
}
|
||
|
|
$tz->add_property('TZOFFSETTO', date('O'));
|
||
|
|
if(date('I')==1){
|
||
|
|
$tz->add_property('DAYLIGHTC', date('I'));
|
||
|
|
} else {
|
||
|
|
$tz->add_property('STANDARDC', date('I'));
|
||
|
|
}
|
||
|
|
|
||
|
|
$myical = new iCalendar;
|
||
|
|
|
||
|
|
$myical->add_component($tz);
|
||
|
|
|
||
|
|
while (!$calendar_results->EOF) {
|
||
|
|
$this_event = $calendar_results->fields;
|
||
|
|
$id = $this_event['activityid'];
|
||
|
|
$type = $this_event['activitytype'];
|
||
|
|
if($type!='Task'){
|
||
|
|
$temp = $event;
|
||
|
|
foreach($temp as $key=>$val){
|
||
|
|
$temp[$key] = $this_event[$key];
|
||
|
|
}
|
||
|
|
$temp['id'] = $id;
|
||
|
|
$ev = new iCalendar_event;
|
||
|
|
$ev->assign_values($temp);
|
||
|
|
|
||
|
|
$al = new iCalendar_alarm;
|
||
|
|
$al->assign_values($temp);
|
||
|
|
$ev->add_component($al);
|
||
|
|
} else {
|
||
|
|
$temp = $todo;
|
||
|
|
foreach($temp as $key=>$val){
|
||
|
|
$temp[$key] = $this_event[$key];
|
||
|
|
}
|
||
|
|
$ev = new iCalendar_todo;
|
||
|
|
$ev->assign_values($temp);
|
||
|
|
}
|
||
|
|
|
||
|
|
$myical->add_component($ev);
|
||
|
|
$calendar_results->MoveNext();
|
||
|
|
}
|
||
|
|
// Print the actual calendar
|
||
|
|
echo $myical->serialize();
|
||
|
|
|
||
|
|
?>
|