Work Order Status Change

{
  "CompanyId": "COMP01",
  "lang": "zh_TW",
  "wo_no": "5101-20260319001",
  "status": "1"  // Delete
}

{
  "CompanyId": "COMP01",
  "lang": "zh_TW",
  "wo_no": "5101-20260319001",
  "status": "2"  // Close
}

{
  "CompanyId": "COMP01",
  "lang": "zh_TW",
  "wo_no": "5101-20260319001",
  "status": "3"  // Reopen
}

{
  "code": "200",
  "msg": "success"
}

{
  "code": "500",
  "msg": "JS_0126_00062"
}

{
  "code": "500",
  "msg": "JS_0115_00014"
}

{
  "code": "500",
  "msg": "JS_0126_00059"
}

-- Check if already released (cannot delete if released)
SELECT COUNT(*) FROM SFT_WS_RUN WITH (NOLOCK)
WHERE ID = N'{wo_no}'
  AND EXECUTETYPE = 'release'
  AND PLUSINDEX = '0'
-- If COUNT > 0, throw JS_0126_00062

-- Check for split batch records
SELECT COUNT(*) FROM SFT_BATCH_REC WHERE BR001 = N'{wo_no}'
-- If COUNT > 0, throw remind_004

-- Delete related data (execute in order)
DELETE FROM SFT_OP_REALRUN WHERE ID = :CMOID
DELETE FROM LOT WHERE MOID = :CMOID
DELETE FROM MODETAIL WHERE CMOID = :CMOID
DELETE FROM SFT_SPEC_MODIREC WHERE MD001 = :CMOID
DELETE FROM SFT_BATCH_REC WHERE BR002 = :CMOID
DELETE FROM EQUIPMENT_RUN WHERE LOTID = :CMOID
DELETE FROM SFT_WS_RUN WHERE ID = :CMOID
DELETE FROM SFT_SPLITOUT_REC WHERE SSR001 = :CMOID
DELETE FROM SFT_ASSEMBLY_REC WHERE SAR001 = :CMOID
DELETE FROM SFT_HOLD_REC WHERE HR001 = :CMOID
DELETE FROM SFT_MO_MODI WHERE MODI002 = :CMOID

-- Check if order is on hold
jsonQueryFactory.sqlQuery_checkMoidIsHold(dataObject)
-- If on hold, throw JS_0115_00014

-- Check for incomplete operations
jsonQueryFactory.checkHaveUndoneOp(dataObject)
-- If has incomplete ops, throw JS_0115_00017

-- Execute close flow (handled by JsonQueryFactory)
-- Update MODETAIL.STATUS = 99
UPDATE MODETAIL SET
    STATUS = 99,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{current_time}'
WHERE CMOID = :CMOID

-- Check if order is closed
SELECT COUNT(*) FROM MODETAIL WITH (NOLOCK)
WHERE CMOID = N'{wo_no}'
  AND STATUS NOT IN ('99', '100')
-- If COUNT > 0, not closed, throw JS_0126_00059

-- Restore closed status (reverse close flow)
-- Determine restore status based on SFT_WS_RUN check-in records
UPDATE MODETAIL SET
    STATUS = CASE
        WHEN (SELECT COUNT(1) FROM SFT_WS_RUN WITH (NOLOCK)
              WHERE ID = N'{wo_no}' AND EXECUTETYPE = 'checkIn') > 0
        THEN 2  -- Has check-in record → In Progress
        ELSE 1  -- No check-in record → Not Started
    END,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{current_time}'
WHERE CMOID = :CMOID