/*
|
* Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
|
*
|
* Redistribution and use in source and binary forms, with or without
|
* modification, are permitted provided that the following conditions are met:
|
*
|
* Redistributions of source code must retain the above copyright notice,
|
* this list of conditions and the following disclaimer.
|
* Redistributions in binary form must reproduce the above copyright
|
* notice, this list of conditions and the following disclaimer in the
|
* documentation and/or other materials provided with the distribution.
|
* Neither the name of the dreamlu.net developer nor the names of its
|
* contributors may be used to endorse or promote products derived from
|
* this software without specific prior written permission.
|
* Author: Chill 庄骞 (smallchill@163.com)
|
*/
|
package org.sxkj.fw.device.mapper;
|
|
import com.baomidou.mybatisplus.core.conditions.Wrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import org.apache.ibatis.annotations.Param;
|
import org.sxkj.fw.cockpit.vo.AlarmStatisticsVO;
|
import org.sxkj.fw.device.vo.DeviceTypeStatisticsVO;
|
import org.sxkj.fw.cockpit.vo.DeviceStatisticsVO;
|
import org.sxkj.fw.device.dto.FwDeviceDTO;
|
import org.sxkj.fw.device.dto.FwDevicePolygonQueryDTO;
|
import org.sxkj.fw.device.entity.FwDeviceEntity;
|
import org.sxkj.fw.device.excel.FwDeviceExcel;
|
import org.sxkj.fw.device.vo.CockpitFwDeviceVO;
|
import org.sxkj.fw.device.vo.FwDeviceVO;
|
|
import java.util.List;
|
|
/**
|
* 设备表 Mapper 接口
|
*
|
* @author aix
|
* @since 2026-01-08
|
*/
|
public interface FwDeviceMapper extends BaseMapper<FwDeviceEntity> {
|
|
/**
|
* 自定义分页
|
*
|
* @param page
|
* @param fwDevice
|
* @return
|
*/
|
List<FwDeviceEntity> selectFwDevicePage(IPage page, FwDeviceDTO fwDevice);
|
|
/**
|
* 列表查询
|
*
|
* @param isAreaSelect
|
* @param areaId
|
* @param areaIds
|
* @return
|
*/
|
List<FwDeviceEntity> selectFwDeviceList(@Param("isAreaSelect") Integer isAreaSelect, @Param("areaId") Long areaId,
|
@Param("areaIds") List<Long> areaIds, @Param("status") Integer status, @Param("isTrack") Integer isTrack);
|
|
/**
|
* 根据多边形查询设备列表
|
*
|
* @param query 查询条件
|
* @return 设备列表
|
*/
|
List<FwDeviceEntity> selectFwDeviceListByPolygons(@Param("query") FwDevicePolygonQueryDTO query);
|
|
|
/**
|
* 获取导出数据
|
* @param queryWrapper
|
* @return
|
*/
|
List<FwDeviceExcel> exportFwDevice(@Param("ew") Wrapper<FwDeviceEntity> queryWrapper);
|
|
/**
|
* 设备统计 - 驾驶舱使用
|
* @return 统计数据
|
*/
|
List<DeviceStatisticsVO> statisticalDeviceType(String regionCode, String currentDeptId);
|
|
/**
|
* 设备统计 - 按类型统计
|
* @return 统计数据
|
*/
|
List<DeviceTypeStatisticsVO> getDeviceTypeStatistics(List<Long> deptList,String currentDeptId);
|
|
/**
|
* 设备出库去向统计
|
* @return 统计数据
|
*/
|
List<DeviceStatisticsVO> getDeviceOutStatistics(String effectiveRangeKmIsNotNull,List<Long> deptList,String currentDeptId);
|
|
/**
|
* 设备生产厂商统计
|
* @return 统计数据
|
*/
|
List<DeviceStatisticsVO> getDeviceManufacturerStatistics(List<Long> deptList, String currentDeptId);
|
|
/**
|
* 告警统计
|
* @return
|
*/
|
AlarmStatisticsVO statisticalDeviceAtt(String regionCode, String currentDeptId);
|
|
/**
|
* 获取设备列表
|
* @param page
|
* @param fwDevice
|
* @return
|
*/
|
List<CockpitFwDeviceVO> selectCockpitDevicePage(IPage<CockpitFwDeviceVO> page, FwDeviceDTO fwDevice);
|
|
/**
|
* 按设备ID更新出入库状态
|
*
|
* @param deviceId 设备ID
|
* @param trackStatus 出入库状态
|
* @return 影响行数
|
*/
|
int updateTrackStatusByDeviceId(@Param("deviceId") Long deviceId, @Param("trackStatus") Integer trackStatus, @Param("outTarget") String outTarget, @Param("outTargetCode") String outTargetCode);
|
|
/**
|
* 查询非本部门区域的设备
|
* @param regionName 部门名称
|
* @param currentDeptId 当前用户部门ID
|
* @return 设备列表
|
*/
|
List<FwDeviceVO> selectNonDeptAreaDevices(@Param("regionName") String regionName, @Param("currentDeptId") String currentDeptId);
|
|
/**
|
*
|
* @param fwDeviceDTO
|
* @return
|
*/
|
List<DeviceStatisticsVO> getDeviceStatistics(FwDeviceDTO fwDeviceDTO);
|
}
|
