费用报销添加关联源单类型

一、demo脚本

-- 插入 源单类型选项
SET @modulename='Expense';                -- 模块
SET @select_module='NormalApprove';        -- 选择的模块
SET @withdetail=NULL;                    -- 是否带源单产品明细 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;

-- 被关联单据相关信息添加与关联单据的关联关系
SET @module='NormalApprove';
SET @related_module='Expense';
SET @actions='add';
SET @tabid=(SELECT tabid FROM ld_tab WHERE `name`=@module);
SET @rel_tabid=(SELECT tabid FROM ld_tab WHERE `name`=@related_module);
SET @relation_id=(SELECT MAX(relation_id) FROM ld_relatedlists);
SET @seq=(SELECT MAX(sequence) FROM ld_relatedlists WHERE tabid=@tabid);
INSERT INTO ld_relatedlists(relation_id,tabid,related_tabid,`name`,sequence,label,presence,actions,type,related_coltable)
SELECT @relation_id+1,@tabid,@rel_tabid,CONCAT('get_',LOWER(@related_module)),@seq+1,@related_module,0,@actions,'datacategory_sql','expensedetail.entitytypeid' FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM ld_relatedlists WHERE tabid=@tabid AND label=@related_module);

UPDATE ld_relatedlists_seq SET id=(SELECT MAX(relation_id) FROM ld_relatedlists);
delimiter;

 

 

 

SET @modulename='Expense';                -- 模块
SET @select_module='Campaigns';            -- 选择的模块
SET @withdetail=NULL;                    -- 是否带源单产品明细 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;

SET @module='Campaigns';
SET @related_module='Expense';
SET @actions='add';
SET @tabid=(SELECT tabid FROM ld_tab WHERE `name`=@module);
SET @rel_tabid=(SELECT tabid FROM ld_tab WHERE `name`=@related_module);
SET @relation_id=(SELECT MAX(relation_id) FROM ld_relatedlists);
SET @seq=(SELECT MAX(sequence) FROM ld_relatedlists WHERE tabid=@tabid);
INSERT INTO ld_relatedlists(relation_id,tabid,related_tabid,`name`,sequence,label,presence,actions,type,related_coltable)
SELECT @relation_id+1,@tabid,@rel_tabid,CONCAT('get_',LOWER(@related_module)),@seq+1,@related_module,0,@actions,'datacategory_sql','expensedetail.entitytypeid' FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM ld_relatedlists WHERE tabid=@tabid AND label=@related_module);

UPDATE ld_relatedlists_seq SET id=(SELECT MAX(relation_id) FROM ld_relatedlists);
delimiter;

费用报销关联源单类型添加.sql