| Line 234... |
Line 234... |
| 234 |
requirementsCount = requirements.get(itemId)
|
234 |
requirementsCount = requirements.get(itemId)
|
| 235 |
if requirementsCount is None:
|
235 |
if requirementsCount is None:
|
| 236 |
requirementsCount = 0.0
|
236 |
requirementsCount = 0.0
|
| 237 |
if availability.has_key(itemId):
|
237 |
if availability.has_key(itemId):
|
| 238 |
availabilityCount = availability.get(itemId)[0]
|
238 |
availabilityCount = availability.get(itemId)[0]
|
| 239 |
item = self.__get_item_from_master(itemId)
|
239 |
item = self.get_item_from_master(itemId)
|
| 240 |
if requirementsCount > availabilityCount or itemId in SKUListForPO:
|
240 |
if requirementsCount > availabilityCount or itemId in SKUListForPO:
|
| 241 |
if item.preferredVendor is None:
|
241 |
if item.preferredVendor is None:
|
| 242 |
if errorsMap.has_key(itemId):
|
242 |
if errorsMap.has_key(itemId):
|
| 243 |
errorsMap[itemId] = errorsMap.get(itemId) + "| Preferred Vendor is Missing"
|
243 |
errorsMap[itemId] = errorsMap.get(itemId) + "| Preferred Vendor is Missing"
|
| 244 |
else:
|
244 |
else:
|
| Line 247... |
Line 247... |
| 247 |
if (netRequirements.has_key(item.preferredVendor)):
|
247 |
if (netRequirements.has_key(item.preferredVendor)):
|
| 248 |
netRequirements[item.preferredVendor].append([item, requirementsCount - availabilityCount])
|
248 |
netRequirements[item.preferredVendor].append([item, requirementsCount - availabilityCount])
|
| 249 |
else:
|
249 |
else:
|
| 250 |
netRequirements[item.preferredVendor] = [[item, requirementsCount - availabilityCount]];
|
250 |
netRequirements[item.preferredVendor] = [[item, requirementsCount - availabilityCount]];
|
| 251 |
else:
|
251 |
else:
|
| 252 |
item = self.__get_item_from_master(itemId)
|
252 |
item = self.get_item_from_master(itemId)
|
| 253 |
if item.preferredVendor is None:
|
253 |
if item.preferredVendor is None:
|
| 254 |
if errorsMap.has_key(itemId):
|
254 |
if errorsMap.has_key(itemId):
|
| 255 |
errorsMap[itemId] = errorsMap.get(itemId) + "| Preferred Vendor is Missing"
|
255 |
errorsMap[itemId] = errorsMap.get(itemId) + "| Preferred Vendor is Missing"
|
| 256 |
else:
|
256 |
else:
|
| 257 |
errorsMap[itemId] = "Preferred Vendor is Missing "
|
257 |
errorsMap[itemId] = "Preferred Vendor is Missing "
|
| Line 355... |
Line 355... |
| 355 |
def close_session(self):
|
355 |
def close_session(self):
|
| 356 |
if session.is_active:
|
356 |
if session.is_active:
|
| 357 |
print "session is active. closing it."
|
357 |
print "session is active. closing it."
|
| 358 |
session.close()
|
358 |
session.close()
|
| 359 |
|
359 |
|
| 360 |
def __get_item_from_master(self, item_id):
|
360 |
def get_item_from_master(self, item_id):
|
| 361 |
client = CatalogClient("catalog_service_server_host_master", "catalog_service_server_port").get_client()
|
361 |
client = CatalogClient("catalog_service_server_host_master", "catalog_service_server_port").get_client()
|
| 362 |
return client.getItem(item_id)
|
362 |
return client.getItem(item_id)
|
| 363 |
|
363 |
|
| 364 |
def inc():
|
364 |
def inc():
|
| 365 |
global i
|
365 |
global i
|
| Line 432... |
Line 432... |
| 432 |
for itemId, error in errorsMap.items():
|
432 |
for itemId, error in errorsMap.items():
|
| 433 |
row += 1
|
433 |
row += 1
|
| 434 |
i=-1
|
434 |
i=-1
|
| 435 |
worksheet.write(row, inc(), "Not_defined")
|
435 |
worksheet.write(row, inc(), "Not_defined")
|
| 436 |
worksheet.write(row, inc(), str(itemId))
|
436 |
worksheet.write(row, inc(), str(itemId))
|
| 437 |
item = purchaseHandler.__get_item_from_master(itemId)
|
437 |
item = purchaseHandler.get_item_from_master(itemId)
|
| 438 |
worksheet.write(row, inc(), item.brand+" "+item.model_name+" "+item.model_number+" "+item.color)
|
438 |
worksheet.write(row, inc(), item.brand+" "+item.model_name+" "+item.model_number+" "+item.color)
|
| 439 |
worksheet.write(row, inc(), 0)
|
439 |
worksheet.write(row, inc(), 0)
|
| 440 |
|
440 |
|
| 441 |
worksheet.write(row, inc(), 0)
|
441 |
worksheet.write(row, inc(), 0)
|
| 442 |
worksheet.write(row, inc(), 0)
|
442 |
worksheet.write(row, inc(), 0)
|