From d4d985e00f1f70dd390bd5aaf40062416d73f4e7 Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Mon, 17 Nov 2008 12:02:44 -0500
Subject: [PATCH] Data records are now assigned to the correct client group if they were created by the administrator.

---
 interface/lib/classes/plugin_listview.inc.php |   19 ++++++++++++++++---
 1 files changed, 16 insertions(+), 3 deletions(-)

diff --git a/interface/lib/classes/plugin_listview.inc.php b/interface/lib/classes/plugin_listview.inc.php
index 762e5a7..771cd5b 100644
--- a/interface/lib/classes/plugin_listview.inc.php
+++ b/interface/lib/classes/plugin_listview.inc.php
@@ -28,6 +28,7 @@
                 // $app->listform->listDef["page_params"] = "&id=".$app->tform_actions->id."&next_tab=".$_SESSION["s"]["form"]["tab"];
 				$app->listform->listDef["page_params"] = "&id=".$this->form->id."&next_tab=".$_SESSION["s"]["form"]["tab"];
 				$listTpl->setVar('parent_id',$this->form->id);
+				$listTpl->setVar('theme', $_SESSION['s']['theme']);
 
                 // Generate the SQL for searching
                 if($app->listform->listDef["auth"] != 'no') {
@@ -49,10 +50,14 @@
                 $limit_sql = $app->listform->getPagingSQL($sql_where);
                 $listTpl->setVar("paging",$app->listform->pagingHTML);
 				
+				$sql_order_by = '';
+				if(isset($this->options["sql_order_by"])) {
+					$sql_order_by = $this->options["sql_order_by"];
+				}
 				
 
                 // Get the data
-                $records = $app->db->queryAllRecords("SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $limit_sql");
+                $records = $app->db->queryAllRecords("SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $sql_order_by $limit_sql");
 
                 $bgcolor = "#FFFFFF";
                 if(is_array($records)) {
@@ -69,18 +74,26 @@
 								foreach($app->listform->listDef["item"] as $field) {
 									$key = $field["field"];
 									if($field['formtype'] == "SELECT") {
-										$rec[$key] = $field['value'][$rec[$key]];
+										if(strtolower($rec[$key]) == 'y' or strtolower($rec[$key]) == 'n') {
+											// Set a additional image variable for bolean fields
+											$rec['_'.$key.'_'] = (strtolower($rec[$key]) == 'y')?'x16/tick_circle.png':'x16/cross_circle.png';
+										}
+										//* substitute value for select field
+										@$rec[$key] = $field['value'][$rec[$key]];
 									}
+									// Create a lowercase version of every item
+									$rec[$key.'_lowercase'] = strtolower($rec[$key]);
 								}
 
                                 // The variable "id" contains always the index field
                                 $rec["id"] = $rec[$idx_key];
+								$rec["delete_confirmation"] = $app->lng('delete_confirmation');
 
                                 $records_new[] = $rec;
                         }
                 }
 
-                $listTpl->setLoop('records',$records_new);
+                $listTpl->setLoop('records',@$records_new);
 
                 // Loading language field
                 $lng_file = "lib/lang/".$_SESSION["s"]["language"]."_".$app->listform->listDef['name']."_list.lng";

--
Gitblit v1.9.1