packServer/backend/app/model/subject_plan.js
liufumingren 3030f50cd3 续期改为选套餐下单,支付回调确认后才续期
数据库
- 新增 subject_plans(天数 + 定价):迁移内置三档
  30 天 ¥99 / 180 天 ¥499(推荐,划线 594)/ 365 天 ¥899(最划算,划线 1204)
- subject_orders 增加 plan_id / plan_code / plan_name 快照

后端
- GET /api/web/subject-plans:上架套餐(含 pricePerDay)
- POST /api/web/subjects/:id/orders 改为 { planId }:金额只认套餐价,
  前端传的 amount/days 一律忽略;套餐不存在/下架/未配价格 → 422
- 新增 GET /api/web/subjects/:id/orders/:orderNo(轮询支付状态)、
  POST .../orders/:orderNo/close(关闭待支付订单)
- 下单仍然只建单不动期限;续期只发生在 POST /api/pay/notify(渠道回调)成功之后

前端
- 续期不再 prompt 输入天数:弹窗展示套餐卡片(天数/价格/划线价/角标/折合每天),
  点「生成订单(¥xxx)」→ 显示订单号、金额、状态(待支付)
- 每 2s 轮询订单状态,回调确认后自动刷新主体列表并提示新到期时间;
  待支付时可「关闭订单」,避免留下悬挂单

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-10-21 17:43:18 +08:00

35 lines
1.7 KiB
JavaScript
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

'use strict';
/**
* 续期套餐(subject_plans)
*
* 一行 = 一个可选的续期套餐(天数 + 售价)。续期时前端只传套餐 id,
* 金额由服务端按 `price` 计算,避免被前端篡改。
*
* - `code`:稳定编码(p30 / p180 / p365 …),接口与日志里用
* - `status`:1 上架 0 下架(下架后历史订单不受影响)
* - `sort`:展示顺序(小的在前)
*/
module.exports = (app) => {
const { BIGINT, STRING, TINYINT, INTEGER, DECIMAL, DATE } = app.Sequelize;
const SubjectPlan = app.model.define('subject_plan', {
id: { type: BIGINT.UNSIGNED, primaryKey: true, autoIncrement: true, comment: '主键' },
code: { type: STRING(32), allowNull: false, unique: true, comment: '套餐编码(稳定标识)' },
name: { type: STRING(64), allowNull: false, comment: '套餐名称(展示用)' },
days: { type: INTEGER.UNSIGNED, allowNull: false, comment: '续期天数' },
price: { type: DECIMAL(10, 2), allowNull: false, defaultValue: 0, comment: '售价(元)' },
originalPrice: { type: DECIMAL(10, 2), allowNull: true, comment: '划线原价(可选)' },
tag: { type: STRING(16), allowNull: true, comment: '角标文案(推荐 / 最划算)' },
description: { type: STRING(255), allowNull: true, comment: '副标题说明' },
sort: { type: INTEGER.UNSIGNED, allowNull: false, defaultValue: 0, comment: '排序(小的在前)' },
status: { type: TINYINT.UNSIGNED, allowNull: false, defaultValue: 1, comment: '状态:1上架 0下架' },
}, {
tableName: 'subject_plans',
paranoid: true,
comment: '主体续期套餐表',
});
return SubjectPlan;
};