Changeset 626 for trunk/Modules/Search/Search.php

Timestamp:

Dec 4, 2013, 9:50:16 PM (11 years ago)

Author:

chronos

Message:

• Modified: Search page generalized as dynamic configurable list. Other modules can register their search ability.
• Modified: If sarch is invoked on some module then filter is added to table. Filter have to be disabled to view all items again.
• Added: Shoutbox can be searched.

File:

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

trunk/Modules/Search/Search.php

@@ -14 +14 @@
                 $this->Description = 'Allow test search in other modules content.';
                 $this->Dependencies = array();
+                $this->SearchItems = array();
         }
 
@@ -21 +22 @@
         }
         
-        function RegisterContent($Name, $Columns, $Query)
+        function RegisterSearch($Name, $Title, $Columns, $Query, $Link)
         {
-          $this->SearchItems[$Name] = array('Columns' => $Columns, 'Query' => $Query);  
+                // Query can be table name or subselect query
+          $this->SearchItems[$Name] = array('Name' => $Title, 'Columns' => $Columns, 
+      'Query' => $Query, 'Link' => $Link);      
         }
 
-        function UnregisterContent($Name)
+        function UnregisterSearch($Name)
         {
           unset($this->SearchItems[$Name]);     
@@ -36 +39 @@
         function Show()
         {
-                global $TranslationTree;
-        
                 if(array_key_exists('text', $_GET)) $Search = $_GET['text'];
                 else if(array_key_exists('text', $_POST)) $Search = $_POST['text'];
                 else $Search = '';
                 $SearchHTML = htmlentities($Search);
-        
-                $Output = '<table class="BaseTable"><tr><th>Skupina</th><th>Výsledků</th></tr>';
-                foreach($TranslationTree as $Group)
+                
+                $Output = '<table class="BaseTable"><tr><th>'.T('Section').'</th><th>'.T('Found count').'</th></tr>';
+                foreach($this->System->ModuleManager->Modules['Search']->SearchItems as $SearchItem)
                 {
-                        $Table = $Group['TablePrefix'];
-        
-                        $sql = 'SELECT COUNT(*) FROM `'.$Table.'` WHERE '.
-                                        ' (`ID` LIKE "%'.$Search.'%")'.
-                                        ' OR (`Entry` LIKE "%'.$Search.'%")';
-                        foreach($Group['Items'] as $Item)
+                        $ColumnQuery = array();
+                        foreach($SearchItem['Columns'] as $Column)
                         {
-                                if($Item['Column'] != '') $sql .= ' OR (`'.$Item['Column'].'` LIKE "%'.$Search.'%")';
-                        }
-                        $DbResult = $this->Database->query($sql);
-                        $Line = $DbResult->fetch_row();
-                        if ($Line[0] <> '0')
-                          $Output .= '<tr><td><a href="'.$this->System->Link('/TranslationList.php?group='.
-                          $Group['Id'].'&amp;user=0&amp;state=0&amp;text='.$SearchHTML.'&amp;entry=').'">'.
-                          $Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>';
+                          $ColumnQuery[] = '(`'.$Column.'` LIKE "%'.$Search.'%")';
+                  }
+                  $ColumnQuery = implode(' OR ', $ColumnQuery);
+                  if($SearchItem['Query'] != '')
+                  { 
+                    $DbResult = $this->Database->query('SELECT COUNT(*) FROM '.$SearchItem['Query'].' WHERE '.$ColumnQuery);
+                  $Line = $DbResult->fetch_row();
+                  $Line = $Line[0];
+                  } else $Line = '';
+                $Output .= '<tr><td><a href="'.$SearchItem['Link'].$SearchHTML.'">'.$SearchItem['Name'].'</a></td><td>'.$Line.'</td></tr>';
                 }
-        
-                $DbResult = $this->Database->query('SELECT count(*) FROM `User` WHERE `Name` LIKE "%'.$Search.'%"');
-                $Line = $DbResult->fetch_row();
-                $Output .= '<tr><td><a href="'.$this->System->Link('/userlist.php?search='.$SearchHTML).'">Uživatelé</a></td><td>'.$Line[0].'</td></tr>';
-        
-                $DbResult = $this->Database->query('SELECT count(*) FROM `Team` WHERE `Name` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%"');
-                $Line = $DbResult->fetch_row();
-                $Output .= '<tr><td><a href="'.$this->System->Link('/team/?search='.$SearchHTML).'">Týmy</a></td><td>'.$Line[0].'</td></tr>';
-        
-                $DbResult = $this->Database->query('SELECT count(*) FROM `CzWoWPackageVersion` WHERE `Text` LIKE "%'.$Search.'%"');
-                $Line = $DbResult->fetch_row();
-                $Output .= '<tr><td><a href="'.$this->System->Link('/download.php?addon').'">Čeština pro klienta</a></td><td>'.$Line[0].'</td></tr>';
-                $Output .= '<tr><td><a href="'.$this->System->Link('/aowow/?search='.$SearchHTML).'">Vyhledávací databáze AoWoW</a></td></tr>';
-        
-                $DbResult = $this->Database->query('SELECT count(*) FROM `Dictionary` WHERE '.
-                        '(`Text` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%") AND `Language` = '.$this->System->Config['OriginalLanguage']);
-                $Line = $DbResult->fetch_row();
-                $Output .= '<tr><td><a href="'.$this->System->Link('/dictionary/?search='.$SearchHTML).
-      '">Slovníček</a></td><td>'.$Line[0].'</td></tr>';
-        
-                $Output .= '</table>';
+  
+        $Output .= '</table>';
                 return($Output);
         }