[datatables] Datatables should sort Quantity data numerically

[alistair3149]

Setup

• MW version: 1.39.7
• DB (MySQL etc.): 10.11.7-MariaDB-1:10.11.7+maria~ubu2204
• PHP version: 8.1.28 (fpm-fcgi)
• SMW version: 4.1.3
• SRF version: 4.2.1

Issue

Quantity type properties are sorted alphabetically instead of numerically in datatable, which is unexpected by the users.

Steps to reproduce

1. Set up an inline ask query on a page
2. Set format set as 'datatables'
3. Add any properties with the Quantity type
4. Save the page
5. Click on the property in the table header to sort the column

Expected result:
The datatable should be sorted by that property numerically.

Observed result:
The datatable is sorted by that property alphabetically.

Example page with the issue: https://starcitizen.tools/Gun
The Damage, Range, and Muzzle velocity properties have the Quantity type.

[alistair3149]

The latest commit did not fix the issue for us.
Perhaps any-number have troubles with units and number separators?

[alistair3149]

Hmm in that case, may I suggest inserting a data-order attribute using the raw number output of the SMW property (#-n) into the <td>element? That should resolve all the quantity sorting issue.

[alistair3149]

Just an update, datatables handles the unit correctly, but it cannot sort numbers with separators correctly. It seems that the numerical sorting stop at the first separator.

It appears that the datatable doesn't sort date correctly as well. The dates are being sorted alphabetically instead of sorting by recency.