standard sorting by main characteristic for most lists

cfoe

2012-07-17 222ea214ffc25abac78e9d520ef34865280a0bab

standard sorting by main characteristic for most lists

 interface/web/client/client_edit.php

@@ -101,7 +101,7 @@

        global $app;

        $sql = "SELECT template_id,template_name FROM client_template WHERE template_type = 'a'";
        $sql = "SELECT template_id,template_name FROM client_template WHERE template_type = 'a' ORDER BY template_name ASC";
        $tpls = $app->db->queryAllRecords($sql);
        $option = '';
        $tpl = array();

 interface/web/client/client_template_list.php

@@ -44,5 +44,6 @@
if(!$_SESSION["s"]["user"]["typ"] == 'admin') die('Client-Templates are only for Admins.');

$app->uses('listform_actions');
$app->listform_actions->SQLOrderBy = 'ORDER BY template_name';
$app->listform_actions->onLoad();
?>

 interface/web/client/form/client.tform.php

@@ -235,11 +235,10 @@
        ),
        'country' => array (
            'datatype'    => 'VARCHAR',

            'formtype'    => 'SELECT',
            'default'    => (isset($conf['language']) ? strtoupper($conf['language']) : ''),
            'datasource'    => array (     'type'    => 'SQL',
                                        'querystring' => 'SELECT iso,printable_name FROM country ORDER BY printable_name',
                                                    'querystring'   => 'SELECT iso,printable_name FROM country ORDER BY iso ASC',
                                        'keyfield'=> 'iso',
                                        'valuefield'=> 'printable_name'
                                     ),

 interface/web/client/list/client.list.php

@@ -94,12 +94,11 @@

$liste["item"][] = array(    'field'        => "country",
                            'datatype'    => "VARCHAR",
                            'formtype'    => "TEXT",
                            'op'        => "like",
                            'prefix'    => "%",
                            'suffix'    => "%",
                            'formtype'    => "SELECT",
                            'op'    => "=",
                            'prefix'    => "",
                            'suffix'    => "",
                            'width'        => "",
                            'value'        => "");


?>

 interface/web/client/list/reseller.list.php

@@ -85,12 +85,11 @@

$liste["item"][] = array(    'field'        => "country",
                            'datatype'    => "VARCHAR",
                            'formtype'    => "TEXT",
                            'op'        => "like",
                            'prefix'    => "%",
                            'suffix'    => "%",
                            'formtype'    => "SELECT",
                            'op'    => "=",
                            'prefix'    => "",
                            'suffix'    => "",
                            'width'        => "",
                            'value'        => "");


?>

 interface/web/client/templates/clients_list.htm

@@ -32,7 +32,7 @@
                        <td class="tbl_col_contact_name"><input type="text" name="search_contact_name" value="{tmpl_var name='search_contact_name'}" style="width:120px;" /></td>
                        <td class="tbl_col_username"><input type="text" name="search_username" value="{tmpl_var name='search_username'}" style="width:120px;" /></td>
                        <td class="tbl_col_city"><input type="text" name="search_city" value="{tmpl_var name='search_city'}" style="width:120px;" /></td>
                        <td class="tbl_col_country"><input type="text" name="search_country" value="{tmpl_var name='search_country'}" style="width:30px;" /></td>
                        <td class="tbl_col_country"><select name="search_country" style="width:120px;">{tmpl_var name='search_country'}</select></td>
                        <td class="tbl_col_buttons"><div class="buttons"><button type="button" class="icons16 icoFilter" name="Filter" id="Filter" value="{tmpl_var name="filter_txt"}" onClick="submitForm('pageForm','client/client_list.php');"><span>{tmpl_var name="filter_txt"}</span></button></div></td>
                    </tr>
                </thead>

 interface/web/client/templates/resellers_list.htm

@@ -30,7 +30,7 @@
                        <td class="tbl_col_company_name"><input type="text" name="search_company_name" value="{tmpl_var name='search_company_name'}" style="width:120px;" /></td>
                        <td class="tbl_col_contact_name"><input type="text" name="search_contact_name" value="{tmpl_var name='search_contact_name'}" style="width:120px;" /></td>
                        <td class="tbl_col_city"><input type="text" name="search_city" value="{tmpl_var name='search_city'}" style="width:120px;" /></td>
                        <td class="tbl_col_country"><input type="text" name="search_country" value="{tmpl_var name='search_country'}" style="width:30px;" /></td>
                        <td class="tbl_col_country"><select name="search_country" style="width:120px;">{tmpl_var name='search_country'}</select></td>
                        <td class="tbl_col_buttons"><div class="buttons"><button type="button" class="icons16 icoFilter" name="Filter" id="Filter" value="{tmpl_var name="filter_txt"}" onClick="submitForm('pageForm','client/reseller_list.php');"><span>{tmpl_var name="filter_txt"}</span></button></div></td>
                    </tr>
                </thead>

 interface/web/dns/dns_template_list.php

@@ -18,6 +18,7 @@
$app->uses('listform_actions');
// $app->listform_actions->SQLExtWhere = "access = 'REJECT'";

$app->listform_actions->SQLOrderBy = 'ORDER BY name';
$app->listform_actions->onLoad();



 interface/web/dns/dns_wizard.php

@@ -56,7 +56,7 @@


// Load the templates
$records = $app->db->queryAllRecords("SELECT * FROM dns_template WHERE visible = 'Y'");
$records = $app->db->queryAllRecords("SELECT * FROM dns_template WHERE visible = 'Y' ORDER BY name ASC");
$template_id_option = '';
$n = 0;
foreach($records as $rec){

 interface/web/dns/list/dns_slave.list.php

@@ -89,9 +89,5 @@
                            'suffix'    => "%",
                            'width'        => "",
                            'value'        => "");





?>

 interface/web/dns/list/dns_template.list.php

@@ -66,15 +66,5 @@
                            'suffix'    => "%",
                            'width'        => "",
                            'value'        => "");











?>

 interface/web/domain/domain_list.php

@@ -46,6 +46,7 @@

$app->uses('listform_actions');

$app->listform_actions->SQLOrderBy = 'ORDER BY domain';
$app->listform_actions->onLoad();

?>

 interface/web/mail/mail_domain_list.php

@@ -21,6 +21,7 @@
// Limit the results to alias domains
// $app->listform_actions->SQLExtWhere = "type = 'local'";

$app->listform_actions->SQLOrderBy = 'ORDER BY domain';
$app->listform_actions->onLoad();



 interface/web/sites/database_list.php

@@ -67,6 +67,7 @@
}

$list = new list_action;
$list->SQLOrderBy = 'ORDER BY database_name';
$list->onLoad();



 interface/web/sites/ftp_user_list.php

@@ -68,6 +68,7 @@
}

$list = new list_action;
$list->SQLOrderBy = 'ORDER BY username';
$list->onLoad();



 interface/web/sites/shell_user_list.php

@@ -49,6 +49,7 @@
// Limit the results to alias domains
//$app->listform_actions->SQLExtWhere = "type = 'subdomain'";

$app->listform_actions->SQLOrderBy = 'ORDER BY username';
$app->listform_actions->onLoad();



 interface/web/sites/user_quota_stats.php

@@ -88,7 +88,7 @@

$list = new list_action;
$list->SQLExtWhere = "type = 'vhost'";

$list->SQLOrderBy = 'ORDER BY domain';
$list->onLoad();



 interface/web/sites/web_aliasdomain_list.php

@@ -48,7 +48,7 @@

// Limit the results to alias domains
$app->listform_actions->SQLExtWhere = "type = 'alias'";

$app->listform_actions->SQLOrderBy = 'ORDER BY domain';
$app->listform_actions->onLoad();



 interface/web/sites/web_domain_list.php

@@ -53,7 +53,7 @@

$list = new list_action;
$list->SQLExtWhere = "type = 'vhost'";
$list->SQLOrderBy = 'ORDER BY domain';
$list->onLoad();


?>

 interface/web/sites/web_sites_stats.php

@@ -59,7 +59,7 @@

$list = new list_action;
$list->SQLExtWhere = "type = 'vhost'";

$list->SQLOrderBy = 'ORDER BY domain';
$list->onLoad();



 interface/web/sites/web_subdomain_list.php

@@ -48,7 +48,7 @@

// Limit the results to alias domains
$app->listform_actions->SQLExtWhere = "type = 'subdomain'";

$app->listform_actions->SQLOrderBy = 'ORDER BY domain';
$app->listform_actions->onLoad();



 interface/web/sites/webdav_user_list.php

@@ -44,7 +44,7 @@
$app->auth->check_module_permissions('sites');

$app->uses('listform_actions');

$app->listform_actions->SQLOrderBy = 'ORDER BY username';
$app->listform_actions->onLoad();



 interface/web/vm/openvz_ip_list.php

@@ -47,8 +47,8 @@

$app->uses('listform_actions');

// $app->listform_actions->SQLOrderBy = 'ORDER BY company_name, contact_name, client_id';
// $app->listform_actions->SQLExtWhere = "limit_client = 0";
$app->listform_actions->SQLOrderBy = 'ORDER BY server_id,ip_address';
$app->listform_actions->onLoad();