接口路径(新)：http://api.yesapi.net/api/SVIP/Wx502552735_Hai/QueryData
接口路径(旧)：http://api.yesapi.net/?s=SVIP.Wx502552735_Hai.QueryData
接口描述： 根据自由条件查询haiwellsizhoumfp的表数据，同时额外返回【项目信息表】数据
| 参数名字 | 参数类型 | 是否必须 | 默认值 | 备注 | 参数说明 |
|---|---|---|---|---|---|
| app_key | 字符串 | 必须 | 最小：32 | 公共参数 开发者应用的app_key，查看我的app_key，如果还没有，可免费注册开通。 | |
| sign | 字符串 | 可选 | 公共参数接口签名，其中： | ||
| uuid | 字符串 | 可选 | 公共参数 UUID，当前登录的应用会员ID，即全局唯一用户ID，查看我的应用会员。传递此参数后，可以在开放平台查看每日活跃会员统计图表。uuid需要和token一起传递。 | ||
| token | 字符串 | 可选 | 公共参数 当前登录会员的会话凭证，可通过会员登录接口获得。uuid需要和token一起传递。 | ||
| return_data | 字符串 | 可选 | 0 | 公共参数 数据返回结构，其中：
| |
| model_suffix | 字符串 | 可选 | 数据库表名后缀拼接，默认为空，例如传递model_suffix=1，只能传递数字或字母 | ||
| select | 字符串 | 可选 | * | SQL语句的SELECT部分，多个字段用英文逗号分割，如：select=id,uuid | |
| where | 字符串 | 必须 | _id > 0 | 查询条件，不能为空，必须为有效和SQL查询条件 | |
| order | 字符串JSON格式 | 可选 | ["\u552f\u4e00Id ASC"] | SQL语句的ORDER部分，JSON格式。具体格式为：[第一组排序，第二组排序，……]，可以单个或组合排序。 每一组排序格式为："字段名 + 空格 + ASC|DESC"，其中：
例2：组合排序，order=["id DESC", "add_time ASC"]，表示id DESC, add_time ASC，即先按ID从大到小，再按创建时间倒序排序。 特别地，RAND表示随机排序，请慎用。 | |
| page | 整型 | 可选 | 1 | 最小：1 | 第几页 |
| perpage | 整型 | 可选 | 10 | 最小：1；最大：10000 | 分页数量 |
查看我的接口域名、app_key和app_secrect 客户端接入指南(如何生成签名) 开启/关闭签名
# 请求链接
{你的接口域名}/?s=SVIP.Wx502552735_Hai.QueryData&return_data=0&select=*&where=_id > 0&order=["_id ASC"]&page=1&perpage=2&app_key=A55BA547D5EB95AE5077C72D966DA712
# 返回结果
{
"ret": 200,
"data": {
"err_code": 0,
"err_msg": "",
"total": 0,
"list": [],
"page": 1,
"perpage": 2,
"projects": [
{
"Id": 11,
"项目名称": "项目名称1",
"项目地址": "项目地址1",
"建设单位": "建设单位1",
"结构设计单位": "结构设计单位1",
"MFP工法设计单位": "工法设计单位1",
"总包单位": "总包单位1",
"MFP会员单位": "会员单位1",
"勘察单位": "勘察单位1",
"基坑工程": "基坑工程1",
"地基处理": "地基处理1",
"防渗结构": "防渗结构1",
"围护墙": "围护墙1",
"复合地基": "复合地基",
"垃圾填埋场": "垃圾填埋场1",
"止水帷幕": "止水帷幕1",
"进出洞加固": "进出洞加固1",
"大坝防渗漏": "大坝防渗漏1",
"坑内加固": "坑内加固",
"其他1": "其他11",
"其他2": "其他21",
"其他3": "其他31",
"项目概况": "项目概况1",
"设计桩长": "设计桩长1",
"四轴搅拌工程量": "四轴搅拌工程量1",
"接入设备数量": "接入设备数量1",
"设备编号": "设备编号1",
"项目施工开始日期": "2021/9/1 0:00:00",
"项目施工结束日期": "2021/9/19 0:00:00",
"水泥掺量": "水泥掺量1",
"水灰比": "水灰比1",
"项目实施情况简述": "项目实施情况简述1",
"客户端保存日期": "2021-09-19 04:36:33",
"提交服务器日期": "2021-09-19 04:36:33"
},
{
"Id": 46,
"项目名称": "1234",
"项目地址": "1234",
"建设单位": "1234",
"结构设计单位": "1234",
"MFP工法设计单位": "1234",
"总包单位": "1234",
"MFP会员单位": "1234",
"勘察单位": "1234",
"基坑工程": "True",
"地基处理": "False",
"防渗结构": "False",
"围护墙": "True",
"复合地基": "False",
"垃圾填埋场": "True",
"止水帷幕": "False",
"进出洞加固": "False",
"大坝防渗漏": "False",
"坑内加固": "False",
"其他1": "123",
"其他2": "",
"其他3": "",
"项目概况": "123",
"设计桩长": "123",
"四轴搅拌工程量": "123",
"接入设备数量": "123",
"设备编号": "123",
"项目施工开始日期": "2021-09-30 00:00:00",
"项目施工结束日期": "2021-10-08 00:00:00",
"水泥掺量": "123",
"水灰比": "123",
"项目实施情况简述": "123",
"客户端保存日期": "2021-10-14 13:11:51",
"提交服务器日期": "2021-10-14 13:11:51"
},
{
"Id": 51,
"项目名称": "测试项目",
"项目地址": "测试项目地址",
"建设单位": "测试建设单位",
"结构设计单位": "",
"MFP工法设计单位": "",
"总包单位": "",
"MFP会员单位": "MFP会员单位",
"勘察单位": "",
"基坑工程": "True",
"地基处理": "False",
"防渗结构": "False",
"围护墙": "False",
"复合地基": "False",
"垃圾填埋场": "False",
"止水帷幕": "False",
"进出洞加固": "False",
"大坝防渗漏": "False",
"坑内加固": "False",
"其他1": "",
"其他2": "",
"其他3": "",
"项目概况": "项目当前即将进场",
"设计桩长": "50",
"四轴搅拌工程量": "200",
"接入设备数量": "10",
"设备编号": "MFP021595478545",
"项目施工开始日期": "2021/11/1 0:00:00",
"项目施工结束日期": "2021/11/30 0:00:00",
"水泥掺量": "",
"水灰比": "13",
"项目实施情况简述": "当前已准备就绪，即将进场",
"客户端保存日期": "2021-10-30 00:52:03",
"提交服务器日期": "2021-10-30 00:52:06"
},
{
"Id": 52,
"项目名称": "1",
"项目地址": "1",
"建设单位": "1",
"结构设计单位": "11",
"MFP工法设计单位": "1",
"总包单位": "1",
"MFP会员单位": "1",
"勘察单位": "1",
"基坑工程": "False",
"地基处理": "False",
"防渗结构": "True",
"围护墙": "False",
"复合地基": "False",
"垃圾填埋场": "False",
"止水帷幕": "False",
"进出洞加固": "False",
"大坝防渗漏": "False",
"坑内加固": "False",
"其他1": "1",
"其他2": "",
"其他3": "",
"项目概况": "1",
"设计桩长": "1",
"四轴搅拌工程量": "1",
"接入设备数量": "1",
"设备编号": "1",
"项目施工开始日期": "2021/11/4 0:00:00",
"项目施工结束日期": "2021/11/1 0:00:00",
"水泥掺量": "1",
"水灰比": "1",
"项目实施情况简述": "1",
"客户端保存日期": "2021-11-18 16:50:33",
"提交服务器日期": "2021-11-18 16:50:39"
},
{
"Id": 53,
"项目名称": "MFP工法上海浦东项目",
"项目地址": "上海市浦东区",
"建设单位": "上海建工",
"结构设计单位": "",
"MFP工法设计单位": "",
"总包单位": "",
"MFP会员单位": "上海工程机械厂",
"勘察单位": "",
"基坑工程": "True",
"地基处理": "True",
"防渗结构": "False",
"围护墙": "False",
"复合地基": "False",
"垃圾填埋场": "False",
"止水帷幕": "False",
"进出洞加固": "False",
"大坝防渗漏": "False",
"坑内加固": "False",
"其他1": "",
"其他2": "",
"其他3": "",
"项目概况": "项目准备进场",
"设计桩长": "20",
"四轴搅拌工程量": "10000立方",
"接入设备数量": "1",
"设备编号": "12345678",
"项目施工开始日期": "2021-11-11 00:00:00",
"项目施工结束日期": "2021-11-20 00:00:00",
"水泥掺量": "",
"水灰比": "0.6",
"项目实施情况简述": "正在进展",
"客户端保存日期": "2021-11-18 17:32:51",
"提交服务器日期": "2021-11-18 17:32:52"
},
{
"Id": 54,
"项目名称": "1",
"项目地址": "3",
"建设单位": "1",
"结构设计单位": "",
"MFP工法设计单位": "2",
"总包单位": "",
"MFP会员单位": "2",
"勘察单位": "",
"基坑工程": "False",
"地基处理": "True",
"防渗结构": "False",
"围护墙": "False",
"复合地基": "False",
"垃圾填埋场": "False",
"止水帷幕": "False",
"进出洞加固": "False",
"大坝防渗漏": "False",
"坑内加固": "False",
"其他1": "",
"其他2": "",
"其他3": "",
"项目概况": "3",
"设计桩长": "1",
"四轴搅拌工程量": "2",
"接入设备数量": "3",
"设备编号": "1",
"项目施工开始日期": "2021-12-10 00:00:00",
"项目施工结束日期": "2021-12-11 00:00:00",
"水泥掺量": "",
"水灰比": "1",
"项目实施情况简述": "1",
"客户端保存日期": "2021-12-11 13:13:15",
"提交服务器日期": "2021-12-11 13:13:17"
},
{
"Id": 55,
"项目名称": "1",
"项目地址": "1",
"建设单位": "1",
"结构设计单位": "1",
"MFP工法设计单位": "1",
"总包单位": "1",
"MFP会员单位": "1",
"勘察单位": "1",
"基坑工程": "True",
"地基处理": "False",
"防渗结构": "False",
"围护墙": "False",
"复合地基": "False",
"垃圾填埋场": "False",
"止水帷幕": "False",
"进出洞加固": "True",
"大坝防渗漏": "False",
"坑内加固": "False",
"其他1": "1",
"其他2": "",
"其他3": "",
"项目概况": "1",
"设计桩长": "1",
"四轴搅拌工程量": "1",
"接入设备数量": "1",
"设备编号": "1",
"项目施工开始日期": "2021/12/11 0:00:00",
"项目施工结束日期": "2021/12/11 0:00:00",
"水泥掺量": "1",
"水灰比": "1",
"项目实施情况简述": "1",
"客户端保存日期": "2021-12-11 13:23:19",
"提交服务器日期": "2021-12-11 13:23:19"
},
{
"Id": 56,
"项目名称": "1",
"项目地址": "1",
"建设单位": "1",
"结构设计单位": "1",
"MFP工法设计单位": "1",
"总包单位": "1",
"MFP会员单位": "1",
"勘察单位": "1",
"基坑工程": "True",
"地基处理": "False",
"防渗结构": "False",
"围护墙": "False",
"复合地基": "False",
"垃圾填埋场": "False",
"止水帷幕": "False",
"进出洞加固": "True",
"大坝防渗漏": "False",
"坑内加固": "False",
"其他1": "1",
"其他2": "",
"其他3": "",
"项目概况": "1",
"设计桩长": "1",
"四轴搅拌工程量": "1",
"接入设备数量": "1",
"设备编号": "1",
"项目施工开始日期": "2021/12/11 0:00:00",
"项目施工结束日期": "2021/12/11 0:00:00",
"水泥掺量": "1",
"水灰比": "1",
"项目实施情况简述": "1",
"客户端保存日期": "2021-12-11 13:23:19",
"提交服务器日期": "2021-12-11 13:23:21"
},
{
"Id": 57,
"项目名称": "1",
"项目地址": "1",
"建设单位": "1",
"结构设计单位": "1",
"MFP工法设计单位": "1",
"总包单位": "1",
"MFP会员单位": "1",
"勘察单位": "1",
"基坑工程": "True",
"地基处理": "False",
"防渗结构": "False",
"围护墙": "False",
"复合地基": "False",
"垃圾填埋场": "False",
"止水帷幕": "False",
"进出洞加固": "True",
"大坝防渗漏": "False",
"坑内加固": "False",
"其他1": "1",
"其他2": "",
"其他3": "",
"项目概况": "1",
"设计桩长": "1",
"四轴搅拌工程量": "1",
"接入设备数量": "1",
"设备编号": "1",
"项目施工开始日期": "2021-12-11 00:00:00",
"项目施工结束日期": "2021-12-11 00:00:00",
"水泥掺量": "1",
"水灰比": "1",
"项目实施情况简述": "1",
"客户端保存日期": "2021-12-11 14:37:26",
"提交服务器日期": "2021-12-11 14:37:29"
},
{
"Id": 58,
"项目名称": "1",
"项目地址": "3",
"建设单位": "1",
"结构设计单位": "",
"MFP工法设计单位": "2",
"总包单位": "",
"MFP会员单位": "2",
"勘察单位": "",
"基坑工程": "False",
"地基处理": "True",
"防渗结构": "False",
"围护墙": "False",
"复合地基": "False",
"垃圾填埋场": "False",
"止水帷幕": "False",
"进出洞加固": "False",
"大坝防渗漏": "False",
"坑内加固": "False",
"其他1": "",
"其他2": "",
"其他3": "",
"项目概况": "3",
"设计桩长": "1",
"四轴搅拌工程量": "2",
"接入设备数量": "3",
"设备编号": "1",
"项目施工开始日期": "2021-12-10 00:00:00",
"项目施工结束日期": "2021-12-11 00:00:00",
"水泥掺量": "",
"水灰比": "1",
"项目实施情况简述": "1",
"客户端保存日期": "2021-12-11 14:39:42",
"提交服务器日期": "2021-12-11 15:24:34"
}
],
"haiwellsizhoumfp": [
{
"_id": 1,
"_dbTime": "2021-11-17 10:39:02",
"_terminalTime": "2021-11-17 10:39:01.424",
"_groupName": "Haiwellsizhoumfp",
"有无GPS": "1",
"当前桩号": "12",
"设计坐标X": "0.00",
"设计坐标Y": "0.00",
"实际坐标X": "0.00",
"实际坐标Y": "0.00",
"地面标高": "0.00",
"设计桩顶": "0.00",
"设计硬土层": "-35.00",
"设计桩底": "-35.00",
"实际硬土层": "0.00",
"实际桩顶": "0.00",
"桩底埋置深度": "0.00",
"实际桩底": "0.00",
"设计桩长": "35.00",
"浆流量1": "80.25",
"浆流量2": "79.48",
"浆流量3": "79.77",
"浆流量4": "80.30",
"压力1": "0.54",
"压力2": "0.62",
"压力3": "0.62",
"压力4": "0.61",
"下沉浆量": "0.00",
"提升浆量": "0.00",
"浆量给定手动": "80.00",
"浆量给定自动": "17.84",
"浆泵状态1": "1",
"浆泵状态2": "1",
"浆泵状态3": "1",
"浆泵状态4": "1",
"动力头温度报警1": "0",
"动力头温度报警2": "0",
"动力头正转": "1",
"动力头反转": "0",
"钻杆电机电流1": "125.50",
"钻杆电机电流2": "140.43",
"钻杆选择速度1": "19.80",
"钻杆选择速度2": "19.80",
"转速给定": "20.00",
"平台倾角X": "-2.06",
"平台倾角Y": "-1.14",
"立柱倾角X": "-0.36",
"立柱倾角Y": "-0.35",
"旋转角度": "0.00",
"加气气压1": "0.63",
"加气气压2": "0.00",
"当前阶段": "0",
"钻头高程": "-2.73",
"变频器电流": "254.20",
"钻杆重量": "62.07",
"上提速度": "0.00",
"下提速度": "1.86",
"速度控制值手动": "0.60",
"变频器故障复位": "0",
"绞车运行指示": "0",
"绞车手自动": "0",
"绞车手动上升": "0",
"绞车手动下降": "0",
"绞车停止": "0",
"变频器停止": "0",
"变频器正转": "0",
"变频器反转": "0",
"变频器手自动切换": "0",
"确认桩底": "0",
"罗经仪Z角清零": "0",
"罗经仪X角清零": "0",
"罗经仪Y角清零": "0",
"罗经仪Z角": "0.00",
"罗经仪X角": "0.00",
"罗经仪Y角": "0.00",
"搅拌罐重量": "1430",
"储浆罐重量": "1440",
"西门子S7_1200_S7_1500_1_Q32": "1",
"西门子S7_1200_S7_1500_1_Q31": "0",
"西门子S7_1200_S7_1500_1_Q30": "1",
"西门子S7_1200_S7_1500_1_Q27": "0",
"西门子S7_1200_S7_1500_1_Q26": "1",
"西门子S7_1200_S7_1500_1_Q20": "0",
"西门子S7_1200_S7_1500_1_I35": "0",
"西门子S7_1200_S7_1500_1_I44": "0",
"西门子S7_1200_S7_1500_1_I45": "1",
"西门子S7_1200_S7_1500_1_I41": "0",
"西门子S7_1200_S7_1500_1_Q10": "1",
"西门子S7_1200_S7_1500_1_Q21": "0",
"西门子S7_1200_S7_1500_1_I24": "0",
"西门子S7_1200_S7_1500_1_I05": "0",
"西门子S7_1200_S7_1500_1_I06": "0",
"西门子S7_1200_S7_1500_1_I15": "0",
"西门子S7_1200_S7_1500_1_I21": "0",
"西门子S7_1200_S7_1500_1_I26": "1",
"西门子S7_1200_S7_1500_1_I00": "0",
"西门子S7_1200_S7_1500_1_Q06": "1",
"西门子S7_1200_S7_1500_1_I30": "0",
"西门子S7_1200_S7_1500_1_I20": "0",
"西门子S7_1200_S7_1500_1_I14": "0",
"西门子S7_1200_S7_1500_1_I12": "0",
"西门子S7_1200_S7_1500_1_I11": "1",
"西门子S7_1200_S7_1500_1_I23": "0",
"西门子S7_1200_S7_1500_1_I34": "0"
},
{
"_id": 2,
"_dbTime": "2021-11-17 10:39:12",
"_terminalTime": "2021-11-17 10:39:11.424",
"_groupName": "Haiwellsizhoumfp",
"有无GPS": "1",
"当前桩号": "12",
"设计坐标X": "0.00",
"设计坐标Y": "0.00",
"实际坐标X": "0.00",
"实际坐标Y": "0.00",
"地面标高": "0.00",
"设计桩顶": "0.00",
"设计硬土层": "-35.00",
"设计桩底": "-35.00",
"实际硬土层": "0.00",
"实际桩顶": "0.00",
"桩底埋置深度": "0.00",
"实际桩底": "0.00",
"设计桩长": "35.00",
"浆流量1": "79.57",
"浆流量2": "79.91",
"浆流量3": "80.06",
"浆流量4": "79.67",
"压力1": "0.53",
"压力2": "0.61",
"压力3": "0.58",
"压力4": "0.60",
"下沉浆量": "0.00",
"提升浆量": "0.00",
"浆量给定手动": "80.00",
"浆量给定自动": "17.84",
"浆泵状态1": "1",
"浆泵状态2": "1",
"浆泵状态3": "1",
"浆泵状态4": "1",
"动力头温度报警1": "0",
"动力头温度报警2": "0",
"动力头正转": "1",
"动力头反转": "0",
"钻杆电机电流1": "137.50",
"钻杆电机电流2": "128.26",
"钻杆选择速度1": "19.83",
"钻杆选择速度2": "19.83",
"转速给定": "20.00",
"平台倾角X": "-2.20",
"平台倾角Y": "-1.06",
"立柱倾角X": "-0.38",
"立柱倾角Y": "-0.26",
"旋转角度": "0.00",
"加气气压1": "0.63",
"加气气压2": "0.00",
"当前阶段": "0",
"钻头高程": "-3.01",
"变频器电流": "253.70",
"钻杆重量": "61.42",
"上提速度": "0.00",
"下提速度": "1.95",
"速度控制值手动": "0.60",
"变频器故障复位": "0",
"绞车运行指示": "0",
"绞车手自动": "0",
"绞车手动上升": "0",
"绞车手动下降": "0",
"绞车停止": "0",
"变频器停止": "0",
"变频器正转": "0",
"变频器反转": "0",
"变频器手自动切换": "0",
"确认桩底": "0",
"罗经仪Z角清零": "0",
"罗经仪X角清零": "0",
"罗经仪Y角清零": "0",
"罗经仪Z角": "0.00",
"罗经仪X角": "0.00",
"罗经仪Y角": "0.00",
"搅拌罐重量": "1500",
"储浆罐重量": "1370",
"西门子S7_1200_S7_1500_1_Q32": "1",
"西门子S7_1200_S7_1500_1_Q31": "0",
"西门子S7_1200_S7_1500_1_Q30": "1",
"西门子S7_1200_S7_1500_1_Q27": "0",
"西门子S7_1200_S7_1500_1_Q26": "1",
"西门子S7_1200_S7_1500_1_Q20": "0",
"西门子S7_1200_S7_1500_1_I35": "0",
"西门子S7_1200_S7_1500_1_I44": "0",
"西门子S7_1200_S7_1500_1_I45": "1",
"西门子S7_1200_S7_1500_1_I41": "0",
"西门子S7_1200_S7_1500_1_Q10": "1",
"西门子S7_1200_S7_1500_1_Q21": "0",
"西门子S7_1200_S7_1500_1_I24": "0",
"西门子S7_1200_S7_1500_1_I05": "0",
"西门子S7_1200_S7_1500_1_I06": "0",
"西门子S7_1200_S7_1500_1_I15": "0",
"西门子S7_1200_S7_1500_1_I21": "0",
"西门子S7_1200_S7_1500_1_I26": "1",
"西门子S7_1200_S7_1500_1_I00": "0",
"西门子S7_1200_S7_1500_1_Q06": "1",
"西门子S7_1200_S7_1500_1_I30": "0",
"西门子S7_1200_S7_1500_1_I20": "0",
"西门子S7_1200_S7_1500_1_I14": "0",
"西门子S7_1200_S7_1500_1_I12": "0",
"西门子S7_1200_S7_1500_1_I11": "1",
"西门子S7_1200_S7_1500_1_I23": "0",
"西门子S7_1200_S7_1500_1_I34": "0"
}
]
},
"msg": "V3.3.0 YesApi SVIP.Wx502552735_Hai.QueryData 2022-03-08 11:04:12 hn216"
}
| 返回字段 | 类型 | 说明 |
|---|---|---|
| ret | 整型 | 接口状态码，200表示成功，4xx表示客户端非法请求，5xx表示服务端异常，查看异常错误码 |
| data | object/array/混合 | 接口返回的业务数据，由不同的API接口决定不同的数据返回字段和结构。当return_data=1时，接口只会返回此data字段。 |
| data.haiwellsizhoumfp | 字符串 | 符合条件的haiwellsizhoumfp的表数据 |
| data.projects | 字符串 | 项目信息表数据 |
| msg | 字符串 | 提示信息，面向技术人员的帮助或错误提示信息 |
| _t | 整数 | 服务器当时Unix时间戳，例如：1657513450 |
| _auth | 字符串 | 反向数字签名，可用于客户端进行反向验证，防止数据篡改，例如：9bcd54ff53e71a1d80d37c52bdfabf76。验证算法：_auth = md5(data返回的JSON字符串 + _t当前时间戳字符串 + APP_SECRECT密钥字符串)，若需要关闭或开启请提交工单 |
由 果创云YesApi.cn 提供技术支持，4万+开发者都在用，累计API调用1,800,000＋万次