| | |
| | | private Long id; |
| | | |
| | | /** |
| | | * 所属灯杆 |
| | | */ |
| | | private String belongTo; |
| | | |
| | | /** |
| | | * 大气设备状态:在线:1/离线:0 |
| | | */ |
| | | private Integer equipmentState; |
| | | |
| | | /** |
| | | * 接入时间 |
| | | */ |
| | | private LocalDateTime createTime; |
| | | |
| | | /** |
| | | * 所属人 |
| | | */ |
| | | private Long userId; |
| | | |
| | | /** |
| | | * 灯杆ID |
| | | */ |
| | | private String lightPoleId; |
| | | |
| | | /** |
| | | * MAC地址 |
| | |
| | | private Long id; |
| | | //水质设备编码 |
| | | private String waterQualityEquipmentCode; |
| | | //所属灯杆 |
| | | private String belongTo; |
| | | //水质酸碱度pH |
| | | private String waterQualityPh; |
| | | //水质溶解度DO(mg/L) |
| | |
| | | package com.sandu.ximon.dao.mapper; |
| | | |
| | | import com.sandu.ximon.dao.bo.AirDataBo; |
| | | import com.sandu.ximon.dao.domain.AirData; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.sandu.ximon.dao.domain.Monitor; |
| | |
| | | public interface AirDataMapper extends BaseMapper<AirData> { |
| | | List<String> listAirEquipmentMAC(); |
| | | |
| | | List<AirDataBo> listAirData(); |
| | | |
| | | List<AirDataBo> listAirDataByKeyword(String keyword); |
| | | |
| | | } |
| | | |
| | | |
| | |
| | | package com.sandu.ximon.dao.mapper; |
| | | |
| | | import com.sandu.ximon.dao.bo.AirEquipmentBo; |
| | | import com.sandu.ximon.dao.domain.AirEquipment; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * @Entity com.sandu.ximon.dao.domain.AirEquipment |
| | | */ |
| | | @Mapper |
| | | public interface AirEquipmentMapper extends BaseMapper<AirEquipment> { |
| | | List<AirEquipmentBo> listAirEquipment(); |
| | | |
| | | List<AirEquipmentBo> listAirEquipmentByKeyword(String keyword); |
| | | } |
| | | |
| | | |
| | |
| | | package com.sandu.ximon.dao.mapper; |
| | | |
| | | import com.sandu.common.domain.BaseMapper; |
| | | import com.sandu.ximon.dao.bo.WaterQualityDataBo; |
| | | import com.sandu.ximon.dao.domain.WaterQualityData; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | |
| | | |
| | | @Mapper |
| | | public interface WaterQualityDataMapper extends BaseMapper<WaterQualityData> { |
| | | List<WaterQualityData> listWaterQualityDataByKeyword(String keyword); |
| | | List<WaterQualityData> listWaterQualityData(); |
| | | List<WaterQualityDataBo> listWaterQualityDataByKeyword(String keyword); |
| | | |
| | | List<WaterQualityDataBo> listWaterQualityData(); |
| | | |
| | | } |
| | |
| | | package com.sandu.ximon.dao.mapper; |
| | | |
| | | import com.sandu.common.domain.BaseMapper; |
| | | import com.sandu.ximon.dao.bo.WaterQualityEquipmentBo; |
| | | import com.sandu.ximon.dao.domain.WaterQualityEquipment; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | |
| | | |
| | | @Mapper |
| | | public interface WaterQualityEquipmentMapper extends BaseMapper<WaterQualityEquipment> { |
| | | List<WaterQualityEquipment> listWaterQualityEquipmentByKeyword(String keyword); |
| | | List<WaterQualityEquipmentBo> listWaterQualityEquipment(); |
| | | List<WaterQualityEquipmentBo> listWaterQualityEquipmentByKeyword(String keyword); |
| | | } |
| | |
| | | air_data |
| | | </select> |
| | | |
| | | <select id="listAirData" resultType="com.sandu.ximon.dao.bo.AirDataBo"> |
| | | SELECT |
| | | t1.*, t2.pole_id, |
| | | t3.pole_name |
| | | FROM |
| | | air_data t1 |
| | | JOIN ( |
| | | SELECT |
| | | MAX(t1.id) a1 |
| | | FROM |
| | | air_data t1 |
| | | LEFT JOIN pole_binding t2 ON t1.device_mac = t2.device_code |
| | | AND t2.device_type = 3 |
| | | LEFT JOIN pole t3 ON t3.id = t2.pole_id |
| | | GROUP BY |
| | | t1.device_mac |
| | | LIMIT 0, |
| | | 10 |
| | | ) t ON t.a1 = t1.id |
| | | LEFT JOIN pole_binding t2 ON t1.device_mac = t2.device_code |
| | | AND t2.device_type = 3 |
| | | LEFT JOIN pole t3 ON t3.id = t2.pole_id |
| | | </select> |
| | | |
| | | <select id="listAirDataByKeyword" resultType="com.sandu.ximon.dao.bo.AirDataBo"> |
| | | SELECT |
| | | t1.*, t2.pole_id, |
| | | t3.pole_name |
| | | FROM |
| | | air_data t1 |
| | | JOIN ( |
| | | SELECT |
| | | MAX(t1.id) a1 |
| | | FROM |
| | | air_data t1 |
| | | LEFT JOIN pole_binding t2 ON t1.device_mac = t2.device_code |
| | | AND t2.device_type = 3 |
| | | LEFT JOIN pole t3 ON t3.id = t2.pole_id |
| | | WHERE |
| | | t3.pole_name LIKE CONCAT(CONCAT('%', #{keyword}), '%') |
| | | GROUP BY |
| | | t1.device_mac |
| | | LIMIT 0, |
| | | 10 |
| | | ) t ON t.a1 = t1.id |
| | | LEFT JOIN pole_binding t2 ON t1.device_mac = t2.device_code |
| | | AND t2.device_type = 3 |
| | | LEFT JOIN pole t3 ON t3.id = t2.pole_id |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | |
| | | <resultMap id="BaseResultMap" type="com.sandu.ximon.dao.domain.AirEquipment"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="belongTo" column="belong_to" jdbcType="VARCHAR"/> |
| | | <result property="equipmentState" column="equipment_state" jdbcType="INTEGER"/> |
| | | <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/> |
| | | <result property="userId" column="user_id" jdbcType="BIGINT"/> |
| | | <result property="lightPoleId" column="light_pole_id" jdbcType="VARCHAR"/> |
| | | <result property="mac" column="mac" jdbcType="VARCHAR"/> |
| | | </resultMap> |
| | | |
| | |
| | | create_time,user_id,light_pole_id, |
| | | mac |
| | | </sql> |
| | | |
| | | <select id="listAirEquipment" resultType="com.sandu.ximon.dao.bo.AirEquipmentBo"> |
| | | SELECT |
| | | t1.*, t2.pole_id, |
| | | t3.pole_name |
| | | FROM |
| | | air_equipment t1 |
| | | LEFT JOIN pole_binding t2 ON t1.mac = t2.device_code |
| | | AND t2.device_type = 4 |
| | | LEFT JOIN pole t3 ON t3.id = t2.pole_id |
| | | ORDER BY |
| | | t1.id DESC |
| | | </select> |
| | | <select id="listAirEquipmentByKeyword" resultType="com.sandu.ximon.dao.bo.AirEquipmentBo"> |
| | | SELECT |
| | | t1.*, t2.pole_id, |
| | | t3.pole_name |
| | | FROM |
| | | air_equipment t1 |
| | | LEFT JOIN pole_binding t2 ON t1.mac = t2.device_code |
| | | AND t2.device_type = 4 |
| | | LEFT JOIN pole t3 ON t3.id = t2.pole_id |
| | | WHERE |
| | | t3.pole_name LIKE CONCAT(CONCAT('%', #{keyword}), '%') |
| | | ORDER BY |
| | | t1.id DESC |
| | | |
| | | </select> |
| | | </mapper> |
| | |
| | | <resultMap id="BaseResultMap" type="com.sandu.ximon.dao.domain.WaterQualityData"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <result property="waterQualityEquipmentCode" column="water_quality_equipment_code" jdbcType="VARCHAR"/> |
| | | <result property="belongTo" column="belong_to" jdbcType="VARCHAR"/> |
| | | <result property="waterQualityPh" column="water_quality_ph" jdbcType="VARCHAR"/> |
| | | <result property="waterQualityDo" column="water_quality_do" jdbcType="VARCHAR"/> |
| | | <result property="waterQualityEc" column="water_quality_ec" jdbcType="VARCHAR"/> |
| | |
| | | <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/> |
| | | <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/> |
| | | </resultMap> |
| | | <select id="listWaterQualityDataByKeyword" resultType="com.sandu.ximon.dao.domain.WaterQualityData" |
| | | <select id="listWaterQualityDataByKeyword" resultType="com.sandu.ximon.dao.bo.WaterQualityDataBo" |
| | | parameterType="java.lang.String"> |
| | | SELECT |
| | | t1.*, t2.pole_id, |
| | |
| | | LEFT JOIN pole t3 ON t3.id = t2.pole_id |
| | | </select> |
| | | |
| | | <select id="listWaterQualityData" resultType="com.sandu.ximon.dao.domain.WaterQualityData" |
| | | <select id="listWaterQualityData" resultType="com.sandu.ximon.dao.bo.WaterQualityDataBo" |
| | | parameterType="java.lang.String"> |
| | | SELECT |
| | | t1.*, t2.pole_id, |
| | |
| | | water_quality_data t1 |
| | | JOIN ( |
| | | SELECT |
| | | MAX(t1.id) a1, |
| | | t1.water_quality_ph, |
| | | t2.pole_id, |
| | | t3.pole_name |
| | | MAX(t1.id) a1 |
| | | FROM |
| | | water_quality_data t1 |
| | | LEFT JOIN pole_binding t2 ON t1.water_quality_equipment_code = t2.device_code |
| | |
| | | |
| | | <resultMap id="BaseResultMap" type="com.sandu.ximon.dao.domain.WaterQualityEquipment"> |
| | | <id property="id" column="id" jdbcType="BIGINT"/> |
| | | <!-- <result property="belongTo" column="belong_to" jdbcType="VARCHAR"/>--> |
| | | <!-- <result property="belongTo" column="belong_to" jdbcType="VARCHAR"/>--> |
| | | <result property="waterQualityEquipmentCode" column="water_quality_equipment_code" jdbcType="VARCHAR"/> |
| | | <result property="equipmentState" column="equipment_state" jdbcType="INTEGER"/> |
| | | <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/> |
| | | </resultMap> |
| | | |
| | | <select id="listWaterQualityEquipmentByKeyword" resultType="com.sandu.ximon.dao.domain.WaterQualityEquipment" |
| | | <select id="listWaterQualityEquipmentByKeyword" resultType="com.sandu.ximon.dao.bo.WaterQualityEquipmentBo" |
| | | parameterType="java.lang.String"> |
| | | SELECT |
| | | t1.*, t2.pole_id, |
| | |
| | | ORDER BY |
| | | t1.id DESC |
| | | </select> |
| | | <select id="listWaterQualityEquipment" resultType="com.sandu.ximon.dao.bo.WaterQualityEquipmentBo"> |
| | | SELECT |
| | | t1.*, t2.pole_id, |
| | | t3.pole_name |
| | | FROM |
| | | water_quality_equipment t1 |
| | | LEFT JOIN pole_binding t2 ON t1.water_quality_equipment_code = t2.device_code |
| | | AND t2.device_type = 4 |
| | | LEFT JOIN pole t3 ON t3.id = t2.pole_id |
| | | ORDER BY |
| | | t1.id DESC |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | |
| | | import com.sandu.common.domain.ResponseVO; |
| | | import com.sandu.common.util.ResponseUtil; |
| | | import com.sandu.ximon.dao.bo.AirDataBo; |
| | | import com.sandu.ximon.admin.service.AirDataService; |
| | | import com.sandu.ximon.dao.domain.AirData; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | |
| | | |
| | | @GetMapping |
| | | public ResponseVO<Object> listAirData() { |
| | | List<AirData> list = airDataService.listAirData(); |
| | | List<AirDataBo> list = airDataService.listAirData(); |
| | | return ResponseUtil.successPage(list); |
| | | } |
| | | |
| | | /** |
| | | * 查询大气数据模糊查询 |
| | | * |
| | | * @param keyword 关键字 |
| | | * @return |
| | | */ |
| | | @GetMapping("/listAirDataByKeyword/{keyword}") |
| | | public ResponseVO<Object> listAirDataByKeyword(@PathVariable String keyword) { |
| | | List<AirDataBo> list = airDataService.listAirDataByKeyword(keyword); |
| | | return ResponseUtil.successPage(list); |
| | | } |
| | | |
| | | /** |
| | | * 查询大气设备MAC地址 |
| | | * |
| | | * @return |
| | | */ |
| | | @GetMapping("/listAirEquipmentMAC") |
| | |
| | | import com.sandu.common.domain.ResponseVO; |
| | | import com.sandu.common.util.ResponseUtil; |
| | | import com.sandu.ximon.admin.service.AirEquipmentService; |
| | | import com.sandu.ximon.dao.bo.AirEquipmentBo; |
| | | import com.sandu.ximon.dao.domain.AirEquipment; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springframework.web.bind.annotation.*; |
| | |
| | | |
| | | @GetMapping |
| | | public ResponseVO<Object> listAirEquipment() { |
| | | List<AirEquipment> list = airEquipmentService.listAirEquipment(); |
| | | List<AirEquipmentBo> list = airEquipmentService.listAirEquipment(); |
| | | return ResponseUtil.successPage(list); |
| | | } |
| | | |
| | |
| | | */ |
| | | @GetMapping("/listAirEquipmentByKeyword/{keyword}") |
| | | public ResponseVO<Object> listAirEquipmentByKeyword(@PathVariable String keyword) { |
| | | List<AirEquipment> list = airEquipmentService.listAirEquipmentByKeyword(keyword); |
| | | List<AirEquipmentBo> list = airEquipmentService.listAirEquipmentByKeyword(keyword); |
| | | return ResponseUtil.successPage(list); |
| | | } |
| | | |
| | |
| | | import com.sandu.common.util.ResponseUtil; |
| | | import com.sandu.ximon.admin.dto.WaterQualityDataDto; |
| | | import com.sandu.ximon.admin.service.WaterQualityDataService; |
| | | import com.sandu.ximon.dao.bo.WaterQualityDataBo; |
| | | import com.sandu.ximon.dao.domain.WaterQualityData; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springframework.web.bind.annotation.*; |
| | |
| | | |
| | | @GetMapping |
| | | public ResponseVO<Object> listWaterQualityData() { |
| | | List<WaterQualityData> list = waterQualityDataService.listWaterQualityData(); |
| | | List<WaterQualityDataBo> list = waterQualityDataService.listWaterQualityData(); |
| | | return ResponseUtil.success(list); |
| | | } |
| | | |
| | |
| | | */ |
| | | @GetMapping("/listWaterQualityDataByKeyword/{keyword}") |
| | | public ResponseVO<Object> listWaterQualityDataByKeyword(@PathVariable String keyword) { |
| | | List<WaterQualityData> list = waterQualityDataService.listWaterQualityDataByKeyword(keyword); |
| | | List<WaterQualityDataBo> list = waterQualityDataService.listWaterQualityDataByKeyword(keyword); |
| | | return ResponseUtil.success(list); |
| | | } |
| | | |
| | |
| | | import com.sandu.common.util.ResponseUtil; |
| | | import com.sandu.ximon.admin.param.WaterQualityEquipmentParam; |
| | | import com.sandu.ximon.admin.service.WaterQualityEquipmentService; |
| | | import com.sandu.ximon.dao.bo.WaterQualityEquipmentBo; |
| | | import com.sandu.ximon.dao.domain.WaterQualityEquipment; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springframework.web.bind.annotation.*; |
| | |
| | | |
| | | @GetMapping |
| | | public ResponseVO<Object> listWaterQualityEquipment() { |
| | | List<WaterQualityEquipment> list = waterQualityEquipmentService.listWaterQualityEquipment(); |
| | | List<WaterQualityEquipmentBo> list = waterQualityEquipmentService.listWaterQualityEquipment(); |
| | | return ResponseUtil.success(list); |
| | | } |
| | | |
| | |
| | | */ |
| | | @GetMapping("/listWaterQualityEquipmentByKeyword/{keyword}") |
| | | public ResponseVO<Object> listWaterQualityEquipmentByKeyword(@PathVariable String keyword) { |
| | | List<WaterQualityEquipment> list = waterQualityEquipmentService.listWaterQualityEquipmentByKeyword(keyword); |
| | | List<WaterQualityEquipmentBo> list = waterQualityEquipmentService.listWaterQualityEquipmentByKeyword(keyword); |
| | | return ResponseUtil.success(list); |
| | | } |
| | | |
| | |
| | | public void process(String productKey, String deviceName, CommonFrame frame) { |
| | | String functionCode = frame.getPayload().substring(2, 4); |
| | | if (A5AtmosphereReportEnum.HeartBeat_Data.getCode().equals(functionCode)) { |
| | | log.info("心跳相应"); |
| | | log.info("心跳相应——大气数据"); |
| | | A5AtmosphereHeartbeatReportInnerFrame heartbeatReportInnerFrame = new A5AtmosphereHeartbeatReportInnerFrame().transformFrame(frame.getPayload()); |
| | | log.info(heartbeatReportInnerFrame.toString()); |
| | | |
| | |
| | | |
| | | import com.sandu.ximon.admin.service.WaterQualityDataService; |
| | | import com.sandu.ximon.admin.service.WaterQualityEquipmentService; |
| | | import com.sandu.ximon.dao.bo.WaterQualityEquipmentBo; |
| | | import com.sandu.ximon.dao.domain.WaterQualityEquipment; |
| | | import lombok.AllArgsConstructor; |
| | | import lombok.extern.slf4j.Slf4j; |
| | |
| | | |
| | | @Scheduled(cron = "0 0 0/1 * * ?") |
| | | public void UserSubjectRefund() { |
| | | List<WaterQualityEquipment> waterQualityEquipmentList = waterQualityEquipmentService.listWaterQualityEquipment(); |
| | | List<WaterQualityEquipmentBo> waterQualityEquipmentList = waterQualityEquipmentService.listWaterQualityEquipment(); |
| | | for (WaterQualityEquipment waterQualityEquipment : waterQualityEquipmentList) { |
| | | waterQualityDataService.getWaterQualityDataInfo(waterQualityEquipment.getWaterQualityEquipmentCode()); |
| | | } |
| | |
| | | package com.sandu.ximon.admin.service; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.sandu.common.execption.BusinessException; |
| | | |
| | | import com.sandu.common.service.impl.BaseServiceImpl; |
| | | import com.sandu.ximon.dao.bo.AirDataBo; |
| | | import com.sandu.ximon.admin.manager.iot.frame.inner.report.A5AtmosphereHeartbeatReportInnerFrame; |
| | | import com.sandu.ximon.dao.domain.AirData; |
| | | import com.sandu.ximon.dao.domain.AirEquipment; |
| | | import com.sandu.ximon.dao.mapper.AirDataMapper; |
| | | import lombok.AllArgsConstructor; |
| | | import org.springframework.beans.BeanUtils; |
| | |
| | | @AllArgsConstructor |
| | | public class AirDataService extends BaseServiceImpl<AirDataMapper, AirData> { |
| | | private final AirDataMapper airDataMapper; |
| | | private final AirEquipmentService airEquipmentService; |
| | | |
| | | /** |
| | | * 保存上报大气心跳数据 |
| | |
| | | BeanUtils.copyProperties(heartBeatDataPackage, airData); |
| | | airData.setDeviceMac(deviceName); |
| | | |
| | | //将设备信息添加到大气设备表 |
| | | AirEquipment airEquipment = new AirEquipment(); |
| | | airEquipment.setId(airData.getId()); |
| | | airEquipment.setMac(airData.getDeviceMac()); |
| | | airEquipment.setCreateTime(airData.getCreateTime()); |
| | | airEquipmentService.addAirEquipment(airEquipment); |
| | | |
| | | return save(airData); |
| | | } |
| | | |
| | | /** |
| | | * 查询全部大气设备 |
| | | * 查询全部大气数据 |
| | | */ |
| | | public List<AirData> listAirData() { |
| | | LambdaQueryWrapper<AirData> wrapper = Wrappers.lambdaQuery(AirData.class); |
| | | List<AirData> list = list(wrapper); |
| | | public List<AirDataBo> listAirData() { |
| | | return airDataMapper.listAirData(); |
| | | } |
| | | |
| | | return list; |
| | | /** |
| | | * 查询大气数据(模糊查询) |
| | | */ |
| | | public List<AirDataBo> listAirDataByKeyword(String keyword) { |
| | | if (keyword == null || keyword.trim().length() == 0) { |
| | | return listAirData(); |
| | | } else { |
| | | return airDataMapper.listAirDataByKeyword(keyword); |
| | | } |
| | | } |
| | | |
| | | /** |
| | |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.sandu.common.execption.BusinessException; |
| | | import com.sandu.common.service.impl.BaseServiceImpl; |
| | | import com.sandu.ximon.dao.bo.AirEquipmentBo; |
| | | import com.sandu.ximon.dao.domain.AirData; |
| | | import com.sandu.ximon.dao.domain.AirEquipment; |
| | | import com.sandu.ximon.dao.domain.Monitor; |
| | |
| | | @AllArgsConstructor |
| | | public class AirEquipmentService extends BaseServiceImpl<AirEquipmentMapper, AirEquipment> { |
| | | |
| | | private final AirEquipmentMapper airEquipmentMapper; |
| | | |
| | | /** |
| | | * 查询全部大气设备数据 |
| | | */ |
| | | public List<AirEquipment> listAirEquipment() { |
| | | LambdaQueryWrapper<AirEquipment> wrapper = Wrappers.lambdaQuery(AirEquipment.class); |
| | | List<AirEquipment> list = list(wrapper); |
| | | |
| | | return list; |
| | | public List<AirEquipmentBo> listAirEquipment() { |
| | | return airEquipmentMapper.listAirEquipment(); |
| | | } |
| | | |
| | | /** |
| | | * 模糊查询 |
| | | */ |
| | | public List<AirEquipment> listAirEquipmentByKeyword(String keyword) { |
| | | |
| | | LambdaQueryWrapper<AirEquipment> wrapper = Wrappers.lambdaQuery(AirEquipment.class); |
| | | if(keyword != null){ |
| | | wrapper.like(AirEquipment::getBelongTo,keyword); |
| | | public List<AirEquipmentBo> listAirEquipmentByKeyword(String keyword) { |
| | | if (keyword == null || keyword.trim().length() == 0) { |
| | | return listAirEquipment(); |
| | | } else { |
| | | return airEquipmentMapper.listAirEquipmentByKeyword(keyword); |
| | | } |
| | | List<AirEquipment> airDataList = list(wrapper); |
| | | return airDataList; |
| | | |
| | | } |
| | | |
| | | /** |
| | | * 添加大气设备数据 |
| | | * |
| | | * @return |
| | | */ |
| | | public void addAirEquipment(AirEquipment airEquipment) { |
| | | AirEquipment one = getOne(Wrappers.lambdaQuery(AirEquipment.class).eq(AirEquipment::getMac, airEquipment.getMac())); |
| | | if (one == null) { |
| | | save(airEquipment); |
| | | } |
| | | } |
| | | |
| | | /** |
| | |
| | | import com.sandu.common.execption.BusinessException; |
| | | import com.sandu.common.service.impl.BaseServiceImpl; |
| | | import com.sandu.ximon.admin.dto.WaterQualityDataDto; |
| | | import com.sandu.ximon.dao.bo.WaterQualityDataBo; |
| | | import com.sandu.ximon.dao.domain.WaterQualityData; |
| | | import com.sandu.ximon.dao.mapper.WaterQualityDataMapper; |
| | | import com.sandu.ximon.dao.mapper.WaterQualityEquipmentMapper; |
| | |
| | | /** |
| | | * 查询全部水质设备数据 |
| | | */ |
| | | public List<WaterQualityData> listWaterQualityData() { |
| | | public List<WaterQualityDataBo> listWaterQualityData() { |
| | | return waterQualityDataMapper.listWaterQualityData(); |
| | | } |
| | | |
| | | /** |
| | | * 模糊查询 |
| | | */ |
| | | public List<WaterQualityData> listWaterQualityDataByKeyword(String keyword) { |
| | | public List<WaterQualityDataBo> listWaterQualityDataByKeyword(String keyword) { |
| | | if (keyword == null || keyword.trim().length() == 0) { |
| | | return listWaterQualityData(); |
| | | } else { |
| | | return waterQualityDataMapper.listWaterQualityDataByKeyword(keyword); |
| | | } |
| | | |
| | | // LambdaQueryWrapper<WaterQualityData> wrapper = Wrappers.lambdaQuery(WaterQualityData.class); |
| | | // if (keyword != null) { |
| | | // wrapper.like(WaterQualityData::getBelongTo, keyword); |
| | | // } |
| | | // List<WaterQualityData> waterQualityDataList = list(wrapper); |
| | | // return waterQualityDataList; |
| | | } |
| | | |
| | | /** |
| | |
| | | import com.sandu.common.execption.BusinessException; |
| | | import com.sandu.common.service.impl.BaseServiceImpl; |
| | | import com.sandu.ximon.admin.param.WaterQualityEquipmentParam; |
| | | import com.sandu.ximon.dao.bo.WaterQualityEquipmentBo; |
| | | import com.sandu.ximon.dao.domain.AirEquipment; |
| | | import com.sandu.ximon.dao.domain.Monitor; |
| | | import com.sandu.ximon.dao.domain.WaterQualityEquipment; |
| | |
| | | public class WaterQualityEquipmentService extends BaseServiceImpl<WaterQualityEquipmentMapper, WaterQualityEquipment> { |
| | | private WaterQualityEquipmentMapper waterQualityEquipmentMapper; |
| | | private final PoleBindingService poleBindingService; |
| | | |
| | | /** |
| | | * 查询全部水质设备 |
| | | */ |
| | | public List<WaterQualityEquipment> listWaterQualityEquipment() { |
| | | LambdaQueryWrapper<WaterQualityEquipment> wrapper = Wrappers.lambdaQuery(WaterQualityEquipment.class); |
| | | List<WaterQualityEquipment> list = list(wrapper); |
| | | |
| | | return list; |
| | | public List<WaterQualityEquipmentBo> listWaterQualityEquipment() { |
| | | return waterQualityEquipmentMapper.listWaterQualityEquipment(); |
| | | } |
| | | |
| | | /** |
| | | * 模糊查询 |
| | | */ |
| | | public List<WaterQualityEquipment> listWaterQualityEquipmentByKeyword(String keyword) { |
| | | if(keyword == null || keyword.trim().length() == 0){ |
| | | public List<WaterQualityEquipmentBo> listWaterQualityEquipmentByKeyword(String keyword) { |
| | | if (keyword == null || keyword.trim().length() == 0) { |
| | | return listWaterQualityEquipment(); |
| | | |
| | | }else{ |
| | | } else { |
| | | return waterQualityEquipmentMapper.listWaterQualityEquipmentByKeyword(keyword); |
| | | } |
| | | |