Subversion Repositories SmartDukaan

Rev

Rev 29055 | Rev 29765 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 29055 Rev 29064
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,sb.serviceId,sb.brand,po.name,ps.code,ps.applicableType,ps.createTimestamp,ps.pendingCreateTimestamp,ps.na_Comment,fs.code,fs.activeTimeStamp,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.pendingCreateTimestamp,ps.na_Comment,ps.partnerNotInterestedServiceComment,fs.code,fs.activeTimeStamp,us.createTimestamp) from PartnerBrandService pbs "
28 
				+ " join  ServiceBrandsConfig sb  on pbs.brandServiceId = sb.id  join PaymentOption po on sb.serviceId = po.id "
 28 
				+ " 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"),
 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 
})
 30 
})
31 
public class ServiceBrandsConfig implements Serializable {
 31 
public class ServiceBrandsConfig implements Serializable {
32 
 
 32