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()))