Subversion Repositories SmartDukaan

/**

 * 

 */

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

import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;

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

import javax.persistence.*;

import java.time.LocalDateTime;

import java.time.format.DateTimeFormatter;

/**

 * @author govind

 *

 */

@Entity

@Table(name = "cs.position")

@NamedQueries({

        @NamedQuery(name = "Position.Auth_User_Partner_Maping", query = "select new com.spice.profitmandi.dao.model.AuthUserPartnerMapModel( "

                + "  p.authUserId, pp.fofoId )  from Position p" +

                " JOIN PartnerPosition pp ON pp.positionId = p.id" +

                "                  JOIN Region r ON pp.regionId = r.id" +

                "                  JOIN PartnerRegion pr ON pr.regionId = pp.regionId" +

                "                  JOIN FofoStore fs ON fs.id = pp.fofoId" +

                "         where p.authUserId = :authId and fs.active= true and p.categoryId = :categoryId")

})

public class Position {

    @Id

    @Column(name = "id", unique = true, updatable = false)

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private int id;

    @Column(name = "auth_user_id")

    private int authUserId;

    @Column(name = "category_id")

    private int categoryId;

    @Column(name = "region_id")

    private int regionId;

    @Column(name = "escalation_type")

    @Enumerated(EnumType.STRING)

    private EscalationType escalationType;

    @Convert(converter = LocalDateTimeAttributeConverter.class)

    @Column(name = "create_timestamp")

    private LocalDateTime createTimestamp;

    @Column(name = "ticket_assignee")

    private boolean ticketAssignee;

    public boolean isTicketAssignee() {

        return ticketAssignee;

    }

    public void setTicketAssignee(boolean ticketAssignee) {

        this.ticketAssignee = ticketAssignee;

    }

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public int getAuthUserId() {

        return authUserId;

    }

    public void setAuthUserId(int authUserId) {

        this.authUserId = authUserId;

    }

    public int getCategoryId() {

        return categoryId;

    }

    public void setCategoryId(int categoryId) {

        this.categoryId = categoryId;

    }

    public EscalationType getEscalationType() {

        return escalationType;

    }

    public void setEscalationType(EscalationType escalationType) {

        this.escalationType = escalationType;

    }

    public int getRegionId() {

        return regionId;

    }

    public void setRegionId(int regionId) {

        this.regionId = regionId;

    }

    public LocalDateTime getCreateTimestamp() {

        return createTimestamp;

    }

    public void setCreateTimestamp(LocalDateTime createTimestamp) {

        this.createTimestamp = createTimestamp;

    }

    public String getFormattedCreateTimestamp() {

        if (createTimestamp == null) {

            return null;

        }

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

        return createTimestamp.format(formatter);

    }

    @Override

    public int hashCode() {

        final int prime = 31;

        int result = 1;

        result = prime * result + authUserId;

        result = prime * result + categoryId;

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

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

        result = prime * result + id;

        result = prime * result + regionId;

        result = prime * result + (ticketAssignee ? 1231 : 1237);

        return result;

    }

    @Override

    public boolean equals(Object obj) {

        if (this == obj) return true;

        if (obj == null) return false;

        if (getClass() != obj.getClass()) return false;

        Position other = (Position) obj;

        if (authUserId != other.authUserId) return false;

        if (categoryId != other.categoryId) return false;

        if (createTimestamp == null) {

            if (other.createTimestamp != null) return false;

        } else if (!createTimestamp.equals(other.createTimestamp)) return false;

        if (escalationType != other.escalationType) return false;

        if (id != other.id) return false;

        if (regionId != other.regionId) return false;

        if (ticketAssignee != other.ticketAssignee) return false;

        return true;

    }

    @Override

    public String toString() {

        return "Position [id=" + id + ", authUserId=" + authUserId + ", categoryId=" + categoryId + ", regionId=" + regionId + ", escalationType=" + escalationType + ", createTimestamp=" + createTimestamp + ", ticketAssignee=" + ticketAssignee + "]";

    }

}