Subversion Repositories SmartDukaan

def get_orders_for_store(orderId, storeId, startDate, endDate, statuses):

    orders = []

    query = Order.query

    if storeId < 1:

        return orders

    elif orderId > 0:

        query = query.filter(Order.id == orderId)

    else :

        if startDate:

            query = query.filter(cast(Order.created_timestamp, DATE) >= startDate.date())

        if endDate:

            query = query.filter(cast(Order.created_timestamp, DATE) <= endDate.date())

        if len(statuses) > 0:

            query = query.filter(Order.status.in_(statuses))

    orders = query.filter(Order.storeId == storeId).all()

    return orders

def get_store_order_advance_invoice(orderId):

    order = Order.get_by(id = orderId)

    filename = "/tmp/recharge" + str(order.id) + ".pdf"

    product = order.lineitems[0].brand + order.lineitems[0].model_name + order.lineitems[0].model_number + order.lineitems[0].color

    amount = order.advanceAmount

    totalAmount = order.total_amount

    delivery = order.created_timestamp

    customerName = order.customer_name

    #payMethod = recharge.payMethod

    return __printStoreOrderAdvanceInvoice(filename, product, amount, totalAmount, customerName, delivery)

def __printStoreOrderAdvanceInvoice(filename, product, amount, totalAmount, customerName, delivery): 

    PAGE_HEIGHT=defaultPageSize[1];

    styles = getSampleStyleSheet()

    styles.add(ParagraphStyle(name='prologue', alignment=TA_CENTER, fontName="Courier", rightIndent = 5, fontSize=10), alias='sH')

    styles.add(ParagraphStyle(name='text', alignment=TA_JUSTIFY, fontName="Courier", fontSize=10), alias='text')

    styles.add(ParagraphStyle(name='line', alignment=TA_CENTER, fontName="Courier", fontSize=10), alias='line')

    styles.add(ParagraphStyle(name='epilogue', alignment=TA_CENTER, fontName="Courier", leftIndent = 30, rightIndent=36, fontSize=10), alias='ep')

    Story = []

    prologueStyle = styles["prologue"]

    lineStyle = styles["line"]

    textStyle = styles["text"]

    epilogueStyle = styles["epilogue"]

    doc = BaseDocTemplate(filename,showBoundary=0)

    #Two Columns

    frame1 = Frame(58, doc.bottomMargin, doc.width/2 + 25, doc.height + 7, id='col1')

    Story.append(Paragraph("""Spice Retail Limited<br></br>

        C/O,PIBCO LIMITED,Basement,Punjsons<br></br>

        2,Kalkaji Industrial Area,New Delhi<br></br>

          .<br></br>

        TIN NO. 07430284979<br></br>

        Service Tax No:AAACM0294PST001<br></br><br></br><br></br>""", prologueStyle))

    drawLine(Story, lineStyle)

    Story.append(Paragraph("{0:<6s}{1:<34s}".format("NAME:", customerName).replace(" ", "&nbsp;"), textStyle))

    Story.append(Paragraph("{0:<15s}{1:  %d/%m/%Y}".format("EXP DELIVERY:", delivery).replace(" ", "&nbsp;"), textStyle))

    Story.append(Paragraph("{0:<15s}{1:<25s}".format("PAYMENT MODE:", "CARD").replace(" ", "&nbsp;"), textStyle))

    drawLine(Story, lineStyle)

    Story.append(Paragraph("{0:<15s}{1:<25s}".format("PAYMENT MODE:", "CARD").replace(" ", "&nbsp;"), textStyle))

    drawLine(Story, lineStyle)

    Story.append(Paragraph("{0:<39s}".format(product).replace(" ", "&nbsp;"), textStyle))

    drawLine(Story, lineStyle)

    Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("TOTAL PRICE: ", totalAmount).replace(' ', '&nbsp;'),textStyle))

    Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("ADVANCE PAID: ", amount).replace(' ', '&nbsp;'),textStyle))

    drawLine(Story, lineStyle)

    doc.addPageTemplates([PageTemplate(id='TwoCol',frames=[frame1]), ])

    #start the construction of the pdf

    doc.build(Story)

    try:

        fileToSend = open(filename, "rb")

        pdfFile = fileToSend.read()

    except:

        return bin(0)

    return pdfFile