Subversion Repositories SmartDukaan

Rev

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

Rev 34412 Rev 34490
Line 110... Line 110...
110 
 
 110 
 
111 
        @NamedNativeQuery(name = "FofoOrder.getCatalogSoldQtyLastDaysByDate", query = "" +
 111 
        @NamedNativeQuery(name = "FofoOrder.getCatalogSoldQtyLastDaysByDate", query = "" +
112 
                " SELECT i.catalog_item_id,fo.fofo_id, i.model_number,i.brand, SUM(foi.quantity) AS total_quantity_sold FROM fofo.fofo_order fo" +
 112 
                " SELECT i.catalog_item_id,fo.fofo_id, i.model_number,i.brand, SUM(foi.quantity) AS total_quantity_sold FROM fofo.fofo_order fo" +
113 
                " LEFT JOIN fofo.fofo_order_item foi ON foi.order_id = fo.id " +
 113 
                " LEFT JOIN fofo.fofo_order_item foi ON foi.order_id = fo.id " +
114 
                " JOIN catalog.item i ON i.id = foi.item_id " +
 114 
                " JOIN catalog.item i ON i.id = foi.item_id " +
115 
                " WHERE fo.fofo_id = :fofoId AND fo.create_timestamp >= :cutOffDate AND i.catalog_item_id IN (:catalogIds) " +
 115 
                " WHERE fo.fofo_id = :fofoId AND fo.create_timestamp >= :cutOffDate" +
116 
                " GROUP BY i.catalog_item_id", resultSetMapping = "lastDaysSoldQtyByDateAndCatalogId"),
 116 
                " GROUP BY i.catalog_item_id", resultSetMapping = "lastDaysSoldQtyByDateAndCatalogId"),
117 
 
 117 
 
118 
 
 118 
 
119 
})
 119 
})
120 
 
 120