--更新payment 的status,orderid,issue 触发
CREATE OR REPLACE TRIGGER "UPDATE_ORDER_STATUS_ISSUE"
AFTER UPDATE OF STATUS, ORDERID, ISSUE ON PAYMENT
FOR EACH ROW
BEGIN
IF :OLD.STATUS != :NEW.STATUS THEN
UPDATE ORDER
SET PAYMENTSTATUS = :NEW.STATUS
WHERE ORDERID = :NEW.ORDERID;
ELSIF :OLD.ISSUE != :NEW.ISSUE THEN
UPDATE ORDER
SET PAYMENTISSUE = :NEW.ISSUE
WHERE ORDERID = :NEW.ORDERID;
END IF;
CREATE OR REPLACE TRIGGER INSERT_REFUND_FLIGHTNO
AFTER INSERT ON REFUND
FOR EACH ROW
BEGIN
UPDATE ORDERPASSAGER BP
SET BP.REFUNDFLIGHTNO = :NEW.FLIGHTNO
WHERE BP.ORDERID = :NEW.ORDERID
AND BP.FOID = :NEW.FOID;
CREATE OR REPLACE TRIGGER "UPDATE_ORDER_STATUS_ISSUE"
AFTER UPDATE OF STATUS, ORDERID, ISSUE ON PAYMENT
FOR EACH ROW
BEGIN
IF :OLD.STATUS != :NEW.STATUS THEN
UPDATE ORDER
SET PAYMENTSTATUS = :NEW.STATUS
WHERE ORDERID = :NEW.ORDERID;
ELSIF :OLD.ISSUE != :NEW.ISSUE THEN
UPDATE ORDER
SET PAYMENTISSUE = :NEW.ISSUE
WHERE ORDERID = :NEW.ORDERID;
END IF;
END;
CREATE OR REPLACE TRIGGER INSERT_REFUND_FLIGHTNO
AFTER INSERT ON REFUND
FOR EACH ROW
BEGIN
UPDATE ORDERPASSAGER BP
SET BP.REFUNDFLIGHTNO = :NEW.FLIGHTNO
WHERE BP.ORDERID = :NEW.ORDERID
AND BP.FOID = :NEW.FOID;
END;