<?php

$config	=	Array(
					'Prefix'	=> 'ug',
					'Clones'	=> Array(
											'g-ug'	=>	Array(
																'ParentPrefix'		=>	'g',
																'ForeignKey'		=>	'GroupId',
																'ParentTableKey' 	=> 	'GroupId',
																
																'IDField'			=>	'PortalUserId',
																
																'ListSQLs'	=>	Array(
																	''	=>	'	SELECT %1$s.* %2$s FROM %1$s
																						LEFT JOIN '.TABLE_PREFIX.'PortalGroup g ON %1$s.GroupId = g.GroupId
																						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.'PortalGroup g ON %1$s.GroupId = g.GroupId
																						LEFT JOIN '.TABLE_PREFIX.'PortalUser u ON %1$s.PortalUserId = u.PortalUserId'
																),
																'CalculatedFields'	=>	Array (
																	''	=>	Array(
																		'UserName' => 'CONCAT(u.LastName, \' \', u.FirstName)',
																		'UserLogin' => 'u.Login',
																	),
																),
																'VirtualFields'	=> Array (
																	'UserName' => Array('type' => 'string'),
																	'UserLogin' => Array('type' => 'string'),
																),
																'Grids'	=> Array(
																	'GroupUsers'	=>	Array(
																		'Icons' => Array ('default' => 'icon16_group.gif'),
																		'Fields' => Array(
																			'PortalUserId'			=> Array ('title' => 'la_col_Id', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter'),
																			'UserName'			=> Array ('title'=>'la_col_UserFirstLastName'),
																			'UserLogin'			=> Array ('title'=>'la_col_Login'),
																			'PrimaryGroup'	=> Array( 'title'=>'la_col_PrimaryGroup', 'filter_block' => 'grid_options_filter'),
																			'MembershipExpires'	=>	Array ('title' => 'la_col_MembershipExpires', 'data_block' => 'grid_membership_td', 'filter_block' => 'grid_date_range_filter'),
																		),
																	),
																),
															),

											'u-ug'	=>	Array(
																'ParentPrefix'		=>	'u',
																'ForeignKey'		=>	'PortalUserId',
																'ParentTableKey' 	=> 	'PortalUserId',
															),
									),

					'ItemClass'			=>	Array('class'=>'UserGroups_DBItem','file'=>'user_groups_dbitem.php','build_event'=>'OnItemBuild'),
					'ListClass'			=>	Array('class'=>'kDBList','file'=>'','build_event'=>'OnListBuild'),
					'EventHandlerClass'	=>	Array('class'=>'UserGroupsEventHandler','file'=>'user_groups_eh.php','build_event'=>'OnBuild'),
					'TagProcessorClass' =>	Array('class'=>'kDBTagProcessor','file'=>'','build_event'=>'OnBuild'),
					'AutoLoad'			=>	true,

					'QueryString' => Array (
						1	=>	'id',
						2	=>	'page',
						3	=>	'event',
					),

					'IDField'			=>	'GroupId',

					'TableName'			=>	TABLE_PREFIX.'UserGroup',

					'ListSQLs'			=>	Array(	''=>'	SELECT %1$s.* %2$s FROM %1$s
															LEFT JOIN '.TABLE_PREFIX.'PortalGroup g ON %1$s.GroupId = g.GroupId'),

					'ItemSQLs'			=>	Array(	''=>'	SELECT %1$s.* %2$s FROM %1$s
															LEFT JOIN '.TABLE_PREFIX.'PortalGroup g ON %1$s.GroupId = g.GroupId'),

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

					'CalculatedFields'	=>	Array (
						''	=>	Array(
							'GroupName' => 'g.Name',
							'GroupDescription' => 'g.Description',
						),
					),

					'Fields'			=>	Array(
						'PortalUserId'				=>	Array('type' => 'int', 'not_null' => 1, 'default' => 0),
						'GroupId'					=>	Array('type' => 'int', 'not_null' => 1, 'default' => 0),
						'MembershipExpires' 		=> Array('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => null),
						'PrimaryGroup'				=>	Array('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Yes', 0 => 'la_No'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 1),
						'ExpirationReminderSent'	=>	Array('type' => 'int', 'not_null' => 1, 'default' => 0),
									        ),

					'VirtualFields'	=> Array (
						'GroupName' => Array('type' => 'string'),
						'GroupDescription' => Array('type' => 'string'),
					),


					'Grids'	=> Array(
						'Default'	=>	Array(
							'Icons' => Array ('default' => 'icon16_group.gif'),
							'Fields' => Array(
								'GroupId'			=> Array ('title' => 'la_col_Id', 'data_block' => 'grid_checkbox_td', 'filter_block' => 'grid_range_filter'),
								'GroupName'			=> Array ('title'=>'la_col_GroupName'),
								'GroupDescription'			=> Array ('title'=>'la_col_Description'),
								'PrimaryGroup'	=> Array( 'title'=>'la_col_PrimaryGroup', 'filter_block' => 'grid_options_filter'),
								'MembershipExpires'	=>	Array ('title' => 'la_col_MembershipExpires', 'data_block' => 'grid_membership_td', 'filter_block' => 'grid_date_range_filter'),
							),
						),
					),

	);

?>