SSP-2693 - Journal Steps are missing from the Student view
NOJIRA
Revert "NOJIRA"

This reverts commit c4c7941e9ae7919bd4dc511e4a6942597f1796c2.
SSP-2694 Fixed incorrect Paging Total fro PagingWapp
NOJIRA  improved logger level for tracking directory person refresh.
SSP-2697 Filter inactive CLs in custom AP Task dialog
SSP-2695 Grant exec permissions on two MSSQL procs

In theory this shouldn't be necessary, but for consistency
we're setting up exec grants for the operational ssp database
user on all our SQLServer stored procs. Previously two of
our procs had these grants and two didn't. This adds grants
for the latter:

  update_directory_person_from_view_where_school_id
  update_directory_person_from_view_where_person_id
SSP-2688 Fire tr_insert_directory_person_program_status after insert

Previously that trigger was only firing after update, which meant
mv_directory_person wouldn't cache a person's program status
upon initial create, only after a subsequent edit. Now that trigger
fires on both insert and update.
SSP-2702 Fully populate client-side Person singleton after Quick Add

It takes at least two API calls to fully create a server-side Person
as a side-effect of submitting the Quick Add form... one to
create the Person and one to assign a Program Status. Previously,
the response from the Person create was cached client side in the
singleton Person model prior to assigning the Program Status. The
Main tool no longer attempts to reload that Person, so Program
Status (and other fields) would potentially be rendered with stale
(empty) values.

This patch addresses the problem by always reloads the Person from
the server before dismissing the Quick Add dialog in the success path.
SSP-2703 Filter inactive SSG associations in directory search
SSP-2703 Filter inactive SSG associations in non-directory search

Basically the same as the directory search patch for later versions
but for the "legacy" /students/search API.
SSP-2710 Expire persistent prog status before creating new

Transitioning a person's program status requires a SQL update
to expire the old and an insert to create the new. A trigger
fires after each to update mv_directory_person. If the
insert runs first, the trigger will error out b/c the person
has two active program statuses. Hibernate has no idea that
we have a business rule here, and the two program status
records are completely unrelated to each other from Hib's
perspective. So it makes no guarantees about the order of the
insert and update when the next session flush occurs. In
some or all cases we were seeing the insert run first.

This patch forces the session to flush after the update.
SSP-2712 Sync modified persons into directory individually

Previously if a single statement modified multiple person records,
the SQLServer trigger that updated mv_directory_person would bomb
out b/c it included a query that assumed the 'inserted' table only
contained a single record
SSP-2714 Handle bulk early_alert write statements (MSSQL)
SSP-2714 Handle bulk e_a_resp and p_p_status write statements (MSSQL)

Also tweaks the early_alert trigger to update mv_directory_person
for *distinct* person_ids rather than all person_ids.

NB that the behavior of the person_program_status trigger behavior
also changed to no longer filter out soft-deleted persons. Could
see no reason why this trigger needed it - it was the only
SQLServer trigger with that logic. The Postgres version didn't
have the logic.
SSP-2713 Support triggered inserts and updates to directory

Previously only supported updates via triggers.

Conflicts:
	src/main/resources/org/jasig/ssp/database/masterChangeLog.xml
SSP-2704 Replace dbo schema references with property placeholders
SSP-2718 Avoid reading entire result set for directory result cnt
SSP-2716 Inline coach history report handler

Previously the coach history report link handler was in the
Main tool's codebase so, the link had no effect if the tool
wasn't currently focused. The patch simply moves that
handler into the controller for the panel that houses
the link (StudentRecordViewController.js) so the handler is
effectively always available.

Note that this patch for 2.5.x is slightly different than
the 2.6.x patch in that StudentRecordViewController did not
have a reference to the person singleton in 2.5.x so it
needed to be added as part of this patch (it gets it in
2.6.x as part of the Watch Student enhancement).
SSP-2698 Use local copy of urlrewrite.xml DTD

This guards against SSP outages when http://www.tuckey.org is
down or unreachable.