Você não pode selecionar mais de 25 tópicos
Os tópicos devem começar com uma letra ou um número, podem incluir traços ('-') e podem ter até 35 caracteres.
97 linhas
5.8 KiB
97 linhas
5.8 KiB
%%%---------------------------------------------------------------------
|
|
%%% 充值相关define定义
|
|
%%%---------------------------------------------------------------------
|
|
|
|
|
|
%% ============================= 商品大类 =============================
|
|
-define(PRODUCT_TYPE_NORMAL, 1). %% 普通充值(含充值返利)
|
|
-define(PRODUCT_TYPE_WELFARE, 2). %% 福利卡
|
|
-define(PRODUCT_TYPE_DAILY_GIFT,3). %% 每日礼包
|
|
-define(PRODUCT_TYPE_GIFT, 4). %% 直购礼包
|
|
-define(PRODUCT_TYPE_FIRST_GIFT,5). %% 首充礼包
|
|
-define(PRODDUCT_TYPE_CONTRACT, 6). %% 契约直购
|
|
|
|
|
|
-define(PRODUCT_TYPE_VERIFY, 99). %% 审核专用
|
|
|
|
|
|
%% ============================= 商品子类 =============================
|
|
|
|
%% 福利卡－－－－－－－－－－－－
|
|
-define(WELFARE_SUBTYPE_QUARTER, 3). %% 季度卡
|
|
-define(WELFARE_SUBTYPE_MONTH, 2). %% 月卡
|
|
-define(WELFARE_SUBTYPE_WEEK, 1). %% 周卡
|
|
-define(QUARTER_MAX, 1). %% 每日最大购买季度卡次数
|
|
-define(MONTH_MAX, 2). %% 每日最大购买月卡次数
|
|
-define(WEEK_MAX, 3). %% 每日最大购买周卡次数
|
|
-define(WELFARE_MONTH_AND_QUARTER_ADD, 6). %% 月卡+季度卡幻魔橙装掉率加成
|
|
-define(WELFARE_QUARTER_ADD, 4). %% 季度卡幻魔橙装掉率加成
|
|
-define(WELFARE_MONTH_ADD, 2). %% 月卡幻魔橙装掉率加成
|
|
-define(PRODUCT_TYPE_SELLSWORDS_RESUPPLY, 5). %% 佣兵补给
|
|
|
|
%% ============================= 返利类型 =============================
|
|
-define(RETURN_TYPE_NO, 0). %% 返利类型：无返利
|
|
-define(RETURN_TYPE_LIFE_FIRST, 1). %% 返利类型：终生首次
|
|
-define(RETURN_TYPE_ACT_FIRST, 2). %% 返利类型：活动时间首次
|
|
|
|
%% ============================= 限购类型 =============================
|
|
-define(PRODUCT_LIMIT_DAILY, 1). %% 日限购
|
|
-define(PRODUCT_LIMIT_WEEK, 2). %% 周限购
|
|
-define(PRODUCT_LIMIT_LIFE, 3). %% 终生限购
|
|
-define(PRODUCT_LIMIT_MONTH, 4). %% 月限购
|
|
|
|
-define(PAY_TOTAL_RECHARGE(RoleId), lists:concat(["recharge_total_gold_", RoleId])).
|
|
%% ===================================================================
|
|
%% 充值后更新同账号的总充值金额-元宝
|
|
-define(sql_acc_charge_update_total,<<"UPDATE acc_share_data SET total_charge = total_charge + ~p WHERE accid=~p and accname = '~s'">>).
|
|
|
|
%% 充值统计-查询总充值金额-元宝
|
|
-define(sql_recharge_get_total, <<"SELECT `total_gold` FROM player_recharge_rfmt WHERE role_id=~p">>).
|
|
%% 充值统计-取出玩家指定期间的充值总额(是人民币)
|
|
-define(sql_get_pay_rmb_sum, <<"SELECT total_money FROM player_recharge_rfmt WHERE role_id=~p">>).
|
|
%% 充值统计-取出统计
|
|
-define(sql_get_recharge_statistic,
|
|
<<"select last_pay_time,total_money,total_gold,recency,frequency,monetary,top from player_recharge_rfmt where role_id=~p">>).
|
|
%% 充值统计-保存充值
|
|
-define(sql_save_recharge_statistic,
|
|
<<"replace into player_recharge_rfmt(role_id,last_pay_time,total_money,total_gold,recency,frequency,monetary,top) values(~p,~p,~p,~p,~p,~p,~p,~p)">>).
|
|
%% 充值统计-取出总充值金额在一定数量以上的玩家
|
|
-define(sql_pay_gold_player_id, <<"SELECT `role_id` FROM player_recharge_rfmt WHERE `total_gold` >= ~p ">>).
|
|
|
|
%% 写入充值订单(只用于秘籍)
|
|
-define(sql_pay_insert_gm, <<"INSERT INTO `charge`(`type`,pay_no,accname,player_id,nickname,product_id,money,gold,ctime,status,lv) VALUES(~p, ~p, '~s', ~p, '~ts', ~p, ~p, ~p, ~p, ~p, ~p)" >>).
|
|
%% 取出充值待处理的记录
|
|
-define(sql_pay_fetch_all, <<"SELECT `id`, `player_id`, `ctime` FROM `charge` WHERE `status`=0">>).
|
|
%% 更新充值待处理的记录的状态为已处理
|
|
-define(sql_pay_update_recharge, <<"UPDATE `charge` SET `status`=1 WHERE id=~p AND `status`=0">>).
|
|
%% 取出指定玩家所有待处理的充值记录
|
|
-define(sql_pay_fetch_all_of_user, <<"SELECT `id`, `type`, `product_id`, `money`, `gold`, `ctime`, `pay_no` FROM `charge` WHERE `player_id`=~p AND `status`=0 ORDER BY `id`">>).
|
|
%% 取出一定时间内玩家的充值总额
|
|
-define(sql_pay_task_get_gold, <<"SELECT SUM(gold) FROM recharge_log WHERE player_id=~p AND time >= ~p AND time < ~p">>).
|
|
|
|
%% 取出指定时间范围，充值玩家的充值额
|
|
-define(SQL_SELECT_PAY_ROLES_GOLD, <<"SELECT player_id,SUM(gold) FROM recharge_log WHERE time >= ~p AND time < ~p GROUP BY player_id">>).
|
|
%% 取出指定时间范围，充值玩家的id列表
|
|
-define(SQL_SELECT_PAY_ROLE_IDS, <<"SELECT DISTINCT player_id FROM recharge_log WHERE time >= ~p AND time < ~p">>).
|
|
|
|
%% 取出充值元宝道具使用总额
|
|
-define(sql_gold_goods_total, <<"SELECT SUM(gold) FROM recharge_log WHERE `player_id`=~p AND `type`=2 AND time >= ~p AND time < ~p">>).
|
|
%% 根据充值日志取出最后充值时间
|
|
-define(sql_get_last_pay_time, <<"SELECT `time` FROM `recharge_log` WHERE `player_id`=~p ORDER BY `time` DESC LIMIT 1">>).
|
|
|
|
%% 更新玩家最后充值时间
|
|
-define(sql_update_last_pay_time, <<"update player_login set last_pay_time=~p where id=~p">>).
|
|
|
|
%% 插入充值日志（根据charge的记录插入，以及元宝卡）
|
|
-define(sql_insert_recharge_log,
|
|
<<"insert into `recharge_log`(`accid`, `accname`, `player_id`, `type`, `product_id`, `money`, `gold`, `time`) values(~p, '~s', ~p, ~p, ~p, ~p, ~p, ~p)">>).
|
|
|
|
-define(sql_delete_recharge_log,
|
|
<<"delete from recharge_log where player_id = ~p and `id` = ~p">>).
|
|
|
|
%% 获得充值数据 - 最大取一千条记录
|
|
-define(sql_get_recharge_list,
|
|
<<"SELECT `time`, `type`, `money`, `gold` FROM `recharge_log` WHERE `accid`=~p AND `accname`='~s' AND `player_id`=~p AND `time`>=~p order by `time` desc limit 1000">>).
|
|
|
|
-define(sql_get_recharge_list_by_player_id,
|
|
<<"SELECT `time`, `type`, `money`, `gold` FROM `recharge_log` WHERE `player_id`=~p AND `time`>=~p order by `time` desc limit 1000">>).
|