Yammy日記

_ [EC-CUBE][OpenSource][Software] EC-CUBE用のカレンダーブロックを作成

PEAR::Calendarを使って作ってみた。

事前にデータベースにテーブル作成＆データINSERT

INSERT INTO dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) 
VALUES ('カレンダー', 'bloc/calendar.tpl', 'calendar', 'frontparts/bloc/calendar.php', 1, now(), now());
CREATE TABLE dtb_holiday (
    holiday_id serial NOT NULL,
    title text NOT NULL,
    month int2 NOT NULL,
    day int2 NOT NULL,
    rank int4 NOT NULL DEFAULT 0,
    creator_id int4 NOT NULL,
    create_date timestamp NOT NULL DEFAULT now(),
    update_date timestamp NOT NULL,
    del_flg  int2 NOT NULL DEFAULT 0
);
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('元旦(1月1日)','1', '1' ,100, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('成人の日(1月第2月曜日)','1', '14' ,98, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('建国記念の日(2月11日)','2', '11' ,96, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('春分の日(3月21日)','3', '21' ,94, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('昭和の日(4月29日)','4', '29' ,92, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('憲法記念日(5月3日)','5', '3' ,90, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('みどりの日(5月4日)','5', '4' ,88, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('こどもの日(5月5日)','5', '5' ,86, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('海の日(7月第3月曜日)','7', '21' ,84, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('敬老の日(9月第3月曜日)','9', '15' ,82, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('秋分の日(9月23日)','9', '23' ,80, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('体育の日(10月第2月曜日)','10', '13' ,78, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('文化の日(11月3日)','11', '3' ,76, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('勤労感謝の日(11月23日)','11', '23' ,74, 0, now(), 0, now());
INSERT INTO dtb_holiday (title, month, day, rank, creator_id, update_date, del_flg, create_date)
VALUES ('天皇誕生日(12月23日)','12', '23' ,72, 0, now(), 0, now());

後はコミットした以下のファイルを https://svn.ec-cube.net/open/branches/version-2/ より取得すれば完了。

data/Smarty/templates/default/admin/basis/holiday.tpl
data/Smarty/templates/default/admin/basis/subnavi.tpl
data/Smarty/templates/default/bloc/calendar.tpl
data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php
data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Calendar.php
data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Holiday_Ex.php
data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Calendar_Ex.php
data/module/Calendar
html/admin/basis/holiday.php
html/frontparts/bloc/calendar.php
html/install/sql/create_table_mysql.sql
html/install/sql/create_table_pgsql.sql
html/install/sql/insert_data.sql
html/user_data/packages/default/css/index.css