bug修复

lin

2024-03-04 7ffe7b1791adfc27f4411c7ad0bea229f6799445

bug修复

 src/main/java/org/springblade/modules/article/mapper/ArticleMapper.xml

@@ -41,8 +41,7 @@


    <sql id="selectArticle">
        select
            id,
        select id,
            title,
            type,
            content,
@@ -63,8 +62,7 @@
            article_range,
            building,
            unit
        from
            jczz_article
        from jczz_article
    </sql>


@@ -198,7 +196,6 @@
        LEFT JOIN blade_region br on br.`code` = jd.community_code
        where 1=1
        and ja.is_deleted = 0
        <if test="article.propertyFlag!=null ">
            <if test="article.communityName!=null and article.communityName!=''">
                and br.`village_name` like concat('%',#{article.communityName},'%')
            </if>
@@ -206,8 +203,6 @@
            <if test="article.streetName!=null and article.streetName!=''">
                and br.town_name like concat('%',#{article.streetName},'%')
            </if>
        </if>


        <if test="article.title!=null and article.title!=''">
            and ja.title like concat('%',#{article.title},'%')
@@ -444,7 +439,8 @@
    </select>

    <update id="upcomment">
        update jczz_article set iscomment = #{type}
        update jczz_article
        set iscomment = #{type}
        where id in(${ids})
    </update>


 src/main/java/org/springblade/modules/property/entity/PropertyCompanyDistrictEntity.java

@@ -59,7 +59,7 @@
    @ApiModelProperty(value = "小区id")
    private String districtId;
    /**
     * 负责人姓名
     * 负责人id
     */
    @ApiModelProperty(value = "负责人id")
    private String principal;

 src/main/java/org/springblade/modules/property/mapper/PropertyCompanyDistrictMapper.xml

@@ -33,7 +33,8 @@
        jpc.name as propertyCompanyName,
        br.name communityName,
        br.name streetName,
        jg.grid_name
        jg.grid_name,
        bu.name principalName
        FROM
        jczz_property_company_district jpcd
        LEFT JOIN jczz_district jd ON jd.id = jpcd.district_id AND jd.is_deleted = 0
@@ -41,6 +42,7 @@
        LEFT JOIN blade_region br on br.code= jd.community_code
        LEFT JOIN jczz_grid_range jgr on jgr.district_code=jd.id
        LEFT JOIN jczz_grid jg on jg.id = jgr.grid_id
        LEFT JOIN blade_user bu on bu.id = jpcd.principal
        where jpcd.is_deleted = 0
        <if test="propertyCompanyDistrict.communityName!=null and propertyCompanyDistrict.communityName!=''">
            and br.name like concat('%', #{propertyCompanyDistrict.communityName},'%')

 src/main/java/org/springblade/modules/property/vo/PropertyCompanyDistrictVO.java

@@ -16,10 +16,10 @@
 */
package org.springblade.modules.property.vo;

import org.springblade.modules.property.entity.PropertyCompanyDistrictEntity;
import org.springblade.core.tool.node.INode;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.springblade.modules.property.entity.PropertyCompanyDistrictEntity;

import java.util.List;

@@ -57,5 +57,11 @@
    // 机构
    private String deptId;

    /**
     * 负责人名称
     */
    @ApiModelProperty(value = "负责人名称")
    private String principalName;


}

 src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java

@@ -24,6 +24,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import lombok.AllArgsConstructor;
import org.apache.commons.lang3.StringUtils;
import org.apache.logging.log4j.util.Strings;
import org.flowable.idm.engine.impl.persistence.entity.UserEntity;
import org.springblade.common.cache.DictCache;
@@ -640,6 +641,9 @@
    @Override
    public List<User> getUserInfoByPropertyId(String propertyCompanyId, String roleId) {
        // 查询物业公司，获取物业公司的机构
        if(StringUtils.isBlank(propertyCompanyId)){
            return new ArrayList<>();
        }
        IPropertyCompanyService bean = SpringUtil.getBean(IPropertyCompanyService.class);
        PropertyCompanyEntity one = bean.getOne(Wrappers.<PropertyCompanyEntity>lambdaQuery().eq(PropertyCompanyEntity::getId, propertyCompanyId));
        return baseMapper.getUserInfoByPropertyId(one.getDeptId().toString(), roleId);