html：
<div class="page-content"> <div class="page-header"> <h1> 订奶管理 <small> <i class="icon-double-angle-right"></i> 导入订奶 </small> </h1> </div><!-- /.page-header --> <script type="text/javascript" src="/js/ajaxfileupload.js"></script> <div class="alert alert-danger" role="alert"> <span class="red">为保证<span class="blue">顺利</span>导入数据，请使用<span class="blue">word2003</span>标准格式</span><br> <span class="red">文件大小不能超过<span class="blue">1M</span></span><br> <span class="red">内容格式请<span class="blue">严格</span>遵守 模板格式。</span><br> <span class="red">正式内容不能包含非法字符、函数、注释、颜色等</span><br> <span class="red">如导入失败，请仔细检查以上几条..</span> </div> <div class="col-sm-12"> <form action="/wxbackend/milk/importExcel" method="post" enctype="multipart/form-data"> <div class="widget-main" style="width:580px;margin:0;padding:0;"> <input type="file" name="excelFile" id="excelFile" > </div> <button type="button" id="submit" onclick="ajaxFileUpload()" class="btn btn-info"><i class="icon-ok bigger-110"></i>导入</button> <a href="javascript: window.location.reload()" id="refersh" class="btn btn-inverse"><span class="glyphicon glyphicon-refresh"></span> 刷新页面</a> <img id="loading" src="/images/loading.gif" style="display:none;"> </form> </div> </div>
JS：
<script type="text/javascript">
jQuery(function($) {
$('#excelFile').ace_file_input({
no_file:'请选择Excel文件..',btn_choose:'Choose',btn_change:'Change',droppable:false,onchange:null,thumbnail:false,//| true | large
//whitelist:'jpg|jpeg',//blacklist:'exe|PHP|dll',//onchange:''
//
});
});
function ajaxFileUpload(){
var excelFile = $('#excelFile').val();
if(excelFile == '') {
alert('请选择Excel文件..');
return false;
}
if(excelFile.lastIndexOf('.') > 0) {
var ext = excelFile.substr(excelFile.lastIndexOf('.')+1);
if(!(ext == 'xls')){
alert('请选择Excel类型文件..');
return false
}
}
/**
$("#loading")
.ajaxStart(function(){
$(this).show();
})
.ajaxComplete(function(){
$(this).hide();
});*/
$("#loading").show();
document.getElementById('submit').disabled = true;
document.getElementById('refersh').disabled = true;
$.ajaxFileUpload(
{
url:'/wxbackend/milk/importExcel',secureuri:false,fileElementId:'excelFile',dataType: 'text',success: function (data){
$("#loading").hide();
if(data.substr(0,2) == '99') {
var row = data.substring(3,data.length);
data = '99';
info = '文件导入错误，数据不完整或含有非法字符，请检查后再试，Excel第 '+row+' 行';
}
switch (data){
case '0':
alert('文件类型错误，请使用word2003兼容格式');
break;
case '-1':
alert('网络错误，请在网络良好的情况下再试');
break;
case '99':
alert(info);
break;
case '-2':
alert('文件没有读取权限，请联系管理员');
break;
case '-3':
alert('非法上传！！');
break;
case '-4':
alert('文件内容格式不正确，请严格按照模板文件');
break;
case '-4':
alert('文件大小不能超过1M');
break;
case '1':
alert('导入成功，订奶用户下去查看');
break;
default :
alert('导入失败，未知错误，请联系管理员');
break;
}
if(data == '1')
window.location.href="/wxbackend/milk/milkOrderList?is_import=1";
else window.location.reload();
},error: function (data,status,e){
$("#loading").hide();
document.getElementById('submit').disabled = false;
document.getElementById('refersh').disabled = false;
alert(e);
window.location.reload();
}
}
)
return false;
}
</script>
注意：
高版本的jquery 已没有handleError 方法 所以在ajaxfileupload.js的uploadHttpData方法后面加上：
handleError: function( s,xhr,e ) {
// If a local callback was specified,fire it
if ( s.error ) {
s.error.call( s.context || window,e );
}
// Fire the global callback
if ( s.global ) {
(s.context ? jQuery(s.context) : jQuery.event).trigger( "ajaxError",[xhr,s,e] );
}
}
即可
ajaxfileupload.js：
jQuery.extend({
createUploadIframe: function(id,uri)
{
//create frame
var frameId = 'jUploadFrame' + id;
var iframeHtml = '<iframe id="' + frameId + '" name="' + frameId + '" style="position:absolute; top:-9999px; left:-9999px"';
if(window.ActiveXObject)
{
if(typeof uri== 'boolean'){
iframeHtml += ' src="' + 'javascript:false' + '"';
}
else if(typeof uri== 'string'){
iframeHtml += ' src="' + uri + '"';
}
}
iframeHtml += ' />';
jQuery(iframeHtml).appendTo(document.body);
return jQuery('#' + frameId).get(0);
},createUploadForm: function(id,fileElementId,data)
{
//create form
var formId = 'jUploadForm' + id;
var fileId = 'jUploadFile' + id;
var form = jQuery('<form action="" method="POST" name="' + formId + '" id="' + formId + '" enctype="multipart/form-data"></form>');
if(data)
{
for(var i in data)
{
jQuery('<input type="hidden" name="' + i + '" value="' + data[i] + '" />').appendTo(form);
}
}
var oldElement = jQuery('#' + fileElementId);
var newElement = jQuery(oldElement).clone();
jQuery(oldElement).attr('id',fileId);
jQuery(oldElement).before(newElement);
jQuery(oldElement).appendTo(form);
//set attributes
jQuery(form).css('position','absolute');
jQuery(form).css('top','-1200px');
jQuery(form).css('left','-1200px');
jQuery(form).appendTo('body');
return form;
},ajaxFileUpload: function(s) {
// TODO introduce global settings,allowing the client to modify them for all requests,not only timeout
s = jQuery.extend({},jQuery.ajaxSettings,s);
var id = new Date().getTime()
var form = jQuery.createUploadForm(id,s.fileElementId,(typeof(s.data)=='undefined'?false:s.data));
var io = jQuery.createUploadIframe(id,s.secureuri);
var frameId = 'jUploadFrame' + id;
var formId = 'jUploadForm' + id;
// Watch for a new set of requests
if ( s.global && ! jQuery.active++ )
{
jQuery.event.trigger( "ajaxStart" );
}
var requestDone = false;
// Create the request object
var xml = {}
if ( s.global )
jQuery.event.trigger("ajaxSend",[xml,s]);
// Wait for a response to come back
var uploadCallback = function(isTimeout)
{
var io = document.getElementById(frameId);
try
{
if(io.contentWindow)
{
xml.responseText = io.contentWindow.document.body?io.contentWindow.document.body.innerHTML:null;
xml.responseXML = io.contentWindow.document.XMLDocument?io.contentWindow.document.XMLDocument:io.contentWindow.document;
}else if(io.contentDocument)
{
xml.responseText = io.contentDocument.document.body?io.contentDocument.document.body.innerHTML:null;
xml.responseXML = io.contentDocument.document.XMLDocument?io.contentDocument.document.XMLDocument:io.contentDocument.document;
}
}catch(e)
{
jQuery.handleError(s,xml,null,e);
}
if ( xml || isTimeout == "timeout")
{
requestDone = true;
var status;
try {
status = isTimeout != "timeout" ? "success" : "error";
// Make sure that the request was successful or notmodified
if ( status != "error" )
{
// process the data (runs the xml through httpData regardless of callback)
var data = jQuery.uploadHttpData( xml,s.dataType );
// If a local callback was specified,fire it and pass it the data
if ( s.success )
s.success( data,status );
// Fire the global callback
if( s.global )
jQuery.event.trigger( "ajaxSuccess",s] );
} else
jQuery.handleError(s,status);
} catch(e)
{
status = "error";
jQuery.handleError(s,e);
}
// The request was completed
if( s.global )
jQuery.event.trigger( "ajaxComplete",s] );
// Handle the global AJAX counter
if ( s.global && ! --jQuery.active )
jQuery.event.trigger( "ajaxStop" );
// Process result
if ( s.complete )
s.complete(xml,status);
jQuery(io).unbind()
setTimeout(function()
{ try
{
jQuery(io).remove();
jQuery(form).remove();
} catch(e)
{
jQuery.handleError(s,e);
}
},100)
xml = null
}
}
// Timeout checker
if ( s.timeout > 0 )
{
setTimeout(function(){
// Check to see if the request is still happening
if( !requestDone ) uploadCallback( "timeout" );
},s.timeout);
}
try
{
var form = jQuery('#' + formId);
jQuery(form).attr('action',s.url);
jQuery(form).attr('method','POST');
jQuery(form).attr('target',frameId);
if(form.encoding)
{
jQuery(form).attr('encoding','multipart/form-data');
}
else
{
jQuery(form).attr('enctype','multipart/form-data');
}
jQuery(form).submit();
} catch(e)
{
jQuery.handleError(s,e);
}
jQuery('#' + frameId).load(uploadCallback );
return {abort: function () {}};
},uploadHttpData: function( r,type ) {
var data = !type;
data = type == "xml" || data ? r.responseXML : r.responseText;
// If the type is "script",eval it in global context
if ( type == "script" )
jQuery.globalEval( data );
// Get the JavaScript object,if JSON is used.
if ( type == "json" )
eval( "data = " + data );
// evaluate scripts within html
if ( type == "html" )
jQuery("<div>").html(data).evalScripts();
return data;
},handleError: function( s,e] );
}
}
})
