OAT » TA Admin

UPDATE recourseFilingDetails
SET stageCode = 55, stageDescription = 'Notificada', filingDate = (SELECT filingDate FROM recourseFilingDetails WHERE recourseFilingId = 2980 AND isDeleted = 0)
WHERE recourseFilingId = 3066 AND isDeleted = 0

INSERT INTO notifications (creatorId, recourseFilingId)
VALUES (1, 3066)

DECLARE @notificationId INT = SCOPE_IDENTITY()

INSERT INTO notificationDetails (creatorId, notificationId, statusCode, statusDescription, stageCode, stageDescription, typeCode, typeDescription)
SELECT 1, @notificationId, nd.statusCode, nd.statusDescription, nd.stageCode, nd.stageDescription, nd.typeCode, nd.typeDescription
FROM notifications n 
INNER JOIN notificationDetails nd ON nd.notificationId = n.notificationId AND nd.isDeleted = 0
WHERE n.recourseFilingId = 2980

INSERT INTO notificationDocuments (creatorId, notificationId)
VALUES (1, @notificationId)

DECLARE @documentId INT = SCOPE_IDENTITY()

INSERT INTO notificationDocumentDetails (notificationDocumentId, documentRoleCode, documentRoleDescription, documentTypeCode, documentTypeDescription, description, url, fileExtension, fileName, hash, creatorId, filePageCount)
SELECT @documentId, ndd.documentRoleCode, ndd.documentRoleDescription, ndd.documentTypeCode, ndd.documentTypeDescription, ndd.description, ndd.url, ndd.fileExtension, ndd.fileName, ndd.hash, 1, ndd.filePageCount
FROM notifications n 
INNER JOIN notificationDocuments nd ON nd.notificationId = n.notificationId AND nd.isDeleted = 0
INNER JOIN notificationDocumentDetails ndd ON ndd.notificationDocumentId = nd.notificationDocumentId AND ndd.isDeleted = 0
WHERE n.recourseFilingId = 2980

SELECT @documentId notificationDocumentId, @notificationId notificationId