FOF30\Model\DataModel\Behaviour\Filters::onAfterBuildQuery PHP Méthode

    public function onAfterBuildQuery(&$model, &$query)
    {
        $tableKey = $model->getIdFieldName();
        $db = $model->getDbo();
        $fields = $model->getTableFields();
        $blacklist = $model->blacklistFilters();
        $filterZero = $model->getBehaviorParam('filterZero', null);
        $tableAlias = $model->getBehaviorParam('tableAlias', null);
        foreach ($fields as $fieldname => $fieldmeta) {
            if (in_array($fieldname, $blacklist)) {
                continue;
            }
            $fieldInfo = (object) array('name' => $fieldname, 'type' => $fieldmeta->Type, 'filterZero' => $filterZero, 'tableAlias' => $tableAlias);
            $filterName = $fieldInfo->name;
            $filterState = $model->getState($filterName, null);
            // Special primary key handling: if ignore request is set we'll also look for an 'id' state variable if a
            // state variable by the same name as the key doesn't exist. If ignore request is not set in the model we
            // do not filter by 'id' since this interferes with going from an edit page to a browse page (the list is
            // filtered by id without user controls to unset it).
            if ($fieldInfo->name == $tableKey) {
                $filterState = $model->getState($filterName, null);
                if (!$model->getIgnoreRequest()) {
                    continue;
                }
                if (empty($filterState)) {
                    $filterState = $model->getState('id', null);
                }
            }
            $field = DataModel\Filter\AbstractFilter::getField($fieldInfo, array('dbo' => $db));
            if (!is_object($field) || !$field instanceof DataModel\Filter\AbstractFilter) {
                continue;
            }
            if (is_array($filterState) && (array_key_exists('value', $filterState) || array_key_exists('from', $filterState) || array_key_exists('to', $filterState)) || is_object($filterState)) {
                $options = new \JRegistry($filterState);
            } else {
                $options = new \JRegistry();
                $options->set('value', $filterState);
            }
            $methods = $field->getSearchMethods();
            $method = $options->get('method', $field->getDefaultSearchMethod());
            if (!in_array($method, $methods)) {
                $method = 'exact';
            }
            switch ($method) {
                case 'between':
                case 'outside':
                case 'range':
                    $sql = $field->{$method}($options->get('from', null), $options->get('to', null), $options->get('include', false));
                    break;
                case 'interval':
                case 'modulo':
                    $sql = $field->{$method}($options->get('value', null), $options->get('interval'));
                    break;
                case 'search':
                    $sql = $field->{$method}($options->get('value', null), $options->get('operator', '='));
                    break;
                case 'exact':
                case 'partial':
                default:
                    $sql = $field->{$method}($options->get('value', null));
                    break;
            }
            if ($sql) {
                $query->where($sql);
            }
        }
    }

 /**
  * @group           Behaviour
  * @group           FiltersOnAfterBuildQuery
  * @covers          FOF30\Model\DataModel\Behaviour\Filters::onAfterBuildQuery
  * @dataProvider    FiltersDataprovider::getTestOnAfterBuildQuery
  */
 public function testOnAfterBuildQuery($test, $check)
 {
     //\PHPUnit_Framework_Error_Warning::$enabled = false;
     $msg = 'Filters::onAfterBuildQuery %s - Case: ' . $check['case'];
     $config = array('idFieldName' => 'foftest_foobar_id', 'tableName' => '#__foftest_foobars');
     $model = $this->getMock('\\FOF30\\Tests\\Stubs\\Model\\DataModelStub', array('getState'), array(static::$container, $config));
     $model->expects($this->any())->method('getState')->willReturnCallback(function ($key, $default = null) use($test) {
         if (isset($test['mock']['state'][$key])) {
             return $test['mock']['state'][$key];
         }
         return $default;
     });
     $model->setIgnoreRequest($test['ignore']);
     $query = \JFactory::getDbo()->getQuery(true)->select('*')->from('test');
     $dispatcher = $model->getBehavioursDispatcher();
     $filter = new Filters($dispatcher);
     $filter->onAfterBuildQuery($model, $query);
     $this->assertEquals($check['query'], trim((string) $query), sprintf($msg, 'Failed to build the query'));
 }