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]) self.cached_helper = helper return self.cached_helper
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) for item in self.param.sidecar: helper["form"][-1][-1].append(item) if self.action: helper["_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"]) 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.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 make(self, field, value, error, title, placeholder="", readonly=False): field_id = to_id(field) control = DIV() if value and not error: download_div = DIV() if not readonly: download_div.append(LABEL("Currently: ", )) url = getattr(field, "download_url", lambda value: "#")(value) download_div.append(A(" download ", _href=url)) if not readonly: 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=field_id, _name=field.name)) return control
def render_default_form(self): seach_type = safe_int(request.query.get("seach_type", 0), default=0) seach_string = request.query.get("seach_string") options = [ OPTION(items[0], _value=k, _selected=(k == seach_type)) for k, items in enumerate(self.param.search_queries) ] hidden_fields = [ INPUT(_name=key, _value=request.query.get(key), _type="hidden") for key in request.query if not key in ("seach_type", "seach_string") ] form = FORM(*hidden_fields, **dict(_method="GET", _action=self.endpoint)) select = SELECT(*options, **dict(_name="seach_type",)) input = INPUT(_type="text", _name="seach_string", _value=seach_string,) submit = INPUT(_type="submit", _value="Search") clear_script = "document.querySelector('[name=seach_string]').value='';" clear = INPUT(_type="submit", _value="Clear", _onclick=clear_script) div = DIV(_id="grid-search", **self.param.grid_class_style.get("grid-search")) # we do not need classes for these elements tr = TR() if len(options) > 1: tr.append(TD(select)) tr.append(TD(input)) tr.append(TD(submit, clear)) form.append(TABLE(tr)) div.append(form) return div
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 helper(self): if self.accepted and not self.keep_values: self.vars.clear() if not self.cached_helper: helper = self.formstyle( self.table, self.vars, self.errors, self.readonly, self.deletable ) if self.formkey: helper.append( INPUT(_type="hidden", _name="_formkey", _value=self.formkey) ) for key in self.hidden or {}: helper.append(INPUT(_type="hidden", _name=key, _value=self.hidden[key])) self.cached_helper = helper return self.cached_helper
def render_search_form(self): _sf = DIV(_class='is-pulled-right', _style='padding-bottom: 1rem;') _sf.append(self.search_form.custom['begin']) _tr = TR() for field in self.search_form.table: _td = TD(_style='padding-right: .5rem;') if field.type == 'boolean': _td.append(self.search_form.custom['widgets'][field.name]) _td.append(field.label) else: _td.append(self.search_form.custom['widgets'][field.name]) if field.name in self.search_form.custom['errors'] and self.search_form.custom['errors'][ field.name]: _td.append(DIV(self.search_form.custom['errors'][field.name], _style="color:#ff0000")) _tr.append(_td) if self.search_button: _tr.append(TD(INPUT(_class='button', _type='submit', _value=self.search_button))) else: _tr.append(TD(self.search_form.custom['submit'])) _sf.append(TABLE(_tr)) for hidden_widget in self.search_form.custom['hidden_widgets'].keys(): _sf.append(self.search_form.custom['hidden_widgets'][hidden_widget]) _sf.append(self.search_form.custom['end']) return _sf
def make(self, field, value, error, title, placeholder="", readonly=False): return INPUT( _value=value, _type=self.type_map.get(field.type, "text"), _id=to_id(field), _name=field.name, _placeholder=placeholder, _title=title, _readonly=readonly, )
def make(self, field, value, error, title, placeholder="", readonly=False): return INPUT( _value=json.dumps(value or []), _type="text", _id=to_id(field), _name=field.name, _placeholder=placeholder, _title=title, _readonly=readonly, )
def make(self, field, value, error, title, placeholder="", readonly=False): return INPUT( _value=str(value).replace(" ", "T"), _type=self.input_type, _id=to_id(field), _name=field.name, _placeholder=placeholder, _title=title, _readonly=readonly, )
def make(self, field, value, error, title, placeholder="", readonly=False): """converts the widget to an HTML helper""" return INPUT( _value=value, _type=self.type_map.get(field.type, "text"), _id=to_id(field), _name=field.name, _placeholder=placeholder, _title=title, _readonly=readonly, )
def make(self, field, value, error, title, placeholder="", readonly=False): return INPUT( _value=value, _type="password", _id=to_id(field), _name=field.name, _placeholder=placeholder, _title=title, _autocomplete="OFF", _readonly=readonly, )
def make(self, field, value, error, title, placeholder=None, readonly=False): attrs = {} if readonly: attrs = {"_disabled": True} return INPUT( _type="checkbox", _id=to_id(field), _name=field.name, _value="ON", _checked=value, _readonly=readonly, **attrs )
def render_search_form(self): # TODO: Do we need this? div = DIV(_id="grid-search", **self.param.grid_class_style.get("grid-search")) div.append(self.param.search_form.custom["begin"]) tr = TR(**self.param.grid_class_style.get("search_form_tr")) for field in self.param.search_form.table: td = TD(**self.param.grid_class_style.get("search_form_td")) if field.type == "boolean": sb = DIV(**self.param.grid_class_style.get("search_boolean")) sb.append(self.param.search_form.custom["widgets"][field.name]) sb.append(field.label) td.append(sb) else: td.append(self.param.search_form.custom["widgets"][field.name]) td.append(self.param.search_form.custom["wrapped_widgets"][field.name]) if ( field.name in self.param.search_form.custom["errors"] and self.param.search_form.custom["errors"][field.name] ): td.append( DIV( self.param.search_form.custom["errors"][field.name], _style="color:#ff0000", ) ) tr.append(td) if self.param.search_button_text: tr.append( TD( INPUT( _class="button", _type="submit", _value=self.param.search_button_text, ), **self.param.grid_class_style.get("search_form_td"), ) ) else: tr.append( TD( self.param.search_form.custom["submit"], **self.param.grid_class_style.get("search_form_td"), ) ) div.append(TABLE(tr, **self.param.grid_class_style.get("search_form_table"))) for hidden_widget in self.param.search_form.custom["hidden_widgets"].keys(): div.append(self.param.search_form.custom["hidden_widgets"][hidden_widget]) div.append(self.param.search_form.custom["end"]) return div
def make(self, field, value, error, title, placeholder=None, readonly=False): return INPUT( _type="checkbox", _id=to_id(field), _name=field.name, _value="ON", _disabled="", _checked=value, _readonly=readonly, )
def make(self, field, value, error, title, placeholder="", readonly=False): if field.type == "list:string": _class = "type-list-string" elif field.type == "list:integer": _class = "type-list-integer" else: _class = "" return INPUT( _value=json.dumps(value or []), _type="text", _id=to_id(field), _name=field.name, _placeholder=placeholder, _title=title, _readonly=readonly, _class=_class, )
def make(self, field, value, error, title, placeholder="", readonly=False): control = DIV() field_id = to_id(field) value = list(map(str, value if isinstance(value, list) else [value])) field_options = [[k, v, (not k is None and k in value)] for k, v in get_options(field.requires) if k != ""] for k, v, selected in field_options: control.append( INPUT( v, _id=field_id, _value=k, _label=v, _name=field.name, _type="radio", _checked=selected, )) control.append(LABEL(v, _for=field_id)) return control
def radio_widget(field, values_dict): control = DIV() if "_table" in dir(field): tablename = field._table else: tablename = "no_table" for k, v in get_options(field.requires)[1:]: attrs = {} if values_dict and str(values_dict["order_type"]) == k: attrs["_checked"] = "ON" control.append( INPUT( v, _id="%s_%s" % (tablename, k), _value=k, _label=v, _name=field.name, _type="radio", **attrs, )) control.append(LABEL(v, _for="%s_%s" % (tablename, k))) return control
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 FormStyleDefault(table, vars, errors, readonly, deletable): form = FORM(TABLE(), _method='POST', _action='#', _enctype='multipart/form-data') for field in table: input_id = '%s_%s' % (field.tablename, field.name) value = field.formatter(vars.get(field.name)) error = errors.get(field.name) field_class = field.type.split()[0].replace(':', '-') if field.type == 'blob': # never display blobs (mistake?) continue elif readonly or field.type == 'id': if not field.readable: continue else: control = field.represent and field.represent( value) or value or '' elif not field.writable: continue 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 == '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=donwload_url(value))) control.append( INPUT(_type='checkbox', _value='ON', _name='_delete_' + field.name)) control.append('(check to remove)') elif hasattr(field.requires, 'options'): multiple = field.type.startswith('list:') value = value if isinstance(value, list) else [value] options = [ OPTION(v, _value=k, _selected=(k in value)) for k, v in field.requires.options() ] control = SELECT(*options, _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) form[0].append( TR(TD(LABEL(field.label, _for=input_id)), TD(control, DIV(error, _class='error') if error else ''), TD(field.comment or ''))) td = TD(INPUT(_type='submit', _value='Submit')) if deletable: td.append(INPUT(_type='checkbox', _value='ON', _name='_delete')) td.append('(check to delete)') form[0].append(TR(TD(), td, TD())) return form
def FormStyleDefault(table, vars, errors, readonly, deletable, classes=None): form = FORM(_method='POST',_action='#',_enctype='multipart/form-data') classes = classes or {} class_label = classes.get('label', '') class_outer = classes.get('outer', '') class_inner = classes.get('inner', '') class_error = classes.get('error', '') class_info = classes.get('info', '') for field in table: input_id = '%s_%s' % (field.tablename, field.name) value = field.formatter(vars.get(field.name)) error = errors.get(field.name) field_class = field.type.split()[0].replace(':','-') if field.type == 'blob': # never display blobs (mistake?) continue elif readonly or field.type=='id': if not field.readable: continue else: control = DIV(field.represent and field.represent(value) or value or '') elif not field.writable: continue 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 == '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=donwload_url(value))) control.append(INPUT(_type='checkbox',_value='ON', _name='_delete_'+field.name)) control.append('(check to remove)') elif hasattr(field.requires, 'options'): multiple = field.type.startswith('list:') value = list(map(str, value if isinstance(value, list) else [value])) options = [OPTION(v,_value=k,_selected=(k in value)) for k,v in field.requires.options()] control = SELECT(*options, _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'] = classes.get(key, '') 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 deletable: form.append(DIV(DIV(INPUT(_type='checkbox',_value='ON',_name='_delete', _class=classes.get('input[type=checkbox]')), _class=class_inner), P('check to delete',_class="help"), _class=class_outer)) submit = DIV(DIV(INPUT(_type='submit',_value='Submit', _class=classes.get('input[type=submit]')), _class=class_inner), _class=class_outer) form.append(submit) return form
def boolean_renderer(key, value, rec): if value is True: return INPUT(_type='checkbox',_readonly=True,_checked=True)
def filterlink(self, key): """creates an input to filter by key""" if not self.is_searchable(key): return "" return INPUT(_id="py4web-grid-filter-" + key, _class="py4web-grid-filter")
class Grid: FORMATTERS_BY_TYPE = { "boolean": lambda value: INPUT(_type="checkbox", _checked=value) if value else "", "datetime": lambda value: XML("<script>document.write((new Date(%s,%s,%s,%s,%s,%s)).toLocaleString())</script>" % ( value.year, value.month - 1, value.day, value.hour, value.minute, value.second, )) if value else "", "time": lambda value: XML( "<script>document.write((new Date(0, 0, 0,%s,%s,%s)).toLocaleString().split(', ')[1])</script>" % (value.hour, value.minute, value.second)) if value else "", "date": lambda value: XML( '<script>document.write((new Date(%s,%s,%s)).toLocaleString().split(",")[0])</script>' % ( value.year, value.month - 1, value.day, )) if value else "", "list:string": lambda value: ", ".join(str(x) for x in value) if value else "", "list:integer": lambda value: ", ".join(x for x in value) if value else "", "default": lambda value: str(value) if value is not None else "", } def __init__( self, path, query, search_form=None, search_queries=None, fields=None, show_id=False, orderby=None, left=None, headings=None, create=True, details=True, editable=True, deletable=True, pre_action_buttons=None, post_action_buttons=None, auto_process=True, rows_per_page=15, include_action_button_text=True, search_button_text="Filter", formstyle=FormStyleDefault, grid_class_style=GridClassStyle, ): """ Grid is a searchable/sortable/pageable grid :param path: The part of the URL to be parsed by this grid :param query: the query used to filter the data :param search_form: py4web FORM to be included as the search form :param search_queries: future use - pass a dict of name and a search query :param fields: list of fields to display on the list page, if blank, glean tablename from first query : and use all fields of that table :param show_id: show the record id field on list page - default = False :param orderby: pydal orderby field or list of fields :param left: if joining other tables, specify the pydal left expression here :param headings: list of headings to be used for list page - if not provided use the field label :param create: URL to redirect to for creating records - set to False to not display the button :param editable: URL to redirect to for editing records - set to False to not display the button :param deletable: URL to redirect to for deleting records - set to False to not display the button :param pre_action_buttons: list of action_button instances to include before the standard action buttons :param post_action_buttons: list of action_button instances to include after the standard action buttons :param auto_process: True/False - automatically process the sql for the form - if False, user is responsible for calling process(). """ # in case the query is a Table instead if isinstance(query, query._db.Table): query = query._id != None self.path = path or "" self.db = query._db self.param = Param( query=query, fields=fields, show_id=show_id, orderby=orderby, left=left, search_form=search_form, search_queries=search_queries, headings=headings or [], create=create, details=details, editable=editable, deletable=deletable, pre_action_buttons=pre_action_buttons, post_action_buttons=post_action_buttons, rows_per_page=rows_per_page, include_action_button_text=include_action_button_text, search_button_text=search_button_text, formstyle=formstyle, grid_class_style=grid_class_style, new_sidecar=None, new_submit_value=None, new_action_button_text="New", details_sidecar=None, details_submit_value=None, details_action_button_text="Details", edit_sidecar=None, edit_submit_value=None, edit_action_button_text="Edit", delete_action_button_text="Delete", htmx_target=None, ) # instance variables that will be computed self.action = None self.current_page_number = None self.endpoint = request.fullpath if self.path: self.endpoint = self.endpoint[:-len(self.path)].rstrip("/") self.hidden_fields = None self.form = None self.number_of_pages = None self.page_end = None self.page_start = None self.query_parms = request.params self.readonly_fields = None self.record_id = None self.rows = None self.tablename = None self.total_number_of_rows = None self.use_tablename = self.is_join() self.formatters = {} self.formatters_by_type = copy.copy(Grid.FORMATTERS_BY_TYPE) if auto_process: self.process() def process(self): query = None db = self.db if not self.param.search_form and self.param.search_queries: search_type = safe_int(request.query.get("search_type", 0), default=0) search_string = request.query.get("search_string") if search_type < len(self.param.search_queries) and search_string: query_lambda = self.param.search_queries[search_type][1] try: query = query_lambda(search_string) except: pass # flash a message here if not query: query = self.param.query else: query &= self.param.query parts = self.path.split("/") self.action = parts[0] or "select" self.tablename = self.get_tablenames( self.param.query)[0] # what if there ar 2? self.record_id = safe_int(parts[1] if len(parts) > 1 else None, default=None) if self.param.fields: if not isinstance(self.param.fields, list): self.param.fields = [self.param.fields] else: table = db[self.tablename] self.param.fields = [field for field in table if field.readable] self.readonly_fields = [ field for field in self.param.fields if not field.writable ] self.referrer = None if not self.tablename: raise HTTP(400) if self.action in ["new", "details", "edit"]: # SECURITY: if the record does not exist or does not match query, than we are not allowed if self.record_id: if (db((db[self.tablename]._id == self.record_id) & self.param.query).count() == 0): redirect(self.endpoint) ## maybe flash readonly = self.action == "details" for field in self.readonly_fields: db[field.tablename][field.name].writable = False if not self.param.show_id: # if not show id, find the "id" field and set readable/writable to False for field in db[self.tablename]: if field.type == "id": db[self.tablename][field.name].readable = False db[self.tablename][field.name].writable = False attrs = ({ "_hx-post": request.url, "_hx-target": self.param.htmx_target, "_hx-swap": "innertHTML", } if self.param.htmx_target else {}) self.form = Form( db[self.tablename], record=self.record_id, readonly=readonly, formstyle=self.param.formstyle, **attrs, ) if self.action == "new": if self.param.new_sidecar: self.form.param.sidecar.append(self.param.new_sidecar) if self.param.new_submit_value: self.form.param.submit_value = self.param.new_submit_value if self.action == "details": if self.param.details_sidecar: self.form.param.sidecar.append(self.param.details_sidecar) if self.param.details_submit_value: self.form.param.submit_value = self.param.details_submit_value if self.action == "edit": if self.param.edit_sidecar: self.form.param.sidecar.append(self.param.edit_sidecar) if self.param.edit_submit_value: self.form.param.submit_value = self.param.edit_submit_value # SECURITY: if the new record was created but does not match filter, delete it if self.form.accepted and not self.record_id: new_record = db[self.tablename]._id == self.form.vars["id"] if db(new_record & self.param.query).count() == 0: db(new_record).delete() # TODO: SHOULD FLASH SOME MESSAGE # redirect to the referrer if self.form.accepted or (readonly and request.method == "POST"): referrer = request.query.get("_referrer") if referrer: redirect( base64.b16decode( referrer.encode("utf8")).decode("utf8")) else: redirect(self.endpoint) elif self.action == "delete": db(db[self.tablename].id == self.record_id).delete() url = parse_referer() if url and url.query: self.endpoint += "?%s" % url.query redirect(self.endpoint) elif self.action == "select": self.referrer = "_referrer=%s" % base64.b16encode( request.url.encode("utf8")).decode("utf8") # find the primary key of the primary table pt = db[self.tablename] key_is_missing = True for field in self.param.fields: if (field.table._tablename == pt._tablename and field.name == pt._id.name): key_is_missing = False if key_is_missing: # primary key wasn't included, add it and set show_id to False so it doesn't display self.param.fields.append(pt._id) self.param.show_id = False self.current_page_number = safe_int(request.query.get("page"), default=1) select_params = dict() # try getting sort order from the request sort_order = request.query.get("orderby", "") try: parts = sort_order.lstrip("~").split(".") orderby = db[parts[0]][parts[1]] if sort_order.startswith("~"): orderby = ~orderby select_params["orderby"] = orderby except (IndexError, KeyError, TypeError, AttributeError): select_params["orderby"] = self.param.orderby if self.param.left: select_params["left"] = self.param.left if self.param.left: # TODO: maybe this can be made more efficient self.total_number_of_rows = len( db(query).select(db[self.tablename].id, **select_params)) else: self.total_number_of_rows = db(query).count() # if at a high page number and then filter causes less records to be displayed, reset to page 1 if (self.current_page_number - 1) * self.param.rows_per_page > self.total_number_of_rows: self.current_page_number = 1 if self.total_number_of_rows > self.param.rows_per_page: self.page_start = self.param.rows_per_page * ( self.current_page_number - 1) self.page_end = self.page_start + self.param.rows_per_page select_params["limitby"] = (self.page_start, self.page_end) else: self.page_start = 0 if self.total_number_of_rows > 1: self.page_start = 1 self.page_end = self.total_number_of_rows if self.param.fields: self.rows = db(query).select(*self.param.fields, **select_params) else: self.rows = db(query).select(**select_params) self.number_of_pages = self.total_number_of_rows // self.param.rows_per_page if self.total_number_of_rows % self.param.rows_per_page > 0: self.number_of_pages += 1 else: redirect(self.endpoint) def iter_pages( self, current_page, num_pages, left_current=1, right_current=1, left_edge=1, right_edge=1, ): """ generator used to determine which page numbers should be shown on the Grid pager :param left_current: # of pages to add to the left of current page :param right_current: # of fpages to add to the right of current page :param left_edge: # of pages to add to the left end :param right_edge: # of fpages to add to the right end """ left_range = set(range(1, min(2 + left_edge, num_pages + 1))) mid_range = set( range( max(1, current_page - left_current), min(current_page + right_current + 1, num_pages + 1), )) right_range = set(range(max(1, num_pages - right_edge), num_pages + 1)) return list(sorted(left_range | mid_range | right_range)) 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) if self.param.htmx_target: attr["_hx-get"] = url attr["_hx-target"] = self.param.htmx_target attr["_hx-swap"] = "innertHTML" else: attr["_href"] = url link = A( I(_class="fa %s" % icon), _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 render_default_form(self): search_type = safe_int(request.query.get("search_type", 0), default=0) search_string = request.query.get("search_string") options = [ OPTION(items[0], _value=k, _selected=(k == search_type)) for k, items in enumerate(self.param.search_queries) ] hidden_fields = [ INPUT(_name=key, _value=request.query.get(key), _type="hidden") for key in request.query if not key in ("search_type", "search_string") ] if self.param.htmx_target: attrs = { "_hx-post": self.endpoint, "_hx-target": self.param.htmx_target, "_hx-swap": "innertHTML", } else: attrs = {"_method": "GET", "_action": self.endpoint} form = FORM(*hidden_fields, **attrs) select = SELECT( *options, **dict(_name="search_type", ), ) input = INPUT( _type="text", _name="search_string", _value=search_string, ) submit = INPUT(_type="submit", _value="Search") clear_script = "document.querySelector('[name=search_string]').value='';" clear = INPUT(_type="submit", _value="Clear", _onclick=clear_script) div = DIV(_id="grid-search", **self.param.grid_class_style.get("grid-search")) # we do not need classes for these elements tr = TR() if len(options) > 1: tr.append(TD(select)) tr.append(TD(input)) tr.append(TD(submit, clear)) form.append(TABLE(tr)) div.append(form) return div def render_search_form(self): # TODO: Do we need this? div = DIV(_id="grid-search", **self.param.grid_class_style.get("grid-search")) div.append(self.param.search_form.custom["begin"]) tr = TR(**self.param.grid_class_style.get("search_form_tr")) for field in self.param.search_form.table: td = TD(**self.param.grid_class_style.get("search_form_td")) if field.type == "boolean": sb = DIV(**self.param.grid_class_style.get("search_boolean")) sb.append(self.param.search_form.custom["widgets"][field.name]) sb.append(field.label) td.append(sb) else: td.append(self.param.search_form.custom["widgets"][field.name]) if (field.name in self.param.search_form.custom["errors"] and self.param.search_form.custom["errors"][field.name]): td.append( DIV( self.param.search_form.custom["errors"][field.name], _style="color:#ff0000", )) tr.append(td) if self.param.search_button_text: tr.append( TD( INPUT( _class="button", _type="submit", _value=self.param.search_button_text, ), **self.param.grid_class_style.get("search_form_td"), )) else: tr.append( TD( self.param.search_form.custom["submit"], **self.param.grid_class_style.get("search_form_td"), )) div.append( TABLE(tr, **self.param.grid_class_style.get("search_form_table"))) for hidden_widget in self.param.search_form.custom[ "hidden_widgets"].keys(): div.append( self.param.search_form.custom["hidden_widgets"][hidden_widget]) div.append(self.param.search_form.custom["end"]) return div def render_table_header(self): up = I(**self.param.grid_class_style.get("grid-sorter-icon-up")) dw = I(**self.param.grid_class_style.get("grid-sorter-icon-down")) columns = [] sort_order = request.query.get("orderby", "") for index, field in enumerate(self.param.fields): if field.readable and (field.type != "id" or self.param.show_id): key = "%s.%s" % (field.tablename, field.name) heading = (self.param.headings[index] if index < len(self.param.headings) else field.label) heading = title(heading) # add the sort order query parm sort_query_parms = dict(self.query_parms) if key == sort_order: sort_query_parms["orderby"] = "~" + key href = URL(self.endpoint, vars=sort_query_parms) col = A(heading, up, _href=href) else: sort_query_parms["orderby"] = key href = URL(self.endpoint, vars=sort_query_parms) col = A(heading, dw if "~" + key == sort_order else "", _href=href) columns.append((key, col)) thead = THEAD( _class=self.param.grid_class_style.classes.get("grid-thead", "")) for key, col in columns: col_class = " grid-col-%s" % key thead.append( TH( col, _class=self.param.grid_class_style.classes.get( "grid-th", "") + col_class, _style=self.param.grid_class_style.styles.get("grid-th"), )) if (self.param.details or self.param.editable or self.param.deletable or self.param.pre_action_buttons or self.param.post_action_buttons): thead.append( TH("", **self.param.grid_class_style.get("grid-th-action-button"))) return thead def render_field(self, row, field, field_index): """ 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] key = "%s.%s" % (field.tablename, field.name) formatter = (self.formatters.get(key) or self.formatters_by_type.get(field.type) or self.formatters_by_type.get("default")) class_type = "grid-cell-type-%s" % str( field.type).split(":")[0].split("(")[0] class_col = " grid-col-%s" % key td = TD( formatter(field_value), _class=(self.param.grid_class_style.classes.get("grid-td", "") + " " + class_type if class_type not in self.param.grid_class_style.classes.get( class_type, "").split(" ") else "" + " " + self.param.grid_class_style.classes.get(class_type, "") + " " + class_col).strip(), _style=(self.param.grid_class_style.styles.get(class_type) or self.param.grid_class_style.styles.get("grid-td")), ) return td def render_table_body(self): tbody = TBODY() for row in self.rows: # find the row id - there may be nested tables.... if self.use_tablename and self.tablename in row and "id" not in row: row_id = row[self.tablename]["id"] else: row_id = row["id"] self.use_tablename = False tr = TR( _role="row", _class=self.param.grid_class_style.classes.get("grid-tr"), _style=self.param.grid_class_style.styles.get("grid-tr"), ) # add all the fields to the row for index, field in enumerate(self.param.fields): if field.readable and (field.type != "id" or self.param.show_id): tr.append(self.render_field(row, field, index)) td = None # add the action buttons if ((self.param.details and self.param.details != "") or (self.param.editable and self.param.editable != "") or (self.param.deletable and self.param.deletable != "") or (self.param.post_action_buttons or self.param.pre_action_buttons)): classes = ( self.param.grid_class_style.classes.get("grid-td", "") + " " + self.param.grid_class_style.classes.get( "grid-td-action-button")).strip() styles = ( self.param.grid_class_style.styles.get("grid-td", "") + " " + self.param.grid_class_style.styles.get( "grid-td-action-button")).strip() td = TD(_class=classes, _style=styles) if self.param.pre_action_buttons: for btn in self.param.pre_action_buttons: if btn.onclick: btn.url = None td.append( self.render_action_button( btn.url, btn.text, btn.icon, _onclick=btn.onclick, additional_classes=btn.additional_classes, message=btn.message, row_id=row_id if btn.append_id else None, row=row, )) if self.param.details and self.param.details != "": if isinstance(self.param.details, str): details_url = self.param.details else: details_url = self.endpoint + "/details" details_url += "/%s?%s" % (row_id, self.referrer) td.append( self.render_action_button( details_url, self.param.details_action_button_text, "fa-id-card", name="grid-details-button", )) if self.param.editable and self.param.editable != "": if isinstance(self.param.editable, str): edit_url = self.param.editable else: edit_url = self.endpoint + "/edit" edit_url += "/%s?%s" % (row_id, self.referrer) td.append( self.render_action_button( edit_url, self.param.edit_action_button_text, "fa-edit", name="grid-edit-button", )) if self.param.deletable and self.param.deletable != "": if isinstance(self.param.deletable, str): delete_url = self.param.deletable else: delete_url = self.endpoint + "/delete" delete_url += "/%s?%s" % (row_id, self.referrer) td.append( self.render_action_button( delete_url, self.param.delete_action_button_text, "fa-trash", additional_classes="confirmation", message="Delete record", name="grid-delete-button", _onclick= "if(!confirm('sure you want to delete')) return false;", )) if self.param.post_action_buttons: for btn in self.param.post_action_buttons: if btn.onclick: btn.url = None td.append( self.render_action_button( btn.url, btn.text, btn.icon, _onclick=btn.onclick, additional_classes=btn.additional_classes, message=btn.message, row_id=row_id if btn.append_id else None, row=row, )) tr.append(td) tbody.append(tr) return tbody def render_table_pager(self): pager = DIV(**self.param.grid_class_style.get("grid-pagination")) previous_page_number = None for page_number in self.iter_pages(self.current_page_number, self.number_of_pages): pager_query_parms = dict(self.query_parms) pager_query_parms["page"] = page_number # if there is a gat add a spacer if previous_page_number and page_number - previous_page_number > 1: pager.append(SPAN("...", _style="margin:0 10px;")) is_current = self.current_page_number == page_number page_name = ("grid-pagination-button-current" if is_current else "grid-pagination-button") attrs = ({ "_hx-get": URL(self.endpoint, vars=pager_query_parms), "_hx-target": self.param.htmx_target, "_hx-swap": "innertHTML", } if self.param.htmx_target else { "_href": URL(self.endpoint, vars=pager_query_parms) }) pager.append( A( page_number, **self.param.grid_class_style.get(page_name), _role="button", **attrs, )) previous_page_number = page_number return pager 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 render(self): """ build the query table :return: html representation of the table or the py4web Form object """ if self.action == "select": return self.render_table() elif self.action in ["new", "details", "edit"]: return self.form def data(self): """ get the record that is being edited / displayed :return: DAL record of the record being edited """ return (self.db[self.tablename](self.record_id) if self.tablename and self.record_id else None) def add_search_query(self, name, query, requires): if self.param.search_form: raise ValueError( "Cannot add search queries if a you provide a search_form to the grid call " "or if auto_process is set to True. Ensure no search_form is set, set " "auto_process to False, add your search query and then call grid.process()." ) if self.param.search_queries is None: self.param.search_queries = [] self.param.search_queries.append([name, query, requires]) def get_tablenames(self, *args): """Returns the tablenames used by this grid""" return list(self.db._adapter.tables(*args).keys()) def is_join(self): items = [self.param.query] if self.param.left is not None: if isinstance(self.param.left, (list, tuple)): items += [item for item in self.param.left] else: items += [self.param.left] return len(self.get_tablenames(*items)) > 1
def example_helpers(): return dict(a=H1("I am a title"), b=2, c=dict(d=3, e=4, x=INPUT(_name="test")))
def showme(): return dict(a=H1("I am a title"), b=2, c=dict(d=3, e=4, x=INPUT(_name="test")))
def produce( self, table, vars, errors, readonly, noncreate, deletable, classes=None, class_inner_exceptions=None, kwargs=None, ): self.classes.update(classes or {}) self.class_inner_exceptions.update(class_inner_exceptions or {}) kwargs = kwargs if kwargs else {} form_method = "POST" form_action = request.url form_enctype = "multipart/form-data" form = FORM( _method=form_method, _action=form_action, _enctype=form_enctype, **kwargs ) 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>"), ) 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"] for field in table: # 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) 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 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. 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": if field.type == "boolean": field_value = value field_type = "checkbox" control = INPUT( _type=field_type, _id=input_id, _name=field_name, _value="ON", _disabled="", _checked=value, _title=title, ) 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 widget for the field use it elif field.widget: control = field.widget(table, value) # Grab the custom widget attributes. field_attributes = control.attributes field_type = "widget" field_value = value # else pick the proper default widget elif field.type == "text": field_value = value or "" field_type = "text" control = TEXTAREA( field_value, _id=input_id, _name=field_name, _placeholder=placeholder, _title=title, ) elif field.type == "date": field_value = value field_type = "date" control = INPUT( _value=field_value, _type="date", _id=input_id, _name=field_name, _placeholder=placeholder, _title=title, ) elif field.type == "datetime": helpervalue = str(value) helpervalue = helpervalue.replace(" ", "T") field_value = helpervalue field_type = "datetime-local" control = INPUT( _value=helpervalue, _type="datetime-local", _id=input_id, _name=field_name, _placeholder=placeholder, _title=title, ) elif field.type == "time": field_value = value field_type = "time" control = INPUT( _value=value, _type="time", _id=input_id, _name=field_name, _placeholder=placeholder, _title=title, ) elif field.type == "boolean": field_value = value field_type = "checkbox" field_attributes["_value"] = "ON" control = INPUT( _type="checkbox", _id=input_id, _name=field_name, _value=field_attributes["_value"], _checked=value, _title=title, ) elif field.type == "upload": control = DIV() if value and not error: download_div = DIV() download_div.append( LABEL( "Currently: ", ) ) if getattr(field, "download_url", None): url = field.download_url(value) else: url = "#" download_div.append(A(" download ", _href=url)) # 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 ) delete_checkbox_name = "_delete_" + field_name download_div.append( INPUT( _type="checkbox", _value="ON", _name=delete_checkbox_name, _title=title, ) ) download_div.append(" (check to remove)") delete_field_attributes = dict() delete_field_attributes["_label"] = "Remove" delete_field_attributes["_value"] = "ON" delete_field_attributes["_type"] = "checkbox" delete_field_attributes["_name"] = delete_checkbox_name json_controls["form_fields"] += [delete_field_attributes] json_controls["form_values"][delete_checkbox_name] = None control.append(download_div) control.append(LABEL("Change: ")) control.append(INPUT(_type="file", _id=input_id, _name=field_name)) field_value = None field_type = "file" 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])) field_options = [ [k, v, (not k is None and k in value)] for k, v in get_options(field.requires) ] option_tags = [ OPTION(v, _value=k, _selected=_selected) for (k, v, _selected) in field_options ] control = SELECT( *option_tags, _id=input_id, _name=field_name, _multiple=multiple, _title=title ) field_value = value field_type = "options" field_attributes["_multiple"] = multiple field_attributes["_options"] = field_options else: field_type = "password" if field.type == "password" else "text" if field.type.startswith("list:"): value = json.dumps(value or []) field_value = None if field.type == "password" else value field_autocomplete = "off" if field_type == "password" else "on" control = INPUT( _type=field_type, _id=input_id, _name=field_name, _value=field_value, _class=field_class, _placeholder=placeholder, _title=title, _autocomplete=field_autocomplete, ) field_attributes["_autocomplete"] = field_autocomplete 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() # 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"] = input_id 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": 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=self.class_inner_exceptions.get( control.name, 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: 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 = 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 FormStyleDefault(table, vars, errors, readonly, deletable, classes=None): form = FORM(_method="POST", _action=request.path, _enctype="multipart/form-data") classes = classes or {} class_label = classes.get("label", "") class_outer = classes.get("outer", "") class_inner = classes.get("inner", "") class_error = classes.get("error", "") class_info = classes.get("info", "") for field in table: input_id = "%s_%s" % (field.tablename, field.name) value = vars.get(field.name) error = errors.get(field.name) field_class = field.type.split()[0].replace(":", "-") if not field.readable: 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: 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 == "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 hasattr(field.requires, "options"): multiple = field.type.startswith("list:") value = list( map(str, value if isinstance(value, list) else [value])) options = [ OPTION(v, _value=k, _selected=(not k is None and k in value)) for k, v in field.requires.options() ] control = SELECT(*options, _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"] = classes.get(key, "") 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 deletable: form.append( DIV( DIV( INPUT( _type="checkbox", _value="ON", _name="_delete", _class=classes.get("input[type=checkbox]"), ), _class=class_inner, ), P("check to delete", _class="help"), _class=class_outer, )) submit = DIV( DIV( INPUT( _type="submit", _value="Submit", _class=classes.get("input[type=submit]"), ), _class=class_inner, ), _class=class_outer, ) form.append(submit) return form