| Line 38... |
Line 38... |
| 38 |
+ " PartnerOnBoardingPanel pob on pob.Code=fs.code left join PartnerServiceComment psc on psc.id=ps.partnerServiceCommentId where ps.partnerServiceCommentId = :partnerServiceCommentId"),
|
38 |
+ " PartnerOnBoardingPanel pob on pob.Code=fs.code left join PartnerServiceComment psc on psc.id=ps.partnerServiceCommentId where ps.partnerServiceCommentId = :partnerServiceCommentId"),
|
| 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 "
|
| 43 |
+ " join PartnerOnBoardingPanel pob on pob.Code=fs.code where psc.allFollowupDate = :currentDate"),
|
43 |
+ " join PartnerOnBoardingPanel pob on pob.Code=fs.code where psc.allFollowupDate <= :currentDate"),
|
| 44 |
|
44 |
|
| 45 |
})
|
45 |
})
|
| 46 |
|
46 |
|
| 47 |
public class ServiceBrandsConfig implements Serializable {
|
47 |
public class ServiceBrandsConfig implements Serializable {
|
| 48 |
|
48 |
|