Consumables break if large number of items is checked-out

[swift2512]

Debug mode

• I have enabled debug mode
• I have read checked the Common Issues page

Describe the bug

If more that 8300 pieces of consumable are checked-out, page shows 'No matching records found' for that consumable.
If user has more than 10k pieces of consumables assigned - users part of SnipeIT is bricked - page shows 'No matching records found'.

Reproduction steps

1. Create consumables with large quantity - 44444
2. Check-out 9000 consumables to the user
3. Visit page where list of users, that consumable was checked-out to, is shown.

Expected behavior

That list shows entries, not the message 'No matching records found'. On a side note, that list would should show single line for check-out action with number of items checked-out, instead of entry for every single item.

Screenshots

Snipe-IT Version

latest demo

Operating System

Web Server

PHP Version

Operating System

No response

Browser

No response

Version

No response

Device

No response

Operating System

No response

Browser

No response

Version

No response

Error messages

No response

Additional context

Currently, you can't remove assigned consumables and there's no other way to remove consumables from the user. I understand that 8000+ pieces of consumables may look like overkill, but our company goes through 500 packs of A4 sheets per week and if we would decide to track paper, we would brick the system unintentionally. Also, someone could make a mistake checking-out consumables by putting 9999 as quantity.

[swift2512]

You can also break stuff with accessories in the same way - by checking-out 10k+ items.

And it would be nice to have bulk check-in for accessories- nobody wants to check-in 20 pieces of same accessory individually. Even better way - only one line with total of items is shown and you can input a number of checked in items. (But this may be more difficult because IDs are involved.)

[swift2512]

I broke demo website... You can't have more than 60k items assigned. All accessories are gone from the view. Sorry :)

[snipe]

There is already a PR open for this. #15785 - just not sure it's how we want to handle it, nor the use case where someone would be checking out 10k consumables at a time.

[swift2512]

It's not 10k a a time. It's total quantity that breaks everything.

…

On Wed, 20 Nov 2024, 15:16 snipe, ***@***.***> wrote: There is already a PR open for this. #15785 <#15785> - just not sure it's how we want to handle it, nor the use case where someone would be checking out 10k consumables at a time. — Reply to this email directly, view it on GitHub <#15853 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AA4UZQ3454DJZVMDFKIRVCD2BSDUFAVCNFSM6AAAAABSEC2FKCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOBYGU2TQMZVGM> . You are receiving this because you authored the thread.Message ID: ***@***.***>