Subversion Repositories SmartDukaan

Rev

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

Rev 31652 Rev 31657
Line 55... Line 55...
55 
})
 55 
})
56 
 
 56 
 
57 
@NamedNativeQueries({
 57 
@NamedNativeQueries({
58 
 
 58 
 
59 
		@NamedNativeQuery(name = "scheme.getActiveScheme", query = "select si.catalog_id from catalog.scheme s join fofo.scheme_item si on s.id = si.scheme_id "
 59 
		@NamedNativeQuery(name = "scheme.getActiveScheme", query = "select si.catalog_id from catalog.scheme s join fofo.scheme_item si on s.id = si.scheme_id "
60 
				+ " where s.active_timestamp is not null and date(start_date_time) <= :startDate and date(end_date_time) >=  :startDate and type = :type group by  si.catalog_id order by active_timestamp desc "),
 60 
				+ " where s.active_timestamp is not null and start_date_time <= :startDate and end_date_time >= :startDate and type = 'SPECIAL_SUPPORT' order by active_timestamp desc "),
61 
 
 61 
 
62 
		@NamedNativeQuery(name = "scheme.selectMissedActivationSale", query = "select cs.id as scheme_id, ai.serial_number, sr.order_id, ii.id as inventory_item_id, ai.activation_timestamp"
 62 
		@NamedNativeQuery(name = "scheme.selectMissedActivationSale", query = "select cs.id as scheme_id, ai.serial_number, sr.order_id, ii.id as inventory_item_id, ai.activation_timestamp"
63 
				+ " from fofo.activated_imei ai "
 63 
				+ " from fofo.activated_imei ai "
64 
				+ "   join fofo.inventory_item ii on ai.serial_number = ii.serial_number "
 64 
				+ "   join fofo.inventory_item ii on ai.serial_number = ii.serial_number "
65 
				+ "   join catalog.item i on i.id = ii.item_id "
 65 
				+ "   join catalog.item i on i.id = ii.item_id "