From e1ceb050e19c7574bca146a8da7047ee4ff456b5 Mon Sep 17 00:00:00 2001
From: Marius Burkard <m.burkard@pixcept.de>
Date: Sun, 10 Jul 2016 05:02:35 -0400
Subject: [PATCH] Merge branch 'stable-3.1'

---
 interface/web/client/list/client.list.php |  215 ++++++++++++++++++++++++++++++++---------------------
 1 files changed, 129 insertions(+), 86 deletions(-)

diff --git a/interface/web/client/list/client.list.php b/interface/web/client/list/client.list.php
index 5961db8..ae41bef 100644
--- a/interface/web/client/list/client.list.php
+++ b/interface/web/client/list/client.list.php
@@ -1,86 +1,129 @@
-<?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'		=> "");
-
-?>
\ No newline at end of file
+<?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' => "");
+	
+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'));
+}
+
+?>

--
Gitblit v1.9.1