-- 生产任务管理 - 首页卡片预置脚本
--zhaohui_zeng  2019-11-28

DELETE FROM t_bas_mainpagelayout WHERE FID = 923898190342806528;
INSERT INTO t_bas_mainpagelayout(FID,FCUSTOMABLE,FTYPE,FFORMNUM,FMASTERID,FNUMBER,FDISABLETIME,FLAYOUT,FCREATETIME,FISMULTIORG,FENABLE,FMODIFIERID,FISPRESET,FBIZAPPID,FMODIFYTIME,FSCHEMETYPE,FCREATORID,FUSERID,FDISABLERID) VALUES (923898190342806528,'1','app',' ',0,'HP-000014',NULL,'[{"w":3,"h":1,"x":0,"y":0,"i":"923890745671310336","moved":false,"static":false},{"w":5,"h":1,"x":3,"y":0,"i":"930905139902942208","moved":false,"static":false},{"w":4,"h":1,"x":8,"y":0,"i":"930905193053162496","moved":false,"static":false}]',{ts'2020-08-18  00:00:00'},'1','1',0,'0','0MBB4=9D3YI9',NULL,'1',1,0,0); 

DELETE FROM t_bas_mainpagelayout_l WHERE FPKID = '0WG=D=H5IY76';
INSERT INTO t_bas_mainpagelayout_l(FID,FPKID,FLOCALEID,FNAME) VALUES (923898190342806528,'0WG=D=H5IY76','zh_CN','需求管理应用首页默认方案'); 

DELETE FROM t_bas_cardconfig WHERE FID = 930944917969046528;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (930944917969046528,'bos_card_quicklaunch',923890745671310336,923898190342806528,0,'{"cardType":"bos_card_quicklaunch","config":{"0OI5L6S/AYWB":{"cache_sel_appId":"0MBB4=9D3YI9","cache_sel_menuId":"0OI5L6S/AYWB","launchType":"launchType_menu"},"0OI5OKYQRRYZ":{"cache_sel_appId":"0MBB4=9D3YI9","cache_sel_menuId":"0OI5OKYQRRYZ","launchType":"launchType_menu"}}}'); 

DELETE FROM t_bas_cardconfig WHERE FID = 930944917969046529;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (930944917969046529,'bos_card_billstats_list',930905139902942208,923898190342806528,0,'{"cardType":"bos_card_quicklaunch","config":{"0PW9A0LP6G=J":{"cache_sel_appId":"0MBB4=9D3YI9","cache_sel_menuId":"0PW9A0LP6G=J","launchType":"launchType_menu"},"0OT7VRHLM27=":{"cache_sel_appId":"0MBB4=9D3YI9","cache_sel_menuId":"0OT7VRHLM27=","launchType":"launchType_menu"},"0Q=UYK4/97R1":{"cache_sel_appId":"0MBB4=9D3YI9","cache_sel_menuId":"0Q=UYK4/97R1","launchType":"launchType_menu"}}}'); 

DELETE FROM t_bas_cardconfig WHERE FID = 930944917969046530;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (930944917969046530,'bos_card_billstats_list',930905193053162496,923898190342806528,0,'{"cardType":"bos_card_quicklaunch","config":{"0Q11OMHK3VO0":{"cache_sel_appId":"0MBB4=9D3YI9","cache_sel_menuId":"0Q11OMHK3VO0","launchType":"launchType_menu"},"0Q11SYR3+GLA":{"cache_sel_appId":"0MBB4=9D3YI9","cache_sel_menuId":"0Q11SYR3+GLA","launchType":"launchType_menu"},"0UYXBQO72SCE":{"cache_sel_appId":"0MBB4=9D3YI9","cache_sel_menuId":"0UYXBQO72SCE","launchType":"launchType_menu"}}}'); 

DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0XB10OFW1MHJ';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (930944917969046528,'0XB10OFW1MHJ','zh_CN',' ','基础资料'); 

DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0XB10OFW1MHI';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (930944917969046528,'0XB10OFW1MHI','zh_TW',' ','基礎資料'); 

DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0XB10OFW1MHL';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (930944917969046529,'0XB10OFW1MHL','zh_CN',' ','预测'); 

DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0XB10OFW1MHK';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (930944917969046529,'0XB10OFW1MHK','zh_TW',' ','預測'); 

DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0XB10OFW1MHN';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (930944917969046530,'0XB10OFW1MHN','zh_CN',' ','需求计划'); 

DELETE FROM t_bas_cardconfig_l WHERE FPKID = '0XB10OFW1MHM';
INSERT INTO t_bas_cardconfig_l(FID,FPKID,FLOCALEID,FCUSTOMNAME,FCARDTITLE) VALUES (930944917969046530,'0XB10OFW1MHM','zh_TW',' ','需求計劃'); 


