<?php

$mask = array(
	      'table' => 'sys_theme_values',
	      'title' => 'Liste der Farben',
	      'join' => array(
			      'sys_themes ON sys_theme_values.theme = sys_themes.id',
			      'sys_theme_items ON sys_theme_values.item = sys_theme_items.id',
			      ),
	      'list' => array(
			      'id' => array(
					    'name' => 'ID',
					    'visible' => false,
					    'sql' => 'sys_theme_values.id',
					    ),
			      'theme' => array(
					    'name' => 'Theme',
					    'width' => 80,
					    'filter' => 's',
					    'specs' => array('ClassName' => 'aligncenter'),
					    'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('sys_themes','id','name').", 0, '')",
					    'distinct' => "SELECT DISTINCT theme,sys_themes.name FROM sys_theme_values JOIN sys_themes ON theme = sys_themes.id ORDER BY name",
					    ),
			      'item' => array(
					    'name' => 'Item',
					    'width' => 170,
					    'filterUI' => 's',
					    'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('sys_theme_items','id','name').", 0, '')",
					    'distinct' => "SELECT DISTINCT item,sys_theme_items.name FROM sys_theme_values JOIN sys_theme_items ON item = sys_theme_items.id ORDER BY name",
					    ),
			      'value' => array(
					    'name' => 'Value',
					    'width' => 200,
					    ),
			      'title' => array(
					    'name' => 'title',
					    'width' => 300,
					    ),
			      ),
	      'edit' => array(
			      'theme' => array(
					    'name' => 'Theme',
					    'type' => 'select',
					    'options' => 'SELECT id,name AS text FROM sys_themes ORDER BY name',
					    ),
			      'item' => array(
					    'name' => 'Item',
					    'type' => 'select',
					    'options' => 'SELECT id,name AS text FROM sys_theme_items ORDER BY name',
					    ),
			      'value' => array(
					    'name' => 'Value',
					    'type' => 'text',
					    'size' => 25,
					    ),
			      ),
	      );

?>