Subversion Repositories SmartDukaan

Rev

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

Rev 7089 Rev 7090
Line 54... Line 54...
54
54
55 
  <select id="fetchMismatchScansPerInvoiceNumber" parameterType="java.util.Date" resultType="invoiceScan" >
 55 
  <select id="fetchMismatchScansPerInvoiceNumber" parameterType="java.util.Date" resultType="invoiceScan" >
56 
    SELECT i.invoiceNumber, i.numItems, sum(initialQuantity) as scannedQuantity, i.date, s.name as supplierName
 56 
    SELECT i.invoiceNumber, i.numItems, sum(initialQuantity) as scannedQuantity, i.date, s.name as supplierName
57 
    FROM invoice i
 57 
    FROM invoice i
58 
    JOIN supplier s
 58 
    JOIN supplier s
- 
 
 59 
    	ON (i.supplierId = s.id)
59 
    LEFT JOIN purchase p
 60 
    LEFT JOIN purchase p
60 
        ON (p.invoiceNumber = i.invoiceNumber)
 61 
        ON (p.invoiceNumber = i.invoiceNumber)
61 
    LEFT JOIN inventoryItem ii
62 
    LEFT JOIN inventoryItem ii
62 
    	ON (ii.purchaseId = p.id)
 63 
    	ON (ii.purchaseId = p.id)
63 
    JOIN scanNew sn
 64 
    JOIN scanNew sn