Subversion Repositories SmartDukaan

Rev

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

Rev 31163 Rev 31860
Line 18... Line 18...
18 
				" join Purchase p on p.id = ii.purchaseId join Order o on o.invoiceNumber = p.purchaseReference" +
 18 
				" join Purchase p on p.id = ii.purchaseId join Order o on o.invoiceNumber = p.purchaseReference" +
19 
				" join LineItem li on li.orderId = o.id join LineItemImei lii on (lii.id=li.id and lii.serialNumber=ii.serialNumber)" +
 19 
				" join LineItem li on li.orderId = o.id join LineItemImei lii on (lii.id=li.id and lii.serialNumber=ii.serialNumber)" +
20 
				"where ii.id in :inventoryItemIds")
 20 
				"where ii.id in :inventoryItemIds")
21 
})
 21 
})
22 
@Entity
 22 
@Entity
23 
@Table(name = "fofo.inventory_item", schema = "fofo")
 23 
@Table(name = "fofo.inventory_item")
24 
public class InventoryItem implements Comparable {
 24 
public class InventoryItem implements Comparable {
25 
 
 25 
 
26 
	public InventoryItem(String serialNumber) {
 26 
	public InventoryItem(String serialNumber) {
27 
		this.serialNumber = serialNumber;
 27 
		this.serialNumber = serialNumber;
28 
	}
 28 
	}