多对多中间表关联模糊搜索

当前表model

/*
 * 关联货品管理类别中间表Model
 * @auth jackie <2019.10.18>
 */
public function hasManyGoodsManagementType()
{
    return $this->hasMany(KeyGoodsmanagementType::class,'management_id','id');
}

/*
 * @param $management_type_name 货品管理类别
 * @auth jackie <2019.10.22>
 */
public function scopeManagementTypeLike($query,$management_type_name)
{
    return $query->whereHas('hasManyGoodsManagementType.hasOneGoodsManagementType',function ($query1) use($management_type_name){
        return $query1->where('name','like',$management_type_name);
    });
}

中间表model

/*
 * 关联货品管理类别表
 * @auth jackie <2019.10.>
 */
public function hasOneGoodsManagementType()
{
    return $this->hasOne(GoodsManagementType::class,'id','management_type_id');
}