二级联动代码段操作文档

1.首先确认二级联动的父级信息的id 存储在子级中

如:父级信息:

          [{
          "shenfenming": "H北京市",
          "shenfenbianhao": "1"    //父级信息id
        }, {
          "shenfenming": "H安徽省",
          "shenfenbianhao": "2"
        }, {
          "shenfenming": "H广东省",
          "shenfenbianhao": "3"
        }];
  
  

则子级信息必为:

       [{
          "shiquming": "H海淀区",
          "shiqubianhao": "a1",
          "shenfenid": "1"           //对应父级id
        }, {
          "shiquming": "H朝阳区",
          "shiqubianhao": "b1",
          "shenfenid": "1"          
        }, {
          "shiquming": "H密云区",
          "shiqubianhao": "c1",
          "shenfenid": "1"
        }, {
          "shiquming": "H合肥市",
          "shiqubianhao": "a2",
          "shenfenid": "2"           //对应父级id
        }, {
          "shiquming": "H六安市",
          "shiqubianhao": "b2",
          "shenfenid": "2"
        }, {
          "shiquming": "H马鞍山市",
          "shiqubianhao": "c2",
          "shenfenid": "2"
        }, {
          "shiquming": "H广州市",
          "shiqubianhao": "a3",
          "shenfenid": "3"
        }, {
          "shiquming": "H朝阳市",
          "shiqubianhao": "b3",
          "shenfenid": "3"
        }, {
          "shiquming": "H汕头市",
          "shiqubianhao": "c3",
          "shenfenid": "3"
        }];
  
  
2.正常查询获取父级/子级信息;
3.插入多级联动拼接代码段

3.1 多级联动数据来源,设置为tmp_data

3.2 设置多级联动表名:

数据来源中的表名,设置父级数据存储位置,子级数据存储位置;

设置表间关联字段

添加默认值,默认值根据需要添加

3.3 删除代码段中多余的点

4.数据采集输出

4.1 数据直接采集到tmp_data中

4.2 数据输出介绍

{
    "shenfenbiao": [{
        "shenfenming": "H北京市",
        "shenfenbianhao": "1"
    }, {
        "shenfenming": "H安徽省",
        "shenfenbianhao": "2"
    }, {
        "shenfenming": "H广东省",
        "shenfenbianhao": "3"
    }],
    "shiqubiao": {
        "1": [{
            "shiquming": "H海淀区",
            "shiqubianhao": "a1",
            "shenfenid": "1"
        }, {
            "shiquming": "H朝阳区",
            "shiqubianhao": "b1",
            "shenfenid": "1"
        }, {
            "shiquming": "H密云区",
            "shiqubianhao": "c1",
            "shenfenid": "1"
        }],
        "2": [{
            "shiquming": "H合肥市",
            "shiqubianhao": "a2",
            "shenfenid": "2"
        }, {
            "shiquming": "H六安市",
            "shiqubianhao": "b2",
            "shenfenid": "2"
        }, {
            "shiquming": "H马鞍山市",
            "shiqubianhao": "c2",
            "shenfenid": "2"
        }],
        "3": [{
            "shiquming": "H广州市",
            "shiqubianhao": "a3",
            "shenfenid": "3"
        }, {
            "shiquming": "H朝阳市",
            "shiqubianhao": "b3",
            "shenfenid": "3"
        }, {
            "shiquming": "H汕头市",
            "shiqubianhao": "c3",
            "shenfenid": "3"
        }]
    }
}
  
5.页面绑定

页面绑定参照手册