~~~
/**
* 列表(主鍵列表，條件數組，閉包查詢)
*
* @param array $param 查詢條件
* @return void
*/
public function doList(Request $request)
{
//返回訂單列表
//
$param = $request->param();
$page = $param['page'];
$start = $param['start'];
$limit = $param['limit'];
$offset = ($page - 1) * $limit;
//日志類型及查詢日期
//
$type = array_key_exists("type", $param) ? $param['type'] : null;
$date = array_key_exists("date", $param) ? $param['date'] : null;
// 匹配條件
//
if ((!empty($type) || '0' == $type) && (!empty($date))) {
$where = "DATEDIFF(`create_time`,'{$date}') = 0 AND `type` = '{$type}'";
} else if (!empty($type) || '0' == $type) {
$where = "`type` = '{$type}'";
} else if (!empty($date)) {
$where = "DATEDIFF(`create_time`,'{$date}') = 0";
} else {
$date = date('Y-m-d');
//默認參數(當天)配合數據倉庫字段加載
$where = "DATEDIFF(`create_time`,'{$date}') = 0";
}
try {
//查詢數據
$result = self::all(function ($query) use ($offset, $limit, $where) {
$query->where($where)
->limit($offset, $limit)
->order('create_time', 'desc');
});
$rows = [];
foreach ($result as $data) {
$item = $data->getData();
array_push($rows, $item);
}
//返回結果
//
$res = array();
//查詢數據總量
$total = self::where($where)->count();
if ($total > 0) {
$res['rows'] = $rows;
$res['total'] = $total;
} else {
$res['total'] = 0;
$res['rows'] = array();
}
//請求類型返回
return $res;
} catch (\Exception $e) {
throw new \think\Exception('異常消息:' . $e->getMessage());
}
}
~~~
