CREATE PROCEDURE UpdateDate(idDeal INT(11), baseDate DATETIME)
BEGIN
    set @constDays = 15;
    set @newData = ADDDATE(baseDate, INTERVAL @constDays DAY);
    IF((SELECT datavencimento_negocio FROM negocio WHERE id_negocio=idDeal) < @newData) THEN
        UPDATE negocio SET datavencimento_negocio = @newData WHERE id_negocio=idDeal;
    END IF;
END

CREATE TRIGGER `negocioUpdateDateDeal_OnUpdate` AFTER UPDATE ON `negocio`
FOR EACH ROW  BEGIN
    IF (OLD.estagio_negocio != NEW.estagio_negocio) THEN
        CALL UpdateDate(NEW.id_negocio, now());
    END IF;
END;

CREATE TRIGGER `contratosUpdateDateDeal_OnInsert` AFTER INSERT ON `contratos`
FOR EACH ROW  BEGIN
    set @idNegocio = (SELECT n.id_negocio FROM negocio n, contratos_clientes cc WHERE cc.contrato=NEW.id AND cc.cliente=n.id_cliente AND NEW.imovel=n.id_imovel GROUP BY n.id_negocio LIMIT 1);
    IF ((@idNegocio IS NOT NULL)) THEN
        CALL UpdateDate(@idNegocio,  now());
    END IF;
END;