tbrehm
2008-11-22 28f4cf88f8d8d50cf9a1ff8f68275d8cbd93892a
interface/lib/classes/plugin_listview.inc.php
@@ -28,6 +28,7 @@
                // $app->listform->listDef["page_params"] = "&id=".$app->tform_actions->id."&next_tab=".$_SESSION["s"]["form"]["tab"];
            $app->listform->listDef["page_params"] = "&id=".$this->form->id."&next_tab=".$_SESSION["s"]["form"]["tab"];
            $listTpl->setVar('parent_id',$this->form->id);
            $listTpl->setVar('theme', $_SESSION['s']['theme']);
                // Generate the SQL for searching
                if($app->listform->listDef["auth"] != 'no') {
@@ -49,10 +50,14 @@
                $limit_sql = $app->listform->getPagingSQL($sql_where);
                $listTpl->setVar("paging",$app->listform->pagingHTML);
            
            $sql_order_by = '';
            if(isset($this->options["sql_order_by"])) {
               $sql_order_by = $this->options["sql_order_by"];
            }
            
                // Get the data
                $records = $app->db->queryAllRecords("SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $limit_sql");
                $records = $app->db->queryAllRecords("SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $sql_order_by $limit_sql");
                $bgcolor = "#FFFFFF";
                if(is_array($records)) {
@@ -69,18 +74,26 @@
                        foreach($app->listform->listDef["item"] as $field) {
                           $key = $field["field"];
                           if($field['formtype'] == "SELECT") {
                              $rec[$key] = $field['value'][$rec[$key]];
                              if(strtolower($rec[$key]) == 'y' or strtolower($rec[$key]) == 'n') {
                                 // Set a additional image variable for bolean fields
                                 $rec['_'.$key.'_'] = (strtolower($rec[$key]) == 'y')?'x16/tick_circle.png':'x16/cross_circle.png';
                              }
                              //* substitute value for select field
                              @$rec[$key] = $field['value'][$rec[$key]];
                           }
                           // Create a lowercase version of every item
                           $rec[$key.'_lowercase'] = strtolower($rec[$key]);
                        }
                                // The variable "id" contains always the index field
                                $rec["id"] = $rec[$idx_key];
                        $rec["delete_confirmation"] = $app->lng('delete_confirmation');
                                $records_new[] = $rec;
                        }
                }
                $listTpl->setLoop('records',$records_new);
                $listTpl->setLoop('records',@$records_new);
                // Loading language field
                $lng_file = "lib/lang/".$_SESSION["s"]["language"]."_".$app->listform->listDef['name']."_list.lng";