通过关联创建单据实现自动驳回

一、demo脚本

DROP PROCEDURE IF EXISTS `ldcrm_bohuio_by_addbill`;
delimiter ||
CREATE  PROCEDURE `ldcrm_bohuio_by_addbill`(
    tmp_billid INT(19)
)
BEGIN
    
    UPDATE ld_salesorder SET approvestatus='已驳回',approveby=NULL,currentapprover=NULL,currentapprovestepid=NULL WHERE salesorderid=tmp_billid;

    INSERT INTO ld_approvelog(
    id,
    description,
    crmid,
    approveid,
    stepid,

    approved_by,
    approveresult,
    createdtime,
    nextstepid
    )
    SELECT
        IFNULL((SELECT MAX(id)+1 FROM ld_approvelog),1),
        '通过关联创建单据自动驳回',
        tmp_billid,
        NULL,
        NULL,

        1,
        4,
        NOW(),
        NULL;

    UPDATE ld_approvelog_seq SET id=(SELECT MAX(id) FROM ld_approvelog);

end ||
delimiter;

-- CALL ldcrm_bohuio_by_addbill('{Record.ID}')
 

通过创建单据驳回.sql