/**
* Get Values relationship.
*
* @return Values
*/
public function values(Collection $properties = null)
{
$instance = new Value();
$instance->setConnection($this->getConnectionName());
//Builder $query, Model $parent, $foreignKey, $localKey
return new Values($instance->newQuery(), $this, $instance->getTable() . '.entity_id', $this->getKeyName(), $properties);
}
/**
* @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();
}
}
/**
* Delete entity values.
*
* @throws \InvalidArgumentException
*/
public function delete()
{
if (!in_array(SoftDeletes::class, class_uses_recursive(get_class($this->entity)), true) || $this->entity->forceDeleting) {
$instance = new Value();
$connection = $this->entity->getConnection();
$connection->table($instance->getTable())->where('entity_id', $this->entity->getKey())->whereIn('property_id', $this->properties->pluck('id'))->delete();
}
}
