duanju_manage/tests/Audience/Services/UserGroupServiceTest.php

<?php

namespace Tests\Audience\Services;

use Illuminate\Support\Facades\DB;
use Modules\Audience\Services\UserGroupService;
use PHPUnit\Framework\TestCase;

class UserGroupServiceTest extends \Tests\TestCase
{

    public function testGetSQL()
    {
        $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',
        ];

        $sql = UserGroupService::getSQL($tags);
    }
}