From daff5cb75bce6d6b0cbed092c3b807bb04fade9b Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Thu, 31 May 2007 11:15:12 -0400 Subject: [PATCH] diverse updates. --- interface/lib/classes/listform_actions.inc.php | 19 +++++++++++++++++-- 1 files changed, 17 insertions(+), 2 deletions(-) diff --git a/interface/lib/classes/listform_actions.inc.php b/interface/lib/classes/listform_actions.inc.php index c76a23c..519d661 100644 --- a/interface/lib/classes/listform_actions.inc.php +++ b/interface/lib/classes/listform_actions.inc.php @@ -41,12 +41,17 @@ var $idx_key; var $DataRowColor; var $SQLExtWhere = ''; + var $SQLOrderBy = ''; function onLoad() { global $app, $conf, $list_def_file; if(!is_object($app->tpl)) $app->uses('tpl'); if(!is_object($app->listform)) $app->uses('listform'); + if(!is_object($app->tform)) $app->uses('tform'); + + // Clear session variable that is used when lists are embedded with the listview plugin + $_SESSION["s"]["form"]["return_to"] = ''; // Load list definition $app->listform->loadListDef($list_def_file); @@ -56,7 +61,7 @@ $app->listform_tpl_generator->buildHTML($app->listform->listDef); } - $app->tpl->newTemplate("form.tpl.htm"); + $app->tpl->newTemplate("listpage.tpl.htm"); $app->tpl->setInclude('content_tpl','templates/'.$app->listform->listDef["name"].'_list.htm'); // Getting Datasets from DB @@ -87,6 +92,14 @@ $this->DataRowColor = ($this->DataRowColor == "#FFFFFF")?"#EEEEEE":"#FFFFFF"; $rec["bgcolor"] = $this->DataRowColor; + // substitute value for select fields + foreach($app->listform->listDef["item"] as $field) { + $key = $field["field"]; + if($field['formtype'] == "SELECT") { + $rec[$key] = $field['value'][$rec[$key]]; + } + } + // The variable "id" contains always the index variable $rec["id"] = $rec[$this->idx_key]; @@ -111,12 +124,14 @@ $sql_where = $app->listform->getSearchSQL($sql_where); $app->tpl->setVar($app->listform->searchValues); + + $order_by_sql = $this->SQLOrderBy; // Generate SQL for paging $limit_sql = $app->listform->getPagingSQL($sql_where); $app->tpl->setVar("paging",$app->listform->pagingHTML); - return "SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $limit_sql"; + return "SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $order_by_sql $limit_sql"; } -- Gitblit v1.9.1