Subversion Repositories SmartDukaan

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

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 = "catalog.customer_offers", schema = "catalog")

@NamedQueries({

		@NamedQuery(name = "CustomerOffer.getOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("

				+ " i.id, cast(sum(coi.schemePayout - coi.dealerPayout) as long))"

				+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"

				+ " join CustomerOffer co on co.id=coi.customerOfferId where "

				+ " :date between co.startDate and co.endDate"

				+ " and i.brand in :brands  group by i.id"), })

public class CustomerOffer {

	@Id

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	@Column(name = "offer_name")

	private String offerName;

	@Column(name = "start_date")

	private LocalDateTime startDate;

	@Column(name = "end_date")

	private LocalDateTime endDate;

	@Column(name = "created_timestamp")

	private LocalDateTime createdTimestamp;

	@Column(name = "updated_timestamp")

	private LocalDateTime updatedTimestamp;

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public String getOfferName() {

		return offerName;

	}

	public void setOfferName(String offerName) {

		this.offerName = offerName;

	}

	public LocalDateTime getStartDate() {

		return startDate;

	}

	public void setStartDate(LocalDateTime startDate) {

		this.startDate = startDate;

	}

	public LocalDateTime getEndDate() {

		return endDate;

	}

	public void setEndDate(LocalDateTime endDate) {

		this.endDate = endDate;

	}

	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 "CustomerOffer [id=" + id + ", offerName=" + offerName + ", startDate=" + startDate + ", endDate="

				+ endDate + ", createdTimestamp=" + createdTimestamp + ", updatedTimestamp=" + updatedTimestamp + "]";

	}

}