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

<?php

namespace App\Http\Controllers;

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

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

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

    /**
     * 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\UserOperationDaily  $userOperationDaily
     * @return \Illuminate\Http\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->get('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->get('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->get('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->get('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->get('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->get('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.
     *
     * @param  \App\Models\UserOperationDaily  $userOperationDaily
     * @return \Illuminate\Http\Response
     */
    public function edit(UserOperationDaily $userOperationDaily)
    {
        //
    }

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

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Models\UserOperationDaily  $userOperationDaily
     * @return \Illuminate\Http\Response
     */
    public function destroy(UserOperationDaily $userOperationDaily)
    {
        //
    }
}