Subversion Repositories SmartDukaan

Rev

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

Rev 27124 Rev 30416
Line 8... Line 8...
8
import javax.persistence.EnumType;
8
import javax.persistence.EnumType;
9
import javax.persistence.Enumerated;
9
import javax.persistence.Enumerated;
10
import javax.persistence.GeneratedValue;
10
import javax.persistence.GeneratedValue;
11
import javax.persistence.GenerationType;
11
import javax.persistence.GenerationType;
12
import javax.persistence.Id;
12
import javax.persistence.Id;
-
 
13
import javax.persistence.NamedQueries;
-
 
14
import javax.persistence.NamedQuery;
13
import javax.persistence.Table;
15
import javax.persistence.Table;
14
import javax.persistence.Transient;
16
import javax.persistence.Transient;
15
 
17
 
16
import com.spice.profitmandi.dao.entity.fofo.ActivityType;
18
import com.spice.profitmandi.dao.entity.fofo.ActivityType;
17
 
19
 
Line 19... Line 21...
19
 * @author amit
21
 * @author amit
20
 *
22
 *
21
 */
23
 */
22
@Entity
24
@Entity
23
@Table(name = "cs.ticket", schema = "cs")
25
@Table(name = "cs.ticket", schema = "cs")
-
 
26
 
-
 
27
@NamedQueries({
-
 
28
 
-
 
29
		@NamedQuery(name = "Ticket.selectRecentClosedTicket", query = "select new com.spice.profitmandi.dao.model.TicketViewModel(t.id,tc.name,tbc.name,"
-
 
30
				+ "t.closeTimestamp" + ")"
-
 
31
				+ " 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"),
-
 
32
 
-
 
33
})
24
public class Ticket {
34
public class Ticket {
25
 
35
 
26
	public int getL4AuthUser() {
36
	public int getL4AuthUser() {
27
		return l4AuthUser;
37
		return l4AuthUser;
28
	}
38
	}
Line 80... Line 90...
80
	@Enumerated(EnumType.STRING)
90
	@Enumerated(EnumType.STRING)
81
	private ActivityType lastActivity;
91
	private ActivityType lastActivity;
82
 
92
 
83
	@Column(name = "last_activity_id")
93
	@Column(name = "last_activity_id")
84
	private int lastActivityId;
94
	private int lastActivityId;
85
	
95
 
86
	@Transient
96
	@Transient
87
	private TicketAssigned lastAassignment;
97
	private TicketAssigned lastAassignment;
88
 
98
 
89
	
-
 
90
	public TicketAssigned getLastAassignment() {
99
	public TicketAssigned getLastAassignment() {
91
		return lastAassignment;
100
		return lastAassignment;
92
	}
101
	}
93
 
102
 
94
	public void setLastAassignment(TicketAssigned lastAassignment) {
103
	public void setLastAassignment(TicketAssigned lastAassignment) {