[TOC] #### 1. 構建搜索器參數 --- ``` /** * 模型搜索器參數構造函數 * * @param array $keys * @param array $where */ function where_filter(&$keys, array $where) { // 去掉數組里的空字符串和null $where = array_filter($where, function ($k) { return ($k === '' || $k === null) ? false : true; }); // 拿到所有鍵 $keys = array_keys($where); // 返回數組 return $where; } ``` #### 2. 根據時間范圍篩選 --- ``` /** * 追加獲取器 * * create_time_range 根據時間范圍篩選 */ public function searchCreateTimeRangeAttr($query, $value) { $query->whereBetweenTime('create_time', ...explode(' - ', $value)); } ``` #### 3. 根據 nickname 字段模糊查詢 --- ``` /** * 根據nickname字段模糊查詢 * * @param [type] $query [description] * @param [type] $value [description] * @param [type] $data [description] */ public function searchNicknameAttr($query, $value, $data) { $value !== '' && $query->whereLike('nickname', '%' . $value . '%'); } ``` #### 4. hasWhere 根據關聯條件來查詢當前模型對象數據 --- **商家表** ```html mysql> select * from merch; +----+---------+-----------------+ | id | user_id | name | +----+---------+-----------------+ | 1 | 1 | 昊天宗 | | 2 | 2 | 七寶琉璃宗 | 2 rows in set (0.00 sec) ``` **用戶表** ```html mysql> select * from user; +----+--------+-------+ | id | name | score | +----+--------+-------+ | 1 | 張三 | 30 | | 2 | 李四 | 20 | | 3 | 王五 | 50 | +----+--------+-------+ 3 rows in set (0.02 sec) ``` **應用場景: 在商家列表中根據用戶昵稱查詢商家** ``` public function searchNameAttr($query, $value, $data) { $query->hasWhere('user', function ($query) use ($value) { $query->whereLike('name', '%' . $value . '%'); }); } ```