def getBody(self):
table = HtmlTable(cellspacing=2, cellpadding=2, border=1)
table.addHeader(['Painter', 'Style', 'Born', 'Until'])
table.setRowBGColor(table.rownum, 'lightgreen')
for row in self.getData():
table.addRow(row)
return center(table.getTable())
def buildEditAuthor(self, book_id):
'''build a table that will be a stub table of the main edit table.
it will have all author information and will (eventually) be the place
to remove and add authors from/to book records
accepts a book id, finds all authors asscoiated with
returns a table for those authors'''
author = Author()
bookAuthor = author.getBookAuthor(book_id)
editAuthorTable = HtmlTable(border=1, cellpadding=3)
add ='<button type = "button" id="authorToggle"> Add Author </button>'
addAuthor = '<div id = "addAuthor" style = "display: none">'
addAuthor += self.buildAddAuthor()
addAuthor += '</div>'
editAuthorTable.addHeader(['Author', add])
for author in bookAuthor:
catAuthor = '<nobr>%s %s</nobr>'\
%(author['first_name'], author['last_name'])
remove = 'Remove author %s*' %author['author_id']
editAuthorTable.addRow([catAuthor, remove])
editAuthorTable.addRow(['',\
'*remove author feature not avalible yet'])
return editAuthorTable.getTable(), addAuthor
def buildMain(self, where= None, order_by = None):
'''build table seen on main page using all books. Accepts optional
arguements to filter (search) or sort. Returns table'''
bookData = self.query.getData('main', where, order_by)
# start html table
mainTable = HtmlTable(border=1, cellpadding=3)
# table header, uses display name and enables sorting
table_header = ['#']
for field, name in self.display_names:
sortflag =''
if field == order_by:
sortflag = ' ^'
js = "document.form1.order_by.value='%s';" % field
js += "document.form1.submit();"
h = '<a onclick="javascript:%s">%s%s</a>' % (js, name, sortflag)
table_header.append(h)
mainTable.addHeader(table_header)
# table body- build a numbered row for each record
i = 0
activity = 'view'
for rec in bookData:
i += 1
href = '<a href="detail.py?book_id=%d&activity=%s">%s'\
% (rec['book_id'], activity, rec['title'])
# format date
if rec['date']:
dates = '<br>'.join(['<nobr>%s</nobr>' % d.strip()
for d in rec['date'].split('&')])
else:
dates = '-'
mainTable.addRow(\
[i,
href,
rec['author'] or '' ,
rec['notes' ] ,
dates])
return mainTable.getTable()
def buildEditDate(self, book_id):
'''build table that will be a sub-table of the main edit table to
hold dates and date addtion/subtraction features. Accepts a book id,
find associated dates. Returns table'''
when = WhenRead()
bookDate = when.getWhenRead(book_id)
editDateTable = HtmlTable(border=1, cellpadding=3)
editDateTable.addHeader(['Date', 'Add Addtional Date'])
for bD in bookDate:
remove = 'Forget this date'
editDateTable.addRow([str(bD[0]), remove])
return editDateTable.getTable()
def buildDetail(self, book_id):
'''Static table to view book details'''
where = 'book.book_id =' + str(book_id)
bookData = self.query.getData('record', where)
detailTable = HtmlTable(border=1, cellpadding=3)
detailTable.addHeader(['Field', 'Entry'])
for column, display in self.display_names:
for rec in bookData:
if rec[column]:
data = rec[column]
else:
data = '-'
detailTable.addRow([display, data])
return detailTable.getTable()
def buildEditDate(self, dateData):
'''build table that will be a sub-table of the main edit table to
hold dates and date addtion/subtraction features. Accepts a book id,
find associated dates. Returns table'''
#initilize date table
editDateTable = HtmlTable(border=1, cellpadding=3)
editDateTable.addHeader(['Date(s) Read'])
if dateData:
for d in dateData:
editDateTable.addRow([str(d[0])])
addNew = 'Add Date:'
addNew += self.forms.getJQueryUI('when_read', '', 'datepicker')
editDateTable.addRow([addNew])
return editDateTable.getTable()
def build_report(self):
metadata = Metadata()
display_data = metadata.interrogateMetadata(self.page, 'display')
display_names = display_data['col_attributes']
table = HtmlTable(border=1, cellpadding=3)
table.addHeader(['Field', 'Entry'])
for column, display in display_names:
if self.activity == 'view':
# make a simple table, not a form
for rec in self.recordData:
if rec[column]:
data = rec[column]
else:
data = self.show_blank
table.addRow([display, data])
else:
#use methods to build form
form = self.columns[column][0]['form_type']
# type_method = {'text' :' self.getTextField(column)',
# 'drop_down' : 'self.getDropDown(column)',
# 'radio_static': 'self.getStaticRadio(column)',
# 'autocomplete': 'self.getAutocomplete(column)'
# }
if form == 'text':
form_field =self.getTextField(column)
if form == 'drop_down':
form_field =self.getDropDown(column)
if form == 'radio_static':
form_field =self.getStaticRadio(column)
if form == 'autocomplete':
form_field =self.getAutocomplete(column)
table.addRow([display, form_field])
#push final product
report = table.getTable()
return report
def buildEditAuthor(self, authorData):
'''Accept authorData which may be None
Build author sub-table. if authorData !None include the list of authors
and set the add author section to hidden. Else set add author section
to be visable. Return 2 seperate sections: remove author and add author
'''
#initialize Author form
editAuthorTable = HtmlTable(border=1, cellpadding=3)
#create button that will toggle open the add author section
add ='<button type = "button" id="authorToggle"> Add Author </button>'
#add the header row of the table with the add button
editAuthorTable.addHeader(['Author'])
#section shows list of authors currenlty paired with the book
if authorData:
for author in authorData:
catAuthor = '<nobr>%s %s</nobr>'\
%(author['first_name'], author['last_name'])
editAuthorTable.addRow([catAuthor])
#initialize hidden add author section
# addAuthor = '<div id = "addAuthor" style = "display: none">'
# else:
#initialize visable add author section
# addAuthor = '<div id = "addAuthor" style = "display: default">'
#complete the addAuthor section
addAuthor = '<div id = "addAuthor" style = "display: default">'
addAuthor += self.buildAddAuthor()
addAuthor += '</div>'
editAuthorTable.addRow([addAuthor])
return editAuthorTable.getTable()
def buildBookForm(self, bookData):
'''Accepts bookData, which may be blank.
Builds book form. If bookData !None pre-populates form with default
values from bookData.
returns book form HTML table
'''
#initialze book from table
bookForm = HtmlTable(border=1, cellpadding=3)
bookForm.addHeader(['Field', 'Entry'])
#loop through display names (the ordered list of column names)
#for each: determine the default value and form type
for column, display in self.display_names:
form_type = self.columns[column][0]['form_type']
if self.report == 'edit' and bookData !=None:
default = bookData[0][column]
else:
default = None
#buld a form field of the correct type
if form_type == 'text':
if default == None:
default = ''
form_field = self.forms.getTextField(column, default)
elif form_type == 'drop_down':
#pull in the values from the home table to make a
#list of options
options = self.query.getColumnValues(column)
form_field = self.forms.getDropDown(column, default, options)
elif form_type == 'radio_static':
if default == None and column == 'published':
default = 1
#pull in status radio options from metadata
options = self.columns[column][0]['radio_options']
form_field =self.forms.getStaticRadio(column, default, options)
elif form_type == 'datepicker':
if default == None:
default = ''
form_field = self.forms.getJQueryUI(column, default, form_type)
elif form_type == 'autocomplete':
if default == None:
default = ''
form_field =self.forms.getAutoComplete(column, default)
else:
#debug feature that will make a cell in the table declare
#what form type it thinks it should be if the form type is not
#found above
form_field = form_type
#add the display name and form field as a new row in the book form
bookForm.addRow([display, form_field])
return bookForm.getTable()
order_by= form.getvalue('order_by', '')
# build report body:
books = Books()
results = books.retrieveCoreData(term, order_by)
# build html table
table = HtmlTable(border=1, cellpadding=3)
# table header
header = ['#',
'<a href= "main2.py?order_by=title">Title</a>',
'<a href= "main2.py?order_by=author">Author</a>',
'<a href= "main2.py?order_by=notes">Notes</a>',
'<a href= "main2.py?order_by=when_read">Date</a>']
table.addHeader(header)
# table body
i = 0
for (book_id, title, author, notes, when_read) in results:
i += 1
href = '<a href="detail.py?book_id=%d">%s' % (book_id, title)
date = '<nobr>%s</nobr>' % date2str(when_read)
table.addRow([i, href, author, notes, date])
# Output HTML
print 'Content-Type: text/html\n'
print "<html>"
print """
<head>
'''%header
#build debug_section
debug_section = 'Book ID = %s' % (book_id)
if title:
debug_section = debug_section + ' Title = %s' %title
#build form_header
form_header = '''
<form method = "POST" action = "detail.py" name = "form">
'''
#bulid report
table = HtmlTable(border=1, cellpadding=3)
table.addHeader(['Field', 'Value'])
if activity == 'edit':
for key, value in results.data.items():
form_field='''
<input type = 'text' name = '%s' value = '%s' size = '100'>
''' % (key, value)
table.addRow([key, form_field])
else:
print results
#report = table.getTable()
#buld input_section
)
# build debug_section
debug_section = "Activity = %s Book ID = %s" % (activity, book_id)
if title:
debug_section = debug_section + " Title = %s" % title
# build form_header
form_header = """
<form method = "POST" action = "detail.py" name = "form">
"""
# bulid report
table = HtmlTable(border=1, cellpadding=3)
table.addHeader(["Field", "Value"])
if activity == "edit":
for key, value in book.data.items():
form_field = """
<input type = 'text' name = '%s' value = '%s' size = '100'>
""" % (
key,
value,
)
table.addRow([key, form_field])
else:
for key, value in book.data.items():
string_value = "%s" % value
table.addRow([key, string_value])
def buildBookForm(self, book_id= None):
'''dynamic composite table. made of three parts:
the book form which has all form elements for all elements related to
the book except the date, and author which a book has a many:many
relationship with.
Date is a sperate form (INACTIVE currently)
Author has two parts: the edit author table holds all author
information, eventually removing authors will be enabled. It has a
sub table of add author.
Accepts a book id, finds relevant data, calls helper methods.
Returns composite table of all above sub-parts.
'''
if self.report == 'edit' and book_id != None:
where = 'book.book_id =' + str(book_id)
bookData = self.query.getData('edit', where)
bookTable = HtmlTable(border=1, cellpadding=3)
bookTable.addHeader(['Field', 'Entry'])
for column, display in self.display_names:
form_type = self.columns[column][0]['form_type']
if self.report == 'edit':
default = bookData[0][column]
else:
default = None
if column == 'author' or column == 'when_read':
pass
else:
#use general methods to build forms
if form_type == 'text':
if default == None:
default = ''
form_field = self.forms.getTextField(column, default)
elif form_type == 'drop_down':
#pull in the values from the home table to make a
#list of options
options = self.query.getColumnValues(column)
form_field = \
self.forms.getDropDown(column, default, options)
elif form_type == 'radio_static':
if default == None and column == 'published':
default = 1
options = self.columns[column][0]['radio_options']
form_field =\
self.forms.getStaticRadio(column, default, options)
elif form_type == 'datepicker':
if default == None:
default = ''
form_field =\
self.forms.getJQueryUI(column, default, form_type)
elif form_type == 'autocomplete':
if default == None:
default = ''
form_field =\
self.forms.getAutoComplete(column, default)
else:
form_field = form_type
bookTable.addRow([display, form_field])
bookT = bookTable.getTable()
if self.report == 'edit':
authorT, authorF= self.buildEditAuthor(book_id)
dateT = self.buildEditDate(book_id)
else:
authorT = self.buildAddAuthor()
dateT = self.buildAddDate()
subTables = HtmlTable(border=0, cellpadding = 20)
subTables.addRow([authorT])
subTables.addRow([authorF])
subTables.addRow([dateT])
subT = subTables.getTable()
editModules = HtmlTable(border=0, cellpadding=30)
editModules.addRow([bookT, subT])
return editModules.getTable()
table = HtmlTable(border=1, cellpadding=3)
# table header
header = ['#']
for field, name in [['title' , 'Title'],
['author' , 'Author'],
['notes' , 'Notes'],
['when_read', 'Date']]:
sortflag =''
if field == order_by:
sortflag = ' ^'
js = "document.form1.order_by.value='%s';" % field
js += "document.form1.submit();"
h = '<a onclick="javascript:%s">%s%s</a>' % (js, name, sortflag)
header.append(h)
table.addHeader(header)
# table body
i = 0
activity = 'view'
for (book_id, title, author, notes, date) in results:
i += 1
href = '<a href="detail.py?book_id=%d&activity=%s">%s' % (book_id, activity, title)
# date = '<nobr>%s</nobr>' % date2str(when_read)
table.addRow([i, href, author, notes, date])
print table.getTable()
### FOOTER
print "</body>"
else:
header = 'Book Record'
html_header= '''
<html>
<h3>%s</h3>
'''%header
#build form_header
form_header = '''
<form method = "POST" action = "detail.py" name = "form">
'''
#bulid report using metadata. Vary on activity
table = HtmlTable(border=1, cellpadding=3)
table.addHeader(['Field', 'Entry'])
loadyaml = LoadYaml()
columns = loadyaml.loadYaml('columns')
pages = loadyaml.loadYaml('pages')
query = Query()
where = 'book.book_id =' + book_id
if activity == 'view':
page = 'record'
if activity == 'edit':
page = 'edit'
results = query.getData(page, where)
