Contract Filesize sorting and filtering

[timrettop]

Description

For hosts, contract data integrity is important.

In this regard, it'd be useful to sort on the contracts active disk utilization to see what contracts are using the most storage.

It'd also be useful to filter on contracts that have or do not have active data to 'Select All -> Run Integrity Check' (filesize not capacity I believe based on SiaFoundation/core#220)

Version

v2.3.5

What operating system are you running (e.g. Ubuntu 22.04, macOS, Windows 11)?

docker on ubuntu

Anything else?

Maybe this feature would also be useful for renterd? Not sure about walletd.

[timrettop]

For Sorting Contracts on Filesize, as far as I've been able to test, the frontend needs an additional ContractFilterSortField in the hostd-types api.ts as well as an update to SortField type and a new array item in SortOptions in web/apps/hostd/contexts/contracts/types.ts.

However that only adds the Order By option in the View and it DOES NOT order the contracts correctly from my testing.

I believe that would require updating the buildOrderBy function and possibly the buildContractFilter in persist/sqlite/contracts.go for the api/contracts POST call field 'sortField' to work right?

Thats probably the same backend code that would allow to create filters on whether or not the filesize is 0 ?