<%@page import = "java.util.*"%>
<%@page import ="ibase.webitm.utility.*"%>
<%@page import = "ibase.webitm.ejb.dis.*"%>
<%@page import = "java.sql.*"%>
<%@page import = "java.text.DecimalFormat"%>
<%@page import = "ibase.webitm.utility.GenericUtility"%>
<%@page import = "ibase.webitm.ejb.dis.StockHelpBean"%>

<jsp:useBean id="stkHlpBn" scope="session" class="ibase.webitm.ejb.dis.StockHelpBean"/>

<HTML>
<HEAD>
<% 

String lotno = request.getParameter("lotno");
String sitecode = request.getParameter("sitecode");
String itemcode = request.getParameter("itemcode");

stkHlpBn.setLotNo(lotno.toUpperCase());
stkHlpBn.setSiteCode( sitecode.toUpperCase() );
stkHlpBn.setItemCode( itemcode.toUpperCase() );




%>

<%
		ArrayList stockHelpList = stkHlpBn.loaddata();
StockHelpBean stkHlpBean = null;

if( stockHelpList.size() > 0 )
{
		
%>
	
		<br/>
			<DIV ID="TableBorder" class="tableborderDiv">
			<TABLE name="main" border = "1" id="main" CLASS="sort-table" STYLE="class:header_css;POSITION:relative;TOP:20;left:10;width:790" >
			<thead>	
				
				<th  class="thClass" nowrap>Tran id</th>
				<th  class="thClass" nowrap>Tran Date</th>
				<th  class="thClass" nowrap>Ref Ser</th>
				<th  class="thClass" nowrap>Ref Id</th>
				<th  class="thClass" nowrap>Ref Line</th>
				<th  class="thClass" nowrap>Order Id</th>
				<th  class="thClass" nowrap>Item Code</th>
				<th  class="thClass" nowrap>Site Code</th>
				<th  class="thClass" nowrap>Loc Code</th>
				<th  class="thClass" nowrap>Unit</th>
				<th  class="thClass" nowrap>Lot No</th>
				<th  class="thClass" nowrap>Lot Sl</th>
				<th  class="thClass" nowrap>Quantity</th>
				<th  class="thClass" nowrap>Eff Qty</th>
				<th  class="thClass" nowrap>Eff Date</th>
				<th  class="thClass" nowrap>Chg Win</th>
				<th  class="thClass" nowrap>Qty Before</th>
				<th  class="thClass" nowrap>Qty After</th>
				<th  class="thClass" nowrap>Reas Code</th>
				<th  class="thClass" nowrap>Sundry Type</th>
				<th  class="thClass" nowrap>Sundry Code</th>
				<th  class="thClass" nowrap>Ref Date</th>
				<th  class="thClass" nowrap>Ref Ser For</th>
				<th  class="thClass" nowrap>Ref Id For</th>
				<th  class="thClass" nowrap>Acct code dr</th>
				<th  class="thClass" nowrap>Cctr code dr</th>
				<th  class="thClass" nowrap>Acct code cr</th>
				<th  class="thClass" nowrap>Cctr code cr</th>
				<th  class="thClass" nowrap>Grade</th>
				<th  class="thClass" nowrap>Rate</th>
				<th  class="thClass" nowrap>Gross Rate</th>
				<th  class="thClass" nowrap>No Art</th>
				<th  class="thClass" nowrap>Dimention</th>
				<th  class="thClass" nowrap>Actual Qty</th>
				<th  class="thClass" nowrap>Conv Qty</th>
				<th  class="thClass" nowrap>Amount</th>
				<th  class="thClass" nowrap>Inv Stat</th>
				<th  class="thClass" nowrap>Rate Insu</th>
				
			</thead>
			
			<%
			for(int i=0;i<stockHelpList.size();i++)
			{
				stkHlpBean = (StockHelpBean)stockHelpList.get(i);
			
			
			%>
			
			<tr BGCOLOR="#FFFFFF">	
			<td align = "center"><font size="-1"><%= (stkHlpBean.tranidhere != null && stkHlpBean.tranidhere.equals("")) ? "-" : stkHlpBean.tranidhere %></font></td>
			
			<td align = "center"><font size="-1"><%= (stkHlpBean.trandate != null && stkHlpBean.trandate.equals("")) ? "-" : stkHlpBean.trandate %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.refser != null && stkHlpBean.refser.equals("")) ? "-" : stkHlpBean.refser %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.refid != null && stkHlpBean.refid.equals("")) ? "-" : stkHlpBean.refid %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.refline != null && stkHlpBean.refline.equals("")) ? "-" : stkHlpBean.refline %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.orderid == null || stkHlpBean.orderid.equals("")) ? "-" : stkHlpBean.orderid %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.itemCodeStk != null && stkHlpBean.itemCodeStk.equals("")) ? "-" : stkHlpBean.itemCodeStk %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.siteCodeStk != null && stkHlpBean.siteCodeStk.equals("")) ? "-" : stkHlpBean.siteCodeStk %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.currLocCode1 != null && stkHlpBean.currLocCode1.equals("")) ? "-" : stkHlpBean.currLocCode1 %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.unit != null && stkHlpBean.unit.equals("")) ? "-" : stkHlpBean.unit %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.currLotNo1 != null && stkHlpBean.currLotNo1.equals("")) ? "-" : stkHlpBean.currLotNo1 %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.currLotSl1 != null && stkHlpBean.currLotSl1.equals("")) ? "-" : stkHlpBean.currLotSl1 %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.quantity != null && stkHlpBean.quantity.equals("")) ? "-" : stkHlpBean.quantity %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.effqty != null && stkHlpBean.effqty.equals("")) ? "-" : stkHlpBean.effqty %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.efedate != null && stkHlpBean.efedate.equals("")) ? "-" : stkHlpBean.efedate %></font></td>
			
			
			<td align = "center"><font size="-1"><%= (stkHlpBean.chgwin != null && stkHlpBean.chgwin.equals("")) ? "-" : stkHlpBean.chgwin %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.qtybefore != null && stkHlpBean.qtybefore.equals("")) ? "-" : stkHlpBean.qtybefore %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.qtyaft != null && stkHlpBean.qtyaft.equals("")) ? "-" : stkHlpBean.qtyaft %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.reascode == null || stkHlpBean.reascode.equals("")) ? "-" : stkHlpBean.reascode %></font></td>
			
			<td align = "center"><font size="-1"><%= (stkHlpBean.sundrytype == null || stkHlpBean.sundrytype.equals("")) ? "-" : stkHlpBean.sundrytype %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.sundrycode == null || stkHlpBean.sundrycode.equals("")) ? "-" : stkHlpBean.sundrycode %></font></td>
			
			
			<td align = "center"><font size="-1"><%= (stkHlpBean.refdate != null && stkHlpBean.refdate.equals("")) ? "-" : stkHlpBean.refdate %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.refserfor == null || stkHlpBean.refserfor.equals("")) ? "-" : stkHlpBean.refserfor %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.refidfor == null || stkHlpBean.refidfor.equals("")) ? "-" : stkHlpBean.refidfor %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.acctcddr != null && stkHlpBean.acctcddr.equals("")) ? "-" : stkHlpBean.acctcddr %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.cctrcddr != null && stkHlpBean.cctrcddr.equals("")) ? "-" : stkHlpBean.cctrcddr %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.acctcdcr != null && stkHlpBean.acctcdcr.equals("")) ? "-" : stkHlpBean.acctcdcr %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.cctrcdcr == null || stkHlpBean.cctrcdcr.equals("")) ? "-" : stkHlpBean.cctrcdcr %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.grade != null && stkHlpBean.grade.equals("")) ? "-" : stkHlpBean.grade %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.rateinv != null && stkHlpBean.rateinv.equals("")) ? "-" : stkHlpBean.rateinv %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.grossrate != null && stkHlpBean.grossrate.equals("")) ? "-" : stkHlpBean.grossrate %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.noartinv != null && stkHlpBean.noartinv.equals("")) ? "-" : stkHlpBean.noartinv %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.dimention == null || stkHlpBean.dimention.equals("")) ? "-" : stkHlpBean.dimention %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.actqty != null && stkHlpBean.actqty.equals("")) ? "-" : stkHlpBean.actqty %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.convqty != null && stkHlpBean.convqty.equals("")) ? "-" : stkHlpBean.convqty %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.amount != null && stkHlpBean.amount.equals("")) ? "-" : stkHlpBean.amount %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.invStat1 != null && stkHlpBean.invStat1.equals("")) ? "-" : stkHlpBean.invStat1 %></font></td>
			<td align = "center"><font size="-1"><%= (stkHlpBean.rateinsu != null && stkHlpBean.rateinsu.equals("")) ? "-" : stkHlpBean.rateinsu %></font></td>
			
			
			
			
					</tr>
					
					<% }
			
					}
					%>
			
