bot-28/app/Services/IssueService.php

<?php


namespace App\Services;

use App\Services\BaseService;
use App\Models\Issue;
use App\Models\Config;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\Log;

use App\Services\GameplayRuleService;
use App\Constants\GameplayRuleEnum;
use App\Http\Controllers\admin\Lottery;
use App\Services\KeyboardService;
use App\Services\LotteryImageService;
use Telegram\Bot\FileUpload\InputFile;
use App\Jobs\SendTelegramMessageJob;

/**
 * 投注
*/
class IssueService extends BaseService 
{
    /**
     * @description: 模型
     * @return {string}
     */    
    public static function model() :string
    {
        return Issue::class;
    }

    /**
     * @description: 枚举
     * @return {*}
     */    
    public static function enum() :string
    {
        return '';
    }

    /**
     * @description: 获取查询条件
     * @param {array} $search 查询内容
     * @return {array}
     */    
    public static function getWhere(array $search = []) :array
    {
        $where = [];
        if(isset($search['issue_no']) && !empty($search['issue_no'])){
            $where[] = ['issue_no', '=', $search['issue_no']];
        }
        if(isset($search['id']) && !empty($search['id'])){
            $where[] = ['id', '=', $search['id']];
        }
        if(isset($search['status']) && !empty($search['status'])){
            $where[] = ['status', '=', $search['status']];
        }
        return $where;
    }

     /**
     * @description: 查询单条数据
     * @param array $search
     * @return \App\Models\Coin|null
     */
    public static function findOne(array $search): ?Issue
    {
        return self::model()::where(self::getWhere($search))->first();
    }

    /**
     * @description: 查询所有数据
     * @param array $search
     * @return \Illuminate\Database\Eloquent\Collection
     */
    public static function findAll(array $search = [])
    {
        return self::model()::where(self::getWhere($search))->get();
    }

    /**
     * @description: 分页查询
     * @param array $search
     * @return \Illuminate\Contracts\Pagination\LengthAwarePaginator
     */
    public static function paginate(array $search = [])
    {
        $limit = isset($search['limit'])?$search['limit']:15;
        $paginator = self::model()::where(self::getWhere($search))->orderBy('issue_no','desc')->paginate($limit);
        return ['total' => $paginator->total(), 'data' => $paginator->items()];
    }

    /**
     * @description: 
     * @param {*} $params
     * @return {*}
     */    
    public static function submit($params = [])
    {
        $result = false;
        $msg['code'] = self::NOT;
        $msg['msg'] = '';
        
        // 2. 判断是否是更新
        if (!empty($params['id'])) {
            // 更新
            $info = self::findOne(['id'=>$params['id']] );
            if (!$info) {
                $msg['msg'] = '期号不存在！';
            }else{
                $result = $info->update($params);
                $id = $params['id'];
            }
        } else {
            // 创建
            $result = $info = self::model()::create($params);
            $id = $result->id;
        }
        
       
        if($result){
           $msg['code'] = self::YES;
           $msg['msg'] = '设置成功';
           $msg['key'] = $id;
        }else{
            $msg['msg'] = empty($msg['msg']) ?'操作失败':$msg['msg'];
        }

        return $msg;
    }

    /**
     * @description: 开始下注
     * @param {*} $id
     * @return {*}
     */
    public static function betting($id)
    {
        $info = self::findOne(['id'=>$id]);
        if(!$info){
            return ['code'=>self::NOT, 'msg'=>'期号不存在'];
        }

        if(!in_array($info->status, [self::model()::STATUS_DRAFT,self::model()::STATUS_BETTING])){
            return ['code'=>self::NOT, 'msg'=>'期号状态不正确'];
        }

        $info->status = self::model()::STATUS_BETTING;
        $info->save();

        // $text = "";
        // $text .= "第".$info->issue_no."期\n";
        // $text .= "🔥🔥🔥🔥🔥开始下注🔥🔥🔥🔥🔥\n";
        $replyInfo = KeyboardService::findOne(['button' => '开始下注']);
        if($replyInfo){
            $text = $replyInfo->reply;
            $buttons = json_decode($replyInfo->buttons,true);
            $image = $replyInfo->image;
            if($image){
                $image = url($image);
            }
            self::bettingGroupNotice($text, $buttons, $image);
        }
        $replyInfo = KeyboardService::findOne(['button' => '玩法规则']);
        if($replyInfo){
            $text = $replyInfo->reply;
            $buttons = json_decode($replyInfo->buttons,true);
            $image = $replyInfo->image;
            if($image){
                $image = url($image);
            }
            if(empty($buttons)){
                $buttons = self::getOperateButton();
            }
            self::bettingGroupNotice($text, $buttons, $image);
        }
        return ['code'=>self::YES, 'msg'=>'开始下注'];
    } 

    /**
     * @description: 封盘
     * @param {*} $id
     * @return {*}
     */
    public static function closeBetting($id)
    {
        $info = self::findOne(['id'=>$id]);
        if(!$info){
            return ['code'=>self::NOT, 'msg'=>'期号不存在'];
        }

        if($info->status != self::model()::STATUS_BETTING){
            return ['code'=>self::NOT, 'msg'=>'期号状态不正确'];
        }

        $info->status = self::model()::STATUS_CLOSE;
        $info->save();
        $replyInfo = KeyboardService::findOne(['button' => '停止下注']);
        if($replyInfo){
            $text = $replyInfo->reply;
            $buttons = json_decode($replyInfo->buttons,true);
            $image = $replyInfo->image;
            if($image){
                $image = url($image);
            }
            self::bettingGroupNotice($text, $buttons, $image);
        }
        $replyInfo = KeyboardService::findOne(['button' => '封盘开奖']);
        if($replyInfo){
            $text = $replyInfo->reply;
            $buttons = json_decode($replyInfo->buttons,true);
            $image = $replyInfo->image;
            if($image){
                $image = url($image);
            }
            self::bettingGroupNotice($text, $buttons, $image);
        }
        return ['code'=>self::YES, 'msg'=>'封盘成功'];
    }

    /**
     * @description: 开奖
     * @param {*} $id
     * @param {*} $winning_numbers 开奖号码
     * @param {*} $combo 开奖组合
     * @param {*} $recordImage 开奖图片
     * @return {*}
     */
    public static function  lotteryDraw($id, $winning_numbers ,$combo ,$recordImage)
    {
        $info = self::findOne(['id'=>$id]);
        if(!$info){
            return ['code'=>self::NOT, 'msg'=>'期号不存在'];
        }

        if($info->status != self::model()::STATUS_CLOSE){
            return ['code'=>self::NOT, 'msg'=>'期号状态不正确'];
        }

        $winArr = array_map('intval',explode(',',$winning_numbers));
        // 计算中奖
        $awards = self::award(explode(',',$winning_numbers));
        DB::beginTransaction();
        try {
            $info->status = self::model()::STATUS_DRAW;
            $info->winning_numbers = $winning_numbers;
            $info->combo = $combo;
            $info->image = $recordImage;
            $info->save();

            $replyInfo = KeyboardService::findOne(['button' => '本期开奖']);
            if($replyInfo){
                $text = $replyInfo->reply;
                $text .= "\n";
                $text .= $info->issue_no."期 ".implode('+',explode(',',$winning_numbers))."=".array_sum($winArr)." ".$combo;
                
                $buttons = json_decode($replyInfo->buttons,true);
                $image = $replyInfo->image;
                if($image){
                    $image = url($image);
                }
                if(empty($buttons)){
                    $serviceAccount = Config::where('field', 'service_account')->first()->val;
                    $buttons[] = [['text' => '✅唯一财务', 'callback_data' => "", 'url' => "https://t.me/{$serviceAccount}"]];

                }
                // dispatch(new SendTelegramMessageJob($text, $buttons, $image, true));
                self::bettingGroupNotice($text, $buttons, $image ,true);
            }
            $recordImage = self::lotteryImage($info->issue_no);
            if($recordImage){
                self::bettingGroupNotice('', [], url($recordImage));
                // dispatch(new SendTelegramMessageJob('', [], url($recordImage)));
            }

            BetService::betSettled($info->issue_no, $awards);



            DB::commit();
            return ['code'=>self::YES, 'msg'=>'开奖成功'];
        } catch (\Exception $e) {
            DB::rollBack();
            Log::error('开奖失败: '.$e->getMessage().$winning_numbers);
            return ['code'=>self::NOT, 'msg'=>'开奖失败'];
        }
    }


    // 虚拟开奖
    public static function fakeLotteryDraw($issue_no,$awards)
    {

        $fake_bet_list = Cache::get('fake_bet_'.$issue_no,[]);
        $text = "";

        foreach($fake_bet_list as $k => $v){
            $lastStr = self::getLastChar($v['first_name'],1);
            if(in_array($v['keywords'],$awards)){
                $amount = (float)$v['amount'];
                $odds = (float)$v['odds'];
                $profit = $amount * $odds;
                if($profit > 880000){
                    $profit = 880000; // 单注最高奖金880000
                }
                $item['profit'] = $profit;

                $yl = $profit - $amount;
                if($k+1 <= 30){
                    $text .= "私聊下注 【******".$lastStr."】 {$yl}\n";
                }
            }else{
                if($k+1 <= 30){
                    $text .= "私聊下注 【******".$lastStr."】 -{$v['amount']}\n";
                }
            }
            
        }

        return $text;
    }


    /**
     * @description: 获取中奖的奖项
     * @param {*} $winning_numbers
     * @return {*}
     */    
    public static function award($winning_numbers)
    {
        $result = [];
       
        // 组合
        $sum = array_sum($winning_numbers);

        $section = self::getSection($sum); // 总和段位
        $result[] = $section;

        $sumOddEven = self::calculateOddEven($sum); // 总和单双
        $result[] = $sumOddEven;

        $sumSize = self::calculateSumSize($sum);  // 总和大小
        $result[] = $sumSize;
        $sumExtremeSize = self::calculateSumExtremeSize($sum);  // 总和极值
        if($sumExtremeSize){
            $result[] = $sumExtremeSize;
        }
        $sumCao = $sum . '操';  // 总和数字
        $result[] = $sumCao;
        $sumCombo = $sumSize. $sumOddEven;  // 总和大小单双组合
        $result[] = $sumCombo;

        $sumBaoZi = self::isBaoZi($winning_numbers[0], $winning_numbers[1], $winning_numbers[2]); // 豹子
        if($sumBaoZi){
            $result[] = $sumBaoZi;
        }
        $sumPair = self::isPair($winning_numbers[0], $winning_numbers[1], $winning_numbers[2]); // 对子
        if($sumPair){
            $result[] = $sumPair;
        }

        $sumStraight = self::isStraight($winning_numbers[0], $winning_numbers[1], $winning_numbers[2]); // 顺子
        if($sumStraight){
            $result[] = $sumStraight;
        }

        $tail = self::getLastDigit($sum); // 总和尾数
        $result[] = $tail . '尾'; // 尾数

        $tailOddEven = self::calculateOddEven($tail); // 尾数单双
        $result[] = '尾'.$tailOddEven;

        $tailSize = self::calculateOneSize($tail); // 尾数大小
        $result[] = '尾'.$tailSize;

        $tailCombo = '尾'.$tailSize . $tailOddEven; // 尾数大小单双组合
        $result[] = $tailCombo;

        $numA = $winning_numbers[0];    // A球
        $result[] = $numA.'A';

        $numAOddEven = self::calculateOddEven($numA); // A球单双
        $result[] = 'A'.$numAOddEven;

        $numASize = self::calculateOneSize($numA); // A球大小
        $result[] = 'A'.$numASize;

        $result[] = 'A'.$numASize.$numAOddEven; // A球大小单双组合


        $numB = $winning_numbers[1];    // B球
        $result[] = $numB.'B';

        $numBOddEven = self::calculateOddEven($numB); // B球
        $result[] = 'B'.$numBOddEven;
        $numBSize = self::calculateOneSize($numB); // B球大小
        $result[] = 'B'.$numBSize;

        $result[] = 'B'.$numBSize.$numBOddEven; // B球大小单双组合

        $numC = $winning_numbers[2];
        $result[] = $numC.'C';
        $numCOddEven = self::calculateOddEven($numC); // C球单双
        $result[] = 'C'.$numCOddEven;
        $numCSize = self::calculateOneSize($numC); // C球大小
        $result[] = 'C'.$numCSize;

        $result[] = 'C'.$numCSize.$numCOddEven; // C球大小单双组合


        return $result;
    }


    /**
     * @description: 算单双
     * @param {*} $number
     * @return {*}
     */    
    public static function calculateOddEven($number)
    {
        if ($number & 1) {
            return GameplayRuleEnum::SINGLE;
        } else {
            return GameplayRuleEnum::DOUBLE;
        }
    }

    /**
     * @description: 总和大小
     * @param {*} $number
     * @return {*}
     */    
    public static function calculateSumSize($number)
    {
        if($number >= GameplayRuleEnum::SUM_BIG) {
            return GameplayRuleEnum::BIG;
        }

        if($number <= GameplayRuleEnum::SUM_SMALL){
            return GameplayRuleEnum::SMALL;
        }
    }

    /**
     * @description: 总和极值
     * @param {*} $number
     * @return {*}
     */    
    public static function calculateSumExtremeSize($number)
    {
        $result = '';
        if($number >= GameplayRuleEnum::SUM_EXTREME_BIG) {
            $result = GameplayRuleEnum::EXTREME_BIG;
        }

        if($number <= GameplayRuleEnum::SUM_EXTREME_SMALL){
            $result = GameplayRuleEnum::EXTREME_SMALL;
        }

        return $result;
    }

    /**
     * @description: 豹子
     * @param {int} $a
     * @param {int} $b
     * @param {int} $c
     * @return {*}
     */    
    public static function isBaoZi(int $a, int $b, int $c)
    {
        $result = '';
        if($a === $b && $b === $c){
            $result = GameplayRuleEnum::BAO_ZI;
        }

        return $result;
    }

    /**
     * @description: 对子
     * @param {int} $a
     * @param {int} $b
     * @param {int} $c
     * @return {*}
     */
    public static function isPair($a, $b, $c) {
        $result = '';
        // 确保输入都是个位数
        if (!is_numeric($a) || !is_numeric($b) || !is_numeric($c) ||
            $a < 0 || $a > 9 || $b < 0 || $b > 9 || $c < 0 || $c > 9) {
            return ''; // 或者抛出异常
        }
        
        if(($a == $b && $a != $c) || 
            ($a == $c && $a != $b) || 
            ($b == $c && $b != $a)){
            $result = GameplayRuleEnum::PAIRS;
        }
        // 判断是否为对子情况
        return $result;
    }

    /**
     * @description: 顺子
     * @param {int} $a
     * @param {int} $b
     * @param {int} $c
     * @return {*}
     */
    public static function isStraight($a, $b, $c) {
        $result = '';
        // 确保输入都是个位数（0-9）
        if (!is_numeric($a) || !is_numeric($b) || !is_numeric($c) ||
            $a < 0 || $a > 9 || $b < 0 || $b > 9 || $c < 0 || $c > 9) {
            return '';
        }
    
        // 去重（顺子必须三个不同数字）
        if ($a == $b || $a == $c || $b == $c) {
            return '';
        }
    
        // 检查是否是完全升序或完全降序的连续数字
        $numbers = [$a, $b, $c];
        sort($numbers); // 排序后检查是否是 x, x+1, x+2
        list($x, $y, $z) = $numbers;
    
        // 情况1：升序连续（1,2,3）
        $isAscending = ($x + 1 == $y) && ($y + 1 == $z);
    
        // 情况2：降序连续（3,2,1）
        $isDescending = ($z + 1 == $y) && ($y + 1 == $x);
        if($isAscending || $isDescending){
            $result = GameplayRuleEnum::STRAIGHT;
        }
        return $result;
    }
    
    /**
     * 获取数字的尾数
     * @param int $number 输入数字
     * @return int 尾数
     */
    public static function getLastDigit($number) {
        // 确保输入是整数
        $number = (int)$number;
        // 取绝对值，处理负数情况
        $number = abs($number);
        // 取模10得到尾数
        return $number % 10;
    }


    /**
     * @description: 尾大小
     * @param {*} $number
     * @return {*}
     */    
    public static function calculateOneSize($number)
    {
        if($number >= GameplayRuleEnum::ONE_BIG) {
            return GameplayRuleEnum::BIG;
        }

        if($number <= GameplayRuleEnum::ONE_SMALL){
            return GameplayRuleEnum::SMALL;
        }
    }

    /**
     * @description: 获取段位
     * @param {*} $number
     * @return {*}
     */
    public static function getSection($number) {
        $result = '';
        if ($number >= GameplayRuleEnum::SECTION_1[0] && $number <= GameplayRuleEnum::SECTION_1[1]) {
            $result = GameplayRuleEnum::ONE;
        } elseif ($number >= GameplayRuleEnum::SECTION_2[0] && $number <= GameplayRuleEnum::SECTION_2[1]) {
            $result = GameplayRuleEnum::TWO;
        } elseif ($number >= GameplayRuleEnum::SECTION_3[0] && $number <= GameplayRuleEnum::SECTION_3[1]) {
            $result = GameplayRuleEnum::THREE;
        } elseif ($number >= GameplayRuleEnum::SECTION_4[0] && $number <= GameplayRuleEnum::SECTION_4[1]) {
            $result = GameplayRuleEnum::FOUR;
        }
        return $result; // 不在任何段中
    }

    /**
     * @description: 近期开奖记录
     * @return {*}
     */    
    public static function currentLotteryResults($memberId)
    {
        // $result = self::model()::where('status', self::model()::STATUS_DRAW)->orderBy('id','desc')->take(16)->get();
        // $text = "📅 近期开奖记录\n";
        // $text .= "====================\n";
        // if($result){
        //     foreach($result as $k => $v){


        //         $winArr = explode(',',$v->winning_numbers);

        //         // 组合
        //         $sum = array_sum($winArr);

        //         $combo = [];

        //         $sumOddEven = self::calculateOddEven($sum); // 总和单双

        //         $sumSize = self::calculateSumSize($sum);  // 总和大小

        //         $sumExtremeSize = self::calculateSumExtremeSize($sum);  // 总和极值
        //         if(empty($sumExtremeSize)){
        //             $sumExtremeSize = "-";
        //         }
             

        //         $tail = self::getLastDigit($sum); // 总和尾数
        //         if($tail == 0){
        //             $tail = '-'; // 尾数
        //         }else{
        //             $tail = '尾'.$tail; // 尾数
        //         }
                


        //         $text .= "回合：{$v->issue_no}期 \n";
        //         $text .= "结果：".implode('+',explode(',',$v->winning_numbers))."=".array_sum(explode(',',$v->winning_numbers))." \n";
        //         $text .= "组合：{$sumSize} {$sumOddEven} \n";
        //         $text .= "极值：{$sumExtremeSize} \n";
        //         $text .= "尾数：{$tail} \n";
        //         $text .= "---------------------------\n";
        //     }
        //     self::telegram()->sendMessage([
        //             'chat_id' => $memberId,
        //             'text' => $text,
        //         ]);
        // }else{
        //     self::telegram()->sendMessage([
        //             'chat_id' => $memberId,
        //             'text' => "暂无开奖记录",
        //         ]);
        // }
        $result = self::model()::where('status', self::model()::STATUS_DRAW)->orderBy('id','desc')->first();
        if($result){
            if($result->image){
                self::telegram()->sendPhoto([
                    'chat_id' => $memberId,
                    'photo' => InputFile::create(url($result->image)),
                ]);
            }else{
                // if($result->combo){
                //     self::telegram()->sendMessage([
                //         'chat_id' => $memberId,
                //         'text' => "",
                //     ]);
                // }else{
                    self::telegram()->sendMessage([
                        'chat_id' => $memberId,
                        'text' => "暂无开奖记录",
                    ]);
                // }
                
            }
            
        }
    }

    // 获取最新的开奖数据
    public static function getLatestIssue()
    {
        $url = "https://ydpc28.co/api/pc28/list";
        $result = file_get_contents($url);
        $result = json_decode($result,true);
        if($result['errorCode'] != 0){
            return ['code'=>self::NOT, 'msg'=>'获取最新期号失败'];

        }
        $nextDrawInfo = $result['data']['nextDrawInfo'];
        $startTime = $nextDrawInfo['currentBJTime'];
        // if($nextDrawInfo['nextDrawTime'] >= date('H:i:s')) {
        //     $endTime = date('Y-m-d').' '.$nextDrawInfo['nextDrawTime']; // 下一期的截止时间
        // }else{
        //     $endTime = date('Y-m-d',strtotime('+1 day')).' '.$nextDrawInfo['nextDrawTime']; // 下一期的截止时间
        // }

        $endTime = date('Y-m-d H:i:s',strtotime($startTime) + 210);
        

        $list = $result['data']['list'];
        $listKey = [];
        foreach($list as $k => $v){
            $listKey[$v['lotNumber']] = $v;
        }

        $oldList = self::findAll(['status' => self::model()::STATUS_CLOSE]);    // 获取所有封盘的期号
        foreach($oldList as $k => $v){
            if(isset($listKey[$v->issue_no])){
                $issue = $listKey[$v->issue_no];
                $winning_numbers = implode(',', str_split((string)$issue['openCode']));

                $winArr = array_map('intval',explode(',',$winning_numbers));

                // 组合
                $sum = array_sum($winArr);

                $combo = [];

                $sumOddEven = self::calculateOddEven($sum); // 总和单双
                $combo[] = $sumOddEven;

                $sumSize = self::calculateSumSize($sum);  // 总和大小
                $combo[] = $sumSize;

                $sumExtremeSize = self::calculateSumExtremeSize($sum);  // 总和极值
                if($sumExtremeSize){
                    $combo[] = $sumExtremeSize;
                }
        

                $sumBaoZi = self::isBaoZi($winArr[0], $winArr[1], $winArr[2]); // 豹子
                if($sumBaoZi){
                    $combo[] = $sumBaoZi;
                }
                $sumPair = self::isPair($winArr[0], $winArr[1], $winArr[2]); // 对子
                if($sumPair){
                    $combo[] = $sumPair;
                }

                $sumStraight = self::isStraight($winArr[0], $winArr[1], $winArr[2]); // 顺子
                if($sumStraight){
                    $combo[] = $sumStraight;
                }

                $tail = self::getLastDigit($sum); // 总和尾数
                if($tail == 0 || $tail == 9){
                    
                }else{
                     $combo[] = '尾'.$tail; // 尾数
                }
               

                $combo = implode(' ', $combo);
                self::lotteryDraw($v->id, $winning_numbers, $combo,'');
            }
        }

        sleep(3); // 等待开奖完成

        $latestIssue = $list[0];    // 最后开奖
        
        $new_issue_no = $latestIssue['lotNumber'] + 1;  // 新期号

        $newInfo = self::findOne(['issue_no' => $new_issue_no]);   // 找新的期号
        
        // 不存在
        if(!$newInfo){

            $res = self::submit([
                'issue_no' => $new_issue_no,
                'status' => self::model()::STATUS_DRAFT,
                'start_time' => $startTime,
                'end_time' => $endTime,
            ]);

            $id = $res['key']??0;
            if($id){
                self::betting($id); // 开始下注
            }
            Cache::set('new_issue_no',$new_issue_no, 10); // 缓存
        }


        
        return $result;
    }

    // 封盘倒数
    public static function syncCountdownIssue()
    {
        $now_date = date('Y-m-d H:i:s',time() + 50); // 提前50秒
        $info = self::model()::where('status', self::model()::STATUS_BETTING)->orderBy('end_time','asc')->first();
        if($info){
            if($info['end_time'] < $now_date){
                $replyInfo = KeyboardService::findOne(['button' => '封盘倒数']);
                if($replyInfo){
                    
                    $text = $replyInfo->reply;
                    $buttons = json_decode($replyInfo->buttons,true);
                    $image = $replyInfo->image;
                    if($image){
                        $image = url($image);
                    }
                    if(Cache::has('issue_countdown_'.$info->id)){
                        
                    }else{
                        self::bettingGroupNotice($text, $buttons, $image);
                        Cache::put('issue_countdown_'.$info->id, true, 60); // 缓存50秒，防止多次发送
                    }
                    
                }
            }
        }
        
        
    }

    // 停止下注
    public static function syncCloseIssue()
    {
        $now_date = date('Y-m-d H:i:s',time() + 30); // 提前30秒
        $list = self::findAll(['status' => self::model()::STATUS_BETTING]);

        foreach($list as $k => $v){
            if($v['end_time'] < $now_date){
                self::closeBetting($v->id);
            }
        }
    }

    // 生成开奖图片
    public static function lotteryImage($issue_no)
    {
        $list = self::model()::where('issue_no','<=',$issue_no)->where(self::getWhere(['status' => self::model()::STATUS_DRAW]))->orderBy('issue_no','desc')->take(20)->get();
        $records = $list->toArray();

        foreach($records as $k => $v){
            $winning_numbers = explode(',',$v['winning_numbers']);
            $v['winning_numbers'] = $winning_numbers;

            // 组合
            $sum = array_sum($winning_numbers);

            $v['sum'] = $sum;
            $sumOddEven = self::calculateOddEven($sum); // 总和单双

            $sumSize = self::calculateSumSize($sum);  // 总和大小
            $v['combo'] = $sumSize . ' ' . $sumOddEven;

            $sumExtremeSize = self::calculateSumExtremeSize($sum);  // 总和极值
            if(!$sumExtremeSize){
                $sumExtremeSize = '-';
            }
            $v['extreme'] = $sumExtremeSize;

            $tail = self::getLastDigit($sum); // 总和尾数
            if($tail === 0 || $tail === 9){
                $tailStr = '-';
            }else{
                $tailStr = '尾' . $tail;
            }
            $v['tail'] = $tailStr;

            $records[$k] = $v;
        }
        $service = new LotteryImageService();
        $url = $service->generate($records);

        self::model()::where('issue_no', $issue_no)->update(['image' => $url]);
        return $url;

    }
}