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); }