계약일 이중저장 불일치 보정 절차 (배포 전)

docker exec simplehr-prod-postgres psql -U simplehr_prod -d simplehr_prod -c "
SELECT e.id, u.name, e.contract_type, e.contract_end_date
FROM employees e
JOIN users u ON u.id = e.user_id
WHERE e.contract_end_date IS NOT NULL
  AND NOT EXISTS (
    SELECT 1 FROM employee_contracts ec
    WHERE ec.employee_id = e.id
      AND ec.status != 'CANCELLED'
  );"

docker exec simplehr-prod-postgres psql -U simplehr_prod -d simplehr_prod -c "
SELECT e.id, u.name,
       e.contract_end_date::date AS employee_end,
       ec.end_date::date AS contract_end,
       ec.id AS ec_id
FROM employees e
JOIN users u ON u.id = e.user_id
JOIN employee_contracts ec ON ec.employee_id = e.id
  AND ec.status != 'CANCELLED'
WHERE e.contract_end_date IS NOT NULL
  AND ec.end_date::date != e.contract_end_date::date;"

-- 예시 (직원 ID, tenant_id 확인 후 실행)
-- INSERT INTO employee_contracts (
--   id, tenant_id, employee_id, contract_number, contract_type,
--   start_date, end_date, status, created_at, updated_at
-- ) VALUES (
--   gen_random_uuid(), '테넌트ID', '직원ID', 'MANUAL-001',
--   '계약유형', '입사일', '만료일', 'ACTIVE', now(), now()
-- );

-- 최신 계약(created_at DESC)의 end_date만 업데이트
-- 2단계 쿼리 결과의 ec_id를 사용
-- UPDATE employee_contracts
-- SET end_date = '2026-07-31', updated_at = now()
-- WHERE id = 'ec_id값';

docker exec simplehr-prod-postgres psql -U simplehr_prod -d simplehr_prod -c "
SELECT count(*)
FROM employees e
JOIN employee_contracts ec ON ec.employee_id = e.id
  AND ec.status != 'CANCELLED'
WHERE e.contract_end_date IS NOT NULL
  AND ec.end_date::date != e.contract_end_date::date;"