guoshilong
2023-06-27 ed3be595c8d9908c63dbc3658a47bfb07127c6f0
添加时间降序排序
2 files modified
2 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/manageProtect/mapper/ManageProtectRecordMapper.xml 1 ●●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/schedulingModules/mapper/SchedulingRecordMapper.xml 1 ●●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/manageProtect/mapper/ManageProtectRecordMapper.xml
@@ -34,5 +34,6 @@
        <if test="record.type !=null and record.type !=''">
            AND R.type = #{record.type}
        </if>
        ORDER BY R.CREATE_TIME DESC
    </select>
</mapper>
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/schedulingModules/mapper/SchedulingRecordMapper.xml
@@ -31,6 +31,7 @@
        <if test="record.gateStatus !=null and record.gateStatus !=''">
            AND R.gate_status = #{record.gateStatus}
        </if>
        ORDER BY R.CREATE_TIME  DESC
    </select>
    <select id="customizeGetDetail" resultType="cn.gistack.sm.schedulingModules.vo.SchedulingRecordVO">
        SELECT R.*,arb."name" reservoirName FROM SM_SCHEDULING_RECORD R