新增应急空间统计

zrj

2024-10-30 f041358716340c6a8f48933a33acab5abea9db2a

新增应急空间统计

 src/main/java/org/springblade/modules/yw/controller/EmergencySpaceController.java

@@ -117,4 +117,16 @@
        String data = emergencySpaceService.importEmergencySpace(ExcelUtil.read(file, EmergencySpaceExcel.class),isCovered == 1);
        return R.data(200, data, data);
    }

    /**
     * 获取应急空间统计数据
     * @param emergencySpace
     * @return
     */
    @GetMapping("getStatisticData")
    @ApiOperationSupport(order = 9)
    @ApiOperation(value = "获取应急空间统计数据", notes = "")
    public R getStatisticData(EmergencySpaceVO emergencySpace) {
        return R.data(emergencySpaceService.getStatisticData(emergencySpace));
    }
}

 src/main/java/org/springblade/modules/yw/mapper/EmergencySpaceMapper.java

@@ -6,6 +6,7 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
import java.util.Map;

/**
 * 应急空间表 Mapper 接口
@@ -24,4 +25,10 @@
     */
    List<EmergencySpaceVO> selectEmergencySpacePage(IPage page,@Param("emergencySpace") EmergencySpaceVO emergencySpace);

    /**
     * 获取应急空间统计数据
     * @param emergencySpace
     * @return
     */
    List<Map<String, Object>> getStatisticData(@Param("emergencySpace") EmergencySpaceVO emergencySpace);
}

 src/main/java/org/springblade/modules/yw/mapper/EmergencySpaceMapper.xml

@@ -21,8 +21,30 @@
        <result column="is_deleted" property="isDeleted"/>
    </resultMap>

    <!--自定义分页查询-->
    <select id="selectEmergencySpacePage" resultMap="emergencySpaceResultMap">
        select * from yw_emergency_space where is_deleted = 0
    </select>

    <!--获取应急空间统计数据-->
    <select id="getStatisticData" resultType="java.util.Map">
        SELECT
            case when type=1 then '应急池'
            when type =2 then '阀门'
            when type =3 then '公共管网'
            when type =4 then '污水提升泵站'
            when type =5 then '水库'
            when type =6 then '应急泵'
            when type =7 then '消防沙'
            end as type,
            count(*) as num
        FROM
            yw_emergency_space
        WHERE
            is_deleted = 0
            AND type IS NOT NULL
            AND firm_id IS NOT NULL
            GROUP BY type
    </select>

</mapper>

 src/main/java/org/springblade/modules/yw/service/IEmergencySpaceService.java

@@ -7,6 +7,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;

import java.util.List;
import java.util.Map;

/**
 * 应急空间表 服务类
@@ -31,4 +32,11 @@
     * @return
     */
    String importEmergencySpace(List<EmergencySpaceExcel> data, boolean isCovered);

    /**
     * 获取应急空间统计数据
     * @param emergencySpace
     * @return
     */
    List<Map<String,Object>> getStatisticData(EmergencySpaceVO emergencySpace);
}

 src/main/java/org/springblade/modules/yw/service/impl/EmergencySpaceServiceImpl.java

@@ -16,6 +16,7 @@
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
import java.util.Map;
import java.util.Objects;

/**
@@ -111,4 +112,16 @@
            emergencySpaceEntity.setFirmId(firmInfo.getId());
        }
    }

    /**
     * 获取应急空间统计数据
     * @param emergencySpace
     * @return
     */
    @Override
    public List<Map<String,Object>> getStatisticData(EmergencySpaceVO emergencySpace) {
        // 按应急空间类型进行统计
        List<Map<String,Object>> list = baseMapper.getStatisticData(emergencySpace);
        return list;
    }
}