
/** 供应协同应用首页预置数据，增加对账待办和对账待办 **/

/** 删除多余的数据 DELETE FROM t_bas_cardconfig WHERE FID = 1218653784469735425;**/

DELETE FROM t_bas_mainpagelayout WHERE FID = 1218716071788349440;
DELETE FROM t_bas_mainpagelayout WHERE FID = 425271562829090816;
INSERT INTO t_bas_mainpagelayout(FID,FCUSTOMABLE,FTYPE,FFORMNUM,FNUMBER,FDISABLETIME,FLAYOUT,FCREATETIME,FISMULTIORG,FENABLE,FMODIFIERID,FISPRESET,FBIZAPPID,FMODIFYTIME,FSCHEMETYPE,FCREATORID,FUSERID,FDISABLERID) VALUES (425271562829090816,'1','app',' ','425271562829090816',NULL,'[{"w":7,"h":1,"x":0,"y":1,"i":"417920263536040960","moved":false,"static":false},{"w":12,"h":1,"x":0,"y":0,"i":"417935274287356928","moved":false,"static":false},{"w":4,"h":1,"x":0,"y":2,"i":"1219555031011887104","moved":false,"static":false},{"w":3,"h":1,"x":4,"y":2,"i":"1219555383895568384","moved":false,"static":false}]',{ts'2021-08-09  00:00:00'},'1','1',1,'1','eae607fb000152ac',{ts'2021-08-10  00:00:00'},'1',1,0,0); 

DELETE FROM t_bas_mainpagelayout_l WHERE FPKID = '1TOQV54HV12/';
DELETE FROM t_bas_mainpagelayout_l WHERE FPKID = '425271562829090816';
INSERT INTO t_bas_mainpagelayout_l(FID,FPKID,FLOCALEID,FNAME) VALUES (425271562829090816,'425271562829090816','zh_CN','供应协同应用首页默认方案'); 

DELETE FROM t_bas_cardconfig WHERE FID = 1219556213948221442;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (1219556213948221442,'bos_card_billstats_list',1219555031011887104,425271562829090816,0,'{"cardType":"bos_card_billstats_list","config":{"1":{"appnum":"scp","datatype":"count","filterschema":"1TJ3R4L8V541","scale":"0","menuid":"JS5UIC9=TL9","entityid":"scp_check","numtitle":"f:customname","numcolor":"#FF903D"},"2":{"appnum":"scp","datatype":"count","filterschema":"1TJ3XSNOBNJ8","scale":"0","menuid":"JS5UIC9=TL9","entityid":"scp_check","numtitle":"f:customname","numcolor":"#FF903D"}}}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 1219556213948221443;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (1219556213948221443,'bos_card_billstats',1219555383895568384,425271562829090816,0,'{"appnum":"scp","datatype":"count","cardType":"bos_card_billstats","filterschema":"1TF=RC+X1/8+","scale":"0","menuid":"JS5WDQPRW4V","entityid":"scp_invoice","numtitle":"f:customname","numcolor":"#FF903D"}'); 



DELETE FROM t_bas_cardconfig_L WHERE FID = 1219556213948221442 AND FLOCALEID='zh_TW';
INSERT INTO t_bas_cardconfig_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1219556213948221442,'1TSRU93+6SMP','zh_TW',' ','對賬待辦'); 
DELETE FROM t_bas_cardconfig_L WHERE FID = 1219556213948221442 AND FLOCALEID='zh_CN';
INSERT INTO t_bas_cardconfig_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1219556213948221442,'1TSRU93+6SMQ','zh_CN','待确认,待开票','对账待办'); 

DELETE FROM t_bas_cardconfig_L WHERE FID = 1219556213948221443 AND FLOCALEID='zh_TW';
INSERT INTO t_bas_cardconfig_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1219556213948221443,'1TSRU93+6SMR','zh_TW',' ','開票待辦'); 
DELETE FROM t_bas_cardconfig_L WHERE FID = 1219556213948221443 AND FLOCALEID='zh_CN';
INSERT INTO t_bas_cardconfig_L(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (1219556213948221443,'1TSRU93+6SMS','zh_CN','待提交','开票待办'); 


