def render_field(self, row, field): """ Render a field if only 1 table in the query, the no table name needed when getting the row value - however, if there are multiple tables in the query (self.use_tablename == True) then we need to use the tablename as well when accessing the value in the row object the row object sent in can take :param row: :param field: :return: """ if self.use_tablename: field_value = row[field.tablename][field.name] else: field_value = row[field.name] if field.type == 'date': _td = TD(XML("<script>\ndocument.write(" "moment(\"%s\").format('L'));\n</script>" % field_value) \ if row and field and field_value else '', _class='has-text-centered') elif field.type == 'boolean': # True/False - only show on True, blank for False if row and field and field_value: _td = TD(_class='has-text-centered') _span = SPAN(_class='icon is-small') _span.append(I(_class='fas fa-check-circle')) _td.append(_span) else: _td = TD(XML(' ')) else: _td = TD(field_value if row and field and field_value else '') return _td
def hcaptcha_form(): form = Form( [ Field( "dummy_form", "string", ) ] ) form.structure.append( XML('<div class="h-captcha" data-sitekey="{}"></div>'.format(HCAPTCHA_SITE_KEY)) ) if form.accepted: r = hCaptcha(request.forms.get("g-recaptcha-response")) if r == True: # do something with form data form.structure.append( XML( '<div style="color:green">Captcha was solved succesfully!</font></div>' ) ) else: form.structure.append( XML('<div class="py4web-validation-error">invalid captcha</div>') ) return dict(form=form)
def render_table(self): _html = DIV(_class='field') _top_div = DIV(_style='padding-bottom: 1rem;') # build the New button if needed if self.create and self.create != '': if isinstance(self.create, str): create_url = self.create else: create_url = create_url = URL(self.endpoint) + '/new/%s/0' % self.tablename _top_div.append(self.render_action_button(create_url, 'New', 'fa-plus', size='normal')) # build the search form if provided if self.search_form: _top_div.append(self.render_search_form()) _html.append(_top_div) _table = TABLE(_class='table is-bordered is-striped is-hoverable is-fullwidth') # build the header _table.append(self.render_table_header()) # include moment.js to present dates in the proper locale _html.append(XML('<script src="https://momentjs.com/downloads/moment.js"></script>')) # build the rows _table.append(self.render_table_body()) # add the table to the html _html.append(_table) # add the row counter information _row_count = DIV(_class='is-pulled-left') _row_count.append( P('Displaying rows %s thru %s of %s' % (self.page_start + 1 if self.number_of_pages > 1 else 1, self.page_end if self.page_end < self.total_number_of_rows else self.total_number_of_rows, self.total_number_of_rows))) _html.append(_row_count) # build the pager if self.number_of_pages > 1: _html.append(self.render_table_pager()) if self.deletable: _html.append((XML(""" <script type="text/javascript"> $('.confirmation').on('click', function () { return confirm($(this).attr('message') +' - Are you sure?'); }); </script> """))) return XML(_html)
def __call__(self, img_id=None): # turn our class into HTML return XML( MainAppComponent.MAINAPP.format( get_posts_url=URL(self.get_posts_url, signer=self.signer), create_post_url=URL(self.create_post_url, signer=self.signer), get_about_url=URL(self.get_about_url, signer=self.signer), delete_all=URL(self.delete_all_posts_url, signer=self.signer)))
def __call__(self, id=None): """This method returns the element that can be included in the page. @param id: id of the file uploaded. This can be useful if there are multiple instances of this form on the page.""" return XML( FileUpload.FILE_UPLOAD.format( url=URL(self.url, id, signer=self.signer)))
def __call__(self, id=None): """This method returns the element that can be included in the page. @param id: id of the file uploaded. This can be useful if there are multiple instances of this form on the page.""" return XML(ThumbRater.THUMBRATER.format( url=URL(self.url, id, signer=self.signer), callback_url=URL(self.callback_url, id, signer=self.signer)))
def __call__(self, redirect_url=None): """This method returns the element that can be included in the page. The *args and **kwargs are used when subclassing, to allow for forms that are 'custom built' for some need.""" return XML(VueForm.FORM.format(url=URL(self.url, signer=self.signer), check_url=URL(self.url_check, signer=self.signer), redirect_url=redirect_url))
def __call__(self): return XML( NotesHandler.NOTESHANDLER.format( get_notes=URL(self.get_notes_url, signer=self.signer), add_notes=URL(self.add_notes_url, signer=self.signer), save_notes=URL(self.save_notes_url, signer=self.signer), delete_notes=URL(self.delete_notes_url, signer=self.signer)))
def gantt(): res_actions = get_items(status='Resolved') if res_actions: projxml = get_gantt_data(res_actions) else: projxml = "<project></project>" return dict(project=XML(projxml), quests=res_actions)
def helper(self): if self.accepted: self.clear() if not self.cached_helper: helper = self.formstyle(self.table, self.vars, self.errors, self.readonly, self.deletable) if self.action: helper["_action"] = self.action if self.form_name: helper["controls"]["hidden_widgets"]["formname"] = INPUT( _type="hidden", _name="_formname", _value=self.form_name) helper["form"].append( helper["controls"]["hidden_widgets"]["formname"]) if self.formkey: helper["controls"]["hidden_widgets"]["formkey"] = INPUT( _type="hidden", _name="_formkey", _value=self.formkey) helper["form"].append( helper["controls"]["hidden_widgets"]["formkey"]) for key in self.hidden or {}: helper["controls"]["hidden_widgets"][key] = INPUT( _type="hidden", _name=key, _value=self.hidden[key]) helper["form"].append( helper["controls"]["hidden_widgets"][key]) helper["controls"]["begin"] = XML("".join( str(helper["controls"]["begin"]) + str(helper["controls"]["hidden_widgets"][hidden_field]) for hidden_field in helper["controls"]["hidden_widgets"])) self.cached_helper = helper return self.cached_helper
def convxml(value, tag, sanitize=False, trunc=False, trunclength=40): value = str(value) value = value.replace('\n', ' ').replace('\r', '') if trunc: value = truncquest(value, trunclength, wrap=0, mark=False) return '<' + tag + '>' + XML(str(value), sanitize=sanitize) + '</' + tag + '>'
def __call__(self): """This method returns the element that can be included in the page. The *args and **kwargs are used when subclassing, to allow for forms that are 'custom built' for some need. """ return XML( VueForm.FORM.format(url=self.url(), check_url=self.check_url()))
def __call__(self, id=None): """This method returns the element that can be included in the page. @param id: if an id is specified, the form is an update form for the specified record id.""" return XML( VueForm.FORM.format(url=self.url(id), check_url=self.check_url(id)))
def render_action_button( self, url, button_text, icon, icon_size="small", additional_classes=None, additional_styles=None, override_classes=None, override_styles=None, message=None, onclick=None, row_id=None, name="grid-button", row=None, **attr, ): separator = "?" if row_id: url += "/%s" % row_id classes = self.param.grid_class_style.classes.get(name, "") styles = self.param.grid_class_style.styles.get(name, "") def join(items): return ( " ".join(items) if isinstance(items, (list, tuple)) else " %s" % items ) if override_classes: classes = join(override_classes) elif additional_classes: classes += join(additional_classes) if override_styles: styles = join(override_styles) elif additional_styles: styles += join(additional_styles) if callable(url): url = url(row) link = A( I(_class="fa %s" % icon), _href=url, _role="button", _class=classes, _message=message, _title=button_text, _style=styles, **attr, ) if self.param.include_action_button_text: link.append( XML( '<span class="grid-action-button-text"> %s</span>' % button_text ) ) return link
def helper(self): if self.accepted: self.clear() if not self.cached_helper: helper = self.param.formstyle( self.table, self.vars, self.errors, self.readonly, self.deletable, self.noncreate, show_id=self.show_id, kwargs=self.kwargs, ) for item in self.param.sidecar: helper["form"][-1][-1].append(item) button_attributes = item.attributes button_attributes["_label"] = item.children[0] helper["json_controls"]["form_buttons"] += [button_attributes] if self.action: helper["form"]["_action"] = self.action if self.param.submit_value: helper["controls"]["submit"][ "_value"] = self.param.submit_value if self.form_name: helper["controls"]["hidden_widgets"]["formname"] = INPUT( _type="hidden", _name="_formname", _value=self.form_name) helper["form"].append( helper["controls"]["hidden_widgets"]["formname"]) helper["json_controls"]["form_values"][ "_formname"] = self.form_name if self.formkey: helper["controls"]["hidden_widgets"]["formkey"] = INPUT( _type="hidden", _name="_formkey", _value=self.formkey) helper["form"].append( helper["controls"]["hidden_widgets"]["formkey"]) helper["json_controls"]["form_values"][ "_formkey"] = self.formkey for key in self.param.hidden or {}: helper["controls"]["hidden_widgets"][key] = INPUT( _type="hidden", _name=key, _value=self.param.hidden[key]) helper["form"].append( helper["controls"]["hidden_widgets"][key]) helper["controls"]["begin"] = XML("".join( str(helper["controls"]["begin"]) + str(helper["controls"]["hidden_widgets"][hidden_field]) for hidden_field in helper["controls"]["hidden_widgets"])) self.cached_helper = helper return self.cached_helper
def __call__(self, id=None): return XML( ThumbRater.THUMBRATER.format(url=URL(self.url, id, signer=self.signer), callback_url=URL(self.callback_url, id, signer=self.signer)))
def __call__(self, id=None, redirect_url=None): """This method returns the element that can be included in the page. @param id: if an id is specified, the form is an update form for the specified record id. @param redirect_url: URL to which to redirect after success.""" return XML(VueForm.FORM.format(url=URL(self.url, id, signer=self.signer), check_url=URL(self.url_check, id, signer=self.signer), redirect_url=redirect_url))
def grid(self, table): name = 'vue%s' % str(uuid.uuid4())[:8] return DIV(self.mtable(table), TAG.SCRIPT(_src=URL('static/js/axios.min.js')), TAG.SCRIPT(_src=URL('static/js/vue.min.js')), TAG.SCRIPT(_src=URL('static/js/utils.js')), TAG.SCRIPT(_src=URL('static/components/mtable.js')), TAG.SCRIPT( XML('var app=utils.app("%s"); app.start()' % name)), _id=name)
def get_gantt_data(quests): projxml = "<project>" questlist = [x.question.id for x in quests] intlinks = getlinks(questlist) for i, row in enumerate(quests): projxml += convrow(row, getstrdepend(intlinks, row.question.id), True) projxml += '</project>' return XML(projxml)
def edit_dog(): dog_id = request.query.get('id') form = Form(db.dog, record=dog_id, formstyle=FormStyleBulma) form.param.sidecar = [XML('<button class="button" onclick="close_modal();" ' 'style="margin-left: .5rem;">Cancel</button>')] if form.accepted: url = URL('index') redirect(url) return dict(form=form)
def grid(self, table): name = "vue%s" % str(uuid.uuid4())[:8] return DIV( self.mtable(table), TAG.SCRIPT(_src=URL("static/js/axios.min.js")), TAG.SCRIPT(_src=URL("static/js/vue.min.js")), TAG.SCRIPT(_src=URL("static/js/utils.js")), TAG.SCRIPT(_src=URL("static/components/mtable.js")), TAG.SCRIPT(XML('var app={}; app.vue = new Vue({el:"#%s"});' % name)), _id=name, )
def __call__(self, id=None): # a clear cut interface is better than dependence on global variables, but including the same user # every time might make data strained, adding user as a prop may be added later return XML( Comment.COMMENT.format(get_url=URL(self.get_url, id, signer=self.signer), add_url=URL(self.add_url, signer=self.signer), edit_url=URL(self.edit_url, signer=self.signer), delete_url=URL(self.delete_url, signer=self.signer), ticket_id=id))
def test_tags(self): DIV = TAG.div IMG = TAG['img/'] self.assertEqual(DIV().xml(), "<div></div>") self.assertEqual(IMG().xml(), "<img/>") self.assertEqual(DIV(_id="my_id").xml(), "<div id=\"my_id\"></div>") self.assertEqual(IMG(_src="crazy").xml(), "<img src=\"crazy\"/>") self.assertEqual( DIV(_class="my_class", _mytrueattr=True).xml(), "<div class=\"my_class\" mytrueattr=\"mytrueattr\"></div>") self.assertEqual( DIV(_id="my_id", _none=None, _false=False, without_underline="serius?").xml(), "<div id=\"my_id\"></div>") self.assertEqual( DIV("<b>xmlscapedthis</b>").xml(), "<div><b>xmlscapedthis</b></div>") self.assertEqual( DIV(XML("<b>don'txmlscapedthis</b>")).xml(), "<div><b>don'txmlscapedthis</b></div>")
def view_project(pid='0'): projectrow = db(db.project.id == pid).select().first() session['projid'] = pid if projectrow else 0 events = db(db.event.projid == pid).select(orderby=~db.event.startdatetime) actions = get_items(qtype='action', status='In Progress', project=pid) questions = get_items(qtype='quest', status='In Progress', project=pid) issues = get_items(qtype='issue', project=pid) res_actions = get_items(qtype='action', status='Resolved', project=pid, execstatus='Incomplete') comp_actions = get_items(qtype='action', status='Resolved', project=pid, execstatus='Completed') res_questions = get_items(qtype='question', status='Resolved', project=pid) if res_actions: projxml = get_gantt_data(res_actions) else: projxml = "<project></project>" db.comment.auth_userid.default = auth.user_id db.comment.parenttable.default = 'project' db.comment.parentid.default = pid commentform = Form(db.comment, formstyle=FormStyleBulma) return dict(projectid=pid, projectrow=projectrow, qactions=actions, questions=questions, issues=issues, res_actions=res_actions, res_questions=res_questions, comp_actions=comp_actions, events=events, get_class=get_class, get_disabled=get_disabled, myconverter=myconverter, project=XML(projxml), auth=auth, like=like, commentform=commentform)
def employees(path=None): queries = [(db.employee.id > 0)] orderby = [db.employee.last_name, db.employee.first_name] search_queries = [['Search by Company', lambda val: db.company.id == val, db.employee.company.requires], ['Search by Department', lambda val: db.department.id == val, db.employee.department.requires], ['Search by Name', lambda val: "first_name || ' ' || last_Name LIKE '%%%s%%'" % val]] search = GridSearch(search_queries, queries) fields = [db.employee.id, db.employee.first_name, db.employee.last_name, db.company.name, db.department.name, db.employee.hired, db.employee.supervisor, db.employee.active] grid = Grid(path, search.query, search_form=search.search_form, fields=fields, left=[db.company.on(db.employee.company == db.company.id), db.department.on(db.employee.department == db.department.id)], orderby=orderby, create=True, details=True, editable=True, deletable=True, **GRID_DEFAULTS) grid.formatters_by_type['boolean'] = lambda value: SPAN(I(_class='fas fa-check-circle')) if value else "" grid.formatters_by_type['date'] =lambda value: XML( '<script>document.write((new Date(%s,%s,%s)).toLocaleDateString({month: "2-digit", day: "2-digit", year: "numeric"}).split(",")[0])</script>' % (value.year, value.month, value.day,) ) return dict(grid=grid)
def produce(self, table, vars, errors, readonly, deletable, classes=None): self.classes.update(classes or {}) form = FORM( _method="POST", _action=request.url, _enctype="multipart/form-data" ) controls = dict( widgets=dict(), hidden_widgets=dict(), errors=dict(), begin=XML(form.xml().split("</form>")[0]), end=XML("</form>"), ) class_label = self.classes["label"] class_outer = self.classes["outer"] class_inner = self.classes["inner"] class_error = self.classes["error"] class_info = self.classes["info"] for field in table: input_id = "%s_%s" % (field.tablename, field.name) value = vars.get(field.name, field.default) error = errors.get(field.name) field_class = field.type.split()[0].replace(":", "-") if not field.readable and not field.writable: continue if not readonly and not field.writable: continue if field.type == "blob": # never display blobs (mistake?) continue if field.type == "id" and value is None: field.writable = False continue if readonly or field.type == "id": control = DIV(field.represent and field.represent(value) or value or "") elif field.widget: control = field.widget(table, value) elif field.type == "text": control = TEXTAREA(value or "", _id=input_id, _name=field.name) elif field.type == "date": control = INPUT( _value=value, _type="date", _id=input_id, _name=field.name ) elif field.type == "datetime": if isinstance(value, str): value = value.replace(" ", "T") control = INPUT( _value=value, _type="datetime-local", _id=input_id, _name=field.name ) elif field.type == "time": control = INPUT( _value=value, _type="time", _id=input_id, _name=field.name ) elif field.type == "boolean": control = INPUT( _type="checkbox", _id=input_id, _name=field.name, _value="ON", _checked=value, ) elif field.type == "upload": control = DIV(INPUT(_type="file", _id=input_id, _name=field.name)) if value: control.append(A("download", _href=field.download_url(value))) control.append( INPUT( _type="checkbox", _value="ON", _name="_delete_" + field.name ) ) control.append("(check to remove)") elif get_options(field.requires) is not None: multiple = field.type.startswith("list:") value = list(map(str, value if isinstance(value, list) else [value])) option_tags = [ OPTION(v, _value=k, _selected=(not k is None and k in value)) for k, v in get_options(field.requires) ] control = SELECT( *option_tags, _id=input_id, _name=field.name, _multiple=multiple ) else: field_type = "password" if field.type == "password" else "text" control = INPUT( _type=field_type, _id=input_id, _name=field.name, _value=value, _class=field_class, ) key = control.name.rstrip("/") if key == "input": key += "[type=%s]" % (control["_type"] or "text") control["_class"] = self.classes.get(key, "") controls["widgets"][field.name] = control if error: controls["errors"][field.name] = error form.append( DIV( LABEL(field.label, _for=input_id, _class=class_label), DIV(control, _class=class_inner), P(error, _class=class_error) if error else "", P(field.comment or "", _class=class_info), _class=class_outer, ) ) if 'id' in vars: form.append(INPUT(_name='id',_value=vars['id'],_hidden=True)) if deletable: controls["delete"] = INPUT( _type="checkbox", _value="ON", _name="_delete", _class=self.classes["input[type=checkbox]"], ) form.append( DIV( DIV(controls["delete"], _class=class_inner,), P("check to delete", _class="help"), _class=class_outer, ) ) controls["submit"] = INPUT( _type="submit", _value="Submit", _class=self.classes["input[type=submit]"], ) submit = DIV(DIV(controls["submit"], _class=class_inner,), _class=class_outer,) form.append(submit) return dict(form=form, controls=controls)
def __call__( self, table, vars, errors, readonly, deletable, noncreate, show_id, kwargs=None, ): kwargs = kwargs if kwargs else {} form_method = "POST" form_action = request.url.split(":", 1)[1] form_enctype = "multipart/form-data" form = FORM(_method=form_method, _action=form_action, _enctype=form_enctype, **kwargs) controls = Param( labels=dict(), widgets=dict(), wrappers=dict(), comments=dict(), hidden_widgets=dict(), placeholders=dict(), titles=dict(), errors=dict(), begin=XML(form.xml().split("</form>")[0]), submit="", delete="", end=XML("</form>"), ) json_controls = dict(form_fields=[], form_values=dict(), form_buttons=[], form_method=form_method, form_action=form_action, form_enctype=form_enctype, **kwargs) class_label = self.classes["label"] class_outer = self.classes["outer"] class_inner = self.classes["inner"] class_error = self.classes["error"] class_info = self.classes["info"] all_fields = [x for x in table] if "_virtual_fields" in dir(table): all_fields += table._virtual_fields for field in all_fields: # Reset the json control fields. field_attributes = dict() field_value = None field_name = field.name field_type = field.type field_comment = field.comment if field.comment else "" field_label = field.label input_id = "%s_%s" % (field.tablename, field.name) if isinstance(field, FieldVirtual): value = None else: value = vars.get( field.name, field.default() if callable(field.default) else field.default, ) error = errors.get(field.name) field_class = "type-" + field.type.split()[0].replace(":", "-") placeholder = (field._placeholder if "_placeholder" in field.__dict__ else None) title = field._title if "_title" in field.__dict__ else None field_disabled = False # only display field if readable or writable if not field.readable and not field.writable: continue # if this is a readonly field only show readable fields if readonly: if not field.readable: continue # do not show the id if not desired if field.type == "id" and not show_id: continue # if this is an create form (unkown id) then only show writable fields. # Some if an edit form was made from a list of fields and noncreate=True elif not vars.get("id") and noncreate: if not field.writable: continue # ignore blob fields if field.type == "blob": # never display blobs (mistake?) continue # ignore fields of type id its value is equal to None if field.type == "id" and value is None: field.writable = False continue # if the form is readonly or this is an id type field, display it as readonly if (readonly or not field.writable or field.type == "id" or isinstance(field, FieldVirtual)): # for boolean readonly we use a readonly checbox if field.type == "boolean": control = CheckboxWidget().make(field, value, error, title, readonly=True) # for all othe readonly fields we use represent or a string else: if isinstance(field, FieldVirtual): field_value = field.f(vars) else: field_value = (field.represent and field.represent(value) or value or "") field_type = "represent" control = DIV(field_value) field_disabled = True # if we have a field.widget for the field use it but this logic is deprecated elif field.widget: control = field.widget(table, vars) # else we pick the right widget else: if field.name in self.widgets: widget = self.widgets[field.name] elif field.type == "text": widget = TextareaWidget() elif field.type == "datetime": widget = DateTimeWidget() elif field.type == "boolean": widget = CheckboxWidget() elif field.type == "upload": widget = FileUploadWidget() url = getattr(field, "download_url", lambda value: "#")(value) # Set the download url. field_attributes["_download_url"] = url # Set the flag determining whether the file is an image. field_attributes["_is_image"] = ( url != "#") and Form.is_image(value) # do we need the variables below? delete_field_attributes = dict() delete_field_attributes["_label"] = "Remove" delete_field_attributes["_value"] = "ON" delete_field_attributes["_type"] = "checkbox" delete_field_attributes["_name"] = "_delete_" + field.name json_controls["form_fields"] += [delete_field_attributes] json_controls["form_values"]["_delete_" + field.name] = None elif get_options(field.requires) is not None: widget = SelectWidget() elif field.type == "password": widget = PasswordWidget() elif field.type.startswith("list:"): widget = ListWidget() else: widget = Widget() control = widget.make(field, value, error, title, placeholder) key = control.name.rstrip("/") if key == "input": key += "[type=%s]" % (control["_type"] or "text") control["_class"] = join_classes(control.attributes.get("_class"), self.classes.get(key)) # Set the form controls. controls["labels"][field_name] = field_label controls["widgets"][field_name] = control controls["comments"][field_name] = field_comment controls["titles"][field_name] = title controls["placeholders"][field_name] = placeholder # Set the remain json field attributes. field_attributes["_title"] = title field_attributes["_label"] = field_label field_attributes["_comment"] = field_comment field_attributes["_id"] = to_id(field) field_attributes["_class"] = field_class field_attributes["_name"] = field.name field_attributes["_type"] = field.type field_attributes["_placeholder"] = placeholder field_attributes["_error"] = error field_attributes["_disabled"] = field_disabled # Add to the json controls. json_controls["form_fields"] += [field_attributes] json_controls["form_values"][field_name] = field_value if error: controls["errors"][field.name] = error if field.type == "boolean": controls.wrappers[field.name] = wrapped = SPAN( control, _class=class_inner) form.append( DIV( wrapped, LABEL( " " + field.label, _for=input_id, _class=class_label, _style="display: inline !important", ), P(error, _class=class_error) if error else "", P(field.comment or "", _class=class_info), _class=class_outer, )) else: controls.wrappers[field.name] = wrapped = DIV( control, _class=self.class_inner_exceptions.get( control.name, class_inner), ) form.append( DIV( LABEL(field.label, _for=input_id, _class=class_label), wrapped, P(error, _class=class_error) if error else "", P(field.comment or "", _class=class_info), _class=class_outer, )) if vars.get("id"): form.append(INPUT(_name="id", _value=vars["id"], _hidden=True)) if deletable: deletable_record_attributes = dict() deletable_field_name = "_delete" deletable_field_type = "checkbox" # Set the deletable json field attributes. deletable_record_attributes["_label"] = " check to delete" deletable_record_attributes["_name"] = deletable_field_name deletable_record_attributes["_type"] = deletable_field_type deletable_record_attributes["_class"] = self.classes[ "input[type=checkbox]"] deletable_record_attributes["_value"] = "ON" # Add to the json controls. json_controls["form_fields"] += [deletable_record_attributes] json_controls["form_values"][deletable_field_name] = None controls["delete"] = INPUT( _type=deletable_field_type, _value=deletable_record_attributes["_value"], _name=deletable_field_name, _class=self.classes["input[type=checkbox]"], ) form.append( DIV( SPAN( controls["delete"], _class=class_inner, _stye="vertical-align: middle;", ), P( deletable_record_attributes["_label"], _class="help", _style="display: inline !important", ), _class=class_outer, )) submit_button_attributes = dict() submit_button_field_type = "submit" # Set the deletable json field attributes. submit_button_attributes["_label"] = "Submit" submit_button_attributes["_type"] = submit_button_field_type submit_button_attributes["_class"] = self.classes["input[type=submit]"] # Add to the json controls. json_controls["form_buttons"] += [submit_button_attributes] controls["submit"] = INPUT( _type=submit_button_field_type, _value="Submit", _class=self.classes["input[type=submit]"], ) submit = DIV( DIV( controls["submit"], _class=class_inner, ), _class=class_outer, ) form.append(submit) return dict(form=form, controls=controls, json_controls=json_controls)
def produce(self, table, vars, errors, readonly, deletable, classes=None): self.classes.update(classes or {}) form = FORM(_method="POST", _action=request.url, _enctype="multipart/form-data") controls = Param( labels=dict(), widgets=dict(), comments=dict(), hidden_widgets=dict(), placeholders=dict(), titles=dict(), errors=dict(), begin=XML(form.xml().split("</form>")[0]), submit="", delete="", end=XML("</form>"), ) class_label = self.classes["label"] class_outer = self.classes["outer"] class_inner = self.classes["inner"] class_error = self.classes["error"] class_info = self.classes["info"] for field in table: input_id = "%s_%s" % (field.tablename, field.name) value = vars.get(field.name, field.default) error = errors.get(field.name) field_class = "type-" + field.type.split()[0].replace(":", "-") placeholder = ( field._placeholder if "_placeholder" in field.__dict__ else None ) title = field._title if "_title" in field.__dict__ else None # only diplay field if readable or writable if not field.readable and not field.writable: continue # if this is a reaonly field only show readable fields if readonly: if not field.readable: continue # if this is an create form (unkown id) then only show writable fields elif not vars.get("id"): if not field.writable: continue # ignore blob fields if field.type == "blob": # never display blobs (mistake?) continue # ignore fields of type id its value is equal to None if field.type == "id" and value is None: field.writable = False continue # if the form is readonly or this is an id type field, display it as readonly if readonly or not field.writable or field.type == "id": if field.type == "boolean": control = INPUT( _type="checkbox", _id=input_id, _name=field.name, _value="ON", _disabled="", _checked=value, _title=title, ) else: control = DIV( field.represent and field.represent(value) or value or "" ) # if we have a widget for the field use it elif field.widget: control = field.widget(table, value) # else pick the proper default widget elif field.type == "text": control = TEXTAREA( value or "", _id=input_id, _name=field.name, _placeholder=placeholder, _title=title, ) elif field.type == "date": control = INPUT( _value=value, _type="date", _id=input_id, _name=field.name, _placeholder=placeholder, _title=title, ) elif field.type == "datetime": if isinstance(value, str): value = value.replace(" ", "T") control = INPUT( _value=value, _type="datetime-local", _id=input_id, _name=field.name, _placeholder=placeholder, _title=title, ) elif field.type == "time": control = INPUT( _value=value, _type="time", _id=input_id, _name=field.name, _placeholder=placeholder, _title=title, ) elif field.type == "boolean": control = INPUT( _type="checkbox", _id=input_id, _name=field.name, _value="ON", _checked=value, _title=title, ) elif field.type == "upload": control = DIV() if value and field.download_url is not None and not error: download_div = DIV() download_div.append( LABEL( "Currently: ", ) ) download_div.append( A(" download ", _href=field.download_url(value)) ) download_div.append( INPUT( _type="checkbox", _value="ON", _name="_delete_" + field.name, _title=title, ) ) download_div.append(" (check to remove)") control.append(download_div) control.append(LABEL("Change: ")) control.append(INPUT(_type="file", _id=input_id, _name=field.name)) elif get_options(field.requires) is not None and field.writable == True: multiple = field.type.startswith("list:") value = list(map(str, value if isinstance(value, list) else [value])) option_tags = [ OPTION(v, _value=k, _selected=(not k is None and k in value)) for k, v in get_options(field.requires) ] control = SELECT( *option_tags, _id=input_id, _name=field.name, _multiple=multiple, _title=title ) else: field_type = "password" if field.type == "password" else "text" if field.type.startswith("list:"): value = json.dumps(value or []) control = INPUT( _type=field_type, _id=input_id, _name=field.name, _value=None if field.type == "password" else value, _class=field_class, _placeholder=placeholder, _title=title, _autocomplete="off" if field_type == "password" else "on", ) key = control.name.rstrip("/") if key == "input": key += "[type=%s]" % (control["_type"] or "text") control["_class"] = ( control.attributes.get("_class", "") + " " + self.classes.get(key, "") ).strip() controls["labels"][field.name] = field.label controls["widgets"][field.name] = control controls["comments"][field.name] = field.comment if field.comment else "" controls["titles"][field.name] = title controls["placeholders"][field.name] = placeholder if error: controls["errors"][field.name] = error if field.type == "boolean": form.append( DIV( SPAN(control, _class=class_inner), LABEL( " " + field.label, _for=input_id, _class=class_label, _style="display: inline !important", ), P(error, _class=class_error) if error else "", P(field.comment or "", _class=class_info), _class=class_outer, ) ) else: form.append( DIV( LABEL(field.label, _for=input_id, _class=class_label), DIV(control, _class=class_inner), P(error, _class=class_error) if error else "", P(field.comment or "", _class=class_info), _class=class_outer, ) ) if vars.get("id"): form.append(INPUT(_name="id", _value=vars["id"], _hidden=True)) if deletable: controls["delete"] = INPUT( _type="checkbox", _value="ON", _name="_delete", _class=self.classes["input[type=checkbox]"], ) form.append( DIV( SPAN( controls["delete"], _class=class_inner, _stye="vertical-align: middle;", ), P( " check to delete", _class="help", _style="display: inline !important", ), _class=class_outer, ) ) controls["submit"] = INPUT( _type="submit", _value="Submit", _class=self.classes["input[type=submit]"], ) submit = DIV( DIV( controls["submit"], _class=class_inner, ), _class=class_outer, ) form.append(submit) return dict(form=form, controls=controls)
def render_table(self): html = DIV(**self.param.grid_class_style.get("grid-wrapper")) grid_header = DIV(**self.param.grid_class_style.get("grid-header")) # build the New button if needed if self.param.create and self.param.create != "": if isinstance(self.param.create, str): create_url = self.param.create else: create_url = self.endpoint + "/new" create_url += "?%s" % self.referrer grid_header.append( self.render_action_button( create_url, self.param.new_action_button_text, "fa-plus", icon_size="normal", override_classes=self.param.grid_class_style.classes.get( "grid-new-button", ""), override_styles=self.param.grid_class_style.get( "new_button"), )) # build the search form if provided if self.param.search_form: grid_header.append(self.render_search_form()) elif self.param.search_queries and len(self.param.search_queries) > 0: grid_header.append(self.render_default_form()) html.append(grid_header) table = TABLE(**self.param.grid_class_style.get("grid-table")) # build the header table.append(self.render_table_header()) # build the rows table.append(self.render_table_body()) # add the table to the html html.append( DIV(table, **self.param.grid_class_style.get("grid-table-wrapper"))) # add the row counter information footer = DIV(**self.param.grid_class_style.get("grid-footer")) row_count = DIV(**self.param.grid_class_style.get("grid-info")) row_count.append("Displaying rows %s thru %s of %s" % ( self.page_start + 1 if self.number_of_pages > 1 else 1, self.page_end if self.page_end < self.total_number_of_rows else self.total_number_of_rows, self.total_number_of_rows, )) if self.number_of_pages > 0 else row_count.append( "No rows to display") footer.append(row_count) # build the pager if self.number_of_pages > 1: footer.append(self.render_table_pager()) html.append(footer) return XML(html)
def __call__(self): """This method returns the element that can be included in the page.""" return XML(Grid.GRID.format(url=self.url()))