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/dns/list/dns_slave.list.php |  125 ++++++++++++++++++++++++-----------------
 1 files changed, 74 insertions(+), 51 deletions(-)

diff --git a/interface/web/dns/list/dns_slave.list.php b/interface/web/dns/list/dns_slave.list.php
index aaa09e0..529a189 100644
--- a/interface/web/dns/list/dns_slave.list.php
+++ b/interface/web/dns/list/dns_slave.list.php
@@ -13,34 +13,38 @@
 
 
 // Name of the list
-$liste["name"] 				= "dns_slave";
+if($_SESSION['s']['user']['typ'] == 'admin') {
+	$liste["name"]     = "dns_slave_admin";
+} else {
+	$liste["name"]     = "dns_slave";
+}
 
 // Database table
-$liste["table"] 			= "dns_slave";
+$liste["table"]   = "dns_slave";
 
 // Index index field of the database table
-$liste["table_idx"]			= "id";
+$liste["table_idx"]  = "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"]				= "dns_slave_list.php";
+$liste["file"]   = "dns_slave_list.php";
 
 // Script file of the edit form
-$liste["edit_file"]			= "dns_slave_edit.php";
+$liste["edit_file"]  = "dns_slave_edit.php";
 
 // Script File of the delete script
-$liste["delete_file"]		= "dns_slave_del.php";
+$liste["delete_file"]  = "dns_slave_del.php";
 
 // Paging Template
-$liste["paging_tpl"]		= "templates/paging.tpl.htm";
+$liste["paging_tpl"]  = "templates/paging.tpl.htm";
 
 // Enable auth
-$liste["auth"]				= "yes";
+$liste["auth"]   = "yes";
 
 
 /*****************************************************
@@ -48,50 +52,69 @@
 *****************************************************/
 
 
-$liste["item"][] = array(	'field'		=> "active",
-							'datatype'	=> "VARCHAR",
-							'formtype'	=> "SELECT",
-							'op'		=> "=",
-							'prefix'	=> "",
-							'suffix'	=> "",
-							'width'		=> "",
-							'value'		=> array('Y' => "<div id=\"ir-Yes\" class=\"swap\"><span>Yes</span></div>",'N' => "<div class=\"swap\" id=\"ir-No\"><span>No</span></div>"));
+$liste["item"][] = array(   'field'     => "active",
+	'datatype' => "VARCHAR",
+	'formtype' => "SELECT",
+	'op' => "=",
+	'prefix' => "",
+	'suffix' => "",
+	'width' => "",
+	'value' => array('Y' => "<div id=\"ir-Yes\" class=\"swap\"><span>".$app->lng('yes_txt')."</span></div>", 'N' => "<div class=\"swap\" id=\"ir-No\"><span>".$app->lng('no_txt')."</span></div>"));
 
 
-$liste["item"][] = array(	'field'		=> "server_id",
-							'datatype'	=> "VARCHAR",
-							'formtype'	=> "SELECT",
-							'op'		=> "like",
-							'prefix'	=> "%",
-							'suffix'	=> "%",
-							'datasource'	=> array ( 	'type'	=> 'CUSTOM',
-														'class'=> 'custom_datasource',
-														'function'=> 'dns_servers'
-									 				  ),
-							'width'		=> "",
-							'value'		=> "");
+$liste["item"][] = array(   'field' => "server_id",
+	'datatype' => "VARCHAR",
+	'formtype' => "SELECT",
+	'op' => "like",
+	'prefix' => "%",
+	'suffix' => "%",
+	'datasource'=> array (  'type' => 'CUSTOM',
+		'class' => 'custom_datasource',
+		'function' => 'slave_dns_servers'
+	),
+	'width' => "",
+	'value' => "");
+	
+if($_SESSION['s']['user']['typ'] == 'admin') {
+	$liste["item"][] = array( 'field'  => "sys_groupid",
+		'datatype' => "INTEGER",
+		'formtype' => "SELECT",
+		'op'  => "=",
+		'prefix' => "",
+		'suffix' => "",
+		'datasource' => array (  'type' => 'SQL',
+			//'querystring' => 'SELECT groupid, name FROM sys_group WHERE groupid != 1 ORDER BY name',
+			'querystring' => "SELECT sys_group.groupid,CONCAT(IF(client.company_name != '', CONCAT(client.company_name, ' :: '), ''), IF(client.contact_firstname != '', CONCAT(client.contact_firstname, ' '), ''), client.contact_name, ' (', client.username, IF(client.customer_no != '', CONCAT(', ', client.customer_no), ''), ')') as name FROM sys_group, client WHERE sys_group.groupid != 1 AND sys_group.client_id = client.client_id ORDER BY client.company_name, client.contact_name",
+			'keyfield'=> 'groupid',
+			'valuefield'=> 'name'
+		),
+		'width'  => "",
+		'value'  => "");
+}
 
-$liste["item"][] = array(	'field'		=> "origin",
-							'datatype'	=> "VARCHAR",
-							'formtype'	=> "TEXT",
-							'op'		=> "like",
-							'prefix'	=> "%",
-							'suffix'	=> "%",
-							'width'		=> "",
-							'value'		=> "");
+$liste["item"][] = array(   'field' => "origin",
+	'datatype' => "VARCHAR",
+	'filters'   => array( 0 => array( 'event' => 'SHOW',
+			'type' => 'IDNTOUTF8')
+	),
+	'formtype' => "TEXT",
+	'op' => "like",
+	'prefix' => "%",
+	'suffix' => "%",
+	'width' => "",
+	'value' => "");
 
 
-$liste["item"][] = array(	'field'		=> "ns",
-							'datatype'	=> "VARCHAR",
-							'formtype'	=> "TEXT",
-							'op'		=> "like",
-							'prefix'	=> "%",
-							'suffix'	=> "%",
-							'width'		=> "",
-							'value'		=> "");
+$liste["item"][] = array(   'field' => "ns",
+	'datatype' => "VARCHAR",
+	'filters'   => array( 0 => array( 'event' => 'SHOW',
+			'type' => 'IDNTOUTF8')
+	),
+	'formtype' => "TEXT",
+	'op' => "like",
+	'prefix' => "%",
+	'suffix' => "%",
+	'width' => "",
+	'value' => "");
 
-
-
-
-
-?>
\ No newline at end of file
+?>

--
Gitblit v1.9.1