| Line 22... |
Line 22... |
| 22 |
@Entity
|
22 |
@Entity
|
| 23 |
@Table(name = "fofo.service_brand", schema = "fofo")
|
23 |
@Table(name = "fofo.service_brand", schema = "fofo")
|
| 24 |
|
24 |
|
| 25 |
@NamedQueries({
|
25 |
@NamedQueries({
|
| 26 |
@NamedQuery(name = "ServiceBrandsConfig.selectFinanceServices", query = "select new com.spice.profitmandi.dao.model.FinanceServicesModel(pbs.fofoId, "
|
26 |
@NamedQuery(name = "ServiceBrandsConfig.selectFinanceServices", query = "select new com.spice.profitmandi.dao.model.FinanceServicesModel(pbs.fofoId, "
|
| - |
|
27 |
+ " pbs.partnerStatusType,pbs.applicableType,pbs.active,pbs.brandServiceId,pbs.na_Comment,pbs.partnerStatusComment,"
|
| 27 |
+ " pbs.partnerStatusType,pbs.applicableType,pbs.active,pbs.brandServiceId,pbs.na_Comment,pbs.partnerStatusComment,sb.serviceId,sb.brand,po.name,ps.code,ps.applicableType,ps.createTimestamp,ps.pendingCreateTimestamp,ps.na_Comment,ps.partnerNotInterestedServiceComment,fs.code,fs.activeTimeStamp,us.createTimestamp) from PartnerBrandService pbs "
|
28 |
+ "sb.serviceId,sb.brand,po.name,ps.code,ps.applicableType,ps.createTimestamp,ps.pendingCreateTimestamp,ps.na_Comment,ps.genComment,ps.partnerNotInterestedServiceComment,fs.code,fs.activeTimeStamp,us.createTimestamp,pob.documentsCompleted) from PartnerBrandService pbs "
|
| 28 |
+ " join ServiceBrandsConfig sb on pbs.brandServiceId = sb.id join PaymentOption po on sb.serviceId = po.id "
|
29 |
+ " join ServiceBrandsConfig sb on pbs.brandServiceId = sb.id join PaymentOption po on sb.serviceId = po.id "
|
| 29 |
+ " join PartnerService ps on ps.serviceId =po.id and pbs.fofoId = ps.fofoId join FofoStore fs on fs.id = pbs.fofoId join userUser us on us.id=fs.id"),
|
30 |
+ " join PartnerService ps on ps.serviceId =po.id and pbs.fofoId = ps.fofoId join FofoStore fs on fs.id = pbs.fofoId join userUser us on us.id=fs.id join PartnerOnBoardingPanel pob on pob.Code=fs.code"),
|
| - |
|
31 |
|
| - |
|
32 |
@NamedQuery(name = "ServiceBrandsConfig.selectFinanceServicesByFofoId", query = "select new com.spice.profitmandi.dao.model.FinanceServicesModel(pbs.fofoId, "
|
| - |
|
33 |
+ " pbs.partnerStatusType,pbs.applicableType,pbs.active,pbs.brandServiceId,pbs.na_Comment,pbs.partnerStatusComment,"
|
| 30 |
})
|
34 |
+ "sb.serviceId,sb.brand,po.name,ps.code,ps.applicableType,ps.createTimestamp,ps.pendingCreateTimestamp,ps.na_Comment,ps.genComment,ps.partnerNotInterestedServiceComment,fs.code,fs.activeTimeStamp,us.createTimestamp,pob.documentsCompleted) from PartnerBrandService pbs "
|
| - |
|
35 |
+ " join ServiceBrandsConfig sb on pbs.brandServiceId = sb.id join PaymentOption po on sb.serviceId = po.id "
|
| - |
|
36 |
+ " join PartnerService ps on ps.serviceId =po.id and pbs.fofoId = ps.fofoId join"
|
| - |
|
37 |
+ " FofoStore fs on fs.id = pbs.fofoId join userUser us on us.id=fs.id join "
|
| - |
|
38 |
+ "PartnerOnBoardingPanel pob on pob.Code=fs.code where fs.id = :fofoId"), })
|
| - |
|
39 |
|
| 31 |
public class ServiceBrandsConfig implements Serializable {
|
40 |
public class ServiceBrandsConfig implements Serializable {
|
| 32 |
|
41 |
|
| 33 |
private static final long serialVersionUID = 1L;
|
42 |
private static final long serialVersionUID = 1L;
|
| 34 |
|
43 |
|
| 35 |
public ServiceBrandsConfig() {
|
44 |
public ServiceBrandsConfig() {
|