<?php

JavaScript::instance()->file('lib/ricoTableColumnDB.js');

$mask = array(
	      'table' => 'sys_group',
	      'title' => 'Gruppenverwaltung',
	      'list' => array(
			      'id' => array(
					    'name' => 'ID',
					    'visible' => false,
					    ),
			      'gname' => array(
					    'name' => 'Gruppe',
					    'width' => 70,
					    ),
			      'name' => array(
					    'name' => 'Name',
					    'width' => 150,
					    ),
			      'sys_user' => array(
					    'name' => 'Bearb.',
					    'width' => 50,
					    ),
			      'sys_edit' => array(
					    'name' => 'Geändert',
					    'width' => 80,
					    'type' => 'date',
					    'specs' => array('dateFmt' => 'yyyy-mm-dd'),
					    ),
			      ),
	      'second' => array(
		  'user' => array(
			 'title' => 'Mitglieder',
			 'table' => 'sys_user',
			 'rows' => 10,
			 'width' => 410,
			 'list' => array(
					 'id' => array(
						       'name' => 'ID',
						       'visible' => false,
						       'sql' => 'sys_user.id',
						       ),
					 'login' => array(
							  'name' => 'Login',
							  'width' => 70,
							  ),
					 'name' => array(
							 'name' => 'Name',
							 'width' => 120,
							 'sql' => 'sys_user.name',
							 ),
					 'email' => array(
							  'name' => 'E-Mail',
							  'width' => 150,
							  ),
					 'checked' => array(
							    'name' => 'Perm',
							    'width' => 40,
							    'sql' => '(SELECT count(*)
                                                               FROM sys_group_user
                                                               WHERE sys_user_id = sys_user.id
                                                                 AND sys_group_id = {id})',
							    'control' => "new Rico.TableColumn.checkboxDB(0," .
									 "Hallinta.baseURL+'ajax/ricoUpdateConnection.php')",
							    'filter' => 'c',
							    'specs' => array('ClassName' => 'aligncenter has-checkbox', 'canSort' => true),
							    'update' => array('table' => 'sys_group_user',
									      'basecol' => 'sys_group_id',
									      'refcol' => 'sys_user_id',
									      'reftable' => 'sys_user',
									      'refid' => 'sys_user.id',
									      ),
							    ),
					 ),
				   ),
		  'menuitems' => array(
			 'title' => 'Menüpunkte',
			 'table' => 'sys_menuitem',
			 'rows' => 15,
			 'width' => 500,
			 'list' => array(
					 'id' => array(
						       'name' => 'ID',
						       'visible' => false,
						       'sql' => 'sys_menuitem.id',
						       ),
					 'parent' => array(
							   'name' => 'Super',
							   'sqltype' => 'int',
							   'filter' => 's',
							   'width' => 120,
							   'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('sys_menuitem','id','title', [0 => 'Root']).", 0, '')",
							   ),
					 'priority' => array(
							     'name' => 'Prio',
							     'width' => 50,
							     'type' => 'number',
							     'specs' => array('ClassName' => 'aligncenter'),
							     'visible' => false,
							     ),
					 'module' => array(
							   'filter' => 's',
							   'name' => 'Modul',
							   'width' => 90,
							   ),
					 'page' => array(
							 'filter' => 't',
							 'name' => 'Page',
							 'width' => 100,
							 ),
					 'title' => array(
							  'name' => 'Titel',
							  'filter' => 't',
							  'width' => 100,
							  ),
					 'checked' => array(
							    'name' => 'Perm',
							    'width' => 40,
							    'sql' => '(SELECT count(*)
                                                               FROM sys_group_menuitem
                                                               WHERE sys_menuitem_id = sys_menuitem.id
                                                                 AND sys_group_id = {id})',
							    'control' => "new Rico.TableColumn.checkboxDB(0," .
									 "Hallinta.baseURL+'ajax/ricoUpdateConnection.php')",
							    'filter' => 'c',
							    'specs' => array('ClassName' => 'aligncenter has-checkbox', 'canSort' => true),
							    'update' => array('table' => 'sys_group_menuitem',
									      'basecol' => 'sys_group_id',
									      'refcol' => 'sys_menuitem_id',
									      'reftable' => 'sys_menuitem',
									      'refid' => 'sys_menuitem.id',
									      ),
							    ),
					 ),
				   ),
				),
	      'edit' => array(
			      'gname' => array(
					    'name' => 'Gruppe',
					    'type' => 'text',
					    'size' => 20,
					    ),
			      'name' => array(
					    'name' => 'Name',
					    'type' => 'text',
					    'size' => 20,
					    ),
			      ),
	      );