Subversion Repositories SmartDukaan

#!/usr/bin/python

'''

Loads the static logic of assigning provider to a particular pincode

into the DestinationProviderAllocation table.

It reads the logic from a XLS workbook containing two sheets. The first sheet is

for shipments worth less than Rs 5000. The second sheet is for shipments costing

more than Rs 5000.

@attention: This script may need enhancement if we want to differentiate between

COD and Prepaid orders.

@attention: This table is not being used currently. If and when this comes into 

use, please remember to update the logic of get_logistics_estimation 

in DataAccessor.py. 

@author: Ankur Singhal

'''

from datetime import *

from elixir import *

from shop2020.logistics.service.impl import DataService, EcomExpressService

from shop2020.logistics.service.impl.DataService import \

    ServiceableLocationDetails

from shop2020.utils.EmailAttachmentSender import get_attachment_part, mail

import optparse

if __name__ == '__main__' and __package__ is None:

    import sys

    import os

    sys.path.insert(0, os.getcwd())

def main():

    parser = optparse.OptionParser()

    parser.add_option("-H", "--host", dest="hostname",

                  default="localhost",

                  type="string", help="The HOST where the DB server is running",

                  metavar="HOST")

    parser.add_option("-P", "--provider_id", dest="provider_id",

                  default="localhost",

                  type="string", help="The HOST where the DB server is running",

                  metavar="HOST")

    (options, args) = parser.parse_args()

    if len(args) != 0:

        parser.error("You've supplied extra arguments. Are you sure you want to run this program?")

    provider_id = options.provider_id

    hostname = options.hostname

    if provider_id is None or hostname is None:

        parser.error("You've supplied extra arguments. Are you sure you want to run this program?")

    DataService.initialize(dbname='logistics', db_hostname=hostname)

    if provider_id=="49":

        subject = "Tat is missing for Ecom Express active pincodes"

        missingPincodes = []

        serviceabilityPincodeList = EcomExpressService.getServiceablePinCodes(datetime.now()-timedelta(days=5))

        #print "serviceabilityPincodeList", serviceabilityPincodeList

        for serviceabilityPincode in serviceabilityPincodeList:

            pincode = str(serviceabilityPincode["pincode"])

            serviceableLocationDetails = ServiceableLocationDetails.query.filter_by(provider_id=int(provider_id)).filter_by(dest_pincode=pincode).first()

            if serviceableLocationDetails:

                if serviceabilityPincode['active']:

                    serviceableLocationDetails.exp=1

                    serviceableLocationDetails.cod=1

                else:

                    serviceableLocationDetails.exp=0

                    serviceableLocationDetails.cod=0

            elif serviceabilityPincode['active']:

                missingPincodes.append(pincode)

        print missingPincodes

        if missingPincodes:

            subject += " - " + ", ".join(missingPincodes)

            mail("cnc.center@shop2020.in", "5h0p2o2o", ["deena.nath@smartdukaan.com"], subject, text="")

    session.commit()

    session.close()

if __name__ == '__main__':

    main()