package com.model.main;

import java.io.Serializable;

import javax.persistence.*;

import com.dao.hibernate.HibernateUtil;

@Entity
@Table(name="bb_batter_stat")
@NamedQueries({
        @NamedQuery(name=BatterStat.GET_STAT_BY_PLAYER_ID,
                query = "SELECT s FROM BatterStat s WHERE s.player=:player"),
        @NamedQuery(name=BatterStat.UPDATE_BATTER_STAT,
        query = "UPDATE BatterStat s SET " +
                "s.aField = :aField," +
                "s.abInt = :abInt," +
                "s.abvsl = :abvsl," +
                "s.abvsr = :abvsr," +
                "s.avgInt = :avgInt," +
                "s.avgvsl = :avgvsl," +
                "s.avgvsr = :avgvsr," +
                "s.bbvsl = :bbvsl," +
                "s.bbvsr = :bbvsr," +
                "s.cs = :cs," +
                "s.csField = :csField," +
                "s.d2bInt = :d2bInt," +
                "s.d2bvsl = :d2bvsl," +
                "s.d2bvsr = :d2bvsr," +
                "s.dpField = :dpField," +
                "s.eField = :eField," +
                "s.fo = :fo," +
                "s.fpctField = :fpctField," +
                "s.g = :g," +
                "s.gField = :gField," +
                "s.go = :go," +
                "s.gsField = :gsField," +
                "s.hInt = :hInt," +
                "s.hbp = :hbp," +
                "s.hrInt = :hrInt," +
                "s.hrvsl = :hrvsl," +
                "s.hrvsr = :hrvsr," +
                "s.hvsl = :hvsl," +
                "s.hvsr = :hvsr," +
                "s.ibb = :ibb," +
                "s.innField = :innField," +
                "s.np = :np," +
                "s.obpvsl = :obpvsl," +
                "s.obpvsr = :obpvsr," +
                "s.ops = :ops," +
                "s.pavsl = :pavsl," +
                "s.pavsr = :pavsr," +
                "s.pbField = :pbField," +
                "s.poField = :poField," +
                "s.rInt = :rInt," +
                "s.rbiInt = :rbiInt," +
                "s.rblvsl = :rblvsl," +
                "s.rblvsr = :rblvsr," +
                "s.rfField = :rfField," +
                "s.rvsl = :rvsl," +
                "s.rvsr = :rvsr," +
                "s.sb = :sb," +
                "s.sbField = :sbField," +
                "s.sbInt = :sbInt," +
                "s.sfvsl = :sfvsl," +
                "s.sfvsr = :sfvsr," +
                "s.slgvsl = :slgvsl," +
                "s.slgvsr = :slgvsr," +
                "s.sovsl = :sovsl," +
                "s.sovsr = :sovsr," +
                "s.t3bInt = :t3bInt," +
                "s.t3bvsl = :t3bvsl," +
                "s.t3bvsr = :t3bvsr," +
                "s.tb = :tb," +
                "s.xbh = :xbh WHERE s.player = :player")
})
public class BatterStat implements Serializable {
    public static final String GET_STAT_BY_PLAYER_ID = "BatterStat:GET_STAT_BY_PLAYER_ID";
    private static final long serialVersionUID = 1L;
    public static final String UPDATE_BATTER_STAT = "BatterStat:UPDATE_BATTER_STAT";
    private Integer id;
    private Integer aField;
    private Integer abInt;
    private Integer abvsl;
    private Integer abvsr;
    private float avgInt;
    private float avgvsl;
    private float avgvsr;
    private Integer bbvsl;
    private Integer bbvsr;
    private Integer cs;
    private Integer csField;
    private Integer d2bInt;
    private Integer d2bvsl;
    private Integer d2bvsr;
    private Integer dpField;
    private Integer eField;
    private Integer fo;
    private float fpctField;
    private Integer g;
    private Integer gField;
    private Integer go;
    private Integer gsField;
    private Integer hInt;
    private Integer hbp;
    private Integer hrInt;
    private Integer hrvsl;
    private Integer hrvsr;
    private Integer hvsl;
    private Integer hvsr;
    private Integer ibb;
    private float innField;
    private Integer np;
    private float obpvsl;
    private float obpvsr;
    private float ops;
    private Integer pavsl;
    private Integer pavsr;
    private Integer pbField;
    private Integer poField;
    private Integer rInt;
    private Integer rbiInt;
    private Integer rblvsl;
    private Integer rblvsr;
    private float rfField;
    private Integer rvsl;
    private Integer rvsr;
    private Integer sb;
    private Integer sbField;
    private Integer sbInt;
    private Integer sfvsl;
    private Integer sfvsr;
    private float slgvsl;
    private float slgvsr;
    private Integer sovsl;
    private Integer sovsr;
    private Integer t3bInt;
    private Integer t3bvsl;
    private Integer t3bvsr;
    private Integer tb;
    private Integer xbh;
    private Player player;

    public BatterStat() {
        aField = new Integer(0);
        abInt = new Integer(0);
        abvsl = new Integer(0);
        abvsr = new Integer(0);
        avgInt = new Integer(0);
        avgvsl = new Integer(0);
        avgvsr = new Integer(0);
        bbvsl = new Integer(0);
        bbvsr = new Integer(0);
        cs = new Integer(0);
        csField = new Integer(0);
        d2bInt = new Integer(0);
        d2bvsl = new Integer(0);
        d2bvsr = new Integer(0);
        dpField = new Integer(0);
        eField = new Integer(0);
        fo = new Integer(0);
        fpctField = new Integer(0);
        g = new Integer(0);
        gField = new Integer(0);
        go = new Integer(0);
        gsField = new Integer(0);
        hInt = new Integer(0);
        hbp = new Integer(0);
        hrInt = new Integer(0);
        hrvsl = new Integer(0);
        hrvsr = new Integer(0);
        hvsl = new Integer(0);
        hvsr = new Integer(0);
        ibb = new Integer(0);
        innField = new Integer(0);
        np = new Integer(0);
        obpvsl = new Integer(0);
        obpvsr = new Integer(0);
        ops = new Integer(0);
        pavsl = new Integer(0);
        pavsr = new Integer(0);
        pbField = new Integer(0);
        poField = new Integer(0);
        rInt = new Integer(0);
        rbiInt = new Integer(0);
        rblvsl = new Integer(0);
        rblvsr = new Integer(0);
        rfField = new Integer(0);
        rvsl = new Integer(0);
        rvsr = new Integer(0);
        sb = new Integer(0);
        sbField = new Integer(0);
        sbInt = new Integer(0);
        sfvsl = new Integer(0);
        sfvsr = new Integer(0);
        slgvsl = new Integer(0);
        slgvsr = new Integer(0);
        sovsl = new Integer(0);
        sovsr = new Integer(0);
        t3bInt = new Integer(0);
        t3bvsl = new Integer(0);
        t3bvsr = new Integer(0);
        tb = new Integer(0);
        xbh = new Integer(0);
    }


    @Id
    @SequenceGenerator(name="BB_BATTER_STAT_ID_GENERATOR", sequenceName="BB_BATTER_STAT_ID_SEQ", allocationSize=HibernateUtil.ALLOCATION_SIZE)
    @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="BB_BATTER_STAT_ID_GENERATOR")
    @Column(unique=true, nullable=false)
    public Integer getId() {
        return this.id;
    }

    public void setId(Integer id) {
        this.id = id;
    }


    @Column(name="a_field")
    public Integer getAField() {
        return this.aField;
    }

    public void setAField(Integer aField) {
        this.aField = aField;
    }


    @Column(name="ab_int")
    public Integer getAbInt() {
        return this.abInt;
    }

    public void setAbInt(Integer abInt) {
        this.abInt = abInt;
    }


    public Integer getAbvsl() {
        return this.abvsl;
    }

    public void setAbvsl(Integer abvsl) {
        this.abvsl = abvsl;
    }


    public Integer getAbvsr() {
        return this.abvsr;
    }

    public void setAbvsr(Integer abvsr) {
        this.abvsr = abvsr;
    }


    @Column(name="avg_int")
    public float getAvgInt() {
        return this.avgInt;
    }

    public void setAvgInt(float avgInt) {
        this.avgInt = avgInt;
    }


    public float getAvgvsl() {
        return this.avgvsl;
    }

    public void setAvgvsl(float avgvsl) {
        this.avgvsl = avgvsl;
    }


    public float getAvgvsr() {
        return this.avgvsr;
    }

    public void setAvgvsr(float avgvsr) {
        this.avgvsr = avgvsr;
    }


    public Integer getBbvsl() {
        return this.bbvsl;
    }

    public void setBbvsl(Integer bbvsl) {
        this.bbvsl = bbvsl;
    }


    public Integer getBbvsr() {
        return this.bbvsr;
    }

    public void setBbvsr(Integer bbvsr) {
        this.bbvsr = bbvsr;
    }


    public Integer getCs() {
        return this.cs;
    }

    public void setCs(Integer cs) {
        this.cs = cs;
    }


    @Column(name="cs_field")
    public Integer getCsField() {
        return this.csField;
    }

    public void setCsField(Integer csField) {
        this.csField = csField;
    }


    @Column(name="d2b_int")
    public Integer getD2bInt() {
        return this.d2bInt;
    }

    public void setD2bInt(Integer d2bInt) {
        this.d2bInt = d2bInt;
    }


    public Integer getD2bvsl() {
        return this.d2bvsl;
    }

    public void setD2bvsl(Integer d2bvsl) {
        this.d2bvsl = d2bvsl;
    }


    public Integer getD2bvsr() {
        return this.d2bvsr;
    }

    public void setD2bvsr(Integer d2bvsr) {
        this.d2bvsr = d2bvsr;
    }


    @Column(name="dp_field")
    public Integer getDpField() {
        return this.dpField;
    }

    public void setDpField(Integer dpField) {
        this.dpField = dpField;
    }


    @Column(name="e_field")
    public Integer getEField() {
        return this.eField;
    }

    public void setEField(Integer eField) {
        this.eField = eField;
    }


    public Integer getFo() {
        return this.fo;
    }

    public void setFo(Integer fo) {
        this.fo = fo;
    }


    @Column(name="fpct_field")
    public float getFpctField() {
        return this.fpctField;
    }

    public void setFpctField(float fpctField) {
        this.fpctField = fpctField;
    }


    public Integer getG() {
        return this.g;
    }

    public void setG(Integer g) {
        this.g = g;
    }


    @Column(name="g_field")
    public Integer getGField() {
        return this.gField;
    }

    public void setGField(Integer gField) {
        this.gField = gField;
    }


    public Integer getGo() {
        return this.go;
    }

    public void setGo(Integer go) {
        this.go = go;
    }


    @Column(name="gs_field")
    public Integer getGsField() {
        return this.gsField;
    }

    public void setGsField(Integer gsField) {
        this.gsField = gsField;
    }


    @Column(name="h_int")
    public Integer getHInt() {
        return this.hInt;
    }

    public void setHInt(Integer hInt) {
        this.hInt = hInt;
    }


    public Integer getHbp() {
        return this.hbp;
    }

    public void setHbp(Integer hbp) {
        this.hbp = hbp;
    }


    @Column(name="hr_int")
    public Integer getHrInt() {
        return this.hrInt;
    }

    public void setHrInt(Integer hrInt) {
        this.hrInt = hrInt;
    }


    public Integer getHrvsl() {
        return this.hrvsl;
    }

    public void setHrvsl(Integer hrvsl) {
        this.hrvsl = hrvsl;
    }


    public Integer getHrvsr() {
        return this.hrvsr;
    }

    public void setHrvsr(Integer hrvsr) {
        this.hrvsr = hrvsr;
    }


    public Integer getHvsl() {
        return this.hvsl;
    }

    public void setHvsl(Integer hvsl) {
        this.hvsl = hvsl;
    }


    public Integer getHvsr() {
        return this.hvsr;
    }

    public void setHvsr(Integer hvsr) {
        this.hvsr = hvsr;
    }


    public Integer getIbb() {
        return this.ibb;
    }

    public void setIbb(Integer ibb) {
        this.ibb = ibb;
    }


    @Column(name="inn_field")
    public float getInnField() {
        return this.innField;
    }

    public void setInnField(float innField) {
        this.innField = innField;
    }


    public Integer getNp() {
        return this.np;
    }

    public void setNp(Integer np) {
        this.np = np;
    }


    public float getObpvsl() {
        return this.obpvsl;
    }

    public void setObpvsl(float obpvsl) {
        this.obpvsl = obpvsl;
    }


    public float getObpvsr() {
        return this.obpvsr;
    }

    public void setObpvsr(float obpvsr) {
        this.obpvsr = obpvsr;
    }


    public float getOps() {
        return this.ops;
    }

    public void setOps(float ops) {
        this.ops = ops;
    }


    public Integer getPavsl() {
        return this.pavsl;
    }

    public void setPavsl(Integer pavsl) {
        this.pavsl = pavsl;
    }


    public Integer getPavsr() {
        return this.pavsr;
    }

    public void setPavsr(Integer pavsr) {
        this.pavsr = pavsr;
    }


    @Column(name="pb_field")
    public Integer getPbField() {
        return this.pbField;
    }

    public void setPbField(Integer pbField) {
        this.pbField = pbField;
    }


    @Column(name="po_field")
    public Integer getPoField() {
        return this.poField;
    }

    public void setPoField(Integer poField) {
        this.poField = poField;
    }


    @Column(name="r_int")
    public Integer getRInt() {
        return this.rInt;
    }

    public void setRInt(Integer rInt) {
        this.rInt = rInt;
    }


    @Column(name="rbi_int")
    public Integer getRbiInt() {
        return this.rbiInt;
    }

    public void setRbiInt(Integer rbiInt) {
        this.rbiInt = rbiInt;
    }


    public Integer getRblvsl() {
        return this.rblvsl;
    }

    public void setRblvsl(Integer rblvsl) {
        this.rblvsl = rblvsl;
    }


    public Integer getRblvsr() {
        return this.rblvsr;
    }

    public void setRblvsr(Integer rblvsr) {
        this.rblvsr = rblvsr;
    }


    @Column(name="rf_field")
    public float getRfField() {
        return this.rfField;
    }

    public void setRfField(float rfField) {
        this.rfField = rfField;
    }


    public Integer getRvsl() {
        return this.rvsl;
    }

    public void setRvsl(Integer rvsl) {
        this.rvsl = rvsl;
    }


    public Integer getRvsr() {
        return this.rvsr;
    }

    public void setRvsr(Integer rvsr) {
        this.rvsr = rvsr;
    }


    public Integer getSb() {
        return this.sb;
    }

    public void setSb(Integer sb) {
        this.sb = sb;
    }


    @Column(name="sb_field")
    public Integer getSbField() {
        return this.sbField;
    }

    public void setSbField(Integer sbField) {
        this.sbField = sbField;
    }


    @Column(name="sb_int")
    public Integer getSbInt() {
        return this.sbInt;
    }

    public void setSbInt(Integer sbInt) {
        this.sbInt = sbInt;
    }


    public Integer getSfvsl() {
        return this.sfvsl;
    }

    public void setSfvsl(Integer sfvsl) {
        this.sfvsl = sfvsl;
    }


    public Integer getSfvsr() {
        return this.sfvsr;
    }

    public void setSfvsr(Integer sfvsr) {
        this.sfvsr = sfvsr;
    }


    public float getSlgvsl() {
        return this.slgvsl;
    }

    public void setSlgvsl(float slgvsl) {
        this.slgvsl = slgvsl;
    }


    public float getSlgvsr() {
        return this.slgvsr;
    }

    public void setSlgvsr(float slgvsr) {
        this.slgvsr = slgvsr;
    }


    public Integer getSovsl() {
        return this.sovsl;
    }

    public void setSovsl(Integer sovsl) {
        this.sovsl = sovsl;
    }


    public Integer getSovsr() {
        return this.sovsr;
    }

    public void setSovsr(Integer sovsr) {
        this.sovsr = sovsr;
    }


    @Column(name="t3b_int")
    public Integer getT3bInt() {
        return this.t3bInt;
    }

    public void setT3bInt(Integer t3bInt) {
        this.t3bInt = t3bInt;
    }


    public Integer getT3bvsl() {
        return this.t3bvsl;
    }

    public void setT3bvsl(Integer t3bvsl) {
        this.t3bvsl = t3bvsl;
    }


    public Integer getT3bvsr() {
        return this.t3bvsr;
    }

    public void setT3bvsr(Integer t3bvsr) {
        this.t3bvsr = t3bvsr;
    }


    public Integer getTb() {
        return this.tb;
    }

    public void setTb(Integer tb) {
        this.tb = tb;
    }

    public Integer getXbh() {
        return this.xbh;
    }

    public void setXbh(Integer xbh) {
        this.xbh = xbh;
    }

    @OneToOne(fetch=FetchType.LAZY)
    @JoinColumn(name="bb_players_id", nullable=false)
    public Player getPlayer() {
        return this.player;
    }

    public void setPlayer(Player player) {
        this.player = player;
    }

}