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):
if xform is None:
xform = XForm.objects.get(id_string=id_string, user=user)
instances = Instance.objects.filter(xform__user=user,
xform__id_string=id_string,
geom__isnull=False).order_by('id')
data_for_template = []
labels = {}
def cached_get_labels(xpath):
if xpath in labels.keys():
return labels[xpath]
labels[xpath] = xform.get_label(xpath)
return labels[xpath]
for instance in queryset_iterator(instances):
# read the survey instances
data_for_display = instance.get_dict()
xpaths = data_for_display.keys()
xpaths.sort(cmp=instance.xform.get_xpath_cmp())
label_value_pairs = [(cached_get_labels(xpath),
data_for_display[xpath]) for xpath in xpaths
if not xpath.startswith(u"_")]
table_rows = [
'<tr><td>%s</td><td>%s</td></tr>' % (k, v)
for k, v in label_value_pairs
]
img_urls = image_urls(instance)
img_url = img_urls[0] if img_urls else ""
point = instance.point
if point:
data_for_template.append({
'name':
id_string,
'id':
instance.id,
'lat':
point.y,
'lng':
point.x,
'image_urls':
img_urls,
'table':
'<table border="1"><a href="#"><img width="210" '
'class="thumbnail" src="%s" alt=""></a>%s'
'</table>' % (img_url, ''.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
def kml_export_data(id_string, user):
# TODO resolve circular import
from onadata.apps.viewer.models.data_dictionary import DataDictionary
dd = DataDictionary.objects.get(id_string=id_string, user=user)
instances = Instance.objects.filter(user=user,
xform__id_string=id_string,
geom__isnull=False).order_by('id')
data_for_template = []
labels = {}
def cached_get_labels(xpath):
if xpath in labels.keys():
return labels[xpath]
labels[xpath] = dd.get_label(xpath)
return labels[xpath]
for instance in instances:
# read the survey instances
data_for_display = instance.get_dict()
xpaths = data_for_display.keys()
xpaths.sort(cmp=instance.xform.data_dictionary().get_xpath_cmp())
label_value_pairs = [(cached_get_labels(xpath),
data_for_display[xpath]) for xpath in xpaths
if not xpath.startswith(u"_")]
table_rows = []
for key, value in label_value_pairs:
table_rows.append('<tr><td>%s</td><td>%s</td></tr>' % (key, value))
img_urls = image_urls(instance)
img_url = img_urls[0] if img_urls else ""
point = instance.point
data_for_template.append({
'name':
id_string,
'id':
instance.id,
'lat':
point.y,
'lng':
point.x,
'image_urls':
img_urls,
'table':
'<table border="1"><a href="#"><img width="210" '
'class="thumbnail" src="%s" alt=""></a>%s'
'</table>' % (img_url, ''.join(table_rows))
})
return data_for_template
def kml_export_data(id_string, user):
# TODO resolve circular import
from onadata.apps.viewer.models.data_dictionary import DataDictionary
dd = DataDictionary.objects.get(id_string=id_string, user=user)
instances = Instance.objects.filter(
xform__user=user, xform__id_string=id_string, geom__isnull=False
).order_by('id')
data_for_template = []
labels = {}
def cached_get_labels(xpath):
if xpath in labels.keys():
return labels[xpath]
labels[xpath] = dd.get_label(xpath)
return labels[xpath]
for instance in instances:
# read the survey instances
data_for_display = instance.get_dict()
xpaths = data_for_display.keys()
xpaths.sort(cmp=instance.xform.data_dictionary().get_xpath_cmp())
label_value_pairs = [
(cached_get_labels(xpath), data_for_display[xpath]) for xpath in
xpaths if not xpath.startswith(u"_")]
table_rows = ['<tr><td>%s</td><td>%s</td></tr>' % (k, v) for k, v
in label_value_pairs]
img_urls = image_urls(instance)
img_url = img_urls[0] if img_urls else ""
point = instance.point
if point:
data_for_template.append({
'name': id_string,
'id': instance.id,
'lat': point.y,
'lng': point.x,
'image_urls': img_urls,
'table': '<table border="1"><a href="#"><img width="210" '
'class="thumbnail" src="%s" alt=""></a>%s'
'</table>' % (img_url, ''.join(table_rows))})
return data_for_template