zhuhongbin
/
TMRWatchNew


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167
							<%@ page contentType="text/html; charset=utf-8" session="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<head>
<title>我的工作台</title>
<%@ include file="../common/header.jsp" %>
<script type="text/javascript" src="${contextPath }/js/calendar/WdatePicker.js"></script>
<script type="text/javascript" language="javascript" src="${contextPath}/js/highslide.js"></script>
<script type="text/javascript">
	var mydata,loadcount=0,type = "link";
	$(document).ready( function() {
		$("input.datebox").bind("click", function() {WdatePicker();});
		setNowDate();
	});
	
	//初始化日期
	function setNowDate(){
		var myDate = new Date();
		var year = myDate.getFullYear();
		var month = myDate.getMonth()+1;
		var day = myDate.getDate();
		var yesterday = day-1;
		var nowdate = year + "-" + month + "-" + day;
		$("#endDate").val(nowdate);
		var lastmonth = myDate.getMonth();
		var lastdate = year + "-" + month + "-" + yesterday;		
		$("#beginDate").val(lastdate);
	}
	function leftDate(){
		var beginDate = $("#beginDate").val();
		var endDate = $("#endDate").val();
		var newbDate = checkDate(beginDate,"left");
		var neweDate = checkDate(endDate,"left");
		$("#beginDate").val(newbDate);
		$("#endDate").val(neweDate);
		queryDate();	//加载jqgrid
	}
	function rightDate(){
		var beginDate = $("#beginDate").val();
		var endDate = $("#endDate").val();
		var newbDate = checkDate(beginDate,"");
		var neweDate = checkDate(endDate,"");
		$("#beginDate").val(newbDate);
		$("#endDate").val(neweDate);
		queryDate();	//加载jqgrid
	}
	//查询数据
	function queryDate(){
		//清空主表数据重新加载一次
		//$("#list").clearGridData();
		//loadList();
		var beginDate = $("#beginDate").val();
		var endDate = $("#endDate").val();
		var d1 = new Date(beginDate.replace(/\-/g, "\/"));  
 		var d2 = new Date(endDate.replace(/\-/g, "\/")); 
		confirmdate();
		if(beginDate==""){
			alert("请选择开始日期");
			$("#beginDate").focus();
		}else if(endDate==""){
			alert("请选择结束日期");
			$("#endDate").focus();
		}
		else if(d1>d2){
			alert("开始日期不能大于结束日期");
		}
		else{
			if(type == "link"){
				loadList();  //第一次加载jqgrid
				type = "query";
			}else{
				//重新加载json类型
				jQuery("#list").jqGrid("setGridParam",{ 
										                url:"${contextPath }/admin/feedstorage/storagelist.html",
										                postData:{"beginDate":beginDate,"endDate":endDate}
								                	  }
				).trigger("reloadGrid");
			}
		}
		$("#list").jqGrid("setGridHeight",$(window).height() - 135);
		$("#list").jqGrid("setGridWidth",document.body.clientWidth - 5);
	}
	//导出配方
	function exportExcel(){
		var beginDate = $("#beginDate").val();
		var endDate = $("#endDate").val();
		document.location.href="${contextPath}/admin/feedstorage/feedstoragereportExcel.html?beginDate="+beginDate+"&endDate="+endDate;
	}
	
	function confirmdate(){
		var beginDate=$("#beginDate").val();
		$.ajax({
				async: false,
				type: 'POST',
				data: "beginDate="+beginDate,
				dataType: 'json',
				url: "${contextPath}/admin/feedstorage/checkbdate.html",
				error: function(){alert("系统错误");},
				success: function(json){
					if(json.status == "success"){
						return true;
					}
					else{
						alert(json.msg);
						return false;
					}
				}
			});
	}
	
		//jqgrid初始化
	function loadList(){
	
		var beginDate = $("#beginDate").val();
		var endDate = $("#endDate").val();
	
		jQuery("#list").jqGrid({ 
			url: "${contextPath }/admin/feedstorage/storagelist.html?beginDate="+beginDate+"&endDate="+endDate,
			datatype: "json",  //从服务器端返回的数据类型，（表格期望接收的数据类型）。可选类型：xml，xmlstring，json，local，function
			colNames:["饲料名称","期初","入库","损耗","用料","期末"],  //列名
			colModel:[
				{name: "FeedName",index: "FeedName", align: "center",sortable:false},
				{name: "qc",index: "qc", align: "center",sortable:false},
				{name:"rk",index: "rk", align: "center",sortable:false},				
				{name:"sh",index: "sh", align: "center",sortable:false},
				{name: "yl",index: "yl", align: "center",sortable:false}, 
				{name: "qm",index: "qm",width:"100px", align: "center",sortable:false},
			],
			caption: "库存信息",	//标题
			pager: "#page",	//#page分页控件绑定的位置对象
			rowNum: 500,	//每页显示条数
		   	rowList: [15,30,50],	//分页下拉选项内容
			viewrecords: true,		//是否显示总条数
		   	emptyrecords: "无数据",	//服务器返回空列表时显示的内容
		   	autowidth: true,	//自动调节宽度
		   	
		   	toolbar: [true,"top"],
		   	
		    jsonReader: {
		        root: "rows",	//数据行
		        page: "page",	// 当前页
		        total: "total",	// 总页数
		        records: "records",	//总共有几条记录
		        repeatitems: false,	// 设置成false，在后台设置值的时候，可以乱序。且并非每个值都得设
		        cell: "cell",
		        id: "FeedName"
		    }
		 
		});}
</script>
<body style="background-color: #E0E0E0">
<div>
	<div class="navfrm">		
			<span>当前位置：</span>
			<span><a href="${contextPath }/admin/welcome.html">首页</a></span>
			<span>&nbsp;>>&nbsp;</span>
			<span>库存量统计</span>		
	</div>
	<input id="beginDate" name="beginDate" style="width:100px;" class="datebox" value="" /> - 
	<input id="endDate" name="endDate" style="width:100px;" class="datebox" value=""/>
	<input type="button" value="<" onclick="leftDate();" /><input type="button" value=">" onclick="rightDate();" />
	<input type="button" value="统计" onclick="queryDate()" class="sysub" />
	<input type="button" value="导出Excel" onclick="exportExcel()" class="sysub" />
	<table id="list"></table>
</div>
</body>
</html>