def get(self, event_slug=None, datetime_slug=None):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
localization = get_localization()
# query on event
condition = "'event slug' = '%s'" % event_slug
if datetime_slug:
condition += " AND "
condition += "'datetime slug' = '%s'" % datetime_slug
data = fusion_tables.select(configuration['slave table'], condition=condition)
no_results_message = ''
if not data:
no_results_message = localization[configuration['language']]['no-results']
data = data[0] if data else {}
# if data has no address, fetch it
if not data['address']:
data['address'] = address(data['latitude'], data['longitude'], language)
template = jinja_environment.get_template('event.html')
content = template.render(
configuration=configuration,
data=data,
date_time_reformat=date_time_reformat,
date_time_reformat_iso=date_time_reformat_iso,
no_results_message=no_results_message,
localization=localization[language]
)
# return the web-page content
self.response.out.write(content)
return
def get(self, event_slug=None, datetime_slug=None):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
localization = get_localization()
# query on event
condition = "'event slug' = '%s'" % event_slug
if datetime_slug:
condition += " AND "
condition += "'datetime slug' = '%s'" % datetime_slug
data = fusion_tables.select(configuration['slave table'],
condition=condition)
no_results_message = ''
if not data:
no_results_message = localization[
configuration['language']]['no-results']
data = data[0] if data else {}
# if data has no address, fetch it
if not data['address']:
data['address'] = address(data['latitude'], data['longitude'],
language)
template = jinja_environment.get_template('event.html')
content = template.render(
configuration=configuration,
data=data,
date_time_reformat=date_time_reformat,
date_time_reformat_iso=date_time_reformat_iso,
no_results_message=no_results_message,
localization=localization[language])
# return the web-page content
self.response.out.write(content)
return
def get(self):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
localization = get_localization()
offset = self.request.get("offset")
condition = "'state' = 'public'"
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
if limit:
condition += " AND 'start' < '%s'" % limit
if offset:
condition += " OFFSET %s" % offset
# at least for debugging, limit to 100 results
condition += " LIMIT 100"
no_results_message = ''
data = fusion_tables.select(configuration['master table'],
condition=condition)
if not data:
no_results_message = localization[
configuration['language']]['no-results']
# remove duplicates
unique_data = []
location_slugs = []
for d in data:
location_slug = d['location slug']
if location_slug not in location_slugs:
unique_data.append(d)
location_slugs.append(location_slug)
next_url = self.request.path_url + "?offset=%s" % str(
int(offset if offset else 0) + 100)
# for debugging, the id must be added to an url as parameter
id_appendix = ""
if self.request.get("id"):
id_appendix = "?id=%s" % self.request.get("id")
next_url += "&id=%s" % self.request.get("id")
template = jinja_environment.get_template('locations.html')
content = template.render(configuration=configuration,
data=unique_data,
date_time_reformat=date_time_reformat,
no_results_message=no_results_message,
localization=localization[language],
id_appendix=id_appendix,
offset=offset,
next_url=next_url)
# return the web-page content
self.response.out.write(content)
return
def get(self):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
localization = get_localization()
offset = self.request.get("offset")
condition = "'state' = 'public'"
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
if limit:
condition += " AND 'start' < '%s'" % limit
if offset:
condition += " OFFSET %s" % offset
# at least for debugging, limit to 100 results
condition += " LIMIT 100"
no_results_message = ''
data = fusion_tables.select(configuration['master table'], condition=condition)
if not data:
no_results_message = localization[configuration['language']]['no-results']
# remove duplicates
unique_data = []
location_slugs = []
for d in data:
location_slug = d['location slug']
if location_slug not in location_slugs:
unique_data.append(d)
location_slugs.append(location_slug)
next_url = self.request.path_url + "?offset=%s" % str(int(offset if offset else 0) + 100)
# for debugging, the id must be added to an url as parameter
id_appendix = ""
if self.request.get("id"):
id_appendix = "?id=%s" % self.request.get("id")
next_url += "&id=%s" % self.request.get("id")
template = jinja_environment.get_template('locations.html')
content = template.render(
configuration=configuration,
data=unique_data,
date_time_reformat=date_time_reformat,
no_results_message=no_results_message,
localization=localization[language],
id_appendix=id_appendix,
offset=offset,
next_url=next_url
)
# return the web-page content
self.response.out.write(content)
return
def get(self, now=datetime.datetime.strftime(datetime.datetime.now(), DATE_TIME_FORMAT), location_slug=None):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
localization = get_localization()
condition = "start >= '%s'" % now
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
if limit:
condition += " AND 'start' < '%s'" % limit
# query on location
condition += " AND 'location slug' = '%s'" % location_slug
# sort by datetime slug
condition += " ORDER BY 'datetime slug'"
no_results_message = ''
data = fusion_tables.select(configuration['slave table'], condition=condition)
if not data:
no_results_message = 'Geen activiteiten voldoen aan de zoekopdracht.'
condition = "'location slug' = '%s'" % location_slug # search without time filter
data = fusion_tables.select_first(configuration['slave table'], condition)
if not data:
# TODO what if the location's events have been deleted?
logging.error("No events found for location (%s)" % condition)
raise webapp2.abort(404)
qr_url = self.request.url
url = qr_url.replace('/qr/location/','/all/location/')
template = jinja_environment.get_template('qr.html')
content = template.render(
configuration=configuration,
data=data,
date_time_reformat=date_time_reformat,
no_results_message=no_results_message,
url=url,
localization=localization[language]
)
# return the web-page content
self.response.out.write(content)
return
def get(self,
location_slug=None,
timeframe=None,
tags=None,
hashtags=None):
now = self.request.get("now")
if not now:
now = datetime.datetime.strftime(
datetime.datetime.now(),
DATE_TIME_FORMAT) # fallback to server time
configuration = customer_configuration.get_configuration(self.request)
localization = get_localization()
# detect language and use configuration as default
language = get_language(self.request, configuration)
# calculate midnight, midnight1 and midnight 7 based on now
now_p = datetime.datetime.strptime(now, DATE_TIME_FORMAT)
midnight_p = datetime.datetime.combine(
now_p + datetime.timedelta(days=1), datetime.time.min)
midnight1_p = datetime.datetime.combine(
now_p + datetime.timedelta(days=2), datetime.time.min)
midnight7_p = datetime.datetime.combine(
now_p + datetime.timedelta(days=8), datetime.time.min)
midnight = datetime.datetime.strftime(midnight_p, DATE_TIME_FORMAT)
midnight1 = datetime.datetime.strftime(midnight1_p, DATE_TIME_FORMAT)
midnight7 = datetime.datetime.strftime(midnight7_p, DATE_TIME_FORMAT)
# query on timeframe
if timeframe == 'now':
# start < now and end > now
condition = "start <= '" + now + "' and end >= '" + now + "'"
elif timeframe == 'today':
# end > now and start < midnight
condition = "end >= '" + now + "' and start <= '" + midnight + "'"
elif timeframe == 'tomorrow':
# end > midnight and start < midnight + 1 day
condition = "end >= '" + midnight + "' and start <= '" + midnight1 + "'"
elif timeframe == 'week':
# end > now and start < midnight + 7 days
condition = "end >= '" + now + "' and start <= '" + midnight7 + "'"
else: # 'all' and other timeframes are interpreted as 'all'
# end > now
condition = "end >= '" + now + "'"
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
if limit:
condition += " AND 'start' < '%s'" % limit
# query on tags
if tags:
tags_p = tags.split(',')
for tag in tags_p:
condition += " AND tags CONTAINS '#" + tag + "#'"
# tags in the fusion table are surrounded by hash characters to avoid
# confusion if one tag would be a substring of another tag
# query on hashtags
if hashtags:
hashtags_p = hashtags.split(',')
for hashtag in hashtags_p:
condition += " AND hashtags CONTAINS '#" + hashtag + "#'"
# query on location
condition += " AND 'location slug' = '" + location_slug + "'"
# sort by datetime slug
condition += " ORDER BY 'datetime slug'"
no_results_message = ''
data = fusion_tables.select(configuration['slave table'],
condition=condition)
if not data:
no_results_message = localization[
configuration['language']]['no-results']
condition = "'location slug' = '" + location_slug + "'" # search without timeframe or tags filter
data = fusion_tables.select_first(configuration['slave table'],
condition=condition)
if not data:
# TODO what if the location's events have been deleted?
# is foreseen: fallback to query on event_slug only
logging.error("No events found for location (%s)" % condition)
raise webapp2.abort(404)
template = jinja_environment.get_template('location.html')
content = template.render(configuration=configuration,
data=data,
date_time_reformat=date_time_reformat,
no_results_message=no_results_message,
localization=localization[language])
# return the web-page content
self.response.out.write(content)
return
from jinja_templates import jinja_environment
import customer_configuration
from lib import get_localization, get_language, slugify, BaseHandler
import json
from datetime import date, timedelta
localization = get_localization()
class MapHandler(BaseHandler):
def get(self, *args, **kwargs):
style = self.request.get("style") # hidden feature
now = self.request.get("now") # hidden feature
if not now:
now = '' # no fallback needed here!
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
template = jinja_environment.get_template('map.html')
# map colors to tags
colors = ['purple', 'blue', 'teal', 'lightgreen', 'amber', 'red']
tags = configuration['tags'].split(',')
tag_colors = {}
for i, tag in enumerate(tags):
tag_colors[slugify(tag)] = colors[i % 6]
tag_colors['all-tags'] = 'white'
content = template.render(
configuration=configuration,
limit=limit if limit else 0, # e.g. "2014-07-19 09:00:00"
from jinja_templates import jinja_environment
import customer_configuration
from lib import get_localization, get_language, slugify, BaseHandler
import json
from datetime import date, timedelta
localization = get_localization()
class MapHandler(BaseHandler):
def get(self, *args, **kwargs):
style = self.request.get("style") # hidden feature
now = self.request.get("now") # hidden feature
if not now:
now = '' # no fallback needed here!
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
template = jinja_environment.get_template('map.html')
# map colors to tags
colors = ['purple', 'blue', 'teal', 'lightgreen', 'amber', 'red']
tags = configuration['tags'].split(',')
tag_colors = {}
for i, tag in enumerate(tags):
tag_colors[slugify(tag)] = colors[i % 6]
tag_colors['all-tags'] = 'white'
content = template.render(
configuration=configuration,
def get(self, location_slug=None, timeframe=None, tags=None, hashtags=None):
now = self.request.get("now")
if not now:
now = datetime.datetime.strftime(datetime.datetime.now(), DATE_TIME_FORMAT) # fallback to server time
configuration = customer_configuration.get_configuration(self.request)
localization = get_localization()
# detect language and use configuration as default
language = get_language(self.request, configuration)
# calculate midnight, midnight1 and midnight 7 based on now
now_p = datetime.datetime.strptime(now, DATE_TIME_FORMAT)
midnight_p = datetime.datetime.combine(now_p + datetime.timedelta(days=1), datetime.time.min)
midnight1_p = datetime.datetime.combine(now_p + datetime.timedelta(days=2), datetime.time.min)
midnight7_p = datetime.datetime.combine(now_p + datetime.timedelta(days=8), datetime.time.min)
midnight = datetime.datetime.strftime(midnight_p, DATE_TIME_FORMAT)
midnight1 = datetime.datetime.strftime(midnight1_p, DATE_TIME_FORMAT)
midnight7 = datetime.datetime.strftime(midnight7_p, DATE_TIME_FORMAT)
# query on timeframe
if timeframe == 'now':
# start < now and end > now
condition = "start <= '" + now + "' and end >= '" + now + "'"
elif timeframe == 'today':
# end > now and start < midnight
condition = "end >= '" + now + "' and start <= '" + midnight + "'"
elif timeframe == 'tomorrow':
# end > midnight and start < midnight + 1 day
condition = "end >= '" + midnight + "' and start <= '" + midnight1 + "'"
elif timeframe == 'week':
# end > now and start < midnight + 7 days
condition = "end >= '" + now + "' and start <= '" + midnight7 + "'"
else: # 'all' and other timeframes are interpreted as 'all'
# end > now
condition = "end >= '" + now + "'"
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
if limit:
condition += " AND 'start' < '%s'" % limit
# query on tags
if tags:
tags_p = tags.split(',')
for tag in tags_p:
condition += " AND tags CONTAINS '#" + tag + "#'"
# tags in the fusion table are surrounded by hash characters to avoid
# confusion if one tag would be a substring of another tag
# query on hashtags
if hashtags:
hashtags_p = hashtags.split(',')
for hashtag in hashtags_p:
condition += " AND hashtags CONTAINS '#" + hashtag + "#'"
# query on location
condition += " AND 'location slug' = '" + location_slug + "'"
# sort by datetime slug
condition += " ORDER BY 'datetime slug'"
no_results_message = ''
data = fusion_tables.select(configuration['slave table'], condition=condition)
if not data:
no_results_message = localization[configuration['language']]['no-results']
condition = "'location slug' = '" + location_slug + "'" # search without timeframe or tags filter
data = fusion_tables.select_first(configuration['slave table'], condition=condition)
if not data:
# TODO what if the location's events have been deleted?
# is foreseen: fallback to query on event_slug only
logging.error("No events found for location (%s)" % condition)
raise webapp2.abort(404)
template = jinja_environment.get_template('location.html')
content = template.render(
configuration=configuration,
data=data,
date_time_reformat=date_time_reformat,
no_results_message=no_results_message,
localization=localization[language]
)
# return the web-page content
self.response.out.write(content)
return
def get(self,
edit_mode='new',
event_slug=None,
location_slug=None,
latitude=None,
longitude=None,
zoom=None,
tags=None,
hashtags=None):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
event = [{}]
event_default = 'false'
location_default = 'false'
coordinates_default = 'false'
tags_default = 'false'
hashtags_default = 'false'
if event_slug:
event = fusion_tables.select_first(
configuration['master table'],
condition="'event slug' = '%s'" % event_slug)
event_default = 'true'
if location_slug:
event = fusion_tables.select_first(
configuration['master table'],
condition="'location slug' = '%s'" % location_slug)
location_default = 'true'
if latitude and longitude and not event_slug and not location_slug:
event[0]['latitude'] = latitude
event[0]['longitude'] = longitude
event[0]['zoom'] = zoom # zoom is not in a normal event object !
coordinates_default = 'true'
if tags and not event_slug:
event[0]['tags'] = ','.join(["#%s#" % t for t in tags.split(',')])
tags_default = 'true'
if hashtags and not event_slug:
event[0]['hashtags'] = ','.join(
["#%s#" % h for h in hashtags.split(',')])
hashtags_default = 'true'
if edit_mode == 'new':
if event_slug:
title = "edit-new-event-based-on-original"
else:
title = "edit-new-event-from-scratch"
else:
title = "update-event"
localization = get_localization()
template = jinja_environment.get_template('editor.html')
content = template.render(
configuration=configuration,
# note that event is a [{}] !
event_json=json.dumps(event)
if event else '[0]', # check map.html and gmaps.js why
event_default=event_default,
location_default=location_default,
coordinates_default=coordinates_default,
tags_default=tags_default,
hashtags_default=hashtags_default,
title=title,
edit_mode=edit_mode,
slugify=slugify,
language=language,
localization=localization[language])
# return the web-page content
self.response.out.write(content)
return
def get(
self,
edit_mode="new",
event_slug=None,
location_slug=None,
latitude=None,
longitude=None,
zoom=None,
tags=None,
hashtags=None,
):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
event = [{}]
event_default = "false"
location_default = "false"
coordinates_default = "false"
tags_default = "false"
hashtags_default = "false"
if event_slug:
event = fusion_tables.select_first(
configuration["master table"], condition="'event slug' = '%s'" % event_slug
)
event_default = "true"
if location_slug:
event = fusion_tables.select_first(
configuration["master table"], condition="'location slug' = '%s'" % location_slug
)
location_default = "true"
if latitude and longitude and not event_slug and not location_slug:
event[0]["latitude"] = latitude
event[0]["longitude"] = longitude
event[0]["zoom"] = zoom # zoom is not in a normal event object !
coordinates_default = "true"
if tags and not event_slug:
event[0]["tags"] = ",".join(["#%s#" % t for t in tags.split(",")])
tags_default = "true"
if hashtags and not event_slug:
event[0]["hashtags"] = ",".join(["#%s#" % h for h in hashtags.split(",")])
hashtags_default = "true"
if edit_mode == "new":
if event_slug:
title = "edit-new-event-based-on-original"
else:
title = "edit-new-event-from-scratch"
else:
title = "update-event"
localization = get_localization()
template = jinja_environment.get_template("editor.html")
content = template.render(
configuration=configuration,
# note that event is a [{}] !
event_json=json.dumps(event) if event else "[0]", # check map.html and gmaps.js why
event_default=event_default,
location_default=location_default,
coordinates_default=coordinates_default,
tags_default=tags_default,
hashtags_default=hashtags_default,
title=title,
edit_mode=edit_mode,
slugify=slugify,
language=language,
localization=localization[language],
)
# return the web-page content
self.response.out.write(content)
return