You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
64 lines
3.2 KiB
64 lines
3.2 KiB
%% ---------------------------------------------------------
|
|
%% 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">>).
|
|
%%%---------------------------------------------------------------------
|
|
%%% 常量定义
|
|
%%%---------------------------------------------------------------------
|