oops: Fix crash upgrading to c7c82835

oops: Fix crash rendering ticket view

oops: Fix crash posting response to ticket

oops: Fix refresh url after ticket reply post

orm: Locate annotations after the root model's fields

orm: Add PK field check for DISTINCT aggregate expressions

When using the DISTINCT option for aggregate expressions, ensure that when a
relationship is used in the aggregate, that a single field of the remote
model's primary key is used — rather than the foreign key, since it would
never have more than one unique value.

search: Re-implement basic ticket search

oops: Couple trivial changes

oops: Fix date formatting for PDF output

oops: Fix staff profile view and update

oops: Fix canned response listing

orm: Fix crash compiling WHERE IN (nested select)

nav: Move settings/email to email/settings

i18n: Make field visibility config translatable

oops: Fix crash adding field to custom form

forms: Fix `required` flag transfer to FormField

oops: Fix bad merge on new ticket by staff

forms: Show uneditable fields on new ticket by staff

oops: Fix bad merge on client ticket view

The commit also renames some fields in department table.

This significantly reduces the time necessary to render the ticket queue
page with the ORM.

And manage it with updates to tickets. This will ease the sorting and
display of tickets based on the time of last update in the ticket queues

This will contain the effective due date of the ticket — either the due date
or the estimated overdue time of the ticket based on the SLA settings. It
will be maintained with ticket updates.

orm: Add greater support for expressions in order_by

Also re-implement the "exclude answered tickets" and "exclude assigned
tickets" from open queue options.

This patch adds support for automatic date and time formatting based on a
selection of locale. The locale can default to the system or user specified
language+locale, or can be elected separately. For instance, English
speakers can pick between US, GB, and many other English speaking locales.

This also removes the need of the %timezone table and uses the timezonedb
built into PHP 5.3+. User's can now select from a much longer list of
database and no longer need to deal with the DST checkbox.

Compare the database `state` field rather than the admin editable status
name.

This is necessary to avoid confusion vs. closed state.

Furthermore, revamp the __cdata system to better support multiple selection
fields. Drop the `.._id` fields and use a coalesce of the ID value of the
entry value or the entry value itself. For JSON backed fields, strip some
JSON characters to result in a comma-separated list.

The search engine now uses MySQL FIND_IN_SET to analyze a search selection
in advanced searches. Also, interaction with the MySQL full text search
backend is fully supported.

Fix search backend to use the new statuses

Reserve 'archived' state for automation

Move ticket status change to unified backend.

Ticket numbers are now configurable as a system-default and by help topic.
Previously, an administrator could select between six-digit random and
sequential numbers. Now, the sequence is selectable so multiple sequences
as needed, and a format can be specified to define how the ticket numbers
look. Formats can also be defined for each help topic.

Names parsed from incoming emails are stored in the database as is. This
pull request addresses potential XSS vulnerability due to improper display
of unsanitized names. Going forward names will be scrubbed on create.

The software defines at least three contexts for the phrase "Open"

  * The name of a ticket queue (Open tickets)
  * A status of a ticket (Open / Closed)
  * An action to be performed (Open a ticket)

References:
(Crowdin login required)
http://i18n.osticket.com/translate/osticket-official/148/enus-de#2915