Subversion Repositories SmartDukaan

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

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

import javax.persistence.*;

@Entity
@Table(name = "catalog.focused_model")
@NamedQueries({@NamedQuery(name = "Focused.soldFocusItemByPartner",
                  query = "select new com.spice.profitmandi.dao.model.SoldFocusedItemPartnerWiseModel" +
                                "(foi.itemId, fm.catalogId, fm.obsRecommendedQty, fm.regionId, odr.createTimestamp) " +
                                " FROM FofoOrder odr " +
                                " JOIN FofoOrderItem foi on foi.orderId = odr.id " +
                                " JOIN Item ci on ci.id = foi.itemId " +
                                " JOIN FocusedModel fm on fm.catalogId = ci.catalogItemId " +
                            " JOIN PartnerRegion ptr on ptr.fofoId = (:fofoId) " +
                                " WHERE odr.fofoId = (:fofoId) and odr.createTimestamp > (:orderDate) " +
                                " and (fm.regionId = 5 OR fm.regionId = ptr.regionId) " +
                                " and fm.obsRecommendedQty > 0")

})
public class FocusedModel implements Serializable {

        private static final long serialVersionUID = 1L;

        @Id
        @Column(name = "id", columnDefinition = "int(11)")
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;

        @Column(name = "catalog_id")
        private int catalogId;

        @Column(name = "recommended_qty")
        private int recommendedQty;

        @Column(name = "minimum_qty")
        private int minimumQty;

        @Column(name = "region_id")
        private int regionId;;

        @Column(name = "observable_recommended_qty")
        private int obsRecommendedQty;

        @Column(name = "observable_minimum_qty")
        private int obsMinimumQty;

        @Column(name = "created_timestamp")
        private LocalDateTime createdTimestamp;

        public int getId() {
                return id;
        }

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

        public int getObsRecommendedQty() {
                return obsRecommendedQty;
        }

        public void setObsRecommendedQty(int obsRecommendedQty) {
                this.obsRecommendedQty = obsRecommendedQty;
        }

        public int getObsMinimumQty() {
                return obsMinimumQty;
        }

        public void setObsMinimumQty(int obsMinimumQty) {
                this.obsMinimumQty = obsMinimumQty;
        }

        public int getRegionId() {
                return regionId;
        }

        public void setRegionId(int regionId) {
                this.regionId = regionId;
        }

        public int getCatalogId() {
                return catalogId;
        }

        public LocalDateTime getCreatedTimestamp() {
                return createdTimestamp;
        }

        public void setCreatedTimestamp(LocalDateTime createdTimestamp) {
                this.createdTimestamp = createdTimestamp;
        }

        public void setCatalogId(int catalogId) {
                this.catalogId = catalogId;
        }

        public int getRecommendedQty() {
                return recommendedQty;
        }

        public void setRecommendedQty(int recommendedQty) {
                this.recommendedQty = recommendedQty;
        }

        public int getMinimumQty() {
                return minimumQty;
        }

        public void setMinimumQty(int minimumQty) {
                this.minimumQty = minimumQty;
        }

        public static long getSerialversionuid() {
                return serialVersionUID;
        }

        @Override
        public String toString() {
                return "FocusedModel [id=" + id + ", catalogId=" + catalogId + ", recommendedQty=" + recommendedQty
                                + ", minimumQty=" + minimumQty + ", regionId=" + regionId + ", obsRecommendedQty=" + obsRecommendedQty
                                + ", obsMinimumQty=" + obsMinimumQty + ", createdTimestamp=" + createdTimestamp + "]";
        }

}