bot-28/app/Services/BalanceLogService.php

<?php

namespace App\Services;

use App\Models\BalanceLog;

// 余额额变动记录
class BalanceLogService extends BaseService
{

    public static $RW = ['充值','提现','人工充值','人工扣款','三方提现','三方充值','资产转移','比比返','投注','回水'];
    public static $MODEL= BalanceLog::class;



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

        return $where;
    }

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

    /**
     * @description: 查询所有数据
     * @param array $search
     * @return \Illuminate\Database\Eloquent\Collection
     */
    public static function findAll(array $search = [])
    {
        return static::model()::where(static::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 = static::model()::where(static::getWhere($search))
            ->when(isset($search['change_types']) && !empty($search['change_types']), function ($query) use ($search) {
                return $query->whereIn('change_type', $search['change_types']);
            })
            ->orderBy('updated_at', 'desc')
            ->paginate($limit);
        return ['total' => $paginator->total(), 'data' => $paginator->items()];
    }

    /**
     * @description: 生成资金变动日志
     * @param {*} $memberId
     * @param {*} $amount
     * @param {*} $before_balance
     * @param {*} $after_balance
     * @param {*} $change_type
     * @param {*} $related_id
     * @param {*} $remark
     * @return {*}
     */
    public static function addLog($memberId, $amount, $before_balance, $after_balance, $change_type, $related_id, $remark, $room_id = null)
    {
        $data = [];
        $data['member_id'] = $memberId;
        $data['amount'] = $amount;
        $data['before_balance'] = $before_balance;
        $data['after_balance'] = $after_balance;
        $data['change_type'] = $change_type;
        $data['related_id'] = $related_id;
        $data['remark'] = $remark;
        if ($room_id) $data['room_id'] = $room_id;
        return static::model()::create($data);
    }

    /**
     * @description: 获取今日流水
     * @param int $memberId
     * @param string|null $date
     * @return {*}
     */
    public static function getTodayFlowing($memberId, $date = null)
    {
        if (!$date) {
            $date = date('Y-m-d');
        }
        $startTime = date('Y-m-d H:i:s', strtotime($date . ' 00:00:00'));
        $endTime = date('Y-m-d H:i:s', strtotime($date . ' 23:59:59'));


        $flow = static::model()::where('member_id', $memberId)
            ->whereBetween('created_at', [$startTime, $endTime])
            ->where('change_type', '投注')
            ->sum('amount');
        $refund = static::model()::where('member_id', $memberId)
            ->whereBetween('created_at', [$startTime, $endTime])
            ->where('change_type', '返水')
            ->sum('amount');

        $profit = static::model()::where('member_id', $memberId)
            ->whereBetween('created_at', [$startTime, $endTime])
            ->where('change_type', '中奖') //嬴正数 输负数
            ->sum('amount');

        $walletInfo = WalletService::model()::where('member_id', $memberId)->first();
        $text = '';
        $text .= "当日流水: " . number_format((0-$flow), 2) . "\n";
        $text .= "返水额度: " . number_format($refund, 2) . "\n";
        $text .= "当日盈亏: " . number_format(($profit + $refund + $flow), 2) . "\n";
        $text .= "余额: " . number_format($walletInfo['available_balance'], 2) . "\n";
        return [
            'chat_id' => $memberId,
            'text' => $text
        ];
    }

    public static function getFlowingHistory($memberId, $messageId = null, $page = 1, $limit = 5)
    {
        $dateTime = date('Y-m-d 00:00:00');
        $list = [];
        for ($i = 0; $i < $limit; $i++) {
            $newIndex = ($page - 1) * $limit + $i;
            $date = date('Y-m-d', strtotime($dateTime . " -{$newIndex} day"));
            $startTime = date('Y-m-d H:i:s', strtotime($date . ' 00:00:00'));
            $endTime = date('Y-m-d H:i:s', strtotime($date . ' 23:59:59'));


            $flow = static::model()::where('member_id', $memberId)
                ->whereBetween('created_at', [$startTime, $endTime])
                ->where('change_type', '投注')
                ->sum('amount');
            $refund = static::model()::where('member_id', $memberId)
                ->whereBetween('created_at', [$startTime, $endTime])
                ->where('change_type', '返水')
                ->sum('amount');

            $profit = static::model()::where('member_id', $memberId)
                ->whereBetween('created_at', [$startTime, $endTime])
                ->where('change_type', '中奖') //嬴正数 输负数
                ->sum('amount');

            $list[] = [
                'date' => $date,
                'flow' => number_format($flow, 2),
                'refund' => number_format($refund, 2),
                'profit' => number_format(($profit + $refund + $flow), 2)
            ];
        }
        // $startTime = date('Y-m-d H:i:s',strtotime($date . ' 00:00:00'));
        // $endTime = date('Y-m-d H:i:s',strtotime($date . ' 23:59:59'));


        // $list = static::model()::where('member_id', $memberId)
        //     ->whereBetween('created_at', [$startTime, $endTime])
        //     ->orderBy('created_at', 'desc')
        //     ->get();

        $text = lang("流水历史")." \n";
        foreach ($list as $item) {
            $text .= "---------------------\n";
            $text .= lang("日期")."： {$item['date']} \n";
            $text .= lang("流水")."： {$item['flow']} \n";
            $text .= lang("返水")."： {$item['refund']} \n";
            $text .= lang("盈利")."： {$item['profit']} \n";
        }

        $keyboard = [[
            ['text' => "👇".lang("下一页"), 'callback_data' => "FlowingHistoryPage@@" . ($page + 1)]
        ]];
        if ($page > 1) {
            array_unshift($keyboard[0], ['text' => "👆".lang("上一页"), 'callback_data' => "FlowingHistoryPage@@" . ($page - 1)]);
        }
        return [
            'chat_id' => $memberId,
            'text' => $text,
            'message_id' => $messageId,
            'reply_markup' => json_encode(['inline_keyboard' => $keyboard]),
        ];
    }

}