Subversion Repositories SmartDukaan

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

import com.spice.profitmandi.dao.entity.catalog.Scheme;

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

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

import javax.persistence.*;

import java.io.Serializable;

import java.time.LocalDateTime;

import java.util.Objects;

@Entity

@Table(name = "fofo.scheme_in_out")

@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 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 >= :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"),

        @NamedQuery(name = "SchemeInOut.selectAllPurchaseInventoryByFofoId", query = "select new com.spice.profitmandi.dao.model.AllPurchaseInventoryModel(sum(cast(sio.amount As int ))) from InventoryItem ii join SchemeInOut sio on"

                + "  sio.inventoryItemId=ii.id join Scheme sc on sc.id=sio.schemeId  where sc.type in :types and ii.fofoId = :fofoId and ii.createTimestamp >= :startDate and "

                + "  ii.createTimestamp <= :endDate and ii.fofoId = :fofoId group by ii.fofoId"),

        @NamedQuery(name = "SchemeInOut.selectAllCreditedSaleInventoryByFofoId", query = "select new com.spice.profitmandi.dao.model.AllPurchaseInventoryModel(sum(cast(sio.amount As int ))) from "

                + "  ScanRecord sr join InventoryItem  ii on ii.id=sr.inventoryItemId join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on (sio.inventoryItemId=sr.inventoryItemId) join Scheme sc on sc.id=sio.schemeId   where   sc.type in :types and fo.cancelledTimestamp is null and "

                + "  sio.status='CREDITED' and sr.type='SALE' and sr.createTimestamp >= :startDate and sr.createTimestamp <= :endDate and sr.fofoId = :fofoId group by sr.fofoId"),

        @NamedQuery(name = "SchemeInOut.selectFrontIncomeByFofoId", query = "select new com.spice.profitmandi.dao.model.AllPurchaseInventoryModel(sum(cast(foi.sellingPrice As int )-cast(foi.dp As int ))) "

                + " from InventoryItem ii join ScanRecord sr on sr.inventoryItemId=ii.id join FofoOrder fo on fo.id=sr.orderId join FofoOrderItem foi on (foi.orderId=fo.id and foi.itemId=ii.itemId) where "

                + " fo.cancelledTimestamp is null and sr.type='SALE' and sr.createTimestamp >=:startDate and sr.createTimestamp <= :endDate and sr.fofoId = :fofoId group by sr.fofoId"),

        @NamedQuery(name = "SchemeInOut.selectAllPendingSaleInventoryByFofoId", query = "select new com.spice.profitmandi.dao.model.AllPurchaseInventoryModel(sum(cast(sio.amount As int ))) from "

                + "  ScanRecord sr join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on  sio.inventoryItemId=sr.inventoryItemId  where  fo.cancelledTimestamp is null and "

                + "  sio.status='PENDING' and sr.type='SALE' and sr.createTimestamp >= :startDate and sr.createTimestamp < :endDate and sr.fofoId = :fofoId group by sr.fofoId"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthCreditedIncomeByFofoId", query = "select new com.spice.profitmandi.dao.model.LastMonthCreditedIncomeModel(foi.brand,sum(cast(foi.quantity As int)), sum(cast(sio.amount As int))) from ScanRecord sr "

                + " join InventoryItem  ii on ii.id=sr.inventoryItemId join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on sio.inventoryItemId=sr.inventoryItemId join FofoOrderItem foi on (foi.orderId=fo.id and foi.itemId=ii.itemId) join Scheme sc on sc.id=sio.schemeId   where   sc.type in :types and fo.cancelledTimestamp is null and "

                + "sio.status='CREDITED' and sr.type='SALE' and sr.createTimestamp >= :startDate and sr.createTimestamp < :endDate and sr.fofoId = :fofoId group by foi.brand"),

        @NamedQuery(name = "SchemeInOut.selectFrontIncomeByBrand", query = "select new com.spice.profitmandi.dao.model.LastMonthCreditedIncomeModel(foi.brand,sum(cast(foi.quantity As int)), sum(cast(foi.sellingPrice As int )-cast(ii.unitPrice-ii.priceDropAmount As int ))) "

                + " from InventoryItem ii join ScanRecord sr on sr.inventoryItemId=ii.id join FofoOrder fo on fo.id=sr.orderId join FofoOrderItem foi on (foi.orderId=fo.id and foi.itemId = ii.itemId) where "

                + " fo.cancelledTimestamp is null and sr.type='SALE' and sr.createTimestamp >=:startDate and sr.createTimestamp <= :endDate and sr.fofoId = :fofoId group by foi.brand"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthPendingIncomeByFofoId", query = "select new com.spice.profitmandi.dao.model.LastMonthCreditedIncomeModel(foi.brand,sum(cast(foi.quantity As int)),sum(cast(sio.amount As int ))) from "

                + "  ScanRecord sr join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on  sio.inventoryItemId=sr.inventoryItemId  join FofoOrderItem foi on  foi.orderId=fo.id where  fo.cancelledTimestamp is null and "

                + "  sio.status='PENDING' and sr.type='SALE' and sr.createTimestamp >= :startDate and sr.createTimestamp < :endDate and sr.fofoId = :fofoId group by foi.brand"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthPurchaseInMarginByFofoId", query = "select new com.spice.profitmandi.dao.model.LastMonthCreditedIncomeModel(i.brand, count(distinct ii.id ),sum(cast(sio.amount As int ))) from InventoryItem ii join SchemeInOut sio on"

                + "  sio.inventoryItemId=ii.id join Scheme sc on sc.id=sio.schemeId join Item i on i.id=ii.itemId where sio.status='CREDITED' and sc.type in  :types and ii.fofoId = :fofoId and ii.createTimestamp >= :startDate and "

                + "  ii.createTimestamp <= :endDate group by i.brand"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthBrandWiseIncome", query = "select new com.spice.profitmandi.dao.model.LastMonthBrandWiseIncomeModel(" +

                " i.brand,sum(case when sio.status = 'CREDITED' then cast(sr.quantity As int) else 0 end)," +

                " sum(case when sio.status = 'CREDITED' then cast(sio.amount As float) else  0 end)," +

                " sum(case when sio.status = 'PENDING' then cast(sio.amount As float) else  0 end)," +

                "i.catalogItemId,i.modelName,i.modelNumber) from ScanRecord sr join InventoryItem ii on ii.id=sr.inventoryItemId "

                + "  join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on sio.inventoryItemId=sr.inventoryItemId join FofoOrderItem foi on (foi.orderId=fo.id and ii.itemId=foi.itemId)  join FofoLineItem  fli on (fli.fofoOrderItemId=foi.id and fli.serialNumber=ii.serialNumber)  join  Item i on i.id=foi.itemId join Scheme sc on sc.id=sio.schemeId   where   sc.type in :types and fo.cancelledTimestamp is null and "

                + "  (sio.status='CREDITED' or sio.status='PENDING') and sr.type='SALE' and sr.createTimestamp >= :startDate and sr.createTimestamp < :endDate and sr.fofoId = :fofoId  and foi.brand = :brand group by i.catalogItemId,i.modelName,i.modelNumber,i.brand"),

        @NamedQuery(name = "SchemeInOut.selectFrontIncomeBrandWise", query = "select new com.spice.profitmandi.dao.model.LastMonthFrontEndBrandWiseIncome(i.brand,sum(cast(sr.quantity As int)),sum(cast(foi.sellingPrice -(ii.unitPrice-ii.priceDropAmount) As float)),0.0,i.catalogItemId,i.modelName,i.modelNumber) "

                + " from InventoryItem ii join ScanRecord sr on sr.inventoryItemId=ii.id join FofoOrder fo on fo.id=sr.orderId join FofoOrderItem foi on (foi.orderId=fo.id and foi.itemId=ii.itemId) join Item i on foi.itemId=i.id where "

                + " fo.cancelledTimestamp is null and sr.type='SALE' and sr.createTimestamp >=:startDate and sr.createTimestamp < :endDate and sr.fofoId = :fofoId and foi.brand = :brand group by i.catalogItemId,i.modelName,i.modelNumber,i.brand"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthPurchaseBrandWiseIncome", query = "select new com.spice.profitmandi.dao.model.LastMonthBrandWiseIncomeModel( " +

                "i.brand ,count(distinct ii.id),sum(cast(sio.amount As float)) ,0.0,i.catalogItemId,i.modelName,i.modelNumber) from"

                + " InventoryItem ii join SchemeInOut sio on sio.inventoryItemId=ii.id join Scheme sc on sc.id=sio.schemeId " +

                " join Item i on i.id=ii.itemId where sio.status='CREDITED' and "

                + "  sc.type in :types and ii.fofoId = :fofoId and i.brand= :brand and ii.createTimestamp >= :startDate and " +

                " ii.createTimestamp <= :endDate group by i.catalogItemId,i.modelName,i.modelNumber,i.brand"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthCreditedImei", query = "select new com.spice.profitmandi.dao.model.LastMonthImeiModel(fli.serialNumber,(case when sio.status='CREDITED' then sio.amount else 0 end),(case when sio.status='PENDING' then sio.amount else 0 end),sc.description,sr.createTimestamp,sio.status)" +

                " from ScanRecord sr join InventoryItem ii on ii.id=sr.inventoryItemId "

                + "      join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on sio.inventoryItemId=sr.inventoryItemId join FofoOrderItem foi on (foi.orderId=fo.id and foi.itemId=ii.itemId)  join FofoLineItem  fli on (fli.fofoOrderItemId=foi.id and fli.serialNumber=ii.serialNumber) "

                + "      join  Item i on i.id=foi.itemId join Scheme sc on sc.id=sio.schemeId   where   sc.type in :types and fo.cancelledTimestamp is null and (sio.status='CREDITED' or sio.status='PENDING' ) and sr.type='SALE' and sr.createTimestamp >= :startDate and sr.createTimestamp <= :endDate and "

                + "      i.catalogItemId= :catalogItemId and sr.fofoId = :fofoId"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthPurchaseInImei", query = "select new com.spice.profitmandi.dao.model.LastMonthImeiModel(ii.serialNumber,sio.amount,cast(0.0 As float),sc.description,ii.createTimestamp,sio.status) from InventoryItem ii "

                + "     join SchemeInOut sio on sio.inventoryItemId=ii.id join Scheme sc on sc.id=sio.schemeId join Item i on i.id=ii.itemId where sio.status='CREDITED' and sc.type in :types and ii.fofoId = :fofoId and "

                + "     i.catalogItemId= :catalogItemId and ii.createTimestamp >= :startDate and ii.createTimestamp <= :endDate"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthFrontEndImei", query = "select new com.spice.profitmandi.dao.model.LastMonthFrontEndImeiModel( ii.serialNumber,foi.sellingPrice, ii.unitPrice-ii.priceDropAmount) from InventoryItem ii "

                + "      join ScanRecord sr on sr.inventoryItemId=ii.id join FofoOrder fo on fo.id=sr.orderId join FofoOrderItem foi on (foi.orderId=fo.id and foi.itemId=ii.itemId) join Item i on foi.itemId=i.id where "

                + "     fo.cancelledTimestamp is null and sr.type='SALE' and i.catalogItemId= :catalogItemId and sr.createTimestamp >=:startDate and sr.createTimestamp <= :endDate and sr.fofoId = :fofoId "

                + "     group by ii.id"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthCreditedByImei", query = "select new com.spice.profitmandi.dao.model.LastMonthImeiModel(fli.serialNumber,(case when sio.status='CREDITED' then sio.amount else 0 end),(case when sio.status='PENDING' then sio.amount else 0 end),sc.description,sr.createTimestamp,sio.status)from ScanRecord sr "

                + "   join InventoryItem ii on ii.id=sr.inventoryItemId  join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on sio.inventoryItemId=sr.inventoryItemId join FofoOrderItem foi on foi.orderId=fo.id  join FofoLineItem  fli on (fli.fofoOrderItemId=foi.id and fli.serialNumber=ii.serialNumber )"

                + "      join  Item i on i.id=foi.itemId join Scheme sc on sc.id=sio.schemeId   where   sc.type in :types and fo.cancelledTimestamp is null and (sio.status='CREDITED' or sio.status='PENDING') and sr.type='SALE' and "

                + "      fli.serialNumber in :imeis and sr.fofoId = :fofoId"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthPurchaseInByImei", query = "select new com.spice.profitmandi.dao.model.LastMonthImeiModel(ii.serialNumber,sio.amount, cast(0.0 As float) ,sc.description,ii.createTimestamp,sio.status) from InventoryItem ii "

                + "     join SchemeInOut sio on sio.inventoryItemId=ii.id join Scheme sc on sc.id=sio.schemeId join Item i on i.id=ii.itemId where sio.status='CREDITED' and sc.type in :types and ii.fofoId = :fofoId and "

                + "     ii.serialNumber in :imeis"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthFrontEndByImei", query = "select new com.spice.profitmandi.dao.model.LastMonthFrontEndImeiModel( ii.serialNumber,foi.sellingPrice, ii.unitPrice-ii.priceDropAmount, fo.createTimestamp) from InventoryItem ii "

                + "      join ScanRecord sr on sr.inventoryItemId=ii.id join FofoOrder fo on fo.id=sr.orderId join FofoOrderItem foi on (foi.orderId=fo.id and ii.itemId=foi.itemId) where "

                + "     fo.cancelledTimestamp is null and sr.type='SALE' and ii.serialNumber in (:imeis) and sr.fofoId = :fofoId  group by ii.id"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthCategoryUpgradeMarginByBrand", query = "select new com.spice.profitmandi.dao.model.LastMonthCategoryUpgradeMargin(foi.brand, sum(case when sio.status='REJECTED' then -sio.amount else sio.amount end) ) " +

                " from ScanRecord sr join InventoryItem ii on ii.id=sr.inventoryItemId "

                + " join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on sio.inventoryItemId=sr.inventoryItemId join FofoOrderItem foi on (foi.orderId=fo.id and foi.itemId=ii.itemId) join Scheme sc on sc.id=sio.schemeId   where   sc.type = 'CATEGORY' and fo.cancelledTimestamp is null "

                + "  and sr.type='SALE' and sr.createTimestamp >= :startDate and sr.createTimestamp <= :endDate and sr.fofoId = :fofoId group by foi.brand"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthCategoryUpgradeMarginByBrandModel", query = "select new com.spice.profitmandi.dao.model.LastMonthCategoryUpgradeMargin(i.modelNumber,sum(case when sio.status='REJECTED' then -sio.amount else sio.amount end)) " +

                " from ScanRecord sr join InventoryItem ii on ii.id=sr.inventoryItemId "

                + " join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on sio.inventoryItemId=sr.inventoryItemId join FofoOrderItem foi on (foi.orderId=fo.id and foi.itemId=ii.itemId) join FofoLineItem  fli on (fli.fofoOrderItemId=foi.id and fli.serialNumber=ii.serialNumber)  join  Item i on i.id=foi.itemId join Scheme sc on sc.id=sio.schemeId   where   sc.type = 'CATEGORY' and fo.cancelledTimestamp is null and "

                + " sr.type='SALE' and sr.createTimestamp >= :startDate and sr.createTimestamp <= :endDate and sr.fofoId = :fofoId  and foi.brand = :brand group by i.catalogItemId,i.modelName,i.modelNumber,i.brand"),

        @NamedQuery(name = "SchemeInOut.selectLastMonthCategoryUpgradeMarginByImei", query = "select new com.spice.profitmandi.dao.model.LastMonthCategoryUpgradeMargin(fli.serialNumber,sum(case when sio.status='REJECTED' then -sio.amount else sio.amount end) ) from " +

                " ScanRecord sr join InventoryItem ii on ii.id=sr.inventoryItemId "

                + "      join FofoOrder fo on fo.id=sr.orderId join SchemeInOut sio on sio.inventoryItemId=sr.inventoryItemId join FofoOrderItem foi on (foi.orderId=fo.id and foi.itemId=ii.itemId)  join FofoLineItem  fli on (fli.fofoOrderItemId=foi.id  and ii.serialNumber=fli.serialNumber) "

                + "      join  Item i on i.id=foi.itemId join Scheme sc on sc.id=sio.schemeId   where sc.type = 'CATEGORY' and fo.cancelledTimestamp is null and sr.type='SALE' and sr.createTimestamp >= :startDate and sr.createTimestamp <= :endDate and "

                + "      i.catalogItemId= :catalogItemId and sr.fofoId = :fofoId group by fli.serialNumber"),

        @NamedQuery(name = "SchemeInOut.selectSchemeEarningsByFofoId",

                query = "select new com.spice.profitmandi.dao.model.SchemeEarningModel("

                        + " s.id, s.name, s.description, i.brand, count(distinct ii.id), sum(sio.amount))"

                        + " from SchemeInOut sio"

                        + " join Scheme s on s.id=sio.schemeId"

                        + " join InventoryItem ii on ii.id=sio.inventoryItemId"

                        + " join Item i on i.id=ii.itemId"

                        + " where ii.fofoId = :fofoId"

                        + " and sio.status = 'CREDITED'"

                        + " and sio.rolledBackTimestamp is null"

                        + " and sio.creditTimestamp >= :startDate and sio.creditTimestamp <= :endDate"

                        + " group by s.id, s.name, s.description, i.brand"),

        @NamedQuery(name = "SchemeInOut.selectPaidMargins", query = "select new com.spice.profitmandi.service.transaction.InventoryMarginModel("

                + " ii.fofoId, ii.sgstRate, ii.cgstRate, ii.igstRate," +

                " cast(case when sio.creditTimestamp >= :startDate and sio.creditTimestamp <= :endDate then sio.amount " +

                "			when sio.creditTimestamp is not null and sio.rolledBackTimestamp >= :startDate and sio.rolledBackTimestamp <= :endDate then -sio.amount" +

                "			else 0 end as float), ii.id, ii.serialNumber, s.name, p.purchaseReference, " +

                " case when sio.rolledBackTimestamp >= :startDate and sio.rolledBackTimestamp <= :endDate then sio.rolledBackTimestamp else sio.creditTimestamp end, ii.hsnCode)  from "

                + " SchemeInOut sio join Scheme s on s.id=sio.schemeId join InventoryItem ii on sio.inventoryItemId=ii.id join com.spice.profitmandi.dao.entity.fofo.Purchase p on p.id=ii.purchaseId"

                + " where sio.createTimestamp >= :cnDate and (:fofoId IS NULL OR ii.fofoId = :fofoId) and ((sio.creditTimestamp >= :startDate and sio.creditTimestamp <= :endDate) or (sio.creditTimestamp is not null and sio.rolledBackTimestamp >= :startDate and sio.rolledBackTimestamp <= :endDate))"

                + " and not (sio.rolledBackTimestamp is not null and sio.creditTimestamp >= :startDate and sio.creditTimestamp <= :endDate and sio.rolledBackTimestamp >= :startDate and sio.rolledBackTimestamp <= :endDate)")

})

public class SchemeInOut implements Serializable {

    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;

    @Transient

    private int reference;

    @Transient

    private String serialNumber;

    @Transient

    private String storeCode;

    @Transient

    private SchemeType schemeType;

    @Transient

    private Scheme scheme;

    public SchemeInOut(int schemeId, int inventoryItemId) {

        this.schemeId = schemeId;

        this.inventoryItemId = inventoryItemId;

    }

    public SchemeInOut() {

    }

    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;

    }

    public int getReference() {

        return reference;

    }

    public void setReference(int reference) {

        this.reference = reference;

    }

    public Scheme getScheme() {

        return scheme;

    }

    public void setScheme(Scheme scheme) {

        this.scheme = scheme;

    }

    @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 +

                ", scheme=" + scheme +

                '}';

    }

    @Override

    public boolean equals(Object o) {

        if (this == o) return true;

        if (o == null || getClass() != o.getClass()) return false;

        SchemeInOut that = (SchemeInOut) o;

        return id == that.id && schemeId == that.schemeId && inventoryItemId == that.inventoryItemId && Float.compare(that.amount, amount) == 0 && reference == that.reference && status == that.status && Objects.equals(createTimestamp, that.createTimestamp) && Objects.equals(rolledBackTimestamp, that.rolledBackTimestamp) && Objects.equals(creditTimestamp, that.creditTimestamp) && Objects.equals(statusDescription, that.statusDescription) && Objects.equals(serialNumber, that.serialNumber) && Objects.equals(storeCode, that.storeCode) && schemeType == that.schemeType && Objects.equals(scheme, that.scheme);

    }

    @Override

    public int hashCode() {

        return Objects.hash(id, schemeId, inventoryItemId, amount, status, createTimestamp, rolledBackTimestamp, creditTimestamp, statusDescription, reference, serialNumber, storeCode, schemeType, scheme);

    }

    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;

    }

}