Subversion Repositories SmartDukaan

Rev

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

Rev 33665 Rev 33680
Line 8... Line 8...
8 
 
 8 
 
9 
@Entity
 9 
@Entity
10 
@Table(name = "dtr.scratch_offer")
 10 
@Table(name = "dtr.scratch_offer")
11 
@NamedQueries({@NamedQuery(name = "ScratchOffer.selectAllCountOfOffer",
 11 
@NamedQueries({@NamedQuery(name = "ScratchOffer.selectAllCountOfOffer",
12 
		query = "SELECT so.offerName, COUNT(so) FROM ScratchOffer so " +
 12 
		query = "SELECT so.offerName, COUNT(so) FROM ScratchOffer so " +
13 
				"WHERE so.createdTimestamp BETWEEN :startDate AND :endDate " +
 13 
				"WHERE so.scratched=true AND so.createdTimestamp BETWEEN :startDate AND :endDate " +
14 
				"GROUP BY so.offerName")
 14 
				"GROUP BY so.offerName")
15 
})
 15 
})
16 
public class ScratchOffer implements Serializable {
 16 
public class ScratchOffer implements Serializable {
17 
 
 17 
 
18 
	/**
 18 
	/**