Subversion Repositories SmartDukaan

Rev

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

Rev 11311 Rev 11336
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, po.taxType, inv.invoiceDate as invoiceDate
 72 
        nlc, po.warehouseId, po.taxType, 1000 * UNIX_TIMESTAMP(inv.invoiceDate) as invoiceDate
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)