New table sorting library

[Jim]

Many tables in TM are sortable by different columns by clicking on the column header.  The table sorting library we have been using for years has had some problems.  I've gone through and replaced all sortable tables with the one at https://github.com/tofsjonas/sortable .

Please try sorting tables on various pages on the staging server, https://tmstage.teresco.org/ , and let me know if you notice any problems.  Functionality should be very similar to what we had before, except it should work more consistently. If things are looking good after a short testing period, I'll install this version on the main site.

[Markkos1992]

Is the functionality there yet?  The tmstage site shows an ongoing update.

[Jim]

Is the functionality there yet?  The tmstage site shows an ongoing update.

Should be.  The ongoing update messaging was a remnant of a previous test of something else, which I've now removed.

[Markkos1992]

The total clinchable in the stats table for a region IMO should not be sortable.  Nothing else noticeable from what I have seen.

I would like to be able to sort the line at the top of the Route Finder, but I presume that may be a loading issue.

[michih]

The user page table content should be right-aligned again.

The total clinchable in the stats table for a region IMO should not be sortable.

Why?

[Markkos1992]

The total clinchable in the stats table for a region IMO should not be sortable.

Why?

Personally, I do not like it getting in the way of usernames especially if I ever want to use the data in a personal spreadsheet.

[michih]

@Jim, have you changed anything in the last three hours? The user page tables are sorted by region and system name now. I'm quite sure that it was by clinched miles (region) and % clinched three hours ago - just as it should be!

[michih]

The total clinchable in the stats table for a region IMO should not be sortable.

Why?

Personally, I do not like it getting in the way of usernames especially if I ever want to use the data in a personal spreadsheet.

You don't need to sort it if you don't want to. I thinkt it's fine that it's possible.

[Jim]

@Jim, have you changed anything in the last three hours? The user page tables are sorted by region and system name now. I'm quite sure that it was by clinched miles (region) and % clinched three hours ago - just as it should be!

I haven't, but I bet I need to specify an initial sorting that differs from the order that comes out of the DB in those cases.

[Jim]

The total clinchable in the stats table for a region IMO should not be sortable.  Nothing else noticeable from what I have seen.

Agreed, that should not move from the top.  I will see what I can do.

I would like to be able to sort the line at the top of the Route Finder, but I presume that may be a loading issue.

If I understand what you mean, I think that shouldn't be too hard.  So you'd like to be able to sort by each of the column headers on findroute.php?  I just have to make sure the filter drop-downs are excluded.

[Markkos1992]

If I understand what you mean, I think that shouldn't be too hard.  So you'd like to be able to sort by each of the column headers on findroute.php?  I just have to make sure the filter drop-downs are excluded.

Basically.

[Jim]

@Jim, have you changed anything in the last three hours? The user page tables are sorted by region and system name now. I'm quite sure that it was by clinched miles (region) and % clinched three hours ago - just as it should be!

I haven't, but I bet I need to specify an initial sorting that differs from the order that comes out of the DB in those cases.

The version on tmstage should now sort as it did before.

Is this the behavior we want?  I am not sure why the by-region table sorts by distance traveled while the by-system sorts by % traveled.

[formulanone]

Sorting by percentages for each region puts the values in order by the first or second digit. This means that 100.00% values appear after the 19-11.x% values, but all 10.xx% values appear after the 100%. Then 1.xx% values appear after 10%, instead of below the 9.99-2.00%, et cetera.

Otherwise, I do like the ability to sort the column headers (for example, finding the longest or shortest routes in a system).

[Jim]

I think I've fixed all the problems mentioned here, and added column sorting functionality on findroute.  Check out the current version on tmstage and let me know if I missed anything.

[Markkos1992]

At the top of the page, the stats page is not showing the color on distance traveled for me for active only now.

I am also getting an "out of memory" error whenever I try to use the route finder.  I want to think it was something on my end, but I am unsure.