Subversion Repositories SmartDukaan

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

import java.time.LocalDateTime;

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

@Entity
@Table(name = "dtr.brands_limit")

@NamedQueries({
                @NamedQuery(name = "BrandLimit.selectAllPartnerBrandLimit", query = "select new com.spice.profitmandi.dao.model.PartnerBrandLimit(fs.id,bl.brandName,"
                                + " case when rbl.partnerId is null then bl.stockLimit else rbl.minStockLimit end) "
                                + " from FofoStore fs join BrandLimit bl on 1=1"
                                + " left join RetailerBrandsLimit rbl on (rbl.brandName = bl.brandName and rbl.partnerId = fs.id)"), })
public class BrandLimit {

        @Id
        @Column(name = "id", unique = false, updatable = false)
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;

        @Column(name = "brand_name")
        private String brandName;
        @Column(name = "brand_limit")
        private float brandLimit;
        @Column(name = "created_time_stamp")
        private LocalDateTime createdTimestamp;

        @Column(name = "stock_limit")
        private float stockLimit;

        @Column(name = "updated_time_stamp")
        private LocalDateTime updatedTimestamp;

        public int getId() {
                return id;
        }

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

        public float getStockLimit() {
                return stockLimit;
        }

        public void setStockLimit(float stockLimit) {
                this.stockLimit = stockLimit;
        }

        public String getBrandName() {
                return brandName;
        }

        public void setBrandName(String brandName) {
                this.brandName = brandName;
        }

        public float getBrandLimit() {
                return brandLimit;
        }

        public void setBrandLimit(float brandLimit) {
                this.brandLimit = brandLimit;
        }

        public LocalDateTime getCreatedTimestamp() {
                return createdTimestamp;
        }

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

        public LocalDateTime getUpdatedTimestamp() {
                return updatedTimestamp;
        }

        public void setUpdatedTimestamp(LocalDateTime updatedTimestamp) {
                this.updatedTimestamp = updatedTimestamp;
        }

        @Override
        public String toString() {
                return "BrandLimit [id=" + id + ", brandName=" + brandName + ", brandLimit=" + brandLimit
                                + ", createdTimestamp=" + createdTimestamp + ", stockLimit=" + stockLimit + ", updatedTimestamp="
                                + updatedTimestamp + "]";
        }

        public BrandLimit() {
                super();
                // TODO Auto-generated constructor stub
        }

}