Subversion Repositories SmartDukaan

Rev

Rev 30644 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 30644 Rev 31860
Line 11... Line 11...
11 
 * This class basically contains api details
 11 
 * This class basically contains api details
12 
 *
 12 
 *
13 
 * @author ashikali
 13 
 * @author ashikali
14 
 */
 14 
 */
15 
@Entity
 15 
@Entity
16 
@Table(name = "fofo.purchase", schema = "fofo")
 16 
@Table(name = "fofo.purchase")
17 
@NamedQueries({
 17 
@NamedQueries({
18 
		@NamedQuery(name = "Purchase.selectByModelsAndSaleBetween", query = "select p from Purchase p join InventoryItem ii on p.id = ii.purchaseId"
 18 
		@NamedQuery(name = "Purchase.selectByModelsAndSaleBetween", query = "select p from Purchase p join InventoryItem ii on p.id = ii.purchaseId"
19 
				+ " join Item i on i.id=ii.itemId where i.catalogItemId in :catalogItemIds"
 19 
				+ " join Item i on i.id=ii.itemId where i.catalogItemId in :catalogItemIds"
20 
				+ " and p.createTimestamp between :startDate and :endDate")
 20 
				+ " and p.createTimestamp between :startDate and :endDate")
21 
})
 21 
})