EditableTreeview : Add lines when working on the final line

[cls116]

condition

1. The first column of the final line is a combobox.
2. This is a method of implementing a function where an additional line is automatically created when a value is selected in the final line combobox.

I used the on_cell_edited function shown in the example. Additionally, a function called get_max_iid was added to obtain etv's max iid.

    def on_cell_edited(self, event=None):
        col, item = self.etv.get_event_info()
        i = self.get_max_iid()
        if col == 'AcctItem' and int(item) == i:
            self.etv.insert("", "end", iid=i+1, text=i+1, values=(i+2, ""))

    def get_max_iid(self):
        iids = self.etv.get_children()
        max_iid = max(int(iid) for iid in iids)
        return max_iid

Is there a better way?

Below is the full source code.
file : test.ui

<?xml version='1.0' encoding='utf-8'?>
<interface version="1.3">
  <object class="tk.Toplevel" id="toplevel1">
    <property name="geometry">740x310</property>
    <property name="height">200</property>
    <property name="title" translatable="yes">Reg Account Group</property>
    <property name="width">200</property>
    <containerlayout manager="grid">
      <property type="col" id="0" name="weight">1</property>
      <property type="row" id="1" name="weight">1</property>
    </containerlayout>
    <child>
      <object class="ttk.Frame" id="frame1">
        <property name="height">20</property>
        <property name="width">200</property>
        <layout manager="grid">
          <property name="column">0</property>
          <property name="padx">10</property>
          <property name="pady">10</property>
          <property name="row">0</property>
          <property name="sticky">nw</property>
        </layout>
        <containerlayout manager="grid">
          <property name="propagate">false</property>
        </containerlayout>
        <child>
          <object class="ttk.Label" id="Label_AccountGroup" named="True">
            <property name="text" translatable="yes">Account Group</property>
            <layout manager="grid">
              <property name="column">0</property>
              <property name="row">0</property>
              <property name="sticky">nsew</property>
            </layout>
          </object>
        </child>
        <child>
          <object class="ttk.Combobox" id="AccountGroup" named="True">
            <property name="width">13</property>
            <bind sequence="&lt;&lt;ComboboxSelected&gt;&gt;" handler="on_cmbAG_changed" add="" />
            <layout manager="grid">
              <property name="column">1</property>
              <property name="padx">10</property>
              <property name="row">0</property>
              <property name="sticky">nsew</property>
            </layout>
          </object>
        </child>
      </object>
    </child>
    <child>
      <object class="ttk.Frame" id="frame2">
        <property name="height">200</property>
        <property name="width">720</property>
        <layout manager="grid">
          <property name="column">0</property>
          <property name="padx">10</property>
          <property name="pady">10</property>
          <property name="row">1</property>
          <property name="sticky">nsew</property>
        </layout>
        <containerlayout manager="grid">
          <property name="anchor">n</property>
          <property name="propagate">false</property>
          <property type="col" id="0" name="weight">1</property>
          <property type="row" id="0" name="weight">1</property>
        </containerlayout>
        <child>
          <object class="pygubu.builder.widgets.scrollbarhelper" id="scrollbarhelper1">
            <property name="scrolltype">both</property>
            <property name="usemousewheel">false</property>
            <layout manager="grid">
              <property name="column">0</property>
              <property name="row">0</property>
              <property name="sticky">nsew</property>
            </layout>
            <child>
              <object class="pygubu.builder.widgets.editabletreeview" id="etv" named="True">
                <property name="selectmode">extended</property>
                <property name="show">headings</property>
                <bind sequence="&lt;&lt;TreeviewCellEdited&gt;&gt;" handler="on_cell_edited" add="" />
                <bind sequence="&lt;&lt;TreeviewInplaceEdit&gt;&gt;" handler="on_inplace_edit" add="" />
                <layout manager="grid">
                  <property name="column">0</property>
                  <property name="row">0</property>
                  <property name="sticky">nsew</property>
                </layout>
                <child>
                  <object class="ttk.Treeview.Column" id="Line" named="True">
                    <property name="column_anchor">w</property>
                    <property name="heading_anchor">center</property>
                    <property name="minwidth">20</property>
                    <property name="stretch">true</property>
                    <property name="text" translatable="yes">#</property>
                    <property name="tree_column">false</property>
                    <property name="visible">true</property>
                    <property name="width">20</property>
                  </object>
                </child>
                <child>
                  <object class="ttk.Treeview.Column" id="AcctItem" named="True">
                    <property name="column_anchor">w</property>
                    <property name="heading_anchor">center</property>
                    <property name="minwidth">20</property>
                    <property name="stretch">true</property>
                    <property name="text" translatable="yes">Group</property>
                    <property name="tree_column">false</property>
                    <property name="visible">true</property>
                    <property name="width">150</property>
                  </object>
                </child>
                <child>
                  <object class="ttk.Treeview.Column" id="FromAcct" named="True">
                    <property name="column_anchor">w</property>
                    <property name="heading_anchor">center</property>
                    <property name="minwidth">20</property>
                    <property name="stretch">true</property>
                    <property name="text" translatable="yes">From Acct</property>
                    <property name="tree_column">false</property>
                    <property name="visible">true</property>
                    <property name="width">80</property>
                  </object>
                </child>
                <child>
                  <object class="ttk.Treeview.Column" id="FromName" named="True">
                    <property name="column_anchor">w</property>
                    <property name="heading_anchor">center</property>
                    <property name="minwidth">20</property>
                    <property name="stretch">true</property>
                    <property name="text" translatable="yes">From Name</property>
                    <property name="tree_column">false</property>
                    <property name="visible">true</property>
                    <property name="width">120</property>
                  </object>
                </child>
                <child>
                  <object class="ttk.Treeview.Column" id="ToAcct" named="True">
                    <property name="column_anchor">w</property>
                    <property name="heading_anchor">center</property>
                    <property name="minwidth">20</property>
                    <property name="stretch">true</property>
                    <property name="text" translatable="yes">To Acct</property>
                    <property name="tree_column">false</property>
                    <property name="visible">true</property>
                    <property name="width">80</property>
                  </object>
                </child>
                <child>
                  <object class="ttk.Treeview.Column" id="ToName" named="True">
                    <property name="column_anchor">w</property>
                    <property name="heading_anchor">center</property>
                    <property name="minwidth">20</property>
                    <property name="stretch">true</property>
                    <property name="text" translatable="yes">To Name</property>
                    <property name="tree_column">false</property>
                    <property name="visible">true</property>
                    <property name="width">120</property>
                  </object>
                </child>
                <child>
                  <object class="ttk.Treeview.Column" id="Remarks" named="True">
                    <property name="column_anchor">w</property>
                    <property name="heading_anchor">center</property>
                    <property name="minwidth">20</property>
                    <property name="stretch">true</property>
                    <property name="text" translatable="yes">Remarks</property>
                    <property name="tree_column">false</property>
                    <property name="visible">true</property>
                    <property name="width">100</property>
                  </object>
                </child>
              </object>
            </child>
          </object>
        </child>
      </object>
    </child>
    <child>
      <object class="ttk.Frame" id="frame3">
        <property name="height">200</property>
        <property name="width">200</property>
        <layout manager="grid">
          <property name="column">0</property>
          <property name="padx">20</property>
          <property name="pady">10</property>
          <property name="row">2</property>
          <property name="sticky">sw</property>
        </layout>
        <child>
          <object class="ttk.Button" id="btn_Add" named="True">
            <property name="text" translatable="yes">Add</property>
            <layout manager="grid">
              <property name="column">0</property>
              <property name="row">0</property>
            </layout>
          </object>
        </child>
        <child>
          <object class="ttk.Button" id="btn_Cancel" named="True">
            <property name="command" type="command" cbtype="simple">close</property>
            <property name="text" translatable="yes">Cancel</property>
            <layout manager="grid">
              <property name="column">1</property>
              <property name="row">0</property>
            </layout>
          </object>
        </child>
      </object>
    </child>
  </object>
</interface>

file : test.py

#!/usr/bin/python3
import pathlib
from tkinter import Widget
import tkinter.ttk as ttk
import pygubu
from pygubu.widgets.editabletreeview import _EntryEditor, _ComboboxEditor
from test_pop import TestPopApp
PROJECT_PATH = pathlib.Path(__file__).parent / 'screen'
PROJECT_UI = PROJECT_PATH / "test.ui"

# Custom Widget : Inplace Entry Widget Event Binding "Tab" Key
class MyEntryIEditor(_EntryEditor):
    def __init__(self, master, **kw):
        super().__init__(master, **kw)
        # Store treeview instance and init related fields
        self.treeview = master
        self.curr_row_item = None
        self.related_col = None

    def _create_widget(self, master, **kw):
        entry = super()._create_widget(master, **kw)
        entry.bind("<Tab>", self.popup)
        return entry

    def popup(self, event=None):
        pop = TestPopApp()
        pop.popupData()
        pop.mainwindow.wait_window()
        if pop.set_values:
            self._variable.set(pop.set_values[1])
            if self.curr_row_item and self.related_col:
                label = pop.set_values[2]
                self.treeview.set(self.curr_row_item, self.related_col, label)

class GroupEditor(_ComboboxEditor):
    def _create_widget(self, master, **kw):
        kw['state'] = 'readonly'
        return super()._create_widget(master, **kw)
    
    def set_options(self, new_values):
        self.widget.configure(values=new_values)
        # curr_value = self._variable.get()
        # if curr_value not in new_values:
        #     self._variable.set('')

class TestApp:
    def __init__(self, master=None):
        self.builder = builder = pygubu.Builder(on_first_object=self.setup_ttk_styles)
        builder.add_resource_path(PROJECT_PATH)
        builder.add_from_file(PROJECT_UI)
        # Main widget
        self.mainwindow = builder.get_object("toplevel1", master)
        builder.connect_callbacks(self)
        self.init_widget()

    def run(self):
        self.mainwindow.mainloop()

    def setup_ttk_styles(self, widget=None):
        # ttk styles configuration
        self.style = style = ttk.Style()
        optiondb = style.master
        style.configure("MyCustomLabel.TLabel", background="green")
        style.configure("MyCustomFrame.TFrame", background='purple')
        style.configure("SecondStyle.TLabel", background="yellow", foreground="blue")
        style.configure('MyCoolButton.TButton', background='white')
        style.theme_use("default")     # clam, alt, default, classic
        style.configure('tv.Treeview')
    
    def init_widget(self):
        list_AG = ['1 - Cost','2 - Profit & Loss']
        self.dict_item = {
            '1':['1.Raw Matrials','2.Labor Costs','3.Manufacturing Overheads'],
            '2':['1.Sales','2.Cost of sales','3.Selling admin & exp',
                 '4.Non-operating income','5.Non-operating expense']
        }
        # Header
        self.cmbAG = self.builder.get_object('AccountGroup')
        self.cmbAG['state'] = 'readonly'
        self.cmbAG['values'] = list_AG
        # Treeview Grid
        self.etv = self.builder.get_object('etv')
        self.linenum = self.builder.get_object('Line')
        # Create and connect group column editor
        self.group_editor = GroupEditor(self.etv)
        self.acctitem = self.builder.get_object('AcctItem')
        # Create editors only once
        self.fromacc_editor = MyEntryIEditor(self.etv)
        self.fromacct = self.builder.get_object('FromAcct')
        self.fromacc_editor.related_col = 'FromName'
        self.toacc_editor = MyEntryIEditor(self.etv)
        self.toacct = self.builder.get_object('ToAcct')
        self.toacc_editor.related_col = 'ToName'
        # Insert Treeview Blank Line
        for i in range(3):
            self.etv.insert("", "end", iid=i, text=i+1, values=(i+1, ""))
        # Buttom
        self.btn_add = self.builder.get_object('btn_Add')
        self.btn_cancel = self.builder.get_object('btn_Cancel')

        # Event Binding
        self.cmbAG.bind('<<ComboboxSelected>>', self.on_cmbAG_changed)

    #-----------------------------------------------------------------------------------------------------------------
    # Event
    # Connect <<ComboboxSelected>>
    def on_cmbAG_changed(self, event):
        cost_num = self.cmbAG.get()[:1]
        self.group_editor.set_options(self.dict_item[cost_num])

    # Connect <<TreeviewInplaceEdit>>
    def on_inplace_edit(self, event=None):
        if self.btn_add.grid_info():
            col, item = self.etv.get_event_info()
            if col == 'AcctItem':
                self.etv.inplace_editor(col, item, self.group_editor)
            if col == 'FromAcct':
                self.fromacc_editor.curr_row_item = item
                self.etv.inplace_editor(col, item, self.fromacc_editor)
            if col == 'ToAcct':
                self.toacc_editor.curr_row_item = item
                self.etv.inplace_editor(col, item, self.toacc_editor)
            if col == 'Remarks':
                self.etv.inplace_entry(col, item)

    # Connect <<TreeviewCellEdited>>
    def on_cell_edited(self, event=None):
        col, item = self.etv.get_event_info()
        i = self.get_max_iid()
        if col == 'AcctItem' and int(item) == i:
            self.etv.insert("", "end", iid=i+1, text=i+1, values=(i+2, ""))

    def get_max_iid(self):
        iids = self.etv.get_children()
        max_iid = max(int(iid) for iid in iids)
        return max_iid

    def close(self, event=None):
        self.mainwindow.destroy()
    
    #-----------------------------------------------------------------------------------------------------------------
    # Data

#---------------------------------------------------------------------------------------------------------------------
if __name__ == "__main__":
    app = TestApp()
    app.run()

[alejandroautalan]

Hello @cls116.

I used the on_cell_edited function shown in the example. Additionally, a function called get_max_iid was added to obtain etv's max iid.

    def on_cell_edited(self, event=None):
        col, item = self.etv.get_event_info()
        i = self.get_max_iid()
        if col == 'AcctItem' and int(item) == i:
            self.etv.insert("", "end", iid=i+1, text=i+1, values=(i+2, ""))

    def get_max_iid(self):
        iids = self.etv.get_children()
        max_iid = max(int(iid) for iid in iids)
        return max_iid

Is there a better way?

As you are manually setting the item ids, Instead of searching for the max you can use the last child:

# Connect <<TreeviewCellEdited>>
    def on_cell_edited(self, event=None):
        col, item = self.etv.get_event_info()

        # Get the last item
        last_item = int(self.etv.get_children()[-1])

        if col == 'AcctItem' and int(item) == last_item:
            print("Edited last row.")
            self.etv.insert(
                "", "end", iid=last_item+1, text=last_item+1, values=(last_item+2, ""))

#    def get_max_iid(self):
#        iids = self.etv.get_children()
#        max_iid = max(int(iid) for iid in iids)
#        return max_iid

discussion-256.zip

Regards
Alejandro A

[cls116]

thank you so much Alejandro