Merge branch 'stable-3.1'

Marius Burkard

2016-05-04 c3189ce6c7301c3ec17878fd3918f31d0d3cb18a

 interface/lib/classes/plugin_listview.inc.php

@@ -30,117 +30,206 @@

class plugin_listview extends plugin_base {

        var $module;
        var $form;
        var $tab;
        var $record_id;
        var $formdef;
        var $options;
   var $module;
   var $form;
   var $tab;
   var $record_id;
   var $formdef;
   var $options;

        function onShow() {
   function onShow() {

                global $app;
      global $app;

                $app->uses('listform');
                $app->listform->loadListDef($this->options["listdef"]);
      $app->uses('listform');
      $app->listform->loadListDef($this->options["listdef"]);

                //$app->listform->SQLExtWhere = "type = 'alias'";
      //$app->listform->SQLExtWhere = "type = 'alias'";

                $listTpl = new tpl;
                $listTpl->newTemplate('templates/'.$app->listform->listDef["name"].'_list.htm');
				
            //die(print_r($app->tform_actions));
      $listTpl = new tpl;
      $listTpl->newTemplate('templates/'.$app->listform->listDef["name"].'_list.htm');

                // Changing some of the list values to reflect that the list is called within a tform page
                $app->listform->listDef["file"] = $app->tform->formDef["action"];
                // $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']);
      //die(print_r($app->tform_actions));

                // Generate the SQL for searching
                if($app->listform->listDef["auth"] != 'no') {
                        if($_SESSION["s"]["user"]["typ"] == "admin") {
                                $sql_where = "";
                        } else {
                                $sql_where = $app->tform->getAuthSQL('r')." and";
                        }
                }
      // Changing some of the list values to reflect that the list is called within a tform page
      $app->listform->listDef["file"] = $app->tform->formDef["action"];
      // $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']);

                if($this->options["sqlextwhere"] != '') {
                        $sql_where .= " ".$this->options["sqlextwhere"]." and";
                }
      // Generate the SQL for searching
      $sql_where = "";
      if($app->listform->listDef["auth"] != 'no') {
         if($_SESSION["s"]["user"]["typ"] != "admin") {
            $sql_where = $app->tform->getAuthSQL('r')." and";
         }
      }

                $sql_where = $app->listform->getSearchSQL($sql_where);
                $listTpl->setVar($app->listform->searchValues);
      if($this->options["sqlextwhere"] != '') {
         $sql_where .= " ".$this->options["sqlextwhere"]." and";
      }

                // Generate SQL for paging
                $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"];
      $sql_where = $app->listform->getSearchSQL($sql_where);
      $listTpl->setVar($app->listform->searchValues);

      // Generate SQL for paging
      $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"];
      }

      //* Limit each page
      $limits = array('5'=>'5', '15'=>'15', '25'=>'25', '50'=>'50', '100'=>'100', '999999999' => 'all');

      //* create options and set selected, if default -> 15 is selected
      $options='';
      foreach($limits as $key => $val){
         $options .= '<option value="'.$key.'" '.(isset($_SESSION['search']['limit']) &&  $_SESSION['search']['limit'] == $key ? 'selected="selected"':'' ).(!isset($_SESSION['search']['limit']) && $key == '15' ? 'selected="selected"':'').'>'.$val.'</option>';
      }
      $listTpl->setVar('search_limit', '<select name="search_limit" style="width:50px">'.$options.'</select>');


      //Sorting
      if(!isset($_SESSION['search'][$app->listform->listDef["name"]]['order'])){
         $_SESSION['search'][$app->listform->listDef["name"]]['order'] = '';
      }

      if(!empty($_GET['orderby'])){
         $order = str_replace('tbl_col_', '', $_GET['orderby']);
         //* Check the css class submited value
         if (preg_match("/^[a-z\_]{1,}$/", $order)) {
            if($_SESSION['search'][$app->listform->listDef["name"]]['order'] == $order){
               $_SESSION['search'][$app->listform->listDef["name"]]['order'] = $order.' DESC';
            } else {
               $_SESSION['search'][$app->listform->listDef["name"]]['order'] = $order;
            }
				
         }
      }

                // Get the data
                $records = $app->db->queryAllRecords("SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $sql_order_by $limit_sql");
      // If a manuel oder by like customers isset the sorting will be infront
      if(!empty($_SESSION['search'][$app->listform->listDef["name"]]['order'])){
         if(empty($sql_order_by)){
            $sql_order_by = "ORDER BY ".$_SESSION['search'][$app->listform->listDef["name"]]['order'];
         } else {
            $sql_order_by = str_replace("ORDER BY ", "ORDER BY ".$_SESSION['search'][$app->listform->listDef["name"]]['order'].', ', $sql_order_by);
         }
      }

                $bgcolor = "#FFFFFF";
                if(is_array($records)) {
                        $idx_key = $app->listform->listDef["table_idx"];
                        foreach($records as $rec) {
      // Loading language field
      $lng_file = "lib/lang/".$_SESSION["s"]["language"]."_".$app->listform->listDef['name']."_list.lng";
      include $lng_file;
      $listTpl->setVar($wb);

                                $rec = $app->listform->decode($rec);

                                // Change of color
                                $bgcolor = ($bgcolor == "#FFFFFF")?"#EEEEEE":"#FFFFFF";
                                $rec["bgcolor"] = $bgcolor;
								
                        // substitute value for select fields
                        foreach($app->listform->listDef["item"] as $field) {
                           $key = $field["field"];
                           if($field['formtype'] == "SELECT") {
                              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]);
                        }
      // Get the data
      $records = $app->db->queryAllRecords("SELECT * FROM ?? WHERE $sql_where $sql_order_by $limit_sql", $app->listform->listDef["table"]);

                                // The variable "id" contains always the index field
                                $rec["id"] = $rec[$idx_key];
                        $rec["delete_confirmation"] = $app->lng('delete_confirmation');
      $bgcolor = "#FFFFFF";
      if(is_array($records)) {
         $idx_key = $app->listform->listDef["table_idx"];
         foreach($records as $rec) {

                                $records_new[] = $rec;
                        }
                }
            $rec = $app->listform->decode($rec);

                $listTpl->setLoop('records',@$records_new);
            // Change of color
            $bgcolor = ($bgcolor == "#FFFFFF")?"#EEEEEE":"#FFFFFF";
            $rec["bgcolor"] = $bgcolor;

                // Loading language field
                $lng_file = "lib/lang/".$_SESSION["s"]["language"]."_".$app->listform->listDef['name']."_list.lng";
                include($lng_file);
                $listTpl->setVar($wb);
            // substitute value for select fields
            foreach($app->listform->listDef["item"] as $field) {
               $key = $field["field"];
               if($field['formtype'] == "SELECT") {
                  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]);
            }

                // Setting Returnto information in the session
                $list_name = $app->listform->listDef["name"];
                // $_SESSION["s"]["list"][$list_name]["parent_id"] = $app->tform_actions->id;
            $_SESSION["s"]["list"][$list_name]["parent_id"] = $this->form->id;
            $_SESSION["s"]["list"][$list_name]["parent_name"] = $app->tform->formDef["name"];
                $_SESSION["s"]["list"][$list_name]["parent_tab"] = $_SESSION["s"]["form"]["tab"];
                $_SESSION["s"]["list"][$list_name]["parent_script"] = $app->tform->formDef["action"];
                $_SESSION["s"]["form"]["return_to"] = $list_name;
            //die(print_r($_SESSION["s"]["list"][$list_name]));
            // The variable "id" contains always the index field
            $rec["id"] = $rec[$idx_key];
            $rec["delete_confirmation"] = $wb['delete_confirmation'];

                return $listTpl->grab();
            $records_new[] = $rec;
         }
      }

        }
      $listTpl->setLoop('records', @$records_new);

      // Setting Returnto information in the session
      $list_name = $app->listform->listDef["name"];
      // $_SESSION["s"]["list"][$list_name]["parent_id"] = $app->tform_actions->id;
      $_SESSION["s"]["list"][$list_name]["parent_id"] = $this->form->id;
      $_SESSION["s"]["list"][$list_name]["parent_name"] = $app->tform->formDef["name"];
      $_SESSION["s"]["list"][$list_name]["parent_tab"] = $_SESSION["s"]["form"]["tab"];
      $_SESSION["s"]["list"][$list_name]["parent_script"] = $app->tform->formDef["action"];
      $_SESSION["s"]["form"]["return_to"] = $list_name;
      //die(print_r($_SESSION["s"]["list"][$list_name]));

      // defaults
      $listTpl->setVar('app_title', $app->_conf['app_title']);
      if(isset($_SESSION['s']['user'])) {
         $listTpl->setVar('app_version', $app->_conf['app_version']);
         // get pending datalog changes
         $datalog = $app->db->datalogStatus();
         $listTpl->setVar('datalog_changes_txt', $app->lng('datalog_changes_txt'));
         $listTpl->setVar('datalog_changes_end_txt', $app->lng('datalog_changes_end_txt'));
         $listTpl->setVar('datalog_changes_count', $datalog['count']);
         $listTpl->setLoop('datalog_changes', $datalog['entries']);
      } else {
         $listTpl->setVar('app_version', '');
      }
      $listTpl->setVar('app_link', $app->_conf['app_link']);

      $listTpl->setVar('app_logo', $app->_conf['logo']);

      $listTpl->setVar('phpsessid', session_id());

      $listTpl->setVar('theme', $_SESSION['s']['theme']);
      $listTpl->setVar('html_content_encoding', $app->_conf['html_content_encoding']);

      $listTpl->setVar('delete_confirmation', $app->lng('delete_confirmation'));
      //print_r($_SESSION);
      if(isset($_SESSION['s']['module']['name'])) {
         $listTpl->setVar('app_module', $_SESSION['s']['module']['name']);
      }
      if(isset($_SESSION['s']['user']) && $_SESSION['s']['user']['typ'] == 'admin') {
         $listTpl->setVar('is_admin', 1);
      }
      if(isset($_SESSION['s']['user']) && $app->auth->has_clients($_SESSION['s']['user']['userid'])) {
         $listTpl->setVar('is_reseller', 1);
      }
      /* Show username */
      if(isset($_SESSION['s']['user'])) {
         $listTpl->setVar('cpuser', $_SESSION['s']['user']['username']);
         $listTpl->setVar('logout_txt', $app->lng('logout_txt'));
         /* Show search field only for normal users, not mail users */
         if(stristr($_SESSION['s']['user']['username'], '@')){
            $listTpl->setVar('usertype', 'mailuser');
         } else {
            $listTpl->setVar('usertype', 'normaluser');
         }
      }

      /* Global Search */
      $listTpl->setVar('globalsearch_resultslimit_of_txt', $app->lng('globalsearch_resultslimit_of_txt'));
      $listTpl->setVar('globalsearch_resultslimit_results_txt', $app->lng('globalsearch_resultslimit_results_txt'));
      $listTpl->setVar('globalsearch_noresults_text_txt', $app->lng('globalsearch_noresults_text_txt'));
      $listTpl->setVar('globalsearch_noresults_limit_txt', $app->lng('globalsearch_noresults_limit_txt'));
      $listTpl->setVar('globalsearch_searchfield_watermark_txt', $app->lng('globalsearch_searchfield_watermark_txt'));
		
      return $listTpl->grab();

   }

}

?>
?>