Top pilots

phpVMS Legacy Add-Ons (v2/v5) Simpilot Group Addons
21

Using echo to show that data is not going to work, you need to use the method described in the instructions as you have started to do in the post above.

Have you installed the sql file?

Is there any data in the table?

Does the VA have any flights for the current month?

Thank you soooooooo much

this code worked

<?php
$month = date("m");
$year = date("Y");
$pilot = TopPilotData::top_pilot_hours($month, $year, 5);
foreach ($pilot as $top) {
    $pilot = PilotData::GetPilotData($top->pilot_id);
    echo '<tr>';
    echo '<td>'.$pilot->firstname.' '.$pilot->lastname.' - '.PilotData::GetPilotCode($pilot->code, $pilot->pilotid).'</td>';
    echo '<td>'.$top->hours.'</td>';
    echo '</tr>';
   }
?>
1 Like
22

Not quite sure if it matters but here is what i use…it has some styling you can change. What is different about my code is that it shows the TOP PILOTS by flights and display the amount of flights

Feel free to use it!

<?php 
$month = date("m");
$year = date("Y");
   $topflights = TopPilotData::top_pilot_flights($month, $year, 5);
   echo '<table cellpadding="0px"><tr><td width="100%" valign="top">';
   echo '<table class="datatable" width="100%" style="background-color:#FFF">';
   echo '<tr bgcolor="#e01933">';
   echo '<th><font color="white">Pilot</font></th>';
   echo '<th><font color="white">Flights Flown</font></th>';
   echo '</tr>';

   foreach ($topflights as $top) {
       $pilot = PilotData::GetPilotData($top->pilot_id);
       echo '<tr align="center" valign="middle">';
       echo '<td>'.PilotData::GetPilotCode($pilot->code, $pilot->pilotid).' - '.$pilot->firstname.' '.$pilot->lastname.'</td>';
       echo '<td>'.$top->flights.'</td>';
       echo '</tr>';
   }

   echo '</table>';
   echo '</table>';


?>
<?php {
}
?>
23

Yes thanks alot Vanity

24

Not quite sure if it matters but here is what i use…it has some styling you can change. What is different about my code is that it shows the TOP PILOTS by flights and display the amount of flights

Feel free to use it!

<?php $month = date("m"); $year = date("Y"); $topflights = TopPilotData::top_pilot_flights($month, $year, 5); echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($topflights as $top) { $pilot = PilotData::GetPilotData($top->pilot_id); echo ''; echo ''; echo ''; echo ''; } echo '
PilotFlights Flown
'.PilotData::GetPilotCode($pilot->code, $pilot->pilotid).' - '.$pilot->firstname.' '.$pilot->lastname.''.$top->flights.'
'; echo '
'; ?> <?php { } ?>

How can i get this code to pull only PIREPS that have been accepted?

25

Also, on the regular table, on the All time table it only shows approved flights, but the monthly stats shows all PIREPs including rejected PIREPS. how can i get that to only show approved PIREPs?

26

Also, is there a reason why the All time stats are showing pilots about an hour more than the monthly stats? (This our first month of operation) they should all be the same numbers.

27

Hi Dave,

I am wanting to pull top 5 pilots for the previous month for hours flown, to show on home page. how would I get it, i have tried a few of the codes but it doesnt seem to show and I gt errors

28

I think that this should work accordingly:

<?php
$year = date("Y");
$month = date("m")-1;
if($month == 0) { //If it's january, previous month is december.
		    $month = 12;
		    $year -= 1;
}
$pilot = TopPilotData::top_pilot_hours($month, $year, 5);
echo '<table>';
foreach ($pilot as $top) {
		    $pilot = PilotData::GetPilotData($top->pilot_id);
		    echo '<tr>';
		    echo '<td>'.$pilot->firstname.' '.$pilot->lastname.' - '.PilotData::GetPilotCode($pilot->code, $pilot->pilotid).'</td>';
		    echo '<td>'.$top->hours.'</td>';
		    echo '</tr>';
    }
echo '</table>';
?>
29

Great just what i was looking for and its done the trick . Many thanks for your great support