Subversion Repositories SmartDukaan

Rev

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

Rev 35614 Rev 35617
Line 15... Line 15...
15 
 
 15 
 
16 
@NamedQueries({
 16 
@NamedQueries({
17 
 
 17 
 
18 
		@NamedQuery(name = "Ticket.selectRecentClosedTicket", query = "select new com.spice.profitmandi.dao.model.TicketViewModel(t.id,tc.name,tbc.name,"
 18 
		@NamedQuery(name = "Ticket.selectRecentClosedTicket", query = "select new com.spice.profitmandi.dao.model.TicketViewModel(t.id,tc.name,tbc.name,"
19 
				+ "t.closeTimestamp" + ")"
 19 
				+ "t.closeTimestamp" + ")"
20 
				+ " from Ticket t  left join  TicketSubCategory tbc on t.subCategoryId  = tbc.id left join TicketCategory tc on tbc.categoryId = tc.id where t.closeTimestamp > :startDate and t.fofoId = :fofoId and t.subCategoryId not in (83, 84)"),
 20 
				+ " from Ticket t  left join  TicketSubCategory tbc on t.subCategoryId  = tbc.id left join TicketCategory tc on tbc.categoryId = tc.id where t.closeTimestamp > :startDate and t.fofoId = :fofoId and tbc.visibility = true"),
21 
 
 21 
 
22 
})
 22 
})
23 
public class Ticket {
 23 
public class Ticket {
24 
 
 24 
 
25 
	public int getL4AuthUser() {
 25 
	public int getL4AuthUser() {