-- 数电票(普通发票) 增加抵扣条件
UPDATE t_er_invoicetype SET
                            fisoffset='1',
                            fudrdisplay='商品名称 包含 运输服务 并且 商品名称 不包含 货运 并且 商品名称 不包含 国际 并且 商品名称 不包含 港澳台 并且 商品名称 不包含 管道 并且 商品名称 不包含 航天 ',
                            fuserdefinerule='{"filterRow":[{"id":"3FB2D4BYI4RQ","leftBracket":"","compareType":"59","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3FB2D4BYMAOS","value":"运输服务"}],"baseDataIds":[]},{"id":"3FB2D4BYI4RR","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3FB2D4BYMAOT","value":"货运"}],"baseDataIds":[]},{"id":"3FB2D4BYI4RS","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3FB2D4BYMAOU","value":"国际"}],"baseDataIds":[]},{"id":"3FB2D4BYI4RT","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3FB2D4BYMAOV","value":"港澳台"}],"baseDataIds":[]},{"id":"3FB2D4BYI4RU","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3FB2D4BYMAOW","value":"管道"}],"baseDataIds":[]},{"id":"3FB2D4BYI4RV","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3FB2D4BYMAOX","value":"航天"}],"baseDataIds":[]}],"forList":false}',
                            fjs='goodsname.indexOf(''运输服务'') >= 0 && goodsname.search(''货运'') < 0 && goodsname.search(''国际'') < 0 && goodsname.search(''港澳台'') < 0 && goodsname.search(''管道'') < 0 && goodsname.search(''航天'') < 0 '
WHERE fid=1388470114852066304;

-- 飞机票增加签注抵扣条件
UPDATE t_er_invoicetype SET
                            fudrdisplay='发票日期 大于等于 2019-04-01 并且 (旅客 不为空  或者 身份证 不为空 ) 并且 地域 不等于国际 并且 (签注 不包含 退票费 并且 签注 不包含 改签费) 并且 机票状态 不等于改签 ',
                            fuserdefinerule='{"filterRow":[{"id":"3HDS3I8ULRA8","leftBracket":"","compareType":"65","fieldName":"invoicedate","rightBracket":"","logic":"0","value":[{"id":"3HDS3I8ULPZQ","value":"2019-04-01"}],"baseDataIds":[]},{"id":"3HDS3I8ULRA9","leftBracket":"(","compareType":"9","fieldName":"passengername","rightBracket":"","logic":"1","value":[{"id":"3HDS3I8ULPZR","value":""}],"baseDataIds":[]},{"id":"3HDS3I8ULRA=","leftBracket":"","compareType":"9","fieldName":"idcard","rightBracket":")","logic":"0","value":[{"id":"3HDS3I8ULPZS","value":""}],"baseDataIds":[]},{"id":"3HDS3I8ULRAA","leftBracket":"","compareType":"106","fieldName":"region","rightBracket":"","logic":"0","value":[{"id":"3HDS3I8ULPZT","value":"2"}],"baseDataIds":[]},{"id":"3HDS3I8ULRAB","leftBracket":"(","compareType":"58","fieldName":"endorsement","rightBracket":"","logic":"0","value":[{"id":"3HDS3I8ULPZU","value":"退票费"}],"baseDataIds":[]},{"id":"3HDS3I8ULRAC","leftBracket":"","compareType":"58","fieldName":"endorsement","rightBracket":")","logic":"0","value":[{"id":"3HDS3I8ULPZV","value":"改签费"}],"baseDataIds":[]},{"id":"3HDS3I8ULRAD","leftBracket":"","compareType":"106","fieldName":"ticketchanges","rightBracket":"","logic":"0","value":[{"id":"3HDS3I8ULPZW","value":"2"}],"baseDataIds":[]}],"forList":false}',
                            fjs='invoicedate >= ''2019-04-01'' && (passengername != '''' ||idcard != '''') && region != ''2'' && (endorsement.search(''退票费'') < 0 && endorsement.search(''改签费'') < 0) && ticketchanges != ''2'' '
WHERE fid=1327557913929185280;