
update t_er_invoicetype set    fudrdisplay = '发票日期 大于等于 2019-04-01 并且 商品名称 包含 运输服务 并且 商品名称 不包含 货运 并且 商品名称 不包含 国际 并且 商品名称 不包含 港澳台 并且 商品名称 不包含 管道 并且 商品名称 不包含 航天 并且 区块链 等于 0 ', fuserdefinerule = '{"filterRow":[{"id":"3NF4XJFIXYV9","leftBracket":"","compareType":"65","fieldName":"invoicedate","rightBracket":"","logic":"0","value":[{"id":"3NF4XJFIX68+","value":"2019-04-01"}],"baseDataIds":[]},{"id":"3NF4XJFIXYV=","leftBracket":"","compareType":"59","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3NF4XJFIX68/","value":"运输服务"}],"baseDataIds":[]},{"id":"3NF4XJFIXYVA","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3NF4XJFIX680","value":"货运"}],"baseDataIds":[]},{"id":"3NF4XJFIXYVB","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3NF4XJFIX681","value":"国际"}],"baseDataIds":[]},{"id":"3NF4XJFIXYVC","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3NF4XJFIX682","value":"港澳台"}],"baseDataIds":[]},{"id":"3NF4XJFIXYVD","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3NF4XJFIX683","value":"管道"}],"baseDataIds":[]},{"id":"3NF4XJFIXYVE","leftBracket":"","compareType":"58","fieldName":"goodsname","rightBracket":"","logic":"0","value":[{"id":"3NF4XJFIX684","value":"航天"}],"baseDataIds":[]},{"id":"3NF4XJFIXYVF","leftBracket":"","compareType":"105","fieldName":"blockchain","rightBracket":"","logic":"0","value":[{"id":"3NF4XJFIX685","value":"0"}],"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 && blockchain == ''0'' '    where  fid = 1327557004444640256;
