excelexporters.tenantbatch.generate_excel() - Code Metrics - Inspection of "added excel exporter of tenant batch report" - MyEMS/myems - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( a1f49c...12e286 )

by Guangyu

created 2021-05-13 01:55 UTC

excelexporters.tenantbatch.generate_excel() C

↳ Parent: excelexporters.tenantbatch

Complexity

Conditions

Size

Total Lines	149
Code Lines	115

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	115
dl	0
loc	149
rs	5.6
c	0
b	0
f	0
cc	7
nop	4

How to fix Long Method

import base64
import uuid
import os
from openpyxl.styles import PatternFill, Border, Side, Alignment, Protection, Font
from openpyxl.drawing.image import Image
from openpyxl import Workbook


####################################################################################################################
# PROCEDURES
# Step 1: Validate the report data
# Step 2: Generate excelexporters file
# Step 3: Encode the excelexporters file to Base64
####################################################################################################################

def export(result, space_name, reporting_start_datetime_local, reporting_end_datetime_local):

    ####################################################################################################################
    # Step 1: Validate the report data
    ####################################################################################################################
    if result is None:
        return None

    ####################################################################################################################
    # Step 2: Generate excel file from the report data
    ####################################################################################################################
    filename = generate_excel(result,
                              space_name,
                              reporting_start_datetime_local,
                              reporting_end_datetime_local)
    ####################################################################################################################
    # Step 3: Encode the excel file to Base64
    ####################################################################################################################
    try:
        with open(filename, 'rb') as binary_file:
            binary_file_data = binary_file.read()
    except IOError as ex:
        pass

    # Base64 encode the bytes
    base64_encoded_data = base64.b64encode(binary_file_data)

    # get the Base64 encoded data using human-readable characters.
    base64_message = base64_encoded_data.decode('utf-8')
    # delete the file from server
    try:
        os.remove(filename)
    except NotImplementedError as ex:
        pass
    return base64_message


def generate_excel(report, space_name, reporting_start_datetime_local, reporting_end_datetime_local):

    wb = Workbook()
    ws = wb.active

    # Row height
    ws.row_dimensions[1].height = 102
    for i in range(2, 5 + 1):
        ws.row_dimensions[i].height = 42

    for i in range(6, len(report['tenants']) + 15):
        ws.row_dimensions[i].height = 60

    # Col width
    ws.column_dimensions['A'].width = 1.5

    ws.column_dimensions['B'].width = 25.0

    for i in range(ord('C'), ord('L')):
        ws.column_dimensions[chr(i)].width = 15.0

    # Font
    name_font = Font(name='Constantia', size=15, bold=True)
    title_font = Font(name='宋体', size=15, bold=True)
    data_font = Font(name='Franklin Gothic Book', size=11)

    table_fill = PatternFill(fill_type='solid', fgColor='1F497D')
    f_border = Border(left=Side(border_style='medium', color='00000000'),
                      right=Side(border_style='medium', color='00000000'),
                      bottom=Side(border_style='medium', color='00000000'),
                      top=Side(border_style='medium', color='00000000')
                      )
    b_border = Border(
        bottom=Side(border_style='medium', color='00000000'),
    )

    b_c_alignment = Alignment(vertical='bottom',
                              horizontal='center',
                              text_rotation=0,
                              wrap_text=True,
                              shrink_to_fit=False,
                              indent=0)
    c_c_alignment = Alignment(vertical='center',
                              horizontal='center',
                              text_rotation=0,
                              wrap_text=True,
                              shrink_to_fit=False,
                              indent=0)
    b_r_alignment = Alignment(vertical='bottom',
                              horizontal='right',
                              text_rotation=0,
                              wrap_text=True,
                              shrink_to_fit=False,
                              indent=0)
    c_r_alignment = Alignment(vertical='bottom',
                              horizontal='center',
                              text_rotation=0,
                              wrap_text=True,
                              shrink_to_fit=False,
                              indent=0)

    # Img
    img = Image("excelexporters/myems.png")
    img.width = img.width * 0.85
    img.height = img.height * 0.85
    ws.add_image(img, 'B1')

    # Title
    ws.row_dimensions[3].height = 60

    ws['B3'].font = name_font
    ws['B3'].alignment = b_r_alignment
    ws['B3'] = '空间:'
    ws['C3'].border = b_border
    ws['C3'].alignment = b_c_alignment
    ws['C3'].font = name_font
    ws['C3'] = space_name

    ws['F3'].font = name_font
    ws['F3'].alignment = b_r_alignment
    ws['F3'] = '日期:'
    ws['G3'].border = b_border
    ws['G3'].alignment = b_c_alignment
    ws['G3'].font = name_font
    ws['G3'] = reporting_start_datetime_local + "~" + reporting_end_datetime_local
    ws.merge_cells("G3:H3")

    # Title
    ws['B6'].border = f_border
    ws['B6'].font = name_font
    ws['B6'].alignment = c_c_alignment
    ws['B6'].fill = table_fill
    ws['B6'] = '名称'

    ws['C6'].border = f_border
    ws['C6'].alignment = c_c_alignment
    ws['C6'].font = name_font
    ws['C6'].fill = table_fill
    ws['C6'] = '空间'

    ws['D6'].border = f_border
    ws['D6'].font = name_font
    ws['D6'].alignment = c_c_alignment
    ws['D6'].fill = table_fill
    ws['D6'] = '成本中心'

    ca_len = len(report['energycategories'])

    for i in range(0, ca_len):
        col = chr(ord('E') + i)
        ws[col + '6'].fill = table_fill
        ws[col + '6'].font = name_font
        ws[col + '6'].alignment = c_c_alignment
        ws[col + '6'] = report['energycategories'][i]['name'] + \
            " (" + report['energycategories'][i]['unit_of_measure'] + ")"
        ws[col + '6'].border = f_border

    current_row_number = 7
    for i in range(0, len(report['tenants'])):

        ws['B' + str(current_row_number)].font = title_font

        ws['B' + str(current_row_number)].border = f_border
        ws['B' + str(current_row_number)].alignment = c_c_alignment
        ws['B' + str(current_row_number)] = report['tenants'][i]['tenant_name']

        ws['C' + str(current_row_number)].font = title_font
        ws['C' + str(current_row_number)].border = f_border
        ws['C' + str(current_row_number)].alignment = c_c_alignment
        ws['C' + str(current_row_number)] = report['tenants'][i]['space_name']

        ws['D' + str(current_row_number)].font = title_font
        ws['D' + str(current_row_number)].border = f_border
        ws['D' + str(current_row_number)].alignment = c_c_alignment
        ws['D' + str(current_row_number)] = report['tenants'][i]['cost_center_name']

        ca_len = len(report['tenants'][i]['values'])
        for j in range(0, ca_len):
            col = chr(ord('E') + j)
            ws[col + str(current_row_number)].font = title_font
            ws[col + str(current_row_number)].border = f_border
            ws[col + str(current_row_number)].alignment = c_c_alignment
            ws[col + str(current_row_number)] = report['tenants'][i]['values'][j]

        current_row_number += 1

    filename = str(uuid.uuid4()) + '.xlsx'
    wb.save(filename)

    return filename


1		import base64
2		import uuid
3		import os
4		from openpyxl.styles import PatternFill, Border, Side, Alignment, Protection, Font
5		from openpyxl.drawing.image import Image
6		from openpyxl import Workbook
7
8
9		####################################################################################################################
10		# PROCEDURES
11		# Step 1: Validate the report data
12		# Step 2: Generate excelexporters file
13		# Step 3: Encode the excelexporters file to Base64
14		####################################################################################################################
15
16	View Code Duplication	def export(result, space_name, reporting_start_datetime_local, reporting_end_datetime_local):
		0 ignored issues – show Duplication introduced 2021-05-13 02:13 UTC by Report Bug Copy Issue Report This code seems to be duplicated in your project. Loading history...
17		####################################################################################################################
18		# Step 1: Validate the report data
19		####################################################################################################################
20		if result is None:
21		return None
22
23		####################################################################################################################
24		# Step 2: Generate excel file from the report data
25		####################################################################################################################
26		filename = generate_excel(result,
27		space_name,
28		reporting_start_datetime_local,
29		reporting_end_datetime_local)
30		####################################################################################################################
31		# Step 3: Encode the excel file to Base64
32		####################################################################################################################
33		try:
34		with open(filename, 'rb') as binary_file:
35		binary_file_data = binary_file.read()
36		except IOError as ex:
37		pass
38
39		# Base64 encode the bytes
40		base64_encoded_data = base64.b64encode(binary_file_data)
		0 ignored issues – show introduced 2021-05-13 02:13 UTC by Report Bug Copy Issue Report The variable `binary_file_data` does not seem to be defined for all execution paths. Loading history...
41		# get the Base64 encoded data using human-readable characters.
42		base64_message = base64_encoded_data.decode('utf-8')
43		# delete the file from server
44		try:
45		os.remove(filename)
46		except NotImplementedError as ex:
47		pass
48		return base64_message
49
50
51		def generate_excel(report, space_name, reporting_start_datetime_local, reporting_end_datetime_local):
52
53		wb = Workbook()
54		ws = wb.active
55
56		# Row height
57		ws.row_dimensions[1].height = 102
58		for i in range(2, 5 + 1):
59		ws.row_dimensions[i].height = 42
60
61		for i in range(6, len(report['tenants']) + 15):
62		ws.row_dimensions[i].height = 60
63
64		# Col width
65		ws.column_dimensions['A'].width = 1.5
66
67		ws.column_dimensions['B'].width = 25.0
68
69		for i in range(ord('C'), ord('L')):
70		ws.column_dimensions[chr(i)].width = 15.0
71
72		# Font
73		name_font = Font(name='Constantia', size=15, bold=True)
74		title_font = Font(name='宋体', size=15, bold=True)
75		data_font = Font(name='Franklin Gothic Book', size=11)
76
77		table_fill = PatternFill(fill_type='solid', fgColor='1F497D')
78		f_border = Border(left=Side(border_style='medium', color='00000000'),
79		right=Side(border_style='medium', color='00000000'),
80		bottom=Side(border_style='medium', color='00000000'),
81		top=Side(border_style='medium', color='00000000')
82		)
83		b_border = Border(
84		bottom=Side(border_style='medium', color='00000000'),
85		)
86
87		b_c_alignment = Alignment(vertical='bottom',
88		horizontal='center',
89		text_rotation=0,
90		wrap_text=True,
91		shrink_to_fit=False,
92		indent=0)
93		c_c_alignment = Alignment(vertical='center',
94		horizontal='center',
95		text_rotation=0,
96		wrap_text=True,
97		shrink_to_fit=False,
98		indent=0)
99		b_r_alignment = Alignment(vertical='bottom',
100		horizontal='right',
101		text_rotation=0,
102		wrap_text=True,
103		shrink_to_fit=False,
104		indent=0)
105		c_r_alignment = Alignment(vertical='bottom',
106		horizontal='center',
107		text_rotation=0,
108		wrap_text=True,
109		shrink_to_fit=False,
110		indent=0)
111
112		# Img
113		img = Image("excelexporters/myems.png")
114		img.width = img.width * 0.85
115		img.height = img.height * 0.85
116		ws.add_image(img, 'B1')
117
118		# Title
119		ws.row_dimensions[3].height = 60
120
121		ws['B3'].font = name_font
122		ws['B3'].alignment = b_r_alignment
123		ws['B3'] = '空间:'
124		ws['C3'].border = b_border
125		ws['C3'].alignment = b_c_alignment
126		ws['C3'].font = name_font
127		ws['C3'] = space_name
128
129		ws['F3'].font = name_font
130		ws['F3'].alignment = b_r_alignment
131		ws['F3'] = '日期:'
132		ws['G3'].border = b_border
133		ws['G3'].alignment = b_c_alignment
134		ws['G3'].font = name_font
135		ws['G3'] = reporting_start_datetime_local + "~" + reporting_end_datetime_local
136		ws.merge_cells("G3:H3")
137
138		# Title
139		ws['B6'].border = f_border
140		ws['B6'].font = name_font
141		ws['B6'].alignment = c_c_alignment
142		ws['B6'].fill = table_fill
143		ws['B6'] = '名称'
144
145		ws['C6'].border = f_border
146		ws['C6'].alignment = c_c_alignment
147		ws['C6'].font = name_font
148		ws['C6'].fill = table_fill
149		ws['C6'] = '空间'
150
151		ws['D6'].border = f_border
152		ws['D6'].font = name_font
153		ws['D6'].alignment = c_c_alignment
154		ws['D6'].fill = table_fill
155		ws['D6'] = '成本中心'
156
157		ca_len = len(report['energycategories'])
158
159		for i in range(0, ca_len):
160		col = chr(ord('E') + i)
161		ws[col + '6'].fill = table_fill
162		ws[col + '6'].font = name_font
163		ws[col + '6'].alignment = c_c_alignment
164		ws[col + '6'] = report['energycategories'][i]['name'] + \
165		" (" + report['energycategories'][i]['unit_of_measure'] + ")"
166		ws[col + '6'].border = f_border
167
168		current_row_number = 7
169		for i in range(0, len(report['tenants'])):
170
171		ws['B' + str(current_row_number)].font = title_font
		0 ignored issues – show Comprehensibility Best Practice introduced 2021-05-13 02:13 UTC by Report Bug Copy Issue Report The variable `str` does not seem to be defined. Loading history...
172		ws['B' + str(current_row_number)].border = f_border
173		ws['B' + str(current_row_number)].alignment = c_c_alignment
174		ws['B' + str(current_row_number)] = report['tenants'][i]['tenant_name']
175
176		ws['C' + str(current_row_number)].font = title_font
177		ws['C' + str(current_row_number)].border = f_border
178		ws['C' + str(current_row_number)].alignment = c_c_alignment
179		ws['C' + str(current_row_number)] = report['tenants'][i]['space_name']
180
181		ws['D' + str(current_row_number)].font = title_font
182		ws['D' + str(current_row_number)].border = f_border
183		ws['D' + str(current_row_number)].alignment = c_c_alignment
184		ws['D' + str(current_row_number)] = report['tenants'][i]['cost_center_name']
185
186		ca_len = len(report['tenants'][i]['values'])
187		for j in range(0, ca_len):
188		col = chr(ord('E') + j)
189		ws[col + str(current_row_number)].font = title_font
190		ws[col + str(current_row_number)].border = f_border
191		ws[col + str(current_row_number)].alignment = c_c_alignment
192		ws[col + str(current_row_number)] = report['tenants'][i]['values'][j]
193
194		current_row_number += 1
195
196		filename = str(uuid.uuid4()) + '.xlsx'
197		wb.save(filename)
198
199		return filename
200

MyEMS / myems

Push — master ( a1f49c...12e286 )

excelexporters.tenantbatch.generate_excel() C

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like