def deleteTitle(ACCNO):
libcur.execute(
'SELECT ACCNO FROM circulation Where ACCNO=?;', (ACCNO,))
vTc = libcur.fetchall()
if len(vTc) != 1:
try:
libcur.execute('DELETE FROM library Where ACCNO=?;', (ACCNO,))
libdb.commit()
libcur.execute('SELECT COUNT(*) FROM library;')
tT = libcur.fetchall()[0][0]
eel.queryTitlesTable(2)
eel.fillTitlesHead()
if tT > 0:
libcur.execute('SELECT * FROM library order by ACCNO ASC;')
lLD = libcur.fetchall()
for rows in lLD:
eel.fillTitlesBody(
rows[0], rows[6], rows[1], rows[2], rows[4], rows[(-1)], rows[3], rows[(-3)])
eel.queryTitlesTable(1)
libcur.execute('SELECT COUNT(*) FROM library;')
tT = libcur.fetchall()[0][0]
libcur.execute('SELECT SUM(NOC) FROM library;')
tC = libcur.fetchall()[0][0]
libcur.execute('SELECT COUNT(*) FROM members;')
lM = libcur.fetchall()[0][0]
eel.showLoadingBar()
eel.triggerChangeSuccess(tT, tC, lM)
eel.deleteTitleSuccess()
except:
eel.deleteTitleError(2)
else:
eel.deleteTitleError(1)
def authenticateUser(passkey, login_stat):
if passkey == abtdataP['userPassword']:
libcur.execute('SELECT COUNT(*) FROM library;')
tT = libcur.fetchall()[0][0]
libcur.execute('SELECT SUM(NOC) FROM library;')
tC = libcur.fetchall()[0][0]
libcur.execute('SELECT COUNT(*) FROM members;')
lM = libcur.fetchall()[0][0]
eel.showLoadingBar()
if login_stat == 1:
if tT > 0:
eel.fillTitlesHead()
libcur.execute('SELECT * FROM library Order by ACCNO ASC;')
lLD = libcur.fetchall()
for rows in lLD:
eel.fillTitlesBody(
rows[0], rows[6], rows[1], rows[2], rows[4], rows[(-1)], rows[3], rows[(-3)])
else:
eel.queryTitlesTable(1)
else:
eel.fillTitlesHead()
eel.queryTitlesTable(1)
if lM > 0:
eel.fillMembersHead()
libcur.execute('SELECT * FROM members Order by UID ASC;')
lMD = libcur.fetchall()
for rows in lMD:
eel.fillMembersBody(
rows[0], rows[1], rows[2], rows[4], rows[3])
else:
eel.queryMembersTable(1)
else:
eel.fillMembersHead()
eel.queryMembersTable(1)
libcur.execute('SELECT COUNT(*) FROM circulation;')
lenC = libcur.fetchall()[0][0]
if lenC > 0:
eel.fillReturneesHead()
libcur.execute(
'SELECT * FROM circulation ORDER by UID ASC;')
lCD = libcur.fetchall()
for rows in lCD:
eel.fillReturneesBody(
rows[0], rows[1], rows[2], rows[3], rows[4])
else:
eel.queryReturnsTable(1)
else:
eel.fillReturneesHead()
eel.queryReturnsTable(1)
eel.triggerpasswordSuccess(abtdataP['userName'], abtdataP['instName'],
abtdataP['instCity'], abtdataP['instPIN'], abtdataP['instEmail'], tT, tC, lM)
eel.hideLoadingBar()
else:
eel.triggerpasswordError()
def submitTitle(ACCNO):
try:
libcur.execute(
'SELECT ACCNO FROM circulation Where ACCNO=?;', (ACCNO,))
vTc = libcur.fetchall()
if len(vTc) == 1:
try:
libcur.execute(
"UPDATE library set ISSUED = 'NO' WHERE ACCNO=?;", (ACCNO,))
libcur.execute(
'DELETE FROM circulation Where ACCNO=?;', (ACCNO,))
libdb.commit()
eel.queryReturnsTable(2)
eel.fillReturneesHead()
libcur.execute(
'SELECT * FROM circulation order by UID ASC;')
lCD = libcur.fetchall()
for rows in lCD:
eel.fillReturneesBody(
rows[0], rows[1], rows[2], rows[3], rows[4])
else:
eel.queryReturnsTable(1)
eel.queryTitlesTable(2)
eel.fillTitlesHead()
libcur.execute(
'SELECT * FROM library order by ACCNO ASC;')
lLD = libcur.fetchall()
for rows in lLD:
eel.fillTitlesBody(
rows[0], rows[6], rows[1], rows[2], rows[4], rows[(-1)], rows[3], rows[(-3)])
else:
eel.queryTitlesTable(1)
eel.submitTitleSuccess()
except:
eel.submitTitleError(3)
else:
eel.submitTitleError(2)
except:
eel.submitTitleError(3)
def submitaddTitleData(LACCNO, TITLE, AUTHOR, ISBN, LACCDATE, LTYPE, LNOC):
try:
LTITLE = TITLE.strip()
LAUTHOR = AUTHOR.strip()
LISBN = ISBN.strip()
if len(LAUTHOR) == 0:
LAUTHOR = '-'
if len(LISBN) == 0:
LISBN = '-'
lib_dataL = []
lib_dataT = (
int(LACCNO), LTITLE, LAUTHOR, LACCDATE,
LTYPE, LISBN, 'NO', int(LNOC))
lib_dataL.append(lib_dataT)
libcur.execute(
'INSERT INTO library VALUES(?, ?, ?, ?, ?, ?, ?, ?);', lib_dataT)
libdb.commit()
libcur.execute('SELECT COUNT(*) FROM library;')
tT = libcur.fetchall()[0][0]
libcur.execute('SELECT SUM(NOC) FROM library;')
tC = libcur.fetchall()[0][0]
libcur.execute('SELECT COUNT(*) FROM members;')
lM = libcur.fetchall()[0][0]
eel.queryTitlesTable(2)
eel.fillTitlesHead()
if tT > 0:
libcur.execute('SELECT * FROM library order by ACCNO ASC;')
lLD = libcur.fetchall()
for rows in lLD:
eel.fillTitlesBody(
rows[0], rows[6], rows[1], rows[2], rows[4], rows[(-1)], rows[3], rows[(-3)])
eel.queryTitlesTable(1)
eel.triggeraddTitleDataSuccess(tT, tC, lM)
except:
eel.triggeraddTitleDataError()
def issueTitle(UID, ACCNO):
libcur.execute(
'SELECT ACCNO FROM circulation Where ACCNO=?;', (ACCNO,))
tE = libcur.fetchall()
if len(tE) == 0:
libcur.execute(
'SELECT ACCNO FROM library Where ACCNO=?;', (ACCNO,))
vT = libcur.fetchall()
libcur.execute('SELECT UID FROM members Where UID=?;', (UID,))
vM = libcur.fetchall()
if len(vT) == 1:
if len(vM) == 1:
libcur.execute(
'SELECT UID FROM circulation Where UID=?;', (UID,))
mE = libcur.fetchall()
if len(mE) == 0:
try:
libcur.execute(
'SELECT * FROM library where ACCNO=?', (ACCNO,))
rLD = libcur.fetchall()[0]
libcur.execute(
'SELECT * FROM members where UID=?', (UID,))
rMD = libcur.fetchall()[0]
cir_dataT = (rMD[0], rLD[0],
rLD[1], rMD[1], rMD[2])
libcur.execute(
'INSERT INTO circulation VALUES(?, ?, ?, ?, ?);', cir_dataT)
libcur.execute(
"UPDATE library set ISSUED = 'YES' WHERE ACCNO=?;", (ACCNO,))
libdb.commit()
eel.queryReturnsTable(2)
eel.fillReturneesHead()
libcur.execute(
'SELECT * FROM circulation ORDER by UID ASC;')
lCD = libcur.fetchall()
for rows in lCD:
eel.fillReturneesBody(
rows[0], rows[1], rows[2], rows[3], rows[4])
else:
eel.queryReturnsTable(1)
eel.queryTitlesTable(2)
eel.fillTitlesHead()
libcur.execute(
'SELECT * FROM library order by ACCNO ASC;')
lLD = libcur.fetchall()
for rows in lLD:
eel.fillTitlesBody(
rows[0], rows[6], rows[1], rows[2], rows[4], rows[(-1)], rows[3], rows[(-3)])
else:
eel.queryTitlesTable(1)
eel.issueTitleSuccess()
except:
eel.issueTitleError(6)
else:
eel.issueTitleError(5)
else:
eel.issueTitleError(3)
else:
eel.issueTitleError(2)
else:
eel.issueTitleError(4)