duanju_manage/app/Console/Commands/ContentManage/ContentTest.php

<?php

namespace App\Console\Commands\ContentManage;

use http\Exception\RuntimeException;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Redis;
use Modules\Audience\Services\UserGroupService;
use Modules\Common\Errors\Errors;
use Modules\Common\Exceptions\CommonBusinessException;

class ContentTest extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'app:contenttest';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Command description';

    /**
     * Execute the console command.
     */
    public function handle(): void
    {
        $tags = [
            'attention_hour' => '0-6',
            'in_48_hour' => 1,
            'interact_hour' => '0-6',
            'last_watch_day' => '0-2',
            'register_day' => '0-2',
            'total_watch_day' => '0-2',
            'charge_type' => 1,
            'total_charge_money' => '1-1000',
            'avg_charge_money' => '2-300',
            'charge_num' => '1-1',
            'remain_coin' => '0-1',
            'last_charge_day' => '0-4',
            'video_watch' => [1,2,3],
            'video_charge' => [4,5]
        ];

        $sql = UserGroupService::getSQL($tags)->distinct()->count('a.uid');
        dump($sql);
    }
}