get('view')) { case 'toc': $chapter = PaliText::where('book',$request->get('book')) ->where('paragraph',$request->get('para')) ->first(); $start = $request->get('para'); $end = $request->get('para') + $chapter->chapter_len -1 ; $table = PaliText::where('book',$request->get('book')) ->whereBetween('paragraph',[$start,$end]) ->where('level','<',100) ->select(['book','paragraph','level','text','chapter_strlen']); break; } //获取记录总条数 $count = $table->count(); //处理排序 $table = $table->orderBy($request->get("order",'paragraph'), $request->get("dir",'asc')); //处理分页 $table = $table->skip($request->get("offset",0)) ->take($request->get("limit",1000)); $result = $table->get(); return $this->ok([ "rows"=>ChapterResource::collection($result), "count"=>$count ]); } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { // } /** * Display the specified resource. * * @param \App\Models\PaliText $paliText * @return \Illuminate\Http\Response */ public function show(PaliText $paliText) { // } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param \App\Models\PaliText $paliText * @return \Illuminate\Http\Response */ public function update(Request $request, PaliText $paliText) { // } /** * Remove the specified resource from storage. * * @param \App\Models\PaliText $paliText * @return \Illuminate\Http\Response */ public function destroy(PaliText $paliText) { // } }