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.

In-line forms are forms that are rendered as one field. The data of the
inline form is also saved in the data for one field. Currently, the data is
rendered to JSON and stashed in the database.

The data in the field is also accessible via the variable replacement
system, so something line %{ticket.field.subfield} can be handled by the
inline form field.

Also fix syntax error preventing deletes and drop the [manage all phrases]
feature for now.

Also, autodetect the endusers timezone using the jstimezonedetect Javascript
library.

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.

Move the attachments to the sidebar, add the concept of language-specific
attachments. Add a sidebar to the front page. De-emphasize the "open new
ticket" button. Add a knowledge base search feature to front page and also
add the concept of "featured" articles and categories on the front page.

Also complete the translation client-side

This reworks the tabs CSS and javascript coding to be more flexible and to
support vertical tabs. (Bootstrap calls this stacked.) The javascript also
allows the URL to include the hash-tag of the last-clicked tab so that the
tab can be automatically shown when the page is reloaded.

Including language-specific attachments

This will help if the user has "Browser Preference" selected as the
preferred language. When email correspondence needs to be sent to the user,
the browser_lang extra attribute can be used as a backup to to the user's
language preference in the event that the language preference is set to auto
(Browser Preference).