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

Adds migration patch for role-based access

Introduce the concept of role-based access for agents.

The commit also renames some fields in department table.

Fix misspelled class and add expression support to SqlAggregate

Lint test rulez!

This will be used for greater flexibility in visibility and requirement
settings.

This will disable the ability for a user to close a ticket when they
have not filled out all of the required fields. Explains the problem to
the user trying to close and directs them to the edit page. Added some
functions to the $ticket class to make it easy to determine the missing
required fields.

Allow fields to be configured for view / edit / required for both agents and
end users. Fields can also be disabled now so that the field remains in the
form but is no longer displayed for new entries.

Allow tickets to be created without a subject — use the help topic full name
instead.

This is necessary so we can consolidate various settings and permissions
into one bit mask field.

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.