If APCu is available, then the queue counts can be cached between requests.
They are automatically cleared and recalculated if the status of a ticket
changes or if a queue or saved search is edited. Otherwise, the queue counts
will expire after an hour and be recalculated anyway.

Somehow on large datasets (like >1M tickets), MySQL can get confused on which
index will provide the best performance. Generally, as systems age, they will
have significantly more closed tickets than open ones. Therefore, it should be
safe to assume that scanning the `status_id` index on the ticket table for
`open` tickets would be the fastest way to arrive at the sort-of short list of
tickets which should need to possibly be aged.

The commit fixes queues display and sorting.

* Require keyword search term to be 3 words or less
* Show keyword search option on Advanced Search dialog

This commit makes Primary Queues buckets for sub queues with forced inheritance of
criteria. Primary queues are now hidden unless there are no sub queues
attached. Agents can still get to primary queue by clicking on it.

The commit also adds default sub queues for Closed queue, utilizing DateTime
periods.

Conflicts:
	file.php
	include/class.file.php
	include/class.thread.php

Export: Make Export Fast Again

File Disposition

This commit ensures that we use the correct disposition for downloading files.

Attachment Names Issue

This commit ensures that we will always get the correct attachment name regardless of if the file content is the same. Additionally, it ensures that the file_ids for attachments are compared in the correct order (elseifs)

This commit ensures that we will always get the correct attachment name regardless of if the file content is the same. Additionally, it ensures that the file_ids for attachments are compared in the correct order (elseifs)

Add period to DateTimeField

Form Attachment Issues

- Make sure we keep attachments in the session even if the page refreshes to display an error message
- Reverse the array of files to be id => name instead of name => id
- Make sure we retain the old ticket or task id if we encounter an error while trying to create a ticket or task from a thread entry
- Make sure we have a valid fileId before returning file info
- Make sure we can still add files for Canned Responses (id and name flip issue)
- Make sure we can still add attachments to Internal Notes for Tickets and Tasks

Add support for periods to DateTimeField allowing the search on range of
dates based on set period like 'Today', 'This Quarter' or 'Last Week' etc.

View All Tickets for User

Ticket Sources

This commit ensures that we will always have the correct display of values for the Ticket Source regardless of if the key and value differ.
Ex: if we had a Ticket Source that contained a space in the value, the key would be camelcased

When clicking 'All Tickets' for a User from within a Ticket, make sure we search using the User's email address instead of their Full Name in case we have users with the same name.

Filter Action Validation Fixes

change old wiki urls to new doc urls

Advanced Search Column Conditions

This commit fixes an issue we had where the bolding on the Ticket Number and Subject columns of advanced searches showed the opposite of what they should have. We instead want them to be bold if the Tickets are Unanswered.

- Let validate_actions pass if we are trying to disable/archive a Help Topic so that the filter flag can be set.
- Make sure we do not throw validation errors when deleting a filter action. Just delete it.

Only use field display when fetch value is not string

Retain Help Topics for Emails

If a Help Topic is disabled or archived and it is also selected as the Help Topic for an Email, make sure we do not remove that Help Topic from the Email. Instead, if that email receives a Ticket, we should just assign the ticket to the Default Help Topic. If there is no Default Help Topic, the Ticket will not have a Help Topic at all.

Pass name to Queue Column Annotation annotate routine

Oops: Creating Tickets with Attachments

This addresses a careless copy/paste mistake made with 4496

This commit adds the ability for DatetimeField to specify format string -
this is useful when the field display requires specific format different
from the system defined formats. For example during export.

This commit addresses longstanding memory and speed issues with ticket
export especially when exporting large set of tickets.

The implementation borrows heavily on Custom Columns, which introduced the
idea of using placeholder field to parse the data from query (db) instead of
making models to do the  parsing which led to related models getting fetched
too -- and hence the memory issues.

The commit also addresses caching of choices for selection fields and such
to avoid expensive trips to database for each row!

Conflicts:
	include/class.forms.php
	scp/js/scp.js