Subversion Repositories SmartDukaan

Rev

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

Rev 30121 Rev 30492
Line 19... Line 19...
19 
				+ " where cis.fofoId = :fofoId and cis.availability > 0 and REPLACE(CONCAT(i.brand,' ', ifnull(i.modelName, ' '), ' ', ifnull(i.modelNumber, ' ')), '  ', ' ')  like CONCAT('%',:query,'%')"),
 19 
				+ " where cis.fofoId = :fofoId and cis.availability > 0 and REPLACE(CONCAT(i.brand,' ', ifnull(i.modelName, ' '), ' ', ifnull(i.modelNumber, ' ')), '  ', ' ')  like CONCAT('%',:query,'%')"),
20 
 
 20 
 
21 
		@NamedQuery(name = "Item.selectCatalogIdByMopRange", query = "select i.catalogItemId"
 21 
		@NamedQuery(name = "Item.selectCatalogIdByMopRange", query = "select i.catalogItemId"
22 
				+ " from Item i join TagListing tl on tl.itemId = i.id "
 22 
				+ " from Item i join TagListing tl on tl.itemId = i.id "
23 
				+ " where tl.mop between :startPrice and :endPrice and  i.categoryId=10006 group by i.catalogItemId"),
 23 
				+ " where tl.mop between :startPrice and :endPrice and  i.categoryId=10006 group by i.catalogItemId"),
- 
 
 24 
 
- 
 
 25 
		@NamedQuery(name = "Item.selectAllBrands", query = "select distinct"
- 
 
 26 
				+ "  i.brand from Item i join TagListing tl on tl.itemId = i.id "
- 
 
 27 
				+ " where i.categoryId=:categoryId"),
- 
 
 28 
		@NamedQuery(name = "Item.selectAllCategories", query = "select distinct"
- 
 
 29 
				+ "  i.categoryId from Item i join TagListing tl on tl.itemId = i.id ")
24 
})
 30 
})
25 
@Entity
 31 
@Entity
26 
@Table(name = "catalog.item", schema = "catalog")
 32 
@Table(name = "catalog.item", schema = "catalog")
27 
public class Item implements Serializable {
 33 
public class Item implements Serializable {
28 
 
 34