excelexporters.equipmentbatch.generate_excel() - Code Metrics - Inspection of "Merge branch 'develop'" - MyEMS/myems - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 9b1c49...b02625 )

by Guangyu

created 2022-09-17 08:47 UTC

excelexporters.equipmentbatch.generate_excel() D

↳ Parent: excelexporters.equipmentbatch

Complexity

Conditions

Size

Total Lines	140
Code Lines	108

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	108
dl	0
loc	140
rs	4.1999
c	0
b	0
f	0
cc	10
nop	5

How to fix Long Method Complexity

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


########################################################################################################################
# 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, language):

    ####################################################################################################################
    # 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,
                              language)
    ####################################################################################################################
    # Step 3: Encode the excel file to Base64
    ####################################################################################################################
    binary_file_data = b''
    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, language):
    locale_path = './i18n/'
    if language == 'zh_CN':
        trans = gettext.translation('myems', locale_path, languages=['zh_CN'])
    elif language == 'de':
        trans = gettext.translation('myems', locale_path, languages=['de'])
    elif language == 'en':
        trans = gettext.translation('myems', locale_path, languages=['en'])
    else:
        trans = gettext.translation('myems', locale_path, languages=['en'])
    trans.install()
    _ = trans.gettext
    wb = Workbook()
    ws = wb.active
    ws.title = "EquipmentBatch"

    # 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['equipments']) + 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='Arial', size=15, bold=True)
    title_font = Font(name='Arial', 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)

    # Img
    img = Image("excelexporters/myems.png")
    ws.add_image(img, 'A1')

    # Title
    ws['B3'].alignment = b_r_alignment
    ws['B3'] = _('Space') + ':'
    ws['C3'].border = b_border
    ws['C3'].alignment = b_c_alignment
    ws['C3'] = space_name

    ws['B4'].alignment = b_r_alignment
    ws['B4'] = _('Reporting Start Datetime') + ':'
    ws['C4'].border = b_border
    ws['C4'].alignment = b_c_alignment
    ws['C4'] = reporting_start_datetime_local

    ws['B5'].alignment = b_r_alignment
    ws['B5'] = _('Reporting End Datetime') + ':'
    ws['C5'].border = b_border
    ws['C5'].alignment = b_c_alignment
    ws['C5'] = reporting_end_datetime_local

    # Title
    ws['B6'].border = f_border
    ws['B6'].font = name_font
    ws['B6'].alignment = c_c_alignment
    ws['B6'].fill = table_fill
    ws['B6'] = _('Name')

    ws['C6'].border = f_border
    ws['C6'].alignment = c_c_alignment
    ws['C6'].font = name_font
    ws['C6'].fill = table_fill
    ws['C6'] = _('Space')

    ca_len = len(report['energycategories'])

    for i in range(0, ca_len):
        col = chr(ord('D') + 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['equipments'])):

        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['equipments'][i]['equipment_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['equipments'][i]['space_name']

        ca_len = len(report['equipments'][i]['values'])
        for j in range(0, ca_len):
            col = chr(ord('D') + j)
            ws[col + str(current_row_number)].font = data_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)] = round(report['equipments'][i]['values'][j], 2)

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

MyEMS / myems

Push — master ( 9b1c49...b02625 )

excelexporters.equipmentbatch.generate_excel() D

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Complexity

Duplication Side-by-Side

Filter issues like