Subversion Repositories SmartDukaan

Rev

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

Rev 30492 Rev 30499
Line 24... Line 24...
24 
 
 24 
 
25 
		@NamedQuery(name = "Item.selectAllBrands", query = "select distinct"
 25 
		@NamedQuery(name = "Item.selectAllBrands", query = "select distinct"
26 
				+ "  i.brand from Item i join TagListing tl on tl.itemId = i.id "
 26 
				+ "  i.brand from Item i join TagListing tl on tl.itemId = i.id "
27 
				+ " where i.categoryId=:categoryId"),
 27 
				+ " where i.categoryId=:categoryId"),
28 
		@NamedQuery(name = "Item.selectAllCategories", query = "select distinct"
 28 
		@NamedQuery(name = "Item.selectAllCategories", query = "select distinct"
29 
				+ "  i.categoryId from Item i join TagListing tl on tl.itemId = i.id ")
 29 
				+ "  i.categoryId from Item i join TagListing tl on tl.itemId = i.id "),
- 
 
 30 
		@NamedQuery(name = "Item.selectAllModels", query = "select "
- 
 
 31 
				+ "  i from Item i join TagListing tl on tl.itemId = i.id where i.brand in :brands and i.categoryId = :categoryId")
30 
})
 32 
})
31 
@Entity
 33 
@Entity
32 
@Table(name = "catalog.item", schema = "catalog")
 34 
@Table(name = "catalog.item", schema = "catalog")
33 
public class Item implements Serializable {
 35 
public class Item implements Serializable {
34 
 
 36