Merge branch 'stable-3.1'

Marius Burkard

2016-04-20 4569cae57f127afd093794310ccd290d2d9fdf36

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

@@ -13,84 +13,117 @@


// Name of the list
$liste["name"]             = "clients";
$liste["name"]    = "clients";

// Database table
$liste["table"]          = "client";
$liste["table"]   = "client";

// Index index field of the database table
$liste["table_idx"]         = "client_id";
$liste["table_idx"]  = "client_id";

// Search Field Prefix
$liste["search_prefix"]    = "search_";
$liste["search_prefix"]  = "search_";

// Records per page
$liste["records_per_page"]    = 15;
$liste["records_per_page"]  = "15";

// Script File of the list
$liste["file"]            = "client_list.php";
$liste["file"]   = "client_list.php";

// Script file of the edit form
$liste["edit_file"]         = "client_edit.php";
$liste["edit_file"]  = "client_edit.php";

// Script File of the delete script
$liste["delete_file"]      = "client_del.php";
$liste["delete_file"]  = "client_del.php";

// Paging Template
$liste["paging_tpl"]      = "templates/paging.tpl.htm";
$liste["paging_tpl"]  = "templates/paging.tpl.htm";

// Enable authe
$liste["auth"]            = "yes";
$liste["auth"]   = "yes";


/*****************************************************
* Suchfelder
*****************************************************/

$liste["item"][] = array(   'field'      => "client_id",
                     'datatype'   => "INTEGER",
                     'formtype'   => "TEXT",
                     'op'      => "=",
                     'prefix'   => "",
                     'suffix'   => "",
                     'width'      => "",
                     'value'      => "");
$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'     => "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'     => "contact_name",
   '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'     => "customer_no",
   'datatype' => "VARCHAR",
   'formtype' => "TEXT",
   'op' => "like",
   'prefix' => "%",
   'suffix' => "%",
   'width' => "",
   'value' => "");

$liste["item"][] = array(   'field'      => "country",
                     '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' => "");
	
if(is_file(ISPC_WEB_PATH.'/robot/lib/robot_config.inc.php')){
   $liste["item"][] = array( 'field'  => "validation_status",
   'datatype' => "VARCHAR",
   'formtype' => "SELECT",
   'op'  => "=",
   'prefix' => "",
   'suffix' => "",
   'width'  => "",
   'value'  => array('accept' => 'accept', 'review' => 'review', 'reject' => 'reject'));
}

?>