播放计划列表

zhanzhiqin

2022-04-18 9157a7cd26d7a82a065e7afdc9b1ddfc6a62250b

播放计划列表

 dao/src/main/java/com/sandu/ximon/dao/domain/LEDProgramFile.java

@@ -4,12 +4,15 @@
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;

import java.io.Serializable;
import java.time.LocalDateTime;

import lombok.Data;

/**
 * LED节目表
 *
 * @TableName led_program_file
 */
@TableName(value ="led_program_file")
@@ -29,6 +32,11 @@
    /**
     * 
     */
    private Long clientId;

    /**
     *
     */
    private String userName;

    /**

 dao/src/main/java/com/sandu/ximon/dao/domain/LedSFile.java

@@ -4,12 +4,15 @@
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;

import java.io.Serializable;
import java.time.LocalDateTime;

import lombok.Data;

/**
 * led熙讯文件表
 *
 * @TableName led_s_file
 */
@TableName(value ="led_s_file")
@@ -24,6 +27,11 @@
    /**
     * 客户ID
     */
    private Long userId;

    /**
     * 上级客户ID
     */
    private Long cilentId;

    /**

 dao/src/main/resources/mapper/LEDProgramFileMapper.xml

@@ -7,6 +7,7 @@
    <resultMap id="BaseResultMap" type="com.sandu.ximon.dao.domain.LEDProgramFile">
            <id property="id" column="id" jdbcType="BIGINT"/>
            <result property="userId" column="user_id" jdbcType="BIGINT"/>
        <result property="clientId" column="client_id" jdbcType="BIGINT"/>
            <result property="userName" column="user_name" jdbcType="VARCHAR"/>
            <result property="name" column="name" jdbcType="VARCHAR"/>
            <result property="size" column="size" jdbcType="VARCHAR"/>
@@ -17,11 +18,4 @@
            <result property="kind" column="kind" jdbcType="INTEGER"/>
            <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
    </resultMap>

    <sql id="Base_Column_List">
        id,user_id,user_name,
        name,size,file_type,
        file_url,screen_shot,md5,
        kind,create_time
    </sql>
</mapper>

 dao/src/main/resources/mapper/LedSFileMapper.xml

@@ -6,6 +6,7 @@

    <resultMap id="BaseResultMap" type="com.sandu.ximon.dao.domain.LedSFile">
        <id property="fileId" column="file_id" jdbcType="BIGINT"/>
        <result property="userId" column="user_id" jdbcType="BIGINT"/>
        <result property="cilentId" column="cilent_id" jdbcType="BIGINT"/>
        <result property="userName" column="user_name" jdbcType="VARCHAR"/>
        <result property="originName" column="origin_name" jdbcType="VARCHAR"/>
@@ -19,11 +20,4 @@
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
    </resultMap>

    <sql id="Base_Column_List">
        file_id
        ,cilent_id,user_name,
        origin_name,file_url,file_type,
        file_size,height,width,
        create_time
    </sql>
</mapper>

 ximon-admin/src/main/java/com/sandu/ximon/admin/controller/LEDProgramFileController.java

@@ -44,11 +44,13 @@
        if (!permissionConfig.check(MenuEnum.LED_FILE_LIST.getCode())) {
            return ResponseUtil.fail("缺少对应用户权限");
        }
        PageHelper.startPage(baseConditionVO.getPageNo(), baseConditionVO.getPageSize());

        LambdaQueryWrapper<LEDProgramFile> wrapper = ledProgramFileService.listFile();
        if(null!=keyword){
        if (!keyword.isEmpty()) {
            wrapper.like(LEDProgramFile::getName,keyword);
        }

        PageHelper.startPage(baseConditionVO.getPageNo(), baseConditionVO.getPageSize());
        return ResponseUtil.successPage(ledProgramFileService.list(wrapper));
    }


 ximon-admin/src/main/java/com/sandu/ximon/admin/controller/LedSFileController.java

@@ -52,11 +52,12 @@
        if (!permissionConfig.check(MenuEnum.LED_FILE_LIST.getCode())) {
            return ResponseUtil.fail("缺少对应用户权限");
        }
        PageHelper.startPage(baseConditionVO.getPageNo(), baseConditionVO.getPageSize());
        LambdaQueryWrapper<LedSFile> wrapper = ledProgramFileService.listFile();
        if (null != keyword) {
        if (!keyword.isEmpty()) {
            wrapper.like(LedSFile::getOriginName, keyword);
        }

        PageHelper.startPage(baseConditionVO.getPageNo(), baseConditionVO.getPageSize());
        return ResponseUtil.success(ledProgramFileService.list(wrapper));
    }


 ximon-admin/src/main/java/com/sandu/ximon/admin/service/LEDProgramFileService.java

@@ -43,7 +43,9 @@
    public LambdaQueryWrapper<LEDProgramFile> listFile() {
        LambdaQueryWrapper<LEDProgramFile> ledProgramFileLambdaQueryWrapper = Wrappers.lambdaQuery(LEDProgramFile.class);
        if (SecurityUtils.getClientId() != null) {
            return ledProgramFileLambdaQueryWrapper.eq(LEDProgramFile::getUserId, SecurityUtils.getUserId());
            return ledProgramFileLambdaQueryWrapper.eq(LEDProgramFile::getUserId, SecurityUtils.getUserId()).or(w -> {
                w.eq(LEDProgramFile::getClientId, SecurityUtils.getUserId());
            });
        } else {
            return ledProgramFileLambdaQueryWrapper;
        }

 ximon-admin/src/main/java/com/sandu/ximon/admin/service/LedSFileService.java

@@ -60,7 +60,9 @@
    public LambdaQueryWrapper<LedSFile> listFile(){
        LambdaQueryWrapper<LedSFile> ledProgramFileLambdaQueryWrapper = Wrappers.lambdaQuery(LedSFile.class);
        if(SecurityUtils.getClientId()!=null){
            return ledProgramFileLambdaQueryWrapper.eq(LedSFile::getCilentId,SecurityUtils.getUserId());
            return ledProgramFileLambdaQueryWrapper.eq(LedSFile::getCilentId, SecurityUtils.getUserId()).or(w -> {
                w.eq(LedSFile::getUserId, SecurityUtils.getUserId());
            });
        }else {
            return ledProgramFileLambdaQueryWrapper;
        }