Subversion Repositories SmartDukaan

        yester5date = date.today() - timedelta(1)

            yester5date = date.today() - timedelta(delta)

        syester5date = yester5date.strftime('%Y-%m-%d')

            syester5date = yester5date.strftime('%Y-%m-%d')

        self.db.flipkartOrderAffiliateInfo.find({"saleDate":syester5date})

            self.db.flipkartOrderAffiliateInfo.find({"saleDate":syester5date})

        for order in self.db.flipkartOrderAffiliateInfo.find({"saleDate":syester5date}):

            for order in self.db.flipkartOrderAffiliateInfo.find({"saleDate":syester5date}):

            userId = None

                userId = None

            subTagId = None

                subTagId = None

            email = None

                email = None

            subTagId = order.get("subTagId")

                subTagId = order.get("subTagId")

            if subTagId:

                if subTagId:

                click = session.query(Clicks).filter_by(tag = subTagId).first()

                    click = session.query(Clicks).filter_by(tag = subTagId).first()

                if click is not None:

                    if click is not None:

                    userId= click.user_id 

                        userId= click.user_id 

                    user = session.query(Users.email).filter_by(id = userId).first()

                        user = session.query(Users.email).filter_by(id = userId).first()

                    if user is not None:

                        if user is not None:

                        email = user.email

                            email = user.email

            flipkartOrder = FlipkartOrders()

                flipkartOrder = FlipkartOrders()

            flipkartOrder.user_id = userId

                flipkartOrder.user_id = userId

            flipkartOrder.identifier = order.get("identifier")

                flipkartOrder.identifier = order.get("identifier")

            flipkartOrder.email = email

                flipkartOrder.email = email

            flipkartOrder.subtagId = order.get("subTagId")

                flipkartOrder.subtagId = order.get("subTagId")

            flipkartOrder.created = datetime.strptime(order.get("saleDate"), "%Y-%m-%d")

                flipkartOrder.created = datetime.strptime(order.get("saleDate"), "%Y-%m-%d")

            flipkartOrder.status = order.get("conversionStatus")

                flipkartOrder.status = order.get("conversionStatus")

            flipkartOrder.title = order.get("productTitle")

                flipkartOrder.title = order.get("productTitle")

            flipkartOrder.price = order.get("price")

                flipkartOrder.price = order.get("price")

            flipkartOrder.quantity = order.get("quantity")

                flipkartOrder.quantity = order.get("quantity")

            flipkartOrder.productCode = order.get("productCode")

                flipkartOrder.productCode = order.get("productCode")

            skuData = getSkuData(2, order.get("productCode"))

                skuData = getSkuData(2, order.get("productCode"))

            if skuData is not None:

                if skuData is not None:

                flipkartOrder.catalogId = skuData.get("skuBundleId")

                    flipkartOrder.catalogId = skuData.get("skuBundleId")

                flipkartOrder.brand = skuData.get("brand")

                    flipkartOrder.brand = skuData.get("brand")

                flipkartOrder.model = skuData.get("model_name")

                    flipkartOrder.model = skuData.get("model_name")

                flipkartOrder.category = categoryMap.get(skuData.get("category_id"))

                    flipkartOrder.category = categoryMap.get(skuData.get("category_id"))

                flipkartOrder.title =skuData.get("source_product_name")

                    flipkartOrder.title =skuData.get("source_product_name")

        session.commit()

            session.commit()