触发器：报价单合计额回填到销售机会的预计成交
解决方法：
这个问题通过触发器可实现：当报价单有更新时，判断如果“合计”大于0，则更新与该报价单中对应的销售机会的“预计成交金额”=报价的合计
步骤：
1、打开navicat工具，找到灵当CRM数据库；
2、新建查询，复制下面的sql语句，并执行；
drop trigger if exists update_potential_amount_byquote;
delimiter ||
CREATE TRIGGER update_potential_amount_byquote BEFORE UPDATE ON ld_quotes
FOR EACH ROW
BEGIN
IF NEW.total>0 THEN
update ld_potential set ld_potential.amount=NEW.total where ld_potential.potentialid=OLD.potentialid;
END IF;
END ||
delimiter ;
delimiter ||
CREATE TRIGGER update_potential_amount_byquote BEFORE UPDATE ON ld_quotes
FOR EACH ROW
BEGIN
IF NEW.total>0 THEN
update ld_potential set ld_potential.amount=NEW.total where ld_potential.potentialid=OLD.potentialid;
END IF;
END ||
delimiter ;