Subversion Repositories SmartDukaan

Rev

Rev 31860 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 31860 Rev 32066
Line 1... Line 1...
1 
package com.spice.profitmandi.dao.entity.fofo;
 1 
package com.spice.profitmandi.dao.entity.fofo;
2 
 
 2 
 
3 
import java.io.Serializable;
 3 
import java.io.Serializable;
4 
import java.time.LocalDate;
 - 
 
5 
import java.time.LocalDateTime;
 4 
import java.time.LocalDateTime;
6 
 
 5 
 
7 
import javax.persistence.Column;
 6 
import javax.persistence.Column;
8 
import javax.persistence.Convert;
 - 
 
9 
import javax.persistence.Entity;
 7 
import javax.persistence.Entity;
10 
import javax.persistence.Id;
 8 
import javax.persistence.Id;
- 
 
 9 
import javax.persistence.NamedNativeQueries;
- 
 
 10 
import javax.persistence.NamedNativeQuery;
11 
import javax.persistence.Table;
 11 
import javax.persistence.Table;
12 
 
 12 
 
13 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
 - 
 
14 
 
 - 
 
15 
@Entity
 13 
@Entity
16 
@Table(name = "fofo.hygiene_data")
 14 
@Table(name = "fofo.hygiene_data")
- 
 
 15 
@NamedNativeQueries({
- 
 
 16 
 
- 
 
 17 
        @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"),
- 
 
 18 
 
- 
 
 19 
})
17 
public class HygieneData implements Serializable {
 20 
public class HygieneData implements Serializable {
18 
 
 21 
 
19 
	private static final long serialVersionUID = 1L;
 22 
    private static final long serialVersionUID = 1L;
- 
 
 23 
 
- 
 
 24 
    @Id
- 
 
 25 
    @Column(name = "order_id")
- 
 
 26 
    private int orderId;
- 
 
 27 
 
- 
 
 28 
    @Column(name = "fofo_id ")
- 
 
 29 
    private int fofoId;
- 
 
 30 
 
- 
 
 31 
    public int getFofoId() {
- 
 
 32 
        return fofoId;
- 
 
 33 
    }
- 
 
 34 
 
- 
 
 35 
    public void setFofoId(int fofoId) {
- 
 
 36 
        this.fofoId = fofoId;
- 
 
 37 
    }
- 
 
 38 
 
- 
 
 39 
    @Column(name = "status")
- 
 
 40 
    private String status;
20 
 
 41 
 
21 
	@Id
 - 
 
22 
	@Column(name = "order_id")
 42 
    @Column(name = "remark")
23 
	private int orderId;
 43 
    private String remark;
24 
 
 44 
 
25 
	@Column(name = "fofo_id ")
 45 
    @Column(name = "DOP")
26 
	private int fofoId;
 46 
    private LocalDateTime DOP;
27 
 
 47 
 
28 
	public int getFofoId() {
 48 
    @Column(name = "rating")
29 
		return fofoId;
 49 
    private int rating;
30 
	}
 - 
 
31 
 
 50 
 
32 
	public void setFofoId(int fofoId) {
 51 
    @Column(name = "feedback")
33 
		this.fofoId = fofoId;
 52 
    private String feedback;
34 
	}
 - 
 
35 
 
 53 
 
36 
	@Column(name = "status")
 54 
    @Column(name = "call_count")
37 
	private String status;
 55 
    private int callCount;
38 
 
 56 
 
39 
	@Column(name = "remark")
 - 
 
40 
	private String remark;
 - 
 
41 
 
 57 
 
42 
	@Column(name = "DOP")
 58 
    @Column(name = "created_timestamp")
43 
	private LocalDateTime DOP;
 59 
    private LocalDateTime createdTimestamp;
44 
 
 60 
 
45 
	@Column(name = "rating")
 61 
    @Column(name = "disposed_timestamp")
46 
	private int rating;
 62 
    private LocalDateTime disposedTimestamp;
47 
 
 63 
 
48 
	@Column(name = "feedback")
 64 
    @Column(name = "next_timestamp")
49 
	private String feedback;
 65 
    private LocalDateTime nextTimestamp;
50 
 
 66 
 
51 
	@Column(name = "created_timestamp")
 67 
    @Column(name = "ques_phone")
52 
	private LocalDateTime createdTimestamp;
 68 
    private String quesPhone;
53 
 
 69 
 
54 
	@Column(name = "disposed_timestamp")
 70 
    @Column(name = "ques_Information")
55 
	private LocalDateTime disposedTimestamp;
 71 
    private String quesInformation;
56 
 
 72 
 
57 
	@Column(name = "next_timestamp")
 73 
    @Column(name = "ques_invoice")
58 
	private LocalDateTime nextTimestamp;
 74 
    private String quesInvoice;
59 
 
 75 
 
60 
	@Column(name = "ques_phone")
 76 
    @Column(name = "hygiene_rating")
61 
	private String quesPhone;
 77 
    private boolean hygieneRating;
62 
 
 78 
 
63 
	@Column(name = "ques_Information")
 79 
    public boolean getHygieneRating() {
64 
	private String quesInformation;
 80 
        return hygieneRating;
- 
 
 81 
    }
65 
 
 82 
 
66 
	@Column(name = "ques_invoice")
 83 
    public void setHygieneRating(boolean hygieneRating) {
67 
	private String quesInvoice;
 84 
        this.hygieneRating = hygieneRating;
- 
 
 85 
    }
68 
 
 86 
 
69 
	@Column(name = "hygiene_rating")
 87 
    public int getOrderId() {
70 
	private boolean hygieneRating;
 88 
        return orderId;
- 
 
 89 
    }
71 
 
 90 
 
72 
	public boolean getHygieneRating() {
 91 
    public void setOrderId(int orderId) {
73 
		return hygieneRating;
 92 
        this.orderId = orderId;
74 
	}
 93 
    }
75 
 
 94 
 
76 
	public void setHygieneRating(boolean hygieneRating) {
 95 
    public String getQuesPhone() {
77 
		this.hygieneRating = hygieneRating;
 96 
        return quesPhone;
78 
	}
 97 
    }
79 
 
 98 
 
80 
	public int getOrderId() {
 99 
    public void setQuesPhone(String quesPhone) {
81 
		return orderId;
 100 
        this.quesPhone = quesPhone;
82 
	}
 101 
    }
83 
 
 102 
 
84 
	public void setOrderId(int orderId) {
 103 
    public String getQuesInformation() {
85 
		this.orderId = orderId;
 104 
        return quesInformation;
86 
	}
 105 
    }
87 
 
 106 
 
88 
	public String getQuesPhone() {
 107 
    public void setQuesInformation(String quesInformation) {
89 
		return quesPhone;
 108 
        this.quesInformation = quesInformation;
90 
	}
 109 
    }
91 
 
 110 
 
92 
	public void setQuesPhone(String quesPhone) {
 111 
    public String getQuesInvoice() {
93 
		this.quesPhone = quesPhone;
 112 
        return quesInvoice;
94 
	}
 113 
    }
95 
 
 114 
 
96 
	public String getQuesInformation() {
 115 
    public void setQuesInvoice(String quesInvoice) {
97 
		return quesInformation;
 116 
        this.quesInvoice = quesInvoice;
98 
	}
 117 
    }
99 
 
 118 
 
100 
	public void setQuesInformation(String quesInformation) {
 119 
    public static long getSerialversionuid() {
101 
		this.quesInformation = quesInformation;
 120 
        return serialVersionUID;
102 
	}
 121 
    }
103 
 
 122 
 
104 
	public String getQuesInvoice() {
 123 
    public String getStatus() {
105 
		return quesInvoice;
 124 
        return status;
106 
	}
 125 
    }
107 
 
 126 
 
108 
	public void setQuesInvoice(String quesInvoice) {
 127 
    public void setStatus(String status) {
109 
		this.quesInvoice = quesInvoice;
 128 
        this.status = status;
110 
	}
 129 
    }
111 
 
 130 
 
112 
	public static long getSerialversionuid() {
 131 
    public String getRemark() {
113 
		return serialVersionUID;
 132 
        return remark;
114 
	}
 133 
    }
115 
 
 134 
 
116 
	public String getStatus() {
 135 
    public void setRemark(String remark) {
117 
		return status;
 136 
        this.remark = remark;
118 
	}
 137 
    }
119 
 
 138 
 
120 
	public void setStatus(String status) {
 139 
    public LocalDateTime getDOP() {
121 
		this.status = status;
 140 
        return DOP;
122 
	}
 141 
    }
123 
 
 142 
 
124 
	public String getRemark() {
 143 
    public void setDOP(LocalDateTime dOP) {
125 
		return remark;
 144 
        DOP = dOP;
126 
	}
 145 
    }
127 
 
 146 
 
128 
	public void setRemark(String remark) {
 147 
    public int getRating() {
129 
		this.remark = remark;
 148 
        return rating;
130 
	}
 149 
    }
131 
 
 150 
 
132 
	public LocalDateTime getDOP() {
 151 
    public void setRating(int rating) {
133 
		return DOP;
 152 
        this.rating = rating;
134 
	}
 153 
    }
135 
 
 154 
 
136 
	public void setDOP(LocalDateTime dOP) {
 155 
    public LocalDateTime getDisposedTimestamp() {
137 
		DOP = dOP;
 156 
        return disposedTimestamp;
138 
	}
 157 
    }
139 
 
 158 
 
140 
	public int getRating() {
 159 
    public void setDisposedTimestamp(LocalDateTime disposedTimestamp) {
141 
		return rating;
 160 
        this.disposedTimestamp = disposedTimestamp;
142 
	}
 161 
    }
143 
 
 162 
 
144 
	public void setRating(int rating) {
 163 
    public LocalDateTime getNextTimestamp() {
145 
		this.rating = rating;
 164 
        return nextTimestamp;
146 
	}
 165 
    }
147 
 
 166 
 
148 
	public LocalDateTime getDisposedTimestamp() {
 167 
    public void setNextTimestamp(LocalDateTime nextTimestamp) {
149 
		return disposedTimestamp;
 168 
        this.nextTimestamp = nextTimestamp;
150 
	}
 169 
    }
151 
 
 170 
 
152 
	public void setDisposedTimestamp(LocalDateTime disposedTimestamp) {
 171 
    public String getFeedback() {
153 
		this.disposedTimestamp = disposedTimestamp;
 172 
        return feedback;
154 
	}
 173 
    }
155 
 
 174 
 
156 
	public LocalDateTime getNextTimestamp() {
 175 
    public void setFeedback(String feedback) {
157 
		return nextTimestamp;
 176 
        this.feedback = feedback;
158 
	}
 177 
    }
159 
 
 178 
 
160 
	public void setNextTimestamp(LocalDateTime nextTimestamp) {
 179 
    public LocalDateTime getCreatedTimestamp() {
161 
		this.nextTimestamp = nextTimestamp;
 180 
        return createdTimestamp;
162 
	}
 181 
    }
163 
 
 182 
 
164 
	public String getFeedback() {
 183 
    public void setCreatedTimestamp(LocalDateTime createdTimestamp) {
165 
		return feedback;
 184 
        this.createdTimestamp = createdTimestamp;
166 
	}
 185 
    }
167 
 
 186 
 
168 
	public void setFeedback(String feedback) {
 - 
 
169 
		this.feedback = feedback;
 - 
 
170 
	}
 - 
 
171 
 
 187 
 
172 
	public LocalDateTime getCreatedTimestamp() {
 188 
    public int getCallCount() {
173 
		return createdTimestamp;
 189 
        return callCount;
174 
	}
 190 
    }
175 
 
 191 
 
176 
	public void setCreatedTimestamp(LocalDateTime createdTimestamp) {
 192 
    public void setCallCount(int callCount) {
177 
		this.createdTimestamp = createdTimestamp;
 193 
        this.callCount = callCount;
178 
	}
 194 
    }
179 
 
 195 
 
180 
	@Override
 196 
    @Override
181 
	public String toString() {
 197 
    public String toString() {
182 
		return "HygieneData [orderId=" + orderId + ", fofoId=" + fofoId + ", status=" + status + ", remark=" + remark
 198 
        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 + "]";
183 
				+ ", DOP=" + DOP + ", rating=" + rating + ", feedback=" + feedback + ", createdTimestamp="
 - 
 
184 
				+ createdTimestamp + ", disposedTimestamp=" + disposedTimestamp + ", nextTimestamp=" + nextTimestamp
 - 
 
185 
				+ ", quesPhone=" + quesPhone + ", quesInformation=" + quesInformation + ", quesInvoice=" + quesInvoice
 - 
 
186 
				+ ", hygieneRating=" + hygieneRating + "]";
 - 
 
187 
	}
 199 
    }
188 
 
 200 
 
189 
}
 201 
}