Settings > Invoice says and priced at the rate its client's * contract sets, else the default rate - the same hours and rate Unbilled Time and a ticket's Invoice window fill * in - so the value here is what invoicing them would come to. Per client, * then every ticket, the longest waiting first. */ require_once "includes/inc_report.php"; reportEnforce('tickets_unbilled'); $client_id = reportClientId(); // The same tickets, hours and rates Unbilled Time bills - functions/billing.php $time_rules = billingTimeRules(); $tickets = []; foreach (billingUnbilledTickets($client_id) as $row) { $row['billable_hours'] = $row['hours']; $tickets[] = $row; } usort($tickets, function ($a, $b) { return $b['waiting'] <=> $a['waiting'] ?: intval($a['ticket_number']) <=> intval($b['ticket_number']); }); $clients = []; foreach ($tickets as $ticket) { $id = intval($ticket['ticket_client_id']); $clients[$id] = $clients[$id] ?? ['client_id' => $id, 'client' => $ticket['client_name'], 'abbr' => $ticket['client_abbreviation'], 'rate' => $ticket['rate'], 'default_rate' => $ticket['default_rate'], 'rate_source' => $ticket['rate_source'] ?? '', 'rate_note' => $ticket['rate_note'] ?? '', 'rates' => [], 'tickets' => 0, 'seconds' => 0, 'billable_hours' => 0.0, 'value' => 0.0, 'oldest' => 0, 'no_time' => 0]; $clients[$id]['tickets']++; $clients[$id]['rates'][sprintf('%.2f', $ticket['rate'])] = true; $clients[$id]['seconds'] += $ticket['seconds']; $clients[$id]['billable_hours'] += $ticket['billable_hours']; $clients[$id]['value'] += $ticket['value']; $clients[$id]['oldest'] = max($clients[$id]['oldest'], $ticket['waiting']); $clients[$id]['no_time'] += $ticket['billable_hours'] <= 0 ? 1 : 0; } uasort($clients, function ($a, $b) { return $b['value'] <=> $a['value'] ?: $b['tickets'] <=> $a['tickets']; }); $clients = array_values($clients); $waiting_html = function ($days) { $tone = $days > 30 ? 'danger' : ($days > 7 ? 'warning' : 'secondary'); return '' . ($days <= 0 ? 'Today' : $days . ' day' . ($days === 1 ? '' : 's')) . ''; }; $rate_html = function ($row) { // A client's tickets at more than one rate - a contract's after-hours rate, or work either side of a contract's start if (count($row['rates'] ?? []) > 1) { return 'Varies'; } if ($row['rate'] <= 0) { return 'No rate'; } $source = $row['rate_source'] ?? ''; return reportMoney($row['rate']) . ($row['default_rate'] ? ' default' : (in_array($source, ['contract', 'after_hours', 'default_after_hours'], true) ? ' ' . ($source === 'contract' ? 'contract' : 'after hours') . '' : '')); }; $client_columns = [ 'client' => ['label' => 'Client', 'html' => function ($row) { return reportClientCell($row['client_id'], $row['client'], $row['abbr']); }], 'tickets' => ['label' => 'Tickets', 'type' => 'count', 'html' => function ($row) { return '' . reportCount($row['tickets']) . '' . ($row['no_time'] ? ' (' . $row['no_time'] . ' with no time)' : ''); }], 'seconds' => ['label' => 'Time logged', 'type' => 'hours', 'decimals' => 2], 'billable_hours' => ['label' => 'To bill', 'type' => 'decimal', 'decimals' => 2, 'title' => 'Hours rounded ' . billingTimeRulesText($time_rules) . ', ticket by ticket'], 'rate' => ['label' => 'Rate', 'type' => 'money', 'html' => $rate_html], 'value' => ['label' => 'Value', 'type' => 'money', 'class' => 'fw-semibold'], 'oldest' => ['label' => 'Oldest waiting', 'type' => 'count', 'csv_label' => 'Oldest days waiting', 'html' => function ($row) use ($waiting_html) { return $waiting_html($row['oldest']); }], ]; $ticket_columns = [ 'ticket' => ['label' => 'Ticket', 'csv' => function ($row) { return ticketReference($row) . ' ' . $row['ticket_subject']; }, 'html' => function ($row) { return reportTicketLink($row); }, 'class' => 'itflow-report-text'], 'client_name' => ['label' => 'Client', 'html' => function ($row) { return reportClientCell($row['ticket_client_id'], $row['client_name'], $row['client_abbreviation']); }], 'user_name' => ['label' => 'Agent', 'html' => function ($row) { return reportAgentCell($row['ticket_assigned_to'], $row['user_name'] ?? '', $row['user_avatar'] ?? ''); }], 'resolved' => ['label' => 'Done', 'type' => 'date', 'class' => 'text-nowrap', 'csv' => function ($row) { return substr($row['ticket_resolved_at'] ?: $row['ticket_closed_at'], 0, 10); }, 'html' => function ($row) { return escapeHtml(date('M j, Y', strtotime($row['ticket_resolved_at'] ?: $row['ticket_closed_at']))); }], 'waiting' => ['label' => 'Waiting', 'type' => 'count', 'csv_label' => 'Days waiting', 'html' => function ($row) use ($waiting_html) { return $waiting_html($row['waiting']); }], 'seconds' => ['label' => 'Time logged', 'type' => 'hours', 'decimals' => 2, 'html' => function ($row) { return $row['seconds'] <= 0 ? 'None' : reportHours($row['seconds'], 2); }], 'billable_hours' => ['label' => 'To bill', 'type' => 'decimal', 'decimals' => 2], 'rate' => ['label' => 'Rate', 'type' => 'money', 'html' => $rate_html], 'value' => ['label' => 'Value', 'type' => 'money', 'class' => 'fw-semibold'], ]; foreach ($tickets as &$ticket) { $ticket['resolved'] = $ticket['ticket_resolved_at'] ?: $ticket['ticket_closed_at']; } unset($ticket); $totals = ['tickets' => count($tickets), 'seconds' => array_sum(array_column($tickets, 'seconds')), 'billable_hours' => array_sum(array_column($tickets, 'billable_hours')), 'value' => array_sum(array_column($tickets, 'value'))]; if (reportExporting('tickets')) { reportCsv('Unbilled Tickets', $ticket_columns, $tickets, ['ticket' => 'Total'] + $totals); } if (reportExporting()) { reportCsv('Unbilled Work by Client', $client_columns, $clients, ['client' => 'Total'] + $totals); } require_once "includes/inc_report_layout.php"; $no_time = count(array_filter($tickets, function ($t) { return $t['billable_hours'] <= 0; })); $no_rate = count(array_filter($tickets, function ($t) { return $t['rate'] <= 0; })); $over_30 = array_filter($tickets, function ($t) { return $t['waiting'] > 30; }); ?>
$client_id, 'subtitle' => 'As of ' . date('M j, Y'), 'export' => ['clients' => 'By client', 'tickets' => 'Every ticket'], ]); ?> 'Not invoiced yet', 'value' => reportMoney($totals['value']), 'tone' => $totals['value'] > 0 ? 'warning' : '', 'sub' => 'At each client\'s rate'], ['label' => 'Tickets', 'value' => reportCount(count($tickets)), 'url' => '/agent/unbilled_time.php' . ($client_id ? "?client_id=$client_id" : ''), 'sub' => reportCount(count($clients)) . ' client' . (count($clients) === 1 ? '' : 's') . ''], ['label' => 'Hours to bill', 'value' => number_format($totals['billable_hours'], 2), 'sub' => escapeHtml(reportHours($totals['seconds'], 2)) . ' logged', 'title' => 'Each ticket\'s time rounded ' . billingTimeRulesText($time_rules)], ['label' => 'Waiting over 30 days', 'value' => reportCount(count($over_30)), 'tone' => $over_30 ? 'danger' : 'success', 'sub' => $over_30 ? escapeHtml(reportMoney(array_sum(array_column($over_30, 'value')))) . ' of it' : 'Nothing left that long'], ]) ?>
billable ticket too little time logged to bill, so nothing here - log the time, type the hours in Unbilled Time, or mark not billable there.
ticket for a client with no hourly rate - set one on the client, or a default hourly rate in Admin > Settings.
reportEmpty('You are all caught up - every billable ticket that is done has been invoiced.'), 'totals' => ['client' => 'Total'] + $totals, ]) ?>
300, 'export_table' => 'tickets', 'totals' => ['ticket' => 'Total'] + $totals]) ?>
Billable tickets that are resolved or closed and on no invoice. Bill them in ">Unbilled Time - the hours and rates here are what it fills in.