bug-fix: missing semi-colons in sql query
bug-fix: default javascript function param

- older versions of FF cannot process default
  js parameter values in the calling window
perf: speed up report generation

- construct better queries using temp tables outside
  of loop structures
bug-fix: add date restriction to query

- the temp table for assignment completes needs to
  included the date restriction
perf: speeding up productivity report

- try pre-building the test type dependent adjudication comparison
  query as an associative array of test id => string where
  the string can be used in sprintf calls with the progenitor and
  adjudicate test entry id's
bug-fix: use create_timestamp

- use the create_timestamp instead of the start_datetime
  as the point at which the assignment is started
bug-fix: perf improv, change count to sum, start

- perf improvement by switching to get_one() calls
- bug fixes: use activity record datetime when first
  assignment created as an operation, change count
  to sum function for in progress assignment count
bug-fix: final bug fixes
add a TODO that will address one more bug
bug-fix: link cohort id to started counts

- link the assignment and participant tables to the
  activity table to find started assignments by cohort
bug-fix: another attempt at created counts

- getting the number of created assignments correctly
  implemented
bug-fix: reworking counts correctly with grouping
Merge remote branch 'origin/release' into qa