
--首页布局预置
DELETE FROM t_bas_mainpagelayout WHERE FID = 602143643725223936;
INSERT INTO t_bas_mainpagelayout(FID,FCREATORID,FDISABLETIME,FDISABLERID,FTYPE,FCUSTOMABLE,FMODIFYTIME,FLAYOUT,FCREATETIME,FNUMBER,FFORMNUM,FISPRESET,FMODIFIERID,FBIZAPPID,FSCHEMETYPE,FENABLE,FUSERID,FMASTERID) VALUES (602143643725223936,0,null,0,'app','1',{ts'2018-08-08 18:08:00'},'[{"w":12,"h":1,"x":0,"y":0,"i":"601894153932004352","moved":false,"static":false},{"w":6,"h":1,"x":0,"y":1,"i":"601894744146095104","moved":false,"static":false},{"w":12,"h":2,"x":0,"y":3,"i":"602159123483613184","moved":false,"static":false},{"w":6,"h":1,"x":6,"y":1,"i":"648438319750843392","moved":false,"static":false},{"w":4,"h":1,"x":8,"y":2,"i":"664643291412696064","moved":false,"static":false},{"w":4,"h":1,"x":0,"y":2,"i":"664654852793568256","moved":false,"static":false},{"w":4,"h":1,"x":4,"y":2,"i":"664655722339922944","moved":false,"static":false}]',null,' ',' ','1',13466739,'/JJVQ13HQZAJ','1','1',1,0); 

DELETE FROM t_bas_mainpagelayout_l WHERE FPKID = '602143643725223936';
INSERT INTO t_bas_mainpagelayout_l(FID,FPKID,FLOCALEID,FNAME) VALUES (602143643725223936,'602143643725223936','zh_CN','销售管理应用首页默认方案'); 

--卡片方案预置
DELETE FROM t_bas_cardconfig WHERE FID = 742490291675606016;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (742490291675606016,'bos_card_quicklaunch',601894153932004352,602143643725223936,0,'{"cardType":"bos_card_quicklaunch","config":{"/U5/8/L=ML9K":{"cache_sel_appId":"/JJVQ13HQZAJ","cache_sel_menuId":"/U5/8/L=ML9K","launchType":"launchType_menu"},"0+V0A/FV05OX":{"cache_sel_appId":"/JJVQ13HQZAJ","cache_sel_menuId":"0+V0A/FV05OX","launchType":"launchType_menu"},"0/MSB64Y6R7Y":{"cache_sel_appId":"/JJVQ13HQZAJ","cache_sel_menuId":"0/MSB64Y6R7Y","launchType":"launchType_menu"}}}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 742490291675606017;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (742490291675606017,'bos_card_billstats_list',601894744146095104,602143643725223936,0,'{"cardType":"bos_card_billstats_list","config":{"1":{"appnum":"sm","datatype":"count","filterschema":"/VXLY94PPO/7","scale":"0","filterclass":" ","menuid":"/V3R=D+X6YKD","entityid":"sm_salorder","numtitle":"f:customname","numcolor":"#FF903D"},"2":{"appnum":"sm","datatype":"count","filterschema":"/VXMKVTJPOJT","scale":"0","filterclass":" ","menuid":"/V3R=D+X6YKD","entityid":"sm_salorder","numtitle":"f:customname","numcolor":"#E1453E"}}}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 742490291675606018;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (742490291675606018,'bos_card_custom',602159123483613184,602143643725223936,0,'{"cardformnum":"sm_card_orderamountanaly","cardType":"bos_card_custom","cardformname":"订单金额"}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 742490291675606020;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (742490291675606020,'bos_card_custom',664643291412696064,602143643725223936,0,'{"cardformnum":"sm_card_orderyearamount","cardType":"bos_card_custom","cardformname":"年销售金额"}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 742490291675606021;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (742490291675606021,'bos_card_custom',664654852793568256,602143643725223936,0,'{"cardformnum":"sm_card_ordermouthamount","cardType":"bos_card_custom","cardformname":"当月销售金额"}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 742490291675606022;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (742490291675606022,'bos_card_custom',664655722339922944,602143643725223936,0,'{"cardformnum":"sm_card_orderquaramount","cardType":"bos_card_custom","cardformname":"季度销售金额"}'); 
DELETE FROM t_bas_cardconfig WHERE FID = 742490291675606019;
INSERT INTO t_bas_cardconfig(FID,FTYPE,FCARDID,FMAINPAGEID,FUSERID,FCONFIG) VALUES (742490291675606019,'bos_card_billstats_list',648438319750843392,602143643725223936,0,'{"cardType":"bos_card_billstats_list","config":{"1":{"appnum":"sm","datatype":"count","filterschema":"0/MJ00RYXDSD","scale":"0","filterclass":" ","menuid":"/Z0VQCPO2DC3","entityid":"sm_delivernotice","numtitle":"f:customname","numcolor":"#FF903D"},"2":{"appnum":"sm","datatype":"count","filterschema":"0/MJ0XHU3O5B","scale":"0","filterclass":" ","menuid":"/Z0VQCPO2DC3","entityid":"sm_delivernotice","numtitle":"f:customname","numcolor":"#E1453E"}}}'); 

DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW/';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606016,'0A6630GNIMW/','en_US','Quick Launch'); 
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW0';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606016,'0A6630GNIMW0','zh_CN','快速发起'); 
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW+';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606016,'0A6630GNIMW+','zh_TW','快速發起'); 

DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW2';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606017,'0A6630GNIMW2','en_US','Card Title'); 
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW3';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES ('待提交,待审核',742490291675606017,'0A6630GNIMW3','zh_CN','销售订单'); 
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW1';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606017,'0A6630GNIMW1','zh_TW','銷售訂單'); 

DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW5';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606018,'0A6630GNIMW5','zh_CN','订单金额'); 
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW4';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606018,'0A6630GNIMW4','zh_TW','訂單金額'); 

DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW9';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606020,'0A6630GNIMW9','zh_CN','当年销售金额'); 
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW8';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606020,'0A6630GNIMW8','zh_TW','當年銷售金額'); 

DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMWA';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606021,'0A6630GNIMWA','zh_CN','当月销售金额'); 
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW=';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606021,'0A6630GNIMW=','zh_TW','當月銷售金額'); 

DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMWC';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606022,'0A6630GNIMWC','zh_CN','当季销售金额'); 
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMWB';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606022,'0A6630GNIMWB','zh_TW','當季銷售金額'); 

DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW7';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES ('待提交,待审核',742490291675606019,'0A6630GNIMW7','zh_CN','发货通知'); 
DELETE FROM T_BAS_CARDCONFIG_L WHERE FPKID = '0A6630GNIMW6';
INSERT INTO T_BAS_CARDCONFIG_L(FCUSTOMNAME,FID,FPKID,FLOCALEID,FCARDTITLE) VALUES (' ',742490291675606019,'0A6630GNIMW6','zh_TW','發貨通知'); 

