From 3fc28c0142bf8ab4e2cfae44931e2a51aadc4d51 Mon Sep 17 00:00:00 2001
From: mcramer <m.cramer@pixcept.de>
Date: Mon, 25 Feb 2013 13:51:37 -0500
Subject: [PATCH] - Added: remoting queries with a lot of results (e.g. email addresses or alias domains or dns rr) lead to non-functioning soap requests   - added '#OFFSET#' AND '#LIMIT#' handling to the query   - added automatic 'WHERE 1' if an empty array was given as query   example: $result = $api->sites_web_domain_get('type' => 'vhost', '#OFFSET#' => 25, '#LIMIT#' => 50); to get the websites 26 to 75

---
 interface/web/client/list/client.list.php |   16 +++++++++++++++-
 1 files changed, 15 insertions(+), 1 deletions(-)

diff --git a/interface/web/client/list/client.list.php b/interface/web/client/list/client.list.php
index 2d45179..0169810 100644
--- a/interface/web/client/list/client.list.php
+++ b/interface/web/client/list/client.list.php
@@ -72,7 +72,16 @@
                             'prefix'	=> "%",
                             'suffix'	=> "%",
                             'width'	=> "",
-                            'value'	=> "");  
+                            'value'	=> "");
+
+$liste["item"][] = array(   'field'     => "customer_no",
+                            'datatype'	=> "VARCHAR",
+                            'formtype'	=> "TEXT",
+                            'op'	=> "like",
+                            'prefix'	=> "%",
+                            'suffix'	=> "%",
+                            'width'	=> "",
+                            'value'	=> "");							
 
 $liste["item"][] = array(   'field'     => "username",
                             'datatype'	=> "VARCHAR",
@@ -98,6 +107,11 @@
                             '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'	=> "");
 

--
Gitblit v1.9.1