TypeSubtypeWhereClause.php

Go to the documentation of this file.

<?php

namespace Elgg\Database\Clauses;

use Elgg\Database\QueryBuilder;

class TypeSubtypeWhereClause extends WhereClause {

    public $type_column = 'type';

    public $subtype_column = 'subtype';

    public $type_subtype_pairs = [];

    public function prepare(QueryBuilder $qb, $table_alias = null) {

        $alias = function ($column) use ($table_alias) {
            return $table_alias ? "{$table_alias}.{$column}" : $column;
        };

        $types_where = [];

        if (!empty($this->type_subtype_pairs)) {
            foreach ($this->type_subtype_pairs as $type => $subtypes) {
                if (is_array($subtypes) && !empty($subtypes)) {
                    $types_where[] = $qb->merge([
                        $qb->compare($alias($this->type_column), '=', $type, ELGG_VALUE_STRING),
                        $qb->compare($alias($this->subtype_column), '=', $subtypes, ELGG_VALUE_STRING),
                    ]);
                } else {
                    $types_where[] = $qb->compare($alias($this->type_column), '=', $type, ELGG_VALUE_STRING);
                }
            }
        }

        $wheres = [];
        if (!empty($types_where)) {
            $wheres[] = $qb->merge($types_where, 'OR');
        }

        $wheres[] = parent::prepare($qb, $table_alias);

        return $qb->merge($wheres);
    }
}