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()