📄 print.jsp
字号:
from_whouse=false;
} else
{
to_whouse=false;
from_whouse=true;
ttblno=wblno ;
}
prevcustpo = rsIs.getString("custpo");
prevnet = rsIs.getDouble("net") ;
coils = rsIs.getString("coils");
invunit = rsIs.getString("invunit");
canlbspr = rsIs.getString("canlbspr");
invextend= rsIs.getDouble("invextend");
DESC = rsIs.getString("DESC");
custprod = rsIs.getString("custprod");
hscode= rsIs.getString("hscode");
}
ASResultSet rs=Sqlca.getASResultSet("select * from invoice where blno='" + BLNO + "'");
if(rs.next() )
{
invgst=rs.getString("invgst");
prepaid =rs.getString("prepaid");
collect =rs.getString("collect");
otherfees=rs.getString("otherfees");
reason1=rs.getString("reason1");
reason2=rs.getString("reason2");
sundry=rs.getString("sundry");
freight=rs.getString("freight");
subtot =rs.getString("subtot");
invamt =rs.getString("invamt");
if(invamt.equals("")){invamt="0";}
fsurcharge =rs.getString("fsurcharge");
gross =rs.getString("gross");
fsurrate =rs.getString("fsurrate");
shadd1= rs.getString("shadd1");
shadd2= rs.getString("shadd2");
shadd3= rs.getString("shadd3");
shadd4= rs.getString("shadd4");
plant= rs.getString("plant");
duty= rs.getDouble("duty");
frins= rs.getDouble("frins") ;
insurance= rs.getDouble("insurance");
verifyby= rs.getString("verifyby");
}
ASResultSet rsc=Sqlca.getASResultSet("select * from customer where account='" + rsIs.getString("account") + "' and subacct='" +rsIs.getString("subacct") + "'");
if(rsc.next() )
{ out.print("&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&");
posort=rsc.getString("posort");
custpo =rsIs.getString("custpo");
isimperial =rsc.getString("isimperial");
country =rsc.getString("country");
shname=rsc.getString("shname");
}
ASResultSet rso=Sqlca.getASResultSet("select * from ord_item where worksno =" +rsIs.getString("worksno") ) ;
if(rso.next() )
{ out.print("&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&");
contract=StringUtils.nullToEmpty(rso.getString("contract"));
mt_width=rso.getString("mt_width");
mt_gauge=rso.getString("mt_gauge");
alloy=rso.getString("alloy");
account=rso.getString("account");
STATUS= rso.getString("STATUS");
}
for(int i=0;i< Integer.parseInt((Invoice=="")?"0":Invoice);i++)
{
out.print(" <table bgcolor='#DCDCDC'>");
if(posort.equals( "0"))
{
if(prevcustpo.equals( custpo))
{
if( custpo.length() <=16)
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}else
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}
}else
{
if(nPOnet!= prevnet)
{
out.print("<tr><td> CUSTOMER ORDER TOTAL </td><td>" + nPOnet +"</td><td>" + nPOinv +"</td></tr>");
if(invgst!=null)
{
out.print("<tr><td> GST/HST </td></tr>");
nGST=nPOinv *gstrate /100;
out.print("<tr><td>" + nGST +"</td></tr>");
out.print("<tr><td>" + nGST+nPOinv +"</td></tr>");
}
if( custpo.length() <=16)
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}else
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}
}
}
}else
{
if( custpo.length() <=16)
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}else
{
out.print("<tr><td>" + custpo +"</td></tr>");
}
}
if(StringUtils.copper(alloy))
{
out.print("<tr><td> COPPER </td></tr>");
}
if(StringUtils.nickel(alloy))
{
out.print("<tr><td> NICKEL SILVER </td></tr>");
}
if(StringUtils.brass(alloy))
{
out.print("<tr><td> BRASS </td></tr>");
}
if(StringUtils.phos(alloy))
{
out.print("<tr><td> PHOS BRONZE </td></tr>");
}
if(contract=="FERGUS-T")
{
out.print("<tr><td> TOLL </td></tr>");
}
out.print("<tr><td>" + prevnet +"</td></tr>"); //net
if(islbs=="0")
{
out.print("<tr><td>" + invunit +"</td><td> " + invextend + "</td></tr>");
}else
{
out.print("<tr><td>" + canlbspr +"</td><td> " + invextend + "</td></tr>");
}
nPOinv =nPOinv + invextend;
if(isimperial=="0")
{
out.print("<tr><td>" + DESC +"</td></tr>");
}
else
{
out.print("<tr><td>" + DESC + " " + mt_width + "mm " + mt_gauge+"mm "+"</td></tr>");
}
if(custprod!="0")
{
out.print("<tr><td>Part No: " + custprod +"</td></tr>");
}
if("UO".indexOf(country )> 0 )
{
if( !from_whouse)
{
if(StringUtils.copper(oalloy))
{
if(hscode=="7410.11.0000")
cfoil="COPPER FOIL";
if(hscode=="7409.11.5010")
cfoil="COPPER STRIP";
if(hscode=="7409.11.5050")
cfoil="COPPER STRIP";
if(hscode=="7409.11.1000")
cfoil="COPPER STRIP";
else
cfoil="COPPER STRIP";
}
if(StringUtils.brass(oalloy))
{
if(hscode=="7410.12.0030")
cfoil="BRASS FOIL";
if(hscode=="7409.21.0050")
cfoil="BRASS STRIP";
if(hscode=="7409.21.0075")
cfoil="BRASS STRIP";
if(hscode=="7409.21.0010")
cfoil="BRASS STRIP";
else
cfoil="BRASS STRIP";
}
else
{
cfoil="STRIP";
}
out.print("<tr><td>H.S. CODE:" + hscode + " (" + cfoil +")</td></tr>");
}
}
if(account=="VALCAN")
{
if(STATUS =="CM")
{
out.print("<tr><td>COMPLETE </td></tr>");
}
else
{
out.print("<tr><td>PARTIAL </td></tr>");
}
}
if(posort=="0")
{
if(prevcustpo == custpo)
{
if( custpo.length() <=16)
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}else
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}
}else
{
if(nPOnet!= prevnet)
{
out.print("<tr><td> CUSTOMER ORDER TOTAL </td><td>" + nPOnet +"</td><td>" + nPOinv +"</td></tr>");
if(invgst!=null)
{
out.print("<tr><td> GST/HST </td></tr>");
nGST=nPOinv *gstrate /100;
out.print("<tr><td>" + nGST +"</td></tr>");
out.print("<tr><td>" + nGST+nPOinv +"</td></tr>");
}
if( custpo.length() <=16)
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}else
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}
}
}
}else
{
if( custpo.length() <=16)
{
out.print("<tr><td>" + custpo +"</td></tr>");
out.print("<tr><td>" + coils +"</td></tr>");
}else
{
out.print("<tr><td>" + custpo +"</td></tr>");
}
}
if(prepaid!=null)
{
out.print("<tr><td> PREPAID </td></tr>");
out.print("<tr><td>" + prepaid +"</td></tr>");
out.print("<tr><td> CR </td></tr>");
out.print("<tr><td>" + collect +"</td></tr>");
}
if(otherfees!=null || !otherfees.equals("") )
{
String CR="";
totherfees=Double.valueOf(otherfees).doubleValue() ;
if(totherfees<0)
totherfees=totherfees*(-1);
if(totherfees > 0) CR="";else CR="CR";
out.print("<tr><td>" + reason1 +" "+ reason2 +"</td></tr>");
out.print("<tr><td>" + totherfees +"</td></tr>");
out.print("<tr><td>" + CR +"</td></tr>");
}
if(sundry!=null || !sundry.equals("") )
{
String CR="";
tsundry=Double.valueOf(sundry).doubleValue() ;
if(tsundry<0)
tsundry=tsundry*(-1);
if(totherfees > 0) CR="";else CR="CR";
out.print("<tr><td>" + reason1 +" "+ reason2 +"</td></tr>");
out.print("<tr><td>" + tsundry +"</td></tr>");
out.print("<tr><td>" + CR +"</td></tr>");
} if(freight!=null || !freight.equals("") )
{
out.print("<tr><td> FREIGHT ALLOWANCE </td></tr>");
out.print("<tr><td>" + freight +"</td></tr>");
out.print("<tr><td> CR </td></tr>");
}
if(!(otherfees==null && sundry==null && freight==null))
{
out.print("<tr><td>" + subtot +"</td></tr>");
print_invamt=false;
}
else
{
print_invamt=false;
}
if(country =="O")
{
if(print_invamt)
{
out.print("<tr><td>" + invamt +"</td></tr>");
}
}else
{
if(invgst==null)
{
if(fsurcharge!=null)
{
out.print("<tr><td> FUEL SURCHARGE </td></tr>");
out.print("<tr><td>" + gross +"</td></tr>");
out.print("<tr><td>" + fsurrate +"</td></tr>");
out.print("<tr><td>" + fsurcharge +"</td></tr>");
out.print("<tr><td>" + invamt +"</td></tr>");
}
}else
{
out.print("<tr><td> GST/HST </td></tr>");
out.print("<tr><td>" + invgst +"</td></tr>");
if(fsurcharge!=null)
{
out.print("<tr><td> FUEL SURCHARGE </td></tr>");
out.print("<tr><td>" + gross +"</td></tr>");
out.print("<tr><td>" + fsurrate +"</td></tr>");
out.print("<tr><td>" + fsurcharge +"</td></tr>");
out.print("<tr><td>" + invamt +"</td></tr>");
}
}
}
if("UO".indexOf(country ) > 0 && !country.equals("") )
{
if(!from_whouse)
{
if(Integer.parseInt( invamt ) >= 0 )
{
out.print("<tr><td> NON RELATED TRANSACTION " + country=="O"?"MADE IN CANADA":"MADE IN ONTARIO, CANADA" + " </td></tr>");
}
}
if(Integer.parseInt( invamt ) >= 0 )
{
out.print("<tr><td> GROSS WEIGHT: </td><td> " + gross + wght + "</td></tr>");
out.print("<tr><td> SHIP TO: </td><td> " + shname + "</td></tr>");
}
if(Integer.parseInt( invamt ) >= 0 )
{
if(to_whouse || from_whouse)
{
cwh=ordertype;
out.print("<tr><td>VIA: </td><td> " + ttblno==null?"":" B/L:"+ ttblno + "</td></tr>");
}
out.print("<tr> <td> " + shadd1 + "</td></tr>");
if(shadd2!="")
out.print("<tr> <td> " + shadd2 + "</td></tr>");
if(shadd3!="")
out.print("<tr> <td> " + shadd3 + "</td></tr>");
if(shadd4!="")
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -