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" οnclick="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, status, e ) {
// If a local callback was specified, fire it
if ( s.error ) {
s.error.call( s.context || window, xhr, status, 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", [xml, s] );
} else
jQuery.handleError(s, xml, status);
} catch(e)
{
status = "error";
jQuery.handleError(s, xml, status, e);
}
// The request was completed
if( s.global )
jQuery.event.trigger( "ajaxComplete", [xml, 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, xml, null, 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, xml, null, 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, xhr, status, e ) {
// If a local callback was specified, fire it
if ( s.error ) {
s.error.call( s.context || window, xhr, status, e );
}
// Fire the global callback
if ( s.global ) {
(s.context ? jQuery(s.context) : jQuery.event).trigger( "ajaxError", [xhr, s, e] );
}
}
})