# -*- coding: utf-8 -*- from gluon import * class WorkshopSchedule: def __init__(self, filter_date_start, filter_date_end = None, filter_archived = True, filter_only_public = True, sorting = 'date'): self.filter_date_start = filter_date_start self.filter_date_end = filter_date_end self.filter_archived = filter_archived self.filter_only_public = filter_only_public self.sorting = sorting def _get_workshops_rows_filter_query(self): """ Apply filters to workshops """ where = '' if self.filter_archived: where += "AND ws.Archived='F'" where += ' ' if self.filter_only_public: where += "AND ws.PublicWorkshop='T'" where += ' ' #TODO: check first activity date as startdate ... or create function in workshops.py that updates dates # & times for workshops when an activity is added/updated/deleted. if self.filter_date_start: where += "AND ws.Startdate >= '" + str(self.filter_date_start) + "'" where += ' ' if self.filter_date_end: where += "AND ws.Enddate <= " + str(self.filter_date_end) + "'" where += ' ' return where def _get_workshops_rows_orderby(self): """ Apply right sorting to rows """ db = current.db orderby = 'ws.Startdate' if self.sorting == 'name': orderby = 'ws.Name' return orderby def get_workshops_rows(self): """ Gets workshop rows """ db = current.db orderby_sql = self._get_workshops_rows_orderby() where_filter = self._get_workshops_rows_filter_query() fields = [ db.workshops.id, db.workshops.Name, db.workshops.Tagline, db.workshops.Startdate, db.workshops.Enddate, db.workshops.Starttime, db.workshops.Endtime, db.workshops.auth_teacher_id, db.workshops.auth_teacher_id2, db.workshops.Preview, db.workshops.Description, db.workshops.school_levels_id, db.workshops.school_locations_id, db.workshops.picture, db.workshops.thumbsmall, db.workshops.thumblarge, db.workshops_products.Price ] query = """ SELECT ws.id, ws.Name, ws.Tagline, ws.Startdate, ws.Enddate, ws.Starttime, ws.Endtime, ws.auth_teacher_id, ws.auth_teacher_id2, ws.Preview, ws.Description, ws.school_levels_id, ws.school_locations_id, ws.picture, ws.thumbsmall, ws.thumblarge, wsp.Price FROM workshops ws LEFT JOIN ( SELECT id, workshops_id, Price FROM workshops_products WHERE FullWorkshop = 'T' ) wsp ON ws.id = wsp.workshops_id WHERE ws.id > 0 {where_filter} ORDER BY {orderby_sql} """.format(orderby_sql = orderby_sql, where_filter = where_filter) rows = db.executesql(query, fields=fields) return rows def get_workshops_list(self): """ Returns list of workshops """ rows = self.get_workshops_rows().as_list() def _get_workshops_shop(self): """ Format list of workshops in a suitable way for the shop """ def new_workshop_month(): _class = 'workshops-list-month' return DIV(H2(last_day_month.strftime('%B %Y'), _class='center'), _class=_class) from general_helpers import get_last_day_month request = current.request os_gui = current.globalenv['os_gui'] T = current.T TODAY_LOCAL = current.TODAY_LOCAL rows = self.get_workshops_rows() current_month = TODAY_LOCAL last_day_month = get_last_day_month(current_month) workshops_month = new_workshop_month() workshops_month_body = DIV(_class='box-body') workshops = DIV() for i, row in enumerate(rows): repr_row = list(rows[i:i + 1].render())[0] more_info = os_gui.get_button('noicon', URL('event', vars={'wsID':row.workshops.id}), title=T('More info...'), btn_class='btn-link', btn_size='', _class='workshops-list-workshop-more-info') # Check if we're going into a later month if row.workshops.Startdate > last_day_month: if len(workshops_month_body) >= 1: # check if we have more in the month than just the title (the 1 in len()) workshops_month.append(DIV(workshops_month_body, _class='box box-solid')) workshops.append(workshops_month) last_day_month = get_last_day_month(row.workshops.Startdate) workshops_month = new_workshop_month() workshops_month_body = DIV(_class='box-body') startdate = SPAN(row.workshops.Startdate.strftime('%d %B').lstrip("0").replace(" 0", " "), _class='label_date') enddate = '' if not row.workshops.Startdate == row.workshops.Enddate: enddate = SPAN(row.workshops.Enddate.strftime('%d %B').lstrip("0").replace(" 0", " "), _class='label_date') workshop = DIV( DIV(DIV(DIV(repr_row.workshops.thumblarge, _class='workshops-list-workshop-image center'), _class='col-xs-12 col-sm-12 col-md-3'), DIV(A(H3(row.workshops.Name), _href=URL('shop', 'event', vars={'wsID':row.workshops.id})), H4(repr_row.workshops.Tagline), DIV(os_gui.get_fa_icon('fa-calendar-o'), ' ', startdate, ' ', repr_row.workshops.Starttime, ' - ', enddate, ' ', repr_row.workshops.Endtime, _class='workshops-list-workshop-date'), DIV(os_gui.get_fa_icon('fa-user-o'), ' ', repr_row.workshops.auth_teacher_id, _class='workshops-list-workshop-teacher'), DIV(os_gui.get_fa_icon('fa-map-marker'), ' ', repr_row.workshops.school_locations_id, _class='workshops-list-workshop-location'), BR(), more_info, _class='col-xs-12 col-sm-12 col-md-9 workshops-list-workshop-info'), _class=''), _class='workshops-list-workshop col-md-8 col-md-offset-2 col-xs-12') workshops_month_body.append(workshop) # if we're at the last row, add the workshops to the page if i + 1 == len(rows): workshops_month.append(DIV(workshops_month_body, _class='box box-solid')) workshops.append(workshops_month) return workshops def get_workshops_shop(self): """ Use caching when not running as test to return the workshops list in the shop """ web2pytest = current.globalenv['web2pytest'] request = current.request auth = current.auth # Don't cache when running tests if web2pytest.is_running_under_test(request, request.application): rows = self._get_workshops_shop() else: cache = current.cache CACHE_LONG = current.globalenv['CACHE_LONG'] cache_key = 'openstudio_workshops_workshops_schedule_shop' rows = cache.ram(cache_key , lambda: self._get_workshops_shop(), time_expire=CACHE_LONG) return rows