代码优化

linwei

2024-02-03 2a600eae2ad4bab763ae61f2fe362298eec78d09

代码优化

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

@@ -132,9 +132,6 @@
            and date_format(jpc.create_time,'%Y-%m-%d') <= #{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>


 src/main/java/org/springblade/modules/taskPlaceRectification/mapper/TaskPlaceRectificationMapper.xml

@@ -256,12 +256,8 @@
                    </when>
                </choose>
            </if>
            and jtpr.create_time=(
            SELECT MAX(create_time) FROM jczz_task_place_rectification where jtpr.house_code=house_code
            )
            order by jtpr.create_time desc
        </where>

        order by jtpr.create_time desc
    </select>