| Line 32... |
Line 32... |
| 32 |
@NamedQuery(name = "ServiceBrandsConfig.selectFinanceServicesByFofoId", query = "select new com.spice.profitmandi.dao.model.FinanceServicesModel(pbs.fofoId, "
|
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,"
|
33 |
+ " pbs.partnerStatusType,pbs.applicableType,pbs.active,pbs.brandServiceId,pbs.na_Comment,pbs.partnerStatusComment,"
|
| 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,psc.allFollowupDate) from PartnerBrandService pbs "
|
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,psc.allFollowupDate) from PartnerBrandService pbs "
|
| 35 |
+ " join ServiceBrandsConfig sb on pbs.brandServiceId = sb.id join PaymentOption po on sb.serviceId = po.id "
|
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"
|
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 "
|
37 |
+ " FofoStore fs on fs.id = pbs.fofoId join userUser us on us.id=fs.id left join "
|
| 38 |
+ " PartnerOnBoardingPanel pob on pob.Code=fs.code left join PartnerServiceComment psc on psc.id=ps.partnerServiceCommentId where ps.fofoId = :fofoId"),
|
38 |
+ " PartnerOnBoardingPanel pob on pob.Code=fs.code left join PartnerServiceComment psc on psc.id=ps.partnerServiceCommentId where ps.fofoId = :fofoId"),
|
| 39 |
|
39 |
|
| 40 |
@NamedQuery(name = "ServiceBrandsConfig.selectFinanceServiceByFollowUpDate", query = "select new com.spice.profitmandi.dao.model.FinanceServiceFollowUpDateModel(ps.serviceId, "
|
40 |
@NamedQuery(name = "ServiceBrandsConfig.selectFinanceServiceByFollowUpDate", query = "select new com.spice.profitmandi.dao.model.FinanceServiceFollowUpDateModel(ps.serviceId, "
|
| 41 |
+ " ps.fofoId,ps.genComment,ps.partnerNotInterestedServiceComment,fs.code,psc.allFollowupDate) from PartnerServiceComment psc join PartnerService ps on psc.id = ps.partnerServiceCommentId "
|
41 |
+ " ps.fofoId,ps.genComment,ps.partnerNotInterestedServiceComment,fs.code,psc.allFollowupDate) from PartnerServiceComment psc join PartnerService ps on psc.id = ps.partnerServiceCommentId "
|
| 42 |
+ " join FofoStore fs on fs.id = ps.fofoId join userUser us on us.id=fs.id "
|
42 |
+ " join FofoStore fs on fs.id = ps.fofoId join userUser us on us.id=fs.id "
|