terom@6: # coding: utf-8
terom@6: """
terom@6:     Order data model/view/handler
terom@6: """
terom@6: 
terom@15: from svv.controllers import PageHandler, DocumentHandler
terom@6: from svv.html import tags
terom@6: from svv import database as db
terom@15: from svv import pdf
terom@6: 
terom@7: import datetime
terom@9: import logging
terom@11: import collections
terom@6: 
terom@18: try :
terom@18:     # Python2.6 stdlib
terom@18:     import json
terom@18: 
terom@18: except ImportError :
terom@18:     # simplejson, API should be similar
terom@18:     import simplejson as json
terom@18: 
terom@9: log = logging.getLogger('svv.orders')
terom@6: 
terom@9: class FormError (Exception) :
terom@9:     """
terom@9:         A user-level error in a form field
terom@9:     """
terom@6: 
terom@11:     def __init__ (self, field, value, error) :
terom@9:         """
terom@9:                 field       - name of field with error
terom@11:                 value       - the errenous value in the form that we recieved it
terom@11:                               may be None if it was the *lack* of a value that caused the issue
terom@9:                 error       - descriptive text for user
terom@9:         """
terom@6: 
terom@9:         self.field = field
terom@11:         self.value = value
terom@9: 
terom@9:         super(FormError, self).__init__(error)
terom@9: 
terom@15: class BaseForm (object) :
terom@9:     # any POST data we have processed, updated from process()
terom@9:     data = None
terom@9: 
terom@9:     def __init__ (self, app) :
terom@9:         """
terom@9:                 app             - bind this form to the app state (db etc)
terom@9:         """
terom@9: 
terom@9:         self.app = app
terom@9: 
terom@11:         # accumulated errors
terom@11:         self.errors = collections.defaultdict(list)
terom@11: 
terom@9:     def defaults (self) :
terom@9:         """
terom@9:             Update our attributes with default values
terom@9:         """
terom@9:         
terom@15:         raise NotImplementedError()
terom@9: 
terom@12:     def fail_field (self, form_error, field=None) :
terom@12:         """
terom@12:             Mark the field mentioned inside the given FormError as failed.
terom@12: 
terom@12:                 form_error      - the FormError to store
terom@12:                 field           - the name of the field to store the error under, if not the same as in form_error
terom@12:         """
terom@12: 
terom@12:         field = field or form_error.field
terom@12: 
terom@12:         log.warn("Marking field %s as failed: %s", field, form_error)
terom@12: 
terom@12:         self.errors[field].append(form_error)
terom@12: 
terom@9:     def process_raw_field (self, name, default=None, required=None) :
terom@9:         """
terom@9:             Process a generic incoming data field.
terom@9: 
terom@9:                 default         - value to return if no value was present
terom@9:                 required        - raise a FormError if no value present
terom@9: 
terom@9:             Returns the value as a str, or default
terom@9:         """
terom@9: 
terom@11:         if name in self.data :
terom@11:             return self.data[name]
terom@9: 
terom@9:         elif required :
terom@11:             raise FormError(name, None, "Required field")
terom@9: 
terom@9:         else :
terom@9:             return default
terom@9: 
terom@9:     def process_string_field (self, name, default=None, required=None, strip=True) :
terom@9:         """
terom@9:             Process a generic incoming string field.
terom@9: 
terom@9:             Trims extra whitespace from around the value, unless strip=False is given.
terom@9: 
terom@9:             Returns the value as unicode, or default.
terom@9:         """
terom@9: 
terom@9:         value = self.process_raw_field(name, required=required)
terom@9: 
terom@9:         if value is None :
terom@9:             return default
terom@9: 
terom@9:         try :
terom@9:             # XXX: decode somehow, or can werkzeug handle that?
terom@9:             value = unicode(value)
terom@9: 
terom@9:         except UnicodeDecodeError :
terom@11:             raise FormError(name, value, "Failed to decode Unicode characters")
terom@9: 
terom@9:         if strip :
terom@9:             value = value.strip()
terom@9: 
terom@9:         return value
terom@9:     
terom@9:     def process_integer_field (self, name, default=None, required=None) :
terom@9:         """
terom@9:             Process a generic incoming int field.
terom@9: 
terom@9:             Returns the value as int, or default.
terom@9:         """
terom@9: 
terom@9:         value = self.process_raw_field(name, required=required)
terom@9: 
terom@9:         if value is None :
terom@9:             return default
terom@9: 
terom@9:         try :
terom@9:             return int(value)
terom@9: 
terom@9:         except ValueError :
terom@11:             raise FormError(name, value, "Must be a number")
terom@9:     
terom@9:     DATETIME_FORMAT = "%d.%m.%Y %H:%M"
terom@9: 
terom@9:     def process_datetime_field (self, name, default=None, required=None, format=DATETIME_FORMAT) :
terom@9:         """
terom@9:             Process an incoming datetime field.
terom@9: 
terom@9:             Returns the value as datetime, or default.
terom@9:         """
terom@9: 
terom@9:         value = self.process_raw_field(name, required=required)
terom@9: 
terom@9:         if value is None :
terom@9:             return default
terom@9: 
terom@9:         try :
terom@9:             return datetime.datetime.strptime(value, format)
terom@9: 
terom@9:         except ValueError, ex :
terom@11:             raise FormError(name, value, "Invalid date/time value: " + str(ex))
terom@9: 
terom@9:     def process_multifield (self, table, id, fields) :
terom@9:         """
terom@9:             Process a set of user-given field values for an object with an unique id, and some set of additional fields.
terom@9:             
terom@9:             If the id is given, look up the corresponding field values, and return those.
terom@9: 
terom@9:             If any of the fields are given, either look up a matching row, or create a new one, and return its id.
terom@9: 
terom@9:             Returns an (id_name, field_name, ...) N-tuple.
terom@9:         """
terom@9: 
terom@9:         id_name, id_col, id_value = id
terom@9: 
terom@9:         if id_value :
terom@9:             # look up object from db
terom@9:             columns = [col for name, col, value in fields]
terom@9: 
terom@9:             sql = db.select(columns, (id_col == id_value))
terom@9: 
terom@11:             for row in self.app.query(sql) :
terom@9:                 # XXX: sanity-check row values vs our values
terom@9: 
terom@9:                 # new values
terom@9:                 fields = tuple(
terom@9:                     (name, col, row[col]) for name, col, value in fields
terom@9:                 )
terom@9:                 
terom@9:                 # ok, just use the first one
terom@9:                 break
terom@9: 
terom@9:             else :
terom@9:                 # not found!
terom@11:                 raise FormError(id_name, id_value, "Item selected does not seem to exist")
terom@9:                 
terom@9:             log.info("Lookup %s=%d -> %s", id_name, id_value, dict((name, value) for name, col, value in fields))
terom@9: 
terom@9:         elif any(value for name, col, value in fields) :
terom@9:             # look up identical object from db?
terom@9:             sql = db.select([id_col], db.and_(*[(col == value) for name, col, value in fields]))
terom@9: 
terom@9:             for row in self.app.query(sql) :
terom@9:                 if id_value :
terom@9:                     log.warn("Duplicate %s=%d for %s", id_name, id_value, dict((name, value) for name, col, value in fields))
terom@9:                 
terom@9:                 # found object's id
terom@9:                 id_value = row[id_col]
terom@9: 
terom@9:                 log.info("Found %s -> %d", dict((name, value) for name, col, value in fields), id_value)
terom@9:             
terom@9:             # create new object?
terom@9:             if not id_value :
terom@9:                 sql = db.insert(table).values(dict((col, value) for name, col, value in fields))
terom@9: 
terom@9:                 id_value, = self.app.insert(sql)
terom@9: 
terom@9:                 log.info("Create %s -> %d", dict((name, value) for name, col, value in fields), id_value)
terom@9: 
terom@9:         else :
terom@9:             # not known
terom@9:             log.debug("No %s known for order...", id_name)
terom@9:         
terom@9:         # return full set of values
terom@9:         return (id_value, ) + tuple(value for name, col, value in fields)
terom@9: 
terom@15:     def process (self, data) :
terom@15:         """
terom@15:             Bind ourselves to the given incoming POST data, and update our order field attributes.
terom@15: 
terom@15:                 data        - the submitted POST data as a MultiDict
terom@15: 
terom@15:             Returns True if all fields were processed without errors, False otherwise.
terom@15:         """
terom@15: 
terom@15:         raise NotImplmentedError()
terom@15:     
terom@15:         return not self.errors
terom@15: 
terom@15:     def render_text_input (self, name, value=None, multiline=False) :
terom@15:         """
terom@15:             Render HTML for a generic text field input.
terom@15:                 
terom@15:                 name            - field name, as used for POST
terom@15:                 value           - default field value
terom@15:                 multiline       - use a multi-line <textarea> instead
terom@15:         """
terom@15: 
terom@15:         if multiline :
terom@15:             # XXX: textarea can't be self-closing for some reason?
terom@15:             return tags.textarea(name=name, id=name, _selfclosing=False, _whitespace_sensitive=True)(value)
terom@15: 
terom@15:         else :
terom@15:             return tags.input(type='text', name=name, id=name, value=value)
terom@15: 
terom@15:     def render_select_input (self, name, options, value=None) :
terom@15:         """
terom@15:             Render HTML for a generic select control.
terom@15: 
terom@15:                 name            - field name, as used for POST
terom@15:                 options         - sequence of (value, title) options. `value` may be None to omit.
terom@15:                 value           - the selected value
terom@15:         """
terom@15: 
terom@15:         return tags.select(name=name, id=name)(
terom@15:             (
terom@15:                 tags.option(value=opt_value, selected=('selected' if opt_value == value else None))(opt_title)
terom@15:             ) for opt_value, opt_title in options
terom@15:         )
terom@15: 
terom@15:     def render_datetime_input (self, name, value=None) :
terom@15:         """
terom@15:             Render HTML for a generic datetime control (using jQuery).
terom@15: 
terom@15:                 name            - field name, as used for POST
terom@15:                 value           - selected date
terom@15:         """
terom@15:             
terom@15:         return (
terom@15:             self.render_text_input(name, (value.strftime(self.DATETIME_FORMAT) if value else None)),
terom@15: 
terom@15:             tags.script("$(document).ready(function () { $('#" + name + "').datetimepicker(); });"),
terom@15:         )
terom@15: 
terom@15:     def render_form_field (self, name, title, description, inputs) :
terom@15:         """
terom@15:             Render the label, input control, error note and description for a single field, along with their containing <li>.
terom@15:         """
terom@15: 
terom@15:         # any errors for this field?
terom@15:         errors = self.errors[name]
terom@15: 
terom@15:         return tags.li(class_='field' + (' failed' if errors else ''))(
terom@15:             tags.label((
terom@15:                 title,
terom@15:                 tags.strong(u"(Virheellinen)") if errors else None,
terom@15:             ), for_=name),
terom@15: 
terom@15:             inputs,
terom@15: 
terom@15:             tags.p(description),
terom@15:             
terom@15:             # possible errors
terom@15:             tags.ul(class_='errors')(tags.li(error.message) for error in errors) if errors else None,
terom@15:         )
terom@15: 
terom@15:     def render (self, action, submit=u"Tallenna") :
terom@15:         """
terom@15:             Render the entire <form>, using any loaded/processed values.
terom@15: 
terom@15:                 action          - the target URL for the form to POST to
terom@15:                 submit          - label for the submit button
terom@15:         """
terom@15:         
terom@15:         raise NotImplementedError()
terom@15: 
terom@15: 
terom@15: class OrderForm (BaseForm) :
terom@15:     """
terom@15:         A single instance of a <form>, where we can process submitted data from the client, storing the associated
terom@15:         Order-related data, and then render a form for any of that related data.
terom@15:     """
terom@15:     
terom@15:     def defaults (self) :
terom@15:         """
terom@15:             Update our attributes with default values
terom@15:         """
terom@15: 
terom@15:         self.customer_id = None
terom@15:         self.customer_name = None
terom@15: 
terom@15:         self.contact_id = None
terom@15:         self.contact_name = None
terom@15:         self.contact_phone = None
terom@15:         self.contact_email = None
terom@15:         self.contact_customer = None
terom@15: 
terom@15:         self.event_name = None
terom@15:         self.event_description = None
terom@15: 
terom@15:         tomorrow = datetime.date.today() + datetime.timedelta(days=1)
terom@15:         
terom@15:         # default to tomorrow afternoon
terom@15:         self.event_start = datetime.datetime.combine(tomorrow, datetime.time(16, 00))
terom@15:         
terom@15:         # automatically determined once start is set
terom@15:         self.event_end = None
terom@15: 
terom@9:     def process_customer (self) :
terom@9:         """
terom@9:             Process the incoming customer_* fields, returning (customer_id, customer_name).
terom@9:         """
terom@9: 
terom@11:         try :
terom@11:             customer_id = self.process_integer_field('customer_id')
terom@11:             customer_name = self.process_string_field('customer_name')
terom@6: 
terom@11:             if not customer_id and not customer_name :
terom@11:                 raise FormError('customer_name', None, "Must enter a customer")
terom@11:        
terom@11:             return self.process_multifield(db.customers,
terom@11:                 ('customer_id', db.customers.c.id, customer_id),
terom@11:                 (
terom@11:                     ('customer_name', db.customers.c.name, customer_name),
terom@11:                 ),
terom@11:             )
terom@11: 
terom@11:         except FormError, e :
terom@11:             # list it
terom@11:             self.fail_field(e, 'customer_name')
terom@11: 
terom@11:             return None, None
terom@11:  
terom@14:     def process_contact (self, customer_id, customer_name) :
terom@7:         """
terom@9:             Process the incoming contact_* fields, returning 
terom@9:                 (contact_id, contact_name, contact_phone, contact_email, contact_customer)
terom@7:         """
terom@11:         
terom@11:         try :
terom@11:             contact_id = self.process_integer_field('contact_id')
terom@11:             contact_name = self.process_string_field('contact_name')
terom@11:             contact_phone = self.process_string_field('contact_phone')
terom@11:             contact_email = self.process_string_field('contact_email')
terom@11:             contact_customer = customer_id
terom@7: 
terom@14:             if not contact_id and not contact_name and (contact_phone or contact_email) and customer_name :
terom@14:                 # use customer name as contact name, if otherwise missing
terom@14:                 contact_name = customer_name
terom@14: 
terom@11:             if not contact_id and not (contact_name or contact_phone or contact_email) :
terom@11:                 raise FormError('contact_name', None, "Must enter a contact")
terom@11: 
terom@11:             return self.process_multifield(db.contacts,
terom@11:                 ('contact_id', db.contacts.c.id, contact_id),
terom@11:                 (
terom@11:                     ('contact_name', db.contacts.c.name, contact_name),
terom@11:                     ('contact_phone', db.contacts.c.phone, contact_phone),
terom@11:                     ('contact_email', db.contacts.c.email, contact_email),
terom@11:                     ('contact_customer', db.contacts.c.customer, contact_customer),
terom@11:                 ),
terom@11:             )
terom@11: 
terom@11:         except FormError, e :
terom@11:             # list it
terom@11:             self.fail_field(e, 'contact_name' if e.field == 'contact_id' else None)
terom@11: 
terom@11:             return None, None, None, None, None
terom@7: 
terom@9:     def process_event (self) :
terom@7:         """
terom@9:             Process the incoming event_* fields, returning
terom@9:                 (event_name, event_description, event_start, event_end)
terom@7:         """
terom@11:         
terom@11:         try :
terom@11:             event_name = self.process_string_field('event_name')
terom@11:             event_description = self.process_string_field('event_description', strip=False)
terom@11:             event_start = self.process_datetime_field('event_start')
terom@11:             event_end = self.process_datetime_field('event_end')
terom@7: 
terom@11:             if event_end < event_start :
terom@11:                 raise FormError('event_start', event_end, "Event must end after start")
terom@9: 
terom@11:             return (event_name, event_description, event_start, event_end)
terom@11: 
terom@11:         except FormError, e :
terom@11:             # list it
terom@11:             self.fail_field(e)
terom@11: 
terom@11:             return None, None, None, None
terom@9: 
terom@9:     def process (self, data) :
terom@9:         """
terom@9:             Bind ourselves to the given incoming POST data, and update our order field attributes.
terom@9: 
terom@9:                 data        - the submitted POST data as a MultiDict
terom@11: 
terom@11:             Returns True if all fields were processed without errors, False otherwise.
terom@9:         """
terom@9: 
terom@9:         # bind the raw post data
terom@9:         self.data = data
terom@9: 
terom@9:         # customer
terom@9:         self.customer_id, self.customer_name = self.process_customer()
terom@9: 
terom@9:         # contact
terom@14:         self.contact_id, self.contact_name, self.contact_phone, self.contact_email, self.contact_customer = self.process_contact(self.customer_id, self.customer_name)
terom@9: 
terom@9:         if self.contact_customer and not self.customer_id :
terom@9:             # TODO: be really smart?
terom@9:             pass
terom@9: 
terom@9:         # event
terom@9:         self.event_name, self.event_description, self.event_start, self.event_end = self.process_event()
terom@11:     
terom@11:         return not self.errors
terom@9: 
terom@12:     def load (self, id) :
terom@11:         """
terom@12:             Load our field values from the database using the given id
terom@13: 
terom@13:             XXX: move SQL stuff out into an OrderModel class or something
terom@12:         """
terom@12:         
terom@12:         # query tables from db
terom@12:         sql_from = db.orders.join(db.customers).join(db.contacts, (db.orders.c.contact == db.contacts.c.id))
terom@12:         sql = db.select(
terom@12:             [
terom@12:                 db.orders,
terom@12:                 db.customers,
terom@12:                 db.contacts
terom@12:             ],
terom@12:             (db.orders.c.id == id),
terom@12:             from_obj = sql_from,
terom@12:             use_labels = True,
terom@12:         )
terom@11: 
terom@12:         for row in self.app.query(sql) :
terom@12:             # load data
terom@11: 
terom@12:             self.customer_id = row[db.customers.c.id]
terom@12:             self.customer_name = row[db.customers.c.name]
terom@11: 
terom@12:             self.contact_id = row[db.contacts.c.id]
terom@12:             self.contact_name = row[db.contacts.c.name]
terom@12:             self.contact_phone = row[db.contacts.c.phone]
terom@12:             self.contact_email = row[db.contacts.c.email]
terom@11: 
terom@12:             self.event_name = row[db.orders.c.event_name]
terom@12:             self.event_description = row[db.orders.c.event_description]
terom@12:             self.event_start = row[db.orders.c.event_start]
terom@12:             self.event_end = row[db.orders.c.event_end]
terom@12:             
terom@12:             break
terom@12: 
terom@12:         else :
terom@12:             raise KeyError(id, "No such order found")
terom@9: 
terom@9:     def build_customer_list (self) :
terom@9:         """
terom@9:             Query a (id, name) list of customers.
terom@9:         """
terom@9: 
terom@9:         sql = db.select([db.customers.c.id, db.customers.c.name])
terom@9: 
terom@9:         return self.app.query(sql)
terom@9: 
terom@9:     def build_contact_list (self, customer_id=None) :
terom@9:         """
terom@9:             Query a (id, name, phone, email) list of contacts, optionally for given customer if given.
terom@9:         """
terom@9: 
terom@9:         sql = db.select([db.contacts.c.id, db.contacts.c.name, db.contacts.c.phone, db.contacts.c.email])
terom@7: 
terom@7:         if customer_id :
terom@9:             sql = sql.where((db.contacts.c.customer == customer_id))
terom@7: 
terom@9:         return self.app.query(sql)
terom@9: 
terom@9: 
terom@7:     def render_customer_input (self) :
terom@7:         """
terom@9:             Render HTML for customer_id/name field inputs.
terom@7:         """
terom@7: 
terom@9:         # all known customers
terom@11:         customers = list(self.build_customer_list())
terom@7:         
terom@7:         return (
terom@11:             self.render_select_input('customer_id', [(0, u"Luo uusi")] + customers, self.customer_id),
terom@9:             self.render_text_input('customer_name', self.customer_name),
terom@7: 
terom@18:             tags.script(r"$(document).ready(function () { $('#customer_id').formSelectsPreset({textTarget: $('#customer_name')}); });"),
terom@7:         )
terom@7: 
terom@7:     def render_contact_input (self) :
terom@7:         """
terom@7:             Render HTML for contact name field <input>s
terom@7:         """
terom@9:         # recommended contacts for selected customer, if known
terom@18:         contacts = list(self.build_contact_list(self.customer_id))
terom@7: 
terom@7:         return (
terom@11:             self.render_select_input('contact_id', [(0, u"Luo uusi")] + [(id, name) for id, name, phone, email in contacts], self.contact_id),
terom@9:             self.render_text_input('contact_name', self.contact_name),
terom@7: 
terom@18:             tags.script("""\
terom@18: $(document).ready(function () { 
terom@18:     contact_phones = %(phones)s;
terom@18:     contact_emails = %(emails)s;
terom@18: 
terom@18:     $('#contact_id').formSelectsPreset({
terom@18:         textTarget: $('#contact_name'),
terom@18: 
terom@18:         mapTargets: [
terom@18:             [$('#contact_phone'), contact_phones],
terom@18:             [$('#contact_email'), contact_emails]
terom@18:         ]
terom@18:     });
terom@18: });
terom@18: """ %       dict(
terom@18:                 phones  = json.dumps(dict((row[db.contacts.c.id], row[db.contacts.c.phone]) for row in contacts)),
terom@18:                 emails  = json.dumps(dict((row[db.contacts.c.id], row[db.contacts.c.email]) for row in contacts)),
terom@18:             )),
terom@7:         )
terom@7: 
terom@7:     def render_event_input (self) :
terom@7:         """
terom@7:             Render HTML for event start/end field <input>s
terom@7:         """
terom@7:         
terom@7:         return (
terom@10:             self.render_datetime_input('event_start', self.event_start),
terom@7:             " - ",
terom@10:             self.render_datetime_input('event_end', self.event_end),
terom@7: 
terom@7:             tags.script(r"""
terom@7: $(document).ready(function () { 
terom@7:     var event_start = $('#event_start');
terom@7:     var event_end = $('#event_end');
terom@21:     
terom@21:     // XXX: datetimepicker breaks beforeShow completely (event having one breaks)
terom@7:     event_start.change(function () {
terom@7:         // copy value as default
terom@7:         var start_date = event_start.datetimepicker("getDate");
terom@21:         
terom@21:         if (start_date) {
terom@21:             event_end.datetimepicker("option", {
terom@21:                 defaultDate: start_date,
terom@21:                 minDate: start_date,
terom@21:             });
terom@21:         }
terom@7:     });
terom@7: 
terom@7:     // init default as well
terom@7:     event_start.change();
terom@7: });"""      ),
terom@7: 
terom@7:         )
terom@7: 
terom@9:     def render (self, action, submit=u"Tallenna") :
terom@9:         """
terom@9:             Render the entire <form>, using any loaded/processed values.
terom@9: 
terom@9:                 action          - the target URL for the form to POST to
terom@9:                 submit          - label for the submit button
terom@9:         """
terom@9: 
terom@9:         return tags.form(action=action, method='POST')(
terom@11:             (
terom@11:                 tags.h3(u"Lomakkeessa oli virheitä"),
terom@11:                 tags.p(u"Korjaa lomake ja lähetä uudelleen"),
terom@11: 
terom@11:                 tags.ul(class_='errors')(
terom@11:                     tags.li(tags.a(href='#' + error.field)(
terom@11:                         tags.em(error.field),
terom@11:                         error.message,
terom@11:                     )) for field_errors in self.errors.itervalues() for error in field_errors
terom@11:                 ),
terom@11:             ) if self.errors else None,
terom@11: 
terom@6:             tags.fieldset(
terom@6:                 tags.legend(u"Tilaaja"),
terom@6:                 
terom@6:                 tags.ol(
terom@9:                     self.render_form_field('customer_name', u"Tilaaja", u"Tilaavan yhdistyksen/henkilön nimi", (
terom@9:                         self.render_customer_input()
terom@6:                     )),
terom@6: 
terom@9:                     self.render_form_field('contact_name', u"Yhteyshenkilö", u"Yhteyshenkilön nimi, jos eri kun tilaaja", (
terom@9:                         self.render_contact_input()
terom@9:                     )),
terom@9: 
terom@18:                     self.render_form_field('contact_phone', u"Puhelinnumero", u"Yhteyshenkilön puhelinnumero", (
terom@9:                         self.render_text_input('contact_phone', self.contact_phone)
terom@9:                     )),
terom@9: 
terom@18:                     self.render_form_field('contact_email', u"Sähköpostiosoite", u"Yhteyshenkilön sähköpostiosoite", (
terom@9:                         self.render_text_input('contact_email', self.contact_email)
terom@6:                     )),
terom@6:                 ),
terom@6:             ),
terom@6: 
terom@6:             tags.fieldset(
terom@6:                 tags.legend(u"Tapahtuma"),
terom@6:            
terom@6:                 tags.ol(
terom@9:                     self.render_form_field('event_name', u"Tapahtuma", u"Tapahtuman lyhyt nimi", (
terom@9:                         self.render_text_input('event_name', self.event_name)
terom@6:                     )),
terom@6: 
terom@9:                     self.render_form_field('event_description', u"Lisätiedot", u"Tapahtuman tarkemmat tiedot", (
terom@9:                         self.render_text_input('event_description', self.event_description, multiline=True)
terom@6:                     )),
terom@6: 
terom@21:                     self.render_form_field('event_start', u"Ajankohta", 
terom@21:                         (
terom@21:                             u"Tapahtuman ajankohta (kamat noudetaan - palautetaan)", 
terom@21:                             tags.br(), 
terom@21:                             u"(%s)" % (datetime.datetime.now().strftime(self.DATETIME_FORMAT)),
terom@21:                         ), 
terom@21:                         (self.render_event_input()),
terom@21:                     ),
terom@6:                 ),
terom@6:             ),
terom@7: 
terom@9:             tags.input(type='submit', value=submit),
terom@6:         )
terom@6: 
terom@15: class OrderContractForm (BaseForm) :
terom@15:     """
terom@15:         Form for generating an order's contract document
terom@15:     """
terom@15: 
terom@15:     DEFAULT_PLACE = u"Otaniemi"
terom@15: 
terom@15:     def defaults (self) :
terom@15: 
terom@15:         today = datetime.date.today()
terom@15: 
terom@15:         self.prefill_placetime = False
terom@15:         self.prefill_placetime_default = "%s, %s" % (self.DEFAULT_PLACE, today.strftime("%d.%m.%Y"))
terom@15:         self.prefill_ourname = False
terom@15:         self.prefill_ourname_default = None
terom@15: 
terom@15:     def build_name_for_armed_input (self, name) :
terom@15:         """
terom@15:             Return the name used for the checkbox associated with the named armed text input
terom@15:         """
terom@15:         
terom@15:         return name + '_enabled'
terom@15: 
terom@15:     def render_checkbox_input (self, name, checked=None) :
terom@15:         """
terom@15:             Render HTML for a checkbox.
terom@15:         """
terom@15: 
terom@15:         return tags.input(type="checkbox", name=name, id=name, value="1",
terom@15:             checked=("checked" if checked else None)
terom@15:         )
terom@15: 
terom@15:     def render_armed_text_input (self, name, value=False, default=None) :
terom@15:         """
terom@15:             Render HTML for a text field that must be enabled by a checkbox before being used.
terom@15: 
terom@15:                 value       - the three-state value
terom@15:                                 False       - not checked, use default as value
terom@15:                                 None        - checked, use empty value
terom@15:                                 str         - checked, ues value
terom@15:         """
terom@15: 
terom@15:         checkbox_name = self.build_name_for_armed_input(name)
terom@15: 
terom@15:         if value is False :
terom@15:             checked = False
terom@15:             value = default
terom@15:         
terom@15:         else :
terom@15:             checked = True
terom@15: 
terom@15:         return (
terom@15:             self.render_checkbox_input(checkbox_name, checked),
terom@15:             self.render_text_input(name, value),
terom@15: 
terom@15:             tags.script("$(document).ready(function () { $('#" + name + "').formEnabledBy($('#" + checkbox_name + "')); });")
terom@15:         )
terom@15: 
terom@15:     def process_checkbox_field (self, name, required=None) :
terom@15:         """
terom@15:             Process an incoming checkbox input's value.
terom@15: 
terom@15:             The value must be a literal "1" to be accepted as True, and only a missing or empty value will be
terom@15:             recognized as False.
terom@15:         """
terom@15: 
terom@15:         value = self.process_raw_field(name, required)
terom@15: 
terom@15:         if not value and required :
terom@15:             raise FormError(name, value, "Must be checked")
terom@15: 
terom@15:         elif not value :
terom@15:             # unchecked
terom@15:             return False
terom@15: 
terom@15:         elif value == "1" :
terom@15:             # checked
terom@15:             return True
terom@15:         
terom@15:         else :
terom@15:             raise FormError(name, value, "Unrecognized checkbox state")
terom@15: 
terom@15:     def process_armed_text_field (self, name, required=None) :
terom@15:         """
terom@15:             A text field that must be enabled by a checkbox before being used.
terom@15: 
terom@15:             If not enabled, returns False. Otherwise, text field value, and fails if empty but required.
terom@15:         """
terom@15: 
terom@15:         checkbox_name = self.build_name_for_armed_input(name)
terom@15:         
terom@15:         if self.process_checkbox_field(checkbox_name) :
terom@15:             # use input value
terom@15:             return self.process_string_field(name, required=required)
terom@15: 
terom@15:         else :
terom@15:             # not selected
terom@15:             return False
terom@15: 
terom@15:     def render (self, action, submit=u"Tulosta Vuokrasopimus") :
terom@15:         
terom@15:         # self.url_for(OrderContractDocument, id=id)
terom@15:         return tags.form(action=action, method='POST')(
terom@15:             tags.fieldset(
terom@15:                 tags.legend(u"Vuokrasopimus"),
terom@15: 
terom@15:                 tags.ol(
terom@15:                     self.render_form_field('prefill_placetime', u"Esitäytä aika/paikka", u"Esitäytä allekirjoitusosion aika/paikka rivi", (
terom@15:                         self.render_armed_text_input('prefill_placetime', self.prefill_placetime, self.prefill_placetime_default)
terom@15:                     )),
terom@15: 
terom@15:                     self.render_form_field('prefill_ourname', u"Esitäytä vuokranantaja", u"Esitäytä allekirjoitusosion vuokranantajan nimi", (
terom@15:                         self.render_armed_text_input('prefill_ourname', self.prefill_ourname, self.prefill_ourname_default)
terom@15:                     )),
terom@17: 
terom@17:                     tags.li(
terom@17:                         tags.input(type='submit', value=submit),
terom@17:                     ),
terom@15:                 ),
terom@15:             ),
terom@15: 
terom@15:         )
terom@15: 
terom@15: 
terom@15:     def process (self, data) :
terom@15:         # bind the raw post data
terom@15:         self.data = data
terom@15: 
terom@15:         self.prefill_placetime = self.process_armed_text_field('prefill_placetime')
terom@15:         self.prefill_ourname = self.process_armed_text_field('prefill_ourname')
terom@15:         
terom@15:         return not self.errors
terom@9: 
terom@9: class OrdersView (PageHandler) :
terom@13:     """
terom@13:         Render list of orders, so as to access upcoming orders, current orders, and old orders..
terom@13:     """
terom@13: 
terom@13:     def build_orders_list (self, order_by=(db.orders.c.event_start)) :
terom@13:         """
terom@13:             Build summary list of orders, returning a series of 
terom@13:                 (order_id, customer_id, customer_name, event_name, contact_id, contact_name, event_start, event_end)
terom@13:             tuples, ordered by event_start, per default
terom@13:         """
terom@13:         
terom@13:         sql_from = db.orders.join(db.customers).join(db.contacts, (db.contacts.c.id == db.orders.c.contact))
terom@13:         sql = db.select(
terom@13:             [
terom@13:                 db.orders.c.id,
terom@13:                 db.orders.c.customer,
terom@13:                 db.customers.c.name,
terom@13:                 db.orders.c.event_name,
terom@13:                 db.orders.c.contact,
terom@13:                 db.contacts.c.name,
terom@13:                 db.orders.c.event_start,
terom@13:                 db.orders.c.event_end,
terom@13:             ],
terom@13:             from_obj = sql_from,
terom@13:             order_by = order_by,
terom@13:             use_labels = True,
terom@13:         )
terom@13: 
terom@13:         return self.app.query(sql)
terom@13:     
terom@14:     def group_orders_by_time (self, orders) :
terom@14:         """
terom@14:             Sort the given set of orders into a set of categories by time.
terom@14: 
terom@14:             Returns a
terom@14:                 (past, current, future)
terom@14:             set of order summary items.
terom@14:         """
terom@14: 
terom@14:         past = []
terom@14:         current = []
terom@14:         future = []
terom@14: 
terom@14:         today = datetime.date.today()
terom@14: 
terom@14:         for row in orders :
terom@14:             if row[db.orders.c.event_end].date() < today :
terom@14:                 past.append(row)
terom@14: 
terom@14:             elif row[db.orders.c.event_start].date() <= today :
terom@14:                 current.append(row)
terom@14: 
terom@14:             else :
terom@14:                 future.append(row)
terom@14:         
terom@14:         return past, current, future
terom@14: 
terom@13:     def render_event_time (self, start, end) :
terom@13:         """
terom@13:             Render concise start - end description
terom@13:         """
terom@13: 
terom@13:         # different days
terom@13:         if (start.year, start.month) != (end.year, end.month) :
terom@13:             # just the full dates
terom@13:             return "%s - %s" % (start.strftime("%d.%m.%Y"), end.strftime("%d.%m.%Y"))
terom@13: 
terom@13:         elif (start.day != end.day) :
terom@13:             # day range
terom@14:             date = "%s-%s.%s" % (start.strftime("%d"), end.strftime("%d"), start.strftime("%m.%Y"))
terom@13:         
terom@13:         else : # start.date() == end.date()
terom@13:             # single day
terom@13:             date = start.strftime("%d.%m.%Y")
terom@13: 
terom@13:         # time
terom@14:         time = "%s-%s" % (start.strftime("%H:%M"), end.strftime("%H:%M"))
terom@13: 
terom@13:         # format
terom@13:         return "%s %s" % (date, time)
terom@13: 
terom@14:     # columns for sorting
terom@14:     COLUMNS = (
terom@14:         ('order_id',        u"ID",              db.orders.c.id),
terom@14:         ('customer_name',   u"Tilaaja",         db.customers.c.name),
terom@14:         ('event_name',      u"Tapahtuma",       db.orders.c.event_name),
terom@14:         ('contact_name',    u"Yhteyshenkilö",   db.contacts.c.name),
terom@14:         ('event_start',     u"Ajankohta",       db.orders.c.event_start),
terom@14:     )
terom@14: 
terom@14: 
terom@14:     def render_orders_list_rows (self, orders) :
terom@13:         """
terom@14:             Render HTML for each of the orders in the order list, inserting sub-captions for various months
terom@13:         """
terom@13:         
terom@13:         # XXX: still broken
terom@13:         from svv import urls
terom@13:         
terom@14:         # track each row's year/month
terom@14:         last_date = None
terom@14:         row_counter = 0
terom@14: 
terom@14:         for row in orders :
terom@14:             # this order's date - only consider the starting datetime
terom@14:             date = row[db.orders.c.event_start].date()
terom@14:             
terom@14:             # month changed?
terom@14:             if last_date and (date.year, date.month) != (last_date.year, last_date.month) :
terom@14:                 # sub-caption
terom@14:                 yield tags.tr(class_='sub-caption')(
terom@14:                     tags.th(colspan=len(self.COLUMNS))(
terom@14:                         date.strftime("%B %Y")
terom@14:                     )
terom@14:                 )
terom@14: 
terom@14:                 # reset
terom@14:                 row_counter = 0
terom@14:             
terom@14:             # track
terom@14:             last_date = date
terom@14: 
terom@14:             # actual row
terom@14:             yield tags.tr(class_=('alternate' if row_counter % 2 else None))(
terom@14:                 # Id
terom@14:                 tags.td(class_='row-header')(
terom@14:                     tags.a(href=self.url_for(OrderView, id=row[db.orders.c.id]))(
terom@14:                         u"#%d" % (row[db.orders.c.id])
terom@14:                     )
terom@14:                 ),
terom@14: 
terom@14:                 # Tilaaja
terom@14:                 tags.td(
terom@14:                     tags.a(href=self.url_for(urls.CustomerView, id=row[db.orders.c.customer]))(
terom@14:                         row[db.customers.c.name]
terom@14:                     ) if row[db.orders.c.customer] else "-"
terom@14:                 ),
terom@14: 
terom@14:                 # Tapahtuma
terom@14:                 tags.td(
terom@14:                     tags.a(href=self.url_for(OrderView, id=row[db.orders.c.id]))(
terom@14:                         row[db.orders.c.event_name]
terom@14:                     )
terom@14:                 ),
terom@14: 
terom@14:                 # Yhteyshenkilö
terom@14:                 tags.td(
terom@14:                     tags.a(href='#')(
terom@14:                         row[db.contacts.c.name]
terom@14:                     ) if row[db.orders.c.contact] else "-"
terom@14:                 ),
terom@14: 
terom@14:                 # Ajankohta
terom@14:                 tags.td(
terom@14:                     self.render_event_time(row[db.orders.c.event_start], row[db.orders.c.event_end])
terom@14:                 ),
terom@14:             )
terom@14: 
terom@14:             row_counter += 1
terom@13: 
terom@13: 
terom@14:     def render_orders_list (self, orders, caption) :
terom@14:         """
terom@14:             Render HTML for sorted order list
terom@14:         """
terom@14:         
terom@13:         return tags.table(cellspacing="0")(
terom@14:             tags.caption(caption),
terom@13:             tags.thead(
terom@13:                 tags.tr(
terom@13:                     tags.th(
terom@13:                         tags.a(href="?sort=" + name)(title)
terom@14:                             if False else
terom@13:                         (title)
terom@14:                     ) for name, title, col in self.COLUMNS
terom@13:                 ),
terom@13:             ),
terom@13:             tags.tbody(
terom@14:                 # render using separate loop for sub-captions
terom@14:                 self.render_orders_list_rows(orders)
terom@13:             )
terom@13:         )
terom@13: 
terom@10:     def render_content (self) :
terom@14: #        # sort criteria
terom@14: #        sort = self.request.args.get('sort')
terom@14: #
terom@14: #        if sort :
terom@14: #            sort_col = (dict((name, col) for name, title, col in columns).get(sort), db.orders.c.event_start)
terom@14: #
terom@14: #        else :
terom@14: #            sort = 'event_start'
terom@14: #            sort_col = db.orders.c.event_start
terom@14: #
terom@14: #        orders = self.build_orders_list(sort_col)
terom@14: 
terom@14: 
terom@14:         # full order list
terom@14:         orders_full = self.build_orders_list()
terom@14: 
terom@14:         # categorize
terom@14:         past, current, future = self.group_orders_by_time(orders_full)
terom@14: 
terom@13:         return (
terom@13:             tags.h1("Tilauslista"),
terom@13: 
terom@14:             (
terom@14:                 (
terom@14:                     self.render_orders_list(orders, title),
terom@14:                 ) for title, orders in (
terom@14:                     (u"Tämänhetkiset", current),
terom@14:                     (u"Tulevat", future),
terom@14:                     (u"Menneet", past),
terom@14:                 ) if orders
terom@14:             ),
terom@13:         )
terom@9: 
terom@9: class OrderView (PageHandler) :
terom@12:     """
terom@12:         Render form for database object, let the user make updates, update the database.
terom@12:     """
terom@12:     
terom@12:     def update (self, id, form) :
terom@12:         """
terom@12:             Update database values from form
terom@12:         """
terom@12: 
terom@12:         sql = db.orders.update().where((db.orders.c.id == id)).values(
terom@12:             {
terom@12:                 db.orders.c.customer            : form.customer_id,
terom@12:                 db.orders.c.contact             : form.contact_id,
terom@12:                 db.orders.c.event_name          : form.event_name,
terom@12:                 db.orders.c.event_description   : form.event_description,
terom@12:                 db.orders.c.event_start         : form.event_start,
terom@12:                 db.orders.c.event_end           : form.event_end,
terom@12:             }
terom@12:         )
terom@12: 
terom@12:         # execute it
terom@12:         self.app.execute(sql)
terom@12: 
terom@12:     def process (self, id) :
terom@12:         """
terom@12:             Set up our form.
terom@12:         """
terom@12: 
terom@12:         self.form = OrderForm(self.app)
terom@12: 
terom@12:         # use either POST data or database data
terom@12:         if self.POST :
terom@12:             # feed form our POST data
terom@12:             if self.form.process(self.POST) :
terom@12:                 # submit data OK
terom@12:                 self.update(id, self.form)
terom@12: 
terom@12:             else :
terom@12:                 # errors
terom@12:                 pass
terom@12:         
terom@12:         else :
terom@12:             # fetch data from database
terom@12:             self.form.load(id)
terom@12: 
terom@15:     def render_contract_form (self, id) :
terom@15:         """
terom@15:             Render the contract panel for our view
terom@15:         """
terom@15: 
terom@15:         form = OrderContractForm(self.app)
terom@20:         form.defaults()
terom@15: 
terom@15:         # prefilled values?
terom@15:         if self.POST :
terom@15:             # feed form POST data
terom@15:             form.process(self.POST)
terom@15: 
terom@15:         # render
terom@15:         return form.render(action=self.url_for(OrderContractDocument, id=id))
terom@15: 
terom@10:     def render_content (self, id) :
terom@12:         """
terom@12:             Render our form
terom@12:         """
terom@12: 
terom@12:         return (
terom@12:             tags.h1(u"Tilaus #%d" % (id, )),
terom@12:             tags.h3(u"%s - %s (%s)" % (self.form.customer_name, self.form.event_name, self.form.event_start.strftime('%d.%m.%Y'))),
terom@15:             
terom@15:             self.render_contract_form(id),
terom@12:             self.form.render(action=self.url_for(OrderView, id=id))
terom@12:         )
terom@12: 
terom@9: 
terom@9: class NewOrderView (PageHandler) :
terom@9:     """
terom@11:         Render form for input, let the user correct their errors, create the order, and redirect out.
terom@9:     """
terom@9: 
terom@11:     def create (self, form) :
terom@11:         """
terom@11:             Create the new order from the given form data, returning the new order's ID
terom@11:         """
terom@10: 
terom@11:         # if we've gotten this far, then we can create it!
terom@11:         sql = db.insert(db.orders).values(
terom@11:             customer            = form.customer_id,
terom@11:             contact             = form.contact_id,
terom@9:             
terom@11:             event_name          = form.event_name,
terom@11:             event_description   = form.event_description,
terom@11:             event_start         = form.event_start,
terom@11:             event_end           = form.event_end,
terom@11:         )
terom@11: 
terom@11:         # go!
terom@11:         order_id, = self.app.insert(sql)
terom@11: 
terom@11:         # great
terom@11:         return order_id
terom@11: 
terom@11:     def process (self) :
terom@11:         """
terom@11:             Set up up our form.
terom@11:         """
terom@11: 
terom@11:         self.form = OrderForm(self.app)
terom@11: 
terom@11:         # use either POST data or defaults
terom@11:         if self.POST :
terom@11:             # try and process the input, checking for any failures...
terom@11:             if self.form.process(self.POST) :
terom@11:                 # should be good, create it!
terom@11:                 order_id = self.create(self.form)
terom@9:                 
terom@11:                 # redirect there now that our business is done and the order exists
terom@11:                 return self.redirect_for(OrderView, id=order_id)
terom@11:             
terom@11:             else :
terom@11:                 # errors in form input
terom@11:                 pass
terom@9: 
terom@11:         else :
terom@11:             # init from defaults
terom@11:             self.form.defaults()
terom@11:     
terom@11:     def render_content (self) :
terom@11:         """
terom@11:             Render our form
terom@11:         """
terom@9: 
terom@11:         return (
terom@11:             tags.h1(u"Uusi tilaus"),
terom@11:             self.form.render(action=self.url_for(NewOrderView))
terom@11:         )
terom@9: 
terom@15: class OrderContractDocument (DocumentHandler) :
terom@15:     """
terom@15:         Generate and return PDF document for rental contract.
terom@15:     """
terom@15: 
terom@15:     def load_params (self, data) :
terom@15:         """
terom@15:             Return OrderContractForm with parameters for generation
terom@15:         """
terom@15: 
terom@15:         form = OrderContractForm(self.app)
terom@15: 
terom@15:         form.defaults()
terom@15: 
terom@15:         if data :
terom@15:             # XXX: can't fail
terom@15:             form.process(data)
terom@15: 
terom@15:         return form
terom@15: 
terom@15:     def load_order (self, id):
terom@15:         """
terom@15:             Return OrderModel object for given ID
terom@15:         """
terom@15: 
terom@15:         # XXX: really need that OrderModel object :)
terom@15:         form = OrderForm(self.app)
terom@15:         form.load(id)
terom@15: 
terom@15:         return form
terom@15:     
terom@15:     def generate_document (self, id) :
terom@15: 
terom@15:         # retrieve from db
terom@15:         order = self.load_order(id)
terom@15: 
terom@15:         # params set by form
terom@15:         params = self.load_params(self.POST)
terom@15: 
terom@15:         title = "Teekkarispeksi Ry - Vuokrasopimus"
terom@15:         author = "Teekkarispeksi Ry"
terom@15: 
terom@15:         tpl = pdf.PageTemplate('page',
terom@15:             header_columns  = (
terom@15:                 ("", ""),
terom@15:                 ("", ""),
terom@15:                 ("", ""),
terom@17:                 ("Vuokrasopimus", [order.customer_name, order.event_name, 'dd.mm.yy hh:mm-hh:mm']),
terom@15:             ),
terom@15:             footer_columns  = (
terom@17:                 ("Teekkarispeksi Ry", ("www.teekkarispeksi.fi", )),
terom@17:                 ("Tekniikkavastaava", ("Juha Kallas", "045 xxx yyzz", "jskallas@cc.hut.fi")),
terom@17:                 ("Varastovastaava", ("Joel Pirttimaa", "045 xxx yyzz", "jhpirtti@cc.hut.fi")),
terom@15:                 ("", ""),
terom@15:             ),
terom@15:         )
terom@15: 
terom@15:         doc = pdf.DocumentTemplate([tpl],
terom@15:             title = title, author = author,
terom@15:         )
terom@15: 
terom@15:         # stylesheet
terom@15:         styles = pdf.Styles
terom@15: 
terom@15:         from reportlab.platypus import Paragraph as p
terom@15: 
terom@15:         # contract terms
terom@15:         list_seq = pdf.ListItem.seq
terom@15:         terms = pdf.ListItem("Sopimusehdot", styles.h2, None, list_seq(), [
terom@15:             pdf.ListItem("Osapuolet", styles.list_h2, None, list_seq(), [
terom@15:                 pdf.ListItem(None, None, "Teekkarispeksi ry (Y-tunnus 1888541-7), jäljempänä “Vuokranantaja”."),
terom@15:                 pdf.ListItem(None, None, order.customer_name + u", jäljempänä “Vuokraaja”. 1.1 ja 1.2 jäljempänä yhdessä “osapuolet”.")
terom@15:             ]),
terom@15:             pdf.ListItem("Kaluston lainaaminen", styles.list_h2, None, list_seq(), [
terom@15:                 pdf.ListItem("Yleistä", styles.list_h3, "Tässä sopimuksessa sovitaan toiminnasta Vuokranantajan lainatessa tanssimattoja Vuokraajalle"),
terom@15:                 pdf.ListItem("Vuokranantajan velvollisuudet", styles.list_h3, "Vuokranantaja sitoutuu toimittamaan sovittuna ajankohtana Vuokraajalle erikseen sovittava (liite) määrä tanssimattoja."),
terom@15:                 pdf.ListItem("Blaa Blaa", styles.list_h3, "Etc."),
terom@15:             ]),
terom@15:             pdf.ListItem("Tätä sopimusta ja sitä koskevia erimielisyyksiä koskevat määräykset", styles.list_h2, None, list_seq(), [
terom@15:                 pdf.ListItem("Sopimuksen voimassaolo", styles.list_h3, "Sopimus on osapuolia sitova sen jälkeen, kun osapuolet ovat sen allekirjoittaneet."),
terom@15:                 pdf.ListItem("Muutosten tekeminen", styles.list_h3, "Muutokset sopimukseen on tehtävä kirjallisesti molempien osapuolten kesken."),
terom@15:                 pdf.ListItem("Blaa Blaa", styles.list_h3, "Etc."),
terom@15:             ]),
terom@15:         ])
terom@15: 
terom@15: 
terom@15: 
terom@15:         sig_prefill = {}
terom@15: 
terom@15:         if params.prefill_placetime :
terom@15:             sig_prefill[('Vuokranantaja', 'Aika ja paikka')] = sig_prefill[('Vuokraaja', 'Aika ja paikka')] = params.prefill_placetime
terom@15: 
terom@15:         if params.prefill_ourname :
terom@15:             sig_prefill[('Vuokranantaja', 'Nimen selvennys')] = params.prefill_ourname
terom@15: 
terom@15:         elements = [
terom@15:                 p("Vuokrasopimus", styles.h1),
terom@15:                 p("Teekkarispeksi ry AV-tekniikka", styles.h3),
terom@15:         ] + list(terms.render_pdf()) + [
terom@15:                 p("Nouto", styles.h2),
terom@15:                 p("\t\tAika: _______________\tPaikka: _______________", styles.text),
terom@15:                 p("Palautus", styles.h2),
terom@15:                 p("\t\tAika: _______________\tPaikka: _______________", styles.text),
terom@15:                 
terom@15:                 pdf.SignatureBlock(("Vuokranantaja", "Vuokraaja"), ("%(column)s", "Nimen selvennys", "Aika ja paikka"), sig_prefill),
terom@15:         ]
terom@15: 
terom@15:         # ok
terom@15:         return doc, elements
terom@15:        
terom@15: