105 lines
4.3 KiB
Python
105 lines
4.3 KiB
Python
# SPDX-License-Identifier: WTFPL
|
|
|
|
import os
|
|
from gi.repository import GLib, Gtk, Gdk
|
|
|
|
from .view import View
|
|
from yms import gtkutils, combobox, treeview
|
|
from yms.lookup import Dropdown
|
|
from yms.model import equipment
|
|
|
|
class EquipmentView(View):
|
|
|
|
def __init__(self, context):
|
|
super().__init__(context, _("Equipment"), "equipment.ui")
|
|
self.context = context
|
|
|
|
self.equip = equipment.Equipment(context.db) # current record
|
|
self.newrecord = False
|
|
|
|
self.lst_equipment = Gtk.ListStore(int, str, str, str, str, str, str)
|
|
sql = (
|
|
"SELECT e.eid, e.ename, c.compname, e.model, e.serial, "
|
|
"DATE_FORMAT(e.purchdate, '{}'), e.remarks "
|
|
"FROM equipment AS e LEFT OUTER JOIN company AS c ON (e.manufacturer=c.compid) "
|
|
"WHERE e.vid=%s "
|
|
"ORDER BY e.ename"
|
|
).format("%%d.%%m.%%Y") # TODO format from settings via mapping
|
|
self.db.cur.execute(sql, (context.vessel.vid,))
|
|
for row in self.db.cur.fetchall():
|
|
self.lst_equipment.append(row)
|
|
|
|
treeview.add_column(self.tree['equipment'], _('ID'), 0)
|
|
treeview.add_column(self.tree['equipment'], _('Name'), 1)
|
|
treeview.add_column(self.tree['equipment'], _('Manufacturer'), 2)
|
|
treeview.add_column(self.tree['equipment'], _('Model'), 3)
|
|
treeview.add_column(self.tree['equipment'], _('Serial'), 4)
|
|
treeview.add_column(self.tree['equipment'], _('Age'), 5)
|
|
treeview.add_column(self.tree['equipment'], _('Remarks'), 6)
|
|
self.tree['equipment'].set_model(self.lst_equipment)
|
|
|
|
self.dd_category = self.context.lookup.dropdown(Dropdown.EQUIPMENT_CATEGORY)
|
|
#combobox.load_from_dict(self.combo['unit'], self.dd_unit)
|
|
|
|
# buttons on list page
|
|
def on_but_new_clicked(self, widget):
|
|
self.newrecord = True
|
|
self.label['title_editor'].set_text(_("Add new Equipment"))
|
|
self.clear_record()
|
|
self.equip.vid = self.context.vessel.vid
|
|
self.topwidget.set_visible_child(self.box['equip_edit'])
|
|
|
|
def on_but_edit_clicked(self, widget):
|
|
self.label['title_edit'].set_text(_("Edit Equipment"))
|
|
self.topwidget.set_visible_child(self.box['equip_edit'])
|
|
|
|
def on_but_detail_clicked(self, widget):
|
|
eid = treeview.get_value(self.tree['equipment'], 0)
|
|
self.equip.load(eid)
|
|
self.display_record()
|
|
self.topwidget.set_visible_child(self.box['equip_detail'])
|
|
self.button['close'].grab_focus()
|
|
|
|
def on_tvw_equipment_row_activated(self, widget, path, column):
|
|
eid = treeview.get_value(widget, 0)
|
|
self.equip.load(eid)
|
|
self.display_record()
|
|
self.topwidget.set_visible_child(self.box['equip_detail'])
|
|
|
|
# buttons on detail page
|
|
# edit2 uses edit callback
|
|
def on_but_close_clicked(self, widget):
|
|
self.topwidget.set_visible_child(self.box['equipment'])
|
|
|
|
def on_but_delete_clicked(self, widget):
|
|
self.topwidget.set_visible_child(self.box['equipment'])
|
|
|
|
# buttons on edit page
|
|
def on_but_save_clicked(self, widget):
|
|
pass
|
|
|
|
def on_but_cancel_clicked(self, widget):
|
|
self.topwidget.set_visible_child(self.box['equipment'])
|
|
|
|
def display_record(self):
|
|
print(self.equip)
|
|
self.label['name'].set_text(self.equip.ename)
|
|
self.label['shortname'].set_text(self.equip.shortname or '')
|
|
#lookup self.label['manufacturer'].set_text(self.equip.manufacturer)
|
|
self.label['model'].set_text(self.equip.model or '')
|
|
self.label['serial'].set_text(self.equip.serial or '')
|
|
self.label['weight'].set_text(self.format_float(self.equip.weight, 2, suffix='kg'))
|
|
self.label['price'].set_text(self.format_float(self.equip.price, 2, suffix='€'))
|
|
self.label['date_purch'].set_text(self.equip.purchdate or '')
|
|
#lookup self.label['supplier'].set_text(self.equip.supplier)
|
|
self.label['category'].set_text(self.dd_category[self.equip.ecat])
|
|
self.label['flags'].set_text(self.equip.flags or '')
|
|
self.label['remarks'].set_text(self.equip.remarks or '')
|
|
|
|
def edit_record(self):
|
|
self.entry['sname'].set_text(self.storage.sname)
|
|
self.spin['x'].set_value(self.storage.x)
|
|
self.spin['y'].set_value(self.storage.y)
|
|
self.spin['z'].set_value(self.storage.z)
|
|
self.text['remarks'].get_buffer().set_text(self.storage.remarks or '')
|