simplify html audio tags

- use css to style audio widgets
perf: speed up assignment creation

- use a database view of the sabretooth recording table
to speed up location of participants
bug-fix: assignment creation, productivity report

- finalize and correct the sql query to get the participant it
for a new assignment
- fix assignment modifier in productivity report
- work on assignment report fixing
- the reports dont work correctly but pushing to live / release anyway
Merge remote branch 'origin/qa' into release
bug-fix: missing unique key pair rank value

- creation of classification or alpha_numeric adjudicate
entries requires test_entry_id and rank unique key pair:
rank was not being set
- fixes mantis issue 0000621
bug-fix: default to Open assignment restriction

- fix assignment list restriction to default to Open
assignments ( mantis issue 0000620 )
bug-fix: determine adjudications fix

- adjudications should only be determined when all an
assignment's and its sibling's tests are complete
- assignments should only be completed when all the adjudications
are resolved
bug-fix:  set complete status at test level only

- the complete status of a test should only be determined
when a typist submits an edit to a specific test entry type
- the administrator needs to be able to un defer and keep the
test status as not completed
bug-fix: typo in cohort value

- cohort_id undefined because cohort key value pair typo
on value
bug-fix: bad end_datetime object

- if no date restriction, set end_datetime to now
bug-fix: assignment status report fixes

- associate array of completes by cohort name
was incorrectly initialized
bug-fix: assignment end_datetime not set

- the assignment end_datetime would never be
set for adjudicate cases since the progenitor
entries would always fail to compare
bug-fix: enforce completed and !deferred select

- enforce completed and not deferred in modifier
for test entry selection when identifying assignments
requiring adjudication
implement views for assignment list

- implement views in the db design that count
test_entry deferrals, adjudicates, and completes
- linking to views allows sorting on the number of
deferrals, adjudicates, and completes in the assignment list
- remove unnecessary sabretooth_recording db class since a
view cannot behave like a standard cenozo record
add a message to the patch
remove sql from procedure to avoid mysql issue

- the assignment_toal view can be created whether it exists or not
by running plain sql
- this avoids a mysql issue with permissions when creating a
view that has a SELECT within a procedure using a sql script
bug-fix: fixing adjudication bug

- adjudications are being incorrectly flagged on test_entry records
- confirmation adjudicate data was being incorrectly assigned from
the adjudicate entry instead of a progenitor entry
implementing mispelled dictionary

- adding a mispelled dictionary to tests so that variants
or intrusions (depeding on test context) can be tracked
and presented as mispellings
prevent mispelled words from being entered

- add check of mispelled word if a test has a mispelled word dictionary
- throw an exception notice in applicable edit classes whenever a word is
classified as mispelled
enhance word validations and handle mispellings

- centralize word validation to static function in database\word class
- clean up trailing spaces on line ends
- handle mispelled words