Exemplo n.º 1
0
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
Exemplo n.º 2
0
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']