pilot page sorting

phpVMS Legacy Support
1

how can i sort the table so that the pilot with most hours or most flights is on top.i have been trying different stuff but can’t get it to work.

and is there a way to only show the active pilots in the pilots list or an icon that says inactive or active

2

and is there a way to only show the active pilots in the pilots list or an icon that says inactive or active

That would be great. I have been thinking about 2 different pages. 1 for active like we have now, and if they click a link, it will show only inactive. Not sure if that is doable though.

3

You can check the $pilot->active field, or the $pilot->retired. Try print_r($pilot) to see the fields.

How is it sorted now? I don’t remember

4

ok will try it

curently its sorted as new pilots first

5

By hours is best?

6

HI

how can I sorting pilot page ?  ;D

Best Regard

7

I personally would prefer for the pilots to be in descending numerical order so 1st pilot registered is on top. Currently #1 is at the bottom. Not very user friendly.

8

HI

yes, Currently #1 is at the bottom. Not very user friendly. so Where can I change sorting ?

9

in the pilotdata.class change this

ORDER BY p.pilotid DEC";

to

ORDER BY p.pilotid ASC";

hint look at line 85