data1.json 文件内容:{“tenantId”:108,“deviceIds”:[“0210860000016_1_0210860000016”]}
curl -XPOST -H ‘Content-Type: application/json’ -H ‘user_id : 14’ -H ‘access_token : 111’ http://127.0.0.1:9107/reportmanagement/dw108/getOpHours -d @data1.json
curl -XPOST -H ‘Content-Type: application/json’ -H ‘user_id : 14’ -H ‘access_token : 111’ http://127.0.0.1:9107/reportmanagement/dw108/getOpHours -d @data1.json
curl -X POST -d @report.json http://127.0.0.1:9007/reportmanagement/dw108/getOpHours
curl -X POST -d @report.json http://127.0.0.1:9007/reportmanagement/dw108/getDuration
curl -H “Content-Type:application/json” -X POST --data ‘{“tenantId”:108,“deviceIds”:[“0210860000016_1_0210860000016”]}’ http://127.0.0.1:9007/reportmanagement/dw108/getDuration
curl -H “Content-Type:application/json” -X POST --data ‘{“tenantId”:108,“deviceIds”:[“0210860000016_1_0210860000016”]}’ http://127.0.0.1:9007/reportmanagement/dw108/getOpHours
curl -H “Content-Type:application/json” -X POST --data ‘{“tenantId”:108,“deviceIds”:[“0210860000016_1_0210860000016”]}’ http://127.0.0.1:9107/reportmanagement/dw/getOpHours
curl -H “Content-Type:application/json” -X POST --data @report.json http://127.0.0.1:9007/reportmanagement/dw108/getOpHours
curl -H “Content-Type:application/json” -X POST --data ‘{“tenantId”:108,“deviceIds”:[“1210840000001_1_1210840000001”]}’ http://127.0.0.1:9007/reportmanagement/dw108/getOpHours
https://global.irootech.com/reportmanagement/dw108/getOpHours
/reportmanagement/dw
{“query”:“select Timestamp_Local,Optional_Hydac_pressure_transducer_CAN_OK from realData_Info_kafka_test where deviceId = (‘0210860000029_1_0210860000029’) and __time >= ‘2018-12-02 02:40:12’”}
curl -XPOST -H’Content-Type: application/json’ http://localhost:8082/druid/v2/sql/ -d ‘{“query”:"select ts2 as “Timestamp_Local”,double9 as “deliveredAmount” from kafka_RuleEngineBoltOut_middle where deviceId = (‘0210860000029_1_0210860000029’) and __time >= ‘2018-12-02 02:40:12’ "}’
curl -XPOST -H’Content-Type: application/json’ http://localhost:8082/druid/v2/sql/ -d ‘{“query”:“select DeviceStatus as deviceStatus,avg(GPS_Latitude) as gpsLatitude, avg(GPS_Longitude) as gpsLongitude,max(deliveredAmount) as deliveryAmount,min(__time) as minTime,min(TIME_PARSE(Timestamp_CloudM2M)) as cloudTime,min(TIME_PARSE(Timestamp_Local)) as locaTime from realData_Info_kafka_test where deviceId in (‘0210860000034_1_0210860000034’) and __time >= ‘2019-02-08T10:55:42.458Z’ and __time < ‘2019-02-15T10:55:45.343Z’ group by DeviceStatus,DATE_TRUNC(‘minute’,__time) order by min(__time) asc”}’
eu.druid.address = http://10.80.21.133:8082/druid/v2/sql/
usa.druid.address = http://10.81.2.29:8082/druid/v2/sql/
curl -X POST -H ‘Content-Type: application/json’ 10.80.21.133:8082/druid/v2/sql/ -d @trail3.json
curl -X POST -H ‘Content-Type: application/json’ http://10.80.21.133:8082/druid/v2/sql/ -d @trail3.json
curl -H “Content-Type:application/json” -X POST --data ‘{}’ http://127.0.0.1:5008/maintenance/maintenance/sendmail
curl -H “Content-Type:application/json” -X POST --data ‘{“tenantId”:108,“deviceIds”:“0300860000016_1_0300860000016”,“properties”:"‘status’,‘Support’,‘Fuel_Tank’, ‘Pump_Type’,‘Pump_No’,‘SW_Vers’,‘Op_Hour’,‘Deliv_Amo’,‘Truck_Type’,‘Distance’,‘Timestamp_CloudM2M’"}’ http://127.0.0.1:9002/deviceFilter/getDeviceInfoByDeviceId
curl -H “Content-Type:application/json” -X POST --data ‘{“tenantId”:108,“deviceIds”:“0300860000016_1_0300860000016”,“properties”:"‘status’,‘Support’,‘Fuel_Tank’, ‘Pump_Type’,‘Pump_No’,‘SW_Vers’,‘Op_Hour’,‘Deliv_Amo’,‘Truck_Type’,‘Distance’,‘Timestamp_CloudM2M’"}’ http://127.0.0.1:9007/report/kpi
curl -H “Content-Type:application/json” -X POST --data ‘{“deviceIds”:[“0210860000018_1_0210860000018”],“limit”:5,“modelType”:5013}’ http://127.0.0.1:6006/remoteService/getDescAndTimeByDeviceId
“status”,“Support”,“Fuel_Tank”, “Pump_Type”,“Pump_No”,“SW_Vers”,“Op_Hour”,“Deliv_Amo”,“Truck_Type”,“Distance”,“Timestamp_CloudM2M”
‘status’,‘Support’,‘Fuel_Tank’, ‘Pump_Type’,‘Pump_No’,‘SW_Vers’,‘Op_Hour’,‘Deliv_Amo’,‘Truck_Type’,‘Distance’,‘Timestamp_CloudM2M’
curl -H “Content-Type:application/json” -X POST --data ‘{“teleModuleTypeID”:“1200”,“tenantID”:108}’ http://127.0.0.1:5107/ota/usa/get_exist_firmware_info
curl -H “Content-Type:application/json” -X POST --data ‘{“statStartStr”:“2020-07-01”,“statEndStr”:“2020-07-31”,“statType”:2}’ http://127.0.0.1:9007/reportmanagement/dw108/setDwStat
curl -H “Content-Type:application/json” -X POST --data ‘{“statStartStr”:“2020-07-01”,“statEndStr”:“2020-07-31”,“statType”:2}’ http://127.0.0.1:9007/reportmanagement/dw108/getDwStat