search

HZ-HBO-ICT / it-conference

Official repository for the IT-Conference
https://weareinittogether.nl
MIT License
5 stars 0 forks source link

Bug: Sponsorship sidemenu option badge not working #426

Open dwaard opened 1 month ago

dwaard commented 1 month ago

Describe the bug the sponsorship sidemenu item does not show the amount of open sponsorships in a badge

To Reproduce Steps to reproduce the behavior:

  1. Log in as event organizer
  2. Open the hub
  3. See error

Expected behavior A number representing the amount of companies where the is_sponsorship_approved attribute is not 1 should appear in the badge

Screenshots image

Desktop (please complete the following information): N/A

Smartphone (please complete the following information): N/A

Additional context Currently, the query used is: \App\Models\Company::where('is_sponsorship_approved', 0)->count(). However, the attribute value can be 1, 0 and <null>. It appears that this attribute is nullable. The query must be updated to cope with this