<?php

	$config = Array (
		'Prefix' => 'rev',

		'Clones' => Array (
			'l-rev' => Array(
				'ParentPrefix' => 'l',
				'ConfigMapping' => Array (
					'PerPage'				=>	'Perpage_LinkReviews',
					'ShortListPerPage'		=>	'Perpage_LinkReviews_Short',
					'DefaultSorting1Field'	=>	'Link_ReviewsSort',
					'DefaultSorting2Field'	=>	'Link_ReviewsSort2',
					'DefaultSorting1Dir'	=>	'Link_ReviewsOrder',
					'DefaultSorting2Dir'	=>	'Link_ReviewsOrder2',

					'ReviewDelayInterval'	=>	'link_ReviewDelay_Interval',
					'ReviewDelayValue'		=>	'link_ReviewDelay_Value',
				),
			),

			'n-rev' => Array (
				'ParentPrefix' => 'n',
				'ConfigMapping' => Array (
					'PerPage'				=>	'Perpage_NewsReviews',
					'ShortListPerPage'		=>	'Perpage_NewsReviews_Short',
					'DefaultSorting1Field'	=>	'News_SortReviews',
					'DefaultSorting2Field'	=>	'News_SortReviews2',
					'DefaultSorting1Dir'	=>	'News_SortReviewsOrder',
					'DefaultSorting2Dir'	=>	'News_SortReviewsOrder2',

					'ReviewDelayInterval'	=>	'News_ReviewDelay_Interval',
					'ReviewDelayValue'		=>	'News_ReviewDelay_Value',
				),
			),

			'bb-rev' => Array (
					'ParentPrefix' => 'bb',
					'ConfigMapping' => Array (
						'PerPage'				=>	'Perpage_TopicReviews',

						'ReviewDelayInterval'	=>	'topic_ReviewDelay_Interval',
						'ReviewDelayValue'		=>	'topic_ReviewDelay_Value',
					),
				),

			'p-rev' => Array (
				'ParentPrefix' => 'p',
				'ConfigMapping' => Array (
					'PerPage'				=>	'Comm_Perpage_Reviews',

					'ReviewDelayInterval'	=>	'product_ReviewDelay_Value',
					'ReviewDelayValue'		=>	'product_ReviewDelay_Interval',
				),
			),
		),

		'ItemClass'			=>	Array('class'=>'kDBItem','file'=>'','build_event'=>'OnItemBuild'),
		'ListClass'			=>	Array('class'=>'kDBList','file'=>'','build_event'=>'OnListBuild'),
		'EventHandlerClass'	=>	Array('class'=>'ReviewsEventHandler','file'=>'reviews_event_handler.php','build_event'=>'OnBuild'),
		'TagProcessorClass' =>	Array('class'=>'ReviewsTagProcessor','file'=>'reviews_tag_processor.php','build_event'=>'OnBuild'),
		'AutoLoad'			=>	true,

		'QueryString' => Array (
			1 => 'id',
			2 => 'Page',
			3 => 'event',
			4 => 'mode',
		),

		'ParentPrefix' 		=> 'p', // replace all usage of rev to "p-rev" and then remove this param from here and Prefix too
		'ConfigMapping' => Array (
			'PerPage'				=>	'Comm_Perpage_Reviews',

			'ReviewDelayInterval'	=>	'product_ReviewDelay_Value',
			'ReviewDelayValue'		=>	'product_ReviewDelay_Interval',
		),

		'IDField'			=>	'ReviewId',
		'StatusField'		=>	Array('Status'),	// field, that is affected by Approve/Decline events
		'TableName'			=>	TABLE_PREFIX.'ItemReview',
		'ParentTableKey'	=>	'ResourceId',	// linked field in master table
		'ForeignKey'		=>	'ItemId',		// linked field in subtable

		'AutoDelete'		=>	true,
		'AutoClone'			=>	true,

		'TitlePresets' => Array (
			'reviews_edit' => Array('format' => "!la_title_Editing_Review!"),
		),

		'FilterMenu' => Array (
			'Groups' => Array(
				Array('mode' => 'AND', 'filters' => Array('show_active','show_pending','show_disabled'), 'type' => WHERE_FILTER),
			),
			'Filters' => Array(
				'show_active'	=>	Array('label' =>'la_Active', 'on_sql' => '', 'off_sql' => '%1$s.Status != 1' ),
				'show_pending'	=>	Array('label' => 'la_Pending', 'on_sql' => '', 'off_sql' => '%1$s.Status != 2'  ),
				'show_disabled'	=>	Array('label' => 'la_Disabled', 'on_sql' => '', 'off_sql' => '%1$s.Status != 0'  ),
			)
		),

		'CalculatedFields' => Array (
			'' => Array (
					'ReviewedBy' => 'IF( ISNULL(pu.Login), IF (%1$s.CreatedById = -1, \'root\', IF (%1$s.CreatedById = -2, \'Guest\', \'n/a\')), pu.Login )',
			),

			'products' => Array (
				'ReviewedBy'	=>	'IF( ISNULL(pu.Login), IF (%1$s.CreatedById = -1, \'root\', IF (%1$s.CreatedById = -2, \'Guest\', \'n/a\')), pu.Login )',
				'ItemName'		=>	'pr.l1_Name',
				'ProductId'		=>	'pr.ProductId',
			),

			'product' => Array (
				'ReviewedBy'	=>	'IF( ISNULL(pu.Login), IF (%1$s.CreatedById = -1, \'root\', IF (%1$s.CreatedById = -2, \'Guest\', \'n/a\')), pu.Login )',
				'ItemName'		=>	'pr.l1_Name',
				'ProductId'		=>	'pr.ProductId',
			),
		),

		// key - special, value - list select sql
		'ListSQLs' => Array (
			'' => '	SELECT %1$s.* %2$s
					FROM %1$s
					LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON pu.PortalUserId = %1$s.CreatedById',

			'products'	=> 	'	SELECT %1$s.* %2$s
								FROM %1$s, '.TABLE_PREFIX.'Products pr
					 			LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON	pu.PortalUserId = %1$s.CreatedById',

			'product'	=> 	'	SELECT %1$s.* %2$s
								FROM %1$s, '.TABLE_PREFIX.'Products pr
								LEFT JOIN '.TABLE_PREFIX.'PortalUser pu ON	pu.PortalUserId = %1$s.CreatedById',
		),

		'ItemSQLs' => Array ('' => 'SELECT * FROM %s'),

		'ListSortings' => Array (
			'' => Array(
				'ForcedSorting' => Array('Priority' => 'desc'),
				'Sorting' => Array('CreatedOn' => 'desc'),
			)
		),

		'Fields' =>	Array (
		    'ReviewId' => Array('type' => 'int', 'not_null' => 1, 'default' => 0),
		    'CreatedOn' => Array('type' => 'int', 'formatter'=>'kDateFormatter', 'default'=>'#NOW#'),
		    'ReviewText' => Array('type'=>'string','required'=>1,'not_null'=>1,'default'=>''),
		    'Rating' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'lu_None', 1 => 'lu_Rating_1', 2 => 'lu_Rating_2', 3 => 'lu_Rating_3', 4 => 'lu_Rating_4', 5 => 'lu_Rating_5'), 'use_phrases' => 1, 'min_value_inc' => 0, 'max_value_inc' => 5, 'default' => 0),
		    'IPAddress' => Array('type'=>'string','max_value_inc'=>15,'not_null'=>1,'default'=>''),
		    'ItemId' => Array('type'=>'int','not_null'=>1,'default'=>0),
		    'CreatedById' => Array('type' => 'int', 'formatter'=>'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array(-1 => 'root', -2 => 'Guest'),'left_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'','left_key_field'=>'PortalUserId','left_title_field'=>'Login','required'=>1,'not_null'=>1,'default'=>-1),
		    'ItemType' => Array('type'=>'int','not_null'=>1,'default'=>0),
		    'Priority' => Array('type'=>'int','not_null'=>1,'default'=>0),
		    'Status' => Array('type' => 'int', 'formatter'=>'kOptionsFormatter', 'use_phrases' => 1, 'options'=>Array(1=>'la_Active',2=>'la_Pending',0=>'la_Disabled'),'not_null'=>1,'default'=>2 ),
		    'TextFormat' => Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_text', 1 => 'la_html'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 0),
		    'Module' => Array('type'=>'string','not_null'=>1,'default'=>''),
		),

		'VirtualFields' => Array (
			'ReviewedBy' => Array('type' => 'string', 'default' => ''),
		),

		'Grids' => Array (
			'Default' => Array (
				'Icons' => Array ('default'=>'icon16_custom.gif',1=>'icon16_review.gif',2=>'icon16_review_pending.gif',0=>'icon16_review_disabled.gif'),
				'Fields' => Array (
					'ReviewText' => Array( 'title'=>'la_col_ReviewText', 'data_block' => 'reviewtext_checkbox_td'),
					'ReviewedBy' => Array( 'title'=>'la_col_ReviewedBy' ),
					'CreatedOn_formatted' => Array( 'title'=>'la_col_CreatedOn', 'sort_field' => 'CreatedOn'  ),
					'Status' => Array( 'title'=>'la_col_Status' ),
					'Rating' => Array( 'title'=>'la_col_Rating' ),
				),
			),

			'ReviewsSection' => Array (
				'Icons' => Array ('default'=>'icon16_custom.gif',1=>'icon16_review.gif',2=>'icon16_review_pending.gif',0=>'icon16_review_disabled.gif'),
				'Fields' => Array (
					'ReviewText' => Array( 'title'=>'la_col_ReviewText', 'data_block' => 'grid_checkbox_namelink_td'),
					'ReviewedBy' => Array( 'title'=>'la_col_ReviewedBy' ),
					'CreatedOn_formatted' => Array( 'title'=>'la_col_CreatedOn', 'sort_field' => 'CreatedOn' ),
					'Status' => Array( 'title'=>'la_col_Status' ),
				),
			),
		),
	);

?>