wuxw
2019-12-22 a444df635ac8b6e3a43de1a59a315a0412daf362
优化查询已经入住的 信息
3个文件已修改
16 ■■■■■ 已修改文件
Api/src/main/java/com/java110/api/listener/community/ListMyEnteredCommunitysListener.java 4 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
java110-bean/src/main/java/com/java110/dto/community/CommunityDto.java 9 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
java110-db/src/main/resources/mapper/community/CommunityServiceDaoImplMapper.xml 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
Api/src/main/java/com/java110/api/listener/community/ListMyEnteredCommunitysListener.java
@@ -12,6 +12,7 @@
import com.java110.dto.org.OrgStaffRelDto;
import com.java110.event.service.api.ServiceDataFlowEvent;
import com.java110.utils.constant.ServiceCodeConstant;
import com.java110.utils.constant.StateConstant;
import com.java110.utils.util.Assert;
import com.java110.utils.util.BeanConvertUtil;
import com.java110.vo.api.community.ApiCommunityDataVo;
@@ -96,6 +97,7 @@
        if ("9999".equals(orgDtos.get(0).getBelongCommunityId())) {
            CommunityDto communityDto = BeanConvertUtil.covertBean(reqJson, CommunityDto.class);
            communityDto.setMemberId(reqJson.getString("storeId"));
            communityDto.setAuditStatusCd(StateConstant.AGREE_AUDIT);
            count = communityInnerServiceSMOImpl.queryCommunitysCount(communityDto);
            if (count > 0) {
                communitys = BeanConvertUtil.covertBeanList(communityInnerServiceSMOImpl.queryCommunitys(communityDto), ApiCommunityDataVo.class);
@@ -113,7 +115,7 @@
        ApiCommunityVo apiCommunityVo = new ApiCommunityVo();
        apiCommunityVo.setTotal(count);
        apiCommunityVo.setRecords((int) Math.ceil((double) count / (double) reqJson.getInteger("row")));
        apiCommunityVo.setRecords(1);
        apiCommunityVo.setCommunitys(communitys);
        ResponseEntity<String> responseEntity = new ResponseEntity<String>(JSONObject.toJSONString(apiCommunityVo), HttpStatus.OK);
java110-bean/src/main/java/com/java110/dto/community/CommunityDto.java
@@ -26,6 +26,7 @@
    private String state;
    private String stateName;
    private String[] communityIds;
    private String auditStatusCd;
@@ -138,4 +139,12 @@
    public void setCommunityIds(String[] communityIds) {
        this.communityIds = communityIds;
    }
    public String getAuditStatusCd() {
        return auditStatusCd;
    }
    public void setAuditStatusCd(String auditStatusCd) {
        this.auditStatusCd = auditStatusCd;
    }
}
java110-db/src/main/resources/mapper/community/CommunityServiceDaoImplMapper.xml
@@ -469,6 +469,9 @@
            and cm.member_id = #{memberId}
            and cm.status_cd = '0'
        </if>
        <if test="memberId !=null and memberId !='' and auditStatusCd != null and auditStatusCd !=''">
            and cm.audit_status_cd = #{auditStatusCd}
        </if>
        <if test="page != -1 and page != null ">
            limit #{page}, #{row}
        </if>