| | |
|---|
| | | 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);
|
|---|
| | |
|---|
| | | $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
|
|---|
| | |
|---|
| | |
|
|---|
| | | $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";
|
|---|
| | |
|
|---|
| | | }
|
|---|
| | |
|
|---|
