Subversion Repositories SmartDukaan

#!/usr/bin/python

from elixir import *
from datetime import datetime, timedelta, date 
import sys
from shop2020.model.v1.order.impl import DataService
from shop2020.model.v1.order.impl.DataAccessors import move_orders_to_correct_warehouse
from shop2020.model.v1.order.impl.DataService import InsuranceDetailForOrder,\
    Order
import xlwt
from shop2020.utils import EmailAttachmentSender
from shop2020.utils.EmailAttachmentSender import get_attachment_part
from shop2020.thriftpy.model.v1.order.ttypes import OrderStatus
from shop2020.clients.CatalogClient import CatalogClient
    
def delivered_orders():
    DataService.initialize(db_hostname="192.168.190.114")
    todate = datetime.now() 
    todate = todate-timedelta(days = 10)
    insurances = InsuranceDetailForOrder.query.filter(InsuranceDetailForOrder.isDeclared == False).filter(InsuranceDetailForOrder.startDate >= todate).all()
    if not insurances:
        return

    wbk = xlwt.Workbook()
    sheet = wbk.add_sheet('main')

    date_style = xlwt.XFStyle()
    date_style.num_format_str = "D/M/YY"
    
    heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
    sheet.set_panes_frozen(True)
    sheet.set_horz_split_pos(1)
    sheet.set_remove_splits(True)
    
    excel_integer_format = '0'
    integer_style = xlwt.XFStyle()
    integer_style.num_format_str = excel_integer_format

    sheet.write(0, 0, "Riskstartdate", heading_xf)
    sheet.write(0, 1, "StoreId", heading_xf)
    sheet.write(0, 2, "SystemInvoiceNumber", heading_xf)
    sheet.write(0, 3, "CustomerName", heading_xf)
    sheet.write(0, 4, "Type", heading_xf)
    sheet.write(0, 5, "Make", heading_xf)
    sheet.write(0, 6, "Model", heading_xf)
    sheet.write(0, 7, "EquipmentIdentificationNumber", heading_xf)
    sheet.write(0, 8, "Qty", heading_xf)
    sheet.write(0, 9, "Rate", heading_xf)
    sheet.write(0, 10, "TaxAmount", heading_xf)
    sheet.write(0, 11, "NetSales", heading_xf)
    sheet.write(0, 12, "FatherName", heading_xf)
    sheet.write(0, 13, "Birthdate", heading_xf)
    sheet.write(0, 14, "SystemInvoiceDate.", heading_xf)
    sheet.write(0, 15, "OrderId", heading_xf)
    sheet.write(0, 16, "OtherDetails3", heading_xf)
        
    xstr = lambda s: s or ""
    
    declaredAmount= 0.0
    i = 1
    for insurance in insurances:
        order = insurance.order
        if order.status != OrderStatus.DELIVERY_SUCCESS:
            continue
        line = order.lineitems[0]
        insurance.isDeclared = True
        declaredAmount += line.total_price
        
        sheet.write(i, 0, insurance.startDate, date_style)
        sheet.write(i, 1, '')
        sheet.write(i, 2, order.invoice_number)
        sheet.write(i, 3, order.customer_name)
        sheet.write(i, 4, 'Mobile Phones')
        sheet.write(i, 5, line.brand)
        sheet.write(i, 6, xstr(line.model_name) + " " + xstr(line.model_number))
        sheet.write(i, 7, line.serial_number)
        sheet.write(i, 8, line.quantity)
        sheet.write(i, 9, line.unit_price)
        sheet.write(i, 10, "0")
        sheet.write(i, 11, line.total_price)
        sheet.write(i, 12, insurance.guardianName)
        sheet.write(i, 13, insurance.dob)
        sheet.write(i, 14, order.billing_timestamp, date_style)
        sheet.write(i, 15, order.id)
        sheet.write(i, 16, '')        
        i = i + 1
    
    session.commit()
    client = CatalogClient().get_client()
    client.updateInsuranceDeclaredAmount(1, declaredAmount)
        
    today = date.today()
    datestr = str(today.year) + "-" + str(today.month) + "-" + str(today.day)
    filename = "/tmp/insurance-" + datestr + ".xls"
    wbk.save(filename)
    EmailAttachmentSender.mail("cnc.center@shop2020.in", "5h0p2o2o", ["ab@universalinsurance.co.in", "urmila.phadke@universalinsurace.co.in"], "Insurance Details for date " + datestr, "Please find attached insurance details for today.", [get_attachment_part(filename)], ["pramit.singh@shop2020.in","rbuniversal@gmail.com","rajveer.singh@shop2020.in","anupam.singh@shop2020.in","rajneesh.arora@shop2020.in"], [])

def returned_orders():
    DataService.initialize(db_hostname="192.168.190.114")
    todate = datetime.now() 
    todate = todate-timedelta(days = 2)
    orders = Order.query.filter(Order.insurer > 0).filter(Order.received_return_timestamp >= todate).all()
    
    if not orders:
        return

    wbk = xlwt.Workbook()
    sheet = wbk.add_sheet('main')

    date_style = xlwt.XFStyle()
    date_style.num_format_str = "D/M/YY"
    
    heading_xf = xlwt.easyxf('font: bold on; align: wrap on, vert centre, horiz center')
    sheet.set_panes_frozen(True)
    sheet.set_horz_split_pos(1)
    sheet.set_remove_splits(True)
    
    excel_integer_format = '0'
    integer_style = xlwt.XFStyle()
    integer_style.num_format_str = excel_integer_format

    sheet.write(0, 0, "SalesReturnDate", heading_xf)
    sheet.write(0, 1, "SalesReturnNumber", heading_xf)
    sheet.write(0, 2, "CustomerName", heading_xf)
    sheet.write(0, 3, "EquipmentIdentificationNumber", heading_xf)
    sheet.write(0, 4, "SystemInvoiceNumber", heading_xf)
    sheet.write(0, 5, "Rate", heading_xf)
    sheet.write(0, 6, "Amount", heading_xf)
    sheet.write(0, 7, "OrderId", heading_xf)

    xstr = lambda s: s or ""
    
    declaredAmount= 0.0
    i = 1
    for order in orders:
        insurance = order.insuranceDetails[0]
        if not (insurance.startDate or insurance.expiryDate) or insurance.expiryDate < datetime.now():
            continue
        
        line = order.lineitems[0]
        insurance.expiryDate = order.received_return_timestamp
    
        insured_days = ((order.received_return_timestamp).date() - ((insurance.startDate).date())).days 
        
        declaredAmount += line.total_price/365*(365-insured_days)
        
        sheet.write(i, 0, insurance.startDate, date_style)
        sheet.write(i, 1, order.invoice_number)
        sheet.write(i, 2, order.customer_name)
        sheet.write(i, 3, line.serial_number)
        sheet.write(i, 4, order.invoice_number)
        sheet.write(i, 5, line.unit_price)
        sheet.write(i, 6, line.unit_price)
        sheet.write(i, 7, order.id)
        i = i + 1
    
    session.commit()
    client = CatalogClient().get_client()
    client.updateInsuranceDeclaredAmount(1, -declaredAmount)
        
    today = date.today()
    datestr = str(today.year) + "-" + str(today.month) + "-" + str(today.day)
    filename = "/tmp/insurance-return-" + datestr + ".xls"
    wbk.save(filename)
    EmailAttachmentSender.mail("cnc.center@shop2020.in", "5h0p2o2o", ["ab@universalinsurance.co.in", "urmila.phadke@universalinsurace.co.in"], "Cancelled Insurance Policy Details for date " + datestr, "Please find attached orders which insurance need to be cancelled for today.", [get_attachment_part(filename)], ["pramit.singh@shop2020.in","rbuniversal@gmail.com","rajveer.singh@shop2020.in","anupam.singh@shop2020.in","rajneesh.arora@shop2020.in"], [])
   
def main():
    delivered_orders()
    returned_orders()
    
if __name__ == '__main__':
    main()