This fixes an issue, where the department manager cannot be excluded from
the new ticket alert if the members of the department are checked.
Considering there is a separate selection for the manager, this patch
adjusts the system so the manager of the department only receives the new
ticket alert if the manager checkbox is set. Otherwise, only the members of
the department other than the manager receive the alert.

login: Client SSO Destination

Reviewed-By: Peter Rotich <peter@osticket.com>

Consider the destination clicked prior to SSO authentication.

collars: Add avatars to the popup mgmt dialog

Reviewed-By: Peter Rotich <peter@osticket.com>

Fix for issue 2574 and 2672

Reviewed-By: Peter Rotich <peter@osticket.com>

Issue/2877

Reviewed-By: Peter Rotich <peter@osticket.com>

forms: Fix search by date time fields

Reviewed-By: Peter Rotich <peter@osticket.com>

This changes the storage model for datetime fields and stores them in the
same format as the MySQL `datetime` column type. This allows for the
searching code to be consistent when searching the database for
datetime custom form entry data.

v1.10 rc2 issues

Reviewed-By: Jared Hancock <jared@osticket.com>

Users & Orgs export

Reviewed-By: Jared Hancock <jared@osticket.com>

Change orgs listing to ORM
Add cdata tables support for users and organizations

v1.10 Fixes

Reviewed-By: Jared Hancock <jared@osticket.com>

osTicket supports filtering allowable files on the client-side via JS as
well as server-side on upload.

Ajax based upload skipped server-side validation with the assumption that
the client already validated the file upload. For most cases this is a valid
assumption (ajax only works if JS is enabled) but fails to account for cases
where HTTP requests is intercepted and changed on transit or the request is
posted directly to the ajax interface.

This commit forces server-side file upload validation.

Catch InconsistentModelException on config load to allow for fallback to old
config table when upgrade is pending.

https://github.com/osTicket/osTicket-1.8/issues/2672

This is commit reverts prior commit to prevent email loops by dead-banning
alerts and auto-responses based on recent communication with the end user.

Cast email adddress to string

Require subject and message go send mail filter action

Dept::getMembersForAlerts can return an empty array instead of query-set

And, add to the collabs preview popup too