source: trunk/Modules/Search/Search.php@ 636

<?php

class ModuleSearch extends AppModule
{
        var $SearchItems;
        
        function __construct($System)
        {
                parent::__construct($System);
                $this->Name = 'Search';
                $this->Version = '1.0';
                $this->Creator = 'Chronos';
                $this->License = 'GNU/GPL';
                $this->Description = 'Allow test search in other modules content.';
                $this->Dependencies = array();
                $this->SearchItems = array();
        }

        function Start()
        {
                $this->System->RegisterPage('search', 'PageSearch');
        }
        
        function RegisterSearch($Name, $Title, $Columns, $Query, $Link)
        {
                // Query can be table name or subselect query
          $this->SearchItems[$Name] = array('Name' => $Title, 'Columns' => $Columns, 
      'Query' => $Query, 'Link' => $Link);      
        }

        function UnregisterSearch($Name)
        {
          unset($this->SearchItems[$Name]);     
        }
}

class PageSearch extends Page
{
        function Show()
        {
                $this->Title = T('Search');
                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>'.T('Section').'</th><th>'.T('Found count').'</th></tr>';
                foreach($this->System->ModuleManager->Modules['Search']->SearchItems as $SearchItem)
                {
                        $ColumnQuery = array();
                        foreach($SearchItem['Columns'] as $Column)
                        {
                          $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>';
                }
  
        $Output .= '</table>';
                return($Output);
        }
}