Improve Handler ListVendors by ordering licenseIDs

[lebe1]

Type of change

• [x] Bug fix (non-breaking change which fixes an issue)
• [ ] New feature (non-breaking change which adds functionality)
• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
• [ ] This change requires a documentation update

Description

IMPORTANT TO KNOW

Since I have no extended demo data to test with I can just assume, that this command does order the licenseIDs alphabetically but not numerical. To order it numerical, we would have to add something like this

SELECT vendor.ID, LicenseID, FirstName, LastName, LastPayout, Balance
FROM Vendor
JOIN account ON account.vendor = vendor.id
ORDER BY
  SUBSTR(LicenseID, 1, 1),  -- Sort by the letter part
  CAST(SUBSTR(LicenseID, 3) AS SIGNED);  -- Sort by the numeric part

This in fact would mean though, we can not apply our ordering list to any other license IDs having more than one character, which would contradict to our generalisition approach... What do you think?

CHANGES

• Solves issue of unordered Vendors list by ordering it by their licenseID
• Solves issues of unordered Payments considering the SQL Query Order of Execution

TODO

• Checked Order by running commands and not receiving errors but should create more test data to see it correctly ordered
  • Therefore, I should manipulate the timestamp to -1 day or -1 hour and don't know yet how to arrange it

Checklist:

• [ ] I have commented my code (or ChatGPT did), particularly in hard-to-understand areas
• [ ] I have made corresponding changes to the documentation
• [ ] My changes generate no new warnings, neither in my IDE nor in my browser
• [ ] I have added tests that prove my fix is effective or that my feature works