Subversion Repositories SmartDukaan

Rev

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

Rev 8630 Rev 9433
Line 67... Line 67...
67
67
68 
  <select id="getPurchaseScansByGrnDate" parameterType="map" resultType="detailedPurchaseScan">
 68 
  <select id="getPurchaseScansByGrnDate" parameterType="map" resultType="detailedPurchaseScan">
69 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
 69 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
70 
        p.invoiceNumber AS invoiceNumbers, inv.receivedFrom AS receivedBy, i.itemId,brand, modelName, modelNumber, color,
70 
        p.invoiceNumber AS invoiceNumbers, inv.receivedFrom AS receivedBy, i.itemId,brand, modelName, modelNumber, color,
71 
        unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId,
71 
        unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId,
72 
        nlc, po.warehouseId
72 
        nlc, po.warehouseId, po.taxType
73 
    FROM purchase p
 73 
    FROM purchase p
74 
    JOIN purchaseorder po
74 
    JOIN purchaseorder po
75 
        ON (po.id = p.purchaseOrder_id)
 75 
        ON (po.id = p.purchaseOrder_id)
76 
    JOIN inventoryItem i
 76 
    JOIN inventoryItem i
77 
        ON (p.id = i.purchaseId)
 77 
        ON (p.id = i.purchaseId)