trigger_ar_payment.sql

CREATE OR REPLACE FUNCTION update_ar_payment() RETURNS TRIGGER
LANGUAGE plpgsql
AS
$$
BEGIN
    INSERT INTO sync_ar_payment (invoice_id, payment_id, tgl_bayar)
        VALUES (NEW.ar_invoice_id, NEW.id, NEW.tgl_bayar);
    RETURN NEW;
END
$$;

CREATE OR REPLACE FUNCTION delete_ar_payment() RETURNS TRIGGER
LANGUAGE plpgsql
AS
$$
BEGIN
    INSERT INTO sync_ar_payment (invoice_id, payment_id, tgl_bayar)
        VALUES (OLD.ar_invoice_id, OLD.id, OLD.tgl_bayar);
    RETURN OLD;
END
$$;

CREATE TRIGGER update_ar_payment
    AFTER INSERT OR UPDATE
    ON webr.ar_payment
    FOR EACH ROW EXECUTE PROCEDURE update_ar_payment();

CREATE TRIGGER delete_ar_payment
    AFTER DELETE
    ON webr.ar_payment
    FOR EACH ROW EXECUTE PROCEDURE delete_ar_payment();