dd0d2937c518cd6841b0034b9a67c02131ffdc2c..9bfd0f697d407902d9d80d95e5c23943a556b79f
2023-03-10 zhanghua
mysql5.7不能使用 with
9bfd0f 对比 | 目录
2023-03-10 zhanghua
Merge branch 'master' of http://42.193.1.25:9521/r/sccg_server
1cd453 对比 | 目录
2023-03-10 zhanghua
操作手册
f70314 对比 | 目录
3个文件已修改
1个文件已添加
15 ■■■■ 已修改文件
document/堡垒机-操作手册(1).docx 补丁 | 查看 | 原始文档 | blame | 历史
ycl-common/src/main/java/com/ycl/service/oss/impl/OssServiceImpl.java 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ycl-platform/src/main/java/com/ycl/service/video/impl/VideoAlarmReportServiceImpl.java 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
ycl-platform/src/main/resources/mapper/caseHandler/DisposeRecordMapper.xml 6 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
document/±¤ÀÝ»ú-²Ù×÷ÊÖ²á(1).docx
Binary files differ
ycl-common/src/main/java/com/ycl/service/oss/impl/OssServiceImpl.java
@@ -33,7 +33,7 @@
            // è°ƒç”¨oss的方法实现长传
            // ç¬¬ä¸€ä¸ªå‚æ•° bucketName
            // ç¬¬äºŒä¸ªå‚æ•° ä¸Šä¼ åˆ°oss的文件路径和文件名称
            ossClient.putObject(bucketName, fileName, new ByteArrayInputStream(file.getBytes()),objectMetadata);
            ossClient.putObject(bucketName, fileName, new ByteArrayInputStream(file.getBytes()), objectMetadata);
            // å…³é—­OSSClient。
            ossClient.shutdown();
            // æŠŠä¸Šä¼ çš„æ–‡ä»¶è·¯å¾„返回 ï¼ˆæ‰‹åŠ¨æ‹¼æŽ¥ï¼‰
@@ -82,16 +82,18 @@
            // è°ƒç”¨oss的方法实现长传
            // ç¬¬ä¸€ä¸ªå‚æ•° bucketName
            // ç¬¬äºŒä¸ªå‚æ•° ä¸Šä¼ åˆ°oss的文件路径和文件名称
            ossClient.putObject(bucketName, fileName, inputStream,objectMetadata);
            ossClient.putObject(bucketName, fileName, inputStream, objectMetadata);
            // å…³é—­OSSClient。
            ossClient.shutdown();
            // æŠŠä¸Šä¼ çš„æ–‡ä»¶è·¯å¾„返回 ï¼ˆæ‰‹åŠ¨æ‹¼æŽ¥ï¼‰
            // è¿™é‡Œè®¾ç½®å›¾ç‰‡æœ‰æ•ˆæ—¶é—´ æˆ‘设置了30å¹´
            Date expiration = new Date(System.currentTimeMillis() + 946080000 * 1000);
            String url = ossClient.generatePresignedUrl(bucketName, fileName, expiration).toString();
            // System.out.println("oss成功:" + url);
            return url;
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("oss异常:" + e.getMessage());
            // e.printStackTrace();
            return null;
        }
    }
ycl-platform/src/main/java/com/ycl/service/video/impl/VideoAlarmReportServiceImpl.java
@@ -145,7 +145,6 @@
//                æŒ‰ç…§Base64编码解析数据
                byte[] data = DatatypeConverter.parseBase64Binary(alarmParam.getPicData());
                InputStream inputStream = new ByteArrayInputStream(data);
                try {
//                    å¦‚æžœList<AlarmDataParam>合理
                    if (alarmParam.getAlarmData()!=null && alarmParam.getAlarmData().size()!=0) {
ycl-platform/src/main/resources/mapper/caseHandler/DisposeRecordMapper.xml
@@ -24,7 +24,7 @@
    </sql>
    <select id="selectMyBackList" resultType="com.ycl.vo.MyBacklogVO">
        with tmp as(
        select distinct * from (
        SELECT
        t3.event_source,
        t3.category,
@@ -63,7 +63,7 @@
                and t3.`code` LIKE CONCAT('%',#{code},'%')
            </if>
        </where>
        )
        select distinct * from tmp order by create_time
        ) as t
         order by create_time
    </select>
</mapper>