COALESCE sort fields when a column has multiple data sources.

issue: Files - deleteOrphans()

- Save Filter Actions at the top of Filter::save
- Validate the Filter Actions before commiting the save

This is done to fix the issue where Depts/HT's said 'Unchanged' when initially saved. Now their configuration is set correctly before doing additional validations for active depts/hts

Conflicts:
	include/class.format.php

Conflicts:
	include/class.thread_actions.php

This addresses the issue where files were being deleted before being sent
out in Agent responses. This was due to a bug in the query that gets the
orphaned files. This query was getting files created within the last 24
hours not after the last 24 hours. The query also had another bug that
would use the time from PHP instead of MySQL which could cause issues.
This updates the query as per @greezybacon's suggestions to delete
orphaned files that were created more than 24 hours ago.

- change recipient name vars to 'Collaborator' in tmpls if ticket user isn't a recipient
- for templates going to Bcc'd Collaborators, account for all name format variables that could be used
- new function getNameFormats returns an array of all name formats in templates for staff.name.* or recipient.name.*
- other minor cc/bcc fixes

This addresses an issue where the New Activity Notice Template was not
keeping the CSS styling for the %{message} variable. This was due to Gmail
adding `<div dir="ltr">` tags around some text in the body causing the CSS
styling to break. This adds RegEx to the formatter so we can remove the
`<div dir="ltr">` tags from the email body before the New Activity Notice
Template is sent preserving the CSS styling.

This fix uses 'filter' instead of 'findFirst' for finding Dept and Team referrals since the __in operator is not included in the evaluate function that was being called when using 'findFirst'

This addresses an issue where the Ticket Preview is broken no matter if it
has a custom field attached or not. This corrects a typo for `$thisstaff`
so the system can get the Agent’s Role to complete the rest of the preview
options.

- function isReopenable needed to check for topic
- getHelpTopics for inline edit needed to include name of disabled Topic if selected
- getHelpTopics for dashboard needed to include disabled/archived Topics

This addresses an issue where unchecking the box for 'Inherit columns from
the parent queue' does not hide the columns from the parent queue. Instead
it pushes them below the new, editable columns. This adds jQuery to toggle
the visibility of the parent columns.

The commit simply uses existing order by routing in Staff class

* Ticket preview crash
* Task view crash

issue: Outlook _MailEndCompose

upgrader: Flush Cache On Upgrade

issue: Org. User Account Status

This addresses an issue where hovering on the Search Tab does not trigger
the counts AJAX call. This adds the AJAX call to the search tab so any
queue tab will trigger the counts AJAX.

This addresses an issue where the Upgrader will sometimes use an outdated
cached object and throw an error. This adds a the function to clear the
Model Cache every time the Upgrader runs an Upgrade Patch to get fresh
objects.

Give initial Admin user extended access to ALL departments loaded on
install. This will help new osTicket users, without the Access Control knowhow, see all tickets regardless of the
department while learning the system.

Commit 3944b51d added ability to archive help topics and departments but
failed to port changes default data (yaml files) loaded on install.

This commits adds the correct bits to flags field for both help topics and
departments. It also removes retired 'isactive' field for help topics.

This commits adds ability for agents to configure public queues.

* Customize Columns
* Set default sort & quick filter
* Add supplemental filters (criteria)

To support above features this commit also addresses confusing Advanced
Search UI to make it intuitive when dealing with a Saved Queue vs. Saved
Search vs. Adhoc Search

This addresses an issue where the User’s account status is always 'Active'
in the Organization list no matter what their actual status is. This adds the
account status to the user query which adds the correct status to the Users’
account.

This addresses an issue where Outlook adds weird (and seemingly random)
_MailEndCompose tags to the email body which turns unwanted content into
links. This adds the _MailEndCompose tag to Format::sanitize() so it
will be removed from the email body.