Example #1
0
/**
 *	Gets a list of all tickets based on urgency criteria given (subject to ticket visibility)
 *
 *	@param int $urgency The urgency of tickets you want to get.
 *  @param int $dept An array of department ids whose tickets you want to examine, defaults to all departments.
 *	@param int $limit The number of tickets to limit to, default 10.
 *	@param string $output_method Set to 'echo' for displaying content, set to 'array' to simply return data.
 *	@return array An array of data, more details under the underlying function {@link ssi_getSDTickets()}
 *	@since 2.0
*/
function ssi_staffTicketsUrgency($urgency, $dept = array(), $limit = 10, $output_method = 'echo')
{
    $query_where = 'hdt.urgency = {int:urgency}';
    $query_where_params = array('urgency' => $urgency);
    $dept_ids = array();
    if (!empty($dept)) {
        // Did they perhaps just put an integer of some sort?
        if (!is_array($dept)) {
            $dept = array(0 => $dept);
        }
        foreach ($dept as $id) {
            $dept_ids[] = (int) $id;
        }
        if (!empty($dept_ids)) {
            $query_where .= ' AND hdt.dept IN ({array_int:dept})';
            $query_where_params['dept'] = $dept_ids;
        }
    }
    return ssi_getSDTickets($query_where, $query_where_params, $limit, 'hdt.id_ticket ASC', $output_method);
}
/**
 *	Gets a list of all tickets based on urgency criteria given (subject to ticket visibility)
 *
 *	@param int $urgency The urgency of tickets you want to get.
 *	@param int $limit The number of tickets to limit to, default 10.
 *	@param string $output_method Set to 'echo' for displaying content, set to 'array' to simply return data.
 *	@return array An array of data, more details under the underlying function {@link ssi_getSDTickets()}
 *	@since 2.0
*/
function ssi_staffTicketsUrgency($urgency, $limit = 10, $output_method = 'echo')
{
    $query_where = 'hdt.urgency = {int:urgency}';
    $query_where_params = array('urgency' => $urgency);
    return ssi_getSDTickets($query_where, $query_where_params, '', 'hdt.id_ticket ASC', $output_method);
}