コード例 #1
0
def get_project_list_data():
    project_list = dict()
    status = 200
    project_names = []

    try:
        log.info('In Project List Data ----')

        projects = get_distinct_projects()
        cost_center_projects = set_global_cost_center_list()

        for (project) in projects:
            for center in cost_center_projects:
                center_data = json.loads(json.dumps(center, cls=AlchemyEncoder))
                if project[0] == center_data['project_id']:
                    project_list[project[0]] = center_data['project_name']
                elif project[0] not in project_list:
                    project_list[project[0]] = project[0]

        for (id, names) in project_list.iteritems():
            project_names.append(names)
    except Exception as e:
        log_error(e[0])
        status = 500
        project_list['message'] = str(e[0])

    response = dict(data=project_names, status=status)

    return response
コード例 #2
0
def get_costs_per_center_year(year, center):
    data = {}
    log.info('get_costs_per_CENTER_YEAR_month == {0} --{1}'.format(year,center))
    log_output(year)
    log_output(center)
    try:
        project_list_local = project_list_per_center(center)['list']
        project_ids = project_list_per_center(center)['ids']

        log_output('Project_list_local')
        log_output(project_list_local)

        query_data = get_billing_data_per_year_per_center(str(year), project_ids)
        log_output(query_data)

        log.info('get_billing_data_per_year_per_center == {0}'.format(query_data))
        usage_data = get_per_month_cost(query_data)

        data = {
            'usage_data': usage_data,
            'project_list': project_list_local
        }
    except Exception as e:
        log_error(e)
        log.info(e)
    return data
コード例 #3
0
def get_project_list_data():
    project_list = dict()
    status = 200
    project_names = []

    try:
        log.info('In Project List Data ----')

        projects = get_distinct_projects()
        cost_center_projects = set_global_cost_center_list()

        for (project) in projects:
            for center in cost_center_projects:
                center_data = json.loads(json.dumps(center, cls=AlchemyEncoder))
                if project[0] == center_data['project_id']:
                    project_list[project[0]] = center_data['project_name']
                elif project[0] not in project_list:
                    project_list[project[0]] = project[0]

        for (id, names) in project_list.iteritems():
            project_names.append(names)
    except Exception as e:
        log_error(e[0])
        status = 500
        project_list['message'] = str(e[0])

    response = dict(data=project_names, status=status)

    return response
コード例 #4
0
def get_costs_per_resource_month_center(year, month, center, project):
    project_json = {}

    try:
        project_data = []
        resource_list = []
        query_data = get_billing_data_per_resource_month_center(str(year), str(month), str(project))
        log_output(query_data)

        for (resource, cost) in query_data:
            each_project = {'name': resource, 'cost': float(cost)}
            resource_list.append(resource)
            project_data.append(each_project)

        resource_list_local = resource_list_per_project(center, project)

        project_list_local = project_list_per_center(center)['list']

        project_json = {
            'usage_data': project_data,
            'resource_list': resource_list_local,
            'project_list': project_list_local
        }
    except Exception as e:
        log_error(e)
    return project_json
コード例 #5
0
def get_costs_per_resource_all_project_per_day_week(year, week, center, resource, output_type):
    log.info('get_costs_per_resource_all_project_per_day_week == {0}--{1} --{2} --{3}--{4} '.format(year, week, center,
                                                                                                    resource,
                                                                                                    output_type))
    resource_json = dict()
    day_data = dict()
    status = 200

    try:
        project_list_local = project_list_per_center(center)['list']
        project_list_ids = project_list_per_center(center)['ids']
        resource_list_local = resource_list_per_project(center, None)

        query_data = get_billing_data_per_resource_all_project_per_day_week(str(year), str(week), project_list_ids,
                                                                            str(resource), output_type)
        log_output(query_data)

        if output_type == 'day':
            day_data = get_per_day_data(query_data)
        elif output_type == 'week':
            day_data['usage_data'] = get_week_data(query_data, year, None)
            day_data['d3_json'] = []

        resource_json = {'usage_data': day_data['usage_data'], 'd3_json': day_data['d3_json'],
                         'project_list': project_list_local,
                         'resource_list': resource_list_local}

    except Exception as e:
        log_error(e[0])
        status = 500
        resource_json['message'] = str(e[0])

    response = dict(data=resource_json, status=status)

    return response
コード例 #6
0
def get_costs_year(year, output_type):
    data = dict()
    usage_data = []
    status = 200

    log.info(' In get_costs_year == {0} -- {1}'.format(year, output_type))
    try:
        query_data = get_billing_data_per_year(str(year), output_type)
        log_output(query_data)
        data = {
            'usage_data': usage_data
        }

        if output_type == 'month':
            usage_data = get_per_month_cost(query_data, None, year)
            data['usage_data'] = usage_data
        elif output_type == 'week' or output_type == 'quarter':
            usage_data = get_usage_data(query_data)
            data['usage_data'] = usage_data
        elif output_type == 'day':
            day_data = get_per_day_data(query_data)
            data['usage_data'] = day_data['usage_data']
            data['d3_json'] = day_data['d3_json']

    except Exception as e:
        log_error(e[0])
        status = 500
        data['message'] = str(e[0])

    response = dict(data=data, status=status)

    return response
コード例 #7
0
def get_costs_year(year, output_type):
    data = dict()
    usage_data = []
    status = 200

    log.info(' In get_costs_year == {0} -- {1}'.format(year, output_type))
    try:
        query_data = get_billing_data_per_year(str(year), output_type)
        log_output(query_data)
        data = {
            'usage_data': usage_data
        }

        if output_type == 'month':
            usage_data = get_per_month_cost(query_data, None, year)
            data['usage_data'] = usage_data
        elif output_type == 'week' or output_type == 'quarter':
            usage_data = get_usage_data(query_data)
            data['usage_data'] = usage_data
        elif output_type == 'day':
            day_data = get_per_day_data(query_data)
            data['usage_data'] = day_data['usage_data']
            data['d3_json'] = day_data['d3_json']

    except Exception as e:
        log_error(e[0])
        status = 500
        data['message'] = str(e[0])

    response = dict(data=data, status=status)

    return response
コード例 #8
0
def get_costs_per_resource_all_project_per_day_week(year, week, center, resource, output_type):
    log.info('get_costs_per_resource_all_project_per_day_week == {0}--{1} --{2} --{3}--{4} '.format(year, week, center,
                                                                                                    resource,
                                                                                                    output_type))
    resource_json = dict()
    day_data = dict()
    status = 200

    try:
        project_list_local = project_list_per_center(center)['list']
        project_list_ids = project_list_per_center(center)['ids']
        resource_list_local = resource_list_per_project(center, None)

        query_data = get_billing_data_per_resource_all_project_per_day_week(str(year), str(week), project_list_ids,
                                                                            str(resource), output_type)
        log_output(query_data)

        if output_type == 'day':
            day_data = get_per_day_data(query_data)
        elif output_type == 'week':
            day_data['usage_data'] = get_week_data(query_data, year, None)
            day_data['d3_json'] = []

        resource_json = {'usage_data': day_data['usage_data'], 'd3_json': day_data['d3_json'],
                         'project_list': project_list_local,
                         'resource_list': resource_list_local}

    except Exception as e:
        log_error(e[0])
        status = 500
        resource_json['message'] = str(e[0])

    response = dict(data=resource_json, status=status)

    return response
コード例 #9
0
def get_costs_per_resource_quarter_center(year, quarter, center, project, output_type):
    log.info(
        'get_costs_per_resource_month_center == {0}--{1} --{2} --{3} -- {4}'.format(year, quarter, center,
                                                                                    project, output_type))

    project_json = dict()
    usage_data = []
    status = 200

    try:
        project_list_local = project_list_per_center(center)['list']
        resource_list_local = resource_list_per_project(center, project)

        project_json = {
            'usage_data': usage_data,
            'resource_list': resource_list_local,
            'project_list': project_list_local
        }

        if output_type == 'month':
            query_data = get_billing_data_per_year_quarter_week_day(str(year), str(quarter), str(project),
                                                                    output_type)
            log_output(query_data)

            usage_data = get_per_month_cost(query_data, quarter, year)
            project_json['usage_data'] = usage_data

        elif output_type == 'week':
            query_data = get_billing_data_per_year_quarter_week_day(str(year), str(quarter),
                                                                    str(project),
                                                                    output_type)
            log_output(query_data)

            usage_data = get_week_data(query_data, year, None)

            project_json['usage_data'] = usage_data

        elif output_type == 'day':
            query_data = get_billing_data_per_year_quarter_week_day(str(year), str(quarter),
                                                                    str(project),
                                                                    output_type)
            log_output(query_data)

            day_data = get_per_day_data(query_data)
            project_json['usage_data'] = day_data['usage_data']
            project_json['d3_json'] = day_data['d3_json']

    except Exception as e:
        log_error(e[0])
        status = 500
        project_json['message'] = str(e[0])

    response = dict(data=project_json, status=status)

    return response
コード例 #10
0
def get_costs_per_resource_quarter_center(year, quarter, center, project, output_type):
    log.info(
        'get_costs_per_resource_month_center == {0}--{1} --{2} --{3} -- {4}'.format(year, quarter, center,
                                                                                    project, output_type))

    project_json = dict()
    usage_data = []
    status = 200

    try:
        project_list_local = project_list_per_center(center)['list']
        resource_list_local = resource_list_per_project(center, project)

        project_json = {
            'usage_data': usage_data,
            'resource_list': resource_list_local,
            'project_list': project_list_local
        }

        if output_type == 'month':
            query_data = get_billing_data_per_year_quarter_week_day(str(year), str(quarter), str(project),
                                                                    output_type)
            log_output(query_data)

            usage_data = get_per_month_cost(query_data, quarter, year)
            project_json['usage_data'] = usage_data

        elif output_type == 'week':
            query_data = get_billing_data_per_year_quarter_week_day(str(year), str(quarter),
                                                                    str(project),
                                                                    output_type)
            log_output(query_data)

            usage_data = get_week_data(query_data, year, None)

            project_json['usage_data'] = usage_data

        elif output_type == 'day':
            query_data = get_billing_data_per_year_quarter_week_day(str(year), str(quarter),
                                                                    str(project),
                                                                    output_type)
            log_output(query_data)

            day_data = get_per_day_data(query_data)
            project_json['usage_data'] = day_data['usage_data']
            project_json['d3_json'] = day_data['d3_json']

    except Exception as e:
        log_error(e[0])
        status = 500
        project_json['message'] = str(e[0])

    response = dict(data=project_json, status=status)

    return response
コード例 #11
0
def get_costs_per_cost_month(year, value_to_match, output_type):
    log.info('get_costs_per_cost_month == {0}--{1} --{2}'.format(year, value_to_match, output_type))
    month_json = dict()
    month_data = []
    status = 200
    try:
        cost_center_list = set_global_cost_center_list()
        new_dict = dict()
        projects_list = []
        month_json = {
            'usage_data': month_data
        }

        for project_info in cost_center_list:
            projects_list.append(str(project_info['project_id']))

        query_data = get_billing_data_per_year_month(str(year), str(value_to_match), str(output_type))
        log_output(query_data)

        if query_data is not None:

            for (project, cost) in query_data:
                for project_info in cost_center_list:
                    cost_center = str(project_info['cost_center'])
                    project_id = str(project_info['project_id'])
                    owner = str(project_info['owner'])

                    if project == project_id:
                        new_dict[cost_center] = new_dict.get(cost_center, {})
                        new_dict[cost_center]['owner'] = owner
                        new_dict[cost_center]['cost'] = new_dict[cost_center].get('cost', 0.0)
                        new_dict[cost_center]['project'] = new_dict[cost_center].get('project', [])
                        new_dict[cost_center]['project'].append(str(project))
                        new_dict[cost_center]['cost'] += cost

            for key, value in new_dict.items():
                each_month = dict(name=value['owner'], cost=value['cost'], id=key)
                month_data.append(each_month)

        month_json['usage_data'] = month_data

        month_json = {
            'usage_data': month_data
        }

    except Exception as e:

        log_error(e[0])
        status = 500
        month_json['message'] = str(e[0])

    response = dict(data=month_json, status=status)

    return response
コード例 #12
0
def get_costs_per_cost_month(year, month):
    log.info('get_costs_per_cost_month == {0}--{1}'.format(year,month))
    month_json = {}

    cost_center_list = get_center_list(False)
    log.info('COST_CENTER_LIST == {0}'.format(cost_center_list))

    log_output('In cost per month for a year')
    log_output(year)
    log_output(month)

    try:
        month_data = []
        query_data = get_billing_data_per_year_per_month(str(year), str(month))
        log_output(query_data)

        new_dict = dict()
        projects_list = []

        if query_data is not None:
            for project_info in cost_center_list:
                projects_list.append(str(project_info['project_id']))

            log.info('Project_Cost_center_list_global {0}'.format(cost_center_list))
            log.info('Project_Cost_center_list {0}'.format(projects_list))

            for (project, cost) in query_data:
                for project_info in cost_center_list:
                    cost_center = str(project_info['cost_center'])
                    project_id = str(project_info['project_id'])

                    if project == project_id:
                        new_dict[cost_center] = new_dict.get(cost_center, {})
                        new_dict[cost_center]['cost'] = new_dict[cost_center].get('cost', 0.0)
                        new_dict[cost_center]['project'] = new_dict[cost_center].get('project', [])
                        new_dict[cost_center]['project'].append(str(project))
                        new_dict[cost_center]['cost'] += cost

            log.info('new_dic --1 {0}'.format(new_dict))

            for key, value in new_dict.items():
                each_month = dict(name=key, cost=value['cost'])
                month_data.append(each_month)

            log.info('MONTH_DATA {0}'.format(month_data))

        month_json = {
            'usage_data': month_data
        }

    except Exception as e:

        log_error(e)
    return month_json
コード例 #13
0
def get_costs_per_cost_month(year, value_to_match, output_type):
    log.info('get_costs_per_cost_month == {0}--{1} --{2}'.format(year, value_to_match, output_type))
    month_json = dict()
    month_data = []
    status = 200
    try:
        cost_center_list = set_global_cost_center_list()
        new_dict = dict()
        projects_list = []
        month_json = {
            'usage_data': month_data
        }

        for project_info in cost_center_list:
            projects_list.append(str(project_info['project_id']))

        query_data = get_billing_data_per_year_month(str(year), str(value_to_match), str(output_type))
        log_output(query_data)

        if query_data is not None:

            for (project, cost) in query_data:
                for project_info in cost_center_list:
                    cost_center = str(project_info['cost_center'])
                    project_id = str(project_info['project_id'])
                    director = str(project_info['director'])

                    if project == project_id:
                        new_dict[cost_center] = new_dict.get(cost_center, {})
                        new_dict[cost_center]['director'] = director
                        new_dict[cost_center]['cost'] = new_dict[cost_center].get('cost', 0.0)
                        new_dict[cost_center]['project'] = new_dict[cost_center].get('project', [])
                        new_dict[cost_center]['project'].append(str(project))
                        new_dict[cost_center]['cost'] += cost

            for key, value in new_dict.items():
                each_month = dict(name=value['director'], cost=value['cost'], id=key)
                month_data.append(each_month)

        month_json['usage_data'] = month_data

        month_json = {
            'usage_data': month_data
        }

    except Exception as e:

        log_error(e[0])
        status = 500
        month_json['message'] = str(e[0])

    response = dict(data=month_json, status=status)

    return response
コード例 #14
0
def get_costs_per_center_week(year, week, center, output_type):
    log.info(
        'get_costs_per_center_week == {0}--{1} --{2} --{3}'.format(year, week, center, output_type))
    center_json = dict()
    status = 200
    try:


        cost_center_list = set_global_cost_center_list()
        project_list_local = project_list_per_center(center)['list']
        project_id_local = project_list_per_center(center)['ids']
        resource_list_local = resource_list_per_project(center, None)
        cost_center_projects_id = []
        cost_center_projects_name = []

        for project_info in cost_center_list:
            if project_info['cost_center'] == center:
                cost_center_projects_id.append(project_info['project_id'])
                cost_center_projects_name.append(project_info['project_name'])

        week_output = []
        center_json = {
            'usage_data': week_output,
            'project_list': project_list_local,
            'resource_list': resource_list_local

        }
        if output_type == 'week':
            query_data = get_billing_data_per_year_week_day(str(year), str(week), str(output_type), project_id_local)
            log_output(query_data)

            center_json['usage_data'] = get_week_data(query_data, year, cost_center_projects_id)

        elif output_type == 'day':
            query_data = get_billing_data_per_year_week_day(str(year), str(week), str(output_type), project_id_local)
            log_output(query_data)

            day_data = get_per_day_data(query_data)
            center_json['usage_data'] = day_data['usage_data']
            center_json['d3_json'] = day_data['d3_json']

    except Exception as e:
        log_error(e[0])
        status = 500
        center_json['message'] = str(e[0])

    response = dict(data=center_json, status=status)

    return response
コード例 #15
0
def get_project_list_data():
    log.info('In Project List Data ----')
    data = dict()
    project_list = dict()
    try:
        projects = get_distinct_projects()

        for (project) in projects:
            project_list[project[0]] = project[0]

        log_output('PROJECT LIST')
        log_output(project_list)
        for (project) in project_list:
            log.info('INSIDE LOOP')
            # Request an access token from the metadata server.
            token_data = get_access_token()
            resp_access = token_data['resp_access']
            content_access = token_data['content_access']

            if resp_access.status == 200:

                # Extract the access token from the response.
                d = json.loads(content_access)
                access_token = d['access_token']  # Save the access token
                # log.debug('access_token -- {0}'.format(access_token))
                # Construct the request to Google Cloud Storage
                if project != 'Not Available':
                    project_id = project.split('-')[1]
                else:
                    project_id = 'Not Available'

                project_data = get_project_data(project_id, access_token)
                resp = project_data['resp']
                content = project_data['content']
                if resp.status == 200:
                    # log.debug('Project_data {0} -- {1}'.format(project_id, content))
                    data = json.loads(content)
                    project_list[project] = data['name']
                else:
                    log.error('Project_data  Error {0} -- {1}'.format(project_id, resp.status))


            else:
                log.error('Access Token Error {0}'.format(resp_access.status))

    except Exception as e:
        log_error(e)

    return project_list
コード例 #16
0
def get_costs_per_center_week(year, week, center, output_type):
    log.info(
        'get_costs_per_center_week == {0}--{1} --{2} --{3}'.format(year, week, center, output_type))
    center_json = dict()
    status = 200
    try:


        cost_center_list = set_global_cost_center_list()
        project_list_local = project_list_per_center(center)['list']
        project_id_local = project_list_per_center(center)['ids']
        resource_list_local = resource_list_per_project(center, None)
        cost_center_projects_id = []
        cost_center_projects_name = []

        for project_info in cost_center_list:
            if project_info['cost_center'] == center:
                cost_center_projects_id.append(project_info['project_id'])
                cost_center_projects_name.append(project_info['project_name'])

        week_output = []
        center_json = {
            'usage_data': week_output,
            'project_list': project_list_local,
            'resource_list': resource_list_local

        }
        if output_type == 'week':
            query_data = get_billing_data_per_year_week_day(str(year), str(week), str(output_type), project_id_local)
            log_output(query_data)

            center_json['usage_data'] = get_week_data(query_data, year, cost_center_projects_id)

        elif output_type == 'day':
            query_data = get_billing_data_per_year_week_day(str(year), str(week), str(output_type), project_id_local)
            log_output(query_data)

            day_data = get_per_day_data(query_data)
            center_json['usage_data'] = day_data['usage_data']
            center_json['d3_json'] = day_data['d3_json']

    except Exception as e:
        log_error(e[0])
        status = 500
        center_json['message'] = str(e[0])

    response = dict(data=center_json, status=status)

    return response
コード例 #17
0
def get_costs_per_center_month(year, month, center):
    center_json = {}
    cost_center_list = get_center_list(False)
    try:

        cost_center_projects_id = []
        cost_center_projects_name = []
        cost_center_projects_all_id = []
        cost_center_projects_all_name = []

        for project_info in cost_center_list:
            cost_center_projects_all_id.append(project_info['project_id'])
            cost_center_projects_all_name.append(project_info['project_name'])
            if project_info['cost_center'] == center:
                cost_center_projects_id.append(project_info['project_id'])
                cost_center_projects_name.append(project_info['project_name'])


        month_data = []

        query_data = get_billing_data_per_year_per_month(str(year), str(month))
        log_output(query_data)

        for (project, cost) in query_data:
            if project in cost_center_projects_id:
                if cost_center_projects_name[cost_center_projects_id.index(project)].lower() == 'none':
                    name = project
                else:
                    name = cost_center_projects_name[cost_center_projects_id.index(project)]
                each_month = {'name': name,
                              'cost': float(cost)}
                month_data.append(each_month)

        project_list_local = project_list_per_center(center)['list']

        log.info('MonthData {0}'.format(month_data))
        log.info('Project List {0}'.format(project_list_local))

        center_json = {
            'usage_data': month_data,
            'project_list': project_list_local

        }
    except Exception as e:
        log_error(e)
    return center_json
コード例 #18
0
def get_costs_per_month(year):
    data = {}
    log.info(' In get_costs_per_month == {0}'.format(year))
    try:

        query_data = get_billing_data_per_year(str(year))
        log_output(query_data)

        usage_data = get_per_month_cost(query_data)

        log.info(' get_costs_per_month  DATA == {0}'.format(usage_data))
        data = {
            'usage_data': usage_data
        }
    except Exception as e:
        log_error(e)
    return data
コード例 #19
0
def get_costs_per_resource_all_project_per_day(year, month, center, resource):
    resource_json = {}
    try:
        project_list_local = project_list_per_center(center)['list']
        project_list_ids = project_list_per_center(center)['ids']

        month_int = int(month)
        days = calendar.monthrange(year, month_int)[1] + 1
        each_day = []

        query_data = get_billing_data_per_resource_all_project_per_day(str(year), str(month), project_list_ids,
                                                                       str(resource))
        log_output(query_data)

        for x in range(1, days):
            each_day.append({'name': x, 'cost': 0, 'usage': 0, 'unit': ''})

        d3_json = [{'key': 'Cost', 'values': [], 'bar': True}, {'key': 'Usage', 'values': []}]

        for (day, cost, use, unit) in query_data:
            for val in each_day:
                if val['name'] == day:
                    val['cost'] = float(cost)
                    val['usage'] = float(use)
                    val['unit'] = str(unit)

            value = []
            value.append(day)
            value.append(float(cost))
            value.append('$')
            d3_json[0]['values'].append(value)
            value = []
            value.append(day)
            value.append(float(use))
            value.append(str(unit))
            d3_json[1]['values'].append(value)

        resource_list_local = resource_list_per_project(center, None)


        resource_json = {'usage_data': each_day, 'd3_json': d3_json, 'project_list': project_list_local,
                         'resource_list': resource_list_local}
    except Exception as e:
        log_error(e)
    return resource_json
コード例 #20
0
def get_costs_per_resource_per_project_per_day_quarter(year, value_to_match, center, project, resource, output_type):
    log.info('get_costs_per_resource_per_project_per_day_quarter == {0}--{1} --{2} --{3}--{4}--{5} '.format(year,
                                                                                                            value_to_match,
                                                                                                            center,
                                                                                                            project,
                                                                                                            resource,
                                                                                                            output_type))

    resource_json = dict()
    day_data = dict()
    status = 200

    try:
        project_list_local = project_list_per_center(center)['list']
        resource_list_local = resource_list_per_project(center, project)

        query_data = get_billing_data_per_resource_per_project_per_quarter(str(year), str(value_to_match),
                                                                           str(project),
                                                                           str(resource), output_type)
        log_output(query_data)

        if output_type == 'month':
            day_data['usage_data'] = get_per_month_cost(query_data, value_to_match, year)
            day_data['d3_json'] = []
        elif output_type == 'day':
            day_data = get_per_day_data(query_data)
        else:
            day_data['usage_data'] = get_week_data(query_data, year, None)
            day_data['d3_json'] = []

        resource_json = {'usage_data': day_data['usage_data'], 'd3_json': day_data['d3_json'],
                         'project_list': project_list_local,
                         'resource_list': resource_list_local}

    except Exception as e:
        log_error(e[0])
        status = 500
        resource_json['message'] = str(e[0])

    response = dict(data=resource_json, status=status)

    return response
コード例 #21
0
def get_costs_per_resource_per_project_per_day_quarter(year, value_to_match, center, project, resource, output_type):
    log.info('get_costs_per_resource_per_project_per_day_quarter == {0}--{1} --{2} --{3}--{4}--{5} '.format(year,
                                                                                                            value_to_match,
                                                                                                            center,
                                                                                                            project,
                                                                                                            resource,
                                                                                                            output_type))

    resource_json = dict()
    day_data = dict()
    status = 200

    try:
        project_list_local = project_list_per_center(center)['list']
        resource_list_local = resource_list_per_project(center, project)

        query_data = get_billing_data_per_resource_per_project_per_quarter(str(year), str(value_to_match),
                                                                           str(project),
                                                                           str(resource), output_type)
        log_output(query_data)

        if output_type == 'month':
            day_data['usage_data'] = get_per_month_cost(query_data, value_to_match, year)
            day_data['d3_json'] = []
        elif output_type == 'day':
            day_data = get_per_day_data(query_data)
        else:
            day_data['usage_data'] = get_week_data(query_data, year, None)
            day_data['d3_json'] = []

        resource_json = {'usage_data': day_data['usage_data'], 'd3_json': day_data['d3_json'],
                         'project_list': project_list_local,
                         'resource_list': resource_list_local}

    except Exception as e:
        log_error(e[0])
        status = 500
        resource_json['message'] = str(e[0])

    response = dict(data=resource_json, status=status)

    return response
コード例 #22
0
def get_costs_per_resource_per_project(year, center, project, resource):
    resource_json = {}

    project_list_local = project_list_per_center(center)['list']
    resource_list_local = resource_list_per_project(center, project)

    try:
        query_data = get_billing_data_per_resource_per_project(str(year), str(project), str(resource))
        log_output(query_data)

        usage_data = get_per_month_cost(query_data)
        resource_json = {
            'usage_data': usage_data,
            'project_list': project_list_local,
            'resource_list': resource_list_local

        }
    except Exception as e:
        log_error(e)
    return resource_json
コード例 #23
0
def get_costs_per_project_year(year, center, project):
    month_json = {}

    project_list_local = project_list_per_center(center)['list']

    try:

        month_data = []
        query_data = get_billing_data_per_project_year(str(year), str(project))
        log_output(query_data)

        for (project, cost) in query_data:
            each_month = {'name': project, 'cost': float(cost)}
            month_data.append(each_month)
        month_json = {
            'usage_data': month_data,
            'project_list': project_list_local
        }
    except Exception as e:
        log_error(e)
    return month_json
コード例 #24
0
def get_costs_per_center_month(year, month, center, output_type):
    log.info(
        'get_costs_per_center_month == {0}--{1} --{2} --{3}'.format(year, month, center, output_type))
    center_json = dict()
    status = 200

    try:


        cost_center_list = set_global_cost_center_list()
        project_list_local = project_list_per_center(center)['list']
        project_id_local = project_list_per_center(center)['ids']
        resource_list_local = resource_list_per_project(center, None)
        cost_center_projects_id = []
        cost_center_projects_name = []

        for project_info in cost_center_list:
            if project_info['cost_center'] == center:
                cost_center_projects_id.append(project_info['project_id'])
                cost_center_projects_name.append(project_info['project_name'])

        month_data = []
        center_json = {
            'usage_data': month_data,
            'project_list': project_list_local,
            'resource_list': resource_list_local

        }
        if output_type == 'month':


            query_data = get_billing_data_per_year_month(str(year), str(month), str(output_type))
            log_output(query_data)

            for (project, cost) in query_data:
                if project in cost_center_projects_id:
                    if cost_center_projects_name[cost_center_projects_id.index(project)].lower() == 'none':
                        name = project
                    else:
                        name = cost_center_projects_name[cost_center_projects_id.index(project)]
                    each_month = {'name': name,
                                  'cost': float(cost)}
                    month_data.append(each_month)
            center_json['usage_data'] = month_data

        elif output_type == 'week':
            query_data = get_billing_data_per_year_month_week_day(str(year), str(month), str(output_type),
                                                                  project_id_local)
            log_output(query_data)

            center_json['usage_data'] = get_week_data(query_data, year, cost_center_projects_id)

        elif output_type == 'day':
            query_data = get_billing_data_per_year_month_week_day(str(year), str(month), str(output_type),
                                                                  project_id_local)
            log_output(query_data)
            day_data = get_per_day_data(query_data)
            center_json['usage_data'] = day_data['usage_data']
            center_json['d3_json'] = day_data['d3_json']

    except Exception as e:
        log_error(e[0])
        status = 500
        center_json['message'] = str(e[0])

    response = dict(data=center_json, status=status)

    return response
コード例 #25
0
def get_costs_per_center_month(year, month, center, output_type):
    log.info(
        'get_costs_per_center_month == {0}--{1} --{2} --{3}'.format(year, month, center, output_type))
    center_json = dict()
    status = 200

    try:


        cost_center_list = set_global_cost_center_list()
        project_list_local = project_list_per_center(center)['list']
        project_id_local = project_list_per_center(center)['ids']
        resource_list_local = resource_list_per_project(center, None)
        cost_center_projects_id = []
        cost_center_projects_name = []

        for project_info in cost_center_list:
            if project_info['cost_center'] == center:
                cost_center_projects_id.append(project_info['project_id'])
                cost_center_projects_name.append(project_info['project_name'])

        month_data = []
        center_json = {
            'usage_data': month_data,
            'project_list': project_list_local,
            'resource_list': resource_list_local

        }
        if output_type == 'month':


            query_data = get_billing_data_per_year_month(str(year), str(month), str(output_type))
            log_output(query_data)

            for (project, cost) in query_data:
                if project in cost_center_projects_id:
                    if cost_center_projects_name[cost_center_projects_id.index(project)].lower() == 'none':
                        name = project
                    else:
                        name = cost_center_projects_name[cost_center_projects_id.index(project)]
                    each_month = {'name': name,
                                  'cost': float(cost)}
                    month_data.append(each_month)
            center_json['usage_data'] = month_data

        elif output_type == 'week':
            query_data = get_billing_data_per_year_month_week_day(str(year), str(month), str(output_type),
                                                                  project_id_local)
            log_output(query_data)

            center_json['usage_data'] = get_week_data(query_data, year, cost_center_projects_id)

        elif output_type == 'day':
            query_data = get_billing_data_per_year_month_week_day(str(year), str(month), str(output_type),
                                                                  project_id_local)
            log_output(query_data)
            day_data = get_per_day_data(query_data)
            center_json['usage_data'] = day_data['usage_data']
            center_json['d3_json'] = day_data['d3_json']

    except Exception as e:
        log_error(e[0])
        status = 500
        center_json['message'] = str(e[0])

    response = dict(data=center_json, status=status)

    return response