Web Design Discussion > General Web Design Discussion

using csv order for routes

(1/5) > >>

Jim:
On the tmtest server, I've sprinkled in some "ORDER BY" clauses to order routes displayed by various pages to match the order they appear in the CSV files.  So far, I've hit mapview.php, region.php, and system.php.  Please have a look at these and let me know where else might benefit from this kind of ordering.

Jim:
Note that the recent DB enhancement does not include the order of routes within a connected route, only the order of routes and connected routes within their csv for their systems, so that kind of ordering has not improved.

mapcat:
I'm not seeing the new behavior in http://tmtest.teresco.org/user/region.php?units=miles&u=mapcat&rg=AR.

http://tmtest.teresco.org/user/system.php?units=miles&u=mapcat&sys=usaif&rg=AR returns an error.

http://tmtest.teresco.org/user/mapview.php?units=miles&u=mapcat&rg=AR seems ok.

Would you consider using it for the tables in the HB?

Jim:

--- Quote from: mapcat on June 19, 2018, 11:47:29 pm ---I'm not seeing the new behavior in http://tmtest.teresco.org/user/region.php?units=miles&u=mapcat&rg=AR.

--- End quote ---

What's not ordered as expected?


--- Quote ---http://tmtest.teresco.org/user/system.php?units=miles&u=mapcat&sys=usaif&rg=AR returns an error.

--- End quote ---

Looks like I didn't consider that someone might combine a system and a region..


--- Quote ---Would you consider using it for the tables in the HB?

--- End quote ---

Are routes there not already in csv order?

Jim:

--- Quote from: Jim on June 19, 2018, 10:33:48 pm ---Note that the recent DB enhancement does not include the order of routes within a connected route, only the order of routes and connected routes within their csv for their systems, so that kind of ordering has not improved.

--- End quote ---

This information is now also in the test DB (and will be in the main DB after tonight's site update) so modifications to the web front end that use it can start to be tested soon.

Navigation

[0] Message Index

[#] Next page