```
Db::whereTime('time','today')->select() //獲取今天的數據
```
```
Db::whereTime('time','yesterday')->select() //獲取昨天的數據
```
```
Db::whereTime('time','week')->select() //獲取本周的數據
```
```
Db::whereTime('time','last week')->select() //獲取上一周的數據
```
```
Db::whereTime('time','month')->select() //獲取本月的數據
```
```
Db::whereTime('time','year')->select() //獲取今年的數據
```
```
Db::whereTime('time','last year')->select() //獲取去年的數據
```
## 模型批量更新**
~~~
$addressList::where('user_id',$uid)->update(['default'=>0]);
~~~
## **日志寫入自定義路徑**
```
Log::init(['type' => 'File', 'path' => LOG_PATH . 'commission/']);
log::write($this->request->post(),'info');
```
## 模型自動格式化時間戳
~~~
// 定義時間戳字段名
protected $createTime = 'createtime';
protected $updateTime = 'updatetime';
protected $dateFormat = 'Y-m-d H:i:s';
~~~
模型關聯查詢使用關聯模型作為查詢條件
~~~
$data = $this->with(['user', 'order', 'dealerFirst', 'dealerSecond', 'referee' => function ($q) use ($dealer_id) {
$q->where('dealer_id', $dealer_id);
}])->where($where)
->where('first_user_id|second_user_id', '=', $dealer_id)
->order(['create_time' => 'desc'])
->select();
~~~
