fuliqi
2024-09-05 cd24a045bd9ee29505ddc9760d25f5d4037f4f0c
ycl-server/src/main/java/com/ycl/platform/mapper/YwPointMapper.java
@@ -3,8 +3,11 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ycl.platform.base.BaseSelect;
import com.ycl.platform.domain.entity.ReportAuditingRecord;
import com.ycl.platform.domain.entity.YwPoint;
import com.ycl.platform.domain.query.YwPointQuery;
import com.ycl.platform.domain.vo.CheckTagVO;
import com.ycl.platform.domain.vo.ReportAuditingRecordVO;
import com.ycl.platform.domain.vo.YwPointVO;
import com.ycl.platform.domain.excel.PointExport;
import org.apache.ibatis.annotations.Mapper;
@@ -40,7 +43,10 @@
    /**
     * 通过标签查重点点位或省厅点位或重点指挥图像
     */
    List<YwPoint> selectByTag(@Param("important")Boolean important, @Param("province")Boolean province, @Param("commandImage")Boolean commandImage);
    List<YwPoint> selectByTag(@Param("important")Boolean important,
                              @Param("province")Boolean province,
                              @Param("commandImage")Boolean commandImage,
                              @Param("deptTag") Boolean deptTag);
    /**
     * 导出数据
@@ -49,4 +55,62 @@
     * @return
     */
    List<PointExport> export(@Param("query") YwPointQuery query);
    void deleteAll();
    /**
     * 更新点位信息
     *
     * @param pointList
     */
    int updatePoint(List<YwPoint> pointList);
    /**
     * 统计某点位对应的未完成工单数量,理论上最大值为1个工单
     *
     * @param pointId
     * @return
     */
    YwPointVO countNotFinishedWorkOrderByPointId(@Param("pointId") Integer pointId);
    /**
     * 统计某点位对应的未完成工单数量,理论上最大值为1个工单
     *
     * @param serialNumber
     * @return
     */
    YwPointVO countNotFinishedWorkOrderByGb(@Param("serialNumber") String serialNumber);
    /**
     * 查询有部级标签的点位的国标码
     *
     * @param tagType 0 部级  1 重点  2 重点指挥图像
     * @return
     */
    List<String> getDeptPointGB(@Param("tagType") Integer tagType);
    /**
     * 点位下拉
     *
     * @param keyword
     * @param unitId
     * @return
     */
    List<YwPoint> select(@Param("keyword") String keyword, @Param("unitId") Integer unitId);
    /**
     * 获取最新一条报备结果
     * @param serialNumber
     * @param reportType
     * @return
     */
    ReportAuditingRecordVO getReportResult(@Param("serialNumber") String serialNumber, @Param("reportType") String reportType);
    /**
     * 通过国标获取标签信息
     *
     * @param gbList
     * @return
     */
    List<CheckTagVO> getTagsByGB(@Param("gbList") List<String> gbList);
}