JSON多层嵌套解析问题

bh8cxf

一个JSON的解析问题，具体是这个JSON有3个组，每个组又嵌套几个组！这3个组不固定，有可能出现1个组，有可能出现2个组，我想在结果中排除vip组，然后的到usable_count值最大这个小组里面的参数
{"btn_status":1,"btn_text":"请选择","code":1,"data":[{"usable_count":251,"max_price":"320.00","min_price":"150.00","region":1,"list":[{"usable_count":15,"price":"150.00","estate":1,"name":"101","id":1},{"usable_count":44,"price":"150.00","estate":2,"name":"102","id":2},{"usable_count":48,"price":"220.00","estate":31,"name":"131","id":31}],"name":"南面"},{"usable_count":31,"max_price":"888.00","min_price":"888.00","region":3,"list":[{"usable_count":13,"price":"888.00","estate":1,"name":"VIP1","id":1},{"usable_count":17,"price":"888.00","estate":3,"name":"VIP3","id":3}],"name":"VIP"},{"usable_count":22,"max_price":"150.00","min_price":"100.00","region":6,"list":[{"usable_count":35,"price":"100.00","estate":3,"name":"503","id":3},{"usable_count":24,"price":"120.00","estate":20,"name":"520","id":20},{"usable_count":3,"price":"100.00","estate":21,"name":"521","id":21},{"usable_count":22,"price":"100.00","estate":22,"name":"522","id":22},{"usable_count":54,"price":"150.00","estate":35,"name":"535","id":35}],"name":"顶层看台"}],"msg":"获取成功","max_num":2,"type_code":1}  这是格式1
{"btn_status":1,"btn_text":"请选择","code":1,"data":[{"usable_count":1,"max_price":"888.00","min_price":"888.00","region":3,"list":[{"usable_count":"1","price":"888.00","estate":1,"name":"VIP1","id":1}],"name":"VIP"},{"usable_count":1,"max_price":"100.00","min_price":"100.00","region":6,"list":[{"usable_count":"1","price":"100.00","estate":5,"name":"505","id":5},{"usable_count":37,"price":"100.00","estate":6,"name":"506","id":6},{"usable_count":55,"price":"100.00","estate":7,"name":"507","id":7},{"usable_count":62,"price":"120.00","estate":8,"name":"508","id":8}],"name":"南面"}],"msg":"获取成功","max_num":2}这是格式2

{"btn_status":1,"btn_text":"请选择","code":1,"data":[{"usable_count":1,"max_price":"150.00","min_price":"150.00","region":1,"list":[{"usable_count":"1","price":"150.00","estate":4,"name":"104","id":4},{"usable_count":388,"price":"150.00","estate":8,"name":"108","id":8},{"usable_count":360,"price":"180.00","estate":9,"name":"109","id":9},{"usable_count":434,"price":"180.00","estate":10,"name":"110","id":10}],"name":"北面"},{"usable_count":2,"max_price":"888.00","min_price":"888.00","region":3,"list":[{"usable_count":"1","price":"888.00","estate":1,"name":"VIP1","id":1},{"usable_count":"1","price":"888.00","estate":3,"name":"VIP3","id":3}],"name":"VIP"}],"msg":"获取成功","max_num":2}这是格式3


{"btn_status":1,"btn_text":"请选择","code":1,"data":[{"usable_count":1,"max_price":"150.00","min_price":"150.00","region":1,"list":[{"usable_count":"1","price":"150.00","estate":4,"name":"104","id":4},{"usable_count":388,"price":"150.00","estate":8,"name":"108","id":8},{"usable_count":360,"price":"180.00","estate":9,"name":"109","id":9},{"usable_count":434,"price":"180.00","estate":10,"name":"110","id":10}],"name":"北面"},{"usable_count":2,"max_price":"888.00","min_price":"888.00","region":3,"list":[{"usable_count":"1","price":"888.00","estate":1,"name":"VIP1","id":1},{"usable_count":"1","price":"888.00","estate":3,"name":"VIP3","id":3}],"name":"VIP"}],"msg":"获取成功","max_num":2}这是格式4

1752328925

1752328925 发表于 2024-10-25 22:25
自己看看

usable_count 自己加进去 我就打印了名字和价格

bh8cxf

目前自己写就写出来这个

  

子程序名	返回值类型	公开	备 注
_按钮1_被单击

变量名	类 型	静态	数组	备 注
json	类_json
i	整数型
比较值	整数型
name	文本型
usable_count	文本型
price	文本型

比较值 ＝ 1
json.解析 ( #全部, , )
计次循环首 (json.成员数 (“data[0].list”), i)
如果真 (到整数 (json.取属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ()) ＞ 比较值)
比较值 ＝ 到整数 (json.取属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ())
name ＝ json.取通用属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “].name”, )
usable_count ＝ json.取属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ()
price ＝ json.取通用属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “].price”, )

计次循环尾 ()
计次循环首 (json.成员数 (“data[2].list”), i)
如果真 (到整数 (json.取属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ()) ＞ 比较值)
比较值 ＝ 到整数 (json.取属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ())
name ＝ json.取通用属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “].name”, )
usable_count ＝ json.取属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ()
price ＝ json.取通用属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “].price”, )

计次循环尾 ()
调试输出 (name, usable_count, price)

i支持库列表	支持库注释
spec	特殊功能支持库

.版本 2<br /> .支持库 spec<br /> <br /> .子程序 _按钮1_被单击<br /> .局部变量 json, 类_json<br /> .局部变量 i, 整数型<br /> .局部变量 比较值, 整数型<br /> .局部变量 name, 文本型<br /> .局部变量 usable_count, 文本型<br /> .局部变量 price, 文本型<br /> <br /> 比较值 ＝ 1<br /> json.解析 (#全部, , )<br /> <br /> .计次循环首 (json.成员数 (“data[0].list”), i)<br />     .如果真 (到整数 (json.取属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ()) ＞ 比较值)<br />         比较值 ＝ 到整数 (json.取属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ())<br />         name ＝ json.取通用属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “].name”, )<br />         usable_count ＝ json.取属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ()<br />         price ＝ json.取通用属性 (“data[0].list[” ＋ 到文本 (i － 1) ＋ “].price”, )<br />     .如果真结束<br /> <br /> .计次循环尾 ()<br /> .计次循环首 (json.成员数 (“data[2].list”), i)<br />     .如果真 (到整数 (json.取属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ()) ＞ 比较值)<br />         比较值 ＝ 到整数 (json.取属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ())<br />         name ＝ json.取通用属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “].name”, )<br />         usable_count ＝ json.取属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “]['usable_count']”).取数据文本 ()<br />         price ＝ json.取通用属性 (“data[2].list[” ＋ 到文本 (i － 1) ＋ “].price”, )<br /> <br />     .如果真结束<br /> <br /> .计次循环尾 ()<br /> <br /> 调试输出 (name, usable_count, price)

bh8cxf

用的精易模块

1752328925

自己看看

bh8cxf

1752328925 发表于 2024-10-25 22:25
自己看看

大哥，我是想要排除VIP哪一组之后，再比较其他两个组的小组成员，这两个组的小组成员之中那一个的usable_count值最大，便取这个小组的name, usable_count, price

bh8cxf

bh8cxf 发表于 2024-10-25 23:20
大哥，我是想要排除VIP哪一组之后，再比较其他两个组的小组成员，这两个组的小组成员之中那一个的usable_ ...

您看看格式3和格式4，打印出来没有排除vip哪一组

1752328925

bh8cxf 发表于 2024-10-25 23:20
大哥，我是想要排除VIP哪一组之后，再比较其他两个组的小组成员，这两个组的小组成员之中那一个的usable_ ...

看下是不是这个样子的。。。。。。。。

1752328925

1752328925 发表于 2024-10-25 23:37
看下是不是这个样子的。。。。。。。。

你要比较内层list的值 还是外层的啊

bh8cxf

1752328925 发表于 2024-10-25 23:39
你要比较内层list的值 还是外层的啊

先排除外层的vip组，再取内层的来比较，要考虑外层VIP组有时会出现，有时不出现！比如{"btn_status":1,"btn_text":"请选择","code":1,"data":[{"usable_count":1,"max_price":"150.00","min_price":"150.00","region":1,"list":[{"usable_count":"1","price":"150.00","estate":4,"name":"104","id":4},{"usable_count":388,"price":"150.00","estate":8,"name":"108","id":8},{"usable_count":360,"price":"180.00","estate":9,"name":"109","id":9},{"usable_count":434,"price":"180.00","estate":10,"name":"110","id":10}],"name":"北面"},{"usable_count":2,"max_price":"888.00","min_price":"888.00","region":3,"list":[{"usable_count":"1","price":"888.00","estate":1,"name":"VIP1","id":1},{"usable_count":"1","price":"888.00","estate":3,"name":"VIP3","id":3}],"name":"VIP"}],"msg":"获取成功","max_num":2}这一格式的，北面最多的usable_count值是434，就取这一组