Marius Cramer
2013-10-14 d9bcf68e395d6156645a7974b1a992aa6e6c00aa
interface/web/client/list/client.list.php
@@ -1,86 +1,118 @@
<?php
/*
   Datatypes:
   - INTEGER
   - DOUBLE
   - CURRENCY
   - VARCHAR
   - TEXT
   - DATE
*/
// Name of the list
$liste["name"]             = "resellers";
// Database table
$liste["table"]          = "reseller";
// Index index field of the database table
$liste["table_idx"]         = "reseller_id";
// Search Field Prefix
$liste["search_prefix"]    = "search_";
// Records per page
$liste["records_per_page"]    = 15;
// Script File of the list
$liste["file"]            = "reseller_list.php";
// Script file of the edit form
$liste["edit_file"]         = "reseller_edit.php";
// Script File of the delete script
$liste["delete_file"]      = "reseller_del.php";
// Paging Template
$liste["paging_tpl"]      = "templates/paging.tpl.htm";
// Enable authe
$liste["auth"]            = "yes";
/*****************************************************
* Suchfelder
*****************************************************/
$liste["item"][] = array(   'field'      => "company",
                     'datatype'   => "VARCHAR",
                     'formtype'   => "TEXT",
                     'op'      => "like",
                     'prefix'   => "%",
                     'suffix'   => "%",
                     'width'      => "",
                     'value'      => "");
$liste["item"][] = array(   'field'      => "firstname",
                     'datatype'   => "VARCHAR",
                     'formtype'   => "TEXT",
                     'op'      => "like",
                     'prefix'   => "%",
                     'suffix'   => "%",
                     'width'      => "",
                     'value'      => "");
$liste["item"][] = array(   'field'      => "surname",
                     'datatype'   => "VARCHAR",
                     'formtype'   => "TEXT",
                     'op'      => "like",
                     'prefix'   => "%",
                     'suffix'   => "%",
                     'width'      => "",
                     'value'      => "");
$liste["item"][] = array(   'field'      => "city",
                     'datatype'   => "VARCHAR",
                     'formtype'   => "TEXT",
                     'op'      => "like",
                     'prefix'   => "%",
                     'suffix'   => "%",
                     'width'      => "",
                     'value'      => "");
<?php
/*
   Datatypes:
   - INTEGER
   - DOUBLE
   - CURRENCY
   - VARCHAR
   - TEXT
   - DATE
*/
// Name of the list
$liste["name"]          = "clients";
// Database table
$liste["table"]       = "client";
// Index index field of the database table
$liste["table_idx"]      = "client_id";
// Search Field Prefix
$liste["search_prefix"]    = "search_";
// Records per page
$liste["records_per_page"]    = "15";
// Script File of the list
$liste["file"]         = "client_list.php";
// Script file of the edit form
$liste["edit_file"]      = "client_edit.php";
// Script File of the delete script
$liste["delete_file"]      = "client_del.php";
// Paging Template
$liste["paging_tpl"]      = "templates/paging.tpl.htm";
// Enable authe
$liste["auth"]         = "yes";
/*****************************************************
* Suchfelder
*****************************************************/
$liste["item"][] = array(   'field'     => "client_id",
                            'datatype'   => "INTEGER",
                            'formtype'   => "TEXT",
                            'op'   => "=",
                            'prefix'   => "",
                            'suffix'   => "",
                            'width'   => "",
                            'value'   => "");
$liste["item"][] = array(   'field'     => "company_name",
                            'datatype'   => "VARCHAR",
                            'formtype'   => "TEXT",
                            'op'   => "like",
                            'prefix'   => "%",
                            'suffix'   => "%",
                            'width'   => "",
                            'value'   => "");
$liste["item"][] = array(   'field'     => "contact_name",
                            'datatype'   => "VARCHAR",
                            'formtype'   => "TEXT",
                            'op'   => "like",
                            'prefix'   => "%",
                            'suffix'   => "%",
                            'width'   => "",
                            'value'   => "");
$liste["item"][] = array(   'field'     => "customer_no",
                            'datatype'   => "VARCHAR",
                            'formtype'   => "TEXT",
                            'op'   => "like",
                            'prefix'   => "%",
                            'suffix'   => "%",
                            'width'   => "",
                            'value'   => "");
$liste["item"][] = array(   'field'     => "username",
                            'datatype'   => "VARCHAR",
                            'formtype'   => "TEXT",
                            'op'   => "like",
                            'prefix'   => "%",
                            'suffix'   => "%",
                            'width'   => "",
                            'value'   => "");
$liste["item"][] = array(   'field'     => "city",
                            'datatype'   => "VARCHAR",
                            'formtype'   => "TEXT",
                            'op'   => "like",
                            'prefix'   => "%",
                            'suffix'   => "%",
                            'width'   => "",
                            'value'   => "");
$liste["item"][] = array(   'field'     => "country",
                            'datatype'   => "VARCHAR",
                            'formtype'   => "SELECT",
                            'op'   => "=",
                            'prefix'   => "",
                            'suffix'   => "",
                            'datasource'=> array (  'type'          => 'SQL',
                                                    'querystring'   => 'SELECT iso,printable_name FROM country ORDER BY iso ASC',
                                                    'keyfield'      => 'iso',
                                                    'valuefield'    => 'printable_name'
                                                ),
                            'width'   => "",
                            'value'   => "");
?>