Implemented: FS#479 - Which domains belong to which Client

tbrehm

2010-06-22 7d6ec3d7c30e64d37dedd4ace570a97c1fd2149b

Implemented: FS#479 - Which domains belong to which Client

 interface/web/mail/list/mail_domain.list.php

@@ -13,7 +13,11 @@


// Name of the list
$liste["name"]                 = "mail_domain";
if($_SESSION['s']['user']['typ'] == 'admin') {
    $liste["name"]                 = "mail_domain_admin";
} else {
    $liste["name"]                 = "mail_domain";
}

// Database table
$liste["table"]             = "mail_domain";
@@ -58,6 +62,22 @@
                            'value'        => array('y' => "<div id=\"ir-Yes\" class=\"swap\"><span>Yes</span></div>", 'n' => "<div class=\"swap\" id=\"ir-No\"><span>No</span></div>"));


if($_SESSION['s']['user']['typ'] == 'admin') {
$liste["item"][] = array(    'field'        => "sys_groupid",
                            'datatype'    => "INTEGER",
                            'formtype'    => "SELECT",
                            'op'        => "=",
                            'prefix'    => "",
                            'suffix'    => "",
                            'datasource'    => array (     'type'    => 'SQL',
                                                        'querystring' => 'SELECT groupid, name FROM sys_group WHERE groupid != 1 ORDER BY name',
                                                        'keyfield'=> 'groupid',
                                                        'valuefield'=> 'name'
                                                       ),
                            'width'        => "",
                            'value'        => "");
}


$liste["item"][] = array(    'field'        => "server_id",
                            'datatype'    => "VARCHAR",

 interface/web/sites/list/database.list.php

@@ -13,7 +13,11 @@


// Name of the list
$liste["name"]                 = "database";
if($_SESSION['s']['user']['typ'] == 'admin') {
    $liste["name"]                 = "database_admin";
} else {
    $liste["name"]                 = "database";
}

// Database table
$liste["table"]             = "web_database";
@@ -66,6 +70,22 @@
                            'width'        => "",
                            'value'        => array('y' => "Yes",'n' => "No"));

if($_SESSION['s']['user']['typ'] == 'admin') {
$liste["item"][] = array(    'field'        => "sys_groupid",
                            'datatype'    => "INTEGER",
                            'formtype'    => "SELECT",
                            'op'        => "=",
                            'prefix'    => "",
                            'suffix'    => "",
                            'datasource'    => array (     'type'    => 'SQL',
                                                        'querystring' => 'SELECT groupid, name FROM sys_group WHERE groupid != 1 ORDER BY name',
                                                        'keyfield'=> 'groupid',
                                                        'valuefield'=> 'name'
                                                       ),
                            'width'        => "",
                            'value'        => "");
}

$liste["item"][] = array(    'field'        => "server_id",
                            'datatype'    => "VARCHAR",
                            'formtype'    => "SELECT",

 interface/web/sites/list/web_domain.list.php

@@ -13,7 +13,11 @@


// Name of the list
$liste["name"]                 = "web_domain";
if($_SESSION['s']['user']['typ'] == 'admin') {
    $liste["name"]                 = "web_domain_admin";
} else {
    $liste["name"]                 = "web_domain";
}

// Database table
$liste["table"]             = "web_domain";
@@ -66,13 +70,28 @@
                            'width'        => "",
                            'value'        => array('y' => "<div id=\"ir-Yes\" class=\"swap\"><span>Yes</span></div>",'n' => "<div class=\"swap\" id=\"ir-No\"><span>No</span></div>"));


$liste["item"][] = array(    'field'        => "server_id",
                            'datatype'    => "VARCHAR",
if($_SESSION['s']['user']['typ'] == 'admin') {
$liste["item"][] = array(    'field'        => "sys_groupid",
                            'datatype'    => "INTEGER",
                            'formtype'    => "SELECT",
                            'op'        => "like",
                            'prefix'    => "%",
                            'suffix'    => "%",
                            'op'        => "=",
                            'prefix'    => "",
                            'suffix'    => "",
                            'datasource'    => array (     'type'    => 'SQL',
                                                        'querystring' => 'SELECT groupid, name FROM sys_group WHERE groupid != 1 ORDER BY name',
                                                        'keyfield'=> 'groupid',
                                                        'valuefield'=> 'name'
                                                       ),
                            'width'        => "",
                            'value'        => "");
}
	
$liste["item"][] = array(    'field'        => "server_id",
                            'datatype'    => "INTEGER",
                            'formtype'    => "SELECT",
                            'op'        => "=",
                            'prefix'    => "",
                            'suffix'    => "",
                            'datasource'    => array (     'type'    => 'SQL',
                                                        'querystring' => 'SELECT a.server_id, a.server_name FROM server a, web_domain b WHERE (a.server_id = b.server_id) AND ({AUTHSQL-B}) ORDER BY a.server_name',
                                                        'keyfield'=> 'server_id',

 interface/web/sites/templates/web_domain_list.htm

@@ -25,7 +25,7 @@
            <th class="tbl_col_buttons" scope="col">&nbsp;</th>
          </tr>
          <tr>
            <td class="tbl_col_domain_id"><input type="text" name="search_domain_id" value="{tmpl_var name='search_domain_id'}" /></td>
            <td class="tbl_col_domain_id"><input type="text" size="5" name="search_domain_id" value="{tmpl_var name='search_domain_id'}" /></td>
            <td class="tbl_col_active"><select name="search_active" onChange="submitForm('pageForm','sites/web_domain_list.php');">{tmpl_var name='search_active'}</select></td>
            <td class="tbl_col_server_id"><select name="search_server_id" onChange="submitForm('pageForm','sites/web_domain_list.php');">{tmpl_var name='search_server_id'}</select></td>
            <td class="tbl_col_domain"><input type="text" name="search_domain" value="{tmpl_var name='search_domain'}" /></td>