Subversion Repositories SmartDukaan

Rev

Rev 36346 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 36346 Rev 36934
Line 7... Line 7...
7 
        @NamedNativeQuery(name = "Aging.15DaysWarehouseWiseStock",
 7 
        @NamedNativeQuery(name = "Aging.15DaysWarehouseWiseStock",
8 
                query = "SELECT " +
 8 
                query = "SELECT " +
9 
                        "    cis.warehouse_id AS warehouse_id, " +
 9 
                        "    cis.warehouse_id AS warehouse_id, " +
10 
                        "    SUM((cis.total - cis.Dlt15) * cis.dealer_price) AS total_aging " +
 10 
                        "    SUM((cis.total - cis.Dlt15) * cis.dealer_price) AS total_aging " +
11 
                        "FROM inventory.tbl_cis cis " +
 11 
                        "FROM inventory.tbl_cis cis " +
- 
 
 12 
                        "JOIN catalog.item ci ON ci.id = cis.item_id " +
12 
                        "WHERE cis.total > 0 " +
 13 
                        "WHERE cis.total > 0 " +
- 
 
 14 
                        "  AND ci.category = 10006 " +
13 
                        "GROUP BY cis.warehouse_id",
 15 
                        "GROUP BY cis.warehouse_id",
14 
                resultSetMapping = "WarehouseAgingStock")
 16 
                resultSetMapping = "WarehouseAgingStock")
15 
})
 17 
})
16 
 
 18 
 
17 
@SqlResultSetMappings({
 19 
@SqlResultSetMappings({