function import_google($cate_sn = "")
{
global $xoopsDB, $xoopsUser;
if (!ini_get('safe_mode')) {
set_time_limit(0);
}
$client_id = '254265660934-4m4mon8fms910dokh93o3spp77k0ahtr.apps.googleusercontent.com';
//$client_secret = '0ROGDfIJB1Q3RBFioMc0Bqig';
$client_secret = '*****@*****.**';
$redirect_uri = XOOPS_URL . '/modules/tad_cal/admin/import.php';
include XOOPS_ROOT_PATH . '/modules/tad_cal/class/gapi/autoload.php';
$client = new Google_Client();
$client->setClientId($client_id);
$client->setClientSecret($client_secret);
$client->setRedirectUri($redirect_uri);
// $client->setAccessType('offline');
// $client->setApprovalPrompt('force');
$client->setScopes("https://www.googleapis.com/auth/userinfo.email");
$client->setScopes("https://www.googleapis.com/auth/userinfo.profile");
$client->setScopes("https://www.googleapis.com/auth/calendar");
// $client->setScopes("https://www.googleapis.com/auth/calendar.readonly");
$client->setApplicationName("Tad Cal");
$client->setDeveloperKey('AIzaSyCk7fQpA3WRB3NtyYFTxrGB9wu484qDdsY');
if (!isset($_SESSION['import_google'])) {
$_SESSION['import_google'] = $cate_sn;
} else {
$cate_sn = $_SESSION['import_google'];
}
$cal = new Google_Service_Calendar($client);
if (isset($_GET['code'])) {
$client->authenticate($_GET['code']);
$_SESSION['token'] = $client->getAccessToken();
$redirect = 'http://' . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'];
header('Location: ' . filter_var($redirect, FILTER_SANITIZE_URL) . "?cate_sn={$cate_sn}");
exit;
}
if (isset($_SESSION['token'])) {
// if($client->isAccessTokenExpired()) {
// $authUrl = $client->createAuthUrl();
// header('Location: ' . filter_var($authUrl, FILTER_SANITIZE_URL));
// exit;
// }
$client->setAccessToken($_SESSION['token']);
}
if ($client->getAccessToken()) {
//取得使用者編號
$uid = $xoopsUser ? $xoopsUser->getVar('uid') : "";
$sql = "select * from " . $xoopsDB->prefix("tad_cal_cate") . " where cate_sn='{$cate_sn}'";
$result = $xoopsDB->queryF($sql) or web_error($sql);
$all = $xoopsDB->fetchArray($result);
//以下會產生這些變數： $cate_sn , $cate_title , $cate_sort , $cate_enable , $cate_handle , $enable_group , $enable_upload_group , $google_id , $google_pass
foreach ($all as $k => $v) {
${$k} = $v;
}
$myts =& MyTextSanitizer::getInstance();
$now = date('Y-m-d H:i:s', time());
date_default_timezone_set('Asia/Taipei');
$calendarId = str_replace('%40', '@', $cate_handle);
$events = $cal->events->listEvents($calendarId);
while (true) {
foreach ($events->getItems() as $event) {
$title = $myts->addSlashes($event->summary);
$start = $event->start->dateTime;
$end = $event->end->dateTime;
$recurrence = is_array($event->recurrence) ? $myts->addSlashes(implode('', $event->recurrence)) : '';
$location = $myts->addSlashes($event->location);
$kind = $myts->addSlashes($event->kind);
$details = $myts->addSlashes($event->description);
$etag = $myts->addSlashes($event->etag);
$id = $myts->addSlashes($event->id);
$sequence = $myts->addSlashes($event->sequence);
$allday = isAllDay($start, $end);
$sql = "insert into " . $xoopsDB->prefix("tad_cal_event") . "\n (`title` , `start` , `end` , `recurrence` , `location` , `kind` , `details` , `etag` , `id` , `sequence` , `uid` , `cate_sn` , `allday` , `tag` , `last_update`)\n values('{$title}' , '{$start}' , '{$end}' , '{$recurrence}' , '{$location}' , '{$kind}' , '{$details}' , '{$etag}' , '{$id}' , '{$sequence}' , '{$uid}' , '{$cate_sn}' , '{$allday}' , '{$tag}' , '{$now}') ON DUPLICATE KEY UPDATE `title`='{$title}' , `start`='{$start}' , `end`='{$end}' , `recurrence`='{$recurrence}' , `location`='{$location}' , `kind`='{$kind}' , `details`='{$details}' , `etag`='{$etag}' , `id`='{$id}' , `sequence`='{$sequence}' , `uid`= '{$uid}' , `cate_sn`='{$cate_sn}' , `allday`='{$allday}' , `tag`='{$tag}' , `last_update`='{$now}'";
$xoopsDB->queryF($sql) or web_error($sql);
//取得最後新增資料的流水編號
$sn = $xoopsDB->getInsertId();
//重複事件
rrule($sn, $recurrence, $allday);
}
// $pageToken = $events->getNextPageToken();
// if ($pageToken) {
// $optParams = array('pageToken' => $pageToken);
// $events = $cal->events->listEvents($calendarId, $optParams);
// } else {
// break;
// }
}
$now = date("Y-m-d H:i:s");
$sql = "delete from " . $xoopsDB->prefix("tad_cal_event") . " where cate_sn='{$cate_sn}' and `last_update` < '{$now}'";
$xoopsDB->queryF($sql) or web_error($sql);
if (isset($_SESSION['import_google'])) {
unset($_SESSION['import_google']);
}
} else {
$authUrl = $client->createAuthUrl();
header("Location: " . $authUrl);
exit;
}
}
function rrule($sn = '', $recurrence = '', $allDay = null)
{
global $xoopsDB, $xoopsUser;
include_once XOOPS_ROOT_PATH . "/modules/tad_cal/class/rrule.php";
include_once XOOPS_ROOT_PATH . "/modules/tad_cal/class/ical.php";
if (empty($sn) or empty($recurrence)) {
return;
}
// die($recurrence);
$ical = new ical();
$ical->parse($recurrence);
$rrule_array = $ical->get_all_data();
// die('[rrule_array]' . var_export($rrule_array));
foreach ($rrule_array['']['RRULE'] as $key => $val) {
$all[] = "{$key}={$val}";
}
$rrule = 'RRULE:' . implode(";", $all);
// die($rrule_array['']['DTSTART']['unixtime']);
$start = substr(str_replace(":", "", str_replace("-", "", date("c", $rrule_array['']['DTSTART']['unixtime']))), 0, 15);
$endTime = $rrule_array['']['DTEND']['unixtime'] - $rrule_array['']['DTSTART']['unixtime'];
// die($start . "====" . $rrule);
// echo "<p>start= $start</p>";
// echo "<p>rrule= $rrule</p>";
$rule = new RRule($start, $rrule);
$i = 0;
while ($date = $rule->GetNext()) {
if ($i > 300) {
break;
}
$new_date = $date->Render();
// echo "<p>new_date= $new_date</p>";
if (empty($new_date)) {
continue;
}
$end = date("Y-m-d H:i", strtotime($new_date) + $endTime);
$allday = is_null($allDay) ? isAllDay($new_date, $end) : $allDay;
$allDate[] = "('{$sn}','{$new_date}','{$end}','{$allday}')";
$i++;
}
// exit;
$sql_data = implode(",", $allDate);
if (empty($sql_data)) {
return;
}
$sql = "delete from " . $xoopsDB->prefix("tad_cal_repeat") . " where `sn`='{$sn}'";
$xoopsDB->queryF($sql) or web_error($sql);
$sql = "insert into " . $xoopsDB->prefix("tad_cal_repeat") . "\n (`sn` , `start` , `end` , `allday`)\n values{$sql_data}";
// echo "<p>$sql</p>";
$xoopsDB->queryF($sql) or web_error($sql);
}
