<?php

$config	=	Array(
					'Prefix'			=>	'phrases',
					'ItemClass'			=>	Array('class'=>'kDBItem','file'=>'','build_event'=>'OnItemBuild'),
					'ListClass'			=>	Array('class'=>'kDBList','file'=>'','build_event'=>'OnListBuild'),
					'EventHandlerClass'	=>	Array('class'=>'PhrasesEventHandler','file'=>'phrases_event_handler.php','build_event'=>'OnBuild'),
					'TagProcessorClass' =>	Array('class'=>'kDBTagProcessor','file'=>'','build_event'=>'OnBuild'),
					'AutoLoad'			=>	true,

					'Hooks'	=>	Array(
												Array(
													'Mode' => hBEFORE,
													'Conditional' => false,
													'HookToPrefix' => 'phrases',
													'HookToSpecial' => '',
													'HookToEvent' => Array('OnCreate'),
													'DoPrefix' => 'phrases',
													'DoSpecial' => '',
													'DoEvent' => 'OnBeforePhraseCreate',
												),

												Array(
													'Mode' => hAFTER,
													'Conditional' => false,
													'HookToPrefix' => 'phrases',
													'HookToSpecial' => '',
													'HookToEvent' => Array('OnBeforeItemCreate','OnBeforeItemUpdate'),
													'DoPrefix' => 'phrases',
													'DoSpecial' => '',
													'DoEvent' => 'OnSetLastUpdated',
												),
											),

					'QueryString'		=>	Array(
												1	=>	'id',
												2	=>	'page',
												3	=>	'event',
												4 	=>	'label',
											),
					'IDField'			=>	'PhraseId',

					'TitleField'		=>	'Phrase',

					'TitlePresets'		=>	Array(
												'default'	=>	Array(	'new_status_labels'		=> Array('phrases'=>'!la_title_Adding_Phrase!'),
																		'edit_status_labels'	=> Array('phrases'=>'!la_title_Editing_Phrase!'),
																		'new_titlefield'		=> Array('phrases'=>'!la_title_New_Phrase!'),
																),

												'phrase_edit'	=>	Array('prefixes' => Array('phrases'), 'format' => '#phrases_status# - #phrases_titlefield#'),

											),

					'FilterMenu'		=>	Array(
												'Groups' => Array(
													Array('mode' => 'AND', 'filters' => Array('show_front','show_admin','show_both'), 'type' => WHERE_FILTER),
												),
												'Filters' => Array(
													'show_front'	=>	Array('label' =>'la_PhraseType_Front', 'on_sql' => '', 'off_sql' => '%1$s.PhraseType != 0' ),
													'show_admin'	=>	Array('label' => 'la_PhraseType_Admin', 'on_sql' => '', 'off_sql' => '%1$s.PhraseType != 1'  ),
													'show_both'	=>	Array('label' => 'la_PhraseType_Both', 'on_sql' => '', 'off_sql' => '%1$s.PhraseType != 2'  ),
												)
											),

					'TableName'			=>	TABLE_PREFIX.'Phrase',

					'CalculatedFields'	=>	Array(
												''	=>	Array(
															'PrimaryTranslation'	=>	'pri.Translation',
													),

											),

					'ListSQLs'			=>	Array(	''=>'	SELECT %1$s.* %2$s
    														FROM %1$s
    														LEFT JOIN '.TABLE_PREFIX.'Phrase pri ON (%1$s.Phrase = pri.Phrase) AND (pri.LanguageId = 1)'),

					'ItemSQLs'			=>	Array(	''=>'	SELECT %1$s.* %2$s
															FROM %1$s
															LEFT JOIN '.TABLE_PREFIX.'Phrase pri ON (%1$s.Phrase = pri.Phrase) AND (pri.LanguageId = 1)',),

					'ListSortings'	=> 	Array(
																'' => Array(
																	'Sorting' => Array('Phrase' => 'asc'),
																)
															),

					'ForeignKey'		=>	'LanguageId',
					'ParentTableKey' 	=> 	'LanguageId',
					'ParentPrefix' 		=> 	'lang',
					'AutoDelete'		=>	true,
					'AutoClone'			=> 	true,

					'Fields'			=>	Array(
									            'Phrase' => Array('type' => 'string','required'=>1,'unique'=>Array('LanguageId'),'not_null' => '1','default' => ''),
									            'Translation' => Array('type' => 'string','required'=>1,'not_null' => '1','default' => ''),
									            'PhraseType' => Array('type' => 'int','required'=>1,'formatter'=>'kOptionsFormatter','options'=>Array(0=>'la_PhraseType_Front',1=>'la_PhraseType_Admin',2=>'la_PhraseType_Both'), 'use_phrases' => 1, 'not_null' => '1','default' => '0'),
									            'PhraseId' => Array('type' => 'int','not_null' => '1','default' => ''),
									            'LanguageId' => Array('type' => 'int','not_null' => '1','default' => '0'),
									            'LastChanged' => Array('type' => 'int', 'formatter'=>'kDateFormatter', 'not_null' => '1','default' => '0'),
            									'LastChangeIP' => Array('type' => 'string','not_null' => '1','default' => ''),
												'Module' => Array('type' => 'string', 'formatter'=>'kOptionsFormatter', 'options'=>Array(''=>''), 'options_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'Modules WHERE Loaded = 1 ORDER BY LoadOrder', 'option_key_field'=>'Name', 'option_title_field'=>'Name', 'not_null' => '1','default' => 'In-Portal'),
									        ),

					'VirtualFields'	=> 	Array(
												'PrimaryTranslation'	=>	Array(),
												'LangFile'		=>	Array(),
												'ImportOverwrite' => Array(),
												'DoNotEncode' => Array(),
										),

					'Grids'	=> Array(
										'Default'		=>	Array(
																	'Icons' => Array('default'=>'icon16_language_var.gif'),
																	'Fields' => Array(
																			'Phrase' 	=> Array( 'title'=>'la_col_Label', 'data_block' => 'grid_checkbox_td'),
																			'Translation' => Array( 'title'=>'la_col_Translation' ),
																			'PrimaryTranslation' 	=> Array( 'title'=>'la_col_PrimaryValue' ),
																			'PhraseType' 	=> Array( 'title'=>'la_col_PhraseType' ),
																			'LastChanged' 	=> Array( 'title'=>'la_col_LastChanged' ),
																			'Module' 	=> Array( 'title'=>'la_col_Module' ),
																		),

																),
							),
	);

?>