/** * @param Builder $builder * @param Eloquent $model * * @throws \InvalidArgumentException */ public function apply(Builder $builder, Eloquent $model) { $query = $builder->getQuery(); if (count($loads = $builder->getEagerLoads()) === 0 && count($query->wheres) === 0 || count($properties = Factory::getPropertiesByEntity($model)) === 0) { return; } //compact eager loading if (count($loads) > 0) { $eadgeLoads = []; $props = []; foreach ($loads as $load => $data) { if ($properties->has($load)) { $props[$load] = $properties->get($load); //$eadgeLoads[$load] = $data; } else { $eadgeLoads[$load] = $data; } } if (count($props)) { $eadgeLoads = ['values' => function (Values $relation) use($props) { $relation->setProperties(new Collection($props)); }] + $eadgeLoads; } $builder->setEagerLoads($eadgeLoads); } $table = $model->getTable(); $columns = $this->parseWhere($properties, $query->wheres, $table); if (count($columns) === 0) { return; } $value = new Value(); $query->select($table . '.*'); $multiple = false; foreach ($columns as $alias => $property) { if ($property->multiple) { $multiple = true; } $query->leftJoin($value->getTable() . ' AS ' . $alias, function (JoinClause $join) use($model, $alias, $property) { $join->on($model->getTable() . '.' . $model->getKeyName(), '=', $alias . '.entity_id'); $join->where($alias . '.property_id', '=', $property->id); }); } if ($multiple) { //Distinct if condition by multiple values $query->distinct(); } }
/** * Set the relationships being eagerly loaded. * * @param array $eagerLoad * @return $this * @static */ public static function setEagerLoads($eagerLoad) { return \Illuminate\Database\Eloquent\Builder::setEagerLoads($eagerLoad); }