|
|
服务合同和派工单的相关信息设置中如何显示费用报销单？
打开navicat工具，新建查询，运行下面的sql语句
navicat数据库管理工具可以从官网 https://71mis.com/download/tools/ 下载，下载好后解压
select tabid into @tabid from ld_tab where name='project';
select max(relation_id) into @relation_id from ld_relatedlists;
update ld_relatedlists_seq set id=@relation_id+1
where not exists (select 1 from ld_relatedlists where tabid=@tabid and related_tabid=67)
and exists(select * from ld_option_module where tabid=67 and option_tabid=@tabid);
insert into ld_relatedlists(relation_id,tabid,related_tabid,`name`,sequence,label,presence,actions,type,related_coltable)
select @relation_id+1,@tabid,67,'get_expense',11,'Expense',1,'add','datacategory_sql','expensedetail.entitytypeid' from dual
where not exists (select 1 from ld_relatedlists where tabid=@tabid and related_tabid=67) and exists(select * from ld_option_module where tabid=67 and option_tabid=@tabid);
delimiter;
select tabid into @tabid from ld_tab where name='projecttask';
select max(relation_id) into @relation_id from ld_relatedlists;
update ld_relatedlists_seq set id=@relation_id+1 where not exists (select 1 from ld_relatedlists where tabid=@tabid and related_tabid=67) and exists(select * from ld_option_module where tabid=67 and option_tabid=@tabid);
insert into ld_relatedlists(relation_id,tabid,related_tabid,`name`,sequence,label,presence,actions,type,related_coltable)
select @relation_id+1,@tabid,67,'get_expense',12,'Expense',1,'add','datacategory_sql','expensedetail.entitytypeid' from dual
where not exists (select 1 from ld_relatedlists where tabid=@tabid and related_tabid=67)
and exists(select * from ld_option_module where tabid=67 and option_tabid=@tabid);
delimiter;
服务合同和派工单相关信息设置显示费用报销单.sql
(1.55 KB, 下载次数: 542)
|
|
楼主
