def thoroughbred_mismatch(order_id, qstring):
order_data = salesapi.sale(order_id)
# for now assume only ever one fulfill
wh_fulfill = WarehouseFulfill.objects \
.filter(savor_order_id=order_id) \
.values('warehouse_pack_id')[0]
req_fulfill = Fulfillment.objects \
.filter(order_id=order_id) \
.values('id')[0]
req_record = fulfillment(req_fulfill['id'])
req_record['shipping_zip'] = order_data['shipping_zip']
req_record['shipping_name'] = order_data['shipping_name']
whouse_record = warehousefulfill(wh_fulfill['warehouse_pack_id'])
output = []
flds = ['shipping_name', 'shipping_zip', 'skus']
def get_row(fld):
return {'field': fld,
'savor': str(req_record.get(fld, '')),
'thoroughbred': str(whouse_record.get(fld, '')),
'mismatch': req_record.get(fld, '') != whouse_record.get(fld, '')}
for fld in flds:
output.append(get_row(fld))
return output
def thoroughbred_mismatch(qstring):
mismatched_f = fulfillment({'status': 'mismatched'})
warehouse_recds = warehousefulfill({})
mismatched = []
for f in mismatched_f:
fulfill_id = f['id']
order_zip = f['order']['shipping_zip']
whouse_recs = [r for r in warehouse_recds
if r['fulfillment'] == fulfill_id]
if len(whouse_recs) > 0:
whouse_record = whouse_recs[0]
if whouse_record['skus'] != f['skus']:
mismatched.append({'fulfill_id': fulfill_id,
'fail_reason': 'SKUS'})
elif not rec_zip(order_zip,
whouse_record['shipping_zip']):
mismatched.append({'fulfill_id': fulfill_id,
'fail_reason': 'ZIP'})
return mismatched
def queryset(self, request, qs):
if self.value():
fulfillment_ids = [x['id'] for x in fulfill_api.fulfillment({})
if x['ship_info'] == self.value() and x['status'] == 'requested']
return qs.filter(id__in=fulfillment_ids)
