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)