Subversion Repositories SmartDukaan

Rev

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

Rev 5944 Rev 5956
Line 7... Line 7...
7 
Updated on 02-Jan-2012
 7 
Updated on 02-Jan-2012
8 
 
 8 
 
9 
@author: Chandranshu
 9 
@author: Chandranshu
10 
@author: Rajveer
 10 
@author: Rajveer
11 
'''
 11 
'''
12 
import optparse
 - 
 
13 
import xlwt
 - 
 
14 
from operator import itemgetter
 12 
from operator import itemgetter
- 
 
 13 
from shop2020.clients.CatalogClient import CatalogClient
- 
 
 14 
from shop2020.clients.InventoryClient import InventoryClient
- 
 
 15 
from shop2020.clients.TransactionClient import TransactionClient
- 
 
 16 
from shop2020.model.v1.catalog.impl.CategoryManager import CategoryManager
15 
import operator
 17 
import operator
- 
 
 18 
import optparse
- 
 
 19 
import xlwt
16 
 
 20 
 
17 
 
 21 
 
18 
if __name__ == '__main__' and __package__ is None:
 22 
if __name__ == '__main__' and __package__ is None:
19 
    import sys
 23 
    import sys
20 
    import os
 24 
    import os
21 
    sys.path.insert(0, os.getcwd())
 25 
    sys.path.insert(0, os.getcwd())
22 
from shop2020.model.v1.catalog.impl.CategoryManager import CategoryManager
 - 
 
23 
from shop2020.clients.CatalogClient import CatalogClient
 - 
 
24 
from shop2020.clients.TransactionClient import TransactionClient
 - 
 
25 
 
 26 
 
26 
categories={}
 27 
categories={}
27 
catm = CategoryManager()
 28 
catm = CategoryManager()
28 
root_category = catm.getCategory(10000)
 29 
root_category = catm.getCategory(10000)
29 
for child_cat_id in root_category.children_category_ids:
 30 
for child_cat_id in root_category.children_category_ids:
Line 43... Line 44...
43 
    (options, args) = parser.parse_args()
 44 
    (options, args) = parser.parse_args()
44
45
45 
    if len(args) != 1:
 46 
    if len(args) != 1:
46 
        parser.error("Missing argument: output file name")
 47 
        parser.error("Missing argument: output file name")
47
48
48 
    inventory_client = CatalogClient().get_client()
 49 
    inventory_client = InventoryClient().get_client()
49 
    stocks_for_items_with_pending_orders = inventory_client.getPendingOrdersInventory(options.vendorId)
 50 
    stocks_for_items_with_pending_orders = inventory_client.getPendingOrdersInventory(options.vendorId)
50
51
51 
    txn_client = TransactionClient().get_client()
 52 
    txn_client = TransactionClient().get_client()
52 
    item_wise_risky_orders = txn_client.getItemWiseRiskyOrdersCount()
 53 
    item_wise_risky_orders = txn_client.getItemWiseRiskyOrdersCount()
53 
    #[OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.LOW_INV_PO_RAISED, OrderStatus.LOW_INV_REVERSAL_IN_PROCESS]
 54 
    #[OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.LOW_INV_PO_RAISED, OrderStatus.LOW_INV_REVERSAL_IN_PROCESS]
Line 115... Line 116...
115 
    for stock in stocks_for_items_with_pending_orders:
 116 
    for stock in stocks_for_items_with_pending_orders:
116 
        itemId = stock.itemId
 117 
        itemId = stock.itemId
117 
        if not item_quantity_list.has_key(itemId):
 118 
        if not item_quantity_list.has_key(itemId):
118 
            continue
 119 
            continue
119
120
- 
 
 121 
        catalog_client = CatalogClient().get_client()
120 
        item = inventory_client.getItem(itemId)
 122 
        item = catalog_client.getItem(itemId)
121
123
122 
        category = categories[item.category]
 124 
        category = categories[item.category]
123 
        brand = item.brand
 125 
        brand = item.brand
124 
        model_name = item.modelName if item.modelName else ""
 126 
        model_name = item.modelName if item.modelName else ""
125 
        model_number = item.modelNumber
 127 
        model_number = item.modelNumber