Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.fofo;

import java.io.Serializable;
import java.time.LocalDateTime;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Transient;

import com.spice.profitmandi.dao.enumuration.catalog.SchemeType;
import com.spice.profitmandi.dao.enumuration.transaction.SchemePayoutStatus;

@Entity
@Table(name = "fofo.scheme_in_out", schema = "fofo")

@NamedQueries({

                @NamedQuery(name = "SchemeInOut.selectPendingActivationGroupByBrandYearMonth", query = "select new com.spice.profitmandi.dao.model.ActivationYearMonthModel(i.brand, "
                                + "   DATE_FORMAT(sio.createTimestamp, '%m-%Y'),sum(cast(sio.amount As int)) ) from Scheme sc join  SchemeInOut sio  on"
                                + " sc.id = sio.schemeId join InventoryItem ii  on ii.id = sio.inventoryItemId"
                                + " join Item i on i.id = ii.itemId where sc.type = 'ACTIVATION' and sio.status ='PENDING' and sio.createTimestamp >= :startDate and ii.fofoId = :fofoId  "
                                + "  group by i.brand, DATE_FORMAT(sio.createTimestamp, '%m-%Y')"),

                @NamedQuery(name = "SchemeInOut.selectByYearMonthActivationGroupByBrand", query = "select new com.spice.profitmandi.dao.model.ActivationBrandModel(i.brand, "
                                + "  sum(cast(sio.amount As integer )) ) from Scheme sc join  SchemeInOut sio  on"
                                + " sc.id = sio.schemeId join InventoryItem ii  on ii.id = sio.inventoryItemId"
                                + " join Item i on i.id = ii.itemId where sc.type = 'ACTIVATION' and sio.status ='PENDING' and sio.createTimestamp <= :endDate and ii.fofoId = :fofoId  "
                                + "  group by i.brand"),

                @NamedQuery(name = "SchemeInOut.selectBrandPendingActivationItemDetails", query = "select new com.spice.profitmandi.dao.model.ActivationItemDetailModel(i.brand, "
                                + "  i.modelName,i.modelNumber,cast(sio.amount As integer ),ii.serialNumber, ii.id) from Scheme sc join SchemeInOut sio  on"
                                + "      sc.id = sio.schemeId join InventoryItem ii  on ii.id = sio.inventoryItemId"
                                + "      join Item i on i.id = ii.itemId where sc.type = 'ACTIVATION' and sio.status ='PENDING' and "
                                + "  ii.fofoId = :fofoId and i.brand = :brand and  DATE_FORMAT(sio.createTimestamp, '%m-%Y') = :yearMonthValue"),

                @NamedQuery(name = "SchemeInOut.selectBrandPendingActivationItemDetailByYearMonth", query = "select new com.spice.profitmandi.dao.model.ActivationItemDetailModel(i.brand, "
                                + "  i.modelName,i.modelNumber,cast(sio.amount As integer ),ii.serialNumber, ii.id) from Scheme sc join SchemeInOut sio  on"
                                + "      sc.id = sio.schemeId join InventoryItem ii  on ii.id = sio.inventoryItemId"
                                + "      join Item i on i.id = ii.itemId where sc.type = 'ACTIVATION' and sio.status ='PENDING' and "
                                + "  ii.fofoId = :fofoId and i.brand = :brand and sio.createTimestamp <= :endDate"),

})
public class SchemeInOut implements Serializable {

        public SchemeInOut(int schemeId, int inventoryItemId) {
                this.schemeId = schemeId;
                this.inventoryItemId = inventoryItemId;
        }

        public SchemeInOut() {
        }

        private static final long serialVersionUID = 1L;

        @Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;

        @Column(name = "scheme_id")
        private int schemeId;

        @Column(name = "inventory_item_id")
        private int inventoryItemId;

        @Column(name = "amount")
        private float amount;

        @Column(name = "status")
        @Enumerated(EnumType.STRING)
        private SchemePayoutStatus status;

        @Column(name = "create_timestamp")
        private LocalDateTime createTimestamp = LocalDateTime.now();

        @Column(name = "rolled_back_timestamp")
        private LocalDateTime rolledBackTimestamp;

        @Column(name = "credit_timestamp")
        private LocalDateTime creditTimestamp;

        @Column(name = "description")
        private String statusDescription;

        public int getId() {
                return id;
        }

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

        public SchemePayoutStatus getStatus() {
                return status;
        }

        public void setStatus(SchemePayoutStatus status) {
                this.status = status;
        }

        public LocalDateTime getCreditTimestamp() {
                return creditTimestamp;
        }

        public void setCreditTimestamp(LocalDateTime creditTimestamp) {
                this.creditTimestamp = creditTimestamp;
        }

        public String getStatusDescription() {
                return statusDescription;
        }

        public void setStatusDescription(String statusDescription) {
                this.statusDescription = statusDescription;
        }

        @Transient
        private int reference;

        public int getReference() {
                return reference;
        }

        public void setReference(int reference) {
                this.reference = reference;
        }

        @Transient
        private String serialNumber;

        @Transient
        private String storeCode;

        @Transient
        private SchemeType schemeType;

        public String getStoreCode() {
                return storeCode;
        }

        public void setStoreCode(String storeCode) {
                this.storeCode = storeCode;
        }

        public SchemeType getSchemeType() {
                return schemeType;
        }

        public void setSchemeType(SchemeType schemeType) {
                this.schemeType = schemeType;
        }

        public String getSerialNumber() {
                return serialNumber;
        }

        public void setSerialNumber(String serialNumber) {
                this.serialNumber = serialNumber;
        }

        public int getSchemeId() {
                return schemeId;
        }

        public void setSchemeId(int schemeId) {
                this.schemeId = schemeId;
        }

        public int getInventoryItemId() {
                return inventoryItemId;
        }

        public void setInventoryItemId(int inventoryItemId) {
                this.inventoryItemId = inventoryItemId;
        }

        public float getAmount() {
                return amount;
        }

        public void setAmount(float amount) {
                this.amount = amount;
        }

        public LocalDateTime getCreateTimestamp() {
                return createTimestamp;
        }

        public void setCreateTimestamp(LocalDateTime createTimestamp) {
                this.createTimestamp = createTimestamp;
        }

        public LocalDateTime getRolledBackTimestamp() {
                return rolledBackTimestamp;
        }

        public void setRolledBackTimestamp(LocalDateTime rolledBackTimestamp) {
                this.rolledBackTimestamp = rolledBackTimestamp;
        }

        @Override
        public int hashCode() {
                final int prime = 31;
                int result = 1;
                result = prime * result + Float.floatToIntBits(amount);
                result = prime * result + ((createTimestamp == null) ? 0 : createTimestamp.hashCode());
                result = prime * result + id;
                result = prime * result + inventoryItemId;
                result = prime * result + ((rolledBackTimestamp == null) ? 0 : rolledBackTimestamp.hashCode());
                result = prime * result + schemeId;
                result = prime * result + ((schemeType == null) ? 0 : schemeType.hashCode());
                result = prime * result + ((serialNumber == null) ? 0 : serialNumber.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;
                SchemeInOut other = (SchemeInOut) obj;
                if (Float.floatToIntBits(amount) != Float.floatToIntBits(other.amount))
                        return false;
                if (createTimestamp == null) {
                        if (other.createTimestamp != null)
                                return false;
                } else if (!createTimestamp.equals(other.createTimestamp))
                        return false;
                if (id != other.id)
                        return false;
                if (inventoryItemId != other.inventoryItemId)
                        return false;
                if (rolledBackTimestamp == null) {
                        if (other.rolledBackTimestamp != null)
                                return false;
                } else if (!rolledBackTimestamp.equals(other.rolledBackTimestamp))
                        return false;
                if (schemeId != other.schemeId)
                        return false;
                if (schemeType != other.schemeType)
                        return false;
                if (serialNumber == null) {
                        if (other.serialNumber != null)
                                return false;
                } else if (!serialNumber.equals(other.serialNumber))
                        return false;
                return true;
        }

        @Override
        public String toString() {
                return "SchemeInOut [id=" + id + ", schemeId=" + schemeId + ", inventoryItemId=" + inventoryItemId + ", amount="
                                + amount + ", status=" + status + ", createTimestamp=" + createTimestamp + ", rolledBackTimestamp="
                                + rolledBackTimestamp + ", creditTimestamp=" + creditTimestamp + ", statusDescription="
                                + statusDescription + ", reference=" + reference + ", serialNumber=" + serialNumber + ", storeCode="
                                + storeCode + ", schemeType=" + schemeType + "]";
        }

}