forms: oops: Properly validate forms for agents

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

users: Error message setting username to an email

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

forms: If an answer has no saved value, use the field

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

User Directory not sortable by Status

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

pjax: Fix placement of footer

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

oops: Fix bad merge for list properties as sub-fields

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

i18n: Fix several issues with right-to-left layout

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

Fixes https://github.com/osTicket/osTicket-1.8/issues/1277 and https://github.com/osTicket/osTicket-1.8/issues/1373

This patch fixes a small glitch where validation might be bypassed for
fields for agents. Previously there was a glitch where required fields would
have their validation errors ignored.

Since users can already log in via their email address, offer a friendly
error message when agents configure the user name to be an email address.

Footer should not be in #pjax_container, because the footer is not rendered
for non PJAX requests.

When processing the value of a DynamicFormEntryAnswer, if there is no
database-backed, value, then use the value of the associated field.

This patch also makes a slight edit to mPDF to allow better detection of
substitions in characters, as the DejaVu fonts shipped do not support Thai
glyphs.

forms: Add default selection to SelectionField

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

This allows administrators to select a default value for selection fields
deriving from Custom Lists. This has been implemented on the ChoiceField,
but was forgotten on the SelectionField

forms: Add free text field

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

bug: Decode mailbox when parsing an email address

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

This addresses cases where incoming emails doesn't include charset and
mailbox may include non-ascii characters.

  * Use the title of "Information" with internal tag of "info"
  * Add "Visibility" column to UI and retire "Required" and "Internal"
    columns
  * Add visibility selection to new fields and show visibility to the user
    information fields when displayed on the ticket details form
  * Make the visibility settings translatable
  * Use constants internally for visibility configuration detection
  * Use a larger input when managing the information HTML content
  * Fix validation errors for new fields
    * Enforce new field name uniqueness
    * Enforce new field name character validation

oops: Fix hardcoded table prefix

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

orm: Fix MySQL occasional "Commands OOS" error

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

Under certain intermittent circumstances (usually a significant number of
ORM queries), the ORM will trigger a MySQL error:

Commands out of sync; you can't run this command now

Usually this MySQL error is related to buffered versus unbuffered queries.
However, the ORM already uses buffered queries (MySQL calls it
"store_result"). In this case, it appears there is some sort of race between
fetching the result metadata before configuring the statement for buffering.
(By "race" I mean that the error is not reliably triggered).

This patch seems to fix the issue by configuring buffering before fetching
result metadata — necessary to configure the fetching (output) phase of the
statement.