$row) { if (intval($row['ticket_status_active']) === 1 && $status_id !== TICKET_STATUS_CLOSED) { $columns[$status_id] = $row + ['tickets' => []]; } } $ordering_sql = intval($config_ticket_ordering) === 1 ? "ticket_order ASC, ticket_id DESC" : "CASE ticket_priority WHEN 'Urgent' THEN 0 WHEN 'High' THEN 1 WHEN 'Medium' THEN 2 WHEN 'Low' THEN 3 ELSE 4 END, ticket_id DESC"; $sql = mysqli_query($mysqli, "SELECT $ticket_select_columns FROM tickets $ticket_joins $ticket_where ORDER BY $ordering_sql"); $board_count = 0; $off_board_count = 0; while ($row = mysqli_fetch_assoc($sql)) { $status_id = intval($row['ticket_status_id']); if (isset($columns[$status_id])) { $columns[$status_id]['tickets'][intval($row['ticket_id'])] = $row; $board_count++; } else { // In a status with no column - one that has since been switched off $off_board_count++; } } $board_ids = []; foreach ($columns as $column) { $board_ids = array_merge($board_ids, array_keys($column['tickets'])); } $last_replies = ticketLastReplies($board_ids); $task_counts = ticketTaskCounts($board_ids); $tickets_tags = tagsForRecords('ticket', $board_ids); ?>
matching ticket in a status that is switched off, so not on the board. See them in the list
$column) { $color = ticketStatusColor($column['ticket_status_color']); $column_about = ticketStatusAbout($column); ?>
> >
$row) { $row_client_id = intval($row['ticket_client_id']); $reference = escapeHtml(ticketReference($row)); $url = escapeHtml(ticketUrl($ticket_id, $row_client_id)); $is_open = ticketIsOpen($row); $move = ticketWhoseMove($row); $sla = ticketSlaState($row); $due = ticketDueState($row); $attention = $is_open ? ticketAttention($sla, $due) : ''; $schedule = $is_open ? $row['ticket_schedule'] : null; $scheduled_today = $schedule && substr($schedule, 0, 10) === date('Y-m-d'); $reply = $last_replies[$ticket_id] ?? null; $mine = intval($row['ticket_assigned_to']) === intval($session_user_id); $flags = trim(ticketDuePill($due) . ' ' . (in_array($sla['key'], ['breached', 'at_risk', 'running'], true) ? ticketSlaPill($sla) : '')); ?>