Subversion Repositories SmartDukaan

'''

Created on 22-Jun-2012

This script fetches the scan mismatches as per the invoices received

and sends an email to concerned people.

@author: mandeep

'''

from optparse import OptionParser

from shop2020.clients.WarehouseClient import WarehouseClient

from shop2020.utils import EmailAttachmentSender

from shop2020.utils.Utils import to_java_date

import datetime

def generateScanMismatches(date):

    warehouseClient = WarehouseClient().get_client()

    return warehouseClient.fetchScansPerInvoiceNumber(to_java_date(datetime.datetime.strptime(date, '%Y-%m-%d')))

def reportMismatches(mismatches, date):

    body = ["\t".join(['Date', 'Invoice Number', 'Supplier', 'No. of Items as per Invoice', 'No. of Items actually scanned'])]

    unscannedCount = 0

    for invoiceScan in mismatches:

        body.append("\t".join([date, invoiceScan.invoiceNumber, invoiceScan.supplierName, str(invoiceScan.numItems), str(invoiceScan.scannedQuantity)]))

        unscannedCount += invoiceScan.numItems - invoiceScan.scannedQuantity

    subject = date + ': All items scanned IN!'

    if body.__len__() > 1:

        subject = date + ': ' + str(abs(unscannedCount))

        if unscannedCount > 0:

            subject += ' items not scanned IN yet'

        else:

            subject += ' extra items got scanned IN'

    EmailAttachmentSender.mail('cnc.center@shop2020.in', '5h0p2o2o', ['mandeep.dhir@shop2020.in', 'amit.kumar@shop2020.in', 'ashutosh.saxena@shop2020.in', 'sandeep.sachdeva@shop2020.in','amar.kumar@shop2020.in'], subject, "\n".join(body))

def generateAndReportScanMismatches(date):

    reportMismatches(generateScanMismatches(date), date)

def main():

    parser = OptionParser()

    parser.add_option("-d", "--date", dest="date", default = datetime.date.today().isoformat(), type='string', help='date in YYYY-MM-DD format')

    (options, args) = parser.parse_args()

    generateAndReportScanMismatches(options.date)

if __name__ == '__main__':

    main()