| 23 |
@Table(name = "fofo.service_brand", schema = "fofo")
|
23 |
@Table(name = "fofo.service_brand", schema = "fofo")
|
| 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,sb.serviceId,sb.brand,po.name,ps.code,ps.applicableType,fs.code,us.createTimestamp) from PartnerBrandService pbs "
|
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.na_Comment,fs.code,us.createTimestamp) from PartnerBrandService pbs "
|
| 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"),
|
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"),
|