def index(self):
# if session.get('flash', None):
# c.flash = session['flash']
# else:
# c.flash = False
# session.clear()
c.recordset = self.book_q.all()
return render('books.html')
def download(self):
name = request.params.get('name', '')
tables = {'members': Session.query(Members).all(),
'books': Session.query(Books).all(),
'issues': Session.query(Issues).all(),
'overdue': self.report_overdue()}
generate_file = {'members': 'membersreport.html',
'books': 'booksreport.html',
'issues': 'issuesreport.html',
'overdue': 'overduereport.html'}
path = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
c.recordset = tables[name]
template_name = generate_file[name]
res = render(template_name)
temp = StringIO()
pdf_result = pisa.pisaDocument(res, temp)
pdf_path = os.path.join(path, 'public/pdf%s.pdf') % name
temp.seek(0)
filename = '%sreport.pdf' % name
result = {'temp': temp, 'filename': filename}
pdf_data = result['temp'].read()
response.headers['Content-type'] = 'application/pdf'
return pdf_data
def index(self):
return render('reports.html')
def loadEditMember(self):
mem_id = request.params['memberID']
c.recordset = self.member_q.filter_by(memberID=mem_id).first()
return render('editmember.html')
def loadAddMember(self):
session.clear()
return render('addmember.html')
def index(self):
c.recordset = self.member_q.all()
return render('members.html')
def loadEditBook(self):
bk_id = request.params['bkID']
c.recordset = self.book_q.filter_by(bookID=bk_id).first()
return render('editbook.html')
def loadAddBook(self):
session.clear()
return render('addbook.html')
def loadEditIssue(self):
is_id = request.params['issueID']
c.recordset = self.issue_q.filter_by(issueID=is_id).first()
return render('editissue.html')
def loadAddIssue(self):
c.memberRecords = Session.query(Members).all()
c.bookRecords = Session.query(Books).all()
c.recordset = Session.query(Issues).all()
return render('addissue.html')
def index(self):
c.recordset = self.issue_q.all()
return render('issues.html')
