<?php

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

					'QueryString'		=>	Array(
												1	=>	'id',
												2	=>	'page',
												3	=>	'event',
												4	=>	'mode',
											),
											
					'IDField' 			=>	'VisitId',
					'TableName'			=>	TABLE_PREFIX.'Visits',
					
					'CalculatedFields' => Array(
								'' => Array (
										'UserName'	=>	'IF( ISNULL(u.Login), IF (%1$s.PortalUserId = -1, \'root\', IF (%1$s.PortalUserId = -2, \'Guest\', \'n/a\')), u.Login)',
									),
								),
								
					'ListSQLs'			=>	Array(	''=>'	SELECT %1$s.* %2$s
															FROM %1$s
															LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON %1$s.PortalUserId = u.PortalUserId'),
																		 
					'ItemSQLs'			=>	Array(	''=>'	SELECT %1$s.* %2$s
															FROM %1$s
															LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON %1$s.PortalUserId = u.PortalUserId'),
					
					'ListSortings'	=> 	Array( 
																'' => Array(
																	'Sorting' => Array('VisitDate' => 'asc'),
																)
															),
					
					'Fields' => Array(
										'VisitId' => Array(),
										'VisitDate' => Array('type' => 'int', 'formatter'=>'kDateFormatter', 'not_null' => '1','default' => '0'),
										'Referer' => Array('type' => 'string','not_null' => '1','default' => ''),
            							'IPAddress' => Array('type' => 'string','not_null' => '1','default' => ''),
										'AffiliateId' => Array('type' => 'int','not_null' => '1','default' => '0'),
										'PortalUserId' => Array('type' => 'int','not_null' => '1','default' => -2),
										'OrderId' => Array('type' => 'int','not_null' => '1','default' => '0'),
							    ),		
							
					'VirtualFields'	=> 	Array(
												'Username'		=>	Array('type'=>'string'),
											),
									
					'Grids'	=> Array(),
					
	);

?>