| | |
| | | */ |
| | | package org.springblade.modules.grid.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableLogic; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.baomidou.mybatisplus.annotation.*; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.fasterxml.jackson.databind.annotation.JsonSerialize; |
| | | import com.fasterxml.jackson.databind.ser.std.ToStringSerializer; |
| | |
| | | public class GridPatrolRecordEntity implements Serializable { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 主键 |
| | | */ |
| | | @JsonSerialize(using = ToStringSerializer.class) |
| | | @ApiModelProperty("主键id") |
| | | |
| | | @ApiModelProperty(value = "主键ID", example = "") |
| | | @TableId(value = "id", type = IdType.ASSIGN_ID) |
| | | private Long id; |
| | | |
| | | /** |
| | | * 名称 |
| | | */ |
| | | @ApiModelProperty(value = "名称") |
| | | /** 名称 */ |
| | | @ApiModelProperty(value = "名称", example = "") |
| | | @TableField("name") |
| | | private String name; |
| | | /** |
| | | * 内容 |
| | | */ |
| | | @ApiModelProperty(value = "内容") |
| | | |
| | | /** 内容 */ |
| | | @ApiModelProperty(value = "内容", example = "") |
| | | @TableField("context") |
| | | private String context; |
| | | /** |
| | | * 图片地址 |
| | | */ |
| | | @ApiModelProperty(value = "图片地址") |
| | | |
| | | /** 图片地址 */ |
| | | @ApiModelProperty(value = "图片地址", example = "") |
| | | @TableField("url") |
| | | private String url; |
| | | |
| | | /** |
| | | * 巡查时间 |
| | | */ |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @ApiModelProperty("巡查时间") |
| | | /** 巡查时间 */ |
| | | @ApiModelProperty(value = "巡查时间", example = "") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | @TableField("patrol_time") |
| | | private Date patrolTime; |
| | | |
| | | /** |
| | | * 创建人 |
| | | */ |
| | | @JsonSerialize(using = ToStringSerializer.class) |
| | | @ApiModelProperty("创建人") |
| | | private Long createUser; |
| | | |
| | | /** |
| | | * 创建时间 |
| | | */ |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @ApiModelProperty("创建时间") |
| | | /** 创建时间 */ |
| | | @ApiModelProperty(value = "创建时间", example = "") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | @TableField(value = "create_time",fill = FieldFill.INSERT) |
| | | private Date createTime; |
| | | |
| | | /** |
| | | * 是否删除 |
| | | */ |
| | | @TableLogic |
| | | @ApiModelProperty("是否已删除 0:否 1:是") |
| | | /** 创建人 */ |
| | | @ApiModelProperty(value = "创建人", example = "") |
| | | @TableField("create_user") |
| | | private Long createUser; |
| | | |
| | | /** 是否删除 0:否 1:是 */ |
| | | @ApiModelProperty(value = "是否删除 0:否 1:是", example = "") |
| | | @TableField("is_deleted") |
| | | private Integer isDeleted; |
| | | |
| | | /** 纬度 */ |
| | | @ApiModelProperty(value = "纬度", example = "") |
| | | @TableField("latitude") |
| | | private String latitude; |
| | | |
| | | /** 经度 */ |
| | | @ApiModelProperty(value = "经度", example = "") |
| | | @TableField("longitude") |
| | | private String longitude; |
| | | |
| | | /** 地址 */ |
| | | @ApiModelProperty(value = "地址", example = "") |
| | | @TableField("location") |
| | | private String location; |
| | | |
| | | } |
| | |
| | | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="gridPatrolRecordResultMap" type="org.springblade.modules.grid.entity.GridPatrolRecordEntity"> |
| | | <result column="id" property="id"/> |
| | | <result column="name" property="name"/> |
| | | <result column="context" property="context"/> |
| | | <result column="url" property="url"/> |
| | | <result column="create_time" property="createTime"/> |
| | | <result column="create_user" property="createUser"/> |
| | | <result column="is_deleted" property="isDeleted"/> |
| | | <result property="id" column="id" /> |
| | | <result property="name" column="name" /> |
| | | <result property="context" column="context" /> |
| | | <result property="url" column="url" /> |
| | | <result property="patrolTime" column="patrol_time" /> |
| | | <result property="createTime" column="create_time" /> |
| | | <result property="createUser" column="create_user" /> |
| | | <result property="isDeleted" column="is_deleted" /> |
| | | <result property="latitude" column="latitude" /> |
| | | <result property="longitude" column="longitude" /> |
| | | <result property="location" column="location" /> |
| | | </resultMap> |
| | | |
| | | <!--自定义分页查询--> |
| | |
| | | |
| | | @GetMapping("/getStatisticsCount") |
| | | public R getStatisticsCount(HouseRentalTenantVO houseRental){ |
| | | houseRental.setUserId(AuthUtil.getUserId()); |
| | | return R.data(houseRentalService.getStatisticsCount(houseRental)); |
| | | } |
| | | |
| | |
| | | */ |
| | | package org.springblade.modules.house.controller; |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import io.swagger.annotations.ApiParam; |
| | | import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; |
| | | import lombok.AllArgsConstructor; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import javax.validation.Valid; |
| | | |
| | | import org.springblade.core.boot.ctrl.BladeController; |
| | | import org.springblade.core.excel.util.ExcelUtil; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.utils.DateUtil; |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springblade.modules.house.entity.HouseholdEntity; |
| | | import org.springblade.modules.house.excel.HouseHoldExcel; |
| | | import org.springblade.modules.house.excel.HouseHoldImporter; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.modules.house.entity.HouseholdEntity; |
| | | import org.springblade.modules.house.service.IHouseholdService; |
| | | import org.springblade.modules.house.vo.HouseholdVO; |
| | | import org.springblade.modules.house.wrapper.HouseholdWrapper; |
| | | import org.springblade.modules.house.service.IHouseholdService; |
| | | import org.springblade.core.boot.ctrl.BladeController; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import javax.validation.Valid; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | @PostMapping("/statistics") |
| | | @ApiOperationSupport(order = 7) |
| | | @ApiOperation(value = "住户审核统计", notes = "网格员调用") |
| | | public R remove( ) { |
| | | return R.data(householdService.statistics(AuthUtil.getUserId())); |
| | | public R getStatistics() { |
| | | return R.data(householdService.statistics(AuthUtil.getUserId(), "")); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | List<HouseRentalExcel> export(@Param("vo") HouseRentalTenantVO houseRental); |
| | | |
| | | Integer getStatisticsCount(Long userId); |
| | | Integer getStatisticsCount(Long userId,String neiCode); |
| | | } |
| | |
| | | |
| | | <select id="getStatisticsCount" resultType="java.lang.Integer"> |
| | | SELECT |
| | | count(1) |
| | | count( 1 ) |
| | | FROM |
| | | jczz_grid_range jgr |
| | | LEFT JOIN jczz_grid jg ON jg.id = jgr.grid_id |
| | | LEFT JOIN jczz_gridman jgm on jg.id = jgm.grid_id |
| | | LEFT JOIN jczz_house_rental jhr on jhr.house_code=jgr.house_code |
| | | jczz_house_rental jhr |
| | | LEFT JOIN jczz_doorplate_address jda ON jhr.house_code = jda.address_code |
| | | WHERE |
| | | jhr.is_deleted = 0 |
| | | <if test="neiCode != null and neiCode != ''"> |
| | | and jda.nei_code = #{neiCode} |
| | | </if> |
| | | <if test="userId != null"> |
| | | AND jhr.house_code IN ( |
| | | SELECT |
| | | jgr.house_code |
| | | FROM |
| | | jczz_grid_range jgr |
| | | LEFT JOIN jczz_grid jg ON jg.id = jgr.grid_id |
| | | LEFT JOIN jczz_gridman jgm ON jg.id = jgm.grid_id |
| | | WHERE |
| | | jg.is_deleted = 0 |
| | | and jhr.audit_status = 0 |
| | | AND jgm.user_id = #{userId} |
| | | AND jgm.user_id = #{userId} ) |
| | | </if> |
| | | </select> |
| | | |
| | | |
| | |
| | | */ |
| | | List<HouseHoldExcel> export(@Param("household") HouseholdVO household); |
| | | |
| | | Integer statistics(Long userId); |
| | | Integer statistics(Long userId,String neiCode); |
| | | |
| | | /** |
| | | * 查询物业 |
| | |
| | | jg.grid_name |
| | | FROM |
| | | jczz_household jh |
| | | LEFT JOIN jczz_house jhs ON jh.house_code = jhs.house_code |
| | | LEFT JOIN jczz_house jhs ON jh.house_code = jhs.house_code and jhs.is_deleted = 0 |
| | | LEFT JOIN jczz_doorplate_address jda ON jda.address_code = jh.house_code |
| | | LEFT JOIN jczz_grid_range jgr on jgr.house_code=jda.address_code |
| | | LEFT JOIN jczz_grid jg on jg.id = jgr.grid_id |
| | | LEFT JOIN jczz_gridman jgm on jgm.grid_id=jg.id |
| | | WHERE |
| | | jh.is_deleted = 0 |
| | | <if test="household.userId!=null"> |
| | | and jgm.user_id = #{household.userId} |
| | | </if> |
| | | <if test="household.name!=null and household.name !=''"> |
| | | and jh.name like concat('%',#{household.name},'%') |
| | | </if> |
| | |
| | | |
| | | <select id="statistics" resultType="java.lang.Integer"> |
| | | SELECT |
| | | count(1) |
| | | count( 1 ) |
| | | FROM |
| | | jczz_grid_range jgr |
| | | jczz_household jh |
| | | LEFT JOIN jczz_doorplate_address jda ON jh.house_code = jda.address_code |
| | | <where> |
| | | <if test="neiCode != null and neiCode != ''"> |
| | | and jda.nei_code = #{neiCode} |
| | | </if> |
| | | <if test="userId != null"> |
| | | AND jh.house_code IN ( |
| | | SELECT |
| | | jgr.house_code |
| | | FROM |
| | | jczz_grid_range jgr |
| | | LEFT JOIN jczz_grid jg ON jg.id = jgr.grid_id |
| | | LEFT JOIN jczz_gridman jgm on jg.id = jgm.grid_id |
| | | LEFT JOIN jczz_household jh on jh.house_code=jgr.house_code |
| | | WHERE |
| | | jg.is_deleted = 0 |
| | | and jh.confirm_flag = 0 |
| | | AND jgm.user_id = #{userId} |
| | | LEFT JOIN jczz_gridman jgm ON jg.id = jgm.grid_id |
| | | WHERE |
| | | jg.is_deleted = 0 |
| | | AND jgm.user_id = #{userId} ) |
| | | </if> |
| | | and jh.is_deleted = 0 |
| | | and jh.confirm_flag = 0 |
| | | </where> |
| | | </select> |
| | | |
| | | <!--查询物业--> |
| | |
| | | |
| | | void importUserHouseHold(List<HouseHoldExcel> data, Boolean isCovered); |
| | | |
| | | Integer statistics(Long userId); |
| | | Integer statistics(Long userId,String neiCode); |
| | | |
| | | /** |
| | | * 住户对应物业,网格,公安负责人查询 |
| | |
| | | |
| | | @Override |
| | | public Integer getStatisticsCount(HouseRentalTenantVO houseRental) { |
| | | return baseMapper.getStatisticsCount(AuthUtil.getUserId()); |
| | | return baseMapper.getStatisticsCount(houseRental.getUserId(), houseRental.getNeiCode()); |
| | | } |
| | | } |
| | |
| | | * @return |
| | | */ |
| | | @Override |
| | | public Integer statistics(Long userId) { |
| | | return baseMapper.statistics(userId); |
| | | public Integer statistics(Long userId,String neiCode) { |
| | | return baseMapper.statistics(userId,neiCode); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | private String endTime; |
| | | |
| | | private String neiCode; |
| | | |
| | | private Long userId; |
| | | |
| | | |
| | | } |
| | |
| | | @ApiModelProperty("结束时间") |
| | | private String endTime; |
| | | |
| | | @ApiModelProperty("用户id") |
| | | private Long userId; |
| | | |
| | | } |
| | |
| | | */ |
| | | package org.springblade.modules.place.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springblade.modules.place.entity.PlaceExtEntity; |
| | | import org.springblade.modules.place.vo.PlaceExtVO; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | |
| | | /** |
| | | * 场所详情表 自定义详情 |
| | | * |
| | | * @param placeExt |
| | | * @return |
| | | */ |
| | | PlaceExtVO getDetail(@Param("placeExt") PlaceExtVO placeExt); |
| | | |
| | | |
| | | Integer selectCount(@Param("userId") Long userId, @Param("neiCode") String neiCode, @Param("confirmFlag") Integer confirmFlag); |
| | | } |
| | |
| | | order by jpe.create_time desc,jpe.id desc |
| | | </select> |
| | | |
| | | <!--自定义详情查询--> |
| | | <!--场所审核统计--> |
| | | <select id="selectCount" resultType="java.lang.Integer"> |
| | | SELECT |
| | | count( 1 ) |
| | | FROM |
| | | jczz_place_ext jpe |
| | | LEFT JOIN jczz_place jp ON jp.id = jpe.place_id |
| | | LEFT JOIN jczz_doorplate_address jda ON jp.house_code = jda.address_code |
| | | <where> |
| | | <if test="confirmFlag != null"> |
| | | and jpe.confirm_flag = #{confirmFlag} |
| | | </if> |
| | | <if test="userId != null"> |
| | | AND jp.house_code IN ( |
| | | SELECT |
| | | jgr.house_code |
| | | FROM |
| | | jczz_grid_range jgr |
| | | LEFT JOIN jczz_grid jg ON jg.id = jgr.grid_id |
| | | LEFT JOIN jczz_gridman jgm ON jg.id = jgm.grid_id |
| | | WHERE |
| | | jg.is_deleted = 0 |
| | | <if test="neiCode != null and neiCode != ''"> |
| | | and jg.community_code = #{neiCode} |
| | | </if> |
| | | AND jgm.user_id = #{userId} ) |
| | | </if> |
| | | and jpe.is_deleted = 0 |
| | | </where> |
| | | |
| | | |
| | | </select> |
| | | |
| | | <select id="getDetail" resultType="org.springblade.modules.place.vo.PlaceExtVO"> |
| | | select jpe.*,jp.place_name as placeName from jczz_place_ext jpe |
| | | left join jczz_place jp on jpe.place_id = jp.id and jp.is_deleted = 0 |
| | | select jpe.*, jp.place_name as placeName |
| | | from jczz_place_ext jpe |
| | | left join jczz_place jp on jpe.place_id = jp.id and jp.is_deleted = 0 |
| | | where jpe.is_deleted = 0 |
| | | and jpe.place_id = #{placeExt.placeId} |
| | | and jpe.place_id = #{placeExt.placeId} |
| | | </select> |
| | | |
| | | |
| | |
| | | package org.springblade.modules.place.service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springblade.modules.place.entity.PlaceExtEntity; |
| | | import org.springblade.modules.place.vo.PlaceExtVO; |
| | | import org.springblade.core.mp.base.BaseService; |
| | |
| | | * @return |
| | | */ |
| | | PlaceExtVO getDetail(PlaceExtVO placeExt); |
| | | |
| | | Integer selectCount(@Param("userId") Long userId, @Param("neiCode") String neiCode, @Param("confirmFlag") Integer confirmFlag); |
| | | } |
| | |
| | | // 返回 |
| | | return detail; |
| | | } |
| | | |
| | | @Override |
| | | public Integer selectCount(Long userId, String neiCode, Integer confirmFlag) { |
| | | return baseMapper.selectCount(userId, neiCode, confirmFlag); |
| | | } |
| | | } |
| | |
| | | PlaceExtEntity one = placeExtService.getOne(wrapper); |
| | | if (null == one) { |
| | | placeExtEntity.setPlaceId(placeVO.getId()); |
| | | placeExtEntity.setLocaltion(placeVO.getLocaltion()); |
| | | //新增 |
| | | placeExtService.savePlaceExt(placeExtEntity); |
| | | } |
| | |
| | | */ |
| | | @GetMapping("/dynamicMenu") |
| | | @ApiOperation(value = "菜单列表", notes = "传入menu") |
| | | public R<List<MenuVO>> dynamicMenu(String roleId, Long topMenuId, @RequestParam(value = "labelType", required = false) Integer labelType) { |
| | | public R<List<MenuVO>> dynamicMenu(String roleId, Long topMenuId, @RequestParam(value = "labelType", required = false,defaultValue = "1") Integer labelType) { |
| | | List<MenuVO> list = menuService.routes(roleId, topMenuId,labelType,1); |
| | | return R.data(list); |
| | | } |
| | |
| | | @GetMapping("/countTypeNumber") |
| | | @ApiOperationSupport(order = 9) |
| | | @ApiOperation(value = "统计类型数量") |
| | | public R countTypeNumber() { |
| | | public R countTypeNumber(@RequestParam(value = "neiCode", required = false) String neiCode) { |
| | | return R.data(taskService.countTypeNumber()); |
| | | } |
| | | |
| | |
| | | @GetMapping("/getStatistics") |
| | | @ApiOperation(value = "w网格员查询报事报修统计" ) |
| | | public R getStatistics() { |
| | | return R.data(taskReportForRepairsService.getStatistics(AuthUtil.getUserId())); |
| | | return R.data(taskReportForRepairsService.getStatistics(AuthUtil.getUserId(),"")); |
| | | } |
| | | |
| | | /** |
| | |
| | | |
| | | |
| | | <select id="selectTaskCount" resultType="int" parameterType="org.springblade.modules.task.vo.TaskVO"> |
| | | SELECT count(1) |
| | | SELECT |
| | | count( 1 ) |
| | | FROM |
| | | jczz_gridman jgm |
| | | LEFT JOIN jczz_grid jg ON jgm.grid_id = jg.id |
| | | LEFT JOIN jczz_grid_range jgr ON jg.id = jgr.grid_id |
| | | LEFT JOIN jczz_task jt ON jgr.house_code = jt.house_code |
| | | jczz_task jt |
| | | LEFT JOIN jczz_doorplate_address jda ON jda.address_code = jt.house_code |
| | | WHERE |
| | | jgm.user_id = #{userId} |
| | | <if test="status != null"> |
| | | and jt.status = #{status} |
| | | </if> |
| | | <if test="frequency != null"> |
| | | and jt.frequency = #{frequency} |
| | | </if> |
| | | <if test="type != null"> |
| | | and jt.type = #{type} |
| | | </if> |
| | | <!-- 取保候审 --> |
| | | <if test="reportType != null and reportType == 1 "> |
| | | and jt.report_type = 1 |
| | | </if> |
| | | <!-- 场所店铺 --> |
| | | <if test="reportType != null and reportType == 2 "> |
| | | and jt.report_type in (2,3,4,5,6) |
| | | </if> |
| | | <where> |
| | | <if test="status != null"> |
| | | and jt.status = #{status} |
| | | </if> |
| | | <if test="frequency != null"> |
| | | and jt.frequency = #{frequency} |
| | | </if> |
| | | <if test="type != null"> |
| | | and jt.type = #{type} |
| | | </if> |
| | | <!-- 取保候审 --> |
| | | <if test="reportType != null and reportType == 1 "> |
| | | and jt.report_type = 1 |
| | | </if> |
| | | <!-- 场所店铺 --> |
| | | <if test="reportType != null and reportType == 2 "> |
| | | and jt.report_type in (2,3,4,5,6) |
| | | </if> |
| | | |
| | | <if test="name != null and name != ''"> |
| | | and jt.name like concat('%', #{name}, '%') |
| | | </if> |
| | | <if test="name != null and name != ''"> |
| | | and jt.name like concat('%', #{name}, '%') |
| | | </if> |
| | | <if test="neiCode != null and neiCode != ''"> |
| | | and jda.nei_code = #{neiCode} |
| | | </if> |
| | | <if test="userId != null"> |
| | | AND jt.house_code IN ( |
| | | SELECT |
| | | jgr.house_code |
| | | FROM |
| | | jczz_grid_range jgr |
| | | LEFT JOIN jczz_grid jg ON jg.id = jgr.grid_id |
| | | LEFT JOIN jczz_gridman jgm ON jg.id = jgm.grid_id |
| | | WHERE |
| | | jg.is_deleted = 0 |
| | | AND jgm.user_id = #{userId} ) |
| | | </if> |
| | | </where> |
| | | |
| | | order by jt.create_time desc |
| | | |
| | | </select> |
| | | |
| | | |
| | |
| | | */ |
| | | TaskReportStatistics getStatisticsCount(@Param("userId") Long userId); |
| | | |
| | | Integer getStatistics(Long userId); |
| | | Integer getStatistics(Long userId,String neiCode); |
| | | |
| | | /** |
| | | * 更新状态--临时接口 |
| | |
| | | |
| | | |
| | | <select id="getStatistics" resultType="java.lang.Integer"> |
| | | |
| | | SELECT |
| | | count(1) |
| | | count( 1 ) |
| | | FROM |
| | | jczz_gridman jgm |
| | | LEFT JOIN jczz_grid jg ON jgm.grid_id = jg.id |
| | | LEFT JOIN jczz_grid_range jgr ON jg.id = jgr.grid_id |
| | | LEFT JOIN jczz_task_report_for_repairs jtr ON jgr.house_code = jtr.address_code |
| | | LEFT JOIN jczz_doorplate_address jda ON jda.address_code = jtr.address_code |
| | | jczz_task_report_for_repairs jtr |
| | | LEFT JOIN jczz_doorplate_address jda ON jtr.address_code = jda.address_code |
| | | WHERE |
| | | jtr.is_deleted = 0 |
| | | <if test="neiCode != null and neiCode != ''"> |
| | | and jda.nei_code = #{neiCode} |
| | | </if> |
| | | <if test="userId != null"> |
| | | AND jtr.address_code IN ( |
| | | SELECT |
| | | jgr.house_code |
| | | FROM |
| | | jczz_grid_range jgr |
| | | LEFT JOIN jczz_grid jg ON jg.id = jgr.grid_id |
| | | LEFT JOIN jczz_gridman jgm ON jg.id = jgm.grid_id |
| | | WHERE |
| | | jg.is_deleted = 0 |
| | | and jtr.confirm_flag = 1 |
| | | AND jgm.user_id = #{userId} |
| | | AND jgm.user_id = #{userId} ) |
| | | </if> |
| | | |
| | | </select> |
| | | |
| | |
| | | */ |
| | | boolean checkReportForRepairs(TaskReportForRepairsEntity taskReportForRepairs); |
| | | |
| | | Integer getStatistics(Long userId); |
| | | Integer getStatistics(Long userId,String neiCode); |
| | | |
| | | /** |
| | | * 更新状态--临时接口 |
| | |
| | | } |
| | | |
| | | @Override |
| | | public Integer getStatistics(Long userId) { |
| | | return baseMapper.getStatistics(userId); |
| | | public Integer getStatistics(Long userId,String neiCode) { |
| | | return baseMapper.getStatistics(userId,neiCode); |
| | | } |
| | | |
| | | /** |
| | |
| | | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import org.springblade.common.utils.SpringUtils; |
| | | import org.springblade.core.mp.base.BaseServiceImpl; |
| | | import org.springblade.core.secure.utils.AuthUtil; |
| | | import org.springblade.modules.house.service.IHouseRentalService; |
| | | import org.springblade.modules.house.service.IHouseholdService; |
| | | import org.springblade.modules.house.vo.HouseRentalTenantVO; |
| | | import org.springblade.modules.place.service.IPlaceExtService; |
| | | import org.springblade.modules.task.entity.TaskEntity; |
| | | import org.springblade.modules.task.mapper.TaskMapper; |
| | | import org.springblade.modules.task.service.ITaskReportForRepairsService; |
| | | import org.springblade.modules.task.service.ITaskService; |
| | | import org.springblade.modules.task.vo.TaskVO; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | |
| | | @Service |
| | | public class TaskServiceImpl extends BaseServiceImpl<TaskMapper, TaskEntity> implements ITaskService { |
| | | |
| | | // @Autowired |
| | | // private ITaskReportForRepairsService iTaskReportForRepairsService; |
| | | // @Autowired |
| | | // private ITaskReportForRepairsService iTaskReportForRepairsService; |
| | | |
| | | @Autowired |
| | | private IHouseholdService iHouseholdService; |
| | |
| | | public Object countTypeNumber() { |
| | | TaskVO taskVO = new TaskVO(); |
| | | Map<String, Object> objectObjectHashMap = new HashMap<>(); |
| | | taskVO.setUserId(AuthUtil.getUserId()); |
| | | taskVO.setType(1); |
| | | taskVO.setStatus(1); |
| | | // 综治任务 |
| | | Integer comprehensiveTask = baseMapper.selectTaskCount(taskVO); |
| | | taskVO.setType(2); |
| | | // 组建任务 |
| | | Integer residentialTask = baseMapper.selectTaskCount(taskVO); |
| | | taskVO.setType(3); |
| | | // 公安任务 |
| | | Integer publicTask = baseMapper.selectTaskCount(taskVO); |
| | | |
| | | taskVO.setReportType(2); |
| | | // 标签时间 |
| | | Integer bqsj = baseMapper.selectTaskCount(taskVO); |
| | | taskVO.setReportType(1); |
| | | // 标签时间 |
| | | Integer qbhs = baseMapper.selectTaskCount(taskVO); |
| | | // 报事报修 |
| | | // Integer statistics = iTaskReportForRepairsService.getStatistics(AuthUtil.getUserId()); |
| | | Integer bsbx = SpringUtils.getBean(ITaskReportForRepairsService.class).getStatistics(AuthUtil.getUserId(), ""); |
| | | // 住房审核 |
| | | Integer statistics1 = iHouseholdService.statistics(AuthUtil.getUserId()); |
| | | Integer zhsh = iHouseholdService.statistics(AuthUtil.getUserId(),""); |
| | | // 出租审核 |
| | | Integer statisticsCount = iHouseRentalService.getStatisticsCount(new HouseRentalTenantVO()); |
| | | |
| | | objectObjectHashMap.put("comprehensiveTask", comprehensiveTask); |
| | | objectObjectHashMap.put("residentialTask", residentialTask); |
| | | objectObjectHashMap.put("publicTask", publicTask); |
| | | |
| | | // objectObjectHashMap.put("baoshi", statistics); |
| | | objectObjectHashMap.put("zhufang", statistics1); |
| | | objectObjectHashMap.put("chuzhu", statisticsCount); |
| | | HouseRentalTenantVO houseRentalTenantVO = new HouseRentalTenantVO(); |
| | | houseRentalTenantVO.setUserId(AuthUtil.getUserId()); |
| | | Integer czsh = iHouseRentalService.getStatisticsCount(houseRentalTenantVO); |
| | | // 场所审核 |
| | | Integer cssh = SpringUtils.getBean(IPlaceExtService.class).selectCount(AuthUtil.getUserId(), "", 1); |
| | | objectObjectHashMap.put("qbhs", qbhs); |
| | | objectObjectHashMap.put("bqsj", bqsj); |
| | | objectObjectHashMap.put("bsbx", bsbx); |
| | | objectObjectHashMap.put("zhsh", zhsh); |
| | | objectObjectHashMap.put("czsh", czsh); |
| | | objectObjectHashMap.put("cssh", cssh); |
| | | return objectObjectHashMap; |
| | | } |
| | | |
| | |
| | | @ApiModelProperty(value = "社区编码") |
| | | private String communityCode; |
| | | |
| | | private String neiCode; |
| | | |
| | | } |