kyj-yanglao-end-new/sql/mysql/elderly_doctor_order_exec_auto_complete.sql

-- ============================================================
-- 长期医嘱执行记录：定时任务注册 + 机构「执行记录自动完成」配置初始化
-- ============================================================

-- 1. 为每个机构初始化「执行记录自动完成」配置（默认关闭）
INSERT INTO `system_business_params_config`
(`title`, `config_name`, `config_code`, `value`, `description`, `tenant_id`, `enable_status`)
SELECT '医嘱执行配置', '执行记录自动完成设置', 'DOCTOR_ORDER_EXEC_AUTO_COMPLETE', '0',
       '开启后，长期医嘱定时任务生成的护士执行记录自动置为已执行', t.`id`, 0
FROM `system_tenant` t
WHERE NOT EXISTS (
    SELECT 1 FROM (SELECT `tenant_id`, `config_code` FROM `system_business_params_config`) c
    WHERE c.`tenant_id` = t.`id` AND c.`config_code` = 'DOCTOR_ORDER_EXEC_AUTO_COMPLETE'
);

-- 2. 注册定时任务：每天 00:10 为未停止的长期医嘱条目生成当天执行记录
INSERT INTO `infra_job`
(`name`, `status`, `handler_name`, `handler_param`, `cron_expression`, `retry_count`, `retry_interval`, `monitor_timeout`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
SELECT '长期医嘱执行记录生成 Job', 2, 'longDoctorOrderExecJob', '', '0 10 0 * * ?', 3, 0, 0,
       '1', NOW(), '1', NOW(), b'0'
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM (SELECT `handler_name` FROM `infra_job` WHERE `deleted` = b'0') j
    WHERE j.`handler_name` = 'longDoctorOrderExecJob'
);