package org.aitp.competitor;

import java.math.BigDecimal;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class PO {
       private String poNbr;
       private String blgNam;
       private Address blgAdr;
       private String shpNam;
       private Address shpAdr;
       private String ordDte;
       private String reqDte;
       private String shpDte;
       private BigDecimal itmTtl;
       private BigDecimal slsTax;
       private BigDecimal shpAmt;
       private ArrayList PODtlAry;
       
	
	/**
	 * 
	 */
	public PO() {
//		super();
		PODtlAry = new ArrayList();
	}
	
	/**
	 * @return Returns the poNbr.
	 */
	public String getPoNbr() {
		return poNbr;
	}
	
	/**
	 * @param poNbr The poNbr to set.
	 */
	public void setPoNbr(String poNbr) {
		this.poNbr = poNbr;
	}
	
	/**
	 * @return Returns the blgNam.
	 */
	public String getBlgNam() {
		return blgNam;
	}
	
	/**
	 * @param blgNam The blgNam to set.
	 */
	public void setBlgNam(String blgNam) {
		this.blgNam = blgNam;
	}
	
	/**
	 * @return Returns the blgAdr.
	 */
	public Address getBlgAdr() {
		return blgAdr;
	}
	
	/**
	 * @param blgAdr The blgAdr to set.
	 */
	public void setBlgAdr(Address blgAdr) {
		this.blgAdr = blgAdr;
	}
	
	/**
	 * @return Returns the shpNam.
	 */
	public String getShpNam() {
		return shpNam;
	}
	
	/**
	 * @param shpNam The shpNam to set.
	 */
	public void setShpNam(String shpNam) {
		this.shpNam = shpNam;
	}

	/**
	 * @return Returns the shpAdr.
	 */
	public Address getShpAdr() {
		return shpAdr;
	}
	
	/**
	 * @param shpAdr The shpAdr to set.
	 */
	public void setShpAdr(Address shpAdr) {
		this.shpAdr = shpAdr;
	}
	
	/**
	 * @return Returns the ordDte.
	 */
	public String getOrdDte() {
		return ordDte;
	}
	
	/**
	 * @param ordDte The ordDte to set.
	 */
	public void setOrdDte(String ordDte) {
		this.ordDte = ordDte;
	}
	
	/**
	 * @return Returns the reqDte.
	 */
	public String getReqDte() {
		return reqDte;
	}
	
	/**
	 * @param reqDte The reqDte to set.
	 */
	public void setReqDte(String reqDte) {
		this.reqDte = reqDte;
	}

	/**
	 * @return Returns the shpDte.
	 */
	public String getShpDte() {
		return shpDte;
	}
	
	/**
	 * @param shpDte The shpDte to set.
	 */
	public void setShpDte(String shpDte) {
		this.shpDte = shpDte;
	}
	
	/**
	 * @return Returns the itmTtl.
	 */
	public BigDecimal getItmTtl() {
		return itmTtl;
	}
	
	/**
	 * @param itmTtl The itmTtl to set.
	 */
	public void setItmTtl(BigDecimal itmTtl) {
		this.itmTtl = itmTtl;
	}
	
	/**
	 * @return Returns the slsTax.
	 */
	public BigDecimal getSlsTax() {
		return slsTax;
	}
	
	/**
	 * @param slsTax The slsTax to set.
	 */
	public void setSlsTax(BigDecimal slsTax) {
		this.slsTax = slsTax;
	}
	

	/**
	 * @return Returns the shpAmt.
	 */
	public BigDecimal getShpAmt() {
		return shpAmt;
	}
	/**
	 * @param shpAmt The shpAmt to set.
	 */
	public void setShpAmt(BigDecimal shpAmt) {
		this.shpAmt = shpAmt;
	}
	
	/**
	 * @return Returns the pODtl.
	 */
	public PODtl getPODtl(int i) {
		return (PODtl) PODtlAry.get(i);
	}
	
    public PO retrieveHdr(ResultSet rs) {
        Address ba = new Address();
        Address sa = new Address();
        try {
           this.setPoNbr(rs.getString("PONbr"));
           this.setBlgNam(rs.getString("BlgNam"));
           ba.setLine1(rs.getString("BlgLn1"));
           ba.setLine2(rs.getString("BlgLn2"));
           ba.setCity(rs.getString("BlgCty"));
           ba.setState(rs.getString("BlgSt"));
           ba.setZip(rs.getString("BlgZip"));
           this.setBlgAdr(ba);
           this.setShpNam(rs.getString("ShpNam"));
           ba.setLine1(rs.getString("ShpLn1"));
           ba.setLine2(rs.getString("ShpLn2"));
           ba.setCity(rs.getString("ShpCty"));
           ba.setState(rs.getString("ShpSt"));
           ba.setZip(rs.getString("ShpZip"));
           this.setShpAdr(ba);
           this.setOrdDte(rs.getString("OrdDte"));
           this.setReqDte(rs.getString("ReqDte"));
           this.setShpDte(rs.getString("ShpDte"));
           this.setItmTtl(rs.getBigDecimal("ItmTtl"));
           this.setSlsTax(rs.getBigDecimal("SlsTax"));
           this.setShpAmt(rs.getBigDecimal("ShpAmt"));
        } catch (SQLException sqle) {
            System.err.println(sqle);
        } // catch
        return this;
    } // retrieveHdr
    
    public void retrieveDtl(ResultSet rs) {
    	try {
        	PODtl pod = new PODtl(
        			  rs.getShort("POLin"),
			    	  rs.getString("ItmNbr"),
					  rs.getBigDecimal("ItmPrc"),
					  rs.getBigDecimal("ItmWgt"),
					  rs.getInt("OrdAmt"),
					  rs.getInt("ShpAmt"),
					  rs.getInt("BOAmt"));
			this.PODtlAry.add(pod);
        } catch (SQLException sqle) {
    		System.err.println(sqle);
    	} catch (NullPointerException npe) {
			System.err.println(npe);
    	}	// catch
    } // retrieveDtl 

    public int getDtlLen() {
    	return PODtlAry.size();
    }
} // PO