RelationshipWhereClause.php

Go to the documentation of this file.

<?php

namespace Elgg\Database\Clauses;

use Elgg\Database\QueryBuilder;

class RelationshipWhereClause extends WhereClause {

    public $ids;

    public $names;

    public $subject_guids;

    public $object_guids;

    public $created_after;

    public $created_before;

    public $inverse;

    public $join_on = 'guid';

    public function prepare(QueryBuilder $qb, $table_alias = null) {
        $alias = function ($column) use ($table_alias) {
            return $table_alias ? "{$table_alias}.{$column}" : $column;
        };

        $wheres = [];

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

        $wheres[] = $qb->compare($alias('id'), '=', $this->ids, ELGG_VALUE_ID);
        $wheres[] = $qb->compare($alias('relationship'), '=', $this->names, ELGG_VALUE_STRING);
        $wheres[] = $qb->compare($alias('guid_one'), '=', $this->subject_guids, ELGG_VALUE_GUID);
        $wheres[] = $qb->compare($alias('guid_two'), '=', $this->object_guids, ELGG_VALUE_GUID);
        $wheres[] = $qb->between($alias('time_created'), $this->created_after, $this->created_before, ELGG_VALUE_TIMESTAMP);

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