video_server/app/Repositories/TaskAwarkLogRepository.php

<?php

declare(strict_types=1);

namespace App\Repositories;

use App\Model\TaskAwarkLogModel;
use Carbon\Carbon;
use KZ2\Repositories\Model\Repository;

class TaskAwarkLogRepository extends Repository
{

    public function model()
    {
        return TaskAwarkLogModel::class;
    }

    /**
     * 查询用户奖励方式记录
     *
     * @param $where
     * @return \Hyperf\Database\Model\Builder|\Hyperf\Database\Model\Model|object|null
     */
    public function findUserRewardWay($where)
    {
        return TaskAwarkLogModel::query()->where($where)->first();
    }

    /**
     * 统计今天一次性的奖励
     * @param string $userCode
     * @param int $rewardType 奖励类型:1,观影次数;2,评论数;3,开房查询记录.4;金币
     * @return int
     */
    public function coutTodayOnce($userCode, $rewardType = 1)
    {
        $today = Carbon::now()->toDateString();


        $model = TaskAwarkLogModel::query()->where(['uid' => $userCode, 'reward_type' => $rewardType, 'is_add_up' => 2])->whereDate('date', $today);

        $amount = $model->sum('reward');

        return $amount;
    }
}