/*人人差旅首页方案调整*/
DELETE FROM T_BAS_CARDCONFIG_L WHERE FID IN (SELECT FID FROM T_BAS_CARDCONFIG WHERE FMAINPAGEID = 422128908339531776);	
DELETE FROM T_BAS_CARDCONFIG WHERE FMAINPAGEID = 422128908339531776;	
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 422128908339531776;	
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 422128908339531776;	
DELETE FROM T_BAS_MAINPAGELAYOUT WHERE FID = 422128908339531776;	
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '10V96P=Z+OU/';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (975865158062608384,'10V96P=Z+OU/','zh_CN',' ','快速发起'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '10V96P=Z+OU+';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (975865158062608384,'10V96P=Z+OU+','zh_TW',' ','快速發起'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '10V96P=Z+OU0';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (975865158062608385,'10V96P=Z+OU0','zh_CN','申请中,已审批,已完成','出差申请单'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '10V96P=Z+OU1';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (975865158062608386,'10V96P=Z+OU1','zh_CN','报销中,已完成','差旅报销单'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '10V96P=Z+OU2';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (975865158062608387,'10V96P=Z+OU2','zh_CN',' ','出差情况'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '10V96P=Z+OU4';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (975865158062608388,'10V96P=Z+OU4','zh_CN',' ','消息中心'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '10V96P=Z+OU3';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (975865158062608388,'10V96P=Z+OU3','zh_TW',' ','消息中心'); 
DELETE FROM t_bas_cardconfig WHERE FID = 975865158062608384;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (975865158062608384,'bos_card_quicklaunch',417809622468942848,422128908339531776,0,'{"cardType":"bos_card_quicklaunch","config":{"18X+5D+X9QZB":{"cache_sel_appId":"18XD+/5EDN8X","cache_sel_menuId":"18X+5D+X9QZB","launchType":"launchType_menu"},"18X+PXETXUWI":{"cache_sel_appId":"18XD+/5EDN8X","cache_sel_menuId":"18X+PXETXUWI","launchType":"launchType_menu"},"18X+JBJAZ6FZ":{"cache_sel_appId":"18XD+/5EDN8X","cache_sel_menuId":"18X+JBJAZ6FZ","launchType":"launchType_menu"},"/GX65/SHD8EF":{"cache_sel_appId":"18XD+/5EDN8X","cache_sel_menuId":"/GX65/SHD8EF","launchType":"launchType_menu"},"18X/L8LQAACP":{"cache_sel_appId":"18XD+/5EDN8X","cache_sel_menuId":"18X/L8LQAACP","launchType":"launchType_menu"}}}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 975865158062608385;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (975865158062608385,'bos_card_billstats_list',422129142708850688,422128908339531776,0,'{"cardType":"bos_card_billstats_list","config":{"1":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"GNB1K+LF/RT","entityname":"出差申请单","filterclass":" ","entityid":"er_tripreqbill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"出差申请单（申请中）"},"2":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"GNB55=20HP0","entityname":"出差申请单","filterclass":" ","entityid":"er_tripreqbill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"出差申请单（已审批）"},"3":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"F=NV1ZI26GR","entityname":"出差申请单","filterclass":" ","entityid":"er_tripreqbill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"出差申请单（已完成）"}}}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 975865158062608386;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (975865158062608386,'bos_card_billstats_list',422129788237402112,422128908339531776,0,'{"cardType":"bos_card_billstats_list","config":{"1":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"HQ6MA52HBC+","entityname":"差旅报销单","filterclass":" ","entityid":"er_tripreimbursebill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"差旅报销单（报销中）"},"2":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"HQ6P+1P41=9","entityname":"差旅报销单","filterclass":" ","entityid":"er_tripreimbursebill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"差旅报销单（已完成）"}}}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 975865158062608387;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (975865158062608387,'bos_card_custom',422130428128808960,422128908339531776,0,'{"cardformnum":"tra_tripinfo","cardType":"bos_card_custom","cardformname":"出差情况"}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 975865158062608388;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (975865158062608388,'bos_card_msgcenter',975865000809740288,422128908339531776,0,'{"cardType":"bos_card_msgcenter","config":{"1":{"cardType":"bos_card_msgcenter","nodeId":"toHandle","nodeText":"待办任务"},"2":{"cardType":"bos_card_msgcenter","nodeId":"handled","nodeText":"已办任务"}}}');DELETE FROM t_bas_mainpagelayout_l WHERE FPKID = '422128908339531776';
INSERT INTO t_bas_mainpagelayout_l(FID,FPKID,FLOCALEID,FNAME) VALUES (422128908339531776,'422128908339531776','zh_CN','人人差旅应用首页默认方案'); 
DELETE FROM t_bas_mainpagelayout WHERE FID = 422128908339531776;
INSERT INTO t_bas_mainpagelayout(FID,FCUSTOMABLE,FTYPE,FFORMNUM,FNUMBER,FDISABLETIME,FLAYOUT,FCREATETIME,FISMULTIORG,FENABLE,FMODIFIERID,FISPRESET,FBIZAPPID,FMODIFYTIME,FSCHEMETYPE,FCREATORID,FUSERID,FDISABLERID) VALUES (422128908339531776,'1','app',' ','422128908339531776',NULL,'[{"w":12,"h":1,"x":0,"y":0,"i":"417809622468942848","moved":false,"static":false},{"w":7,"h":1,"x":0,"y":1,"i":"422129142708850688","moved":false,"static":false},{"w":5,"h":1,"x":7,"y":1,"i":"422129788237402112","moved":false,"static":false},{"w":12,"h":3,"x":0,"y":2,"i":"422130428128808960","moved":false,"static":false},{"w":4,"h":1,"x":0,"y":5,"i":"975865000809740288","moved":false,"static":false}]',NULL,'1','1',170256,'1','18XD+/5EDN8X',{ts'2020-09-08  10:29:52'},'1',1,1,0); 


/*人人费用首页方案调整*/
DELETE FROM T_BAS_CARDCONFIG_L WHERE FID IN (SELECT FID FROM T_BAS_CARDCONFIG WHERE FMAINPAGEID = 422140624716735488);	
DELETE FROM T_BAS_CARDCONFIG WHERE FMAINPAGEID = 422140624716735488;	
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 422140624716735488;	
DELETE FROM T_BAS_MAINPAGELAYOUT_L WHERE FID = 422140624716735488;	
DELETE FROM T_BAS_MAINPAGELAYOUT WHERE FID = 422140624716735488;	
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0YS2G=8T9ZLC';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (942641337621055488,'0YS2G=8T9ZLC','zh_CN',' ','快速发起'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0YS2G=8T9ZLB';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (942641337621055488,'0YS2G=8T9ZLB','zh_TW',' ','快速發起'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0YS2G=8T9ZLD';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (942641337621055489,'0YS2G=8T9ZLD','zh_CN','申请中,已审批,未还款','借款单'); 
DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0YS2G=8T9ZLE';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (942641337621055490,'0YS2G=8T9ZLE','zh_CN','申请中,已审批,已付款','费用报销单'); 
DELETE FROM t_bas_cardconfig WHERE FID = 942641337621055488;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (942641337621055488,'bos_card_quicklaunch',417753503193144320,422140624716735488,0,'{"cardType":"bos_card_quicklaunch","config":{"18XICSU/14SY":{"cache_sel_appId":"18X6P1ZSXS44","cache_sel_menuId":"18XICSU/14SY","launchType":"launchType_menu"},"18XIG=4C6BCH":{"cache_sel_appId":"18X6P1ZSXS44","cache_sel_menuId":"18XIG=4C6BCH","launchType":"launchType_menu"},"18XIKSH1A6+W":{"cache_sel_appId":"18X6P1ZSXS44","cache_sel_menuId":"18XIKSH1A6+W","launchType":"launchType_menu"},"00105B3C7T82":{"cache_sel_appId":"18X6P1ZSXS44","cache_sel_menuId":"00105B3C7T82","launchType":"launchType_menu"},"0632O/+0GW2S":{"cache_sel_appId":"18X6P1ZSXS44","cache_sel_menuId":"0632O/+0GW2S","launchType":"launchType_menu"}}}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 942641337621055489;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (942641337621055489,'bos_card_billstats_list',422142296910242816,422140624716735488,0,'{"cardType":"bos_card_billstats_list","config":{"1":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"14IW1RSJD7/9","entityname":"借款单","filterclass":" ","entityid":"er_dailyloanbill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"借款单（申请中）"},"2":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"14IWB6U95CUO","entityname":"借款单","filterclass":" ","entityid":"er_dailyloanbill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"借款单（已审批）"},"3":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"14IWFWP/FL1L","entityname":"借款单","filterclass":" ","entityid":"er_dailyloanbill","numtitle":"f:customname","numcolor":"#E1453E","filterschemaname":"借款单（未还款）"}}}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 942641337621055490;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (942641337621055490,'bos_card_billstats_list',422143397059404800,422140624716735488,0,'{"cardType":"bos_card_billstats_list","config":{"1":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"14IWM7JPLAX4","entityname":"费用报销单","filterclass":" ","entityid":"er_dailyreimbursebill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"费用报销单（申请中）"},"2":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"14IWNYAENIFK","entityname":"费用报销单","filterclass":" ","entityid":"er_dailyreimbursebill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"费用报销单（已审批）"},"3":{"showentityname":"false","cardType":"bos_card_billstats_list","filterschema":"14IWP/N8OXK5","entityname":"费用报销单","filterclass":" ","entityid":"er_dailyreimbursebill","numtitle":"f:customname","numcolor":"#666666","filterschemaname":"费用报销单（已付款）"}}}');DELETE FROM t_bas_mainpagelayout_l WHERE FPKID = '422140624716735488';
INSERT INTO t_bas_mainpagelayout_l(FID,FPKID,FLOCALEID,FNAME) VALUES (422140624716735488,'422140624716735488','zh_CN','人人费用应用首页默认方案'); 
DELETE FROM t_bas_mainpagelayout WHERE FID = 422140624716735488;
INSERT INTO t_bas_mainpagelayout(FID,FCUSTOMABLE,FTYPE,FFORMNUM,FNUMBER,FDISABLETIME,FLAYOUT,FCREATETIME,FISMULTIORG,FENABLE,FMODIFIERID,FISPRESET,FBIZAPPID,FMODIFYTIME,FSCHEMETYPE,FCREATORID,FUSERID,FDISABLERID) VALUES (422140624716735488,'1','app',' ','422140624716735488',NULL,'[{"w":12,"h":1,"x":0,"y":0,"i":"417753503193144320","moved":false,"static":false},{"w":6,"h":1,"x":0,"y":1,"i":"422142296910242816","moved":false,"static":false},{"w":6,"h":1,"x":6,"y":1,"i":"422143397059404800","moved":false,"static":false}]',NULL,'1','1',170256,'1','18X6P1ZSXS44',{ts'2020-07-24  14:20:04'},'1',1,1,0); 
