Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.cs;

import com.spice.profitmandi.dao.entity.fofo.ActivityType;

import com.spice.profitmandi.dao.enumuration.cs.EscalationType;

import javax.persistence.*;

import java.time.LocalDateTime;

import java.time.format.DateTimeFormatter;

/**

 * @author amit

 *

 */

@Entity

@Table(name = "cs.ticket")

@NamedQueries({

		@NamedQuery(name = "Ticket.selectRecentClosedTicket", query = "select new com.spice.profitmandi.dao.model.TicketViewModel(t.id,tc.name,tbc.name,"

				+ "t.closeTimestamp" + ")"

				+ " 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"),

})

public class Ticket {

	// Escalation thresholds in WORKING days (excludes weekends)

	public static final int L2_ESCALATION_WORKING_DAYS = 3;   // L1 -> L2 after 3 working days

	public static final int L3_ESCALATION_WORKING_DAYS = 3;   // L2 -> L3 after 3 more working days (6 total)

	public static final int FINAL_ESCALATION_WORKING_DAYS = 2; // L3 -> Final after 2 more working days (8 total)

	// Legacy constants (deprecated - use working days instead)

	@Deprecated

	public static final int L2EscalationDays = 5;

	@Deprecated

	public static final int L3EscalationDays = 10;

	@Deprecated

	public static final int FinalEscalationDays = 15;

	@Id

	@Column

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	@Column(name = "fofo_id")

	private int fofoId;

	@Column(name = "subcategory_id")

	private int subCategoryId;

	@Column(name = "create_timestamp")

	private LocalDateTime createTimestamp;

	@Column(name = "update_timestamp")

	private LocalDateTime updateTimestamp;

	@Column(name = "close_timestamp")

	private LocalDateTime closeTimestamp;

	@Column(name = "current_assignee_id")

	private int currentAssigneeId;

	@Column(name = "current_manager_id")

	private int currentManagerId;

	@Column(name = "current_escalation_level")

	@Enumerated(EnumType.STRING)

	private EscalationType currentEscalationLevel;

	@Column(name = "happy_code")

	private String happyCode;

	@Column(name = "assignment_id")

	private int assignmentId;

	@Column(name = "last_activity")

	@Enumerated(EnumType.STRING)

	private ActivityType lastActivity;

	@Column(name = "last_activity_id")

	private int lastActivityId;

	@Column(name = "first_activity_id")

	private int firstActivityId;

	@Transient

	private TicketAssigned lastAassignment;

	public TicketAssigned getLastAassignment() {

		return lastAassignment;

	}

	public void setLastAassignment(TicketAssigned lastAassignment) {

		this.lastAassignment = lastAassignment;

	}

	public int getLastActivityId() {

		return lastActivityId;

	}

	public void setLastActivityId(int lastActivityId) {

		this.lastActivityId = lastActivityId;

	}

	public int getFirstActivityId() {

		return firstActivityId;

	}

	public void setFirstActivityId(int firstActivityId) {

		this.firstActivityId = firstActivityId;

	}

	public int getAssignmentId() {

		return assignmentId;

	}

	public void setAssignmentId(int assignmentId) {

		this.assignmentId = assignmentId;

	}

	public String getFormattedCreateTimestamp() {

		if (createTimestamp == null) {

			return null;

		}

		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");

		return createTimestamp.format(formatter);

	}

	public String getFormattedCloseTimestamp() {

		if (closeTimestamp == null) {

			return null;

		}

		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");

		return closeTimestamp.format(formatter);

	}

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public int getFofoId() {

		return fofoId;

	}

	public void setFofoId(int fofoId) {

		this.fofoId = fofoId;

	}

	public int getSubCategoryId() {

		return subCategoryId;

	}

	public void setSubCategoryId(int subCategoryId) {

		this.subCategoryId = subCategoryId;

	}

	public LocalDateTime getCreateTimestamp() {

		return createTimestamp;

	}

	public void setCreateTimestamp(LocalDateTime createTimestamp) {

		this.createTimestamp = createTimestamp;

	}

	public LocalDateTime getUpdateTimestamp() {

		return updateTimestamp;

	}

	public void setUpdateTimestamp(LocalDateTime updateTimestamp) {

		this.updateTimestamp = updateTimestamp;

	}

	public LocalDateTime getCloseTimestamp() {

		return closeTimestamp;

	}

	public void setCloseTimestamp(LocalDateTime closeTimestamp) {

		this.closeTimestamp = closeTimestamp;

	}

	public int getCurrentAssigneeId() {

		return currentAssigneeId;

	}

	public void setCurrentAssigneeId(int currentAssigneeId) {

		this.currentAssigneeId = currentAssigneeId;

	}

	public int getCurrentManagerId() {

		return currentManagerId;

	}

	public void setCurrentManagerId(int currentManagerId) {

		this.currentManagerId = currentManagerId;

	}

	public EscalationType getCurrentEscalationLevel() {

		return currentEscalationLevel;

	}

	public void setCurrentEscalationLevel(EscalationType currentEscalationLevel) {

		this.currentEscalationLevel = currentEscalationLevel;

	}

	public String getHappyCode() {

		return happyCode;

	}

	public void setHappyCode(String happyCode) {

		this.happyCode = happyCode;

	}

	public ActivityType getLastActivity() {

		return lastActivity;

	}

	public void setLastActivity(ActivityType lastActivity) {

		this.lastActivity = lastActivity;

	}

	public static int getL2escalationdays() {

		return L2EscalationDays;

	}

	public static int getL3escalationdays() {

		return L3EscalationDays;

	}

	public static int getFinalescalationdays() {

		return FinalEscalationDays;

	}

	@Override

	public int hashCode() {

		final int prime = 31;

		int result = 1;

		result = prime * result + assignmentId;

		result = prime * result + ((closeTimestamp == null) ? 0 : closeTimestamp.hashCode());

		result = prime * result + ((createTimestamp == null) ? 0 : createTimestamp.hashCode());

		result = prime * result + fofoId;

		result = prime * result + ((happyCode == null) ? 0 : happyCode.hashCode());

		result = prime * result + id;

		result = prime * result + currentAssigneeId;

		result = prime * result + currentManagerId;

		result = prime * result + ((currentEscalationLevel == null) ? 0 : currentEscalationLevel.hashCode());

		result = prime * result + ((lastActivity == null) ? 0 : lastActivity.hashCode());

		result = prime * result + lastActivityId;

		result = prime * result + firstActivityId;

		result = prime * result + subCategoryId;

		result = prime * result + ((updateTimestamp == null) ? 0 : updateTimestamp.hashCode());

		return result;

	}

	@Override

	public boolean equals(Object obj) {

		if (this == obj)

			return true;

		if (obj == null)

			return false;

		if (getClass() != obj.getClass())

			return false;

		Ticket other = (Ticket) obj;

		if (assignmentId != other.assignmentId)

			return false;

		if (closeTimestamp == null) {

			if (other.closeTimestamp != null)

				return false;

		} else if (!closeTimestamp.equals(other.closeTimestamp))

			return false;

		if (createTimestamp == null) {

			if (other.createTimestamp != null)

				return false;

		} else if (!createTimestamp.equals(other.createTimestamp))

			return false;

		if (fofoId != other.fofoId)

			return false;

		if (happyCode == null) {

			if (other.happyCode != null)

				return false;

		} else if (!happyCode.equals(other.happyCode))

			return false;

		if (id != other.id)

			return false;

		if (currentAssigneeId != other.currentAssigneeId)

			return false;

		if (currentManagerId != other.currentManagerId)

			return false;

		if (currentEscalationLevel != other.currentEscalationLevel)

			return false;

		if (lastActivity != other.lastActivity)

			return false;

		if (lastActivityId != other.lastActivityId)

			return false;

		if (firstActivityId != other.firstActivityId)

			return false;

		if (subCategoryId != other.subCategoryId)

			return false;

		if (updateTimestamp == null) {

			if (other.updateTimestamp != null)

				return false;

		} else if (!updateTimestamp.equals(other.updateTimestamp))

			return false;

		return true;

	}

	@Override

	public String toString() {

		return "Ticket{" +

				"id=" + id +

				", fofoId=" + fofoId +

				", subCategoryId=" + subCategoryId +

				", createTimestamp=" + createTimestamp +

				", updateTimestamp=" + updateTimestamp +

				", closeTimestamp=" + closeTimestamp +

				", currentAssigneeId=" + currentAssigneeId +

				", currentManagerId=" + currentManagerId +

				", currentEscalationLevel=" + currentEscalationLevel +

				", happyCode='" + happyCode + '\'' +

				", assignmentId=" + assignmentId +

				", lastActivity=" + lastActivity +

				", lastActivityId=" + lastActivityId +

				", firstActivityId=" + firstActivityId +

				", lastAassignment=" + lastAassignment +

				'}';

	}

}