diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java new file mode 100644 index 0000000..acb4a18 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java @@ -0,0 +1,159 @@ +package com.casic.PgInterface.overtimeInPG.domain; + +import javax.persistence.*; +import java.io.Serializable; +import java.util.Date; + +//import org.hibernate.type.MaterializedClobType; +//import javax.annotation.Generated; +//import java.sql.Clob; + +@Entity +@Table(name = "PG_TAGPOSITION") +@SequenceGenerator(name ="SEQ_PG_TAGPOSITION_ID",sequenceName = "SEQ_PG_TAGPOSITION_ID",allocationSize = 1,initialValue = 1) +public class PGTagPosition implements Serializable { + private long id; + private String hostId; + private String hostName; + private String tagId; + private String tagName; + private String tagMac; + private String coordinatesName; + private String coordinate; + private String x; + private String y; + private String positionUpdatetime; + private Date parsedTime; + // private Date queryTime; + @Id +// @GeneratedValue(strategy = GenerationType.AUTO) + @GeneratedValue(strategy = GenerationType.SEQUENCE,generator ="SEQ_PG_TAGPOSITION_ID") + @Column(name = "ID") + public long getId() { + return id; + } + + public void setId(long id) { + this.id = id; + } + @Basic + @Column(name = "HOSTID" ) + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + @Basic + @Column(name = "HOSTNAME") + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + @Basic + @Column(name = "TAGID") + public String getTagId() { + return tagId; + } + + public void setTagId(String tagId) { + this.tagId = tagId; + } + @Basic + @Column(name = "TAGMAC") + public String getTagMac() { + return tagMac; + } + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + @Basic + @Column(name = "TAGMACNAME") + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + @Basic + @Column(name = "COORDINATESNAME") + public String getCoordinatesName() + { + return coordinatesName; + } + public void setCoordinatesName(String coordinatesName) + { + this.coordinatesName = coordinatesName; + } + + @Basic + @Column(name = "COORDINATE") + public String getCoordinate() + { + return coordinate; + } + public void setCoordinate(String coordinate) + { + this.coordinate = coordinate; + } + + @Basic + @Column(name = "X") + public String getX() + { + return x; + } + public void setX(String x) + { + this.x = x; + } + @Basic + @Column(name = "Y") + public String getY() + { + return y; + } + public void setY(String y) + { + this.y = y; + } + + @Basic + @Column(name = "POSITIONUPDATETIME") + public String getPositionUpdatetime() + { + return positionUpdatetime; + } + public void setPositionUpdatetime(String positionUpdatetime) + { + this.positionUpdatetime = positionUpdatetime; + } + + @Basic + @Column(name = "PARSEDTIME") + public Date getParsedTime() + { + return parsedTime; + } + public void setParsedTime(Date parsedTime) + { + this.parsedTime = parsedTime; + } + +// @Basic +// @Column(name = "QUERYTIME") +// public Date getQueryTime() +// { +// return queryTime; +// } +// public void setQueryTime(Date queryTime) +// { +// this.queryTime = queryTime; +// } + +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java new file mode 100644 index 0000000..acb4a18 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java @@ -0,0 +1,159 @@ +package com.casic.PgInterface.overtimeInPG.domain; + +import javax.persistence.*; +import java.io.Serializable; +import java.util.Date; + +//import org.hibernate.type.MaterializedClobType; +//import javax.annotation.Generated; +//import java.sql.Clob; + +@Entity +@Table(name = "PG_TAGPOSITION") +@SequenceGenerator(name ="SEQ_PG_TAGPOSITION_ID",sequenceName = "SEQ_PG_TAGPOSITION_ID",allocationSize = 1,initialValue = 1) +public class PGTagPosition implements Serializable { + private long id; + private String hostId; + private String hostName; + private String tagId; + private String tagName; + private String tagMac; + private String coordinatesName; + private String coordinate; + private String x; + private String y; + private String positionUpdatetime; + private Date parsedTime; + // private Date queryTime; + @Id +// @GeneratedValue(strategy = GenerationType.AUTO) + @GeneratedValue(strategy = GenerationType.SEQUENCE,generator ="SEQ_PG_TAGPOSITION_ID") + @Column(name = "ID") + public long getId() { + return id; + } + + public void setId(long id) { + this.id = id; + } + @Basic + @Column(name = "HOSTID" ) + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + @Basic + @Column(name = "HOSTNAME") + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + @Basic + @Column(name = "TAGID") + public String getTagId() { + return tagId; + } + + public void setTagId(String tagId) { + this.tagId = tagId; + } + @Basic + @Column(name = "TAGMAC") + public String getTagMac() { + return tagMac; + } + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + @Basic + @Column(name = "TAGMACNAME") + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + @Basic + @Column(name = "COORDINATESNAME") + public String getCoordinatesName() + { + return coordinatesName; + } + public void setCoordinatesName(String coordinatesName) + { + this.coordinatesName = coordinatesName; + } + + @Basic + @Column(name = "COORDINATE") + public String getCoordinate() + { + return coordinate; + } + public void setCoordinate(String coordinate) + { + this.coordinate = coordinate; + } + + @Basic + @Column(name = "X") + public String getX() + { + return x; + } + public void setX(String x) + { + this.x = x; + } + @Basic + @Column(name = "Y") + public String getY() + { + return y; + } + public void setY(String y) + { + this.y = y; + } + + @Basic + @Column(name = "POSITIONUPDATETIME") + public String getPositionUpdatetime() + { + return positionUpdatetime; + } + public void setPositionUpdatetime(String positionUpdatetime) + { + this.positionUpdatetime = positionUpdatetime; + } + + @Basic + @Column(name = "PARSEDTIME") + public Date getParsedTime() + { + return parsedTime; + } + public void setParsedTime(Date parsedTime) + { + this.parsedTime = parsedTime; + } + +// @Basic +// @Column(name = "QUERYTIME") +// public Date getQueryTime() +// { +// return queryTime; +// } +// public void setQueryTime(Date queryTime) +// { +// this.queryTime = queryTime; +// } + +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java new file mode 100644 index 0000000..5aa38cb --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java @@ -0,0 +1,94 @@ +package com.casic.PgInterface.overtimeInPG.dto; + + +public class PGPositionDto { + + public String tagMac; + public String tagName; + public String hostId; + public String hostName; + // public String TagId; +// public String CoordinatesId; + public String coordinatesName; + public String X; + public String Y; + public String positionUpdateTime; + + public String getTagMac() { + return tagMac; + } + + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + + public String getCoordinatesName() { + return coordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + this.coordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPositionUpdateTime() { + return positionUpdateTime; + } + + public void setPositionUpdateTime(String positionUpdateTime) { + this.positionUpdateTime = positionUpdateTime; + } + + @Override + public String toString() { + return "PGPositionDto{" + + "tagMac='" + tagMac + '\'' + + ", tagName='" + tagName + '\'' + + ", hostId='" + hostId + '\'' + + ", hostName='" + hostName + '\'' + + ", coordinatesName='" + coordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + positionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java new file mode 100644 index 0000000..acb4a18 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java @@ -0,0 +1,159 @@ +package com.casic.PgInterface.overtimeInPG.domain; + +import javax.persistence.*; +import java.io.Serializable; +import java.util.Date; + +//import org.hibernate.type.MaterializedClobType; +//import javax.annotation.Generated; +//import java.sql.Clob; + +@Entity +@Table(name = "PG_TAGPOSITION") +@SequenceGenerator(name ="SEQ_PG_TAGPOSITION_ID",sequenceName = "SEQ_PG_TAGPOSITION_ID",allocationSize = 1,initialValue = 1) +public class PGTagPosition implements Serializable { + private long id; + private String hostId; + private String hostName; + private String tagId; + private String tagName; + private String tagMac; + private String coordinatesName; + private String coordinate; + private String x; + private String y; + private String positionUpdatetime; + private Date parsedTime; + // private Date queryTime; + @Id +// @GeneratedValue(strategy = GenerationType.AUTO) + @GeneratedValue(strategy = GenerationType.SEQUENCE,generator ="SEQ_PG_TAGPOSITION_ID") + @Column(name = "ID") + public long getId() { + return id; + } + + public void setId(long id) { + this.id = id; + } + @Basic + @Column(name = "HOSTID" ) + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + @Basic + @Column(name = "HOSTNAME") + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + @Basic + @Column(name = "TAGID") + public String getTagId() { + return tagId; + } + + public void setTagId(String tagId) { + this.tagId = tagId; + } + @Basic + @Column(name = "TAGMAC") + public String getTagMac() { + return tagMac; + } + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + @Basic + @Column(name = "TAGMACNAME") + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + @Basic + @Column(name = "COORDINATESNAME") + public String getCoordinatesName() + { + return coordinatesName; + } + public void setCoordinatesName(String coordinatesName) + { + this.coordinatesName = coordinatesName; + } + + @Basic + @Column(name = "COORDINATE") + public String getCoordinate() + { + return coordinate; + } + public void setCoordinate(String coordinate) + { + this.coordinate = coordinate; + } + + @Basic + @Column(name = "X") + public String getX() + { + return x; + } + public void setX(String x) + { + this.x = x; + } + @Basic + @Column(name = "Y") + public String getY() + { + return y; + } + public void setY(String y) + { + this.y = y; + } + + @Basic + @Column(name = "POSITIONUPDATETIME") + public String getPositionUpdatetime() + { + return positionUpdatetime; + } + public void setPositionUpdatetime(String positionUpdatetime) + { + this.positionUpdatetime = positionUpdatetime; + } + + @Basic + @Column(name = "PARSEDTIME") + public Date getParsedTime() + { + return parsedTime; + } + public void setParsedTime(Date parsedTime) + { + this.parsedTime = parsedTime; + } + +// @Basic +// @Column(name = "QUERYTIME") +// public Date getQueryTime() +// { +// return queryTime; +// } +// public void setQueryTime(Date queryTime) +// { +// this.queryTime = queryTime; +// } + +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java new file mode 100644 index 0000000..5aa38cb --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java @@ -0,0 +1,94 @@ +package com.casic.PgInterface.overtimeInPG.dto; + + +public class PGPositionDto { + + public String tagMac; + public String tagName; + public String hostId; + public String hostName; + // public String TagId; +// public String CoordinatesId; + public String coordinatesName; + public String X; + public String Y; + public String positionUpdateTime; + + public String getTagMac() { + return tagMac; + } + + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + + public String getCoordinatesName() { + return coordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + this.coordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPositionUpdateTime() { + return positionUpdateTime; + } + + public void setPositionUpdateTime(String positionUpdateTime) { + this.positionUpdateTime = positionUpdateTime; + } + + @Override + public String toString() { + return "PGPositionDto{" + + "tagMac='" + tagMac + '\'' + + ", tagName='" + tagName + '\'' + + ", hostId='" + hostId + '\'' + + ", hostName='" + hostName + '\'' + + ", coordinatesName='" + coordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + positionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java new file mode 100644 index 0000000..57be186 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java @@ -0,0 +1,122 @@ +package com.casic.PgInterface.overtimeInPG.dto; + +import com.fasterxml.jackson.annotation.JsonIgnoreProperties; + +@JsonIgnoreProperties(ignoreUnknown = true) +public class PGTagPositionDto { + public String TagMac; + public String TagName; + public String HostId; + public String HostName; + public String TagId; + public String CoordinatesId; + public String CoordinatesName; + public String X; + public String Y; + public String postionUpdateTime; + + public String getCoordinatesId() { + return CoordinatesId; + } + + public void setCoordinatesId(String coordinatesId) { + CoordinatesId = coordinatesId; + } + + public String getCoordinatesName() { + return CoordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + CoordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPostionUpdateTime() { + return postionUpdateTime; + } + + public void setPostionUpdateTime(String postionUpdateTime) { + this.postionUpdateTime = postionUpdateTime; + } + +/* +{"Success":true,"ErrorCode":0,"ErrorText":"","TagId":11003,"TagMac":"B0:8E:1A:50:54:88", +"TagName":"马桶监测505488","SerialNo":"","MapId":2,"CoordinatesName":"101洗漱间", +"CoordinatesId":38,"X":-88.7699966430664,"Y":-24.059999465942383,"IsLowBattery":false, +"IsAreaWarning":false,"IsDisappeared":true,"IsBeltBroken":false,"IsReset":false, +"IsStill2Move":false,"IsMove2Still":false,"IsButtonPress":true,"HostName":"马桶监测505488", +"HostId":96,"HostGroupIds":[1,9],"HostStatusId":0,"HostExternalId":"5488","HostExternalInfo":"", +"postionUpdateTime":"2019-05-22T11:09:31.9387103+08:00"} + */ + + public String getTagId() { + return TagId; + } + + public void setTagId(String tagId) { + TagId = tagId; + } + + public String getTagMac() { + return TagMac; + } + + public void setTagMac(String tagMac) { + TagMac = tagMac; + } + + public String getTagName() { + return TagName; + } + + public void setTagName(String tagName) { + TagName = tagName; + } + public String getHostId() { + return HostId; + } + + public void setHostId(String hostId) { + HostId = hostId; + } + + public String getHostName() { + return HostName; + } + + public void setHostName(String hostName) { + HostName = hostName; + } + + @Override + public String toString() { + return "PGTagPositionDto{" + + "TagMac='" + TagMac + '\'' + + ", TagName='" + TagName + '\'' + + ", HostId='" + HostId + '\'' + + ", HostName='" + HostName + '\'' + + ", TagId='" + TagId + '\'' + + ", CoordinatesId='" + CoordinatesId + '\'' + + ", CoordinatesName='" + CoordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + postionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java new file mode 100644 index 0000000..acb4a18 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java @@ -0,0 +1,159 @@ +package com.casic.PgInterface.overtimeInPG.domain; + +import javax.persistence.*; +import java.io.Serializable; +import java.util.Date; + +//import org.hibernate.type.MaterializedClobType; +//import javax.annotation.Generated; +//import java.sql.Clob; + +@Entity +@Table(name = "PG_TAGPOSITION") +@SequenceGenerator(name ="SEQ_PG_TAGPOSITION_ID",sequenceName = "SEQ_PG_TAGPOSITION_ID",allocationSize = 1,initialValue = 1) +public class PGTagPosition implements Serializable { + private long id; + private String hostId; + private String hostName; + private String tagId; + private String tagName; + private String tagMac; + private String coordinatesName; + private String coordinate; + private String x; + private String y; + private String positionUpdatetime; + private Date parsedTime; + // private Date queryTime; + @Id +// @GeneratedValue(strategy = GenerationType.AUTO) + @GeneratedValue(strategy = GenerationType.SEQUENCE,generator ="SEQ_PG_TAGPOSITION_ID") + @Column(name = "ID") + public long getId() { + return id; + } + + public void setId(long id) { + this.id = id; + } + @Basic + @Column(name = "HOSTID" ) + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + @Basic + @Column(name = "HOSTNAME") + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + @Basic + @Column(name = "TAGID") + public String getTagId() { + return tagId; + } + + public void setTagId(String tagId) { + this.tagId = tagId; + } + @Basic + @Column(name = "TAGMAC") + public String getTagMac() { + return tagMac; + } + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + @Basic + @Column(name = "TAGMACNAME") + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + @Basic + @Column(name = "COORDINATESNAME") + public String getCoordinatesName() + { + return coordinatesName; + } + public void setCoordinatesName(String coordinatesName) + { + this.coordinatesName = coordinatesName; + } + + @Basic + @Column(name = "COORDINATE") + public String getCoordinate() + { + return coordinate; + } + public void setCoordinate(String coordinate) + { + this.coordinate = coordinate; + } + + @Basic + @Column(name = "X") + public String getX() + { + return x; + } + public void setX(String x) + { + this.x = x; + } + @Basic + @Column(name = "Y") + public String getY() + { + return y; + } + public void setY(String y) + { + this.y = y; + } + + @Basic + @Column(name = "POSITIONUPDATETIME") + public String getPositionUpdatetime() + { + return positionUpdatetime; + } + public void setPositionUpdatetime(String positionUpdatetime) + { + this.positionUpdatetime = positionUpdatetime; + } + + @Basic + @Column(name = "PARSEDTIME") + public Date getParsedTime() + { + return parsedTime; + } + public void setParsedTime(Date parsedTime) + { + this.parsedTime = parsedTime; + } + +// @Basic +// @Column(name = "QUERYTIME") +// public Date getQueryTime() +// { +// return queryTime; +// } +// public void setQueryTime(Date queryTime) +// { +// this.queryTime = queryTime; +// } + +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java new file mode 100644 index 0000000..5aa38cb --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java @@ -0,0 +1,94 @@ +package com.casic.PgInterface.overtimeInPG.dto; + + +public class PGPositionDto { + + public String tagMac; + public String tagName; + public String hostId; + public String hostName; + // public String TagId; +// public String CoordinatesId; + public String coordinatesName; + public String X; + public String Y; + public String positionUpdateTime; + + public String getTagMac() { + return tagMac; + } + + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + + public String getCoordinatesName() { + return coordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + this.coordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPositionUpdateTime() { + return positionUpdateTime; + } + + public void setPositionUpdateTime(String positionUpdateTime) { + this.positionUpdateTime = positionUpdateTime; + } + + @Override + public String toString() { + return "PGPositionDto{" + + "tagMac='" + tagMac + '\'' + + ", tagName='" + tagName + '\'' + + ", hostId='" + hostId + '\'' + + ", hostName='" + hostName + '\'' + + ", coordinatesName='" + coordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + positionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java new file mode 100644 index 0000000..57be186 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java @@ -0,0 +1,122 @@ +package com.casic.PgInterface.overtimeInPG.dto; + +import com.fasterxml.jackson.annotation.JsonIgnoreProperties; + +@JsonIgnoreProperties(ignoreUnknown = true) +public class PGTagPositionDto { + public String TagMac; + public String TagName; + public String HostId; + public String HostName; + public String TagId; + public String CoordinatesId; + public String CoordinatesName; + public String X; + public String Y; + public String postionUpdateTime; + + public String getCoordinatesId() { + return CoordinatesId; + } + + public void setCoordinatesId(String coordinatesId) { + CoordinatesId = coordinatesId; + } + + public String getCoordinatesName() { + return CoordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + CoordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPostionUpdateTime() { + return postionUpdateTime; + } + + public void setPostionUpdateTime(String postionUpdateTime) { + this.postionUpdateTime = postionUpdateTime; + } + +/* +{"Success":true,"ErrorCode":0,"ErrorText":"","TagId":11003,"TagMac":"B0:8E:1A:50:54:88", +"TagName":"马桶监测505488","SerialNo":"","MapId":2,"CoordinatesName":"101洗漱间", +"CoordinatesId":38,"X":-88.7699966430664,"Y":-24.059999465942383,"IsLowBattery":false, +"IsAreaWarning":false,"IsDisappeared":true,"IsBeltBroken":false,"IsReset":false, +"IsStill2Move":false,"IsMove2Still":false,"IsButtonPress":true,"HostName":"马桶监测505488", +"HostId":96,"HostGroupIds":[1,9],"HostStatusId":0,"HostExternalId":"5488","HostExternalInfo":"", +"postionUpdateTime":"2019-05-22T11:09:31.9387103+08:00"} + */ + + public String getTagId() { + return TagId; + } + + public void setTagId(String tagId) { + TagId = tagId; + } + + public String getTagMac() { + return TagMac; + } + + public void setTagMac(String tagMac) { + TagMac = tagMac; + } + + public String getTagName() { + return TagName; + } + + public void setTagName(String tagName) { + TagName = tagName; + } + public String getHostId() { + return HostId; + } + + public void setHostId(String hostId) { + HostId = hostId; + } + + public String getHostName() { + return HostName; + } + + public void setHostName(String hostName) { + HostName = hostName; + } + + @Override + public String toString() { + return "PGTagPositionDto{" + + "TagMac='" + TagMac + '\'' + + ", TagName='" + TagName + '\'' + + ", HostId='" + HostId + '\'' + + ", HostName='" + HostName + '\'' + + ", TagId='" + TagId + '\'' + + ", CoordinatesId='" + CoordinatesId + '\'' + + ", CoordinatesName='" + CoordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + postionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java b/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java new file mode 100644 index 0000000..0eb9245 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java @@ -0,0 +1,45 @@ +package com.casic.PgInterface.overtimeInPG.manager; + +import com.casic.PgInterface.core.hibernate.HibernateEntityDao; +import com.casic.PgInterface.overtimeInPG.domain.PGTagPosition; +import com.casic.PgInterface.overtimeInPG.dto.PGPositionDto; +import com.casic.PgInterface.overtimeInPG.dto.PGTagPositionDto; +import org.hibernate.Criteria; +import org.hibernate.SQLQuery; +import org.hibernate.criterion.Restrictions; +import org.hibernate.procedure.ProcedureCall; +import org.hibernate.transform.Transformers; +import org.springframework.stereotype.Service; + +import javax.persistence.ParameterMode; +import java.util.HashMap; +import java.util.List; +import java.util.Map; + +@Service +public class PGTagPositionManager extends HibernateEntityDao{ + + public boolean findTagPosition(String dateStr,String hostId) + { + Criteria criteria = createCriteria(PGTagPosition.class); + criteria.add(Restrictions.and(Restrictions.eq("hostId",hostId),Restrictions.eq("positionUpdatetime",dateStr))); + criteria.add(Restrictions.sqlRestriction(" queryTime between sysdate-1 and sysdate")); + return criteria.setMaxResults(1).list().size()>0; + } + + public Map getRecentPosition() + { + Map retMap = new HashMap<>(); + List pgPositionDtoList ; + String querySql = " select * from tagPositionView "; + SQLQuery sqlQuery = (SQLQuery) this.getSession().createSQLQuery(querySql).setResultTransformer(Transformers.aliasToBean(PGPositionDto.class)); + pgPositionDtoList = sqlQuery.list(); + retMap.put("code",200); + retMap.put("message","success"); + retMap.put("data",pgPositionDtoList); + return retMap; + } + +} + + diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java new file mode 100644 index 0000000..acb4a18 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java @@ -0,0 +1,159 @@ +package com.casic.PgInterface.overtimeInPG.domain; + +import javax.persistence.*; +import java.io.Serializable; +import java.util.Date; + +//import org.hibernate.type.MaterializedClobType; +//import javax.annotation.Generated; +//import java.sql.Clob; + +@Entity +@Table(name = "PG_TAGPOSITION") +@SequenceGenerator(name ="SEQ_PG_TAGPOSITION_ID",sequenceName = "SEQ_PG_TAGPOSITION_ID",allocationSize = 1,initialValue = 1) +public class PGTagPosition implements Serializable { + private long id; + private String hostId; + private String hostName; + private String tagId; + private String tagName; + private String tagMac; + private String coordinatesName; + private String coordinate; + private String x; + private String y; + private String positionUpdatetime; + private Date parsedTime; + // private Date queryTime; + @Id +// @GeneratedValue(strategy = GenerationType.AUTO) + @GeneratedValue(strategy = GenerationType.SEQUENCE,generator ="SEQ_PG_TAGPOSITION_ID") + @Column(name = "ID") + public long getId() { + return id; + } + + public void setId(long id) { + this.id = id; + } + @Basic + @Column(name = "HOSTID" ) + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + @Basic + @Column(name = "HOSTNAME") + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + @Basic + @Column(name = "TAGID") + public String getTagId() { + return tagId; + } + + public void setTagId(String tagId) { + this.tagId = tagId; + } + @Basic + @Column(name = "TAGMAC") + public String getTagMac() { + return tagMac; + } + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + @Basic + @Column(name = "TAGMACNAME") + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + @Basic + @Column(name = "COORDINATESNAME") + public String getCoordinatesName() + { + return coordinatesName; + } + public void setCoordinatesName(String coordinatesName) + { + this.coordinatesName = coordinatesName; + } + + @Basic + @Column(name = "COORDINATE") + public String getCoordinate() + { + return coordinate; + } + public void setCoordinate(String coordinate) + { + this.coordinate = coordinate; + } + + @Basic + @Column(name = "X") + public String getX() + { + return x; + } + public void setX(String x) + { + this.x = x; + } + @Basic + @Column(name = "Y") + public String getY() + { + return y; + } + public void setY(String y) + { + this.y = y; + } + + @Basic + @Column(name = "POSITIONUPDATETIME") + public String getPositionUpdatetime() + { + return positionUpdatetime; + } + public void setPositionUpdatetime(String positionUpdatetime) + { + this.positionUpdatetime = positionUpdatetime; + } + + @Basic + @Column(name = "PARSEDTIME") + public Date getParsedTime() + { + return parsedTime; + } + public void setParsedTime(Date parsedTime) + { + this.parsedTime = parsedTime; + } + +// @Basic +// @Column(name = "QUERYTIME") +// public Date getQueryTime() +// { +// return queryTime; +// } +// public void setQueryTime(Date queryTime) +// { +// this.queryTime = queryTime; +// } + +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java new file mode 100644 index 0000000..5aa38cb --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java @@ -0,0 +1,94 @@ +package com.casic.PgInterface.overtimeInPG.dto; + + +public class PGPositionDto { + + public String tagMac; + public String tagName; + public String hostId; + public String hostName; + // public String TagId; +// public String CoordinatesId; + public String coordinatesName; + public String X; + public String Y; + public String positionUpdateTime; + + public String getTagMac() { + return tagMac; + } + + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + + public String getCoordinatesName() { + return coordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + this.coordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPositionUpdateTime() { + return positionUpdateTime; + } + + public void setPositionUpdateTime(String positionUpdateTime) { + this.positionUpdateTime = positionUpdateTime; + } + + @Override + public String toString() { + return "PGPositionDto{" + + "tagMac='" + tagMac + '\'' + + ", tagName='" + tagName + '\'' + + ", hostId='" + hostId + '\'' + + ", hostName='" + hostName + '\'' + + ", coordinatesName='" + coordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + positionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java new file mode 100644 index 0000000..57be186 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java @@ -0,0 +1,122 @@ +package com.casic.PgInterface.overtimeInPG.dto; + +import com.fasterxml.jackson.annotation.JsonIgnoreProperties; + +@JsonIgnoreProperties(ignoreUnknown = true) +public class PGTagPositionDto { + public String TagMac; + public String TagName; + public String HostId; + public String HostName; + public String TagId; + public String CoordinatesId; + public String CoordinatesName; + public String X; + public String Y; + public String postionUpdateTime; + + public String getCoordinatesId() { + return CoordinatesId; + } + + public void setCoordinatesId(String coordinatesId) { + CoordinatesId = coordinatesId; + } + + public String getCoordinatesName() { + return CoordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + CoordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPostionUpdateTime() { + return postionUpdateTime; + } + + public void setPostionUpdateTime(String postionUpdateTime) { + this.postionUpdateTime = postionUpdateTime; + } + +/* +{"Success":true,"ErrorCode":0,"ErrorText":"","TagId":11003,"TagMac":"B0:8E:1A:50:54:88", +"TagName":"马桶监测505488","SerialNo":"","MapId":2,"CoordinatesName":"101洗漱间", +"CoordinatesId":38,"X":-88.7699966430664,"Y":-24.059999465942383,"IsLowBattery":false, +"IsAreaWarning":false,"IsDisappeared":true,"IsBeltBroken":false,"IsReset":false, +"IsStill2Move":false,"IsMove2Still":false,"IsButtonPress":true,"HostName":"马桶监测505488", +"HostId":96,"HostGroupIds":[1,9],"HostStatusId":0,"HostExternalId":"5488","HostExternalInfo":"", +"postionUpdateTime":"2019-05-22T11:09:31.9387103+08:00"} + */ + + public String getTagId() { + return TagId; + } + + public void setTagId(String tagId) { + TagId = tagId; + } + + public String getTagMac() { + return TagMac; + } + + public void setTagMac(String tagMac) { + TagMac = tagMac; + } + + public String getTagName() { + return TagName; + } + + public void setTagName(String tagName) { + TagName = tagName; + } + public String getHostId() { + return HostId; + } + + public void setHostId(String hostId) { + HostId = hostId; + } + + public String getHostName() { + return HostName; + } + + public void setHostName(String hostName) { + HostName = hostName; + } + + @Override + public String toString() { + return "PGTagPositionDto{" + + "TagMac='" + TagMac + '\'' + + ", TagName='" + TagName + '\'' + + ", HostId='" + HostId + '\'' + + ", HostName='" + HostName + '\'' + + ", TagId='" + TagId + '\'' + + ", CoordinatesId='" + CoordinatesId + '\'' + + ", CoordinatesName='" + CoordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + postionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java b/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java new file mode 100644 index 0000000..0eb9245 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java @@ -0,0 +1,45 @@ +package com.casic.PgInterface.overtimeInPG.manager; + +import com.casic.PgInterface.core.hibernate.HibernateEntityDao; +import com.casic.PgInterface.overtimeInPG.domain.PGTagPosition; +import com.casic.PgInterface.overtimeInPG.dto.PGPositionDto; +import com.casic.PgInterface.overtimeInPG.dto.PGTagPositionDto; +import org.hibernate.Criteria; +import org.hibernate.SQLQuery; +import org.hibernate.criterion.Restrictions; +import org.hibernate.procedure.ProcedureCall; +import org.hibernate.transform.Transformers; +import org.springframework.stereotype.Service; + +import javax.persistence.ParameterMode; +import java.util.HashMap; +import java.util.List; +import java.util.Map; + +@Service +public class PGTagPositionManager extends HibernateEntityDao{ + + public boolean findTagPosition(String dateStr,String hostId) + { + Criteria criteria = createCriteria(PGTagPosition.class); + criteria.add(Restrictions.and(Restrictions.eq("hostId",hostId),Restrictions.eq("positionUpdatetime",dateStr))); + criteria.add(Restrictions.sqlRestriction(" queryTime between sysdate-1 and sysdate")); + return criteria.setMaxResults(1).list().size()>0; + } + + public Map getRecentPosition() + { + Map retMap = new HashMap<>(); + List pgPositionDtoList ; + String querySql = " select * from tagPositionView "; + SQLQuery sqlQuery = (SQLQuery) this.getSession().createSQLQuery(querySql).setResultTransformer(Transformers.aliasToBean(PGPositionDto.class)); + pgPositionDtoList = sqlQuery.list(); + retMap.put("code",200); + retMap.put("message","success"); + retMap.put("data",pgPositionDtoList); + return retMap; + } + +} + + diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java b/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java index 685fbf1..77eddab 100644 --- a/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java @@ -4,9 +4,13 @@ import com.casic.PgInterface.core.util.StringUtils; import com.casic.PgInterface.core.util.configProperty; import com.casic.PgInterface.overtimeInPG.domain.PGTagMac; +import com.casic.PgInterface.overtimeInPG.domain.PGTagPosition; import com.casic.PgInterface.overtimeInPG.dto.PGTagMacDto; +import com.casic.PgInterface.overtimeInPG.dto.PGTagPositionDto; import com.casic.PgInterface.overtimeInPG.manager.PGTagMacManager; +import com.casic.PgInterface.overtimeInPG.manager.PGTagPositionManager; import com.jayway.jsonpath.Configuration; +import com.jayway.jsonpath.*; import com.jayway.jsonpath.JsonPath; import com.jayway.jsonpath.ReadContext; import com.jayway.jsonpath.TypeRef; @@ -16,8 +20,10 @@ import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Service; +import com.jayway.jsonpath.spi.json.JsonProvider; import javax.annotation.Resource; +import java.lang.reflect.InvocationTargetException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; @@ -34,6 +40,8 @@ private static final Logger logger = LoggerFactory.getLogger(TagmacRun.class); @Resource private PGTagMacManager pgTagMacManager; + @Resource + private PGTagPositionManager pgTagPositionManager; public void getAllMac() { TypeRef> tagMacType = new TypeRef>() { @@ -65,6 +73,47 @@ } } } + public void getMacPosition() throws ParseException { + TypeRef> tagPositionType = new TypeRef>() { + }; + SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + String allTagPosition=null; + // String allTagPosition=null; + allTagPosition = HttpClientUtils.get(getAllUrl,authorization); + logger.info("allTagPosition:"+allTagPosition); + if (StringUtils.isNotBlank(allTagPosition)) { + ReadContext readContext = JsonPath.using(configuration).parse(allTagPosition); + if ("true".equals(readContext.read("$.Success",String.class))) + { + List tagPositionList = readContext.read("$.AllResult", tagPositionType); + logger.info("size:" + tagPositionList.size()); + if (tagPositionList.size()>0) { + for (PGTagPositionDto tagPosition : tagPositionList) { + PGTagPosition pgTagPosition = new PGTagPosition(); +// PGTagPosition pgTagPositionTmp = new PGTagPosition(); + System.out.println("info:"+tagPosition.toString()); + boolean bExist = false; + bExist = pgTagPositionManager.findTagPosition(tagPosition.getPostionUpdateTime(),tagPosition.getHostId()); + if (bExist) continue;// only sync, no update for the record ,efficency + pgTagPosition.setHostId(tagPosition.getHostId()); + pgTagPosition.setHostName(tagPosition.getHostName()); + pgTagPosition.setTagId(tagPosition.getTagId()); + pgTagPosition.setTagMac(tagPosition.getTagMac()); + pgTagPosition.setTagName(tagPosition.getTagName()); + pgTagPosition.setX(tagPosition.getX()); + pgTagPosition.setY(tagPosition.getY()); + pgTagPosition.setCoordinate(tagPosition.getCoordinatesId()); + pgTagPosition.setCoordinatesName(tagPosition.getCoordinatesName()); + pgTagPosition.setPositionUpdatetime(tagPosition.getPostionUpdateTime()); + pgTagPosition.setParsedTime(simpleDateFormat.parse(tagPosition.getPostionUpdateTime().substring(0,19).replaceFirst("T"," "))); +// if (pgTagPositionTmp != null ) +// pgTagPosition.setId(pgTagPositionTmp.getId()); + pgTagPositionManager.save(pgTagPosition); + } + } + } + } + } public void postInOut(String strFrom) { Calendar calendar = Calendar.getInstance(); @@ -149,8 +198,10 @@ // logger.info("query:"+pgInOutRecManager.getInOutRec("2019-01-01","2019-06-02").toString()); } - public static void main(String[] args) { -// getAllMac(); + public static void main(String[] args) throws ParseException { + TagmacRun tagmacRun = new TagmacRun(); +// tagmacRun.getMacPosition(); + tagmacRun.getAllMac(); } } diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java new file mode 100644 index 0000000..acb4a18 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java @@ -0,0 +1,159 @@ +package com.casic.PgInterface.overtimeInPG.domain; + +import javax.persistence.*; +import java.io.Serializable; +import java.util.Date; + +//import org.hibernate.type.MaterializedClobType; +//import javax.annotation.Generated; +//import java.sql.Clob; + +@Entity +@Table(name = "PG_TAGPOSITION") +@SequenceGenerator(name ="SEQ_PG_TAGPOSITION_ID",sequenceName = "SEQ_PG_TAGPOSITION_ID",allocationSize = 1,initialValue = 1) +public class PGTagPosition implements Serializable { + private long id; + private String hostId; + private String hostName; + private String tagId; + private String tagName; + private String tagMac; + private String coordinatesName; + private String coordinate; + private String x; + private String y; + private String positionUpdatetime; + private Date parsedTime; + // private Date queryTime; + @Id +// @GeneratedValue(strategy = GenerationType.AUTO) + @GeneratedValue(strategy = GenerationType.SEQUENCE,generator ="SEQ_PG_TAGPOSITION_ID") + @Column(name = "ID") + public long getId() { + return id; + } + + public void setId(long id) { + this.id = id; + } + @Basic + @Column(name = "HOSTID" ) + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + @Basic + @Column(name = "HOSTNAME") + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + @Basic + @Column(name = "TAGID") + public String getTagId() { + return tagId; + } + + public void setTagId(String tagId) { + this.tagId = tagId; + } + @Basic + @Column(name = "TAGMAC") + public String getTagMac() { + return tagMac; + } + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + @Basic + @Column(name = "TAGMACNAME") + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + @Basic + @Column(name = "COORDINATESNAME") + public String getCoordinatesName() + { + return coordinatesName; + } + public void setCoordinatesName(String coordinatesName) + { + this.coordinatesName = coordinatesName; + } + + @Basic + @Column(name = "COORDINATE") + public String getCoordinate() + { + return coordinate; + } + public void setCoordinate(String coordinate) + { + this.coordinate = coordinate; + } + + @Basic + @Column(name = "X") + public String getX() + { + return x; + } + public void setX(String x) + { + this.x = x; + } + @Basic + @Column(name = "Y") + public String getY() + { + return y; + } + public void setY(String y) + { + this.y = y; + } + + @Basic + @Column(name = "POSITIONUPDATETIME") + public String getPositionUpdatetime() + { + return positionUpdatetime; + } + public void setPositionUpdatetime(String positionUpdatetime) + { + this.positionUpdatetime = positionUpdatetime; + } + + @Basic + @Column(name = "PARSEDTIME") + public Date getParsedTime() + { + return parsedTime; + } + public void setParsedTime(Date parsedTime) + { + this.parsedTime = parsedTime; + } + +// @Basic +// @Column(name = "QUERYTIME") +// public Date getQueryTime() +// { +// return queryTime; +// } +// public void setQueryTime(Date queryTime) +// { +// this.queryTime = queryTime; +// } + +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java new file mode 100644 index 0000000..5aa38cb --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java @@ -0,0 +1,94 @@ +package com.casic.PgInterface.overtimeInPG.dto; + + +public class PGPositionDto { + + public String tagMac; + public String tagName; + public String hostId; + public String hostName; + // public String TagId; +// public String CoordinatesId; + public String coordinatesName; + public String X; + public String Y; + public String positionUpdateTime; + + public String getTagMac() { + return tagMac; + } + + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + + public String getCoordinatesName() { + return coordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + this.coordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPositionUpdateTime() { + return positionUpdateTime; + } + + public void setPositionUpdateTime(String positionUpdateTime) { + this.positionUpdateTime = positionUpdateTime; + } + + @Override + public String toString() { + return "PGPositionDto{" + + "tagMac='" + tagMac + '\'' + + ", tagName='" + tagName + '\'' + + ", hostId='" + hostId + '\'' + + ", hostName='" + hostName + '\'' + + ", coordinatesName='" + coordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + positionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java new file mode 100644 index 0000000..57be186 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java @@ -0,0 +1,122 @@ +package com.casic.PgInterface.overtimeInPG.dto; + +import com.fasterxml.jackson.annotation.JsonIgnoreProperties; + +@JsonIgnoreProperties(ignoreUnknown = true) +public class PGTagPositionDto { + public String TagMac; + public String TagName; + public String HostId; + public String HostName; + public String TagId; + public String CoordinatesId; + public String CoordinatesName; + public String X; + public String Y; + public String postionUpdateTime; + + public String getCoordinatesId() { + return CoordinatesId; + } + + public void setCoordinatesId(String coordinatesId) { + CoordinatesId = coordinatesId; + } + + public String getCoordinatesName() { + return CoordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + CoordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPostionUpdateTime() { + return postionUpdateTime; + } + + public void setPostionUpdateTime(String postionUpdateTime) { + this.postionUpdateTime = postionUpdateTime; + } + +/* +{"Success":true,"ErrorCode":0,"ErrorText":"","TagId":11003,"TagMac":"B0:8E:1A:50:54:88", +"TagName":"马桶监测505488","SerialNo":"","MapId":2,"CoordinatesName":"101洗漱间", +"CoordinatesId":38,"X":-88.7699966430664,"Y":-24.059999465942383,"IsLowBattery":false, +"IsAreaWarning":false,"IsDisappeared":true,"IsBeltBroken":false,"IsReset":false, +"IsStill2Move":false,"IsMove2Still":false,"IsButtonPress":true,"HostName":"马桶监测505488", +"HostId":96,"HostGroupIds":[1,9],"HostStatusId":0,"HostExternalId":"5488","HostExternalInfo":"", +"postionUpdateTime":"2019-05-22T11:09:31.9387103+08:00"} + */ + + public String getTagId() { + return TagId; + } + + public void setTagId(String tagId) { + TagId = tagId; + } + + public String getTagMac() { + return TagMac; + } + + public void setTagMac(String tagMac) { + TagMac = tagMac; + } + + public String getTagName() { + return TagName; + } + + public void setTagName(String tagName) { + TagName = tagName; + } + public String getHostId() { + return HostId; + } + + public void setHostId(String hostId) { + HostId = hostId; + } + + public String getHostName() { + return HostName; + } + + public void setHostName(String hostName) { + HostName = hostName; + } + + @Override + public String toString() { + return "PGTagPositionDto{" + + "TagMac='" + TagMac + '\'' + + ", TagName='" + TagName + '\'' + + ", HostId='" + HostId + '\'' + + ", HostName='" + HostName + '\'' + + ", TagId='" + TagId + '\'' + + ", CoordinatesId='" + CoordinatesId + '\'' + + ", CoordinatesName='" + CoordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + postionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java b/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java new file mode 100644 index 0000000..0eb9245 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java @@ -0,0 +1,45 @@ +package com.casic.PgInterface.overtimeInPG.manager; + +import com.casic.PgInterface.core.hibernate.HibernateEntityDao; +import com.casic.PgInterface.overtimeInPG.domain.PGTagPosition; +import com.casic.PgInterface.overtimeInPG.dto.PGPositionDto; +import com.casic.PgInterface.overtimeInPG.dto.PGTagPositionDto; +import org.hibernate.Criteria; +import org.hibernate.SQLQuery; +import org.hibernate.criterion.Restrictions; +import org.hibernate.procedure.ProcedureCall; +import org.hibernate.transform.Transformers; +import org.springframework.stereotype.Service; + +import javax.persistence.ParameterMode; +import java.util.HashMap; +import java.util.List; +import java.util.Map; + +@Service +public class PGTagPositionManager extends HibernateEntityDao{ + + public boolean findTagPosition(String dateStr,String hostId) + { + Criteria criteria = createCriteria(PGTagPosition.class); + criteria.add(Restrictions.and(Restrictions.eq("hostId",hostId),Restrictions.eq("positionUpdatetime",dateStr))); + criteria.add(Restrictions.sqlRestriction(" queryTime between sysdate-1 and sysdate")); + return criteria.setMaxResults(1).list().size()>0; + } + + public Map getRecentPosition() + { + Map retMap = new HashMap<>(); + List pgPositionDtoList ; + String querySql = " select * from tagPositionView "; + SQLQuery sqlQuery = (SQLQuery) this.getSession().createSQLQuery(querySql).setResultTransformer(Transformers.aliasToBean(PGPositionDto.class)); + pgPositionDtoList = sqlQuery.list(); + retMap.put("code",200); + retMap.put("message","success"); + retMap.put("data",pgPositionDtoList); + return retMap; + } + +} + + diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java b/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java index 685fbf1..77eddab 100644 --- a/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java @@ -4,9 +4,13 @@ import com.casic.PgInterface.core.util.StringUtils; import com.casic.PgInterface.core.util.configProperty; import com.casic.PgInterface.overtimeInPG.domain.PGTagMac; +import com.casic.PgInterface.overtimeInPG.domain.PGTagPosition; import com.casic.PgInterface.overtimeInPG.dto.PGTagMacDto; +import com.casic.PgInterface.overtimeInPG.dto.PGTagPositionDto; import com.casic.PgInterface.overtimeInPG.manager.PGTagMacManager; +import com.casic.PgInterface.overtimeInPG.manager.PGTagPositionManager; import com.jayway.jsonpath.Configuration; +import com.jayway.jsonpath.*; import com.jayway.jsonpath.JsonPath; import com.jayway.jsonpath.ReadContext; import com.jayway.jsonpath.TypeRef; @@ -16,8 +20,10 @@ import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Service; +import com.jayway.jsonpath.spi.json.JsonProvider; import javax.annotation.Resource; +import java.lang.reflect.InvocationTargetException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; @@ -34,6 +40,8 @@ private static final Logger logger = LoggerFactory.getLogger(TagmacRun.class); @Resource private PGTagMacManager pgTagMacManager; + @Resource + private PGTagPositionManager pgTagPositionManager; public void getAllMac() { TypeRef> tagMacType = new TypeRef>() { @@ -65,6 +73,47 @@ } } } + public void getMacPosition() throws ParseException { + TypeRef> tagPositionType = new TypeRef>() { + }; + SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + String allTagPosition=null; + // String allTagPosition=null; + allTagPosition = HttpClientUtils.get(getAllUrl,authorization); + logger.info("allTagPosition:"+allTagPosition); + if (StringUtils.isNotBlank(allTagPosition)) { + ReadContext readContext = JsonPath.using(configuration).parse(allTagPosition); + if ("true".equals(readContext.read("$.Success",String.class))) + { + List tagPositionList = readContext.read("$.AllResult", tagPositionType); + logger.info("size:" + tagPositionList.size()); + if (tagPositionList.size()>0) { + for (PGTagPositionDto tagPosition : tagPositionList) { + PGTagPosition pgTagPosition = new PGTagPosition(); +// PGTagPosition pgTagPositionTmp = new PGTagPosition(); + System.out.println("info:"+tagPosition.toString()); + boolean bExist = false; + bExist = pgTagPositionManager.findTagPosition(tagPosition.getPostionUpdateTime(),tagPosition.getHostId()); + if (bExist) continue;// only sync, no update for the record ,efficency + pgTagPosition.setHostId(tagPosition.getHostId()); + pgTagPosition.setHostName(tagPosition.getHostName()); + pgTagPosition.setTagId(tagPosition.getTagId()); + pgTagPosition.setTagMac(tagPosition.getTagMac()); + pgTagPosition.setTagName(tagPosition.getTagName()); + pgTagPosition.setX(tagPosition.getX()); + pgTagPosition.setY(tagPosition.getY()); + pgTagPosition.setCoordinate(tagPosition.getCoordinatesId()); + pgTagPosition.setCoordinatesName(tagPosition.getCoordinatesName()); + pgTagPosition.setPositionUpdatetime(tagPosition.getPostionUpdateTime()); + pgTagPosition.setParsedTime(simpleDateFormat.parse(tagPosition.getPostionUpdateTime().substring(0,19).replaceFirst("T"," "))); +// if (pgTagPositionTmp != null ) +// pgTagPosition.setId(pgTagPositionTmp.getId()); + pgTagPositionManager.save(pgTagPosition); + } + } + } + } + } public void postInOut(String strFrom) { Calendar calendar = Calendar.getInstance(); @@ -149,8 +198,10 @@ // logger.info("query:"+pgInOutRecManager.getInOutRec("2019-01-01","2019-06-02").toString()); } - public static void main(String[] args) { -// getAllMac(); + public static void main(String[] args) throws ParseException { + TagmacRun tagmacRun = new TagmacRun(); +// tagmacRun.getMacPosition(); + tagmacRun.getAllMac(); } } diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java b/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java new file mode 100644 index 0000000..4f14abf --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java @@ -0,0 +1,46 @@ +package com.casic.PgInterface.overtimeInPG.web; + + +import com.casic.PgInterface.overtimeInPG.manager.PGInOutRecManager; +import com.casic.PgInterface.overtimeInPG.manager.PGTagPositionManager; +import org.springframework.stereotype.Controller; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RequestParam; +import org.springframework.web.bind.annotation.ResponseBody; + +import javax.annotation.Resource; +import java.util.HashMap; +import java.util.Map; + +@Controller +@RequestMapping("InOutPGrec") +public class PGInOutRecController { +@Resource +private PGInOutRecManager pgInOutRecManager; +@Resource +private PGTagPositionManager pgTagPositionManager; + + @RequestMapping("query") + @ResponseBody + public Map query(@RequestParam(value = "dtFrom", required = true) String dtFrom,@RequestParam(value = "dtTo", required = true) String dtTo) + { + Map resultMap = new HashMap<>(); + resultMap = pgInOutRecManager.getInOutRec(dtFrom,dtTo); + return resultMap; + } + + @RequestMapping("getRecentPosition") + @ResponseBody + public Map getRecentPosition() + { + return pgTagPositionManager.getRecentPosition(); + } + @RequestMapping("getHistoryByTagmac") + @ResponseBody + public Map getHistoryByTagmac() + { + Map resultMap = new HashMap<>(); + + return resultMap; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java new file mode 100644 index 0000000..acb4a18 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/domain/PGTagPosition.java @@ -0,0 +1,159 @@ +package com.casic.PgInterface.overtimeInPG.domain; + +import javax.persistence.*; +import java.io.Serializable; +import java.util.Date; + +//import org.hibernate.type.MaterializedClobType; +//import javax.annotation.Generated; +//import java.sql.Clob; + +@Entity +@Table(name = "PG_TAGPOSITION") +@SequenceGenerator(name ="SEQ_PG_TAGPOSITION_ID",sequenceName = "SEQ_PG_TAGPOSITION_ID",allocationSize = 1,initialValue = 1) +public class PGTagPosition implements Serializable { + private long id; + private String hostId; + private String hostName; + private String tagId; + private String tagName; + private String tagMac; + private String coordinatesName; + private String coordinate; + private String x; + private String y; + private String positionUpdatetime; + private Date parsedTime; + // private Date queryTime; + @Id +// @GeneratedValue(strategy = GenerationType.AUTO) + @GeneratedValue(strategy = GenerationType.SEQUENCE,generator ="SEQ_PG_TAGPOSITION_ID") + @Column(name = "ID") + public long getId() { + return id; + } + + public void setId(long id) { + this.id = id; + } + @Basic + @Column(name = "HOSTID" ) + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + @Basic + @Column(name = "HOSTNAME") + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + @Basic + @Column(name = "TAGID") + public String getTagId() { + return tagId; + } + + public void setTagId(String tagId) { + this.tagId = tagId; + } + @Basic + @Column(name = "TAGMAC") + public String getTagMac() { + return tagMac; + } + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + @Basic + @Column(name = "TAGMACNAME") + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + @Basic + @Column(name = "COORDINATESNAME") + public String getCoordinatesName() + { + return coordinatesName; + } + public void setCoordinatesName(String coordinatesName) + { + this.coordinatesName = coordinatesName; + } + + @Basic + @Column(name = "COORDINATE") + public String getCoordinate() + { + return coordinate; + } + public void setCoordinate(String coordinate) + { + this.coordinate = coordinate; + } + + @Basic + @Column(name = "X") + public String getX() + { + return x; + } + public void setX(String x) + { + this.x = x; + } + @Basic + @Column(name = "Y") + public String getY() + { + return y; + } + public void setY(String y) + { + this.y = y; + } + + @Basic + @Column(name = "POSITIONUPDATETIME") + public String getPositionUpdatetime() + { + return positionUpdatetime; + } + public void setPositionUpdatetime(String positionUpdatetime) + { + this.positionUpdatetime = positionUpdatetime; + } + + @Basic + @Column(name = "PARSEDTIME") + public Date getParsedTime() + { + return parsedTime; + } + public void setParsedTime(Date parsedTime) + { + this.parsedTime = parsedTime; + } + +// @Basic +// @Column(name = "QUERYTIME") +// public Date getQueryTime() +// { +// return queryTime; +// } +// public void setQueryTime(Date queryTime) +// { +// this.queryTime = queryTime; +// } + +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java new file mode 100644 index 0000000..5aa38cb --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGPositionDto.java @@ -0,0 +1,94 @@ +package com.casic.PgInterface.overtimeInPG.dto; + + +public class PGPositionDto { + + public String tagMac; + public String tagName; + public String hostId; + public String hostName; + // public String TagId; +// public String CoordinatesId; + public String coordinatesName; + public String X; + public String Y; + public String positionUpdateTime; + + public String getTagMac() { + return tagMac; + } + + public void setTagMac(String tagMac) { + this.tagMac = tagMac; + } + + public String getTagName() { + return tagName; + } + + public void setTagName(String tagName) { + this.tagName = tagName; + } + + public String getHostId() { + return hostId; + } + + public void setHostId(String hostId) { + this.hostId = hostId; + } + + public String getHostName() { + return hostName; + } + + public void setHostName(String hostName) { + this.hostName = hostName; + } + + public String getCoordinatesName() { + return coordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + this.coordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPositionUpdateTime() { + return positionUpdateTime; + } + + public void setPositionUpdateTime(String positionUpdateTime) { + this.positionUpdateTime = positionUpdateTime; + } + + @Override + public String toString() { + return "PGPositionDto{" + + "tagMac='" + tagMac + '\'' + + ", tagName='" + tagName + '\'' + + ", hostId='" + hostId + '\'' + + ", hostName='" + hostName + '\'' + + ", coordinatesName='" + coordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + positionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java new file mode 100644 index 0000000..57be186 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/dto/PGTagPositionDto.java @@ -0,0 +1,122 @@ +package com.casic.PgInterface.overtimeInPG.dto; + +import com.fasterxml.jackson.annotation.JsonIgnoreProperties; + +@JsonIgnoreProperties(ignoreUnknown = true) +public class PGTagPositionDto { + public String TagMac; + public String TagName; + public String HostId; + public String HostName; + public String TagId; + public String CoordinatesId; + public String CoordinatesName; + public String X; + public String Y; + public String postionUpdateTime; + + public String getCoordinatesId() { + return CoordinatesId; + } + + public void setCoordinatesId(String coordinatesId) { + CoordinatesId = coordinatesId; + } + + public String getCoordinatesName() { + return CoordinatesName; + } + + public void setCoordinatesName(String coordinatesName) { + CoordinatesName = coordinatesName; + } + + public String getX() { + return X; + } + + public void setX(String x) { + X = x; + } + + public String getY() { + return Y; + } + + public void setY(String y) { + Y = y; + } + + public String getPostionUpdateTime() { + return postionUpdateTime; + } + + public void setPostionUpdateTime(String postionUpdateTime) { + this.postionUpdateTime = postionUpdateTime; + } + +/* +{"Success":true,"ErrorCode":0,"ErrorText":"","TagId":11003,"TagMac":"B0:8E:1A:50:54:88", +"TagName":"马桶监测505488","SerialNo":"","MapId":2,"CoordinatesName":"101洗漱间", +"CoordinatesId":38,"X":-88.7699966430664,"Y":-24.059999465942383,"IsLowBattery":false, +"IsAreaWarning":false,"IsDisappeared":true,"IsBeltBroken":false,"IsReset":false, +"IsStill2Move":false,"IsMove2Still":false,"IsButtonPress":true,"HostName":"马桶监测505488", +"HostId":96,"HostGroupIds":[1,9],"HostStatusId":0,"HostExternalId":"5488","HostExternalInfo":"", +"postionUpdateTime":"2019-05-22T11:09:31.9387103+08:00"} + */ + + public String getTagId() { + return TagId; + } + + public void setTagId(String tagId) { + TagId = tagId; + } + + public String getTagMac() { + return TagMac; + } + + public void setTagMac(String tagMac) { + TagMac = tagMac; + } + + public String getTagName() { + return TagName; + } + + public void setTagName(String tagName) { + TagName = tagName; + } + public String getHostId() { + return HostId; + } + + public void setHostId(String hostId) { + HostId = hostId; + } + + public String getHostName() { + return HostName; + } + + public void setHostName(String hostName) { + HostName = hostName; + } + + @Override + public String toString() { + return "PGTagPositionDto{" + + "TagMac='" + TagMac + '\'' + + ", TagName='" + TagName + '\'' + + ", HostId='" + HostId + '\'' + + ", HostName='" + HostName + '\'' + + ", TagId='" + TagId + '\'' + + ", CoordinatesId='" + CoordinatesId + '\'' + + ", CoordinatesName='" + CoordinatesName + '\'' + + ", X='" + X + '\'' + + ", Y='" + Y + '\'' + + ", postionUpdateTime='" + postionUpdateTime + '\'' + + '}'; + } +} diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java b/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java new file mode 100644 index 0000000..0eb9245 --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/manager/PGTagPositionManager.java @@ -0,0 +1,45 @@ +package com.casic.PgInterface.overtimeInPG.manager; + +import com.casic.PgInterface.core.hibernate.HibernateEntityDao; +import com.casic.PgInterface.overtimeInPG.domain.PGTagPosition; +import com.casic.PgInterface.overtimeInPG.dto.PGPositionDto; +import com.casic.PgInterface.overtimeInPG.dto.PGTagPositionDto; +import org.hibernate.Criteria; +import org.hibernate.SQLQuery; +import org.hibernate.criterion.Restrictions; +import org.hibernate.procedure.ProcedureCall; +import org.hibernate.transform.Transformers; +import org.springframework.stereotype.Service; + +import javax.persistence.ParameterMode; +import java.util.HashMap; +import java.util.List; +import java.util.Map; + +@Service +public class PGTagPositionManager extends HibernateEntityDao{ + + public boolean findTagPosition(String dateStr,String hostId) + { + Criteria criteria = createCriteria(PGTagPosition.class); + criteria.add(Restrictions.and(Restrictions.eq("hostId",hostId),Restrictions.eq("positionUpdatetime",dateStr))); + criteria.add(Restrictions.sqlRestriction(" queryTime between sysdate-1 and sysdate")); + return criteria.setMaxResults(1).list().size()>0; + } + + public Map getRecentPosition() + { + Map retMap = new HashMap<>(); + List pgPositionDtoList ; + String querySql = " select * from tagPositionView "; + SQLQuery sqlQuery = (SQLQuery) this.getSession().createSQLQuery(querySql).setResultTransformer(Transformers.aliasToBean(PGPositionDto.class)); + pgPositionDtoList = sqlQuery.list(); + retMap.put("code",200); + retMap.put("message","success"); + retMap.put("data",pgPositionDtoList); + return retMap; + } + +} + + diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java b/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java index 685fbf1..77eddab 100644 --- a/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/task/TagmacRun.java @@ -4,9 +4,13 @@ import com.casic.PgInterface.core.util.StringUtils; import com.casic.PgInterface.core.util.configProperty; import com.casic.PgInterface.overtimeInPG.domain.PGTagMac; +import com.casic.PgInterface.overtimeInPG.domain.PGTagPosition; import com.casic.PgInterface.overtimeInPG.dto.PGTagMacDto; +import com.casic.PgInterface.overtimeInPG.dto.PGTagPositionDto; import com.casic.PgInterface.overtimeInPG.manager.PGTagMacManager; +import com.casic.PgInterface.overtimeInPG.manager.PGTagPositionManager; import com.jayway.jsonpath.Configuration; +import com.jayway.jsonpath.*; import com.jayway.jsonpath.JsonPath; import com.jayway.jsonpath.ReadContext; import com.jayway.jsonpath.TypeRef; @@ -16,8 +20,10 @@ import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Service; +import com.jayway.jsonpath.spi.json.JsonProvider; import javax.annotation.Resource; +import java.lang.reflect.InvocationTargetException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; @@ -34,6 +40,8 @@ private static final Logger logger = LoggerFactory.getLogger(TagmacRun.class); @Resource private PGTagMacManager pgTagMacManager; + @Resource + private PGTagPositionManager pgTagPositionManager; public void getAllMac() { TypeRef> tagMacType = new TypeRef>() { @@ -65,6 +73,47 @@ } } } + public void getMacPosition() throws ParseException { + TypeRef> tagPositionType = new TypeRef>() { + }; + SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + String allTagPosition=null; + // String allTagPosition=null; + allTagPosition = HttpClientUtils.get(getAllUrl,authorization); + logger.info("allTagPosition:"+allTagPosition); + if (StringUtils.isNotBlank(allTagPosition)) { + ReadContext readContext = JsonPath.using(configuration).parse(allTagPosition); + if ("true".equals(readContext.read("$.Success",String.class))) + { + List tagPositionList = readContext.read("$.AllResult", tagPositionType); + logger.info("size:" + tagPositionList.size()); + if (tagPositionList.size()>0) { + for (PGTagPositionDto tagPosition : tagPositionList) { + PGTagPosition pgTagPosition = new PGTagPosition(); +// PGTagPosition pgTagPositionTmp = new PGTagPosition(); + System.out.println("info:"+tagPosition.toString()); + boolean bExist = false; + bExist = pgTagPositionManager.findTagPosition(tagPosition.getPostionUpdateTime(),tagPosition.getHostId()); + if (bExist) continue;// only sync, no update for the record ,efficency + pgTagPosition.setHostId(tagPosition.getHostId()); + pgTagPosition.setHostName(tagPosition.getHostName()); + pgTagPosition.setTagId(tagPosition.getTagId()); + pgTagPosition.setTagMac(tagPosition.getTagMac()); + pgTagPosition.setTagName(tagPosition.getTagName()); + pgTagPosition.setX(tagPosition.getX()); + pgTagPosition.setY(tagPosition.getY()); + pgTagPosition.setCoordinate(tagPosition.getCoordinatesId()); + pgTagPosition.setCoordinatesName(tagPosition.getCoordinatesName()); + pgTagPosition.setPositionUpdatetime(tagPosition.getPostionUpdateTime()); + pgTagPosition.setParsedTime(simpleDateFormat.parse(tagPosition.getPostionUpdateTime().substring(0,19).replaceFirst("T"," "))); +// if (pgTagPositionTmp != null ) +// pgTagPosition.setId(pgTagPositionTmp.getId()); + pgTagPositionManager.save(pgTagPosition); + } + } + } + } + } public void postInOut(String strFrom) { Calendar calendar = Calendar.getInstance(); @@ -149,8 +198,10 @@ // logger.info("query:"+pgInOutRecManager.getInOutRec("2019-01-01","2019-06-02").toString()); } - public static void main(String[] args) { -// getAllMac(); + public static void main(String[] args) throws ParseException { + TagmacRun tagmacRun = new TagmacRun(); +// tagmacRun.getMacPosition(); + tagmacRun.getAllMac(); } } diff --git a/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java b/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java new file mode 100644 index 0000000..4f14abf --- /dev/null +++ b/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java @@ -0,0 +1,46 @@ +package com.casic.PgInterface.overtimeInPG.web; + + +import com.casic.PgInterface.overtimeInPG.manager.PGInOutRecManager; +import com.casic.PgInterface.overtimeInPG.manager.PGTagPositionManager; +import org.springframework.stereotype.Controller; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RequestParam; +import org.springframework.web.bind.annotation.ResponseBody; + +import javax.annotation.Resource; +import java.util.HashMap; +import java.util.Map; + +@Controller +@RequestMapping("InOutPGrec") +public class PGInOutRecController { +@Resource +private PGInOutRecManager pgInOutRecManager; +@Resource +private PGTagPositionManager pgTagPositionManager; + + @RequestMapping("query") + @ResponseBody + public Map query(@RequestParam(value = "dtFrom", required = true) String dtFrom,@RequestParam(value = "dtTo", required = true) String dtTo) + { + Map resultMap = new HashMap<>(); + resultMap = pgInOutRecManager.getInOutRec(dtFrom,dtTo); + return resultMap; + } + + @RequestMapping("getRecentPosition") + @ResponseBody + public Map getRecentPosition() + { + return pgTagPositionManager.getRecentPosition(); + } + @RequestMapping("getHistoryByTagmac") + @ResponseBody + public Map getHistoryByTagmac() + { + Map resultMap = new HashMap<>(); + + return resultMap; + } +} diff --git a/tagPosition.sql b/tagPosition.sql new file mode 100644 index 0000000..ae9ba82 --- /dev/null +++ b/tagPosition.sql @@ -0,0 +1,592 @@ +prompt PL/SQL Developer Export Tables for user ZHYQ@XE +prompt Created by LenovoWork on 20190709 +set feedback off +set define off + +prompt Dropping PG_TAGPOSITION... +drop table PG_TAGPOSITION cascade constraints; +prompt Creating PG_TAGPOSITION... +create table PG_TAGPOSITION +( + id NUMBER(11) default 0 not null, + hostid VARCHAR2(20) not null, + hostname VARCHAR2(100), + tagid VARCHAR2(20) not null, + tagmac VARCHAR2(30) not null, + tagmacname VARCHAR2(100), + coordinatesname VARCHAR2(100), + coordinate VARCHAR2(20), + x VARCHAR2(30), + y VARCHAR2(30), + positionupdatetime VARCHAR2(40), + parsedtime DATE, + querytime DATE default sysdate +) +tablespace USERS + pctfree 10 + initrans 1 + maxtrans 255 + storage + ( + initial 64K + next 1M + minextents 1 + maxextents unlimited + ); +create index QUERYTIME_IDX on PG_TAGPOSITION (QUERYTIME) + tablespace USERS + pctfree 10 + initrans 2 + maxtrans 255 + storage + ( + initial 64K + next 1M + minextents 1 + maxextents unlimited + ); +alter table PG_TAGPOSITION + add constraint TAGPOSITION_ID_PK primary key (ID) + using index + tablespace USERS + pctfree 10 + initrans 2 + maxtrans 255 + storage + ( + initial 64K + next 1M + minextents 1 + maxextents unlimited + ); + +prompt Disabling triggers for PG_TAGPOSITION... +alter table PG_TAGPOSITION disable all triggers; +prompt Loading PG_TAGPOSITION... +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (194, '112', '谢晓威', '14449', 'B0:8E:1A:40:0D:B3', 'B0:8E:1A:40:0D:B3', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4273762+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (195, '186', '0D68', '27260', 'B0:8E:1A:41:0D:68', 'B0:8E:1A:41:0D:68', null, '1160', '-3.7899999618530273', '-3.869999885559082', '2019-07-08T13:32:55.6406975+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (196, '214', '蓝牙标签0129-360351', '30420', 'B0:8E:1A:36:03:51', 'B0:8E:1A:36:03:51', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:07.2298563+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (197, '151', 'Model_D 011A（1-24）', '17745', 'B0:8E:1A:33:01:1A', 'B0:8E:1A:33:01:1A', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5383873+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (198, '243', '楚云飞', '27776', 'B0:8E:1A:41:10:80', 'B0:8E:1A:41:10:80', null, '33', '40.84', '39.54', '2019-07-09T09:34:00.7033423+08:00', to_date('09-07-2019 09:34:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (199, '238', '3568', '32059', '02:90:30:35:35:68', '02:90:30:35:35:68', null, '1242', '-91.06999969482422', '-37.7400016784668', '2019-07-08T13:33:13.2344567+08:00', to_date('08-07-2019 13:33:13', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (200, '144', 'Model-D 测试0548', '17429', 'B0:8E:1A:33:05:48', 'B0:8E:1A:33:05:48', null, '38', '-85.63287353515625', '-23.543903350830078', '2019-07-08T13:32:52.5123847+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (201, '142', 'Model-D 测试0544', '17399', 'B0:8E:1A:33:05:44', 'B0:8E:1A:33:05:44', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.4923827+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (202, '153', 'NEWAPI4796', '11449', 'B0:8E:1A:50:47:96', 'B0:8E:1A:50:47:96', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.2043539+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (203, '225', '0019', '14130', 'B0:8E:1A:40:00:19', 'B0:8E:1A:40:00:19', null, '0', '-1.0', '-1.0', '2019-07-08T13:32:52.3843719+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (204, '136', '测试0013', '16423', 'B0:8E:1A:40:00:13', 'B0:8E:1A:40:00:13', null, '33', '-44.05439376831055', '-38.5018424987793', '2019-07-08T13:32:52.4693804+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (205, '135', '0015蓝牙标签(1103 17:00)', '14145', 'B0:8E:1A:40:00:15', 'B0:8E:1A:40:00:15', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.3923727+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (206, '138', '董-Model-D 0017', '14096', 'B0:8E:1A:40:00:17', 'B0:8E:1A:40:00:17', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:32:52.36537+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (207, '139', '杨-Model-D 0016', '14100', 'B0:8E:1A:40:00:16', 'B0:8E:1A:40:00:16', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.3743709+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (208, '169', 'Model-B test 0295', '21494', 'B0:8E:1A:36:02:95', 'B0:8E:1A:36:02:95', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6904025+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (209, '126', '蓝牙信号测试1', '12844', 'B0:8E:1A:40:0E:C8', 'B0:8E:1A:40:0E:C8', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.3143649+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (210, '46', '龚丽珍', '11408', 'B0:8E:1A:40:0A:EB', 'B0:8E:1A:40:0A:EB', null, '21', '27.66', '35.05', '2019-07-09T09:34:00.6953415+08:00', to_date('09-07-2019 09:34:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (211, '236', '雅马哈03', '30403', 'B0:8E:1A:36:03:09', 'B0:8E:1A:36:03:09', null, '1237', '-205.69000244140625', '-202.38999938964844', '2019-07-08T13:33:07.1658499+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (212, '226', '雅马哈', '30389', 'B0:8E:1A:36:03:0C', 'B0:8E:1A:36:03:0C', null, '1230', '-73.38999938964844', '-53.91999816894531', '2019-07-08T13:33:07.1118445+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (213, '143', 'Model-D 测试05AC', '17457', 'B0:8E:1A:33:05:AC', 'B0:8E:1A:33:05:AC', null, '868', '-85.16999816894531', '-26.760000228881836', '2019-07-08T13:32:52.5203855+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (214, '203', '48', '29189', 'B0:8E:1A:41:1B:48', 'B0:8E:1A:41:1B:48', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7244058+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (215, '205', '44', '29190', 'B0:8E:1A:41:1B:44', 'B0:8E:1A:41:1B:44', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7304064+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (216, '212', '4A', '29213', 'B0:8E:1A:41:1B:4A', 'B0:8E:1A:41:1B:4A', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8214155+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (217, '209', '4B', '29198', 'B0:8E:1A:41:1B:4B', 'B0:8E:1A:41:1B:4B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7654099+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (218, '204', '4E', '29217', 'B0:8E:1A:41:1B:4E', 'B0:8E:1A:41:1B:4E', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8394173+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (219, '234', '雅马哈01', '30498', 'B0:8E:1A:36:03:23', 'B0:8E:1A:36:03:23', null, '0', '0.0', '0.0', '2019-07-08T13:33:07.5108844+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (220, '220', '蔡曦铭Model D', '30382', 'B0:8E:1A:36:03:2F', 'B0:8E:1A:36:03:2F', null, '1237', '205.69000244140625', '202.38999938964844', '2019-07-08T13:33:07.0858419+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (221, '152', 'Model_D 0406（1-24）', '17772', 'B0:8E:1A:33:04:06', 'B0:8E:1A:33:04:06', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.555389+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (222, '147', 'Model_D 0404（1-24）', '17768', 'B0:8E:1A:33:04:04', 'B0:8E:1A:33:04:04', null, '35', '-28.059999465942383', '-17.56999969482422', '2019-07-08T13:32:52.545388+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (223, '166', '王思琦', '13221', 'B0:8E:1A:40:0D:75', 'B0:8E:1A:40:0D:75', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3423677+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (224, '180', '潘桂成', '12860', 'B0:8E:1A:40:0D:77', 'B0:8E:1A:40:0D:77', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3213656+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (225, '181', '伍树灼', '12098', 'B0:8E:1A:40:0D:76', 'B0:8E:1A:40:0D:76', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.2913626+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (226, '154', '渠立汉', '11522', 'B0:8E:1A:40:0A:A2', 'B0:8E:1A:40:0A:A2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.2413576+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (227, '146', '资产4FCA(1-5)', '12670', 'B0:8E:1A:50:4F:CA', 'B0:8E:1A:50:4F:CA', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.3013636+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (228, '188', 'areoscout1', '20298', 'B0:8E:1A:41:03:D4', 'B0:8E:1A:41:03:D4', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.6664001+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (229, '192', '贡云炳Home', '27262', 'B0:8E:1A:41:0C:F4', 'B0:8E:1A:41:0C:F4', null, '1169', '12.029999732971191', '10.5', '2019-07-08T13:32:55.6516986+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (230, '233', 'model b BC', '31793', 'B0:8E:1A:36:01:BC', 'B0:8E:1A:36:01:BC', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:12.2383571+08:00', to_date('08-07-2019 13:33:12', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (231, '104', '赵慧', '14323', 'B0:8E:1A:40:0A:C2', 'B0:8E:1A:40:0A:C2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.4103745+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (232, '195', 'ModelD360302', '29182', '36:03:02:00:00:00', '36:03:02:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.696403+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (233, '237', '雅马哈04', '28438', 'B0:8E:1A:40:03:2E', 'B0:8E:1A:40:03:2E', null, '33', '40.84', '39.54', '2019-07-09T09:34:00.6693389+08:00', to_date('09-07-2019 09:34:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (234, '248', '张大爷', '32282', 'B0:8E:1A:41:07:A0', 'B0:8E:1A:41:07:A0', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5174011+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (235, '229', '摔倒158A', '30279', 'B0:8E:1A:41:15:8A', 'B0:8E:1A:41:15:8A', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5284022+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (236, '241', '摔倒0794', '32279', 'B0:8E:1A:41:07:94', 'B0:8E:1A:41:07:94', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.516401+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:37', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (237, '221', '石福林', '11386', 'B0:8E:1A:40:0A:87', 'B0:8E:1A:40:0A:87', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5003994+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:37', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (238, '201', 'kkkkj', '11579', 'B0:8E:1A:40:0D:73', 'B0:8E:1A:40:0D:73', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5254019+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:37', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (239, '97', '武娟', '11355', 'B0:8E:1A:40:0A:71', 'B0:8E:1A:40:0A:71', '研发东北', '22', '24.86', '54.52', '2019-07-09T09:56:01.5234017+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (240, '246', '0C41', '32307', 'B0:8E:1A:41:0C:41', 'B0:8E:1A:41:0C:41', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5214015+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (241, '223', '测试223', '11545', 'B0:8E:1A:40:0E:DC', 'B0:8E:1A:40:0E:DC', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:54:54.4226923+08:00', to_date('09-07-2019 09:54:54', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (2, '29', '姜洪良', '11356', 'B0:8E:1A:40:0A:7C', 'B0:8E:1A:40:0A:7C', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1543489+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (3, '242', 'NB手环7405', '32534', '02:90:36:29:74:05', '02:90:36:29:74:05', null, '1400', '-3.119999885559082', '-2.390000104904175', '2019-07-08T13:33:14.9846317+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (4, '7', '董永平', '11381', 'B0:8E:1A:40:0F:90', '00010001', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1613496+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (5, '194', 'ModelD2000', '28326', 'B0:8E:1A:00:00:00', 'B0:8E:1A:00:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:59.5620896+08:00', to_date('08-07-2019 13:32:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (6, '240', '摔倒07CE', '32281', 'B0:8E:1A:41:07:CE', 'B0:8E:1A:41:07:CE', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:14.0465379+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (7, '248', '张大爷', '32282', 'B0:8E:1A:41:07:A0', 'B0:8E:1A:41:07:A0', null, '38', '88.77', '24.06', '2019-07-08T18:59:00.0889044+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (8, '229', '摔倒158A', '30279', 'B0:8E:1A:41:15:8A', 'B0:8E:1A:41:15:8A', null, '38', '88.77', '24.06', '2019-07-08T18:59:00.1019057+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (9, '231', '摔倒158B', '30277', 'B0:8E:1A:41:15:8B', 'B0:8E:1A:41:15:8B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:06.7028036+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (10, '241', '摔倒0794', '32279', 'B0:8E:1A:41:07:94', 'B0:8E:1A:41:07:94', null, '38', '88.77', '24.06', '2019-07-08T18:59:00.0919047+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (11, '221', '石福林', '11386', 'B0:8E:1A:40:0A:87', 'B0:8E:1A:40:0A:87', null, '33', '-40.84', '-39.54', '2019-07-08T17:58:26.4285841+08:00', to_date('08-07-2019 17:58:26', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (12, '96', '马桶监测505488', '11003', 'B0:8E:1A:50:54:88', 'B0:8E:1A:50:54:88', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1293464+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (13, '201', 'kkkkj', '11579', 'B0:8E:1A:40:0D:73', 'B0:8E:1A:40:0D:73', null, '38', '88.77', '24.06', '2019-07-08T18:59:00.1009056+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (14, '222', 'B', '26585', 'B0:8E:1A:40:06:B0', 'B0:8E:1A:40:06:B0', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:53.0994434+08:00', to_date('08-07-2019 13:32:53', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (15, '202', 'ModelD360301', '30348', '36:03:01:00:00:00', '36:03:01:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:06.9598293+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (16, '210', '64', '29197', 'B0:8E:1A:41:1B:64', 'B0:8E:1A:41:1B:64', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7594093+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (17, '113', '摔倒', '14663', 'B0:8E:1A:40:0F:1B', 'B0:8E:1A:40:0F:1B', null, '957', '85.87000274658203', '30.559999465942383', '2019-07-08T13:32:52.4363771+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (18, '125', '蓝牙信号测试', '12866', 'B0:8E:1A:40:04:C8', 'B0:8E:1A:40:04:C8', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3283663+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (19, '72', '吴家晟737', '11385', 'B0:8E:1A:40:0A:7D', 'B0:8E:1A:40:0A:7D', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.1763511+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (20, '97', '武娟', '11355', 'B0:8E:1A:40:0A:71', 'B0:8E:1A:40:0A:71', null, '38', '-88.77', '-24.06', '2019-07-08T18:01:55.7445136+08:00', to_date('08-07-2019 18:01:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (21, '145', 'Model-D 测试053A', '17485', 'B0:8E:1A:33:05:3A', 'B0:8E:1A:33:05:3A', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5313866+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (22, '170', 'Model-B test 0266', '21462', 'B0:8E:1A:36:02:66', 'B0:8E:1A:36:02:66', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6824017+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (23, '232', 'model b F2', '31795', 'B0:8E:1A:36:01:F2', 'B0:8E:1A:36:01:F2', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:12.2533586+08:00', to_date('08-07-2019 13:33:12', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (24, '193', '吴晟', '27066', 'B0:8E:1A:41:10:EE', 'B0:8E:1A:41:10:EE', null, '1138', '-42.7400016784668', '-7.190000057220459', '2019-07-08T13:32:54.9576292+08:00', to_date('08-07-2019 13:32:54', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (25, '197', 'ModelDV23602FC', '30140', '36:02:FC:00:00:00', '36:02:FC:00:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:06.2017535+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (26, '158', '测试卡片2', '19918', 'B0:8E:1A:40:21:92', 'B0:8E:1A:40:21:92', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.6063941+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (27, '246', '0C41', '32307', 'B0:8E:1A:41:0C:41', 'B0:8E:1A:41:0C:41', null, '33', '40.84', '39.54', '2019-07-08T18:59:00.0819037+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (28, '223', '测试223', '11545', 'B0:8E:1A:40:0E:DC', 'B0:8E:1A:40:0E:DC', null, '33', '40.84', '39.54', '2019-07-08T18:59:00.0959051+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (29, '141', 'Model-D 测试051E', '17415', 'B0:8E:1A:33:05:1E', 'B0:8E:1A:33:05:1E', null, '38', '-85.39399719238281', '-21.90399932861328', '2019-07-08T13:32:52.5033838+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (30, '217', '董永平Model D', '28842', 'B0:8E:1A:36:02:FA', 'B0:8E:1A:36:02:FA', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:33:01.436277+08:00', to_date('08-07-2019 13:33:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (31, '148', 'Model_D 04F0（1-24）', '17775', 'B0:8E:1A:33:04:F0', 'B0:8E:1A:33:04:F0', null, '38', '-86.52385711669922', '-24.785438537597656', '2019-07-08T13:32:52.5803915+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (32, '178', '拉绳350035', '23471', 'B0:8E:1A:35:00:35', 'B0:8E:1A:35:00:35', null, '35', '-28.059999465942383', '-17.56999969482422', '2019-07-08T13:32:52.715405+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (33, '177', '拉绳350036', '23472', 'B0:8E:1A:35:00:36', 'B0:8E:1A:35:00:36', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7224057+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (34, '133', '资产4FE8(9-26)', '11561', 'B0:8E:1A:50:4F:E8', 'B0:8E:1A:50:4F:E8', null, '38', '88.77', '24.06', '2019-07-08T18:57:19.9988964+08:00', to_date('08-07-2019 18:57:19', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (35, '168', 'Model-B test 01D5', '21608', 'B0:8E:1A:36:01:D5', 'B0:8E:1A:36:01:D5', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7004035+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (36, '174', '李全宝', '17156', 'B0:8E:1A:40:1A:B5', 'B0:8E:1A:40:1A:B5', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4863821+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (37, '239', 'NB演示', '32490', '02:90:36:42:64:83', '02:90:36:42:64:83', null, '1259', '-13.6899995803833', '-6.099999904632568', '2019-07-08T13:33:14.817615+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (38, '216', 'wifi蓝牙标签0333', '30655', 'B0:8E:1A:36:03:33', 'B0:8E:1A:36:03:33', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:33:08.0699403+08:00', to_date('08-07-2019 13:33:08', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (39, '244', 'dyp10002', '30398', 'B0:8E:1A:36:03:30', '00010002', null, '38', '88.77', '24.06', '2019-07-08T18:58:59.1028058+08:00', to_date('08-07-2019 18:58:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (40, '64', '高燕', '11500', 'B0:8E:1A:40:0A:F2', 'B0:8E:1A:40:0A:F2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.2193554+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (41, '137', '黄-Model-D 0019', '16375', 'B0:8E:1A:40:0A:F7', 'B0:8E:1A:40:0A:F7', null, '38', '88.77', '24.06', '2019-07-08T18:58:56.0965052+08:00', to_date('08-07-2019 18:58:56', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (42, '167', '蔡曦铭', '11406', 'B0:8E:1A:40:0E:FF', 'B0:8E:1A:40:0E:FF', null, '38', '-88.77', '-24.06', '2019-07-08T18:03:02.0711456+08:00', to_date('08-07-2019 18:03:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (43, '247', '1315', '11320', 'B0:8E:1A:50:13:15', 'B0:8E:1A:50:13:15', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.135347+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (44, '179', '梁琰佳', '16448', 'B0:8E:1A:40:0D:01', 'B0:8E:1A:40:0D:01', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.4763811+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (45, '31', '陆萍萍', '11511', 'B0:8E:1A:40:0F:95', 'B0:8E:1A:40:0F:95', null, '38', '-88.77', '-24.06', '2019-07-08T17:56:54.2993721+08:00', to_date('08-07-2019 17:56:54', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (46, '103', '黄东升', '29949', 'B0:8E:1A:41:09:08', 'B0:8E:1A:41:09:08', null, '38', '-88.77', '-24.06', '2019-07-08T17:58:43.559297+08:00', to_date('08-07-2019 17:58:43', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (47, '131', 'ESP马桶检测000B', '16273', 'B0:8E:1A:40:00:0B', 'B0:8E:1A:40:00:0B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4463781+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (48, '187', '1D60', '27261', 'B0:8E:1A:40:1D:60', 'B0:8E:1A:40:1D:60', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:55.645698+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (49, '200', '9b', '26520', 'B0:8E:1A:41:11:9B', 'B0:8E:1A:41:11:9B', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.7584093+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (50, '110', '摔倒0000', '13608', 'B0:8E:1A:40:00:00', 'B0:8E:1A:40:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.3493684+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (51, '111', '摔倒1126', '14332', 'B0:8E:1A:40:11:26', 'B0:8E:1A:40:11:26', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4183753+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (52, '63', '时林虎', '11516', 'B0:8E:1A:40:0A:95', 'B0:8E:1A:40:0A:95', null, '33', '-40.84', '-39.54', '2019-07-08T17:35:37.10367+08:00', to_date('08-07-2019 17:35:37', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (53, '155', 'model_b', '20121', 'B0:8E:1A:36:11:11', 'B0:8E:1A:36:11:11', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.615395+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +commit; +prompt 100 records committed... +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (54, '9', '杨亦铭', '11492', 'B0:8E:1A:40:0A:BB', 'B0:8E:1A:40:0A:BB', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.2113546+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (55, '150', 'Model_D 0434（1-24）', '17773', 'B0:8E:1A:33:04:34', 'B0:8E:1A:33:04:34', null, '1139', '-45.43000030517578', '-5.789999961853027', '2019-07-08T13:32:52.5633898+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (56, '245', '手环01', '32613', 'B0:8E:5A:00:00:01', 'B0:8E:5A:00:00:01', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:15.2986631+08:00', to_date('08-07-2019 13:33:15', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (57, '196', 'ModeD3602FB', '29464', '36:02:FB:00:00:00', '36:02:FB:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:03.7725106+08:00', to_date('08-07-2019 13:33:03', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (58, '45', '贡云炳', '11384', 'B0:8E:1A:40:0A:6F', 'B0:8E:1A:40:0A:6F', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.1673502+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (59, '224', '1589', '30268', 'B0:8E:1A:41:15:89', 'B0:8E:1A:41:15:89', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:06.6607994+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (60, '235', '雅马哈02', '30400', 'B0:8E:1A:36:03:10', 'B0:8E:1A:36:03:10', null, '1235', '-112.12999725341797', '-200.58999633789062', '2019-07-08T13:33:07.1538487+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (61, '84', '周乾', '11573', 'B0:8E:1A:40:0A:D4', 'B0:8E:1A:40:0A:D4', null, '33', '40.84', '39.54', '2019-07-08T18:59:01.0910046+08:00', to_date('08-07-2019 18:59:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (62, '189', 'areoscout2', '20775', 'B0:8E:1A:41:01:D2', 'B0:8E:1A:41:01:D2', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6744009+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (63, '159', '测试卡片3', '19824', 'B0:8E:1A:40:22:2E', 'B0:8E:1A:40:22:2E', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.5933928+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (64, '207', '52', '29199', 'B0:8E:1A:41:1B:52', 'B0:8E:1A:41:1B:52', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7704104+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (65, '206', '56', '29218', 'B0:8E:1A:41:1B:56', 'B0:8E:1A:41:1B:56', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8454179+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (66, '208', '5A', '29186', 'B0:8E:1A:41:1B:5A', 'B0:8E:1A:41:1B:5A', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7124046+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (67, '165', '李立峰', '13077', 'B0:8E:1A:40:0D:84', 'B0:8E:1A:40:0D:84', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3343669+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (68, '106', 'test0980', '13792', 'B0:8E:1A:90:09:80', 'B0:8E:1A:90:09:80', null, '0', '1.0', '1.0', '2019-07-08T13:32:52.355369+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (69, '163', 'model_b004', '20162', 'B0:8E:1A:36:00:04', 'B0:8E:1A:36:00:04', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6593994+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (70, '164', 'Model-B 0003', '20161', 'B0:8E:1A:36:00:03', 'B0:8E:1A:36:00:03', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6473982+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (71, '160', 'ModelB02', '20160', 'B0:8E:1A:36:00:02', 'B0:8E:1A:36:00:02', null, '946', '-85.97000122070312', '-11.779999732971191', '2019-07-08T13:32:52.6403975+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (72, '162', 'ModelB01', '20127', 'B0:8E:1A:36:00:01', 'B0:8E:1A:36:00:01', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6233958+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (73, '161', 'ModelB00', '20159', 'B0:8E:1A:36:00:00', 'B0:8E:1A:36:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.6313966+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (74, '211', '3D', '29432', 'B0:8E:1A:41:1B:3D', 'B0:8E:1A:41:1B:3D', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:03.646498+08:00', to_date('08-07-2019 13:33:03', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (75, '107', 'test3C3B', '11548', 'B0:8E:1A:50:3C:3B', 'B0:8E:1A:50:3C:3B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.255359+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (76, '171', '拉绳test 0006', '22652', 'B0:8E:1A:34:00:06', 'B0:8E:1A:34:00:06', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7074042+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (77, '149', 'Model_D 0566（1-24）', '17774', 'B0:8E:1A:33:05:66', 'B0:8E:1A:33:05:66', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5723907+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (78, '112', '谢晓威', '14449', 'B0:8E:1A:40:0D:B3', 'B0:8E:1A:40:0D:B3', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4273762+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (79, '186', '0D68', '27260', 'B0:8E:1A:41:0D:68', 'B0:8E:1A:41:0D:68', null, '1160', '-3.7899999618530273', '-3.869999885559082', '2019-07-08T13:32:55.6406975+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (80, '214', '蓝牙标签0129-360351', '30420', 'B0:8E:1A:36:03:51', 'B0:8E:1A:36:03:51', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:07.2298563+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (81, '151', 'Model_D 011A（1-24）', '17745', 'B0:8E:1A:33:01:1A', 'B0:8E:1A:33:01:1A', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5383873+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (82, '243', '楚云飞', '27776', 'B0:8E:1A:41:10:80', 'B0:8E:1A:41:10:80', null, '33', '40.84', '39.54', '2019-07-08T18:59:01.0960051+08:00', to_date('08-07-2019 18:59:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (83, '238', '3568', '32059', '02:90:30:35:35:68', '02:90:30:35:35:68', null, '1242', '-91.06999969482422', '-37.7400016784668', '2019-07-08T13:33:13.2344567+08:00', to_date('08-07-2019 13:33:13', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (84, '144', 'Model-D 测试0548', '17429', 'B0:8E:1A:33:05:48', 'B0:8E:1A:33:05:48', null, '38', '-85.63287353515625', '-23.543903350830078', '2019-07-08T13:32:52.5123847+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (85, '142', 'Model-D 测试0544', '17399', 'B0:8E:1A:33:05:44', 'B0:8E:1A:33:05:44', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.4923827+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (86, '153', 'NEWAPI4796', '11449', 'B0:8E:1A:50:47:96', 'B0:8E:1A:50:47:96', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.2043539+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (87, '225', '0019', '14130', 'B0:8E:1A:40:00:19', 'B0:8E:1A:40:00:19', null, '0', '-1.0', '-1.0', '2019-07-08T13:32:52.3843719+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (88, '136', '测试0013', '16423', 'B0:8E:1A:40:00:13', 'B0:8E:1A:40:00:13', null, '33', '-44.05439376831055', '-38.5018424987793', '2019-07-08T13:32:52.4693804+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (89, '135', '0015蓝牙标签(1103 17:00)', '14145', 'B0:8E:1A:40:00:15', 'B0:8E:1A:40:00:15', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.3923727+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (90, '138', '董-Model-D 0017', '14096', 'B0:8E:1A:40:00:17', 'B0:8E:1A:40:00:17', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:32:52.36537+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (91, '139', '杨-Model-D 0016', '14100', 'B0:8E:1A:40:00:16', 'B0:8E:1A:40:00:16', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.3743709+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (92, '169', 'Model-B test 0295', '21494', 'B0:8E:1A:36:02:95', 'B0:8E:1A:36:02:95', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6904025+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (93, '126', '蓝牙信号测试1', '12844', 'B0:8E:1A:40:0E:C8', 'B0:8E:1A:40:0E:C8', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.3143649+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (94, '46', '龚丽珍', '11408', 'B0:8E:1A:40:0A:EB', 'B0:8E:1A:40:0A:EB', null, '38', '-88.77', '-24.06', '2019-07-08T17:57:02.2361657+08:00', to_date('08-07-2019 17:57:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (95, '236', '雅马哈03', '30403', 'B0:8E:1A:36:03:09', 'B0:8E:1A:36:03:09', null, '1237', '-205.69000244140625', '-202.38999938964844', '2019-07-08T13:33:07.1658499+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (96, '226', '雅马哈', '30389', 'B0:8E:1A:36:03:0C', 'B0:8E:1A:36:03:0C', null, '1230', '-73.38999938964844', '-53.91999816894531', '2019-07-08T13:33:07.1118445+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (97, '143', 'Model-D 测试05AC', '17457', 'B0:8E:1A:33:05:AC', 'B0:8E:1A:33:05:AC', null, '868', '-85.16999816894531', '-26.760000228881836', '2019-07-08T13:32:52.5203855+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (98, '203', '48', '29189', 'B0:8E:1A:41:1B:48', 'B0:8E:1A:41:1B:48', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7244058+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (99, '205', '44', '29190', 'B0:8E:1A:41:1B:44', 'B0:8E:1A:41:1B:44', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7304064+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (100, '212', '4A', '29213', 'B0:8E:1A:41:1B:4A', 'B0:8E:1A:41:1B:4A', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8214155+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (101, '209', '4B', '29198', 'B0:8E:1A:41:1B:4B', 'B0:8E:1A:41:1B:4B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7654099+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (102, '204', '4E', '29217', 'B0:8E:1A:41:1B:4E', 'B0:8E:1A:41:1B:4E', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8394173+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (103, '234', '雅马哈01', '30498', 'B0:8E:1A:36:03:23', 'B0:8E:1A:36:03:23', null, '0', '0.0', '0.0', '2019-07-08T13:33:07.5108844+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (104, '220', '蔡曦铭Model D', '30382', 'B0:8E:1A:36:03:2F', 'B0:8E:1A:36:03:2F', null, '1237', '205.69000244140625', '202.38999938964844', '2019-07-08T13:33:07.0858419+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (105, '152', 'Model_D 0406（1-24）', '17772', 'B0:8E:1A:33:04:06', 'B0:8E:1A:33:04:06', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.555389+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (106, '147', 'Model_D 0404（1-24）', '17768', 'B0:8E:1A:33:04:04', 'B0:8E:1A:33:04:04', null, '35', '-28.059999465942383', '-17.56999969482422', '2019-07-08T13:32:52.545388+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (107, '166', '王思琦', '13221', 'B0:8E:1A:40:0D:75', 'B0:8E:1A:40:0D:75', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3423677+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (108, '180', '潘桂成', '12860', 'B0:8E:1A:40:0D:77', 'B0:8E:1A:40:0D:77', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3213656+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (109, '181', '伍树灼', '12098', 'B0:8E:1A:40:0D:76', 'B0:8E:1A:40:0D:76', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.2913626+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (110, '154', '渠立汉', '11522', 'B0:8E:1A:40:0A:A2', 'B0:8E:1A:40:0A:A2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.2413576+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (111, '146', '资产4FCA(1-5)', '12670', 'B0:8E:1A:50:4F:CA', 'B0:8E:1A:50:4F:CA', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.3013636+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (112, '188', 'areoscout1', '20298', 'B0:8E:1A:41:03:D4', 'B0:8E:1A:41:03:D4', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.6664001+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (113, '192', '贡云炳Home', '27262', 'B0:8E:1A:41:0C:F4', 'B0:8E:1A:41:0C:F4', null, '1169', '12.029999732971191', '10.5', '2019-07-08T13:32:55.6516986+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (114, '233', 'model b BC', '31793', 'B0:8E:1A:36:01:BC', 'B0:8E:1A:36:01:BC', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:12.2383571+08:00', to_date('08-07-2019 13:33:12', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (115, '104', '赵慧', '14323', 'B0:8E:1A:40:0A:C2', 'B0:8E:1A:40:0A:C2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.4103745+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (116, '195', 'ModelD360302', '29182', '36:03:02:00:00:00', '36:03:02:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.696403+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (117, '237', '雅马哈04', '28438', 'B0:8E:1A:40:03:2E', 'B0:8E:1A:40:03:2E', null, '38', '88.77', '24.06', '2019-07-08T18:59:01.0840039+08:00', to_date('08-07-2019 18:59:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (118, '29', '姜洪良', '11356', 'B0:8E:1A:40:0A:7C', 'B0:8E:1A:40:0A:7C', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1543489+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (119, '242', 'NB手环7405', '32534', '02:90:36:29:74:05', '02:90:36:29:74:05', null, '1400', '-3.119999885559082', '-2.390000104904175', '2019-07-08T13:33:14.9846317+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (120, '7', '董永平', '11381', 'B0:8E:1A:40:0F:90', '00010001', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1613496+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (121, '194', 'ModelD2000', '28326', 'B0:8E:1A:00:00:00', 'B0:8E:1A:00:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:59.5620896+08:00', to_date('08-07-2019 13:32:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (122, '240', '摔倒07CE', '32281', 'B0:8E:1A:41:07:CE', 'B0:8E:1A:41:07:CE', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:14.0465379+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (123, '248', '张大爷', '32282', 'B0:8E:1A:41:07:A0', 'B0:8E:1A:41:07:A0', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6932413+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (124, '229', '摔倒158A', '30279', 'B0:8E:1A:41:15:8A', 'B0:8E:1A:41:15:8A', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6952415+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (125, '231', '摔倒158B', '30277', 'B0:8E:1A:41:15:8B', 'B0:8E:1A:41:15:8B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:06.7028036+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (126, '241', '摔倒0794', '32279', 'B0:8E:1A:41:07:94', 'B0:8E:1A:41:07:94', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6962416+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (127, '221', '石福林', '11386', 'B0:8E:1A:40:0A:87', 'B0:8E:1A:40:0A:87', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6822402+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (128, '96', '马桶监测505488', '11003', 'B0:8E:1A:50:54:88', 'B0:8E:1A:50:54:88', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1293464+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (129, '201', 'kkkkj', '11579', 'B0:8E:1A:40:0D:73', 'B0:8E:1A:40:0D:73', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6952415+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (130, '222', 'B', '26585', 'B0:8E:1A:40:06:B0', 'B0:8E:1A:40:06:B0', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:53.0994434+08:00', to_date('08-07-2019 13:32:53', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (131, '202', 'ModelD360301', '30348', '36:03:01:00:00:00', '36:03:01:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:06.9598293+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (132, '210', '64', '29197', 'B0:8E:1A:41:1B:64', 'B0:8E:1A:41:1B:64', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7594093+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (133, '113', '摔倒', '14663', 'B0:8E:1A:40:0F:1B', 'B0:8E:1A:40:0F:1B', null, '957', '85.87000274658203', '30.559999465942383', '2019-07-08T13:32:52.4363771+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (134, '125', '蓝牙信号测试', '12866', 'B0:8E:1A:40:04:C8', 'B0:8E:1A:40:04:C8', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3283663+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (135, '72', '吴家晟737', '11385', 'B0:8E:1A:40:0A:7D', 'B0:8E:1A:40:0A:7D', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.1763511+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (136, '97', '武娟', '11355', 'B0:8E:1A:40:0A:71', 'B0:8E:1A:40:0A:71', null, '22', '24.86', '54.52', '2019-07-09T09:33:59.690241+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (137, '145', 'Model-D 测试053A', '17485', 'B0:8E:1A:33:05:3A', 'B0:8E:1A:33:05:3A', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5313866+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (138, '170', 'Model-B test 0266', '21462', 'B0:8E:1A:36:02:66', 'B0:8E:1A:36:02:66', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6824017+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (139, '232', 'model b F2', '31795', 'B0:8E:1A:36:01:F2', 'B0:8E:1A:36:01:F2', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:12.2533586+08:00', to_date('08-07-2019 13:33:12', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (140, '193', '吴晟', '27066', 'B0:8E:1A:41:10:EE', 'B0:8E:1A:41:10:EE', null, '1138', '-42.7400016784668', '-7.190000057220459', '2019-07-08T13:32:54.9576292+08:00', to_date('08-07-2019 13:32:54', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (141, '197', 'ModelDV23602FC', '30140', '36:02:FC:00:00:00', '36:02:FC:00:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:06.2017535+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (142, '158', '测试卡片2', '19918', 'B0:8E:1A:40:21:92', 'B0:8E:1A:40:21:92', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.6063941+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (143, '246', '0C41', '32307', 'B0:8E:1A:41:0C:41', 'B0:8E:1A:41:0C:41', null, '33', '40.84', '39.54', '2019-07-09T09:33:59.6942414+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (144, '223', '测试223', '11545', 'B0:8E:1A:40:0E:DC', 'B0:8E:1A:40:0E:DC', null, '38', '88.77', '24.06', '2019-07-09T09:33:58.6821402+08:00', to_date('09-07-2019 09:33:58', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (145, '141', 'Model-D 测试051E', '17415', 'B0:8E:1A:33:05:1E', 'B0:8E:1A:33:05:1E', null, '38', '-85.39399719238281', '-21.90399932861328', '2019-07-08T13:32:52.5033838+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (146, '217', '董永平Model D', '28842', 'B0:8E:1A:36:02:FA', 'B0:8E:1A:36:02:FA', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:33:01.436277+08:00', to_date('08-07-2019 13:33:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (147, '148', 'Model_D 04F0（1-24）', '17775', 'B0:8E:1A:33:04:F0', 'B0:8E:1A:33:04:F0', null, '38', '-86.52385711669922', '-24.785438537597656', '2019-07-08T13:32:52.5803915+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (148, '178', '拉绳350035', '23471', 'B0:8E:1A:35:00:35', 'B0:8E:1A:35:00:35', null, '35', '-28.059999465942383', '-17.56999969482422', '2019-07-08T13:32:52.715405+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (149, '177', '拉绳350036', '23472', 'B0:8E:1A:35:00:36', 'B0:8E:1A:35:00:36', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7224057+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (150, '133', '资产4FE8(9-26)', '11561', 'B0:8E:1A:50:4F:E8', 'B0:8E:1A:50:4F:E8', null, '38', '-88.77', '-24.06', '2019-07-09T09:31:38.7141448+08:00', to_date('09-07-2019 09:31:38', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (151, '168', 'Model-B test 01D5', '21608', 'B0:8E:1A:36:01:D5', 'B0:8E:1A:36:01:D5', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7004035+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (152, '174', '李全宝', '17156', 'B0:8E:1A:40:1A:B5', 'B0:8E:1A:40:1A:B5', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4863821+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (153, '239', 'NB演示', '32490', '02:90:36:42:64:83', '02:90:36:42:64:83', null, '1259', '-13.6899995803833', '-6.099999904632568', '2019-07-08T13:33:14.817615+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +commit; +prompt 200 records committed... +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (154, '216', 'wifi蓝牙标签0333', '30655', 'B0:8E:1A:36:03:33', 'B0:8E:1A:36:03:33', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:33:08.0699403+08:00', to_date('08-07-2019 13:33:08', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (155, '244', 'dyp10002', '30398', 'B0:8E:1A:36:03:30', '00010002', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6892409+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (156, '64', '高燕', '11500', 'B0:8E:1A:40:0A:F2', 'B0:8E:1A:40:0A:F2', null, '24', '54.12', '54.62', '2019-07-09T09:33:59.6892409+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (157, '137', '黄-Model-D 0019', '16375', 'B0:8E:1A:40:0A:F7', 'B0:8E:1A:40:0A:F7', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6912411+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (158, '167', '蔡曦铭', '11406', 'B0:8E:1A:40:0E:FF', 'B0:8E:1A:40:0E:FF', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6922412+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (159, '247', '1315', '11320', 'B0:8E:1A:50:13:15', 'B0:8E:1A:50:13:15', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.135347+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (160, '179', '梁琰佳', '16448', 'B0:8E:1A:40:0D:01', 'B0:8E:1A:40:0D:01', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.4763811+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (161, '31', '陆萍萍', '11511', 'B0:8E:1A:40:0F:95', 'B0:8E:1A:40:0F:95', null, '21', '27.66', '35.05', '2019-07-09T09:33:59.6812401+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (162, '103', '黄东升', '29949', 'B0:8E:1A:41:09:08', 'B0:8E:1A:41:09:08', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6712391+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (163, '131', 'ESP马桶检测000B', '16273', 'B0:8E:1A:40:00:0B', 'B0:8E:1A:40:00:0B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4463781+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (164, '187', '1D60', '27261', 'B0:8E:1A:40:1D:60', 'B0:8E:1A:40:1D:60', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:55.645698+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (165, '200', '9b', '26520', 'B0:8E:1A:41:11:9B', 'B0:8E:1A:41:11:9B', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.7584093+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (166, '110', '摔倒0000', '13608', 'B0:8E:1A:40:00:00', 'B0:8E:1A:40:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.3493684+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (167, '111', '摔倒1126', '14332', 'B0:8E:1A:40:11:26', 'B0:8E:1A:40:11:26', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4183753+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (168, '63', '时林虎', '11516', 'B0:8E:1A:40:0A:95', 'B0:8E:1A:40:0A:95', null, '38', '88.77', '24.06', '2019-07-09T09:33:56.6719392+08:00', to_date('09-07-2019 09:33:56', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (169, '155', 'model_b', '20121', 'B0:8E:1A:36:11:11', 'B0:8E:1A:36:11:11', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.615395+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (170, '9', '杨亦铭', '11492', 'B0:8E:1A:40:0A:BB', 'B0:8E:1A:40:0A:BB', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.2113546+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (171, '150', 'Model_D 0434（1-24）', '17773', 'B0:8E:1A:33:04:34', 'B0:8E:1A:33:04:34', null, '1139', '-45.43000030517578', '-5.789999961853027', '2019-07-08T13:32:52.5633898+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (172, '245', '手环01', '32613', 'B0:8E:5A:00:00:01', 'B0:8E:5A:00:00:01', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:15.2986631+08:00', to_date('08-07-2019 13:33:15', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (173, '196', 'ModeD3602FB', '29464', '36:02:FB:00:00:00', '36:02:FB:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:03.7725106+08:00', to_date('08-07-2019 13:33:03', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (174, '45', '贡云炳', '11384', 'B0:8E:1A:40:0A:6F', 'B0:8E:1A:40:0A:6F', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.1673502+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (175, '224', '1589', '30268', 'B0:8E:1A:41:15:89', 'B0:8E:1A:41:15:89', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:06.6607994+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (176, '235', '雅马哈02', '30400', 'B0:8E:1A:36:03:10', 'B0:8E:1A:36:03:10', null, '1235', '-112.12999725341797', '-200.58999633789062', '2019-07-08T13:33:07.1538487+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (177, '84', '周乾', '11573', 'B0:8E:1A:40:0A:D4', 'B0:8E:1A:40:0A:D4', null, '33', '40.84', '39.54', '2019-07-09T09:34:00.6883408+08:00', to_date('09-07-2019 09:34:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (178, '189', 'areoscout2', '20775', 'B0:8E:1A:41:01:D2', 'B0:8E:1A:41:01:D2', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6744009+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (179, '159', '测试卡片3', '19824', 'B0:8E:1A:40:22:2E', 'B0:8E:1A:40:22:2E', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.5933928+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (180, '207', '52', '29199', 'B0:8E:1A:41:1B:52', 'B0:8E:1A:41:1B:52', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7704104+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (181, '206', '56', '29218', 'B0:8E:1A:41:1B:56', 'B0:8E:1A:41:1B:56', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8454179+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (182, '208', '5A', '29186', 'B0:8E:1A:41:1B:5A', 'B0:8E:1A:41:1B:5A', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7124046+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (183, '165', '李立峰', '13077', 'B0:8E:1A:40:0D:84', 'B0:8E:1A:40:0D:84', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3343669+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (184, '106', 'test0980', '13792', 'B0:8E:1A:90:09:80', 'B0:8E:1A:90:09:80', null, '0', '1.0', '1.0', '2019-07-08T13:32:52.355369+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (185, '163', 'model_b004', '20162', 'B0:8E:1A:36:00:04', 'B0:8E:1A:36:00:04', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6593994+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (186, '164', 'Model-B 0003', '20161', 'B0:8E:1A:36:00:03', 'B0:8E:1A:36:00:03', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6473982+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (187, '160', 'ModelB02', '20160', 'B0:8E:1A:36:00:02', 'B0:8E:1A:36:00:02', null, '946', '-85.97000122070312', '-11.779999732971191', '2019-07-08T13:32:52.6403975+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (188, '162', 'ModelB01', '20127', 'B0:8E:1A:36:00:01', 'B0:8E:1A:36:00:01', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6233958+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (189, '161', 'ModelB00', '20159', 'B0:8E:1A:36:00:00', 'B0:8E:1A:36:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.6313966+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (190, '211', '3D', '29432', 'B0:8E:1A:41:1B:3D', 'B0:8E:1A:41:1B:3D', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:03.646498+08:00', to_date('08-07-2019 13:33:03', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (191, '107', 'test3C3B', '11548', 'B0:8E:1A:50:3C:3B', 'B0:8E:1A:50:3C:3B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.255359+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (192, '171', '拉绳test 0006', '22652', 'B0:8E:1A:34:00:06', 'B0:8E:1A:34:00:06', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7074042+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (193, '149', 'Model_D 0566（1-24）', '17774', 'B0:8E:1A:33:05:66', 'B0:8E:1A:33:05:66', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5723907+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (242, '133', '资产4FE8(9-26)', '11561', 'B0:8E:1A:50:4F:E8', 'B0:8E:1A:50:4F:E8', '101洗漱间', '38', '-88.77', '-24.06', '2019-07-09T09:51:55.4978016+08:00', to_date('09-07-2019 09:51:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (243, '244', 'dyp10002', '30398', 'B0:8E:1A:36:03:30', '00010002', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5224016+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (244, '64', '高燕', '11500', 'B0:8E:1A:40:0A:F2', 'B0:8E:1A:40:0A:F2', '研发西北', '24', '54.12', '54.62', '2019-07-09T09:56:01.5234017+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (245, '137', '黄-Model-D 0019', '16375', 'B0:8E:1A:40:0A:F7', 'B0:8E:1A:40:0A:F7', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5234017+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (246, '167', '蔡曦铭', '11406', 'B0:8E:1A:40:0E:FF', 'B0:8E:1A:40:0E:FF', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5244018+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (247, '31', '陆萍萍', '11511', 'B0:8E:1A:40:0F:95', 'B0:8E:1A:40:0F:95', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5094003+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (248, '103', '黄东升', '29949', 'B0:8E:1A:41:09:08', 'B0:8E:1A:41:09:08', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5064+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (249, '63', '时林虎', '11516', 'B0:8E:1A:40:0A:95', 'B0:8E:1A:40:0A:95', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5064+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (250, '84', '周乾', '11573', 'B0:8E:1A:40:0A:D4', 'B0:8E:1A:40:0A:D4', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5174011+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (251, '243', '楚云飞', '27776', 'B0:8E:1A:41:10:80', 'B0:8E:1A:41:10:80', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5224016+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (252, '46', '龚丽珍', '11408', 'B0:8E:1A:40:0A:EB', 'B0:8E:1A:40:0A:EB', '101卧室', '21', '27.66', '35.05', '2019-07-09T09:56:01.5244018+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime) +values (253, '237', '雅马哈04', '28438', 'B0:8E:1A:40:03:2E', 'B0:8E:1A:40:03:2E', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5074001+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss')); +commit; +prompt 252 records loaded +prompt Enabling triggers for PG_TAGPOSITION... +alter table PG_TAGPOSITION enable all triggers; + +create or replace view tagpositionview as +select hostId "hostId",hostName "hostName" ,X ,Y ,tagMac "tagMac", +positionUpdateTime "positionUpdateTime" , +coordinatesName "coordinatesName" + from pg_tagposition where id in ( +select max(id) from pg_tagposition +--where querytime between sysdate-1/12 and sysdate +group by hostid +) +; + +set feedback on +set define on +prompt Done