Пример #1
0
class SearchWindow:
    def __init__(self):
        self.db_conn = DBInteraction()

        self.root = Tk()
        self.root.wm_title("Search Database")
        self.root.geometry("650x400")

        self.search_label = Label(self.root, font="Georgia 14 bold", text="Search:")
        self.search_label.pack()

        self.search_box = Entry(self.root, font="Georgia 14")
        self.search_box['width'] = 20
        self.search_box.pack()

        self.search_btn = Button(self.root, text="Search", command=self.search_db)
        self.search_btn.pack()

        spacer = Label(self.root, text="\n\n", font="Georgia 5")
        spacer.pack()

        id_label = Label(self.root, text="ID", font="Georgia 14 bold")
        id_label.place(x=65, y=80)
        name_label = Label(self.root, text="Name", font="Georgia 14 bold")
        name_label.place(x=220, y=80)
        age_label = Label(self.root, text="Age", font="Georgia 14 bold")
        age_label.place(x=390, y=80)
        gender_label = Label(self.root, text="Gender", font="Georgia 14 bold")
        gender_label.place(x=525, y=80)

        self.references = []
        self.root.mainloop()

        self.db_conn.shutdown()

    def search_db(self):
        # ============== DELETING THE OLD RESULTS ==============
        for widget in self.references:
            widget.pack_forget()

        # ================= GETTING NEW RESULTS ================
        name = str(self.search_box.get())
        db_results = (self.db_conn.search_data(name))

        for i in db_results:
            temp = Label(self.root,
                         text=str(
                            str(i[0]) + "\t\t" + str(i[1]) + "\t"
                            "\t" + str(i[2]) + "\t\t" + str(i[3])
                            ),
                         font="Georgia 12"
                         )
            temp.pack()
            self.references.append(temp)
Пример #2
0
    def __init__(self):
        self.db_conn = DBInteraction()

        self.root = Tk()
        self.root.wm_title("Search Database")
        self.root.geometry("650x400")

        self.search_label = Label(self.root, font="Georgia 14 bold", text="Search:")
        self.search_label.pack()

        self.search_box = Entry(self.root, font="Georgia 14")
        self.search_box['width'] = 20
        self.search_box.pack()

        self.search_btn = Button(self.root, text="Search", command=self.search_db)
        self.search_btn.pack()

        spacer = Label(self.root, text="\n\n", font="Georgia 5")
        spacer.pack()

        id_label = Label(self.root, text="ID", font="Georgia 14 bold")
        id_label.place(x=65, y=80)
        name_label = Label(self.root, text="Name", font="Georgia 14 bold")
        name_label.place(x=220, y=80)
        age_label = Label(self.root, text="Age", font="Georgia 14 bold")
        age_label.place(x=390, y=80)
        gender_label = Label(self.root, text="Gender", font="Georgia 14 bold")
        gender_label.place(x=525, y=80)

        self.references = []
        self.root.mainloop()

        self.db_conn.shutdown()
from tkinter import *
from tkinter import messagebox
from PIL import Image, ImageTk
from dbInteraction import DBInteraction
from searchDB import SearchWindow

db = DBInteraction()
db.create_tables()
f = open('stored_p_id.txt', 'r')
stored_p_id = int(f.read())
current_p_id = -1
img_new = None

# ===================================================================================================
# =================================== MESSAGE BOX FUNCTIONALITIES ===================================
# ===================================================================================================


def clear_all():
    name_box.delete(0.0, END)
    age_box.delete(0.0, END)
    gender_box.delete(0.0, END)
    last_visit_box.delete(0.0, END)
    allergies_box.delete(0.0, END)
    diseases_conditions_box.delete(0.0, END)
    med_history_box.delete(0.0, END)
    add_comments_box.delete(0.0, END)
    patient_box.delete(0, END)


def enable_all():