| | |
|---|
| | | var $id;
|
|---|
| | | 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->tpl->newTemplate("form.tpl.htm");
|
|---|
| | | if(!is_file('templates/'.$app->listform->listDef["name"].'_list.htm')) {
|
|---|
| | | $app->uses('listform_tpl_generator');
|
|---|
| | | $app->listform_tpl_generator->buildHTML($app->listform->listDef);
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | $app->tpl->newTemplate("listpage.tpl.htm");
|
|---|
| | | $app->tpl->setInclude('content_tpl','templates/'.$app->listform->listDef["name"].'_list.htm');
|
|---|
| | |
|
|---|
| | | // Getting Datasets from DB
|
|---|
| | |
|---|
| | | $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];
|
|---|
| | |
|
|---|
| | |
|---|
| | | $sql_where = $app->tform->getAuthSQL('r')." and";
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | if($this->SQLExtWhere != '') {
|
|---|
| | | $sql_where .= " ".$this->SQLExtWhere." and";
|
|---|
| | | }
|
|---|
| | |
|
|---|
| | | $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";
|
|---|
| | |
|
|---|
| | | }
|
|---|
| | |
|
|---|
