def get_entries(self):
q = FormsFieldEntry.objects.select_related(depth=1).filter(Q(
form_entry__form=self.form)).order_by("-form_entry__time_created")
if self.cleaned_data["start_date"] and self.cleaned_data["end_date"]:
time_from = self.cleaned_data["start_date"]
time_to = self.cleaned_data["end_date"]
if time_from and time_to:
q = q.filter(
form_entry__time_created__range=(time_from, time_to))
columns, rows = forms_format_entries(self.form, q)
cols = self.get_columns()
entries = []
for r in rows:
row = []
if self.form.bind_to_account and self.cleaned_data["field_nickname"]:
row.append({'value': r[
'entity'].account.username, 'type': fc.TEXT})
for f in self.columns['fields']:
if self.cleaned_data[f['slug']]:
row.append(r[f['slug']])
if self.cleaned_data["field_time_created"]:
row.append({'value': r[
'entity'].time_created, 'type': fc.DATE_TIME})
if self.cleaned_data["field_id"]:
row.append({'value': r['entity'].pk, 'type': fc.INTEGER})
entries.append(row)
return entries
def __init__(self, form, request, *args, **kwargs):
self.form = form
self.request = request
self.columns, self.rows = forms_format_entries(
form, FormsFormEntry.objects.none())
self.form_fields = form.fields.select_related().all()
super(FormsExportForm, self).__init__(*args, **kwargs)
for field in self.columns['fields']:
# Checkbox for including in export.
if form.bind_to_account and field['slug'] == 'zorna_owner':
self.fields['field_nickname'] = forms.BooleanField(
label=_(u'Nickname'), initial=True, required=False)
self.fields[field['slug']] = forms.BooleanField(
label=field['label'], initial=True, required=False)
# Checkbox for including date creation.
self.fields["field_time_created"] = forms.BooleanField(
label=_("Creation date"), initial=True, required=False)
self.fields["field_id"] = forms.BooleanField(
label=_("Row ID"), initial=True, required=False)
def __init__(self, form, request, *args, **kwargs):
self.form = form
self.request = request
self.columns, self.rows = forms_format_entries(
form, FormsFormEntry.objects.none())
self.form_fields = form.fields.select_related().all()
super(FormsExportForm, self).__init__(*args, **kwargs)
for field in self.columns['fields']:
# Checkbox for including in export.
if form.bind_to_account and field['slug'] == 'zorna_owner':
self.fields['field_nickname'] = forms.BooleanField(
label=_(u'Nickname'), initial=True, required=False)
self.fields[field['slug']] = forms.BooleanField(
label=field['label'], initial=True, required=False)
# Checkbox for including date creation.
self.fields["field_time_created"] = forms.BooleanField(
label=_("Creation date"), initial=True, required=False)
self.fields["field_id"] = forms.BooleanField(label=_("Row ID"),
initial=True,
required=False)
