[], 'deny' => []]; $form_invites = $is_new && userInvitesReady(); $form_invite_mail = $form_invites && userInviteMailReady(); // Every client - and an archived one only when it has a rule, so saving does not drop it. Those with a rule first. $form_clients = []; $sql = mysqli_query($mysqli, "SELECT client_id, client_name, client_abbreviation, client_archived_at FROM clients WHERE client_archived_at IS NULL OR client_id IN (SELECT client_id FROM user_client_permissions WHERE user_id = $form_user_id) ORDER BY client_id IN (SELECT client_id FROM user_client_permissions WHERE user_id = $form_user_id) DESC, client_archived_at IS NOT NULL, client_name ASC"); while ($row = mysqli_fetch_assoc($sql)) { $form_clients[] = $row; } $value = function ($key) use ($form) { return escapeHtml($form[$key] ?? ''); }; ?>
| = escapeHtml($client['client_name']) ?> Archived |
>
>
>
|
| No clients yet. |