| | |
| | | <?php |
| | | |
| | | /* |
| | | Copyright (c) 2007, Till Brehm, projektfarm Gmbh |
| | | All rights reserved. |
| | | |
| | | Redistribution and use in source and binary forms, with or without modification, |
| | | are permitted provided that the following conditions are met: |
| | | |
| | | * Redistributions of source code must retain the above copyright notice, |
| | | this list of conditions and the following disclaimer. |
| | | * Redistributions in binary form must reproduce the above copyright notice, |
| | | this list of conditions and the following disclaimer in the documentation |
| | | and/or other materials provided with the distribution. |
| | | * Neither the name of ISPConfig nor the names of its contributors |
| | | may be used to endorse or promote products derived from this software without |
| | | specific prior written permission. |
| | | |
| | | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND |
| | | ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED |
| | | WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. |
| | | IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, |
| | | INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, |
| | | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, |
| | | DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY |
| | | OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING |
| | | NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, |
| | | EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
| | | */ |
| | | |
| | | class plugin_listview extends plugin_base { |
| | | |
| | | var $module; |
| | |
| | | // $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') { |
| | |
| | | $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)) { |
| | |
| | | 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"; |