HJY
/
gxwss


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649
							<!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 type="text/javascript"
            src="${ctx}/qui/libs/js/form/datePicker/WdatePicker.js"></script>
    <!-- 日期选择框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-->


    <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: '2',     align: 'center', width: "6%"},
                    { 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: '4',     align: 'center', width: "13%",
                        render:function(rowdata, rowindex, value, column){
                            return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
                        }
                    },
                    { display: '水表号', name: '25',     align: 'center', width: "13%",
                        render:function(rowdata, rowindex, value, column){
                            return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
                        }
                    },
                    { display: '邮寄地址', name: '24',     align: 'center', width: "13%",
                        render:function(rowdata, rowindex, value, column){
                            return "<font class='textSlice' style='width:100%;cursor: pointer;' title='"+value+"'>"+value+"</font>";
                        }
                    },
                    { display: '邮编', name: '23',     align: 'center', width: "6%",
                        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: '9',     align: 'center', width: "5%"},
                    { display: '用水计划旧指标', name: '32',     align: 'center', width: "5%"},
                    { display: '实际用水量', name: '14',     align: 'center', width: "5%"},
                    { display: '实际收水量', name: '15',     align: 'center', width: "5%",
                        render: function (rowdata, rowindex, value, column){
                            return value.toFixed(0);
                        }
                    },
                    { display: '超用率(%)', name: '16',     align: 'center', width: "5%",
                        render: function (rowdata, rowindex, value, column){
                            return value+'%';
                        }
                    },
                    { display: '应收金额', name: '18',     align: 'center', width: "5%",
                        render: function (rowdata, rowindex, value, column){
                            return Number(value).toFixed(1);
                        }
                    },
                    { display: '实收金额', name: '17',     align: 'center', width: "5%",
                        render: function (rowdata, rowindex, value, column){
                            return Number(value).toFixed(1);
                        }
                    },
                    { display: '是否销账', name: '10',     align: 'center', width: "5%",
                        render: function (rowdata, rowindex, value, column){
                            if(value=='yes'){
                                return "是";
                            }
                            if(value=='no'){
                                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: '超10-30%的水量', name: '27',     align: 'center', width: "5%"		            },

                    { display: '超30%以上的水量', name: '28',     align: 'center', width: "5%"		            },
                    { display: '超10-30%的金额', name: '30',     align: 'center', width: "5%",
                        render: function (rowdata, rowindex, value, column){
                            return Number(value).toFixed(1);
                        }
                    },

                    { display: '超30%以上的金额', name: '29',     align: 'center', width: "5%",
                        render: function (rowdata, rowindex, value, column){
                            return Number(value).toFixed(1);
                        }
                    },

                    { display: '总金额', name: '31',     align: 'center', width: "5%",
                        render: function (rowdata, rowindex, value, column){
                            return Number(value).toFixed(1);
                        }
                    },
                    { display: '操作', isAllowHide: false, align: 'center', width:"15%",
                        render: function (rowdata, rowindex, value, column){
                            return '<div class="padding_top4 padding_left20">'
                                <@pop_perm url="/yearhfAssessment/update.do">
                                + '<a href="#"  onclick="onEdit('+ rowdata[0]+')"><span class="icon_edit">修改</span></a>'
                                </@pop_perm>
                                <@pop_perm url="/yearhfAssessment/delete.do">
                                + '<a href="#"  onclick="onDelete('+ rowdata[0]+')"><span class="icon_delete">删除</span></a>'
                                </@pop_perm>
                                + '</div>';
                        }
                    }],
                toolbar:{
                    items:[
                    <@pop_perm url="/yearhfAssessment/create.do">
                {text:'新增',click:onCreate,iconClass:'icon_add'},
        </@pop_perm>

            <@pop_perm url="/yearhfAssessment/update.do">
                {line:true},
                {text:'修改',click:onEdit1, iconClass:'icon_edit'},
        </@pop_perm>

            <@pop_perm url="/yearhfAssessment/delete.do">
                {line:true},
                {text:'批量删除',click:batchDelete, iconClass:'icon_delete'},
        </@pop_perm>
            <@pop_perm url="/yearhfAssessment/print.do">
                {line:true},
                {text:'打印',click:print, iconClass:'icon_print'},
        </@pop_perm>
            <@pop_perm url="/yearhfAssessment/exportExcel.do">
                {line:true},
                {text:'导出',click:exportExcel, iconClass:'icon_export'},
        </@pop_perm>

            <@pop_perm url="/yearhfAssessment/wx.do">
                {line:true},
                {text:'wx',click:wx, 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}/yearhfAssessment/print.do?exportType=list&pageNo=1&pageSize="+total_rows);
        // 	    }

        //打印
        function print(){
            var rows = g.getSelectedRows();
            var rowsLength = rows.length;
            var ids = getCheckedIdHandler();
            if(rowsLength == 0 && ids=='') {
                printByPage();
                return;
            }

            window.open("${ctx}/yearhfAssessment/print.do?exportType=list&ids="+ids+"&flag=selected&pageNo=1&pageSize="+total_rows);
            return;
        }

        //打印
        function wx(){
            window.open("${ctx}/yearhfAssessment/wx.do");
            return;
        }
        function printByPage(){
            var orgNumber=$("#orgNumber").val();
            var orgName=$("#orgName").val();
            var address=$("#address").val();
            var year=$("#year").val();
            var busOrgCustomerNumber=$("#busOrgCustomerNumber").val();
            var busOrgMeterNumber=$("#busOrgMeterNumber").val();
            var yearhf=$('#yearhf').val();

            var overWaterBegin=$('#overWaterBegin').val();
            var overWaterEnd=$('#overWaterEnd').val();
            var amountReceivableBegin=$('#amountReceivableBegin').val();
            var amountReceivableEnd=$('#amountReceivableEnd').val();
            var isPlanUser=$("#isPlanUser").val();
            var userType=$("#userType").val();

            var url="${ctx}/yearhfAssessment/print.do?";
            url +="orgNumber="+orgNumber;
            url +="&orgName="+orgName;
            url +="&address="+address;
            url +="&year="+year;
            url +="&busOrgCustomerNumber="+busOrgCustomerNumber;
            url +="&busOrgMeterNumber="+busOrgMeterNumber;
            url +="&yearhf="+yearhf;

            url +="&overWaterBegin="+overWaterBegin;
            url +="&overWaterEnd="+overWaterEnd;
            url +="&amountReceivableBegin="+amountReceivableBegin;
            url +="&amountReceivableEnd="+amountReceivableEnd;
            url +="&isPlanUser="+isPlanUser;
            url +="&userType="+userType;

            url +="&flag=query";
            url +="&exportType=list";
            url +="&pageNo=1";
            url +="&pageSize="+total_rows;
            url = encodeURI(encodeURI(url));
            window.open(url);
        }

        /**初始时通过向后台传递排序id、排序顺序、初始页码、每页条数**/
        function getData(pageNo,pageSize){
            jQuery.post("${ctx}/yearhfAssessment/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 getData2(sort,direction,pageNo,pageSize){
            $.post("${ctx}/yearhfAssessment/listPage.do",
                {
                    "pageNo":pageNo,
                    "pageSize":pageSize
                },
                function(result){
                    gridData = result;
                    //刷新表格
                    g.loadData(gridData);
                },"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}/yearhfAssessment/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}/yearhfAssessment/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}/yearhfAssessment/create.do?year="+$('#year').val(),
                Title:"新增半年考核",
                Width:700,
                Height:350
            });
        }


        //修改单位基本信息
        function onEdit1() {
            var rows = g.getSelectedRows();
            var rowsLength = rows.length;
            if(rowsLength == 0) {
                top.Dialog.alert("请选中要编辑的记录!");
                return;
            }
            if(rowsLength > 1) {
                top.Dialog.alert("请只选中一条要编辑的记录!");
                return;
            }

            var selectedRows = g.getSelectedRows();

            top.Dialog.open({
                URL : "${ctx}/yearhfAssessment/update.do?entity_id="+selectedRows[0][0],
                Title : "编辑单位半年考核用水",
                Width : 800,
                Height : 500
            });


        }
        //修改
        function onEdit(rowId){
// 		alert(rowId);
            top.Dialog.open({
                ID:'a1',
                URL:"${ctx}/yearhfAssessment/update.do?entity_id="+rowId,
                Title:"修改水表",
                Width:700,
                Height:350
            });
        }

        //导出单位半年考核用水
        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}/yearhfAssessment/exportExcel.do?&ids="+ids+"&flag=selected&exportType=list&pageNo=1&pageSize="+total_rows;
            return;

        }


        //导出处理
        function exportExcelByPage(){
            var orgNumber=$("#orgNumber").val();
            var orgName=$("#orgName").val();
            var address=$("#address").val();
            var year=$("#year").val();
            var busOrgCustomerNumber=$("#busOrgCustomerNumber").val();
            var busOrgMeterNumber=$("#busOrgMeterNumber").val();
            var yearhf=$('#yearhf').val();

            var overWaterBegin=$('#overWaterBegin').val();
            var overWaterEnd=$('#overWaterEnd').val();
            var amountReceivableBegin=$('#amountReceivableBegin').val();
            var amountReceivableEnd=$('#amountReceivableEnd').val();
            var isPlanUser=$("#isPlanUser").val();
            var userType=$("#userType").val();

            var url="${ctx}/yearhfAssessment/exportExcel.do?";
            url +="orgNumber="+orgNumber;
            url +="&orgName="+orgName;
            url +="&address="+address;
            url +="&year="+year;
            url +="&busOrgCustomerNumber="+busOrgCustomerNumber;
            url +="&busOrgMeterNumber="+busOrgMeterNumber;
            url +="&yearhf="+yearhf;

            url +="&overWaterBegin="+overWaterBegin;
            url +="&overWaterEnd="+overWaterEnd;
            url +="&amountReceivableBegin="+amountReceivableBegin;
            url +="&amountReceivableEnd="+amountReceivableEnd;
            url +="&isPlanUser="+isPlanUser;
            url +="&userType="+userType;

            url +="&flag=query";
            url +="&exportType=list";
            url +="&pageNo=1";
            url +="&pageSize="+total_rows;
            url = encodeURI(encodeURI(url));
            window.location =url;
            return false;
        }

        var checkedArray = [];
        function findCheckedArray(id){
            for(var i =0;i<checkedArray.length;i++){
                if(checkedArray[i] == id) return i;
            }
            return -1;
        }

        function addCheckedArray(id){
            if(findCheckedArray(id) == -1){
                checkedArray.push(id);
            }
        }

        function getCheckedIdHandler(){
            return checkedArray.join(',');
        }

        function removeCheckedArray(id){
            var i = findCheckedArray(id);
            if(i==-1) return;
            checkedArray.splice(i,1);
        }

        function checkedHandler(rowdata){
            if (findCheckedArray(rowdata[0]) == -1)
                return false;
            return true;

        }

        function checkRowHandler(checked, data){
            if (checked) addCheckedArray(data[0]);
            else removeCheckedArray(data[0]);
        }

        function checkAllRowHandler(checked){
            for (var rowid in this.records){
                if(checked)
                    addCheckedArray(this.records[rowid][0]);
                else
                    removeCheckedArray(this.records[rowid][0]);
            }
        }

        //清空数组
        function clearArray(){
            checkedArray.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>单位编号：</td>
                <td><input type="text" id="orgNumber" name="orgNumber" /></td>
                <td>单位名称：</td>
                <td><input type="text" id="orgName" name="orgName" /></td>
                <td>单位地址：</td>
                <td><input type="text" id="address" name="address" /></td>
                <td>年度：</td>
                <td><input class="date" dateFmt="yyyy" type="text" id="year"
                           name="year" value="${year!''}" /></td>
            </tr>
            <tr>
                <td>超用水量(≥):：</td>
                <td><input type="text" id="overWaterBegin"
                           name="overWaterBegin" /></td>
                <td>并且(≤)：</td>
                <td><input type="text" id="overWaterEnd" name="overWaterEnd" /></td>
                <td>应收金额(≥):：</td>
                <td><input type="text" id="amountReceivableBegin"
                           name="amountReceivableBegin" /></td>
                <td>并且(≤)：</td>
                <td><input type="text" id="amountReceivableEnd"
                           name="amountReceivableEnd" /></td>
            </tr>
            <tr>
                <td>客户号：</td>
                <td><input type="text" id="customerNumber"
                           name="customerNumber" /></td>
                <td>水表编号：</td>
                <td><input type="text" id="meterNumber" name="meterNumber" /></td>
                <td>半年度：</td>
                <td><select prompt="请选择" id="yearhf" name="yearhf"
                            data='{"list":[{"value":"1","key":"上半年"},{"value":"2","key":"下半年"}]}'></select></td>
                <td>是否计划户：</td>
                <td><select prompt="请选择" id="isPlanUser"
                            data='{"list":[{"value":"yes","key":"计划户"},{"value":"no","key":"非计划户"}]}'
                            name="isPlanUser"></select></td>
            </tr>
            <tr>
                <td>用户类型：</td>
                <td><select prompt="请选择" id="userType" data='${userType}'
                            name="userType"></select></td>
                <td>用水单价：</td>
                <td><select id="waterPrice" name="waterPrice">
                    <option value="">请选择</option>
                    <option value="0.00">0.00</option>
                    <option value="0.10">0.10</option>
                    <option value="1.14">1.14</option>
                    <option value="1.21">1.21</option>
                    <option value="1.45">1.45</option>
                    <option value="1.49">1.49</option>
                    <option value="2.20">2.20</option>
                    <option value="4.97">4.97</option>
                </select></td>
                <td style="padding-left: 15px;"><button type="reset"
                                                        onclick="resetSearch()">
                    <span class="icon_find">重置</span>
                </button></td>
                </td>
                <td style="padding-left: 15px;"><button type="button"
                                                        onclick="searchHandler()">
                    <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 id="pageContent" style="height:35px;"></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>