自定义表单源单类型增加报价单

一、demo脚本

-- 插入 源单类型选项
SET @modulename='CustomForm45';            -- 模块
SET @select_module='Quotes';            -- 选择的模块
SET @withdetail='yes';                    -- 是否带源单产品明细 yes / no

SET @tabid=(SELECT tabid FROM ld_tab WHERE `name`=@modulename);
SET @select_tabid=(SELECT tabid FROM ld_tab WHERE `name`=@select_module);

SET @select_seq=(SELECT COUNT(1) FROM ld_option_module WHERE tabid=@tabid);
SET @select_tabseq=(SELECT tabsequence FROM ld_tab WHERE `name`=@select_module);
INSERT INTO ld_option_module(tabid,option_tabid,presence,approve_demand,sequence,table_sequence,datarang,fieldname,maxrowsshow,withdetail)
SELECT @tabid,@select_tabid,0,0,@select_seq+1,@select_tabseq,'all','source_list',10,@withdetail FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM ld_option_module WHERE tabid=@tabid AND option_tabid=@select_tabid);
delimiter;

自定义表单源单类型增加报价单.sql