Changeset 46 for trunk/Modules/Movie

Timestamp:

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

Author:

chronos

Message:

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

File:

• trunk/Modules/Movie/Movie.php (modified) (3 diffs)

trunk/Modules/Movie/Movie.php

@@ -19 +19 @@
     $this->System->RegisterPage('filmy', 'PageMovieList');
     $this->System->RegisterMenuItem('/filmy', 'Filmy');
-  }  
+  }
 }
 
@@ -30 +30 @@
     $this->ShortTitle = 'Filmy';
   }
-  
+
   function Show()
   {
+    $Output = '';
     $this->Title = 'Filmy - '.$this->Title;
-    $Output = '<div class="title">Filmy</div>';
+    if (array_key_exists('lvm', $_GET) and ($_GET['lvm'] == 'seznam'))
+      $this->ClearPage = true;
+      else $Output .= '<div class="title">Filmy</div>';
+
+    $Filter = new Filter();
+    $Filter->Items = array(
+      array('Name' => 'year', 'Type' => 'Integer', 'DbName' => 'Year', 'Title' => 'Rok'),
+      array('Name' => 'namecz', 'Type' => 'String', 'DbName' => 'NameCz', 'Title' => 'Český název'),
+      array('Name' => 'nameen', 'Type' => 'String', 'DbName' => 'NameEn', 'Title' => 'Anglický název'),
+    );
+    $Output .= $Filter->GetOutput($this->System->Link('/filmy/'));
+    $Where = $Filter->GetWhere($this->Database);
+
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Movie WHERE '.$Where);
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);
+    $Output .= $PageList['Output'];
+    $TableColumns = array(
+      array('Name' => 'Year', 'Title' => 'Rok'),
+      array('Name' => 'NameCz', 'Title' => 'Český název'),
+      array('Name' => 'NameEn', 'Title' => 'Anglický název'),
+      array('Name' => 'Imdb', 'Title' => 'IMDB'),
+      array('Name' => 'Csfd', 'Title' => 'ČSFD'),
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'Year', 1);
+
+    $Output .= '<div id="list_content">';
     $Output .= '<table class="WideTable">';
-    $Output .= '<tr><th>Rok</th><th>Český název</th><th>Anglický název</th><th>IMDb</th><th>ČSFD</th>';
+    $Output .= $Order['Output'];
     $Output .= '</tr>';
-    $DbResult = $this->Database->select('Movie', '*', '1 ORDER BY `Year` DESC');
+    $DbResult = $this->Database->select('Movie', '*', $Where.$Order['SQL'].$PageList['SQLLimit']);
     while($Movie = $DbResult->fetch_assoc())
     {
@@ -50 +77 @@
     }
     $Output .= '</table>';
+    $Output .= '</div>';
+    $Output .= $PageList['Output'];
 
     return($Output);