From 4766e9e10c141a75a14a1440dc63eb1d8a5ada8c Mon Sep 17 00:00:00 2001 From: pedro_morgan <pedro_morgan@ispconfig3> Date: Sun, 19 Aug 2007 00:59:09 -0400 Subject: [PATCH] * Introducing the sb_local.php.skel file to keep a local configuration --- interface/lib/classes/listform_actions.inc.php | 11 +++++++++-- 1 files changed, 9 insertions(+), 2 deletions(-) diff --git a/interface/lib/classes/listform_actions.inc.php b/interface/lib/classes/listform_actions.inc.php index 3f8cf9e..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 @@ -119,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