intra-mart Accel Kaiden! プログラミングガイド 第16版 2022-03-31

4.3.2.2. ガジェットマスタデータ作成

4.3.2.2.1. 申請書ガジェットマスタデータの作成

申請書ガジェットマスタデータを作成します。
利用するデータベースに合わせて、次のいずれかのInsert文を実行します。
このデータを登録することで、申請書マスタメンテナンス画面でこれから作成する「チュートリアルガジェット」を申請書にセットすることができます

コラム

詳細は「申請書ガジェットマスタデータについて」を参照してください。

4.3.2.2.1.1. Oracle Database/PostgreSQL

-- 申請書ガジェット
insert into k10m_gadget(gadget_class, gadget_variation, jsp_path, java_path, sort_key, surface_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', '/WEB-INF/view/kaiden2/tutorial/gadget/gadgetTutorial/gadgetTutorialV01.jsp', 'jp.co.slcs.kaiden2.tutorial.feature.logic.kaiden.gadget.tutorial.GadgetTutorialV01Logic', '531', 'chapterTitle', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
-- 申請書ガジェット概要
insert into k10m_gadget_description(gadget_class, gadget_variation, locale_id, description, gadget_name, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'en', 'Tutorial is gadgets.', 'Tutorial gadgets', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_description(gadget_class, gadget_variation, locale_id, description, gadget_name, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'ja', 'チュートリアルガジェットです。', 'チュートリアルガジェット', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_description(gadget_class, gadget_variation, locale_id, description, gadget_name, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'zh_CN', '教程小玩意。', '教程小工具', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
-- 申請書ガジェットタグ
insert into k10m_gadget_tags(gadget_class, gadget_variation, gadget_tag, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'appAdvance', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_tags(gadget_class, gadget_variation, gadget_tag, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'appNormal', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_tags(gadget_class, gadget_variation, gadget_tag, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'appSettle', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
-- 申請書ガジェットサーフェス
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'chapterTitle', 'en', 'Tutorial gadgets', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'chapterTitle', 'ja', 'チュートリアルガジェット', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'chapterTitle', 'zh_CN', '教程小工具', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialText', 'en', 'Text', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialText', 'ja', 'テキスト', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialText', 'zh_CN', '文本', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialAmount', 'en', 'Amount', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialAmount', 'ja', '金額', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialAmount', 'zh_CN', '金額', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
-- 申請書ガジェットブロック
insert into k10m_gadget_block(gadget_class, gadget_variation, gadget_block, gadget_block_type, sort_key, surface_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialTable', 'normal', '1 ', 'chapterTitle', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
-- 申請書ガジェットフィールドグループ
insert into k10m_gadget_fld_grp(gadget_class, gadget_variation, gadget_block, field_group_id, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialTable', 'tutorialText', 'tutorialText', '1', '0', '101 ', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_fld_grp(gadget_class, gadget_variation, gadget_block, field_group_id, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialTable', 'tutorialAmount', 'tutorialAmount', '1', '0', '102 ', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
-- 申請書ガジェットフィールド
insert into k10m_gadget_field(gadget_class, gadget_variation, gadget_block, field_group_id, field_key, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialTable', 'tutorialText', 'tutorialTextSurface', 'tutorialText', 'a', 'a', '10101 ', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_field(gadget_class, gadget_variation, gadget_block, field_group_id, field_key, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialTable', 'tutorialText', 'tutorialText', 'tutorialText', 'z', 'z', '10102 ', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_field(gadget_class, gadget_variation, gadget_block, field_group_id, field_key, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialTable', 'tutorialAmount', 'tutorialAmountSurface', 'tutorialAmount', 'a', 'a', '10201 ', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');
insert into k10m_gadget_field(gadget_class, gadget_variation, gadget_block, field_group_id, field_key, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values ('tutorial', 'v01', 'tutorialTable', 'tutorialAmount', 'tutorialAmount', 'tutorialAmount', 'z', 'z', '10202 ', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system', '1', to_timestamp('2015-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss'), 'system');

4.3.2.2.1.2. Microsoft SQL Server

-- 申請書ガジェット
insert into k10m_gadget(gadget_class, gadget_variation, jsp_path, java_path, sort_key, surface_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'/WEB-INF/view/kaiden2/tutorial/gadget/gadgetTutorial/gadgetTutorialV01.jsp', N'jp.co.slcs.kaiden2.tutorial.feature.logic.kaiden.gadget.tutorial.GadgetTutorialV01Logic', N'531', N'chapterTitle', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
-- 申請書ガジェット概要
insert into k10m_gadget_description(gadget_class, gadget_variation, locale_id, description, gadget_name, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'en', N'Tutorial is gadgets.', N'Tutorial gadgets', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_description(gadget_class, gadget_variation, locale_id, description, gadget_name, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'ja', N'チュートリアルガジェットです。', N'チュートリアルガジェット', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_description(gadget_class, gadget_variation, locale_id, description, gadget_name, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'zh_CN', N'教程小玩意。', N'教程小工具', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
-- 申請書ガジェットタグ
insert into k10m_gadget_tags(gadget_class, gadget_variation, gadget_tag, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'appAdvance', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_tags(gadget_class, gadget_variation, gadget_tag, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'appNormal', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_tags(gadget_class, gadget_variation, gadget_tag, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'appSettle', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
-- 申請書ガジェットサーフェス
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'chapterTitle', N'en', N'Tutorial gadgets', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'chapterTitle', N'ja', N'チュートリアルガジェット', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'chapterTitle', N'zh_CN', N'教程小工具', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialText', N'en', N'Text', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialText', N'ja', N'テキスト', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialText', N'zh_CN', N'文本', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialAmount', N'en', N'Amount', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialAmount', N'ja', N'金額', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_surface(gadget_class, gadget_variation, surface_key, locale_id, surface, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialAmount', N'zh_CN', N'金額', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
-- 申請書ガジェットブロック
insert into k10m_gadget_block(gadget_class, gadget_variation, gadget_block, gadget_block_type, sort_key, surface_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialTable', N'normal', N'1 ', N'chapterTitle', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
-- 申請書ガジェットフィールドグループ
insert into k10m_gadget_fld_grp(gadget_class, gadget_variation, gadget_block, field_group_id, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialTable', N'tutorialText', N'tutorialText', N'1', N'0', N'101 ', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_fld_grp(gadget_class, gadget_variation, gadget_block, field_group_id, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialTable', N'tutorialAmount', N'tutorialAmount', N'1', N'0', N'102 ', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
-- 申請書ガジェットフィールド
insert into k10m_gadget_field(gadget_class, gadget_variation, gadget_block, field_group_id, field_key, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialTable', N'tutorialText', N'tutorialTextSurface', N'tutorialText', N'a', N'a', N'10101 ', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_field(gadget_class, gadget_variation, gadget_block, field_group_id, field_key, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialTable', N'tutorialText', N'tutorialText', N'tutorialText', N'z', N'z', N'10102 ', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_field(gadget_class, gadget_variation, gadget_block, field_group_id, field_key, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialTable', N'tutorialAmount', N'tutorialAmountSurface', N'tutorialAmount', N'a', N'a', N'10201 ', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');
insert into k10m_gadget_field(gadget_class, gadget_variation, gadget_block, field_group_id, field_key, surface_key, required_type, input_type, sort_key, entry_ts, entry_user_cd, renew_cnt, renew_ts, renew_user_cd) values (N'tutorial', N'v01', N'tutorialTable', N'tutorialAmount', N'tutorialAmount', N'tutorialAmount', N'z', N'z', N'10202 ', '2015-01-01 00:00:00', N'system', '1', '2015-01-01 00:00:00', N'system');