Subversion Repositories SmartDukaan

Rev

Rev 412 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

'''
Created on 05-Aug-2010

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

def get_html_page():
    a = '''<html>
            <head>
            <meta content="text/html; charset=ISO-8859-1"
            http-equiv="content-type">
            <title>Logistics Dashbaord</title>
            </head>
            <body>
            <h2>Aramex dashboard<br>
            </h2>
            <br>
            <hr style="width: 100%; height: 2px;">
            <h3>Package related links</h3>
            <ol>
            <li><a href="/list">Get today's packages</a></li>
            </ol>
            </body>
            </html>'''
    return a
            

def get_sample_xml():
    xml = open("/tmp/AWB_Track.xml", 'r').read()
    return xml

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