Pipeliner Client

### Problem
Currently, the 'open tickets' count displayed on project cards includes all tickets that are not in a 'Closed' status, including those marked as 'Shipped'. This misrepresents the actual number of tickets that still require work, as 'Shipped' tickets are effectively completed.

### Context
- The dashboard shows a single 'open tickets' count on each project card.
- Clients expect this count to reflect only tickets that are still in progress (e.g., 'Submitted', 'Spec', 'In development', 'QA', 'Ready to ship').
- Tickets in 'Shipped' status should not be included in this count, as they are already live in production.
- The task board itself will continue to display all tickets, but the count badge must align with the new rule.

### Proposed Behaviour
- Update the logic for calculating the 'open tickets' count to exclude tickets with the status 'Shipped'.
- Ensure this change is reflected on project cards and any other relevant areas (e.g., task board list count).
- No changes to the actual tickets or other statuses; only the count calculation is adjusted.

## Acceptance criteria
["- [ ] The 'open tickets' count on project cards excludes tickets with status 'Shipped'.", "- [ ] The count updates dynamically when a ticket's status changes to 'Shipped'.", '- [ ] The task board list count (if present) matches the updated rule.', '- [ ] No changes to the visibility or status of tickets in the task board itself.', '- [ ] The change is verified in the dashboard UI and any relevant reports or notifications.']

## Classification
- feature

## Complexity
- 3/10 — The change primarily involves updating a query or filter logic for counting tickets, with minimal frontend adjustments to display the updated count.