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

<?php

namespace App\Http\Controllers;

use App\Http\Api\UserApi;
use App\Models\DhammaTerm;
use App\Models\Sentence;
use App\Models\UserDict;
use App\Models\UserOperationDaily;
use App\Models\UserOperationLog;
use App\Models\Wbw;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use Illuminate\Support\Facades\Cache;

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

    /**
     * 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.
     *
     * @param  UserOperationDaily  $userOperationDaily
     * @return Response
     */
    public function show(Request $request, string $userName)
    {
        //
        $queryUserId = UserApi::getIntIdByName($userName);
        $queryUserUuid = UserApi::getIdByName($userName);
        $cacheExpiry = config('mint.cache.expire');

        $expSum = 0;
        $wbwCount = 0;
        $lookupCount = 0;
        $translationCount = 0;
        $translationCountPub = 0;
        $termCount = 0;
        $termCountWithNote = 0;
        $myDictCount = 0;
        // 总经验值
        if (! $request->has('view') || $request->input('view') === 'exp-sum') {
            $expSum = Cache::remember(
                "user/{$userName}/exp/sum",
                $cacheExpiry,
                function () use ($queryUserId) {
                    return UserOperationDaily::where('user_id', $queryUserId)
                        ->sum('duration');
                }
            );
        }

        // 逐词解析
        if (! $request->has('view') || $request->input('view') === 'wbw-count') {
            $wbwCount = Cache::remember(
                "user/{$userName}/wbw/count",
                $cacheExpiry,
                function () use ($queryUserId) {
                    return Wbw::where('editor_id', $queryUserId)
                        ->count();
                }
            );
        }

        // 查字典次数
        if (! $request->has('view') || $request->input('view') === 'lookup-count') {
            $lookupCount = Cache::remember(
                "user/{$userName}/lookup/count",
                $cacheExpiry,
                function () use ($queryUserId) {
                    return UserOperationLog::where('user_id', $queryUserId)
                        ->where('op_type', 'dict_lookup')
                        ->count();
                }
            );
        }
        // 译文
        // TODO 判断是否是译文channel
        if (! $request->has('view') || $request->input('view') === 'translation-count') {
            $translationCount = Cache::remember(
                "user/{$userName}/translation/count",
                $cacheExpiry,
                function () use ($queryUserUuid) {
                    return Sentence::where('editor_uid', $queryUserUuid)
                        ->count();
                }
            );
            $translationCountPub = Cache::remember(
                "user/{$userName}/translation/count-pub",
                $cacheExpiry,
                function () use ($queryUserUuid) {
                    return Sentence::where('editor_uid', $queryUserUuid)
                        ->where('status', 30)
                        ->count();
                }
            );
        }
        // 术语
        if (! $request->has('view') || $request->input('view') === 'term-count') {
            $termCount = Cache::remember(
                "user/{$userName}/term/count",
                $cacheExpiry,
                function () use ($queryUserId) {
                    return DhammaTerm::where('editor_id', $queryUserId)
                        ->count();
                }
            );
            $termCountWithNote = Cache::remember(
                "user/{$userName}/term/count-note",
                $cacheExpiry,
                function () use ($queryUserId) {
                    return DhammaTerm::where('editor_id', $queryUserId)
                        ->where('note', '<>', '')
                        ->count();
                }
            );
        }
        // 单词本
        if (! $request->has('view') || $request->input('view') === 'my-dict-count') {
            $myDictCount = Cache::remember(
                "user/{$userName}/dict/count",
                $cacheExpiry,
                function () use ($queryUserId) {
                    return UserDict::where('creator_id', $queryUserId)
                        ->count();
                }
            );
        }

        return $this->ok([
            'exp' => ['sum' => (int) $expSum],
            'wbw' => ['count' => (int) $wbwCount],
            'lookup' => ['count' => (int) $lookupCount],
            'translation' => [
                'count' => (int) $translationCount,
                'count_pub' => (int) $translationCountPub,
            ],
            'term' => [
                'count' => (int) $termCount,
                'count_with_note' => (int) $termCountWithNote,
            ],
            'dict' => ['count' => (int) $myDictCount],
        ]);
    }

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

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

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