54 lines
8.2 KiB
Plaintext
54 lines
8.2 KiB
Plaintext
-- 0108 小程序访问数据统计
|
|
SELECT * FROM t_applet_page_visit; -- 小程序日页面访问记录
|
|
SELECT * from t_applet_visit_static; -- 小程序日访问来源记录
|
|
SELECT * from t_applet_visit; -- 小程序日基础指标
|
|
|
|
INSERT INTO `sys_job`( `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '访问页面。目前只提供按 page_visit_pv 排序的 top200', 'DEFAULT', 'ryTask.getVisitPage', '0 0 1 * * ?', '1', '1', '0', 'admin', '2020-08-27 12:12:39', '', '2020-08-27 12:12:50', '');
|
|
INSERT INTO `sys_job`( `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '获取小程序新增或活跃用户的画像分布数据。新增用户数为时间范围内首次访问小程序的去重用户数，', 'DEFAULT', 'ryTask.getUserPortrait1', '0 0 2 * * ?', '1', '1', '0', 'admin', '2020-08-27 12:12:39', '', '2020-08-27 12:12:50', '');
|
|
|
|
INSERT INTO `sys_job`( `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '获取小程序新增或活跃用户的画像分布数据。活跃用户数为时间范围内访问过小程序的去重用户数', 'DEFAULT', 'ryTask.getUserPortrait2', '0 0 3 * * ?', '1', '1', '0', 'admin', '2020-08-27 12:12:39', '', '2020-08-27 12:12:50', '');
|
|
|
|
INSERT INTO `sys_job`( `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '获取用户访问小程序日留存', 'DEFAULT', 'ryTask.getDailyRetain', '0 0 2 * * ?', '1', '1', '0', 'admin', '2020-08-27 12:12:39', '', '2020-08-27 12:12:50', '');
|
|
|
|
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2365, '访问记录', 2371, 1, 'TAppletVisit', 'sms/TAppletVisit/index', 1, 'C', '0', '0', 'sms:TAppletVisit:list', '#', 'admin', '2018-03-01 00:00:00', 'ry', '2018-03-01 00:00:00', '【请填写功能名称】菜单');
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2366, '访问记录查询', 2365, 1, '#', '', 1, 'F', '0', '0', 'sms:TAppletVisit:query', 'server', 'admin', '2018-03-01 00:00:00', 'ry', '2018-03-01 00:00:00', '');
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2367, '用户画像', 2371, 1, 'TAppletVisitStatic', 'sms/TAppletVisitStatic/index', 1, 'C', '0', '0', 'sms:TAppletVisitStatic:list', '#', 'admin', '2018-03-01 00:00:00', 'ry', '2018-03-01 00:00:00', '【请填写功能名称】菜单');
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2368, '用户画像查询', 2367, 1, '#', '', 1, 'F', '0', '0', 'sms:TAppletVisitStatic:query', 'server', 'admin', '2018-03-01 00:00:00', 'ry', '2018-03-01 00:00:00', '');
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2369, '页面记录', 2371, 1, 'TAppletPageVisit', 'sms/TAppletPageVisit/index', 1, 'C', '0', '0', 'sms:TAppletPageVisit:list', '#', 'admin', '2018-03-01 00:00:00', 'ry', '2018-03-01 00:00:00', '【请填写功能名称】菜单');
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2370, '页面记录查询', 2369, 1, '#', '', 1, 'F', '0', '0', 'sms:TAppletPageVisit:query', 'server', 'admin', '2018-03-01 00:00:00', 'ry', '2018-03-01 00:00:00', '');
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2371, '小程序统计', 2282, 4, 'mallSolve', 'goods/goods/views', 1, 'M', '0', '0', NULL, 'post', 'admin', '2020-07-24 08:56:46', '', NULL, '商城结算');
|
|
|
|
|
|
|
|
|
|
1027
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2347, '结算管理', 2282, 3, 'mallSolve', 'goods/goods/views', 1, 'M', '0', '0', NULL, 'post', 'admin', '2020-07-24 08:56:46', '', NULL, '商城结算');
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2348, '商城结算', 2347, 1, 'mallSolveList', 'store/storebilling/storebillinglist', 1, 'C', '0', '0', 'sms:SmsHomeRecommendSubject:list', 'documentation', 'admin', '2018-03-01 00:00:00', 'ry', '2018-03-01 00:00:00', '商城结算');
|
|
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2349, '结算明细', 2211, 1, 'storebillingrecord', 'store/storebilling/storebillingrecord', 1, 'C', '1', '0', 'storebillingrecord', 'server', 'admin', '2018-03-01 00:00:00', 'ry', '2018-03-01 00:00:00', '结算明细');
|
|
|
|
|
|
-- 1127
|
|
|
|
-- 菜单 SQL
|
|
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
values('视频列表', '2308', '1', 'SmsVideo', 'sms/SmsVideo/index', 1, 'C', '0', '0', 'sms:SmsVideo:list', '#', 'admin', '2018-03-01', 'ry', '2018-03-01', '视频列表菜单');
|
|
|
|
-- 按钮父菜单ID
|
|
SELECT @parentId := LAST_INSERT_ID();
|
|
|
|
-- 按钮 SQL
|
|
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
values('视频列表查询', @parentId, '1', '#', '', 1, 'F', '0', '0', 'sms:SmsVideo:query', 'server', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
|
|
|
|
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
values('视频列表新增', @parentId, '2', '#', '', 1, 'F', '0', '0', 'sms:SmsVideo:add', 'server', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
|
|
|
|
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
values('视频列表修改', @parentId, '3', '#', '', 1, 'F', '0', '0', 'sms:SmsVideo:edit', 'server', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
|
|
|
|
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
values('视频列表删除', @parentId, '4', '#', '', 1, 'F', '0', '0', 'sms:SmsVideo:remove', 'server', 'admin', '2018-03-01', 'ry', '2018-03-01', '');
|
|
|
|
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
|
|
values('视频列表导出', @parentId, '5', '#', '', 1, 'F', '0', '0', 'sms:SmsVideo:export', 'server', 'admin', '2018-03-01', 'ry', '2018-03-01', ''); |