from sqlalchemy import Column, String, Integer, DateTime, JSON, Enum from datetime import datetime from app.core.database import Base class VasOrder(Base): __tablename__ = "vas_order" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_order` ( `id` VARCHAR(128) NOT NULL, `user_id` VARCHAR(128) NOT NULL, `product_id` INT NOT NULL, `product_name` VARCHAR(100) NULL, `user_name` VARCHAR(100) NULL, `base_amount` INT NOT NULL, `adjustment_delta` INT NOT NULL DEFAULT 0, `final_amount` INT NOT NULL, `base_currency` VARCHAR(10) NOT NULL, `status` ENUM('pending', 'paid', 'completed', 'closed') NOT NULL DEFAULT 'pending', `channel_type` VARCHAR(32) NOT NULL DEFAULT 'direct' COMMENT 'direct:社交自收直客, agency:中介渠道, website:官网公海', `agency_id` VARCHAR(64) NULL COMMENT '中介机构ID', `handler_id` VARCHAR(128) NULL COMMENT '40%销售提成对接人ID', `developer_id` VARCHAR(128) NULL COMMENT '20%技术版权脚本开发者ID', `settlement_status` VARCHAR(32) NOT NULL DEFAULT 'unsettled' COMMENT '结算状态: unsettled, risk_period, eligible, settled', `completed_at` DATETIME NULL, `risk_cleared_at` DATETIME NULL, `settlement_period_id` VARCHAR(32) NULL, `user_inputs` JSON NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), INDEX `idx_vas_order_user_id` (`user_id`), INDEX `idx_vas_order_product_id` (`product_id`), INDEX `idx_vas_order_status` (`status`), INDEX `idx_vas_order_handler_id` (`handler_id`), INDEX `idx_vas_order_settlement_status` (`settlement_status`), INDEX `idx_vas_order_completed_at` (`completed_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='主订单表'; """ id = Column(String(128), primary_key=True) user_id = Column(String(128), nullable=False) product_id = Column(Integer, nullable=False) product_name = Column(String(100)) user_name = Column(String(100)) base_amount = Column(Integer, nullable=False) adjustment_delta = Column(Integer, default=0) # 负数 = 优惠,正数 = 加价 # 订单最终价(冗余字段,方便查询) final_amount = Column(Integer, nullable=False) base_currency = Column(String(10), nullable=False) status = Column( Enum('pending','paid','completed','closed'), default='pending', nullable=False ) # 渠道来源: direct(社交自收直客), agency(中介渠道), website(官网公海) channel_type = Column( String(32), default='direct', nullable=False ) # 中介机构ID (仅中介单时有值) agency_id = Column(String(64), nullable=True) # 40%销售提成对接人 (直客为录单对接人,中介单为该中介拓展人,公海单为NULL) handler_id = Column(String(128), nullable=True, index=True) # 20%技术版权脚本开发者ID developer_id = Column(String(128), nullable=True) # 结算状态: unsettled(未结算), risk_period(风险期冻结), eligible(待结算), settled(已结算) settlement_status = Column( String(32), default='unsettled', nullable=False, index=True ) completed_at = Column(DateTime, nullable=True) risk_cleared_at = Column(DateTime, nullable=True) settlement_period_id = Column(String(32), nullable=True) user_inputs = Column(JSON) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)