检查记录取最新的

linwe

2024-02-02 50efce5695180c01229eba8393ed32fd3c5e3862

检查记录取最新的

 src/main/java/org/springblade/modules/place/mapper/PlaceCheckMapper.xml

@@ -131,6 +131,10 @@
        <if test="placeCheck.endTime!=null and placeCheck.endTime!=''">
            and date_format(jpc.create_time,'%Y-%m-%d') &lt;= #{placeCheck.endTime}
        </if>

        and jpc.create_time=(
        SELECT MAX(create_time) FROM jczz_place_check where jpc.house_code=house_code
        )
        order by jpc.create_time desc
    </select>