Subversion Repositories SmartDukaan

Rev

Rev 22216 | Rev 22735 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 22216 Rev 22532
Line 39... Line 39...
39
	@NamedQuery(name = "Retailer.selectCountById", query = "select count(r) from Retailer r where r.id= :id"),
39
	@NamedQuery(name = "Retailer.selectCountById", query = "select count(r) from Retailer r where r.id= :id"),
40
	@NamedQuery(name = "Retailer.deleteById",query="delete from Retailer r where r.id= :id"),
40
	@NamedQuery(name = "Retailer.deleteById",query="delete from Retailer r where r.id= :id"),
41
	@NamedQuery(name = "Retailer.selectDocumentById", query = "select d from Retailer r join Document d on d.id = r.documentId where r.id = :id"),
41
	@NamedQuery(name = "Retailer.selectDocumentById", query = "select d from Retailer r join Document d on d.id = r.documentId where r.id = :id"),
42
	@NamedQuery(
42
	@NamedQuery(
43
			name = "Retailer.selectFofoIdAndEmailIdByEmailId",
43
			name = "Retailer.selectFofoIdAndEmailIdByEmailId",
44
			query = "select r.id, u.emailId from User u join UserAccounts ua on ua.user_id = u.id join Retailer r on r.id = ua.account_key where u.emailId = :emailId and ua.account_type = 'saholic' and r.fofo = true")
44
			query = "select r.id, u.emailId from User u join UserAccounts ua on ua.user_id = u.id join Retailer r on r.id = ua.account_key join UserRole ur on ur.userId = u.id where u.emailId = :emailId and ua.account_type = 'saholic' and ur.roleType = 'FOFO'")
45
})
45
})
46
public class Retailer implements Serializable{
46
public class Retailer implements Serializable{
47
	
47
	
48
	private static final long serialVersionUID = 1L;
48
	private static final long serialVersionUID = 1L;
49
	
49
	
Line 107... Line 107...
107
	private int documentId;
107
	private int documentId;
108
		
108
		
109
	@Column(name = "current_address_id")
109
	@Column(name = "current_address_id")
110
	private int currentAddressId;
110
	private int currentAddressId;
111
	
111
	
112
	@Column(name = "fofo", columnDefinition = "tinyint(1) default 0")
-
 
113
	private boolean fofo;
-
 
114
	
-
 
115
	public int getId() {
112
	public int getId() {
116
		return id;
113
		return id;
117
	}
114
	}
118
	public void setId(int id) {
115
	public void setId(int id) {
119
		this.id = id;
116
		this.id = id;
Line 229... Line 226...
229
	}
226
	}
230
    public LocalDateTime getUpdateTimestamp() {
227
    public LocalDateTime getUpdateTimestamp() {
231
		return updateTimestamp;
228
		return updateTimestamp;
232
	}
229
	}
233
    
230
    
234
    public boolean isFofo() {
-
 
235
		return fofo;
-
 
236
	}
-
 
237
    public void setFofo(boolean fofo) {
-
 
238
		this.fofo = fofo;
-
 
239
	}
-
 
240
    
-
 
241
    
-
 
242
	
231
	
243
	@Override
232
	@Override
244
	public int hashCode() {
233
	public int hashCode() {
245
		final int prime = 31;
234
		final int prime = 31;
246
		int result = 1;
235
		int result = 1;
Line 265... Line 254...
265
		return "Retailer [id=" + id + ", name=" + name + ", number=" + number + ", type=" + type + ", monthlySaleValue="
254
		return "Retailer [id=" + id + ", name=" + name + ", number=" + number + ", type=" + type + ", monthlySaleValue="
266
				+ monthlySaleValue + ", smartphoneSaleValue=" + smartphoneSaleValue + ", recharge=" + recharge
255
				+ monthlySaleValue + ", smartphoneSaleValue=" + smartphoneSaleValue + ", recharge=" + recharge
267
				+ ", mobile=" + mobile + ", accessories=" + accessories + ", other1=" + other1 + ", other2=" + other2
256
				+ ", mobile=" + mobile + ", accessories=" + accessories + ", other1=" + other1 + ", other2=" + other2
268
				+ ", selfPickup=" + selfPickup + ", active=" + active + ", migrated=" + migrated + ", createTimestamp="
257
				+ ", selfPickup=" + selfPickup + ", active=" + active + ", migrated=" + migrated + ", createTimestamp="
269
				+ createTimestamp + ", updateTimestamp=" + updateTimestamp + ", documentId="
258
				+ createTimestamp + ", updateTimestamp=" + updateTimestamp + ", documentId="
270
				+ documentId + ", currentAddressId=" + currentAddressId + ", fofo=" + fofo + "]";
259
				+ documentId + ", currentAddressId=" + currentAddressId + "]";
271
	}
260
	}
272
	   
261
	   
273
    
262
    
274
        
263
        
275
}
264
}
276
265