| New file |
| | |
| | | package com.ycl.controller.smoke; |
| | | |
| | | import com.ycl.controller.BaseController; |
| | | import com.ycl.service.smoke.IOdsInTimeService; |
| | | import io.swagger.annotations.Api; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | @RestController |
| | | @RequestMapping("/smoker") |
| | | @Api(tags = "视频资源管理") |
| | | public class SmokeController extends BaseController { |
| | | |
| | | IOdsInTimeService inTimeService; |
| | | |
| | | @Autowired |
| | | |
| | | public void setInTimeService(IOdsInTimeService inTimeService) { |
| | | this.inTimeService = inTimeService; |
| | | } |
| | | } |
| New file |
| | |
| | | package com.ycl.entity.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | import java.io.Serializable; |
| | | |
| | | /** |
| | | * <p> |
| | | * 报警消息 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @TableName("ums_ods_alarm_msg") |
| | | public class OdsAlarmMsg implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * Id |
| | | */ |
| | | @TableId("id") |
| | | @JsonProperty("Id") |
| | | private String id; |
| | | |
| | | /** |
| | | * 设备的mn数据 |
| | | */ |
| | | @TableField("mn") |
| | | @JsonProperty("MN") |
| | | private String mn; |
| | | |
| | | /** |
| | | * 数据收集时间 |
| | | */ |
| | | @TableField("acquit_at") |
| | | @JsonProperty("AcquitAt") |
| | | private Long acquitAt; |
| | | |
| | | /** |
| | | * 持有人 |
| | | */ |
| | | @TableField("owner") |
| | | @JsonProperty("Owner") |
| | | private String owner; |
| | | |
| | | /** |
| | | * 内容 |
| | | */ |
| | | @TableField("content") |
| | | @JsonProperty("Content") |
| | | private String content; |
| | | |
| | | /** |
| | | * 消息类型 |
| | | */ |
| | | @TableField("msg_type") |
| | | @JsonProperty("MsgType") |
| | | private String msgType; |
| | | |
| | | @JsonProperty("Addr") |
| | | @TableField("addr") |
| | | private String addr; |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.entity.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | import java.io.Serializable; |
| | | |
| | | /** |
| | | * <p> |
| | | * 报警记录 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @TableName("ums_ods_alarm_record") |
| | | public class OdsAlarmRecord implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | @TableId("id") |
| | | @JsonProperty("Id") |
| | | private String id; |
| | | |
| | | /** |
| | | * 监测点ID |
| | | */ |
| | | @TableField("local_id") |
| | | @JsonProperty("LocaleId") |
| | | private String localId; |
| | | |
| | | /** |
| | | * 设备编号 |
| | | */ |
| | | @TableField("mn") |
| | | @JsonProperty("MN") |
| | | private String mn; |
| | | |
| | | /** |
| | | * 数据类型1:超标2:异常 |
| | | */ |
| | | @TableField("typ") |
| | | @JsonProperty("Typ") |
| | | private Integer typ; |
| | | |
| | | /** |
| | | * 报警时间 |
| | | */ |
| | | @TableField("alarm_date") |
| | | @JsonProperty("AlarmDate") |
| | | private String alarmDate; |
| | | |
| | | /** |
| | | * 设备类型 |
| | | */ |
| | | @TableField("device_type") |
| | | @JsonProperty("DeviceType") |
| | | private Integer deviceType; |
| | | |
| | | /** |
| | | * 采集时间 |
| | | */ |
| | | @TableField("acquit_at") |
| | | @JsonProperty("AcquitAt") |
| | | private Long acquitAt; |
| | | |
| | | /** |
| | | * 处理时间 |
| | | */ |
| | | @TableField("process_at") |
| | | @JsonProperty("ProcessAt") |
| | | private Long processAt; |
| | | |
| | | /** |
| | | * 所属单位 |
| | | */ |
| | | @TableField("owner") |
| | | @JsonProperty("Owner") |
| | | private String owner; |
| | | |
| | | /** |
| | | * 解决方案 |
| | | */ |
| | | @TableField("solution") |
| | | @JsonProperty("Solution") |
| | | private String solution; |
| | | |
| | | /** |
| | | * 处理地址 |
| | | */ |
| | | @TableField("processing_address") |
| | | @JsonProperty("ProcessingAddress") |
| | | private String processingAddress; |
| | | |
| | | /** |
| | | * 点位地址 |
| | | */ |
| | | @TableField("addr") |
| | | @JsonProperty("Addr") |
| | | private String addr; |
| | | |
| | | /** |
| | | * 处理人ID |
| | | */ |
| | | @TableField("process_user_id") |
| | | @JsonProperty("ProcessUserId") |
| | | private String processUserId; |
| | | |
| | | /** |
| | | * 处理人名称 |
| | | */ |
| | | @TableField("process_user_name") |
| | | @JsonProperty("ProcessUserName") |
| | | private String processUserName; |
| | | |
| | | /** |
| | | * 处理原因 |
| | | */ |
| | | @TableField("process_reason") |
| | | @JsonProperty("Processor") |
| | | private String processReason; |
| | | |
| | | /** |
| | | * 关联地址 |
| | | */ |
| | | @TableField("created_at") |
| | | @JsonProperty("CreatedAt") |
| | | private String createdAt; |
| | | |
| | | /** |
| | | * 地址序列 |
| | | */ |
| | | @TableField("update_at") |
| | | @JsonProperty("UpdatedAt") |
| | | private String updateAt; |
| | | |
| | | /** |
| | | * 查询结果总数 |
| | | */ |
| | | @TableField("total") |
| | | @JsonProperty("") |
| | | private Integer total; |
| | | |
| | | /** |
| | | * 报警图片 |
| | | */ |
| | | @TableField(exist = false) |
| | | @JsonProperty("AlarmRecordPicS") |
| | | private String[] alarmRecordPics; |
| | | |
| | | /** |
| | | * 报警图片 |
| | | */ |
| | | @TableField("alarm_record_pics") |
| | | private String alarmRecordPicsString; |
| | | } |
| New file |
| | |
| | | package com.ycl.entity.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | import java.io.Serializable; |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDateTime; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测点统计&健康码管理 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @TableName("ums_ods_cur_alarm") |
| | | public class OdsCurAlarm implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | @TableId("id") |
| | | @JsonProperty("") |
| | | private Integer id; |
| | | |
| | | /** |
| | | * 异常离线天数 |
| | | */ |
| | | @TableField("abnormal_off_line_days") |
| | | @JsonProperty("AbnormalOfflineDays") |
| | | private Integer abnormalOffLineDays; |
| | | |
| | | /** |
| | | * 处理率 |
| | | */ |
| | | @TableField("abnormal_off_line_process_ratio") |
| | | @JsonProperty("AbnormalOfflineProcessRatio") |
| | | private Integer abnormalOffLineProcessRatio; |
| | | |
| | | /** |
| | | * 异常离线待处理天数 |
| | | */ |
| | | @TableField("abnormal_off_line_to_process_days") |
| | | @JsonProperty("AbnormalOfflineToProcessDays") |
| | | private Integer abnormalOffLineToProcessDays; |
| | | |
| | | /** |
| | | * 地址 |
| | | */ |
| | | @TableField("addr") |
| | | @JsonProperty("Addr") |
| | | private String addr; |
| | | |
| | | /** |
| | | * 排放物浓度折算(昨日) |
| | | */ |
| | | @TableField("c_emissions") |
| | | @JsonProperty("CEmissions") |
| | | private BigDecimal cEmissions; |
| | | |
| | | /** |
| | | * 在线日平均排放浓度 |
| | | */ |
| | | @TableField("c_emissions_avg_online") |
| | | @JsonProperty("CEmissionsAvgOnline") |
| | | private BigDecimal cEmissionsAvgOnline; |
| | | |
| | | /** |
| | | * 日最高排放浓度 |
| | | */ |
| | | @TableField("c_emissions_max") |
| | | @JsonProperty("CEmissionsMax") |
| | | private BigDecimal cEmissionsMax; |
| | | |
| | | /** |
| | | * 日最高排放浓度日期 |
| | | */ |
| | | @TableField("c_emissions_max_date") |
| | | @JsonProperty("CEmissionsMaxDate") |
| | | private LocalDateTime cEmissionsMaxDate; |
| | | |
| | | /** |
| | | * 颗粒物浓度折算(昨日) |
| | | */ |
| | | @TableField("c_granule") |
| | | @JsonProperty("CGranule") |
| | | private BigDecimal cGranule; |
| | | |
| | | /** |
| | | * 非甲烷总烃浓度折算 (昨日) |
| | | */ |
| | | @TableField("c_hydrocarbon") |
| | | @JsonProperty("CHydrocarbon") |
| | | private BigDecimal cHydrocarbon; |
| | | |
| | | /** |
| | | * 菜系名 |
| | | */ |
| | | @TableField("cuisine_name") |
| | | @JsonProperty("CuisineName") |
| | | private String cuisineName; |
| | | |
| | | /** |
| | | * 营业执照 |
| | | */ |
| | | @TableField("customer_bl_no") |
| | | @JsonProperty("CustomerBlNo") |
| | | private String customerBlNo; |
| | | |
| | | /** |
| | | * 联系人 |
| | | */ |
| | | @TableField("customer_contact") |
| | | @JsonProperty("CustomerContact") |
| | | private String customerContact; |
| | | |
| | | /** |
| | | * 电话 |
| | | */ |
| | | @TableField("customer_mobile") |
| | | @JsonProperty("CustomerMobile") |
| | | private String customerMobile; |
| | | |
| | | /** |
| | | * 店名称 |
| | | */ |
| | | @TableField("customer_name") |
| | | @JsonProperty("CustomerName") |
| | | private String customerName; |
| | | |
| | | /** |
| | | * 监测仪故障天数 |
| | | */ |
| | | @TableField("detector_failure_days") |
| | | @JsonProperty("DetectorFailureDays") |
| | | private Integer detectorFailureDays; |
| | | |
| | | /** |
| | | * 超标阈值 |
| | | */ |
| | | @TableField("emissions_sill") |
| | | @JsonProperty("EmissionsSill") |
| | | private Double emissionsSill; |
| | | |
| | | /** |
| | | * 超标数 |
| | | */ |
| | | @TableField("excess_num") |
| | | @JsonProperty("ExcessNum") |
| | | private Integer excessNum; |
| | | |
| | | /** |
| | | * 超标待处理天数 |
| | | */ |
| | | @TableField("excess_to_process_days") |
| | | @JsonProperty("ExcessToProcessDays") |
| | | private Integer excessToProcessDays; |
| | | |
| | | /** |
| | | * 净化器不正常使用天数 |
| | | */ |
| | | @TableField("filter_abnormally_used_days") |
| | | @JsonProperty("FilterAbnormallyUsedDays") |
| | | private Integer filterAbnormallyUsedDays; |
| | | |
| | | /** |
| | | * 净化器清洗次数 |
| | | */ |
| | | @TableField("filter_wash_times") |
| | | @JsonProperty("FilterWashTimes") |
| | | private Integer filterWashTimes; |
| | | |
| | | /** |
| | | * 健康码颜色 |
| | | */ |
| | | @TableField("health_code_color") |
| | | @JsonProperty("HealthCodeColor") |
| | | private String healthCodeColor; |
| | | |
| | | /** |
| | | * 非甲烷总烃超标阈值 |
| | | */ |
| | | @TableField("hydrocarbon_sill") |
| | | @JsonProperty("HydrocarbonSill") |
| | | private Double hydrocarbonSill; |
| | | /** |
| | | * 非甲烷总烃超标阈值 |
| | | */ |
| | | @TableField("granule_sill") |
| | | @JsonProperty("GranuleSill") |
| | | private Double granuleSill; |
| | | /** |
| | | * 监测点Id |
| | | */ |
| | | @TableField("locale_id") |
| | | @JsonProperty("LocaleId") |
| | | private String localeId; |
| | | |
| | | /** |
| | | * 纬度 |
| | | */ |
| | | @TableField("local_lat") |
| | | @JsonProperty("LocaleLat") |
| | | private String localLat; |
| | | |
| | | /** |
| | | * 经度 |
| | | */ |
| | | @TableField("local_lng") |
| | | @JsonProperty("LocaleLng") |
| | | private String localLng; |
| | | |
| | | /** |
| | | * 设备的mn数据 |
| | | */ |
| | | @TableField("mn") |
| | | @JsonProperty("MN") |
| | | private String mn; |
| | | |
| | | /** |
| | | * 名称 |
| | | */ |
| | | @TableField("name") |
| | | @JsonProperty("Name") |
| | | private String name; |
| | | |
| | | /** |
| | | * 店家原因导致离线天数 |
| | | */ |
| | | @TableField("off_line_cause_by_shop_days") |
| | | @JsonProperty("OfflineCausedByShopDays") |
| | | private Integer offLineCauseByShopDays; |
| | | |
| | | /** |
| | | * 所属单位 |
| | | */ |
| | | @TableField("owner") |
| | | @JsonProperty("Owner") |
| | | private String owner; |
| | | |
| | | /** |
| | | * 歇业天数 |
| | | */ |
| | | @TableField("shop_close_days") |
| | | @JsonProperty("ShopClosedDays") |
| | | private Integer shopCloseDays; |
| | | |
| | | /** |
| | | * 状态[1:一般监测点,2:特殊监测点,99:废弃监测点] |
| | | */ |
| | | @TableField("status") |
| | | @JsonProperty("Status") |
| | | private Integer status; |
| | | |
| | | /** |
| | | * 状态描述 |
| | | */ |
| | | @TableField("status_desc") |
| | | @JsonProperty("StatusDesc") |
| | | private String statusDesc; |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.entity.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | import java.io.Serializable; |
| | | |
| | | /** |
| | | * <p> |
| | | * 组织架构 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @TableName("ums_ods_customer") |
| | | public class OdsCustomer implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * id |
| | | */ |
| | | @TableId("id") |
| | | @JsonProperty("Id") |
| | | private Long id; |
| | | |
| | | /** |
| | | * 父节点 |
| | | */ |
| | | @TableField("pid") |
| | | @JsonProperty("Pid") |
| | | private String pid; |
| | | |
| | | /** |
| | | * 营业执照编号 |
| | | */ |
| | | @TableField("bl_no") |
| | | @JsonProperty("BlNo") |
| | | private String blNo; |
| | | |
| | | /** |
| | | * 营业执照名称 |
| | | */ |
| | | @TableField("bl_name") |
| | | @JsonProperty("BlName") |
| | | private String blName; |
| | | |
| | | /** |
| | | * 组织名称 |
| | | */ |
| | | @TableField("org") |
| | | @JsonProperty("Org") |
| | | private String org; |
| | | |
| | | /** |
| | | * 名称 |
| | | */ |
| | | @TableField("name") |
| | | @JsonProperty("Name") |
| | | private String name; |
| | | |
| | | /** |
| | | * 联系人 |
| | | */ |
| | | @TableField("contact") |
| | | @JsonProperty("Contact") |
| | | private String contact; |
| | | |
| | | /** |
| | | * 手机号 |
| | | */ |
| | | @TableField("mobile") |
| | | @JsonProperty("Mobile") |
| | | private String mobile; |
| | | |
| | | /** |
| | | * 联系电话 |
| | | */ |
| | | @TableField("telephone") |
| | | @JsonProperty("Telephone") |
| | | private String telephone; |
| | | |
| | | /** |
| | | * 类型(1:系统用户2:经销单位3:行政单位4:餐饮单位) |
| | | */ |
| | | @TableField("typ") |
| | | @JsonProperty("Typ") |
| | | private Integer typ; |
| | | |
| | | /** |
| | | * 创建者 |
| | | */ |
| | | @TableField("creator") |
| | | @JsonProperty("Creator") |
| | | private String creator; |
| | | |
| | | /** |
| | | * 创建时间 |
| | | */ |
| | | @TableField("create_at") |
| | | @JsonProperty("CreateAt") |
| | | private Long createAt; |
| | | |
| | | /** |
| | | * 状态 |
| | | */ |
| | | @TableField("status") |
| | | @JsonProperty("Status") |
| | | private Integer status; |
| | | |
| | | /** |
| | | * 地址 |
| | | */ |
| | | @TableField("address") |
| | | @JsonProperty("Address") |
| | | private String address; |
| | | |
| | | /** |
| | | * 标志 |
| | | */ |
| | | @TableField("logo") |
| | | @JsonProperty("Logo") |
| | | private String logo; |
| | | |
| | | /** |
| | | * 营业时间 |
| | | */ |
| | | @TableField("business_hour") |
| | | @JsonProperty("BusinessHour") |
| | | private String businessHour; |
| | | |
| | | /** |
| | | * 运维人员ID |
| | | */ |
| | | @TableField("maintainer_id") |
| | | @JsonProperty("MaintainerId") |
| | | private String maintainerId; |
| | | |
| | | /** |
| | | * 关联地址 |
| | | */ |
| | | @TableField("area_ids") |
| | | private String areaIdsString; |
| | | |
| | | /** |
| | | * 地址序列 |
| | | */ |
| | | @TableField("area_id_cascads") |
| | | private String areaIdCascadsString; |
| | | |
| | | /** |
| | | * 地址详细信息 |
| | | */ |
| | | @TableField("areas") |
| | | private String areasString; |
| | | |
| | | @TableField(exist = false) |
| | | @JsonProperty("AreaIds") |
| | | private String[] areaIds; |
| | | |
| | | /** |
| | | * 地址序列 |
| | | */ |
| | | @TableField(exist = false) |
| | | @JsonProperty("AreaIdCascades") |
| | | private String[] areaIdCascads; |
| | | |
| | | /** |
| | | * 地址详细信息 |
| | | */ |
| | | @TableField(exist = false) |
| | | @JsonProperty("Areas") |
| | | private String[] areas; |
| | | |
| | | /** |
| | | * 介绍 |
| | | */ |
| | | @TableField("desc1") |
| | | @JsonProperty("Desc") |
| | | private String desc; |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.entity.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | import java.io.Serializable; |
| | | import java.math.BigDecimal; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @TableName("ums_ods_detector_daily") |
| | | public class OdsDetectorDaily implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * id |
| | | */ |
| | | @TableId("id") |
| | | @JsonProperty("Id") |
| | | private String id; |
| | | |
| | | /** |
| | | * 设备mn |
| | | */ |
| | | @TableField("mn") |
| | | @JsonProperty("MN") |
| | | private String mn; |
| | | |
| | | /** |
| | | * 持有者 |
| | | */ |
| | | @TableField("owner") |
| | | @JsonProperty("Owner") |
| | | private String owner; |
| | | |
| | | /** |
| | | * 数据采集时间 |
| | | */ |
| | | @TableField("acquit_at") |
| | | @JsonProperty("AcquitAt") |
| | | private Long acquitAt; |
| | | |
| | | /** |
| | | * 数据采集日 |
| | | */ |
| | | @TableField("acquit_date") |
| | | @JsonProperty("AcquitDate") |
| | | private String acquitDate; |
| | | |
| | | /** |
| | | * 创建日期 |
| | | */ |
| | | @TableField("create_at") |
| | | @JsonProperty("CreateAt") |
| | | private Long createAt; |
| | | |
| | | /** |
| | | * 排放物浓度折算 |
| | | */ |
| | | @TableField("c_emissions") |
| | | @JsonProperty("CEmissions") |
| | | private BigDecimal cEmissions; |
| | | |
| | | /** |
| | | * 颗粒物浓度折算 |
| | | */ |
| | | @TableField("c_granule") |
| | | @JsonProperty("CGranule") |
| | | private BigDecimal cGranule; |
| | | |
| | | /** |
| | | * 非甲烷总烃浓度折算 |
| | | */ |
| | | @TableField("c_hydrocarbon") |
| | | @JsonProperty("CHydrocarbon") |
| | | private BigDecimal cHydrocarbon; |
| | | |
| | | /** |
| | | * 弃用 |
| | | */ |
| | | @TableField("e_missions") |
| | | @JsonProperty("Emissions") |
| | | private BigDecimal eMissions; |
| | | |
| | | /** |
| | | * 弃用 |
| | | */ |
| | | @TableField("granule") |
| | | @JsonProperty("Granule") |
| | | private BigDecimal granule; |
| | | |
| | | /** |
| | | * 弃用 |
| | | */ |
| | | @TableField("hydrocarbon") |
| | | @JsonProperty("Hydrocarbon") |
| | | private BigDecimal hydrocarbon; |
| | | |
| | | /** |
| | | * 转速 |
| | | */ |
| | | @TableField("velocity") |
| | | @JsonProperty("Velocity") |
| | | private BigDecimal velocity; |
| | | |
| | | /** |
| | | * 温度 |
| | | */ |
| | | @TableField("temperature") |
| | | @JsonProperty("Temperature") |
| | | private BigDecimal temperature; |
| | | |
| | | /** |
| | | * 湿度 |
| | | */ |
| | | @TableField("moisture") |
| | | @JsonProperty("Moisture") |
| | | private BigDecimal moisture; |
| | | |
| | | /** |
| | | * Pm2.5减排量 |
| | | */ |
| | | @TableField("red_pm25") |
| | | @JsonProperty("RedPm25") |
| | | private BigDecimal redPm25; |
| | | |
| | | /** |
| | | * pm10减排量 |
| | | */ |
| | | @TableField("red_pm10") |
| | | @JsonProperty("RedPm10") |
| | | private BigDecimal redPm10; |
| | | |
| | | /** |
| | | * 排放物减排量 |
| | | */ |
| | | @TableField("red_emissions") |
| | | @JsonProperty("RedEmissions") |
| | | private BigDecimal redEmissions; |
| | | |
| | | /** |
| | | * vocs减排量 |
| | | */ |
| | | @TableField("red_vocs") |
| | | @JsonProperty("RedVocs") |
| | | private BigDecimal redVocs; |
| | | |
| | | /** |
| | | * 设备数 |
| | | */ |
| | | @TableField("device_num") |
| | | @JsonProperty("DeviceNum") |
| | | private Integer deviceNum; |
| | | |
| | | /** |
| | | * 状态[1:正常,2:超标,3:正常离线,4异常离] |
| | | */ |
| | | @TableField("status") |
| | | @JsonProperty("Status") |
| | | private Integer status; |
| | | |
| | | /** |
| | | * 净化器风机联动比=净化器开并且风机开的条数/风机开的数据总条数*100%; |
| | | */ |
| | | @TableField("filter_fan_link_ratio") |
| | | @JsonProperty("FilterFanLinkRatio") |
| | | private BigDecimal filterFanLinkRatio; |
| | | |
| | | /** |
| | | * 净化器是否非正常使用 |
| | | */ |
| | | @TableField("filter_abnormally_used") |
| | | @JsonProperty("FilterAbnormallyUsed") |
| | | private Boolean filterAbnormallyUsed; |
| | | |
| | | /** |
| | | * 排放物超标 |
| | | */ |
| | | @TableField("c_emissions_exceed_standard") |
| | | @JsonProperty("CEmissionsExceedStandard") |
| | | private Boolean cEmissionsExceedStandard; |
| | | |
| | | /** |
| | | * 颗粒物超标 |
| | | */ |
| | | @TableField("c_granule_exceed_standard") |
| | | @JsonProperty("CGranuleExceedStandard") |
| | | private Boolean cGranuleExceedStandard; |
| | | |
| | | /** |
| | | * 非甲烷总烃超标 |
| | | */ |
| | | @TableField("c_hydrocarbon_exceed_standard") |
| | | @JsonProperty("CHydrocarbonExceedStandard") |
| | | private Boolean cHydrocarbonExceedStandard; |
| | | |
| | | /** |
| | | * 地区id |
| | | */ |
| | | @TableField("locale_id") |
| | | @JsonProperty("LocaleId") |
| | | private String localeId; |
| | | |
| | | /** |
| | | * 所属单位id |
| | | */ |
| | | @TableField("customer_id") |
| | | @JsonProperty("CustomerId") |
| | | private Integer customerId; |
| | | |
| | | /** |
| | | * 用户 |
| | | */ |
| | | @TableField("customer") |
| | | @JsonProperty("Customer") |
| | | private String customer; |
| | | |
| | | /** |
| | | * 排放物阈值 |
| | | */ |
| | | @TableField("locale_emissions_sill") |
| | | @JsonProperty("LocaleEmissionsSill") |
| | | private BigDecimal localeEmissionsSill; |
| | | |
| | | /** |
| | | * 颗粒物阈值 |
| | | */ |
| | | @TableField("locale_granule_sill") |
| | | @JsonProperty("LocaleGranuleSill") |
| | | private BigDecimal localeGranuleSill; |
| | | |
| | | /** |
| | | * 非甲烷总烃阈值 |
| | | */ |
| | | @TableField("locale_hydrocarbon_sill") |
| | | @JsonProperty("LocaleHydrocarbonSill") |
| | | private BigDecimal localeHydrocarbonSill; |
| | | |
| | | /** |
| | | * 监测点名 |
| | | */ |
| | | @TableField("locale_name") |
| | | @JsonProperty("LocaleName") |
| | | private String localeName; |
| | | |
| | | /** |
| | | * 监测点 |
| | | */ |
| | | @TableField("locale_addr") |
| | | @JsonProperty("LocaleAddr") |
| | | private String localeAddr; |
| | | |
| | | /** |
| | | * 异常离线 |
| | | */ |
| | | @TableField("abnormal_off_line") |
| | | @JsonProperty("AbnormalOffline") |
| | | private Boolean abnormalOffLine; |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.entity.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | import java.io.Serializable; |
| | | import java.math.BigDecimal; |
| | | |
| | | /** |
| | | * <p> |
| | | * 返回实时的设备数据 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @TableName("ums_ods_in_time") |
| | | public class OdsInTime implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 实时数据的设备编号(中间有“-”连接代表该监测点有多个设备绑定) |
| | | */ |
| | | @TableId("id") |
| | | @JsonProperty("Id") |
| | | private String id; |
| | | |
| | | /** |
| | | * 采集时间 |
| | | */ |
| | | @TableField("acquit_at") |
| | | @JsonProperty("AcquitAt") |
| | | private Long acquitAt; |
| | | |
| | | /** |
| | | * 最后确认时间 |
| | | */ |
| | | @TableField("last_at") |
| | | @JsonProperty("LastAt") |
| | | private Long lastAt; |
| | | |
| | | /** |
| | | * 排放物折算浓度 |
| | | */ |
| | | @TableField("c_emissions") |
| | | @JsonProperty("CEmissions") |
| | | private String cEmissions; |
| | | |
| | | /** |
| | | * 颗粒物折算浓度 |
| | | */ |
| | | @TableField("c_granule") |
| | | @JsonProperty("CGranule") |
| | | private String cGranule; |
| | | |
| | | /** |
| | | * 非甲烷总烃折算浓度 |
| | | */ |
| | | @TableField("c_hydrocarbon") |
| | | @JsonProperty("CHydrocarbon") |
| | | private BigDecimal cHydrocarbon; |
| | | |
| | | /** |
| | | * 实时排放量 |
| | | */ |
| | | @TableField("emissions_conc") |
| | | @JsonProperty("EmissionsConc") |
| | | private BigDecimal emissionsConc; |
| | | |
| | | /** |
| | | * 颗粒物含量 |
| | | */ |
| | | @TableField("granule_conc") |
| | | @JsonProperty("GranuleConc") |
| | | private BigDecimal granuleConc; |
| | | |
| | | /** |
| | | * 非甲烷总烃含量 |
| | | */ |
| | | @TableField("hydrocarbon_conc") |
| | | @JsonProperty("HydrocarbonConc") |
| | | private BigDecimal hydrocarbonConc; |
| | | |
| | | /** |
| | | * 风机状态(1:开2:关3:异常) |
| | | */ |
| | | @TableField("fan_status") |
| | | @JsonProperty("FanStatus") |
| | | private Integer fanStatus; |
| | | |
| | | /** |
| | | * 净化器状态(1:开2:关3:异常) |
| | | */ |
| | | @TableField("filter_status") |
| | | @JsonProperty("FilterStatus") |
| | | private Integer filterStatus; |
| | | |
| | | /** |
| | | * 类型[1:监控:2:监测] |
| | | */ |
| | | @TableField("typ") |
| | | @JsonProperty("Typ") |
| | | private Integer typ; |
| | | |
| | | /** |
| | | * 状态 |
| | | (NORMAL正常、ALARM预警、EXCESS超标、DOWN离线、OFF异常离线) |
| | | |
| | | */ |
| | | @TableField("status") |
| | | @JsonProperty("Status") |
| | | private String status; |
| | | |
| | | /** |
| | | * 流速 |
| | | */ |
| | | @TableField("velocity") |
| | | @JsonProperty("Velocity") |
| | | private Double velocity; |
| | | |
| | | /** |
| | | * 温度 |
| | | */ |
| | | @TableField("temperature") |
| | | @JsonProperty("Temperature") |
| | | private Double temperature; |
| | | |
| | | /** |
| | | * 湿度 |
| | | */ |
| | | @TableField("moisture") |
| | | @JsonProperty("Moisture") |
| | | private Double moisture; |
| | | |
| | | /** |
| | | * 监测点名称 |
| | | */ |
| | | @TableField("locale") |
| | | @JsonProperty("Locale") |
| | | private String locale; |
| | | |
| | | /** |
| | | * 监测点ID |
| | | */ |
| | | @TableField("lid") |
| | | @JsonProperty("Lid") |
| | | private String lid; |
| | | |
| | | /** |
| | | * 所属单位 |
| | | */ |
| | | @TableField("owner") |
| | | @JsonProperty("Owner") |
| | | private String owner; |
| | | |
| | | /** |
| | | * 安装地址 |
| | | */ |
| | | @TableField("addr") |
| | | @JsonProperty("Addr") |
| | | private String addr; |
| | | |
| | | /** |
| | | * 超标阈值 |
| | | */ |
| | | @TableField("emissions_sill") |
| | | @JsonProperty("EmissionsSill") |
| | | private Double emissionsSill; |
| | | |
| | | /** |
| | | * 颗粒物超标阈值 |
| | | */ |
| | | @TableField("granule_sill") |
| | | @JsonProperty("GranuleSill") |
| | | private Double granuleSill; |
| | | |
| | | /** |
| | | * 非甲烷总烃超标阈值 |
| | | */ |
| | | @TableField("hydrocarbon_sill") |
| | | @JsonProperty("HydrocarbonSill") |
| | | private Double hydrocarbonSill; |
| | | |
| | | /** |
| | | * 是否联动(0:否1:是) |
| | | */ |
| | | @TableField("link_status") |
| | | @JsonProperty("LinkStatus") |
| | | private Integer linkStatus; |
| | | |
| | | /** |
| | | * 联系电话 |
| | | */ |
| | | @TableField("customer_mobile") |
| | | @JsonProperty("CustomerMobile") |
| | | private String customerMobile; |
| | | |
| | | /** |
| | | * 经度 |
| | | */ |
| | | @TableField("locale_lng") |
| | | @JsonProperty("LocaleLng") |
| | | private String localeLng; |
| | | |
| | | /** |
| | | * 纬度 |
| | | */ |
| | | @TableField("localelat") |
| | | @JsonProperty("LocaleLat") |
| | | private String localelat; |
| | | |
| | | /** |
| | | * 风机电流值 |
| | | */ |
| | | @TableField("fan_current") |
| | | @JsonProperty("fan_current") |
| | | private Double fanCurrent; |
| | | |
| | | /** |
| | | * 净化器电流值 |
| | | */ |
| | | @TableField("pur_current") |
| | | @JsonProperty("pur_current") |
| | | private Double purCurrent; |
| | | |
| | | /** |
| | | * 整体状态(1:在线2:离线3:异常离线) |
| | | */ |
| | | @TableField("online_status") |
| | | @JsonProperty("OnlineStatus") |
| | | private Integer onlineStatus; |
| | | |
| | | /** |
| | | * (NORMAL:正常、OFFLINE:下线、ABANDONED:废弃) |
| | | */ |
| | | @TableField("status_of_record") |
| | | @JsonProperty("StatusOfRecord") |
| | | private String statusOfRecord; |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.entity.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | import java.io.Serializable; |
| | | import java.math.BigDecimal; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测点信息 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @TableName("ums_ods_locale") |
| | | public class OdsLocale implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * Id |
| | | */ |
| | | @TableId("id") |
| | | @JsonProperty("Id") |
| | | private String id; |
| | | |
| | | /** |
| | | * 烟道名称 |
| | | */ |
| | | @TableField("n_name") |
| | | @JsonProperty("Name") |
| | | private String nName; |
| | | |
| | | /** |
| | | * 单位[级联] |
| | | */ |
| | | @TableField("owner") |
| | | @JsonProperty("Owner") |
| | | private String owner; |
| | | |
| | | /** |
| | | * 菜系 |
| | | */ |
| | | @TableField("cuisine") |
| | | @JsonProperty("Cuisine") |
| | | private Integer cuisine; |
| | | |
| | | /** |
| | | * 组织ID |
| | | */ |
| | | @TableField("customer_id") |
| | | @JsonProperty("CustomerId") |
| | | private String customerId; |
| | | |
| | | /** |
| | | * 风速 |
| | | */ |
| | | @TableField("fan_speed") |
| | | @JsonProperty("FanSpeed") |
| | | private BigDecimal fanSpeed; |
| | | |
| | | /** |
| | | * 风量 |
| | | */ |
| | | @TableField("fan_quantity") |
| | | @JsonProperty("FanQuantity") |
| | | private BigDecimal fanQuantity; |
| | | |
| | | /** |
| | | * 管道截面面积 |
| | | */ |
| | | @TableField("pipe_area") |
| | | @JsonProperty("PipeArea") |
| | | private BigDecimal pipeArea; |
| | | |
| | | /** |
| | | * 灶头数量 |
| | | */ |
| | | @TableField("stove_num") |
| | | @JsonProperty("StoveNum") |
| | | private Integer stoveNum; |
| | | |
| | | /** |
| | | * 离线判定[小时] |
| | | */ |
| | | @TableField("offline_judge") |
| | | @JsonProperty("OfflineJudge") |
| | | private Integer offlineJudge; |
| | | |
| | | /** |
| | | * 风机状态 |
| | | */ |
| | | @TableField("fan_status") |
| | | @JsonProperty("FanStatus") |
| | | private Integer fanStatus; |
| | | |
| | | /** |
| | | * 净化器信息 |
| | | */ |
| | | @TableField("filter_info") |
| | | @JsonProperty("FilterInfo") |
| | | private String filterInfo; |
| | | |
| | | /** |
| | | * 净化器状态 |
| | | */ |
| | | @TableField("filter_status") |
| | | @JsonProperty("FilterStatus") |
| | | private Integer filterStatus; |
| | | |
| | | /** |
| | | * 抽样次数 |
| | | */ |
| | | @TableField("samplings") |
| | | @JsonProperty("Samplings") |
| | | private Integer samplings; |
| | | |
| | | /** |
| | | * 是否联动 |
| | | */ |
| | | @TableField("link_status") |
| | | @JsonProperty("LinkStatus") |
| | | private Boolean linkStatus; |
| | | |
| | | /** |
| | | * 超标阈值 |
| | | */ |
| | | @TableField("emissions_sill") |
| | | @JsonProperty("EmissionsSill") |
| | | private BigDecimal emissionsSill; |
| | | |
| | | /** |
| | | * 集气灶面积[调研] |
| | | */ |
| | | @TableField("stove_area") |
| | | @JsonProperty("StoveArea") |
| | | private BigDecimal stoveArea; |
| | | |
| | | /** |
| | | * 日均排烟时间[调研] |
| | | */ |
| | | @TableField("exhaust_time") |
| | | @JsonProperty("ExhaustTime") |
| | | private String exhaustTime; |
| | | |
| | | /** |
| | | * 备注[调研] |
| | | */ |
| | | @TableField("remark") |
| | | @JsonProperty("Remark") |
| | | private String remark; |
| | | |
| | | /** |
| | | * 地址 |
| | | */ |
| | | @TableField("addr") |
| | | @JsonProperty("Addr") |
| | | private String addr; |
| | | |
| | | /** |
| | | * 地区[级联] |
| | | */ |
| | | @TableField("area_id") |
| | | @JsonProperty("AreaId") |
| | | private String areaId; |
| | | |
| | | /** |
| | | * 经度 |
| | | */ |
| | | @TableField("lng") |
| | | @JsonProperty("Lng") |
| | | private String lng; |
| | | |
| | | /** |
| | | * 纬度 |
| | | */ |
| | | @TableField("lat") |
| | | @JsonProperty("Lat") |
| | | private String lat; |
| | | |
| | | /** |
| | | * 创建者 |
| | | */ |
| | | @TableField("creator") |
| | | @JsonProperty("Creator") |
| | | private String creator; |
| | | |
| | | /** |
| | | * 创建日期 |
| | | */ |
| | | @TableField("create_at") |
| | | @JsonProperty("CreateAt") |
| | | private String createAt; |
| | | |
| | | /** |
| | | * 状态[1:一般监测点,2:特殊监测点,99:废弃监测点] |
| | | */ |
| | | @TableField("status") |
| | | @JsonProperty("Status") |
| | | private Integer status; |
| | | |
| | | /** |
| | | * 颗粒物含量超标阈值 |
| | | */ |
| | | @TableField("granule_sill") |
| | | @JsonProperty("GranuleSill") |
| | | private BigDecimal granuleSill; |
| | | |
| | | /** |
| | | * 非甲烷总烃超标阈值 |
| | | */ |
| | | @TableField("hydrocarbon_sill") |
| | | @JsonProperty("HydrocarbonSill") |
| | | private BigDecimal hydrocarbonSill; |
| | | |
| | | /** |
| | | * 健康码颜色 |
| | | */ |
| | | @TableField("health_code_color") |
| | | @JsonProperty("HealthCodeColor") |
| | | private String healthCodeColor; |
| | | |
| | | /** |
| | | * 最后绑定设备mn |
| | | */ |
| | | @TableField("mn_last") |
| | | @JsonProperty("MnLast") |
| | | private String mnLast; |
| | | |
| | | /** |
| | | * 监测点图片 |
| | | */ |
| | | @TableField("locale_pics") |
| | | @JsonProperty("LocalePics") |
| | | private String localePics; |
| | | |
| | | /** |
| | | * 设备类型 最后一次绑定 |
| | | */ |
| | | @TableField("mn_typ_last") |
| | | @JsonProperty("MnTypLast") |
| | | private Integer mnTypLast; |
| | | |
| | | /** |
| | | * 风机信息 |
| | | */ |
| | | @TableField("fan_info") |
| | | @JsonProperty("FanInfo") |
| | | private String fanInfo; |
| | | |
| | | /** |
| | | * 取电方式 |
| | | */ |
| | | @TableField("power_supply_mode") |
| | | @JsonProperty("PowerSupplyMode") |
| | | private String powerSupplyMode; |
| | | |
| | | /** |
| | | * 净化器风机联动比阈值 |
| | | */ |
| | | @TableField("link_ratio_sill") |
| | | @JsonProperty("LinkRatioSill") |
| | | private BigDecimal linkRatioSill; |
| | | |
| | | /** |
| | | * 运维人员ID |
| | | */ |
| | | @TableField("maintainer_id") |
| | | @JsonProperty("MaintainerId") |
| | | private String maintainerId; |
| | | |
| | | /** |
| | | * 绿码:最近X天内,该店家超标次数小等于Value1(默认3)次的,且净化器不正常使用天数小等于Value2(默认3)天的,且离线天数{非歇业、非监测仪故障【数据来源运维人员填写的”异常处理“】}小等于Value3(默认3)。 |
| | | */ |
| | | @TableField("health_code_x") |
| | | @JsonProperty("HealthCodeX") |
| | | private Integer healthCodeX; |
| | | |
| | | @TableField("health_code_value1") |
| | | @JsonProperty("HealthCodeValue1") |
| | | private Integer healthCodeValue1; |
| | | |
| | | @TableField("health_code_value2") |
| | | @JsonProperty("HealthCodeValue2") |
| | | private Integer healthCodeValue2; |
| | | |
| | | @TableField("health_code_value3") |
| | | @JsonProperty("HealthCodeValue3") |
| | | private Integer healthCodeValue3; |
| | | |
| | | /** |
| | | * 红码:最近X天内,该店家超标次数大于Value4(默认5)次的,或者净化器不正常使用天数大于Value5(默认5)天的,且离线天数小于Value6(默认5)。 |
| | | */ |
| | | @TableField("health_code_value4") |
| | | @JsonProperty("HealthCodeValue4") |
| | | private Integer healthCodeValue4; |
| | | |
| | | @TableField("health_code_value5") |
| | | @JsonProperty("HealthCodeValue5") |
| | | private Integer healthCodeValue5; |
| | | |
| | | @TableField("health_code_value6") |
| | | @JsonProperty("HealthCodeValue6") |
| | | private Integer healthCodeValue6; |
| | | |
| | | /** |
| | | * 0~24点间油烟浓度(颗粒物、非甲烷总烃)三个值中的一项值一直小于Value7(默认0.05)mg/M3的,视为数据异常偏小; |
| | | */ |
| | | @TableField("abnormal_value7") |
| | | @JsonProperty("AbnormalValue7") |
| | | private BigDecimal abnormalValue7; |
| | | |
| | | /** |
| | | * 0~24点间油烟浓度(颗粒物、非甲烷总烃)三个值中的一项值一直大于Value8(默认30)mg/M3的,视为数据异常偏大; |
| | | */ |
| | | @TableField("abnormal_value8") |
| | | @JsonProperty("AbnormalValue8") |
| | | private BigDecimal abnormalValue8; |
| | | |
| | | /** |
| | | * 0~24点间油烟浓度(颗粒物、非甲烷总烃)三个值中的一项值一直非Value9(默认0)mg/M3的,视为数据漂移异常 |
| | | */ |
| | | @TableField("abnormal_value9") |
| | | @JsonProperty("AbnormalValue9") |
| | | private BigDecimal abnormalValue9; |
| | | |
| | | /** |
| | | * 0~24点间上线时间小于Value10(默认60)分钟的,视为上线时间过短异常; |
| | | */ |
| | | @TableField("abnormal_value10") |
| | | @JsonProperty("AbnormalValue10") |
| | | private BigDecimal abnormalValue10; |
| | | |
| | | /** |
| | | * Ali设备名称 |
| | | */ |
| | | @TableField("ali_iot_device_name") |
| | | @JsonProperty("AliIotDeviceName") |
| | | private String aliIotDeviceName; |
| | | |
| | | /** |
| | | * Ali设备 |
| | | */ |
| | | @TableField("ali_iot") |
| | | @JsonProperty("AliIot") |
| | | private String aliIot; |
| | | |
| | | /** |
| | | * 创建时间 |
| | | */ |
| | | @TableField("created_at") |
| | | @JsonProperty("CreatedAt") |
| | | private String createdAt; |
| | | |
| | | /** |
| | | * 更新时间 |
| | | */ |
| | | @TableField("updated_at") |
| | | @JsonProperty("UpdatedAt") |
| | | private String updatedAt; |
| | | |
| | | @TableField("health_code_value11") |
| | | @JsonProperty("HealthCodeValue11") |
| | | private Integer healthCodeValue11; |
| | | |
| | | @TableField("health_code_value12") |
| | | @JsonProperty("HealthCodeValue12") |
| | | private Integer healthCodeValue12; |
| | | |
| | | /** |
| | | * 监测方式【1:合并传输 2:独立传输】 |
| | | */ |
| | | @TableField("send_mode") |
| | | @JsonProperty("SendMode") |
| | | private Integer sendMode; |
| | | |
| | | /** |
| | | * 超标计算方式【1:抽样计算 2:滑动计算】 |
| | | */ |
| | | @TableField("surpass_calc_method") |
| | | @JsonProperty("SurpassCalcMethod") |
| | | private Integer surpassCalcMethod; |
| | | |
| | | /** |
| | | * 风机正常电流值 |
| | | */ |
| | | @TableField("fan_standard_current") |
| | | @JsonProperty("FanStandardCurrent") |
| | | private Integer fanStandardCurrent; |
| | | |
| | | /** |
| | | * 净化器正常电流值 |
| | | */ |
| | | @TableField("filter_standard_current") |
| | | @JsonProperty("FilterStandardCurrent") |
| | | private Integer filterStandardCurrent; |
| | | |
| | | /** |
| | | * 设备状态[正常NORMAL、下线OFFLINE、废弃ABANDON] |
| | | */ |
| | | @TableField("status_of_record") |
| | | @JsonProperty("StatusOfRecord") |
| | | private String statusOfRecord; |
| | | |
| | | /** |
| | | * 审核备注 |
| | | */ |
| | | @TableField("remark_of_record") |
| | | @JsonProperty("RemarkOfRecord") |
| | | private String remarkOfRecord; |
| | | |
| | | /** |
| | | * 审核原因 |
| | | */ |
| | | @TableField("cause") |
| | | @JsonProperty("Cause") |
| | | private String cause; |
| | | |
| | | @TableField("customer") |
| | | private String customerString; |
| | | |
| | | @JsonProperty("Customer") |
| | | @TableField(exist = false) |
| | | private OdsLocaleCustomer customer; |
| | | } |
| New file |
| | |
| | | package com.ycl.entity.smoke; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | public class OdsLocaleCustomer { |
| | | |
| | | @JsonProperty("Id") |
| | | private int id; |
| | | @JsonProperty("Pid") |
| | | private String pid; |
| | | @JsonProperty("BlNo") |
| | | private String blNo; |
| | | @JsonProperty("BlName") |
| | | private String blName; |
| | | @JsonProperty("Org") |
| | | private String org; |
| | | @JsonProperty("Name") |
| | | private String name; |
| | | @JsonProperty("Contact") |
| | | private String contact; |
| | | @JsonProperty("Mobile") |
| | | private String mobile; |
| | | @JsonProperty("Telephone") |
| | | private String telephone; |
| | | @JsonProperty("Typ") |
| | | private int typ; |
| | | @JsonProperty("Creator") |
| | | private String creator; |
| | | @JsonProperty("CreateAt") |
| | | private long createAt; |
| | | @JsonProperty("Status") |
| | | private int status; |
| | | @JsonProperty("Address") |
| | | private String address; |
| | | @JsonProperty("Logo") |
| | | private String logo; |
| | | @JsonProperty("BusinessHour") |
| | | private String businessHour; |
| | | @JsonProperty("Desc") |
| | | private String desc; |
| | | @JsonProperty("MaintainerId") |
| | | private String maintainerId; |
| | | @JsonProperty("AreaIds") |
| | | private String areaIds; |
| | | @JsonProperty("AreaIdCascades") |
| | | private String areaIdCascades; |
| | | @JsonProperty("Areas") |
| | | private String areas; |
| | | @JsonProperty("PerPage") |
| | | private int perPage; |
| | | @JsonProperty("Page") |
| | | private int page; |
| | | } |
| New file |
| | |
| | | package com.ycl.entity.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonProperty; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | |
| | | import java.io.Serializable; |
| | | import java.math.BigDecimal; |
| | | |
| | | /** |
| | | * <p> |
| | | * |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @TableName("ums_ods_ten_min_data") |
| | | public class OdsTenMinData implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 数据id |
| | | */ |
| | | @TableId("id") |
| | | @JsonProperty("id") |
| | | private String id; |
| | | |
| | | /** |
| | | * 设备编号 |
| | | */ |
| | | @TableField("mn") |
| | | @JsonProperty("mn") |
| | | private String mn; |
| | | |
| | | /** |
| | | * 设备采集时间戳/600 |
| | | */ |
| | | @TableField("acquit_at") |
| | | @JsonProperty("acquit_at") |
| | | private Long acquitAt; |
| | | |
| | | /** |
| | | * 设备十分钟内发送数据的次数 |
| | | */ |
| | | @TableField("counter") |
| | | @JsonProperty("counter") |
| | | private Integer counter; |
| | | |
| | | /** |
| | | * 创建时间的时间戳 |
| | | */ |
| | | @TableField("create_at") |
| | | @JsonProperty("create_at") |
| | | private Long createAt; |
| | | |
| | | /** |
| | | * 实时排放量,这个是10分钟内的累积量 |
| | | */ |
| | | @TableField("emissions_conc") |
| | | @JsonProperty("emissions_conc") |
| | | private Double emissionsConc; |
| | | |
| | | /** |
| | | * 颗粒物含量 |
| | | */ |
| | | @TableField("granule_conc") |
| | | @JsonProperty("granule_conc") |
| | | private Double granuleConc; |
| | | |
| | | /** |
| | | * 非甲烷总烃 |
| | | */ |
| | | @TableField("hydrocarbon_conc") |
| | | @JsonProperty("hydrocarbon_conc") |
| | | private Double hydrocarbonConc; |
| | | |
| | | /** |
| | | * 流速 |
| | | */ |
| | | @TableField("velocity") |
| | | @JsonProperty("velocity") |
| | | private BigDecimal velocity; |
| | | |
| | | /** |
| | | * 温度 |
| | | */ |
| | | @TableField("temperature") |
| | | @JsonProperty("temperature") |
| | | private BigDecimal temperature; |
| | | |
| | | /** |
| | | * 湿度 |
| | | */ |
| | | @TableField("moisture") |
| | | @JsonProperty("moisture") |
| | | private BigDecimal moisture; |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.mapper.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ycl.entity.smoke.OdsAlarmMsg; |
| | | |
| | | /** |
| | | * <p> |
| | | * 报警消息 Mapper 接口 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface OdsAlarmMsgMapper extends BaseMapper<OdsAlarmMsg> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.mapper.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ycl.entity.smoke.OdsAlarmRecord; |
| | | |
| | | /** |
| | | * <p> |
| | | * 报警记录 Mapper 接口 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface OdsAlarmRecordMapper extends BaseMapper<OdsAlarmRecord> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.mapper.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ycl.entity.smoke.OdsCurAlarm; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测点统计&健康码管理 Mapper 接口 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface OdsCurAlarmMapper extends BaseMapper<OdsCurAlarm> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.mapper.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ycl.entity.smoke.OdsCustomer; |
| | | |
| | | /** |
| | | * <p> |
| | | * 组织架构 Mapper 接口 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface OdsCustomerMapper extends BaseMapper<OdsCustomer> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.mapper.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ycl.entity.smoke.OdsDetectorDaily; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测 Mapper 接口 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface OdsDetectorDailyMapper extends BaseMapper<OdsDetectorDaily> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.mapper.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ycl.entity.smoke.OdsInTime; |
| | | |
| | | /** |
| | | * <p> |
| | | * 返回实时的设备数据 Mapper 接口 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface OdsInTimeMapper extends BaseMapper<OdsInTime> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.mapper.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ycl.entity.smoke.OdsLocale; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测点信息 Mapper 接口 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface OdsLocaleMapper extends BaseMapper<OdsLocale> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.mapper.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ycl.entity.smoke.OdsTenMinData; |
| | | |
| | | /** |
| | | * <p> |
| | | * Mapper 接口 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface OdsTenMinDataMapper extends BaseMapper<OdsTenMinData> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ycl.entity.smoke.OdsAlarmMsg; |
| | | |
| | | /** |
| | | * <p> |
| | | * 报警消息 服务类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface IOdsAlarmMsgService extends IService<OdsAlarmMsg> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ycl.entity.smoke.OdsAlarmRecord; |
| | | |
| | | /** |
| | | * <p> |
| | | * 报警记录 服务类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface IOdsAlarmRecordService extends IService<OdsAlarmRecord> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ycl.entity.smoke.OdsCurAlarm; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测点统计&健康码管理 服务类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface IOdsCurAlarmService extends IService<OdsCurAlarm> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ycl.entity.smoke.OdsCustomer; |
| | | |
| | | /** |
| | | * <p> |
| | | * 组织架构 服务类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface IOdsCustomerService extends IService<OdsCustomer> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ycl.entity.smoke.OdsDetectorDaily; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测 服务类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface IOdsDetectorDailyService extends IService<OdsDetectorDaily> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ycl.entity.smoke.OdsInTime; |
| | | |
| | | /** |
| | | * <p> |
| | | * 返回实时的设备数据 服务类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface IOdsInTimeService extends IService<OdsInTime> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ycl.entity.smoke.OdsLocale; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测点信息 服务类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface IOdsLocaleService extends IService<OdsLocale> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ycl.entity.smoke.OdsTenMinData; |
| | | |
| | | /** |
| | | * <p> |
| | | * 服务类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | public interface IOdsTenMinDataService extends IService<OdsTenMinData> { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ycl.entity.smoke.OdsAlarmMsg; |
| | | import com.ycl.mapper.smoke.OdsAlarmMsgMapper; |
| | | import com.ycl.service.smoke.IOdsAlarmMsgService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 报警消息 服务实现类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Service |
| | | public class OdsAlarmMsgServiceImpl extends ServiceImpl<OdsAlarmMsgMapper, OdsAlarmMsg> implements IOdsAlarmMsgService { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ycl.entity.smoke.OdsAlarmRecord; |
| | | import com.ycl.mapper.smoke.OdsAlarmRecordMapper; |
| | | import com.ycl.service.smoke.IOdsAlarmRecordService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 报警记录 服务实现类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Service |
| | | public class OdsAlarmRecordServiceImpl extends ServiceImpl<OdsAlarmRecordMapper, OdsAlarmRecord> implements IOdsAlarmRecordService { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ycl.entity.smoke.OdsCurAlarm; |
| | | import com.ycl.mapper.smoke.OdsCurAlarmMapper; |
| | | import com.ycl.service.smoke.IOdsCurAlarmService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测点统计&健康码管理 服务实现类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Service |
| | | public class OdsCurAlarmServiceImpl extends ServiceImpl<OdsCurAlarmMapper, OdsCurAlarm> implements IOdsCurAlarmService { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ycl.entity.smoke.OdsCustomer; |
| | | import com.ycl.mapper.smoke.OdsCustomerMapper; |
| | | import com.ycl.service.smoke.IOdsCustomerService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 组织架构 服务实现类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Service |
| | | public class OdsCustomerServiceImpl extends ServiceImpl<OdsCustomerMapper, OdsCustomer> implements IOdsCustomerService { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ycl.entity.smoke.OdsDetectorDaily; |
| | | import com.ycl.mapper.smoke.OdsDetectorDailyMapper; |
| | | import com.ycl.service.smoke.IOdsDetectorDailyService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测 服务实现类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Service |
| | | public class OdsDetectorDailyServiceImpl extends ServiceImpl<OdsDetectorDailyMapper, OdsDetectorDaily> implements IOdsDetectorDailyService { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ycl.entity.smoke.OdsInTime; |
| | | import com.ycl.mapper.smoke.OdsInTimeMapper; |
| | | import com.ycl.service.smoke.IOdsInTimeService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 返回实时的设备数据 服务实现类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Service |
| | | public class OdsInTimeServiceImpl extends ServiceImpl<OdsInTimeMapper, OdsInTime> implements IOdsInTimeService { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ycl.entity.smoke.OdsLocale; |
| | | import com.ycl.mapper.smoke.OdsLocaleMapper; |
| | | import com.ycl.service.smoke.IOdsLocaleService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 监测点信息 服务实现类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Service |
| | | public class OdsLocaleServiceImpl extends ServiceImpl<OdsLocaleMapper, OdsLocale> implements IOdsLocaleService { |
| | | |
| | | } |
| New file |
| | |
| | | package com.ycl.service.smoke.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ycl.entity.smoke.OdsTenMinData; |
| | | import com.ycl.mapper.smoke.OdsTenMinDataMapper; |
| | | import com.ycl.service.smoke.IOdsTenMinDataService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | | * <p> |
| | | * 服务实现类 |
| | | * </p> |
| | | * |
| | | * @author lyq |
| | | * @since 2023-02-28 |
| | | */ |
| | | @Service |
| | | public class OdsTenMinDataServiceImpl extends ServiceImpl<OdsTenMinDataMapper, OdsTenMinData> implements IOdsTenMinDataService { |
| | | |
| | | } |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.mapper.OdsAlarmMsgMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.ycl.entity.smoke.OdsAlarmMsg"> |
| | | <id column="id" property="id" /> |
| | | <result column="mn" property="mn" /> |
| | | <result column="acquit_at" property="acquitAt" /> |
| | | <result column="owner" property="owner" /> |
| | | <result column="content" property="content" /> |
| | | <result column="msg_type" property="msgType" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, mn, acquit_at, owner, content, msg_type |
| | | </sql> |
| | | |
| | | </mapper> |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.mapper.smoke.OdsAlarmRecordMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.ycl.entity.smoke.OdsAlarmRecord"> |
| | | <id column="id" property="id" /> |
| | | <result column="local_id" property="localId" /> |
| | | <result column="mn" property="mn" /> |
| | | <result column="typ" property="typ" /> |
| | | <result column="alarm_date" property="alarmDate" /> |
| | | <result column="device_type" property="deviceType" /> |
| | | <result column="acquit_at" property="acquitAt" /> |
| | | <result column="process_at" property="processAt" /> |
| | | <result column="owner" property="owner" /> |
| | | <result column="solution" property="solution" /> |
| | | <result column="processing_address" property="processingAddress" /> |
| | | <result column="addr" property="addr" /> |
| | | <result column="process_user_id" property="processUserId" /> |
| | | <result column="process_user_name" property="processUserName" /> |
| | | <result column="process_reason" property="processReason" /> |
| | | <result column="created_at" property="createdAt" /> |
| | | <result column="update_at" property="updateAt" /> |
| | | <result column="total" property="total" /> |
| | | <result column="alarm_record_pics" property="alarmRecordPicsString" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, local_id, mn, typ, alarm_date, device_type, acquit_at, process_at, owner, solution, processing_address, addr, process_user_id, process_user_name, process_reason, created_at, update_at, total, alarm_record_pics |
| | | </sql> |
| | | |
| | | </mapper> |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.mapper.smoke.OdsCurAlarmMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.ycl.entity.smoke.OdsCurAlarm"> |
| | | <id column="id" property="id" /> |
| | | <result column="abnormal_off_line_days" property="abnormalOffLineDays" /> |
| | | <result column="abnormal_off_line_process_ratio" property="abnormalOffLineProcessRatio" /> |
| | | <result column="abnormal_off_line_to_process_days" property="abnormalOffLineToProcessDays" /> |
| | | <result column="addr" property="addr" /> |
| | | <result column="c_emissions" property="cEmissions" /> |
| | | <result column="c_emissions_avg_online" property="cEmissionsAvgOnline" /> |
| | | <result column="c_emissions_max" property="cEmissionsMax" /> |
| | | <result column="c_emissions_max_date" property="cEmissionsMaxDate" /> |
| | | <result column="c_granule" property="cGranule" /> |
| | | <result column="c_hydrocarbon" property="cHydrocarbon" /> |
| | | <result column="cuisine_name" property="cuisineName" /> |
| | | <result column="customer_bl_no" property="customerBlNo" /> |
| | | <result column="customer_contact" property="customerContact" /> |
| | | <result column="customer_mobile" property="customerMobile" /> |
| | | <result column="customer_name" property="customerName" /> |
| | | <result column="detector_failure_days" property="detectorFailureDays" /> |
| | | <result column="emissions_sill" property="emissionsSill" /> |
| | | <result column="excess_num" property="excessNum" /> |
| | | <result column="excess_to_process_days" property="excessToProcessDays" /> |
| | | <result column="filter_abnormally_used_days" property="filterAbnormallyUsedDays" /> |
| | | <result column="filter_wash_times" property="filterWashTimes" /> |
| | | <result column="granuli_sill" property="granuliSill" /> |
| | | <result column="health_code_color" property="healthCodeColor" /> |
| | | <result column="hydrocarbon_sill" property="hydrocarbonSill" /> |
| | | <result column="locale_id" property="localeId" /> |
| | | <result column="local_lat" property="localLat" /> |
| | | <result column="local_lng" property="localLng" /> |
| | | <result column="mn" property="mn" /> |
| | | <result column="name" property="name" /> |
| | | <result column="off_line_cause_by_shop_days" property="offLineCauseByShopDays" /> |
| | | <result column="owner" property="owner" /> |
| | | <result column="shop_close_days" property="shopCloseDays" /> |
| | | <result column="status" property="status" /> |
| | | <result column="status_desc" property="statusDesc" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, abnormal_off_line_days, abnormal_off_line_process_ratio, abnormal_off_line_to_process_days, addr, c_emissions, c_emissions_avg_online, c_emissions_max, c_emissions_max_date, c_granule, c_hydrocarbon, cuisine_name, customer_bl_no, customer_contact, customer_mobile, customer_name, detector_failure_days, emissions_sill, excess_num, excess_to_process_days, filter_abnormally_used_days, filter_wash_times, granuli_sill, health_code_color, hydrocarbon_sill, locale_id, local_lat, local_lng, mn, name, off_line_cause_by_shop_days, owner, shop_close_days, status, status_desc |
| | | </sql> |
| | | |
| | | </mapper> |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.mapper.smoke.OdsCustomerMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.ycl.entity.smoke.OdsCustomer"> |
| | | <id column="id" property="id" /> |
| | | <result column="pid" property="pid" /> |
| | | <result column="bl_no" property="blNo" /> |
| | | <result column="bl_name" property="blName" /> |
| | | <result column="org" property="org" /> |
| | | <result column="name" property="name" /> |
| | | <result column="contact" property="contact" /> |
| | | <result column="mobile" property="mobile" /> |
| | | <result column="telephone" property="telephone" /> |
| | | <result column="typ" property="typ" /> |
| | | <result column="creator" property="creator" /> |
| | | <result column="create_at" property="createAt" /> |
| | | <result column="status" property="status" /> |
| | | <result column="address" property="address" /> |
| | | <result column="logo" property="logo" /> |
| | | <result column="business_hour" property="businessHour" /> |
| | | <result column="maintainer_id" property="maintainerId" /> |
| | | <result column="area_ids" property="areaIdsString" /> |
| | | <result column="area_id_cascads" property="areaIdCascadsString" /> |
| | | <result column="areas" property="areasString" /> |
| | | <result column="desc1" property="desc" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, pid, bl_no, bl_name, org, name, contact, mobile, telephone, typ, creator, create_at, status, address, logo, business_hour, maintainer_id, area_ids, area_id_cascads, areas, desc1 |
| | | </sql> |
| | | |
| | | </mapper> |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.mapper.smoke.OdsDetectorDailyMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.ycl.entity.smoke.OdsDetectorDaily"> |
| | | <id column="id" property="id" /> |
| | | <result column="mn" property="mn" /> |
| | | <result column="owner" property="owner" /> |
| | | <result column="acquit_at" property="acquitAt" /> |
| | | <result column="acquit_date" property="acquitDate" /> |
| | | <result column="create_at" property="createAt" /> |
| | | <result column="c_emissions" property="cEmissions" /> |
| | | <result column="c_granule" property="cGranule" /> |
| | | <result column="c_hydrocarbon" property="cHydrocarbon" /> |
| | | <result column="e_missions" property="eMissions" /> |
| | | <result column="granule" property="granule" /> |
| | | <result column="hydrocarbon" property="hydrocarbon" /> |
| | | <result column="velocity" property="velocity" /> |
| | | <result column="temperature" property="temperature" /> |
| | | <result column="moisture" property="moisture" /> |
| | | <result column="red_pm25" property="redPm25" /> |
| | | <result column="red_pm10" property="redPm10" /> |
| | | <result column="red_emissions" property="redEmissions" /> |
| | | <result column="red_vocs" property="redVocs" /> |
| | | <result column="device_num" property="deviceNum" /> |
| | | <result column="status" property="status" /> |
| | | <result column="filter_fan_link_ratio" property="filterFanLinkRatio" /> |
| | | <result column="filter_abnormally_used" property="filterAbnormallyUsed" /> |
| | | <result column="c_emissions_exceed_standard" property="cEmissionsExceedStandard" /> |
| | | <result column="c_granule_exceed_standard" property="cGranuleExceedStandard" /> |
| | | <result column="c_hydrocarbon_exceed_standard" property="cHydrocarbonExceedStandard" /> |
| | | <result column="locale_id" property="localeId" /> |
| | | <result column="customer_id" property="customerId" /> |
| | | <result column="customer" property="customer" /> |
| | | <result column="locale_emissions_sill" property="localeEmissionsSill" /> |
| | | <result column="locale_granule_sill" property="localeGranuleSill" /> |
| | | <result column="locale_hydrocarbon_sill" property="localeHydrocarbonSill" /> |
| | | <result column="locale_name" property="localeName" /> |
| | | <result column="locale_addr" property="localeAddr" /> |
| | | <result column="abnormal_off_line" property="abnormalOffLine" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, mn, owner, acquit_at, acquit_date, create_at, c_emissions, c_granule, c_hydrocarbon, e_missions, granule, hydrocarbon, velocity, temperature, moisture, red_pm25, red_pm10, red_emissions, red_vocs, device_num, status, filter_fan_link_ratio, filter_abnormally_used, c_emissions_exceed_standard, c_granule_exceed_standard, c_hydrocarbon_exceed_standard, locale_id, customer_id, customer, locale_emissions_sill, locale_granule_sill, locale_hydrocarbon_sill, locale_name, locale_addr, abnormal_off_line |
| | | </sql> |
| | | |
| | | </mapper> |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.mapper.smoke.OdsInTimeMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.ycl.entity.smoke.OdsInTime"> |
| | | <id column="id" property="id" /> |
| | | <result column="string" property="string" /> |
| | | <result column="acquit_at" property="acquitAt" /> |
| | | <result column="last_at" property="lastAt" /> |
| | | <result column="c_emissions" property="cEmissions" /> |
| | | <result column="c_granule" property="cGranule" /> |
| | | <result column="c_hydrocarbon" property="cHydrocarbon" /> |
| | | <result column="emissions_conc" property="emissionsConc" /> |
| | | <result column="granule_conc" property="granuleConc" /> |
| | | <result column="hydrocarbon_conc" property="hydrocarbonConc" /> |
| | | <result column="fan_status" property="fanStatus" /> |
| | | <result column="filter_status" property="filterStatus" /> |
| | | <result column="typ" property="typ" /> |
| | | <result column="status" property="status" /> |
| | | <result column="velocity" property="velocity" /> |
| | | <result column="temperature" property="temperature" /> |
| | | <result column="moisture" property="moisture" /> |
| | | <result column="locale" property="locale" /> |
| | | <result column="lid" property="lid" /> |
| | | <result column="owner" property="owner" /> |
| | | <result column="addr" property="addr" /> |
| | | <result column="emissions_sill" property="emissionsSill" /> |
| | | <result column="granule_sill" property="granuleSill" /> |
| | | <result column="hydrocarbon_sill" property="hydrocarbonSill" /> |
| | | <result column="link_status" property="linkStatus" /> |
| | | <result column="customer_mobile" property="customerMobile" /> |
| | | <result column="locale_lng" property="localeLng" /> |
| | | <result column="localelat" property="localelat" /> |
| | | <result column="fan_current" property="fanCurrent" /> |
| | | <result column="pur_current" property="purCurrent" /> |
| | | <result column="online_status" property="onlineStatus" /> |
| | | <result column="status_of_record" property="statusOfRecord" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, string, acquit_at, last_at, c_emissions, c_granule, c_hydrocarbon, emissions_conc, granule_conc, hydrocarbon_conc, fan_status, filter_status, typ, status, velocity, temperature, moisture, locale, lid, owner, addr, emissions_sill, granule_sill, hydrocarbon_sill, link_status, customer_mobile, locale_lng, localelat, fan_current, pur_current, online_status, status_of_record |
| | | </sql> |
| | | |
| | | </mapper> |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.mapper.smoke.OdsLocaleMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.ycl.entity.smoke.OdsLocale"> |
| | | <id column="id" property="id" /> |
| | | <result column="n_name" property="nName" /> |
| | | <result column="owner" property="owner" /> |
| | | <result column="cuisine" property="cuisine" /> |
| | | <result column="customer_id" property="customerId" /> |
| | | <result column="fan_speed" property="fanSpeed" /> |
| | | <result column="fan_quantity" property="fanQuantity" /> |
| | | <result column="pipe_area" property="pipeArea" /> |
| | | <result column="stove_num" property="stoveNum" /> |
| | | <result column="offline_judge" property="offlineJudge" /> |
| | | <result column="fan_status" property="fanStatus" /> |
| | | <result column="filter_info" property="filterInfo" /> |
| | | <result column="filter_status" property="filterStatus" /> |
| | | <result column="samplings" property="samplings" /> |
| | | <result column="link_status" property="linkStatus" /> |
| | | <result column="emissions_sill" property="emissionsSill" /> |
| | | <result column="stove_area" property="stoveArea" /> |
| | | <result column="exhaust_time" property="exhaustTime" /> |
| | | <result column="remark" property="remark" /> |
| | | <result column="addr" property="addr" /> |
| | | <result column="area_id" property="areaId" /> |
| | | <result column="lng" property="lng" /> |
| | | <result column="lat" property="lat" /> |
| | | <result column="creator" property="creator" /> |
| | | <result column="create_at" property="createAt" /> |
| | | <result column="status" property="status" /> |
| | | <result column="granule_sill" property="granuleSill" /> |
| | | <result column="hydrocarbon_sill" property="hydrocarbonSill" /> |
| | | <result column="health_code_color" property="healthCodeColor" /> |
| | | <result column="mn_last" property="mnLast" /> |
| | | <result column="locale_pics" property="localePics" /> |
| | | <result column="mn_typ_last" property="mnTypLast" /> |
| | | <result column="fan_info" property="fanInfo" /> |
| | | <result column="power_supply_mode" property="powerSupplyMode" /> |
| | | <result column="link_ratio_sill" property="linkRatioSill" /> |
| | | <result column="maintainer_id" property="maintainerId" /> |
| | | <result column="health_code_x" property="healthCodeX" /> |
| | | <result column="health_code_value1" property="healthCodeValue1" /> |
| | | <result column="health_code_value2" property="healthCodeValue2" /> |
| | | <result column="health_code_value3" property="healthCodeValue3" /> |
| | | <result column="health_code_value4" property="healthCodeValue4" /> |
| | | <result column="health_code_value5" property="healthCodeValue5" /> |
| | | <result column="health_code_value6" property="healthCodeValue6" /> |
| | | <result column="abnormal_value7" property="abnormalValue7" /> |
| | | <result column="abnormal_value78" property="abnormalValue8" /> |
| | | <result column="abnormal_value79" property="abnormalValue9" /> |
| | | <result column="abnormal_value710" property="abnormalValue10" /> |
| | | <result column="ali_iot_device_name" property="aliIotDeviceName" /> |
| | | <result column="aliIot" property="aliIot" /> |
| | | <result column="created_at" property="createdAt" /> |
| | | <result column="updated_at" property="updatedAt" /> |
| | | <result column="health_code_value11" property="healthCodeValue11" /> |
| | | <result column="health_code_value12" property="healthCodeValue12" /> |
| | | <result column="send_mode" property="sendMode" /> |
| | | <result column="surpass_calc_method" property="surpassCalcMethod" /> |
| | | <result column="fan_standard_current" property="fanStandardCurrent" /> |
| | | <result column="filter_standard_current" property="filterStandardCurrent" /> |
| | | <result column="status_of_record" property="statusOfRecord" /> |
| | | <result column="remark_of_record" property="remarkOfRecord" /> |
| | | <result column="cause" property="cause" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, n_name, owner, cuisine, customer_id, customer, fan_speed, fan_quantity, pipe_area, stove_num, offline_judge, fan_status, filter_info, filter_status, samplings, link_status, emissions_sill, stove_area, exhaust_time, remark, addr, area_id, lng, lat, creator, create_at, status, granule_sill, hydrocarbon_sill, health_code_color, mn_last, locale_pics, mn_typ_last, fan_info, power_supply_mode, link_ratio_sill, maintainer_id, health_code_x, health_code_value1, health_code_value2, health_code_value3, health_code_value4, health_code_value5, health_code_valuee6, abnormal_value7, abnormal_value78, abnormal_value79, abnormal_value710, aliIot_device_name, aliIot, created_at, updated_at, health_code_value11, health_code_value12, send_mode, surpass_calc_method, fan_standardurrent, filter_standard_current, status_of_record, remark_of_record, cause |
| | | </sql> |
| | | |
| | | </mapper> |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ycl.mapper.smoke.OdsTenMinDataMapper"> |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.ycl.entity.smoke.OdsTenMinData"> |
| | | <id column="id" property="id" /> |
| | | <result column="mn" property="mn" /> |
| | | <result column="acquit_at" property="acquitAt" /> |
| | | <result column="counter" property="counter" /> |
| | | <result column="create_at" property="createAt" /> |
| | | <result column="emissions_conc" property="emissionsConc" /> |
| | | <result column="granule_conc" property="granuleConc" /> |
| | | <result column="hydrocarbon_conc" property="hydrocarbonConc" /> |
| | | <result column="velocity" property="velocity" /> |
| | | <result column="temperature" property="temperature" /> |
| | | <result column="moisture" property="moisture" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, mn, acquit_at, counter, create_at, emissions_conc, granule_conc, hydrocarbon_conc, velocity, temperature, moisture |
| | | </sql> |
| | | |
| | | </mapper> |