Will need to update banner extract to include race data so it can be used with slc

Add problem type for "Other -> Immigration"

Clear the list of landlords so we can start fresh for Fall 2016.

Add an interface where a user can create and edit the list of landlords.

Currently, the survey email is only sent when the user clicks the 'return' button while adding issues to a visit.

Change this to send the survey email after an issue is created, but only the first issue of that visit.

Also, trigger a survey email for any follow up visit.

Add:
Electronic signboard (note: this was in the old database, but not included in the current list)
Other Student Development Office

Remove:
Off-Campus Community Relations
Meet and Greet Packet

Change:
Off-Campus Presentation to Presentation

┆Issue is synchronized with this Asana task

Rename the "Family" problem type to "Family / Relationship"

After a visit is saved, send the student who visited an email requesting that he/she complete an online survey.

The text of the email should be stored in a template file (not hard-coded). The actual text will be supplied later.

We need to take a close look at the Appointment Statistics report to make sure that the labels we're using are actually the things we're counting:

• "Total clients" should be the total number of unique client ids with visits during the requested date range.
• Total visits should be the raw number of visit IDs during the requested date range.
• Total first time visits should be the number of non-follow-up visits (during the requested date range)
• New clients should be the number of unique client IDs no seen prior to the requested date range.

On the landlord-tenant report, only show landlords that have an issue. If the landlord hasn't had any issues, then leave them off the list.

Add a checkbox to the visit interface to control whether the follow-up survey email is sent or not. The checkbox should be checked by default.

(Occasionally it's not appropriate or relevant to send the follow-up survey.)

New request to add "Expungement" as a case category.

The datepickers are broken on reports. The UI elements don't display properly and the javascript event handlers don't always update the report when they should.

In the file boost/install.sql, remove the SQL for creating all the landlords. This probably isn't something we want to share with the world. Add a few lines which create "dummy" landlords (e.g. "Acme Realty Co.") instead.

Banner IDs in SLC are hashed before insertion into the database in order to prevent anyone from being able to track an issue back to a particular person. There is a little bit of security through obscurity going on here and it is not a perfect solution, but in this case we believe it is sufficient.

When this was a private project, this hash was simply defined at the top of slc/inc/defines.php, like so:

define('ENCODE_SALT', 'super duper secret');

Although having the salt doesn't make it a lot easier to reverse these hashes, we prefer to keep it secret and changeable.

Please use PHPWS_Settings to create a setting for this, call it "encode_salt", and make sure to use it in the encode() function in inc/functions.php. Also, there will need to be an addition to the settings interface for SLC where this can be set, only by a deity.

┆Issue is synchronized with this Asana task

In the report titled "Problem by Year in School", there is a problem type called "not specified." Based on the number of cases in this category, I'm assuming these are criminal cases. Also, "criminal" doesn't appear anywhere else on the report. Am I correct? And, if so, can this problem type be corrected to read "Criminal"? Thanks!

┆Issue is synchronized with this Asana task

The "Other -> Other" problem type is no longer needed and can be removed.

Add a way (checkboxes?) to track how many international and how many transfer students come in for legal help.

Find a place in the reports (a new report?) to show this info.

┆Issue is synchronized with this Asana task