Changeset 46 for trunk/Global.php

Timestamp:

Nov 10, 2019, 1:42:40 AM (4 years ago)

Author:

chronos

Message:

• Modified: Table filter made more general.
• Added: Filter for movies table.

File:

• trunk/Global.php (modified) (2 diffs)

trunk/Global.php

@@ -22 +22 @@
 {
   global $Config;
-  
+
   return $Config['BaseURL'].$URL;
 }
@@ -184 +184 @@
   return ((float)$Usec + (float)$Sec);
 }
+
+class Filter
+{
+  var $Items = array();
+
+  function GetOutput($Link)
+  {
+    $Output = '';
+    foreach ($this->rItems as $Item)
+    {
+      if (($Item['Type'] == 'String') or ($Item['Type'] == 'Enumeration'))
+      {
+        if (!array_key_exists($Item['Name'], $_SESSION)) $_SESSION[$Item['Name']] = '';
+      } else
+      if ($Item['Type'] == 'Integer')
+      {
+        if (!array_key_exists($Item['Name'].'od', $_SESSION)) $_SESSION[$Item['Name'].'od'] = '';
+        if (!array_key_exists($Item['Name'].'do', $_SESSION)) $_SESSION[$Item['Name'].'do'] = '';
+      }
+    }
+
+    if (array_key_exists('lvm', $_GET) and ($_GET['lvm'] == 'seznam'))
+    {
+      foreach ($this->Items as $Item)
+      {
+        if ($Item['Type'] == 'String')
+        {
+          if (array_key_exists($Item['Name'], $_GET) ) $_SESSION[$Item['Name']] = $_GET[$Item['Name']];
+        } else
+        if ($Item['Type'] == 'Enumeration')
+        {
+          if (array_key_exists($Item['Name'], $_GET) ) $_SESSION[$Item['Name']] = $_GET[$Item['Name']];
+          if ($_SESSION[$Item['Name']] == '0') $_SESSION[$Item['Name']] = '';
+        } else
+        if ($Item['Type'] == 'Integer')
+        {
+          if (array_key_exists($Item['Name'].'od', $_GET) ) $_SESSION[$Item['Name'].'od'] = $_GET[$Item['Name'].'od'];
+          if ($_SESSION[$Item['Name'].'od'] == '0') $_SESSION[$Item['Name'].'od'] = '';
+          if (array_key_exists($Item['Name'].'do', $_GET) ) $_SESSION[$Item['Name'].'do'] = $_GET[$Item['Name'].'do'];
+          if ($_SESSION[$Item['Name'].'do'] == '0') $_SESSION[$Item['Name'].'do'] = '';
+        }
+      }
+    } else {
+      $Output .= '<script type="text/javascript">function reloadlist(){ $(\'#meetlist\').load(document.URL + \' #meetlist\');}'.
+      ' var load_timer = 100;
+   var ltimer = null;
+
+   function checkOut(kc,obj){
+      if(kc==13) $(obj).blur();
+   }
+   function initLTimer(tm){
+      if(ltimer) clearTimeout(ltimer);
+      ltimer = setTimeout("freloader()",tm);
+   }
+   function stopLTimer(){
+      if(ltimer) clearTimeout(ltimer);
+      ltimer = null;
+   }
+
+   var cf = {};
+
+   function setupc(key,val){
+      //console.log(\'setup-control-\'+key+\' = \'+val);
+      ';
+      $Keys = array();
+      foreach ($this->Items as $Item)
+      {
+        if ($Item['Type'] == 'Integer')
+        {
+          $Keys[] = 'key==\''.$Item['Name'].'od\'';
+          $Keys[] = 'key==\''.$Item['Name'].'do\'';
+        }
+      }
+      if (count($Keys) > 0)
+      {
+        $Output .= 'if ('.implode(' || ', $Keys).') {
+          var ccv = $(\'#\'+key).val();
+          if(ccv!=val) $(\'#\'+key).val(val==0?\'\':val);
+        }
+        ';
+      }
+
+      $Keys = array();
+      foreach ($this->Items as $Item)
+      {
+        if ($Item['Type'] == 'Enumeration')
+        {
+          $Keys[] = 'key==\''.$Item['Name'].'\'';
+        }
+      }
+      if (count($Keys) > 0)
+      {
+        $Output .= 'if('.implode(' || ', $Keys).') {
+           $(\'.c\'+key).removeClass(\'active\');
+           $(\'#\'+key+val).addClass(\'active\');
+        }
+        ';
+      }
+      $Output .= '
+   }
+
+   function upf(key,val,lonreload){
+      if(key!=\'first\') cf[\'first\']=0; else st();
+      setupc(key,val);
+      cf[key]=val;
+      if(lonreload) initLTimer(1000); else initLTimer(100);
+   }
+
+   function freloader(){
+      ltimer = null;
+      var qp = jQuery.param( cf );
+      $(\'#list_content\').html(\'\'); $(\'#list_loading\').show();
+      $.get(\''.$Link.'?lvm=seznam&\'+qp,function(data){$(\'#list_loading\').hide();$(\'#list_content\').html(data);})
+   }'.
+      '</script>
+      <div class="table-filter">';
+      foreach ($this->Items as $Item)
+      {
+        if ($Item['Type'] == 'String')
+        {
+          $Output .= '<div class="filter-num-box">'.
+            '<div class="label-box">'.$Item['Title'].'</div>'.
+            '<input value="'.$_SESSION[$Item['Name']].'" onkeyup="if(event.keyCode!=9) upf(\''.$Item['Name'].'\',$(this).val(),(event.keyCode==13?0:1)); '.
+            '" id="'.$Item['Name'].'" autocomplete="off" type="text"/>'.
+            '</div> ';
+        } else
+        if ($Item['Type'] == 'Enumeration')
+        {
+          $Output .= '<div class="btn-group ma3">'.
+            '<div class="label-box">'.$Item['Title'].'</div>';
+          foreach ($Item['States'] as $EnumIndex => $EnumItem)
+          {
+            $Output .= '<button class="btn btn-filter c'.$Item['Name'].' btn-ico" onclick="upf(\''.$Item['Name'].'\','.$EnumIndex.')" id="'.$Item['Name'].$EnumIndex.'" data-toggle="tooltip" '.
+              'data-placement="top" title="'.$EnumItem.'"><span class="icon-'.$EnumIndex.'"></span></button>';
+          }
+          $Output .= '</div>';
+        } else
+        if ($Item['Type'] == 'Integer')
+        {
+          $Output .= '<div class="filter-num-box">'.
+            '<div class="label-box">'.$Item['Title'].'</div>'.
+            '<input value="'.$_SESSION[$Item['Name'].'od'].'" onkeyup="if(event.keyCode!=9) upf(\''.$Item['Name'].'od\',$(this).val(),(event.keyCode==13?0:1)); '.
+            '" id="'.$Item['Name'].'od" autocomplete="off" type="text"/>'.
+            '<div class="label-box">-</div>'.
+            '<input value="'.$_SESSION[$Item['Name'].'do'].'" onkeyup="'.
+            'if(event.keyCode!=9) upf(\''.$Item['Name'].'do\',$(this).val(),(event.keyCode==13?0:1));" '.
+            'id="'.$Item['Name'].'do" autocomplete="off" type="text"/>'.
+            '<div class="label-box">'.$Item['Units'].'</div>'.
+            '</div> ';
+        }
+      }
+      $Output .= '</div>';
+    }
+    return $Output;
+  }
+
+  function GetWhere($Database)
+  {
+    $Where = '';
+    foreach($this->Items as $Item)
+    {
+      if ($Item['Type'] == 'String')
+      {
+        if ($_SESSION[$Item['Name']] != '')
+          $Where .= ' AND ('.$Item['DbName'].' LIKE "%'.$Database->real_escape_string($_SESSION[$Item['Name']]).'%")';
+      } else
+      if ($Item['Type'] == 'Enumeration')
+      {
+        if ($_SESSION[$Item['Name']] != '')
+          $Where .= ' AND ('.$Item['DbName'].' = '.$Database->real_escape_string($_SESSION[$Item['Name']]).')';
+      } else
+      if ($Item['Type'] == 'Integer')
+      {
+        if ($_SESSION[$Item['Name'].'od'] != '')
+          $Where .= ' AND ('.$Item['DbName'].' >= '.$Database->real_escape_string($_SESSION[$Item['Name'].'od']).')';
+        if ($_SESSION[$Item['Name'].'do'] != '')
+          $Where .= ' AND ('.$Item['DbName'].' <= '.$Database->real_escape_string($_SESSION[$Item['Name'].'do']).')';
+      }
+    }
+    if (substr($Where, 0, 4) == ' AND')
+      $Where = substr($Where, 4);
+    if ($Where == '') $Where = '1';
+    return $Where;
+  }
+}