Subversion Repositories SmartDukaan

import sys

import os

import datetime 

import time

from datetime import date

from textwrap import dedent

from sqlalchemy.sql import func

from elixir import *

from reportlab.pdfgen.canvas import Canvas

from reportlab.rl_config import defaultPageSize

from reportlab.lib.units import inch

PAGE_HEIGHT=defaultPageSize[1]

PAGE_WIDTH=defaultPageSize[0]

from shop2020.utils.EmailAttachmentSender import mail, get_attachment_part

def toggle_doa_flag(order_id):

    order = get_order(order_id)

    if(order.doaFlag):

        order.doaFlag = False

    else:

        order.doaFlag = True

    session.commit()

    return order.doaFlag

def request_pickup_number(order_id):

    order = get_order(order_id)

    if order.status != OrderStatus.DELIVERY_SUCCESS and order.status != OrderStatus.DOA_PICKUP_REQUESTED:

        return False

    from_user = 'cnc.center@shop2020.in'

    from_pwd = '5h0p2o2o'

    subject = "Pickup request"

    try:

        catalog_client = InventoryClient().get_client()

        warehouse = catalog_client.getWarehouse(order.warehouse_id)

        logistics_client = LogisticsClient().get_client()

        provider = logistics_client.getProvider(order.logistics_provider_id)

        to_addr = provider.email

        raw_message = '''

        Dear Sir/Madam,

        Kindly arrange a pickup today from Pune, Pickup and delivery address are mentioned below.

        Pickup CODE: %(provider_code)s

        Total Weight: %(order_weight)s kg

        Pickup Address

        %(customer_address)s

        Delivery Address:

        %(warehouse_executive)s

        %(warehouse_address)s

        PIN %(warehouse_pin)s

        Phone: %(warehouse_phone)s

        Thanks and Regards

        Anand Sinha

        '''

        message = dedent(raw_message) % { 'provider_code' : provider.accountNo,

                                          'order_weight' : str(order.total_weight),

                                          'customer_address' : __get_order_address(order),

                                          'warehouse_executive' : 'Parmod Kumar',

                                          'warehouse_address' : warehouse.location,

                                          'warehouse_pin' : warehouse.pincode,

                                          'warehouse_phone': '9971573026'}

        mail(from_user, from_pwd, to_addr, subject, message)

        order.status = OrderStatus.DOA_PICKUP_REQUESTED

        order.statusDescription = "Pick up requested for DOA"

        session.commit()

        return True

    except Exception as e:

        print sys.exc_info()[0]

        return False

def authorize_pickup(order_id, pickup_number):

    order = get_order(order_id)

    if order.status != OrderStatus.DOA_PICKUP_REQUESTED:

        return False

    from_user = 'help@shop2020.in'

    from_pwd = '5h0p2o2o'

    subject = 'Pickup details'

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

    try:

        catalog_client = InventoryClient().get_client()

        warehouse = catalog_client.getWarehouse(order.warehouse_id)

        logistics_client = LogisticsClient().get_client()

        provider = logistics_client.getProvider(order.logistics_provider_id)

        provider_name = provider.name

        to_addr = order.customer_email

        today = date.today().strftime("%d-%B-%Y (%A)")

        raw_message = '''

        Dear Mr. %(customer_name)s,

        In reference to the return of order ID %(order_id)d. We request you to kindly pack the box properly with bubble wrap, and send it along with the original "DOA" certificate and the invoice.

        Take a printout of the attachment in this mail which contains the delivery address and paste it on the packed parcel.

        We have instructed %(provider_name)s to pick up the material from the below mentioned address on %(date)s. %(provider_name)s pickup request number is %(pickup_request_no)s. Kindly keep the parcel ready.

        Pickup will happen from the below mentioned address:-

        %(customer_address)s

        Do let us know in case of any concerns

        Thanks & Regards

        Saholic Team

        '''

        message = dedent(raw_message) % {'customer_name' : order.customer_name,

                                         'order_id' : order_id,

                                         'provider_name' : provider_name,

                                         'date': today,

                                         'pickup_request_no' : pickup_number,

                                         'customer_address' : __get_order_address(order)}

        print message

        __generate_return_advice(order, warehouse, provider, filename)

        mail(from_user, from_pwd, to_addr, subject, message, get_attachment_part(filename))

        order.pickupRequestNo = pickup_number

        order.status = OrderStatus.DOA_RETURN_AUTHORIZED

        order.statusDescription = "DOA pick up authorized"

        session.commit()

        return True

    except Exception as e:

        print sys.exc_info()[0]

        return False

    finally:

        if os.path.exists(filename):

            os.remove(filename)

def __get_order_address(order):

    address = order.customer_name + "\n" + order.customer_address1 + "\n"

    if order.customer_address2:

        address = address + order.customer_address2 + "\n"

    address = address + order.customer_city + "\n"

    address = address + order.customer_state + "\n"

    address = address + "PIN " + order.customer_pincode + "\n"

    address = address + "Phone: " + order.customer_mobilenumber

    return address

def __generate_return_advice(order, warehouse, provider, filename):    

    pdf = Canvas(filename)

    pdf.setFont('Times-Bold',16)

    address_text = pdf.beginText(inch, PAGE_HEIGHT - inch)

    address_text.textLine("To")

    address_text.textLine("Parmod Kumar")

    for line in warehouse.location.split("\n"):

        address_text.textLine(line)

    address_text.textLine("PIN " + warehouse.pincode)

    address_text.textLine("")

    address_text.textLine("Phone: 9971573026")

    pdf.drawText(address_text)

    pdf.setFont('Times-Roman',12)

    order_text = pdf.beginText(inch, PAGE_HEIGHT - 4 * inch)

    order_text.textLine("Pickup CODE: " + provider.accountNo)

    lineitem = order.lineitems[0] 

    order_text.textLine("Content : " + lineitem.brand + " " + lineitem.model_number + " " + lineitem.color)

    order_text.textLine("Declared Value: Rs. " + str(order.total_amount))

    order_text.textLine("Order ID : " + str(order.id))

    pdf.drawText(order_text)

    pdf.showPage()

    pdf.save()

    return filename