def get_display(my):
search_type = "prod/asset"
web = WebContainer.get_web()
related_asset = web.get_form_value("edit|related")
search = Search(search_type)
search.add_filter("code", related_asset)
sobjects = search.get_sobjects()
labels = "|".join( ["%s - %s" % (x.get_code(), x.get_value("name") ) for x in sobjects ] )
values = "|".join( [x.get_code() for x in sobjects ] )
select = SelectWdg( my.get_input_name() )
select.set_persist_on_submit()
select.set_option("values", values)
select.set_option("labels", labels)
select.set_option("web_state","true")
return select
def get_display(my):
search_type = "prod/asset"
web = WebContainer.get_web()
related_asset = web.get_form_value("edit|related")
search = Search(search_type)
search.add_filter("code", related_asset)
sobjects = search.get_sobjects()
labels = "|".join([
"%s - %s" % (x.get_code(), x.get_value("name")) for x in sobjects
])
values = "|".join([x.get_code() for x in sobjects])
select = SelectWdg(my.get_input_name())
select.set_persist_on_submit()
select.set_option("values", values)
select.set_option("labels", labels)
select.set_option("web_state", "true")
return select
def get_display(self):
type = self.kwargs.get("type")
if type not in ['string', 'varchar', 'float', 'integer', 'timestamp', 'login']:
print("WARNING: FilterWdg: type [%s] not supported, using 'string'" % type)
type = 'string'
filter_span = SpanWdg()
web = WebContainer.get_web()
if type in ["string", "varchar"]:
relations = ["is", "is not", "contains", "does not contain", "is empty", "starts with", "ends with"]
relation_select = SelectWdg("%s_relation" % self.prefix)
relation_select.set_option("values", relations)
relation_select.set_persist_on_submit()
self.set_filter_value(relation_select)
filter_span.add(relation_select)
value_text = TextWdg("%s_value" % self.prefix)
value_text.set_persist_on_submit()
self.set_filter_value(value_text)
filter_span.add(value_text)
elif type in ['integer', 'float', 'currency']:
relations = ["is equal to", "is greater than", "is less than"]
relation_select = SelectWdg("%s_relation" % self.prefix)
relation_select.set_option("values", relations)
relation_select.set_persist_on_submit()
self.set_filter_value(relation_select)
filter_span.add(relation_select)
value_text = TextWdg("%s_value" % self.prefix)
value_text.set_persist_on_submit()
self.set_filter_value(value_text)
filter_span.add(value_text)
elif type == 'timestamp':
relations = ["is newer than", "is older than"]
relation_select = SelectWdg("%s_relation" % self.prefix)
relation_select.set_option("values", relations)
relation_select.set_persist_on_submit()
self.set_filter_value(relation_select)
filter_span.add(relation_select)
options = ["1 day", '2 days', '1 week', '1 month']
another_select = SelectWdg("%s_select" % self.prefix)
another_select.add_empty_option("-- Select --")
another_select.set_option("values", options)
another_select.set_persist_on_submit()
self.set_filter_value(another_select)
filter_span.add(another_select)
filter_span.add(" or ")
value_text = TextWdg("%s_value" % self.prefix)
value_text.set_persist_on_submit()
self.set_filter_value(value_text)
filter_span.add(value_text)
elif type in ['login']:
relations = ["is", "is not", "contains", "does not contain", "is empty", "starts with", "ends with"]
relation_select = SelectWdg("%s_relation" % self.prefix)
relation_select.set_option("values", relations)
relation_select.set_persist_on_submit()
self.set_filter_value(relation_select)
filter_span.add(relation_select)
value_text = CheckboxWdg("%s_user" % self.prefix)
value_text.set_persist_on_submit()
self.set_filter_value(value_text)
filter_span.add(value_text)
filter_span.add("{user}")
filter_span.add(" or ")
value_text = TextWdg("%s_value" % self.prefix)
value_text.set_persist_on_submit()
self.set_filter_value(value_text)
filter_span.add(value_text)
return filter_span
span.add(select)
div.add(span)
# make sure the current selection exists
try:
SearchType.get(search_type)
except SearchException, e:
return div
except SqlException, e:
return div
# add the view selector
view_select = SelectWdg("view")
view_select.add_empty_option("-- View --")
view_select.add_event("onchange", "document.form.submit()")
view_select.set_persist_on_submit()
#view_select.set_persistence()
span = SpanWdg(css="med")
span.add("Defined Views: ")
span.add(view_select)
div.add(span)
div.add(my.get_create_view_wdg(search_type))
div.add(HtmlElement.br(2))
div.add(my.get_new_tab_wdg())
widget.add(div)
search = Search("sthpw/widget_config")
def get_display(my):
web = WebContainer.get_web()
naming_util = NamingUtil()
if not my.widget_name:
my.widget_name = my.get_name()
# get the sobject required by this input
sobject = my.get_current_sobject()
if not sobject:
sobject = Search.get_by_id(my.search_type, my.search_id)
if my.new_sample_name:
my.new_sample_name.replace("//", "/")
else:
my.new_sample_name = sobject.get_value(my.widget_name)
widget = DivWdg()
widget.set_id("naming")
widget.add_style("display: block")
# set the sample text
div = DivWdg()
div.add("Sample name: <i>%s</i>" % my.new_sample_name)
div.add(HtmlElement.br(2))
new_sample_wdg = ProdIconButtonWdg("Set New Sample")
new_sample_wdg.add_event("onclick", "toggle_display('generate')")
div.add(new_sample_wdg)
generate = DivWdg()
generate.add(HtmlElement.br())
generate.set_id("generate")
generate.add_style("display: none")
sample_text = TextWdg("new_sample_name")
sample_text.set_option("size", "30")
# sample_text.set_persist_on_submit()
# if my.new_sample_name:
# sample_text.set_value(my.new_sample_name)
generate.add(sample_text)
button = IconButtonWdg("Generate", IconWdg.REFRESH, long=True)
on_script = my.setup_ajax("naming")
button.add_event("onclick", on_script)
generate.add(button)
generate.add(HtmlElement.br(2))
div.add(generate)
widget.add(div)
hidden = TextWdg(my.widget_name)
value = my.naming
hidden.set_value(my.new_sample_name)
widget.add(my.widget_name)
widget.add(hidden)
# get all of the parts
# TODO: not sure if this should be dictated by the sample name
# break up the name into parts
import re
if my.new_sample_name:
tmp = my.new_sample_name.strip("/")
parts = re.split("[\\/._]", tmp)
print "parts: ", parts
else:
return widget
# if there is a naming, then populate that
if my.edit_search_type:
options = naming_util.get_options(my.edit_search_type)
else:
options = naming_util.get_options(sobject.get_value("search_type"))
table = Table()
type_values = []
padding_values = []
for idx, part in enumerate(parts):
table.add_row()
table.add_cell(part)
type_select = SelectWdg("type_%s" % idx)
type_select.add_empty_option("-- Explicit --")
type_select.set_persist_on_submit()
type_select.set_option("values", "|".join(options))
type_values.append(type_select.get_value())
td = table.add_cell(type_select)
widget.add(table)
return widget
def get_display(my):
# if no filters are defined, then display nothing
if not my.filters:
return Widget()
#filter_top = DivWdg(css="maq_search_bar")
filter_top = DivWdg()
filter_top.add_color("color", "color")
filter_top.add_color("background", "background", -5)
filter_top.add_style("padding: 5px")
filter_top.add_style("min-width: 700px")
filter_top.add_border()
my.set_as_panel(filter_top)
# TEST link to help for search widget
help_button = ActionButtonWdg(title="?", tip="Search Documentation", size='small')
filter_top.add(help_button)
help_button.add_behavior( {
'type': 'click_up',
'cbjs_action': '''
spt.help.set_top();
spt.help.load_alias("search-quickstart|what-is-searching|search-interface|search-compound|search-expressions");
'''
} )
help_button.add_style("float: right")
# this id should be removed
filter_top.set_id("%s_search" % my.prefix)
filter_top.add_class("spt_search")
for name, value in my.kwargs.items():
filter_top.set_attr("spt_%s" % name, value)
#filter_top.add(my.statement)
popup = my.get_retrieve_wdg()
filter_top.add(popup)
popup = my.get_save_wdg()
filter_top.add(popup)
display = my.kwargs.get('display')
# Add a number of filters indicator
div = DivWdg()
div.add_class("spt_search_num_filters")
div.add_style("float: right")
div.add_style("font-size: 0.9em")
div.add_style("margin: 0 10 0 10")
#search_summary.add(div)
filter_top.add(div)
if my.num_filters_enabled:
msg = "[%s] filter/s" % my.num_filters_enabled
icon = IconWdg(msg, IconWdg.DOT_GREEN)
div.add(icon)
div.add("%s" % msg)
filter_div = DivWdg()
filter_div.set_id("search_filters")
filter_div.add_class("spt_search_filters")
# TODO: disabling for now
# add the action buttons
#action_wdg = my.get_action_wdg()
#action_wdg.add_style("text-align: right")
#filter_div.add( action_wdg )
# add the top
display_str = 'block'
if not display:
display_str = 'none'
filter_div.add_style("display: %s" % display_str)
search_wdg = my.get_search_wdg()
prefix = "filter_mode"
if my.prefix_namespace:
prefix = '%s_%s' %(my.prefix_namespace, prefix)
hidden = HiddenWdg("prefix", prefix)
match_div = DivWdg()
match_div.add(hidden)
match_div.add_class('spt_search_filter')
palette = match_div.get_palette()
bg_color = palette.color('background')
light_bg_color = palette.color('background', modifier=+10)
select = SelectWdg("filter_mode")
select.add_class("spt_search_filter_mode")
select.set_persist_on_submit(prefix)
select.remove_empty_option()
# for Local search, leave out compound search for now
if my.kwargs.get('prefix_namespace'):
select.set_option("labels", "Match all|Match any")
select.set_option("values", "and|or")
else:
select.set_option("labels", "Match all|Match any|Compound search")
select.set_option("values", "and|or|custom")
#select.set_option("labels", "all|any")
#select.set_option("values", "and|or")
select.add_behavior( {
'type': 'change',
'cbjs_action': '''
var display = bvr.src_el.value == 'custom';;
var top = bvr.src_el.getParent(".spt_search");
var ops = top.getElements(".spt_op");
for (var i = 0; i < ops.length; i++) {
var op = ops[i];
var element = op.getElement(".spt_op_display");
var value = op.getAttribute("spt_op");
if (display) {
element.innerHTML = value;
var level = op.getAttribute("spt_level");
if (level == 1) {
element.setStyle("background", "%s")
element.setStyle("padding", "4px")
}
} else {
element.innerHTML = ' ';
element.setStyle("background", "%s")
element.setStyle("padding", "1px")
}
}
''' %(light_bg_color, bg_color)
} )
match_div.add(select)
match_div.add_color("color", "color2")
match_div.add(" on the following")
hint = HintWdg( "An 'AND' operation is always applied to each category below. " \
"This controls only the filters within each category." )
match_div.add(hint)
match_div.add('<br/>')
match_div.add_style("padding-top: 5px")
filter_div.add( search_wdg)
search_wdg.add_style("float: left")
filter_div.add( match_div)
filter_div.add(HtmlElement.br())
filters_div = DivWdg()
filters_div.add_style("margin: 0 -6 0 -6")
security = Environment.get_security()
# add all the filters
for filter in my.filters:
element_name = filter.get_name()
if not security.check_access("search", element_name, "view"):
continue
# no need to create it again
#filter = my.config.get_display_widget(element_name)
div = DivWdg()
filters_div.add(div)
div.add_class("hand")
class_suffix = element_name.replace(' ', '_')
cbjs_action = 'var el=spt.get_cousin(bvr.src_el,".spt_search",".spt_filter_%s");spt.simple_display_toggle(el);' % class_suffix
div.add_behavior( {
'type': 'click_up',
'cbjs_action': cbjs_action
} )
div.add_color("color", "color", +5)
div.add_gradient("background", "background", -5, -5)
div.add_style("margin-top: -1px")
div.add_border()
div.add_style("padding: 3px")
div.add_style("whitespace: nowrap")
if element_name in ["Parent", 'Children']:
swap = SwapDisplayWdg.get_triangle_wdg()
else:
swap = SwapDisplayWdg.get_triangle_wdg()
swap.set_off()
swap.add_action_script(cbjs_action)
div.add_event("onclick", swap.get_swap_script() )
div.add(swap)
div.add_class("SPT_DTS")
div.add(element_name)
div = DivWdg()
div.add_class("spt_filter_%s" % class_suffix)
if element_name in ["Parent", 'Children']:
div.add_style("display: none")
else:
div.add_style("display: block")
#div.add_style("background-color: #333")
div.add_color("background", "background")
div.add_border()
div.add_style("padding: 5px 3px 5px 3px")
div.add_style("margin-top: -1px")
#div.add_style("margin-left: 20px")
#div.add_style("width: 660")
div.add(filter)
filters_div.add(div)
filter_div.add(filters_div)
buttons_div = DivWdg()
buttons_div.add_style("margin-top: 7px")
buttons_div.add_style("margin-bottom: 7px")
buttons_div.add(my.get_search_wdg() )
filter_div.add(buttons_div)
filter_top.add(filter_div)
return filter_top
def get_display(self):
web = WebContainer.get_web()
naming_util = NamingUtil()
if not self.widget_name:
self.widget_name = self.get_name()
# get the sobject required by this input
sobject = self.get_current_sobject()
if not sobject:
sobject = Search.get_by_id(self.search_type, self.search_id)
if self.new_sample_name:
self.new_sample_name.replace("//", "/")
else:
self.new_sample_name = sobject.get_value(self.widget_name)
widget = DivWdg()
widget.set_id("naming")
widget.add_style("display: block")
# set the sample text
div = DivWdg()
div.add("Sample name: <i>%s</i>" % self.new_sample_name)
div.add(HtmlElement.br(2))
new_sample_wdg = ProdIconButtonWdg("Set New Sample")
new_sample_wdg.add_event("onclick", "toggle_display('generate')")
div.add(new_sample_wdg)
generate = DivWdg()
generate.add(HtmlElement.br())
generate.set_id("generate")
generate.add_style("display: none")
sample_text = TextWdg("new_sample_name")
sample_text.set_option("size", "30")
#sample_text.set_persist_on_submit()
#if self.new_sample_name:
# sample_text.set_value(self.new_sample_name)
generate.add(sample_text)
button = IconButtonWdg("Generate", IconWdg.REFRESH, long=True)
on_script = self.setup_ajax("naming")
button.add_event("onclick", on_script)
generate.add(button)
generate.add(HtmlElement.br(2))
div.add(generate)
widget.add(div)
hidden = TextWdg(self.widget_name)
value = self.naming
hidden.set_value(self.new_sample_name)
widget.add(self.widget_name)
widget.add(hidden)
# get all of the parts
# TODO: not sure if this should be dictated by the sample name
# break up the name into parts
import re
if self.new_sample_name:
tmp = self.new_sample_name.strip("/")
parts = re.split('[\\/._]', tmp)
print "parts: ", parts
else:
return widget
# if there is a naming, then populate that
if self.edit_search_type:
options = naming_util.get_options(self.edit_search_type)
else:
options = naming_util.get_options(sobject.get_value("search_type"))
table = Table()
type_values = []
padding_values = []
for idx, part in enumerate(parts):
table.add_row()
table.add_cell(part)
type_select = SelectWdg("type_%s" % idx)
type_select.add_empty_option("-- Explicit --")
type_select.set_persist_on_submit()
type_select.set_option("values", "|".join(options))
type_values.append(type_select.get_value())
td = table.add_cell(type_select)
widget.add(table)
return widget
def get_first_row_wdg(self):
# read the csv file
self.file_path = ""
div = DivWdg()
div.add(self.get_upload_wdg())
if not self.search_type:
return div
if not self.file_path:
return div
if not self.file_path.endswith(".csv"):
div.add("Uploaded file [%s] is not a csv file" % self.file_path)
return div
if not os.path.exists(self.file_path):
raise Exception("Path '%s' does not exists" % self.file_path)
div.add(HtmlElement.br(2))
div.add(
HtmlElement.
b("The following is taken from first line in the uploaded csv file. Select the appropriate column to match."
))
div.add(HtmlElement.br())
div.add(
HtmlElement.b(
"Make sure you have all the required columns** in the csv."))
option_div = DivWdg()
option_div.add_style("float: left")
option_div.add_style("margin-right: 30px")
option_div.add("<p>3. Parsing Options:</p>")
self.search_type_obj = SearchType.get(self.search_type)
# first row and second row
option_div.add(HtmlElement.br(2))
option_div.add("Use Title Row: ")
title_row_checkbox = FilterCheckboxWdg("has_title")
title_row_checkbox.set_default_checked()
option_div.add(title_row_checkbox)
option_div.add(
HintWdg(
"Set this to use the first row as a title row to match up columns in the database"
))
option_div.add(HtmlElement.br(2))
option_div.add("Sample Data Row: ")
data_row_text = TextWdg("data_row")
data_row_text.set_attr("size", "3")
option_div.add(data_row_text)
option_div.add(
HintWdg(
"Set this as a sample data row to match the columns to the database"
))
option_div.add(HtmlElement.br(2))
div.add(option_div)
self.has_title = title_row_checkbox.is_checked()
# parse the first fow
csv_parser = CsvParser(self.file_path)
if self.has_title:
csv_parser.set_has_title_row(True)
else:
csv_parser.set_has_title_row(False)
csv_parser.parse()
csv_titles = csv_parser.get_titles()
csv_data = csv_parser.get_data()
data_row = data_row_text.get_value()
if not data_row:
data_row = 0
else:
try:
data_row = int(data_row)
except ValueError:
data_row = 0
if data_row >= len(csv_data):
data_row = len(csv_data) - 1
data_row_text.set_value(data_row)
table = Table()
table.set_attr("cellpadding", "10")
table.add_row()
table.add_header("CSV Column Value")
table.add_header("TACTIC Column")
table.add_header("Create New Column")
columns = self.search_type_obj.get_columns()
search_type = self.search_type_obj.get_base_search_type()
sobj = SObjectFactory.create(search_type)
required_columns = sobj.get_required_columns()
row = csv_data[data_row]
labels = []
for column in columns:
if column in required_columns:
label = '%s**' % column
else:
label = column
labels.append(label)
for j, cell in enumerate(row):
table.add_row()
table.add_cell(cell)
column_select = SelectWdg("column_%s" % j)
column_select.add_event(
"onchange",
"if (this.value!='') {set_display_off('new_column_div_%s')} else {set_display_on('new_column_div_%s')}"
% (j, j))
column_select.add_empty_option("-- Select --")
column_select.set_option("values", columns)
column_select.set_option("labels", labels)
# only set the value if it is actually in there
if csv_titles[j] in columns:
column_select.set_option("default", csv_titles[j])
column_select.set_persist_on_submit()
column_select_value = column_select.get_value()
display = column_select.get_buffer_display()
td = table.add_cell(display)
if csv_titles[j] not in columns:
td.add(" <b style='color: red'>*</b>")
# new property
new_column_div = DivWdg()
if column_select_value:
new_column_div.add_style("display", "none")
else:
new_column_div.add_style("display", "block")
new_column_div.set_id("new_column_div_%s" % j)
td = table.add_cell(new_column_div)
text = TextWdg("new_column_%s" % j)
text.set_persist_on_submit()
if self.has_title:
text.set_value(csv_titles[j])
new_column_div.add(" ... or ...")
new_column_div.add(text)
self.num_columns = len(row)
hidden = HiddenWdg("num_columns", self.num_columns)
# need to somehow specify defaults for columns
div.add(table)
div.add("<br/><br/>")
div.add(self.get_preview_wdg())
return div
def get_display(my):
# if no filters are defined, then display nothing
if not my.filters:
return Widget()
#filter_top = DivWdg(css="maq_search_bar")
filter_top = DivWdg()
filter_top.add_color("color", "color")
filter_top.add_color("background", "background", -5)
filter_top.add_style("padding: 5px")
filter_top.add_style("min-width: 800px")
filter_top.add_border()
my.set_as_panel(filter_top)
# TEST link to help for search widget
help_button = ActionButtonWdg(title="?",
tip="Search Documentation",
size='small')
filter_top.add(help_button)
help_button.add_behavior({
'type':
'click_up',
'cbjs_action':
'''
spt.help.set_top();
spt.help.load_alias("search-quickstart|what-is-searching|search-interface|search-compound|search-expressions");
'''
})
help_button.add_style("float: right")
# this id should be removed
filter_top.set_id("%s_search" % my.prefix)
filter_top.add_class("spt_search")
for name, value in my.kwargs.items():
filter_top.set_attr("spt_%s" % name, value)
#filter_top.add(my.statement)
popup = my.get_retrieve_wdg()
filter_top.add(popup)
popup = my.get_save_wdg()
filter_top.add(popup)
display = my.kwargs.get('display')
# Add a number of filters indicator
div = DivWdg()
div.add_class("spt_search_num_filters")
div.add_style("float: right")
div.add_style("font-size: 0.9em")
div.add_style("margin: 0 10 0 10")
#search_summary.add(div)
filter_top.add(div)
if my.num_filters_enabled:
msg = "[%s] filter/s" % my.num_filters_enabled
icon = IconWdg(msg, IconWdg.DOT_GREEN)
div.add(icon)
div.add("%s" % msg)
filter_div = DivWdg()
filter_div.set_id("search_filters")
filter_div.add_class("spt_search_filters")
# TODO: disabling for now
# add the action buttons
#action_wdg = my.get_action_wdg()
#action_wdg.add_style("text-align: right")
#filter_div.add( action_wdg )
# add the top
display_str = 'block'
if not display:
display_str = 'none'
filter_div.add_style("display: %s" % display_str)
search_wdg = my.get_search_wdg()
prefix = "filter_mode"
if my.prefix_namespace:
prefix = '%s_%s' % (my.prefix_namespace, prefix)
hidden = HiddenWdg("prefix", prefix)
match_div = DivWdg()
match_div.add(hidden)
match_div.add_class('spt_search_filter')
palette = match_div.get_palette()
bg_color = palette.color('background')
light_bg_color = palette.color('background', modifier=+10)
select = SelectWdg("filter_mode")
select.add_style("width: 110px")
select.add_class("spt_search_filter_mode")
select.set_persist_on_submit(prefix)
select.remove_empty_option()
# for Local search, leave out compound search for now
if my.kwargs.get('prefix_namespace'):
select.set_option("labels", "Match all|Match any")
select.set_option("values", "and|or")
else:
select.set_option("labels", "Match all|Match any|Compound")
select.set_option("values", "and|or|custom")
#select.set_option("labels", "all|any")
#select.set_option("values", "and|or")
select.add_behavior({
'type':
'change',
'cbjs_action':
'''
var display = bvr.src_el.value == 'custom';;
var top = bvr.src_el.getParent(".spt_search");
var ops = top.getElements(".spt_op");
for (var i = 0; i < ops.length; i++) {
var op = ops[i];
var element = op.getElement(".spt_op_display");
var value = op.getAttribute("spt_op");
if (display) {
element.innerHTML = value;
var level = op.getAttribute("spt_level");
if (level == 1) {
element.setStyle("background", "%s")
element.setStyle("padding", "4px")
}
} else {
element.innerHTML = ' ';
element.setStyle("background", "%s")
element.setStyle("padding", "1px")
}
}
''' % (light_bg_color, bg_color)
})
match_div.add(select)
match_div.add_color("color", "color2")
#match_div.add(" on the following")
#hint = HintWdg( "An 'AND' operation is always applied to each category below. " \
# "This controls only the filters within each category." )
#match_div.add(hint)
#match_div.add('<br/>')
#match_div.add_style("padding-top: 5px")
filter_div.add(search_wdg)
search_wdg.add_style("float: left")
filter_div.add(match_div)
filter_div.add(HtmlElement.br())
filters_div = DivWdg()
filters_div.add_style("margin: 0 -6 0 -6")
security = Environment.get_security()
# add all the filters
for filter in my.filters:
element_name = filter.get_name()
if not security.check_access("search", element_name, "view"):
continue
# no need to create it again
#filter = my.config.get_display_widget(element_name)
div = DivWdg()
filters_div.add(div)
div.add_class("hand")
class_suffix = element_name.replace(' ', '_')
cbjs_action = 'var el=spt.get_cousin(bvr.src_el,".spt_search",".spt_filter_%s");spt.simple_display_toggle(el);' % class_suffix
div.add_behavior({'type': 'click_up', 'cbjs_action': cbjs_action})
div.add_color("color", "color", +5)
#div.add_gradient("background", "background", -5, -5)
div.add_style("margin-top: -1px")
div.add_style("height: 18px")
div.add_border()
div.add_style("padding: 8px 5px")
div.add_style("whitespace: nowrap")
if element_name in ["Parent", 'Children']:
swap = SwapDisplayWdg.get_triangle_wdg()
else:
swap = SwapDisplayWdg.get_triangle_wdg()
swap.set_off()
swap.add_action_script(cbjs_action)
div.add_event("onclick", swap.get_swap_script())
div.add(swap)
div.add_class("SPT_DTS")
div.add(element_name)
div = DivWdg()
div.add_class("spt_filter_%s" % class_suffix)
if element_name in ["Parent", 'Children']:
div.add_style("display: none")
else:
div.add_style("display: block")
#div.add_style("background-color: #333")
div.add_color("background", "background")
div.add_border()
div.add_style("padding: 10px 8px")
div.add_style("margin-top: -1px")
#div.add_style("margin-left: 20px")
#div.add_style("width: 660")
div.add(filter)
filters_div.add(div)
filter_div.add(filters_div)
buttons_div = DivWdg()
buttons_div.add_style("margin-top: 7px")
buttons_div.add_style("margin-bottom: 7px")
search_wdg = my.get_search_wdg()
search_wdg.add_style("margin: 15px auto")
buttons_div.add(search_wdg)
filter_div.add(buttons_div)
filter_top.add(filter_div)
return filter_top
span.add(select)
div.add(span)
# make sure the current selection exists
try:
SearchType.get(search_type)
except SearchException, e:
return div
except SqlException, e:
return div
# add the view selector
view_select = SelectWdg("view")
view_select.add_empty_option("-- View --")
view_select.add_event("onchange", "document.form.submit()")
view_select.set_persist_on_submit()
# view_select.set_persistence()
span = SpanWdg(css="med")
span.add("Defined Views: ")
span.add(view_select)
div.add(span)
div.add(my.get_create_view_wdg(search_type))
div.add(HtmlElement.br(2))
div.add(my.get_new_tab_wdg())
widget.add(div)
search = Search("sthpw/widget_config")
def get_first_row_wdg(my):
# read the csv file
my.file_path = ""
div = DivWdg()
div.add( my.get_upload_wdg() )
if not my.search_type:
return div
if not my.file_path:
return div
if not my.file_path.endswith(".csv"):
div.add( "Uploaded file [%s] is not a csv file"% my.file_path)
return div
if not os.path.exists(my.file_path):
raise Exception("Path '%s' does not exists" % my.file_path)
div.add(HtmlElement.br(2))
div.add( HtmlElement.b("The following is taken from first line in the uploaded csv file. Select the appropriate column to match.") )
div.add(HtmlElement.br())
div.add( HtmlElement.b("Make sure you have all the required columns** in the csv."))
option_div = DivWdg()
option_div.add_style("float: left")
option_div.add_style("margin-right: 30px")
option_div.add("<p>3. Parsing Options:</p>")
my.search_type_obj = SearchType.get(my.search_type)
# first row and second row
option_div.add( HtmlElement.br(2) )
option_div.add("Use Title Row: ")
title_row_checkbox = FilterCheckboxWdg("has_title")
title_row_checkbox.set_default_checked()
option_div.add(title_row_checkbox)
option_div.add( HintWdg("Set this to use the first row as a title row to match up columns in the database") )
option_div.add( HtmlElement.br(2) )
option_div.add("Sample Data Row: ")
data_row_text = TextWdg("data_row")
data_row_text.set_attr("size", "3")
option_div.add(data_row_text)
option_div.add( HintWdg("Set this as a sample data row to match the columns to the database") )
option_div.add( HtmlElement.br(2) )
div.add(option_div)
my.has_title = title_row_checkbox.is_checked()
# parse the first fow
csv_parser = CsvParser(my.file_path)
if my.has_title:
csv_parser.set_has_title_row(True)
else:
csv_parser.set_has_title_row(False)
csv_parser.parse()
csv_titles = csv_parser.get_titles()
csv_data = csv_parser.get_data()
data_row = data_row_text.get_value()
if not data_row:
data_row = 0
else:
try:
data_row = int(data_row)
except ValueError:
data_row = 0
if data_row >= len(csv_data):
data_row = len(csv_data)-1
data_row_text.set_value(data_row)
table = Table()
table.set_attr("cellpadding", "10")
table.add_row()
table.add_header("CSV Column Value")
table.add_header("TACTIC Column")
table.add_header("Create New Column")
columns = my.search_type_obj.get_columns()
search_type = my.search_type_obj.get_base_search_type()
sobj = SObjectFactory.create(search_type)
required_columns = sobj.get_required_columns()
row = csv_data[data_row]
labels = []
for column in columns:
if column in required_columns:
label = '%s**'%column
else:
label = column
labels.append(label)
for j, cell in enumerate(row):
table.add_row()
table.add_cell(cell)
column_select = SelectWdg("column_%s" % j)
column_select.add_event("onchange", "if (this.value!='') {set_display_off('new_column_div_%s')} else {set_display_on('new_column_div_%s')}" % (j,j))
column_select.add_empty_option("-- Select --")
column_select.set_option("values", columns)
column_select.set_option("labels", labels)
# only set the value if it is actually in there
if csv_titles[j] in columns:
column_select.set_option("default", csv_titles[j])
column_select.set_persist_on_submit()
column_select_value = column_select.get_value()
display = column_select.get_buffer_display()
td = table.add_cell( display )
if csv_titles[j] not in columns:
td.add(" <b style='color: red'>*</b>")
# new property
new_column_div = DivWdg()
if column_select_value:
new_column_div.add_style("display", "none")
else:
new_column_div.add_style("display", "block")
new_column_div.set_id("new_column_div_%s" % j)
td = table.add_cell( new_column_div )
text = TextWdg("new_column_%s" % j)
text.set_persist_on_submit()
if my.has_title:
text.set_value(csv_titles[j])
new_column_div.add( " ... or ..." )
new_column_div.add( text )
my.num_columns = len(row)
hidden = HiddenWdg("num_columns", my.num_columns)
# need to somehow specify defaults for columns
div.add(table)
div.add("<br/><br/>")
div.add(my.get_preview_wdg())
return div
def get_display(self):
widget = Widget()
div = DivWdg(css="filter_box")
show_span = SpanWdg(css='med')
show_span.add('Show All Types: ')
checkbox = FilterCheckboxWdg('show_all_types')
checkbox.set_persistence()
show_span.add(checkbox)
show_all_types = checkbox.get_value()
div.add(show_span)
span = SpanWdg(css="med")
span.add("Search Type: ")
select = SelectWdg("filter|search_type")
select.add_empty_option("-- Select --")
project = Project.get()
project_type = project.get_base_type()
search = Search("sthpw/search_object")
if show_all_types:
search.add_where('''
namespace = '%s' or namespace = '%s' or search_type in ('sthpw/task')
''' % (project_type, project.get_code()) )
else:
# show only the custom ones
search.add_filter('namespace', project.get_code() )
search.add_order_by("title")
sobjects = search.get_sobjects()
select.set_sobjects_for_options(sobjects,"search_type", "title")
#select.set_option("query", "sthpw/search_object|search_type|title")
select.set_persistence()
select.add_event("onchange", "document.form.submit()")
search_type = select.get_value()
span.add(select)
div.add(span)
# make sure the current selection exists
try:
SearchType.get(search_type)
except SearchException as e:
return div
except SqlException as e:
return div
# add the view selector
view_select = SelectWdg("view")
view_select.add_empty_option("-- View --")
view_select.add_event("onchange", "document.form.submit()")
view_select.set_persist_on_submit()
#view_select.set_persistence()
span = SpanWdg(css="med")
span.add("Defined Views: ")
span.add(view_select)
div.add(span)
div.add( self.get_create_view_wdg(search_type))
div.add( HtmlElement.br(2) )
div.add( self.get_new_tab_wdg() )
widget.add(div)
search = Search("sthpw/widget_config")
#search.add_user_filter()
search.add_filter("search_type", search_type)
search.add_where("view != 'definition' and view != 'custom'")
#search.add_column("view")
widget_configs = search.get_sobjects()
if widget_configs:
view_select.set_sobjects_for_options(widget_configs,"view","view")
view = view_select.get_value()
if not view:
view = "custom"
#return widget
# get the selected widget config
for widget_config in widget_configs:
if widget_config.get_value("view") == view:
break
else:
return widget
# get the handler: a little HACKY.
config_xml = widget_config.get_xml_value("config")
handler = config_xml.get_value("config/%s/@handler" % view)
if not search_type:
return widget
widget.add(HtmlElement.br())
span = SpanWdg()
custom_view = CustomViewWdg(search_type)
span.add(custom_view)
span.add_style("float: right")
widget.add(span)
widget.add( HtmlElement.br() )
widget.add("<h3>Example View [%s]</h3>" % view)
# add a general filter
filter_div = DivWdg()
for i in range(0,1):
filter = GeneralFilterWdg()
filter.set_columns_from_search_type(search_type)
filter_div.add("Filter: ")
filter_div.add(filter)
#filter_div.add(IconWdg("Remove Filter", IconWdg.RETIRE))
filter_div.add( HtmlElement.br(2) )
widget.add(filter_div)
search = Search(search_type)
search.set_limit(5)
filter.alter_search(search)
if not handler:
if view in ["edit","insert"]:
table = EditWdg(search_type, view)
else:
table = TableWdg(search_type, view)
else:
table = eval("%s(search_type,view)" % handler)
#table.alter_search(search)
sobjects = search.get_sobjects()
if not sobjects and view in ["edit","insert"]:
sobjects = [SObjectFactory.create(search_type)]
table.set_sobjects(sobjects)
widget.add(table)
# show the custom properties
widget.add("<h3>Custom Properties [%s]</h3>" % search_type)
search = Search("prod/custom_property")
search.add_filter("search_type", search_type)
# This is actually reading the sthpw/custom_property conf file, weird
table = TableWdg("prod/custom_property")
table.set_search_limit(5)
table.set_sobjects(search.get_sobjects() )
widget.add(table)
return widget
def get_display(self):
widget = Widget()
div = DivWdg(css="filter_box")
show_span = SpanWdg(css='med')
show_span.add('Show All Types: ')
checkbox = FilterCheckboxWdg('show_all_types')
checkbox.set_persistence()
show_span.add(checkbox)
show_all_types = checkbox.get_value()
div.add(show_span)
span = SpanWdg(css="med")
span.add("Search Type: ")
select = SelectWdg("filter|search_type")
select.add_empty_option("-- Select --")
project = Project.get()
project_type = project.get_base_type()
search = Search("sthpw/search_object")
if show_all_types:
search.add_where('''
namespace = '%s' or namespace = '%s' or search_type in ('sthpw/task')
''' % (project_type, project.get_code()))
else:
# show only the custom ones
search.add_filter('namespace', project.get_code())
search.add_order_by("title")
sobjects = search.get_sobjects()
select.set_sobjects_for_options(sobjects, "search_type", "title")
#select.set_option("query", "sthpw/search_object|search_type|title")
select.set_persistence()
select.add_event("onchange", "document.form.submit()")
search_type = select.get_value()
span.add(select)
div.add(span)
# make sure the current selection exists
try:
SearchType.get(search_type)
except SearchException as e:
return div
except SqlException as e:
return div
# add the view selector
view_select = SelectWdg("view")
view_select.add_empty_option("-- View --")
view_select.add_event("onchange", "document.form.submit()")
view_select.set_persist_on_submit()
#view_select.set_persistence()
span = SpanWdg(css="med")
span.add("Defined Views: ")
span.add(view_select)
div.add(span)
div.add(self.get_create_view_wdg(search_type))
div.add(HtmlElement.br(2))
div.add(self.get_new_tab_wdg())
widget.add(div)
search = Search("sthpw/widget_config")
#search.add_user_filter()
search.add_filter("search_type", search_type)
search.add_where("view != 'definition' and view != 'custom'")
#search.add_column("view")
widget_configs = search.get_sobjects()
if widget_configs:
view_select.set_sobjects_for_options(widget_configs, "view",
"view")
view = view_select.get_value()
if not view:
view = "custom"
#return widget
# get the selected widget config
for widget_config in widget_configs:
if widget_config.get_value("view") == view:
break
else:
return widget
# get the handler: a little HACKY.
config_xml = widget_config.get_xml_value("config")
handler = config_xml.get_value("config/%s/@handler" % view)
if not search_type:
return widget
widget.add(HtmlElement.br())
span = SpanWdg()
custom_view = CustomViewWdg(search_type)
span.add(custom_view)
span.add_style("float: right")
widget.add(span)
widget.add(HtmlElement.br())
widget.add("<h3>Example View [%s]</h3>" % view)
# add a general filter
filter_div = DivWdg()
for i in range(0, 1):
filter = GeneralFilterWdg()
filter.set_columns_from_search_type(search_type)
filter_div.add("Filter: ")
filter_div.add(filter)
#filter_div.add(IconWdg("Remove Filter", IconWdg.RETIRE))
filter_div.add(HtmlElement.br(2))
widget.add(filter_div)
search = Search(search_type)
search.set_limit(5)
filter.alter_search(search)
if not handler:
if view in ["edit", "insert"]:
table = EditWdg(search_type, view)
else:
table = TableWdg(search_type, view)
else:
table = eval("%s(search_type,view)" % handler)
#table.alter_search(search)
sobjects = search.get_sobjects()
if not sobjects and view in ["edit", "insert"]:
sobjects = [SObjectFactory.create(search_type)]
table.set_sobjects(sobjects)
widget.add(table)
# show the custom properties
widget.add("<h3>Custom Properties [%s]</h3>" % search_type)
search = Search("prod/custom_property")
search.add_filter("search_type", search_type)
# This is actually reading the sthpw/custom_property conf file, weird
table = TableWdg("prod/custom_property")
table.set_search_limit(5)
table.set_sobjects(search.get_sobjects())
widget.add(table)
return widget
