/**发票类型，可抵扣条件预置数据**/
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327556726957930496;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327557588274979840;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327557694441256960;
UPDATE t_er_invoicetype SET fisoffset='1', fudrdisplay='发票日期 大于等于 2019-04-01 并且 商品名称 包含 运输服务 并且 商品名称 不包含 货运 并且 商品名称 不包含 国际 并且 商品名称 不包含 港澳台 并且 商品名称 不包含 管道 并且 商品名称 不包含 航天 ', fuserdefinerule='{"filterRow":[{"id":"272AQPG6LO0Q","leftBracket":"","compareType":"65","fieldName":"invoicedate","rightBracket":"","logic":"0","value":[{"id":"272AQPG6LS29","value":"2019-04-01"}],"baseDataIds":[]},{"id":"272AQPG6LO0R","leftBracket":"","compareType":"59","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"272AQPG6LS2=","value":"运输服务"}],"baseDataIds":[]},{"id":"272AQPG6LO0S","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"272AQPG6LS2A","value":"货运"}],"baseDataIds":[]},{"id":"272AQPG6LO0T","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"272AQPG6LS2B","value":"国际"}],"baseDataIds":[]},{"id":"272AQPG6LO0U","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"272AQPG6LS2C","value":"港澳台"}],"baseDataIds":[]},{"id":"272AQPG6LO0V","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"272AQPG6LS2D","value":"管道"}],"baseDataIds":[]},{"id":"272AQPG6LO0W","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"272AQPG6LS2E","value":"航天"}],"baseDataIds":[]}],"forList":false}', fjs='invoicedate >= ''2019-04-01'' && goodsname.indexOf(''运输服务'') >= 0 && goodsname.search(''货运'') < 0 && goodsname.search(''国际'') < 0 && goodsname.search(''港澳台'') < 0 && goodsname.search(''管道'') < 0 && goodsname.search(''航天'') < 0 ', fiseinvoice='1', fistransportinvoice='0', fisvatinvoice='1', fisspecialinvoice='0' WHERE fid=1327557004444640256;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327558026160371712;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327558123443004416;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327558257006475264;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327558372223951872;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327558681973356544;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327558872201765888;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327559025981782016;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327559374461281280;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327559486440863744;
UPDATE t_er_invoicetype SET fisoffset='1', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='1', fistransportinvoice='0', fisvatinvoice='1', fisspecialinvoice='1' WHERE fid=1327557145188759552;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='1', fisspecialinvoice='0' WHERE fid=1327557257998705664;
UPDATE t_er_invoicetype SET fisoffset='1', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='1', fisspecialinvoice='1' WHERE fid=1327557354585138176;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='1', fisspecialinvoice='0' WHERE fid=1327557467537799168;
UPDATE t_er_invoicetype SET fisoffset='1', fudrdisplay='发票日期 大于等于 2019-04-01 并且 (旅客 不为空  或者 身份证 不为空 ) ', fuserdefinerule='{"filterRow":[{"id":"272OSX6=EG2Q","leftBracket":"","compareType":"65","fieldName":"invoicedate","rightBracket":"","logic":"0","value":[{"id":"272OSX6D0S8P","value":"2019-04-01"}],"baseDataIds":[]},{"id":"272OSX6D0W=8","leftBracket":"(","compareType":"9","fieldName":"passengername","rightBracket":"","logic":"1","value":[{"id":"272OSX6D0S8Q","value":""}],"baseDataIds":[]},{"id":"272OSX6D0W=9","leftBracket":"","compareType":"9","fieldName":"idcard","rightBracket":")","logic":"0","value":[{"id":"272OSX6D0S8R","value":""}],"baseDataIds":[]}],"forList":false}', fjs='invoicedate >= ''2019-04-01'' && (passengername != '''' ||idcard != '''') ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327557804365521920;
UPDATE t_er_invoicetype SET fisoffset='1', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='1', fistransportinvoice='0', fisvatinvoice='1', fisspecialinvoice='0' WHERE fid=1327558469850626048;
UPDATE t_er_invoicetype SET fisoffset='1', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327559252860073984;
UPDATE t_er_invoicetype SET fisoffset='0', fudrdisplay=' ', fuserdefinerule=' ', fjs=' ', fiseinvoice='1', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327559588798604288;
UPDATE t_er_invoicetype SET fisoffset='1', fudrdisplay='发票日期 大于等于 2019-04-01 并且 (旅客 不为空  或者 身份证 不为空 ) ', fuserdefinerule='{"filterRow":[{"id":"272OZBJ3ZMPZ","leftBracket":"","compareType":"65","fieldName":"invoicedate","rightBracket":"","logic":"0","value":[{"id":"272OZBJ3ZIOE","value":"2019-04-01"}],"baseDataIds":[]},{"id":"272OZBJ3ZMQ+","leftBracket":"(","compareType":"9","fieldName":"passengername","rightBracket":"","logic":"1","value":[{"id":"272OZBJ3ZIOF","value":""}],"baseDataIds":[]},{"id":"272OZBJ3ZMQ/","leftBracket":"","compareType":"9","fieldName":"idcard","rightBracket":")","logic":"0","value":[{"id":"272OZBJ3ZIOG","value":""}],"baseDataIds":[]}],"forList":false}', fjs='invoicedate >= ''2019-04-01'' && (passengername != '''' ||idcard != '''') ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327557913929185280;
UPDATE t_er_invoicetype SET fisoffset='1', fudrdisplay='发票日期 大于等于 2019-04-01 并且 (旅客 不为空  或者 身份证 不为空 ) ', fuserdefinerule='{"filterRow":[{"id":"272P62UXN4HX","leftBracket":"","compareType":"65","fieldName":"invoicedate","rightBracket":"","logic":"0","value":[{"id":"272P62UXN0GC","value":"2019-04-01"}],"baseDataIds":[]},{"id":"272P62UXN4HY","leftBracket":"(","compareType":"9","fieldName":"passengername","rightBracket":"","logic":"1","value":[{"id":"272P62UXN0GD","value":""}],"baseDataIds":[]},{"id":"272P62UXN4HZ","leftBracket":"","compareType":"9","fieldName":"idcard","rightBracket":")","logic":"0","value":[{"id":"272P62UXN0GE","value":""}],"baseDataIds":[]}],"forList":false}', fjs='invoicedate >= ''2019-04-01'' && (passengername != '''' ||idcard != '''') ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327558571663107072;
UPDATE t_er_invoicetype SET fisoffset='1', fudrdisplay='发票日期 大于等于 2019-04-01 并且 (旅客 不为空  或者 身份证 不为空 ) ', fuserdefinerule='{"filterRow":[{"id":"272PAM07OCN4","leftBracket":"","compareType":"65","fieldName":"invoicedate","rightBracket":"","logic":"0","value":[{"id":"272PAM07O9LL","value":"2019-04-01"}],"baseDataIds":[]},{"id":"272PAM07OCN5","leftBracket":"(","compareType":"9","fieldName":"passengername","rightBracket":"","logic":"1","value":[{"id":"272PAM07O9LM","value":""}],"baseDataIds":[]},{"id":"272PAM07OCN6","leftBracket":"","compareType":"9","fieldName":"idcard","rightBracket":")","logic":"0","value":[{"id":"272PAM07O9LN","value":""}],"baseDataIds":[]}],"forList":false}', fjs='invoicedate >= ''2019-04-01'' && (passengername != '''' ||idcard != '''') ', fiseinvoice='0', fistransportinvoice='0', fisvatinvoice='0', fisspecialinvoice='0' WHERE fid=1327559136635855872;
/**
交通运输票据: ('火车票', '轮船票', '飞机票', '客运票')
**/
UPDATE t_er_invoicetype SET fistransportinvoice='1' where fid in (1327557804365521920, 1327557913929185280, 1327558571663107072, 1327559136635855872);