def get_browse_button(my):
button = ActionButtonWdg(title="Browse")
button_div.add(button)
button.add_style("float: left")
button.add_behavior( {
'type': 'click_up',
'cbjs_action': '''
var applet = spt.Applet.get();
var files = applet.open_file_browser();
var top = bvr.src_el.getParent(".spt_uploader_top");
var drop_area = top.getElement(".spt_uploader_drop");
alert(drop_area);
var file_objs = [];
for (var i = 0; i < files.length; i++ ) {
var file_obj = {};
file_objs.push(file_obj);
var file_path = files[i];
file_obj.fileName = spt.path.get_basename(file_path);
}
spt.uploader.traverse_files(drop_area, file_objs);
'''
} )
return button
def get_upload_button(my):
button = ActionButtonWdg(title="Upload")
button_div.add(button)
button.add_behavior( {
'type': 'click_up',
'cbjs_action': '''
var top = bvr.src_el.getParent(".spt_uploader_top");
var files = top.files;
var applet = spt.Applet.get();
for ( var i = 0; i < files.length; i++ ) {
applet.upload_file(files[i]);
}
'''
} )
return upload
def get_upload_button(my):
button = ActionButtonWdg(title="Upload")
button_div.add(button)
button.add_behavior({
'type':
'click_up',
'cbjs_action':
'''
var top = bvr.src_el.getParent(".spt_uploader_top");
var files = top.files;
var applet = spt.Applet.get();
for ( var i = 0; i < files.length; i++ ) {
applet.upload_file(files[i]);
}
'''
})
return upload
def get_browse_button(my):
button = ActionButtonWdg(title="Browse")
button_div.add(button)
button.add_style("float: left")
button.add_behavior({
'type':
'click_up',
'cbjs_action':
'''
var applet = spt.Applet.get();
var files = applet.open_file_browser();
var top = bvr.src_el.getParent(".spt_uploader_top");
var drop_area = top.getElement(".spt_uploader_drop");
alert(drop_area);
var file_objs = [];
for (var i = 0; i < files.length; i++ ) {
var file_obj = {};
file_objs.push(file_obj);
var file_path = files[i];
file_obj.fileName = spt.path.get_basename(file_path);
}
spt.uploader.traverse_files(drop_area, file_objs);
'''
})
return button
def get_display(my):
top = my.top
top.add_color("background", "background")
top.add_color("color", "color")
top.add_style("padding: 10px")
top.add_style("min-width: 400px")
from tactic.ui.app import HelpButtonWdg
help_wdg = HelpButtonWdg(alias="exporting-csv-data")
top.add(help_wdg)
help_wdg.add_style("float: right")
help_wdg.add_style("margin-top: -3px")
if not my.check():
top.add(DivWdg('Error: %s' %my.error_msg))
top.add(HtmlElement.br(2))
return super(CsvExportWdg, my).get_display()
if my.search_type_list and my.search_type_list[0] != my.search_type:
st = SearchType.get(my.search_type_list[0])
title_div =DivWdg('Exporting related items [%s]' % st.get_title())
top.add(title_div)
top.add(HtmlElement.br())
my.search_type = my.search_type_list[0]
my.view = my.related_view
if my.mode != 'export_all':
num = len(my.selected_search_keys)
else:
search = Search(my.search_type)
num = search.get_count()
msg_div = DivWdg('Total: %s items to export'% num)
msg_div.add_style("font-size: 12px")
msg_div.add_style("font-weight: bold")
msg_div.add_style('margin-left: 4px')
top.add(msg_div)
if num > 300:
msg_div.add_behavior({'type':'load',
'cbjs_action': "spt.alert('%s items are about to be exported. It may take a while.')" %num})
top.add(HtmlElement.br())
div = DivWdg(css='spt_csv_export', id='csv_export_action')
div.add_color("background", "background", -10)
div.add_style("padding: 10px")
div.add_style("margin: 5px")
div.add_styles('max-height: 350px; overflow: auto')
table = Table( css='minimal')
table.add_color("color", "color")
div.add(table)
table.set_id('csv_export_table')
table.center()
cb_name = 'csv_column_name'
master_cb = CheckboxWdg('master_control')
master_cb.set_checked()
master_cb.add_behavior({'type': 'click_up',
'propagate_evt': True,
'cbjs_action': '''
var inputs = spt.api.Utility.get_inputs(bvr.src_el.getParent('.spt_csv_export'),'%s');
for (var i = 0; i < inputs.length; i++)
inputs[i].checked = !inputs[i].checked;
''' %cb_name})
span = SpanWdg('Select Columns To Export')
span.add_style('font-weight','600')
table.add_row_cell(span)
table.add_row_cell(HtmlElement.br())
tr = table.add_row()
tr.add_style('border-bottom: 1px groove #777')
td = table.add_cell(master_cb)
label = HtmlElement.i('toggle all')
label.add_style('color: #888')
table.add_cell(label)
col1 = table.add_col()
col1.add_style('width: 35px')
col2 = table.add_col()
if not my.search_type or not my.view:
return table
# use overriding element names and derived titles if available
config = WidgetConfigView.get_by_search_type(my.search_type, my.view)
if my.element_names and config:
filtered_columns = my.element_names
titles = []
for name in my.element_names:
title = config.get_element_title(name)
titles.append(title)
else:
# excluding FunctionalTableElement
filtered_columns = []
titles = []
if not config:
columns = search.get_columns()
filtered_columns = columns
titles = ['n/a'] * len(filtered_columns)
else:
columns = config.get_element_names()
filtered_columns = columns
titles = config.get_element_titles()
"""
# commented out until it is decided 2.5 widgets will
# use this class to differentiate between reg and functional element
from pyasm.widget import FunctionalTableElement
for column in columns:
widget = config.get_display_widget(column)
if isinstance(widget, FunctionalTableElement):
continue
filtered_columns.append(column)
"""
for idx, column in enumerate(filtered_columns):
table.add_row()
cb = CheckboxWdg(cb_name)
cb.set_option('value', column)
cb.set_checked()
table.add_cell(cb)
title = titles[idx]
table.add_cell('<b>%s</b> (%s) '%(title, column))
action_div = DivWdg()
widget = DivWdg()
table.add_row_cell(widget)
widget.add_style("margin: 20px 0 10px 0px")
cb = CheckboxWdg('include_id', label=" Include ID")
cb.set_default_checked()
widget.add(cb)
hint = HintWdg('To update entries with specific ID later, please check this option. For new inserts in this or other table later on, uncheck this option.')
widget.add(hint)
label = string.capwords(my.mode.replace('_', ' '))
button = ActionButtonWdg(title=label)
is_export_all = my.mode == 'export_all'
button.add_behavior({
'type': "click_up",
'cbfn_action': 'spt.dg_table_action.csv_export',
'element': 'csv_export',
'column_names': 'csv_column_name',
'search_type': my.search_type,
'view': my.view,
'search_keys' : my.selected_search_keys,
'is_export_all' : is_export_all
})
my.close_action = "var popup = bvr.src_el.getParent('.spt_popup');spt.popup.close(popup)"
if my.close_action:
close_button = ActionButtonWdg(title='Close')
close_button.add_behavior({
'type': "click",
'cbjs_action': my.close_action
})
table = Table()
action_div.add(table)
table.center()
table.add_row()
td = table.add_cell(button)
td.add_style("width: 130px")
table.add_cell(close_button)
action_div.add("<br clear='all'/>")
top.add(div)
top.add(HtmlElement.br())
top.add(action_div)
return top
def get_upload_wdg(my):
'''get search type select and upload wdg'''
widget = DivWdg(css='spt_import_csv')
widget.add_color('color','color')
widget.add_color('background','background')
widget.add_style('width: 600px')
# get the search type
title = DivWdg("<b>Select sType to import data into:</b> ")
widget.add( title )
title.add_style("float: left")
# handle new search_types
new_search_type = CheckboxWdg("new_search_type_checkbox")
new_search_type.add_event("onclick", "toggle_display('new_search_type_div')")
#span = SpanWdg(css="med")
#span.add(new_search_type)
#span.add("Create new type")
#span.add(" ... or ... ")
#widget.add(span)
new_search_type_div = DivWdg()
new_search_type_div.set_id("new_search_type_div")
name_input = TextWdg("asset_name")
title = TextWdg("asset_title")
description = TextAreaWdg("asset_description")
key='csv_import'
table = Table()
table.set_id('csv_main_body')
table.add_style("margin: 10px 10px")
table.add_col().set_attr('width','140')
table.add_col().set_attr('width','400')
table.add_row()
table.add_header("Search Type: ").set_attr('align','left')
table.add_cell(name_input)
table.add_row()
table.add_header("Title: ").set_attr('align','left')
table.add_cell(title)
table.add_row()
table.add_header("Description: ").set_attr('align','left')
table.add_cell(description)
new_search_type_div.add(table)
new_search_type_div.add_style("display: none")
#widget.add(new_search_type_div)
div = DivWdg()
search_type_select = SearchTypeSelectWdg("search_type_filter", mode=SearchTypeSelectWdg.ALL)
search_type_select.add_empty_option("-- Select --")
if not search_type_select.get_value():
search_type_select.set_value(my.search_type)
search_type_select.set_persist_on_submit()
div.add(search_type_select)
widget.add(div)
search_type_select.add_behavior( {'type': 'change', \
'cbjs_action': "spt.panel.load('csv_import_main','%s', {}, {\
'search_type_filter': bvr.src_el.value});" %(Common.get_full_class_name(my)) } )
if my.search_type:
sobj = None
try:
sobj = SObjectFactory.create(my.search_type)
except ImportError:
widget.add(HtmlElement.br())
widget.add(SpanWdg('WARNING: Import Error encountered. Please choose another search type.', css='warning'))
return widget
required_columns = sobj.get_required_columns()
if required_columns:
widget.add(HtmlElement.br())
req_span = SpanWdg("Required Columns: ", css='med')
req_span.add_color('color','color')
widget.add(req_span)
#required_columns = ['n/a']
req_span.add(', '.join(required_columns))
widget.add( HtmlElement.br() )
if my.file_path:
hidden = HiddenWdg("file_path", my.file_path)
widget.add(hidden)
if my.web_url:
file_span = FloatDivWdg('URL: <i>%s</i> ' %my.web_url, css='med')
else:
file_span = FloatDivWdg('File uploaded: <i>%s</i> ' %os.path.basename(my.file_path), css='med')
file_span.add_color('color','color')
file_span.add_style('margin: 8px 0 0 10px')
file_span.add_style('font-size: 14px')
widget.add(file_span)
button = ActionButtonWdg(title='Change')
button.add_style('float','left')
button.add_behavior( {'type': 'click_up', \
'cbjs_action': "spt.panel.load('csv_import_main','%s', {}, {\
'search_type_filter': '%s'});" %(Common.get_full_class_name(my), my.search_type) } )
widget.add(button)
widget.add("<br clear='all'/>")
widget.add(HtmlElement.br())
return widget
widget.add("<br/>")
widget.add_style("overflow-y: auto")
msg = DivWdg()
widget.add(msg)
msg.add( "<div style='float: left; padding-left: 100px; padding-top: 6px'><b>Upload a csv file: </b></div>")
msg.add_border()
msg.add_style("width: 400px")
msg.add_color("background", "background3")
msg.add_style("padding: 20px")
msg.add_style("margin: 30 auto")
msg.add_style("text-align: center")
ticket = Environment.get_security().get_ticket_key()
on_complete = '''var server = TacticServerStub.get();
var file = spt.html5upload.get_file();
if (file) {
var file_name = file.name;
// clean up the file name the way it is done in the server
file_name = spt.path.get_filesystem_name(file_name);
var server = TacticServerStub.get();
var class_name = 'tactic.ui.widget.CsvImportWdg';
var values = spt.api.Utility.get_input_values('csv_import_main');
values['is_refresh'] = true;
values['file_name'] = file_name;
values['html5_ticket'] = '%s';
try {
var info = spt.panel.load('csv_import_main', class_name, {}, values);
spt.app_busy.hide();
}
catch(e) {
spt.alert(spt.exception.handler(e));
}
}
else {
alert('Error: file object cannot be found.')
}
spt.app_busy.hide();'''%ticket
from tactic.ui.input import UploadButtonWdg
browse = UploadButtonWdg(name='new_csv_upload', title="Browse", tip="Click to choose a csv file",\
on_complete=on_complete, ticket=ticket)
browse.add_style('float: left')
msg.add(browse)
# this is now only used in the copy and paste Upload button for backward-compatibility
upload_wdg = SimpleUploadWdg(key=key, show_upload=False)
upload_wdg.add_style('display: none')
msg.add(upload_wdg)
#widget.add(span)
msg.add("<br/><br/>-- OR --</br/><br/>")
msg.add("<b>Published URL: </b>")
text = TextWdg("web_url")
msg.add(text)
msg.add("<br/><br/>-- OR --</br/><br/>")
msg.add("<b>Copy and Paste from a Spreadsheet: </b>")
text = TextAreaWdg("data")
text.add_style('width: 33em')
text.add_class("spt_import_cut_paste")
msg.add(text)
button = ActionButtonWdg(title="Parse")
button.add_style("margin: 5px auto")
msg.add(button)
button.add_behavior( {
'type': 'click_up',
'cbjs_action': '''
var top = bvr.src_el.getParent(".spt_import_top");
var el = top.getElement(".spt_import_cut_paste");
var applet = spt.Applet.get();
var value = el.value;
var csv = [];
// convert to a csv file!
lines = value.split("\\n");
for (var i = 0; i < lines.length; i++) {
if (lines[i] == '') {
continue;
}
var parts = lines[i].split("\\t");
var new_line = [];
for (var j = 0; j < parts.length; j++) {
if (parts[j] == '') {
new_line.push('');
}
else {
new_line.push('"'+parts[j]+'"');
}
}
new_line = new_line.join(",");
csv.push(new_line);
}
csv = csv.join("\\n")
// FIXME: need to get a local temp directory
var path = spt.browser.os_is_Windows() ? "C:/sthpw/copy_n_paste.csv" : "/tmp/sthpw/copy_n_paste.csv";
applet.create_file(path, csv);
// upload the file
applet.upload_file(path)
applet.rmtree(path);
var top = bvr.src_el.getParent(".spt_import_csv");
var hidden = top.getElement(".spt_upload_hidden");
hidden.value = path;
var file_name = spt.path.get_basename(hidden.value);
file_name = spt.path.get_filesystem_name(file_name);
var class_name = 'tactic.ui.widget.CsvImportWdg';
var values = spt.api.Utility.get_input_values('csv_import_main');
values['is_refresh'] = true;
values['file_name'] = file_name;
var info = spt.panel.load('csv_import_main', class_name, {}, values);
'''
} )
return widget
sobject_title = my.search_type_obj.get_title()
div = DivWdg(css='spt_csv_sample')
widget.add(div)
h3 = DivWdg("Preview Data")
h3.add_border()
h3.add_color('color','color')
h3.add_gradient('background','background', -5)
h3.add_style("padding: 5px")
h3.add_style("font-weight: bold")
h3.add_style("margin-left: -20px")
h3.add_style("margin-right: -20px")
div.add(h3)
div.add("<br/>")
refresh_button = ActionButtonWdg(title="Refresh")
refresh_button.add_behavior({'type' : 'click_up',
'cbjs_action': "spt.panel.refresh('preview_data',\
spt.api.Utility.get_input_values('csv_import_main'))"})
refresh_button.add_style("float: left")
div.add(refresh_button)
import_button = ActionButtonWdg(title="Import")
import_button.set_id('CsvImportButton')
import_button.add_behavior({
'type':'click_up',
'top_id':'csv_import_main',
sobject_title = my.search_type_obj.get_title()
div = DivWdg(css='spt_csv_sample')
widget.add(div)
h3 = DivWdg("Preview Data")
#h3.add_border()
h3.add_color('color','color')
#h3.add_gradient('background','background', -5)
h3.add("<hr style='dashed'/>")
h3.add_style("padding: 5px")
h3.add_style("font-weight: bold")
h3.add_style("margin-left: -20px")
h3.add_style("margin-right: -20px")
div.add(h3)
div.add("<br/>")
refresh_button = ActionButtonWdg(title="Refresh")
refresh_button.add_behavior({'type' : 'click_up',
'cbjs_action': "spt.panel.refresh('preview_data',\
spt.api.Utility.get_input_values('csv_import_main'))"})
refresh_button.add_style("float: left")
div.add(refresh_button)
import_button = ActionButtonWdg(title="Import")
import_button.set_id('CsvImportButton')
import_button.add_behavior({
'type':'click_up',
'top_id':'csv_import_main',
def get_display(my):
top = my.top
top.add_color("background", "background")
top.add_color("color", "color")
top.add_style("padding: 10px")
top.add_style("min-width: 400px")
from tactic.ui.app import HelpButtonWdg
help_wdg = HelpButtonWdg(alias="exporting-csv-data")
top.add(help_wdg)
help_wdg.add_style("float: right")
help_wdg.add_style("margin-top: -3px")
if not my.check():
top.add(DivWdg('Error: %s' %my.error_msg))
top.add(HtmlElement.br(2))
return super(CsvExportWdg, my).get_display()
if my.search_type_list and my.search_type_list[0] != my.search_type:
st = SearchType.get(my.search_type_list[0])
title_div =DivWdg('Exporting related items [%s]' % st.get_title())
top.add(title_div)
top.add(HtmlElement.br())
my.search_type = my.search_type_list[0]
my.view = my.related_view
if my.mode != 'export_all':
num = len(my.selected_search_keys)
else:
search = Search(my.search_type)
num = search.get_count()
msg_div = DivWdg('Total: %s items to export'% num)
msg_div.add_style("font-size: 12px")
msg_div.add_style("font-weight: bold")
msg_div.add_style('margin-left: 4px')
top.add(msg_div)
if num > 300:
msg_div.add_behavior({'type':'load',
'cbjs_action': "spt.alert('%s items are about to be exported. It may take a while.')" %num})
top.add(HtmlElement.br())
div = DivWdg(css='spt_csv_export', id='csv_export_action')
div.add_color("background", "background", -10)
div.add_style("padding: 10px")
div.add_style("margin: 5px")
div.add_styles('max-height: 350px; overflow: auto')
table = Table( css='minimal')
table.add_color("color", "color")
div.add(table)
table.set_id('csv_export_table')
table.center()
cb_name = 'csv_column_name'
master_cb = CheckboxWdg('master_control')
master_cb.set_checked()
master_cb.add_behavior({'type': 'click_up',
'propagate_evt': True,
'cbjs_action': '''
var inputs = spt.api.Utility.get_inputs(bvr.src_el.getParent('.spt_csv_export'),'%s');
for (var i = 0; i < inputs.length; i++)
inputs[i].checked = !inputs[i].checked;
''' %cb_name})
span = SpanWdg('Select Columns To Export')
span.add_style('font-weight','600')
table.add_row_cell(span)
table.add_row_cell(HtmlElement.br())
tr = table.add_row()
tr.add_style('border-bottom: 1px groove #777')
td = table.add_cell(master_cb)
label = HtmlElement.i('toggle all')
label.add_style('color: #888')
table.add_cell(label)
col1 = table.add_col()
col1.add_style('width: 35px')
col2 = table.add_col()
if not my.search_type or not my.view:
return table
# use overriding element names and derived titles if available
config = WidgetConfigView.get_by_search_type(my.search_type, my.view)
if my.element_names and config:
filtered_columns = my.element_names
titles = []
for name in my.element_names:
title = config.get_element_title(name)
titles.append(title)
else:
# excluding FunctionalTableElement
filtered_columns = []
titles = []
if not config:
columns = search.get_columns()
filtered_columns = columns
titles = ['n/a'] * len(filtered_columns)
else:
columns = config.get_element_names()
filtered_columns = columns
titles = config.get_element_titles()
"""
# commented out until it is decided 2.5 widgets will
# use this class to differentiate between reg and functional element
from pyasm.widget import FunctionalTableElement
for column in columns:
widget = config.get_display_widget(column)
if isinstance(widget, FunctionalTableElement):
continue
filtered_columns.append(column)
"""
for idx, column in enumerate(filtered_columns):
table.add_row()
cb = CheckboxWdg(cb_name)
cb.set_option('value', column)
cb.set_checked()
table.add_cell(cb)
title = titles[idx]
table.add_cell('<b>%s</b> (%s) '%(title, column))
action_div = DivWdg()
widget = DivWdg()
table.add_row_cell(widget)
widget.add_style("margin: 20px 0 10px 0px")
cb = CheckboxWdg('include_id', label=" Include ID")
cb.set_default_checked()
widget.add(cb)
hint = HintWdg('To update entries with specific ID later, please check this option. For new inserts in this or other table later on, uncheck this option.')
widget.add(hint)
label = string.capwords(my.mode.replace('_', ' '))
button = ActionButtonWdg(title=label, size='l')
is_export_all = my.mode == 'export_all'
button.add_behavior({
'type': "click_up",
'cbfn_action': 'spt.dg_table_action.csv_export',
'element': 'csv_export',
'column_names': 'csv_column_name',
'search_type': my.search_type,
'view': my.view,
'search_keys' : my.selected_search_keys,
'is_export_all' : is_export_all
})
my.close_action = "var popup = bvr.src_el.getParent('.spt_popup');spt.popup.close(popup)"
if my.close_action:
close_button = ActionButtonWdg(title='Close')
close_button.add_behavior({
'type': "click",
'cbjs_action': my.close_action
})
table = Table()
action_div.add(table)
table.center()
table.add_row()
td = table.add_cell(button)
td.add_style("width: 130px")
table.add_cell(close_button)
action_div.add("<br clear='all'/>")
top.add(div)
top.add(HtmlElement.br())
top.add(action_div)
if my.is_test:
rtn_data = {'columns': my.element_names, 'count': len(my.selected_search_keys)}
if my.mode == 'export_matched':
rtn_data['sql'] = my.table.search_wdg.search.get_statement()
from pyasm.common import jsondumps
rtn_data = jsondumps(rtn_data)
return rtn_data
return top
def get_upload_wdg(my):
'''get search type select and upload wdg'''
widget = DivWdg(css='spt_import_csv')
widget.add_color('color','color')
widget.add_color('background','background')
widget.add_style('width: 600px')
# get the search type
title = DivWdg("<b>Select sType to import data into:</b> ")
widget.add( title )
title.add_style("float: left")
# handle new search_types
new_search_type = CheckboxWdg("new_search_type_checkbox")
new_search_type.add_event("onclick", "toggle_display('new_search_type_div')")
#span = SpanWdg(css="med")
#span.add(new_search_type)
#span.add("Create new type")
#span.add(" ... or ... ")
#widget.add(span)
new_search_type_div = DivWdg()
new_search_type_div.set_id("new_search_type_div")
name_input = TextWdg("asset_name")
title = TextWdg("asset_title")
description = TextAreaWdg("asset_description")
key='csv_import'
table = Table()
table.set_id('csv_main_body')
table.add_style("margin: 10px 10px")
table.add_col().set_attr('width','140')
table.add_col().set_attr('width','400')
table.add_row()
table.add_header("Search Type: ").set_attr('align','left')
table.add_cell(name_input)
table.add_row()
table.add_header("Title: ").set_attr('align','left')
table.add_cell(title)
table.add_row()
table.add_header("Description: ").set_attr('align','left')
table.add_cell(description)
new_search_type_div.add(table)
new_search_type_div.add_style("display: none")
#widget.add(new_search_type_div)
div = DivWdg()
search_type_select = SearchTypeSelectWdg("search_type_filter", mode=SearchTypeSelectWdg.ALL)
search_type_select.add_empty_option("-- Select --")
if not search_type_select.get_value():
search_type_select.set_value(my.search_type)
search_type_select.set_persist_on_submit()
div.add(search_type_select)
widget.add(div)
search_type_select.add_behavior( {'type': 'change', \
'cbjs_action': "spt.panel.load('csv_import_main','%s', {}, {\
'search_type_filter': bvr.src_el.value});" %(Common.get_full_class_name(my)) } )
if my.search_type:
sobj = None
try:
sobj = SObjectFactory.create(my.search_type)
except ImportError:
widget.add(HtmlElement.br())
widget.add(SpanWdg('WARNING: Import Error encountered. Please choose another search type.', css='warning'))
return widget
required_columns = sobj.get_required_columns()
if required_columns:
widget.add(HtmlElement.br())
req_span = SpanWdg("Required Columns: ", css='med')
req_span.add_color('color','color')
widget.add(req_span)
#required_columns = ['n/a']
req_span.add(', '.join(required_columns))
widget.add( HtmlElement.br() )
if my.file_path:
hidden = HiddenWdg("file_path", my.file_path)
widget.add(hidden)
if my.web_url:
file_span = FloatDivWdg('URL: <i>%s</i> ' %my.web_url, css='med')
else:
file_span = FloatDivWdg('File uploaded: <i>%s</i> ' %os.path.basename(my.file_path), css='med')
file_span.add_color('color','color')
file_span.add_style('margin: 8px 0 0 10px')
file_span.add_style('font-size: 14px')
widget.add(file_span)
button = ActionButtonWdg(title='Change')
button.add_style('float','left')
button.add_behavior( {'type': 'click_up', \
'cbjs_action': "spt.panel.load('csv_import_main','%s', {}, {\
'search_type_filter': '%s'});" %(Common.get_full_class_name(my), my.search_type) } )
widget.add(button)
widget.add("<br clear='all'/>")
widget.add(HtmlElement.br())
return widget
widget.add("<br/>")
widget.add_style("overflow-y: auto")
msg = DivWdg()
widget.add(msg)
msg.add( "<div style='float: left; padding-left: 100px; padding-top: 6px'><b>Upload a csv file: </b></div>")
msg.add_border()
msg.add_style("width: 400px")
msg.add_color("background", "background3")
msg.add_style("padding: 20px")
msg.add_style("margin: 30 auto")
msg.add_style("text-align: center")
ticket = Environment.get_security().get_ticket_key()
on_complete = '''var server = TacticServerStub.get();
var file = spt.html5upload.get_file();
if (file) {
var file_name = file.name;
// clean up the file name the way it is done in the server
//file_name = spt.path.get_filesystem_name(file_name);
var server = TacticServerStub.get();
var class_name = 'tactic.ui.widget.CsvImportWdg';
var values = spt.api.Utility.get_input_values('csv_import_main');
values['is_refresh'] = true;
values['file_name'] = file_name;
values['html5_ticket'] = '%s';
try {
var info = spt.panel.load('csv_import_main', class_name, {}, values);
spt.app_busy.hide();
}
catch(e) {
spt.alert(spt.exception.handler(e));
}
}
else {
alert('Error: file object cannot be found.')
}
spt.app_busy.hide();'''%ticket
from tactic.ui.input import UploadButtonWdg
browse = UploadButtonWdg(name='new_csv_upload', title="Browse", tip="Click to choose a csv file",\
on_complete=on_complete, ticket=ticket)
browse.add_style('float: left')
msg.add(browse)
# this is now only used in the copy and paste Upload button for backward-compatibility
upload_wdg = SimpleUploadWdg(key=key, show_upload=False)
upload_wdg.add_style('display: none')
msg.add(upload_wdg)
#widget.add(span)
msg.add("<br/><br/>-- OR --</br/><br/>")
msg.add("<b>Published URL: </b>")
text = TextWdg("web_url")
msg.add(text)
msg.add("<br/><br/>-- OR --</br/><br/>")
msg.add("<b>Copy and Paste from a Spreadsheet: </b>")
text = TextAreaWdg("data")
text.add_style('width: 33em')
text.add_class("spt_import_cut_paste")
msg.add(text)
button = ActionButtonWdg(title="Parse")
button.add_style("margin: 5px auto")
msg.add(button)
button.add_behavior( {
'type': 'click_up',
'cbjs_action': '''
var top = bvr.src_el.getParent(".spt_import_top");
var el = top.getElement(".spt_import_cut_paste");
var applet = spt.Applet.get();
var value = el.value;
var csv = [];
// convert to a csv file!
lines = value.split("\\n");
for (var i = 0; i < lines.length; i++) {
if (lines[i] == '') {
continue;
}
var parts = lines[i].split("\\t");
var new_line = [];
for (var j = 0; j < parts.length; j++) {
if (parts[j] == '') {
new_line.push('');
}
else {
new_line.push('"'+parts[j]+'"');
}
}
new_line = new_line.join(",");
csv.push(new_line);
}
csv = csv.join("\\n")
// FIXME: need to get a local temp directory
var path = spt.browser.os_is_Windows() ? "C:/sthpw/copy_n_paste.csv" : "/tmp/sthpw/copy_n_paste.csv";
applet.create_file(path, csv);
// upload the file
applet.upload_file(path)
applet.rmtree(path);
var top = bvr.src_el.getParent(".spt_import_csv");
var hidden = top.getElement(".spt_upload_hidden");
hidden.value = path;
var file_name = spt.path.get_basename(hidden.value);
file_name = spt.path.get_filesystem_name(file_name);
var class_name = 'tactic.ui.widget.CsvImportWdg';
var values = spt.api.Utility.get_input_values('csv_import_main');
values['is_refresh'] = true;
values['file_name'] = file_name;
var info = spt.panel.load('csv_import_main', class_name, {}, values);
'''
} )
return widget
sobject_title = my.search_type_obj.get_title()
div = DivWdg(css='spt_csv_sample')
widget.add(div)
h3 = DivWdg("Preview Data")
h3.add_border()
h3.add_color('color','color')
h3.add_gradient('background','background', -5)
h3.add_style("padding: 5px")
h3.add_style("font-weight: bold")
h3.add_style("margin-left: -20px")
h3.add_style("margin-right: -20px")
div.add(h3)
div.add("<br/>")
refresh_button = ActionButtonWdg(title="Refresh")
refresh_button.add_behavior({'type' : 'click_up',
'cbjs_action': "spt.panel.refresh('preview_data',\
spt.api.Utility.get_input_values('csv_import_main'))"})
refresh_button.add_style("float: left")
div.add(refresh_button)
import_button = ActionButtonWdg(title="Import")
import_button.set_id('CsvImportButton')
import_button.add_behavior({
'type':'click_up',
'top_id':'csv_import_main',