1

https://iai.aichatos8.com.cn/#/home?from=lg

select build_version from v$instance

CREATE OR REPLACE TRIGGER AAAA_updatehttx
AFTER UPDATE ON uf_htglseyy
FOR EACH ROW
DECLARE
  vtxrqtyn NUMBER;
  vtxrq DATE;
  vrqsz NUMBER;
BEGIN
  -- 用于避免重复查询的逻辑封装成一个过程
  FOR rec IN (
    SELECT rqsz, txrqtyn, rqlx
    FROM uf_htlx l
    WHERE l.htxx = :NEW.ID AND l.rqlx IN (0, 1, 2, 3)
  ) LOOP
    -- 根据 rqlx 的值选择处理的字段
    IF rec.rqlx = 0 AND :OLD.qdrq <> :NEW.qdrq THEN
      vrqsz := NVL(rec.rqsz, 0);  -- 使用 NVL 确保 vrqsz 不为 NULL
      vtxrqtyn := NVL(rec.txrqtyn, 0);  -- 使用 NVL 确保 vtxrqtyn 不为 NULL
      IF vtxrqtyn = 0 THEN
        vtxrq := ADD_DAYS(:NEW.qdrq, vrqsz);
      ELSIF vtxrqtyn = 1 THEN
        vtxrq := ADD_MONTHS(:NEW.qdrq, vrqsz);
      ELSIF vtxrqtyn = 2 THEN
        vtxrq := ADD_MONTHS(:NEW.qdrq, vrqsz * 12);
      END IF;
      UPDATE uf_htlx l
      SET l.txrq = vtxrq
      WHERE l.htxx = :NEW.ID AND l.rqlx = 0;
    ELSIF rec.rqlx = 1 AND :OLD.cyrq <> :NEW.cyrq THEN
      vrqsz := NVL(rec.rqsz, 0);
      vtxrqtyn := NVL(rec.txrqtyn, 0);
      IF vtxrqtyn = 0 THEN
        vtxrq := ADD_DAYS(:NEW.cyrq, vrqsz);
      ELSIF vtxrqtyn = 1 THEN
        vtxrq := ADD_MONTHS(:NEW.cyrq, vrqsz);
      ELSIF vtxrqtyn = 2 THEN
        vtxrq := ADD_MONTHS(:NEW.cyrq, vrqsz * 12);
      END IF;
      UPDATE uf_htlx l
      SET l.txrq = vtxrq
      WHERE l.htxx = :NEW.ID AND l.rqlx = 1;
    ELSIF rec.rqlx = 2 AND :OLD.zqysrq <> :NEW.zqysrq THEN
      vrqsz := NVL(rec.rqsz, 0);
      vtxrqtyn := NVL(rec.txrqtyn, 0);
      IF vtxrqtyn = 0 THEN
        vtxrq := ADD_DAYS(:NEW.zqysrq, vrqsz);
      ELSIF vtxrqtyn = 1 THEN
        vtxrq := ADD_MONTHS(:NEW.zqysrq, vrqsz);
      ELSIF vtxrqtyn = 2 THEN
        vtxrq := ADD_MONTHS(:NEW.zqysrq, vrqsz * 12);
      END IF;
      UPDATE uf_htlx l
      SET l.txrq = vtxrq
      WHERE l.htxx = :NEW.ID AND l.rqlx = 2;
    ELSIF rec.rqlx = 3 AND :OLD.ysrq <> :NEW.ysrq THEN
      vrqsz := NVL(rec.rqsz, 0);
      vtxrqtyn := NVL(rec.txrqtyn, 0);
      IF vtxrqtyn = 0 THEN
        vtxrq := ADD_DAYS(:NEW.ysrq, vrqsz);
      ELSIF vtxrqtyn = 1 THEN
        vtxrq := ADD_MONTHS(:NEW.ysrq, vrqsz);
      ELSIF vtxrqtyn = 2 THEN
        vtxrq := ADD_MONTHS(:NEW.ysrq, vrqsz * 12);
      END IF;
      UPDATE uf_htlx l
      SET l.txrq = vtxrq
      WHERE l.htxx = :NEW.ID AND l.rqlx = 3;
    END IF;
  END LOOP;
END;

 

 

 

 

 

 

 

 

WfForm.getGlobalStore().commonParam.nodetype==0