/**
* Extends a ComplexTableField by adding a search box to search within the table
*
*/

class SearchComplexTableField extends ComplexTableField {
   
   /**
    * Template for main rendering
    *
    * @var string
    */
   protected $template = "SearchComplexTableField";

   function __construct($controller, $name, $sourceClass, $fieldList, $detailFormFields = null, $sourceFilter = "", $sourceSort = "", $sourceJoin = "") {
      parent::__construct($controller, $name, $sourceClass, $fieldList, $detailFormFields, $sourceFilter, $sourceSort, $sourceJoin);
      
      // search
      $SQL_search = isset($_REQUEST['TableSearch']) ? Convert::raw2sql($_REQUEST['TableSearch']) : null;
      if(!empty($_REQUEST['TableSearch'])) {
         $searchFilters = array();
         foreach($fieldList as $fieldName => $fieldSpec) {
            $searchFilters[] = "`$fieldName` LIKE '%{$SQL_search}%'";
         }
         $this->sourceFilter[] = '(' . implode(' OR ', $searchFilters) . ')';
         
      }
   }
   
   function SearchForm() {
      $searchFields = new FieldGroup(
         new TextField('TableSearch', _t('TableField.SEARCH', 'Search'))
      );

      $actionFields = new LiteralField('ComplexTableFilterButton','<input type="submit" class="action" name="ComplexTableFilterButton" value="'._t('SearchComplexTableField.FILTER', 'Filter').'" id="ComplexTableFilterButton"/>');

      $fieldContainer = new FieldGroup(
            $searchFields,
            $actionFields
      );

      return $fieldContainer->FieldHolder();
   }

}