/** 发票类型 **/
DELETE FROM t_er_invoicetype WHERE fid=1454411568673828864;
if not exists(select 1 from t_er_invoicetype where fnumber='28')
INSERT INTO t_er_invoicetype(FID,FISEINVOICE,FISVATINVOICE,FISDEFAULT,FMASTERID,FSTATUS,FUDRDISPLAY,FJS,FNUMBER,FCREATETIME,FUSERDEFINERULE,FMODIFIERID,FENABLE,FISSPECIALINVOICE,FREMARK,FMODIFYTIME,FISOFFSET,FISTRANSPORTINVOICE,FCREATORID) VALUES (1454411568673828864,'1','0','1',1454411568673828864,'C','旅客 不为空  或者 身份证 不为空  ','passengername != '''' ||idcard != '''' ','28',{ts'2022-06-30  00:00:00'},'{"filterRow":[{"id":"2JMYH1O+P4KG","leftBracket":"","compareType":"9","fieldName":"passengername","rightBracket":"","logic":"1","value":[{"id":"2JMYH1O+P58Q","value":""}],"baseDataIds":[]},{"id":"2JMYH1O+P4KH","leftBracket":"","compareType":"9","fieldName":"idcard","rightBracket":"","logic":"0","value":[{"id":"2JMYH1O+P58R","value":""}],"baseDataIds":[]}],"forList":false}',1236081998485809152,'1','0',' ',{ts'2022-06-30  00:00:00'},'1','1',1236081998485809152);

DELETE FROM t_er_invoicetype WHERE fid=1454412199111273472;
if not exists(select 1 from t_er_invoicetype where fnumber='29')
INSERT INTO t_er_invoicetype(FID,FISEINVOICE,FISVATINVOICE,FISDEFAULT,FMASTERID,FSTATUS,FUDRDISPLAY,FJS,FNUMBER,FCREATETIME,FUSERDEFINERULE,FMODIFIERID,FENABLE,FISSPECIALINVOICE,FREMARK,FMODIFYTIME,FISOFFSET,FISTRANSPORTINVOICE,FCREATORID) VALUES (1454412199111273472,'1','0','1',1454412199111273472,'C','旅客 不为空  或者 身份证 不为空  ','passengername != '''' ||idcard != '''' ','29',{ts'2022-06-30  00:00:00'},'{"filterRow":[{"id":"2JMYN25KUA3U","leftBracket":"","compareType":"9","fieldName":"passengername","rightBracket":"","logic":"1","value":[{"id":"2JMYN25KU=FK","value":""}],"baseDataIds":[]},{"id":"2JMYN25KUA3V","leftBracket":"","compareType":"9","fieldName":"idcard","rightBracket":"","logic":"0","value":[{"id":"2JMYN25KU=FL","value":""}],"baseDataIds":[]}],"forList":false}',1236081998485809152,'1','0',' ',{ts'2022-06-30  00:00:00'},'1','1',1236081998485809152);

/** 发票类型-多语言 **/
DELETE FROM t_er_invoicetype_l WHERE FPKID = '2JMYJ7I/U+SW';
INSERT INTO t_er_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1454411568673828864,'2JMYJ7I/U+SW','zh_CN','电子航空客票');

DELETE FROM t_er_invoicetype_l WHERE FPKID = '2JMYJ7I/U+SX';
INSERT INTO t_er_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1454411568673828864,'2JMYJ7I/U+SX','zh_TW','電子航空客票');

DELETE FROM t_er_invoicetype_l WHERE FPKID = '2JMYNTJ27JOX';
INSERT INTO t_er_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1454412199111273472,'2JMYNTJ27JOX','zh_CN','电子铁路客票');

DELETE FROM t_er_invoicetype_l WHERE FPKID = '2JMYNTJ27JOY';
INSERT INTO t_er_invoicetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1454412199111273472,'2JMYNTJ27JOY','zh_TW','電子鐵路客票');