Laravel where条件拼接，数组拼接where条件-蒲公英云

Laravel where条件拼接，数组拼接where条件

青旅半醒 2021-09-08 18:52 751阅读 0赞

 // 获取文章列表  
// @url api/user/article?article\_class\_id=1&status=1&crop\_class\_id=1  
public function index(Request $request)  
\{  
    $where = \[\];  
    // 分类  
    $article\_class\_id  = $request->article\_class\_id;  
    if(!empty($article\_class\_id))\{  
        $where\['article\_class\_id'\] = intval($article\_class\_id);  
    \}  
    // 状态  
    $status = $request->status;  
    if(!empty($status))\{  
        $where\['status'\] = intval($status);  
    \}  
    // 作物  
    $crop\_class\_id = $request->crop\_class\_id;  
    if(!empty($crop\_class\_id))\{  
        $where\['crop\_class\_id'\] = intval($crop\_class\_id);  
    \}  
    // 标题  
    $title = $request->title;  
    if(!empty($title))\{  
        $where\[\] = \['title', 'like', '%'.$title.'%'\];  
    \}  
    $limit  = $request->input('limit');  
    $deviceRegionList = ArticleModel::where($where)->orderBy('id','desc')->with('user', 'article\_class', 'crop\_class')->paginate($limit)->toArray();  
    $returnData = \[\];  
    $returnData\['msg'\]              = "查询成功";  
    $returnData\['count'\]            = $deviceRegionList\['total'\];  
    $returnData\['current\_page'\]     = $deviceRegionList\['current\_page'\];  
    $returnData\['data'\]             = $deviceRegionList\['data'\];  
    return success($returnData);  
\}