| Line 23... |
Line 23... |
| 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,"
|
| 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 |
+ " 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 "
|
| 29 |
+ " 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 "
|
| 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"),
|
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 left join PartnerServiceComment psc on psc.id=ps.partnerServiceCommentId"),
|
| 31 |
|
31 |
|
| 32 |
@NamedQuery(name = "ServiceBrandsConfig.selectFinanceServicesByFofoId", query = "select new com.spice.profitmandi.dao.model.FinanceServicesModel(pbs.fofoId, "
|
32 |
@NamedQuery(name = "ServiceBrandsConfig.selectFinanceServicesByPartnerServiceCommentId", 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) 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 join "
|
| - |
|
38 |
+ " PartnerOnBoardingPanel pob on pob.Code=fs.code left join PartnerServiceComment psc on psc.id=ps.partnerServiceCommentId where ps.partnerServiceCommentId = :partnerServiceCommentId"),
|
| - |
|
39 |
|
| - |
|
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 "
|
| - |
|
42 |
+ " join FofoStore fs on fs.id = ps.fofoId join userUser us on us.id=fs.id "
|
| 38 |
+ "PartnerOnBoardingPanel pob on pob.Code=fs.code where fs.id = :fofoId"), })
|
43 |
+ " join PartnerOnBoardingPanel pob on pob.Code=fs.code where psc.allFollowupDate = :currentDate"),
|
| - |
|
44 |
|
| - |
|
45 |
})
|
| 39 |
|
46 |
|
| 40 |
public class ServiceBrandsConfig implements Serializable {
|
47 |
public class ServiceBrandsConfig implements Serializable {
|
| 41 |
|
48 |
|
| 42 |
private static final long serialVersionUID = 1L;
|
49 |
private static final long serialVersionUID = 1L;
|
| 43 |
|
50 |
|