| | |
|---|
| | | @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); |
|---|
| | | |
|---|
| | | @Select("<script> " + "SELECT " + " village_id, " + " `name` AS userName, " + " (select count(id) from com_mng_building where village_id = cmv.village_id) as buildSum, " + " address, " |
|---|
| | | @Select("<script> " + "SELECT " + " village_id, " + " `name` AS userName, " + " IFNULL((select count(id) from com_mng_building where village_id = cmv.village_id),0) as buildSum, " + " address, " |
|---|
| | | + " create_at as createAt, " + " lng, " + " lat, " |
|---|
| | | + " ( SELECT count( id ) FROM com_mng_population WHERE village_id = cmv.village_id ) AS userSum, " |
|---|
| | | + " ( SELECT count( id ) FROM com_mng_population_house WHERE village_id = cmv.village_id ) AS houseNum, " |
|---|
| | |
|---|
| | | IPage<PageComMngVillageVO> getGridVillageList(Page page, |
|---|
| | | @Param("villageListAppDTO") ComMngVillageListAppDTO villageListAppDTO); |
|---|
| | | |
|---|
| | | IPage<PageComMngVillageVO> getGridVillageListApp(Page page, |
|---|
| | | @Param("villageListAppDTO") ComMngVillageListAppDTO villageListAppDTO); |
|---|
| | | |
|---|
| | | @Select("<script> " + "SELECT " + " alley, " + " house_num as doorNum, " + " `name` AS userName, " + " build_sum, " |
|---|
| | | + " address, " + " create_at as createAt, " |
|---|
| | | + " ( SELECT count( id ) FROM com_mng_population WHERE village_id = cmv.village_id ) AS userSum, " |
|---|
