<h1>Search Results</h1>
<div class="typography">
   <% if Results %>
    <ul id="SearchResults">
    <% control Results %>
    <li>
    <% if MenuTitle %>
    <h3><a class="searchResultHeader" href="$Link">$MenuTitle</a></h3>
    <% else %>
    <h3><a class="searchResultHeader" href="$Link">$Title</a></h3>
    <% end_if %>
          <% if MetaDescription %>
            <p>$MetaDescription</p>
          <% end_if %>
    <a class="readMoreLink" href="$Link" title="{$Title}">Click Here</a>
    </li>
    <% end_control %>
    </ul>
    <% else %>
    <p>Sorry, your search query did not return any results.</p>
    <% end_if %>

    <% if Results.MoreThanOnePage %>
    <div id="PageNumbers">
    <% if Results.NotLastPage %>
    <a class="next" href="$Results.NextLink" title="View the next page">Next</a>
    <% end_if %>
    <% if Results.NotFirstPage %>
    <a class="prev" href="$Results.PrevLink" title="View the previous page">Prev</a>
    <% end_if %>
    <span>
    <% control Results.SummaryPagination(10) %>
    <% if CurrentBool %>
    $PageNum
    <% else %>
    <a href="$Link" title="View page number $PageNum">$PageNum</a>
    <% end_if %>
    <% end_control %>
    </span>

    </div>
    <% end_if %>
</div>

<?php
class CustomSearch extends SearchForm
{
   
   protected $classesToSearch = array("SiteTree");
   
   public function searchEngine($keywords, $pageLength = null, $sortBy = "Relevance DESC", $extraFilter = "", $booleanSearch = false, $alternativeFileFilter = "", $invertedMatch = false) {
      if(!$pageLength) $pageLength = $this->pageLength;
       $keywords = addslashes($keywords);
   
      $extraFilters = array('SiteTree' => '');
       
       if($booleanSearch) $boolean = "IN BOOLEAN MODE";
       if($extraFilter) {
          $extraFilters['SiteTree'] = " AND $extraFilter";
       }
       
       if($this->showInSearchTurnOn)   $extraFilters['SiteTree'] .= " AND showInSearch <> 0";

      $start = isset($_GET['start']) ? (int)$_GET['start'] : 0;
      $limit = $start . ", " . (int) $pageLength;
      
      $notMatch = $invertedMatch ? "NOT " : "";
      if($keywords) {
         $match['SiteTree'] = "MATCH (Title, MenuTitle, Content, MetaTitle, MetaDescription, MetaKeywords) AGAINST ('$keywords' $boolean)";
      
         // We make the relevance search by converting a boolean mode search into a normal one
         $relevanceKeywords = str_replace(array('*','+','-'),'',$keywords);
         $relevance['SiteTree'] = "MATCH (Title) AGAINST ('$relevanceKeywords') + MATCH (Title, MenuTitle, Content, MetaTitle, MetaDescription, MetaKeywords) AGAINST ('$relevanceKeywords')";
      } else {
         $relevance['SiteTree'] = 1;
         $match['SiteTree'] = "1 = 1";
      }

      // Generate initial queries and base table names
      $baseClasses = array('SiteTree' => '');
      foreach($this->classesToSearch as $class) {
         $queries[$class] = singleton($class)->extendedSQL($notMatch . $match[$class] . $extraFilters[$class], "");
         $baseClasses[$class] = reset($queries[$class]->from);
      }
      
      // Make column selection lists
      $select = array(
         'SiteTree' => array("ClassName","$baseClasses[SiteTree].ID","ParentID","MetaDescription","Title","URLSegment","Content","LastEdited","Created","_utf8'' AS Filename", "_utf8'' AS Name", "$relevance[SiteTree] AS Relevance", "CanViewType"),
      );
      
      // Process queries
      foreach($this->classesToSearch as $class) {
         // There's no need to do all that joining
         $queries[$class]->from = array(str_replace('`','',$baseClasses[$class]) => $baseClasses[$class]);
         $queries[$class]->select = $select[$class];
         $queries[$class]->orderby = null;
      }

      // Combine queries
      $querySQLs = array();
      $totalCount = 0;
      foreach($queries as $query) {
         $querySQLs[] = $query->sql();
         $totalCount += $query->unlimitedRowCount();
      }
      $fullQuery = implode(" UNION ", $querySQLs) . " ORDER BY $sortBy LIMIT $limit";

      // Get records
      $records = DB::query($fullQuery);

      foreach($records as $record)
         $objects[] = new $record['ClassName']($record);

      if(isset($objects)) $doSet = new DataObjectSet($objects);
      else $doSet = new DataObjectSet();
      
      $doSet->setPageLimits($start, $pageLength, $totalCount);

      return $doSet;
   }
}

?>

<?php
class Page extends SiteTree {

   public static $db = array(
   );

   public static $has_one = array(
   );

}
class Page_Controller extends ContentController {

   public static $allowed_actions = array (
   );

   public function init() {
      parent::init();

   }
}