Subversion Repositories SmartDukaan

Rev

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