| 12345678910111213141516171819202122 |
- INSERT INTO oa_holiday_management
- ( id, user_id, join_day, `status`, is_first, created_at, created_by, updated_at, updated_by )
-
- SELECT
- frame_user.id,
- frame_user.id AS user_id,
- IFNULL(
- frame_user.createdat,
- now()) AS join_day,
- 0 AS `status`,
- 1 AS is_first,
- now() AS created_at,
- '1' AS created_by,
- now() AS updated_at,
- '1' AS updated_by
- FROM
- frame_user
- LEFT JOIN oa_holiday_management ON oa_holiday_management.user_id = frame_user.id
- WHERE
- oa_holiday_management.user_id IS NULL
|
