del_records.py

import PySimpleGUI as sg
from datetime import datetime
import db

def generate_layout(year, query:str = None):
	layout = []
	records = list(filter(lambda x: x.tables not in ([-1,], [-2,],), db.get_records(year, filter_canceled=False, filter_today=False)))
	for index, item in enumerate(records): 
		if (not query) or (item.name.lower().strip().find(query.lower().strip()) != -1):
			layout.append([
				sg.Text(item.name, font=("Arial", 11, "bold")),
				sg.Text(f"{item.start.strftime('%Y/%m/%d %H:%M')} - {item.end.strftime('%H:%M')}", expand_x=True, font=("Arial", 11)),
				sg.Button("Lemondás", button_color=('white', "red"), key=f"-DEL-{index}", font=("Arial", 12)),
			])

	return (records, [
		[
			sg.Text("Foglalás lemondása", font=('Arial', 18), expand_x=True),
			sg.Input(query, key="-QUERY-", enable_events=True, size=(15, None)),
			sg.InputCombo(db.get_years(), year, key="-YEAR-", enable_events=True),
			sg.Button("Keresés", key="-SEARCH-"),
		],[sg.Column(
			layout=layout,
			scrollable=True,
			vertical_scroll_only=True,
			expand_x=True,
			expand_y=True,
			key="-LIST-",
		),]
	])


def create_window(year, query):
	records, layout = generate_layout(year, query)
	window = sg.Window(
		title = 'Foglalás - Lemondás', 
		layout = layout, 
		resizable = True, 
		size = (600, 300))
	window.finalize()
	window.set_min_size((490, 150))
	return (window, records)



def run():    
	query = ""
	year = datetime.now().year
	window, records = create_window(year, query)

	while True:
		event, values = window.read()
		print(event, values)

		match event:
			case "-SEARCH-":
				window.close()
				window, records = create_window(year, query)
			case "-QUERY-": query = values["-QUERY-"]
			case "-YEAR-": year = values["-YEAR-"]
			case sg.WIN_CLOSED | "-EXIT-": break

		if event.startswith("-DEL-"):
			record_id = int(event.split("-")[-1])
			r = records[record_id]
			r.type = "L"
			r.tables = [db.Table(x, -1, "UNK") for x in r.tables]
			db.append_db(r)

			i_records = db.intersect_records(r.start, r.end, filter(lambda x: x.tables == [-1,], db.get_records(r.start.year)))
			if i_records:
				w_record = i_records[0]
				tables = db.reserve_table(w_record.name, w_record.start, w_record.end, w_record.chairs)
				if tables:
					w_record.tables = tables
					db.append_db(w_record)
				
			sg.PopupOK("Foglalás sikeresen törölve", title="Ok", no_titlebar=True, grab_anywhere=True,
			keep_on_top=True, font=("Arial", 14, "bold"))
			window.close()
			window, records = create_window(year, query)


	window.close()

if __name__ == "__main__":
	run()