| Line 1126... |
Line 1126... |
| 1126 |
oosStatus.date = oosDate
|
1126 |
oosStatus.date = oosDate
|
| 1127 |
oosStatus.is_oos = status
|
1127 |
oosStatus.is_oos = status
|
| 1128 |
oosStatus.sourceId = sid
|
1128 |
oosStatus.sourceId = sid
|
| 1129 |
order_count = 0
|
1129 |
order_count = 0
|
| 1130 |
rto_count = 0
|
1130 |
rto_count = 0
|
| 1131 |
if status == False:
|
- |
|
| 1132 |
if orderCountByItemIdSourceId.has_key(itemId) and orderCountByItemIdSourceId[itemId].has_key(sid):
|
1131 |
if orderCountByItemIdSourceId.has_key(itemId) and orderCountByItemIdSourceId[itemId].has_key(sid):
|
| 1133 |
order_count = orderCountByItemIdSourceId[itemId][sid]
|
1132 |
order_count = orderCountByItemIdSourceId[itemId][sid]
|
| 1134 |
if rtoOrderCountByItemIdSourceId.has_key(itemId) and rtoOrderCountByItemIdSourceId[itemId].has_key(sid):
|
1133 |
if rtoOrderCountByItemIdSourceId.has_key(itemId) and rtoOrderCountByItemIdSourceId[itemId].has_key(sid):
|
| 1135 |
rto_count = rtoOrderCountByItemIdSourceId[itemId][sid]
|
1134 |
rto_count = rtoOrderCountByItemIdSourceId[itemId][sid]
|
| 1136 |
oosStatus.num_orders = order_count
|
1135 |
oosStatus.num_orders = order_count
|
| 1137 |
oosStatus.rto_orders = rto_count
|
1136 |
oosStatus.rto_orders = rto_count
|
| - |
|
1137 |
if status == True and order_count > 0:
|
| - |
|
1138 |
status = False
|
| 1138 |
total_order_count = total_order_count + order_count
|
1139 |
total_order_count = total_order_count + order_count
|
| 1139 |
total_rto_count = total_rto_count + rto_count
|
1140 |
total_rto_count = total_rto_count + rto_count
|
| 1140 |
else:
|
1141 |
else:
|
| 1141 |
print "OOS Status already exists for ItemID:"+str(itemId) " and SourceID " + str(sid)
|
1142 |
print "OOS Status already exists for ItemID:"+str(itemId) " and SourceID " + str(sid)
|
| 1142 |
|
1143 |
|
| 1143 |
if OOSStatus.query.filter_by(item_id = itemId, date = oosDate, sourceId = 0).first() is None:
|
1144 |
if OOSStatus.query.filter_by(item_id = itemId, date = oosDate, sourceId = 0).first() is None:
|
| 1144 |
oosStatus = OOSStatus()
|
1145 |
oosStatus = OOSStatus()
|
| 1145 |
oosStatus.item_id = itemId
|
1146 |
oosStatus.item_id = itemId
|
| 1146 |
oosStatus.date = oosDate
|
1147 |
oosStatus.date = oosDate
|
| 1147 |
oosStatus.is_oos = status
|
- |
|
| 1148 |
oosStatus.sourceId = 0
|
1148 |
oosStatus.sourceId = 0
|
| 1149 |
oosStatus.num_orders = total_order_count
|
1149 |
oosStatus.num_orders = total_order_count
|
| 1150 |
oosStatus.rto_orders = total_rto_count
|
1150 |
oosStatus.rto_orders = total_rto_count
|
| - |
|
1151 |
if status == True and total_order_count > 0:
|
| - |
|
1152 |
status = False
|
| - |
|
1153 |
oosStatus.is_oos = status
|
| 1151 |
else:
|
1154 |
else:
|
| 1152 |
print "OOS Status already exists for ItemID:"+str(itemId) " and SourceID " + str(sid)
|
1155 |
print "OOS Status already exists for ItemID:"+str(itemId) " and SourceID " + str(sid)
|
| 1153 |
session.commit()
|
1156 |
session.commit()
|
| 1154 |
|
1157 |
|
| 1155 |
def get_oos_statuses_for_x_days_for_item(itemId, sourceId, days):
|
1158 |
def get_oos_statuses_for_x_days_for_item(itemId, sourceId, days):
|