分页
来源：互联网 发布：爱奇艺自制网络剧破案 编辑：程序博客网 时间：2024/06/08 05:28
每页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" onclick="query()" style="width:60px; margin-right:20px" iconCls="icon-search"> 查询 </a></td> <td width="20%" align="left"> <a class="mini-button" onclick="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" onclick="dc();" style="width:100px;" id='qrSubmit'>导出</a> <a class="mini-button" onclick="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=0var 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"); //创建元素节点 trfor(var k=0;k<colname.length;k++){var cell = document.createElement("td");//创建元素节点 tdcell.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 pageBlockdocument.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>阅读全文
0 0
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 分页
- 安卓端使用plus.runtime.restart();出现白屏的解决方案
- docker server gave HTTP response to HTTPS client
- Python：快速排序算法
- 移动端android上line-height不居中的问题
- HDU 2066-一个人的旅行(Floyd任意两点最短路)
- 分页
- java集合
- 【bzoj3714】[PA2014]Kuglarz
- 动态更换地形纹理图
- expandableListview
- openwrt开发板串口测试总结
- 常用linux命令缩写的英文全称
- vue 子组件向父组件发送数据
- form 表单字段 autocomplete 设置为off 后仍然无效的解决方法
