<?php
/**
 * @remark :
 * @name   :ForwardInquiryCount.php
 * @author :lyh
 * @method :post
 * @time   :2023/8/18 9:41
 */

namespace App\Console\Commands\MonthlyCount;

use App\Models\Inquiry\ForwardCount;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

/**
 * @remark :转发询盘人员统计
 * @name   :ForwardInquiryCount
 * @author :lyh
 * @method :post
 * @time   :2023/8/18 9:42
 */
class ForwardInquiryCount extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'forward_count';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '月转发报告统计';

    /**
     * @remark :统计报告
     * @name   :handle
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 9:52
     */
    public function handle(){
        // 获取上个月的开始时间
        $startTime = Carbon::now()->subMonth()->startOfMonth()->toDateString();
        // 获取上个月的结束时间
        $endTime = Carbon::now()->subMonth()->endOfMonth()->toDateString();
        $list = DB::table('gl_inquiry_info')->groupBy('user_name')
            ->select("user_name",DB::raw('COUNT(*) as count'))
            ->where('send_time','>=',$startTime.' 00:00:00')
            ->where('send_time','<=',$endTime.' 23:59:59')
            ->get();
        if(!empty($list)){
            $list = $list->toArray();
            $forwardModel = new ForwardCount();
            foreach ($list as $v){
                $data = [
                    'date'=>Carbon::now()->subMonth()->format('Y-m'),
                    'name'=>$v['user_name'],
                    'count'=>$v['count']
                ];
                $forwardModel->add($data);
            }
        }
        return 1;
    }
}