<?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['Student'] = array(
	'table' => 'contacts', 
	'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',
		),
		'smsgroup' => array (
			'name' => 'smsgroup',			
			'type' => 'varchar',
			'len' => '15',
			'vname' => 'LBL_LIST_SMSGROUP', 
			'default' => 'student',
		),
// 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,
		),
		
// old fields (varchar length may be changed
		'first_name' => array (
			'name' => 'first_name',
			'vname' => 'LBL_FIRST_NAME',
			'type' => 'varchar',
			'len' => '40',  // 100
		),
		'last_name' => array (
			'name' => 'last_name',
			'vname' => 'LBL_LAST_NAME',
			'type' => 'varchar',
			'len' => '40',  // 100
			'required'=>true,
		),
		'first_name_furigana' => array (
			'name' => 'first_name_furigana',
			'vname' => 'フリガナ（姓）',
			'type' => 'varchar',
			'len' => '40',  // 100
		),
		'last_name_furigana' => array (
			'name' => 'last_name_furigana',
			'vname' => 'フリガナ（姓）',
			'type' => 'varchar',
			'len' => '40',  // 100
		),
		'assigned_user_id' => array (
			'name' => 'assigned_user_id',
			'vname' => 'LBL_ASSIGNED_TO',
			'type' => 'id',
			'required'=>true,
		),
		'lead_source' => array (
			'name' => 'lead_source',
			'vname' => '認知媒体',
			'type' => 'enum',
			'options' => 'lead_source_dom',
			'len' => '40',  // 100
		),
		'company_name' => array (
			'name' => 'company_name',
			'vname' => 'LBL_COMPANY_NAME',
			'type' => 'varchar',
			'len' => '100',
		),
		'reports_to_id'=> array(
			'name' => 'reports_to_id',
			'vname' => 'LBL_REPORTS_TO_ID',
			'type' => 'id',		
		),
		'gender' => array (
			'name' => 'gender',
			'vname' => 'LBL_GENDER',
			'type' => 'enum',
			'options' => 'gender',
			'len' => '8',
		),
		'phone_mobile' => array (
			'name' => 'phone_mobile',
			'vname' => '携帯電話',
			'type' => 'phone',
			'dbType' => 'varchar',
			'len' => '25',
		),
		'phone_mobile_cleaned' => array (
			'name' => 'phone_mobile_cleaned',
			'vname' => '携帯電話',
			'type' => 'phone',
			'dbType' => 'varchar',
			'len' => '25',
		),
		'phone_home' => array (
			'name' => 'phone_home',
			'vname' => '自宅電話',
			'type' => 'phone',
			'len' => '25',
		),
		'phone_home_cleaned' => array (
			'name' => 'phone_home_cleaned',
			'vname' => '自宅電話',
			'type' => 'phone',
			'len' => '25',
		),
		'phone_work' => array (
			'name' => 'phone_work',
			'vname' => '昼間の連絡先',
			'type' => 'phone',
			'len' => '25',
		),
		'phone_work_cleaned' => array (
			'name' => 'phone_work_cleaned',
			'vname' => '昼間の連絡先',
			'type' => 'phone',
			'len' => '25',
		),
		'phone_other' => array (
			'name' => 'phone_other',
			'vname' => '緊急連絡先',
			'type' => 'phone',
			'len' => '25',
		),
		'phone_other_cleaned' => array (
			'name' => 'phone_other_cleaned',
			'vname' => '緊急連絡先',
			'type' => 'phone',
			'len' => '25',
		),
		'birthdate' => array (
			'name' => 'birthdate',
			'vname' => '誕生日',
			'type' => 'date',
		),
		'email1' => array (
			'name' => 'email1',
			'vname' => 'LBL_EMAIL_ADDRESS',
			'type' => 'email',
			'len' => '100',
		),
		'email_opt_out' => array (
			'name' => 'email_opt_out',
			'vname' => 'LBL_EMAIL_OPT_OUT',
			'type' => 'bool',
			'len' => '3',
			'default' => '0',
		),
		'invalid_email' => array (
			'name' => 'invalid_email',
			'vname' => 'LBL_INVALID_EMAIL',
			'type' => 'tinyint',
			'default' => '0',
		),
		'idnumber' => array (
			'name' => 'idnumber',
			'vname' => 'LBL_idnumber',
			'type' => 'varchar',
			'len' => '32',
		),
		'contact_status' => array (
			'name' => 'contact_status',
			'vname' => 'LBL_CONTACT_STATUS',
			'type' => 'enum',
			'options' => 'event_contact_status',
			'len' => '3',
		),
		'school_id' => 	array (
			'name' => 'school_id',
			'vname' => '事業所',
			'type' => 'id',
			'len' => '36',
			'table' => 'resource',
		),
		'application_date' => array (
			'name' => 'application_date',
			'vname' => '問合せ日',
			'type' => 'date',
		),
		'enroll_date' => array (
			'name' => 'enroll_date',
			'vname' => '新規入会日',
			'type' => 'date',
		),
		'primary_address_postalcode' => array (
			'name' => 'primary_address_postalcode',
			'vname' => '郵便番号(自宅)',
			'type' => 'varchar',
			'len' => '20',
		),
		'primary_address_state' => array (
			'name' => 'primary_address_state',
			'vname' => '都道府県(自宅)',
			'type' => 'varchar',
			'len' => '100',
		),
		'primary_address_city' => array (
			'name' => 'primary_address_city',
			'vname' => '市区町村(自宅)',
			'type' => 'varchar',
			'len' => '100',
		),
		'primary_address_street' => 	array (
			'name' => 'primary_address_street',
			'vname' => '番地等(自宅)',
			'type' => 'varchar',
			'len' => '150',
		),
		'primary_address_kana' => array (
			'name' => 'primary_address_kana',
			'vname' => '住所カナ(自宅)',
			'type' => 'varchar',
			'len' => '250',
		),
		'send_document_home' => array (
			'name' => 'send_document_home',
			'vname' => 'ラベル印刷の有無(自宅)',
			'type' => 'bool',
			'len' => '3',
			'default' => '0',
		),
		'description' => array (
			'name' => 'description',
			'vname' => 'LBL_DESCRIPTION',
			'type' => 'text',
		),
		
		
// new fields		
		'renewal_date' => array (
			'name' => 'renewal_date',
			'vname' => '更新入会日',
			'type' => 'date',
		),
		'valid_date' => array (
			'name' => 'valid_date',
			'vname' => '有効期限',
			'type' => 'date',
		),
		'old_pass' => array (
			'name' => 'old_pass',
			'vname' => '旧システムパスワード',
			'type' => 'varchar',
			'len' => '12',
		),
		'renraku_saki' => array (
			'name' => 'renraku_saki',
			'vname' => '連絡先',
			'type' => 'varchar',
			'len' => '40',
		),
		'shokaisha_bango' => array (
			'name' => 'shokaisha_bango',
			'vname' => '紹介者番号',
			'type' => 'varchar',
			'len' => '40',
		),
		'renraku_jiko' => array (
			'name' => 'renraku_jiko',
			'vname' => '連絡事項',
			'type' => 'text',
		),
		'other_komoku' => array (
			'name' => 'other_komoku',
			'vname' => 'その他項目',
			'type' => 'text',
		),
		'mail_magazine' => array (
			'name' => 'mail_magazine',
			'vname' => 'メールマガジン購読',
			'type' => 'enum',
			'options' => 'mail_magazine_options',
			'len' => '8',
		),
		'anketo_shokugyo' => array (
			'name' => 'anketo_shokugyo',
			'vname' => '職業',
			'type' => 'enum',
			'options' => 'anketo_shokugyo_options',
			'len' => '24',
		),
		'anketo_baitai' => array (
			'name' => 'anketo_baitai',
			'vname' => 'ACCを知ったきっかけ',
			'type' => 'enum',
			'options' => 'anketo_baitai_options',
			'len' => '24',
		),
		'anketo_janru' => array (
			'name' => 'anketo_janru',
			'vname' => '興味のあるジャンル',
			'type' => 'enum',
			'options' => 'anketo_janru_options',
			'len' => '24',
		),
		'anketo_other' => array (
			'name' => 'anketo_other',
			'vname' => '（未使用）',
			'type' => 'enum',
			'options' => 'anketo_other_options',
			'len' => '24',
		),

		
// OTHER link, relation etc.		
		'accounts' => array (
			'name' => 'accounts',
			'type' => 'link',
			'relationship' => 'accounts_contacts',
			'link_type' => 'one',
			'source' => 'non-db',
			'vname' => 'LBL_ACCOUNT',
		),
		'reports_to_link' => array (
			'name' => 'reports_to_link',
			'type' => 'link',
			'relationship' => 'contact_direct_reports',
			'link_type' => 'one',
			'side' => 'right',
			'source' => 'non-db',
			'vname' => 'LBL_REPORTS_TO',
		),
		'direct_reports'=> array (
			'name' => 'direct_reports',
			'type' => 'link',
			'relationship' => 'contact_direct_reports',
			'source' => 'non-db',
			'vname' => 'LBL_DIRECT_REPORTS',
		),  
		'emails'=> array (
			'name' => 'emails',
			'type' => 'link',
			'relationship' => 'emails_contacts',
			'source' => 'non-db',
			'vname' => 'LBL_EMAILS',
		),
		'persons'=> array (
			'name' => 'persons',
			'type' => 'link',
			'relationship' => 'person_contacts',
			'source' => 'non-db',
			'vname' => 'LBL_PERSONS',
		),
		'notes'=> array (
			'name' => 'notes',
			'type' => 'link',
			'relationship' => 'contact_notes',
			'source' => 'non-db',
			'vname' => 'LBL_NOTES',
		),  
		'project'=> array (
			'name' => 'project',
			'type' => 'link',
			'relationship' => 'projects_contacts',
			'source' => 'non-db',
			'vname' => 'LBL_PROJECTS',
		),  
		'tasks'=> array (
			'name' => 'tasks',
			'type' => 'link',
			'relationship' => 'contact_tasks',
			'source' => 'non-db',
			'vname' => 'LBL_TASKS',
		),  
		'notices'=> array (
			'name' => 'notices',
			'type' => 'link',
			'relationship' => 'contacts_sms_memo',
			'source' => 'non-db',
			'vname' => 'LBL_NOTICES',
		), 
		'created_by_link' => array (
			'name' => 'created_by_link',
			'type' => 'link',
			'relationship' => 'contacts_created_by',
			'vname' => 'LBL_CREATED_BY_USER',
			'link_type' => 'one',
			'module' => 'Users',
			'bean_name' => 'User',
			'source' => 'non-db',
		),
		'modified_user_link' => array (
			'name' => 'modified_user_link',
			'type' => 'link',
			'relationship' => 'contacts_modified_user',
			'vname' => 'LBL_MODIFIED_BY_USER',
			'link_type' => 'one',
			'module' => 'Users',
			'bean_name' => 'User',
			'source' => 'non-db',
		),
		'assigned_user_link' => array (
			'name' => 'assigned_user_link',
			'type' => 'link',
			'relationship' => 'contacts_assigned_user',
			'vname' => 'LBL_ASSIGNED_TO_USER',
			'link_type' => 'one',
			'module' => 'Users',
			'bean_name' => 'User',
			'source' => 'non-db',
		),
		'fees'=> array (
			'name' => 'fees',
			'type' => 'link',
			'relationship' => 'contact_fees',
			'source' => 'non-db',
			'vname' => 'LBL_FEES_LINKED',
		),  
		'absence_availibility'=> array (
			'name' => 'absence_availibility',
			'type' => 'link',
			'link_type' => 'one',
			'relationship' => 'event_contacts',
			'source' => 'non-db',
			'vname' => 'LBL_ABSENCE',
		),  
		'events'=> array (
			'name' => 'events',
			'type' => 'link',
			'link_type' => 'one',
			'relationship' => 'event_contacts',
			'source' => 'non-db',
			'vname' => 'LBL_EVENT',
		),  
		'brothers_sisters'=> array(
			'name'=>'brothers_sisters',
			'source'=>'non-db',
			'type' => 'varchar',  
		),
		'memo'=> array (
			'name' => 'memo',
			'type' => 'link',
			'relationship' => 'memo_contact',
			'vname' => 'LBL_MEMO',
		   	'link_type' => 'one',
	    		'module'=>'SMSMemo',
		    	'bean_name'=>'SMSMemo',
			'source' => 'non-db',
		),  
		'transactions'=> array (
			'name' => 'transactions',
			'type' => 'link',
			'relationship' => 'student_transactions',
			'vname' => 'LBL_TRANSACTION',
			'source' => 'non-db',
		),  

		
	), 
'indices' => array (
//	array(
//		'name' => 'contactspk',
//		'type' => 'primary',
//		'fields' => array('id')
//	),
//	array(
//		'name' => 'idx_cont_last_first',
//		'type' => 'index',
//		'fields' => array('last_name', 'first_name', 'deleted')
//	),
),
 'relationships' => array (
	'contact_direct_reports' => array(
		'lhs_module' => 'Contacts', 
		'lhs_table' => 'contacts', 
		'lhs_key' => 'id',
		'rhs_module' => 'Contacts', 
		'rhs_table' => 'contacts', 
		'rhs_key' => 'reports_to_id',	
	  	'relationship_type' => 'one-to-many'
	  ),
	'contact_notes' => array(
		'lhs_module' => 'Contacts', 
		'lhs_table' => 'contacts', 
		'lhs_key' => 'id',
		'rhs_module' => 'Notes', 
		'rhs_table' => 'notes', 
		'rhs_key' => 'contact_id',	
	  	'relationship_type' => 'one-to-many'
	  ),
	'contact_tasks' => array(
		'lhs_module' => 'Contacts', 
		'lhs_table' => 'contacts', 
		'lhs_key' => 'id',
		'rhs_module' => 'Tasks', 
		'rhs_table' => 'tasks', 
		'rhs_key' => 'contact_id',	
	  	'relationship_type' => 'one-to-many'
	  	),	
	'contacts_assigned_user' => array(
		'lhs_module' => 'Users', 
		'lhs_table' => 'users', 
		'lhs_key' => 'id',
		'rhs_module' => 'Contacts', 
		'rhs_table' => 'contacts', 
		'rhs_key' => 'assigned_user_id',
		'relationship_type' => 'one-to-many'
	),
	'contacts_modified_user' => array(
		'lhs_module' => 'Users', 
		'lhs_table' => 'users', 
		'lhs_key' => 'id',
		'rhs_module' => 'Contacts', 
		'rhs_table' => 'contacts', 
		'rhs_key' => 'modified_user_id',
		'relationship_type' => 'one-to-many'
	),
	'contacts_created_by' => array(
		'lhs_module' => 'Users', 
		'lhs_table' => 'users', 
		'lhs_key' => 'id',
		'rhs_module' => 'Contacts', 
		'rhs_table' => 'contacts', 
		'rhs_key' => 'created_by',
		'relationship_type' => 'one-to-many'
	),
	'contact_fees' => array(
		'lhs_module' => 'Contact', 
		'lhs_table' => 'contacts', 
		'lhs_key' => 'id',
		'rhs_module' => 'Fee', 
		'rhs_table' => 'sms_fee', 
		'rhs_key' => 'contact_id',	
		'relationship_type' => 'one-to-many'
	),
	'memo_contact' => array(
		'lhs_module' => 'Contact', 
		'lhs_table' => 'contacts', 
		'lhs_key' => 'id',
		'rhs_module' => 'SMSMemo', 
		'rhs_table' => 'sms_memo', 
		'rhs_key' => 'parent_id',	
		'relationship_type' => 'one-to-many'
		),
	'student_transactions' => array(
		'lhs_module' => 'Student', 
		'lhs_table' => 'contacts', 
		'lhs_key' => 'id',
		'rhs_module' => 'Transaction', 
		'rhs_table' => 'sms_fee', 
		'rhs_key' => 'sms_transaction',	
		'relationship_type' => 'one-to-many'
	),
),

//This enables optimistic locking for Saves From EditView
'optimistic_locking'=>true,
);
	  
if(file_exists(include_custom("modules/Student/vardefs.override_AN.php"))) {
	include(get_custom_path_with_school_underscore("modules/Student/vardefs.override_AN.php"));
}

?>