def save_title_book(self):
title = self.m_text_member.GetValue()
year = self.m_choice_bookTitle.GetStringSelection()
sql = SQL.sql_book_title(title,year)
cursor.execute(sql)
rows = cursor.fetchall()
Excels.excel_by_title(rows)
def save_book_month(self):
month = self.m_choice_month_book.GetStringSelection()
month = select_month(month)
year = self.m_choice_year_book.GetStringSelection()
sql = SQL.sql_book_month(month, year)
cursor.execute(sql)
rows = cursor.fetchall()
Excels.excel_book_month(rows)
def save_perpus(self):
library = self.m_choice_library.GetStringSelection()
library = select_library(library)
year = self.m_choice_tahun.GetStringSelection()
sql = SQL.sql_perpus(year,library)
cursor.execute(sql)
rows = cursor.fetchall()
Excels.excel_perpus(rows)
def save_fact():
sql = SQL.sql_fact()
cursor.execute(sql)
rows = cursor.fetchall()
Excels.excel_fact(rows)
def save_book_year(self):
year = self.m_choice_allBook.GetStringSelection()
sql = SQL.sql_book_year(year)
cursor.execute(sql)
rows = cursor.fetchall()
Excels.excel_book_year(rows)
def save_member(self):
member = self.m_text_member.GetValue()
sql = SQL.sql_member(member)
cursor.execute(sql)
rows = cursor.fetchall()
Excels.excel_member(rows)