PHP DataSource::prepareFilterValue方法代码示例

 public function buildFilterQuery($filter, &$joins, array &$where, Register $parameter_output)
 {
     $driver = Extension::load('members');
     $filter = $this->processFilter($filter);
     $filter_join = DataSource::FILTER_OR;
     $db = Symphony::Database();
     $values = DataSource::prepareFilterValue($filter->value, $parameter_output, $filter_join);
     if (!is_array($values)) {
         $values = array();
     }
     // Exact matches:
     if ($filter->type == 'is' or $filter->type == 'is-not') {
         $statements = array();
         if ($filter_join == DataSource::FILTER_OR) {
             $handle = $this->buildFilterJoin($joins);
         }
         foreach ($values as $index => $value) {
             if ($filter_join != DataSource::FILTER_OR) {
                 $handle = $this->buildFilterJoin($joins);
             }
             $statements[] = $db->prepareQuery("{$handle}.password = '%s' OR {$handle}.code = '%s'", array(sha1($value), $driver->extractToken($value, 'login')));
         }
         if (empty($statements)) {
             return true;
         }
         if ($filter_join == DataSource::FILTER_OR) {
             $statement = "(\n\t" . implode("\n\tOR ", $statements) . "\n)";
         } else {
             $statement = "(\n\t" . implode("\n\tAND ", $statements) . "\n)";
         }
         if ($filter->type == 'is-not') {
             $statement = 'NOT ' . $statement;
         }
         $where[] = $statement;
     }
     return true;
 }

 public function buildFilterQuery($filter, &$joins, array &$where, Register $parameter_output)
 {
     $filter = $this->processFilter($filter);
     $filter_join = DataSource::FILTER_OR;
     $db = Symphony::Database();
     $values = DataSource::prepareFilterValue($filter->value, $parameter_output, $filter_join);
     if (!is_array($values)) {
         $values = array();
     }
     // Exact matches:
     if ($filter->type == 'is' or $filter->type == 'is-not') {
         $statements = array();
         if ($filter_join == DataSource::FILTER_OR) {
             $handle = $this->buildFilterJoin($joins);
         }
         foreach ($values as $index => $value) {
             if ($filter_join != DataSource::FILTER_OR) {
                 $handle = $this->buildFilterJoin($joins);
             }
             $statements[] = $db->prepareQuery("'%s' IN ({$handle}.value, {$handle}.handle)", array($value));
         }
         if (empty($statements)) {
             return true;
         }
         if ($filter_join == DataSource::FILTER_OR) {
             $statement = "(\n\t" . implode("\n\tOR ", $statements) . "\n)";
         } else {
             $statement = "(\n\t" . implode("\n\tAND ", $statements) . "\n)";
         }
         if ($filter->type == 'is-not') {
             $statement = 'NOT ' . $statement;
         }
         $where[] = $statement;
     } else {
         if ($filter->type == 'is-null') {
             $handle = $this->buildFilterJoin($joins);
             $where[] = $db->prepareQuery("{$handle}.value IS NULL");
         } else {
             if ($filter->type == 'is-null') {
                 $handle = $this->buildFilterJoin($joins);
                 $where[] = $db->prepareQuery("{$handle}.value IS NULL");
             } else {
                 if ($filter->type == 'contains' or $filter->type == 'does-not-contain') {
                     $statements = array();
                     if ($filter_join == DataSource::FILTER_OR) {
                         $handle = $this->buildFilterJoin($joins);
                     }
                     foreach ($values as $index => $value) {
                         $value = '%' . $value . '%';
                         if ($filter_join != DataSource::FILTER_OR) {
                             $handle = $this->buildFilterJoin($joins);
                         }
                         $statements = array($db->prepareQuery("{$handle}.value LIKE '%s'", array($value)), $db->prepareQuery("{$handle}.handle LIKE '%s'", array($value)));
                     }
                     if (empty($statements)) {
                         return true;
                     }
                     if ($filter_join == DataSource::FILTER_OR) {
                         $statement = "(\n\t" . implode("\n\tOR ", $statements) . "\n)";
                     } else {
                         $statement = "(\n\t" . implode("\n\tAND ", $statements) . "\n)";
                     }
                     if ($filter->type == 'does-not-contain') {
                         $statement = 'NOT ' . $statement;
                     }
                     $where[] = $statement;
                 } else {
                     if ($filter->type == 'regex-search') {
                         $handle = $this->buildFilterJoin($joins);
                         $value = trim($filter->value);
                         $statements = array($db->prepareQuery("{$handle}.value REGEXP '%s'", array($value)), $db->prepareQuery("{$handle}.handle REGEXP '%s'", array($value)));
                         $where[] = "(\n\t" . implode("\n\tOR ", $statements) . "\n)";
                     }
                 }
             }
         }
     }
     return true;
 }

    public function buildFilterQuery($filter, &$joins, array &$where, Register $ParameterOutput = NULL)
    {
        self::$key++;
        $value = DataSource::prepareFilterValue($filter['value'], $ParameterOutput, $operation_type);
        $joins .= sprintf('
				LEFT OUTER JOIN `tbl_data_%2$s_%3$s` AS t%1$s ON (e.id = t%1$s.entry_id)
			', self::$key, $this->section, $this->{'element-name'});
        if ($operation_type == DataSource::FILTER_AND) {
            $clause = NULL;
            foreach ($value as $v) {
                $clause .= sprintf("(t%1\$s.value %2\$s '%3\$s') AND", self::$key, $filter['type'] == 'is-not' ? '<>' : '=', $v);
            }
            $where[] = sprintf("(%s)", preg_replace('/AND$/i', NULL, $clause));
        } else {
            $where[] = sprintf("(t%1\$s.value %2\$s IN ('%3\$s'))", self::$key, $filter['type'] == 'is-not' ? 'NOT' : NULL, implode("', '", $value));
        }
        return true;
    }

    public function xbuildFilterQuery($filter, &$joins, array &$where, Register $ParameterOutput = NULL)
    {
        var_dump($this->getFilterTypes($filter));
        var_dump($filter);
        exit;
        self::$key++;
        $value = DataSource::prepareFilterValue($filter['value'], $ParameterOutput, $filterOperationType);
        $joins .= sprintf('
				LEFT OUTER JOIN `tbl_data_%2$s_%3$s` AS t%1$s ON (e.id = t%1$s.entry_id)
			', self::$key, $this->section, $this->{'element-name'});
        if ($filterOperationType == DataSource::FILTER_AND) {
            $clause = NULL;
            foreach ($value as $v) {
                $clause .= sprintf(" (t%1\$s.relation_id %2\$s '%3\$s') AND", self::$key, $filter['type'] == 'is-not' ? '<>' : '=', $v);
            }
            $where[] = sprintf("(%s)", preg_replace('/AND$/i', NULL, $clause));
        } else {
            $where[] = sprintf("(t%1\$s.relation_id %2\$s IN ('%3\$s'))", self::$key, $filter['type'] == 'is-not' ? 'NOT' : NULL, implode("', '", $value));
        }
        return true;
        // OLD CODE ------
        $field_id = $this->{'id'};
        if (preg_match('/^sql:\\s*/', $data[0], $matches)) {
            $data = trim(array_pop(explode(':', $data[0], 2)));
            if (strpos($data, "NOT NULL") !== false) {
                $joins .= " LEFT JOIN\n\t\t\t\t\t\t\t\t\t`tbl_entries_data_{$field_id}` AS `t{$field_id}`\n\t\t\t\t\t\t\t\tON (`e`.`id` = `t{$field_id}`.entry_id)";
                $where .= " AND `t{$field_id}`.relation_id IS NOT NULL ";
            } else {
                if (strpos($data, "NULL") !== false) {
                    $joins .= " LEFT JOIN\n\t\t\t\t\t\t\t\t\t`tbl_entries_data_{$field_id}` AS `t{$field_id}`\n\t\t\t\t\t\t\t\tON (`e`.`id` = `t{$field_id}`.entry_id)";
                    $where .= " AND `t{$field_id}`.relation_id IS NULL ";
                }
            }
        } else {
            foreach ($data as $key => &$value) {
                // for now, I assume string values are the only possible handles.
                // of course, this is not entirely true, but I find it good enough.
                if (!is_numeric($value)) {
                    $related_field_id = $this->{'related-field-id'};
                    if (is_array($related_field_id) && !empty($related_field_id)) {
                        $return = Symphony::Database()->fetchCol("id", sprintf("SELECT\n\t\t\t\t\t\t\t\t\t`entry_id` as `id`\n\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t`tbl_entries_data_%d`\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t`handle` = '%s'\n\t\t\t\t\t\t\t\tLIMIT 1", $related_field_id[0], Lang::createHandle($value)));
                        // Skipping returns wrong results when doing an AND operation, return 0 instead.
                        if (empty($return)) {
                            $value = 0;
                        } else {
                            $value = $return[0];
                        }
                    }
                }
            }
            if ($andOperation) {
                foreach ($data as $key => $bit) {
                    $joins .= " LEFT JOIN `tbl_entries_data_{$field_id}` AS `t{$field_id}{$key}` ON (`e`.`id` = `t{$field_id}{$key}`.entry_id) ";
                    $where .= " AND `t{$field_id}{$key}`.relation_id = '{$bit}' ";
                }
            } else {
                $joins .= " LEFT JOIN `tbl_entries_data_{$field_id}` AS `t{$field_id}` ON (`e`.`id` = `t{$field_id}`.entry_id) ";
                $where .= " AND `t{$field_id}`.relation_id IN ('" . @implode("', '", $data) . "') ";
            }
        }
        return true;
    }

 public function buildFilterQuery($filter, &$joins, array &$where, Register $parameter_output)
 {
     $filter = $this->processFilter($filter);
     $filter_join = DataSource::FILTER_OR;
     $db = Symphony::Database();
     $values = DataSource::prepareFilterValue($filter->value, $parameter_output, $filter_join);
     if (!is_array($values)) {
         $values = array();
     }
     // Exact matches:
     if ($filter->type == 'is' or $filter->type == 'is-not') {
         $statements = array();
         if ($filter_join == DataSource::FILTER_OR) {
             $handle = $this->buildFilterJoin($joins);
         }
         foreach ($values as $index => $value) {
             if ($filter_join != DataSource::FILTER_OR) {
                 $handle = $this->buildFilterJoin($joins);
             }
             $statements[] = $db->prepareQuery("'%s' IN ({$handle}.relation_id)", array($value));
         }
         if (empty($statements)) {
             return true;
         }
         if ($filter_join == DataSource::FILTER_OR) {
             $statement = "(\n\t" . implode("\n\tOR ", $statements) . "\n)";
         } else {
             $statement = "(\n\t" . implode("\n\tAND ", $statements) . "\n)";
         }
         if ($filter->type == 'is-not') {
             $statement = 'NOT ' . $statement;
         }
         $where[] = $statement;
     }
 }