class UI(tk.Toplevel):
def __init__(self, parent, *args, **kwargs):
super().__init__(name='rejection')
self.parent = parent
self.engine = kwargs['engine']
self.index = kwargs['index']
self.resizable(0, 0)
self.transient(parent)
self.description = tk.StringVar()
self.enable = tk.BooleanVar()
self.init_ui()
self.engine.center_me(self)
def init_ui(self):
w = self.engine.get_init_ui(self)
r = 0
c = 1
tk.Label(w, text="Actions:").grid(row=r, sticky=tk.W)
self.cbActions = ttk.Combobox(w, )
self.cbActions.grid(row=r, column=c, sticky=tk.W, padx=5, pady=5)
r += 1
ttk.Label(w, text="Description:").grid(row=r, sticky=tk.W)
self.txDescription = ttk.Entry(
w,
textvariable=self.description,
)
self.txDescription.grid(row=r, column=c, sticky=tk.W, padx=5, pady=5)
r += 1
ttk.Label(w, text="Modified:").grid(row=r, column=0, sticky=tk.W)
self.modified_date = Calendarium(self, "")
self.modified_date.get_calendarium(w, r, c)
r += 1
ttk.Label(w, text="Enable:").grid(row=r, sticky=tk.W)
chk = ttk.Checkbutton(w, onvalue=1, offvalue=0, variable=self.enable)
chk.grid(row=r, column=c, sticky=tk.W)
if self.index is not None:
self.engine.get_save_cancel_delete(self, w)
else:
self.engine.get_save_cancel(self, w)
def on_open(self,
selected_test,
selected_batch,
selected_result,
selected_rejection=None):
self.selected_test = selected_test
self.selected_batch = selected_batch
self.selected_result = selected_result
self.set_actions()
if self.index is not None:
self.selected_rejection = selected_rejection
msg = "Update rejection"
self.set_values()
else:
msg = "Add rejection"
self.enable.set(1)
self.modified_date.set_today()
self.title(msg)
self.cbActions.focus()
def on_save(self, evt=None):
if self.engine.on_fields_control(self) == False: return
if self.modified_date.get_date(self) == False: return
if messagebox.askyesno(self.engine.title,
self.engine.ask_to_save,
parent=self) == True:
args = self.get_values()
if self.index is not None:
sql = self.engine.get_update_sql('rejections', 'rejection_id')
args = (*args, self.selected_rejection[0])
else:
sql = self.engine.get_insert_sql('rejections', len(args))
self.engine.write(sql, args)
self.parent.on_open(self.selected_test, self.selected_batch,
self.selected_result)
if self.index is not None:
self.parent.lstItems.see(self.index)
self.parent.lstItems.selection_set(self.index)
self.on_cancel()
def on_delete(self, evt=None):
if self.index is not None:
if messagebox.askyesno(self.engine.title,
self.engine.delete,
parent=self) == True:
sql = "DELETE FROM rejections WHERE rejection_id =?"
args = (self.selected_rejection[0], )
self.engine.write(sql, args)
self.parent.on_open(self.selected_test, self.selected_batch,
self.selected_result)
if self.index is not None:
self.parent.lstItems.see(self.index)
self.parent.lstItems.selection_set(self.index)
self.on_cancel()
else:
messagebox.showinfo(self.engine.title,
self.engine.abort,
parent=self)
def set_actions(self):
index = 0
values = []
self.dict_actions = {}
sql = "SELECT action_id, action FROM actions ORDER BY action ASC"
rs = self.engine.read(True, sql, ())
for i in rs:
self.dict_actions[index] = i[0]
index += 1
values.append(i[1])
self.cbActions['values'] = values
def get_values(self, ):
return (self.selected_result[0],
self.dict_actions[self.cbActions.current()],
self.description.get(), self.modified_date.get_timestamp(),
self.enable.get())
def set_values(self, ):
key = next(key for key, value in self.dict_actions.items()
if value == self.selected_rejection[2])
self.cbActions.current(key)
self.description.set(self.selected_rejection[3])
self.modified_date.year.set(int(self.selected_rejection[4].year))
self.modified_date.month.set(int(self.selected_rejection[4].month))
self.modified_date.day.set(int(self.selected_rejection[4].day))
self.enable.set(self.selected_rejection[5])
def on_cancel(self, evt=None):
self.destroy()
class UI(tk.Toplevel):
def __init__(self, parent, *args, **kwargs):
super().__init__(name='result')
self.parent = parent
self.engine = kwargs['engine']
self.index = kwargs['index']
self.transient(parent)
self.resizable(0, 0)
self.test = tk.StringVar()
self.batch = tk.StringVar()
self.result = tk.DoubleVar()
self.recived_time = tk.StringVar()
self.enable = tk.BooleanVar()
self.vcmd = self.engine.get_validate_float(self)
self.set_style()
self.init_ui()
self.engine.center_me(self)
def set_style(self):
s = ttk.Style()
s.configure('Data.TLabel', font=('Helvetica', 12, 'bold'))
def init_ui(self):
w = self.engine.get_init_ui(self)
r = 0
c = 1
ttk.Label(w, text="Test:").grid(row=r, sticky=tk.W)
lbl = ttk.Label(w, style='Data.TLabel', textvariable=self.test)
lbl.grid(row=r, column=c, sticky=tk.W, padx=5, pady=5)
r += 1
ttk.Label(w, text="Batch:").grid(row=r, sticky=tk.W)
lbl = ttk.Label(w, style='Data.TLabel', textvariable=self.batch)
lbl.grid(row=r, column=c, sticky=tk.W, padx=5, pady=5)
r += 1
ttk.Label(w, text="Result:").grid(row=r, sticky=tk.W)
self.txtResult = ttk.Entry(w,
width=8,
justify=tk.CENTER,
validate='key',
validatecommand=self.vcmd,
textvariable=self.result)
self.txtResult.grid(row=r, column=1, sticky=tk.W, padx=5, pady=5)
r += 1
ttk.Label(w, text="Recived:").grid(row=r, sticky=tk.N + tk.W)
self.recived_date = Calendarium(self, "")
self.recived_date.get_calendarium(w, r, c)
r += 1
lbl = ttk.Label(w, text="Time:").grid(row=r, sticky=tk.W)
lbl = ttk.Label(w, style='Data.TLabel', textvariable=self.recived_time)
lbl.grid(row=r, column=c, sticky=tk.W, padx=5, pady=5)
r += 1
ttk.Label(w, text="Enable:").grid(row=r, sticky=tk.W)
chk = ttk.Checkbutton(
w,
onvalue=1,
offvalue=0,
variable=self.enable,
)
chk.grid(row=r, column=c, sticky=tk.W)
if self.index is not None:
self.engine.get_save_cancel_delete(self, w)
else:
self.engine.get_save_cancel(self, w)
def on_open(self, selected_test, selected_batch, selected_result=None):
self.selected_batch = selected_batch
self.test.set(selected_test[1])
self.batch.set(self.selected_batch[2])
if self.index is not None:
self.selected_result = selected_result
msg = "Update {0} for {1}".format(self.winfo_name(),
selected_test[1])
self.set_values()
else:
msg = "Insert {0} for {1}".format(self.winfo_name(),
selected_test[1])
self.enable.set(1)
self.result.set('')
self.recived_date.set_today()
self.title(msg)
self.txtResult.focus()
def on_save(self, evt=None):
if self.engine.on_fields_control(self) == False: return
if self.recived_date.get_date(self) == False: return
if messagebox.askyesno(self.engine.title,
self.engine.ask_to_save,
parent=self) == True:
args = self.get_values()
if self.index is not None:
sql = self.engine.get_update_sql('results', 'result_id')
args = (*args, self.selected_result[0])
else:
sql = self.engine.get_insert_sql('results', len(args))
self.engine.write(sql, args)
self.parent.set_results()
if self.index is not None:
if self.parent.winfo_name() == 'data':
self.parent.lstResults.focus(self.index)
self.parent.lstResults.see(self.index)
self.parent.lstResults.selection_set(self.index)
else:
self.parent.lstResults.see(self.index)
self.parent.lstResults.selection_set(self.index)
self.on_cancel()
def on_delete(self, evt=None):
if self.index is not None:
if messagebox.askyesno(self.engine.title,
self.engine.delete,
parent=self) == True:
sql = "DELETE FROM results WHERE result_id =?"
args = (self.selected_result[0], )
self.engine.write(sql, args)
sql = "DELETE FROM rejections WHERE result_id =?"
args = (self.selected_result[0], )
self.engine.write(sql, args)
self.parent.set_results()
self.on_cancel()
else:
messagebox.showinfo(self.engine.title,
self.engine.abort,
parent=self)
def get_values(self, ):
return (self.selected_batch[0], self.result.get(),
self.recived_date.get_timestamp(), self.enable.get())
def set_values(self, ):
try:
self.recived_date.year.set(int(self.selected_result[3].year))
self.recived_date.month.set(int(self.selected_result[3].month))
self.recived_date.day.set(int(self.selected_result[3].day))
t = "{0}:{1}:{0}".format(self.selected_result[3].hour,
self.selected_result[3].minute,
self.selected_result[3].second)
self.recived_time.set(t)
except:
print(sys.exc_info()[0])
print(sys.exc_info()[1])
print(sys.exc_info()[2])
self.result.set(self.selected_result[2])
self.enable.set(self.selected_result[4])
def on_cancel(self, evt=None):
self.destroy()
