Subversion Repositories SmartDukaan

Rev

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

Rev 35065 Rev 35084
Line 30... Line 30...
30 
						"join Catalog ca on ca.modelNumber = foi.modelNumber " +
 30 
						"join Catalog ca on ca.modelNumber = foi.modelNumber " +
31 
						"where fo.fofoId in :fofoIds " +
 31 
						"where fo.fofoId in :fofoIds " +
32 
						"and foi.brand =:brand " +
 32 
						"and foi.brand =:brand " +
33 
						"and fo.cancelledTimestamp is null " +
 33 
						"and fo.cancelledTimestamp is null " +
34 
						"and foi.createTimestamp >= :startDate " +
 34 
						"and foi.createTimestamp >= :startDate " +
- 
 
 35 
						"and foi.createTimestamp < :endDate " +
- 
 
 36 
						"and ca.categoryId =  10006 " +
35 
						"group by foi.brand, foi.modelName, foi.modelNumber,ca.categoryId"
 37 
						"group by foi.brand, foi.modelName, foi.modelNumber,ca.categoryId, fo.fofoId,DATE_FORMAT(foi.createTimestamp, '%m-%Y')"
36 
		),
 38 
		),
37 
 
 39 
 
38 
})
 40 
})
39 
public class FofoOrderItem implements Serializable {
 41 
public class FofoOrderItem implements Serializable {
40 
 
 42