Untitled
unknown
plain_text
2 years ago
2.4 kB
4
Indexable
if "0063_service" in data and data['0063_service'] !=" ":
row += 1
transtbl = p.add_table_cell(transtbl, 1, row, " ", self.options['trans_left3'] + "");
row += 1
transtbl = p.add_table_cell(transtbl, 1, row, " " + 'Service fees', self.options['trans_left_tbl_headings2'] + "");
#total = self.safe_sum(data,'0063_service') + self.safe_sum(data,'0060_service')
total = sum([float(item['amount_fmt']) for item in data['0063_service']]) +sum([float(item['amount_fmt']) for item in data['0060_service']])
if total < 0 :
display_total = "{:,.2f}".format(abs(total))
transtbl = p.add_table_cell(transtbl, 5, row, "R" + display_total + " - ", self.options['trans_left_tbl_headings4'] + "");
else:
display_total = "{:,.2f}".format(total)
transtbl = p.add_table_cell(transtbl, 5, row, "R" + display_total + " ", self.options['trans_left_tbl_headings4'] + "");
#transtbl = p.add_table_cell(transtbl, 5, row, "R"+str(total) + " ", self.options['trans_left_tbl_headings4'] + "");
row += 1
transtbl = p.add_table_cell(transtbl, 1, row, " Service/No", self.options[ 'trans_left2_italic'] + "");
transtbl = p.add_table_cell(transtbl, 2, row, ""+"Quantity/Description", self.options['trans_left_it'] + "");
transtbl = p.add_table_cell(transtbl, 3, row, ""+"Ref/Date"+" "+"Unit Price", self.options['trans_left_it'] + "");
transtbl = p.add_table_cell(transtbl, 4, row, "", self.options['trans_right_tbl_1'] + "");
transtbl = p.add_table_cell(transtbl, 5, row, "", self.options['trans_right3'] + "");
table_x = 15 # Adjust the X-coordinate based on your layout
table_y = ph.getYfromtop(790) # Adjust the Y-coordinate based on your layout
table_width = 567 # Adjust based on your layout
table_height = ph.getYfromtop(790) - table_y # Corrected calculation for table_height
column_widths = [100, 200, 150, 0, 0]
row_height = 20Editor is loading...