<?php

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

Actions::instance()->addLink(new Link(array('id' => 'btn_import',
					    'icon' => Hallinta::instance()->urlbase().'masks/vmail/import.png',
					    'title' => 'Neuen Shared Folder hinzufügen',
					    'function' => 'discover_folder')));

$mask = array(
	      'title' => 'Shared Folder',
	      'table' => 'vmail_folder',
	      'join' => array('vmail_user ON vmail_user_id = vmail_user.id',
			      'vmail_domain ON vmail_domain_id = vmail_domain.id'),
	      'list' => array(
			      'id' => array(
					    'name' => 'ID',
					    'visible' => false,
					    'sql' => 'vmail_folder.id',
					    ),
			      'folder' => array(
					    'name' => 'Folder',
					    'width' => 200,
					    'type' => 'text',
					    'filter' => 't',
					    ),
			      'name' => array(
					    'name' => 'Domain',
					    'visible' => false,
					    'width' => 200,
					    'type' => 'text',
					    'filter' => 's',
					    ),
			      'username' => array(
					    'name' => 'User',
					    'visible' => false,
					    'width' => 200,
					    'type' => 'text',
					    'filter' => 't',
					    ),
			      'email' => array(
					    'name' => 'Username',
					    'width' => 300,
					    'type' => 'text',
					    'filter' => 't',
					    'sql' => "username || '@' || name",
					    ),
			      'delete' => array(
					    'name' => 'Del',
					    'width' => 25,
					    'specs' => array('ClassName' => 'aligncenter', 'canSort' => false),
					    'control' => "new Rico.TableColumn.link('javascript:folder_del({0})')",
					    'sql' => "'<img src=\"".Hallinta::instance()->urlbase()."masks/vmail/delete.png\" title=\"Löschen\">'",
					    ),
			      ),
	      'second' => array(
		  'perms' => array(
			 'title' => 'Freigaben',
			 'table' => 'vmail_user',
			 'rows' => 10,
			 'width' => 400,
			 'join' => array('vmail_domain ON vmail_domain_id = vmail_domain.id'),
			 'where' => 'vmail_user.id <> (SELECT vmail_user_id FROM vmail_folder WHERE id = {id}) AND active = 1',
			 'list' => array(
				 'id' => array(
					       'name' => 'ID',
					       'visible' => false,
					       'sql' => 'vmail_user.id',
					       ),
				 'name' => array(
						 'name' => 'Domain',
						 'visible' => false,
						 'width' => 200,
						 'type' => 'text',
				                 'filter' => 's',
						 ),
				 'username' => array(
						     'name' => 'Username',
						     'visible' => false,
						     'width' => 200,
						     'type' => 'text',
				                     'filter' => 't',
						     ),
				 'email' => array(
						  'name' => 'Username',
						  'width' => 300,
						  'type' => 'text',
						  'sql' => "username || '@' || name",
				                  'filter' => 't',
						  ),
				 'checked' => array(
						    'name' => 'OK',
						    'width' => 40,
						    'sql' => '(SELECT count(*)
                                                               FROM vmail_folder_user
                                                               WHERE vmail_user_id = vmail_user.id
                                                                 AND vmail_folder_id = {id})',
						    'control' => "new Rico.TableColumn.checkboxFunction(folder_checkbox_change, folder_checkbox_all)",
						    'filter' => 'c',
						    'specs' => array('ClassName' => 'aligncenter has-checkbox', 'canSort' => false),
						    ),
					 ),
				   ),
				),
	      );