def kml_export_data(id_string, user, xform=None):
"""
KML export data from form submissions.
"""
def cached_get_labels(xpath):
"""
Get and Cache labels for the XForm.
"""
if xpath in list(labels):
return labels[xpath]
labels[xpath] = xform.get_label(xpath)
return labels[xpath]
xform = xform or XForm.objects.get(id_string=id_string, user=user)
data_kwargs = {'geom__isnull': False}
if xform.is_merged_dataset:
data_kwargs.update({
'xform_id__in':
[i for i in xform.mergedxform.xforms.filter(
deleted_at__isnull=True).values_list('id', flat=True)]
})
else:
data_kwargs.update({'xform_id': xform.pk})
instances = Instance.objects.filter(**data_kwargs).order_by('id')
data_for_template = []
labels = {}
for instance in queryset_iterator(instances):
# read the survey instances
data_for_display = instance.get_dict()
xpaths = list(data_for_display)
xpaths.sort(key=cmp_to_key(instance.xform.get_xpath_cmp()))
table_rows = [
'<tr><td>%s</td><td>%s</td></tr>' %
(cached_get_labels(xpath), data_for_display[xpath]) for xpath in
xpaths if not xpath.startswith(u"_")]
img_urls = image_urls(instance)
if instance.point:
data_for_template.append({
'name': instance.xform.id_string,
'id': instance.id,
'lat': instance.point.y,
'lng': instance.point.x,
'image_urls': img_urls,
'table': '<table border="1"><a href="#"><img width="210" '
'class="thumbnail" src="%s" alt=""></a>%s'
'</table>' % (img_urls[0] if img_urls else "",
''.join(table_rows))})
return data_for_template
def kml_export_data(id_string, user, xform=None):
"""
KML export data from form submissions.
"""
def cached_get_labels(xpath):
"""
Get and Cache labels for the XForm.
"""
if xpath in list(labels):
return labels[xpath]
labels[xpath] = xform.get_label(xpath)
return labels[xpath]
xform = xform or XForm.objects.get(id_string=id_string, user=user)
data_kwargs = {'geom__isnull': False}
if xform.is_merged_dataset:
data_kwargs.update({
'xform_id__in':
[i for i in xform.mergedxform.xforms.filter(
deleted_at__isnull=True).values_list('id', flat=True)]
})
else:
data_kwargs.update({'xform_id': xform.pk})
instances = Instance.objects.filter(**data_kwargs).order_by('id')
data_for_template = []
labels = {}
for instance in queryset_iterator(instances):
# read the survey instances
data_for_display = instance.get_dict()
xpaths = list(data_for_display)
xpaths.sort(key=cmp_to_key(instance.xform.get_xpath_cmp()))
table_rows = [
'<tr><td>%s</td><td>%s</td></tr>' %
(cached_get_labels(xpath), data_for_display[xpath]) for xpath in
xpaths if not xpath.startswith(u"_")]
img_urls = image_urls(instance)
if instance.point:
data_for_template.append({
'name': instance.xform.id_string,
'id': instance.id,
'lat': instance.point.y,
'lng': instance.point.x,
'image_urls': img_urls,
'table': '<table border="1"><a href="#"><img width="210" '
'class="thumbnail" src="%s" alt=""></a>%s'
'</table>' % (img_urls[0] if img_urls else "",
''.join(table_rows))})
return data_for_template