def __init__(self): con = Mysql.Connect() cur = con.cursor() Toplevel.__init__(self) self.geometry("800x800") self.title("Return book") self.resizable(False, False) self.top_frame = Frame(self, height=150, bg='grey') self.top_frame.pack(fill=X) heading = Label(self.top_frame, text='Delete book from Library', font='arial 18 bold', bg='grey') heading.place(x=300, y=60) self.bodyframe = Frame(self, height=650, bg='white') self.bodyframe.pack(fill=X) cur.execute("SELECT * FROM books") books = cur.fetchall() book_list = [] for book in books: book_list.append(str(book[0]) + '-' + book[1]) self.lbl_name = Label(self.bodyframe, text='Enter book name:', font='arial 12 bold', bg='white') self.lbl_name.place(x=40, y=40) self.book_name = StringVar() self.txt_book_combo = ttk.Combobox(self.bodyframe, textvariable=self.book_name) self.txt_book_combo.place(x=200, y=45) self.txt_book_combo['values'] = book_list savebutton = Button(self.bodyframe, text='Delete', command=self.return_book) savebutton.place(x=400 , y=45)
def Select_book(self): u.setUserid(self.txt_member_combo.get().split('-')[0]) con = Mysql.Connect() cur = con.cursor() cur.execute("SELECT * FROM issuedbooks where userid='" + u.getUserid() + "'") books = cur.fetchall() book_list = [] for book in books: book_list.append(str(book[1])) self.lbl_bookname = Label(self.bodyframe, text='elect Book Id: ', font='arial 12 bold', bg='white') self.lbl_bookname.place(x=40, y=80) self.book_name = StringVar() self.txt_book_combo = ttk.Combobox(self.bodyframe, textvariable=self.book_name) self.txt_book_combo.place(x=200, y=80) self.txt_book_combo['values'] = book_list savebutton = Button(self.bodyframe, text='Return', command=self.return_book) savebutton.place(x=400, y=80)
def showmember(self): self.member_management_box = ttk.Treeview(self.tab2, height=30,columns=("uname", "fname", "lname", "email", "contact")) self.mscroll = Scrollbar(self.tab2, orient=VERTICAL) self.member_management_box.grid(row=0, column=0, padx=(10, 0), pady=10, sticky=N) self.mscroll.config(command=self.member_management_box.yview) self.member_management_box.config(yscrollcommand=self.mscroll.set) self.mscroll.grid(row=0, column=0, sticky=N + S + E) self.member_management_box.heading("uname", text="User Name") self.member_management_box.heading("fname", text="First Name") self.member_management_box.heading("lname", text="Last Name") self.member_management_box.heading("email", text="Email") self.member_management_box.heading("contact", text="Contact") self.member_management_box['show'] = 'headings' self.member_management_box.column("uname", width=70) self.member_management_box.column("fname", width=70) self.member_management_box.column("lname", width=70) self.member_management_box.column("email", width=50) self.member_management_box.column("contact", width=70) con = Mysql.Connect() cur = con.cursor() cur.execute("SELECT username,fname,lname,email,contact FROM member") members = cur.fetchall() for member in members: self.member_management_box.insert('', END, values=member) con.commit()
def searchsort(self): """ Sorting all the books on the basis of radio button selected by the user """ con = Mysql.Connect() cur = con.cursor() value = self.list_choice.get() query = '' if value == 1: query = "SELECT * FROM books ORDER BY bookname" elif value == 2: query = "SELECT * FROM books WHERE book_status = 0" else: query = "SELECT * FROM books WHERE book_status = 1" self.management_box.delete(0, END) counter = 0 cur.execute(query) searchquery = cur.fetchall() for book in searchquery: self.management_box.insert(counter, str(book[0]) + '-' + str(book[1])) counter += 1
def setUp(self): self.__connection=Mysql.Connect() self.cur=self.__connection.cursor() self.user=c.users() self.model=m.account() self.user.setBookname("Ma") self.user.setAuthor("Anisul") self.user.setEdition("n/a") self.user.setPublished("n/a") self.user.setPublisher("n/a")
def showsummary(self): con = Mysql.Connect() cur = con.cursor() cur.execute("SELECT COUNT(bookid) FROM books WHERE book_status=0") book_instock_counter = cur.fetchall() self.lbl_book_count.config(text="IN STOCK: " + str(book_instock_counter[0][0])) cur.execute("SELECT COUNT(userid) FROM member") member_counter = cur.fetchall() self.lbl_member_counter.config(text="MEMBERS: " + str(member_counter[0][0])) cur.execute("SELECT COUNT(bookid) FROM books WHERE book_status=1") issued_counter = cur.fetchall() self.lbl_taken_count.config(text="ISSUED: " + str(issued_counter[0][0]))
def search(self): """ For searching book in the Library """ con = Mysql.Connect() cur = con.cursor() value = self.ent_search.get() query ="SELECT * FROM books WHERE bookname LIKE %s" cur.execute(query,("%"+value+"%",)) searchquery = cur.fetchall() self.management_box.delete(0,END) counter = 0 for book in searchquery: self.management_box.insert(counter, str(book[0])+'-'+str(book[1])) counter += 1
def bookinfo(evt): con = Mysql.Connect() cur = con.cursor() self.value = str(self.management_box.get(self.management_box.curselection())) self.id = self.value.split('-')[0] self.list_details.delete(0, 'end') cur.execute("SELECT * FROM books WHERE bookid='" + self.id + "'") book_info = cur.fetchall() self.list_details.insert(0, 'Book Name:' + book_info[0][1]) self.list_details.insert(1, 'Author:' + book_info[0][2]) self.list_details.insert(2, 'Edition:' + book_info[0][3]) if book_info[0][6] == 0: self.list_details.insert(3, 'Status: In Stock') else: self.list_details.insert(3, 'Status: Not in stock')
def __init__(self): con = Mysql.Connect() cur = con.cursor() Toplevel.__init__(self) self.geometry("800x800") self.title("Return book") self.resizable(False, False) self.top_frame = Frame(self, height=150, bg='grey') self.top_frame.pack(fill=X) heading = Label(self.top_frame, text='Return book to Library', font='arial 18 bold', bg='grey') heading.place(x=300, y=60) self.bodyframe = Frame(self, height=650, bg='white') self.bodyframe.pack(fill=X) cur.execute("SELECT * FROM member") members = cur.fetchall() member_list = [] for member in members: member_list.append(str(member[0]) + '-' + member[1]) self.lbl_name = Label(self.bodyframe, text='Enter Member name:', font='arial 12 bold', bg='white') self.lbl_name.place(x=40, y=40) self.member_name = StringVar() self.txt_member_combo = ttk.Combobox(self.bodyframe, textvariable=self.member_name) self.txt_member_combo.place(x=200, y=45) self.txt_member_combo['values'] = member_list savebutton = Button(self.bodyframe, text='Select Book', command=self.Select_book) savebutton.place(x=400, y=45)
from tkinter import * from tkinter import ttk from Model.dbCon import Mysql from View import members as m from View import books as b from View import issuebook as i from View import Return as r from View import delete as d from View import removeMember as rm con = Mysql.Connect() cur = con.cursor() class System(Toplevel): def __init__(self): Toplevel.__init__(self) self.geometry("1300x900") self.title("Library Management System") self.resizable(False,False) #========================================================== self.main_frame = Frame(self) self.main_frame.pack() self.top_frame = Frame(self.main_frame, width=900, height=70, borderwidth=2, relief=SUNKEN, padx=20) self.top_frame.pack(side=TOP, fill=X) self.btn_add_member = Button(self.top_frame, text="Add New Member", font="arial 12 bold", padx=10,command=self.new_member) self.btn_add_member.pack(side=LEFT)
def __init__(self): self.__connection = Mysql.Connect() self.cur = self.__connection.cursor()