2024-11-08 04:30:58 +00:00
|
|
|
[basic]
|
|
|
|
|
template_file=certificate_template.xlsx
|
|
|
|
|
doc_file=certificate_[zekken_number].xlsx
|
|
|
|
|
sections=section1
|
|
|
|
|
maxcol=10
|
2024-11-09 19:11:19 +09:00
|
|
|
column_width=3,5,16,16,16,20,16,8,8,12,3
|
2024-11-08 14:33:46 +09:00
|
|
|
output_path=media/reports/[event_code]
|
2024-11-08 04:30:58 +00:00
|
|
|
|
|
|
|
|
[section1]
|
|
|
|
|
template_sheet=certificate
|
|
|
|
|
sheet_name=certificate
|
|
|
|
|
groups=group1,group2
|
|
|
|
|
fit_to_width=1
|
|
|
|
|
orientation=portrait
|
|
|
|
|
|
|
|
|
|
[section1.group1]
|
|
|
|
|
table_name=mv_entry_details
|
|
|
|
|
where=zekken_number='[zekken_number]' and event_name='[event_code]'
|
2024-11-09 19:11:19 +09:00
|
|
|
group_range=A1:K15
|
2024-11-08 04:30:58 +00:00
|
|
|
|
|
|
|
|
|
|
|
|
|
[section1.group2]
|
|
|
|
|
table_name=v_checkins_locations
|
|
|
|
|
where=zekken_number='[zekken_number]' and event_code='[event_code]'
|
|
|
|
|
sort=path_order
|
2024-11-09 19:11:19 +09:00
|
|
|
group_range=A16:J16
|
2024-11-08 04:30:58 +00:00
|
|
|
|
