src/main/java/org/springblade/modules/property/entity/PropertyCapitalApplyEntity.java
@@ -81,7 +81,7 @@ * 分摊方式 */ @ApiModelProperty(value = "分摊方式") private Integer allocationWay; private String allocationWay; /** * 预算总金额 */ src/main/java/org/springblade/modules/property/mapper/PropertyCapitalApplyMapper.java
@@ -16,6 +16,7 @@ */ package org.springblade.modules.property.mapper; import org.apache.ibatis.annotations.Param; import org.springblade.modules.property.entity.PropertyCapitalApplyEntity; import org.springblade.modules.property.vo.PropertyCapitalApplyVO; import com.baomidou.mybatisplus.core.mapper.BaseMapper; @@ -37,7 +38,8 @@ * @param propertyCapitalApply * @return */ List<PropertyCapitalApplyVO> selectPropertyCapitalApplyPage(IPage page, PropertyCapitalApplyVO propertyCapitalApply); List<PropertyCapitalApplyVO> selectPropertyCapitalApplyPage(IPage page, @Param("propertyCapitalApply") PropertyCapitalApplyVO propertyCapitalApply); } src/main/java/org/springblade/modules/property/mapper/PropertyCapitalApplyMapper.xml
@@ -27,9 +27,18 @@ <result column="is_deleted" property="isDeleted"/> </resultMap> <!--自定义分页查询--> <select id="selectPropertyCapitalApplyPage" resultMap="propertyCapitalApplyResultMap"> select * from jczz_property_capital_apply where is_deleted = 0 <if test="propertyCapitalApply.districtId!=null"> and district_id = #{propertyCapitalApply.districtId} </if> <if test="propertyCapitalApply.name!=null and propertyCapitalApply.name!=''"> and name like concat('%',#{propertyCapitalApply.name},'%') </if> <if test="propertyCapitalApply.linkman!=null and propertyCapitalApply.linkman!=''"> and linkman like concat('%',#{propertyCapitalApply.linkman},'%') </if> </select>