data_processor.py @ 7247844

ESS_GUIESS_GUI_DocsESS_GUI_batch_fittingESS_GUI_bumps_abstractionESS_GUI_iss1116ESS_GUI_iss879ESS_GUI_iss959ESS_GUI_openclESS_GUI_orderingESS_GUI_sync_sascalccostrafo411magnetic_scattrelease-4.1.1release-4.1.2release-4.2.2release_4.0.1ticket-1009ticket-1094-headlessticket-1242-2d-resolutionticket-1243ticket-1249ticket885unittest-saveload

Last change on this file since 7247844 was 5531a46, checked in by Gervaise Alina <gervyh@…>, 13 years ago
make sure the grid is not editable when there is no data
Property mode set to `100644`
File size: 52.4 KB

Rev	Line
[24adb89]	1	"""
	2	Implement grid used to store data
	3	"""
	4	import wx
	5	import numpy
[904830e]	6	import math
[1ec979d]	7	import time
[904830e]	8	import re
[850525c]	9	import os
[24adb89]	10	import sys
[7ad194fa]	11	import copy
[24adb89]	12	from wx.lib.scrolledpanel import ScrolledPanel
	13	import wx.grid as Grid
	14	import wx.aui
	15	from wx.aui import AuiNotebook as nb
	16	import wx.lib.sheet as sheet
[1c86a37]	17	from sans.guiframe.panel_base import PanelBase
	18	from sans.guiframe.utils import format_number
[24adb89]	19	from sans.guiframe.events import NewPlotEvent
	20	from sans.guiframe.events import StatusEvent
[fe98127]	21	from danse.common.plottools import plottables
[24adb89]	22	from sans.guiframe.dataFitting import Data1D
	23
[904830e]	24	FUNC_DICT = {"sqrt": "math.sqrt",
	25	"pow": "math.sqrt"}
[73197d0]	26
[5425990]	27	class BatchCell:
	28	"""
	29	Object describing a cell in the grid.
	30
	31	"""
	32	def __init__(self):
	33	self.label = ""
	34	self.value = None
	35	self.col = -1
	36	self.row = -1
[75790dc]	37	self.object = []
[5425990]	38
[73197d0]	39
[904830e]	40	def parse_string(sentence, list):
	41	"""
	42	Return a dictionary of column label and index or row selected
	43	:param sentence: String to parse
	44	:param list: list of columns label
	45	"""
	46	toks = []
	47	p2 = re.compile(r'\d+')
	48	p = re.compile(r'[\+\-\*\%\/]')
	49	labels = p.split(sentence)
	50	col_dict = {}
	51	for elt in labels:
	52	rang = None
	53	temp_arr = []
	54	for label in list:
	55	label_pos = elt.find(label)
[08dc9e87]	56	separator_pos = label_pos + len(label)
	57	if label_pos != -1 and len(elt) >= separator_pos and\
	58	elt[separator_pos]== "[":
	59	# the label contain , meaning the range selected is not
	60	# continuous
[904830e]	61	if elt.count(',') > 0:
	62	new_temp = []
	63	temp = elt.split(label)
	64	for item in temp:
	65	range_pos = item.find(":")
	66	if range_pos != -1:
	67	rang = p2.findall(item)
	68	for i in xrange(int(rang[0]), int(rang[1])+1 ):
	69	new_temp.append(i)
	70	temp_arr += new_temp
	71	else:
[08dc9e87]	72	# continuous range
[904830e]	73	temp = elt.split(label)
	74	for item in temp:
[08dc9e87]	75	if item.strip() != "":
	76	range_pos = item.find(":")
	77	if range_pos != -1:
	78	rang = p2.findall(item)
	79	for i in xrange(int(rang[0]), int(rang[1])+1 ):
	80	temp_arr.append(i)
[904830e]	81	col_dict[elt] = (label, temp_arr)
	82	return col_dict
[24adb89]	83
[f4b37d1]	84
	85
	86	class SPanel(ScrolledPanel):
	87	def __init__(self, parent, args, *kwds):
	88	ScrolledPanel.__init__(self, parent , args, *kwds)
	89	self.SetupScrolling()
	90
[24adb89]	91	class GridPage(sheet.CSheet):
[9c8f3ad]	92	"""
	93	"""
[24adb89]	94	def __init__(self, parent, panel=None):
	95	"""
	96	"""
	97	sheet.CSheet.__init__(self, parent)
[f4b37d1]	98
	99	self.AdjustScrollbars()
	100	#self.SetLabelBackgroundColour('#DBD4D4')
[fd51a7c]	101	self.uid = wx.NewId()
[f4b37d1]	102	self.parent = parent
[24adb89]	103	self.panel = panel
	104	self.col_names = []
[8523a1f2]	105	self.data_inputs = {}
	106	self.data_outputs = {}
[d03a356]	107	self.data = None
[71fa9028]	108	self.details = ""
	109	self.file_name = None
[9c8f3ad]	110	self._cols = 50
	111	self._rows = 51
[63dc6e5]	112	self.last_selected_row = -1
	113	self.last_selected_col = -1
[1c86a37]	114	self.col_width = 30
	115	self.row_height = 20
[656d65d]	116	self.max_row_touse = 0
[49ad00b]	117	self.axis_value = []
	118	self.axis_label = ""
	119	self.selected_cells = []
	120	self.selected_cols = []
[75790dc]	121	self.selected_rows = []
	122	self.plottable_cells = []
[63dc6e5]	123	self.plottable_flag = False
[1c86a37]	124	self.SetColMinimalAcceptableWidth(self.col_width)
	125	self.SetRowMinimalAcceptableHeight(self.row_height)
[24adb89]	126	self.SetNumberRows(self._cols)
	127	self.SetNumberCols(self._rows)
[f4b37d1]	128	self.AutoSize()
[23477c6]	129	self.list_plot_panels = {}
[1c86a37]	130	self.default_col_width = 75
[5531a46]	131	self.EnableEditing(False)
[1c86a37]	132	if self.GetNumberCols() > 0:
	133	self.default_col_width = self.GetColSize(0)
[49ad00b]	134	self.Bind(wx.grid.EVT_GRID_LABEL_LEFT_CLICK, self.on_left_click)
[24adb89]	135	self.Bind(wx.grid.EVT_GRID_LABEL_RIGHT_CLICK, self.on_right_click)
[49ad00b]	136	self.Bind(wx.grid.EVT_GRID_CELL_LEFT_CLICK, self.on_selected_cell)
[656d65d]	137	self.Bind(wx.grid.EVT_GRID_CMD_CELL_CHANGE, self.on_edit_cell)
[1c86a37]	138
	139
[656d65d]	140	def on_edit_cell(self, event):
	141	"""
	142	"""
	143	row, col = event.GetRow(), event.GetCol()
	144	if row > self.max_row_touse:
	145	self.max_row_touse = row
	146	event.Skip()
[49ad00b]	147
	148	def on_selected_cell(self, event):
	149	"""
	150	Handler catching cell selection
	151	"""
	152	flag = event.CmdDown() or event.ControlDown()
[904830e]	153	row, col = event.GetRow(), event.GetCol()
	154	cell = (row, col)
[63dc6e5]	155	event.Skip()
[49ad00b]	156	if not flag:
[08dc9e87]	157	self.selected_cols = []
	158	self.selected_rows = []
[49ad00b]	159	self.selected_cells = []
[904830e]	160	self.axis_label = ""
[08dc9e87]	161	self.axis_value = []
	162	self.plottable_list = []
	163	self.plottable_cells = []
	164	self.plottable_flag = False
	165	self.last_selected_col = col
	166	self.last_selected_row = row
[63dc6e5]	167	if col >= 0:
[08dc9e87]	168	label_row = 0
	169	self.axis_label = self.GetCellValue(label_row, col)
	170	self.selected_cols.append(col)
[dadf255]	171	if cell not in self.selected_cells:
	172	if row > 0:
	173	self.selected_cells.append(cell)
[08dc9e87]	174	self.selected_rows.append(row)
[49ad00b]	175	else:
[dadf255]	176	if flag:
	177	self.selected_cells.remove(cell)
	178	self.axis_value = []
	179	for cell_row, cell_col in self.selected_cells:
	180	if cell_row > 0 and cell_row < self.max_row_touse:
	181	self.axis_value.append(self.GetCellValue(cell_row, cell_col))
[08dc9e87]	182
[63dc6e5]	183
[49ad00b]	184	def on_left_click(self, event):
	185	"""
	186	Catch the left click on label mouse event
	187	"""
[647df0d1]	188	event.Skip()
[49ad00b]	189	flag = event.CmdDown() or event.ControlDown()
	190	col = event.GetCol()
[63dc6e5]	191	row = event.GetRow()
[dadf255]	192	if not flag:
	193	self.selected_cols = []
[75790dc]	194	self.selected_rows = []
[dadf255]	195	self.selected_cells = []
	196	self.axis_label = ""
[08dc9e87]	197	self.axis_value = []
[63dc6e5]	198	self.plottable_list = []
[75790dc]	199	self.plottable_cells = []
[63dc6e5]	200	self.plottable_flag = False
[75790dc]	201
[63dc6e5]	202	self.last_selected_col = col
	203	self.last_selected_row = row
[75790dc]	204	if row != -1 and row not in self.selected_rows:
	205	self.selected_rows.append(row)
	206
[647df0d1]	207	if col != -1:
	208	for row in range(1, self.GetNumberRows()+ 1):
	209	cell = (row, col)
	210	if row > 0 and row < self.max_row_touse:
	211	if cell not in self.selected_cells:
	212	self.selected_cells.append(cell)
[08dc9e87]	213	else:
	214	if flag:
	215	self.selected_cells.remove(cell)
[647df0d1]	216	self.selected_cols.append(col)
	217	self.axis_value = []
	218	for cell_row, cell_col in self.selected_cells:
	219	self.axis_value.append(self.GetCellValue(cell_row, cell_col))
	220	self.axis_label = self.GetCellValue(0, col)
[75790dc]	221
[24adb89]	222	def on_right_click(self, event):
[9c8f3ad]	223	"""
	224	Catch the right click mouse
	225	"""
[656d65d]	226
[24adb89]	227	col = event.GetCol()
[656d65d]	228	self.selected_cols = []
	229	self.selected_cols.append(col)
[24adb89]	230	# Slicer plot popup menu
	231	slicerpop = wx.Menu()
[656d65d]	232	col_label_menu = wx.Menu()
[1c86a37]	233	c_name = self.GetCellValue(0, col)
	234	label = "Insert column before %s " % str(c_name)
[656d65d]	235	slicerpop.AppendSubMenu(col_label_menu ,
[1c86a37]	236	'&%s' % str(label), str(label))
[71fa9028]	237	col_name = [self.GetCellValue(0, c)
	238	for c in range(self.GetNumberCols())]
	239	row = 0
	240	label = self.GetCellValue(row, col)
	241	self.insert_col_menu(col_label_menu, label, self)
[b18cf3d]	242
	243
	244	col_after_menu = wx.Menu()
	245	label = "Insert column after %s " % str(c_name)
	246	slicerpop.AppendSubMenu(col_after_menu ,
	247	'&%s' % str(label), str(label))
	248	col_name = [self.GetCellValue(0, c)
	249	for c in range(self.GetNumberCols())]
	250	self.insert_after_col_menu(col_after_menu, label, self)
	251
	252
[656d65d]	253	id = wx.NewId()
	254	hint = 'Remove selected column %s'
[71fa9028]	255	slicerpop.Append(id, '&Remove Column', hint)
[656d65d]	256	wx.EVT_MENU(self, id, self.on_remove_column)
[24adb89]	257
[656d65d]	258	pos = wx.GetMousePosition()
[24adb89]	259	pos = self.ScreenToClient(pos)
	260	self.PopupMenu(slicerpop, pos)
[647df0d1]	261	event.Skip()
[24adb89]	262
[71fa9028]	263	def insert_col_menu(self, menu, label, window):
	264	"""
	265	"""
[5531a46]	266	if self.data is None:
	267	return
[71fa9028]	268	id = wx.NewId()
	269	title = "Empty"
	270	hint = 'Insert empty column before %s' % str(label)
	271	menu.Append(id, title, hint)
	272	wx.EVT_MENU(window, id, self.on_insert_column)
[fb0de166]	273	row = 0
	274	col_name = [self.GetCellValue(row, col)
[71fa9028]	275	for col in range(self.GetNumberCols())]
	276	for c_name in self.data.keys():
	277	if c_name not in col_name:
	278	id = wx.NewId()
	279	hint = "Insert %s column before the " % str(c_name)
	280	hint += " %s column" % str(label)
	281	menu.Append(id, '&%s' % str(c_name), hint)
	282	wx.EVT_MENU(window, id, self.on_insert_column)
	283
[b18cf3d]	284	def insert_after_col_menu(self, menu, label, window):
	285	"""
	286	"""
[5531a46]	287	if self.data is None:
	288	return
[b18cf3d]	289	id = wx.NewId()
	290	title = "Empty"
	291	hint = 'Insert empty column after %s' % str(label)
	292	menu.Append(id, title, hint)
	293	wx.EVT_MENU(window, id, self.on_insert_after_column)
	294	row = 0
	295	col_name = [self.GetCellValue(row, col)
	296	for col in range(self.GetNumberCols())]
	297	for c_name in self.data.keys():
	298	if c_name not in col_name:
	299	id = wx.NewId()
	300	hint = "Insert %s column after the " % str(c_name)
	301	hint += " %s column" % str(label)
	302	menu.Append(id, '&%s' % str(c_name), hint)
	303	wx.EVT_MENU(window, id, self.on_insert_after_column)
	304
[71fa9028]	305	def on_remove_column(self, event=None):
[656d65d]	306	"""
	307	"""
	308	if self.selected_cols is not None or len(self.selected_cols) > 0:
	309	col = self.selected_cols[0]
[71fa9028]	310	self.remove_column(col=col, numCols=1)
	311
	312	def remove_column(self, col, numCols=1):
	313	"""
	314	Remove column to the current grid
	315	"""
	316	# add data to the grid
	317	row = 0
	318	col_name = self.GetCellValue(row, col)
	319	self.data[col_name] = []
	320	for row in range(1, self.GetNumberRows() + 1):
	321	if row < self.max_row_touse:
	322	value = self.GetCellValue(row, col)
	323	self.data[col_name].append(value)
	324	for k , value_list in self.data.iteritems():
	325	if k != col_name:
	326	length = len(value_list)
	327	if length < self.max_row_touse:
	328	diff = self.max_row_touse - length
	329	for i in range(diff):
	330	self.data[k].append("")
	331	self.DeleteCols(pos=col, numCols=numCols, updateLabels=True)
[656d65d]	332
	333	def on_insert_column(self, event):
	334	"""
	335	"""
	336	if self.selected_cols is not None or len(self.selected_cols) > 0:
	337	col = self.selected_cols[0]
	338	# add data to the grid
	339	row = 0
	340	id = event.GetId()
	341	col_name = event.GetEventObject().GetLabelText(id)
[71fa9028]	342	self.insert_column(col=col, col_name=col_name)
	343	if not issubclass(event.GetEventObject().__class__ , wx.Menu):
	344	col += 1
	345	self.selected_cols[0] += 1
[b18cf3d]	346
	347	def on_insert_after_column(self, event):
	348	"""
	349	Insert the given column after the highlighted column
	350	"""
	351	if self.selected_cols is not None or len(self.selected_cols) > 0:
	352	col = self.selected_cols[0] + 1
	353	# add data to the grid
	354	row = 0
	355	id = event.GetId()
	356	col_name = event.GetEventObject().GetLabelText(id)
	357	self.insert_column(col=col, col_name=col_name)
	358	if not issubclass(event.GetEventObject().__class__ , wx.Menu):
	359	self.selected_cols[0] += 1
[71fa9028]	360
	361	def insert_column(self, col, col_name):
	362	"""
	363	"""
	364
	365	row = 0
	366	self.InsertCols(pos=col, numCols=1, updateLabels=True)
	367	if col_name.strip() != "Empty":
	368	self.SetCellValue(row, col, str(col_name.strip()))
	369	if col_name in self.data.keys():
	370	value_list = self.data[col_name]
	371	cell_row = 1
	372	for value in value_list:
[6dad639]	373	label = value#format_number(value, high=True)
[b18cf3d]	374	self.SetCellValue(cell_row, col, str(label))
[71fa9028]	375	cell_row += 1
[b18cf3d]	376	self.AutoSizeColumn(col, True)
	377	width = self.GetColSize(col)
	378	if width < self.default_col_width:
	379	self.SetColSize(col, self.default_col_width)
	380	self.ForceRefresh()
[656d65d]	381
[24adb89]	382	def on_set_x_axis(self, event):
[9c8f3ad]	383	"""
	384	"""
[24adb89]	385	self.panel.set_xaxis(x=self.axis_value, label=self.axis_label)
	386
	387	def on_set_y_axis(self, event):
[9c8f3ad]	388	"""
	389	"""
[24adb89]	390	self.panel.set_yaxis(y=self.axis_value, label=self.axis_label)
	391
[71fa9028]	392	def set_data(self, data_inputs, data_outputs, details, file_name):
[24adb89]	393	"""
[9c8f3ad]	394	Add data to the grid
[dadf255]	395	:param data_inputs: data to use from the context menu of the grid
	396	:param data_ouputs: default columns deplayed
[24adb89]	397	"""
[71fa9028]	398	self.file_name = file_name
	399	self.details = details
	400
[8523a1f2]	401	if data_outputs is None:
	402	data_outputs = {}
	403	self.data_outputs = data_outputs
[71fa9028]	404	if data_inputs is None:
[8523a1f2]	405	data_inputs = {}
	406	self.data_inputs = data_inputs
[656d65d]	407	self.data = {}
	408	for item in (self.data_outputs, self.data_inputs):
	409	self.data.update(item)
[5531a46]	410
	411	if len(self.data) + len(self.data_inputs) +len(self.data_outputs) == 0:
	412	self.EnableEditing(False)
	413	else:
	414	self.EnableEditing(True)
[8523a1f2]	415	if len(self.data_outputs) > 0:
[9c8f3ad]	416	self._cols = self.GetNumberCols()
	417	self._rows = self.GetNumberRows()
[8523a1f2]	418	self.col_names = self.data_outputs.keys()
[24adb89]	419	self.col_names.sort()
[9c8f3ad]	420	nbr_user_cols = len(self.col_names)
	421	#Add more columns to the grid if necessary
	422	if nbr_user_cols > self._cols:
	423	new_col_nbr = nbr_user_cols - self._cols
	424	self.AppendCols(new_col_nbr, True)
	425	#Add more rows to the grid if necessary
[8523a1f2]	426	nbr_user_row = len(self.data_outputs.values())
[9c8f3ad]	427	if nbr_user_row > self._rows + 1:
	428	new_row_nbr = nbr_user_row - self._rows
	429	self.AppendRows(new_row_nbr, True)
	430	# add data to the grid
[10675c3]	431	row = 0
[24adb89]	432	col = 0
[8523a1f2]	433	cell_col = 0
	434	for col_name in self.col_names:
	435	# use the first row of the grid to add user defined labels
	436	self.SetCellValue(row, col, str(col_name))
[24adb89]	437	col += 1
[8523a1f2]	438	cell_row = 1
	439	value_list = self.data_outputs[col_name]
	440
	441	for value in value_list:
[5425990]	442	label = value
	443	if issubclass(value.__class__, BatchCell):
	444	label = value.label
[1c86a37]	445	try:
	446	float(label)
[6dad639]	447	label = str(label)#format_number(label, high=True)
[1c86a37]	448	except:
	449	label = str(label)
	450	self.SetCellValue(cell_row, cell_col, label)
	451	self.AutoSizeColumn(cell_col, True)
	452	width = self.GetColSize(cell_col)
	453	if width < self.default_col_width:
	454	self.SetColSize(cell_col, self.default_col_width)
	455
[8523a1f2]	456	cell_row += 1
	457	cell_col += 1
[656d65d]	458	if cell_row > self.max_row_touse:
	459	self.max_row_touse = cell_row
[1c86a37]	460	self.ForceRefresh()
	461
[71fa9028]	462	def get_grid_view(self):
	463	"""
	464	Return value contained in the grid
	465	"""
	466	grid_view = {}
	467	for col in xrange(self.GetNumberCols()):
	468	label = self.GetCellValue(row=0, col=col)
	469	label = label.strip()
	470	if label != "":
	471	grid_view[label] = []
[c27a111]	472	for row in range(1, self.max_row_touse):
[71fa9028]	473	value = self.GetCellValue(row=row, col=col)
	474	if value != "":
	475	grid_view[label].append(value)
	476	else:
	477	grid_view[label].append(None)
	478	return grid_view
	479
[24adb89]	480	class Notebook(nb, PanelBase):
	481	"""
	482	## Internal name for the AUI manager
	483	window_name = "Fit panel"
	484	## Title to appear on top of the window
	485	"""
	486	window_caption = "Notebook "
	487
	488	def __init__(self, parent, manager=None, data=None, args, *kwargs):
	489	"""
	490	"""
	491	nb.__init__(self, parent, -1,
[f4b37d1]	492	style=wx.aui.AUI_NB_WINDOWLIST_BUTTON\|
	493	wx.aui.AUI_BUTTON_DOWN\|
[9c8f3ad]	494	wx.aui.AUI_NB_DEFAULT_STYLE\|
	495	wx.CLIP_CHILDREN)
[24adb89]	496	PanelBase.__init__(self, parent)
[9c8f3ad]	497	self.enable_close_button()
[24adb89]	498	self.parent = parent
	499	self.manager = manager
	500	self.data = data
[d03a356]	501	#add empty page
	502	self.add_empty_page()
	503
[9c8f3ad]	504	self.Bind(wx.aui.EVT_AUINOTEBOOK_PAGE_CLOSE, self.on_close_page)
[7ad194fa]	505
[d03a356]	506	def add_empty_page(self):
	507	"""
	508	"""
	509	grid = GridPage(self, panel=self.parent)
	510	self.AddPage(grid, "", True)
	511	pos = self.GetPageIndex(grid)
[63f4b8e]	512	title = "Batch" + str(self.GetPageCount())
[d03a356]	513	self.SetPageText(pos, title)
	514	self.SetSelection(pos)
[f4b37d1]	515	return grid , pos
[d03a356]	516
[9c8f3ad]	517	def enable_close_button(self):
	518	"""
	519	display the close button on tab for more than 1 tabs else remove the
	520	close button
	521	"""
	522	if self.GetPageCount() <= 1:
	523	style = self.GetWindowStyleFlag()
	524	flag = wx.aui.AUI_NB_CLOSE_ON_ACTIVE_TAB
	525	if style & wx.aui.AUI_NB_CLOSE_ON_ACTIVE_TAB == flag:
	526	style = style & ~wx.aui.AUI_NB_CLOSE_ON_ACTIVE_TAB
	527	self.SetWindowStyle(style)
	528	else:
	529	style = self.GetWindowStyleFlag()
	530	flag = wx.aui.AUI_NB_CLOSE_ON_ACTIVE_TAB
	531	if style & wx.aui.AUI_NB_CLOSE_ON_ACTIVE_TAB != flag:
	532	style \|= wx.aui.AUI_NB_CLOSE_ON_ACTIVE_TAB
	533	self.SetWindowStyle(style)
[9680906d]	534
	535	def on_edit_axis(self):
	536	"""
[08dc9e87]	537	Return the select cell of a given selected column. Check that all cells
	538	are from the same column
[9680906d]	539	"""
	540	pos = self.GetSelection()
	541	grid = self.GetPage(pos)
[08dc9e87]	542	if len(grid.selected_cols) >= 1:
[49ad00b]	543	col = grid.selected_cols[0]
[08dc9e87]	544	for c in grid.selected_cols:
	545	if c != col:
[7ad194fa]	546	msg = "Edit axis doesn't understand this selection.\n"
[08dc9e87]	547	msg += "Please select only one column"
[7ad194fa]	548	raise ValueError, msg
[08dc9e87]	549	for (cell_row, cell_col) in grid.selected_cells:
	550	if cell_col != col:
	551	msg = "Cannot use cells from different columns for "
	552	msg += "this operation.\n"
	553	msg += "Please select elements of the same col.\n"
	554	raise ValueError, msg
	555	else:
	556	msg = "No item selected.\n"
	557	msg += "Please select only one column or one cell"
	558	raise ValueError, msg
	559
[dadf255]	560	return grid.selected_cells
	561
[7ad194fa]	562
[904830e]	563	def get_column_labels(self):
	564	"""
	565	return dictionary of columns labels of the current page
	566	"""
	567	pos = self.GetSelection()
	568	grid = self.GetPage(pos)
	569	labels = {}
	570	row = 0
	571	for col in range(grid.GetNumberCols()):
	572	label = grid.GetCellValue(row, col)
	573	if label.strip() != "" :
	574	labels[label.strip()] = col
	575	return labels
	576
[7ad194fa]	577	def create_axis_label(self, cell_list):
	578	"""
	579	Receive a list of cells and create a string presenting the selected
	580	cells.
	581	:param cell_list: list of tuple
[9680906d]	582
[7ad194fa]	583	"""
	584	pos = self.GetSelection()
	585	grid = self.GetPage(pos)
	586	label = ""
	587	col_name = ""
[dadf255]	588	def create_label(col_name, row_min=None, row_max=None):
	589	"""
	590	"""
	591	result = ""
	592	if row_min is not None or row_max is not None:
	593	if row_min is None:
	594	result = str(row_max) + "]"
	595	elif row_max is None:
	596	result = str(col_name) + "[" + str(row_min) + ":"
	597	else:
	598	result = str(col_name) + "[" + str(row_min) + ":"
[08dc9e87]	599	result += str(row_max) + "]"
	600	return str(result)
[dadf255]	601
[7ad194fa]	602	if len(cell_list) > 0:
[dadf255]	603	if len(cell_list) == 1:
	604	row_min, col = cell_list[0]
	605	col_name = grid.GetCellValue(0, col)
	606	label = create_label(col_name, row_min+1 , row_min+1)
	607	return label, col_name
	608	else:
	609	temp_list = copy.deepcopy(cell_list)
	610	temp_list.sort()
	611	length = len(temp_list)
	612	row_min, col = temp_list[0]
	613	row_max, _ = temp_list[length-1]
	614	col_name = grid.GetCellValue(0, col)
	615	index = 0
	616	for row in xrange(row_min, row_max +1):
	617	if index > 0 and index < len(temp_list):
	618	new_row, _ = temp_list[index]
	619	if row != new_row:
	620	temp_list.insert(index, (None, None))
[08dc9e87]	621	if index -1 >= 0:
[dadf255]	622	new_row, _ = temp_list[index-1]
	623	label += create_label(col_name, None, new_row +1)
	624	label += ","
	625	if index + 1 < len(temp_list):
	626	new_row, _ = temp_list[index + 1]
	627	label += create_label(col_name, new_row+1, None)
	628	if index == 0:
	629	label += create_label(col_name, row_min+1, None)
	630	elif index == len(temp_list)-1:
	631	label += create_label(col_name, None, row_max+1)
	632	index += 1
	633	return label, col_name
[7ad194fa]	634
[9c8f3ad]	635	def on_close_page(self, event):
	636	"""
	637	close the page
	638	"""
	639	if self.GetPageCount() == 1:
	640	event.Veto()
	641	self.enable_close_button()
[24adb89]	642
[71fa9028]	643	def set_data(self, data_inputs, data_outputs, details="", file_name=None):
[8523a1f2]	644	if data_outputs is None or data_outputs == {}:
[24adb89]	645	return
	646
[f4b37d1]	647	for pos in range(self.GetPageCount()):
	648	grid = self.GetPage(pos)
	649	if grid.data is None:
	650	#Found empty page
[71fa9028]	651	grid.set_data(data_inputs=data_inputs,
	652	data_outputs=data_outputs,
	653	details=details,
	654	file_name=file_name)
[f4b37d1]	655	self.SetSelection(pos)
	656	return
	657
	658	grid, pos = self.add_empty_page()
[a84ca2a]	659	grid.set_data(data_inputs=data_inputs,
	660	data_outputs=data_outputs,
	661	file_name=file_name,
	662	details=details)
[f4b37d1]	663
[9c8f3ad]	664	def add_column(self):
	665	"""
	666	Append a new column to the grid
	667	"""
	668	pos = self.GetSelection()
	669	grid = self.GetPage(pos)
	670	grid.AppendCols(1, True)
	671
[71fa9028]	672
[f4b37d1]	673
[24adb89]	674
[9c8f3ad]	675
[24adb89]	676	class GridPanel(SPanel):
[8523a1f2]	677	def __init__(self, parent, data_inputs=None,
	678	data_outputs=None, args, *kwds):
[24adb89]	679	SPanel.__init__(self, parent , args, *kwds)
[f4b37d1]	680
[24adb89]	681	self.vbox = wx.BoxSizer(wx.VERTICAL)
	682
[9680906d]	683	self.plotting_sizer = wx.FlexGridSizer(3, 7, 10, 5)
[75790dc]	684	self.button_sizer = wx.BoxSizer(wx.HORIZONTAL)
[24adb89]	685	self.grid_sizer = wx.BoxSizer(wx.HORIZONTAL)
	686	self.vbox.AddMany([(self.grid_sizer, 1, wx.EXPAND, 0),
	687	(wx.StaticLine(self, -1), 0, wx.EXPAND, 0),
[75790dc]	688	(self.plotting_sizer),
	689	(self.button_sizer)])
[24adb89]	690	self.parent = parent
[8523a1f2]	691	self._data_inputs = data_inputs
	692	self._data_outputs = data_outputs
[24adb89]	693	self.x = []
	694	self.y = []
	695	self.x_axis_label = None
	696	self.y_axis_label = None
[904830e]	697	self.x_axis_title = None
	698	self.y_axis_title = None
[24adb89]	699	self.x_axis_unit = None
	700	self.y_axis_unit = None
[75790dc]	701	self.view_button = None
[24adb89]	702	self.plot_button = None
[904830e]	703	self.notebook = None
[23477c6]	704
[24adb89]	705	self.layout_grid()
	706	self.layout_plotting_area()
	707	self.SetSizer(self.vbox)
[71fa9028]	708
[904830e]	709	def set_xaxis(self, label="", x=None):
	710	"""
	711	"""
[24adb89]	712	if x is None:
	713	x = []
	714	self.x = x
[904830e]	715	self.x_axis_label.SetValue("%s[:]" % str(label))
	716	self.x_axis_title.SetValue(str(label))
[24adb89]	717
[904830e]	718	def set_yaxis(self, label="", y=None):
	719	"""
	720	"""
[24adb89]	721	if y is None:
	722	y = []
	723	self.y = y
[904830e]	724	self.y_axis_label.SetValue("%s[:]" % str(label))
	725	self.y_axis_title.SetValue(str(label))
[24adb89]	726
[904830e]	727	def get_plot_axis(self, col, list):
	728	"""
	729
	730	"""
	731	axis = []
	732	pos = self.notebook.GetSelection()
	733	grid = self.notebook.GetPage(pos)
	734	for row in list:
[c911f34]	735	label = grid.GetCellValue(0, col)
	736	value = grid.GetCellValue(row - 1, col).strip()
	737	if value != "":
	738	if label.lower().strip() == "data":
	739	axis.append(float(row - 1))
	740	else:
[dadf255]	741	try:
	742	axis.append(float(value))
	743	except:
	744	msg = "Invalid data in row %s column %s" % (str(row),
	745	str(col))
	746	wx.PostEvent(self.parent.parent,
[75790dc]	747	StatusEvent(status=msg, info="error"))
[c911f34]	748	else:
	749	axis.append(None)
[904830e]	750	return axis
	751
[656d65d]	752	def on_save_column(self, parent):
	753	"""
	754	"""
	755	pos = self.notebook.GetSelection()
	756	grid = self.notebook.GetPage(pos)
	757	if parent is not None and self.data is not None:
	758	parent.write_batch_tofile(data=grid.data,
	759	file_name=path,
	760	details=self.details)
	761
[75790dc]	762	def on_view(self, event):
	763	"""
	764	Get object represented buy the given cell and plot them.
	765	"""
	766	pos = self.notebook.GetSelection()
	767	grid = self.notebook.GetPage(pos)
	768	title = self.notebook.GetPageText(pos)
[9400de6]	769	if len(grid.selected_cells) == 0:
	770	msg = "Highlight a Data or Chi2 column first..."
	771	wx.PostEvent(self.parent.parent,
	772	StatusEvent(status=msg, info="error"))
	773	return
[75790dc]	774	for cell in grid.selected_cells:
	775	row, col = cell
	776	label_row = 0
	777	label = grid.GetCellValue(label_row, col)
	778	if label in grid.data:
	779	values = grid.data[label]
[344c5d8]	780	if row > len(values) or row < 1:
[9400de6]	781	msg = "Invalid cell was chosen."
	782	wx.PostEvent(self.parent.parent, StatusEvent(status=msg,
	783	info="error"))
[1ec979d]	784	time.sleep(0.5)
[9400de6]	785	continue
[344c5d8]	786	else:
	787	value = values[row -1]
[75790dc]	788	if issubclass(value.__class__, BatchCell):
[fe98127]	789	if value.object is None or len(value.object) == 0:
	790	msg = "Row %s , " % str(row)
[c27a111]	791	msg += "Column %s is NOT " % str(label)
	792	msg += "the results of fits to view..."
[fe98127]	793	#raise ValueError, msg
	794	wx.PostEvent(self.parent.parent, StatusEvent(status=msg,
	795	info="error"))
	796	return
[75790dc]	797	for new_plot in value.object:
[fe98127]	798	if new_plot is None or \
[1f83477]	799	not issubclass(new_plot.__class__,
[fe98127]	800	plottables.Plottable):
[75790dc]	801	msg = "Row %s , " % str(row)
[c27a111]	802	msg += "Column %s is NOT " % str(label)
	803	msg += "the results of fits to view..."
[75790dc]	804	#raise ValueError, msg
	805	wx.PostEvent(self.parent.parent,
	806	StatusEvent(status=msg, info="error"))
[1ec979d]	807	time.sleep(0.5)
[7d47789]	808	continue
[63f4b8e]	809	#new_plot.name = title + ': ' + new_plot.title
[75790dc]	810	if issubclass(new_plot.__class__, Data1D):
[23477c6]	811	if label in grid.list_plot_panels.keys():
	812	group_id = grid.list_plot_panels[label]
[fd51a7c]	813	else:
[5d192cd]	814	group_id = str(new_plot.group_id) + str(grid.uid)
[23477c6]	815	grid.list_plot_panels[label] = group_id
[fd51a7c]	816	if group_id not in new_plot.list_group_id:
	817	new_plot.group_id = group_id
	818	new_plot.list_group_id.append(group_id)
[75790dc]	819	else:
[18a6556]	820	if label.lower() in ["data", "chi2"]:
[75790dc]	821	if len(grid.selected_cells) != 1:
[b18cf3d]	822	msg = "2D View: Please select one data set"
[c27a111]	823	msg += " at a time for View Results."
[75790dc]	824	wx.PostEvent(self.parent.parent,
	825	StatusEvent(status=msg,
[1ec979d]	826	info="error"))
	827	time.sleep(0.5)
[7d47789]	828	continue
[23477c6]	829	"""
[75790dc]	830	wx.PostEvent(self.parent.parent,
[fd51a7c]	831	NewPlotEvent(action="clear",
	832	group_id=str(group_id),
[23477c6]	833	title=title))
	834	"""
[fd51a7c]	835	wx.PostEvent(self.parent.parent,
[75790dc]	836	NewPlotEvent(plot=new_plot,
[1ec979d]	837	group_id=str(new_plot.group_id),
	838	title=title))
[c27a111]	839	msg = "Plotting the View Results completed!"
	840	wx.PostEvent( self.parent.parent,
	841	StatusEvent(status=msg))
[75790dc]	842	else:
	843
	844	msg = "Row %s , " % str(row)
[c27a111]	845	msg += "Column %s is NOT " % str(label)
	846	msg += "the results of fits to view..."
[75790dc]	847	#raise ValueError, msg
	848	wx.PostEvent(self.parent.parent,
	849	StatusEvent(status=msg, info="error"))
[1ec979d]	850	time.sleep(0.5)
[665fd06]	851	continue
[75790dc]	852
	853
	854
	855
[24adb89]	856	def on_plot(self, event):
	857	"""
[904830e]	858	Evaluate the contains of textcrtl and plot result
[24adb89]	859	"""
[904830e]	860	pos = self.notebook.GetSelection()
	861	grid = self.notebook.GetPage(pos)
	862	column_names = {}
	863	if grid is not None:
	864	column_names = self.notebook.get_column_labels()
[08dc9e87]	865	#evaluate x
[904830e]	866	sentence = self.x_axis_label.GetValue()
[1c86a37]	867	try:
	868	if sentence.strip() == "":
[08dc9e87]	869	msg = "Select column values for x axis"
[1c86a37]	870	raise ValueError, msg
	871	except:
	872	wx.PostEvent(self.parent.parent,
	873	StatusEvent(status=msg, info="error"))
	874	return
[08dc9e87]	875
[904830e]	876	dict = parse_string(sentence, column_names.keys())
	877	for tok, (col_name, list) in dict.iteritems():
	878	col = column_names[col_name]
	879	xaxis = self.get_plot_axis(col, list)
	880	sentence = sentence.replace(tok,
	881	"numpy.array(%s)" % str(xaxis))
	882	for key, value in FUNC_DICT.iteritems():
	883	sentence = sentence.replace(key.lower(), value)
	884	x = eval(sentence)
	885	#evaluate y
	886	sentence = self.y_axis_label.GetValue()
	887	if sentence.strip() == "":
	888	msg = "select value for y axis"
	889	raise ValueError, msg
	890	dict = parse_string(sentence, column_names.keys())
	891	for tok, (col_name, list) in dict.iteritems():
	892	col = column_names[col_name]
	893	yaxis = self.get_plot_axis(col, list)
	894	sentence = sentence.replace(tok,
	895	"numpy.array(%s)" % str(yaxis))
	896	for key, value in FUNC_DICT.iteritems():
	897	sentence = sentence.replace(key, value)
	898	y = eval(sentence)
[08dc9e87]	899	if len(x) != len(y) and (len(x) == 0 or len(y) == 0):
	900	msg = "Need same length for X and Y axis and both greater than 0"
	901	msg += " to plot.\n"
	902	msg += "Got X length = %s, Y length = %s" % (str(len(x)),
	903	str(len(y)))
	904	wx.PostEvent(self.parent.parent,
	905	StatusEvent(status=msg, info="error"))
	906	return
	907
[904830e]	908	#plotting
	909	new_plot = Data1D(x=x, y=y)
[24adb89]	910	new_plot.id = wx.NewId()
	911	new_plot.group_id = wx.NewId()
[904830e]	912	title = "%s vs %s" % (self.y_axis_title.GetValue(),
	913	self.x_axis_title.GetValue())
[1ec979d]	914	new_plot.xaxis(self.x_axis_title.GetValue(),
	915	self.x_axis_unit.GetValue())
	916	new_plot.yaxis(self.y_axis_title.GetValue(),
	917	self.y_axis_unit.GetValue())
[904830e]	918	try:
	919	title = self.notebook.GetPageText(pos)
[dadf255]	920	new_plot.name = title
[1c86a37]	921	new_plot.xtransform = "x"
	922	new_plot.ytransform = "y"
[904830e]	923	wx.PostEvent(self.parent.parent,
[1ec979d]	924	NewPlotEvent(plot=new_plot,
[c27a111]	925	group_id=str(new_plot.group_id), title =title))
	926	msg = "Plotting completed!"
	927	wx.PostEvent( self.parent.parent,
	928	StatusEvent(status=msg))
[904830e]	929	except:
[dadf255]	930	wx.PostEvent(self.parent.parent,
[75790dc]	931	StatusEvent(status=msg, info="error"))
[c27a111]	932
[24adb89]	933	def layout_grid(self):
	934	"""
	935	Draw the area related to the grid
	936	"""
[904830e]	937	self.notebook = Notebook(parent=self)
[8523a1f2]	938	self.notebook.set_data(self._data_inputs, self._data_outputs)
[904830e]	939	self.grid_sizer.Add(self.notebook, 1, wx.EXPAND, 0)
[24adb89]	940
	941	def layout_plotting_area(self):
	942	"""
	943	Draw area containing options to plot
	944	"""
[75790dc]	945
[904830e]	946	self.x_axis_title = wx.TextCtrl(self, -1)
	947	self.y_axis_title = wx.TextCtrl(self, -1)
	948	self.x_axis_label = wx.TextCtrl(self, -1, size=(200, -1))
	949	self.y_axis_label = wx.TextCtrl(self, -1, size=(200, -1))
[9680906d]	950	self.x_axis_add = wx.Button(self, -1, "Add")
	951	self.x_axis_add.Bind(event=wx.EVT_BUTTON, handler=self.on_edit_axis,
	952	id=self.x_axis_add.GetId())
	953	self.y_axis_add = wx.Button(self, -1, "Add")
	954	self.y_axis_add.Bind(event=wx.EVT_BUTTON, handler=self.on_edit_axis,
	955	id=self.y_axis_add.GetId())
[24adb89]	956	self.x_axis_unit = wx.TextCtrl(self, -1)
	957	self.y_axis_unit = wx.TextCtrl(self, -1)
[1c86a37]	958	self.view_button = wx.Button(self, -1, "View Results")
[7d47789]	959	view_tip = "Highlight the data set or the Chi2 column first."
[b18cf3d]	960	self.view_button.SetToolTipString(view_tip)
[75790dc]	961	wx.EVT_BUTTON(self, self.view_button.GetId(), self.on_view)
[24adb89]	962	self.plot_button = wx.Button(self, -1, "Plot")
[7d47789]	963	plot_tip = "Highlight a column for each axis and \n"
	964	plot_tip += "click the Add buttons first."
[b18cf3d]	965	self.plot_button.SetToolTipString(plot_tip)
[75790dc]	966	self.button_sizer.AddMany( [ (500, 30),
	967	(self.view_button, 0, wx.RIGHT\|wx.BOTTOM, 10),
	968	(self.plot_button, 0, wx.RIGHT\|wx.BOTTOM, 10)])
	969
[24adb89]	970	wx.EVT_BUTTON(self, self.plot_button.GetId(), self.on_plot)
[9680906d]	971	self.plotting_sizer.AddMany([
[9bfa73f]	972	(wx.StaticText(self, -1,
	973	"X-axis Label\nSelection Range"), 1,
[904830e]	974	wx.TOP\|wx.BOTTOM\|wx.LEFT, 10),
	975	(self.x_axis_label, 1, wx.TOP\|wx.BOTTOM, 10),
	976	(self.x_axis_add, 1, wx.TOP\|wx.BOTTOM\|wx.RIGHT, 10),
[9bfa73f]	977	(wx.StaticText(self, -1, "X-axis Label"), 1,
[904830e]	978	wx.TOP\|wx.BOTTOM\|wx.LEFT, 10),
	979	(self.x_axis_title, 1, wx.TOP\|wx.BOTTOM, 10),
[7124300]	980	(wx.StaticText(self, -1 , "X-axis Unit"), 1,
[904830e]	981	wx.TOP\|wx.BOTTOM, 10),
	982	(self.x_axis_unit, 1, wx.TOP\|wx.BOTTOM, 10),
[9bfa73f]	983	(wx.StaticText(self, -1,
	984	"Y-axis Label\nSelection Range"), 1,
[904830e]	985	wx.BOTTOM\|wx.LEFT, 10),
	986	(self.y_axis_label, wx.BOTTOM, 10),
	987	(self.y_axis_add, 1, wx.BOTTOM\|wx.RIGHT, 10),
[9bfa73f]	988	(wx.StaticText(self, -1, "Y-axis Label"), 1,
[904830e]	989	wx.BOTTOM\|wx.LEFT, 10),
	990	(self.y_axis_title, wx.BOTTOM, 10),
[9bfa73f]	991	(wx.StaticText(self, -1 , "Y-axis Unit"), 1, wx.BOTTOM, 10),
[904830e]	992	(self.y_axis_unit, 1, wx.BOTTOM, 10),
[9680906d]	993	(-1, -1),
	994	(-1, -1),
	995	(-1, -1),
	996	(-1, -1),
	997	(-1, -1),
	998	(-1, -1),
[75790dc]	999	(-1, 1)])
[24adb89]	1000
[9680906d]	1001	def on_edit_axis(self, event):
	1002	"""
	1003	Get the selected column on the visible grid and set values for axis
	1004	"""
[08dc9e87]	1005	try:
	1006	cell_list = self.notebook.on_edit_axis()
	1007	except:
	1008	msg = str(sys.exc_value)
	1009	wx.PostEvent(self.parent.parent,
	1010	StatusEvent(status=msg, info="error"))
	1011	return
[904830e]	1012	label, title = self.create_axis_label(cell_list)
	1013	tcrtl = event.GetEventObject()
	1014	if tcrtl == self.x_axis_add:
	1015	self.edit_axis_helper(self.x_axis_label, self.x_axis_title,
	1016	label, title)
	1017	elif tcrtl == self.y_axis_add:
	1018	self.edit_axis_helper(self.y_axis_label, self.y_axis_title,
	1019	label, title)
	1020
[7ad194fa]	1021	def create_axis_label(self, cell_list):
	1022	"""
	1023	Receive a list of cells and create a string presenting the selected
	1024	cells.
	1025	:param cell_list: list of tuple
[24adb89]	1026
[7ad194fa]	1027	"""
[904830e]	1028	if self.notebook is not None:
	1029	return self.notebook.create_axis_label(cell_list)
[7ad194fa]	1030
[904830e]	1031	def edit_axis_helper(self, tcrtl_label, tcrtl_title, label, title):
[9680906d]	1032	"""
[904830e]	1033	get controls to modify
[9680906d]	1034	"""
[904830e]	1035	tcrtl_label.SetValue(str(label))
	1036	tcrtl_title.SetValue(str(title))
	1037
[24adb89]	1038	def add_column(self):
[9c8f3ad]	1039	"""
	1040	"""
[904830e]	1041	if self.notebook is not None:
	1042	self.notebook.add_column()
[24adb89]	1043
[9c8f3ad]	1044	def on_remove_column(self):
	1045	"""
	1046	"""
[904830e]	1047	if self.notebook is not None:
	1048	self.notebook.on_remove_column()
[9c8f3ad]	1049
[24adb89]	1050
	1051	class GridFrame(wx.Frame):
[8523a1f2]	1052	def __init__(self, parent=None, data_inputs=None, data_outputs=None, id=-1,
[cf0eb8e]	1053	title="Batch Window", size=(800, 500)):
[24adb89]	1054	wx.Frame.__init__(self, parent=parent, id=id, title=title, size=size)
	1055	self.parent = parent
[8523a1f2]	1056	self.panel = GridPanel(self, data_inputs, data_outputs)
[24adb89]	1057	menubar = wx.MenuBar()
	1058	self.SetMenuBar(menubar)
[71fa9028]	1059
	1060	self.curr_col = None
	1061	self.curr_grid = None
	1062	self.curr_col_name = ""
	1063	file = wx.Menu()
	1064	menubar.Append(file, "&File")
	1065
	1066	hint = "Open file containing batch results"
	1067	open_menu = file.Append(wx.NewId(), 'Open ', hint)
	1068	wx.EVT_MENU(self, open_menu.GetId(), self.on_open)
	1069
	1070	hint = "Open the the current grid into excel"
	1071	open_excel_menu = file.Append(wx.NewId(), 'Open with Excel', hint)
	1072	wx.EVT_MENU(self, open_excel_menu.GetId(), self.open_with_excel)
	1073	file.AppendSeparator()
	1074	save_menu = file.Append(wx.NewId(), 'Save As', 'Save into File')
	1075	wx.EVT_MENU(self, save_menu.GetId(), self.on_save_page)
	1076
	1077	self.edit = wx.Menu()
	1078	hint = "Insert column before the selected column"
	1079	self.insert_before_menu = wx.Menu()
	1080	self.insert_sub_menu = self.edit.AppendSubMenu(self.insert_before_menu,
	1081	'Insert Before', hint)
	1082
	1083	hint = "Remove the selected column"
	1084	self.remove_menu = self.edit.Append(-1, 'Remove Column', hint)
	1085	wx.EVT_MENU(self, self.remove_menu.GetId(), self.on_remove_column)
	1086
	1087	self.Bind(wx.EVT_MENU_OPEN, self.on_menu_open)
	1088	menubar.Append(self.edit, "&Edit")
[cb26857]	1089	self.Bind(wx.EVT_CLOSE, self.on_close)
[24adb89]	1090
[71fa9028]	1091	def GetLabelText(self, id):
[656d65d]	1092	"""
	1093	"""
[71fa9028]	1094	for item in self.insert_before_menu.GetMenuItems():
	1095	m_id = item.GetId()
	1096	if m_id == id:
	1097	return item.GetLabel()
	1098
	1099	def on_remove_column(self, event):
[cb26857]	1100	"""
	1101	"""
[71fa9028]	1102	pos = self.panel.notebook.GetSelection()
	1103	grid = self.panel.notebook.GetPage(pos)
	1104	grid.on_remove_column(event=None)
[cb26857]	1105
[71fa9028]	1106	def on_menu_open(self, event):
[9c8f3ad]	1107	"""
[71fa9028]	1108
[9c8f3ad]	1109	"""
[71fa9028]	1110	if self.edit == event.GetMenu():
	1111	#get the selected column
	1112	pos = self.panel.notebook.GetSelection()
	1113	grid = self.panel.notebook.GetPage(pos)
	1114	col_list = grid.GetSelectedCols()
	1115	if len(col_list) > 0:
	1116	self.remove_menu.Enable(True)
	1117	else:
	1118	self.remove_menu.Enable(False)
	1119	if len(col_list)== 0 or len(col_list) > 1:
	1120	self.insert_sub_menu.Enable(False)
	1121
	1122	label = "Insert Column Before"
	1123	self.insert_sub_menu.SetText(label)
	1124	else:
	1125	self.insert_sub_menu.Enable(True)
	1126
	1127	col = col_list[0]
	1128	#GetColLabelValue(self, col)
	1129	col_name = grid.GetCellValue(row=0, col=col)
	1130	label = "Insert Column Before " + str(col_name)
	1131	self.insert_sub_menu.SetText(label)
	1132	for item in self.insert_before_menu.GetMenuItems():
	1133	self.insert_before_menu.DeleteItem(item)
	1134	grid.insert_col_menu(menu=self.insert_before_menu,
	1135	label=col_name, window=self)
	1136	event.Skip()
[9c8f3ad]	1137
[71fa9028]	1138
	1139
	1140	def on_save_page(self, event):
	1141	"""
	1142	"""
	1143	if self.parent is not None:
	1144	pos = self.panel.notebook.GetSelection()
	1145	grid = self.panel.notebook.GetPage(pos)
[7b48b08]	1146	if grid.file_name is None or grid.file_name.strip() == "" or \
	1147	grid.data is None or len(grid.data) == 0:
	1148	name = self.panel.notebook.GetPageText(pos)
	1149	msg = " %s has not data to save" % str(name)
	1150	wx.PostEvent(self.parent,
	1151	StatusEvent(status=msg, info="error"))
	1152
	1153	return
[71fa9028]	1154	reader, ext = os.path.splitext(grid.file_name)
	1155	path = None
	1156	if self.parent is not None:
	1157	location = os.path.dirname(grid.file_name)
	1158	dlg = wx.FileDialog(self, "Save Project file",
	1159	location, grid.file_name, ext, wx.SAVE)
	1160	path = None
	1161	if dlg.ShowModal() == wx.ID_OK:
	1162	path = dlg.GetPath()
	1163	dlg.Destroy()
	1164	if path != None:
	1165	if self.parent is not None:
	1166	data = grid.get_grid_view()
	1167	self.parent.write_batch_tofile(data=data,
	1168	file_name=path,
	1169	details=grid.details)
	1170
	1171	def on_open(self, event):
[656d65d]	1172	"""
[71fa9028]	1173	Open file containg batch result
[656d65d]	1174	"""
[71fa9028]	1175	if self.parent is not None:
	1176	self.parent.on_read_batch_tofile(event)
	1177
	1178	def open_with_excel(self, event):
	1179	"""
	1180	open excel and display batch result in Excel
	1181	"""
	1182	if self.parent is not None:
	1183	pos = self.panel.notebook.GetSelection()
	1184	grid = self.panel.notebook.GetPage(pos)
	1185	data = grid.get_grid_view()
[7b48b08]	1186	if grid.file_name is None or grid.file_name.strip() == "" or \
	1187	grid.data is None or len(grid.data) == 0:
	1188	name = self.panel.notebook.GetPageText(pos)
	1189	msg = " %s has not data to open on excel" % str(name)
	1190	wx.PostEvent(self.parent,
	1191	StatusEvent(status=msg, info="error"))
	1192
	1193	return
[71fa9028]	1194	self.parent.open_with_externalapp(data=data,
	1195	file_name=grid.file_name,
	1196	details=grid.details)
	1197
	1198	def on_close(self, event):
	1199	"""
	1200	"""
	1201	self.Hide()
[656d65d]	1202
[71fa9028]	1203
[656d65d]	1204	def on_append_column(self, event):
[cb26857]	1205	"""
[9c8f3ad]	1206	Append a new column to the grid
[cb26857]	1207	"""
[24adb89]	1208	self.panel.add_column()
[cb26857]	1209
[71fa9028]	1210	def set_data(self, data_inputs, data_outputs, details="", file_name=None):
[cb26857]	1211	"""
	1212	"""
[a84ca2a]	1213
	1214	self.panel.notebook.set_data(data_inputs=data_inputs,
[71fa9028]	1215	file_name=file_name,
	1216	details=details,
	1217	data_outputs=data_outputs)
[24adb89]	1218
	1219
[83eb1b52]	1220	class BatchOutputFrame(wx.Frame):
[73197d0]	1221	"""
	1222	Allow to select where the result of batch will be displayed or stored
	1223	"""
[8523a1f2]	1224	def __init__(self, parent, data_inputs, data_outputs, file_name="",
[850525c]	1225	details="", args, *kwds):
[73197d0]	1226	"""
	1227	:param parent: Window instantiating this dialog
	1228	:param result: result to display in a grid or export to an external
	1229	application.
	1230	"""
[850525c]	1231	#kwds['style'] = wx.CAPTION\|wx.SYSTEM_MENU
[83eb1b52]	1232	wx.Frame.__init__(self, parent, args, *kwds)
[73197d0]	1233	self.parent = parent
[83eb1b52]	1234	self.panel = wx.Panel(self)
[850525c]	1235	self.file_name = file_name
	1236	self.details = details
[8523a1f2]	1237	self.data_inputs = data_inputs
	1238	self.data_outputs = data_outputs
	1239	self.data = {}
	1240	for item in (self.data_outputs, self.data_inputs):
	1241	self.data.update(item)
[73197d0]	1242	self.flag = 1
	1243	self.SetSize((300, 200))
	1244	self.local_app_selected = None
	1245	self.external_app_selected = None
	1246	self.save_to_file = None
	1247	self._do_layout()
[8523a1f2]	1248
[73197d0]	1249	def _do_layout(self):
	1250	"""
	1251	Draw the content of the current dialog window
	1252	"""
	1253	vbox = wx.BoxSizer(wx.VERTICAL)
[83eb1b52]	1254	box_description = wx.StaticBox(self.panel, -1, str("Batch Outputs"))
[73197d0]	1255	hint_sizer = wx.StaticBoxSizer(box_description, wx.VERTICAL)
[83eb1b52]	1256	selection_sizer = wx.GridBagSizer(5, 5)
[73197d0]	1257	button_sizer = wx.BoxSizer(wx.HORIZONTAL)
[caf3a08f]	1258	text = "Open with %s" % self.parent.application_name
[83eb1b52]	1259	self.local_app_selected = wx.RadioButton(self.panel, -1, text,
[73197d0]	1260	style=wx.RB_GROUP)
	1261	self.Bind(wx.EVT_RADIOBUTTON, self.onselect,
	1262	id=self.local_app_selected.GetId())
	1263	text = "Open with Excel"
[83eb1b52]	1264	self.external_app_selected = wx.RadioButton(self.panel, -1, text)
[73197d0]	1265	self.Bind(wx.EVT_RADIOBUTTON, self.onselect,
	1266	id=self.external_app_selected.GetId())
[caf3a08f]	1267	text = "Save to File"
[83eb1b52]	1268	self.save_to_file = wx.CheckBox(self.panel, -1, text)
[73197d0]	1269	self.Bind(wx.EVT_CHECKBOX, self.onselect,
	1270	id=self.save_to_file.GetId())
	1271	self.local_app_selected.SetValue(True)
	1272	self.external_app_selected.SetValue(False)
	1273	self.save_to_file.SetValue(False)
[83eb1b52]	1274	button_close = wx.Button(self.panel, -1, "Close")
	1275	button_close.Bind(wx.EVT_BUTTON, id=button_close.GetId(),
	1276	handler=self.on_close)
	1277	button_apply = wx.Button(self.panel, -1, "Apply")
	1278	button_apply.Bind(wx.EVT_BUTTON, id=button_apply.GetId(),
	1279	handler=self.on_apply)
	1280	button_apply.SetFocus()
[73197d0]	1281	hint = ""
[83eb1b52]	1282	hint_sizer.Add(wx.StaticText(self.panel, -1, hint))
[73197d0]	1283	hint_sizer.Add(selection_sizer)
	1284	#draw area containing radio buttons
	1285	ix = 0
	1286	iy = 0
	1287	selection_sizer.Add(self.local_app_selected, (iy, ix),
	1288	(1, 1), wx.LEFT\|wx.EXPAND\|wx.ADJUST_MINSIZE, 15)
	1289	iy += 1
	1290	selection_sizer.Add(self.external_app_selected, (iy, ix),
	1291	(1, 1), wx.LEFT\|wx.EXPAND\|wx.ADJUST_MINSIZE, 15)
	1292	iy += 1
	1293	selection_sizer.Add(self.save_to_file, (iy, ix),
	1294	(1, 1), wx.LEFT\|wx.EXPAND\|wx.ADJUST_MINSIZE, 15)
	1295	#contruction the sizer contaning button
	1296	button_sizer.Add((20, 20), 1, wx.EXPAND\|wx.ADJUST_MINSIZE, 0)
[caf3a08f]	1297
	1298	button_sizer.Add(button_close, 0,
	1299	wx.LEFT\|wx.EXPAND\|wx.ADJUST_MINSIZE, 15)
[83eb1b52]	1300	button_sizer.Add(button_apply, 0,
[73197d0]	1301	wx.LEFT\|wx.RIGHT\|wx.ADJUST_MINSIZE, 10)
	1302	vbox.Add(hint_sizer, 0, wx.EXPAND\|wx.ALL, 10)
[83eb1b52]	1303	vbox.Add(wx.StaticLine(self.panel, -1), 0, wx.EXPAND, 0)
[73197d0]	1304	vbox.Add(button_sizer, 0 , wx.TOP\|wx.BOTTOM, 10)
	1305	self.SetSizer(vbox)
	1306
[83eb1b52]	1307	def on_apply(self, event):
	1308	"""
	1309	Get the user selection and display output to the selected application
	1310	"""
	1311	if self.flag == 1:
[8523a1f2]	1312	self.parent.open_with_localapp(data_inputs=self.data_inputs,
	1313	data_outputs=self.data_outputs)
[83eb1b52]	1314	elif self.flag == 2:
	1315	self.parent.open_with_externalapp(data=self.data,
	1316	file_name=self.file_name,
	1317	details=self.details)
	1318	def on_close(self, event):
	1319	"""
	1320	close the Window
	1321	"""
	1322	self.Close()
	1323
[73197d0]	1324	def onselect(self, event=None):
	1325	"""
	1326	Receive event and display data into third party application
	1327	or save data to file.
	1328
	1329	"""
	1330	if self.save_to_file.GetValue():
[850525c]	1331	reader, ext = os.path.splitext(self.file_name)
	1332	path = None
	1333	location = os.getcwd()
	1334	if self.parent is not None:
[83eb1b52]	1335	location = os.path.dirname(self.file_name)
[850525c]	1336	dlg = wx.FileDialog(self, "Save Project file",
	1337	location, self.file_name, ext, wx.SAVE)
	1338	path = None
	1339	if dlg.ShowModal() == wx.ID_OK:
	1340	path = dlg.GetPath()
	1341	dlg.Destroy()
	1342	if path != None:
	1343	if self.parent is not None and self.data is not None:
[83eb1b52]	1344	self.parent.write_batch_tofile(data=self.data,
[850525c]	1345	file_name=path,
	1346	details=self.details)
	1347	if self.local_app_selected.GetValue():
[73197d0]	1348	self.flag = 1
	1349	else:
	1350	self.flag = 2
	1351	return self.flag
	1352
	1353
	1354
[24adb89]	1355	if __name__ == "__main__":
	1356	app = wx.App()
	1357
	1358	try:
	1359	data = {}
	1360	j = 0
	1361	for i in range(4):
	1362	j += 1
	1363	data["index"+str(i)] = [i/j, i*j, i, i+j]
[656d65d]	1364
	1365	data_input = copy.deepcopy(data)
	1366	data_input["index5"] = [10,20,40, 50]
	1367	frame = GridFrame(data_outputs=data, data_inputs=data_input)
[24adb89]	1368	frame.Show(True)
	1369	except:
	1370	print sys.exc_value
	1371
	1372	app.MainLoop()

Note: See TracBrowser for help on using the repository browser.

SasView

source: sasview/sansguiframe/src/sans/guiframe/data_processor.py @ 7247844

Download in other formats: