Subversion Repositories SmartDukaan

'''
Created on 05-Aug-2010

@author: ashish
'''
import xlwt
from shop2020.clients.LogisticsClient import LogisticsClient

def get_xls_for_today(warehouse):
    book = xlwt.Workbook(encoding="utf8")
    sheet = book.add_sheet("Shipment", True);
    sheet.write(0,0, "No shipments")
    
    
    
    logistics_client = LogisticsClient()
    logistics_client.__start__()
    client = logistics_client.get_client()
    
    shipments = client.getTodaysShipments(int(warehouse), 1)
    
    if shipments:
        #add the headers to the xls file
        sheet.write(0,0, "Shipments for today")
        #headings
        sheet.write(1,0, "AWB")
        sheet.write(1,1, "Origin")
        sheet.write(1,2, "Destination")
        sheet.write(1,3, "Timestamp")
        sheet.write(1,4, "Recepient's Name")
        sheet.write(1,5, "Recepient's Address")
        sheet.write(1,6, "Recepient's Pincode")
        sheet.write(1,7, "Recepient's Phone")
        sheet.write(1,8, "Weight")
        sheet.write(1,9, "Contents")
        sheet.write(1,10, "Warehouse")
        
        i=3
        for shipment in shipments:
            sheet.write(i,0, shipment.awb)
            sheet.write(i,1, shipment.origin)
            sheet.write(i,2, shipment.destination)
            sheet.write(i,3, shipment.timestamp)
            sheet.write(i,4, shipment.recepient_name)
            sheet.write(i,5, shipment.recepient_address)
            sheet.write(i,6, shipment.recepient_pincode)
            sheet.write(i,7, shipment.recepient_phone)
            sheet.write(i,8, shipment.shipment_weight)
            sheet.write(i,9, shipment.shipment_contents)
            sheet.write(i,10, shipment.warehouse_name)
            i = i + 1
    
    book.save("/tmp/worksheet-statemnet.xls")
    
    file = open("/tmp/worksheet-statemnet.xls", 'r').read()
    return file