laravel日常笔记

1. 闭包 中使用 $request 前需要引入 user ($request)

$users = User::query()
    ->where('status', '=', 1)
    ->where(function ($query) use ($request) {
        $query->where('mobile', 'like', '%' . $request->search . '%')
            ->orWhere(function ($query) use ($request) {
                $query->where('realname', 'like', '%' . $request->search . '%');
            });
    })
    ->whereIn('id', $ids_info)
    ->orderBy('create_time', 'desc')
    ->get();

2. $request->all() 中追加数据

$request->offsetSet('source', 2);
$requestData = $request->all();

3. Request 验证 存在或者唯一

'mobile'   => 'required|unique:yc_user,mobile',  //唯一，不允许重复
'shop_id'  => 'required|exists:yc_shop,id',		 //shop_id, 必须存在

namespace App\Http\Requests\App\User;

use Illuminate\Foundation\Http\FormRequest;

class UserRequest extends FormRequest
{
    public function authorize()
    {
        return true;
    }

    public function rules()
    {
        return [
            'mobile'   => 'required|unique:yc_user,mobile',
            'shop_id'  => 'required|exists:yc_shop,id',
            'sex'      => 'required|in:0,1,2',
            'realname' => 'required'
        ];
    }

    public function attributes()
    {
        return [
            'mobile'   => __('手机号'),
            'shop_id'  => __('门店'),
            'sex'      => __('性别'),
            'realname' => __('姓名')
        ];
    }
}

4. 打印sql

DB::connection()->enableQueryLog();  // 开启QueryLog
xxx
dump(DB::getQueryLog());

5. laravel 观察者

• 文档： https://learnku.com/docs/laravel/6.x/eloquent/5176

• 目录： Eloquent ORM->观察者