业主反馈

zengh

2021-08-13 cc59ba2cd1d7265a750c377d1fc1c3fa2e3b9c0f

业主反馈

 src/main/java/org/springblade/modules/ownerFeed/mapper/OwnerMapper.xml

@@ -5,5 +5,22 @@

    <select id="selectOwnerPage" resultType="org.springblade.modules.ownerFeed.vo.OwnerVO">
        select * from owner_feedback
        where 1=1
        <if test="owner.company!=null and owner.company!=''">
            and company like concat('%',#{owner.company},'%')
        </if>

        <if test="owner.owner!=null and owner.owner!=''">
            and owner like concat('%',#{owner.owner},'%')
        </if>

        <if test="owner.startTime!=null and owner.startTime!=''">
            and feedback_time&gt;=#{owner.startTime}
        </if>

        <if test="owner.endTime!=null and owner.endTime!=''">
            and feedback_time&lt;=#{owner.endTime}
        </if>

    </select>
</mapper>

 src/main/java/org/springblade/modules/ownerFeed/vo/OwnerVO.java

@@ -13,4 +13,7 @@
@EqualsAndHashCode(callSuper = true)
public class OwnerVO extends Owner {
    private static final long serialVersionUID = 1L;

    private String startTime;
    private String endTime;
}