Exemple #1
0
    def handle(self, *args, **options):

        microsoft_customers = '/tmp/customers.json'

        migration_csvs = os.path.join(settings.BASE_DIR, 'migrations')
        order_csv = os.path.join(migration_csvs, 'orders.csv')

        microsoft_customers = '/tmp/customers.json'
        existing_microsoft_domains = os.path.join(migration_csvs,
                                                  'microsoft_domains.csv')

        m = MicrosoftBase()
        headers = m.getAccessHeaders()
        """headers = {
            'Authorization': 'Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6InowMzl6ZHNGdWl6cEJmQlZLMVRuMjVRSFlPMCIsImtpZCI6InowMzl6ZHNGdWl6cEJmQlZLMVRuMjVRSFlPMCJ9.eyJhdWQiOiJodHRwczovL2dyYXBoLndpbmRvd3MubmV0IiwiaXNzIjoiaHR0cHM6Ly9zdHMud2luZG93cy5uZXQvN2MyNjFhMTktM2VmZS00ZTZjLTg5ZGEtZDBlNmVhOTc0MzZkLyIsImlhdCI6MTQ5NTA2Nzc5NSwibmJmIjoxNDk1MDY3Nzk1LCJleHAiOjE0OTUwNzE2OTUsImFpbyI6IlkyWmdZT0N1MVh0NVdlS2Q0Y2RKTHNhRyszNGxBQUE9IiwiYXBwaWQiOiI5MzFhYTEzNy1mOGQ4LTQ3ZWMtYjZmNS04Y2ZlNzQ5ZWEyOGEiLCJhcHBpZGFjciI6IjEiLCJpZHAiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC83YzI2MWExOS0zZWZlLTRlNmMtODlkYS1kMGU2ZWE5NzQzNmQvIiwib2lkIjoiODk5YTg4NTUtMWU0Mi00OTVkLThlOTEtOGI0ODFkYTc3M2JkIiwicm9sZXMiOlsiRGlyZWN0b3J5LlJlYWQuQWxsIiwiRGlyZWN0b3J5LlJlYWRXcml0ZS5BbGwiLCJEb21haW4uUmVhZFdyaXRlLkFsbCJdLCJzdWIiOiI4OTlhODg1NS0xZTQyLTQ5NWQtOGU5MS04YjQ4MWRhNzczYmQiLCJ0aWQiOiI3YzI2MWExOS0zZWZlLTRlNmMtODlkYS1kMGU2ZWE5NzQzNmQiLCJ1dGkiOiJLTFZHMThwNHBreTFnaGxCS1I4Q0FBIiwidmVyIjoiMS4wIn0.oW6di_XNbT_ZQWNXWvVp0UaavkGg_JEQany5jog5ETeM_xWaRhAdv2L20FIIQ0H82N4yiHKZGG0N_VuYxU6_-jB4uckv6Y3n2KJnt2tpNtdJlZgbf3mSgLyP4gkOTkMFdRBW_swYAvnU03ZyTCN-eQxoV3n5S0eQkkrm8nCIEA1wcpwo7IWwTswKxIyIq44yM1PxjeIvHBp6P7IBP4Y8rDBaz0dZOWN_J4lpDi2Kr9v0VsGeHbgfkV8Ra3pj8q3uSoGZfe5iZ5yI_mki8JELMFsoMkO02v8-WfUiy_Fq6vkJwGI-0DmgWkX0nwvMsTPjSmInWbYApxvbFnX8_hJvpw',
            'Accept': 'application/json',
            'Content-Type': 'application/json'
        }"""

        customers = json.load(open('/tmp/customer_map.json', 'r'))

        processed_orders = json.load(open('/tmp/orders.json', 'r'))

        with open(order_csv, 'r', encoding='latin1') as csvfile:
            for row in reversed(list(csv.reader(csvfile))):
                order_status = row[6]
                if order_status == 'Provision':
                    customer = None
                    try:
                        customer = Customers.objects.get(pk=customers[row[1]])
                    except:
                        print("Could not find Customer for %s" % (row[1], ))
                        continue

                    # Handle only msft for now
                    vendor = row[11]
                    if vendor == 'MICROSOFT' or vendor == 'Office':
                        if not row[17]:
                            print("Could not find order for order: %s " %
                                  (row[2], ))
                            continue

                        if row[17] == 'Microsoft Azure':
                            print("Azure Order: %s" % (row[2], ))
                            pass  # Skip for now
                        else:
                            if row[2] in processed_orders:
                                continue  # Skip as its already processed

                            print("Processing Order: %s" % (row[2], ))
                            cloud_account_object = CloudAccounts.objects.filter(
                                customer=customer,
                                type='MS',
                                vendor=VendorDetails.objects.get(pk=4))
                            if not cloud_account_object:
                                print(
                                    "Could not find Cloud Account for order: %s"
                                    % (row[2], ))
                                continue

                            cloud_account = cloud_account_object.first()
                            if 'tenant_id' not in cloud_account.details:
                                print(
                                    "Could not find domain name for Order: %s, Check with Redington"
                                    % (row[2], ))
                                continue

                            tenant_id = cloud_account.details['tenant_id']

                            url = str.format(
                                'https://api.partnercenter.microsoft.com/v1/customers/{}/subscriptions',
                                tenant_id)

                            subscriptions_out = requests.get(url,
                                                             headers=headers)

                            if subscriptions_out.status_code == 401:
                                # Reprocess
                                m = MicrosoftBase()
                                headers = m.getAccessHeaders()
                                subscriptions_out = requests.get(
                                    url, headers=headers)

                            if subscriptions_out.status_code == 200:
                                subscriptions = json.loads(
                                    codecs.decode(subscriptions_out.content,
                                                  'utf-8-sig'))
                                items = subscriptions['items']
                                subscription_available = False
                                for item in items:
                                    if item['offerName'] == row[17]:
                                        # Insert into Orders, ordersItems and subscriptions
                                        subscription_available = True

                                        # Check if Order placed, then insert into items
                                        existing_order = Orders.objects.filter(
                                            order_number=row[2])
                                        if existing_order:
                                            # Get Order Reference
                                            order_pk = existing_order[0].pk
                                        else:
                                            # Insert into Order
                                            order = Orders()
                                            order.order_number = row[2]
                                            order.pk = int(row[2][3:])
                                            order.status = 6
                                            order.partner = customer.partner
                                            order.customer = customer
                                            order.vendor = VendorDetails.objects.get(
                                                pk=4)
                                            order.total_cost = 0
                                            try:
                                                dateVal = datetime.datetime.strptime(
                                                    row[4], '%d/%m/%y')
                                            except:
                                                dateVal = datetime.datetime.strptime(
                                                    row[4], '%d/%m/%Y')
                                            order.created_at = dateVal
                                            order.created_by = PartnerUserDetails.objects.filter(
                                                partner=customer.partner
                                            )[0].user
                                            order.billing_type = item[
                                                'billingCycle']
                                            if order.billing_type == 'monthly':
                                                order.billing_completed = 0
                                            else:
                                                order.billing_completed = 1
                                            order.modified_by_id = PartnerUserDetails.objects.filter(
                                                partner=customer.partner
                                            )[0].user.pk

                                            order.save()
                                            order_pk = order.pk

                                        # Insert into Order Items
                                        orderItem = OrderItems()
                                        orderItem.order = Orders.objects.get(
                                            pk=order_pk)
                                        orderItem.product = Products.objects.get(
                                            pk=4)
                                        orderItem.quantity = item['quantity']
                                        orderItem.discount = 0  # Check with Redington
                                        orderItem.price_per_unit = row[15]
                                        orderItem.cost = float(
                                            item['quantity']) * float(row[15])
                                        try:
                                            dateVal = datetime.datetime.strptime(
                                                row[4], '%d/%m/%y')
                                        except:
                                            dateVal = datetime.datetime.strptime(
                                                row[4], '%d/%m/%Y')
                                        orderItem.created_at = dateVal
                                        orderItem.created_by = PartnerUserDetails.objects.filter(
                                            partner=customer.partner)[0].user
                                        orderItem.modified_by_id = PartnerUserDetails.objects.filter(
                                            partner=customer.partner
                                        )[0].user.pk
                                        orderItem.save()

                                        # Insert into Subscription
                                        subscription = Subscriptions()
                                        subscription.customer = customer
                                        subscription.order = Orders.objects.get(
                                            pk=order_pk)
                                        subscription.product = Products.objects.get(
                                            pk=4)
                                        subscription.subscription = item['id']
                                        subscription.creation_date = parse_datetime(
                                            item['creationDate'])
                                        subscription.ms_order_id = item[
                                            'orderId']
                                        subscription.name = item['offerName']
                                        subscription.quantity = item[
                                            'quantity']
                                        subscription.unit_type = item[
                                            'unitType']
                                        subscription.effective_start_date = parse_datetime(
                                            item['effectiveStartDate'])
                                        subscription.commitment_end_date = parse_datetime(
                                            item['commitmentEndDate'])
                                        subscription.auto_renew_enabled = item[
                                            'autoRenewEnabled']
                                        subscription.status = item['status']
                                        subscription.is_trial = item['isTrial']
                                        subscription.billing_type = item[
                                            'billingType']
                                        subscription.billing_cycle = item[
                                            'billingCycle']
                                        subscription.contract_type = item[
                                            'contractType']
                                        subscription.save()

                                        processed_orders[row[2]] = order_pk
                                        json.dump(
                                            processed_orders,
                                            open('/tmp/orders.json', 'w')
                                        )  # Write back for further process

                                if not subscription_available:
                                    pprint.pprint(
                                        "Couldnt find subscription: %s for: %s and order: %s"
                                        % (row[17], tenant_id, row[2]))
                                    continue
                            else:
                                pprint.pprint(
                                    "No subscriptions found for %s for order %s"
                                    % (tenant_id, row[2]))
                                continue
                    else:
                        # Handle other vendors  (Amazon)
                        pass