配置快递匹配规则，配置快递停发规则

字段说明

  • ShippingCode 固定值为 _kdbreak_
  • ParmKey 值为Id,必须唯一
  • ParmValue 值为匹配规则，通常为中文，例如：停发、疫情
  • ParmAssign 值为快递编码，使用“*”符号为不指定快递的通用匹配规则

规则说明

一行数据为一个规则
一个快递可以配置多个规则
多行规则满足任意一行规则即可判定停发
一行规则中，使用“|” 符合分割匹配规则，需要同时满足才会判定停发，例如：疫情|停发，则需要同时包含疫情和停发的文字才会判定停发

示例脚本

1.配置一个不指定快递(*)的规则：包含疫情和停发，则判定为停发

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = '_kd_break_' AND ParmKey = 'TF-*01' AND ParmAssign='*')
Begin
    Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue, ParmAssign, Ex1)
    Values('_kd_break_', 'TF-*01', '包含则停发', '疫情|停发', '*', '*|快递')
END

2.菜鸟(CNYZ)配置多行规则:多行规则，满足任意一行规则即可判定停发

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = '_kd_break_' AND ParmKey = 'TF-CN01' AND ParmAssign='CNYZ')
Begin
    Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue, ParmAssign, Ex1)
    Values('_kd_break_', 'TF-CN01', '包含则停发', '设置为停发', 'CNYZ', '*|快递')
END

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = '_kd_break_' AND ParmKey = 'TF-CN02' AND ParmAssign='CNYZ')
Begin
    Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue, ParmAssign, Ex1)
    Values('_kd_break_', 'TF-CN02', '包含则停发', '超出物流商服务范围', 'CNYZ', '*|快递')
END

3.拼多多(PDD)配置一行多词|分隔：一行内同时满足才判定为停发

If not exists(Select 1 From TDefShippingMethodsDet Where ShippingCode = '_kd_break_' AND ParmKey = 'TF-DD01' AND ParmAssign='PDD')
Begin
    Insert Into TDefShippingMethodsDet(ShippingCode, ParmKey, ParmName, ParmValue, ParmAssign, Ex1)
    Values('_kd_break_', 'TF-DD01', '包含则停发', '疫情|地址超出', 'PDD', '*|快递')
END