独角数卡自动发卡系统增加个人中心显示财务明细的修改教程

CREATE TABLE `balance_records` (
  `id` BIGINT(20) UNSIGNED AUTO_INCREMENT PRIMARY KEY COMMENT '记录ID',
  `user_id` BIGINT(20) UNSIGNED NOT NULL COMMENT '用户ID',
  `order_id` BIGINT(20) UNSIGNED NOT NULL COMMENT '订单ID',
  `order_sn` VARCHAR(150) NOT NULL COMMENT '订单号',
  `title` VARCHAR(200) NOT NULL COMMENT '订单标题',
  `balance_before` DECIMAL(10,2) NOT NULL DEFAULT 0.00 COMMENT '变动前余额',
  `balance_after` DECIMAL(10,2) NOT NULL DEFAULT 0.00 COMMENT '变动后余额',
  `amount` DECIMAL(10,2) NOT NULL DEFAULT 0.00 COMMENT '变动金额',
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

管理员增加减少余额
/app/Admin/Forms/BalanceForm.php

用户消费扣除余额
/app/Http/Controllers/Pay/WalletController.php

用户自助充值
/app/Service/OrderProcessService.php

用户界面显示余额
/app/Http/Controllers/Home/UserController.php
/resources/views//hyper/static_pages/user.blade.php