Почетна Преглед Помоћ
Регистрација Пријавите се
Amoy2
/
wlyy2.0
Прати 5
Волим 1
Креирај огранак 18
Датотеке Дискусије 0 Захтеви за спајање 0 Вики
Грана: dev
Гране Ознаке
wlyy2.0
/
svr
/
svr-statistics
/
doc
/
sql
/
统计相关表数据备份20171121.txt

统计相关表数据备份20171121.txt 75 KB
Пермалинк Историја Датотека

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192 
  1. CREATE TABLE `wlyy_job_config_new` (
    2. 

  2.   `id` int(10) NOT NULL,
    3. 

  3.   `job_name` varchar(200) DEFAULT NULL COMMENT '任务名称',
    4. 

  4.   `job_info` varchar(200) DEFAULT NULL COMMENT '任务描述',
    5. 

  5.   `job_type` varchar(10) DEFAULT NULL COMMENT '任务类型(0--单次执行  1--周期执行 2--监听任务)',
    6. 

  6.   `job_class` varchar(200) DEFAULT NULL COMMENT '任务执行的class',
    7. 

  7.   `sql` varchar(2000) DEFAULT NULL,
    8. 

  8.   `sql_count` varchar(2000) DEFAULT NULL,
    9. 

  9.   `sql_day` varchar(255) DEFAULT NULL,
    10. 

  10.   `sql_year` varchar(255) DEFAULT NULL,
    11. 

  11.   `cache_key` varchar(255) DEFAULT NULL,
    12. 

  12.   `quartz_cron` varchar(200) DEFAULT NULL COMMENT 'quartz表达式',
    13. 

  13.   `status` varchar(1) DEFAULT NULL COMMENT '1 启动 0停止',
    14. 

  14.   `quota_id` varchar(50) DEFAULT NULL,
    15. 

  15.   `del` varchar(1) DEFAULT NULL COMMENT '1: 正常 0： 删除',
    16. 

  16.   PRIMARY KEY (`id`)
    17. 

  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    18. 

  18. 

  19. CREATE TABLE `wlyy_dimension_quota` (
    20. 

  20.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    21. 

  21.   `quota_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '关联 wlyy_quota code',
    22. 

  22.   `dimension_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '关联 wlyy_dimension',
    23. 

  23.   `dict_sql` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
    24. 

  24.   `convert_clazz` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '数据转换的类',
    25. 

  25.   `sort` int(2) DEFAULT NULL COMMENT '维度顺序',
    26. 

  26.   `key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '查询出来的key',
    27. 

  27.   PRIMARY KEY (`id`)
    28. 

  28. ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    29. 

  29. 

  30. CREATE TABLE `wlyy_dimension` (
    31. 

  31.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键(uuid)',
    32. 

  32.   `code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '业务代码',
    33. 

  33.   `type` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '类型:1 性别 2 年龄 ',
    34. 

  34.   `name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '指标名称',
    35. 

  35.   `status` int(2) DEFAULT NULL COMMENT '1: 正常 0：不可以用 -1 已删除',
    36. 

  36.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
    37. 

  37.   `create_user` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建人',
    38. 

  38.   `create_user_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建人名',
    39. 

  39.   `update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '修改时间',
    40. 

  40.   `update_user` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改人',
    41. 

  41.   `update_user_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改人名',
    42. 

  42.   `remark` varchar(1500) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    43. 

  43.   PRIMARY KEY (`id`)
    44. 

  44. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    45. 

  45. 

  46. 

  47. 

  48. 

  49. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('1', '签约数的已扣费', '签约人数：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.code AS business_id, a.idcard, a.admin_team_code AS team,a.patient FROM wlyy_sign_family a WHERE a.type = 2 AND a. STATUS IN (1, 2)  AND a.expenses_status = 1', 'SELECT COUNT(a.id) FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (1, 2) AND a.expenses_status = 1 ', ' AND a.expenses_time < \'[endTime]\' AND a.expenses_time >= \'[startTime]\' AND a.sign_year = \'[year]\'', ' AND a.expenses_time < \'[endTime]\' AND a.sign_year = \'[year]\'', 'sign_expenses_status_1', '0 0 0 * * ?', '1', '1', '1');
    50. 

  50. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('2', '解约人数', '解约人数：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT CODE AS business_id, hospital AS hospital, admin_team_code AS team FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (-3)', 'SELECT COUNT(id) FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (-3)', 'AND a.apply_unsign_date < \'[endTime]\' AND a.apply_unsign_date >= \'[startTime]\' AND a.sign_year = \'[year]\'', 'AND a.apply_unsign_date < \'[endTime]\' AND a.sign_year = \'[year]\'', NULL, '30 0 0 * * ?', '1', '2', '1');
    51. 

  51. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('3', '健康咨询量', '健康咨询量：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'select admin_team_code team,id business_id from wlyy_consult_team a where   a.type= 2', 'select count(id) from wlyy_consult_team a where   a.type= 2', 'and a.czrq>=\'[startTime]\' and a.czrq< \'[endTime]\'', 'and a.czrq>=\'[startTime]\' and a.czrq< \'[endTime]\'', NULL, '0 1 0 * * ?', '1', '3', '1');
    52. 

  52. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('4', '随访量', '随访量：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT f.id business_id,f.admin_team_code team FROM wlyy_followup f WHERE 1=1 and f.status=1', 'SELECT COUNT(f.id) FROM wlyy_followup f WHERE 1=1  and f.status=1', 'and f.followup_plan_date>=\'[startTime]\'  and f.followup_plan_date<\'[endTime]\'', 'and f.followup_plan_date>=\'[startTime]\'  and f.followup_plan_date<\'[endTime]\'', NULL, '30 1 0 * * ?', '1', '4', '1');
    53. 

  53. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('5', '健康指导', '健康指导：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT phg.id business_id,phg.admin_team_code team FROM wlyy_patient_health_guidance phg  WHERE  1=1', 'SELECT COUNT(phg.id) FROM wlyy_patient_health_guidance phg WHERE 1=1', 'AND phg.create_time >= \'[startTime]\' AND phg.create_time < \'[endTime]\'', 'AND phg.create_time >= \'[startTime]\' AND phg.create_time < \'[endTime]\'', NULL, '0 2 0 * * ?', '1', '5', '1');
    54. 

  54. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('6', '签约患者性别', '签约患者性别:每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.code AS business_id, a.idcard, a.admin_team_code AS team,a.patient FROM wlyy_sign_family a WHERE a.type = 2 AND a. STATUS IN (1, 2)  AND a.expenses_status = 1', 'SELECT COUNT(a.id) FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (1, 2) AND a.expenses_status = 1 ', ' AND a.expenses_time < \'[endTime]\' AND a.expenses_time >= \'[startTime]\' AND a.sign_year = \'[year]\'', ' AND a.expenses_time < \'[endTime]\' AND a.sign_year = \'[year]\'', 'sign_expenses_status_1', '30 2 0 * * ?', '1', '6', '1');
    55. 

  55. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('7', '签约患者分组', '签约患者分组:每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.code AS business_id, a.idcard, a.admin_team_code AS team,a.patient FROM wlyy_sign_family a WHERE a.type = 2 AND a. STATUS IN (1, 2)  AND a.expenses_status = 1', 'SELECT COUNT(a.id) FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (1, 2) AND a.expenses_status = 1 ', ' AND a.expenses_time < \'[endTime]\' AND a.expenses_time >= \'[startTime]\' AND a.sign_year = \'[year]\'', ' AND a.expenses_time < \'[endTime]\' AND a.sign_year = \'[year]\'', 'sign_expenses_status_1', '0 3 0 * * ?', '0', '7', '0');
    56. 

  56. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('8', '签约患者年龄', '签约患者年龄:每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.code AS business_id, a.idcard, a.admin_team_code AS team,a.patient FROM wlyy_sign_family a WHERE a.type = 2 AND a. STATUS IN (1, 2)  AND a.expenses_status = 1', 'SELECT COUNT(a.id) FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (1, 2) AND a.expenses_status = 1 ', ' AND a.expenses_time < \'[endTime]\' AND a.expenses_time >= \'[startTime]\' AND a.sign_year = \'[year]\'', ' AND a.expenses_time < \'[endTime]\' AND a.sign_year = \'[year]\'', 'sign_expenses_status_1', '30 3 0 * * ?', '1', '8', '1');
    57. 

  57. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('9', '待签约人数', '待签约人数：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT * FROM ( SELECT CODE AS business_id, m.team_id AS team, a.patient_apply_date AS patient_apply_date FROM wlyy_sign_family a, wlyy_admin_team_member m WHERE a.type = 2 AND a.STATUS = 0 AND a.doctor = m.doctor_code AND m.available = 1 AND (a.admin_team_code IS NULL OR a.admin_team_code = \"\") UNION ALL SELECT CODE AS business_id, a.admin_team_code AS team, a.patient_apply_date AS patient_apply_date FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS = 0 AND a.admin_team_code IS NOT NULL AND a.admin_team_code != \"\" ) a WHERE 1 = 1', 'SELECT COUNT(business_id) FROM ( SELECT CODE AS business_id, m.team_id AS team, a.patient_apply_date AS patient_apply_date FROM wlyy_sign_family a, wlyy_admin_team_member m WHERE a.type = 2 AND a.STATUS = 0 AND a.doctor = m.doctor_code AND m.available = 1 AND (a.admin_team_code IS NULL OR a.admin_team_code = \"\") UNION ALL SELECT CODE AS business_id, a.admin_team_code AS team, a.patient_apply_date AS patient_apply_date FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS = 0 AND a.admin_team_code IS NOT NULL AND a.admin_team_code != \"\" ) a WHERE 1 = 1', ' And a.patient_apply_date < \'[endTime]\' AND a.patient_apply_date >= \'[startTime]\'', 'And a.patient_apply_date < \'[endTime]\' ', NULL, '0 4 0 * * ?', '1', '9', '1');
    58. 

  58. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('10', '已改签人数', '已改签人数：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT code AS business_id, admin_team_code AS team FROM wlyy_sign_family a WHERE a.type = 2 AND a.status = 100 AND a.expenses_status = 1', 'SELECT COUNT(id) FROM wlyy_sign_family a WHERE a.type = 2 AND a.status = 100 AND a.expenses_status = 1', 'and a.patient_apply_date< \'[endTime]\' and  a.patient_apply_date>= \'[startTime]\' and a.sign_year =\'[year]\' ', 'and a.patient_apply_date< \'[endTime]\'  and a.sign_year =\'[year]\' ', NULL, '30 4 0 * * ?', '1', '10', '1');
    59. 

  59. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('11', '实时任务', '实时任务', '', 'com.yihu.wlyy.statistics.job.business.CurrentMysqlToEsQuotaJob', '', '', '', '', '', '0 0 5,7,9,11,13,15,17,19,21,23 * * ?', '1', '11', '1');
    60. 

  60. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('12', '签约下按年龄分组后再按疾病统计', '签约下按年龄分组后再按疾病统计(2016年需要，2017年后改成服务类型)', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.code AS business_id, a.idcard, a.admin_team_code AS team,a.patient FROM wlyy_sign_family a WHERE a.type = 2 AND a. STATUS IN (1, 2)  AND a.expenses_status = 1', 'SELECT count(id) FROM wlyy_sign_family a WHERE a.type = 2 AND STATUS IN (1, 2) AND a.expenses_status = 1', ' AND a.expenses_time < \'[endTime]\' AND a.expenses_time >= \'[startTime]\' AND a.sign_year = \'[year]\'', ' AND a.expenses_time < \'[endTime]\' AND a.sign_year = \'[year]\'', 'sign_expenses_status_1', '0 5 0 * * ?', '0', '12', '0');
    61. 

  61. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('14', '签约数的未扣费', '签约数的扣费钱情况：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.id AS business_id, a.admin_team_code AS team FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (1, 2) AND a.expenses_status = 0', 'SELECT COUNT(a.id) FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (1, 2) AND a.expenses_status = 0', ' AND a.apply_date < \'[endTime]\' AND a.apply_date >= \'[startTime]\' AND a.sign_year = \'[year]\'', ' AND a.apply_date < \'[endTime]\' AND a.sign_year = \'[year]\'', '', '30 5 0 * * ?', '1', '14', '1');
    62. 

  62. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('15', '签约健康标签服务 ', '健康分布服务：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.code AS business_id, a.idcard, a.admin_team_code AS team,a.patient FROM wlyy_sign_family a WHERE a.type = 2 AND a. STATUS IN (1, 2)  AND a.expenses_status = 1', 'SELECT COUNT(a.id) FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (1, 2) AND a.expenses_status = 1 ', ' AND a.expenses_time < \'[endTime]\' AND a.expenses_time >= \'[startTime]\' AND a.sign_year = \'[year]\'', ' AND a.expenses_time < \'[endTime]\' AND a.sign_year = \'[year]\'', 'sign_expenses_status_1', '0 6 0 * * ?', '1', '15', '1');
    63. 

  63. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('17', '签约年龄疾病统计', '签约年龄疾病统计', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.code AS business_id, a.idcard, a.admin_team_code AS team,a.patient FROM wlyy_sign_family a WHERE a.type = 2 AND a. STATUS IN (1, 2)  AND a.expenses_status = 1', 'SELECT COUNT(a.id) FROM wlyy_sign_family a WHERE a.type = 2 AND a.STATUS IN (1, 2) AND a.expenses_status = 1 ', ' AND a.expenses_time < \'[endTime]\' AND a.expenses_time >= \'[startTime]\' AND a.sign_year = \'[year]\'', ' AND a.expenses_time < \'[endTime]\' AND a.sign_year = \'[year]\'', 'sign_expenses_status_1', '30 6 0 * * ?', '1', '17', '1');
    64. 

  64. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('20', '已经签约患者绑定设备', '已经签约患者绑定设备：每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT pd.id AS business_id, sf.admin_team_code AS team FROM wlyy_patient_device pd, wlyy_sign_family sf WHERE pd.user_idcard = sf.idcard AND sf.type = 2 AND pd.del = 0 AND sf.STATUS IN (1, 2)', 'SELECT count(sf.id) FROM wlyy_patient_device pd, wlyy_sign_family sf WHERE pd.user_idcard = sf.idcard AND sf.type = 2 AND pd.del = 0 AND sf.STATUS IN (1, 2)', ' AND pd.czrq <\'[endTime]\'  AND pd.czrq >=\'[startTime]\' and sf.sign_year =\'[year]\' ', ' AND pd.czrq <\'[endTime]\' and sf.sign_year =\'[year]\' ', NULL, '0 7 0 * * ?', '1', '20', '1');
    65. 

  65. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('21', '已经签约微信关注人数', '已经签约微信关注人数', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT sf.CODE AS business_id, sf.admin_team_code AS team FROM wlyy_patient p, wlyy_sign_family sf WHERE p.idcard = sf.idcard AND sf.type = 2 AND sf.STATUS IN (1, 2)  AND p.openid IS NOT NULL', 'SELECT count(sf.id) FROM wlyy_patient p, wlyy_sign_family sf WHERE p.idcard = sf.idcard AND sf.type = 2 AND sf.STATUS IN (1, 2) AND p.openid IS NOT NULL', 'AND p.openid_time <\'[endTime]\' AND p.openid_time >=\'[startTime]\' and sf.sign_year =\'[year]\'  ', 'AND p.openid_time <\'[endTime]\' and sf.sign_year =\'[year]\'  ', NULL, '30 7 0 * * ?', '1', '21', '1');
    66. 

  66. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('22', '健康咨询量  未回复', '未回复健康咨询量', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'select admin_team_code team,id business_id from wlyy.wlyy_consult_team a where  a.type=2 and EXISTS( SELECT DISTINCT t.id consultId FROM [im].topics t, [im].participants p, [im].doctors d, [im].sessions s  WHERE p.participant_id = d.id AND t.session_id = p.session_id AND t.session_id = s.id AND s.type = 1 AND t. STATUS <> 10 AND t.`reply` = 0 AND t.create_time < \'[endTime]\' AND t.create_time >= \'[startTime]\' AND a.consult=t.id)', 'select count(*) from wlyy.wlyy_consult_team a where  a.type=2 and EXISTS( SELECT DISTINCT t.id consultId FROM [im].topics t, [im].participants p, [im].doctors d, [im].sessions s  WHERE p.participant_id = d.id AND t.session_id = p.session_id AND t.session_id = s.id AND s.type = 1 AND t. STATUS <> 10 AND t.`reply` = 0 AND t.create_time < \'[endTime]\' AND t.create_time >= \'[startTime]\' AND a.consult=t.id)', '', '', '', '0 8 0 * * ?', '1', '22', '1');
    67. 

  67. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('23', '健康咨询量 及时回复', '及时回复的健康咨询量', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', ' select a.admin_team_code team,a.id business_id from wlyy_consult_team a where a.type=2 and EXISTS( SELECT DISTINCT t.id consultId FROM [im].topics t,[im].participants p,[im].doctors d,[im].sessions s WHERE p.participant_id = d.id AND t.session_id = p.session_id AND t.session_id = s.id AND s.business_type = 2 AND t.`reply` = 1 AND TIMESTAMPDIFF(SECOND,t.create_time,t.reply_time) < 86400 AND TIMESTAMPDIFF(SECOND,t.create_time,t.reply_time) > 0 AND t.create_time < \'[endTime]\' AND t.create_time >= \'[startTime]\' AND a.consult=t.id )', ' select count(a.id) business_id from wlyy_consult_team a where a.type=2 and EXISTS( SELECT DISTINCT t.id consultId FROM [im].topics t,[im].participants p,[im].doctors d,[im].sessions s WHERE p.participant_id = d.id AND t.session_id = p.session_id AND t.session_id = s.id AND s.business_type = 2 AND t.`reply` = 1 AND TIMESTAMPDIFF(SECOND,t.create_time,t.reply_time) < 86400 AND TIMESTAMPDIFF(SECOND,t.create_time,t.reply_time) > 0 AND t.create_time < \'[endTime]\' AND t.create_time >= \'[startTime]\' AND a.consult=t.id )', '', '', '', '30 8 0 * * ?', '1', '23', '1');
    68. 

  68. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('24', '健康咨询量 首次回复', '首次回复时间分布数', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.admin_team_code AS team, a.id AS business_id, DATE_FORMAT(t.replyTime, \'%Y-%m-%d %H:%i:%S\') AS slavekey1 FROM wlyy.wlyy_consult_team a, (SELECT DISTINCT t.id AS consultId, t.reply_time AS replyTime FROM [im].topics t, [im].participants p, [im].doctors d, [im].sessions s WHERE p.participant_id = d.id AND t.session_id = p.session_id AND t.session_id = s.id AND s.business_type = 2 AND t.`reply` = 1 AND TIMESTAMPDIFF(SECOND, t.create_time, t.reply_time) < 86400 AND TIMESTAMPDIFF(SECOND, t.create_time, t.reply_time) > 0 AND t.create_time < \'[endTime]\' AND t.create_time >= \'[startTime]\' ) t WHERE a.consult = t.consultId and a.type=2 ', 'SELECT count(a.id ) FROM wlyy.wlyy_consult_team a, (SELECT DISTINCT t.id AS consultId, t.reply_time AS replyTime FROM [im].topics t, [im].participants p, [im].doctors d, [im].sessions s WHERE p.participant_id = d.id AND t.session_id = p.session_id AND t.session_id = s.id AND s.business_type = 2 AND t.`reply` = 1 AND TIMESTAMPDIFF(SECOND, t.create_time, t.reply_time) < 86400 AND TIMESTAMPDIFF(SECOND, t.create_time, t.reply_time) > 0 AND t.create_time < \'[endTime]\' AND t.create_time >= \'[startTime]\' ) t WHERE a.consult = t.consultId and a.type=2 ', '', '', '', '0 9 0 * * ?', '1', '24', '1');
    69. 

  69. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('27', '代预约量', '代预约量', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT w.id business_id,sf.admin_team_code team FROM wlyy_patient_reservation w,wlyy_sign_family sf WHERE w.patient=sf.patient and sf.`status`>0 and w.doctor is not null', 'SELECT count(w.id) FROM wlyy_patient_reservation w,wlyy_sign_family sf WHERE w.patient=sf.patient and sf.`status`>0 and w.doctor is not null', 'and w.czrq>=\'[startTime]\' and w.czrq<\'[endTime]\' and sf.sign_year=\'[year]\'', 'and w.czrq<\'[endTime]\' and sf.sign_year=\'[year]\'', NULL, '30 9 0 * * ?', '1', '27', '1');
    70. 

  70. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('28', '统计平均值', '只执行redis统计 不按照年度统计', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT t.id AS business_id, t.admin_team_code AS team, s.score AS num FROM wlyy_consult_team t, wlyy_evaluate_score s WHERE t.consult = s.consult\r\n', 'SELECT count(t.id) FROM wlyy_consult_team t, wlyy_evaluate_score s WHERE t.consult = s.consult\r\n', 'AND t.czrq >= \'[startTime]\' AND t.czrq < \'[endTime]\'', ' AND t.czrq < \'[endTime]\'', NULL, '0 10 0 * * ?', '1', '28', '1');
    71. 

  71. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('29', '市续签量', '续签量（按照年度全量）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id,fr.admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', ' and fr.apply_date<\'[endTime]\'   and fr.apply_date>=\'[startTime]\'  and fr.sign_year =\'[year]\'  ', ' and fr.apply_date < \'[endTime]\'   and fr.sign_year =\'[year]\'  ', 'renew_city', '30 10 0 * * ?', '1', '29', '1');
    72. 

  72. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('30', '续签团队转签原因(到达量)', '续签原因（按照年度全量）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team, fr.renew_change_reason AS slaveKey1 FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id != fr.old_admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id != fr.old_admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', NULL, '0 11 0 * * ?', '1', '30', '1');
    73. 

  73. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('31', '续签夸团队', '续签夸团队（按照年度全量）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id != fr.old_admin_team_id AND fr.hospital = fr.old_hospital AND LEFT(fr.hospital, 6) = LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id != fr.old_admin_team_id AND fr.hospital = fr.old_hospital AND LEFT(fr.hospital, 6) = LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND	 fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\'  AND  fr.sign_year = \'[year]\'', NULL, '30 11 0 * * ?', '1', '31', '1');
    74. 

  74. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('32', '续签夸社区', '续签夸社区（按照年度全量）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id != fr.old_admin_team_id AND fr.hospital != fr.old_hospital AND LEFT(fr.hospital, 6) = LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id != fr.old_admin_team_id AND fr.hospital != fr.old_hospital AND LEFT(fr.hospital, 6) = LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND	 fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\'  AND fr.sign_year = \'[year]\'', NULL, '0 12 0 * * ?', '1', '32', '1');
    75. 

  75. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('33', '续签夸区', '续签夸区（按照年度全量）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id != fr.old_admin_team_id AND fr.hospital != fr.old_hospital AND LEFT(fr.hospital, 6) != LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id != fr.old_admin_team_id AND fr.hospital != fr.old_hospital AND LEFT(fr.hospital, 6) != LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND	 fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\'  AND  fr.sign_year = \'[year]\'', NULL, '30 12 0 * * ?', '1', '33', '1');
    76. 

  76. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('34', '续签团队签入', '续签签入（按照年度全量）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.admin_team_id AS team FROM wlyy_sign_family_renew_log fr WHERE fr.old_admin_team_id  != fr.admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.old_admin_team_id != fr.admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', NULL, '0 13 0 * * ?', '1', '34', '1');
    77. 

  77. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('35', '续签团队签出', '续签签出（按照年度全量）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE fr.old_admin_team_id != fr.admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.old_admin_team_id != fr.admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_out_team', '30 13 0 * * ?', '1', '35', '1');
    78. 

  78. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('36', '签约服务类型', '每天凌晨1点触发', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT a.code AS business_id, a.idcard, a.admin_team_code AS team,a.patient FROM wlyy_sign_family a WHERE a.type = 2 AND a. STATUS IN (1, 2)  AND a.expenses_status = 1', 'SELECT COUNT(a.id) FROM wlyy_sign_family a, wlyy_sign_patient_label_info spli WHERE a.type = 2 AND a.STATUS IN (1, 2) AND a.expenses_status = 1 AND a.patient = spli.patient AND spli.label_type = \'2\' AND spli.STATUS = \'1\'', ' AND a.expenses_time < \'[endTime]\' AND a.expenses_time >= \'[startTime]\' AND a.sign_year = \'[year]\'', ' AND a.expenses_time < \'[endTime]\' AND a.sign_year = \'[year]\'', 'sign_expenses_status_1', '0 14 0 * * ?', '1', '36', '1');
    79. 

  79. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('38', '续签机构签入', '续签签入（按照年度全量）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.admin_team_id AS team FROM wlyy_sign_family_renew_log fr WHERE fr.hospital != fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.hospital != fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\'  AND fr.sign_year = \'[year]\'', NULL, '30 14 0 * * ?', '1', '38', '1');
    80. 

  80. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('39', '续签机构签出', '续签签出（', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team,fr.patient patient,fr.idcard AS idcard  FROM wlyy_sign_family_renew_log fr WHERE fr.hospital != fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.hospital != fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\'  AND fr.sign_year = \'[year]\'', 'renew_out_hospital', '0 15 0 * * ?', '1', '39', '1');
    81. 

  81. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('40', '续签区签入', '续签签入（按照年度全量）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.admin_team_id AS team FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) != LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) != LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', NULL, '30 15 0 * * ?', '1', '40', '1');
    82. 

  82. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('41', '续签区签出', '续签签出（', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team,fr.patient patient,fr.idcard AS idcard  FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) != LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) != LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_out_town', '0 16 0 * * ?', '1', '41', '1');
    83. 

  83. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('42', '续签团队续签人数(', '团队续签人数(到达量)', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id = fr.old_admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id = fr.old_admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_team', '30 16 0 * * ?', '1', '42', '1');
    84. 

  84. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('43', '续签社区续签人数', '社区续签人数(到达量)', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE fr.hospital = fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.hospital = fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_hospital', '0 17 0 * * ?', '1', '43', '1');
    85. 

  85. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('44', '续签区续签人数', '区续签人数(到达量)', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) = LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) = LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_town', '30 17 0 * * ?', '1', '44', '1');
    86. 

  86. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('49', '已经签约微信关注人数(到达量) 未扣费', '已经签约微信关注人数', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT sf.CODE AS business_id, sf.admin_team_code AS team FROM wlyy_patient p, wlyy_sign_family sf WHERE p.idcard = sf.idcard AND sf.type = 2 AND sf.STATUS IN (1, 2) AND sf.expenses_status != 1 AND p.openid IS NOT NULL', 'SELECT COUNT(sf.id) FROM wlyy_patient p, wlyy_sign_family sf WHERE p.idcard = sf.idcard AND sf.type = 2 AND sf.STATUS IN (1, 2) AND sf.expenses_status != 1 AND p.openid IS NOT NULL', '\r\nAND p.openid_time < \'[endTime]\' AND p.openid_time >= \'[startTime]\' AND sf.sign_year = \'[year]\'', 'AND p.openid_time < \'[endTime]\'  AND sf.sign_year = \'[year]\'', NULL, '0 18 0 * * ?', '1', '49', '1');
    87. 

  87. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('50', '已经签约微信关注人数(到达量) 已扣费', '已经签约微信关注人数', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT sf.CODE AS business_id, sf.admin_team_code AS team FROM wlyy_patient p, wlyy_sign_family sf WHERE p.idcard = sf.idcard AND sf.type = 2 AND sf.STATUS IN (1, 2) AND sf.expenses_status = 1 AND p.openid IS NOT NULL', 'SELECT COUNT(sf.id) FROM wlyy_patient p, wlyy_sign_family sf WHERE p.idcard = sf.idcard AND sf.type = 2 AND sf.STATUS IN (1, 2) AND sf.expenses_status = 1 AND p.openid IS NOT NULL', '\r\nAND p.openid_time < \'[endTime]\' AND p.openid_time >= \'[startTime]\' AND sf.sign_year = \'[year]\'', 'AND p.openid_time < \'[endTime]\'  AND sf.sign_year = \'[year]\'', NULL, '30 18 0 * * ?', '1', '50', '1');
    88. 

  88. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('51', '市级续签量服务类型维度 (到达量)', '续签量服务类型维度 ', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id,fr.admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', ' and fr.apply_date<\'[endTime]\'   and fr.apply_date>=\'[startTime]\'  and fr.sign_year =\'[year]\'  ', ' and fr.apply_date < \'[endTime]\'   and fr.sign_year =\'[year]\'  ', 'renew_city', '0 19 0 * * ?', '1', '51', '1');
    89. 

  89. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('52', '团队续签人数服务类型维度(到达量)', '团队续签人数服务类型维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id = fr.old_admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.admin_team_id = fr.old_admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_team', '30 19 0 * * ?', '1', '52', '1');
    90. 

  90. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('53', '社区续签人数服务类型维度(到达量)', '社区续签人数服务类型维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE fr.hospital = fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.hospital = fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_hospital', '0 20 0 * * ?', '1', '53', '1');
    91. 

  91. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('54', '区续签人数服务类型维度(到达量)', '区续签人数服务类型维度(到达量)', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) = LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) = LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_town', '30 20 0 * * ?', '1', '54', '1');
    92. 

  92. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('55', '统计团队续签迁出人数服务类型维度', '区续签人数服务类型维度(到达量)', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team,fr.patient patient,fr.idcard AS idcard FROM wlyy_sign_family_renew_log fr WHERE fr.old_admin_team_id != fr.admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.old_admin_team_id != fr.admin_team_id AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_out_team', '0 21 0 * * ?', '1', '55', '1');
    93. 

  93. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('56', '统计社区续签迁出人数服务类型维度', '统计社区续签迁出人数服务类型维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team,fr.patient patient,fr.idcard AS idcard  FROM wlyy_sign_family_renew_log fr WHERE fr.hospital != fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE fr.hospital != fr.old_hospital AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\'  AND fr.sign_year = \'[year]\'', 'renew_out_hospital', '30 21 0 * * ?', '1', '56', '1');
    94. 

  94. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('57', '统计区续签迁出人数服务类型维度', '统计区续签迁出人数服务类型维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT fr.id AS business_id, fr.old_admin_team_id AS team,fr.patient patient,fr.idcard AS idcard  FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) != LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'SELECT COUNT(fr.id) FROM wlyy_sign_family_renew_log fr WHERE LEFT(fr.hospital, 6) != LEFT(fr.old_hospital, 6) AND LENGTH(fr.hospital) = 10 AND LENGTH(fr.old_hospital) = 10', 'AND fr.apply_date < \'[endTime]\' AND fr.apply_date >= \'[startTime]\' AND fr.sign_year = \'[year]\'', 'AND fr.apply_date < \'[endTime]\' AND fr.sign_year = \'[year]\'', 'renew_out_town', '0 22 0 * * ?', '1', '57', '1');
    95. 

  95. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('58', '统计长处方总数疾病和状态维度', '统计长处方总数疾病和状态维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT p.code AS prescription_code, p.id AS business_id,p.admin_team_id AS team, p.patient AS patient FROM wlyy_prescription p where 1=1 ', 'SELECT COUNT(p.code) FROM wlyy_prescription p where 1=1 ', 'AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', 'AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '30 22 0 * * ?', '1', '58', '1');
    96. 

  96. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('59', '健康教育人数', '健康教育人数', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT w.admin_team_code AS team,w.id as business_id,w.patient as patient FROM wlyy_health_edu_article_patient w where 1=1 ', 'SELECT COUNT(w.id) FROM wlyy_health_edu_article_patient w where 1=1 ', 'AND w.czrq < \'[endTime]\' AND w.czrq >= \'[startTime]\'', 'AND w.czrq < \'[endTime]\' AND w.czrq >= \'[startTime]\'', 'article_count', '0 23 0 * * ?', '1', '59', '1');
    97. 

  97. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('60', '统计长处方总数年龄和疾病维度', '统计长处方总数年龄和疾病维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT p.code AS prescription_code, p.id AS business_id,p.admin_team_id AS team, p.patient AS patient ,a.idcard AS idcard FROM wlyy_prescription p,wlyy_patient a where p.patient=a.code', 'SELECT COUNT(p.id) FROM wlyy_prescription p,wlyy_patient a where p.patient=a.code', 'AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', 'AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '30 23 0 * * ?', '1', '60', '1');
    98. 

  98. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('61', '统计长处方费用总数疾病维度', '统计长处方费用总数疾病维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT s. code AS prescription_code, p.id AS business_id, s.admin_team_id AS team, s.patient AS patient,p.total_amount AS num FROM wlyy_prescription_pay p, wlyy_prescription s WHERE p.prescription_code = s. CODE and p.trade_status = 1', 'SELECT COUNT(p.id) FROM wlyy_prescription_pay p, wlyy_prescription s WHERE p.prescription_code = s. CODE and p.trade_status = 1', 'AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', 'AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '1 24 0 * * ?', '1', '61', '1');
    99. 

  99. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('62', '统计长处方配送方式和疾病维度', '统计长处方配送方式和疾病维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT p.code AS prescription_code, p.id AS business_id,p.admin_team_id AS team, p.patient AS patient FROM wlyy_prescription p where p.status>=50', 'SELECT COUNT(p.code) FROM wlyy_prescription p where  p.status>=50', 'AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', 'AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '31 24 0 * * ?', '1', '62', '1');
    100. 

  100. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('63', '统计长处方年龄疾病人数(按照患者去重)', '统计长处方疾病人数(按照患者去重)', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT p.patient,t.idcard AS idcard,t.id AS business_id,p.admin_team_id AS team FROM wlyy_prescription p,wlyy_patient t WHERE p.patient = t. CODE AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\' GROUP BY p.patient', 'SELECT count(DISTINCT p.patient) FROM wlyy_prescription p,wlyy_patient t WHERE p.patient = t. CODE AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '', 'prescription_patient_age', '1 25 0 * * ?', '1', '63', '1');
    101. 

  101. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('64', '统计长处方总数状态维度', '统计长处方总数状态维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT   p.patient as patient ,p.code AS prescription_code, p.id AS business_id,p.admin_team_id AS team FROM wlyy_prescription p where 1=1 ', 'SELECT  count(p.code) FROM wlyy_prescription p where 1=1 ', ' AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', ' AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '31 25 0 * * ?', '1', '64', '1');
    102. 

  102. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('65', '统计长处方总数年龄维度', '统计长处方总数年龄维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT p.code AS prescription_code, p.id AS business_id,p.admin_team_id AS team, p.patient AS patient ,a.idcard AS idcard FROM wlyy_prescription p,wlyy_patient a where p.patient=a.code ', 'SELECT count(p.code) FROM wlyy_prescription p,wlyy_patient a where p.patient=a.code ', ' AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', ' AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '1 26 0 * * ?', '1', '65', '1');
    103. 

  103. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('66', '统计长处方费用总数维度', '统计长处方费用总数维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT s. code AS prescription_code, p.id AS business_id, s.admin_team_id AS team, s.patient AS patient,p.total_amount AS num FROM wlyy_prescription_pay p, wlyy_prescription s WHERE p.prescription_code = s. CODE and p.trade_status = 1', 'SELECT COUNT(p.id) FROM wlyy_prescription_pay p, wlyy_prescription s WHERE p.prescription_code = s. CODE and p.trade_status = 1 ', ' AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', ' AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '31 26 0 * * ?', '1', '66', '1');
    104. 

  104. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('67', '统计长处方配送方式维度', '统计长处方配送方式维度', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT p.code AS prescription_code, p.id AS business_id,p.admin_team_id AS team, p.patient AS patient FROM wlyy_prescription p where p.status>=50', 'SELECT COUNT(p.code) FROM wlyy_prescription p where  p.status>=50 ', ' AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', ' AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '1 27 0 * * ?', '1', '67', '1');
    105. 

  105. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('68', '统计长处方年龄人数(按照患者去重)', '统计长处方年龄人数(按照患者去重)', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT p.patient,t.idcard AS idcard,t.id AS business_id,p.admin_team_id AS team FROM wlyy_prescription p,wlyy_patient t WHERE p.patient = t. CODE AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\' GROUP BY p.patient', 'SELECT count(DISTINCT p.patient) FROM wlyy_prescription p,wlyy_patient t WHERE p.patient = t. CODE AND p.create_time < \'[endTime]\' AND p.create_time >= \'[startTime]\'', '', '', 'prescription_patient_age', '31 27 0 * * ?', '1', '68', '1');
    106. 

  106. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('69', '随访量（工作报告，没有状态区分）', '随访量（工作报告，没有状态区分）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT f.id business_id,f.admin_team_code team FROM wlyy_followup f WHERE 1=1', 'SELECT COUNT(f.id) FROM wlyy_followup f WHERE 1=1 ', 'and f.followup_plan_date>=\'[startTime]\'  and f.followup_plan_date<\'[endTime]\'', 'and f.followup_plan_date>=\'[startTime]\'  and f.followup_plan_date<\'[endTime]\'', NULL, '1 28 0 * * ?', '1', '69', '1');
    107. 

  107. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('70', '随访量（计划中，未开始）', '随访量（计划中，未开始）', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT f.id business_id,f.admin_team_code team FROM wlyy_followup f WHERE 1=1 and f.status=2 ', 'SELECT COUNT(f.id) FROM wlyy_followup f WHERE 1=1 and f.status=2 ', 'and f.followup_plan_date>=\'[startTime]\'  and f.followup_plan_date<\'[endTime]\'', NULL, NULL, '31 28 0 * * ?', '1', '70', '1');
    108. 

  108. INSERT INTO `wlyy`.`wlyy_job_config_new` (`id`, `job_name`, `job_info`, `job_type`, `job_class`, `sql`, `sql_count`, `sql_day`, `sql_year`, `cache_key`, `quartz_cron`, `status`, `quota_id`, `del`) VALUES ('71', '健康教育批次', '健康教育批次', '2', 'com.yihu.wlyy.statistics.job.business.MysqlToEsQuotaJob', 'SELECT w.admin_team_code AS team,w.id as business_id,w.patient as patient,w.batch_no FROM wlyy_health_edu_article_patient w where 1=1 AND w.batch_no IS NOT NULL AND w.czrq <= \'[endTime]\' AND w.czrq >= \'[startTime]\' GROUP BY batch_no\r\n', 'SELECT COUNT(DISTINCT(w.batch_no)) FROM wlyy_health_edu_article_patient w WHERE 1=1 AND w.czrq <= \'[endTime]\' AND w.czrq >= \'[startTime]\'', NULL, NULL, NULL, '1 29 0 * * ?', '1', '71', '1');
    109. 

  109. 

  110. 

  111. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('1', '1', '1', '�����Ա�ά��', '1', '2017-07-11 09:42:33', NULL, NULL, '2017-06-02 14:19:25', NULL, NULL, NULL);
    112. 

  112. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('2', '2', '2', '����������', '1', '2017-07-11 09:42:34', NULL, NULL, '2017-06-02 14:19:27', NULL, NULL, NULL);
    113. 

  113. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('3', '3', '3', '���߽����ֲ���ǩ', '1', '2017-07-12 14:07:59', NULL, NULL, '2017-06-02 15:01:56', NULL, NULL, NULL);
    114. 

  114. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('4', '4', '4', 'ǩԼ�۷�״̬', '1', '2017-07-11 09:42:18', NULL, NULL, '2017-07-11 09:41:14', NULL, NULL, NULL);
    115. 

  115. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('5', '5', '5', 'ǩԼ�������', '1', '2017-07-12 12:05:40', NULL, NULL, '2017-07-11 09:41:44', NULL, NULL, NULL);
    116. 

  116. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('6', '6', '6', '��ǩתǩԭ��', '1', '2017-07-12 17:29:43', NULL, NULL, '2017-07-12 17:28:37', NULL, NULL, NULL);
    117. 

  117. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('7', '7', '7', '��ѯ�ظ�ʱ��ֲ�', '1', '2017-07-12 17:29:45', NULL, NULL, '2017-07-12 17:28:39', NULL, NULL, NULL);
    118. 

  118. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('8', '8', '8', '���߼�����ǩ', '1', '2017-07-19 16:53:44', NULL, NULL, '2017-07-19 16:53:46', NULL, NULL, NULL);
    119. 

  119. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('9', '9', '9', '�����DZ�ǩ', '1', '2017-10-18 10:14:27', NULL, NULL, '2017-10-18 10:14:29', NULL, NULL, NULL);
    120. 

  120. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('10', '10', '10', '����������������', '1', '2017-11-15 14:32:49', NULL, NULL, '2017-11-15 14:30:57', NULL, NULL, NULL);
    121. 

  121. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('11', '11', '11', '������״̬ά��', '1', '2017-11-15 14:32:42', NULL, NULL, '2017-11-15 14:30:57', NULL, NULL, NULL);
    122. 

  122. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('12', '12', '12', '���������ͷ�ʽά��', '1', '2017-11-15 14:32:41', NULL, NULL, '2017-11-15 14:30:57', NULL, NULL, NULL);
    123. 

  123. INSERT INTO `wlyy`.`wlyy_dimension` (`id`, `code`, `type`, `name`, `status`, `create_time`, `create_user`, `create_user_name`, `update_time`, `update_user`, `update_user_name`, `remark`) VALUES ('13', '13', '13', '���������߼���', '1', '2017-11-15 14:32:37', NULL, NULL, '2017-11-15 14:30:57', NULL, NULL, NULL);
    124. 

  124. 

  125. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('1', '6', '1', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_SEX_DICT\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.SexConvert', '1', 'Idcard');
    126. 

  126. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('2', '7', '3', NULL, NULL, NULL, NULL);
    127. 

  127. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('3', '8', '2', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGE_DICT\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.AgeConvert', '1', '');
    128. 

  128. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('4', '30', '6', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_RENEW_CHANGE_REASON\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.SimpleConvert', '1', 'SlaveKey1');
    129. 

  129. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('6', '36', '5', 'select DISTINCT code,name from wlyy_sign_dict where type=1 and year=2017', 'com.yihu.wlyy.statistics.etl.convert.wlyy.ServerTypeConvert', '1', '');
    130. 

  130. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('7', '15', '3', 'select label_code code,label_name name from wlyy_sign_patient_label where label_type=\'2\' and status=1', 'com.yihu.wlyy.statistics.etl.convert.wlyy.HealthLableConvert', '1', '');
    131. 

  131. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('8', '24', '7', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_CONSULT_TIME\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.ConsultTimeConvert', '1', 'SlaveKey1');
    132. 

  132. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('9', '12', '2', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGE_DICT\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.AgeConvert', '1', '');
    133. 

  133. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('10', '12', '8', 'select label_code code,label_name name from wlyy_sign_patient_label where label_type=\'3\' and status=1', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DiseaseLableConvert', '2', NULL);
    134. 

  134. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('11', '17', '9', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGEDISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DiseaseAndAgeConvert', '1', '');
    135. 

  135. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('12', '51', '9', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGEDISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DiseaseAndAgeConvert', '1', '');
    136. 

  136. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('13', '52', '9', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGEDISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DiseaseAndAgeConvert', '1', NULL);
    137. 

  137. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('14', '53', '9', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGEDISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DiseaseAndAgeConvert', '1', NULL);
    138. 

  138. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('15', '54', '9', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGEDISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DiseaseAndAgeConvert', '1', NULL);
    139. 

  139. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('16', '55', '9', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGEDISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DiseaseAndAgeConvert', '1', NULL);
    140. 

  140. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('17', '56', '9', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGEDISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DiseaseAndAgeConvert', '1', NULL);
    141. 

  141. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('18', '57', '9', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGEDISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DiseaseAndAgeConvert', '1', NULL);
    142. 

  142. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('19', '58', '10', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_PRESCRIPTION_DISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.PrescriptionDiseaseConvert', '1', '');
    143. 

  143. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('20', '58', '11', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_PRESCRIPTION_STATUS\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.PrescriptionStatusConvert', '2', '');
    144. 

  144. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('21', '60', '2', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGE_DICT\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.AgeConvert', '1', '');
    145. 

  145. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('22', '60', '10', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_PRESCRIPTION_DISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.PrescriptionDiseaseConvert', '2', NULL);
    146. 

  146. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('23', '61', '10', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_PRESCRIPTION_DISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.PrescriptionDiseaseConvert', '1', NULL);
    147. 

  147. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('24', '62', '12', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_PRESCRIPTION_SENDT_TYPE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DispensaryTypeConvert', '1', '');
    148. 

  148. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('25', '62', '10', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_PRESCRIPTION_DISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.PrescriptionDiseaseConvert', '2', NULL);
    149. 

  149. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('26', '63', '2', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGE_DICT\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.AgeConvert', '1', '');
    150. 

  150. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('27', '63', '13', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_PRESCRIPTION_DISEASE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.PrescriptionPatientDiseaseConvert', '2', '');
    151. 

  151. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('28', '64', '11', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_PRESCRIPTION_STATUS\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.PrescriptionStatusConvert', '2', '');
    152. 

  152. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('29', '65', '2', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGE_DICT\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.AgeConvert', '1', '');
    153. 

  153. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('31', '67', '12', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_PRESCRIPTION_SENDT_TYPE\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.DispensaryTypeConvert', '1', '');
    154. 

  154. INSERT INTO `wlyy`.`wlyy_dimension_quota` (`id`, `quota_code`, `dimension_code`, `dict_sql`, `convert_clazz`, `sort`, `key`) VALUES ('32', '68', '2', 'select s.code code,s.value name from system_dict s where  s.dict_name=\'QUOTA_AGE_DICT\'', 'com.yihu.wlyy.statistics.etl.convert.wlyy.AgeConvert', '1', '');
    155. 

  155. 

  156. 

  157. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_RENEW_CHANGE_REASON', '1', '��ס�ر��', NULL, '1');
    158. 

  158. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_RENEW_CHANGE_REASON', '2', 'ҽ��רҵ�Ȳ���', NULL, '2');
    159. 

  159. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_RENEW_CHANGE_REASON', '3', '��ѯ�ظ���', NULL, '3');
    160. 

  160. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_RENEW_CHANGE_REASON', '4', '�޻�ø�', NULL, '4');
    161. 

  161. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_RENEW_CHANGE_REASON', '5', 'ҽ������̬�Ȳ�', NULL, '5');
    162. 

  162. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_RENEW_CHANGE_REASON', '6', '����', NULL, '6');
    163. 

  163. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_SEX_DICT', '1', 'Ů', '', '1');
    164. 

  164. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_SEX_DICT', '2', '��', '', '2');
    165. 

  165. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_SEX_DICT', '3', 'δ֪', '', '3');
    166. 

  166. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_AGE_DICT', '1', '0~6', '', '1');
    167. 

  167. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_AGE_DICT', '2', '7~18', '', '2');
    168. 

  168. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_AGE_DICT', '3', '19~30', '', '3');
    169. 

  169. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_AGE_DICT', '4', '31~50', '', '4');
    170. 

  170. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_AGE_DICT', '5', '51~64', '', '5');
    171. 

  171. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_AGE_DICT', '6', '65����', '', '6');
    172. 

  172. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_SIGN_EXPESEX', '0', '�ѿ۷�', '', '1');
    173. 

  173. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_SIGN_EXPESEX', '1', '�ѽɷ�', '', '2');
    174. 

  174. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_SIGN_EXPESEX', '2', '���˷�', '', '3');
    175. 

  175. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_CONSULT_TIME', '1', '0~8', '', NULL);
    176. 

  176. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_CONSULT_TIME', '2', '8~12', '', NULL);
    177. 

  177. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_CONSULT_TIME', '3', '12~13', '', NULL);
    178. 

  178. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_CONSULT_TIME', '4', '13~18', '', NULL);
    179. 

  179. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_CONSULT_TIME', '5', '18~24', '', NULL);
    180. 

  180. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_AGEDISEASE', '1', '��Ѫѹ', '', '1');
    181. 

  181. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_AGEDISEASE', '2', '����', '', '2');
    182. 

  182. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_AGEDISEASE', '3', '65��������Ⱥ', '', '3');
    183. 

  183. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_DISEASE', 'HP0093', '��Ѫѹ', NULL, '1');
    184. 

  184. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_DISEASE', 'HP0047', '����', NULL, '2');
    185. 

  185. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_STATUS', '1', '������', NULL, NULL);
    186. 

  186. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_STATUS', '2', '�����', NULL, NULL);
    187. 

  187. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_STATUS', '3', '��ȡ��', NULL, NULL);
    188. 

  188. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_STATUS', '4', '��˲�ͨ��', NULL, NULL);
    189. 

  189. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_STATUS', '5', '����ԭ��ȡ��', NULL, NULL);
    190. 

  190. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_SENDT_TYPE', '1', '������ȡ', NULL, NULL);
    191. 

  191. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_SENDT_TYPE', '2', '��������', NULL, NULL);
    192. 

  192. INSERT INTO `wlyy`.`system_dict` (`id`, `dict_name`, `code`, `value`, `py_code`, `sort`) VALUES (0, 'QUOTA_PRESCRIPTION_SENDT_TYPE', '3', '����ʦ����', NULL, NULL);
    193.