| | |
| | | * @Description |
| | | */ |
| | | @Data |
| | | @JsonPropertyOrder({ "id", "countyId", "townId", "villageId", "divideId", "blockId", "name", "lng", "lat", "remarks", "operator", "operateDt", "blockName", "address", "rtuAddr", "protocol"}) |
| | | @JsonPropertyOrder({ "id", "countyId", "townId", "villageId", "divideId", "blockId", "name", "lng", "lat", "remarks", "operator", "operateDt", "blockName", "address", "controllerId", "rtuAddr", "protocol"}) |
| | | public class VoAllIntake implements BaseEntity { |
| | | private static final long serialVersionUID = 202412161003001L; |
| | | |
| | |
| | | private String address; |
| | | |
| | | /** |
| | | * 阀控器ID |
| | | */ |
| | | @JSONField(serializeUsing = ObjectWriterImplToString.class) |
| | | private Long controllerId; |
| | | |
| | | /** |
| | | * RTU地址 |
| | | */ |
| | | private String rtuAddr; |
| | |
| | | ge.operateDt, |
| | | blo.`name` AS blockName, |
| | | CONCAT(country.`name`, town.`name`, village.`name`) AS address, |
| | | con.id AS controllerId, |
| | | con.rtuAddr, |
| | | con.protocol |
| | | FROM pr_intake ge |