| | |
| | | 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'); |
| | | 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 |
| | |
| | | |
| | | |
| | | $this->DataRowColor = "#FFFFFF"; |
| | | $records_new = ''; |
| | | if(is_array($records)) { |
| | | $this->idx_key = $app->listform->listDef["table_idx"]; |
| | | foreach($records as $rec) { |
| | |
| | | |
| | | $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"; |
| | | |
| | | } |
| | | |