📄 excel.jsp
字号:
}else
{
if(nPOnet!= prevnet)
{HSSFRow r34=sheet.createRow(i +33);
HSSFCell r1c34=r34.createCell((short)0);
r1c34.setCellValue(" CUSTOMER ORDER TOTAL"+nPOnet +" " + nPOinv );
if(invgst!=null)
{
HSSFRow r35=sheet.createRow(i +34);
HSSFCell r1c35=r35.createCell((short)0);
r1c35.setCellValue( "GST/HST" );
nGST=nPOinv *gstrate /100;
HSSFRow r36=sheet.createRow(i +35);
HSSFCell r1c36=r36.createCell((short)0);
r1c36.setCellValue( nGST );
HSSFRow r37=sheet.createRow(i +36);
HSSFCell r1c37=r37.createCell((short)0);
r1c37.setCellValue( nGST +" "+nPOinv);
}
if( custpo.trim().length() <=16)
{ HSSFRow r38=sheet.createRow(i +37);
HSSFCell r1c38=r38.createCell((short)0);
r1c38.setCellValue( custpo.trim() );
HSSFRow r39=sheet.createRow(i +38);
HSSFCell r1c39=r39.createCell((short)0);
r1c39.setCellValue(coils );
}else
{
HSSFRow r40=sheet.createRow(i +39);
HSSFCell r1c40=r40.createCell((short)0);
r1c40.setCellValue(custpo );
HSSFRow r41=sheet.createRow(i +40);
HSSFCell r1c41=r41.createCell((short)0);
r1c41.setCellValue(coils );
}
}
}
}else
{
if( custpo.trim().length() <=16)
{ HSSFRow r42=sheet.createRow(i +41);
HSSFCell r1c42=r42.createCell((short)0);
r1c42.setCellValue(custpo.trim() );
HSSFRow r43=sheet.createRow(i +42);
HSSFCell r1c43=r43.createCell((short)0);
r1c43.setCellValue(coils );
}else
{ HSSFRow r43=sheet.createRow(i +42);
HSSFCell r1c43=r43.createCell((short)0);
r1c43.setCellValue(custpo );
}
}
if(prepaid!=null)
{
HSSFRow r44=sheet.createRow(i +43);
HSSFCell r1c44=r44.createCell((short)0);
r1c44.setCellValue("PREPAID" );
HSSFRow r45=sheet.createRow(i +44);
HSSFCell r1c45=r45.createCell((short)0);
r1c45.setCellValue(prepaid );
HSSFRow r46=sheet.createRow(i +45);
HSSFCell r1c46=r46.createCell((short)0);
r1c46.setCellValue("CR" );
HSSFRow r47=sheet.createRow(i +46);
HSSFCell r1c47=r47.createCell((short)0);
r1c47.setCellValue(collect);
}
if(otherfees!=null)
{
String CR="";
totherfees=Double.valueOf(otherfees).doubleValue() ;
if(totherfees<0)
totherfees=totherfees*(-1);
if(totherfees > 0) CR="";else CR="CR";
HSSFRow r48=sheet.createRow(i +47);
HSSFCell r1c48=r48.createCell((short)0);
r1c48.setCellValue(reason1 +" "+ reason2);
HSSFRow r49=sheet.createRow(i +48);
HSSFCell r1c49=r49.createCell((short)0);
r1c49.setCellValue(totherfees);
HSSFRow r50=sheet.createRow(i +49);
HSSFCell r1c50=r50.createCell((short)0);
r1c50.setCellValue(CR);
}
if(sundry!=null)
{
String CR="";
tsundry=Double.valueOf(sundry).doubleValue() ;
if(tsundry<0)
tsundry=tsundry*(-1);
if(totherfees > 0) CR="";else CR="CR";
HSSFRow r51=sheet.createRow(i +50);
HSSFCell r1c51=r51.createCell((short)0);
r1c51.setCellValue(reason1 +" "+ reason2 );
HSSFRow r52=sheet.createRow(i +51);
HSSFCell r1c52=r52.createCell((short)0);
r1c52.setCellValue(tsundry );
HSSFRow r53=sheet.createRow(i +52);
HSSFCell r1c53=r53.createCell((short)0);
r1c53.setCellValue(CR );
}
if(freight!=null)
{ HSSFRow r54=sheet.createRow(i +53);
HSSFCell r1c54=r54.createCell((short)0);
r1c54.setCellValue(" FREIGHT ALLOWANCE" );
HSSFRow r55=sheet.createRow(i +54);
HSSFCell r1c55=r55.createCell((short)0);
r1c55.setCellValue(freight );
HSSFRow r56=sheet.createRow(i +55);
HSSFCell r1c56=r56.createCell((short)0);
r1c56.setCellValue("CR" );
}
if(!(otherfees==null && sundry==null && freight==null))
{ HSSFRow r57=sheet.createRow(i +56);
HSSFCell r1c57=r57.createCell((short)0);
r1c57.setCellValue(subtot );
print_invamt=false;
}
else
{
print_invamt=false;
}
if(country =="O")
{
if(print_invamt)
{ HSSFRow r58=sheet.createRow(i +57);
HSSFCell r1c58=r58.createCell((short)0);
r1c58.setCellValue(invamt );
}
}else
{
if(invgst==null)
{
if(fsurcharge!=null)
{ HSSFRow r59=sheet.createRow(i +58);
HSSFCell r1c59=r59.createCell((short)0);
r1c59.setCellValue(" FUEL SURCHARGE " );
HSSFRow r60=sheet.createRow(i +59);
HSSFCell r1c60=r59.createCell((short)0);
r1c59.setCellValue(gross );
HSSFRow r61=sheet.createRow(i +60);
HSSFCell r1c61=r61.createCell((short)0);
r1c61.setCellValue(fsurrate );
HSSFRow r62=sheet.createRow(i +61);
HSSFCell r1c62=r62.createCell((short)0);
r1c62.setCellValue(fsurcharge );
HSSFRow r63=sheet.createRow(i +62);
HSSFCell r1c63=r63.createCell((short)0);
r1c63.setCellValue(invamt );
}
}else
{ HSSFRow r59=sheet.createRow(i +58);
HSSFCell r1c59=r59.createCell((short)0);
r1c59.setCellValue(" GST/HST " );
HSSFRow r60=sheet.createRow(i +59);
HSSFCell r1c60=r59.createCell((short)0);
r1c59.setCellValue(invgst );
if(fsurcharge!=null)
{ HSSFRow r61=sheet.createRow(i +60);
HSSFCell r1c61=r61.createCell((short)0);
r1c61.setCellValue("FUEL SURCHARGE" );
HSSFRow r62=sheet.createRow(i +61);
HSSFCell r1c62=r62.createCell((short)0);
r1c62.setCellValue(gross );
HSSFRow r63=sheet.createRow(i +62);
HSSFCell r1c63=r63.createCell((short)0);
r1c63.setCellValue(fsurrate );
HSSFRow r64=sheet.createRow(i +63);
HSSFCell r1c64=r64.createCell((short)0);
r1c64.setCellValue(fsurcharge );
HSSFRow r65=sheet.createRow(i +64);
HSSFCell r1c65=r65.createCell((short)0);
r1c65.setCellValue(invamt );
}
}
}
if("UO".indexOf(country ) > 0 )
{
if(!from_whouse)
{
if(Integer.parseInt( invamt ) >= 0 )
{ HSSFRow r66=sheet.createRow(i +65);
HSSFCell r1c66=r66.createCell((short)0);
r1c66.setCellValue("NON RELATED TRANSACTION " + country=="O"?"MADE IN CANADA":"MADE IN ONTARIO, CANADA" );
}
}
if(Integer.parseInt( invamt ) >= 0 )
{ HSSFRow r67=sheet.createRow(i +66);
HSSFCell r1c67=r67.createCell((short)0);
r1c67.setCellValue("GROSS WEIGHT:" + gross + wght);
HSSFRow r68=sheet.createRow(i +67);
HSSFCell r1c68=r68.createCell((short)0);
r1c68.setCellValue(" SHIP TO:" + shname );
}
if(Integer.parseInt( invamt ) >= 0 )
{
if(to_whouse || from_whouse)
{
cwh=ordertype;
HSSFRow r69=sheet.createRow(i +68);
HSSFCell r1c69=r69.createCell((short)0);
r1c69.setCellValue(" VIA:" + ttblno==null?"":" B/L:"+ ttblno );
}
HSSFRow r70=sheet.createRow(i +69);
HSSFCell r1c70=r70.createCell((short)0);
r1c70.setCellValue( shadd1 );
if(shadd2!="")
{
HSSFRow r71=sheet.createRow(i +70);
HSSFCell r1c71=r71.createCell((short)0);
r1c71.setCellValue( shadd2 );
}
if(shadd3!="")
{ HSSFRow r72=sheet.createRow(i +71);
HSSFCell r1c72=r72.createCell((short)0);
r1c72.setCellValue( shadd3 );
}
if(shadd4!="")
{ HSSFRow r73=sheet.createRow(i +72);
HSSFCell r1c73=r73.createCell((short)0);
r1c73.setCellValue( shadd4 );
}
}
if(!from_whouse)
{
if(Integer.parseInt( invamt ) >= 0 )
{ HSSFRow r74=sheet.createRow(i +73);
HSSFCell r1c74=r74.createCell((short)0);
r1c74.setCellValue( "THE FOLLOWING IS INCLUDED IN ABOVE C.I.F. SELLING PRICE" );
HSSFRow r75=sheet.createRow(i +74);
HSSFCell r1c75=r75.createCell((short)0);
r1c75.setCellValue( "PACKING INCLUDED IN ABOVE SELLING PRICE:" );
HSSFRow r76=sheet.createRow(i +75);
HSSFCell r1c76=r76.createCell((short)0);
r1c76.setCellValue( "FREIGHT & INSURANCE FROM:"+ plant=="FERG"?"FERGUS, ONTARIO, CANADA":"RICHMOND HILL, ONTARIO, CANADA" );
amount=frins+insurance;
HSSFRow r77=sheet.createRow(i +76);
HSSFCell r1c77=r77.createCell((short)0);
r1c77.setCellValue(amount);
if(duty > 0 )
{ HSSFRow r78=sheet.createRow(i +77);
HSSFCell r1c78=r78.createCell((short)0);
r1c78.setCellValue("U.S. DUTY:</td><td> " + duty );
frsubtot= frins+insurance+duty ;
HSSFRow r79=sheet.createRow(i +78);
HSSFCell r1c79=r79.createCell((short)0);
r1c79.setCellValue(frsubtot);
}
}
if(Integer.parseInt( invamt ) >= 0 )
{
if(verifyby !="PROFORMA")
{ HSSFRow r80=sheet.createRow(i +79);
HSSFCell r1c80=r80.createCell((short)0);
r1c80.setCellValue("WE CERTIFY THIS TO BE A TRUE AND CORRECT COPY OF THE ORIGINAL INVOIC");
}
if(country=="U")
{ HSSFRow r81=sheet.createRow(i +80);
HSSFCell r1c81=r81.createCell((short)0);
r1c81.setCellValue("NOTIFY: PBB GROUP FOR CUSTOMS CLEARANCE");
HSSFRow r82=sheet.createRow(i +81);
HSSFCell r1c82=r82.createCell((short)0);
r1c82.setCellValue("U.S. CUSTOMS CLEARANCE CHARGES FOR A/C OF: WOLVERINE RATCLIFFS INC.");
}
if(verifyby !="PROFORMA")
{ HSSFRow r83=sheet.createRow(i +82);
HSSFCell r1c83=r83.createCell((short)0);
r1c83.setCellValue(cName);
HSSFRow r84=sheet.createRow(i +83);
HSSFCell r1c84=r84.createCell((short)0);
r1c84.setCellValue(cTraffic);
HSSFRow r85=sheet.createRow(i +84);
HSSFCell r1c85=r85.createCell((short)0);
r1c85.setCellValue("TRAFFIC & EXPORT DEPT.");
}
}
}
}
HSSFRow r86=sheet.createRow(i +85);
HSSFRow r87=sheet.createRow(i +86);
HSSFRow r88=sheet.createRow(i +87);
}
}
%>
<% HSSFSheet sheet2 = book.createSheet("PackList");
if(!PackList.equals("") )
{
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);
ASResultSet rsg=Sqlca.getASResultSet("select * from global");
rsg.next();
cname=rsg.getString("cnconame");
ASResultSet rsP=Sqlca.getASResultSet("select * from packnote where blno =" +BLNO + " order by custpo, worksno");
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")+"'");
geocode=rsc.getString("geocode") ;
ASResultSet rss=Sqlca.getASResultSet("select * from shipment where blno =" +BLNO );
d_shipdt=rss.getString("shipdt");
if(rsc.getString("ordertype").trim() =="REG")
{
} else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -