duanju_manage/modules/Statistic/Http/Controllers/VideoStatController.php

<?php

namespace Modules\Statistic\Http\Controllers;

use Carbon\Carbon;
use Catch\Base\CatchController;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Modules\User\Http\Controllers\UserTrait;
use Modules\Statistic\Models\VideoStatByCompany;

/**
 * 短剧统计
 */
class VideoStatController extends CatchController
{

    use UserTrait;
    public function __construct(protected readonly VideoStatByCompany $videoStatByCompany)
    {
        
    }

    public function index(Request $request)
    {
        
        if(!$this->isCompanyManager()){
            return [];
        }
        //$default_end_time = Carbon::now()->subDay();
        $default_end_time = Carbon::now();
        $user_id = $this->getLoginUser()->id;
        $video_name = $request->get('video_name');
        $start_date = $request->get('start_date');
        $end_date = $request->get('end_date');
        $limit = $request->get('limit',15);

        if(!$end_date){
            $end_date = $default_end_time;
        }else{
            $end_date = Carbon::createFromTimeString($end_date.' 00:00:00');
        }

        if($start_date){
            $start_date = Carbon::createFromTimeString($start_date.' 00:00:00');
        }else{
            $start_date = $end_date->clone()->subDays(7);
        }

        $where = [
            ['user_id','=',$user_id],
            ['is_delete','=',0],
            ['day','>=',$start_date->format('Y-m-d')],
            ['day','<=',$end_date->format('Y-m-d')]
        ];
        
        if(trim($video_name)){
            $where[] = ['video_name','like','%'.trim($video_name).'%'];
        }

        $stats = $this->videoStatByCompany->where($where)->select(DB::raw('sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num'))->first();
        $result = $this->videoStatByCompany->where($where)->select('day','video_name','video_id','amount','charge_count','charge_user_num','play_count')->paginate($limit);
        if($stats){
            $stats_obj = [
                'amount'=>$stats->amount,
                'charge_count'=>$stats->charge_count,
                'charge_user_num'=>$stats->charge_user_num
            ];
        }else{
            $stats_obj = [
                'amount'=>0,
                'charge_count'=>0,
                'charge_user_num'=>0
            ];
        }
        
        return ['result'=>$result,'stats'=>$stats_obj];
    }

 
}