| Line 712... |
Line 712... |
| 712 |
def getUserOrders():
|
712 |
def getUserOrders():
|
| 713 |
global i
|
713 |
global i
|
| 714 |
rb = open_workbook(XLS_FILENAME,formatting_info=True)
|
714 |
rb = open_workbook(XLS_FILENAME,formatting_info=True)
|
| 715 |
wb = copy(rb)
|
715 |
wb = copy(rb)
|
| 716 |
worksheet = wb.add_sheet("All Users")
|
716 |
worksheet = wb.add_sheet("All Users")
|
| 717 |
worksheet1 = wb.add_sheet("Suspected Users")
|
717 |
#worksheet1 = wb.add_sheet("Suspected Users")
|
| 718 |
workbook = xlwt.Workbook()
|
718 |
workbook = xlwt.Workbook()
|
| 719 |
sh1 = workbook.add_sheet("All Orders")
|
719 |
sh1 = workbook.add_sheet("All Orders")
|
| 720 |
sh2 = workbook.add_sheet("Flipkart Orders")
|
720 |
sh2 = workbook.add_sheet("Flipkart Orders")
|
| 721 |
|
721 |
|
| 722 |
db=client.Dtr
|
722 |
db=client.Dtr
|
| Line 728... |
Line 728... |
| 728 |
where (lower(u.referrer) not like 'emp%' or u.utm_campaign is not null) and u.activated = 1 and ow.status in ('ORDER_CREATED','DETAIL_CREATED');
|
728 |
where (lower(u.referrer) not like 'emp%' or u.utm_campaign is not null) and u.activated = 1 and ow.status in ('ORDER_CREATED','DETAIL_CREATED');
|
| 729 |
''',)
|
729 |
''',)
|
| 730 |
row = 0
|
730 |
row = 0
|
| 731 |
i=-1
|
731 |
i=-1
|
| 732 |
worksheet.write(row, inc(), 'User Id', boldStyle)
|
732 |
worksheet.write(row, inc(), 'User Id', boldStyle)
|
| 733 |
worksheet1.write(row, i, 'User Id', boldStyle)
|
733 |
#worksheet1.write(row, i, 'User Id', boldStyle)
|
| 734 |
worksheet.write(row, inc(), 'User name', boldStyle)
|
734 |
worksheet.write(row, inc(), 'User name', boldStyle)
|
| 735 |
worksheet1.write(row, i, 'User name', boldStyle)
|
735 |
#worksheet1.write(row, i, 'User name', boldStyle)
|
| 736 |
worksheet.write(row, inc(), 'Order Id', boldStyle)
|
736 |
worksheet.write(row, inc(), 'Order Id', boldStyle)
|
| 737 |
worksheet1.write(row, i, 'Order Id', boldStyle)
|
737 |
#worksheet1.write(row, i, 'Order Id', boldStyle)
|
| 738 |
worksheet.write(row, inc(), 'Created On', boldStyle)
|
738 |
worksheet.write(row, inc(), 'Created On', boldStyle)
|
| 739 |
worksheet1.write(row, i, 'Created On', boldStyle)
|
739 |
#worksheet1.write(row, i, 'Created On', boldStyle)
|
| 740 |
worksheet.write(row, inc(), 'Store Id', boldStyle)
|
740 |
worksheet.write(row, inc(), 'Store Id', boldStyle)
|
| 741 |
worksheet1.write(row, i, 'Store Id', boldStyle)
|
741 |
#worksheet1.write(row, i, 'Store Id', boldStyle)
|
| 742 |
worksheet.write(row, inc(), 'Merchant Order Id', boldStyle)
|
742 |
worksheet.write(row, inc(), 'Merchant Order Id', boldStyle)
|
| 743 |
worksheet1.write(row, i, 'Merchant Order Id', boldStyle)
|
743 |
#worksheet1.write(row, i, 'Merchant Order Id', boldStyle)
|
| 744 |
worksheet.write(row, inc(), 'Product title', boldStyle)
|
744 |
worksheet.write(row, inc(), 'Product title', boldStyle)
|
| 745 |
worksheet1.write(row, i, 'Product title', boldStyle)
|
745 |
#worksheet1.write(row, i, 'Product title', boldStyle)
|
| 746 |
worksheet.write(row, inc(), 'Amount Paid', boldStyle)
|
746 |
worksheet.write(row, inc(), 'Amount Paid', boldStyle)
|
| 747 |
worksheet1.write(row, i, 'Amount Paid', boldStyle)
|
747 |
#worksheet1.write(row, i, 'Amount Paid', boldStyle)
|
| 748 |
worksheet.write(row, inc(), 'Cashback', boldStyle)
|
748 |
worksheet.write(row, inc(), 'Cashback', boldStyle)
|
| 749 |
worksheet1.write(row, i, 'Cashback', boldStyle)
|
749 |
#worksheet1.write(row, i, 'Cashback', boldStyle)
|
| 750 |
worksheet.write(row, inc(), 'Order Status', boldStyle)
|
750 |
worksheet.write(row, inc(), 'Order Status', boldStyle)
|
| 751 |
worksheet1.write(row, i, 'Order Status', boldStyle)
|
751 |
#worksheet1.write(row, i, 'Order Status', boldStyle)
|
| 752 |
worksheet.write(row, inc(), 'Detailed Status', boldStyle)
|
752 |
worksheet.write(row, inc(), 'Detailed Status', boldStyle)
|
| 753 |
worksheet1.write(row, i, 'Detailed Status', boldStyle)
|
753 |
#worksheet1.write(row, i, 'Detailed Status', boldStyle)
|
| 754 |
worksheet.write(row, inc(), 'Cashback Status', boldStyle)
|
754 |
worksheet.write(row, inc(), 'Cashback Status', boldStyle)
|
| 755 |
worksheet1.write(row, i, 'Cashback Status', boldStyle)
|
755 |
#worksheet1.write(row, i, 'Cashback Status', boldStyle)
|
| 756 |
worksheet.write(row, inc(), 'Reconciled', boldStyle)
|
756 |
worksheet.write(row, inc(), 'Reconciled', boldStyle)
|
| 757 |
worksheet1.write(row, i, 'Reconciled', boldStyle)
|
757 |
#worksheet1.write(row, i, 'Reconciled', boldStyle)
|
| 758 |
worksheet.write(row, inc(), 'IP', boldStyle)
|
758 |
worksheet.write(row, inc(), 'IP', boldStyle)
|
| 759 |
worksheet1.write(row, i, 'IP', boldStyle)
|
759 |
#worksheet1.write(row, i, 'IP', boldStyle)
|
| 760 |
worksheet.write(row, inc(), 'Aff Status', boldStyle)
|
760 |
worksheet.write(row, inc(), 'Aff Status', boldStyle)
|
| 761 |
worksheet1.write(row, i, 'Aff Status', boldStyle)
|
761 |
#worksheet1.write(row, i, 'Aff Status', boldStyle)
|
| 762 |
i=-1
|
762 |
i=-1
|
| 763 |
sh1.write(row, inc(), 'User Id', boldStyle)
|
763 |
sh1.write(row, inc(), 'User Id', boldStyle)
|
| 764 |
sh1.write(row, inc(), 'User name', boldStyle)
|
764 |
sh1.write(row, inc(), 'User name', boldStyle)
|
| 765 |
sh1.write(row, inc(), 'Order Id', boldStyle)
|
765 |
sh1.write(row, inc(), 'Order Id', boldStyle)
|
| 766 |
sh1.write(row, inc(), 'Created On', boldStyle)
|
766 |
sh1.write(row, inc(), 'Created On', boldStyle)
|
| Line 874... |
Line 874... |
| 874 |
snapdealafinfo = db.snapdealOrderAffiliateInfo.find_one({"adId":morder.get("adId"), "reconciled":True})
|
874 |
snapdealafinfo = db.snapdealOrderAffiliateInfo.find_one({"adId":morder.get("adId"), "reconciled":True})
|
| 875 |
worksheet.write(row, inc(), snapdealafinfo.get("ip"))
|
875 |
worksheet.write(row, inc(), snapdealafinfo.get("ip"))
|
| 876 |
worksheet.write(row, inc(), snapdealafinfo.get("conversionStatus"))
|
876 |
worksheet.write(row, inc(), snapdealafinfo.get("conversionStatus"))
|
| 877 |
except:
|
877 |
except:
|
| 878 |
print "Could not find", morder.get("adId"), "that is reconciled for order", morder.get("orderId")
|
878 |
print "Could not find", morder.get("adId"), "that is reconciled for order", morder.get("orderId")
|
| 879 |
if result[8] >= 10:
|
879 |
#if result[8] >= 10:
|
| 880 |
row2 +=1
|
880 |
# row2 +=1
|
| 881 |
i=-1
|
881 |
# i=-1
|
| 882 |
worksheet1.write(row2, inc(), result[0])
|
882 |
#worksheet1.write(row2, inc(), result[0])
|
| 883 |
worksheet1.write(row2, inc(), result[7])
|
883 |
#worksheet1.write(row2, inc(), result[7])
|
| 884 |
worksheet1.write(row2, inc(), result[1])
|
884 |
#worksheet1.write(row2, inc(), result[1])
|
| 885 |
worksheet1.write(row2, inc(), result[6], datetime_format)
|
885 |
#worksheet1.write(row2, inc(), result[6], datetime_format)
|
| 886 |
worksheet1.write(row2, inc(), result[2])
|
886 |
#worksheet1.write(row2, inc(), result[2])
|
| 887 |
worksheet1.write(row2, inc(), morder.get("merchantOrderId"))
|
887 |
#worksheet1.write(row2, inc(), morder.get("merchantOrderId"))
|
| 888 |
worksheet1.write(row2, inc(), subOrder.get("productTitle"))
|
888 |
#worksheet1.write(row2, inc(), subOrder.get("productTitle"))
|
| 889 |
worksheet1.write(row2, inc(), subOrder.get("amountPaid"))
|
889 |
#worksheet1.write(row2, inc(), subOrder.get("amountPaid"))
|
| 890 |
worksheet1.write(row2, inc(), subOrder.get("cashBackAmount"))
|
890 |
#worksheet1.write(row2, inc(), subOrder.get("cashBackAmount"))
|
| 891 |
worksheet1.write(row2, inc(), subOrder.get("status"))
|
891 |
#worksheet1.write(row2, inc(), subOrder.get("status"))
|
| 892 |
worksheet1.write(row2, inc(), subOrder.get("detailedStatus"))
|
892 |
#worksheet1.write(row2, inc(), subOrder.get("detailedStatus"))
|
| 893 |
worksheet1.write(row2, inc(), subOrder.get("cashBackStatus"))
|
893 |
#worksheet1.write(row2, inc(), subOrder.get("cashBackStatus"))
|
| 894 |
worksheet1.write(row2, inc(), False if morder.get("reconciled") is None else True)
|
894 |
#worksheet1.write(row2, inc(), False if morder.get("reconciled") is None else True)
|
| 895 |
worksheet1.write(row2, inc(), )
|
895 |
#worksheet1.write(row2, inc(), )
|
| 896 |
if morder.get("reconciled") and morder.get("storeId")==3:
|
896 |
#if morder.get("reconciled") and morder.get("storeId")==3:
|
| 897 |
try:
|
897 |
# try:
|
| 898 |
snapdealafinfo = db.snapdealOrderAffiliateInfo.find_one({"adId":morder.get("adId"), "reconciled":True})
|
898 |
# snapdealafinfo = db.snapdealOrderAffiliateInfo.find_one({"adId":morder.get("adId"), "reconciled":True})
|
| 899 |
worksheet.write(row2, inc(), snapdealafinfo.get("ip"))
|
899 |
# worksheet1.write(row2, inc(), snapdealafinfo.get("ip"))
|
| 900 |
worksheet.write(row2, inc(), snapdealafinfo.get("conversionStatus"))
|
900 |
# worksheet1.write(row2, inc(), snapdealafinfo.get("conversionStatus"))
|
| 901 |
except:
|
901 |
# except:
|
| 902 |
print "Could not find", morder.get("adId"), "that is reconcired for order", morder.get("orderId")
|
902 |
# print "Could not find", morder.get("adId"), "that is reconcired for order", morder.get("orderId")
|
| 903 |
|
903 |
|
| 904 |
flipkartOrders = session.query(FlipkartOrders).order_by(FlipkartOrders.created.desc()).all()
|
904 |
flipkartOrders = session.query(FlipkartOrders).order_by(FlipkartOrders.created.desc()).all()
|
| 905 |
flipkartOrders.reverse()
|
905 |
flipkartOrders.reverse()
|
| 906 |
row3=0
|
906 |
row3=0
|
| 907 |
#try:
|
907 |
#try:
|