Subversion Repositories SmartDukaan

Rev

Rev 31860 | Rev 35567 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
24383 amit.gupta 1 
package com.spice.profitmandi.dao.entity.cs;
2 
 
32923 ranu 3 
import com.spice.profitmandi.dao.entity.fofo.ActivityType;
4 
 
5 
import javax.persistence.*;
24383 amit.gupta 6 
import java.time.LocalDateTime;
24417 govind 7 
import java.time.format.DateTimeFormatter;
24383 amit.gupta 8 
 
9 
/**
10 
 * @author amit
11 
 *
12 
 */
13 
@Entity
31860 tejbeer 14 
@Table(name = "cs.ticket")
30416 tejbeer 15 
 
16 
@NamedQueries({
17 
 
18 
		@NamedQuery(name = "Ticket.selectRecentClosedTicket", query = "select new com.spice.profitmandi.dao.model.TicketViewModel(t.id,tc.name,tbc.name,"
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"),
21 
 
22 
})
24383 amit.gupta 23 
public class Ticket {
27124 amit.gupta 24 
 
25 
	public int getL4AuthUser() {
26 
		return l4AuthUser;
27 
	}
28 
 
29 
	public void setL4AuthUser(int l4AuthUser) {
30 
		this.l4AuthUser = l4AuthUser;
31 
	}
32 
 
24383 amit.gupta 33 
	public static final int L2EscalationDays = 5;
34 
	public static final int L3EscalationDays = 10;
35 
	public static final int FinalEscalationDays = 15;
27124 amit.gupta 36 
 
24383 amit.gupta 37 
	@Id
38 
	@Column
27124 amit.gupta 39 
	@GeneratedValue(strategy = GenerationType.IDENTITY)
24383 amit.gupta 40 
	private int id;
27124 amit.gupta 41 
 
42 
	@Column(name = "fofo_id")
24383 amit.gupta 43 
	private int fofoId;
27124 amit.gupta 44 
 
45 
	@Column(name = "subcategory_id")
24383 amit.gupta 46 
	private int subCategoryId;
27124 amit.gupta 47 
 
48 
	@Column(name = "create_timestamp")
24383 amit.gupta 49 
	private LocalDateTime createTimestamp;
27124 amit.gupta 50 
 
51 
	@Column(name = "update_timestamp")
24383 amit.gupta 52 
	private LocalDateTime updateTimestamp;
27124 amit.gupta 53 
 
54 
	@Column(name = "close_timestamp")
24383 amit.gupta 55 
	private LocalDateTime closeTimestamp;
27124 amit.gupta 56 
 
57 
	@Column(name = "l1_auth_user")
24439 govind 58 
	private int l1AuthUser;
27124 amit.gupta 59 
 
60 
	@Column(name = "l2_auth_user")
24439 govind 61 
	private int l2AuthUser;
27124 amit.gupta 62 
 
63 
	@Column(name = "l3_auth_user")
24439 govind 64 
	private int l3AuthUser;
27124 amit.gupta 65 
 
66 
	@Column(name = "l4_auth_user")
67 
	private int l4AuthUser;
68 
 
69 
	@Column(name = "l5_auth_user")
70 
	private int l5AuthUser;
71 
 
72 
	@Column(name = "happy_code")
24383 amit.gupta 73 
	private String happyCode;
74 
 
27124 amit.gupta 75 
	@Column(name = "assignment_id")
76 
	private int assignmentId;
77 
 
78 
	@Column(name = "last_activity")
24383 amit.gupta 79 
	@Enumerated(EnumType.STRING)
80 
	private ActivityType lastActivity;
27124 amit.gupta 81 
 
82 
	@Column(name = "last_activity_id")
83 
	private int lastActivityId;
30416 tejbeer 84 
 
32923 ranu 85 
	@Column(name = "first_activity_id")
86 
	private int firstActivityId;
87 
 
27124 amit.gupta 88 
	@Transient
89 
	private TicketAssigned lastAassignment;
90 
 
91 
	public TicketAssigned getLastAassignment() {
92 
		return lastAassignment;
93 
	}
94 
 
95 
	public void setLastAassignment(TicketAssigned lastAassignment) {
96 
		this.lastAassignment = lastAassignment;
97 
	}
98 
 
99 
	public int getLastActivityId() {
100 
		return lastActivityId;
101 
	}
102 
 
103 
	public void setLastActivityId(int lastActivityId) {
104 
		this.lastActivityId = lastActivityId;
105 
	}
106 
 
32923 ranu 107 
	public int getFirstActivityId() {
108 
		return firstActivityId;
109 
	}
110 
 
111 
	public void setFirstActivityId(int firstActivityId) {
112 
		this.firstActivityId = firstActivityId;
113 
	}
114 
 
27124 amit.gupta 115 
	public int getAssignmentId() {
116 
		return assignmentId;
117 
	}
118 
 
119 
	public void setAssignmentId(int assignmentId) {
120 
		this.assignmentId = assignmentId;
121 
	}
122 
 
123 
	public String getFormattedCreateTimestamp() {
124 
		if (createTimestamp == null) {
24439 govind 125 
			return null;
126 
		}
127 
		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");
128 
		return createTimestamp.format(formatter);
27124 amit.gupta 129 
	}
130 
 
131 
	public String getFormattedCloseTimestamp() {
132 
		if (closeTimestamp == null) {
24439 govind 133 
			return null;
134 
		}
135 
		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");
136 
		return closeTimestamp.format(formatter);
27124 amit.gupta 137 
	}
24383 amit.gupta 138 
 
139 
	public int getId() {
140 
		return id;
141 
	}
142 
 
143 
	public void setId(int id) {
144 
		this.id = id;
145 
	}
146 
 
147 
	public int getFofoId() {
148 
		return fofoId;
149 
	}
150 
 
151 
	public void setFofoId(int fofoId) {
152 
		this.fofoId = fofoId;
153 
	}
27124 amit.gupta 154 
 
24383 amit.gupta 155 
	public int getSubCategoryId() {
156 
		return subCategoryId;
157 
	}
158 
 
159 
	public void setSubCategoryId(int subCategoryId) {
160 
		this.subCategoryId = subCategoryId;
161 
	}
162 
 
163 
	public LocalDateTime getCreateTimestamp() {
164 
		return createTimestamp;
165 
	}
166 
 
167 
	public void setCreateTimestamp(LocalDateTime createTimestamp) {
168 
		this.createTimestamp = createTimestamp;
169 
	}
170 
 
171 
	public LocalDateTime getUpdateTimestamp() {
172 
		return updateTimestamp;
173 
	}
174 
 
175 
	public void setUpdateTimestamp(LocalDateTime updateTimestamp) {
176 
		this.updateTimestamp = updateTimestamp;
177 
	}
178 
 
179 
	public LocalDateTime getCloseTimestamp() {
180 
		return closeTimestamp;
181 
	}
182 
 
183 
	public void setCloseTimestamp(LocalDateTime closeTimestamp) {
184 
		this.closeTimestamp = closeTimestamp;
185 
	}
186 
 
24439 govind 187 
	public int getL1AuthUser() {
188 
		return l1AuthUser;
189 
	}
24383 amit.gupta 190 
 
24439 govind 191 
	public void setL1AuthUser(int l1AuthUser) {
192 
		this.l1AuthUser = l1AuthUser;
193 
	}
194 
 
195 
	public int getL2AuthUser() {
196 
		return l2AuthUser;
197 
	}
198 
 
199 
	public void setL2AuthUser(int l2AuthUser) {
200 
		this.l2AuthUser = l2AuthUser;
201 
	}
202 
 
203 
	public int getL3AuthUser() {
204 
		return l3AuthUser;
205 
	}
206 
 
207 
	public void setL3AuthUser(int l3AuthUser) {
208 
		this.l3AuthUser = l3AuthUser;
209 
	}
210 
 
24383 amit.gupta 211 
	public String getHappyCode() {
212 
		return happyCode;
213 
	}
214 
 
215 
	public void setHappyCode(String happyCode) {
216 
		this.happyCode = happyCode;
217 
	}
218 
 
219 
	public ActivityType getLastActivity() {
220 
		return lastActivity;
221 
	}
222 
 
223 
	public void setLastActivity(ActivityType lastActivity) {
224 
		this.lastActivity = lastActivity;
225 
	}
226 
 
227 
	public static int getL2escalationdays() {
228 
		return L2EscalationDays;
229 
	}
230 
 
231 
	public static int getL3escalationdays() {
232 
		return L3EscalationDays;
233 
	}
234 
 
235 
	public static int getFinalescalationdays() {
236 
		return FinalEscalationDays;
237 
	}
238 
 
27124 amit.gupta 239 
	public int getL5AuthUser() {
240 
		return l5AuthUser;
241 
	}
242 
 
243 
	public void setL5AuthUser(int l5AuthUser) {
244 
		this.l5AuthUser = l5AuthUser;
245 
	}
246 
 
24383 amit.gupta 247 
	@Override
24439 govind 248 
	public int hashCode() {
249 
		final int prime = 31;
250 
		int result = 1;
27124 amit.gupta 251 
		result = prime * result + assignmentId;
24439 govind 252 
		result = prime * result + ((closeTimestamp == null) ? 0 : closeTimestamp.hashCode());
253 
		result = prime * result + ((createTimestamp == null) ? 0 : createTimestamp.hashCode());
254 
		result = prime * result + fofoId;
255 
		result = prime * result + ((happyCode == null) ? 0 : happyCode.hashCode());
256 
		result = prime * result + id;
257 
		result = prime * result + l1AuthUser;
258 
		result = prime * result + l2AuthUser;
259 
		result = prime * result + l3AuthUser;
27124 amit.gupta 260 
		result = prime * result + l4AuthUser;
261 
		result = prime * result + l5AuthUser;
24439 govind 262 
		result = prime * result + ((lastActivity == null) ? 0 : lastActivity.hashCode());
27124 amit.gupta 263 
		result = prime * result + lastActivityId;
32923 ranu 264 
		result = prime * result + firstActivityId;
24439 govind 265 
		result = prime * result + subCategoryId;
266 
		result = prime * result + ((updateTimestamp == null) ? 0 : updateTimestamp.hashCode());
267 
		return result;
268 
	}
269 
 
270 
	@Override
271 
	public boolean equals(Object obj) {
272 
		if (this == obj)
273 
			return true;
274 
		if (obj == null)
275 
			return false;
276 
		if (getClass() != obj.getClass())
277 
			return false;
278 
		Ticket other = (Ticket) obj;
27124 amit.gupta 279 
		if (assignmentId != other.assignmentId)
280 
			return false;
24439 govind 281 
		if (closeTimestamp == null) {
282 
			if (other.closeTimestamp != null)
283 
				return false;
284 
		} else if (!closeTimestamp.equals(other.closeTimestamp))
285 
			return false;
286 
		if (createTimestamp == null) {
287 
			if (other.createTimestamp != null)
288 
				return false;
289 
		} else if (!createTimestamp.equals(other.createTimestamp))
290 
			return false;
291 
		if (fofoId != other.fofoId)
292 
			return false;
293 
		if (happyCode == null) {
294 
			if (other.happyCode != null)
295 
				return false;
296 
		} else if (!happyCode.equals(other.happyCode))
297 
			return false;
298 
		if (id != other.id)
299 
			return false;
300 
		if (l1AuthUser != other.l1AuthUser)
301 
			return false;
302 
		if (l2AuthUser != other.l2AuthUser)
303 
			return false;
304 
		if (l3AuthUser != other.l3AuthUser)
305 
			return false;
27124 amit.gupta 306 
		if (l4AuthUser != other.l4AuthUser)
24439 govind 307 
			return false;
27124 amit.gupta 308 
		if (l5AuthUser != other.l5AuthUser)
309 
			return false;
24439 govind 310 
		if (lastActivity != other.lastActivity)
311 
			return false;
27124 amit.gupta 312 
		if (lastActivityId != other.lastActivityId)
24439 govind 313 
			return false;
32923 ranu 314 
		if (firstActivityId != other.firstActivityId)
315 
			return false;
24439 govind 316 
		if (subCategoryId != other.subCategoryId)
317 
			return false;
318 
		if (updateTimestamp == null) {
319 
			if (other.updateTimestamp != null)
320 
				return false;
321 
		} else if (!updateTimestamp.equals(other.updateTimestamp))
322 
			return false;
323 
		return true;
324 
	}
325 
 
326 
	@Override
24383 amit.gupta 327 
	public String toString() {
32923 ranu 328 
		return "Ticket{" +
329 
				"id=" + id +
330 
				", fofoId=" + fofoId +
331 
				", subCategoryId=" + subCategoryId +
332 
				", createTimestamp=" + createTimestamp +
333 
				", updateTimestamp=" + updateTimestamp +
334 
				", closeTimestamp=" + closeTimestamp +
335 
				", l1AuthUser=" + l1AuthUser +
336 
				", l2AuthUser=" + l2AuthUser +
337 
				", l3AuthUser=" + l3AuthUser +
338 
				", l4AuthUser=" + l4AuthUser +
339 
				", l5AuthUser=" + l5AuthUser +
340 
				", happyCode='" + happyCode + '\'' +
341 
				", assignmentId=" + assignmentId +
342 
				", lastActivity=" + lastActivity +
343 
				", lastActivityId=" + lastActivityId +
344 
				", firstActivityId=" + firstActivityId +
345 
				", lastAassignment=" + lastAassignment +
346 
				'}';
24383 amit.gupta 347 
	}
24439 govind 348 
 
24383 amit.gupta 349 
}