cformat=None,
style="text-align: left;",
icon="search",
ajax="false",
theme="a",
onclick="document.forms['frm_filter'].submit();",
cmd_id="filter_submit")
frm_filter.custom.widget.repname[
"_onkeydown"] = "if (event.keyCode == 13) document.getElementById('filter_submit').click()"
if not request.post_vars.has_key("ins_cmd"):
session.frm_filter = frm_filter.vars
dbs_reports = None
if frm_filter.vars.database and frm_filter.vars.database != "":
if ns.local.setEngine(
database=db.databases(id=frm_filter.vars.database).alias,
check_ndi=False,
created=False,
createdb=False):
query = (ns.db.ui_report.id > 0)
dbs_reports = []
if frm_filter.vars.repname and frm_filter.vars.repname != "":
query = query & (
(ns.db.ui_report.repname.lower().like(
"%" + str(request.post_vars.repname).lower() + "%")) |
(ns.db.ui_report.description.lower().like(
"%" + str(request.post_vars.repname).lower() + "%")))
if frm_filter.vars.label and frm_filter.vars.label != "":
groups_id = ns.valid.get_groups_id('nervatype',
frm_filter.vars.label)
if groups_id:
response.flash = str(ns.error_message)
flash=response.flash
frm_filter.process(keepvalues=True,onfailure=None)
frm_filter.errors.clear()
response.flash = flash
frm_filter.custom.submit = ui.control.get_mobil_button(label=T("Search"), href="#",
cformat=None, style="text-align: left;", icon="search", ajax="false", theme="a",
onclick= "document.forms['frm_filter'].submit();", cmd_id="filter_submit")
frm_filter.custom.widget.repname["_onkeydown"]="if (event.keyCode == 13) document.getElementById('filter_submit').click()"
if not request.post_vars.has_key("ins_cmd"):
session.frm_filter = frm_filter.vars
dbs_reports=None
if frm_filter.vars.database and frm_filter.vars.database!="":
if ns.local.setEngine(database=db.databases(id=frm_filter.vars.database).alias, check_ndi=False, created=False, createdb=False):
query = (ns.db.ui_report.id>0)
dbs_reports = []
if frm_filter.vars.repname and frm_filter.vars.repname!="":
query = query & ((ns.db.ui_report.repname.lower().like("%"+str(request.post_vars.repname).lower()+"%"))|
(ns.db.ui_report.description.lower().like("%"+str(request.post_vars.repname).lower()+"%")))
if frm_filter.vars.label and frm_filter.vars.label!="":
groups_id=ns.valid.get_groups_id('nervatype', frm_filter.vars.label)
if groups_id:
query = query & ((ns.db.ui_report.nervatype==groups_id))
else:
query = query & ((ns.db.ui_report.transtype==ns.valid.get_groups_id('transtype', frm_filter.vars.label)))
reportkey_rows = ns.db(query).select(ns.db.ui_report.reportkey,orderby=ns.db.ui_report.repname)
[dbs_reports.append(row.reportkey) for row in reportkey_rows]
else:
response.flash = str(ns.error_message)
icon="search",
ajax="false",
theme="a",
onclick="document.forms['frm_filter'].submit();",
cmd_id="filter_submit",
)
frm_filter.custom.widget.repname[
"_onkeydown"
] = "if (event.keyCode == 13) document.getElementById('filter_submit').click()"
if not request.post_vars.has_key("ins_cmd"):
session.frm_filter = frm_filter.vars
dbs_reports = None
if frm_filter.vars.database and frm_filter.vars.database != "":
if ns.local.setEngine(
database=db.databases(id=frm_filter.vars.database).alias, check_ndi=False, created=False, createdb=False
):
query = ns.db.ui_report.id > 0
dbs_reports = []
if frm_filter.vars.repname and frm_filter.vars.repname != "":
query = query & (
(ns.db.ui_report.repname.lower().like("%" + str(request.post_vars.repname).lower() + "%"))
| (ns.db.ui_report.description.lower().like("%" + str(request.post_vars.repname).lower() + "%"))
)
if frm_filter.vars.label and frm_filter.vars.label != "":
groups_id = ns.valid.get_groups_id("nervatype", frm_filter.vars.label)
if groups_id:
query = query & ((ns.db.ui_report.nervatype == groups_id))
else:
query = query & (
(ns.db.ui_report.transtype == ns.valid.get_groups_id("transtype", frm_filter.vars.label))
