owl-admin/doc/系统设计/数据库设计/物理模型/分析后台设计增加/32充值设置.sql

-- Active: xiaoding_test@@192.168.110.85@3306@xiaoding_test



SELECT 
    rr.area /* 区域 */,
    rr.recharge_role /* 充值角色 */,
    rr.recharge_type /* 充值类型 */,
    rr.actual_amount /* 实际充值金额 */,
    rr.bonus_amount /* 赠送金额 */,
    rr.bonus_points /* 赠送积分 */,
    rr.bonus_item_name /* 赠送项目名称 */,
    rr.bonus_item_quantity /* 赠送项目数量 */
FROM 
    recharge_record rr /* 充值记录表 */
WHERE 
    rr.create_time >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)
ORDER BY 
    rr.create_time DESC;