-- 删除旧的打印模板
DELETE FROM t_bas_printtplinfo WHERE FID = 1678288798145876992;

-- 新增收付款打印模板
DELETE FROM t_svc_printmeta WHERE FID = '2K//LHSE+995';
INSERT INTO t_svc_printmeta(FID,FVERSION,FTYPE,FSTPLID,FDATA,FMASTERID,FORGID,FSTATUS,FBILLFORMID,FNUMBER,FNAME,FCREATETIME,FTPLTYPE,FMODIFIERID,FBIZAPPID,FMODIFYTIME,FCREATORID) VALUES ('2K//LHSE+995','1','B',' ',' ','2K//LHSE+995',100000,'C','ifm_transdetail','kdprint_ifm_transdetail_prt_s_rec','内部电子回单模板（收款）',{ts'2023-05-05  00:00:00'},'0',1205742215473681408,'/SII0T3E=QIP',{ts'2023-05-05  00:00:00'},1205742215473681408); 
DELETE FROM t_svc_printmeta_l WHERE FPKID = '394HQBIA98LP';
INSERT INTO t_svc_printmeta_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2K//LHSE+995','394HQBIA98LP','zh_CN','内部电子回单模板（收款）'); 
DELETE FROM t_svc_printmeta_l WHERE FPKID = '394HQBIA999Z';
INSERT INTO t_svc_printmeta_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2K//LHSE+995','394HQBIA999Z','zh_TW','內部電子回單模板（收款）'); 
DELETE FROM t_bas_printtplinfo WHERE FID = 1678287094973240320;
INSERT INTO t_bas_printtplinfo(FID,FTYPE,FISDEFAULT,FMASTERID,FCTRLSTRATEGY,FBILLFORMID,FCREATETIME,FMODIFIERID,FCREATEORG,FENABLE,FMODIFYTIME,FPRINTTPLID,FCREATORID) VALUES (1678287094973240320,'B',NULL,0,'5','ifm_transdetail',{ts'2023-05-05  00:00:00'},1205742215473681408,-1,'1',{ts'2023-05-05  00:00:00'},'2K//LHSE+995',1205742215473681408); 

DELETE FROM t_svc_printmeta WHERE FID = '2K197WV1X7PE';
INSERT INTO t_svc_printmeta(FID,FVERSION,FTYPE,FSTPLID,FDATA,FMASTERID,FORGID,FSTATUS,FBILLFORMID,FNUMBER,FNAME,FCREATETIME,FTPLTYPE,FMODIFIERID,FBIZAPPID,FMODIFYTIME,FCREATORID) VALUES ('2K197WV1X7PE','1','B',' ',' ','2K197WV1X7PE',100000,'C','ifm_transdetail','kdprint_ifm_transdetail_prt_s_pay','内部电子回单模板（付款）',{ts'2023-05-05  00:00:00'},'0',1205742215473681408,'/SII0T3E=QIP',{ts'2023-05-05  00:00:00'},1205742215473681408); 
DELETE FROM t_svc_printmeta_l WHERE FPKID = '394HQB960/=1';
INSERT INTO t_svc_printmeta_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2K197WV1X7PE','394HQB960/=1','zh_CN','内部电子回单模板（付款）'); 
DELETE FROM t_svc_printmeta_l WHERE FPKID = '394HQB960+LT';
INSERT INTO t_svc_printmeta_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2K197WV1X7PE','394HQB960+LT','zh_TW','內部電子回單模板（付款）'); 
DELETE FROM t_bas_printtplinfo WHERE FID = 1678287094469922816;
INSERT INTO t_bas_printtplinfo(FID,FTYPE,FISDEFAULT,FMASTERID,FCTRLSTRATEGY,FBILLFORMID,FCREATETIME,FMODIFIERID,FCREATEORG,FENABLE,FMODIFYTIME,FPRINTTPLID,FCREATORID) VALUES (1678287094469922816,'B',NULL,0,'5','ifm_transdetail',{ts'2023-05-05  00:00:00'},1205742215473681408,-1,'1',{ts'2023-05-05  00:00:00'},'2K197WV1X7PE',1205742215473681408); 

-- 预置打印模板条件
DELETE FROM t_bas_printcondition WHERE FID = 1457254194263126016;
INSERT INTO t_bas_printcondition(FID,FCREATEID,FMODIFYDATE,FCONDITION,FBILLID,FMODIFIERID,FCREATEDATE,FBILLNUMBER) VALUES (1457254194263126016,0,{ts'2023-05-06  00:00:00'},'[{"id":0,"seq":1,"enable":true,"filtertype":"1","filtername":"使用付款模板","filtertemplateid":"2K197WV1X7PE","filtercondition":"{\"filterRow\":[{\"id\":\"3988V9Z85FBD\",\"leftBracket\":\"\",\"compareType\":\"21\",\"fieldName\":\"debitamount\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3988V9Z85EO4\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}"},{"id":0,"seq":2,"enable":true,"filtertype":"1","filtername":"使用收款模板","filtertemplateid":"2K//LHSE+995","filtercondition":"{\"filterRow\":[{\"id\":\"3988VTS2NOBH\",\"leftBracket\":\"\",\"compareType\":\"21\",\"fieldName\":\"creditamount\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3988VTS2P5XT\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}"}]','148VLX=V58AY',13466739,{ts'2022-07-04  00:00:00'},'ifm_transdetail'); 

