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

	}

}