skyversation
/
meidu2021


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352
							<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@include file="/context/mytags.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

  <t:base type="jquery,easyui,tools,DatePicker"></t:base>
  
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  
<head>
  
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  
<title></title>
  
<link rel="stylesheet" type="text/css" media="screen" href="plug-in/jqgrid/css/css/cupertino/jquery-ui-1.8.16.custom.css" />

<link rel="stylesheet" type="text/css" media="screen" href="plug-in/ace/css/ui.jqgrid.css" />  
  
<link rel="stylesheet" type="text/css" media="screen" href="plug-in/jqgrid/js/src/css/jquery.searchFilter.css" />
  
<!--  <script type="text/javascript" src="plug-in/jqgrid/js/jquery-1.7.1.js"></script> 
<script type="text/javascript" src="plug-in/jquery/jquery-1.9.0.min.js"></script> -->

<script type="text/javascript" src="plug-in/jquery/jquery-1.11.3.min.js"></script>
<script type="text/javascript" src="plug-in/jquery/jquery.jqprint.js"></script>
<script type="text/javascript" src="plug-in/jqgrid/js/jquery.jqGrid.src.js"></script>
<script type="text/javascript" src="plug-in/jqgrid/js/i18n/grid.locale-cn.js"></script>
<script type="text/javascript" src="plug-in/tools/curdtools_zh-cn.js"></script>
<script type="text/javascript" src="plug-in/lhgDialog/lhgdialog.min.js?skin=metrole"></script>
<script src = "webpage/cn/com/lzt/report/purchaseRptCommon.js"></script>	
<script type="text/javascript" src="plug-in/tableExport/libs/FileSaver/FileSaver.min.js"></script>
<script type="text/javascript" src="plug-in/tableExport/libs/js-xlsx/xlsx.core.min.js"></script>
<script type="text/javascript" src="plug-in/tableExport/tableExport.min.js"></script>

  	
<style>
        .ui-jqgrid {
            font-size: 14px;
        }


        .ui-jqgrid-view {
            font-size: 14px;
        }


        .ui-jqgrid .ui-jqgrid-htable th {
            height: 28px;
            font-size: 14px;  /* 14 */
        }
        .ui-jqgrid .ui-jqgrid-btable {
       		height: 28px;
            font-size: 12px;
        }
		.ui-jqgrid .ui-jqgrid-ftable {
			font-size: 13px;
		}

        .ui-jqgrid .ui-jqgrid-pager {
            height: 28px;
            font-size: 14px;   /* 14 */
        }


        .ui-jqgrid .ui-pg-input {
            font-size: 1em;
            height: 20px;
        }


        .ui-jqgrid .i-pg-selbox {
            font-size: 0.9em;
            height: 20px;
        }


        .ui-jqgrid tr.ui-row-ltr td {
            text-align: center;
        }
        .ui-jqgrid tr.footrow-ltr td {
        	text-align: center;
        }
        
        .ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default 
        { 
        	background: #5187c9 ; 
        	color: #fffbf8; 
        }
        .ui-widget-content
        {
        	background:#fff;
        }
    </style>

  
</head>
  
<body style="background:#FFFFFF">
<!-- <form id="form1" runat="server"> -->
        <div>
             <div id="div2">
             <%--查询框begin --%>
		<table cellpadding="0"  cellspacing="1" class="formtable" style="position:fixed;top:5px;"> <!--  bottom -->
		 <tr >
		 	<td align="left" width="600px">
				<label class="Validform_label">领料点: </label>
          		 <input id="warehouseId" name="warehouseId" type="hidden"  >
         	     <input name="warehouseName"   type="text" class="inputxt"   style="width: 150px" id="warehouseName" readonly="readonly" />
         		  <span class="Validform_checktip"></span>
                 <label class="Validform_label" style="display: none;">领料点</label>
         			 <t:choose hiddenName="warehouseId" hiddenid="id" url="pOrdersController.do?selectReferWareHouse&classname=cn.com.lzt.warehouse.entity.WarehouseEntity&codefield=warehouseCode&namefield=warehouseName" name="list"
                     left="40%" width="450px" height="700px" icon="icon-search" title="领料点"  textname="warehouseName" isclear="true" isInit="true" ></t:choose>
     		 </td>
		</tr>
	   <tr>
     		 <td class="value">
     		 <span class="spancon"	title="attType">统计频度：</span>
				<select name="attType" id="attType" width="100" onchange="tyepChange()"	style="width: 134px">
					<option value="0" selected="selected">月度</option>
					<option value="1">季度</option>
					<option value="2">年度</option>
				</select>
			</span>
			<input type="text" id="attYear" name="attYear" style="width: 94px;" class="Wdate" onclick="WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,lang:'zh-cn',dateFmt:'yyyy'})">
				<span	style="display:-moz-inline-box;display:inline-block;width: 20px;text-align:center;">年</span>
				<input	type="text" id="attMonth" name="period" style="width: 94px;" class="Wdate" onclick="WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,lang:'zh-cn',dateFmt:'MM'})">
				<span	style="display:-moz-inline-box;display:inline-block;width: 20px;text-align:center;">月</span>
				<select style="width: 104px;background: #f0f0f0;" id="attQuarters" disabled="disabled" name="attQuarters">
					<option value="1">1</option>
					<option value="2">2</option>
					<option value="3">3</option>
					<option value="4">4</option>
				</select>
				<span	style="display:-moz-inline-box;display:inline-block;width: 40px;text-align:center;">季度</span>
     		 </td>
		<%-- 	<td align="right">
				<label class="Validform_label"> 月度: </label>
			</td>
			<td class="value">
				<input id="period" name="period" type="text" style="width: 150px" class="Wdate" readonly="readonly" value="${period}"  
							onClick='WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,dateFmt: "yyyyMM"})'  datatype="*"  ignore="ignore" />   
				<label class="Validform_label" style="display: none;"> 采购期间: </label>
			</td> --%>
			<span style="float: left;padding-left: 774px;padding-top: 34px;" > 
			
			<td height="50px" align="right" colspan="8" valign="top">
				<a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-search"  onclick="btn_query()">查询</a>  
				<a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-putout"  onclick="btn_output()">导出excel</a>  
			</td>
		<!-- 	<td height="50px" align="right" colspan="8"> -->
				<!-- <a  href="#" class="easyui-linkbutton l-btn"  iconcls="icon-search" style="width: 100px;" onclick="btn_query()">&nbsp; &nbsp; 查     询&nbsp; &nbsp;&nbsp; </a>  
				 -->
		<!-- 	</td> -->
		</span>
		</tr>
	   <tr>
			<!-- <table id="jqGrid"></table>   
			<div id="pager2"></div> -->
	   </tr>
	</table>
	<%--查询框end --%>
	 </div>
	 <br/><br/><br/>
            <div id="div1">
                <table id="jqGrid"></table>   
			<div id="pager2"></div> 
            </div>
        </div>
<!--     </form>
 -->
 

<script>
$(function(){
	setDefault();
	_rpttitle='物料采购分类汇总表';
});
function btn_query()
{
	showGridTable();
}


function showGridTable() {

	var attType = $("#attType").val();
	var attYear = $("#attYear").val();
	var attMonth = $("#attMonth").val();
	var attQuarters = $("#attQuarters").val();
	var warehouseid = $("#warehouseId").val();
	var requrl='purchaseRptController.do?projectPurchaseSum4LeaderRptData';
	requrl+=('&attType='+attType);
	requrl+=('&attYear='+attYear);
	requrl+=('&attMonth='+attMonth);
	requrl+=('&attQuarters='+attQuarters);
	if(warehouseid != null)
		requrl+=('&warehouseid='+warehouseid);
	var scope = '月  份';
	var curTitle = '本此成本金额';
	var laseTitle = '上此成本金额';
	if(attType == '0'){
		var scope = '月  份';
		var curTitle = '本此成本金额';
		var laseTitle = '上此成本金额';
	}else if(attType == '1'){
		var scope = '季度月份';
		var curTitle = '本季成本金额';
		var laseTitle = '上季成本金额';
	}else {
		var scope = '年度月份';
		var curTitle = '本年成本金额';
		var laseTitle = '上年成本金额';
	}
    $("#div1").empty();
    $("#div1").html("<table class='jqgrid' id='jqGrid'></table><div class='jqgridpager' id='pager2'></div>");

    $("#jqGrid").jqGrid({
        url: requrl,
    	caption:'<div style="text-align:center;font-size: 14px;"><span>物料采购分类汇总表</span></div>',
        datatype: "json",
        colModel: [  
        	 { label: '领料点名称', name: 'projectName', width: 200 ,sortable:false},   
             { label: scope, name: 'period', width: 120 ,sortable:false},             
             { label: '货品分类名称', name: 'rootclassname', width: 200 ,sortable:false}, 
           /*   { label: '存货型号', name: 'specType', width: 80 },     */         
             { label: curTitle, name: 'amount', width: 160 , formatter:'number',align:'right',summaryType:'sum', summaryTpl:'<b>小计: {0}</b>',sortable:false} , 
             { label: laseTitle, name: 'preamount', width: 160 , formatter:'number',align:'right',summaryType:'sum', summaryTpl:'<b>小计: {0}</b>',sortable:false}  
        ],
        viewrecords: true,
        height: 500,
        rowNum: -1,
        rownumbers: true, 
        rownumWidth: 25, 
        autowidth:false,
        multiselect: false,

        //分组
        viewrecords: true, 
        sortname: 'projectName', //需要分组的列
        grouping:true,
        groupingView : {
              groupField : ['projectName'], //需要分组的列
              groupSummary : [true],         //是否显示汇总  如果为true需要在colModel中进行配置 如： summaryType:'sum', summaryTpl:'<b>小计: {0}</b>''
              groupColumnShow : [true],      //是否显示分组列
              groupText : ['<b>{0}</b>'],    //在分组的头部显示的信息
              groupCollapse : false,         //该属性表示在加载数据的时候是否只显示分组信息，false表示既显示分组信息也显示每个分组里面的详细信息，true则只显示分组信息
        },  
        //统计
        footerrow:true,                   //开启统计
        userDataOnFooter : true,          //在页脚显示统计
        altRows : true ,

        pager: "#jqGridPager",
        jsonReader : {
            root: "page.list",
            page: "page.currPage",
            total: "page.totalPage",
            records: "page.totalCount"
        },
        prmNames : {
            page:"page", 
            rows:"limit", 
            order: "order"
        },

        gridComplete:function(){
            //隐藏grid底部滚动条
            $("#jqGrid").closest(".ui-jqgrid-bdiv").css({ "overflow-x" : "hidden" }); 

            var rowNum=parseInt($(this).getGridParam("records"),10);
            if(rowNum>0){    
                 $(".ui-jqgrid-sdiv").show();
	             var sum_inAmount     = $(this).getCol("amount",false,"sum"); 
	             var sum_preamount      = $(this).getCol("preamount",false,"sum");  
	
	            $(this).footerData("set",{"projectName" : "合计:",
                                          "amount" : sum_inAmount,
                                           "preamount" : sum_preamount }); //将合计值显示出来
	            _hasSearch=true;
             }else{
                 $(".ui-jqgrid-sdiv").hide();
            }
            _hasSearch=true;
        }
    });
}
$("#jqGrid").jqGrid({
	url :'purchaseRptController.do?projectPurchaseSum4LeaderRptData&load=false',
	datatype: "json",
	caption:'<div style="text-align:center;font-size: 14px;"><span>物料采购分类汇总表</span></div>',
    colModel: [  
   	 { label: '项目名称', name: 'projectName', width: 200 ,sortable:false},   
     { label: '统计月份', name: 'period', width: 120 ,sortable:false},             
     { label: '货品分类名称', name: 'rootclassname', width: 200 ,sortable:false}, 
   /*   { label: '存货型号', name: 'specType', width: 80 },     */         
     { label: '本月成本金额', name: 'amount', width: 160 , summaryType:'sum', summaryTpl:'<b>小计: {0}</b>',sortable:false} , 
     { label: '上月成本金额', name: 'preamount', width: 160 , summaryType:'sum', summaryTpl:'<b>小计: {0}</b>',sortable:false}   
    ],
 
    viewrecords: true,
    height: 500,
    rowNum: -1,
    rownumbers: false, 
    rownumWidth: 25, 
    autowidth:false,
    multiselect: false,
    //统计
    footerrow:true,                   //开启统计
    userDataOnFooter : true,          //在页脚显示统计
    altRows : true ,

    pager: "#jqGridPager",
    jsonReader : {
        root: "page.list",
        page: "page.currPage",
        total: "page.totalPage",
        records: "page.totalCount"
    },
    prmNames : {
        page:"page", 
        rows:"limit", 
        order: "order"
    },

    gridComplete:function(){
        //隐藏grid底部滚动条
        $("#jqGrid").closest(".ui-jqgrid-bdiv").css({ "overflow-x" : "hidden" }); 

        var rowNum=parseInt($(this).getGridParam("records"),10);
        if(rowNum>0){    
                 $(".ui-jqgrid-sdiv").show();
         var sum_inAmount     = $(this).getCol("amount",false,"sum"); 
         var sum_preamount      = $(this).getCol("preamount",false,"sum"); 

        $(this).footerData("set",{"projectName" : "合计:",
                                      "amount" : sum_inAmount ,
                                       "preamount" : sum_preamount }); //将合计值显示出来
                }else{
                         $(".ui-jqgrid-sdiv").hide();
        }
    }/*,
    autowidth:true,
    height: 500 ,
    datatype:"local" */
});

</script>
  
</body>
  
</html>