From 19e10d0d6a54b2b0c1a8d4f52c84a18c089d0025 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期三, 20 三月 2024 10:33:43 +0800 Subject: [PATCH] 临时提交 --- src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java | 15 ++++++++++++++- 1 files changed, 14 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java index 4616678..08f67ba 100644 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/CloudRecordServiceMapper.java @@ -101,9 +101,22 @@ int changeCollectById(@Param("collect") boolean collect, @Param("recordId") Integer recordId); @Delete(" <script>" + - "delete from wvp_cloud_record where media_server_id=#{mediaServerId} and id in " + + "delete from wvp_cloud_record where id in " + " <foreach collection='cloudRecordItemIdList' item='item' open='(' separator=',' close=')' > #{item.id}</foreach>" + " </script>") int deleteList(List<CloudRecordItem> cloudRecordItemIdList); + @Select(" <script>" + + "select *" + + " from wvp_cloud_record " + + "where call_id = #{callId}" + + " </script>") + List<CloudRecordItem> getListByCallId(@Param("callId") String callId); + + @Select(" <script>" + + "select *" + + " from wvp_cloud_record " + + "where id = #{id}" + + " </script>") + CloudRecordItem queryOne(@Param("id") Integer id); } -- Gitblit v1.8.0