DELETE FROM t_svc_printtpl_group WHERE fid = 1133393055341087744;
INSERT INTO t_svc_printtpl_group(fid,fcreatetime,fmodifierid,fenable,fmodifytime,fmasterid,fstatus,fcreatorid,fnumber) VALUES (1133393055341087744,{ts'2021-04-10  00:00:00'},13466739,'1',{ts'2021-05-19  00:00:00'},1133393055341087744,'C',13466739,'financial'); 
DELETE FROM t_svc_printtpl_group WHERE fid = 1133393162102900736;
INSERT INTO t_svc_printtpl_group(fid,fcreatetime,fmodifierid,fenable,fmodifytime,fmasterid,fstatus,fcreatorid,fnumber) VALUES (1133393162102900736,{ts'2021-04-11  00:00:00'},13466739,'1',{ts'2021-05-19  00:00:00'},1133393162102900736,'C',13466739,'The supply chain'); 
DELETE FROM t_svc_printtpl_group WHERE fid = 1159938572699042816;
INSERT INTO t_svc_printtpl_group(fid,fcreatetime,fmodifierid,fenable,fmodifytime,fmasterid,fstatus,fcreatorid,fnumber) VALUES (1159938572699042816,{ts'2021-04-12  00:00:00'},13466739,'1',{ts'2021-05-20  00:00:00'},1159938572699042816,'C',13466739,'The personnel'); 
DELETE FROM t_svc_printtpl_group WHERE fid = 1159942565315739648;
INSERT INTO t_svc_printtpl_group(fid,fcreatetime,fmodifierid,fenable,fmodifytime,fmasterid,fstatus,fcreatorid,fnumber) VALUES (1159942565315739648,{ts'2021-04-13  00:00:00'},13466739,'1',{ts'2021-05-20  00:00:00'},1159942565315739648,'C',13466739,'bill'); 
DELETE FROM t_svc_printtpl_group WHERE fid = 1159942761147794432;
INSERT INTO t_svc_printtpl_group(fid,fcreatetime,fmodifierid,fenable,fmodifytime,fmasterid,fstatus,fcreatorid,fnumber) VALUES (1159942761147794432,{ts'2021-04-14  00:00:00'},13466739,'1',{ts'2021-05-20  00:00:00'},1159942761147794432,'C',13466739,'other'); 

DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1J6ZLT/LWY8/';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1133393055341087744,'1J6ZLT/LWY8/','zh_TW','財務'); 
DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1J6ZLT/LWY8+';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1133393055341087744,'1J6ZLT/LWY8+','zh_CN','财务'); 
DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1J6ZMKBQ4A6W';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1133393162102900736,'1J6ZMKBQ4A6W','zh_CN','供应链'); 
DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1J6ZMKBQ4A6X';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1133393162102900736,'1J6ZMKBQ4A6X','zh_TW','供應鏈'); 
DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1MG4IZWAUMLH';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1159938572699042816,'1MG4IZWAUMLH','zh_CN','人事'); 
DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1MG4IZWAUMLI';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1159938572699042816,'1MG4IZWAUMLI','zh_TW','人事'); 
DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1MG5=D/KDN0=';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1159942565315739648,'1MG5=D/KDN0=','zh_CN','票据类'); 
DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1MG5=D/KDN0A';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1159942565315739648,'1MG5=D/KDN0A','zh_TW','票據類'); 
DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1MG5AMR9BGEM';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1159942761147794432,'1MG5AMR9BGEM','zh_CN','其他'); 
DELETE FROM t_svc_printtpl_group_l WHERE fpkid = '1MG5AMR9BGEN';
INSERT INTO t_svc_printtpl_group_l(fid,fpkid,flocaleid,fname) VALUES (1159942761147794432,'1MG5AMR9BGEN','zh_TW','其他');

-- 本次预制的模版和前面的一样。需要删除原预制的模版
DELETE FROM t_svc_printtpl WHERE FID in ('1MJK8OSVT8JE','1LYBR=26/9ZH','1MGB5630EOX1','1MG1MTEXDPRF','1ME4HDY94QNR','1MHLHA9N3GG1','1M7R+SDM=NSJ','1MGQUWTWQWER');
DELETE FROM t_svc_printtpl_l WHERE FID in ('1MJK8OSVT8JE','1LYBR=26/9ZH','1MGB5630EOX1','1MG1MTEXDPRF','1ME4HDY94QNR','1MHLHA9N3GG1','1M7R+SDM=NSJ','1MGQUWTWQWER');

DELETE FROM t_svc_printtpl WHERE FID = '1SFDPVXD57KE';
INSERT INTO t_svc_printtpl(FID,FVERSION,FPIC_HEIGHT,FDATA,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FDIRECTION,FMODIFIERID,FENABLE,FPICTURE,FMODIFYTIME,FPIC_WIDTH,FCREATORID) VALUES ('1SFDPVXD57KE','1',1128,' ','1SFDPVXD57KE','C','kd_rslzzm_1','离职证明',1159938572699042816,{ts'2021-07-26  00:00:00'},'B',13466739,'1','1208702297069074432',{ts'2021-07-26  00:00:00'},789,'13466739'); 
DELETE FROM t_svc_printtpl WHERE FID = '1SFCBQDFDSFE';
INSERT INTO t_svc_printtpl(FID,FVERSION,FPIC_HEIGHT,FDATA,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FDIRECTION,FMODIFIERID,FENABLE,FPICTURE,FMODIFYTIME,FPIC_WIDTH,FCREATORID) VALUES ('1SFCBQDFDSFE','1',630,' ','1SFCBQDFDSFE','C','TravelReimbursement','差旅报销单',1133393055341087744,{ts'2021-07-26  00:00:00'},'A',13466739,'1','1208645539730560000',{ts'2021-07-26  00:00:00'},891,'976598088569324544'); 
DELETE FROM t_svc_printtpl WHERE FID = '1SEY3YKP+0L/';
INSERT INTO t_svc_printtpl(FID,FVERSION,FPIC_HEIGHT,FDATA,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FDIRECTION,FMODIFIERID,FENABLE,FPICTURE,FMODIFYTIME,FPIC_WIDTH,FCREATORID) VALUES ('1SEY3YKP+0L/','1',791,' ','1SEY3YKP+0L/','C','credentials_2','凭证打印模板',1133393055341087744,{ts'2021-07-26  00:00:00'},'A',13466739,'1','1208696625489255424',{ts'2021-07-26  00:00:00'},1116,'13466739'); 
DELETE FROM t_svc_printtpl WHERE FID = '1SF/2IE9USTX';
INSERT INTO t_svc_printtpl(FID,FVERSION,FPIC_HEIGHT,FDATA,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FDIRECTION,FMODIFIERID,FENABLE,FPICTURE,FMODIFYTIME,FPIC_WIDTH,FCREATORID) VALUES ('1SF/2IE9USTX','1',1124,' ','1SF/2IE9USTX','C','kd_rsyghmc_1','员工履历表',1159938572699042816,{ts'2021-07-26  00:00:00'},'B',13466739,'1','1208741526981593088',{ts'2021-07-26  00:00:00'},783,'976598088569324544'); 
DELETE FROM t_svc_printtpl WHERE FID = '1SFHYM8VJ5T3';
INSERT INTO t_svc_printtpl(FID,FVERSION,FPIC_HEIGHT,FDATA,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FDIRECTION,FMODIFIERID,FENABLE,FPICTURE,FMODIFYTIME,FPIC_WIDTH,FCREATORID) VALUES ('1SFHYM8VJ5T3','1',1673,' ','1SFHYM8VJ5T3','C','Electronic receipt_1','兴业银行电子回单',1133393055341087744,{ts'2021-07-26  00:00:00'},'B',13466739,'1','1208687795313326080',{ts'2021-07-26  00:00:00'},1174,'976598088569324544'); 
DELETE FROM t_svc_printtpl WHERE FID = '1SEWNOW=2G89';
INSERT INTO t_svc_printtpl(FID,FVERSION,FPIC_HEIGHT,FDATA,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FDIRECTION,FMODIFIERID,FENABLE,FPICTURE,FMODIFYTIME,FPIC_WIDTH,FCREATORID) VALUES ('1SEWNOW=2G89','1',1128,' ','1SEWNOW=2G89','C','scp_instock_prt_1','采购入库单',1133393162102900736,{ts'2021-07-26  00:00:00'},'B',13466739,'1','1208526448265018368',{ts'2021-07-26  00:00:00'},785,'13466739'); 
DELETE FROM t_svc_printtpl WHERE FID = '1SFIELP3/B8Z';
INSERT INTO t_svc_printtpl(FID,FVERSION,FPIC_HEIGHT,FDATA,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FDIRECTION,FMODIFIERID,FENABLE,FPICTURE,FMODIFYTIME,FPIC_WIDTH,FCREATORID) VALUES ('1SFIELP3/B8Z','1',1119,' ','1SFIELP3/B8Z','C','cw_fkd0001_1','付款单打印（封面）',1133393162102900736,{ts'2021-07-26  00:00:00'},'B',13466739,'1','1208699070617499648',{ts'2021-07-26  00:00:00'},774,'13466739'); 
DELETE FROM t_svc_printtpl WHERE FID = '1SF/BKNRJ7J1';
INSERT INTO t_svc_printtpl(FID,FVERSION,FPIC_HEIGHT,FDATA,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FDIRECTION,FMODIFIERID,FENABLE,FPICTURE,FMODIFYTIME,FPIC_WIDTH,FCREATORID) VALUES ('1SF/BKNRJ7J1','1',753,' ','1SF/BKNRJ7J1','C','kdtest_tickets_1','销售开单_小票打印',1159942565315739648,{ts'2021-07-26  00:00:00'},'B',13466739,'1','1208701526701303808',{ts'2021-07-26  00:00:00'},270,'13466739'); 

DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFZ1L+0MPL4';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SF/2IE9USTX','1SFZ1L+0MPL4','zh_CN','员工履历表'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SEWNOWNL4OK';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SEWNOW=2G89','1SEWNOWNL4OK','zh_TW','采購入庫單'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SEY3YKP+/XR';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SEY3YKP+0L/','1SEY3YKP+/XR','zh_TW','憑證打印模板'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SF/2IE9UTH5';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SF/2IE9USTX','1SF/2IE9UTH5','zh_TW','員工履曆表'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SF/BKNRJ6VT';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SF/BKNRJ7J1','1SF/BKNRJ6VT','zh_TW','銷售開單_小票打印'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFCBQE6E2A9';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SFCBQDFDSFE','1SFCBQE6E2A9','zh_TW','差旅報銷單'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFDJGCA09+0';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SEY3YKP+0L/','1SFDJGCA09+0','zh_CN','凭证打印模板'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFDPVXGSM2O';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SFDPVXD57KE','1SFDPVXGSM2O','zh_TW','離職證明'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFHYM90S8JV';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SFHYM8VJ5T3','1SFHYM90S8JV','zh_TW','興業銀行電子回單'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFIELP6MQS7';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SFIELP3/B8Z','1SFIELP6MQS7','zh_TW','付款單打印（封麵）'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFP08WY4DMK';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SFHYM8VJ5T3','1SFP08WY4DMK','zh_CN','兴业银行电子回单'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFP58K2J864';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SFIELP3/B8Z','1SFP58K2J864','zh_CN','付款单打印（封面）'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFQF203/BIX';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SFCBQDFDSFE','1SFQF203/BIX','zh_CN','差旅报销单'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFR4LR9KR7W';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SEWNOW=2G89','1SFR4LR9KR7W','zh_CN','采购入库单'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFRM9VY3OMJ';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SF/BKNRJ7J1','1SFRM9VY3OMJ','zh_CN','销售开单_小票打印'); 
DELETE FROM t_svc_printtpl_l WHERE FPKID = '1SFRS1D=/0YP';
INSERT INTO t_svc_printtpl_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1SFDPVXD57KE','1SFRS1D=/0YP','zh_CN','离职证明'); 

--本次预制的模版和前面的一样。删除原资源文件
DELETE FROM t_svc_printresource WHERE FID in (1179692479578914816,1179696066195374080,1179705622296273920,1179705954569053184,1179706148270384128,1179706414801642496,1179706592279405568,1179706958173709312,1179707429621883904);

DELETE FROM t_svc_printresource WHERE FID = 1208526448265018368;
INSERT INTO t_svc_printresource(FID,FILESIZE,FTYPE,FCREATETIME,FPOWERSCOPE,FURL,FILETYPE,FPRINTTPLID,FILENAME,FCREATORID) VALUES (1208526448265018368,0,'0',{ts'2021-07-26  00:00:00'},'0',' ','png','1SEWNOW=2G89','采购入库-新.png',13466739); 
DELETE FROM t_svc_printresource WHERE FID = 1208645539730560000;
INSERT INTO t_svc_printresource(FID,FILESIZE,FTYPE,FCREATETIME,FPOWERSCOPE,FURL,FILETYPE,FPRINTTPLID,FILENAME,FCREATORID) VALUES (1208645539730560000,0,'0',{ts'2021-07-26  00:00:00'},'0',' ','png','1SFCBQDFDSFE','download.png',976598088569324544); 
DELETE FROM t_svc_printresource WHERE FID = 1208687795313326080;
INSERT INTO t_svc_printresource(FID,FILESIZE,FTYPE,FCREATETIME,FPOWERSCOPE,FURL,FILETYPE,FPRINTTPLID,FILENAME,FCREATORID) VALUES (1208687795313326080,0,'0',{ts'2021-07-26  00:00:00'},'0',' ','png','1SFHYM8VJ5T3','兴业银行直通车转账回单 (2).png',13466739); 
DELETE FROM t_svc_printresource WHERE FID = 1208696625489255424;
INSERT INTO t_svc_printresource(FID,FILESIZE,FTYPE,FCREATETIME,FPOWERSCOPE,FURL,FILETYPE,FPRINTTPLID,FILENAME,FCREATORID) VALUES (1208696625489255424,0,'0',{ts'2021-07-26  00:00:00'},'0',' ','png','1SEY3YKP+0L/','凭证模板.png',13466739); 
DELETE FROM t_svc_printresource WHERE FID = 1208699070617499648;
INSERT INTO t_svc_printresource(FID,FILESIZE,FTYPE,FCREATETIME,FPOWERSCOPE,FURL,FILETYPE,FPRINTTPLID,FILENAME,FCREATORID) VALUES (1208699070617499648,6773,'0',{ts'2021-07-26  00:00:00'},'0',' ','png','1SFIELP3/B8Z','付款单封面.png',13466739); 
DELETE FROM t_svc_printresource WHERE FID = 1208701526701303808;
INSERT INTO t_svc_printresource(FID,FILESIZE,FTYPE,FCREATETIME,FPOWERSCOPE,FURL,FILETYPE,FPRINTTPLID,FILENAME,FCREATORID) VALUES (1208701526701303808,8025,'0',{ts'2021-07-26  00:00:00'},'0',' ','png','1SF/BKNRJ7J1','销售开单-小票.png',13466739); 
DELETE FROM t_svc_printresource WHERE FID = 1208702297069074432;
INSERT INTO t_svc_printresource(FID,FILESIZE,FTYPE,FCREATETIME,FPOWERSCOPE,FURL,FILETYPE,FPRINTTPLID,FILENAME,FCREATORID) VALUES (1208702297069074432,8025,'0',{ts'2021-07-26  00:00:00'},'0',' ','png','1SFDPVXD57KE','离职证明2.png',13466739); 
DELETE FROM t_svc_printresource WHERE FID = 1208741526981593088;
INSERT INTO t_svc_printresource(FID,FILESIZE,FTYPE,FCREATETIME,FPOWERSCOPE,FURL,FILETYPE,FPRINTTPLID,FILENAME,FCREATORID) VALUES (1208741526981593088,8025,'0',{ts'2021-07-26  00:00:00'},'0',' ','png','1SF/2IE9USTX','员工履历表-1.png',13466739); 


