fix : MySQL=》DMSQL

cy

2022-06-23 b83c40548208609d0d6826be13d742c28a784806

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
[#macro newupload id="" name=id multiple="false" allowTypes="*.gif; *.jpg; *.png; *.ppt;  *.doc; *.xls; *.txt; *.xlsx; *.docx; *.pptx" fileSizeLimit="10000K" values=[]]
<script src="${base}/static/plugins/uploadify/jquery.uploadify.min.js" type="text/javascript" charset="UTF-8"></script>
<link rel="stylesheet" type="text/css" href="${common_static}/static/plugins/uploadify/uploadify.css">
<style>
    .hid {
        display:none;
    }
    .upload_file{
        position:relative;
    }
    .upload_file a.file_btn, .upload_file #file{
        position:absolute;
        left:0;
        top:0;
        z-index:0;
    }
    .upload_file #file{
        z-index:1;
    }
</style>
<script type="text/javascript">
 
 
    $(function(){
        $("#${id}_files").uploadify({
            height        : 25,
            width         : 70,
            removeTimeout:0,
            buttonText :"",
            buttonClass :"hid",
            //wmode :"transparent",
            buttonImage :"${common_static}/static/images/uploadfileBtnBg.gif",
            queueSizeLimit:10,
            swf           : '${base}/static/plugins/uploadify/uploadify.swf',
            uploader      : '${base}/interface/fileupload/upload.html',
            fileTypeExts : '${allowTypes}',
            fileSizeLimit : '${fileSizeLimit}',
            onUploadSuccess : function(file, data, response){
                var data =  JSON.parse(data);
                var filename =  data.FILE_NAME.substring(0,17)+"...";
                var html = '<li>'+
                        '<input type="hidden" name="FILE_ID" value="" />'+
                        '<input type="hidden" name="EXT_NAME" value="'+ data.EXT_NAME +'" />'+
                        '<input type="hidden" name="FIELD_NAME" value="'+ data.FIELD_NAME +'" />'+
                        '<input type="hidden" name="FILE_PATH" value="'+ data.FILE_PATH +'" />'+
                        '<input type="hidden" name="FILE_SIZE" value="'+ data.FILE_SIZE +'" />'+
                        '<input type="hidden" name="FILE_NAME" value="'+ data.FILE_NAME +'" />'+
                        '<span><a target="_blank" href="${base}'+data.FILE_PATH+'" title="'+data.FILE_NAME+'">'+ filename +'</a></span>'+
                        '<input type="text" name="FILE_NOTE" value="" style="display:none;">'+
                        '<a class="blue_txt">删除</a>'+
                        '</li>';
                $("#fileList").append(html);
            }
        });
 
        $(".blue_txt").live("click",function() {
            var dom = $(this);
            confirmInfo('提示', '确定要删除吗？', function(){
                dom.parent().remove();
            })
        });
    });
</script>
<input type="file" name="${id}_files" multiple id="${id}_files" value=""/>
<ul id="fileList" class="file_list">
    [#list values as d]
        <li>
            <input type="hidden" name="FILE_ID" value="${d.ID}" />
            <input type="hidden" name="EXT_NAME" value="${d.FILE_FORMAT}" />
            <input type="hidden" name="FIELD_NAME" value="${d.FIELD_NAME}" />
            <input type="hidden" name="FILE_PATH" value="${d.FILE_PATH}" />
            <input type="hidden" name="FILE_SIZE" value="${d.FILE_SIZE}" />
            <input type="hidden" name="FILE_NAME" value="${d.FILE_NAME}" />
            <span><a target="_blank" href="${base+d.FILE_PATH}" title="${d.FILE_NAME}">${left(d.FILE_NAME,30)}</a></span>
            <input type="text" name="FILE_NOTE" value="${d.FILE_NOTE}"  style="display:none;" >
            <a class="blue_txt">删除</a>
        </li>
    [/#list]
</ul>
[/#macro]