[#macro excExp id ="" name="" ]
|
<script type="text/javascript">
|
var staticUrl = '${base}';
|
</script>
|
<script language="javascript" src="${common_static}/static/plugins/print/LodopFuncs.js"></script>
|
<script language="javascript" src="${common_static}/static/plugins/export/js/shim.js"></script>
|
<script language="javascript" src="${common_static}/static/plugins/export/js/xlsx.full.min.js"></script>
|
<script language="javascript" src="${common_static}/static/plugins/export/js/Blob.js"></script>
|
<script language="javascript" src="${common_static}/static/plugins/export/js/FileSaver.js"></script>
|
<script language="javascript" src="${common_static}/static/plugins/export/js/swfobject.js"></script>
|
<script language="javascript" src="${common_static}/static/plugins/export/js/downloadify.min.js"></script>
|
<script language="javascript" src="${common_static}/static/plugins/export/js/base64.min.js"></script>
|
<script type="text/javascript" src="${common_static}/static/script/statis.js"></script>
|
<!--[if lte IE 9]>
|
<a id="export_btn" style="float:right" tableId="${id}" fn="${name}">Flash required</a>
|
<![endif]-->
|
<a class="common export" href="javascript:exportXlsById('${id}','${name}');"><span>导出</span></a>
|
<script type="text/javascript">
|
|
var LODOP; //声明为全局变量
|
|
//A4打印 type: 1=横向 2=纵向
|
function printA4(type, dom) {
|
LODOP = getLodop();
|
CreateOneFormPage(type, dom);
|
LODOP.PREVIEW();
|
}
|
|
function CreateOneFormPage(type, dom) {
|
var strStyleCSS = "<link href='${common_static}/static/ui/css/printa4-table.css' type='text/css' rel='stylesheet'>";
|
var strFormHtml = strStyleCSS + "<body>" + document.getElementById(dom).innerHTML + "</body>";
|
LODOP.SET_PRINT_PAGESIZE(type, 0, 0, "A4");
|
LODOP.SET_PRINT_STYLEA(1, "Angle", 90);
|
LODOP.ADD_PRINT_HTM("1.0cm", "0.5cm", "RightMargin:0.9cm", "BottomMargin:9mm", strFormHtml);
|
}
|
|
|
function exportXls(name) {
|
LODOP = getLodop();
|
LODOP.PRINT_INIT("");
|
LODOP.ADD_PRINT_TABLE(100, 20, 500, 80, document.documentElement.innerHTML);
|
LODOP.SET_SAVE_MODE("Orientation", 2); //Excel文件的页面设置：横向打印 1-纵向,2-横向;
|
LODOP.SET_SAVE_MODE("PaperSize", 9); //Excel文件的页面设置：纸张大小 9-对应A4
|
LODOP.SET_SAVE_MODE("Zoom", 90); //Excel文件的页面设置：缩放比例
|
LODOP.SET_SAVE_MODE("CenterHorizontally", true);//Excel文件的页面设置：页面水平居中
|
LODOP.SET_SAVE_MODE("CenterVertically", true); //Excel文件的页面设置：页面垂直居中
|
LODOP.SAVE_TO_FILE(name + ".xls");
|
}
|
|
function exportXlsById(id, name) {
|
if($.util.isEmpty(name)){
|
var title =$(".titleTr").text();
|
if($.util.isEmpty(title)){
|
name ="excel导出表"
|
}else{
|
name = title.trim();
|
}
|
}
|
name = name + ".xlsx";
|
export_table_to_excel(id,'xlsx',name);
|
}
|
function s2ab(s) {
|
if(typeof ArrayBuffer !== 'undefined') {
|
var buf = new ArrayBuffer(s.length);
|
var view = new Uint8Array(buf);
|
for (var i=0; i!=s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;
|
return buf;
|
} else {
|
var buf = new Array(s.length);
|
for (var i=0; i!=s.length; ++i) buf[i] = s.charCodeAt(i) & 0xFF;
|
return buf;
|
}
|
}
|
|
function export_table_to_excel(id, type, fn) {
|
var wb = XLSX.utils.table_to_book(document.getElementById(id), {sheet:"Sheet JS"});
|
var wbout = XLSX.write(wb, {bookType:type, bookSST:true, type: 'binary'});
|
if(fn){
|
var fname = fn || 'down.' + type;
|
try {
|
saveAs(new Blob([s2ab(wbout)],{type:"application/octet-stream;"}), fname);
|
} catch(e) {
|
if(typeof console != 'undefined') console.log(e, wbout);
|
}
|
}
|
return wbout;
|
}
|
</script>
|
<!--[if lte IE 9]>
|
<script type="text/javascript">
|
$(function(){
|
$(".common.export").remove();
|
var tableId = $("#export_btn").attr("tableId");
|
var fn = $("#export_btn").attr("fn")+".xlsx";
|
|
Downloadify.create('export_btn',{
|
swf: '${common_static}/static/plugins/export/media/downloadify.swf',
|
downloadImage: '${common_static}/static/plugins/export/images/download.png',
|
width: 85,
|
height: 24,
|
filename: fn, data: function() { var o = export_table_to_excel(tableId, 'xlsx'); return window.btoa(o); },
|
transparent: false,
|
append: false,
|
dataType: 'base64',
|
onComplete: function(){ top.layer.msg('保存成功!');},
|
onCancel: function(){ },
|
onError: function(){ top.layer.msg('出错了!'); }
|
});
|
})
|
</script>
|
<![endif]-->
|
[/#macro]
|
