广播

张晓波

2023-12-06 e8925583e893a0d966024905afe3cddd6bfbe5d1

广播

 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();
    }
}

 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;
}

 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;
}

 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);
}

 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);
        }
    }
}

 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);
}

 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>