Subversion Repositories SmartDukaan

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

import java.io.Serializable;
import java.time.LocalDateTime;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedNativeQueries;
import javax.persistence.NamedNativeQuery;
import javax.persistence.Table;

@Entity
@Table(name = "fofo.hygiene_data")
@NamedNativeQueries({

        @NamedNativeQuery(name = "HygieneData.selectHygieneByMobile", query = "select hd.order_id from fofo.hygiene_data hd " + "join fofo.fofo_order fo on  hd.order_id = fo.id join fofo.customer_address ca on ca.id = fo.customer_address_id " + "where (disposed_timestamp is null or date(disposed_timestamp) = :todayDate ) and ca.phone_number = :phoneNumber"),

})
public class HygieneData implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @Column(name = "order_id")
    private int orderId;

    @Column(name = "fofo_id ")
    private int fofoId;

    public int getFofoId() {
        return fofoId;
    }

    public void setFofoId(int fofoId) {
        this.fofoId = fofoId;
    }

    @Column(name = "status")
    private String status;

    @Column(name = "remark")
    private String remark;

    @Column(name = "DOP")
    private LocalDateTime DOP;

    @Column(name = "rating")
    private int rating;

    @Column(name = "feedback")
    private String feedback;

    @Column(name = "call_count")
    private int callCount;


    @Column(name = "created_timestamp")
    private LocalDateTime createdTimestamp;

    @Column(name = "disposed_timestamp")
    private LocalDateTime disposedTimestamp;

    @Column(name = "next_timestamp")
    private LocalDateTime nextTimestamp;

    @Column(name = "ques_phone")
    private String quesPhone;

    @Column(name = "ques_Information")
    private String quesInformation;

    @Column(name = "ques_invoice")
    private String quesInvoice;

    @Column(name = "hygiene_rating")
    private boolean hygieneRating;

    public boolean getHygieneRating() {
        return hygieneRating;
    }

    public void setHygieneRating(boolean hygieneRating) {
        this.hygieneRating = hygieneRating;
    }

    public int getOrderId() {
        return orderId;
    }

    public void setOrderId(int orderId) {
        this.orderId = orderId;
    }

    public String getQuesPhone() {
        return quesPhone;
    }

    public void setQuesPhone(String quesPhone) {
        this.quesPhone = quesPhone;
    }

    public String getQuesInformation() {
        return quesInformation;
    }

    public void setQuesInformation(String quesInformation) {
        this.quesInformation = quesInformation;
    }

    public String getQuesInvoice() {
        return quesInvoice;
    }

    public void setQuesInvoice(String quesInvoice) {
        this.quesInvoice = quesInvoice;
    }

    public static long getSerialversionuid() {
        return serialVersionUID;
    }

    public String getStatus() {
        return status;
    }

    public void setStatus(String status) {
        this.status = status;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }

    public LocalDateTime getDOP() {
        return DOP;
    }

    public void setDOP(LocalDateTime dOP) {
        DOP = dOP;
    }

    public int getRating() {
        return rating;
    }

    public void setRating(int rating) {
        this.rating = rating;
    }

    public LocalDateTime getDisposedTimestamp() {
        return disposedTimestamp;
    }

    public void setDisposedTimestamp(LocalDateTime disposedTimestamp) {
        this.disposedTimestamp = disposedTimestamp;
    }

    public LocalDateTime getNextTimestamp() {
        return nextTimestamp;
    }

    public void setNextTimestamp(LocalDateTime nextTimestamp) {
        this.nextTimestamp = nextTimestamp;
    }

    public String getFeedback() {
        return feedback;
    }

    public void setFeedback(String feedback) {
        this.feedback = feedback;
    }

    public LocalDateTime getCreatedTimestamp() {
        return createdTimestamp;
    }

    public void setCreatedTimestamp(LocalDateTime createdTimestamp) {
        this.createdTimestamp = createdTimestamp;
    }


    public int getCallCount() {
        return callCount;
    }

    public void setCallCount(int callCount) {
        this.callCount = callCount;
    }

    @Override
    public String toString() {
        return "HygieneData [orderId=" + orderId + ", fofoId=" + fofoId + ", status=" + status + ", remark=" + remark + ", DOP=" + DOP + ", rating=" + rating + ", feedback=" + feedback + ", callCount=" + callCount + ", createdTimestamp=" + createdTimestamp + ", disposedTimestamp=" + disposedTimestamp + ", nextTimestamp=" + nextTimestamp + ", quesPhone=" + quesPhone + ", quesInformation=" + quesInformation + ", quesInvoice=" + quesInvoice + ", hygieneRating=" + hygieneRating + "]";
    }

}