package com.panzhihua.service_community.dao;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.panzhihua.common.model.vos.community.ComMngVillageTotalVO;
|
import com.panzhihua.common.model.vos.community.ComMngVillageVO;
|
import com.panzhihua.service_community.model.dos.ComMngVillageDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
|
/**
|
* @author: llming
|
* @description: 街道
|
**/
|
@Mapper
|
public interface ComActVillageDAO extends BaseMapper<ComMngVillageDO> {
|
|
@Select("select count(id) as houseTotal" +
|
",(select count(DISTINCT floor) from com_mng_population_house where village_id = #{villageId}) as floorTotal" +
|
",(select count(id) from com_mng_population where village_id = #{villageId}) as populationTotal" +
|
",(select count(id) from com_mng_car where area_id = #{villageId}) as carTotal" +
|
" from com_mng_population_house where village_id = #{villageId}")
|
ComMngVillageVO getStatisticsCount(@Param("villageId") Long villageId);
|
|
@Select("select count(village_id) as villageTotal" +
|
",(select count(village_id) from com_mng_village where community_id = #{communityId} and type = 1) as townTotal" +
|
",(select count(village_id) from com_mng_village where community_id = #{communityId} and type = 2) as countrysideTotal" +
|
" from com_mng_village where community_id = #{communityId}" )
|
ComMngVillageTotalVO getVillageStatisticsCount(@Param("communityId") Long communityId);
|
|
@Select("select village_id,alley,house_num,group_at,type,address,update_at from com_mng_village where village_id = #{villageId}")
|
ComMngVillageVO getVillageById(@Param("villageId") Long villageId);
|
}
|
