where('status', 1)->orderByDesc('sort')->orderByDesc('id')->select(['id', 'name', 'cover_path', 'resource_type'])->get(); foreach ($category as $k => $item) { $category[$k]['cover_path'] = $item->cover_path_url; } return response()->json($category); } /** * 资源列表 * @param Request $request * @return \Illuminate\Http\JsonResponse */ public function book(Request $request) { $cid = $request->get('cid', 1); $tid = $request->get('tid', 1); $books = LibraryBook::query()->where('category_id', $cid)->where('resource_type', $tid)->where('status', 1)->select(['id', 'name', 'source', 'body', 'cover_path', 'updated_at'])->orderByDesc('sort')->orderByDesc('id')->simplePaginate(30); foreach ($books as $k => $book) { $books[$k]['cover_path'] = $book->cover_path_url; } return response()->json($books); } /** * 类型 * @return \Illuminate\Http\JsonResponse */ public function resourceTypeMaps(Request $request) { $cid = $request->get('cid', 0); if ($cid) { $resource_types = LibraryCategory::query()->where('status', 1)->where('id', $cid)->value('resource_type'); $data = []; foreach ($resource_types as $resource_type) { $data[$resource_type] = LibraryCategory::resourceTypeMaps[$resource_type]; } return response()->json($data); } return response()->json(LibraryCategory::resourceTypeMaps); } }