Subversion Repositories SmartDukaan

Rev

Rev 14699 | Rev 14740 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 14699 Rev 14739
Line 589... Line 589...
589
                        if morder.get("reconciled") and morder.get("storeId")==3:
589
                        if morder.get("reconciled") and morder.get("storeId")==3:
590
                            try:
590
                            try:
591
                                worksheet.write(row, inc(), db.snapdealOrderAffiliateInfo.find_one({"adId":morder.get("adId"), "reconciled":True}).get("ip"))
591
                                worksheet.write(row, inc(), db.snapdealOrderAffiliateInfo.find_one({"adId":morder.get("adId"), "reconciled":True}).get("ip"))
592
                            except:
592
                            except:
593
                                print "Could not find", morder.get("adId"), "that is reconcired for order", morder.get("orderId")
593
                                print "Could not find", morder.get("adId"), "that is reconcired for order", morder.get("orderId")
594
                        
594
                        referrer = result[-1].lower()
595
                        if result[-2] >= 10 and result[-1].lower().startswith("crm"):
595
                        if result[-2] >= 10 and (referrer.startswith("crm") or referrer.startswith("fos") or referrer=''):
596
                            row2 +=1 
596
                            row2 +=1 
597
                            i=-1
597
                            i=-1
598
                            worksheet1.write(row2, inc(), result[0])
598
                            worksheet1.write(row2, inc(), result[0])
599
                            worksheet1.write(row2, inc(), result[-3])
599
                            worksheet1.write(row2, inc(), result[-3])
600
                            worksheet1.write(row2, inc(), result[1])
600
                            worksheet1.write(row2, inc(), result[1])