From e8925583e893a0d966024905afe3cddd6bfbe5d1 Mon Sep 17 00:00:00 2001
From: 张晓波 <bingbo1993@126.com>
Date: 星期三, 06 十二月 2023 15:58:53 +0800
Subject: [PATCH] 广播
---
hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/controller/AudioController.java | 6 +++
hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/entity/AudioFile.java | 19 +++++++++
hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/bigscreen/mapper/BigScreenMapper.java | 7 +++
hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/AudioService.java | 2 +
hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/entity/AudioDto.java | 5 ++
hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml | 54 +++++++++++++++++++++++++++
hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/impl/AudioServiceImpl.java | 13 ++++++
7 files changed, 105 insertions(+), 1 deletions(-)
diff --git a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/controller/AudioController.java b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/controller/AudioController.java
index 86bbbf0..f9c1bd8 100644
--- a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/controller/AudioController.java
+++ b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/controller/AudioController.java
@@ -29,4 +29,10 @@
audioService.playMusic(AudioDto);
return BasicResult.success();
}
+
+ @RequestMapping("addFile")
+ public BasicResult addFile(@RequestBody AudioDto audioDto){
+ audioService.addFile(audioDto);
+ return BasicResult.success();
+ }
}
diff --git a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/entity/AudioDto.java b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/entity/AudioDto.java
index 2209ef9..4c70f00 100644
--- a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/entity/AudioDto.java
+++ b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/entity/AudioDto.java
@@ -3,9 +3,14 @@
import lombok.Data;
import java.io.Serializable;
+import java.util.List;
@Data
public class AudioDto implements Serializable {
private String groupIds;
+
+ private List<AudioFile> fileList;
+
+ private String groupId;
}
diff --git a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/entity/AudioFile.java b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/entity/AudioFile.java
new file mode 100644
index 0000000..8ea7093
--- /dev/null
+++ b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/entity/AudioFile.java
@@ -0,0 +1,19 @@
+package com.thhy.screen.modules.biz.audio.entity;
+
+import com.thhy.general.annotations.Idkey;
+import lombok.Data;
+
+import java.io.Serializable;
+
+@Data
+public class AudioFile implements Serializable {
+
+ @Idkey
+ private String id;
+
+ private String groupId;
+
+ private String audioFile;
+
+ private Integer defaults;
+}
diff --git a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/AudioService.java b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/AudioService.java
index 7b14600..c507c0a 100644
--- a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/AudioService.java
+++ b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/AudioService.java
@@ -10,4 +10,6 @@
List<AudioGroup> queryGroups();
void playMusic(AudioDto audioDto);
+
+ void addFile(AudioDto audioDto);
}
diff --git a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/impl/AudioServiceImpl.java b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/impl/AudioServiceImpl.java
index e25d27e..c89ade4 100644
--- a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/impl/AudioServiceImpl.java
+++ b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/audio/service/impl/AudioServiceImpl.java
@@ -1,10 +1,12 @@
package com.thhy.screen.modules.biz.audio.service.impl;
import com.thhy.screen.modules.biz.audio.entity.AudioDto;
+import com.thhy.screen.modules.biz.audio.entity.AudioFile;
import com.thhy.screen.modules.biz.audio.entity.AudioGroup;
import com.thhy.screen.modules.biz.audio.service.AudioService;
import com.thhy.screen.modules.biz.bigscreen.mapper.BigScreenMapper;
import com.thhy.screen.utils.AudioUtils;
+import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -26,6 +28,15 @@
String groupIds = audioDto.getGroupIds();
String[] groupIdArray = new String[]{groupIds};
AudioUtils.playMusic(groupIdArray);
- return;
+ }
+
+ @Override
+ public void addFile(AudioDto audioDto) {
+ List<AudioFile> fileList = audioDto.getFileList();
+ screenMapper.deleteAudioFile(audioDto.getGroupId());
+ for(AudioFile audioFile : fileList){
+ audioFile.setGroupId(audioFile.getGroupId());
+ screenMapper.insertAudioFile(audioFile);
+ }
}
}
diff --git a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/bigscreen/mapper/BigScreenMapper.java b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/bigscreen/mapper/BigScreenMapper.java
index d232ee5..d0483de 100644
--- a/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/bigscreen/mapper/BigScreenMapper.java
+++ b/hd/pipe/screen/src/main/java/com/thhy/screen/modules/biz/bigscreen/mapper/BigScreenMapper.java
@@ -1,5 +1,6 @@
package com.thhy.screen.modules.biz.bigscreen.mapper;
+import com.thhy.screen.modules.biz.audio.entity.AudioFile;
import com.thhy.screen.modules.biz.audio.entity.AudioGroup;
import com.thhy.screen.modules.biz.bigscreen.entity.*;
import org.apache.ibatis.annotations.Param;
@@ -38,4 +39,10 @@
List<HashMap<String,Object>> querySteelMake();
List<HashMap<String,Object>> queryRestInfo();
+
+ void insertAudioFile(AudioFile audioFile);
+
+ void updateAudioFile(AudioFile audioFile);
+
+ void deleteAudioFile(String groupId);
}
diff --git a/hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml b/hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml
index eae824e..4ab0c72 100644
--- a/hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml
+++ b/hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml
@@ -272,5 +272,59 @@
from sys_device sd where sd.produce_order = '静养'
</select>
+ <insert id="insertAudioFile">
+ insert into t_audio_group_file
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id !=null and id !=''">
+ id,
+ </if>
+ <if test="groupId !=null and groupId !=''">
+ group_id,
+ </if>
+ <if test="audioFile !=null and audioFile !=''">
+ audio_file,
+ </if>
+ <if test="defaults !=null">
+ `defaults`,
+ </if>
+ </trim>
+ <trim prefix=" values (" suffix=")" suffixOverrides=",">
+ <if test="id !=null and id !=''">
+ #{id},
+ </if>
+ <if test="groupId !=null and groupId !=''">
+ #{groupId},
+ </if>
+ <if test="audioFile !=null and audioFile !=''">
+ #{audioFile},
+ </if>
+ <if test="defaults !=null">
+ #{defaults},
+ </if>
+ </trim>
+ </insert>
+
+ <update id="updateAudioFile">
+ UPDATE t_audio_group_file
+ <set>
+ <trim suffixOverrides=",">
+ <if test="groupId !=null and groupId !=''">
+ group_id = #{groupId},
+ </if>
+ <if test="audioFile !=null and audioFile !=''">
+ audio_file = #{groupFile},
+ </if>
+ <if test="defaults !=null">
+ `defaults` = #{defaults},
+ </if>
+ </trim>
+ </set>
+ where id = #{id}
+ </update>
+
+ <delete id="deleteAudioFile">
+ delete from t_audio_group_file where groupId = #{groupId}
+ </delete>
+
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3