6f638734
 “wangming”
可以下班了，加油，冲
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
-- 外勤规则初始数据（可按环境重复执行：已存在则跳过）
INSERT INTO `lq_attendance_field_work_rule` (
`F_Id`, `F_RuleName`, `F_WorkStartTime`, `F_WorkEndTime`, `F_IsEnabled`, `F_Remark`,
`F_SortCode`, `F_CreateTime`, `F_DeleteMark`, `F_VersionNo`, `F_LastModifyTime`
)
SELECT '1980080509000000001', '总部外勤', '09:00', '18:00', 1, '初始数据：总部外勤标准',
1, NOW(), 0, 1, NOW()
FROM DUAL
WHERE NOT EXISTS (
SELECT 1 FROM `lq_attendance_field_work_rule` WHERE `F_Id` = '1980080509000000001'
);
INSERT INTO `lq_attendance_field_work_rule` (
`F_Id`, `F_RuleName`, `F_WorkStartTime`, `F_WorkEndTime`, `F_IsEnabled`, `F_Remark`,
`F_SortCode`, `F_CreateTime`, `F_DeleteMark`, `F_VersionNo`, `F_LastModifyTime`
)
SELECT '1980080509300000002', '事业外勤', '09:30', '19:00', 1, '初始数据：事业外勤标准',
2, NOW(), 0, 1, NOW()
FROM DUAL
WHERE NOT EXISTS (
SELECT 1 FROM `lq_attendance_field_work_rule` WHERE `F_Id` = '1980080509300000002'
);
|
