DROP TRIGGER IF EXISTS TRI_BAS_MEMBER_LEASE_ORG_D_I;
DELIMITER $
CREATE TRIGGER FDP.TRI_BAS_MEMBER_LEASE_ORG_D_I
AFTER INSERT
ON FDP.BAS_MEMBER_LEASE_ORG_D
FOR EACH ROW
BEGIN
DECLARE ORG_TYPE_COPY CHAR(1);
SET ORG_TYPE_COPY = (SELECT
ORG_TYPE
FROM
FDP.MEMBER_LEASE_ORG_D
WHERE
ARTIFICIAL_FLAG = 1 AND
ORG_CODE = NEW.ORG_CODE
ORDER BY
LAST_MODIFY_DATET DESC
LIMIT
0, 1); -- 变量名不能和字段名相同
INSERT INTO
FDP.MEMBER_LEASE_ORG_D(
ORG_CODE
,ORG_CN_NAME
,ORG_SHORT_NAME
,ORG_EN_NAME
,EXCHANGE
,ORG_TYPE
,UNIQUE_ORG_CODE
,SCD_IND
,ARTIFICIAL_FLAG
,START_DATET
,END_DATET)
VALUES
(
NEW.ORG_CODE
,NEW.ORG_CN_NAME
,NEW.ORG_SHORT_NAME
,NEW.ORG_EN_NAME
,NEW.EXCHANGE
,IF(
ORG_TYPE_COPY
,NULL
,NEW.ORG_TYPE)
,NEW.UNIQUE_ORG_CODE
,NEW.SCD_IND
,0
,NEW.START_DATET
,NEW.END_DATET);
END;$
DELIMITER ;