ExtraField::parseConditions()

Complexity

Conditions	23
Paths	72

Size

Total Lines	156
Code Lines	108

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function parseConditions($options, $alias = 's')
    {
        $inject_extra_fields = null;
        $extraFieldOption = new ExtraFieldOption($this->type);
        $double_fields = [];

        if (isset($options['extra'])) {
            $extra_fields = $options['extra'];
            if (!empty($extra_fields)) {
                $counter = 1;
                $extra_field_obj = new ExtraField($this->type);
                foreach ($extra_fields as &$extra) {
                    if (!isset($extra['id'])) {
                        continue;
                    }
                    $extra_field_info = $extra_field_obj->get($extra['id']);
                    if (empty($extra_field_info)) {
                        continue;
                    }
                    $extra['extra_field_info'] = $extra_field_info;

                    switch ($extra_field_info['field_type']) {
                        case self::FIELD_TYPE_SELECT:
                        case self::FIELD_TYPE_DOUBLE_SELECT:
                            $inject_extra_fields .= " fvo$counter.display_text as {$extra['field']}, ";
                            break;
                        case  self::FIELD_TYPE_TAG:
                            // If using OR
                            //$inject_extra_fields .= " tag$counter.tag as {$extra['field']}, ";
                            // If using AND
                            $newCounter = 1;
                            $fields = [];
                            $tagAlias = $extra['field'];
                            foreach ($extra['data'] as $data) {
                                $fields[] = "tag$counter$newCounter.tag";
                                $newCounter++;
                            }
                            $tags = implode(' , " ", ', $fields);
                            $inject_extra_fields .= " CONCAT($tags) as $tagAlias, ";
                            break;
                        default:
                            $inject_extra_fields .= " fv$counter.value as {$extra['field']}, ";
                            break;
                    }

                    if (isset($extra_fields_info[$extra['id']])) {
                        $info = $extra_fields_info[$extra['id']];
                    } else {
                        $info = $this->get($extra['id']);
                        $extra_fields_info[$extra['id']] = $info;
                    }
                    if (isset($info['field_type']) && self::FIELD_TYPE_DOUBLE_SELECT == $info['field_type']) {
                        $double_fields[$info['id']] = $info;
                    }
                    $counter++;
                }
            }
        }

        $options_by_double = [];
        foreach ($double_fields as $double) {
            $my_options = $extraFieldOption->get_field_options_by_field($double['id'], true);
            $options_by_double['extra_'.$double['variable']] = $my_options;
        }

        $field_value_to_join = [];
        //filter can be all/any = and/or
        $inject_joins = null;
        $inject_where = null;
        $where = null;

        if (!empty($options['where'])) {
            if (!empty($options['extra'])) {
                // Removing double 1=1
                $options['where'] = str_replace(' 1 = 1  AND', '', $options['where']);
                // Always OR
                $counter = 1;
                foreach ($extra_fields as $extra_info) {

The variable $extra_fields does not seem to be defined for all execution paths leading up to this point.

                    $extra_field_info = $extra_info['extra_field_info'];
                    $inject_joins .= " INNER JOIN $this->table_field_values fv$counter
                                       ON ($alias.".$this->primaryKey." = fv$counter.".$this->handler_id.') ';
                    // Add options
                    switch ($extra_field_info['field_type']) {
                        case self::FIELD_TYPE_SELECT:
                        case self::FIELD_TYPE_DOUBLE_SELECT:
                            $options['where'] = str_replace(
                                $extra_info['field'],
                                'fv'.$counter.'.field_id = '.$extra_info['id'].' AND fvo'.$counter.'.option_value',
                                $options['where']
                            );
                            $inject_joins .= "
                                 INNER JOIN $this->table_field_options fvo$counter
                                 ON (
                                    fv$counter.field_id = fvo$counter.field_id AND
                                    fv$counter.value = fvo$counter.option_value
                                 )
                                ";
                            break;
                        case  self::FIELD_TYPE_TAG:
                            /*$options['where'] = str_replace(
                                $extra_info['field'],
                                'tag'.$counter.'.tag ',
                                $options['where']
                            );*/
                            $newCounter = 1;
                            $whereTag = [];
                            foreach ($extra['data'] as $data) {

The variable $extra does not seem to be defined for all execution paths leading up to this point.

                                $data = Database::escape_string($data);
                                $key = $counter.$newCounter;
                                $whereTag[] = ' tag'.$key.'.tag LIKE "%'.$data.'%" ';
                                $inject_joins .= "
                                    INNER JOIN $this->table_field_rel_tag tag_rel$key
                                    ON (
                                        tag_rel$key.field_id = ".$extra_info['id']." AND
                                        tag_rel$key.item_id = $alias.".$this->primaryKey."
                                    )
                                    INNER JOIN $this->table_field_tag tag$key
                                    ON (tag$key.id = tag_rel$key.tag_id)
                                ";
                                $newCounter++;
                            }
                            $options['where'] = ' ('.implode(' AND ', $whereTag).') ';
                            break;
                        default:
                            // text, textarea, etc
                            $options['where'] = str_replace(
                                $extra_info['field'],
                                'fv'.$counter.'.field_id = '.$extra_info['id'].' AND fv'.$counter.'.value',
                                $options['where']
                            );
                            break;
                    }
                    $field_value_to_join[] = " fv$counter.$this->handler_id ";
                    $counter++;
                }
            }
            $where .= ' AND '.$options['where'];
        }

        $order = null;
        if (!empty($options['order'])) {
            $order = ' ORDER BY '.$options['order'];
        }
        $limit = null;
        if (!empty($options['limit'])) {
            $limit = ' LIMIT '.$options['limit'];
        }

        return [
            'order' => $order,
            'limit' => $limit,
            'where' => $where,
            'inject_where' => $inject_where,
            'inject_joins' => $inject_joins,
            'field_value_to_join' => $field_value_to_join,
            'inject_extra_fields' => $inject_extra_fields,
        ];