springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/common/AddComPbCheckUnitDto.java
@@ -111,7 +111,7 @@ @ApiModelProperty(value = "管理员电话") private String adminPhone; @ApiModelProperty(value = "其他") private String otherMark; private String otherRemark; @ApiModelProperty(value = "单位所属") private String belongTo; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/common/EditComPbCheckUnitDto.java
@@ -106,7 +106,7 @@ @ApiModelProperty(value = "管理员电话") private String adminPhone; @ApiModelProperty(value = "其他") private String otherMark; private String otherRemark; @ApiModelProperty(value = "单位所属") private String belongTo; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/neighbor/ComActNeighborCircleAppDTO.java
@@ -47,6 +47,9 @@ private Integer isHelp; private String phone; @ApiModelProperty("接单类型 1单位 2个人") private Integer orderType; /** * 使用类型(1.邻里圈 2.问题清单 3.需求清单) */ springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/common/ComPbCheckUnitVo.java
@@ -123,7 +123,7 @@ @ApiModelProperty(value = "管理员电话") private String adminPhone; @ApiModelProperty(value = "其他") private String otherMark; private String otherRemark; @ApiModelProperty(value = "单位所属") private String belongTo; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/partybuilding/PagePartyOrganizationVO.java
@@ -57,4 +57,6 @@ @ApiModelProperty("结束时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date endTime; @ApiModelProperty(value = "特长类别") private String specialtyName; } springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/entity/ComPbCheckUnit.java
@@ -95,7 +95,7 @@ private String adminPhone; private String otherMark; private String otherRemark; private String belongTo; } springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/ComPbMemberServiceImpl.java
@@ -1111,7 +1111,7 @@ if(StringUtils.isEmpty(member.getCheckUnitName())){ member.setCheckUnitName("待编辑报到单位"); } member.setName(SensitiveUtil.replaceName(member.getName())); //member.setName(SensitiveUtil.replaceName(member.getName())); }); return R.ok(memberPage); } springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbCheckUnitMapper.xml
@@ -37,7 +37,7 @@ and cpcu.community_id = #{dto.communityId} </if> <if test="dto.keyWord != null and dto.keyWord != ''"> and cpcu.org_name like concat(#{dto.keyWord},'%') and (cpcu.contacts like concat(#{dto.keyWord},'%') or cpcu.`name` like concat('%',#{dto.name},'%') or cpcu.phone like concat(#{dto.keyWord},'%')) </if> <if test="dto.name != null and dto.name != ''"> and cpcu.`name` like concat('%',#{dto.name},'%') @@ -45,6 +45,9 @@ <if test="dto.contacts != null and dto.contacts != ''"> and cpcu.`contacts` like concat(#{dto.contacts},'%') </if> <if test="dto.specialtyName != null and dto.specialtyName != ''"> and cpcu.specialty_name like concat(#{dto.specialtyName},'%') </if> </where> order by cpcu.create_at desc </select> springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbMemberMapper.xml
@@ -54,7 +54,7 @@ select m.id, m.org_id, m.name, m.id_card, m.photo_path, m.join_time, m.employment_time, m.audit_result, m.create_at, m.update_at, m.community_id, u.user_id, m.refuse_reason, m.phone, m.type, m.position, m.check_unit_id, m.function, m.specialty_category, m.specialty_name, m.position_two, m.org_name,cpcu.name as checkUnitName,t2.partyTime,t2.partyInterval, m.specialty_name, m.position_two, m.org_name,cpcu.name as checkUnitName,t2.partyTime,t2.partyInterval,cmv.name as villageName,ca.name as communityName, TIMESTAMPDIFF( YEAR, m.employment_time, @@ -68,6 +68,8 @@ LEFT JOIN sys_user u ON m.id_card = u.id_card and u.type = 1 LEFT JOIN com_pb_org o ON m.org_id = o.id LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id LEFT JOIN com_mng_village cmv on m.village_id = cmv.village_id LEFT JOIN com_act ca on m.community_id = ca.community_id LEFT JOIN (select t1.user_id,sum(t.duration) as partyTime,sum(t.reward_integral) as partyInterval from com_act_activity t LEFT JOIN com_act_act_regist t1 on t.id = t1.activity_id where t.type = 3 <if test="dto.startTime !=null"> and t.begin_at between #{dto.startTime} and #{dto.endTime} @@ -105,8 +107,8 @@ <if test="dto.checkUnitId != null"> and m.check_unit_id = #{dto.checkUnitId} </if> <if test="dto.specialtyCategory != null"> and m.specialty_category = #{dto.specialtyCategory} <if test="dto.specialtyName != null and dto.specialtyName !=''"> and m.specialty_name like concat('%',#{dto.specialtyName},'%') </if> </where> order by m.create_at desc