mint/api-v13/app/Http/Controllers/NavCSParaController.php

<?php

namespace App\Http\Controllers;

use App\Http\Resources\NavCSParaResource;
use App\Models\PaliText;
use App\Models\WbwTemplate;
use Illuminate\Http\Request;
use Illuminate\Http\Response;

class NavCSParaController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return Response
     */
    public function index()
    {
        //
    }

    /**
     * Store a newly created resource in storage.
     *
     * @return Response
     */
    public function store(Request $request)
    {
        //
    }

    /**
     * Display the specified resource.
     *
     * @param  WbwTemplate  $wbwTemplate
     * @return Response
     */
    public function show(string $paraNumber)
    {
        // 99_5_37-38
        $id = explode('_', $paraNumber);
        if (count($id) !== 3) {
            return $this->error('参数错误。参数应为3 实际得到'.count($id), 400, 400);
        }
        // 查询段落起始
        $para = PaliText::where('book', $id[0])
            ->where('paragraph', $id[1])
            ->first();
        if (! $para) {
            return $this->error('没有找到段落起始'.$id, 404, 404);
        }
        // cs 段落号列表
        $csPara = explode('-', $id[2]);
        $csList = [];
        for ($i = (int) $csPara[0]; $i <= (int) end($csPara); $i++) {
            $csList[] = $i;
        }
        // 段落区间
        $begin = $id[1];
        $end = (int) $id[1] + $para->chapter_len;
        $curr = WbwTemplate::where('book', $id[0])
            ->where('style', 'paranum')
            ->whereIn('word', $csList)
            ->whereBetween('paragraph', [$begin, $end])
            ->orderBy('paragraph')
            ->select('book', 'paragraph')->get();
        if (! $curr) {
            return $this->error('没有找到段落'.$id, 404, 404);
        }

        $data = [];
        $data['curr'] = new NavCSParaResource($curr[0]);
        $next = WbwTemplate::where('book', $id[0])
            ->where('style', 'paranum')
            ->where('word', (int) end($csPara) + 1)
            ->whereBetween('paragraph', [$begin, $end])
            ->select('book', 'paragraph')->first();
        if ($next) {
            $data['next'] = new NavCSParaResource($next);
            $data['end'] = $next->paragraph - 1;
        } else {
            $data['end'] = $end;
        }
        $prev = WbwTemplate::where('book', $id[0])
            ->where('style', 'paranum')
            ->where('word', (int) $csPara[0] - 1)
            ->whereBetween('paragraph', [$begin, $end])
            ->select('book', 'paragraph')->first();
        if ($prev) {
            $data['prev'] = new NavCSParaResource($prev);
        }

        return $this->ok($data);
    }

    /**
     * Update the specified resource in storage.
     *
     * @return Response
     */
    public function update(Request $request, WbwTemplate $wbwTemplate)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @return Response
     */
    public function destroy(WbwTemplate $wbwTemplate)
    {
        //
    }
}