Subversion Repositories SmartDukaan

Rev

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

Rev 7410 Rev 7453
Line 55... Line 55...
55 
    JOIN lineitem l
 55 
    JOIN lineitem l
56 
        ON (l.itemId = i.itemId AND l.purchaseOrder_id = po.id)
 56 
        ON (l.itemId = i.itemId AND l.purchaseOrder_id = po.id)
57 
    JOIN supplier s
 57 
    JOIN supplier s
58 
        ON (s.id = po.supplierId)
 58 
        ON (s.id = po.supplierId)
59 
    JOIN invoice inv
 59 
    JOIN invoice inv
60 
    	ON (inv.invoiceNumber = p.invoiceNumber)
 60 
    	ON (inv.invoiceNumber = p.invoiceNumber AND inv.supplierId = po.supplierId)
61 
    WHERE po.createdAt BETWEEN #{startDate} AND #{endDate}
61 
    WHERE po.createdAt BETWEEN #{startDate} AND #{endDate}
62 
    AND lastScanType != 'DOA_REPLACED'
62 
    AND lastScanType != 'DOA_REPLACED'
63 
    GROUP BY p.purchaseOrder_id, p.id, i.itemId
 63 
    GROUP BY p.purchaseOrder_id, p.id, i.itemId
64 
    ORDER BY p.purchaseOrder_id, p.id, i.itemId
 64 
    ORDER BY p.purchaseOrder_id, p.id, i.itemId
65 
  </select>
 65 
  </select>