Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
RewriteEngine on
RewriteRule ^([0-9,a-z,A-Z,_]+).ics+ index.php?data=$1
<?php
/*
名古屋ではたらく社長ブログだもんで
サイボウズofffice8と同期するツール暫定版
http://ameblo.jp/sitescope/entry-10260113074.html
上記にて公開していただいているスクリプトをサイボウズ9用に勝手改変版
サイボウズ Office Version 9.3.1 20130703181739にて確認
*/
$sstitle = @$_REQUEST['data'];
$uid = '';
if ( strlen($sstitle) > 5 ) {
$uid = substr($sstitle, 4);
}
//ユーザ名・パスワードをロード
require_once($sstitle.'.php');
//-------------------------------------------------------------------------------------------------------------------
// 設定
//-------------------------------------------------------------------------------------------------------------------
//define("CHAR_CODE", 'SJIS'); //サイボウズの文字コード サイボウズ9はSJIS
define("CHAR_CODE", 'UTF-8'); //サイボウズの文字コード サイボウズ10はUTF-8
define("SCHEDULE_TITLE", 'Cybozu'); //スケジュールタイトル
define("SCHEDULE_MEMO", TRUE); //スケジュールメモまで取得する場合は'TRUE'
define('PRODID', 'Cybozu2iCal'); //http://ameblo.jp/sitescope/entry-10260113074.html
//-------------------------------------------------------------------------------------------------------------------
//POSTデータ組み立て
$data = array(
"_System" => "login",
"_Login" => "1",
"LoginMethod" => "2",
"_Account" => LOGIN_ID,
"Password" => LOGIN_PASS
);
$data = http_build_query($data, "", "&");
//headerにセット
$header = array(
"Content-Type: application/x-www-form-urlencoded",
"Content-Length: ".strlen($data)
);
$context = array(
"http" => array(
"method" => "POST",
"header" => implode("\r\n", $header),
"content" => $data
)
);
//とりあえず個人月間スケジュール
if ( UID == "" ) {
$url = CYBOZU_URL . '?page=ScheduleUserMonth';
} else {
$url = CYBOZU_URL . '?page=ScheduleUserMonth&UID=' . UID;
}
//サイボウズからHTMLデータ取得
$work = file_get_contents($url, false, stream_context_create($context));
//文字コードをUTF-8へ変換
$work = mb_convert_encoding($work, "UTF-8", CHAR_CODE);
//正規表現がめんどくさいのでそのまま文字列比較で不要なとこをまず削除
$work = substr(strchr($work,'<table class="schedule usermonth" id="schedulemonth" width="100%" >'), 0);
$work = substr($work, 0, strpos($work, '<table class="monthNavi" '));
$work = substr(strchr($work,'<tbody id="um__body">'), 0);
$work = substr($work, 0, strpos($work, '</table>'));
//文字列比較でとりあえず、スケジュールを配列に格納
$wdate1 = "";
$wdate2 = "";
$schedule_list = "";
$loop_flg = TRUE;
while ( $loop_flg == TRUE ) {
//日付の取得
$wdate = "";
$wdate = substr(strchr($work,'<span class="date">'), 19);
$wdate = substr($wdate, 0, strpos($wdate, '</span>'));
if ($wdate == "") {
break;
}
//日付のフォーマットを変更
$date_sp = "";
$date_sp = split('/', $wdate);
$schedule_date = Date('Y') . sprintf("%02d",$date_sp[0]) . sprintf("%02d",$date_sp[1]);
//次の日も取得しとく
$schedule_date_tommorow = "";
$schedule_date_tommorow = Date('Ymd', mktime(0, 0, 0, (int)$date_sp[0], (int)((int)$date_sp[1] + 1), (int)Date('Y') ) );
//日付部分をカット
$work = substr(strchr($work,'<span class="date">'), 30);
$loop_flg2 = TRUE;
while ( $loop_flg2 == TRUE ) {
if ( strpos($work, '<a class="event" href=') > strpos($work, '<span class="date">') ) {
break;
} else {
//スケジュールIDを取得
// サイボウズ9
//$schedule_id = substr(strchr($work,'<div class="eventLink scheduleMarkTitle0" name="'), 53);
//$schedule_id = substr($schedule_id, 0, strpos($schedule_id, '">'));
// サイボウズ10
$schedule_id = substr(strchr($work,'<div class="eventLink scheduleMarkTitle0 highlight-event'), 56);
$schedule_id = substr($schedule_id, 0, strpos($schedule_id, '" '));
if ( $schedule_id == "" ) {
break;
}
//----------------------------------
if ( SCHEDULE_MEMO ) {
//スケジュール内容まで取得
$wlink = substr(strchr($work,'<a class="event" href="ag.cgi?'), 30);
$wlink = substr($wlink, 0, strpos($wlink, '" title="'));
$url = CYBOZU_URL . '?' . $wlink;
//サイボウズからHTMLデータ取得
$work2 = file_get_contents($url, false, stream_context_create($context));
//文字コードをUTF-8へ変換
$work2 = mb_convert_encoding($work2, "UTF-8", CHAR_CODE);
//正規表現がめんどくさいのでそのまま文字列比較で不要なとこをまず削除
$work2 = substr(strchr($work2,'<table class="dataView scheduleDataView" width="100%" >'), 0);
$work2 = substr($work2, 0, strpos($work2, '<span class="vr_scheduleUserCount">'));
//スケジュールタイトルを取得
$work2 = str_replace("\n\r","", $work2);
$work2 = str_replace("\n","", $work2);
$work2 = str_replace("\r","", $work2);
$schedule_description = substr(strchr($work2,'<div id="scheduleMemo"><tt>'), 27);
$schedule_description = substr($schedule_description, 0, strpos($schedule_description, '</tt>'));
$schedule_description = strip_tags($schedule_description);
}
//----------------------------------
//スケジュールタイトルを取得
$schedule_title = substr(strchr($work,'=sm" title="'), 12);
$schedule_title = substr($schedule_title, 0, strpos($schedule_title, '">'));
//時刻を取得
if (strpos($work, '<span class="eventDateTime">') < strpos($work, '=sm" title="')) {
$schedule_time = substr(strchr($work, '<span class="eventDateTime">'), 28);
$schedule_time = substr($schedule_time, 0, strpos($schedule_time, '&nbsp;'));
} else {
$schedule_time = '';
}
//タイトル部分をカット
$work = substr(strchr($work,'=sm" title="'), 12);
//時間指定があるか判定
if ( !empty($schedule_time) ) {
$time_sp = "";
$time_sp = split('-', $schedule_time);
$from_sp = split(':', @$time_sp[0]);
//http://www.sunvisor.net/node/383
if ( count($time_sp) > 1 ) {
$to_sp = split(':', @$time_sp[1]);
} else {
$to_sp = $from_sp;
}
$from_sp[0] = sprintf('%02d', @$from_sp[0]);
$to_sp[0] = sprintf('%02d', @$to_sp[0]);
$from_hour = "";
$to_hour = "";
if ($from_sp[0]<10) {
$from_hour = '0' . @$from_sp[0];
} else {
$from_hour = $from_sp[0];
}
if ($to_sp[0]<10) {
$to_hour = '0' . $to_sp[0];
} else {
$to_hour = $to_sp[0];
}
if (count($to_sp)<2){
$to_hour = $from_hour + 1;
$to_sp[1] = $from_sp[1];
}
$schedule_summary = $schedule_title;
//http://www.sunvisor.net/node/383
$schedule_from = ':' . $schedule_date . 'T' . @$from_sp[0] . @$from_sp[1]. '00';
$schedule_to = ':' . $schedule_date . 'T' . @$to_sp[0] . @$to_sp[1]. '00';
$schedule_description = $schedule_title . " " . $schedule_description;
} else {
$schedule_summary = $schedule_title;
//http://www.sunvisor.net/node/383
$schedule_from = ';VALUE=DATE:' . $schedule_date;
$schedule_to = ';VALUE=DATE:' . $schedule_date_tommorow;
$schedule_description = $schedule_title . " " . $schedule_description;
}
//http://www.sunvisor.net/node/383
$schedule_list[] = Array('id' => $schedule_id.$schedule_date,
'description' => $schedule_description,
'dtstart' => $schedule_from,
'dtend' => $schedule_to,
'summary' => $schedule_summary);
}
}
}
//ここから出力
header('Content-Type: text/calendar; charset=utf-8');
echo 'BEGIN:VCALENDAR'. "\n";
echo 'PRODID:' . PRODID. "\n";
echo 'VERSION:2.0'. "\n";
echo 'METHOD:PUBLISH'. "\n";
echo 'CALSCALE:GREGORIAN'. "\n";
echo 'X-WR-CALNAME:' . SCHEDULE_TITLE . "\n";
echo 'X-WR-CALDESC:' . SCHEDULE_TITLE . "\n";
echo 'X-WR-TIMEZONE:Asia/Tokyo'. "\n";
if ( !empty($schedule_list) ) {
foreach ( $schedule_list as $key => $vale ) {
echo 'BEGIN:VEVENT'. "\n";
echo 'UID:' . SCHEDULE_TITLE . '-' . $vale['id'] . "\n";
echo 'DESCRIPTION:' . $vale['description']. "\n";
//http://www.sunvisor.net/node/383
echo 'DTSTART;TZID=Asia/Tokyo' . $vale['dtstart'] . "\n";
echo 'DTEND;TZID=Asia/Tokyo' . $vale['dtend'] . "\n";
echo 'SUMMARY:'. $vale['summary']. "\n";
echo 'END:VEVENT'. "\n";
}
}
echo 'BEGIN:VTIMEZONE'. "\n";
echo 'TZID:Asia/Tokyo'. "\n";
echo 'BEGIN:STANDARD'. "\n";
echo 'DTSTART:19700101T000000'. "\n";
echo 'TZOFFSETFROM:+0900'. "\n";
echo 'TZOFFSETTO:+0900'. "\n";
echo 'END:STANDARD'. "\n";
echo 'END:VTIMEZONE'. "\n";
echo 'END:VCALENDAR'. "\n";
?>
<?php
//GoogleカレンダーでアクセスさせるURLは
//http://hoge.hoge/このファイル名本体.ics
//となりますので、このファイル名は適宜変更ください。
define('CYBOZU_URL', 'http://hoge.hoge/cgi-bin/cbag/ag.cgi'); //サイボウズのURL
define("LOGIN_ID", 'hogehoge'); //ログインID
define("LOGIN_PASS", 'hoge'); //ログインパス
define("UID", 'hoge'); //取得したいスケジュールのID(無い場合はログインユ
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment