orm: Correctly label correlated query joins via sub-queries
orm: Fixup formatting of dates in queries
orm: Fixup mangling of parameter values with colons in sub-queries
misc: Fixup incorrect offset calculation in Misc::dbtime()
forms: search: Add ability to describe a field search
search: Fix crash searching by ticket due date
search: Fix wrong results if searching by a date field (unix epoch was not
    converted to MySQL date format)
search: Fix wrong results searching by date == or !=

bug: Fix reports bugs

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

* Fix warning for negative unix timestamps in Misc::db2gmtime
* Fix crash because of parser context passed to getXxx functions
* Fix inability to update email address

deploy: Add concept of a MANIFEST to the deployment process

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

Add attachments support to FreeTextField

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

Credit: Jared

Allow fields without data to do house-cleaning on deletion.

This allows the MANIFEST to be hidden from HTTP requests since the entire
include/ folder is already denied for Apache.

This fixes a strange issue where the first field of a custom form stapled to
a ticket is not populated with data sourced from the API.

Support ability to include attachments to FreeTextField.

As an option, this will allow preventing deployment of files not tracked
with git. It's also about twice as fast as the PHP version.

This allows files which are edited on the fly during deployment to be
tracked so that they are not unnecessarily deployed again in the next
deployment run. It also allows for more creative deployment strategies using
something like `git ls-files -s`

This is required with the connection to Dept::getEmail()->send(...)

Conflicts:
	include/class.format.php

Conflicts:
	css/thread.css

Ensure that for entries having the same create timestamp, the ID sequence
number is used so that entries inserted first are rendered first in the
thread.

html: Balancing is important

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

9ae01bf2 turned off HTML balancing, however,
quoted response removal will create unbalanced HTML. That HTML will be
stored unbalanced and will require extra processing when displayed on the
ticket thread.

This patch adds balancing support using libxml if enabled, which will
balance HTML without corrupting the HTML like htmLawed will with balancing
enabled.

The bug was partly due to switch to ORM.

This is necessary for auto-assigned tickets

This patch adds to the client interface the ability to filter tickets on the
client portal by help topic, as well as a "clear" feature to clear search,
sort, and filter options.