📄 print.jsp
字号:
out.print("<tr> <td> " + shadd4 + "</td></tr>");
}
if(!from_whouse)
{
if(Integer.parseInt( invamt ) >= 0 )
{
out.print("<tr> <td>THE FOLLOWING IS INCLUDED IN ABOVE C.I.F. SELLING PRICE</td></tr>");
out.print("<tr> <td>PACKING INCLUDED IN ABOVE SELLING PRICE:</td></tr>");
out.print("<tr> <td>FREIGHT & INSURANCE FROM:"+ plant=="FERG"?"FERGUS, ONTARIO, CANADA":"RICHMOND HILL, ONTARIO, CANADA" +" </td></tr>");
amount=frins+insurance;
out.print("<tr> <td> " + amount + "</td></tr>");
if(duty > 0 )
{
out.print("<tr> <td>U.S. DUTY:</td><td> " + duty + "</td></tr>");
frsubtot= frins+insurance+duty ;
out.print("<tr> <td> " + frsubtot + "</td></tr>");
}
}
if(Integer.parseInt( invamt ) >= 0 )
{
if(verifyby !="PROFORMA")
{
out.print("<tr> <td>WE CERTIFY THIS TO BE A TRUE AND CORRECT COPY OF THE ORIGINAL INVOIC</td></tr>");
}
if(country=="U")
{
out.print("<tr> <td>NOTIFY: PBB GROUP FOR CUSTOMS CLEARANCE</td></tr>");
out.print("<tr> <td>U.S. CUSTOMS CLEARANCE CHARGES FOR A/C OF: WOLVERINE RATCLIFFS INC.</td></tr>");
}
if(verifyby !="PROFORMA")
{
out.print("<tr> <td> " + cName + "</td></tr>");
out.print("<tr> <td> " + cTraffic + "</td></tr>");
out.print("<tr> <td>TRAFFIC & EXPORT DEPT.</td></tr>");
}
}
}
}
out.print("<tr> <td></td></tr>");
out.print("<tr> <td></td></tr>");
out.print(" </table>");
}
}
%>
<%
if(!PackList.equals("") ||PackList!="")
{
String shipname ="";
String blno ="";
String add1 ="";
String add2 ="";
String weight ="";
String uaccess ="";
String d_shipdt ="";
String hline1a ="";
String hline1 ="";
String cname ="";
String cISO="QAF-068 Rev:1.0 Rev Date:97/Aug/7";
String geocode ="";
String hline3 ="";
String hline2 ="";
String plant ="";
String c_wname ="";
String hline4 ="";
String hline5 ="";
String hline31 ="";
int numpacks=Integer.parseInt( PackList==""?"0":PackList);
ASResultSet rsg=Sqlca.getASResultSet("select * from global");
if(rsg.next() ){
cname=rsg.getString("cnconame");
}
ASResultSet rsP=Sqlca.getASResultSet("select * from packnote where blno =" +BLNO + " order by custpo, worksno");
if(rsP.next() )
{
plant=rsP.getString("plant");
}
for ( int i=0;i< numpacks;i++)
{
ASResultSet rsc= Sqlca.getASResultSet("select * from customer where account='"+rsP.getString("account") + "' and subacct='"+rsP.getString("subacct")+"'");
if(rsc.next() )
{
geocode=rsc.getString("geocode") ;
}
ASResultSet rss=Sqlca.getASResultSet("select * from shipment where blno =" +BLNO );
if(rss.next() )
{
d_shipdt=rss.getString("shipdt");
}
if(rsc.getString("ordertype") =="REG")
{
} else
{
shipname =rsc.getString("shname");
}
blno =rsP.getString("blno");
add1 =rsP.getString("add1");
add2 =rsP.getString("add2");
weight =rss.getString("islbs")=="0"?"LBS":"KGS";
if(uaccess=="1")
{
hline1a="";
hline1 = cname +" P I C K I N G L I S T" + " DATE: " + d_shipdt;
hline3 = "TO: " + shipname +"Route:"+ geocode +"PICK LIST: "+ blno;
}else
{
hline1a=cISO;
hline1 = cname +" P I C K I N G L I S T" + " DATE: " + d_shipdt;
hline3 = "TO: " + shipname +"BOL: "+ blno;
}
if(plant=="FERG")
{
hline2 = "FERGUS, ONTARIO";
}else
{
hline2 = "RICHMOND HILL, ONTARIO";
}
hline31=c_wname;
hline4 =add1;
hline5 =add2 +"** Weight in " +weight + " **";
out.print(" <table bgcolor='#DCDCDC'>");
out.print("<tr><td>"+hline1a +"</td></tr>");
out.print("<tr><td>"+hline1 +"</td></tr>");
out.print("<tr><td>"+hline2 +"</td></tr>");
out.print("<tr><td>"+hline3 +"</td></tr>");
out.print("<tr><td>"+hline4 +"</td></tr>");
out.print("<tr><td>"+hline5 +"</td></tr>");
out.print("</table> ");
}
}
%>
<%
if(!Certificate.equals("") || Certificate!="" )
{
String cname="";
String cncity="";
String cnprovst="";
String alloy="";
String cnadd1="";
String country="";
String name="";
String custpo="";
String bladd1="";
String millspec="";
String bladd2="";
String blcity="";
String blprovst="";
String worksno="";
String blcountry="";
String blpcode="";
String shipdt="";
String net="";
String islbs="";
String isimperial="";
String width="";
String gauge="";
String mt_width="";
String mt_gauge="";
String temper="";
String custprod="";
String custspec="";
String plant="";
ASResultSet rsg=Sqlca.getASResultSet("select * from global");
if(rsg.next() )
{
cname=rsg.getString("cnconame");
cncity=rsg.getString("cncity");
cnprovst=rsg.getString("cnprovst");
cnadd1=rsg.getString("cnadd1");
plant=rsg.getString("plant");
}
ASResultSet rss=Sqlca.getASResultSet("select * from shipment where blno =" +BLNO );
if(rss.next() )
{
alloy=rss.getString("alloy");
custpo=rss.getString("custpo");
worksno=rss.getString("worksno");
shipdt=rss.getString("shipdt");
net=rss.getString("net");
islbs =rss.getString("islbs");
}
ASResultSet rsc= Sqlca.getASResultSet("select * from customer where account='"+rss.getString("account") + "' and subacct='"+rss.getString("subacct")+"'");
if(rsc.next() )
{
country =rsc.getString("country");
name =rsc.getString("name");
blcity=rsc.getString("blcity");
blprovst=rsc.getString("blprovst");
blcountry=rsc.getString("blcountry");
blpcode=rsc.getString("blpcode");
isimperial=rsc.getString("isimperial");
}
ASResultSet rsi=Sqlca.getASResultSet("select * from invoice where blno="+BLNO );
if(rsi.next() )
{
bladd1 =rsi.getString("bladd1");
bladd2 =rsi.getString("bladd2");
}
ASResultSet rso=Sqlca.getASResultSet("select * from ord_item where worksno="+rss.getString("worksno") );
if(rso.next() )
{
millspec =rso.getString("millspec");
gauge =rso.getString("gauge");
width =rso.getString("width");
mt_gauge=rso.getString("mt_gauge");
mt_width=rso.getString("mt_width");
temper=rso.getString("temper");
alloy=rso.getString("alloy");
custprod=rso.getString("custprod");
custspec=rso.getString("custspec");
}
if(!(StringUtils.copper(alloy) || StringUtils.brass(alloy)))
{
out.print("<script>alert(''Alloy is neither brass or copper, unable to produce certificate.'');</script>");
return;
}
for (int i=0;i<Integer.parseInt(Certificate);i++ )
{
out.print(" <table bgcolor='#DCDCDC'>");
out.print("<tr><td> WOLVERINE RATCLIFFS </td><td> "+cname + "</td></tr>");
out.print("<tr><td>"+cnadd1 +"</td></tr>");
out.print("<tr><td>"+cncity + cnprovst +"</td></tr>");
out.print("<tr><td> CANADA </td></tr>");
if(country=="O")
out.print("<tr><td> ANALYSIS CERTIFICATE </td></tr>");
else
out.print("<tr><td> CERTIFICATE OF COMPLIANCE </td></tr>");
out.print("<tr><td> Customer: </td></tr>");
out.print("<tr><td>"+name + "Customer PO: "+ custpo +"</td></tr>");
out.print("<tr><td>"+bladd1 +"Mill Spec: "+ millspec+"</td></tr>");
if(bladd2!=null)
{
out.print("<tr><td>"+bladd2 +"</td></tr>");
}
out.print("<tr><td>"+blcity +","+blprovst +"</td><td> Works Order: "+worksno + "</td></tr>");
out.print("<tr><td>"+blcountry +" "+ blpcode +"</td></tr>");
out.print("<tr><td> Ship Date: "+shipdt.substring(0,10) +"</td></tr>");
out.print("<tr><td> Quantity Width Gauge Temper Alloy Part # and Spec. #</td></tr>");
out.print("<tr><td>"+net+ islbs=="0"?"LBS":"Kg." +"</td></tr>");
if(isimperial=="0")
{
out.print("<tr><td>"+width +" "+ gauge +"</td></tr>");
} else
{
out.print("<tr><td>"+mt_width +"mm "+ mt_gauge +"mm</td></tr>");
}
out.print("<tr><td>"+temper +" "+alloy + " "+custprod +" "+custspec +"</td></tr>");
if(islbs=="0")
{
out.print("<tr><td>"+Double.valueOf(net).doubleValue() /2.2046 +"Kg.</td></tr>");
}else
{
out.print("<tr><td>"+Double.valueOf(net).doubleValue() /2.2046 +"LBS.</td></tr>");
}
if(isimperial=="0")
{
out.print("<tr><td>"+mt_width +"mm "+ mt_gauge +"mm</td></tr>");
} else
{
out.print("<tr><td>"+width +" "+ gauge +"</td></tr>");
}
out.print("<tr><td> </td></tr>");
out.print("<tr><td>Nominal composition %: </td></tr>");
if(alloy=="14415")
{
out.print("<tr><td> Cu 99.9 Sn .10</td></tr>");
} else
if(alloy=="14420")
{
out.print("<tr><td> Cu RMD Te .010 Sn .060</td></tr>");
} else
if(alloy=="14300")
{
out.print("<tr><td> Cu 99.90 RMD P .006 Cd .080</td></tr>");
} else
if(alloy.indexOf("11000 C1100")>0)
{
out.print("<tr><td> Cu 100</td></tr>");
}else
if(alloy.indexOf("26000 27000")>0)
{
out.print("<tr><td> Cu 70 Zn 30</td></tr>");
} else
if(alloy.indexOf("26120")>0)
{
out.print("<tr><td> Cu 69.9 Zn 30 P .030</td></tr>");
}else
if(alloy.indexOf("26130")>0)
{
out.print("<tr><td> Cu 69.9 Zn 30 P .030</td></tr>");
}else
if(alloy.indexOf("27130")>0)
{
out.print("<tr><td>Cu 64.9 Zn 30 As .030</td></tr>");
} else
if(alloy.indexOf("23000")>0)
{
out.print("<tr><td>Cu 85 Zn 15</td></tr>");
} else
if(alloy.indexOf("24000")>0)
{
out.print("<tr><td>Cu 80 Zn 20</td></tr>");
} else
if(alloy.indexOf("22000")>0)
{
out.print("<tr><td>Cu 90 Zn 10</td></tr>");
} else
if(alloy.indexOf("12200")>0)
{
out.print("<tr><td>Cu 99.90 RMD P .025</td></tr>");
}else
if(alloy.indexOf("C1400")>0)
{
out.print("<tr><td>Cu RMD Pb Max .020 Fe .02 Sn 1.2-2.0 Zn 2.0-4.0 P .001-.02</td></tr>");
}
else
{
out.print("<tr><td>*UNKNOWN*</td></tr>");
}
out.print("<tr><td>We certify that the material identified above has been tested and found</td></tr>");
out.print("<tr><td>to be in compliance with your specification.</td></tr>");
out.print("<tr><td>Thank you for your order.</td></tr>");
if(plant=="HILL")
{
out.print("<tr><td>Al Lewis</td></tr>");
out.print("<tr><td>Quality Assurance Coordinator</td></tr>");
} else
{
out.print("<tr><td> WOLVERINE RATCLIFFS INC.</td></tr>");
}
out.print("<tr><td> </td></tr>");
out.print("<tr><td> </td></tr>");
out.print("</table> ");
}
}
%>
<input type="button" name="next"
value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("EXPORTEXCEL")%>"
onClick=" OpenComp('Billing', '/Billing/printBOL/Excel.jsp', 'wantworks=<%=wantworks%>&Certificate=<%=Certificate%>&PackList=<%=PackList%>&Invoice=<%=Invoice%>&BOL=<%=BOL%>&BLNO=<%=BLNO%>&rand=' + randomNumber(), 'right', ''); self.returnValue = 'OK'; self.close();"
style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC; border-style: outset; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px"
border="1">
</body>
</html>
<%@ include file="/IncludeEnd.jsp" %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -