Laravel 多条件查询

<?php
public function localSearch($city, $name){
    $sou = ['wmember.headimgurl', 'activity.id', 'activity.tr_id', 'activity.wid',
    'activity.title', 'activity.img', 'activity.price',
    'activity.start', 'activity.forming', 'activity.day_number'];
//按类型搜索
$homeSearch = Activity::where('tr_id', 1)->where('end', '>=', date("Y-m-d"))
    ->where('activity.city', $city)
    ->Join('wmember', 'activity.wid', '=', 'wmember.wid')
    ->where('activity.type', 'like', '%' . $name . '%')
    ->select($sou)->get();
if ($homeSearch->isEmpty())
    //按标题搜索
    $homeSearch = Activity::where('tr_id', 1)->where('end', '>=', date("Y-m-d"))
        ->where('activity.city', $city)
        ->Join('wmember', 'activity.wid', '=', 'wmember.wid')
        ->where('activity.title', 'like', '%' . $name . '%')
        ->select($sou)->get();
if ($homeSearch->isEmpty())
    //如果以上条件都不满足就调用首页进入的搜索
    $this->homeSearch($city, $name);

foreach ($homeSearch as $k => $v) {
    $v->img = asset($v->img);
    //判断该活动的报名人数是否成型
    $ord_people = DB::table('order')->where('sub_id', $v->id)->where('status', 2)->sum('people_num');
    if ($ord_people >= $v->forming) {
        $v->become = "已成行";
    } else {
        $v->become = "报名中";
    }
}
if ($homeSearch->first()) {
    return ['status' => '0', 'msg' => "加载成功!", 'search' => $homeSearch];
} else {
    return ['status' => '1', 'msg' => "暂时没有数据!"];
}
}

本作品采用《CC 协议》，转载必须注明作者和本文链接