| | |
|---|
| | | $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];
|
|---|
| | |
|
|---|
| | |
|---|
| | | // Generate the search sql
|
|---|
| | | if($app->listform->listDef["auth"] != 'no') {
|
|---|
| | | if($_SESSION["s"]["user"]["typ"] == "admin") {
|
|---|
| | | $sql_where = $this->SQLExtWhere;
|
|---|
| | | $sql_where = "";
|
|---|
| | | } else {
|
|---|
| | | $sql_where = $this->SQLExtWhere ." ". $app->tform->getAuthSQL('r')." and";
|
|---|
| | | $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);
|
|---|
