<?php
/*********************************************************************************
 * The Developer of the Code is Technopian, Inc.
 * Portions created by Technopian are Copyright (C) 2004-2008 Technopian, Inc.;.
 * All Rights Reserved.
 * Date: 2005-12-15
 * Contributor(s): Yahya,Metehan,Merdan
 ********************************************************************************/

$dictionary_AN['Course'] = array(
	'table' => 'smsevent', 
	'audited'=>false,
	'fields' =>array (
// internal fields
		'id' => array (
			'name' => 'id',
			'vname' => 'LBL_ID',
			'type' => 'id',
			'required'=>true,
		),
		'deleted' =>array (
			'name' => 'deleted',
			'vname' => 'LBL_DELETED',
			'type' => 'bool',
			'required' => true,
			'default' => '0',
		),
		'category' => array (
			'name' => 'category',			
			'type' => 'varchar',
			'len' => '15',
			'vname' => 'LBL_CATEGORY', 
			'default' => 'course',
		),
// automatically updated fields (shown on detailview, not editable)
		'date_entered' => array (
			'name' => 'date_entered',
			'vname' => 'LBL_DATE_ENTERED',
			'type' => 'datetime',
			'required' => true,
		),
		'date_modified' => array (
			'name' => 'date_modified',
			'vname' => 'LBL_DATE_MODIFIED',
			'type' => 'datetime',
			'required' => true,
		),
		'modified_user_id' => array (
			'name' => 'modified_user_id',
			'vname' => 'LBL_MODIFIED',
			'type' => 'id',
			'required'=>true,
		),
		'created_by' => array (
			'name' => 'created_by',
			'vname' => 'LBL_CREATED',
			'type' => 'id',
			'required'=>true,
		),
		'parent_id'=> array (
			'name' => 'parent_id',
			'vname' => 'LBL_PARENT_ID',
			'type' => 'id',
			'len' => '36',
		),
		
// old fields (varchar length may be changed
		'name' => array (
			'name' => 'name',
			'vname' => 'LBL_NAME',
			'type' => 'varchar',
			'len' => '50',			
			'required' => true,
			'subtable' => 1,
		),
		'shortname' => array (
			'name' => 'shortname',
			'vname' => 'LBL_SHORTNAME',
			'type' => 'varchar',
			'len' => '12',			
		),
		'school_id' => 	array (
			'name' => 'school_id',
			'vname' => '事業所',
			'type' => 'id',
			'len' => '36',
			'table' => 'resource',
		),
		'subtype' => array (
			'name' => 'subtype',
			'vname' => 'LBL_SUBTYPE',
			'type' => 'enum',
			'options' => 'course_subtypes_dom',
		),	
		'common_code' => array (
			'name' => 'common_code',
			'vname' => '講座コード',
			'type' => 'char',
			'len' => '36',
			'hankaku' => true,
		),	
		'description' => array (
			'name' => 'description',
			'vname' => 'LBL_DESCRIPTION',
			'type' => 'text',
			'subtable' => 2,
		),		
		
// new fields		
		'assigned_user_id' => array (
			'name' => 'assigned_user_id',
			'vname' => '担当者',
			'type' => 'id',
			'required'=>true,
		),
		'sakusei_jokyo' => array (
			'name' => 'sakusei_jokyo',
			'vname' => '作成状況',
			'type' => 'enum',
			'len' => '8',
			'options' => 'sakusei_jokyo_options',
			'required'=>true,
			'default' => '作成中',
		),	
		'nenki' => array (
			'name' => 'nenki',
			'vname' => '作成状況',
			'type' => 'enum',
			'len' => '8',
			'options' => 'nenki_options',
			'required'=>true,
		),
		'bumon_code' => array (
			'name' => 'bumon_code',
			'vname' => '講座コード（部門）',
			'type' => 'enum',
			'len' => '2',
			'options' => 'bumon_code_options',
			'required'=>true,
		),
		'course_code' => array (
			'name' => 'course_code',
			'vname' => '講座コード（コース）',
			'type' => 'enum',
			'len' => '2',
			'options' => 'course_code_options',
			'required'=>true,
		),
		'name_furigana' => array (
			'name' => 'name_furigana',
			'vname' => '講座名（カナ）',
			'type' => 'varchar',
			'len' => '50',
			'required'=>true,
			'subtable' => 1,
		),
		'koza_kubun' => array (
			'name' => 'koza_kubun',
			'vname' => '講座区分',
			'type' => 'enum',
			'len' => '8',
			'options' => 'koza_kubun_options',
			'default' => '要入会',
			'required'=>true,
		),
		'customer_chui' => array (
			'name' => 'customer_chui',
			'vname' => 'お客様注意情報（社内向け）',
			'type' => 'text',
			'subtable' => 2,
		),
		'uketsuke_chui' => array (
			'name' => 'uketsuke_chui',
			'vname' => '受付時特記事項（社内向け）',
			'type' => 'text',
			'subtable' => 2,
		),
		'shanai_mochimono' => array (
			'name' => 'shanai_mochimono',
			'vname' => 'ご案内事項１　持ち物など',
			'type' => 'text',
			'subtable' => 2,
		),
		'shanai_ryui' => array (
			'name' => 'shanai_ryui',
			'vname' => 'ご案内事項2　留意事項',
			'type' => 'text',
			'subtable' => 2,
		),
		'shanai_henko' => array (
			'name' => 'shanai_henko',
			'vname' => 'ご案内事項3　変更情報',
			'type' => 'text',
			'subtable' => 2,
		),
		'tochu_uketuske_kahi' => array (
			'name' => 'tochu_uketuske_kahi',
			'vname' => '途中受講可否',
			'type' => 'enum',
			'len' => '8',
			'options' => 'tochu_uketuske_kahi_options',
		),
		'tochu_uketuske_memo' => array (
			'name' => 'tochu_uketuske_memo',
			'vname' => 'コメント（途中受講可否）',
			'type' => 'varchar',
			'len' => '32',
			'subtable' => 2,
		),
		'kengaku_kahi' => array (
			'name' => 'kengaku_kahi',
			'vname' => '見学可否',
			'type' => 'enum',
			'len' => '8',
			'options' => 'kengaku_kahi_options',
		),
		'kengaku_memo' => array (
			'name' => 'kengaku_memo',
			'vname' => 'コメント（見学可否）',
			'type' => 'varchar',
			'len' => '32',
			'subtable' => 2,
		),
		'trial_kahi' => array (
			'name' => 'trial_kahi',
			'vname' => 'トライアル可否',
			'type' => 'enum',
			'len' => '8',
			'options' => 'trial_kahi_options',
		),
		'trial_memo' => array (
			'name' => 'trial_memo',
			'vname' => 'トライアル可否（途中受講可否）',
			'type' => 'varchar',
			'len' => '32',
			'subtable' => 2,
		),
		'nigon_ongakukai' => array (
			'name' => 'email_opt_out',
			'vname' => '日本音楽著作権協会支払',
			'type' => 'bool',
			'default' => 'off',
		),
		'yagai_kaijo' => array (
			'name' => 'yagai_kaijo',
			'vname' => '屋外会場の使用有無',
			'type' => 'bool',
			'default' => 'off',
		),
		'hoken_ari' => array (
			'name' => 'hoken_ari',
			'vname' => '保険有無',
			'type' => 'bool',
			'default' => 'off',
		),
		'mark1' => array (
			'name' => 'v',
			'vname' => 'マーク1',
			'type' => 'bool',
			'default' => 'off',
		),
		'mark2' => array (
			'name' => 'mark2',
			'vname' => 'マーク2',
			'type' => 'bool',
			'default' => 'off',
		),
		'kaisaishu_hyoji_web' => array (
			'name' => 'kaisaishu_hyoji_web',
			'vname' => '開催週をWeb・パンフに表示',
			'type' => 'bool',
			'default' => 'off',
		),
		'kaisaibi_hyoji_web' => array (
			'name' => 'kaisaibi_hyoji_web',
			'vname' => '開催曜日をWeb・パンフに表示',
			'type' => 'bool',
			'default' => 'off',
		),
		'kaisaijikan_hyoji_web' => array (
			'name' => 'kaisaijikan_hyoji_web',
			'vname' => '開催時間をWeb・パンフに表示',
			'type' => 'bool',
			'default' => 'off',
		),
		'kaisaishu_hyoji_jukoken' => array (
			'name' => 'kaisaishu_hyoji_jukoken',
			'vname' => '開催週と時間を受講券に表示',
			'type' => 'bool',
			'default' => 'off',
		),
		'kyoshitsu_hyoji_jukoken' => array (
			'name' => 'kyoshitsu_hyoji_jukoken',
			'vname' => '教室情報を受講券に表示',
			'type' => 'bool',
			'default' => 'off',
		),
		'hizuke_hyoji_jukoken' => array (
			'name' => 'hizuke_hyoji_jukoken',
			'vname' => '受講券に日程を表示する',
			'type' => 'bool',
			'default' => 'off',
		),
		'jukoryo_shurui' => array (
			'name' => 'jukoryo_shurui',
			'vname' => '受講料（支払単位）',
			'type' => 'enum',
			'len' => '6',
			'options' => 'jukoryo_shurui_options',
		),
		'kaiin_tanka' => array (
			'name' => 'kaiin_tanka',
			'vname' => '会員価格',
			'type' => 'integer',
		),
		'kaiin_tanka_zeikomi' => array (
			'name' => 'kaiin_tanka_zeikomi',
			'vname' => '会員価格（税込）',
			'type' => 'integer',
		),
		'kaiin_tanka_web' => array (
			'name' => 'kaiin_tanka_web',
			'vname' => '会員価格Web出力',
			'type' => 'bool',
			'default' => 'off',
		),
		'hikaiin_tanka' => array (
			'name' => 'hikaiin_tanka',
			'vname' => '非会員会員価格',
			'type' => 'integer',
		),
		'hikaiin_tanka_zeikomi' => array (
			'name' => 'hikaiin_tanka_zeikomi',
			'vname' => '非会員会員価格（税込）',
			'type' => 'integer',
		),
		'hikaiin_tanka_web' => array (
			'name' => 'hikaiin_tanka_web',
			'vname' => '非会員価格Web出力',
			'type' => 'bool',
			'default' => 'off',
		),
		'kyouzaihi_shurui' => array (
			'name' => 'kyouzaihi_shurui',
			'vname' => '教材費（支払単位）',
			'type' => 'enum',
			'len' => '4',
			'options' => 'kyouzaihi_shurui_options',
		),
		'kyouzaihi_henkin' => array (
			'name' => 'kyouzaihi_henkin',
			'vname' => '教材費返金有無',
			'type' => 'bool',
			'default' => 'off',
		),
		'kyouzai_id'=> array (
			'name' => 'kyouzai_id',
			'vname' => '教材',
			'type' => 'id',
			'len' => '36',
		),
		'kyouzai_tanka' => array (
			'name' => 'kyouzai_tanka',
			'vname' => '教材費価格',
			'type' => 'integer',
		),
		'kyouzai_tanka_zeikomi' => array (
			'name' => 'kyouzai_tanka_zeikomi',
			'vname' => '教材費（税込）',
			'type' => 'integer',
		),
		'kyouzai_tanka_web' => array (
			'name' => 'kyouzai_tanka_web',
			'vname' => '教材費Web出力',
			'type' => 'bool',
			'default' => 'off',
		),
		'setsubihi_shurui' => array (
			'name' => 'setsubihi_shurui',
			'vname' => '設備費支払単位',
			'type' => 'enum',
			'len' => '4',
			'options' => 'setsubihi_shurui_options',
		),
		'setsubihi' => array (
			'name' => 'setsubihi',
			'vname' => '設備費',
			'type' => 'integer',
		),
		'setsubihi_zeikomi' => array (
			'name' => 'setsubihi_zeikomi',
			'vname' => '設備費（税込）',
			'type' => 'integer',
		),
		'kyouzai_tanka_web' => array (
			'name' => 'setsubihi_web',
			'vname' => '設備費Web出力',
			'type' => 'bool',
			'default' => 'off',
		),
		'show_web' => array (
			'name' => 'show_web',
			'vname' => 'web掲載',
			'type' => 'bool',
			'default' => 'off',
		),
		'uketsuke_web' => array (
			'name' => 'uketsuke_web',
			'vname' => 'Web受付',
			'type' => 'bool',
			'default' => 'off',
		),
		'name_web' => array (
			'name' => 'name_web',
			'vname' => 'Web講座名',
			'type' => 'varchar',
			'len' => '150',		
			'subtable' => 1,	
		),
		'name_sub_web' => array (
			'name' => 'name_sub_web',
			'vname' => 'Web副講座名',
			'type' => 'varchar',
			'len' => '150',		
			'subtable' => 1,	
		),
		'web_start_day' => array (
			'name' => 'web_start_day',
			'vname' => 'Web掲載期間（開始）',
			'type' => 'date',
		),
		'web_end_day' => array (
			'name' => 'web_end_day',
			'vname' => 'Web掲載期間（終了）',
			'type' => 'date',
		),
		'web_start_day_shinki' => array (
			'name' => 'web_start_day_shinki',
			'vname' => 'Web受付開始（新規）',
			'type' => 'date',
		),
		'web_start_day_keizoku' => array (
			'name' => 'web_start_day_keizoku',
			'vname' => 'Web受付開始（継続）',
			'type' => 'date',
		),
		'new_web' => array (
			'name' => 'new_web',
			'vname' => '新設扱いにする',
			'type' => 'bool',
			'default' => 'off',
		),
		'shashin1' => array (
			'name' => 'shashin1',
			'vname' => '写真1',
			'type' => 'id',
		),
		'shashin2' => array (
			'name' => 'shashin2',
			'vname' => '写真2',
			'type' => 'id',
		),
		'shashin3' => array (
			'name' => 'shashin3',
			'vname' => '写真3',
			'type' => 'id',
		),
		'description_web' => array (
			'name' => 'description_web',
			'vname' => 'Web・リーフレット用講座詳細',
			'type' => 'text',
			'subtable' => 1,
		),	
		'description_pamp' => array (
			'name' => 'description_pamp',
			'vname' => 'パンフレット用講座概要',
			'type' => 'text',
		),	
		'curriculum' => array (
			'name' => 'curriculum',
			'vname' => 'カリキュラム',
			'type' => 'text',
		),	
		'category1_web' => array (
			'name' => 'category1_web',
			'vname' => 'Web・パンフ掲載ジャンル（大）',
			'type' => 'enum',
			'len' => '32',
			'options' => 'category1_web_options',
		),
		'category2_web' => array (
			'name' => 'category2_web',
			'vname' => 'Web・パンフ掲載ジャンル（中）',
			'type' => 'enum',
			'len' => '32',
			'options' => 'category1_web_options',
		),
		'category3_web' => array (
			'name' => 'category3_web',
			'vname' => 'Web・パンフ掲載ジャンル（小）',
			'type' => 'enum',
			'len' => '32',
			'options' => 'category1_web_options',
		),
		'teiin' => array (
			'name' => 'teiin',
			'vname' => '最大受講定員',
			'type' => 'integer',
			'default' => 0,
			'required'=>true,
		),
		'teiin_min' => array (
			'name' => 'teiin_min',
			'vname' => '最少受講定員',
			'type' => 'integer',
			'default' => 0,
			'required'=>true,
		),
		'tein_type' => array (
			'name' => 'tein_type',
			'vname' => '定員を分けて設定',
			'type' => 'enum',
			'len' => '6',
			'options' => 'tein_type_options',
		),	
		'teiin_sub1' => array (
			'name' => 'teiin_sub1',
			'vname' => '新規/男性',
			'type' => 'integer',
			'default' => 0,
		),
		'teiin_sub2' => array (
			'name' => 'teiin_sub2',
			'vname' => '継続/女性',
			'type' => 'integer',
			'default' => 0,
		),
		'koushi_tanka' => array (
			'name' => 'koushi_tanka',
			'vname' => '講師報酬単価',
			'type' => 'integer',
		),
		'koushi_hoshu_type' => array (
			'name' => 'koushi_hoshu_type',
			'vname' => '講師報酬計算方法',
			'type' => 'enum',
			'len' => '4',
			'options' => 'koushi_hoshu_type_options',
		),			
		'shinki_toruku_no' => array (
			'name' => 'shinki_toruku_no',
			'vname' => '新規受講登録者数',
			'type' => 'integer',
			'default' => 0,
		),
		'keizoku_toruku_no' => array (
			'name' => 'keizoku_toruku_no',
			'vname' => '継続受講登録者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'shinki_yoyaku_no' => array (
			'name' => 'shinki_yoyaku_no',
			'vname' => '新規予約者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'keizoku_yoyaku_no' => array (
			'name' => 'keizoku_yoyaku_no',
			'vname' => '継続予約者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'dansei_toruku_no' => array (
			'name' => 'dansei_toruku_no',
			'vname' => '男性受講登録者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'josei_toruku_no' => array (
			'name' => 'josei_toruku_no',
			'vname' => '女性受講登録者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'dansei_yoyaku_no' => array (
			'name' => 'dansei_yoyaku_no',
			'vname' => '男性予約者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'josei_yoyaku_no' => array (
			'name' => 'josei_yoyaku_no',
			'vname' => '女性予約者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'shinki_cancelm_no' => array (
			'name' => 'shinki_cancelm_no',
			'vname' => '新規キャンセル待ち者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'keizoku_cancelm_no' => array (
			'name' => 'keizoku_cancelm_no',
			'vname' => '継続申キャンセル待ち者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'dansei_cancelm_no' => array (
			'name' => 'dansei_cancelm_no',
			'vname' => '男性キャンセル待ち者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		'josei_cancelm_no' => array (
			'name' => 'josei_cancelm_no',
			'vname' => '女性キャンセル待ち者数',
			'type' => 'integer',
			'default' => 0,
			'subtable' => 3,
		),
		
// OTHER link, relation etc.		
		'schedule'=> array (
			'name' => 'schedule',
			'type' => 'link',
			'relationship' => 'event_schedule',			
			'source' => 'non-db',
			'vname' => 'LBL_SCHEDULE',
		),   
		'contacts' => array (
			'name' => 'contacts',
			'type' => 'link',
			'relationship' => 'event_contacts',
			//'link_type' => 'one',
			'source'=>'non-db',
			'vname'=>'LBL_USERS',
		),
		'participant' => array (
			'name' => 'participant',
			'type' => 'link',
			'relationship' => 'event_contacts',
			//'link_type' => 'one',
			'source'=>'non-db',
			'vname'=>'LBL_USERS',
		),
		'student' => array (
			'name' => 'student',
			'type' => 'link',
			'relationship' => 'event_contacts',
			//'link_type' => 'one',
			'source'=>'non-db',
			'vname'=>'LBL_STUDENTS',
		),
		'teacher' => array (
			'name' => 'teacher',
			'type' => 'link',
			'relationship' => 'event_contacts',
			//'link_type' => 'one',
			'source'=>'non-db',
			'vname'=>'LBL_TEACHER',
		),
		'classroom' => array (
			'name' => 'classroom',
			'type' => 'link',
			'relationship' => 'event_resource',
			//'link_type' => 'one',
			'source'=>'non-db',
			'vname'=>'LBL_ALL_CLASSROOMS',
		),
		'resource' => array (
			'name' => 'resource',
			'type' => 'link',
			'relationship' => 'event_resource',
			//'link_type' => 'one',
			'source'=>'non-db',
			'vname'=>'LBL_OTHER_RESOURCES',
		),
		'memo'=> array (
			'name' => 'memo',
			'type' => 'link',
			'relationship' => 'memo_event',
			'vname' => 'LBL_MEMO',
			'link_type' => 'one',
			'module'=>'SMSMemo',
			'bean_name'=>'SMSMemo',
			'source' => 'non-db',
		), 
	), 
	'indices' => array (
	),
 	'relationships' => array (
		'event_schedule' => array(
			'lhs_module' => 'SMSEvent', 'lhs_table' => 'smsevent', 'lhs_key' => 'id',
			'rhs_module' => 'EventInstance', 'rhs_table' => 'sms_event_instance', 'rhs_key' => 'parent_id',	
			'relationship_type' => 'one-to-many'
		),
		'course_fees' => array(
			'lhs_module' => 'Course', 'lhs_table' => 'smsevent', 'lhs_key' => 'id',
			'rhs_module' => 'Fee', 'rhs_table' => 'sms_fee', 'rhs_key' => 'event_id',	
		  	'relationship_type' => 'one-to-many'
		  ),
		'course_transactions' => array(
			'lhs_module' => 'Course', 'lhs_table' => 'smsevent', 'lhs_key' => 'id',
			'rhs_module' => 'Transaction', 'rhs_table' => 'sms_transaction', 'rhs_key' => 'event_id',	
		  	'relationship_type' => 'one-to-many'
		  ),
		'course_classes' => array(
			'lhs_module' => 'Course', 'lhs_table' => 'smsevent', 'lhs_key' => 'id',
			'rhs_module' => 'EventInstance', 'rhs_table' => 'sms_event_instance', 'rhs_key' => 'parent_id',	
			'relationship_type' => 'one-to-many'
		),
		'syllabus' => array(
			'lhs_module' => 'Course', 'lhs_table' => 'smsevent', 'lhs_key' => 'id',
			'rhs_module' => 'Syllabus', 'rhs_table' => 'sms_syllabus', 'rhs_key' => 'parent_id',	
		  	'relationship_type' => 'one-to-many'
		),
		'memo_event' => array(
			'lhs_module' => 'Course', 'lhs_table' => 'smsevent', 'lhs_key' => 'id',
			'rhs_module' => 'SMSMemo', 'rhs_table' => 'sms_memo', 'rhs_key' => 'parent_id',	
			'relationship_type' => 'one-to-many'
		),
		'smsdocument' => array(
			'lhs_module' => 'Course', 'lhs_table' => 'smsevent', 'lhs_key' => 'id',
			'rhs_module' => 'SMSDocument', 'rhs_table' => 'sms_document', 'rhs_key' => 'parent_id',	
			'relationship_type' => 'one-to-many'
		),	
	),

//This enables optimistic locking for Saves From EditView
	'optimistic_locking'=>true,
);
	  
if(file_exists(include_custom("modules/Course/vardefs.override_AN.php"))) {
	include(get_custom_path_with_school_underscore("modules/Course/vardefs.override_AN.php"));
}

?>