def get_spreadsheet_buffer(self, path, schedule):
spreadsheet = misc.Spreadsheet()
spreadsheet.append_data(
[[None], [str(path), 'DATE OF COMPLETION', self.date], [None]],
bold=True,
wrap_text=False)
return spreadsheet
def get_spreadsheet_buffer(self, path, schedule):
spreadsheet = misc.Spreadsheet()
# Item no and description
for slno, itemno in enumerate(self.itemnos):
if itemno is not None and schedule[itemno] is not None:
spreadsheet.append_data(
[[str(path), 'Item No:' + itemno, self.item_remarks[slno]]
],
bold=True,
wrap_text=False)
spreadsheet.append_data(
[[None, schedule[itemno].extended_description]])
# Remarks columns
if self.remark != '':
spreadsheet.append_data([[None, 'Remarks: ' + self.remark]],
bold=True)
# Data rows
spreadsheet.append_data([[None], [None] + self.captions], bold=True)
for slno, record in enumerate(self.records, 1):
values = record.get_model_rendered(slno)
spreadsheet.append_data([[slno] + values])
# User data
if self.captions_udata:
spreadsheet.append_data(
[[None], [None, 'User Data Captions'] + self.captions_udata],
bold=True)
spreadsheet.append_data([[None, 'User Datas'] + self.user_data])
# Total values
spreadsheet.append_data(
[[None], [None, 'TOTAL'] + self.get_total(), [None]], bold=True)
return spreadsheet
def get_spreadsheet_buffer(self, path, schedule):
spreadsheet = misc.Spreadsheet()
# Set datas
rows = [[str(path), 'Date of measurement:', self.date], [None]]
spreadsheet.append_data(rows, bold=True, wrap_text=False)
# Set datas of children
for slno, item in enumerate(self.items):
spreadsheet.append(
item.get_spreadsheet_buffer(path + [slno], schedule))
return spreadsheet
def get_spreadsheet_buffer(self, path, schedule):
spreadsheet = misc.Spreadsheet()
# Set datas
spreadsheet.add_merged_cell(value='DETAILS OF MEASUREMENT FOR ' +
self.name + ' (ref:' + str(path) + ')',
bold=True,
width=6,
horizontal='center')
spreadsheet.append_data([[None]])
# Set datas of children
for slno, item in enumerate(self.items):
spreadsheet.append(
item.get_spreadsheet_buffer(path + [slno], schedule))
# Set sheet properties
spreadsheet.set_title('CMB')
spreadsheet.set_column_widths([10, 50, 15] + [10] * 15)
return spreadsheet
def get_spreadsheet_buffer(self, path, schedule):
if self.mitems:
return self.int_mitem.get_spreadsheet_buffer(path, schedule)
else:
return misc.Spreadsheet()
def get_spreadsheet_buffer(self, path, schedule):
spreadsheet = misc.Spreadsheet()
spreadsheet.append_data([[str(path), self.remark], [None]],
bold=True,
wrap_text=True)
return spreadsheet