XinYu_RZMES/WebContents/H/H05/UIH051900.xrw

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet href="../../css/body.css" type="text/css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>
			<![CDATA[热轧作业>>钢卷库管理>>入库品种规格说明表(UIH051800)]]>
		</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<reqData/>
					<resData/>
					<searchDate>
						<PRD_YYYYMM/>
						<FROM_DATE/>
						<FROM_DTIME/>
						<TO_DATE/>
						<TO_DTIME/>
						<F_TIME/>
						<T_TIME/>
					</searchDate>
					<datagrid1/>
					<GG/>
				</root>
			</instance>
		</model>
		<script type="javascript" src="../../js/boaMsg.js"/>
		<script type="javascript" src="../../js/boaCommon.js"/>
		<script type="javascript">
			<![CDATA[
					function Init(node) {
					InitParams(node);
				}
				//调用公共的初始化方法获得登录用户名
				function InitParams(node) {
					if (typeof node == "undefined" && typeof node != "object") return;
					model.removenode("/root/initData/rcvInfo");
					model.makeNode("/root/initData/rcvInfo");
					var nodeList = node.childNodes;
					node = model.instances(0).selectSingleNode("/root/initData/rcvInfo");
					for (var i = 0; i < nodeList.length; i++)
						node.appendChild(nodeList.item(i));
				}
				
				function excelExport(){
					return datagrid1;
				}
				
				function find(){
					
					if(commDiffDay(input1.value,input2.value)>90)
					{
						alert(" 查询时间过长，请重新选择三个月内数据查询！！ ");
					    return;
					}
					
					model.removenode("/root/reqData");
					model.makeNode("/root/reqData");
					
					var FROM_DATE = model.getValue("/root/searchDate/FROM_DATE");
					var FROM_DTIME = model.getValue("/root/searchDate/FROM_DTIME");
					var TO_DATE = model.getValue("/root/searchDate/TO_DATE");
					var TO_DTIME = model.getValue("/root/searchDate/TO_DTIME");
					
					var F_TIME = null;
					var T_TIME = null;
					
					F_TIME = FROM_DATE+FROM_DTIME;
					T_TIME = TO_DATE+TO_DTIME;
					
					model.setValue("/root/searchDate/F_TIME",F_TIME);
					model.setValue("/root/searchDate/T_TIME",T_TIME);
					model.refresh();
					
					//这里传参数的时候轧制量传带时分秒的出库量传时间段中结尾的那个时间的
					//总量
					model.duplicate("/root/reqData","/root/searchDate/F_TIME");
					model.duplicate("/root/reqData","/root/searchDate/T_TIME");
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					
				    //轧制量
					model.duplicate("/root/reqData","/root/searchDate/F_TIME");
					model.duplicate("/root/reqData","/root/searchDate/T_TIME");
					
					//火运量
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					
					//汽运量
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					
					
					//总发运量
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
					model.duplicate("/root/reqData","/root/searchDate/TO_DATE");
				    
					commSubmit("UIH051900-service", "find1", "glueAction.do");
					
					commAppendData("/root/datagrid1/COIL_RESULT_VO","/root/resData/COIL_RESULT_VO");
					
					model.refresh(); 
					
					var COIL_IN_DAY_NUM_CNT = 0;
					var COIL_IN_DAY_WGT_SUM = 0;
//					var COIL_IN_MON_NUM_CNT = 0;
//					var COIL_IN_MON_WGT_SUM = 0;
					
					var COIL_OUT_T_DAY_NUM_CNT = 0;
					var COIL_OUT_T_DAY_WGT_SUM = 0;
					var COIL_OUT_T_MON_NUM_CNT = 0;
					var COIL_OUT_T_MON_WGT_SUM = 0;
					
					var COIL_OUT_C_DAY_NUM_CNT = 0;
					var COIL_OUT_C_DAY_WGT_SUM = 0;
					var COIL_OUT_C_MON_NUM_CNT = 0;
					var COIL_OUT_C_MON_WGT_SUM = 0;
					
					var COIL_YARD_DAY_NUM_CNT = 0;
     				var COIL_YARD_DAY_WGT_SUM = 0;
//					var COIL_YARD_MON_NUM_CNT = 0;
//					var COIL_YARD_MON_WGT_SUM = 0;
					
					var COIL_OUT_DAY_NUM_CNT = 0;
					var COIL_OUT_DAY_WGT_SUM = 0;
					var COIL_OUT_MON_NUM_CNT = 0;
					var COIL_OUT_MON_WGT_SUM = 0;
					
					//这里需要循环整个表格，统计相应的结果
					var nodeSet1 = datagrid1.nodeset;
					for(var i=1;i<datagrid1.rows;i++){
						var COIL_IN_DAY_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_IN_DAY_NUM");
						var COIL_IN_DAY_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_IN_DAY_WGT");
//						var COIL_IN_MON_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_IN_MON_NUM");
//						var COIL_IN_MON_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_IN_MON_WGT");
						
						COIL_IN_DAY_NUM_CNT += Number(COIL_IN_DAY_NUM_CNT_1);
						if(COIL_IN_DAY_WGT_SUM_1 == null || COIL_IN_DAY_WGT_SUM_1 == ""){
							COIL_IN_DAY_WGT_SUM_1 = 0;
						}

						COIL_IN_DAY_WGT_SUM += parseFloat(COIL_IN_DAY_WGT_SUM_1);
						
//						COIL_IN_MON_NUM_CNT += Number(COIL_IN_MON_NUM_CNT_1);
//						if(COIL_IN_MON_WGT_SUM_1 == null || COIL_IN_MON_WGT_SUM_1 == ""){
//							COIL_IN_MON_WGT_SUM_1 = "0";
//						}
//						
//						COIL_IN_MON_WGT_SUM += parseFloat(COIL_IN_MON_WGT_SUM_1);
						
						var COIL_OUT_T_DAY_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_T_DAY_NUM");
						var COIL_OUT_T_DAY_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_T_DAY_WGT");
						var COIL_OUT_T_MON_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_T_MON_NUM");
						var COIL_OUT_T_MON_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_T_MON_WGT");
						
						COIL_OUT_T_DAY_NUM_CNT += Number(COIL_OUT_T_DAY_NUM_CNT_1);
						if(COIL_OUT_T_DAY_WGT_SUM_1 == null || COIL_OUT_T_DAY_WGT_SUM_1 == ""){
							COIL_OUT_T_DAY_WGT_SUM_1 = "0";
						}
						
						COIL_OUT_T_DAY_WGT_SUM += parseFloat(COIL_OUT_T_DAY_WGT_SUM_1);
						
						COIL_OUT_T_MON_NUM_CNT += Number(COIL_OUT_T_MON_NUM_CNT_1);
						if(COIL_OUT_T_MON_WGT_SUM_1 == null || COIL_OUT_T_MON_WGT_SUM_1 == ""){
							COIL_OUT_T_MON_WGT_SUM_1 = "0";
						}
						
						COIL_OUT_T_MON_WGT_SUM += parseFloat(COIL_OUT_T_MON_WGT_SUM_1);
						
						var COIL_OUT_C_DAY_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_C_DAY_NUM");
						var COIL_OUT_C_DAY_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_C_DAY_WGT");
						var COIL_OUT_C_MON_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_C_MON_NUM");
						var COIL_OUT_C_MON_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_C_MON_WGT");
						
						COIL_OUT_C_DAY_NUM_CNT += Number(COIL_OUT_C_DAY_NUM_CNT_1);
						if(COIL_OUT_C_DAY_WGT_SUM_1 == null || COIL_OUT_C_DAY_WGT_SUM_1 == ""){
							COIL_OUT_C_DAY_WGT_SUM_1 = "0";
						}
						
						COIL_OUT_C_DAY_WGT_SUM += parseFloat(COIL_OUT_C_DAY_WGT_SUM_1);
						
						COIL_OUT_C_MON_NUM_CNT += Number(COIL_OUT_C_MON_NUM_CNT_1);
						if(COIL_OUT_C_MON_WGT_SUM_1 == null || COIL_OUT_C_MON_WGT_SUM_1 == ""){
							COIL_OUT_C_MON_WGT_SUM_1 = "0";
						}
						
						COIL_OUT_C_MON_WGT_SUM += parseFloat(COIL_OUT_C_MON_WGT_SUM_1);
						
						var COIL_YARD_DAY_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_YARD_DAY_NUM");
						var COIL_YARD_DAY_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_YARD_DAY_WGT");
//						var COIL_YARD_MON_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_YARD_MON_NUM");
//						var COIL_YARD_MON_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_YARD_MON_WGT");
//						
						COIL_YARD_DAY_NUM_CNT += Number(COIL_YARD_DAY_NUM_CNT_1);
						if(COIL_YARD_DAY_WGT_SUM_1 == null || COIL_YARD_DAY_WGT_SUM_1 == ""){
							COIL_YARD_DAY_WGT_SUM_1 = "0";
						}
						
						COIL_YARD_DAY_WGT_SUM += parseFloat(COIL_YARD_DAY_WGT_SUM_1);
//						
//						COIL_YARD_MON_NUM_CNT += Number(COIL_YARD_MON_NUM_CNT_1);
//						if(COIL_YARD_MON_WGT_SUM_1 == null || COIL_YARD_MON_WGT_SUM_1 == ""){
//							COIL_YARD_MON_WGT_SUM_1 = "0";
//						}
//						
//						COIL_YARD_MON_WGT_SUM += parseFloat(COIL_YARD_MON_WGT_SUM_1);
						
						var COIL_OUT_DAY_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_DAY_NUM");
						var COIL_OUT_DAY_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_DAY_WGT");
						var COIL_OUT_MON_NUM_CNT_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_MON_NUM");
						var COIL_OUT_MON_WGT_SUM_1 = model.getValue(nodeSet1+"["+i+"]/COIL_OUT_MON_WGT");
						
						COIL_OUT_DAY_NUM_CNT += Number(COIL_OUT_DAY_NUM_CNT_1);
						
						if(COIL_OUT_DAY_WGT_SUM_1 == null || COIL_OUT_DAY_WGT_SUM_1 == ""){
							COIL_OUT_DAY_WGT_SUM_1 = "0";
						}
						
						COIL_OUT_DAY_WGT_SUM +=parseFloat(COIL_OUT_DAY_WGT_SUM_1);
						
						COIL_OUT_MON_NUM_CNT += Number(COIL_OUT_MON_NUM_CNT_1);
						if(COIL_OUT_MON_WGT_SUM_1 == null || COIL_OUT_MON_WGT_SUM_1 == ""){
							COIL_OUT_MON_WGT_SUM_1 = "0";
						}
						
						COIL_OUT_MON_WGT_SUM += parseFloat(COIL_OUT_MON_WGT_SUM_1);
					}
					
					//这里把获取的值在表格的最后增加一行来显示
					if(datagrid1.rows > 0){
						//这里加入小计的标志
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/EXTSHAPE_DEC_GRD");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/EXTSHAPE_DEC_GRD","小计");
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_IN_DAY_NUM");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_IN_DAY_NUM",COIL_IN_DAY_NUM_CNT);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_IN_DAY_WGT");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_IN_DAY_WGT",COIL_IN_DAY_WGT_SUM);
						
//						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_IN_MON_NUM");
//						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_IN_MON_NUM",COIL_IN_MON_NUM_CNT);
//						
//						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_IN_MON_WGT");
//						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_IN_MON_WGT",COIL_IN_MON_WGT_SUM);
						
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_T_DAY_NUM");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_T_DAY_NUM",COIL_OUT_T_DAY_NUM_CNT);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_T_DAY_WGT");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_T_DAY_WGT",COIL_OUT_T_DAY_WGT_SUM);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_T_MON_NUM");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_T_MON_NUM",COIL_OUT_T_MON_NUM_CNT);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_T_MON_WGT");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_T_MON_WGT",COIL_OUT_T_MON_WGT_SUM);
						
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_C_DAY_NUM");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_C_DAY_NUM",COIL_OUT_C_DAY_NUM_CNT);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_C_DAY_WGT");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_C_DAY_WGT",COIL_OUT_C_DAY_WGT_SUM);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_C_MON_NUM");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_C_MON_NUM",COIL_OUT_C_MON_NUM_CNT);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_C_MON_WGT");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_C_MON_WGT",COIL_OUT_C_MON_WGT_SUM);
						
						//屏蔽库存区域
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_YARD_DAY_NUM");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_YARD_DAY_NUM",COIL_YARD_DAY_NUM_CNT);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_YARD_DAY_WGT");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_YARD_DAY_WGT",COIL_YARD_DAY_WGT_SUM);
//						
//						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_YARD_MON_NUM");
//						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_YARD_MON_NUM",COIL_YARD_MON_NUM_CNT);
//						
//						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_YARD_MON_WGT");
//						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_YARD_MON_WGT",COIL_YARD_MON_WGT_SUM);
						
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_DAY_NUM");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_DAY_NUM",COIL_OUT_DAY_NUM_CNT);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_DAY_WGT");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_DAY_WGT",COIL_OUT_DAY_WGT_SUM);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_MON_NUM");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_MON_NUM",COIL_OUT_MON_NUM_CNT);
						
						model.makeNode(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_MON_WGT");
						model.setValue(nodeSet1+"["+(datagrid1.rows+1)+"]/COIL_OUT_MON_WGT",COIL_OUT_MON_WGT_SUM);
					}
					
					model.refresh();
					
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body>
		<caption id="caption13" class="cell" style="left:0px; top:0px; width:60px; height:20px; font-weight:bold; border-color:#000000; ">时间</caption>
		<datagrid id="datagrid1" nodeset="/root/datagrid1/COIL_RESULT_VO/COIL_RESULT_Row" caption="外观等级^牌号^规格^轧制量^轧制量^轧制量^轧制量^日出库^日出库^日出库^日出库^日出库^日出库^累计出库^累计出库^累计出库^累计出库^累计出库^累计出库^库存^库存^库存^库存|外观等级^牌号^规格^轧制(块)^累计(块)^轧制(吨)^累计(吨)^汽车(块)^火车(块)^小计(块)^汽车(吨)^火车(吨)^小计(吨)^汽车(块)^火车(块)^小计(块)^汽车(吨)^火车(吨)^小计(吨)^总(块)^累计(块)^总(吨)^累计(吨)" colsep="^" colwidth="70, 70, 90, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70, 70" defaultrows="30" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:30px; width:980px; height:590px; ">
			<col ref="EXTSHAPE_DEC_GRD"/>
			<col ref="SPEC_STL_GRD" visibility="hidden"/>
			<col ref="T_W" visibility="hidden"/>
			<col ref="COIL_IN_DAY_NUM"/>
			<col ref="COIL_IN_MON_NUM" visibility="hidden"/>
			<col ref="COIL_IN_DAY_WGT"/>
			<col ref="COIL_IN_MON_WGT" visibility="hidden"/>
			<col ref="COIL_OUT_C_DAY_NUM"/>
			<col ref="COIL_OUT_T_DAY_NUM"/>
			<col ref="COIL_OUT_DAY_NUM"/>
			<col ref="COIL_OUT_C_DAY_WGT"/>
			<col ref="COIL_OUT_T_DAY_WGT"/>
			<col ref="COIL_OUT_DAY_WGT"/>
			<col ref="COIL_OUT_C_MON_NUM"/>
			<col ref="COIL_OUT_T_MON_NUM"/>
			<col ref="COIL_OUT_MON_NUM"/>
			<col ref="COIL_OUT_C_MON_WGT"/>
			<col ref="COIL_OUT_T_MON_WGT"/>
			<col ref="COIL_OUT_MON_WGT"/>
			<col ref="COIL_YARD_DAY_NUM"/>
			<col ref="COIL_YARD_MON_NUM" visibility="hidden"/>
			<col ref="COIL_YARD_DAY_WGT"/>
			<col ref="COIL_YARD_MON_WGT" visibility="hidden"/>
		</datagrid>
		<select id="checkbox1" ref="/root/GG" visibility="hidden" overflow="visible" appearance="full" style="left:895px; top:0px; width:50px; height:20px; border-style:none; ">
			<choices>
				<item>
					<label>规格</label>
					<value>1</value>
				</item>
			</choices>
		</select>
		<line id="line1" style="x1:220px; y1:10px; x2:235px; y2:10px; "/>
		<input id="input1" ref="/root/searchDate/FROM_DATE" inputtype="date" format="yyyy-mm-dd" style="left:60px; top:0px; width:90px; height:20px; background-color:#ffff99; "/>
		<input id="input2" ref="/root/searchDate/TO_DATE" inputtype="date" format="yyyy-mm-dd" style="left:235px; top:0px; width:90px; height:20px; background-color:#ffff99; "/>
		<input id="input3" ref="/root/searchDate/TO_DTIME" format="hh:nn:ss" style="left:325px; top:0px; width:70px; height:20px; background-color:#ffff99; "/>
		<input id="input4" ref="/root/searchDate/FROM_DTIME" format="hh:nn:ss" style="left:150px; top:0px; width:70px; height:20px; background-color:#ffff99; "/>
	</xhtml:body>
</xhtml:html>