Subversion Repositories SmartDukaan

Rev

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

Rev 7453 Rev 7672
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, p.id as purchaseId
49 
        brand, modelName, modelNumber, color, unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId, nlc
50 
    FROM purchase p
 50 
    FROM purchase p
51 
    JOIN purchaseorder po
51 
    JOIN purchaseorder po
52 
        ON (po.id = p.purchaseOrder_id)
 52 
        ON (po.id = p.purchaseOrder_id)
53 
    JOIN inventoryItem i
 53 
    JOIN inventoryItem i
54 
        ON (p.id = i.purchaseId)
 54 
        ON (p.id = i.purchaseId)
Line 65... Line 65...
65 
  </select>
 65 
  </select>
66
66
67 
  <select id="getPurchaseScansByGrnDate" parameterType="map" resultType="detailedPurchaseScan">
 67 
  <select id="getPurchaseScansByGrnDate" parameterType="map" resultType="detailedPurchaseScan">
68 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
 68 
    SELECT p.purchaseOrder_id AS purchaseOrderId, 1000 * UNIX_TIMESTAMP(po.createdAt) AS poCreatedAt, s.name AS supplierName,
69 
        p.invoiceNumber AS invoiceNumbers, inv.receivedFrom AS receivedBy, i.itemId,brand, modelName, modelNumber, color,
69 
        p.invoiceNumber AS invoiceNumbers, inv.receivedFrom AS receivedBy, i.itemId,brand, modelName, modelNumber, color,
70 
        unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId
70 
        unitPrice, SUM(initialQuantity) AS quantity, 1000 * UNIX_TIMESTAMP(receivedOn) as purchasedAt, p.id as purchaseId, nlc
71 
    FROM purchase p
 71 
    FROM purchase p
72 
    JOIN purchaseorder po
72 
    JOIN purchaseorder po
73 
        ON (po.id = p.purchaseOrder_id)
 73 
        ON (po.id = p.purchaseOrder_id)
74 
    JOIN inventoryItem i
 74 
    JOIN inventoryItem i
75 
        ON (p.id = i.purchaseId)
 75 
        ON (p.id = i.purchaseId)