<?php
// +----------------------------------------------------------------------
// | 康比特
// +----------------------------------------------------------------------
declare (strict_types=1);

namespace app\common\model\user;

use cores\BaseModel;
use think\model\relation\BelongsTo;
use app\common\enum\user\balanceLog\Scene as SceneEnum;
use app\common\library\helper;
use think\facade\Db;

/**
 * 用户余额变动明细模型
 * Class BalanceLog
 * @package app\common\model\user
 */
class BalanceLog extends BaseModel
{
    // 定义表名
    protected $name = 'user_balance_log';

    // 定义主键
    protected $pk = 'log_id';

    protected $updateTime = false;

    /**
     * 关联会员记录表
     * @return BelongsTo
     */
    public function user(): BelongsTo
    {
        $module = self::getCalledModule();
        return $this->belongsTo("app\\{$module}\\model\\User");
    }

    /**
     * 新增记录
     * @param int $scene
     * @param array $data
     * @param array $describeParam
     * @param int|null $storeId
     */
    public static function add(int $scene, array $data, array $describeParam, ?int $storeId = null)
    {
        $model = new static;
        $storeId = $storeId ?: $model::$storeId;
        $payload = array_merge([
            'scene' => $scene,
            'describe' => vsprintf(SceneEnum::data()[$scene]['describe'], $describeParam),
            'store_id' => $storeId,
        ], $data);
        if (!array_key_exists('balance_after', $payload)) {
            $balance = Db::name('user')->where([
                'user_id' => (int)($payload['user_id'] ?? 0),
                'store_id' => $storeId,
                'is_delete' => 0,
            ])->value('balance');
            // balance_after 是新增审计字段，不得因历史异常用户缺失而扩大为资金业务失败。
            // 正常业务写准确余额；无法可靠取得时保留 NULL，交由审计检查处理。
            $payload['balance_after'] = $balance === null
                ? null
                : helper::number2((string)$balance);
        }
        $model->save($payload);
    }
}