Subversion Repositories SmartDukaan

Rev

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

Rev 23110 Rev 23297
Line 35... Line 35...
35 
@Entity
 35 
@Entity
36 
@Table(name="transaction.`order`", schema = "transaction")
 36 
@Table(name="transaction.`order`", schema = "transaction")
37 
@NamedQueries({
 37 
@NamedQueries({
38 
	@NamedQuery(name="Order.selectAll",query="select o from Order o"),
 38 
	@NamedQuery(name="Order.selectAll",query="select o from Order o"),
39 
	@NamedQuery(name="Order.selectById",query="select o from Order o where o.id= :id"),
 39 
	@NamedQuery(name="Order.selectById",query="select o from Order o where o.id= :id"),
40 
	@NamedQuery(name = "Order.selectCountByTransactionId", query = "select count(o) from Order o where o.transactionId = :transactionId"),
 - 
 
41 
	@NamedQuery(
 40 
	@NamedQuery(
42 
		name = "Order.selectByTransactionId",
41 
		name = "Order.selectByTransactionId",
43 
		query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
 42 
		query = "select t.id, t.createTimestamp, o.retailerAddress1, o.retailerAddress2, o.retailerCity, "
44 
			+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
 43 
			+ "o.retailerPinCode, o.retailerState, o.shippingCost, o.statusDescription, o.invoiceNumber, o.airwayBillNumber, o.totalAmount, li.brand, li.modelName, "
45 
			+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name,  o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId  from Transaction t join Order o on o.transactionId = t.id "
 44 
			+ "li.modelNumber, li.color, li.quantity, li.unitPrice, p.id, p.name,  o.shippingTimestamp, o.status, o.promisedDeliveryTime, o.retailerName, t.status, i.catalogItemId  from Transaction t join Order o on o.transactionId = t.id "