def write_get_or_create_title(MD,
sheet,
sheet_of_copy_wb,
title_row,
fname=None):
offset_write_xl = get_key(MD, 'offset_write_xl')
offset_write_xl_diff = get_key(MD, 'offset_write_xl_diff')
offset_write_xl_for_searched_obj = get_key(
MD, 'offset_write_xl_for_searched_obj')
check_file_write_more = get_key(MD, 'check_file_write_more')
fname = fname or MD.get('model')
sheet_ncols = sheet.ncols
for k, v in [(offset_write_xl, u' có sẵn hay phải tạo'),
(offset_write_xl_for_searched_obj, u'theo cách tìm'),
(offset_write_xl_diff,
u'ở excel giống hay khác trong database')]:
asmall_func(MD, fname, sheet_ncols, k, sheet_of_copy_wb, title_row, v)
if check_file_write_more:
for more_offset, func, more_title in check_file_write_more:
col = sheet.ncols + more_offset
title = more_title
sheet_of_copy_wb.col(col).width = get_width(len(title))
sheet_of_copy_wb.write(title_row, col, title, header_bold_style)
if MD.get('fields'):
for fname, field_MD in MD.get('fields').items():
write_get_or_create_title(field_MD, sheet, sheet_of_copy_wb,
title_row, fname)
def write_get_or_create_title(MD, sheet, sheet_of_copy_wb, title_row):
fields = MD['fields']
for fname, field_MD in fields.items():
offset_write_xl = get_key(field_MD, 'offset_write_xl')
if offset_write_xl != None:
col = sheet.ncols + offset_write_xl
title = field_MD.get('string', fname) + u' sẵn hay tạo'
sheet_of_copy_wb.col(col).width = get_width(len(title))
sheet_of_copy_wb.write(title_row, col, title, header_bold_style)
if field_MD.get('fields'):
write_get_or_create_title(field_MD, sheet, sheet_of_copy_wb,
title_row)
def asmall_func(MD,
fname,
sheet_ncols,
offset_write_xl,
sheet_of_copy_wb,
title_row,
surfix=u' sẵn hay tạo'):
if offset_write_xl != None:
col = sheet_ncols + offset_write_xl
title = 'Check ' + MD.get('string', fname) + surfix
sheet_of_copy_wb.col(col).width = get_width(len(title))
sheet_of_copy_wb.write(title_row, col, title, header_bold_style)