-- ============================================================= -- 复欣智慧物业服务 · 人文关怀模块 数据库初始化脚本 (SQLite) -- 生成时间: 2026-10-04 模板条数: 41 -- 说明: 节气/农历日期已预计算 2026-2035 年,落库后可每天一次 date 匹配即可 -- ============================================================= -- 1. 节日/节气模板表 CREATE TABLE IF NOT EXISTS care_template ( id TEXT PRIMARY KEY, -- 模板唯一ID, 如 jq_lichun category TEXT NOT NULL, -- birthday/solar_term/traditional/international category_name TEXT NOT NULL, -- 分类显示名 name TEXT NOT NULL, -- 节日/节气名称 date_rule TEXT NOT NULL, -- 日期计算规则 JSON owner_title TEXT, -- 业主版标题(微信订阅消息 thing 字段建议<=20字符) owner_text TEXT, -- 业主版正文 staff_title TEXT, -- 员工版标题 staff_text TEXT, -- 员工版正文 image_url TEXT, -- 配套配图 push_time TEXT DEFAULT '09:00', -- 当日推送时刻 enabled INTEGER DEFAULT 1, -- 该节日是否开启推送(开关, 不用删文案) remark TEXT, created_at TEXT DEFAULT (datetime('now','localtime')), updated_at TEXT DEFAULT (datetime('now','localtime')) ); CREATE INDEX IF NOT EXISTS idx_care_template_cat ON care_template(category); -- 2. 各年份实际触发日期表(每年生成一次即可) CREATE TABLE IF NOT EXISTS care_template_date ( id INTEGER PRIMARY KEY AUTOINCREMENT, tpl_id TEXT NOT NULL, yyyy TEXT NOT NULL, fire_date TEXT NOT NULL, -- 当年触发日 YYYY-MM-DD UNIQUE(tpl_id, yyyy) ); CREATE INDEX IF NOT EXISTS idx_care_date_fire ON care_template_date(fire_date); -- 3. 推送日志台账 CREATE TABLE IF NOT EXISTS care_push_log ( id INTEGER PRIMARY KEY AUTOINCREMENT, tpl_id TEXT NOT NULL, tpl_name TEXT NOT NULL, audience TEXT NOT NULL, -- owner/staff user_id TEXT, user_name TEXT, user_phone TEXT, project_id TEXT, channel TEXT DEFAULT 'subscribe_message', -- subscribe_message/手动 status TEXT NOT NULL, -- success/fail/unauthorized err_msg TEXT, batch_no TEXT, -- 分批次发送批次号(防微信风控) sent_at TEXT DEFAULT (datetime('now','localtime')) ); CREATE INDEX IF NOT EXISTS idx_care_log_tpl ON care_push_log(tpl_id); CREATE INDEX IF NOT EXISTS idx_care_log_sent ON care_push_log(sent_at); -- 4. 用户订阅授权快照(批量推送前置条件) CREATE TABLE IF NOT EXISTS care_subscribe_auth ( id INTEGER PRIMARY KEY AUTOINCREMENT, openid TEXT NOT NULL, user_type TEXT NOT NULL, -- owner/staff tpl_msg_id TEXT NOT NULL, -- 微信订阅消息模板ID auth_count INTEGER DEFAULT 1, -- 剩余可下发次数(一次性订阅每次+1) updated_at TEXT DEFAULT (datetime('now','localtime')), UNIQUE(openid, tpl_msg_id) ); -- 5. 初始化模板数据 INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('bd_owner', 'birthday', '生日祝福', '业主生日', '{"type": "personal", "field": "birthday"}', '生日快乐·万事顺遂', '尊敬的业主您好!今天是您的生日,上海复欣物业全体同仁祝您生日快乐,身体健康,阖家幸福,万事顺遂!', NULL, NULL, '', '09:00', 1, '按个人生日触发,不属于群发节日'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('bd_staff', 'birthday', '生日祝福', '员工生日', '{"type": "personal", "field": "birthday"}', NULL, NULL, '生日快乐·前程似锦', '亲爱的同事:今天是您的生日,公司感谢您一直以来的辛勤付出与坚守。祝您生日快乐,身体健康,家庭美满,前程似锦!', '', '09:00', 1, '按个人生日触发,不属于群发节日'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_lichun', 'solar_term', '24节气', '立春', '{"type": "solar_term", "term": "立春"}', '春风启序·万物复苏', '东风解冻,万物复苏。上海复欣物业祝您春日安康,万事顺遂,愿春风常伴,阖家喜乐。', '春启新程·感恩坚守', '万物随春醒,美好皆可期。感谢坚守岗位,祝您新春启序,工作顺利,阖家安康。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_yushui', 'solar_term', '24节气', '雨水', '{"type": "solar_term", "term": "雨水"}', '春雨润物·春意渐浓', '春雨润物,暖意渐生。提醒您早晚温差较大,注意添衣。祝您平安喜乐,诸事顺心。', '春润万物·感恩有您', '春雨润物,暖意渐来。感谢辛勤付出,注意冷暖,祝您平安顺遂。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_jingzhe', 'solar_term', '24节气', '惊蛰', '{"type": "solar_term", "term": "惊蛰"}', '春雷初响·万物生长', '春雷响,万物长。春意渐浓,气候多变,请注意养生保暖。祝您日子向阳,万事可期。', '春雷催进·奋斗当时', '春雷启万物,奋斗正当时。感谢坚守,愿您万事可期,身心安康。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_chunfen', 'solar_term', '24节气', '春分', '{"type": "solar_term", "term": "春分"}', '昼夜均分·春色正中', '昼夜均分,春色平分。愿您不负春光,生活温暖舒心。复欣物业持续守护您的家园。', '春色平分·耕耘不辍', '春色平分,耕耘不辍。感谢默默守护家园,祝您工作顺心,喜乐常伴。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_qingming', 'solar_term', '24节气', '清明', '{"type": "solar_term", "term": "清明"}', '气清景明·慎终追远', '气清景明,万物皆显。愿您心怀安宁,珍重安康。出行注意安全。', '气清景明·劳逸结合', '气清景明,万物复苏。请大家劳逸结合,注意出行安全,祝您平安顺遂。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_guyu', 'solar_term', '24节气', '谷雨', '{"type": "solar_term", "term": "谷雨"}', '雨生百谷·春意将尽', '雨生百谷,春末将至。湿气渐重,愿您保重身体,阖家平安。', '雨润百谷·耕耘有获', '雨生百谷,耕耘收获。感谢坚守岗位,祝您平安喜乐。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_lixia', 'solar_term', '24节气', '立夏', '{"type": "solar_term", "term": "立夏"}', '初夏登场·万物繁茂', '夏日初临,万物繁茂。气温升高,请注意防暑补水,祝您夏日舒心。', '夏日初临·热忱不减', '夏日初临,热忱不减。感谢坚守一线,高温将至,注意防暑。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_xiaoman', 'solar_term', '24节气', '小满', '{"type": "solar_term", "term": "小满"}', '小得盈满·知足常乐', '小满即安,万物丰盈。愿您生活知足常乐,平安顺遂。', '小满即圆满', '小满方为圆满。感谢辛勤付出,祝您生活舒心,万事称心。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_mangzhong', 'solar_term', '24节气', '芒种', '{"type": "solar_term", "term": "芒种"}', '芒种忙种·仲夏开场', '芒种至,仲夏始。天气湿热,请注意防暑祛湿,祝您安康。', '忙有所获·种有所得', '忙有所获,种有所得。感谢辛勤耕耘,注意防暑祛湿。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_xiazhi', 'solar_term', '24节气', '夏至', '{"type": "solar_term", "term": "夏至"}', '昼长宵短·盛夏已至', '昼最长,夜最短。盛夏来临,注意防暑纳凉,愿您夏日清宁。', '昼长情更长', '昼长情更长,感谢坚守。盛夏炎热,做好防暑,祝您安康。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_xiaoshu', 'solar_term', '24节气', '小暑', '{"type": "solar_term", "term": "小暑"}', '温风渐至·暑气初升', '小暑至,暑气升。天气炎热,提醒您做好防暑,平安度夏。', '暑气渐盛·初心不改', '暑气渐盛,初心不改。感谢在岗守护,高温天气注意防暑。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_dashu', 'solar_term', '24节气', '大暑', '{"type": "solar_term", "term": "大暑"}', '盛夏正浓·家有清凉', '大暑至,盛夏浓。高温酷暑,注意防暑,愿您家有清凉,身心安康。', '酷暑坚守·致敬一线', '盛夏酷暑,感谢坚守。做好防暑防护,愿您平安度夏。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_liqiu', 'solar_term', '24节气', '立秋', '{"type": "solar_term", "term": "立秋"}', '一叶知秋·凉风有信', '一叶知秋,暑去凉来。早晚温差变大,请适时增减衣物。祝您秋安。', '一叶知秋·初心依旧', '一叶知秋,初心依旧。感谢辛勤付出,早晚温差大,注意添衣。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_chushu', 'solar_term', '24节气', '处暑', '{"type": "solar_term", "term": "处暑"}', '暑气渐止·秋色初起', '暑气渐消,秋意渐起。气候干燥,注意润肺养生,祝您万事顺意。', '暑退秋来·守护如常', '暑退秋来,耕耘不息。感谢坚守,秋燥注意养生。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_bailu', 'solar_term', '24节气', '白露', '{"type": "solar_term", "term": "白露"}', '白露凝珠·秋燥渐生', '白露凝珠,秋燥渐盛。早晚寒凉,记得添衣,愿您秋日安康。', '白露秋凉·温暖在岗', '白露至,秋意浓。感谢坚守岗位,早晚记得添衣。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_qiufen', 'solar_term', '24节气', '秋分', '{"type": "solar_term", "term": "秋分"}', '昼夜平分·桂子飘香', '昼夜均分,桂香满庭。秋凉渐至,愿您岁月安然,阖家美满。', '平分秋色·坚守如常', '平分秋色,坚守如常。感谢默默付出,祝您阖家安康。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_hanlu', 'solar_term', '24节气', '寒露', '{"type": "solar_term", "term": "寒露"}', '露气寒冷·秋深添衣', '寒露降临,寒意渐浓。天气转凉,注意防寒保暖,祝您平安喜乐。', '寒露渐凉·温暖在岗', '寒露渐凉,温暖在岗。感谢辛勤工作,注意防寒。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_shuangjiang', 'solar_term', '24节气', '霜降', '{"type": "solar_term", "term": "霜降"}', '霜华初降·秋意正浓', '霜落秋深,草木凝霜。气温走低,及时添衣,愿您岁岁安康。', '霜落秋深·温暖相伴', '霜落秋深,温暖相伴。感谢坚守一线,及时添衣保暖。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_lidong', 'solar_term', '24节气', '立冬', '{"type": "solar_term", "term": "立冬"}', '水始成冰·冬之开篇', '万物收藏,冬之伊始。寒风渐起,请注意防寒保暖,愿您家暖人安。', '冬启万物·坚守有温', '冬启万物藏,坚守有温度。感谢辛勤付出,注意防寒。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_xiaoxue', 'solar_term', '24节气', '小雪', '{"type": "solar_term", "term": "小雪"}', '小雪轻盈·围炉向暖', '小雪初临,寒意渐深。天气干燥寒冷,愿您冬日温暖,诸事顺心。', '寒意渐浓·温暖在岗', '寒意渐浓,温暖在岗。感谢坚守,注意防寒保暖。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_daxue', 'solar_term', '24节气', '大雪', '{"type": "solar_term", "term": "大雪"}', '瑞雪纷飞·岁暮天寒', '大雪纷飞,冬意正浓。气温较低,注意防寒防滑,祝您冬安。', '寒冬守护·防滑保暖', '寒冬已至,守护不停。感谢坚守岗位,出行注意防滑。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_dongzhi', 'solar_term', '24节气', '冬至', '{"type": "solar_term", "term": "冬至"}', '冬至阳生·人间团圆', '冬至大如年,人间小团圆。愿您阖家围坐,温暖相伴,岁岁平安。', '冬至团圆·感恩相伴', '冬至团圆,感恩相伴。感谢辛勤付出,愿您阖家温暖。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_xiaohan', 'solar_term', '24节气', '小寒', '{"type": "solar_term", "term": "小寒"}', '小寒料峭·凛冬至深', '小寒已至,凛冬渐盛。天寒地冻,注意防寒,祝您冬日安康。', '凛冬坚守·温暖相随', '凛冬已至,温暖相随。感谢坚守,注意防寒。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('jq_dahan', 'solar_term', '24节气', '大寒', '{"type": "solar_term", "term": "大寒"}', '大寒岁暮·静待春归', '大寒岁末,冬尽春来。愿您抵御严寒,静待新春,万事皆安。', '岁末大寒·静待春来', '岁末大寒,静待春来。感谢一整年辛勤付出,祝您平安顺遂。', '', '07:30', 1, '天文算法(太阳视黄经)精确交节日,每年自动识别'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_yuandan', 'traditional', '国内传统节日', '元旦', '{"type": "fixed", "month": 1, "day": 1}', '一元复始·万象更新', '一元复始,万象更新。上海复欣物业祝您新年大吉,阖家安康,万事顺意,新岁皆可期。', '辞旧迎新·感恩同行', '辞旧迎新,感恩同行。感谢全体同事一年来坚守岗位、辛勤付出,祝您元旦快乐,阖家幸福,工作顺遂!', '', '08:00', 1, '固定公历日期'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_chunjie', 'traditional', '国内传统节日', '春节', '{"type": "lunar", "month": 1, "day": 1}', '新春启瑞·福满家园', '新春启瑞,福满家园。上海复欣物业恭祝您新春快乐,阖家团圆,岁岁平安,万事兴旺!', '新春大吉·感恩相伴', '新春大吉,感恩相伴。感谢各位坚守岗位,守护小区平安。祝您和家人新春安康,福运绵长。', '', '08:00', 1, '农历节日按农历换算,每年自动落至对应公历日'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_yuanxiao', 'traditional', '国内传统节日', '元宵节', '{"type": "lunar", "month": 1, "day": 15}', '灯火良宵·月圆人安', '灯火良宵,月圆人安。祝您元宵喜乐,阖家美满,日子甜甜蜜蜜。', '元宵佳节·灯火迎春', '元宵佳节,灯火迎春。感谢坚守服务一线,祝您佳节安康,万事顺心。', '', '08:00', 1, '农历节日按农历换算,每年自动落至对应公历日'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_qingming', 'traditional', '国内传统节日', '清明节', '{"type": "solar_term", "term": "清明"}', '春和景明·慎终追远', '春和景明,慎终追远。愿您心怀安宁,出行注意安全,保重身体。', '气清景明·劳逸结合', '气清景明,万物复苏。请大家劳逸结合,注意出行安全,祝您平安顺遂。', '', '08:00', 0, '清明节与『清明』节气同日,默认关闭;想用节庆版文案时手动开启并把节气版关掉'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_laodong', 'traditional', '国内传统节日', '劳动节', '{"type": "fixed", "month": 5, "day": 1}', '劳动创造·美好家园', '劳动创造美好家园。上海复欣物业祝您五一节日快乐,阖家舒心,万事安康。', '致敬奋斗者', '致敬每一位奋斗者!感谢各位同事辛勤耕耘、默默坚守,祝您劳动节快乐,平安喜乐。', '', '08:00', 1, '固定公历日期'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_duanwu', 'traditional', '国内传统节日', '端午节', '{"type": "lunar", "month": 5, "day": 5}', '粽叶飘香·端午安康', '粽叶飘香,端午安康。愿您岁岁平安,阖家喜乐,万事皆安。', '端午仲夏·感恩坚守', '端午临仲夏,时清日复长。感谢坚守岗位,祝您端午安康,身体康健,诸事顺心。', '', '08:00', 1, '农历节日按农历换算,每年自动落至对应公历日'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_qixi', 'traditional', '国内传统节日', '七夕节', '{"type": "lunar", "month": 7, "day": 7}', '星河璀璨·爱意绵长', '星河璀璨,爱意绵长。祝您阖家美满,生活温馨,岁岁皆有欢喜。', '七夕良辰·美好常伴', '七夕良辰,愿美好常伴。祝您家庭和睦,日子温暖,万事称心。', '', '08:00', 1, '农历节日按农历换算,每年自动落至对应公历日'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_zhongqiu', 'traditional', '国内传统节日', '中秋节', '{"type": "lunar", "month": 8, "day": 15}', '月满中秋·家国同欢', '月满中秋,家国同欢。上海复欣物业祝您中秋快乐,阖家团圆,平安喜乐。', '皓月当空·感恩同行', '皓月当空,感恩同行。感谢坚守岗位守护家园,祝您中秋团圆,阖家安康。', '', '08:00', 1, '农历节日按农历换算,每年自动落至对应公历日'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_guoqing', 'traditional', '国内传统节日', '国庆节', '{"type": "fixed", "month": 10, "day": 1}', '盛世华诞·家国安宁', '盛世华诞,家国安宁。上海复欣物业恭祝您国庆快乐,阖家幸福,万事安康!', '喜迎国庆·山河锦绣', '喜迎国庆,共祝山河锦绣。感谢大家坚守岗位,祝您节日快乐,阖家顺遂。', '', '08:00', 1, '固定公历日期'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('ct_chongyang', 'traditional', '国内传统节日', '重阳节', '{"type": "lunar", "month": 9, "day": 9}', '九九重阳·敬老情长', '九九重阳,敬老情长。愿社区各位长者福寿安康,喜乐常伴。', '重阳敬老·暖心服务', '重阳佳节,敬老暖心。感谢大家用心做好老年业主服务,祝您阖家安康。', '', '08:00', 1, '农历节日按农历换算,每年自动落至对应公历日'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('in_earth_day', 'international', '精选国际节日', '世界地球日', '{"type": "fixed", "month": 4, "day": 22}', '珍爱地球·共建家园', '珍爱地球,共建美好家园。上海复欣物业倡导绿色文明,与您共建整洁宜居社区。', '守护环境·绿色服务', '世界地球日,感谢各位同事守护社区环境,践行绿色服务。', '', '09:30', 1, '人文/环保/敬老向,不涉及敏感题材'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('in_environment_day', 'international', '精选国际节日', '世界环境日', '{"type": "fixed", "month": 6, "day": 5}', '绿色社区·美好环境', '共建绿色社区,共享美好环境。愿我们携手爱护小区一草一木。', '园区环境·用心维护', '世界环境日,感谢大家做好园区环境维护,守护社区美好。', '', '09:30', 1, '人文/环保/敬老向,不涉及敏感题材'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('in_elderly_day', 'international', '精选国际节日', '国际老年人日', '{"type": "fixed", "month": 10, "day": 1}', '敬老爱老·温情社区', '敬老爱老,温情社区。愿社区长者平安健康,喜乐常伴。', '用心关怀老年业主', '国际老年人日,感谢大家用心做好老年业主关怀服务。', '', '09:30', 1, '人文/环保/敬老向,不涉及敏感题材'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('in_habitat_day', 'international', '精选国际节日', '世界住房日', '{"type": "weekday_of_month", "month": 10, "weekday": 0, "nth": 1}', '家是港湾·用心守护', '家是温暖港湾,复欣物业用心守护您的安居生活。', '坚守岗位·守护安居', '世界住房日,我们坚守岗位,守护业主安居乐业。', '', '09:30', 1, '人文/环保/敬老向,不涉及敏感题材'); INSERT OR REPLACE INTO care_template (id, category, category_name, name, date_rule, owner_title, owner_text, staff_title, staff_text, image_url, push_time, enabled, remark) VALUES ('in_disability_day', 'international', '精选国际节日', '国际残疾人日', '{"type": "fixed", "month": 12, "day": 3}', '包容友善·温情相伴', '包容友善,温情相伴。共建有温度的和谐社区。', '友善包容·用心服务', '国际残疾人日,倡导友善包容,用心做好特殊群体服务。', '', '09:30', 1, '人文/环保/敬老向,不涉及敏感题材'); -- 6. 初始化 2026-2035 年触发日期 INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2026', '2026-02-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2027', '2027-02-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2028', '2028-02-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2029', '2029-02-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2030', '2030-02-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2031', '2031-02-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2032', '2032-02-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2033', '2033-02-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2034', '2034-02-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lichun', '2035', '2035-02-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2026', '2026-02-18'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2027', '2027-02-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2028', '2028-02-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2029', '2029-02-18'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2030', '2030-02-18'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2031', '2031-02-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2032', '2032-02-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2033', '2033-02-18'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2034', '2034-02-18'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_yushui', '2035', '2035-02-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2026', '2026-03-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2027', '2027-03-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2028', '2028-03-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2029', '2029-03-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2030', '2030-03-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2031', '2031-03-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2032', '2032-03-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2033', '2033-03-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2034', '2034-03-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_jingzhe', '2035', '2035-03-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2026', '2026-03-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2027', '2027-03-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2028', '2028-03-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2029', '2029-03-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2030', '2030-03-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2031', '2031-03-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2032', '2032-03-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2033', '2033-03-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2034', '2034-03-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chunfen', '2035', '2035-03-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2026', '2026-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2027', '2027-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2028', '2028-04-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2029', '2029-04-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2030', '2030-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2031', '2031-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2032', '2032-04-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2033', '2033-04-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2034', '2034-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qingming', '2035', '2035-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2026', '2026-04-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2027', '2027-04-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2028', '2028-04-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2029', '2029-04-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2030', '2030-04-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2031', '2031-04-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2032', '2032-04-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2033', '2033-04-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2034', '2034-04-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_guyu', '2035', '2035-04-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2026', '2026-05-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2027', '2027-05-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2028', '2028-05-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2029', '2029-05-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2030', '2030-05-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2031', '2031-05-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2032', '2032-05-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2033', '2033-05-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2034', '2034-05-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lixia', '2035', '2035-05-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2026', '2026-05-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2027', '2027-05-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2028', '2028-05-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2029', '2029-05-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2030', '2030-05-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2031', '2031-05-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2032', '2032-05-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2033', '2033-05-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2034', '2034-05-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoman', '2035', '2035-05-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2026', '2026-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2027', '2027-06-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2028', '2028-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2029', '2029-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2030', '2030-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2031', '2031-06-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2032', '2032-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2033', '2033-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2034', '2034-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_mangzhong', '2035', '2035-06-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2026', '2026-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2027', '2027-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2028', '2028-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2029', '2029-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2030', '2030-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2031', '2031-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2032', '2032-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2033', '2033-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2034', '2034-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiazhi', '2035', '2035-06-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2026', '2026-07-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2027', '2027-07-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2028', '2028-07-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2029', '2029-07-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2030', '2030-07-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2031', '2031-07-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2032', '2032-07-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2033', '2033-07-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2034', '2034-07-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoshu', '2035', '2035-07-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2026', '2026-07-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2027', '2027-07-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2028', '2028-07-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2029', '2029-07-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2030', '2030-07-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2031', '2031-07-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2032', '2032-07-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2033', '2033-07-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2034', '2034-07-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dashu', '2035', '2035-07-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2026', '2026-08-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2027', '2027-08-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2028', '2028-08-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2029', '2029-08-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2030', '2030-08-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2031', '2031-08-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2032', '2032-08-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2033', '2033-08-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2034', '2034-08-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_liqiu', '2035', '2035-08-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2026', '2026-08-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2027', '2027-08-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2028', '2028-08-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2029', '2029-08-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2030', '2030-08-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2031', '2031-08-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2032', '2032-08-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2033', '2033-08-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2034', '2034-08-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_chushu', '2035', '2035-08-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2026', '2026-09-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2027', '2027-09-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2028', '2028-09-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2029', '2029-09-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2030', '2030-09-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2031', '2031-09-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2032', '2032-09-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2033', '2033-09-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2034', '2034-09-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_bailu', '2035', '2035-09-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2026', '2026-09-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2027', '2027-09-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2028', '2028-09-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2029', '2029-09-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2030', '2030-09-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2031', '2031-09-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2032', '2032-09-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2033', '2033-09-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2034', '2034-09-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_qiufen', '2035', '2035-09-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2026', '2026-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2027', '2027-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2028', '2028-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2029', '2029-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2030', '2030-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2031', '2031-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2032', '2032-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2033', '2033-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2034', '2034-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_hanlu', '2035', '2035-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2026', '2026-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2027', '2027-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2028', '2028-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2029', '2029-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2030', '2030-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2031', '2031-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2032', '2032-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2033', '2033-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2034', '2034-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_shuangjiang', '2035', '2035-10-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2026', '2026-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2027', '2027-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2028', '2028-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2029', '2029-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2030', '2030-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2031', '2031-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2032', '2032-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2033', '2033-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2034', '2034-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_lidong', '2035', '2035-11-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2026', '2026-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2027', '2027-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2028', '2028-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2029', '2029-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2030', '2030-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2031', '2031-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2032', '2032-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2033', '2033-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2034', '2034-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaoxue', '2035', '2035-11-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2026', '2026-12-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2027', '2027-12-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2028', '2028-12-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2029', '2029-12-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2030', '2030-12-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2031', '2031-12-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2032', '2032-12-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2033', '2033-12-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2034', '2034-12-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_daxue', '2035', '2035-12-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2026', '2026-12-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2027', '2027-12-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2028', '2028-12-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2029', '2029-12-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2030', '2030-12-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2031', '2031-12-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2032', '2032-12-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2033', '2033-12-21'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2034', '2034-12-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dongzhi', '2035', '2035-12-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2026', '2026-01-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2027', '2027-01-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2028', '2028-01-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2029', '2029-01-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2030', '2030-01-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2031', '2031-01-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2032', '2032-01-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2033', '2033-01-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2034', '2034-01-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_xiaohan', '2035', '2035-01-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2026', '2026-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2027', '2027-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2028', '2028-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2029', '2029-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2030', '2030-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2031', '2031-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2032', '2032-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2033', '2033-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2034', '2034-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('jq_dahan', '2035', '2035-01-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2026', '2026-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2027', '2027-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2028', '2028-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2029', '2029-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2030', '2030-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2031', '2031-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2032', '2032-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2033', '2033-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2034', '2034-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuandan', '2035', '2035-01-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2026', '2026-02-17'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2027', '2027-02-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2028', '2028-01-26'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2029', '2029-02-13'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2030', '2030-02-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2031', '2031-01-23'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2032', '2032-02-11'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2033', '2033-01-31'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2034', '2034-02-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chunjie', '2035', '2035-02-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2026', '2026-03-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2027', '2027-02-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2028', '2028-02-09'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2029', '2029-02-27'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2030', '2030-02-17'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2031', '2031-02-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2032', '2032-02-25'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2033', '2033-02-14'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2034', '2034-03-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_yuanxiao', '2035', '2035-02-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2026', '2026-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2027', '2027-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2028', '2028-04-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2029', '2029-04-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2030', '2030-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2031', '2031-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2032', '2032-04-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2033', '2033-04-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2034', '2034-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qingming', '2035', '2035-04-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2026', '2026-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2027', '2027-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2028', '2028-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2029', '2029-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2030', '2030-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2031', '2031-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2032', '2032-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2033', '2033-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2034', '2034-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_laodong', '2035', '2035-05-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2026', '2026-06-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2027', '2027-06-09'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2028', '2028-05-28'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2029', '2029-06-16'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2030', '2030-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2031', '2031-06-24'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2032', '2032-06-12'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2033', '2033-06-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2034', '2034-06-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_duanwu', '2035', '2035-06-10'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2026', '2026-08-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2027', '2027-08-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2028', '2028-08-26'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2029', '2029-08-16'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2030', '2030-08-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2031', '2031-08-24'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2032', '2032-08-12'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2033', '2033-08-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2034', '2034-08-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_qixi', '2035', '2035-08-10'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2026', '2026-09-25'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2027', '2027-09-15'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2028', '2028-10-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2029', '2029-09-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2030', '2030-09-12'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2031', '2031-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2032', '2032-09-19'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2033', '2033-09-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2034', '2034-09-27'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_zhongqiu', '2035', '2035-09-16'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2026', '2026-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2027', '2027-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2028', '2028-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2029', '2029-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2030', '2030-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2031', '2031-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2032', '2032-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2033', '2033-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2034', '2034-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_guoqing', '2035', '2035-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2026', '2026-10-18'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2027', '2027-10-08'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2028', '2028-10-26'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2029', '2029-10-16'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2030', '2030-10-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2031', '2031-10-24'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2032', '2032-10-12'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2033', '2033-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2034', '2034-10-20'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('ct_chongyang', '2035', '2035-10-09'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2026', '2026-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2027', '2027-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2028', '2028-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2029', '2029-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2030', '2030-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2031', '2031-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2032', '2032-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2033', '2033-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2034', '2034-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_earth_day', '2035', '2035-04-22'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2026', '2026-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2027', '2027-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2028', '2028-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2029', '2029-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2030', '2030-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2031', '2031-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2032', '2032-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2033', '2033-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2034', '2034-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_environment_day', '2035', '2035-06-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2026', '2026-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2027', '2027-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2028', '2028-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2029', '2029-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2030', '2030-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2031', '2031-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2032', '2032-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2033', '2033-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2034', '2034-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_elderly_day', '2035', '2035-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2026', '2026-10-05'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2027', '2027-10-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2028', '2028-10-02'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2029', '2029-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2030', '2030-10-07'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2031', '2031-10-06'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2032', '2032-10-04'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2033', '2033-10-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2034', '2034-10-02'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_habitat_day', '2035', '2035-10-01'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2026', '2026-12-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2027', '2027-12-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2028', '2028-12-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2029', '2029-12-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2030', '2030-12-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2031', '2031-12-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2032', '2032-12-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2033', '2033-12-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2034', '2034-12-03'); INSERT OR REPLACE INTO care_template_date (tpl_id, yyyy, fire_date) VALUES ('in_disability_day', '2035', '2035-12-03');