Subversion Repositories SmartDukaan

Rev

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

Rev 18127 Rev 23400
Line 44... Line 44...
44
44
45
45
46 
  <select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
 46 
  <select id="getPurchaseScans" parameterType="map" resultType="detailedPurchaseScan">
47 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
 47 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
48 
        GROUP_CONCAT(DISTINCT(p.invoiceNumber)) AS invoiceNumbers, GROUP_CONCAT(DISTINCT(inv.receivedFrom)) AS receivedBy, i.itemId,
 48 
        GROUP_CONCAT(DISTINCT(p.invoiceNumber)) AS invoiceNumbers, GROUP_CONCAT(DISTINCT(inv.receivedFrom)) AS receivedBy, i.itemId,
49 
        brand, modelName, modelNumber, color, unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt,
49 
        brand, modelName, modelNumber, color, unitPrice, sgstRate, cgstRate, igstRate SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt,
50 
        p.id as purchaseId, nlc, po.warehouseId
50 
        p.id as purchaseId, nlc, po.warehouseId
51 
    FROM purchase p
 51 
    FROM purchase p
52 
    JOIN purchaseorder po
52 
    JOIN purchaseorder po
53 
        ON (po.id = p.purchaseOrder_id)
 53 
        ON (po.id = p.purchaseOrder_id)
54 
    JOIN inventoryItem i
 54 
    JOIN inventoryItem i