OFS Procedure

OFS Procedure 8

ePrintLoop za RDP usere

CREATE TRIGGER trg_tHE_Move_Block
ON tHE_Move
AFTER UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
-- U slučaju DELETE ili UPDATE provjeravamo acKey
IF EXISTS (
SELECT 1
FROM deleted d
JOIN fiscalResponse f ON f.acKey = d.acKey
WHERE f.invoiceNumber IS NOT NULL AND LTRIM(RTRIM(f.invoiceNumber)) <> '')
BEGIN
RAISERROR('Brisanje ili izmjena u tHE_Move nije dozvoljena jer postoji povezan invoiceNumber u fiscalResponse.', 16, 1);
ROLLBACK TRANSACTION;
END
END;

CREATE TRIGGER trg_tHE_MoveItem_Block
ON tHE_MoveItem
AFTER UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
-- Zabrana brisanja ako postoji fiscalResponse
IF EXISTS (SELECT 1 FROM deleted d JOIN fiscalResponse f ON f.acKey = d.acKey WHERE f.invoiceNumber IS NOT NULL AND LTRIM(RTRIM(f.invoiceNumber)) <> '')
BEGIN
RAISERROR('Brisanje u tHE_MoveItem nije dozvoljeno jer postoji povezan invoiceNumber u fiscalResponse.', 16, 1);
ROLLBACK TRANSACTION;
RETURN;
END;

IF UPDATE(acIdent) OR UPDATE(anQty)
BEGIN
IF EXISTS (SELECT 1 FROM deleted d JOIN fiscalResponse f ON f.acKey = d.acKey WHERE f.invoiceNumber IS NOT NULL AND LTRIM(RTRIM(f.invoiceNumber)) <> '')
BEGIN
RAISERROR('Izmjena acIdent ili anQty u tHE_MoveItem nije dozvoljena jer postoji povezan invoiceNumber u fiscalResponse.', 16, 1);
ROLLBACK TRANSACTION;
END
END
END;