salix/db/routines/vn/triggers/payment_afterInsert.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` TRIGGER `vn`.`payment_afterInsert`
	AFTER INSERT ON `payment`
	FOR EACH ROW
BEGIN
	DECLARE vIsPayMethodChecked BOOLEAN;
	DECLARE vEmail VARCHAR(150);
		
	SELECT isPayMethodChecked INTO vIsPayMethodChecked
			FROM supplier
			WHERE id = NEW.supplierFk;
			
	
	IF vIsPayMethodChecked = FALSE THEN

		SELECT notificationEmail INTO vEmail
			FROM department
				WHERE name = 'FINANZAS';

        CALL mail_insert(
			vEmail,
       		NULL,
       		'Pago con método sin verificar',
       		CONCAT(
				'Se ha realizado el pago ',
				NEW.id,
       			' al proveedor ',
       			NEW.supplierFk,
       			' con el método de pago sin verificar.'
       		)
       	);
    END IF;
END$$
DELIMITER ;