| Line 38... |
Line 38... |
| 38 |
@NamedQuery(name = "Retailer.selectCountByNumberAndType",query="select count(r) from Retailer r where r.number= :number and r.type= :type"),
|
38 |
@NamedQuery(name = "Retailer.selectCountByNumberAndType",query="select count(r) from Retailer r where r.number= :number and r.type= :type"),
|
| 39 |
@NamedQuery(name = "Retailer.selectCountByDocumentId", query="select count(r) from Retailer r where r.documentId= :documentId"),
|
39 |
@NamedQuery(name = "Retailer.selectCountByDocumentId", query="select count(r) from Retailer r where r.documentId= :documentId"),
|
| 40 |
@NamedQuery(name = "Retailer.selectCountByName", query = "select count(r) from Retailer r where r.name= :name"),
|
40 |
@NamedQuery(name = "Retailer.selectCountByName", query = "select count(r) from Retailer r where r.name= :name"),
|
| 41 |
@NamedQuery(name = "Retailer.selectCountById", query = "select count(r) from Retailer r where r.id= :id"),
|
41 |
@NamedQuery(name = "Retailer.selectCountById", query = "select count(r) from Retailer r where r.id= :id"),
|
| 42 |
@NamedQuery(name = "Retailer.deleteById",query="delete from Retailer r where r.id= :id"),
|
42 |
@NamedQuery(name = "Retailer.deleteById",query="delete from Retailer r where r.id= :id"),
|
| 43 |
@NamedQuery(name = "Retailer.selectDocumentById", query = "select d from Retailer r join Document d on d.id = r.documentId where r.id = :id"),
|
43 |
@NamedQuery(name = "Retailer.selectDocumentById", query = "select d from Retailer r join Document d on d.id = r.documentId where r.id = :id")
|
| 44 |
@NamedQuery(
|
- |
|
| 45 |
name = "Retailer.selectFofoIdAndEmailIdByEmailId",
|
- |
|
| 46 |
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'")
|
- |
|
| 47 |
})
|
44 |
})
|
| 48 |
public class Retailer implements Serializable{
|
45 |
public class Retailer implements Serializable{
|
| 49 |
|
46 |
|
| 50 |
private static final long serialVersionUID = 1L;
|
47 |
private static final long serialVersionUID = 1L;
|
| 51 |
|
48 |
|