Laravel 多态关联中不能使用 has, whereHas

最新推荐文章于 2021-04-01 18:16:27 发布

weixin_30954607

最新推荐文章于 2021-04-01 18:16:27 发布

阅读量741

点赞数

文章标签： php

原文链接：http://www.cnblogs.com/mouseleo/p/10984076.html

版权

ghost commented on Apr 13, 2017 •

edited by ghost

i'm currently using this code in my own project

my Model (\App\Production\Models\Production Model)

public function detail()
{
    return $this->morphTo('detail');
}

public function scopeDetailable($query, $callable = null)
{
    list($type, $key) = $this->getPolymorphicFields();

    $this->newQuery()->distinct()->get([$type])->keyBy($type)->map(function ($model)  use ($type) {
        return (new $model->{$type})->getTable();
    })->each(function ($table, $modelClass) use (&$query, $key, $callable) {
        $model = new $modelClass;

        $query = $query->orWhereExists(function ($query) use ($table, $model, $key, $callable) {
            $query->select('*')->from($table)->whereRaw("{$this->getTable()}.{$key} = {$table}.{$model->getKeyName()}")
                ->when($callable instanceof \Closure, $callable);
        });
    });

    return $query;
}

protected function getPolymorphicFields()
{
    $relation = $this->detail();

    return [$relation->getMorphType(), $relation->getForeignKey()];
}

my Controller

\App\Production\Models\Production::detailable(function ($query) {
    $query->whereDate('panen_future_date', '2017-02-08');
})->with('detail')->get()

and it works for my use case.

please note that all model related to \App\Production\Models\Production model have 'panen_future_date' filed in its table.

转载于:https://www.cnblogs.com/mouseleo/p/10984076.html

weixin_30954607

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Laravel 多态关联中不能使用 has, whereHas

ghostcommentedon Apr 13, 2017•edited by ghosti'm currently using this code in my own projectmy Model (\App\Production\Models\Production Model)public function detail(...
复制链接

扫一扫