Recent 5 Flights

FiveStar · April 19, 2011

Hi there i need a little code to display pilot name on recent flight board i have used other code from yours to display images here is the code

<h2>Recent Completed Flights Board</h2>
<?php
$count = 5;
$pireps = PIREPData::getRecentReportsByCount($count);
?>

<table id="tabledlist" class="tablesorter">
<thead>
<tr>
<th>Flight Number</th>
<th>Departure</th>
<th>Arrival</th>
<th>Aircraft</th>
<th>Flight Time</th>
<th>Pilot Name</th>
<th>Status</th>

</tr>
</thead>
<tbody>

<?php
foreach($pireps as $pirep)
{
$pilotinfo = PilotData::getPilotData($pirep->pilotid);
   $pilotid = PilotData::getPilotCode($pilotinfo->code, $pilotinfo->pilotid);

?>
<tr>
<td align="center">
	<a href="<?php echo url('/pireps/view/'.$pirep->pirepid);?>"><?php echo $pirep->code . $pirep->flightnum; ?></a>
</td>
<td align="center"><?php echo $pirep->depicao; ?></td>
<td align="center"><?php echo $pirep->arricao; ?></td>
<td align="center"><?php echo $pirep->aircraft . " ($pirep->registration)"; ?></td>
<td align="center"><?php echo $pirep->flighttime; ?></td>
<td align="center"><?php echo $pirep->pilotname; ?></td>
<td align="center">
	<?php

	if($pirep->accepted == PIREP_ACCEPTED){
		echo '<img src="'.SITE_URL.'/lib/skins/'.CURRENT_SKIN.'/images/Accepted.gif"border="0" alt=""/>';
           }
	elseif($pirep->accepted == PIREP_REJECTED)
		echo '<img src="'.SITE_URL.'/lib/skins/'.CURRENT_SKIN.'/images/Rejected.gif"border="0"  alt=""/>';
	elseif($pirep->accepted == PIREP_PENDING)
		echo '<img src="'.SITE_URL.'/lib/skins/'.CURRENT_SKIN.'/images/Pedning.gif"border="0"  alt=""/>';
	elseif($pirep->accepted == PIREP_INPROGRESS)
		echo '<img src="'.SITE_URL.'/lib/skins/'.CURRENT_SKIN.'/images/Inprogress.gif"border="0"  alt=""/>';
	?>
</td>
<?php
// Only show this column if they're logged in, and the pilot viewing is the
//	owner/submitter of the PIREPs
if(Auth::LoggedIn() && Auth::$userinfo->pilotid == $report->pilotid)
{
	?>
<td align="right">
	<a href="<?php echo url('/pireps/addcomment?id='.$report->pirepid);?>">Add Comment</a><br />
	<a href="<?php echo url('/pireps/editpirep?id='.$report->pirepid);?>">Edit PIREP</a>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>

now i wont showing pilot name what i should enter to display pilot name also.

Awaiting you

Asmara

Angel Air · August 7, 2011

With link to pirep report on flight number.

<?php
$count = 5;
$pireps = PIREPData::getRecentReportsByCount($count);
?>

<table>
  <thead>
    <tr>
      <th>Flight #</th>
      <th>Departure</th>
      <th>Arrival</th>
      <th>Duration</th>
      <th>Pilot</th>
      <th>Status</th>
    </tr>
   </thead>
   <tbody>

<?php

if(count($pireps) > 0)
{
 foreach ($pireps as $pirep)
 {
   $pilotinfo = PilotData::getPilotData($pirep->pilotid);
   $pilotid = PilotData::getPilotCode($pilotinfo->code, $pilotinfo->pilotid);

   if($pirep->accepted == '0') $status = 'PENDING';
   if($pirep->accepted == '1') $status = 'ACCEPTED';
   else $status = 'REJECTED'; 

   echo '<tr>';
   echo '<td><a href="'.SITE_URL.'/index.php/pireps/viewreport/'.$pirep->pirepid.'">'.$pirep->code.$pirep->flightnum.'</a></td>';
   echo '<td>'.$pirep->depicao.'</td>';
   echo '<td>'.$pirep->arricao.'</td>';
   echo '<td>'.$pirep->flighttime.'</td>';
   echo '<td>'.$pilotid.' '.$pilotinfo->firstname.' '.$pilotinfo->lastname.'</td>';
   echo '<td>'.$status.'</td>';
   echo '</tr>';
 }
}
else
{
   echo '<tr><td>There are no recent flights!</td></tr>';
}
?>
  </tbody>
</table>

Hi,

Thanks for the code it works great.

but I could do with knowing how to change the colour of the:-

"ACCEPTED" to Green

"REJECTED" to RED

"PENDING" to Amber

Any help would be appreciated.

Thanks

Scott

Jeff · August 7, 2011

I use this code in my pirep_viewall.tpl you can modify it to use.

<td align="center">
	<?php

	if($report->accepted == PIREP_ACCEPTED)
		echo '<div id="success"><font color="green">Accepted</font></div>';
	elseif($report->accepted == PIREP_REJECTED)
		echo '<div id="error"><font color="red">Rejected</font></div>';
	elseif($report->accepted == PIREP_PENDING)
		echo '<div id="error"><font color="orange">Approval Pending</font></div>';
	elseif($report->accepted == PIREP_INPROGRESS)
		echo '<div id="error">Flight in Progress</div>';

	?>
</td>

Angel Air · August 8, 2011

thanks jeff works a treat

Angel Air · August 13, 2011

Hi,

Here is the code I am using to display Recent Reports How do I get the flight number to be clickable to show the filed PIREP.

 <?php
$count = 5;
$pireps = PIREPData::getRecentReportsByCount($count);
?>
 <table width="625" border="1" cellspacing="2" cellpadding="2">
   <tdead>
     <tr class="recent">
       <td><strong>Flight No</strong></td>
       <td><strong>Departure</strong></td>
       <td><strong>Arrival</strong></td>
       <td><strong>Duration</strong></td>
       <td><strong>Pilot</strong></td>
       <td><strong>Status</strong></td>
       </tr>
     </tdead>
   <tbody>

     <?php

if(count($pireps) > 0)
{
 foreach ($pireps as $pirep)
 {
 {
       $pilotinfo = PilotData::getPilotData($pirep->pilotid);
       $pilotid = PilotData::getPilotCode($pilotinfo->code, $pilotinfo->pilotid);

       if($pirep->accepted == '0') $status = 'REJECTED';
       if($pirep->accepted == '1') $status = 'ACCEPTED';
       else $status = 'PENDING'; 
} 
?>
     <tr>
       <td><?php echo $pirep->code.$pirep->flightnum; ?></td>
       <td><?php echo $pirep->depicao; ?></td>
       <td><?php echo $pirep->arricao; ?></td>
       <td><?php echo $pirep->flighttime; ?></td>
       <td><?php echo $pilotinfo->firstname.' '.$pilotinfo->lastname; ?></td>
       <td><?php

               if($pirep->accepted == PIREP_ACCEPTED)
                       echo '<span style="color:#347C17"><strong>Accepted</strong></span>';
               elseif($pirep->accepted == PIREP_REJECTED)
                       echo '<span style="color:#FF0000"><strong>Rejected</strong></span>';
               elseif($pirep->accepted == PIREP_PENDING)
                       echo '<span style="color:#E56717"><strong>Approval Pending</strong></span>';
               elseif($pirep->accepted == PIREP_INPROGRESS)
                       echo '<span style="color:#whatever">Flight in Progress</span>';
                       ?>
       </td>
     </tr>
     <?php
}}
else
{
       echo '<tr><td>There are no recent flights!</td></tr>';
}
?>
    </tbody>
 </table>
</div>
<hr />

Thanks

Scott

Angel Air · August 21, 2011

bump

Jeff · August 21, 2011

Scott, this might be what you are looking for:

<td align="center"><a href="<?php echo url('/pireps/view/'.$report->pirepid);?>"><?php echo $report->code  .-  $report->flightnum; ?></a></td>

If not, try this one:

<td align="center"><a href="<?php echo url('/pireps/view/'.$report->pirepid);?>"><?php echo $pirep->code  .-  $pirep->flightnum; ?></a></td>

Angel Air · August 22, 2011

Scott, this might be what you are looking for:

<td align="center"><a href="<?php echo url('/pireps/view/'.$report->pirepid);?>"><?php echo $report->code  .-  $report->flightnum; ?></a></td>

If not, try this one:

<td align="center"><a href="<?php echo url('/pireps/view/'.$report->pirepid);?>"><?php echo $pirep->code  .-  $pirep->flightnum; ?></a></td>

Thanks Jeff will give it a try.

Angel Air · August 24, 2011

Hi Jeff,

Thanks for the codes which work to a point. It does make the flight number clickable but when you click it I get a response of "No report ID specified!" I have had a look in the PIREPS.php file to see where it is going wrong but i may aswell be looking at quantum physics because it does not make any sense to me.

Hope you can help.

Thanks in advance

Scott

Jeff · August 24, 2011

Here is the code I have in my /public_html/core/templates/frontpage_reports.tpl

<p><a href="<?php echo url('/pireps/viewreport/'.$report->pirepid);?>">#<?php echo $report->pirepid
. ' - ' . $report->code.$report->flightnum?></a> - <a href="<?php echo url('/profile/view/'.$report->pilotid);?>"><?php echo $report->firstname . ' ' . $report->lastname?></a></p>

That might work better. If not, let me know.

Angel Air · August 25, 2011

Here is the code I have in my /public_html/core/templates/frontpage_reports.tpl
<p><a href="<?php echo url('/pireps/viewreport/'.$report->pirepid);?>">#<?php echo $report->pirepid
. ' - ' . $report->code.$report->flightnum?></a> - <a href="<?php echo url('/profile/view/'.$report->pilotid);?>"><?php echo $report->firstname . ' ' . $report->lastname?></a></p>
That might work better. If not, let me know.

I have tried that code but still can not get it to work. I was able to get it to goto the pilots public profile but not to the pirep that was filed.

Scott

August 25, 2011

The code should be as follows.

<p><a href="<?php echo url('/pireps/viewreport/'.$pirep->pirepid);?>">#<?php echo $pirep->pirepid
       . ' - ' . $pirep->code.$pirep->flightnum?></a> - <a href="<?php echo url('/profile/view/'.$pirep->pilotid);?>"><?php echo $pirep->firstname . ' ' . $pirep->lastname?></a></p>

All of the $report need to be changed to $pirep

August 25, 2011

Try this complete code

 <?php
$count = 5;
$pireps = PIREPData::getRecentReportsByCount($count);
?>
 <table width="625" border="1" cellspacing="2" cellpadding="2">
   <tdead>
     <tr class="recent">
       <td><strong>Flight No</strong></td>
       <td><strong>Departure</strong></td>
       <td><strong>Arrival</strong></td>
       <td><strong>Duration</strong></td>
       <td><strong>Pilot</strong></td>
       <td><strong>Status</strong></td>
       </tr>
     </tdead>
   <tbody>

     <?php

if(count($pireps) > 0)
{
 foreach ($pireps as $pirep)
 {
 {
       $pilotinfo = PilotData::getPilotData($pirep->pilotid);
       $pilotid = PilotData::getPilotCode($pilotinfo->code, $pilotinfo->pilotid);
} 
?>
     <tr>
       <td><a href="<?php echo url('/pireps/viewreport/'.$pirep->pirepid);?>">
             <?php echo $pirep->code.$pirep->flightnum; ?></a>
       </td>
       <td><?php echo $pirep->depicao; ?></td>
       <td><?php echo $pirep->arricao; ?></td>
       <td><?php echo $pirep->flighttime; ?></td>
       <td><?php echo $pilotinfo->firstname.' '.$pilotinfo->lastname; ?></td>
       <td><?php

               if($pirep->accepted == PIREP_ACCEPTED)
                       echo '<span style="color:#347C17"><strong>Accepted</strong></span>';
               elseif($pirep->accepted == PIREP_REJECTED)
                       echo '<span style="color:#FF0000"><strong>Rejected</strong></span>';
               elseif($pirep->accepted == PIREP_PENDING)
                       echo '<span style="color:#E56717"><strong>Approval Pending</strong></span>';
               elseif($pirep->accepted == PIREP_INPROGRESS)
                       echo '<span style="color:#whatever">Flight in Progress</span>';
                       ?>
       </td>
     </tr>
     <?php
}}
else
{
       echo '<tr><td>There are no recent flights!</td></tr>';
}
?>
    </tbody>
 </table>
</div>
<hr />

Angel Air · August 25, 2011

God you are good!!!

Thankyou very much

Scott

August 26, 2011

God you are good!!!

Thankyou very much

Scott

No Problem

Steve Bartlett · August 25, 2014

For some reason I am getting this error: Warning: Invalid argument supplied for foreach() in/home/xxxx/public_html/lib/skins/vairline/frontpage_main.tpl on line 12

Here are the lines 9 through 15 with foreach ($flights as $flight) being line 12

<?php

$flights = PIREPData::getRecentReportsByCount(10);

$string = "";

foreach ($flights as $flight)

{

$string = $string.$flight->depicao.'+-+'.$flight->arricao.',+';

}

toto88 · October 2, 2014

thank you

_________________________________________________________________________

Gclub

sayedzaafir · March 20, 2019

On 8/25/2011 at 6:42 AM, lorathon said:

Try this complete code


 <?php
$count = 5;
$pireps = PIREPData::getRecentReportsByCount($count);
?>
 <table width="625" border="1" cellspacing="2" cellpadding="2">
   <tdead>
     <tr class="recent">
       <td><strong>Flight No</strong></td>
       <td><strong>Departure</strong></td>
       <td><strong>Arrival</strong></td>
       <td><strong>Duration</strong></td>
       <td><strong>Pilot</strong></td>
       <td><strong>Status</strong></td>
       </tr>
     </tdead>
   <tbody>

     <?php

if(count($pireps) > 0)
{
 foreach ($pireps as $pirep)
 {
 {
       $pilotinfo = PilotData::getPilotData($pirep->pilotid);
       $pilotid = PilotData::getPilotCode($pilotinfo->code, $pilotinfo->pilotid);
} 
?>
     <tr>
       <td><a href="<?php echo url('/pireps/viewreport/'.$pirep->pirepid);?>">
             <?php echo $pirep->code.$pirep->flightnum; ?></a>
       </td>
       <td><?php echo $pirep->depicao; ?></td>
       <td><?php echo $pirep->arricao; ?></td>
       <td><?php echo $pirep->flighttime; ?></td>
       <td><?php echo $pilotinfo->firstname.' '.$pilotinfo->lastname; ?></td>
       <td><?php

               if($pirep->accepted == PIREP_ACCEPTED)
                       echo '<span style="color:#347C17"><strong>Accepted</strong></span>';
               elseif($pirep->accepted == PIREP_REJECTED)
                       echo '<span style="color:#FF0000"><strong>Rejected</strong></span>';
               elseif($pirep->accepted == PIREP_PENDING)
                       echo '<span style="color:#E56717"><strong>Approval Pending</strong></span>';
               elseif($pirep->accepted == PIREP_INPROGRESS)
                       echo '<span style="color:#whatever">Flight in Progress</span>';
                       ?>
       </td>
     </tr>
     <?php
}}
else
{
       echo '<tr><td>There are no recent flights!</td></tr>';
}
?>
    </tbody>
 </table>
</div>
<hr />

i used this , but how to link the pilot profile along there name ??

stifler13371 · July 21, 2019

On 3/20/2019 at 7:00 PM, sayedzaafir said:

i used this , but how to link the pilot profile along there name ??

<?php
$count = 8;
$pireps = PIREPData::getRecentReportsByCount($count);
?>
 <table width="1500" border="1" cellspacing="2" cellpadding="2">
   <tdead>
     <tr class="recent">
       <td><strong>Flight No</strong></td>
       <td><strong>Departure</strong></td>
       <td><strong>Arrival</strong></td>
       <td><strong>Duration</strong></td>
       <td><strong>Pilot</strong></td>
       <th>Landing Rate</strong></th>
       <td><strong>Status</strong></td>
       </tr>
     </tdead>
   <tbody>

     <?php

if(count($pireps) > 0)
{
 foreach ($pireps as $pirep)
 {
 {
       $pilotinfo = PilotData::getPilotData($pirep->pilotid);
       $pilotid = PilotData::getPilotCode($pilotinfo->code, $pilotinfo->pilotid);
} 
?>
     <tr>
       <td><a href="<?php echo url('/pireps/viewreport/'.$pirep->pirepid);?>">
             <?php echo $pirep->code.$pirep->flightnum; ?></a>
       </td>
       <td><?php echo $pirep->depicao; ?></td>
       <td><?php echo $pirep->arricao; ?></td>
       <td><?php echo $pirep->flighttime; ?></td>
       <td><a href="<?php echo url('/profile/view/'.$pirep->pilotid);?>">
             <?php echo $pilotinfo->firstname.' '.$pilotinfo->lastname; ?></a>
       <td><?php echo $pirep->landingrate; ?></td>
       <td><?php

               if($pirep->accepted == PIREP_ACCEPTED)
                       echo '<span style="color:#347C17"><strong>Accepted</strong></span>';
               elseif($pirep->accepted == PIREP_REJECTED)
                       echo '<span style="color:#FF0000"><strong>Rejected</strong></span>';
               elseif($pirep->accepted == PIREP_PENDING)
                       echo '<span style="color:#E56717"><strong>Approval Pending</strong></span>';
               elseif($pirep->accepted == PIREP_INPROGRESS)
                       echo '<span style="color:#whatever">Flight in Progress</span>';
                       ?>
       </td>
     </tr>
     <?php
}}
else
{
       echo '<tr><td>There are no recent flights!</td></tr>';
}
?>
    </tbody>
 </table>
</div>
<hr />

This is what im using on the VA im working with

Jiko · December 9, 2020

On 3/20/2019 at 8:00 PM, sayedzaafir said:

i used this , but how to link the pilot profile along there name ??

<?php
$count = 5;
$pireps = PIREPData::getRecentReportsByCount($count);
?>

<?php
$count = 5;
$pireps = PIREPData::getRecentReportsByCount($count);
?>

<?php
$count = 5;
$pireps = PIREPData::getRecentReportsByCount($count);
?>
 <table width="625" border="1" cellspacing="2" cellpadding="2">
   <tdead>
     <tr class="recent">
       <td><strong>Flight No</strong></td>
       <td><strong>Departure</strong></td>
       <td><strong>Arrival</strong></td>
       <td><strong>Duration</strong></td>
       <td><strong>Pilot</strong></td>
       <td><strong>Status</strong></td>
       </tr>
     </tdead>
   <tbody>

     <?php

if(count($pireps) > 0)
{
 foreach ($pireps as $pirep)
 {
 {
       $pilotinfo = PilotData::getPilotData($pirep->pilotid);
       $pilotid = PilotData::getPilotCode($pilotinfo->code, $pilotinfo->pilotid);
} 
?>
     <tr>
       <td><a href="<?php echo url('/pireps/viewreport/'.$pirep->pirepid);?>">
             <?php echo $pirep->code.$pirep->flightnum; ?></a>
       </td>
	   <td><a href="<?php echo  SITE_URL.'/index.php/profile/view/'.$pilotinfo->pilotid?>">
	       <?php echo $pilotinfo->firstname.' '.$pilotinfo->lastname; ?></td>
       <td><?php echo $pirep->depicao; ?></td>
       <td><?php echo $pirep->arricao; ?></td>
       <td><?php echo $pirep->flighttime; ?></td>
       <td><?php

               if($pirep->accepted == PIREP_ACCEPTED)
                       echo '<span style="color:#347C17"><strong>Accepted</strong></span>';
               elseif($pirep->accepted == PIREP_REJECTED)
                       echo '<span style="color:#FF0000"><strong>Rejected</strong></span>';
               elseif($pirep->accepted == PIREP_PENDING)
                       echo '<span style="color:#E56717"><strong>Approval Pending</strong></span>';
               elseif($pirep->accepted == PIREP_INPROGRESS)
                       echo '<span style="color:#whatever">Flight in Progress</span>';
                       ?>
       </td>
     </tr>
     <?php
}}
else
{
       echo '<tr><td>There are no recent flights!</td></tr>';
}
?>
    </tbody>
 </table>
</div>
<hr />


</div>
    </div>

Sign In

Recent 5 Flights

Recommended Posts

FiveStar

Angel Air

Jeff

Angel Air

Angel Air

Angel Air

Jeff

Angel Air

Angel Air

Jeff

Angel Air

Guest lorathon

Guest lorathon

Angel Air

Guest lorathon

Steve Bartlett

toto88

sayedzaafir

stifler13371

Jiko

Join the conversation