risk_control_platform/sql/risk_inspection_dicts.sql

-- ============================================================
-- 巡检相关字典(按 UI 设计稿)
-- value 一律中文
-- ============================================================

-- 1) 巡检类型
INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, remark) VALUES
  (12225, '000000', '巡检类型', 'risk_inspection_type', 103, 1, NOW(), '巡检管理-巡检类型下拉');
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark) VALUES
  (1, '园区巡检打卡',     '园区巡检打卡',     'risk_inspection_type', NULL, 'primary', 'N', 103, 1, NOW(), NULL),
  (2, '门店闭店检查',     '门店闭店检查',     'risk_inspection_type', NULL, 'success', 'N', 103, 1, NOW(), NULL),
  (3, '打样设施设备检查', '打样设施设备检查', 'risk_inspection_type', NULL, 'warning', 'N', 103, 1, NOW(), NULL);

-- 2) 打卡状态(任务级 - 已/未打卡)
INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, remark) VALUES
  (12226, '000000', '打卡状态', 'risk_inspection_status', 103, 1, NOW(), '巡检管理-打卡状态下拉(已/未打卡)');
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark) VALUES
  (1, '已打卡', '已打卡', 'risk_inspection_status', NULL, 'success', 'N', 103, 1, NOW(), '已有打卡记录'),
  (2, '未打卡', '未打卡', 'risk_inspection_status', NULL, 'info',    'N', 103, 1, NOW(), '尚无打卡记录');

-- 3) 打卡结果(任务级 - 正常/异常)
INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, remark) VALUES
  (12227, '000000', '打卡结果', 'risk_inspection_result', 103, 1, NOW(), '巡检管理-打卡结果下拉(正常/异常)');
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark) VALUES
  (1, '正常', '正常', 'risk_inspection_result', NULL, 'success', 'N', 103, 1, NOW(), 'record.result = 1'),
  (2, '异常', '异常', 'risk_inspection_result', NULL, 'danger',  'N', 103, 1, NOW(), 'record.result = 0');

-- 4) 巡检方式(任务级 - 常规/扫码)
INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, remark) VALUES
  (12228, '000000', '巡检方式', 'risk_inspection_method', 103, 1, NOW(), '巡检任务-打卡方式');
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark) VALUES
  (1, '常规', '常规', 'risk_inspection_method', NULL, 'info',    'N', 103, 1, NOW(), NULL),
  (2, '扫码', '扫码', 'risk_inspection_method', NULL, 'primary', 'N', 103, 1, NOW(), NULL);

-- 5) 巡检周期
INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, remark) VALUES
  (12229, '000000', '巡检周期', 'risk_inspection_cycle', 103, 1, NOW(), '巡检任务-巡检周期');
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark) VALUES
  (1, '每日', '每日', 'risk_inspection_cycle', NULL, 'primary', 'N', 103, 1, NOW(), NULL),
  (2, '每周', '每周', 'risk_inspection_cycle', NULL, 'success', 'N', 103, 1, NOW(), NULL),
  (3, '每月', '每月', 'risk_inspection_cycle', NULL, 'warning', 'N', 103, 1, NOW(), NULL);

-- 6) 巡检项类型
INSERT INTO sys_dict_type(dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, remark) VALUES
  (12230, '000000', '巡检项类型', 'risk_inspection_item_type', 103, 1, NOW(), '巡检任务项-类型');
INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark) VALUES
  (1, '安全', '安全', 'risk_inspection_item_type', NULL, 'danger',  'N', 103, 1, NOW(), NULL),
  (2, '卫生', '卫生', 'risk_inspection_item_type', NULL, 'info',    'N', 103, 1, NOW(), NULL),
  (3, '设备', '设备', 'risk_inspection_item_type', NULL, 'primary', 'N', 103, 1, NOW(), NULL),
  (4, '其他', '其他', 'risk_inspection_item_type', NULL, 'default', 'N', 103, 1, NOW(), NULL);