Subversion Repositories SmartDukaan

Rev

Rev 31199 | Rev 33872 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 31199 Rev 31860
Line 2... Line 2...
2 
 
 2 
 
3 
import javax.persistence.*;
 3 
import javax.persistence.*;
4 
import java.time.LocalDateTime;
 4 
import java.time.LocalDateTime;
5 
 
 5 
 
6 
@Entity
 6 
@Entity
7 
@Table(name = "catalog.customer_offers", schema = "catalog")
 7 
@Table(name = "catalog.customer_offers")
8 
 
 8 
 
9 
@NamedQueries({
 9 
@NamedQueries({
10 
		@NamedQuery(name = "CustomerOffer.getOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
 10 
		@NamedQuery(name = "CustomerOffer.getOfferItemsByBrand", query = "select new com.spice.profitmandi.service.pricecircular.PriceCircularItemModel("
11 
				+ " i.id, i.catalogItemId, cast(sum(coi.schemePayout - coi.dealerPayout) as long))"
 11 
				+ " i.id, i.catalogItemId, cast(sum(coi.schemePayout - coi.dealerPayout) as long))"
12 
				+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"
 12 
				+ " from CustomerOfferItem coi join Item i on coi.catalogId = i.catalogItemId"