123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590 |
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <title>季度超用水费用汇总</title>
- <!--框架必需start-->
- <script type="text/javascript" src="${ctx}/qui/libs/js/jquery.js"></script>
- <script type="text/javascript" src="${ctx}/qui/libs/js/framework.js"></script>
- <link href="${ctx}/qui/libs/css/import_basic.css" rel="stylesheet"
- type="text/css" />
- <link rel="stylesheet" type="text/css" id="skin" prePath="${ctx}/qui/" />
- <link rel="stylesheet" type="text/css" id="customSkin" />
- <!--框架必需end-->
- <!--数据表格start-->
- <script src="${ctx}/qui/libs/js/table/quiGrid.js" type="text/javascript"></script>
- <!--数据表格end-->
- <!--箭头分页start-->
- <script type="text/javascript" src="${ctx}/qui/libs/js/nav/pageArrow.js"></script>
- <!--箭头分页end-->
- <!--表单异步提交start-->
- <script src="${ctx}/qui/libs/js/form/form.js" type="text/javascript"></script>
- <!--表单异步提交end-->
- <!-- 日期选择框start -->
- <script type="text/javascript"
- src="${ctx}/qui/libs/js/form/datePicker/WdatePicker.js"></script>
- <!-- 日期选择框end -->
- <script type="text/javascript">
- var g_pageNo = 1;
- var g_pageSize = 10;
- var total_rows=0;
- //刷新记忆
- var checkedArray = [];
-
- //数据表格使用
- var g;
- var gridData;
- function initComplete(){
- g = $("#maingrid").quiGrid({
- columns: [
- { display: '单位名称', name: '3', align: 'center', width: "10%",
- render:function(rowdata, rowindex, value, column){
- return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
- }
- },
- { display: '用户类型', name: '6', align: 'center', width: "6%",
- render:function(rowdata, rowindex, value, column){
- if(value == "1"){
- return "自来水户";
- }else if(value == "2"){
- return "取水户";
- }else{
- return "";
- }
- }
- },
- { display: '季度', name: '8', align: 'center', width: "5%"},
- { display: '批复用水指标', name: '21', align: 'center', width: "5%",
- render: function (rowdata, rowindex, value, column){
- return Number(value).toFixed(0);
- }
- },
- { display: '实际用水量', name: '14', align: 'center', width: "5%"},
- { display: '实际收水量', name: '15', align: 'center', width: "5%"},
- { display: '应收金额', name: '18', align: 'center', width: "5%",
- render: function (rowdata, rowindex, value, column){
- return Number(value).toFixed(2);
- }
- },
- { display: '实收金额', name: '17', align: 'center', width: "5%",
- render: function (rowdata, rowindex, value, column){
- return Number(value).toFixed(2);
- }
- },
- { display: '是否销账', name: '10', align: 'center', width: "5%",
- render: function (rowdata, rowindex, value, column){
- if(value=='yes'){
- return "是";
- }else{
- return "否";
- }
- }
- },
- { display: '销帐日期', name: '11', align: 'center', width: "5%"},
- { display: '付款方式', name: '12', align: 'center', width: "5%",
- render: function (rowdata, rowindex, value, column){
- if(value=='1'){
- return "现金";
- }
- if(value=='2'){
- return "转账";
- }
- }
- },
- { display: '用水单价', name: '13', align: 'center', width: "5%",
- render: function (rowdata, rowindex, value, column){
- return Number(value).toFixed(2);
- }
- },
- { display: '备注', name: '20', align: 'center', width: "10%"},
- { display: '操作', isAllowHide: false, align: 'center', width:"15%",
- render: function (rowdata, rowindex, value, column){
- return '<div class="padding_top4 padding_left20">'
- <@pop_perm url="/quarterAssessment/quarterlyAssessmentWriteOff.do">
- + '<a href="#" onclick="writeOff('+ rowdata[0]+')"><span class="icon_edit">销帐</span></a>'
- </@pop_perm>
- <@pop_perm url="/quarterAssessment/delete.do">
- + '<a href="#" onclick="onDelete('+ rowdata[0]+')"><span class="icon_delete">删除</span></a>'
- </@pop_perm>
- + '</div>';
- }
- }],
- toolbar:{
- items:[
- // <@pop_perm url="">
- // {text:'新增',click:onCreate,iconClass:'icon_add'},
- // </@pop_perm>
- <@pop_perm url="/quarterAssessment/delete.do">
- {line:true},
- {text:'批量删除',click:batchDelete, iconClass:'icon_delete'},
- </@pop_perm>
- <@pop_perm url="/quarterAssessment/print.do">
- {line:true},
- {text:'打印',click:print, iconClass:'icon_print'},
- </@pop_perm>
- <@pop_perm url="/quarterAssessment/printAddWaterNotice.do">
- {line:true},
- {text:'打印超计划用水加价水费通知预览',click:printAddWaterNotice, iconClass:'icon_print'},
- </@pop_perm>
- <@pop_perm url="/quarterAssessment/exportExcel.do">
- {line:true},
- {text:'导出',click:exportExcel, iconClass:'icon_export'},
- </@pop_perm>
- {line:true}
- ]
- },
- data:[], sortName: 'showOrgName',rownumbers:true,checkbox:true,usePager: false,height: '100%', width:"100%",heightDiff:-40,pageSize:g_pageSize,
- onChangeSort : function(){
- getData(g.options.sortName,g.options.sortOrder,g_pageNo,g_pageSize);
- return false;
- },isChecked:checkedHandler,onCheckRow: checkRowHandler, onCheckAllRow: checkAllRowHandler
- });
-
-
- }
- //点击分页触发
- $(function(){
- getData(g_pageNo,g_pageSize);
- })
-
- //打印预览
- // function print(){
- // window.open("${ctx}/quarterAssessment/print.do?exportType=writeOff&pageNo=1&pageSize="+total_rows);
- // }
- //打印
- function print(){
- var rows = g.getSelectedRows();
- var rowsLength = rows.length;
- var ids = getCheckedIdHandler();
- if(rowsLength == 0 && ids=='') {
- printByPage();
- return;
- }
- // alert(ids);
- // var orgIds=getCheckedOrgIdHandler();
- // var months=getCheckedMonthHandler();
- // var years=getCheckedYearHandler();
- //window.location.href="${ctx}/customerMeter/exportExcel.do?&ids="+ids+"&flag=selected&pageNo=1&pageSize="+total_rows;
- window.open("${ctx}/quarterAssessment/print.do?exportType=writeOff&ids="+ids+"&flag=selected&pageNo=1&pageSize="+total_rows);
- return;
- }
- function printByPage(){
- var orgName=$("#orgName").val();
- var year=$("#year").val();
- var quarter=$('#quarter').val();
- var userType=$("#userType").val();
- var isWriteOff=$("#isWriteOff").val();
-
- var url="${ctx}/quarterAssessment/print.do?";
- url +="&orgName="+orgName;
- url +="&year="+year;
- url +="&quarter="+quarter;
- url +="&isWriteOff="+isWriteOff;
- url +="&userType="+userType;
- url +="&flag=query";
- url +="&exportType=writeOff";
- url +="&pageNo=1";
- url +="&pageSize="+total_rows;
- url = encodeURI(encodeURI(url));
- window.open(url);
- }
-
- /**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/
- function getData(pageNo,pageSize){
- // alert('aaa');
- jQuery.post("${ctx}/quarterAssessment/listPage.do",
- getFormParams(pageNo,pageSize),
- function(result){
- gridData = result;
- //刷新表格
- g.loadData(gridData);
- total_rows=gridData["pager.totalRows"];
- //设置左边内容页
- var content ="共有" + gridData["pager.totalRows"] + "条记录";
- $("#letfContent").html("");
- $("#letfContent").html(content);
- //取得分页组件
- var pager=$("#pager");
- //设置总页页数
- pager.attr("total",gridData["pager.totalRows"]);
- pager.render();
- //绑定翻页事件
- pager.unbind("pageChange");
- pager.bind("pageChange",function(e,index){
- g_pageNo = index + 1;
- getData(g_pageNo,g_pageSize);
- });
- //绑定选择每页显示记录数事件
- pager.bind("sizeChange",function(e,num){
- g_pageSize = num;
- getData(g_pageNo,g_pageSize);
- });
- },"json");
- }
-
-
- //查询
- function searchHandler(){
- //清空数组
- clearArray();
- //重新加载数据,设置当前页面为1
- getData(1,g_pageSize);
- }
-
- /**获得查询表单的提交查询的值**/
- function getFormParams(pageNo,pageSize){
- $("#pageNo").val(pageNo);
- $("#pageSize").val(pageSize);
- return $("#searchForm").formToArray();
- }
-
- /**重置于查询表单,然后重新加载表格数据**/
- function resetSearch(){
- //清空数组
- clearArray();
- $("#searchForm")[0].reset();
- //重新加载数据,设置当前页面为1
- getData(1,g_pageSize);
- }
- //单条记录删除
- function onDelete(rowid){
- top.Dialog.confirm("确定要删除该记录吗?",function(){
- //删除记录
- jQuery.post("${ctx}/quarterAssessment/delete.do",
- {"ids":rowid},
- function(responseText){
- if(responseText.status=="y"){
- top.Dialog.alert(responseText.info);
- resetSearch();
- }else{
- top.Dialog.alert(responseText.info);
- }
-
- },
- "json");
- });
- }
- //批量删除
- function batchDelete() {
- var rows = g.getSelectedRows();
- var rowsLength = rows.length;
- if(rowsLength == 0) {
- top.Dialog.alert("请选中要删除的记录!");
- return;
- }
- top.Dialog.confirm("确定要删除吗?",function(){
- jQuery.post("${ctx}/quarterAssessment/delete.do",
- //获取所有选中行
- getSelectId(g),
- function(responseText){
- if(responseText.status=="y"){
- top.Dialog.alert(responseText.info);
- resetSearch();
- }else{
- top.Dialog.alert(responseText.info);
- return false;
- }
- },
- "json");
- });
-
- //获取所有选中行获取选中行的id 格式为 ids=1&ids=2
- function getSelectId(grid) {
- var selectedRows = grid.getSelectedRows();
- var selectedRowsLength = selectedRows.length;
- var ids = "";
- for(var i = 0;i<selectedRowsLength;i++) {
- ids += selectedRows[i][0] + ",";
- }
- return {"ids":ids};
- }
- }
- //新增
- function onCreate(){
- top.Dialog.open({
- ID:'a1',
- URL:"${ctx}/quarterAssessment/create.do?year="+$('#year').val(),
- Title:"新增季度考核",
- Width:700,
- Height:350
- });
- }
- //销帐
- function writeOff(rowId){
- // alert(rowId);
- top.Dialog.open({
- ID:'a1',
- URL:"${ctx}/quarterAssessment/quarterlyAssessmentWriteOff.do?entity_id="+rowId,
- Title:"销帐",
- Width:700,
- Height:400
- });
- }
-
- //导出单位水表水量表
- function exportExcel() {
- var rows = g.getSelectedRows();
- var rowsLength = rows.length;
- var ids = getCheckedIdHandler();
- if(rowsLength == 0&& ids=='') {
- exportExcelByPage();
- return;
- }
-
- // alert(ids);
- window.location.href="${ctx}/quarterAssessment/exportExcel.do?&ids="+ids+"&exportType=writeOff&flag=selected&pageNo=1&pageSize="+total_rows;
- return;
-
- }
-
-
- //导出处理
- function exportExcelByPage(){
- var orgName=$("#orgName").val();
- var year=$("#year").val();
- var quarter=$('#quarter').val();
- var userType=$("#userType").val();
- var isWriteOff=$("#isWriteOff").val();
-
- var url="${ctx}/quarterAssessment/exportExcel.do?";
- url +="&orgName="+orgName;
- url +="&year="+year;
- url +="&quarter="+quarter;
- url +="&isWriteOff="+isWriteOff;
- url +="&userType="+userType;
- url +="&flag=query";
- url +="&exportType=writeOff";
- url +="&pageNo=1";
- url +="&pageSize="+total_rows;
- url = encodeURI(encodeURI(url));
- window.location =url;
- return false;
- }
- var checkedArray = [];
- var checkedOrgIdArray = [];
- var checkedQuarterArray = [];
- var checkedQuarterArrayByPage = [];
- function findCheckedArray(id){
- for(var i =0;i<checkedArray.length;i++){
- if(checkedArray[i] == id) return i;
- }
- return -1;
- }
- function addCheckedArray(id,orgId,quarter){
- if(findCheckedArray(id) == -1){
- checkedArray.push(id);
- checkedOrgIdArray.push(orgId);
- checkedQuarterArray.push(quarter);
- }
- }
- function getCheckedIdHandler(){
- return checkedArray.join(',');
- }
-
- function removeCheckedArray(id){
- var i = findCheckedArray(id);
- if(i==-1) return;
- checkedArray.splice(i,1);
- checkedOrgIdArray.splice(i,1);
- checkedQuarterArray.splice(i,1);
- }
- function checkedHandler(rowdata){
- if (findCheckedArray(rowdata[0]) == -1)
- return false;
- return true;
- }
- function checkRowHandler(checked, data){
- if (checked) addCheckedArray(data[0],data[1],data[8]);
- else removeCheckedArray(data[0],data[1],data[8]);
- }
- function checkAllRowHandler(checked){
- for (var rowid in this.records){
- if(checked)
- addCheckedArray(this.records[rowid][0],this.records[rowid][1],this.records[rowid][8]);
- else
- removeCheckedArray(this.records[rowid][0],this.records[rowid][1],this.records[rowid][8]);
- }
- }
-
- //得到单位id
- function getCheckedOrgIdHandler(){
- return checkedOrgIdArray.join(',');
- }
- //得到季度
- function getCheckedQuarterHandler(){
- return checkedQuarterArray.join(',');
- }
-
- //打印上半年超计划用水加价水费通知预览。添加日期,打印选中的记录
- function printAddWaterNotice(){
- if(total_rows<=0){
- top.Dialog.alert("没有要打印的数据");
- return;
- }
- var quarters = getCheckedQuarterHandler();
- if((quarters.indexOf("1")>=0&&quarters.indexOf("3")>=0)||(quarters.indexOf("1")>=0&&quarters.indexOf("4")>=0)
- ||(quarters.indexOf("2")>=0&&quarters.indexOf("3")>=0)||(quarters.indexOf("2")>=0&&quarters.indexOf("4")>=0))
- {
- top.Dialog.alert("不能同时选择上半年和下半年季度,请检查");
- return;
- }
-
- var rows = g.getSelectedRows();
- var rowsLength = rows.length;
- if(rowsLength == 0&&quarters=='') {
- //在没有选中记录时得到季度
- var quarters=getCheckedQuarterHandlerByPage();
- if((quarters.indexOf("1")>=0&&quarters.indexOf("3")>=0)||(quarters.indexOf("1")>=0&&quarters.indexOf("4")>=0)
- ||(quarters.indexOf("2")>=0&&quarters.indexOf("3")>=0)||(quarters.indexOf("2")>=0&&quarters.indexOf("4")>=0))
- {
- top.Dialog.alert("没有选中时默认打印查询出来的记录。不能同时打印上半年和下半年季度,请检查");
- return;
- }
- printNoticeByPage();
- return;
- }
- var ids = getCheckedIdHandler();
- var orgIds = getCheckedOrgIdHandler();
- var url="${ctx}/quarterAssessment/addPrintTime.do?";
- url +="ids="+ids;
- url +="&orgIds="+orgIds;
- url +="&flag=selected";
- top.Dialog.open({
- URL : url,
- Title : "添加缴纳加价水费日期",
- Width : 450,
- Height : 150
-
- });
- }
-
- //没有选中时打印
- function printNoticeByPage(){
- var orgName=$("#orgName").val();
- var year=$("#year").val();
- var quarter=$('#quarter').val();
- var userType=$("#userType").val();
- var isWriteOff=$("#isWriteOff").val();
-
- var url="${ctx}/quarterAssessment/addPrintTime.do?";
- url +="&orgName="+orgName;
- url +="&year="+year;
- url +="&quarter="+quarter;
- url +="&userType="+userType;
- url +="&isWriteOff="+isWriteOff;
- url +="&flag=query";
-
- top.Dialog.open({
- URL : url,
- Title : "添加缴纳加价水费日期",
- Width : 450,
- Height : 150
-
- });
- }
-
- function getCheckedQuarterHandlerByPage(){
- for (var record in g.records){
- checkedQuarterArrayByPage.push(g.records[record]['8']);
- }
- return checkedQuarterArrayByPage.join(',');
- }
-
- //清空数组
- function clearArray(){
- /*
- var chId=getCheckedIdHandler();
- var orgId=getCheckedOrgIdHandler();
- var quarters=getCheckedQuarterHandlerByPage();
- var quarter = getCheckedQuarterHandler();
- checkedArray.splice(0,chId.length);
- checkedOrgIdArray.splice(0,orgId.length);
- checkedQuarterArrayByPage.splice(0,quarters.length);
- checkedQuarterArray.splice(0,quarter.length);
- */
- checkedArray.length=0;
- checkedOrgIdArray.length=0;
- checkedQuarterArray.length=0;
- checkedQuarterArrayByPage.length=0;
- }
- </script>
- </head>
- <body>
- <div class="box2" panelTitle="季度超用水费用汇总信息列表">
- <form action="" id="searchForm" method="post">
- <input type="hidden" id="Q_importStatus_S_LK"
- name="Q_importStatus_S_LK" value="normal" /> <input type="hidden"
- id="pageNo" name="pageNo" value="1" /> <input type="hidden"
- id="pageSize" name="pageSize" value="10" />
- <table>
- <tr>
- <td align="right">年度:</td>
- <td><input class="date" dateFmt="yyyy" type="text" id="year"
- name="year" value="${year!''}" /></td>
- <td>用户类型:</td>
- <td><select prompt="请选择" id="userType"
- data='${userType}' name="userType"></select></td>
- <!-- <td align="right">季度:</td>
- <td><input type="text" id="quarter" name="quarter" /></td> -->
- <td>单位名称:</td>
- <td><input type="text" id="orgName" name="orgName" /></td>
- <td>是否销账:</td>
- <td><select prompt="请选择" id="isWriteOff"
- name="isWriteOff"
- data='{"list":[{"value":"yes","key":"是"},{"value":"no","key":"否"}]}'
- name=""></select></td>
- <td>季度:</td>
- <td><select prompt="请选择" id="quarter" name="quarter"
- data='{"list":[{"value":"1","key":"第一季度"},{"value":"2","key":"第二季度"},{"value":"3","key":"第三季度"},{"value":"4","key":"第四季度"},{"value":"1,2","key":"上半年"},{"value":"3,4","key":"下半年"}]}'></select></td>
- <td style="padding-left: 15px;"><button type="button"
- onclick="searchHandler()">
- <span class="icon_find">查询</span>
- </button></td>
- </td>
- <td style="padding-left: 15px;"><button type="reset"
- onclick="resetSearch()">
- <span class="icon_find">重置</span>
- </button></td>
- </td>
- </tr>
- </table>
- </form>
- </div>
- <div id="scrollContent">
- <div class="padding_right5">
- <div id="maingrid"></div>
- </div>
- </div>
- <!-- 分页组件 -->
- <div style="height: 35px;">
- <div id="letfContent" class="float_left padding5"></div>
- <div class="float_right padding5">
- <div id="pager" total="0" class="pageArrow" showSelect="true"
- inputPosition="right"></div>
- </div>
- <div class="clear"></div>
- </div>
- </body>
- </html>
|