%%-----------------------------------------------------------------------------
%% @Module  :       lucky_flop
%% @Author  :       WJQ
%% @Created :       2019-07-17
%% @Description:    幸运翻牌
%%-----------------------------------------------------------------------------

-define(NOT_GET,    0).     %% 未抽取
-define(HAS_GET,    1).     %% 已抽取

%% 玩家幸运翻牌数据
-record(lucky_flop, {
    data_map = #{}          %% #{SubType => #lucky_flop_data{}}
}).

%% 单个子类型数据
-record(lucky_flop_data, {
    sub_type        = 0,            %% 活动子类型
    now_times       = 0,            %% 当前抽奖次数
    total_times     = 0,            %% 累计抽奖次数
    turn            = 0,            %% 当前抽奖轮数
    draw_rewards    = [],           %% 奖池列表[{奖励档次,是否已获取},...]
    receive_rewards = [],           %% 已领取累计奖励列表[奖励档次,...]
    time            = 0             %% 更新时间
}).

-define(SELECT_LUCKY_FLOP,
    <<"SELECT `sub_type`, `now_times`, `total_times`, `turn`, `draw_rewards`, `receive_rewards`, `time`
      FROM `lucky_flop` WHERE `role_id` = ~p ">>).

-define(SELECT_ALL_LUCKY_FLOP,
    <<"SELECT `role_id`, `now_times`, `receive_rewards` FROM `lucky_flop` WHERE `sub_type` = ~p ">>).

-define(REPLACE_LUCKY_FLOP,
    <<"REPLACE `lucky_flop`(`role_id`, `sub_type`, `now_times`, `total_times`, `turn`, `draw_rewards`, `receive_rewards`, `time`)
      VALUES(~p, ~p, ~p, ~p, ~p, '~s', '~s', ~p)">>).

-define(DELETE_LUCKY_FLOP_BY_SUB_TYPE, <<"DELETE FROM `lucky_flop` WHERE `sub_type` = ~p">>).

-define(DELETE_LUCKY_FLOP_ROLE, <<"DELETE FROM `lucky_flop` WHERE `role_id` = ~p AND `sub_type` IN (~s)">>).