def __init__(self, report):
self.query = Query()
self.forms = HTMLutils()
self.report = report
self.columns = loadYaml('columns')
self.pages = loadYaml('pages')
if report == 'add':
page = 'edit'
else:
page = report
self.display_names = self.getDisplayNames(page)
def __init__(self):
self.htmlUtils = HTMLutils()
self.series = Series()
self.author = Author()
self.dynamicJS = DynamicJS()
self.columns = loadYaml('columns')
#get form values
form = cgi.FieldStorage(keep_blank_values = 1)
self.form_values = {}
keys =[]
for k in form.keys():
key = str(k)
value = str(form.getvalue(key))
self.form_values[key] = value
self.book_id= 328
self.activity= 'view'
class Report():
def __init__(self, report):
self.query = Query()
self.forms = HTMLutils()
self.author = Author()
self.when = WhenRead()
self.report = report
self.columns = loadYaml('columns')
self.pages = loadYaml('pages')
if report == 'add':
page = 'edit'
else:
page = report
self.display_names = self.getDisplayNames(page)
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 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 buildRecordForm (self, book_id = None):
'''responisble for building the composite form for book records by
gathering all data, calling necessary helper methods, and adding all
sub-forms together. Form has 3 sub-parts:
(1) the book form which holds all data fields with a 1:1 relationship
to a book_id
(2) the edit author from which itself has 2 sub-parts:
(2a) the remove author feature (currently inactive)
(2b) add author section which defaults to hidden
(3) the dates read add/remove (currently inactive)
form is used for adding records and editing records. If a book_id is
recieved current values for that book_id are pulled from the DB and
used to pre-populate form fields (used for edit). Otherwise the form
is built blank, with no default values (used for add).
Returns composite form as an HTML table
'''
#create holder variables
bookData = None
authorData = None
dateData = None
#bring in data if book_id is present
if book_id:
where = 'book.book_id =' + str(book_id)
bookData = self.query.getData('edit', where)
authorData = self.author.getBookAuthor(book_id)
dateData = self.when.getWhenRead(book_id)
#call helper methods to build all sub-parts
bookForm = self.buildBookForm(bookData)
removeAuthor = self.buildEditAuthor(authorData)
dateForm = self.buildEditDate(dateData)
#put tables with many:many relationships together in a sub-table table
subTs = HtmlTable(border=0, cellpadding = 20)
subTs.addRow([removeAuthor])
subTs.addRow([dateForm])
subTables = subTs.getTable()
#put all form tables together
recordForm = HtmlTable(border=0, cellpadding=30)
recordForm. addRow([bookForm, subTables])
return recordForm.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()
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 buildAddAuthor(self):
'''build a table that will be a subtable of the edit author table
it will be the toggleable section for adding authors to the
DB and the book record. Only called by buildEditAuthor. Returns table.
This table will be interacting with the autocomplete js functions.
'''
autocomplete = 'Add Author: ' + \
self.forms.getAutoComplete('author', '',) +\
'</br>(Last Name, First Name)'
first_name =\
self.forms.getHidden('first_name', '')
last_name = \
self.forms.getHidden('last_name', '')
authorForm = autocomplete + '</br>' + first_name + '</br>'+ \
last_name
return authorForm
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 getDisplayNames(self, page):
'''given a page and column attribute
return a dictionary of lists:
ordered_cols: columns in display order
col_attributes: a list of lists featuring the col and its attribute
value
matching_cols: a list of columns having a feature'''
ordered_cols = []
orderedColDisplay = []
#makes list of columns in display order
for col in self.pages[page]:
ordered_cols.append(col)
if 'book_id' in ordered_cols:
ordered_cols.remove('book_id')
for col in ordered_cols:
x = []
#adds info to correct list if col has attribute
for element in self.columns[col]:
if 'display' in element:
x.append(col)
x.append(element['display'])
orderedColDisplay.append(x)
return orderedColDisplay
class Report():
def __init__(self, report):
self.query = Query()
self.forms = HTMLutils()
self.report = report
self.columns = loadYaml('columns')
self.pages = loadYaml('pages')
if report == 'add':
page = 'edit'
else:
page = report
self.display_names = self.getDisplayNames(page)
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 dates
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 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 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()
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 buildAddAuthor(self):
'''build a table that will be a subtable of the edit author table
it will be the hidden toggleable section for adding authors to the
DB and the book record. Only called by buildEditAuthor. Returns table
'''
autocomplete = 'Author Name: ' + \
self.forms.getAutoComplete('author', '',) + \
'(Last Name, First Name)'
first_name = 'First Name: ' + \
self.forms.getTextField ('first_name', '', readonly = True)
last_name = 'Last Name: '+ \
self.forms.getTextField ('last_name', '', readonly = True)
authorForm = autocomplete + '</br>' + first_name + '</br>'+ \
last_name
return authorForm
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 buildAddDate(self):
''' old method. to be incorporated into buildEditDate when ready
to activate the features'''
datepicker = self.forms.getJQueryUI('when_read','', 'datepicker')
addDateTable = HtmlTable(border=1, cellpadding=3)
addDateTable.addRow(['Date', datepicker])
return addDateTable.getTable()
def getDisplayNames(self, page):
'''given a page and column attribute
return a dictionary of lists:
ordered_cols: columns in display order
col_attributes: a list of lists featuring the col and its attribute
value
matching_cols: a list of columns having a feature'''
ordered_cols = []
orderedColDisplay = []
#makes list of columns in display order
for col in self.pages[page]:
ordered_cols.append(col)
if 'book_id' in ordered_cols:
ordered_cols.remove('book_id')
for col in ordered_cols:
x = []
#adds info to correct list if col has attribute
for element in self.columns[col]:
if 'display' in element:
x.append(col)
x.append(element['display'])
orderedColDisplay.append(x)
return orderedColDisplay
class addAuthor():
def __init__(self):
self.htmlUtils = HTMLutils()
self.series = Series()
self.author = Author()
self.dynamicJS = DynamicJS()
self.columns = loadYaml('columns')
#get form values
form = cgi.FieldStorage(keep_blank_values = 1)
self.form_values = {}
keys =[]
for k in form.keys():
key = str(k)
value = str(form.getvalue(key))
self.form_values[key] = value
self.book_id= 328
self.activity= 'view'
def buildPage(self):
page = ''
form_header = \
self.htmlUtils.build_form_header('POST', 'addAuthor.py', 'form')
form_footer = self.htmlUtils.build_form_footer()
html_footer = self.htmlUtils.build_html_footer()
header = self.buildHeader()
form = self.buildForm()
submit = self.buildInput()
page += 'Content-Type: text/html\n'
page += header
page += '<div id = "authorDiv" style = "display: none">'
page += form
page += submit
page += str(self.form_values)
page += form_footer
page += '</div>'
page += '<button id = "authorToggle"> Add Author </button>'
page += html_footer
return page
def buildHeader(self):
authorHandler = self.dynamicJS.autoCAuthor()
toggleAuthor = self.dynamicJS.toggle('#authorToggle', '#authorDiv')
html_header= '''
<html>
<link rel="stylesheet"
href="//code.jquery.com/ui/1.11.1/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>
<script src="//code.jquery.com/ui/1.11.3/jquery-ui.min.js"></script>
<script>
%s
%s
</script>
<h3>Adding Authors</h3>
''' % (authorHandler, toggleAuthor)
return html_header
def buildForm(self):
autocomplete = 'Author Name: ' + \
self.htmlUtils.getAutoComplete('author', '',\
className = 'addAuthor') + '(Last Name, First Name)'
first_name = 'First Name: ' + \
self.htmlUtils.getTextField\
('first_name', '', readonly = True, className = 'addAuthor')
last_name = 'Last Name: '+ \
self.htmlUtils.getTextField\
('last_name', '', readonly = True, className = 'addAuthor')
authorForm = autocomplete + '</br><p>' + first_name + '</p></br>'+ \
last_name
return authorForm
def buildInput(self):
inputValues = ''
hidden_bookID = self.htmlUtils.getHidden('book_id' , self.book_id)
hidden_activity = self.htmlUtils.getHidden\
('activity', 'add')
button = self.htmlUtils.getButton\
('Submit', 'javascript:document.form.submit()')
inputValues = hidden_bookID+ hidden_activity + button
return inputValues
def __init__(self):
self.htmlUtils = HTMLutils()
self.dynamicJS = DynamicJS()
self.detailProcessor = DetailProcessor()
#get form values
form = cgi.FieldStorage(keep_blank_values = 1)
self.form_values = {}
keys =[]
for k in form.keys():
key = str(k)
value = str(form.getvalue(key))
self.form_values[key] = value
self.book_id= self.form_values['book_id']
self.activity= self.form_values['activity']
self.message = ''
#if the incoming activity is submit_new or update
#send form items out to be processed by update processor
if self.activity == 'submit_new' or self.activity == 'update':
self.message, self.book_id =\
self.detailProcessor.processForm(self.form_values)
self.activity = 'view'
#set builder variables for each possible activity page
if self.activity == 'edit':
self.report = Report('edit')
self.table = self.report.buildRecordForm(book_id = self.book_id)
self.header = 'Edit Record'
self.page = 'edit'
self.new_activity = 'update'
self.button_text = 'Submit'
self.show_blank = None
self.cancel_button_text = 'Cancel'
self.cancel_button_address = 'detail.py?book_id=%s&activity=view'\
%self.book_id
elif self.activity == 'view':
self.report = Report('record')
self.table = self.report.buildDetail(self.book_id)
self.header = 'Book Record'
self.page = 'record'
self.new_activity = 'edit'
self.button_text = 'Edit'
self.show_blank = '-'
self.cancel_button_address = 'main.py'
self.cancel_button_text = 'Back to Catalog'
elif self.activity == 'add':
self.report = Report('add')
self.table = self.report.buildRecordForm()
self.header = 'Enter New Record'
self.page = 'edit'
self.new_activity = 'submit_new'
self.button_text = 'Save'
self.show_blank = ''
self.cancel_button_address = 'main.py'
self.cancel_button_text = 'Cancel'
else:
raise Exception ("Unrecognized activity: %s" %self.activity)
class Detail():
def __init__(self):
self.htmlUtils = HTMLutils()
self.dynamicJS = DynamicJS()
self.detailProcessor = DetailProcessor()
#get form values
form = cgi.FieldStorage(keep_blank_values = 1)
self.form_values = {}
keys =[]
for k in form.keys():
key = str(k)
value = str(form.getvalue(key))
self.form_values[key] = value
self.book_id= self.form_values['book_id']
self.activity= self.form_values['activity']
self.message = ''
#if the incoming activity is submit_new or update
#send form items out to be processed by update processor
if self.activity == 'submit_new' or self.activity == 'update':
self.message, self.book_id =\
self.detailProcessor.processForm(self.form_values)
self.activity = 'view'
#set builder variables for each possible activity page
if self.activity == 'edit':
self.report = Report('edit')
self.table = self.report.buildRecordForm(book_id = self.book_id)
self.header = 'Edit Record'
self.page = 'edit'
self.new_activity = 'update'
self.button_text = 'Submit'
self.show_blank = None
self.cancel_button_text = 'Cancel'
self.cancel_button_address = 'detail.py?book_id=%s&activity=view'\
%self.book_id
elif self.activity == 'view':
self.report = Report('record')
self.table = self.report.buildDetail(self.book_id)
self.header = 'Book Record'
self.page = 'record'
self.new_activity = 'edit'
self.button_text = 'Edit'
self.show_blank = '-'
self.cancel_button_address = 'main.py'
self.cancel_button_text = 'Back to Catalog'
elif self.activity == 'add':
self.report = Report('add')
self.table = self.report.buildRecordForm()
self.header = 'Enter New Record'
self.page = 'edit'
self.new_activity = 'submit_new'
self.button_text = 'Save'
self.show_blank = ''
self.cancel_button_address = 'main.py'
self.cancel_button_text = 'Cancel'
else:
raise Exception ("Unrecognized activity: %s" %self.activity)
def buildPage(self):
page = ''
form_header = \
self.htmlUtils.build_form_header('POST', 'detail.py', 'form')
form_footer = self.htmlUtils.build_form_footer()
html_footer = self.htmlUtils.build_html_footer()
header = self.buildHeader()
submit = self.buildInput()
cancel = self.buildCancel()
page += 'Content-Type: text/html\n'
page += header
page += '<br>'
page += self.message
page += form_header
page += self.table
page += '<br>'
page += submit
page += cancel
# page += str(self.form_values)
page += form_footer
page += html_footer
return page
def buildHeader(self):
'''call in dynamic js functions, add them to the header
return header'''
seriesHandler = self.dynamicJS.autoCSeries()
authorHandler = self.dynamicJS.autoCAuthor()
dateHandler = self.dynamicJS.datePicker()
toggleAuthor = self.dynamicJS.toggle('#authorToggle', '#addAuthor')
html_header= '''
<html>
<link rel="stylesheet"
href="//code.jquery.com/ui/1.11.1/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.11.1/jquery-ui.js"></script>
<script>
%s
%s
%s
%s
</script>
<h3>%s</h3>
'''% (seriesHandler, authorHandler, toggleAuthor, dateHandler,\
self.header)
return html_header
def buildInput(self):
'''build submit buttons'''
inputValues = ''
hidden_bookID = self.htmlUtils.getHidden('book_id' , self.book_id)
hidden_activity = self.htmlUtils.getHidden\
('activity', self.new_activity)
button = self.htmlUtils.getButton\
(self.button_text, 'javascript:document.form.submit()')
inputValues = hidden_bookID + hidden_activity + button
return inputValues
def buildCancel(self):
''' build cancel/go back buttons'''
onClick = "location.href='%s'" %self.cancel_button_address
cancel = self.htmlUtils.getButton(self.cancel_button_text, onClick)
return cancel
