WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/purchase/main/script/PendingPurchaseOrderReport.py



    worksheet.write(row, inc(), 'Additional Qty', boldStyle)
    worksheet.write(row, inc(), 'Errors', boldStyle)
    
    
    purchaseHandler = PurchaseHandler()
    pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7573)
    print errorsMap
    print pendingPurchaseOrders
    
    for itemId, error in errorsMap.items():
        row += 1

            if errorsMap.has_key(lineitem.get('itemId')):
                error = errorsMap.get(lineitem.get('itemId'))
            worksheet.write(row, inc(), error)
    wb.save(XLS_O_FILENAME)
    
    sendmail(["amit.gupta@shop2020.in", "ritesh.chauhan@shop2020.in", "rahul.kandpal@profitmandi.com"], "", "All Pending Purchase Orders", XLS_O_FILENAME)
    #sendmail(["manish.sharma@shop2020.in"], "", "All Pending Purchase Orders", XLS_O_FILENAME)
 
if __name__ == '__main__':
    main()

Rev 23124	Rev 23240
Line 433...	Line 433...
433	`worksheet.write(row, inc(), 'Additional Qty', boldStyle)`	433	`worksheet.write(row, inc(), 'Additional Qty', boldStyle)`
434	`worksheet.write(row, inc(), 'Errors', boldStyle)`	434	`worksheet.write(row, inc(), 'Errors', boldStyle)`
435		435
436		436
437	`purchaseHandler = PurchaseHandler()`	437	`purchaseHandler = PurchaseHandler()`
438	`pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7441)`	438	`pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7573)`
439	`print errorsMap`	439	`print errorsMap`
440	`print pendingPurchaseOrders`	440	`print pendingPurchaseOrders`
441		441
442	`for itemId, error in errorsMap.items():`	442	`for itemId, error in errorsMap.items():`
443	`row += 1`	443	`row += 1`
Line 515...	Line 515...
515	`if errorsMap.has_key(lineitem.get('itemId')):`	515	`if errorsMap.has_key(lineitem.get('itemId')):`
516	`error = errorsMap.get(lineitem.get('itemId'))`	516	`error = errorsMap.get(lineitem.get('itemId'))`
517	`worksheet.write(row, inc(), error)`	517	`worksheet.write(row, inc(), error)`
518	`wb.save(XLS_O_FILENAME)`	518	`wb.save(XLS_O_FILENAME)`
519		519
520	`sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "ritesh.chauhan@shop2020.in", "muvin.khan@shop2020.in", "khushal.bhatia@saholic.com"], "", "All Pending Purchase Orders", XLS_O_FILENAME)`	520	`sendmail(["amit.gupta@shop2020.in", "ritesh.chauhan@shop2020.in", "rahul.kandpal@profitmandi.com"], "", "All Pending Purchase Orders", XLS_O_FILENAME)`
521	`#sendmail(["manish.sharma@shop2020.in"], "", "All Pending Purchase Orders", XLS_O_FILENAME)`	521	`#sendmail(["manish.sharma@shop2020.in"], "", "All Pending Purchase Orders", XLS_O_FILENAME)`
522		522
523	`if __name__ == '__main__':`	523	`if __name__ == '__main__':`
524	`main()`	524	`main()`

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/purchase/main/script/PendingPurchaseOrderReport.py – Rev 23124 → 23240