Ticket #149: distrib_report.py

#!/usr/bin/env python

import csv
import sys,os


def setup_environment():
    pathname = os.path.dirname(sys.argv[0])
    sys.path.append(os.path.abspath(pathname))
    sys.path.append(os.path.normpath(os.path.join(os.path.abspath(pathname), '../')))
    os.environ['DJANGO_SETTINGS_MODULE'] = 'settings'


setup_environment()

from satchmo.contact.models import Order,OrderItem

if __name__=='__main__':

    pending = Order.objects.filter(status="Pending")

    writer = csv.writer(file("pending-orders.csv","wb"))


    cols = ["Name","Address1","Address2","City","State","Zip","Item(s)","Qty","Order Date"]

    writer.writerow(cols)
    for order in pending: #order_info:

        items = [[x.item.id,x.quantity] for x in OrderItem.objects.filter(order__id=order.id)]

        idx=0
        for item in items:
            if idx==0:
                line_item=[order.contact.first_name+" "+order.contact.last_name,order.shipStreet1,order.shipStreet2,order.shipCity,order.shipState,order.shipPostalCode]

            else:
                line_item= ["",]*6

            [line_item.append(x) for x in item]

            if idx==0:
                line_item.append(order.timeStamp)

            writer.writerow(line_item)

            idx+=1