scene('list')->validate(); // 查询条件 $map = []; $limit = request('limit', config('page_num', 10)); $start_time = request('start_time', ''); $end_time = request('end_time', ''); $module_menu_name = request('module_menu_name', ''); $general_description = request('general_description', ''); $notes_type = request('notes_type', ''); // 时间条件 if ($start_time) $map[] = ['insert_time', '>=', strtotime($start_time)]; if ($end_time) $map[] = ['insert_time', '<=', strtotime($end_time)]; // 其他条件 if ($module_menu_name) $map[] = ['module_menu_name', 'like', "%$module_menu_name%"]; if ($general_description) $map[] = ['general_description', 'like', "%$general_description%"]; if ($notes_type) $map[] = ['notes_type', '=', $notes_type]; // 查询数据 $result = $AdminHistoryModel ->where($map) ->select(['id', 'admin_uid', 'is_admin', 'module_menu_name', 'notes_type', 'general_description', 'insert_time']) ->orderByDesc('id') ->paginate($limit)->toarray(); if (isset($result['data']) && count($result['data']) > 0) { foreach ($result['data'] as $key => $value) { $is_admin = $value['is_admin']; if ($is_admin == '1') { $result['data'][$key]['username'] = $AdminUserModel->where('uid', $value['admin_uid'])->value('username'); } else { $result['data'][$key]['username'] = $EmployeeModel->where('id', $value['admin_uid'])->value('name'); } } } // 分配数据 if (!$result) return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => []]); // 加载模板 return json_send(['code' => 'success', 'msg' => '获取成功', 'data' => $result]); } }