2023.01.28

打开或关闭阀门、灌区时未推送状态时间:已完成

• 新增：opTime
• 新增：runtimes

/Device/GetDeviceDetail 接口调用失败:已完成

• “gatewayId”: “551”,
• “deviceId”: 9493
• LEFT JOIN的问题

  • a.DEVICEMODEL 为null
  • 具体sql

    SELECT
    `a`.`DESCRIPTION` AS `Description`,
    `a`.`DEVICEID` AS `Deviceid`,
    `a`.`DEVICEMODEL` AS `DeviceSubType`,
    `a`.`DEVICEMODELNAME` AS `DeviceSubTypeName`,
    `a`.`DEVICENAME` AS `Devicename`,
    `a`.`ENABLE` AS `Enable`,
    `a`.`STATUS` AS `Status`,
    `a`.`SUBTYPE` AS `Subtype`,
    `a`.`DEVICETYPE` AS `Devicetype`,
    `a`.`PORT` AS `Port`,
    `a`.`STATIONID` AS `Stationid`,
    `a`.`CHARGETIME` AS `Chargetime`,
    `a`.`CLIKACTION` AS `Clikaction`,
    `a`.`CLIK_THRESHOLD` AS `clikMaxThreshold`,
    `a`.`CLIKMINTHRESHOLD` AS `Clikminthreshold`,
    `a`.`CLIKMODE` AS `Clikmode`,
    `a`.`CLIK_OUTPUT_MODE` AS `ClikOutputMode`,
    `a`.`CLIK_SETTLING_TIME` AS `ClikSettlingTime`,
    `a`.`DEFRUNTIME` AS `Defruntime`,
    `a`.`ISEXECUTING` AS `Isexecuting`,
    `a`.`MAXRANGE` AS `Maxrange`,
    `a`.`MINRANGE` AS `Minrange`,
    `a`.`PULSEPERCUBICMETER` AS `Pulsepercubicmeter`,
    `a`.`PULSEWIDTH` AS `Pulsewidth`,
    `a`.`SAMPLE_CYCLE` AS `SampleCycle`,
    `b`.`ENABLE` AS `StationEnable`,
    `b`.`ISONLINE` AS `StationIsonline`,
    `b`.`STATIONNAME` AS `Stationname`,
    `b`.`SIGNALLEVEL` AS `StationSignallevel`,
    `b`.`STATIONSN` AS `Stationsn`,
    `b`.`STATUS` AS `StationStatus`,
    `b`.`STATIONTYPE` AS `Stationtype`,
    `b`.`VISIABLE` AS `StationVisiable`,
    `a`.`SWITCHSTATUS` AS `Switchstatus`,
    `a`.`TIMING` AS `Timing`,
    `a`.`USESPMVINDEX` AS `Usespmvindex`,
    `a`.`VALVEDELAY` AS `Valvedelay`,
    `a`.`VALVEFLOWRATE` AS `Valveflowrate`,
    `a`.`VALVEMAINORSLAVE` AS `Valvemainorslave`,
    `a`.`VALVETYPE` AS `Valvetype`,
    `a`.`VOLTAGERANGE` AS `Voltagerange`,
    `b`.`PORTNO` AS `StationPortno`,
    `b`.`DECODERADDR` AS `StationDecoderaddr`,
    `b`.`DESCRIPTION` AS `StationDescription`,
    `b`.`PROTOCOLNUMBER` AS `StationProtocolnumber`,
    `c`.`NAME` AS `StationProtocolName`,
    `d`.`LAT` AS `DeviceLat`,
    `d`.`LNG` AS `DeviceLng`,
    `a`.`DEVICEINDEX` AS `DeviceIndex`,
     `e`.`MAXV` AS `Maxv`,
     `e`.`MINV` AS `Minv`,
     `e`.`SENSORENOBS` AS `Sensorenobs`,
     `e`.`UNIT` AS `Unit`,
     e.TYPE,
     a.deviceModel,
    `b`.`GATEWAYID` AS `GatewayId` 
    FROM
    `device` a
    INNER JOIN `station` b ON ((
            `a`.`DEVICEID` = 9493 
            ) 
    AND ( `a`.`STATIONID` = `b`.`STATIONID` ))
    LEFT JOIN `station_protocol` c ON ( `b`.`PROTOCOLNUMBER` = `c`.`PROTOCOLNUM` )
    LEFT JOIN `device_webmap` d ON ((
            `d`.`GATEWAY_ID` = `a`.`GATEWAYID` 
            ) 
    AND ( `d`.`DEVICE_INDEX` = `a`.`DEVICEINDEX` ))
    LEFT JOIN `devicesubtype` e ON ( `a`.`DEVICEMODEL` = `e`.`TYPE` ) 
    LIMIT 0,1