This commit changes the Agent export to display (disabled) beside the name of Departments on the export if they are Archived or Disabled. This will help Agents determine if an Agent is not assigned to any active Departments.

Add ticket reopen count as a column annotation

This commit fixes an issue with how we export tickets from a specific User. Since changes were made to how Ticket exports are done, we needed to modify the call to export the Tickets from users.php as well since we were unintentionally sending the file name in where the csv headers should've been (variable added in dumpTickets method).

This commit adds var_dump test along with a few enhancements on the test
script.

Unify ticket visibility as a routine to make sure it's applied uniformly.

Add ability to select fields / columns to export for queues, including adhoc
searches.

Add ability to export agents access in CSV format

Add ability to add sticky export fields for queues.

Add ability to export agents access in CSV format

Add object as a third callback parameters
Add ability to set static value as a key

This is required because using unbuffered MySQL queries means that no other
SQL queries can be run until the export is finished. Since the Staff model
will lazily query the config table, the queries need to be fetched in
advance.

This adds a new concept to the ORM iteration mechanisms and allows iterating
over very large queries without caching the records neither in the result
set nor in the model cache. It also implies using the mysqli_query() method
rather than the prepared statement model, as unbuffered queries with the
prepared statement system are much slower.

This commit attempts to remove all coding standard warnings emitted by PHP
7.0.

Change orgs listing to ORM
Add cdata tables support for users and organizations

Add ability to export tasks

For locales which use comma as the decimal separator, CSV exports should be
generated using a semi-colon (;) rather than a comma (,) since spreadsheet
programs in such locales will have difficulty with comma-delimited CSV
files.

Because CSV has no way of indicating a content character set, writing the
file with a Unicode byte-order mark is useful to declare the content in
UTF-8 encoding.

If the ticket details form has an extra field of type "Priority Level"
(beyond the one built in), exports of tickets will be empty.

This patch addresses the issue in the exporter which uses an older version
of the custom data materialized view (__cdata table), which created separate
columns for selection and ID values. The current cdata system only creates a
single column and stores the ID value. It also addresses an issue where the
ID column was passed to the PriorityField::to_php() as the first argument.

This patch includes a slight database migration, and adjusts the
functionality of a few core components.

  * Move collaborators from the ticket to the thread.
    This concept allows collaborators on any object which has a thread,
    including tasks.

  * Add flags to the thread entry
    This will allow flagging thread entries for different purposes.
    Initially this can be used to flag the original message of a thread in
    case a ticket / thread is created without an initial message.

  * Lock becomes more of a utility
    The lock is now disconnected from the ticket and is a separate utility.
    Separately, the ticket and task objects can have a reference to a lock
    object. Furthermore, when submitting some activities to tickets, the
    lock is verified to be owned by the respective agent, and the lock code
    must match a current lock code. The code is rotated on each acquire()
    call to guard against double submissions.

  * Collaborator is an ORM model
    The TicketUser class is broken up now so that the collaborator instance
    can exist apart from a ticket. Email message ids are now generated for
    collaborators without respect for a ticket so that collaborators can be
    properly supported on any thread.

Detach conversation thread from ticket to make it more generic. Any object
can now have its own thread complete with entry type and attachments.

And allow for @context to add context to the bare string literal. For
instance,

    /* @trans, @context "noun" */ 'Open'

Would mark the string 'Open' translatable with context "noun".

  * Paper sizes
  * More prompts on ticket filters