工作流程
事件流程
逻辑问题修正
如:父级信息:
[{ "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" }];
3.1 多级联动数据来源,设置为tmp_data
3.2 设置多级联动表名:
数据来源中的表名,设置父级数据存储位置,子级数据存储位置;
设置表间关联字段
添加默认值,默认值根据需要添加
3.3 删除代码段中多余的点
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" }] } }