Laravelwhere条件拼接,数组使用where方法
原创// 获取文章列表
// @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);
}
版权声明
所有资源都来源于爬虫采集,如有侵权请联系我们,我们将立即删除