./tests/PagingQueryTest.php: $this->pdo = new \PDO("mysql:host=localhost; dbname=blogbeartest", "root", "");
./tests/PagerTest.php: $this->pdo = new \PDO("mysql:host=localhost; dbname=blogbeartest", "root", "");
./tests/DoctrineDbalAdapterTest.php: $this->pdo = new \PDO("mysql:host=localhost; dbname=blogbeartest", "root", "");
./apps/sandbox/tests/PageBlogPostsTest.php: $pdo = new \PDO("mysql:host=localhost; dbname=blogbeartest", "root", "");
./apps/sandbox/tests/AppPostsTest.php: $pdo = new \PDO("mysql:host=localhost; dbname=blogbeartest", "root", "");
./sandbox/scripts/test.config.php: 'password' => null,
./sandbox/scripts/test.config.php: 'password' => null,
# mysql
mysql> SET PASSWORD FOR root@localhost=PASSWORD('hoge');
Query OK, 0 rows affected (0.00 sec)
mysql> quit
# killall mysqld # /usr/bin/mysqld_safe --user=root --skip-grant-tables & mysql mysql mysql> update user set Password=null where Host='localhost' and User='root'; mysql> quit # /etc/rc.d/init.d/mysqld restart
$ sudo yum install httpd mysql-server git curlapache2とmysql-serverを起動し、自動起動の設定を行い動作確認。
$ sudo systemctl start httpd.service $ sudo systemctl enable httpd.service ln -s '/usr/lib/systemd/system/httpd.service' '/etc/systemd/system/multi-user.target.wants/httpd.service' $ sudo systemctl start mysqld.service $ sudo systemctl enable mysqld.service ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'php関係のパッケージを導入。以下のものでおそらく事足りるかと思われる。
$ sudo yum install php php-mbstring php-pear php-pecl-apc php-xml php-mysql php-pecl-xhprofそしてphp.iniを編集。
$sudo vi /etc/php.ini default_charser = UTF-8 date.timezone = Asia/Tokyo mbstring.language = Japanese mbstring.internal_encoding = UTF-8 mbstring.http_input = pass mbstring.http_output = pass mbstring.encoding_translation = Off bstring.detect_order = auto mbstring.substitute_character = none; bstring.func_overload = 0 mbstring.http_output_conv_mimetype= apc.enable_cli = 1 xhprof.output_dir = /tmp上記を設定し、phpのバージョンを確認。
$ php -v PHP 5.4.4 (cli) (built: Jun 14 2012 17:00:36) Copyright (c) 1997-2012 The PHP Group Zend Engine v2.4.0, Copyright (c) 1998-2012 Zend TechnologiesホームディレクトリにとりあえずBEARディレクトリを作成してgithubよりclone。
$ mkdir BEAR $ cd BEAR/ $ git clone git://github.com/koriym/BEAR.Sunday.git Cloning into 'BEAR.Sunday'... remote: Counting objects: 5747, done. remote: Compressing objects: 100% (1923/1923), done. remote: Total 5747 (delta 2891), reused 5720 (delta 2864) Receiving objects: 100% (5747/5747), 2.76 MiB | 69 KiB/s, done. Resolving deltas: 100% (2891/2891), done.composerのインストールでの変化を確認するためにディレクトリ構造を保存しておいた。
$ ls -R BEAR.Sunday >List1 $ cd BEAR.Sunday $ curl -s http://getcomposer.org/installer | php #!/usr/bin/env php All settings correct for using Composer Downloading... Composer successfully installed to: /home/shige/BEAR/BEAR.Sunday/composer.phar Use it: php composer.pharcomposerのインストール前とインストール後での違いを見るとcomposer.pharファイルのみが導入されていることが確認できた。
$ cd ../ $ ls -R BEAR.Sunday >List2 $ diff List1 List2 6a7 > composer.phar導入したcomposerを利用して外部ライブラリを導入する。
$ cd BEAR.Sunday $ ./composer.phar install Installing dependencies - Installing aura/autoload (dev-master) Cloning 1b8028cd301a8c95da7f0b1725bbf4fc8a495529 - Installing aura/router (dev-master) Cloning 9b7cceaf1914214ac615cf1697f39d4f4f71e52d - Installing aura/web (dev-master) Cloning 111c884927e597f25fe8e14bf2d32860469b3730 - Installing monolog/monolog (1.1.0) Downloading: 100% - Installing symfony/event-dispatcher (v2.0.15) Downloading: 100% - Installing guzzle/guzzle (v2.7.2) Downloading: 100% - Installing facebook/xhprof (0.9.2) Downloading: 100% - Installing aura/di (dev-master) Cloning 2bc8695f2efe040935e461f8fa945fc73ebbfe11 - Installing doctrine/common (dev-master) Cloning b3afbb80506d909743475c5b0904285ab0c07941 - Installing ray/aop (dev-master) Cloning e7e5125f829130c716bd797b389cf4c5e3f8c2fd - Installing ray/di (dev-master) Cloning 460bb44f25742147becd22a3afd8b1b92d3183a0 - Installing aura/signal (dev-master) Cloning 501f622f7905a5b42f98265937e84c02db6e78bd - Installing bear/resource (dev-master) Cloning ae5acc46be3aa39241067e613f6e1b7edbf27a8b - Installing doctrine/dbal (dev-master) Cloning 78dbf28923059545b24ba753c112560ad59ca89e - Installing pagerfanta/pagerfanta (dev-master) Cloning c490684def33e992241e7fad33bcbd03d9d18643 - Installing vdump/vdump (0.1.0) Downloading: 100% - Installing smarty/smarty (v3.1.11) Checking out /tags/v3.1.11/@4636 - Installing symfony/console (v2.0.15) Downloading: 100% - Installing symfony/http-foundation (v2.0.15) Downloading: 100% monolog/monolog suggests installing mlehner/gelf-php (Allow sending log messages to a GrayLog2 server) pagerfanta/pagerfanta suggests installing doctrine/orm (2.*) pagerfanta/pagerfanta suggests installing doctrine/mongodb-odm (2.*) pagerfanta/pagerfanta suggests installing solarium/solarium (2.*) Writing lock file Generating autoload files外部ライブラリ導入前と導入後を比較してみました。
$ cd .. $ ls -R BEAR.Sunday>List3 $ diff List2 List3>diff23 $ cat diff23 6a7 > composer.lock 11a13 > vendor 559a562,5967 > > BEAR.Sunday/vendor: > Aura > BEAR > Ray > autoload.php > composer > doctrine > facebook > guzzle > monolog > pagerfanta > smarty > symfony > vdump > ・・・以下略composer.lockとvenderが追加されたようで外部ライブラリの入れ直しではこの2つの削除でOKかな？
$ cd BEAR.Sunday $ chmod -R 777 apps/sandbox/tmp apps/sandbox/logphpunit関係の導入。
$ sudo pear config-set auto_discover 1 config-set succeeded $ sudo pear install pear.phpunit.de/PHPUnit Attempting to discover channel "pear.phpunit.de"... downloading channel.xml ... Starting to download channel.xml (804 bytes) ....done: 804 bytes Auto-discovered channel "pear.phpunit.de", alias "phpunit", adding to registry Attempting to discover channel "pear.symfony-project.com"... downloading channel.xml ... Starting to download channel.xml (865 bytes) ...done: 865 bytes Auto-discovered channel "pear.symfony-project.com", alias "symfony", adding to registry Did not download optional dependencies: phpunit/PHP_Invoker, use --alldeps to download automatically phpunit/PHPUnit can optionally use package "phpunit/PHP_Invoker" (version >= 1.1.0) phpunit/PHP_CodeCoverage can optionally use PHP extension "xdebug" (version >= 2.0.5) phpunit/PHPUnit_MockObject can optionally use PHP extension "soap" downloading PHPUnit-3.6.11.tgz ... Starting to download PHPUnit-3.6.11.tgz (119,171 bytes) ...done: 119,171 bytes downloading File_Iterator-1.3.1.tgz ... Starting to download File_Iterator-1.3.1.tgz (5,157 bytes) ...done: 5,157 bytes downloading Text_Template-1.1.1.tgz ... Starting to download Text_Template-1.1.1.tgz (3,622 bytes) ...done: 3,622 bytes downloading PHP_CodeCoverage-1.1.2.tgz ... Starting to download PHP_CodeCoverage-1.1.2.tgz (132,552 bytes) ...done: 132,552 bytes downloading PHP_Timer-1.0.2.tgz ... Starting to download PHP_Timer-1.0.2.tgz (3,686 bytes) ...done: 3,686 bytes downloading PHPUnit_MockObject-1.1.1.tgz ... Starting to download PHPUnit_MockObject-1.1.1.tgz (19,897 bytes) ...done: 19,897 bytes downloading YAML-1.0.6.tgz ... Starting to download YAML-1.0.6.tgz (10,010 bytes) ...done: 10,010 bytes downloading PHP_TokenStream-1.1.3.tgz ... Starting to download PHP_TokenStream-1.1.3.tgz (9,860 bytes) ...done: 9,860 bytes install ok: channel://pear.phpunit.de/File_Iterator-1.3.1 install ok: channel://pear.phpunit.de/Text_Template-1.1.1 install ok: channel://pear.phpunit.de/PHP_Timer-1.0.2 install ok: channel://pear.symfony-project.com/YAML-1.0.6 install ok: channel://pear.phpunit.de/PHP_TokenStream-1.1.3 install ok: channel://pear.phpunit.de/PHP_CodeCoverage-1.1.2 install ok: channel://pear.phpunit.de/PHPUnit_MockObject-1.1.1 install ok: channel://pear.phpunit.de/PHPUnit-3.6.11 $ sudo pear install phpunit/DbUnit downloading DbUnit-1.1.2.tgz ... Starting to download DbUnit-1.1.2.tgz (41,895 bytes) ............done: 41,895 bytes install ok: channel://pear.phpunit.de/DbUnit-1.1.2 $ sudo pear install phpunit/PHP_Invoker downloading PHP_Invoker-1.1.0.tgz ... Starting to download PHP_Invoker-1.1.0.tgz (3,727 bytes) ....done: 3,727 bytes install ok: channel://pear.phpunit.de/PHP_Invoker-1.1.0 $ sudo pear install phpunit/PHP_Invoker downloading PHP_Invoker-1.1.0.tgz ... Starting to download PHP_Invoker-1.1.0.tgz (3,727 bytes) ....done: 3,727 bytes install ok: channel://pear.phpunit.de/PHP_Invoker-1.1.0phpunitテストを実行するためにデータベースの準備を行う。
$ sudo mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.24 MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec) mysql> CREATE DATABASE `blogbear` DEFAULT CHARACTER SET 'utf8'; Query OK, 1 row affected (0.00 sec) mysql> CREATE DATABASE `blogbeartest` DEFAULT CHARACTER SET 'utf8'; Query OK, 1 row affected (0.00 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | blogbear | | blogbeartest | | mysql | | performance_schema | | test | +--------------------+ 6 rows in set (0.00 sec) mysql> quit Byeデータベースblogbearにpostsテーブルを作成しダミーデータを投入する。
$ sudo mysql blogbear
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.5.24 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE TABLE posts (
-> id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
-> title VARCHAR(50),
-> body TEXT,
-> created DATETIME DEFAULT NULL,
-> modified DATETIME DEFAULT NULL
-> );
Query OK, 0 rows affected (0.04 sec)
mysql> INSERT INTO posts (title,body,created)
-> VALUES ('タイトル', 'これは、記事の本文です。', NOW());
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO posts (title,body,created)
-> VALUES ('またタイトル', 'そこに本文が続きます。', NOW());
Query OK, 1 row affected (0.01 sec)
mysql> INSERT INTO posts (title,body,created)
-> VALUES ('タイトルの逆襲', 'こりゃ本当に面白そう！うそ。', NOW());
Query OK, 1 row affected (0.01 sec)
mysql> show tables;
+--------------------+
| Tables_in_blogbear |
+--------------------+
| posts |
+--------------------+
1 row in set (0.00 sec)
mysql> select * from posts;
+----+-----------------------+--------------------------------------------+---------------------+----------+
| id | title | body | created | modified |
+----+-----------------------+--------------------------------------------+---------------------+----------+
| 1 | タイトル | これは、記事の本文です。 | 2012-07-08 10:17:18 | NULL |
| 2 | またタイトル | そこに本文が続きます。 | 2012-07-08 10:17:18 | NULL |
| 3 | タイトルの逆襲 | こりゃ本当に面白そう！うそ。 | 2012-07-08 10:17:19 | NULL |
+----+-----------------------+--------------------------------------------+---------------------+----------+
3 rows in set (0.00 sec)
mysql> quit
Bye
データベースblogbeartestにpostsテーブルを作成する。$ sudo mysql blogbeartest
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.5.24 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE TABLE posts (
-> id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
-> title VARCHAR(50),
-> body TEXT,
-> created DATETIME DEFAULT NULL,
-> modified DATETIME DEFAULT NULL
-> );
Query OK, 0 rows affected (0.03 sec)
mysql> show tables;
+------------------------+
| Tables_in_blogbeartest |
+------------------------+
| posts |
+------------------------+
1 row in set (0.00 sec)
mysql> quit
Bye
テスト実行準備が終わったのでphpunitテストを実行する。$ cd ~/BEAR/BEAR.Sunday $ phpunit PHPUnit 3.6.11 by Sebastian Bergmann. The Xdebug extension is not loaded. No code coverage will be generated. run:sandbox mode=Dev cahce=enable ............................................. Time: 4 seconds, Memory: 17.25Mb OK (45 tests, 55 assertions)sandboxを実際にビルトインサーバーで実行して挙動をブラウザから確認する。
$ php -S localhost:8088 web.php PHP 5.4.4 Development Server started at Sun Jul 8 10:57:08 2012 Listening on localhost:8088 Document root is /home/shige/BEAR/BEAR.Sunday/apps/sandbox/htdocs Press Ctrl-C to quit. [Sun Jul 8 10:57:26 2012] run:sandbox mode=Dev cahce=enable [Sun Jul 8 10:57:26 2012] ::1:42119 [200]: /assets/css/bootstrap.css [Sun Jul 8 10:57:26 2012] ::1:42120 [200]: /assets/css/bootstrap-responsive.css [Sun Jul 8 10:57:26 2012] ::1:42121 [200]: /assets/js/jquery.js [Sun Jul 8 10:57:26 2012] ::1:42122 [200]: /assets/js/bootstrap-tooltip.js [Sun Jul 8 10:57:26 2012] ::1:42123 [200]: /assets/js/bootstrap-popover.js [Sun Jul 8 10:57:26 2012] ::1:42124 [200]: /assets/js/bootstrap-collapse.js [Sun Jul 8 10:57:26 2012] ::1:42125 [200]: /assets/js/bootstrap-tab.js [Sun Jul 8 10:57:26 2012] ::1:42126 [200]: /assets/ico/favicon.ico [Sun Jul 8 10:57:26 2012] ::1:42128 [200]: /assets/img/glyphicons-halflings.png [Sun Jul 8 10:57:26 2012] ::1:42129 [200]: /assets/ico/favicon.ico [Sun Jul 8 10:58:03 2012] run:sandbox mode=Dev cahce=enable [Sun Jul 8 10:58:03 2012] ::1:42133 [200]: /assets/css/bootstrap.css [Sun Jul 8 10:58:03 2012] ::1:42134 [200]: /assets/js/bootstrap-tooltip.js [Sun Jul 8 10:58:03 2012] ::1:42135 [200]: /assets/js/bootstrap-popover.js [Sun Jul 8 10:58:03 2012] ::1:42136 [200]: /assets/js/bootstrap-collapse.js [Sun Jul 8 10:58:03 2012] ::1:42137 [200]: /assets/js/bootstrap-tab.js ・・・以下略ブラウザからアクセスしてページ内容を確認。
public class AndroidExtendedTestCase extends AndroidTestCase {
public Context getExTestContext() {
Context context = null;
@SuppressWarnings("unchecked")
Class clz = (Class) this.getClass();
try {
Method method = clz.getMethod("getTestContext");
context = (Context) method.invoke(this);
} catch (SecurityException e) {
fail();
} catch (NoSuchMethodException e) {
fail();
} catch (IllegalArgumentException e) {
fail();
} catch (IllegalAccessException e) {
fail();
} catch (InvocationTargetException e) {
fail();
}
return context;
}
}
AssetManager assetMgr = getExTestContext().getAssets(); // filenameはassetsファイル以下相対パスを指定 InputStream is = new InputStream(assetMgr.open(filename));
export JAVA_HOME=/Library/Java/Home export ANT_HOME=/usr/share/java/ant-1.8.2 export GROOVY_HOME=/Library/Frameworks/Groovy.framework/Versions/Current export PATH=$PATH:/Developer/android-sdk-mac_x86/platform-tools export PATH=$PATH:$GROOVY_HOME/binそして確認。
MacBook:~ kaepapa$ source .bash_profile MacBook:~ kaepapa$ groovy -version Groovy Version: 1.8.1 JVM: 1.6.0_26
public function getCalendarEntryList() {
try{
$gcal = Zend_Gdata_Calendar::AUTH_SERVICE_NAME;
$client =Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, $gcal);
$gcal = new Zend_Gdata_Calendar($client);
$query = $gcal->newEventQuery();
$query->setUser('default');
$query->setVisibility('private');
$query->setProjection('full');
$query->setOrderby('starttime');
$feed=$gcal->getCalendarEventFeed($query);
$data['title'] = (string)$feed->title;
$data['totalResults'] = (String)$feed->totalResults;
$events = array();
foreach ($feed as $event) {
$obj = new stdClass;
$obj->title = $event->title;
$when = $event->when;
$obj->when = date('Y/n/j',strtotime($when[0]->getStartTime()));
$obj->startTime = date('G:i',strtotime($when[0]->getStartTime()));
$obj->endTime = date('G:i',strtotime($when[0]->getEndTime()));
$reminders = $when[0]->reminders;
if (count($reminders)!=0) {
foreach ($reminders as $reminder) {
if ($reminder->getMethod()=='email') {
$obj->reminder_email = $reminder->getMinutes();
} else {
$obj->reminder_alert = $reminder->getMinutes();
}
}
}
$obj->content = $event->content;
$obj->edit_key = $event->id;
$where = $event->where;
$obj->where = $where[0]->getValueString();
$events[] = $obj;
}
$data['events'] = $events;
}catch(Exception $e){
echo "エラー:".$e->getMessage();
}
return $data;
}
public function deleteEntry() {
try {
$gcal = Zend_Gdata_Calendar::AUTH_SERVICE_NAME;
$client =Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, $gcal);
$gcal = new Zend_Gdata_Calendar($client);
$edit_key = $this->input->post('edit_key', TRUE);
if (isset($edit_key)) {
$event = $gcal->getCalendarEventEntry('http://www.google.com/calendar/feeds/default/private/full/'.$edit_key);
$event->delete();
}
}catch(Exception $e){
echo "エラー:".$e->getMessage();
}
}
public function add_entry() {
try {
$gcal = Zend_Gdata_Calendar::AUTH_SERVICE_NAME;
$client =Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, $gcal);
$gcal = new Zend_Gdata_Calendar($client);
$dates = explode('/', $this->input->post('when', TRUE));
$stimes = explode(':', $this->input->post('start_time', TRUE));
$etimes = explode(':', $this->input->post('end_time', TRUE));
date_default_timezone_set('Asia/Tokyo');
$stime = date(DATE_RFC3339, mktime($stimes[0],$stimes[1],0,$dates[1],$dates[2],$dates[0]));
$etime = date(DATE_RFC3339, mktime($etimes[0],$etimes[1],0,$dates[1],$dates[2],$dates[0]));
$event = $gcal->newEventEntry();
$event->title = $gcal->newTitle($this->input->post('title', TRUE));
$when = $gcal->newWhen();
$when->startTime = $stime;
$when->endTime = $etime;
if (isset($_POST['reminder_cbox'])) {
$time = $this->input->post('reminder_time', TRUE);
$method = $this->input->post('reminder', TRUE);
$reminders = array();
switch ($method) {
case 'm':
$reminder = $gcal->newReminder();
$reminder->method = "email";
$reminder->minutes = $time;
$reminders[] = $reminder;
break;
case 'p':
$reminder = $gcal->newReminder();
$reminder->method = "alert";
$reminder->minutes = $time;
$reminders[] = $reminder;
break;
case 'mp':
$reminder = $gcal->newReminder();
$reminder->method = "email";
$reminder->minutes = $time;
$reminders[] = $reminder;
$reminder = $gcal->newReminder();
$reminder->method = "alert";
$reminder->minutes = $time;
$reminders[] = $reminder;
break;
}
$when->reminders = $reminders;
}
$event->when = array($when);
$event->where = array($gcal->newWhere($this->input->post('where', TRUE)));
$event->content = $gcal->newContent($this->input->post('content', TRUE));
$newEvent = $gcal->insertEvent($event);
}catch(Exception $e){
echo "エラー:".$e->getMessage();
}
}
public function correct_entry() {
try {
$gcal = Zend_Gdata_Calendar::AUTH_SERVICE_NAME;
$client =Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, $gcal);
$gcal = new Zend_Gdata_Calendar($client);
$dates = explode('/', $this->input->post('when', TRUE));
$stimes = explode(':', $this->input->post('start_time', TRUE));
$etimes = explode(':', $this->input->post('end_time', TRUE));
date_default_timezone_set('Asia/Tokyo');
$stime = date(DATE_RFC3339, mktime($stimes[0],$stimes[1],0,$dates[1],$dates[2],$dates[0]));
$etime = date(DATE_RFC3339, mktime($etimes[0],$etimes[1],0,$dates[1],$dates[2],$dates[0]));
$event = $gcal->getCalendarEventEntry($this->input->post('edit_key', TRUE));
$event->title = $gcal->newTitle($this->input->post('title', TRUE));
$when = $gcal->newWhen();
$when->startTime = $stime;
$when->endTime = $etime;
if (isset($_POST['reminder_cbox'])) {
$time = $this->input->post('reminder_time', TRUE);
$method = $this->input->post('reminder', TRUE);
$reminders = array();
switch ($method) {
case 'm':
$reminder = $gcal->newReminder();
$reminder->method = "email";
$reminder->minutes = $time;
$reminders[] = $reminder;
break;
case 'p':
$reminder = $gcal->newReminder();
$reminder->method = "alert";
$reminder->minutes = $time;
$reminders[] = $reminder;
break;
case 'mp':
$reminder = $gcal->newReminder();
$reminder->method = "email";
$reminder->minutes = $time;
$reminders[] = $reminder;
$reminder = $gcal->newReminder();
$reminder->method = "alert";
$reminder->minutes = $time;
$reminders[] = $reminder;
break;
}
$when->reminders = $reminders;
}
$event->when = array($when);
$event->where = array($gcal->newWhere($this->input->post('where', TRUE)));
$event->content = $gcal->newContent($this->input->post('content', TRUE));
$event->save();
}catch(Exception $e){
echo "エラー:".$e->getMessage();
}
}
<atom:id>http://www.google.com/calendar/feeds/default/private/full/57a84t1b243radd31209erdd9k≷/atom:id> <atom:link href="http://www.google.com/calendar/event?eid=NTdhODR0MWIyNDNyYWRkMzEyMDllcmRkOWtfMjAxMDEyMjdUMDIzMDAwWiB0ZXN0LmthZXBhcGFAbQ" rel="alternate" type="text/html" title="alternate"/> <atom:link href="http://www.google.com/calendar/feeds/default/private/full/57a84t1b243radd31209erdd9k" rel="self" type="application/atom+xml"/> <atom:link href="http://www.google.com/calendar/feeds/default/private/full/57a84t1b243radd31209erdd9k/63429101549" rel="edit" type="application/atom+xml"/>
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Calendar extends Controller {
public function __construct() {
parent::Controller();
$this->output->set_header('Content-Type: text/html; charset=UTF-8');
}
/*
* デフォルトメソッド
*/
public function index() {
$this->load->view('view');
}
}
/* End of file calendar.php */
/* Location: ./system/application/controllers/calendar.php */
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Googleカレンダー予定一覧</title>
<style type="text/css">
body {
font-family: Verdana;
}
li {
border-bottom: solid black 1px;
margin: 10px;
padding: 2px;
width: auto;
padding-bottom: 20px;
}
h2 {
color: red;
text-decoration: none;
}
span.attr {
font-weight: bolder;
}
</style>
</head>
<body>
<?php
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Calendar');
Zend_Loader::loadClass('Zend_Http_Client');
$gcal = Zend_Gdata_Calendar::AUTH_SERVICE_NAME;
$user = "username@gmail.com";
$pass = "password";
$client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $gcal);
$gcal = new Zend_Gdata_Calendar($client);
$query = $gcal->newEventQuery();
$query->setUser('default');
$query->setVisibility('private');
$query->setProjection('basic');
$query->setOrderby('starttime');
if(isset($_GET['q'])) {
$query->setQuery($_GET['q']);
}
try {
$feed = $gcal->getCalendarEventFeed($query);
} catch (Zend_Gdata_App_Exception $e) {
echo "Error: " . $e->getResponse();
}
?>
<h1><?php echo $title ?></h1>
<?php echo $totalResults ?> 件の予定があります。
<p/>
<ol>
<?php
foreach ($feed as $event) {
echo "<li>\n";
echo "<h2>" . stripslashes($event->title) . "</h2>\n";
echo stripslashes($event->summary) . " <br/>\n";
$id = substr($event->id, strrpos($event->id, '/')+1);
echo "<a href=\"edit.php?id=$id\">編集</a> | ";
echo "<a href=\"delete.php?id=$id\">削除</a> <br/>\n";
echo "</li>\n";
}
echo "</ul>";
?>
</ol>
<p/>
<a href="add.php">新しいイベントを追加</a><p/>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get">
予定の検索：<br/>
<input type="text" name="q" size="10"/>
<input type="submit" name="submit" value="検索"/>
</form>
</body>
</html>
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Calendar_model extends Model {
private $user;
private $pass;
public function __construct() {
parent::Model();
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Calendar');
Zend_Loader::loadClass('Zend_Http_Client');
$this->config->load('calendar_config', TRUE);
$this->user = $this->config->item('username','calendar_config');
$this->pass = $this->config->item('password','calendar_config');
}
public function getCalendarEntryList() {
try{
$gcal = Zend_Gdata_Calendar::AUTH_SERVICE_NAME;
$client =Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, $gcal);
$gcal = new Zend_Gdata_Calendar($client);
$query = $gcal->newEventQuery();
$query->setUser('default');
$query->setVisibility('private');
$query->setProjection('basic');
$query->setOrderby('starttime');
$feed=$gcal->getCalendarEventFeed($query);
$data['title'] = (string)$feed->title;
$data['totalResults'] = (String)$feed->totalResults;
$events = array();
foreach ($feed as $event) {
$obj = new stdClass;
$obj->title = $event->title;
$obj->summary = $event->summary;
$obj->id = $event->id;
$events[] = $obj;
}
$data['events'] = $events;
}catch(Zend_Gdata_App_Exception $e){
echo "エラー:".$e->getResponse();
}
return $data;
}
}
/* End of file calendar_model.php */
/* Location: ./system/application/model/calendar_model.php */
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Calendar extends Controller {
public function __construct() {
parent::Controller();
$this->load->model('calendar_model');
$this->output->set_header('Content-Type: text/html; charset=UTF-8');
}
/*
* デフォルトメソッド
*/
public function index() {
$data = $this->calendar_model->getCalendarEntryList();
$this->load->view('calendar_index',$data);
}
}
/* End of file calendar.php */
/* Location: ./system/application/controllers/calendar.php */
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Googleカレンダー予定一覧</title>
<style type="text/css">
body {
font-family: Verdana;
}
li {
border-bottom: solid black 1px;
margin: 10px;
padding: 2px;
width: auto;
padding-bottom: 20px;
}
h2 {
color: red;
text-decoration: none;
}
span.attr {
font-weight: bolder;
}
</style>
</head>
<body>
<h1><?php echo $title ?></h1>
<?php echo $totalResults ?> 件の予定があります。
<p/>
<ol>
<?php
foreach ($events as $e) {
echo "<li>\n";
echo "<h2>" . stripslashes($e->title) . "</h2>\n";
echo stripslashes($e->summary) . " <br/>\n";
$id = substr($e->id, strrpos($e->id, '/')+1);
echo "<a href=\"edit.php?id=$id\">編集</a> | ";
echo "<a href=\"delete.php?id=$id\">削除</a> <br/>\n";
echo "</li>\n";
}
echo "</ul>";
?>
</ol>
<p/>
<a href="add.php">新しいイベントを追加</a><p/>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get">
予定の検索：<br/>
<input type="text" name="q" size="10"/>
<input type="submit" name="submit" value="検索"/>
</form>
</body>
</html>
$group_data = $this->gdata_groups_model->getGroupsElement();
foreach ($xml->groupMembershipInfo as $g) {
foreach ($group_data as $key => $val) {
if ($key == $g['href']) {
$obj->groups[] = $val;
}
}
}
// add group elements
$groups = $this->input->post('groups', TRUE);
foreach ($groups as $g) {
$group = $doc->createElement('gContact:groupMembershipInfo');
$group->setAttribute('deleted','false');
$group->setAttribute('href',$g);
$entry->appendChild($group);
}
// add group elements
$groups = $this->input->post('groups', TRUE);
foreach ($groups as $g) {
$group = $doc->createElement('groupMembershipInfo');
$group->setAttribute('xmlns','http://schemas.google.com/contact/2008');
$group->setAttribute('deleted','false');
$group->setAttribute('href',$g);
$entry->appendChild($group);
}
function set_value($field = '', $default = '') {
if ( ! isset($this->_field_data[$field]))
{
return $default;
}
if ( ! isset($this->_field_data[$field]['postdata'])) {
return $default;
} else {
return $this->_field_data[$field]['postdata'];
}
}
set_value('edit', $this->input->post('edit'));
if ($this->form_validation->run('contacts') == TRUE) {
$this->gdata_model->post();
$data = $this->gdata_model->getContactsList();
$this->load->view('contacts_index', $data);
} else {
$this->load->view('form_contacts_view', $this->gdata_model->getFormData());
}
try {
// perform login and set protocol version to 3.0
$client = Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, 'cp');
$gdata = new Zend_Gdata($client);
$gdata->setMajorProtocolVersion(3);
// perform query and get feed of all results
$query = new Zend_Gdata_Query('http://www.google.com/m8/feeds/groups/default/full');
$query->maxResults = 0;
$query->setParam('orderby', 'lastmodified');
$query->setParam('sortorder', 'descending');
$feed = $gdata->getFeed($query);
$data['title'] = (string)$feed->id;
$data['totalResults'] = (String)$feed->totalResults;
// parse feed and extract contact information
// into simpler objects
$groups = array();
foreach($feed as $entry){
$obj = new stdClass;
$xml = simplexml_load_string($entry->getXML());
if (! isset($xml->systemGroup)) {
$obj->edit = (string)$entry->getEditLink()->href;
$obj->group_name = (string) $entry->title;
} else {
$obj->edit = 'system_group';
$val = $this->config->item('system_groups','config_contacts');
$obj->group_name = $val[(string)$xml->systemGroup['id']];
}
$groups[] = $obj;
}
} catch (Exception $e) {
die('ERROR:' . $e->getMessage());
}
$data['groups'] = $groups;
return $data;
try {
// perform login and set protocol version to 3.0
$client = Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, 'cp');
$gdata = new Zend_Gdata($client);
$gdata->setMajorProtocolVersion(3);
// create new entry
$doc = new DOMDocument();
$doc->formatOutput = true;
$entry = $doc->createElement('atom:entry');
$entry->setAttributeNS('http://www.w3.org/2000/xmlns/' ,'xmlns:atom', 'http://www.w3.org/2005/Atom');
$entry->setAttributeNS('http://www.w3.org/2000/xmlns/' ,'xmlns:gd', 'http://schemas.google.com/g/2005');
$doc->appendChild($entry);
// add category element
$category = $doc->createElement('atom:category');
$category->setAttribute('scheme', 'http://schemas.google.com/g/2005#kind');
$category->setAttribute('term','http://schemas.google.com/contact/2008#group');
$entry->appendChild($category);
// add title element
$title = $doc->createElement('atom:title', $this->input->post('group_name', TRUE));
$title->setAttribute('type', 'text');
$entry->appendChild($title);
$entryResult = $gdata->insertEntry( $doc->saveXML(), 'https://www.google.com/m8/feeds/groups/default/full');
} catch (Exception $e) {
die('ERROR:' . $e->getMessage());
}
return $entryResult->id;
try {
// perform login and set protocol version to 3.0
$client = Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, 'cp');
// set GData delete headers
$client->setHeaders('If-Match: *');
$gdata = new Zend_Gdata($client);
$gdata->setMajorProtocolVersion(3);
// delete entry
$gdata->delete($this->input->post('edit',TRUE));
} catch (Exception $e) {
die('ERROR:' . $e->getMessage());
}
try {
// perform login and set protocol version to 3.0
$client = Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, 'cp');
$client->setHeaders('If-Match: *');
$gdata = new Zend_Gdata($client);
$gdata->setMajorProtocolVersion(3);
$query = new Zend_Gdata_Query($this->input->post('edit'));
$entry = $gdata->getEntry($query);
$xml = simplexml_load_string($entry->getXML());
$xml->title = $this->input->post('group_name');
$entryResult = $gdata->updateEntry($xml->saveXML(), $entry->getEditLink()->href);
} catch (Exception $e) {
die('ERROR:' . $e->getMessage());
}
return $entryResult->id;
$obj->edit = (string)$entry->getEditLink()->href;
// perform login and set protocol version to 3.0
$client = Zend_Gdata_ClientLogin::getHttpClient($this->user, $this->pass, 'cp');
$client->setHeaders('If-Match: *');
$gdata = new Zend_Gdata($client);
$gdata->setMajorProtocolVersion(3);
$query = new Zend_Gdata_Query($this->input->post('edit'));
$org_entry = $gdata->getEntry($query);
$xml = simplexml_load_string($org_entry->getXML());
// create new entry
$doc = new DOMDocument();
$doc->formatOutput = true;
$entry = $doc->createElement('atom:entry');
$entry->setAttributeNS('http://www.w3.org/2000/xmlns/' ,'xmlns:atom', 'http://www.w3.org/2005/Atom');
$doc->appendChild($entry);
// add name element
$name = $doc->createElement('name');
$name->setAttribute('xmlns', 'http://schemas.google.com/g/2005');
$entry->appendChild($name);
//input->post()メソッドを利用してXSS対策
$fullName = $doc->createElement('fullName', $this->input->post('name', TRUE));
$name->appendChild($fullName);
// add org name element
$org = $doc->createElement('organization');
$org->setAttribute('xmlns', 'http://schemas.google.com/g/2005');
$org->setAttribute('rel' ,'http://schemas.google.com/g/2005#work');
$entry->appendChild($org);
$orgName = $doc->createElement('orgName', $this->input->post('org', TRUE));
$org->appendChild($orgName);
// add email elements
$emails = $this->input->post('email', TRUE);
$epleces = $this->input->post('email_place', TRUE);
foreach ($emails as $key => $e) {
if ($e != '') {
$email = $doc->createElement('email');
$email->setAttribute('xmlns','http://schemas.google.com/g/2005');
if ($epleces[$key] == 'custom') {
$email->setAttribute('label', $this->input->post('email_custom', TRUE));
} else {
$email->setAttribute('rel', 'http://schemas.google.com/g/2005#' . $epleces[$key]);
}
$email->setAttribute('address', $e);
$entry->appendChild($email);
}
}
// add phone elements
$phones = $this->input->post('phone', TRUE);
$pplaces = $this->input->post('phone_place', TRUE);
foreach ($phones as $key => $p) {
if ($p != '') {
$phone = $doc->createElement('phoneNumber', $p);
$phone->setAttribute('xmlns','http://schemas.google.com/g/2005');
if ($pplaces[$key] == 'custom') {
$phone->setAttribute('label', $this->input->post('phone_custom', TRUE));
} else {
$phone->setAttribute('rel', 'http://schemas.google.com/g/2005#' . $pplaces[$key]);
}
$entry->appendChild($phone);
}
}
// add web elements
$webs =$this->input->post('web', TRUE);
$wplaces = $this->input->post('web_place', TRUE);
foreach ($webs as $key => $w) {
if ($w != '') {
$web = $doc->createElement('website');
$web->setAttribute('xmlns','http://schemas.google.com/contact/2008');
$web->setAttribute('href',$w);
if ($wplaces[$key] == 'custom') {
$web->setAttribute('label', $this->input->post('web_custom', TRUE));
} else {
$web->setAttribute('rel', $wplaces[$key]);
}
$entry->appendChild($web);
}
}
foreach ($org_entry->category as $category) {
$categorys = $doc->createElement('atom:category');
$categorys->setAttribute('term', $category->getTerm());
$categorys->setAttribute('scheme', $category->getScheme());
$entry->appendChild($categorys);
}
$id = $doc->createElement('atom:id', $org_entry->id);
$entry->appendChild($id);
foreach ($org_entry->link as $link) {
$links = $doc->createElement('atom:link');
$links->setAttribute('href', $link->getHref());
$links->setAttribute('rel', $link->getRel());
$links->setAttribute('type', $link->getType());
$entry->appendChild($links);
}
$title = $doc->createElement('atom:title',$this->input->post('name', TRUE));
$entry->appendChild($title);
$updated = $doc->createElement('atom:updated', $org_entry->updated);
$entry->appendChild($updated);
$edited = $doc->createElement('atom:edited', $org_entry->edited);
$entry->appendChild($edited);
$entryResult = $gdata->updateEntry($entry_data, $org_entry->getEditLink()>href);
<script language="JavaScript">
<!--
function check(){
if(window.confirm('削除して宜しいですか？')){
return true;
} else {
window.alert('削除を中止しました。');
return false;
}
}
//-->
<div class="name">
<?php echo $r->name; ?>
<span class="links">
<?php echo form_open('contacts/delete','onSubmit="return check()"'); ?>
<?php echo form_hidden('id',$r->edit)?>
<?php echo form_submit('submit', '削除'); ?>
<?php echo form_close(); ?>
</span>
</div>
public function delete() {
$this-<gdata_model-<delete();
$data = $this-<gdata_model-<getContactsList();
$this-<load-<view('contacts-index', $data);
}
public function delete() {
try {
// perform login and set protocol version to 3.0
$client = Zend_Gdata_ClientLogin::getHttpClient($this-<user, $this-<pass, 'cp');
// set GData delete headers
$client-<setHeaders('If-Match: *');
$gdata = new Zend_Gdata($client);
$gdata-<setMajorProtocolVersion(3);
// delete entry
$gdata-<delete($this-<input-<post('id',TRUE));
} catch (Exception $e) {
die('ERROR:' . $e-<getMessage());
}
}