meidu2021/daju/WebRoot/webpage/cn/com/lzt/report/supplierSumRpt.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@include file="/context/mytags.jsp"%>
<t:base type="jquery,easyui,tools,DatePicker"></t:base>
<script type="text/javascript" src="plug-in/jquery/jquery.jqprint.js"></script>
<script type="text/javascript" src="plug-in/jquery/jquery-migrate-1.2.1.min.js"></script>
<div  class="easyui-layout" fit="true">
  <div region="center" style="padding:0px;border:0px">
  <t:datagrid name="ordersReportList" checkbox="false" autoLoadData="false" fitColumns="false" title="供应商供货汇总表" actionUrl="purchaseRptController.do?datagridsupplierSumRpt" 
  	idField="id" fit="true" queryMode="group" pagination="false">
   <t:dgCol title="主键"  field="goodsId"  hidden="true"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="主键"  field="supplierid"  hidden="true"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="单据日期"  field="orderDate"   hidden="true"  formatter="yyyy-MM-dd" queryMode="group"  query="true" width="150"></t:dgCol>
   <t:dgCol title="货品名称"  field="pname"    queryMode="single"  width="180"></t:dgCol>
   <t:dgCol title="供应商名称"  field="supplierName"    queryMode="single" query="true"  width="180"></t:dgCol>
   <t:dgCol title="规格"  field="specType"    queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="计量单位"  field="measureUnit"  dictionary="metering_calcu_unit" align="center" queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="数量"  field="quantity"  formatterjs="formatterNum"  queryMode="single" align="right"  width="120"></t:dgCol>
   <t:dgCol title="领料点名称"  field="warehouseName" hidden="true"   queryMode="single" query="true"  width="120"></t:dgCol>
   <t:dgCol title="金额"  field="money"  formatterjs="formatterNum"  queryMode="single"  align="right" width="120"></t:dgCol>
   <t:dgCol title="未到货数量"  field="quantityNotArrived"  formatterjs="formatterNum"  align="right" queryMode="single"  width="120"></t:dgCol>
   <t:dgToolBar title="导出" icon="icon-put" operationCode="put"  funname="ExportXls"></t:dgToolBar>
   <t:dgToolBar title="查看明细" icon="icon-search" funname="showDetail"></t:dgToolBar>
  </t:datagrid>
  </div>
  
 </div>
 <script src = "webpage/cn/com/lzt/ordersreport/ordersReportList.js"></script>
  <script type="text/javascript" src="plug-in/tools/money.js"></script>		
 <script type="text/javascript">
 $(document).ready(function(){
 		//给时间控件加上样式
 			$("input[name='orderDate_begin']").attr("class","Wdate").click(function(){WdatePicker({dateFmt:'yyyy-MM-dd'});});
 			$("input[name='orderDate_end']").attr("class","Wdate").click(function(){WdatePicker({dateFmt:'yyyy-MM-dd'});});
 			$(":input[name='orderDate_begin']").css("width","200px");
 			$(":input[name='orderDate_begin']").val('${orderDate_begin}');
 			$(":input[name='orderDate_begin']").css("margin","5px");
 			$(":input[name='orderDate_end']").css("width","200px");
 			$(":input[name='orderDate_end']").val('${orderDate_end}');
 			$(":input[name='orderDate_end']").css("margin","5px");
 			$(":input[name='warehouseName']").css("width","200px");
 			$(":input[name='warehouseName']").css("margin","5px");
 			$(":input[name='supplierName']").css("width","200px");
 			$(":input[name='supplierName']").css("margin","5px");
 });
 
 function showDetail(){
	 var gridname="ordersReportList";
		var rowsData = $('#'+gridname).datagrid('getSelections');
		if (!rowsData || rowsData.length==0) {
			tip('请选择一条数据，然后查看明细');
			return;
		}
		var goodsId = rowsData[0].goodsId;
		var supplierid = rowsData[0].supplierid;
		var orderDate_end = $(":input[name='orderDate_end']").val();
		var orderDate_begin = $(":input[name='orderDate_begin']").val();
		var warehouseName = $(":input[name='warehouseName']").val();
		createdetailwindow('供应商【'+rowsData[0].supplierName+'】供货【'+rowsData[0].pname+'】明细',
				'purchaseRptController.do?supplierSumRptDetail&goodsId='+goodsId+'&supplierid='+supplierid
						+'&orderDate_begin='+orderDate_begin+'&orderDate_end='+orderDate_end+'&warehouseName='+warehouseName,
				'1300','700');
 }   

//导出
function ExportXls() {
	JeecgExcelExport("purchaseRptController.do?exportxmlSupplierSumRpt","ordersReportList");
}
 </script>