# SPDX-License-Identifier: WTFPL

import os
from gi.repository import Gtk

from .view import View
from yms import gtkutils, combobox, treeview
from yms.model import provision

class ProvisionsView(View):

    def __init__(self, context):
        super().__init__(context, _("Provisions"), "provisions.ui")
        self.context = context

        self.prov = provision.Provision(context.db) # current record
        self.newrecord = False

        self.load_dropdown()

        self.lst_provisions = Gtk.ListStore(int, str, int, str, str, str)
        sql = (
            "SELECT p.provid, p.provname, p.number, p.unit, p.storedate, p.shelflife "
            "FROM provisions AS p LEFT OUTER JOIN storage AS s USING (sid) "
            "WHERE s.vid=%s OR vid IS NULL"
            )
        self.db.dcur.execute(sql, (context.vessel.vid,))
        for row in self.db.dcur.fetchall():
            data = (
                row['provid'],
                row['provname'],
                row['number'],
                self.prov_unit[row['unit']],
                self.format_date(row['storedate']),
                self.format_date(row['shelflife'])
            )
            self.lst_provisions.append(data)

        treeview.add_column(self.tree['provisions'], _('ID'), 0)
        treeview.add_column(self.tree['provisions'], _('Description'), 1)
        treeview.add_column(self.tree['provisions'], _('Number'), 2)
        treeview.add_column(self.tree['provisions'], _('Unit'), 3)
        treeview.add_column(self.tree['provisions'], _('Stored'), 4)
        treeview.add_column(self.tree['provisions'], _('Best before'), 5)
        self.tree['provisions'].set_model(self.lst_provisions)

    def load_dropdown(self):
        self.db.cur.execute("SELECT ddval, ddtext FROM dropdown WHERE ddid=6 ORDER BY ddval")
        self.prov_unit = dict(self.db.cur.fetchall())

    # buttons on list page
    def on_but_new_clicked(self, widget):
        self.topwidget.set_visible_child(self.box['prov_edit'])

    def on_but_edit_clicked(self, widget):
        self.topwidget.set_visible_child(self.box['prov_edit'])

    def on_but_detail_clicked(self, widget):
        provid = treeview.get_value(self.tree['provisions'], 0)
        self.prov.load(provid)
        self.display_record()
        self.topwidget.set_visible_child(self.box['prov_detail'])
        self.button['close'].grab_focus()

    def on_tvw_provisions_row_activated(self, widget, path, column):
        provid = treeview.get_value(widget, 0)
        self.prov.load(provid)
        self.display_record()
        self.topwidget.set_visible_child(self.box['prov_detail'])
        self.button['close'].grab_focus()

    # buttons on detail page
    # edit2 uses edit callback
    def on_but_close_clicked(self, widget):
        self.topwidget.set_visible_child(self.box['provisions'])

    def on_but_delete_clicked(self, widget):
        self.topwidget.set_visible_child(self.box['provisions'])

    # 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['provisions'])

    def display_record(self):
        print(self.prov)
        self.label['name'].set_text(self.prov.provname)
        self.label['category'].set_text(str(self.prov.provcat))
        self.label['storage'].set_text(str(self.prov.sid))
        self.label['box'].set_text(str(self.prov.boxid))
        self.label['number'].set_text(str(self.prov.number))
        self.label['unit'].set_text(str(self.prov.unit))
        self.label['target'].set_text(str(self.prov.target))
        self.label['weight'].set_text(self.format_float(self.prov.weight, 2, suffix='kg'))
        self.label['weight_net'].set_text(self.format_float(self.prov.weight_net, 2, suffix='kg'))
        self.label['price'].set_text(self.format_float(self.prov.price, 2, suffix='€'))
        self.label['remarks'].set_text(self.prov.remarks or '')

    def edit_record(self):
        pass