year-actual-water-summary-list.jsp 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  2. <html>
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  5. <title>年度实际用水汇总信息列表</title>
  6. <!--框架必需start-->
  7. <script type="text/javascript" src="${ctx}/qui/libs/js/jquery.js"></script>
  8. <script type="text/javascript" src="${ctx}/qui/libs/js/framework.js"></script>
  9. <link href="${ctx}/qui/libs/css/import_basic.css" rel="stylesheet"
  10. type="text/css" />
  11. <link rel="stylesheet" type="text/css" id="skin" prePath="${ctx}/qui/" />
  12. <link rel="stylesheet" type="text/css" id="customSkin" />
  13. <!--框架必需end-->
  14. <!--数据表格start-->
  15. <script src="${ctx}/qui/libs/js/table/quiGrid.js" type="text/javascript"></script>
  16. <!--数据表格end-->
  17. <!--箭头分页start-->
  18. <script type="text/javascript" src="${ctx}/qui/libs/js/nav/pageArrow.js"></script>
  19. <!--箭头分页end-->
  20. <!--表单异步提交start-->
  21. <script src="${ctx}/qui/libs/js/form/form.js" type="text/javascript"></script>
  22. <!--表单异步提交end-->
  23. <!-- 日期选择框start -->
  24. <script type="text/javascript"
  25. src="${ctx}/qui/libs/js/form/datePicker/WdatePicker.js"></script>
  26. <!-- 日期选择框end -->
  27. <script type="text/javascript">
  28. var g_pageNo = 1;
  29. var g_pageSize = 10;
  30. var total_rows=0;
  31. //数据表格使用
  32. var g;
  33. var gridData;
  34. function initComplete(){
  35. g = $("#maingrid").quiGrid({
  36. columns: [
  37. { display: '单位编号', name: 'orgNumber', align: 'center', width: "7%"},
  38. { display: '单位名称', name: 'orgName', align: 'center', width: "12%",
  39. render:function(rowdata, rowindex, value, column){
  40. return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
  41. }
  42. },
  43. { display: '单位地址', name: 'address', align: 'center', width: "12%",
  44. render:function(rowdata, rowindex, value, column){
  45. return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
  46. }
  47. },
  48. { display: '年度', name: 'year', align: 'center', width: "5%"},
  49. { display: '全年计划批复水量', name: 'planReply', align: 'center', width: "7%"},
  50. { display: '全年实际批复水量', name: 'actualReply', align: 'center', width: "7%"},
  51. { display: '全年实际用水量', name: 'yearActualWater', align: 'center', width: "7%"},
  52. { display: '全年超计划用水量', name: 'exceedPlan', align: 'center', width: "7%"},
  53. { display: '全年节约用水量', name: 'saveOfWater', align: 'center', width: "7%"},
  54. { display: '一季度计划', name: 'first_quarter_reply', align: 'center', width: "7%"},
  55. { display: '二季度计划', name: 'second_quarter_reply', align: 'center', width: "7%"},
  56. { display: '三季度计划', name: 'third_quarter_reply', align: 'center', width: "7%"},
  57. { display: '四季度计划', name: 'fourth_quarter_reply', align: 'center', width: "7%"},
  58. { display: '超计划用水量比率(%)', name: 'exceedOfWaterRate', align: 'center', width: "8%"},
  59. { display: '实际超用水量', name: 'exceedOfWater', align: 'center', width: "7%"},
  60. { display: '罚款金额(元)', name: 'waterFines', align: 'center', width: "6%"},
  61. { display: '备注', name: 'remark', align: 'center', width: "10%"}
  62. ],
  63. toolbar:{
  64. items:[
  65. <@pop_perm url="/yearSummary/exportYearSummaryExcel.do">
  66. {line:true},
  67. {text: '导出', click: exportYearSummaryExcel, iconClass: 'icon_export'},
  68. </@pop_perm>
  69. <@pop_perm url="/yearSummary/printYearSummary.do">
  70. {line:true},
  71. {text: '打印', click: printYearActualWaterSummary, iconClass: 'icon_print'},
  72. </@pop_perm>
  73. {line:true}
  74. ]
  75. },
  76. data:[],rownumbers:true,dataAction:'local',checkbox:true,usePager: false,
  77. height: '100%', width:"100%",heightDiff:-40,
  78. isChecked:checkedHandler,onCheckRow: checkRowHandler, onCheckAllRow: checkAllRowHandler
  79. });
  80. }
  81. $(function(){
  82. getData(g_pageNo,g_pageSize);
  83. });
  84. /**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/
  85. function getData(pageNo,pageSize){
  86. jQuery.post("${ctx}/yearSummary/listPage.do",
  87. getFormParams(pageNo,pageSize),
  88. function(result){
  89. gridData = result;
  90. //刷新表格
  91. g.loadData(gridData);
  92. total_rows=gridData["pager.totalRows"];
  93. //设置左边内容页
  94. var content ="共有" + gridData["pager.totalRows"] + "条记录";
  95. $("#letfContent").html("");
  96. $("#letfContent").html(content);
  97. //取得分页组件
  98. var pager=$("#pager");
  99. //设置总页页数
  100. pager.attr("total",gridData["pager.totalRows"]);
  101. pager.render();
  102. //绑定翻页事件
  103. pager.unbind("pageChange");
  104. pager.bind("pageChange",function(e,index){
  105. g_pageNo = index + 1;
  106. getData(g_pageNo,g_pageSize);
  107. });
  108. //绑定选择每页显示记录数事件
  109. pager.bind("sizeChange",function(e,num){
  110. g_pageSize = num;
  111. getData(g_pageNo,g_pageSize);
  112. });
  113. },"json");
  114. }
  115. //查询
  116. function searchHandler(){
  117. //清空数组
  118. clearArray();
  119. //重新加载数据,设置当前页面为1
  120. getData(1,g_pageSize);
  121. }
  122. /**获得查询表单的提交查询的值**/
  123. function getFormParams(pageNo,pageSize){
  124. $("#pageNo").val(pageNo);
  125. $("#pageSize").val(pageSize);
  126. return $("#searchForm").formToArray();
  127. }
  128. /**重置于查询表单,然后重新加载表格数据**/
  129. function resetSearch(){
  130. //清空数组
  131. clearArray();
  132. $("#searchForm")[0].reset();
  133. //重新加载数据,设置当前页面为1
  134. getData(1,g_pageSize);
  135. }
  136. //导出年度实际用水汇总信息
  137. function exportYearSummaryExcel() {
  138. var rows = g.getSelectedRows();
  139. var rowsLength = rows.length;
  140. var orgIds=getCheckedOrgIdHandler();
  141. var year=getCheckedYearHandler();
  142. if(rowsLength == 0 && orgIds=='') {
  143. exportYearSummaryExcelByPage();
  144. return;
  145. }
  146. window.location.href="${ctx}/yearSummary/exportYearSummaryExcel.do?orgIds="+orgIds+"&year="+year+"&flag=selected";
  147. return;
  148. }
  149. //导出处理
  150. function exportYearSummaryExcelByPage(){
  151. var orgNumber=$("#orgNumber").val();
  152. var orgName=$("#orgName").val();
  153. var address=$("#address").val();
  154. var year=$("#year").val();
  155. var userType=$("#userType").val();
  156. var url="${ctx}/yearSummary/exportYearSummaryExcel.do?";
  157. url +="orgNumber="+orgNumber;
  158. url +="&orgName="+orgName;
  159. url +="&address="+address;
  160. url +="&year="+year;
  161. url +="&userType="+userType;
  162. url +="&flag=query";
  163. url +="&pageNo=1";
  164. url +="&pageSize="+total_rows;
  165. window.location =url;
  166. return false;
  167. }
  168. //打印年度实际汇总(打印选中的记录)
  169. function printYearActualWaterSummary(){
  170. var rows = g.getSelectedRows();
  171. var rowsLength = rows.length;
  172. var orgIds=getCheckedOrgIdHandler();
  173. var year=getCheckedYearHandler();
  174. if(rowsLength == 0 && orgIds=='') {
  175. printTotal();
  176. return;
  177. }
  178. window.open("${ctx}/yearSummary/printYearSummary.do?orgIds="+orgIds+"&year="+year+"&flag=selected");
  179. return;
  180. }
  181. function printTotal(){
  182. var orgNumber=$("#orgNumber").val();
  183. var orgName=$("#orgName").val();
  184. var address=$("#address").val();
  185. var year=$("#year").val();
  186. var userType=$("#userType").val();
  187. var url="${ctx}/yearSummary/printYearSummary.do?";
  188. url +="orgNumber="+orgNumber;
  189. url +="&orgName="+orgName;
  190. url +="&address="+address;
  191. url +="&year="+year;
  192. url +="&userType="+userType;
  193. url +="&flag=query";
  194. url +="&pageNo=1";
  195. url +="&pageSize="+total_rows;
  196. window.open(url);
  197. return false;
  198. }
  199. var checkedArray = [];
  200. var checkedYearArray = [];
  201. function findCheckedArray(id){
  202. for(var i =0;i<checkedArray.length;i++){
  203. if(checkedArray[i] == id) return i;
  204. }
  205. return -1;
  206. }
  207. function addCheckedArray(id,year){
  208. if(findCheckedArray(id) == -1){
  209. checkedArray.push(id);
  210. checkedYearArray.push(year);
  211. }
  212. }
  213. function removeCheckedArray(id){
  214. var i = findCheckedArray(id);
  215. if(i==-1) return;
  216. checkedArray.splice(i,1);
  217. checkedYearArray.splice(i,1);
  218. }
  219. function checkedHandler(rowdata){
  220. if (findCheckedArray(rowdata.orgId) == -1)
  221. return false;
  222. return true;
  223. }
  224. function checkRowHandler(checked, data){
  225. if (checked) addCheckedArray(data.orgId,data.year);
  226. else removeCheckedArray(data.orgId,data.year);
  227. }
  228. function checkAllRowHandler(checked){
  229. for (var rowid in this.records){
  230. if(checked)
  231. addCheckedArray(this.records[rowid]['orgId'],this.records[rowid]['year']);
  232. else
  233. removeCheckedArray(this.records[rowid]['orgId'],this.records[rowid]['year']);
  234. }
  235. }
  236. function getCheckedOrgIdHandler()
  237. {
  238. return checkedArray.join(',');
  239. }
  240. function getCheckedYearHandler(){
  241. return checkedYearArray.join(',');
  242. }
  243. //清空数组
  244. function clearArray(){
  245. checkedArray.length=0;
  246. checkedYearArray.length=0;
  247. }
  248. </script>
  249. </head>
  250. <body>
  251. <div class="box2" panelTitle="年度实际用水汇总信息列表">
  252. <form action="" id="searchForm" method="post">
  253. <input type="hidden" id="pageNo" name="pageNo" value="1" /> <input
  254. type="hidden" id="pageSize" name="pageSize" value="10" />
  255. <table>
  256. <tr>
  257. <td>单位编号:</td>
  258. <td><input type="text" id="orgNumber" name="orgNumber" /></td>
  259. <td>单位名称:</td>
  260. <td><input type="text" id="orgName" name="orgName" /></td>
  261. <td>单位地址:</td>
  262. <td><input type="text" id="address" name="address" /></td>
  263. </tr>
  264. <tr>
  265. <td>用户类型:</td>
  266. <td><select id="userType" name="userType"
  267. data='{"list":${userTypeData}}' prompt="全部"></select></td>
  268. <td align="right">年度:</td>
  269. <td><input type="text" id="year" name="year" class="date"
  270. dateFmt="yyyy" value="${year!''}" /></td>
  271. <td>
  272. <button type="button" onclick="searchHandler()">
  273. <span class="icon_find">查询</span>
  274. </button>
  275. </td>
  276. <td>
  277. <button type="button" onclick="resetSearch()">
  278. <span class="icon_reload">重置</span>
  279. </button>
  280. </td>
  281. </tr>
  282. </table>
  283. </form>
  284. </div>
  285. <div id="scrollContent">
  286. <div class="padding_right5">
  287. <div id="maingrid"></div>
  288. </div>
  289. </div>
  290. <!-- 分页组件 -->
  291. <div style="height: 35px;">
  292. <div id="letfContent" class="float_left padding5"></div>
  293. <div class="float_right padding5">
  294. <div id="pager" total="0" class="pageArrow" showSelect="true"
  295. inputPosition="right"></div>
  296. </div>
  297. <div class="clear"></div>
  298. </div>
  299. </body>
  300. </html>