<hibernate-mapping>
   
   <query name="getBiddersRmng">
      <![CDATA[
         select new RptBiddersRmng(r.currentElig, r.rmngWaivers, r.rmngWithdrawals, r.rmngDropRounds, r.numPWBs, r.bidderName)
         from RptBiddersRmng r where r.auctionId = :auctionId and r.roundNumber = :roundNum
      ]]>
   </query>
</hibernate-mapping>

package gov.fcc.wrv.model;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

/**
* Represents bidders remaining information.
*
* Each RptBiddersRmng is specific to a bidder
* in an auction.
*
* This is used by the reports in the application
*
* @author berinle
*
*/
@Entity
@Table(name="V_WRV_RPT_BDR_RMNG")
public class RptBiddersRmng implements Serializable {

   private static final long serialVersionUID = 1L;
   
   //-------------------------------------------- properties
   //the auction Id
   private Integer auctionId;
   //the bidder Id
   private Integer bidderId;
   //the number of provisional winning bids
   private Integer numPWBs;
   //the number of drop rounds remaining
   private Integer rmngDropRounds;
   //the number of withdrawals remaining
   private Integer rmngWithdrawals;
   //the number of waivers remaining
   private Integer rmngWaivers;
   //the current eligibility
   private Long currentElig;
   //the bidder name
   private String bidderName;
   //Round number
   private Integer roundNumber;
   
   
   
   public RptBiddersRmng(){}
   
   public RptBiddersRmng(Long currentElig, Integer rmngWaivers, Integer rmngWithdrawals, Integer rmngDropRounds, Integer numPWBs, String bidderName)
   {
      this.currentElig = currentElig;
      this.rmngWaivers = rmngWaivers;
      this.rmngWithdrawals = rmngWithdrawals;
      this.rmngDropRounds = rmngDropRounds;
      this.numPWBs = numPWBs;
      this.bidderName = bidderName;
   }

   //-------------------------------------------- accessors
   @Id
   @Column(name="auction_id")
   public Integer getAuctionId() {
      return auctionId;
   }
   public void setAuctionId(Integer auctionId) {
      this.auctionId = auctionId;
   }
   
   @Column(name="round_num")
   public Integer getRoundNumber() {
      return roundNumber;
   }
   public void setRoundNumber(Integer roundNumber) {
      this.roundNumber = roundNumber;
   }
   @Id
   @Column(name="bidder_id")
   public Integer getBidderId() {
      return bidderId;
   }
   public void setBidderId(Integer bidderId) {
      this.bidderId = bidderId;
   }
   @Column(name="num_pwbs")
   public Integer getNumPWBs() {
      return numPWBs;
   }
   public void setNumPWBs(Integer numPWBs) {
      this.numPWBs = numPWBs;
   }
   @Column(name="rmng_drop_rounds")
   public Integer getRmngDropRounds() {
      return rmngDropRounds;
   }
   public void setRmngDropRounds(Integer rmngDropRounds) {
      this.rmngDropRounds = rmngDropRounds;
   }
   @Column(name="rmng_withdrawals")
   public Integer getRmngWithdrawals() {
      return rmngWithdrawals;
   }
   public void setRmngWithdrawals(Integer rmngWithdrawals) {
      this.rmngWithdrawals = rmngWithdrawals;
   }
   @Column(name="rmng_waivers")
   public Integer getRmngWaivers() {
      return rmngWaivers;
   }
   public void setRmngWaivers(Integer rmngWaivers) {
      this.rmngWaivers = rmngWaivers;
   }
   @Column(name="current_elig")
   public Long getCurrentElig() {
      return currentElig;
   }
   public void setCurrentElig(Long currentElig) {
      this.currentElig = currentElig;
   }
   @Column(name="bidder_name")
   public String getBidderName() {
      return bidderName;
   }
   public void setBidderName(String bidderName) {
      this.bidderName = bidderName;
   }
   
   
   @Override
   public int hashCode()
   {
      final int prime = 31;
      int result = 1;
      result = prime * result
            + ((auctionId == null) ? 0 : auctionId.hashCode());
      result = prime * result
            + ((bidderId == null) ? 0 : bidderId.hashCode());
      result = prime * result
            + ((bidderName == null) ? 0 : bidderName.hashCode());
      result = prime * result
            + ((currentElig == null) ? 0 : currentElig.hashCode());
      result = prime * result + ((numPWBs == null) ? 0 : numPWBs.hashCode());
      result = prime * result
            + ((rmngDropRounds == null) ? 0 : rmngDropRounds.hashCode());
      result = prime * result
            + ((rmngWaivers == null) ? 0 : rmngWaivers.hashCode());
      result = prime * result
            + ((rmngWithdrawals == null) ? 0 : rmngWithdrawals.hashCode());
      result = prime * result
            + ((roundNumber == null) ? 0 : roundNumber.hashCode());
      return result;
   }

   @Override
   public boolean equals(Object obj)
   {
      if (this == obj)
         return true;
      if (obj == null)
         return false;
      if (getClass() != obj.getClass())
         return false;
      final RptBiddersRmng other = (RptBiddersRmng) obj;
      if (auctionId == null)
      {
         if (other.auctionId != null)
            return false;
      }
      else if (!auctionId.equals(other.auctionId))
         return false;
      if (bidderId == null)
      {
         if (other.bidderId != null)
            return false;
      }
      else if (!bidderId.equals(other.bidderId))
         return false;
      if (bidderName == null)
      {
         if (other.bidderName != null)
            return false;
      }
      else if (!bidderName.equals(other.bidderName))
         return false;
      if (currentElig == null)
      {
         if (other.currentElig != null)
            return false;
      }
      else if (!currentElig.equals(other.currentElig))
         return false;
      if (numPWBs == null)
      {
         if (other.numPWBs != null)
            return false;
      }
      else if (!numPWBs.equals(other.numPWBs))
         return false;
      if (rmngDropRounds == null)
      {
         if (other.rmngDropRounds != null)
            return false;
      }
      else if (!rmngDropRounds.equals(other.rmngDropRounds))
         return false;
      if (rmngWaivers == null)
      {
         if (other.rmngWaivers != null)
            return false;
      }
      else if (!rmngWaivers.equals(other.rmngWaivers))
         return false;
      if (rmngWithdrawals == null)
      {
         if (other.rmngWithdrawals != null)
            return false;
      }
      else if (!rmngWithdrawals.equals(other.rmngWithdrawals))
         return false;
      if (roundNumber == null)
      {
         if (other.roundNumber != null)
            return false;
      }
      else if (!roundNumber.equals(other.roundNumber))
         return false;
      return true;
   }


}