%% ---------------------------------------------------------
%% Author:  xyao
%% Email:   jiexiaowen@gmail.com
%% Created: 2012-5-4
%% Description: 日 ,周,目标 ets
%% --------------------------------------------------------

-define(WEEK_KEY(CounterType), {mod_week, CounterType}).

-define(DEFAULT_SUB_MODULE, 0).         %% 默认模块子id设为0
-define(DEFAULT_OTHER,     []).         %% 默认other扩展数据

%% 周定时器类型
-define(WEEK_TYPE_ZERO, 0).             %% 以0点为周期的周定时器类型
-define(WEEK_TYPE_FOUR, 4).             %% 以4点为周期的周定时器类型

%% 每天记录
-record(ets_week, {
        id              = {0,0,0},      %% {模块id, 模块子id, 类型}
        count           = 0,            %% 数量
        other           = [],           %% 扩展数据
        refresh_time    = 0             %% 最后修改时间
    }).

-record(base_week, {
		module          = 0,            %% 所属模块id
        sub_module      = 0,            %% 模块子id
        id              = 0,            %% 周常id
        limit           = 0,            %% 上限
        type            = 0,            %% 周定时器类型
        about           =""             %% 描述
    }).

%% 周计数器（0点分界）
-define(SQL_WEEK_ZERO_ROLE_ALL,
        <<"SELECT `module`,`sub_module`,`type`,`count`,`other`,`refresh_time` FROM `counter_week` WHERE role_id=~p">>).
-define(SQL_WEEK_ZERO_ROLE_UPDATE,
        <<"REPLACE INTO `counter_week` (`role_id`,`module`,`sub_module`,`type`,`count`,`other`,`refresh_time`) VALUES (~p, ~p, ~p, ~p, ~p, '~ts', ~p)">>).
-define(SQL_WEEK_ZERO_ROLE_UPDATE_BATCH,
        <<"REPLACE INTO `counter_week` (`role_id`,`module`,`sub_module`,`type`,`count`,`other`,`refresh_time`) VALUES ~ts">>).

-define(SQL_WEEK_ZERO_ROLE_CLEAR,
        <<"delete from `counter_week` where `role_id` = ~p">>).
-define(SQL_WEEK_ZERO_CLEAR,
        <<"DELETE FROM `counter_week` WHERE refresh_time < ~w">>).
-define(SQL_WEEK_ZERO_ROLE,
        <<"SELECT  `count`,`refresh_time`,`other` FROM `counter_week` WHERE role_id=~p and  module = ~p and sub_module = ~p and type = ~p">>).

%% 周计数器（4点分界）
-define(SQL_WEEK_FOUR_ROLE_ALL,
        <<"SELECT `module`,`sub_module`,`type`,`count`,`other`,`refresh_time` FROM `counter_week_four` WHERE role_id=~p">>).
-define(SQL_WEEK_FOUR_ROLE_UPDATE,
        <<"REPLACE INTO `counter_week_four` (`role_id`,`module`,`sub_module`,`type`,`count`,`other`,`refresh_time`) VALUES (~p, ~p, ~p, ~p, ~p, '~ts', ~p)">>).
-define(SQL_WEEK_FOUR_ROLE_UPDATE_BATCH,
        <<"REPLACE INTO `counter_week_four` (`role_id`,`module`,`sub_module`,`type`,`count`,`other`,`refresh_time`) VALUES ~ts">>).
-define(SQL_WEEK_FOUR_ROLE_CLEAR,
        <<"delete from `counter_week_four` where `role_id` = ~p">>).
-define(SQL_WEEK_FOUR_CLEAR,
        <<"DELETE FROM `counter_week_four` WHERE refresh_time < ~w">>).
-define(SQL_WEEK_FOUR_ROLE,
        <<"SELECT  `count`,`refresh_time`,`other` FROM `counter_week_four` WHERE role_id=~p and  module = ~p and sub_module = ~p and type = ~p">>).
%%%---------------------------------------------------------------------
%%% 常量定义
%%%---------------------------------------------------------------------