def import_combo_items():
idx = 0
chunk = 2000
total = ContactOrderitem.objects.all().count()
# old_items = ContactOrderitem.objects.filter(order__id__gte=15014).iterator()
# old_items = ContactOrderitem.objects.filter(contactorderitemdetail__name='date', contactorderitemdetail__value='01-06-2010')
# old_items = ContactOrderitem.objects.filter(contactorderitemdetail__name__in=('REFUND', 'VOID', 'transmutation'))
while idx < total:
print '*'*75, idx
old_items = ContactOrderitem.objects.all().order_by('id')[idx:idx+chunk]
idx += chunk
for old_item in old_items:
if not is_multiproduct(int(old_item.product_id)):
continue
details_dict = {}
details = old_item.contactorderitemdetail_set.all().iterator()
for d in details:
details_dict[d.name] = d.value
if 'date' not in details_dict or details_dict['date'] == '77-77-7777':
day = date(2009, 1, 1)
else:
d, month, year = map(int, details_dict['date'].split('-'))
if year < 15:
year = year + 2000
try:
day = date(year, month, d)
except Exception, e:
print details_dict
from IPython.Shell import IPShellEmbed; IPShellEmbed()()
# Quantity, sample: 'quantity_Children (12 and under)::0__quantity_Senior (65+)::3__quantity_Adults::2'
# Quantity, sample: 'quantity_default::2'
# quantity_Senior (65+)::0__quantity_Children (12 and under) (with Aquarium)::0__quantity_Adults::4__quantity_Children (12 and under)::2__quantity_Senior (65+) (with aquarium)::0__quantity_Adults (with Aquarium)::0
# print old_item.quantity
children = seniors = adults = default = 0
raw_quantities = old_item.quantity.split('__')
for raw_q in raw_quantities:
quan = Decimal(raw_q.split('::')[-1])
if 'Children' in raw_q:
children += quan
if 'Senior' in raw_q:
seniors += quan
if 'Adults' in raw_q:
adults += quan
if 'default' in raw_q:
default += quan
options = {
'Adult': adults + default,
'Senior': seniors,
'Child': children
}
# print 'Adults: %(Adult)d Senior: %(Senior)d Child: %(Child)d' % options
# sleep(1)
# continue
order = Order.objects.get(id=old_item.order.id)
for key, quantity in options.items():
if quantity == 0:
continue
tour_type = get_tour_type(int(old_item.product_id))
old_product = ProductProduct.objects.get(id=int(old_item.product_id))
dts2s = ProductDatetimeschema2.objects.filter(product=old_product)
times = []
for dts2 in dts2s:
times.append(dts2.dts.get_nice_data()[0])
mp_start_time = min(times)
# This all just makes sure a schedule exists for the right times.
try:
schedule = tour_type.get_schedule_for_day(day)[0]
except IndexError:
# get schedule at this time and add this isoweekday to it, or create a new one
try:
schedule = tour_type.schedules.filter(tour_time=mp_start_time)[0]
except IndexError:
schedule = TourSchedule(tour_time=mp_start_time, tour_type=tour_type)
schedule.save()
dow = DayOfWeek.objects.get(isoweekday=day.isoweekday())
schedule.day_of_week.add(dow)
schedule.save()
# print tour_type, min(times), schedule
tour_product = tour_type.get_product(day, tour_time=mp_start_time)
new_item = OrderItem(order=order)
new_item.quantity = quantity
new_item.product = tour_product.product
new_item.tax = 0
new_item.unit_tax = 0
# i = old_item
# print i.unit_price, i.unit_tax, i.line_item_price, i.tax, i.discount
new_item.line_item_price = old_item.line_item_price
new_item.unit_price = old_item.unit_price
# print old_item.line_item_price, order.id
if new_item.line_item_price == 0:
# SUMIT: Put code in here to figure out what these combos should be priced at for reports
# print tour_product.product.price
# if tour_type.id == 7: # City / Alcatraz
# new_item.line_item_price = Decimal('109.99') * new_item.quantity
# else:
# print tour_type
# from IPython.Shell import IPShellEmbed; IPShellEmbed()()
# assert False
# if tour_type ==
# new_item.line_item_price = Decimal('153.99')
# from IPython.Shell import IPShellEmbed; IPShellEmbed()()
# assert False
print new_item.line_item_price, order.total, tour_type.base_price
# new_item.save()
# Handle VOID, REFUND, and transmutation
if 'VOID' in details_dict:
adjustment = Adjustment(item=new_item)
adjustment.status = Adjustment.VOIDED
adjustment.save()
print details_dict
elif 'REFUND' in details_dict:
adjustment = Adjustment(item=new_item)
adjustment.status = Adjustment.VOIDED
adjustment.save()
print details_dict
elif 'transmutation' in details_dict:
# Don't think there were any of these
from IPython.Shell import IPShellEmbed; IPShellEmbed()()
# update inventory
# product = tour_product.product
# product.total_sold = Decimal(product.total_sold) + Decimal(quantity)
# product.save()
print 'Saved OrderItem: ', new_item.id, ' Order #', order.id
def import_order_items():
idx = 0
chunk = 2000
total = ContactOrderitem.objects.all().count()
# old_items = ContactOrderitem.objects.filter(order__id__gte=15014).iterator()
# old_items = ContactOrderitem.objects.filter(contactorderitemdetail__name='date', contactorderitemdetail__value='01-06-2010')
# old_items = ContactOrderitem.objects.filter(contactorderitemdetail__name__in=('REFUND', 'VOID', 'transmutation'))
while idx < total:
print '*'*75, idx
old_items = ContactOrderitem.objects.all().order_by('id')[idx:idx+chunk]
idx += chunk
for old_item in old_items:
# TODO old_items have a boolean called insurance? is this satchmo or custom and is it necessary?
details_dict = {}
details = old_item.contactorderitemdetail_set.all().iterator()
for d in details:
details_dict[d.name] = d.value
if 'date' not in details_dict or details_dict['date'] == '77-77-7777':
day = date(2009, 1, 1)
else:
d, month, year = map(int, details_dict['date'].split('-'))
if year < 15:
year = year + 2000
try:
day = date(year, month, d)
except Exception, e:
print details_dict
from IPython.Shell import IPShellEmbed; IPShellEmbed()()
# Quantity, sample: 'quantity_Children (12 and under)::0__quantity_Senior (65+)::3__quantity_Adults::2'
# Quantity, sample: 'quantity_default::2'
# quantity_Senior (65+)::0__quantity_Children (12 and under) (with Aquarium)::0__quantity_Adults::4__quantity_Children (12 and under)::2__quantity_Senior (65+) (with aquarium)::0__quantity_Adults (with Aquarium)::0
# print old_item.quantity
children = seniors = adults = default = 0
raw_quantities = old_item.quantity.split('__')
for raw_q in raw_quantities:
quan = Decimal(raw_q.split('::')[-1])
if 'Children' in raw_q:
children += quan
if 'Senior' in raw_q:
seniors += quan
if 'Adults' in raw_q:
adults += quan
if 'default' in raw_q:
default += quan
options = {
'Adult': adults + default,
'Senior': seniors,
'Child': children
}
# print 'Adults: %(Adult)d Senior: %(Senior)d Child: %(Child)d' % options
# sleep(1)
# continue
order = Order.objects.get(id=old_item.order.id)
for key, quantity in options.items():
if quantity == 0:
continue
# so if this product is actually a multiproduct, we need to create items for both products
tour_types = get_tour_types_for_old_id(int(old_item.product_id))
for tour_type in tour_types:
tour_time = None
if 'time' not in details_dict or details_dict['time'] == '-1':
# Probably a multiproduct:
if is_multiproduct(int(old_item.product_id)):
old_product = ProductProduct.objects.get(id=int(old_item.product_id))
dts2s = ProductDatetimeschema2.objects.filter(product=old_product)
for dts2 in dts2s:
if dts2.dts.product.id == tour_type.old_product_id:
tour_time = dts2.dts.get_nice_data()[0]
else:
tour_time, days = ProductDatetimeschema.objects.get(id=details_dict['time']).get_nice_data()
if tour_time is None:
if int(old_item.product_id) == 8:
# move on, this is a gift certificate
continue
else:
if int(old_item.product_id) == 4:
print 'Houston, we have a problem'
from IPython.Shell import IPShellEmbed; IPShellEmbed()()
continue
tour_product = tour_type.get_product(day, tour_time=tour_time)
new_item = OrderItem(order=order)
new_item.quantity = quantity
# These don't have product variations
if tour_type.id in (6, 7, 8):
new_item.product = tour_product.product
else:
try:
new_item.product = tour_product.product.configurableproduct.productvariation_set.get(options__value=key).product
except:
print 'uhh'
from IPython.Shell import IPShellEmbed; IPShellEmbed()()
new_item.tax = 0
new_item.unit_tax = 0
new_item.line_item_price = old_item.unit_price * int(quantity)
new_item.unit_price = old_item.unit_price
try:
new_item.full_clean()
except ValidationError, e:
print 'full_clean'
from IPython.Shell import IPShellEmbed; IPShellEmbed()()
assert False
new_item.save()
# Handle VOID, REFUND, and transmutation
if 'VOID' in details_dict:
adjustment = Adjustment(item=new_item)
adjustment.status = Adjustment.VOIDED
adjustment.save()
print details_dict
elif 'REFUND' in details_dict:
adjustment = Adjustment(item=new_item)
adjustment.status = Adjustment.VOIDED
adjustment.save()
print details_dict
elif 'transmutation' in details_dict:
# Don't think there were any of these
from IPython.Shell import IPShellEmbed; IPShellEmbed()()
else:
# update inventory
product = tour_product.product
product.total_sold = Decimal(product.total_sold) + Decimal(quantity)
product.save()
print 'Saved OrderItem: ', new_item.id, ' Order #', order.id
if 'CODE' in details_dict and details_dict['CODE']:
try:
reseller = Reseller.objects.get(code=details_dict['CODE'])
reseller.orders.add(order)
reseller.save()
# print 'Matched order ', order.id, ' and reseller ', reseller.company_name
except Reseller.DoesNotExist:
try:
concierge = Concierge.objects.get(code=details_dict['CODE'])
concierge.orders.add(order)
concierge.save()
print 'Matched order ', order.id, ' and reseller ', concierge.name
except Concierge.DoesNotExist:
print 'No reseller/concierge for code: ', details_dict['CODE']