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

<?php

namespace App\Http\Controllers;

use App\Http\Api\PaliTextApi;
use App\Models\Channel;
use App\Models\PaliSentence;
use App\Models\Sentence;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use Illuminate\Support\Arr;

class ArticleProgressController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return Response
     */
    public function index(Request $request)
    {
        //
        switch ($request->input('view')) {
            case 'chapter':
                $chapter = PaliTextApi::getChapterStartEnd($request->input('book'), $request->input('para'));
                $channels = Sentence::where('book_id', $request->input('book'))
                    ->whereBetween('paragraph', $chapter)
                    ->where('strlen', '>', 0)
                    ->groupBy('channel_uid')
                    ->select('channel_uid')
                    ->get();
                // 获取单句长度
                $sentLen = PaliSentence::where('book', $request->input('book'))
                    ->whereBetween('paragraph', $chapter)
                    ->orderBy('word_begin')
                    ->select(['book', 'paragraph', 'word_begin', 'word_end', 'length'])
                    ->get();
                // 获取每个channel的完成度
                foreach ($channels as $key => $value) {
                    // code...
                    $finished = Sentence::where('book_id', $request->input('book'))
                        ->whereBetween('paragraph', $chapter)
                        ->where('channel_uid', $value->channel_uid)
                        ->where('strlen', '>', 0)
                        ->select(['strlen', 'book_id', 'paragraph', 'word_start', 'word_end'])
                        ->get();
                    $final = [];
                    foreach ($sentLen as $sent) {
                        // code...
                        $first = Arr::first($finished, function ($value, $key) use ($sent) {
                            return $value->book_id == $sent->book &&
                                $value->paragraph == $sent->paragraph &&
                                $value->word_start == $sent->word_begin &&
                                $value->word_end == $sent->word_end;
                        });
                        $final[] = [$sent->length, $first ? true : false];
                    }
                    $value['final'] = $final;
                }

                return $this->ok($channels);
                break;
        }
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return Response
     */
    public function create()
    {
        //
    }

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

    /**
     * Display the specified resource.
     *
     * @return Response
     */
    public function show(Channel $channel)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @return Response
     */
    public function edit(Channel $channel)
    {
        //
    }

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

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