每页20条,按单位大类分页,按单位子类分页,每页一个小计,最后一页总计,每个单位子类一小计,每个单位大类一小计
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page contentType="text/html; charset=utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>XXXXXXXXX明细报表</title>
<jsp:include page="/pages/include/mini.jsp"></jsp:include>
<script language="javascript" src="${pageContext.request.contextPath}/resource/scripts/lodopUtils.js"></script>
<object id="LODOP" classid="clsid:2105C259-1E0C-4534-8141-A753534CB4CA" width=0 height=0>
<param name="CompanyName" value="XXXXXXXXXXX" />
<param name="License" value="649717666688688748719056235623" />
</object>
<script language="javascript">
var LODOP = document.getElementById("LODOP");//这行语句是为了符合DTD规范
CheckLodop('/tljyb');
function create() {
LODOP.PRINT_INIT("");
if(all_page==0){
LODOP.ADD_PRINT_HTM(25,'0.8cm','98%',80, document.getElementById('head_div').innerHTML);//调用需打印的部分
LODOP.ADD_PRINT_HTM(100, "0.2cm", "98%", 800,document.getElementById('csh_body').outerHTML);
LODOP.SET_PRINT_STYLEA(0,"Vorient",0);
}else{
for(var i=1;i<=all_page;i++){
LODOP.NewPage();
// ADD_PRINT_HTM(intTop,intLeft,intWidth,intHeight,strHtml)增加超文本项
LODOP.ADD_PRINT_HTM(25,'0.8cm','98%',80, document.getElementById('head_div').innerHTML);//调用需打印的部分
LODOP.ADD_PRINT_HTM(100, "0.2cm", "98%", 800,document.getElementById('table'+i).outerHTML);
LODOP.SET_PRINT_STYLEA(0,"Vorient",0); //上边距和下边距同时锁定(中间拉伸)
LODOP.SET_PRINT_PAGESIZE(2,0,0,"A4");
LODOP.SET_SHOW_MODE("LANDSCAPE_DEFROTATED",1);
}
}
}
function print() {
create(); LODOP.PRINT();
}
function preview() {
create(); LODOP.PREVIEW();
}
</script>
</head>
<body style="overflow-y:auto;width:100%;margin:0px;padding:0px;">
<div id="form_criteria" style="width: 100%">
<fieldset>
<legend > 查询条件 </legend>
<table style="line-height: 13px;width: 100%">
<tr>
<td width="7%" align="right" >年月:</td>
<td width="22%" align="left" ><input id="ny" name="ny" class="mini-monthpicker" format="yyyyMM" allowInput="false" required="true" style="width:100%;" /></td>
<td width="20%" align="right" >
<a class="mini-button" οnclick="query()" style="width:60px; margin-right:20px" iconCls="icon-search"> 查询 </a></td>
<td width="20%" align="left">
<a class="mini-button" οnclick="resetForm()" style="width:60px;" iconCls="icon-cancel">重置</a></td>
<td width="30%" align="right" ></td>
</tr>
</table>
</fieldset>
</div>
<div id="from_div">
<fieldset>
<legend > 查询结果 </legend>
<div id="head_div">
<!--表头table -->
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0" style='font-family:宋体;font-size:10pt;'>
<tr> <th colspan="3" align="center" ><span style='font-family:宋体;font-size:16pt;'>医疗费统筹补助明细清单 </span></th></tr>
<tr>
<td width="30%" align="right" height="35"></td>
<td width="40%" align="center" id="sj"></td>
<td width="30%" align="left"></td>
</tr>
</table>
</div>
<div id="csh_body">
<style type="text/css">
.tdys {font-family:宋体;font-size:10pt;height:22px;text-align:center;border-left:1px solid #000000;border-bottom:1px solid #000000;padding:unset;}
.thys{font-family:宋体;font-size:10pt;text-align: center;height:22px;border-left:1px solid #000000;border-bottom:1px solid #000000;padding:unset;font-weight: bold;}
</style>
<!-- 初始化加载table -->
<table style='width:98%;margin-left:10px;border-top:1px solid #000000; border-right:1px solid #000000;padding:unset;border-collapse:collapse;'>
<tr>
<td rowspan="2" class="thys" style="width:5%;">序号</td>
<td rowspan="2" class="thys" >单位名称</td>
<td rowspan="2" class="thys" >开户银行</td>
<td rowspan="2" class="thys" >银行账号</td>
<td rowspan="2" class="thys" >总计</td>
<td colspan="2" class="thys" >在职</td>
<td colspan="2" class="thys" >退休</td>
<td rowspan="2" class="thys" >家床</td>
</tr>
<tr>
<td class="thys">住院</td>
<td class="thys">门诊大病</td>
<td class="thys">住院</td>
<td class="thys">门诊大病</td>
</tr>
<tr>
<td class="tdys">小计</td>
<td class="tdys"> 0 </td>
<td colspan="2" class="tdys"> </td>
<td class="tdys">0</td>
<td class="tdys">0</td>
<td class="tdys">0</td>
<td class="tdys">0</td>
<td class="tdys">0</td>
<td class="tdys">0</td>
</tr>
<tr>
<td class="tdys">合计</td>
<td class="tdys">0</td>
<td colspan="2" class="tdys"> </td>
<td class="tdys">0</td>
<td class="tdys">0</td>
<td class="tdys">0</td>
<td class="tdys">0</td>
<td class="tdys">0</td>
<td class="tdys">0</td>
</tr>
<tr><td colspan="10" id="zbsj" class="tdys"> </td></tr>
</table>
</div>
<div id="body_div"></div>
<div align="center" style="margin-top:10px;">
<a class="mini-button" οnclick="dc();" style="width:100px;" id='qrSubmit'>导出</a>
<a class="mini-button" οnclick="preview();" style="width:100px;" id='qrSubmit'>打印</a>
</div>
<form id="excelForm" method="post" target="excelIFrame">
<input type="hidden" name="ny1" id="ny1" />
<input type="hidden" name="className" value="bbttService"/>
</form>
<iframe id="excelIFrame" name="excelIFrame" style="display:none;" title="正在导出,请等待..."></iframe>
</fieldset>
</div>
<script type="text/javascript">
mini.parse();
var all_page=0; //初始化all_page=0
var form = new mini.Form("#form_criteria");
$(document).ready(function(){
getNowFormatDate()
});
function getNowFormatDate() {
var date = new Date();
var month = date.getMonth() + 1;
var rq = date.getDate();
//if (month >= 1 && month <= 9) {
// month = "0" + month;
//}
var tabTime = date.getFullYear() + "-" + month + "-" + rq;
var zb="第1页/总1页"+" 制表时间:"+tabTime;
document.getElementById("zbsj").innerHTML =zb;
}
function query() {
form.validate();
if (form.isValid() == false) return;
//表头时间 ”XXXX年XX月”
var ny=mini.get("ny").getFormValue();
var year=ny.substr(0,4);
var month=ny.substr(4,2);
document.getElementById("sj").innerHTML =year+' 年 '+month+' 月';
$("#body_div").html("");//清空body_div内容
$("#csh_body").hide();
var ny=mini.get("ny").getFormValue();
$.ajax({
url: "${pageContext.request.contextPath}/bbtj/queryBzmx.action",
type: "POST",
data: {ny:ny},
success: function (text){
var data = text["data"];
var dwlx_hz=text["dwlx_hz"];
var zj=text.zj;
var columns = ['xh','dwmc','khyh','yhzh','ybbhdje','zz_zy_bzje','zz_mz_dbbzje','tx_zy_bzje','tx_mz_dbbzje','jc_bzje'];
if(data.length==0){
$("#csh_body").show();
all_page=0;
}else{
$("#csh_body").hide();
$("#body_div").html("");
insertRowsIntoSpace(columns,data,"body_div",zj,dwlx_hz);
}
},
error : function (result){
var x=mini.decode(result.responseText).errors;
var y=x[0];
if(""==y["msg"])
mini.alert("失败");
else
mini.alert(y["msg"]);
}
});
}
function insertRowsIntoSpace(colname,data,divname,zj,dwlx_hz){
var i_arrNum=0;
var i_pagek=0;
all_page=0;
for(var pageBlock=0;pageBlock <dwlx_hz.length ;pageBlock++){
all_page+=Math.ceil(dwlx_hz[pageBlock]["dwmc"]/20);
}
for(var pageBlock=0;pageBlock < dwlx_hz.length;pageBlock++){
page=Math.ceil(dwlx_hz[pageBlock]["dwmc"]/20);
var css = "font-family:宋体;font-size:10pt;height:22px; text-align:center; border-left:1px solid #000000; border-bottom:1px solid #000000;padding:unset;";
var div = document.getElementById(divname);
for(var i=1;i<=page;i++){
var table = document.createElement("table");
table.id="table"+(i+i_pagek);
table.style.cssText = "width:98%;margin-left:10px;border-top:1px solid #000000; border-right:1px solid #000000;padding:unset;border-collapse:collapse;";
table.appendChild(headtr(1));table.appendChild(headtr(2));
var dwsl=0;
var ybbhdje=0.0;
var zz_zy_bzje=0.0;
var zz_mz_dbbzje=0.0;
var tx_zy_bzje=0.0;
var tx_mz_dbbzje=0.0;
var jc_bzje=0.0;
for(var j=0;j<20;j++){
var row = document.createElement("tr"); //创建元素节点 tr
for(var k=0;k<colname.length;k++){
var cell = document.createElement("td");//创建元素节点 td
cell.style.cssText = css;
var key = colname[k];
var value = data[(i-1)*20+j+i_arrNum][key];
cell.appendChild(document.createTextNode(value));
row.appendChild(cell);
if(key=='dwmc' )
dwsl++; //每页dwsl小计
if(key=="ybbhdje")
ybbhdje=(Number(ybbhdje)+Number(value)).toFixed(2); //每页ybbhdje小计
if(key=="zz_zy_bzje" )
zz_zy_bzje=(Number(zz_zy_bzje)+Number(value)).toFixed(2); //每页zz_zy_bzje小计
if(key=="zz_mz_dbbzje" )
zz_mz_dbbzje=(Number(zz_mz_dbbzje)+Number(value)).toFixed(2); //每页zz_mz_dbbzje小计
if(key=="tx_zy_bzje")
tx_zy_bzje=(Number(tx_zy_bzje)+Number(value)).toFixed(2); //每页tx_zy_bzje小计
if(key=="tx_mz_dbbzje" )
tx_mz_dbbzje=(Number(tx_mz_dbbzje)+Number(value)).toFixed(2); //每页tx_mz_dbbzje小计
if(key=="jc_bzje" )
jc_bzje=(Number(jc_bzje)+Number(value)).toFixed(2); //每页jc_bzje小计
}
table.appendChild(row);
if(((i-1)*20+j+1)==dwlx_hz[pageBlock]["dwmc"]) //等于data.length时,循环结束
break;
}
//20页——本页小计
var pagecount=document.createElement("tr");
var cell1 = document.createElement("td");
cell1.style.cssText = css; cell1.appendChild(document.createTextNode("小计"));//向节点添加最后一个子节点
pagecount.appendChild(cell1);
var cell2 = document.createElement("td");
cell2.style.cssText = css; cell2.appendChild(document.createTextNode(dwsl));
pagecount.appendChild(cell2);
var cell3 = document.createElement("td");
cell3.style.cssText = css; cell3.colSpan="2";
pagecount.appendChild(cell3);
var cell4 = document.createElement("td");
cell4.style.cssText = css; cell4.appendChild(document.createTextNode(ybbhdje));
pagecount.appendChild(cell4);
var cell5 = document.createElement("td");
cell5.style.cssText = css; cell5.appendChild(document.createTextNode(zz_zy_bzje));
pagecount.appendChild(cell5);
var cell6 = document.createElement("td");
cell6.style.cssText = css; cell6.appendChild(document.createTextNode(zz_mz_dbbzje));
pagecount.appendChild(cell6);
var cell7 = document.createElement("td");
cell7.style.cssText = css; cell7.appendChild(document.createTextNode(tx_zy_bzje));
pagecount.appendChild(cell7);
var cell8 = document.createElement("td");
cell8.style.cssText = css; cell8.appendChild(document.createTextNode(tx_mz_dbbzje));
pagecount.appendChild(cell8);
var cell9 = document.createElement("td");
cell9.style.cssText = css; cell9.appendChild(document.createTextNode(jc_bzje));
pagecount.appendChild(cell9);
table.appendChild(pagecount);
//单位页码块,最后一页,单位小计
if(i==page){
var allcount=document.createElement("tr");
var l1 = document.createElement("td");
l1.style.cssText = css; l1.appendChild(document.createTextNode(dwlx_hz[pageBlock]["xh"]));
allcount.appendChild(l1);
var l2 = document.createElement("td");
l2.style.cssText = css; l2.appendChild(document.createTextNode(dwlx_hz[pageBlock]["dwmc"]));
allcount.appendChild(l2);
var l3 = document.createElement("td");
l3.style.cssText = css; l3.colSpan="2";
allcount.appendChild(l3);
var l4 = document.createElement("td");
l4.style.cssText = css; l4.appendChild(document.createTextNode(dwlx_hz[pageBlock]["ybbhdje"]));
allcount.appendChild(l4);
var l5 = document.createElement("td");
l5.style.cssText = css; l5.appendChild(document.createTextNode(dwlx_hz[pageBlock]["zz_zy_bzje"]));
allcount.appendChild(l5);
var l6 = document.createElement("td");
l6.style.cssText = css; l6.appendChild(document.createTextNode(dwlx_hz[pageBlock]["zz_mz_dbbzje"]));
allcount.appendChild(l6);
var l7 = document.createElement("td");
l7.style.cssText = css; l7.appendChild(document.createTextNode(dwlx_hz[pageBlock]["tx_zy_bzje"]));
allcount.appendChild(l7);
var l8 = document.createElement("td");
l8.style.cssText = css; l8.appendChild(document.createTextNode(dwlx_hz[pageBlock]["tx_mz_dbbzje"]));
allcount.appendChild(l8);
var l9 = document.createElement("td");
l9.style.cssText = css; l9.appendChild(document.createTextNode(dwlx_hz[pageBlock]["jc_bzje"]));
allcount.appendChild(l9);
table.appendChild(allcount);
/*------------------------------此模块处理有单位子类数据,,对单位大类的汇总--------------------------------------------*/
//定位到此单位大类下,最大子类
var p_jsxh=Number(i_arrNum)+Number(dwlx_hz[pageBlock]["dwmc"])-1;
var max=99;
for(var x=0;x < dwlx_hz.length;x++){
if(dwlx_hz[x]["dwdl"]==data[p_jsxh]["dwlx"].substr(0,1) && dwlx_hz[x]["max_flag"]=="0"){
max=dwlx_hz[x]["dwlx"];
}
}
if(data[p_jsxh]["dwlx"]==max){
//循环累加金额
var dwsl=0;
var ybbhdje=0.0;
var zz_zy_bzje=0.0;
var zz_mz_dbbzje=0.0;
var tx_zy_bzje=0.0;
var tx_mz_dbbzje=0.0;
var jc_bzje=0.0;
var dwdlsm="";
for(var x=0;x < dwlx_hz.length;x++){
if(dwlx_hz[x]["dwdl"]==max.substr(0,1)){
dwsl=(Number(dwsl)+Number(dwlx_hz[x]["dwmc"]));
ybbhdje=(Number(ybbhdje)+Number(dwlx_hz[x]["ybbhdje"])).toFixed(2);
zz_zy_bzje=(Number(zz_zy_bzje)+Number(dwlx_hz[x]["zz_zy_bzje"])).toFixed(2);
zz_mz_dbbzje=(Number(zz_mz_dbbzje)+Number(dwlx_hz[x]["zz_mz_dbbzje"])).toFixed(2);
tx_zy_bzje=(Number(tx_zy_bzje)+Number(dwlx_hz[x]["tx_zy_bzje"])).toFixed(2);
tx_mz_dbbzje=(Number(tx_mz_dbbzje)+Number(dwlx_hz[x]["tx_mz_dbbzje"])).toFixed(2);
jc_bzje=(Number(jc_bzje)+Number(dwlx_hz[x]["jc_bzje"])).toFixed(2);
dwdlsm=dwlx_hz[x]["dwdlsm"];
}
}
var allcount=document.createElement("tr");
var l1 = document.createElement("td");
l1.style.cssText = css; l1.appendChild(document.createTextNode(dwdlsm));
allcount.appendChild(l1);
var l2 = document.createElement("td");
l2.style.cssText = css; l2.appendChild(document.createTextNode(dwsl));
allcount.appendChild(l2);
var l3 = document.createElement("td");
l3.style.cssText = css; l3.colSpan="2";
allcount.appendChild(l3);
var l4 = document.createElement("td");
l4.style.cssText = css; l4.appendChild(document.createTextNode(ybbhdje));
allcount.appendChild(l4);
var l5 = document.createElement("td");
l5.style.cssText = css; l5.appendChild(document.createTextNode(zz_zy_bzje));
allcount.appendChild(l5);
var l6 = document.createElement("td");
l6.style.cssText = css; l6.appendChild(document.createTextNode(zz_mz_dbbzje));
allcount.appendChild(l6);
var l7 = document.createElement("td");
l7.style.cssText = css; l7.appendChild(document.createTextNode(tx_zy_bzje));
allcount.appendChild(l7);
var l8 = document.createElement("td");
l8.style.cssText = css; l8.appendChild(document.createTextNode(tx_mz_dbbzje));
allcount.appendChild(l8);
var l9 = document.createElement("td");
l9.style.cssText = css; l9.appendChild(document.createTextNode(jc_bzje));
allcount.appendChild(l9);
table.appendChild(allcount);
}/*else{
alert("未进入");
}*/
/*----------------------------------------------------------------------------------------------------------------------------------------*/
}
//总页码--最后一页--“总计”
if((i_pagek+i)==all_page){
var zj_Row=document.createElement("tr");
var total1 = document.createElement("td");
total1.style.cssText = css; total1.appendChild(document.createTextNode("总计"));
zj_Row.appendChild(total1);
var total2 = document.createElement("td");
total2.style.cssText = css; total2.appendChild(document.createTextNode(zj["dwmc"]));
zj_Row.appendChild(total2);
var total3 = document.createElement("td");
total3.style.cssText = css; total3.colSpan="2";
zj_Row.appendChild(total3);
var total4 = document.createElement("td");
total4.style.cssText = css; total4.appendChild(document.createTextNode(zj["ybbhdje"]));
zj_Row.appendChild(total4);
var total5 = document.createElement("td");
total5.style.cssText = css; total5.appendChild(document.createTextNode(zj["zz_zy_bzje"]));
zj_Row.appendChild(total5);
var total6 = document.createElement("td");
total6.style.cssText = css; total6.appendChild(document.createTextNode(zj["zz_mz_dbbzje"]));
zj_Row.appendChild(total6);
var total7 = document.createElement("td");
total7.style.cssText = css; total7.appendChild(document.createTextNode(zj["tx_zy_bzje"]));
zj_Row.appendChild(total7);
var total8 = document.createElement("td");
total8.style.cssText = css; total8.appendChild(document.createTextNode(zj["tx_mz_dbbzje"]));
zj_Row.appendChild(total8);
var total9 = document.createElement("td");
total9.style.cssText = css; total9.appendChild(document.createTextNode(zj["jc_bzje"]));
zj_Row.appendChild(total9);
table.appendChild(zj_Row);
}
//页尾--页码处理
var date = new Date(); var month = date.getMonth() + 1; var rq = date.getDate();
var tabTime = " 制表时间: "+date.getFullYear() + "-" + month + "-" + rq;
var pnum=document.createElement("tr");
var c0 = document.createElement("td");
c0.style.cssText =css; c0.colSpan="10"; c0.appendChild(document.createTextNode("第 "+ (i_pagek+i) +"页 /"+"共 "+all_page+" 页 "+tabTime));
pnum.appendChild(c0);
table.appendChild(pnum);
div.appendChild(table);
//新建一个table,作用间隔每页内容
var table2 = document.createElement("table");
table2.id="tabletime"+i;
table2.style.cssText = "width:98%; border:0;cellspacing:0;";
var pnum=document.createElement("tr");
var c0 = document.createElement("td");
c0.style.cssText ="font-family:宋体;font-size:10pt;text-align:center;height:35px; border-style: none;";
c0.colSpan="10"; c0.appendChild(document.createTextNode(""));
pnum.appendChild(c0);
table2.appendChild(pnum);
div.appendChild(table2);
}
i_arrNum=Number(i_arrNum)+Number(dwlx_hz[pageBlock]["dwmc"]);
i_pagek+=page;
}//FOR pageBlock
document.getElementById(divname).innerHTML=div.innerHTML;
}
function headtr(rowNum){
var tr1 = document.createElement("tr");
var csstd ="font-family:宋体;font-size:10pt;text-align: center;height:22px;font-weight: bold; border-left:1px solid #000000; border-bottom:1px solid #000000;padding:unset;";
if(rowNum==1){
var cell1 = document.createElement("td");
cell1.style.cssText=csstd; cell1.rowSpan="2"; cell1.width="4%"; cell1.appendChild(document.createTextNode("序号"));
tr1.appendChild(cell1);
var cell2 = document.createElement("td");
cell2.style.cssText=csstd; cell2.rowSpan="2"; cell2.width="19%"; cell2.appendChild(document.createTextNode("单位名称"));
tr1.appendChild(cell2);
var cell3 = document.createElement("td");
cell3.style.cssText=csstd; cell3.rowSpan="2"; cell3.width="15%"; cell3.appendChild(document.createTextNode("开户银行"));
tr1.appendChild(cell3);
var cell4 = document.createElement("td");
cell4.style.cssText =csstd; cell4.rowSpan="2"; cell4.width="12%"; cell4.appendChild(document.createTextNode("银行账号"));
tr1.appendChild(cell4);
var cell5 = document.createElement("td");
cell5.style.cssText=csstd; cell5.rowSpan="2"; cell5.width="7%"; cell5.appendChild(document.createTextNode("总计"));
tr1.appendChild(cell5);
var cell6 = document.createElement("td");
cell6.style.cssText=csstd; cell6.colSpan="2"; cell6.appendChild(document.createTextNode("在职"));
tr1.appendChild(cell6);
var cell7 = document.createElement("td");
cell7.style.cssText =csstd; cell7.colSpan="2"; cell7.appendChild(document.createTextNode("退休"));
tr1.appendChild(cell7);
var cell8 = document.createElement("td");
cell8.style.cssText=csstd; cell8.rowSpan="2"; cell8.width="5%"; cell8.appendChild(document.createTextNode("家床"));
tr1.appendChild(cell8);
}
if(rowNum==2){
var cell9 = document.createElement("td");
cell9.style.cssText =csstd; cell9.width="7%"; cell9.appendChild(document.createTextNode("住院"));
tr1.appendChild(cell9);
var cell10 = document.createElement("td");
cell10.style.cssText=csstd; cell10.width="7%"; cell10.appendChild(document.createTextNode("门诊大病"));
tr1.appendChild(cell10);
var cell11 = document.createElement("td");
cell11.style.cssText=csstd; cell11.width="7%"; cell11.appendChild(document.createTextNode("住院"));
tr1.appendChild(cell11);
var cell12 = document.createElement("td");
cell12.style.cssText=csstd; cell12.width="7%"; cell12.appendChild(document.createTextNode("门诊大病"));
tr1.appendChild(cell12);
}
return tr1;
}
//重置
function resetForm(){
form.reset();
}
//导出
function dc(){
form.validate();
if (form.isValid() == false) return;
var ny=mini.get("ny").getFormValue();
var excelForm = document.getElementById("excelForm");
document.getElementById("ny1").value = ny;
excelForm.action="${pageContext.request.contextPath}/bbtj/dc_Mxbb.action";
excelForm.submit();
}
</script>
</body>
</html>