org-water-meter-list.jsp 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402
  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 type="text/javascript"
  16. src="${ctx}/qui/libs/js/form/datePicker/WdatePicker.js"></script>
  17. <!-- 日期选择框end -->
  18. <!--数据表格start-->
  19. <script src="${ctx}/qui/libs/js/table/quiGrid.js" type="text/javascript"></script>
  20. <!--数据表格end-->
  21. <!--箭头分页start-->
  22. <script type="text/javascript" src="${ctx}/qui/libs/js/nav/pageArrow.js"></script>
  23. <!--箭头分页end-->
  24. <!--表单异步提交start-->
  25. <script src="${ctx}/qui/libs/js/form/form.js" type="text/javascript"></script>
  26. <!--表单异步提交end-->
  27. <script type="text/javascript">
  28. var g_pageNo = 1;
  29. var g_pageSize = 12;
  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: "8%"},
  38. { display: '单位名称', name: 'orgName', align: 'center', width: "15%"},
  39. { display: '单位地址', name: 'address', align: 'center', width: "15%"},
  40. { display: '水表编号', name: 'meterNumber', align: 'center', width: "10%"},
  41. { display: '年度', name: 'year', align: 'center', width: "5%"},
  42. { display: '月份', name: 'month', align: 'center', width: "6%"},
  43. { display: '水量', name: 'water', align: 'center', width: "6%"},
  44. { display: '水价', name: 'waterPrice', align: 'center', width: "6%"},
  45. { display: '用水性质', name: 'propertiesName', align: 'center', width: "8%"},
  46. { display: '备注', name: 'remark', align: 'center', width: "12%"},
  47. { display: '操作', isAllowHide: false, align: 'left', width:"12%",
  48. render: function (rowdata, rowindex, value, column){
  49. return '<div class="padding_top4 padding_left20">'
  50. <@pop_perm url="/meterReadInfo/editUnitWaterMeter.do">
  51. +'<a href="#" onclick="onEdit(' + rowdata.infoId +')"><span class="icon_edit">修改</span></a>'
  52. </@pop_perm>
  53. + '</div>';
  54. }
  55. }
  56. ],
  57. toolbar:{
  58. items:[
  59. <@pop_perm url="/meterReadInfo/exportUnitWaterMeterExcel.do">
  60. {line:true},
  61. {text: '导出', click: exportWaterUnitMeterExcel, iconClass: 'icon_export'},
  62. </@pop_perm>
  63. <@pop_perm url="/meterReadInfo/printUnitWaterMeter.do">
  64. {line:true},
  65. {text: '打印', click: printUnitWaterMeter, iconClass: 'icon_print'},
  66. </@pop_perm>
  67. {line:true}
  68. ]
  69. },
  70. data:[],rownumbers:true,dataAction:'local',checkbox:true,usePager: false,
  71. height: '100%', width:"100%",heightDiff:-40,isChecked:checkedHandler,onCheckRow: checkRowHandler, onCheckAllRow: checkAllRowHandler
  72. });
  73. }
  74. $(function(){
  75. getData(g_pageNo,g_pageSize);
  76. });
  77. /**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/
  78. function getData(pageNo,pageSize){
  79. jQuery.post("${ctx}/meterReadInfo/listUnitWaterMeterPage.do",
  80. getFormParams(pageNo,pageSize),
  81. function(result){
  82. gridData = result;
  83. //刷新表格
  84. g.loadData(gridData);
  85. total_rows=gridData["pager.totalRows"];
  86. //设置左边内容页
  87. var content ="共有" + gridData["pager.totalRows"] + "条记录";
  88. $("#letfContent").html("");
  89. $("#letfContent").html(content);
  90. //取得分页组件
  91. var pager=$("#pager");
  92. //设置总页页数
  93. pager.attr("total",gridData["pager.totalRows"]);
  94. pager.attr("pageSize",12);
  95. pager.render();
  96. //绑定翻页事件
  97. pager.unbind("pageChange");
  98. pager.bind("pageChange",function(e,index){
  99. g_pageNo = index + 1;
  100. getData(g_pageNo,g_pageSize);
  101. });
  102. //绑定选择每页显示记录数事件
  103. pager.bind("sizeChange",function(e,num){
  104. g_pageSize = num;
  105. getData(g_pageNo,g_pageSize);
  106. });
  107. },"json");
  108. }
  109. //查询
  110. function searchHandler(){
  111. var getYear = $('#year').val();
  112. var param = ${year!''};
  113. if(getYear==null || getYear==""){
  114. $('#year').val(param);
  115. }
  116. //清空数组
  117. clearArray();
  118. //重新加载数据,设置当前页面为1
  119. getData(1,g_pageSize);
  120. }
  121. /**获得查询表单的提交查询的值**/
  122. function getFormParams(pageNo,pageSize){
  123. $("#pageNo").val(pageNo);
  124. $("#pageSize").val(pageSize);
  125. return $("#searchForm").formToArray();
  126. }
  127. /**重置于查询表单,然后重新加载表格数据**/
  128. function resetSearch(){
  129. //清空数组
  130. clearArray();
  131. $("#searchForm")[0].reset();
  132. //重新加载数据,设置当前页面为1
  133. getData(1,g_pageSize);
  134. }
  135. //编辑
  136. function onEdit(infoId) {
  137. top.Dialog.open({
  138. URL : "${ctx}/meterReadInfo/editUnitWaterMeter.do?infoId="+infoId,
  139. Title : "编辑单位水表水量表",
  140. Width : 800,
  141. Height : 320
  142. });
  143. }
  144. var checkedInfoIdArray = []; //唯一标识,选择复选框时必须用到唯一标识,不然得不到所要的记录
  145. function findCheckedArray(infoId){
  146. for(var i =0;i<checkedInfoIdArray.length;i++){
  147. if(checkedInfoIdArray[i] == infoId) return i;
  148. }
  149. return -1;
  150. }
  151. function addCheckedArray(infoId){
  152. if(findCheckedArray(infoId) == -1){
  153. checkedInfoIdArray.push(infoId);
  154. }
  155. }
  156. function removeCheckedArray(infoId){
  157. var i = findCheckedArray(infoId);
  158. if(i==-1) return;
  159. checkedInfoIdArray.splice(i,1);
  160. }
  161. function checkedHandler(rowdata){
  162. if (findCheckedArray(rowdata.infoId) == -1)
  163. return false;
  164. return true;
  165. }
  166. function checkRowHandler(checked, data){
  167. if (checked) addCheckedArray(data.infoId);
  168. else removeCheckedArray(data.infoId);
  169. }
  170. function checkAllRowHandler(checked){
  171. for (var rowid in this.records){
  172. if(checked)
  173. addCheckedArray(this.records[rowid]['infoId']);
  174. else
  175. removeCheckedArray(this.records[rowid]['infoId']);
  176. }
  177. }
  178. //导出单位水表水量表
  179. function exportWaterUnitMeterExcel() {
  180. var getYear = $('#year').val();
  181. var param = ${year!''};
  182. if(getYear==null || getYear==""){
  183. $('#year').val(param);
  184. }
  185. var rows = g.getSelectedRows();
  186. var rowsLength = rows.length;
  187. var infoIds=getCheckedInfoIdHandler();
  188. if(rowsLength == 0&& infoIds=='') {
  189. exportUnitWaterMeterExcelByPage();
  190. return;
  191. }
  192. window.location.href="${ctx}/meterReadInfo/exportUnitWaterMeterExcel.do?infoIds="+infoIds+"&flag=selected&year="+$("#year").val()+"&pageNo=1&pageSize="+total_rows;
  193. return;
  194. }
  195. //导出处理
  196. function exportUnitWaterMeterExcelByPage(){
  197. var getYear = $('#year').val();
  198. var param = ${year!''};
  199. if(getYear==null || getYear==""){
  200. $('#year').val(param);
  201. }
  202. var orgNumber=$("#orgNumber").val();
  203. var orgName=$("#orgName").val();
  204. var meterNumber=$("#meterNumber").val();
  205. var year=$("#year").val();
  206. var isPlanUser=$("#isPlanUser").val();
  207. var userType=$("#userType").val();
  208. var minWater=$("#minWater").val();
  209. var maxWater=$("#maxWater").val();
  210. var url="${ctx}/meterReadInfo/exportUnitWaterMeterExcel.do?";
  211. url +="orgNumber="+orgNumber;
  212. url +="&orgName="+orgName;
  213. url +="&meterNumber="+meterNumber;
  214. url +="&year="+year;
  215. url +="&isPlanUser="+isPlanUser;
  216. url +="&userType="+userType;
  217. url +="&minWater="+minWater;
  218. url +="&maxWater="+maxWater;
  219. url +="&flag=query";
  220. url +="&pageNo=1";
  221. url +="&pageSize="+total_rows;
  222. window.location =url;
  223. return false;
  224. }
  225. function getCheckedInfoIdHandler(){
  226. return checkedInfoIdArray.join(',');
  227. }
  228. $(function($){
  229. var old_min;
  230. var old_max;
  231. //获得之前的值
  232. $("#minWater").focus( function() {
  233. old_min=$(this).val();
  234. });
  235. $("#maxWater").focus( function() {
  236. old_max=$(this).val();
  237. });
  238. $("#minWater").change( function() {
  239. var water=$(this).val();
  240. if(isNaN(water)){
  241. $(this).val(old_min);
  242. return;
  243. }
  244. });
  245. $("#maxWater").change( function() {
  246. var water=$(this).val();
  247. if(isNaN(water)){
  248. $(this).val(old_max);
  249. return;
  250. }
  251. });
  252. });
  253. //打印
  254. function printUnitWaterMeter(){
  255. var getYear = $('#year').val();
  256. var param = ${year!''};
  257. if(getYear==null || getYear==""){
  258. $('#year').val(param);
  259. }
  260. var rows = g.getSelectedRows();
  261. var rowsLength = rows.length;
  262. var infoIds=getCheckedInfoIdHandler();
  263. if(rowsLength == 0&&infoIds=='') {
  264. printByPage();
  265. return;
  266. }
  267. window.open("${ctx}/meterReadInfo/printUnitWaterMeter.do?infoIds="+infoIds+"&flag=selected&year="+$("#year").val()+"&pageNo=1&pageSize="+total_rows);
  268. return;
  269. }
  270. function printByPage(){
  271. var getYear = $('#year').val();
  272. var param = ${year!''};
  273. if(getYear==null || getYear==""){
  274. $('#year').val(param);
  275. }
  276. var orgNumber=$("#orgNumber").val();
  277. var orgName=$("#orgName").val();
  278. var meterNumber=$("#meterNumber").val();
  279. var year=$("#year").val();
  280. var isPlanUser=$("#isPlanUser").val();
  281. var userType=$("#userType").val();
  282. var minWater=$("#minWater").val();
  283. var maxWater=$("#maxWater").val();
  284. var url="${ctx}/meterReadInfo/printUnitWaterMeter.do?";
  285. url +="orgNumber="+orgNumber;
  286. url +="&orgName="+orgName;
  287. url +="&meterNumber="+meterNumber;
  288. url +="&year="+year;
  289. url +="&isPlanUser="+isPlanUser;
  290. url +="&userType="+userType;
  291. url +="&minWater="+minWater;
  292. url +="&maxWater="+maxWater;
  293. url +="&flag=query";
  294. url +="&pageNo=1";
  295. url +="&pageSize="+total_rows;
  296. window.open(url);
  297. return false;
  298. }
  299. //清空数组
  300. function clearArray(){
  301. checkedInfoIdArray.length=0;
  302. }
  303. </script>
  304. </head>
  305. <body>
  306. <div class="box2" panelTitle="单位水表水量表信息列表">
  307. <form action="" id="searchForm" method="post">
  308. <input type="hidden" id="pageNo" name="pageNo" value="1" /> <input
  309. type="hidden" id="pageSize" name="pageSize" value="12" />
  310. <table>
  311. <tr>
  312. <td>单位编号:</td>
  313. <td><input type="text" id="orgNumber" name="orgNumber" /></td>
  314. <td>单位名称:</td>
  315. <td><input type="text" id="orgName" name="orgName" /></td>
  316. <td align="right">水表编号:</td>
  317. <td><input type="text" id="meterNumber" name="meterNumber" /></td>
  318. <td>年度:</td>
  319. <td><input type="text" id="year" name="year" class="date"
  320. dateFmt="yyyy" value="${year!''}" /></td>
  321. </tr>
  322. <tr>
  323. <td>是否计划户:</td>
  324. <td><select id="isPlanUser" name="isPlanUser">
  325. <option value="">全部</option>
  326. <option value="yes">计划户</option>
  327. <option value="no">非计划户</option>
  328. </select></td>
  329. <td>用户类型:</td>
  330. <td><select id="userType" name="userType"
  331. data='{"list":${userTypeData}}' prompt="全部"></select></td>
  332. <td>月用水量(m³):(≥)</td>
  333. <td><input type="text" id="minWater" name="minWater" /></td>
  334. <td>并且(≤):</td>
  335. <td><input type="text" id="maxWater" name="maxWater" /></td>
  336. <td>&nbsp;</td>
  337. <td>
  338. <button type="button" onclick="searchHandler()">
  339. <span class="icon_find">查询</span>
  340. </button>
  341. <button type="button" onclick="resetSearch()">
  342. <span class="icon_reload">重置</span>
  343. </button>
  344. </td>
  345. </tr>
  346. </table>
  347. </form>
  348. </div>
  349. <div id="scrollContent">
  350. <div class="padding_right5">
  351. <div id="maingrid"></div>
  352. </div>
  353. </div>
  354. <!-- 分页组件 -->
  355. <div style="height: 35px;">
  356. <div id="letfContent" class="float_left padding5"></div>
  357. <div class="float_right padding5">
  358. <div id="pager" total="0" class="pageArrow" showSelect="false"
  359. inputPosition="right"></div>
  360. </div>
  361. <div class="clear"></div>
  362. </div>
  363. </body>
  364. </html>