Passenger Flight with Cargo

[AlessandroCuba]

I need to know how I could have on passenger flights, cargo transport

[chilemugriento]

SOLVED....

Since 2006 our VA had FSPassengers reports

Total Flights: 39122

Total Passengers: 3,422,452

Total freight: 165 960 327 kg / lbs 365 879 868

averaging the data shown above where

freight (lbs) / pax = 106.90577048268 (lbs)

This represents the average weight per luggage per passenger. With this total number of flights, I believe that the sample is statistically representative and very close to reality.

Now, to represent this variable within the phpvms in regular passenger flights, we have to perform a mathematical operation. I used the vStatsCenter module to show cargo transported on flights that are not Freight and Cargo

Here we go:

This is for THIS MONTH values

align="center"> <table

<thead>

? <th colspan="8"> <Center> SELECTED STATISTICS MONTH <BR> <php echo $ month_name = date ('F', mktime (0, 0, 0, $ month)); ?> - <Php echo $ year;> </ h3> <Center> </ th>?

<tr>

<th> <Center> <img src="yoursite.JPG"> <Center> Flights </ th>

<th> <Center> <img src="yoursite.JPG"> <Center> Passengers </ th>

<th> <Center> <img src="yoursite.JPG"> <Center> Load </ th>

<th> <Center> <img src="yoursite.JPG"> <Center> Hours </ th>

<th> <Center> <img src="yoursite.JPG"> <Center> Miles </ th>

<th> <Center> <img src="yoursite.JPG"> <Center> Fuel </ th>

<th> <Center> <img src="yoursite.JPG"> <Center> Land </ th>

</ tr>

</ thead>

<tbody>

<tr>

<td align="center"> <? php echo $ flightcount;> </ td>

<td align="center"> <? php echo number_format ($ passengers);> </ td>

<td align="center"> <? php echo number_format (($ passengers) * (107))> lbs </ td>

<td align="center"> <php echo substr ($ flighthours, 0, 6); > </ td>

<td align="center"> <? php echo number_format ($ flightmiles)> mn </ td>

<td align="center"> <? php echo number_format ($ flightfuel)> lbs </ td>

<td align="center"> <? php echo round ($ avglanding)> ft / min </ td>

<td colspan="7"> </ td>

</ tbody>

</ table> </ p> <BR><BR><BR>

The value 107 can be modified according to characteristics of each VA.

You can use 100 lbs per passenger, 75, 60, 120, etc.

The load data can also be displayed in an additional table that represents the accumulated reports or Pireps that exist in the database

</tbody>

</table></p><BR><BR><BR><BR><BR><BR><h3 align="center">ACUMULATED FROM JANUARY 2006 UNTIL TODAY</h3><BR><BR>

<table align="center">

<thead>

<th colspan="9"><Center>OPERACIONES AEREAS<Center></th>

<tr>

<th><Center><img src="yoursite.JPG">Vuelos</th>

<th><Center><img src="yoursite.JPG">Pasajeros</th>

<th><Center><img src="yoursite.JPG">Carga</th>

<th><Center><img src="yoursite.JPG">Horas</th>

<th><Center><img src="yoursite.JPG">Millas</th>

<th><Center><img src="yoursite.JPG"...bustible</th>

</tr>

</thead>

<tbody>

<tr>

<td align="center"><?php echo number_format(StatsData::TotalFlights()); ?><br />

<td align="center"><?php echo number_format(StatsData::totalpaxcarried()); ?><br />

<td align="center"><?php

$query="SELECT SUM(`load`)*(107) as totalfreight FROM `phpvms_1pireps` WHERE `flighttype`='P' OR `flighttype`='C' OR `flighttype`='H' ";

$result=DB::get_results($query);

echo number_format ($result[0] ->totalfreight); ?> lbs<br />

<td align="center"><?php echo number_format (StatsData::TotalHours())?> <?php echo hrs; ?><br />

<td align="center"><?php echo number_format(StatsData::totalmilesflown()); ?> mn<br />

<td align="center"><?php echo number_format(StatsData::totalfuelburned(), 0); ?> lbs<br />

<td colspan="9"></td>

</tbody>

</table></p><BR><BR><BR><BR><BR>

furthermore, they can be displayed on the PILOT profile.tpl

</table><BR><BR><BR><BR>

<h3 align="center">PRODUCTIVIDAD</h3>

<table align="center">

<thead>

<th colspan="5"><Center>Totales Acumulados<Center></th>

<tr>

<th><Center><img src="yoursite.JPG">Vuelos</th>

<th><Center><img src="yoursite.JPG">Pasajeros</th>

<th><Center><img src="yoursite.JPG"><Center>Horas de vuelo</th>

<th><Center><img src="yoursite.JPG">Recorridas</th>

<th><Center><img src="yoursite.JPG">Carga</th>

</tr>

</thead>

<tbody>

<tr>

<td align="center"><?php echo number_format ($userinfo->totalflights)?></td>

<td align="center"><?php echo number_format (getTotalPassengersPilot());?></td>

<td align="center"><?php echo number_format ($userinfo->totalhours); ?> hrs</td>

<td align="center"><?php echo number_format (getTotalMilesPilot());?> mn</td>

<td align="center"><?php echo number_format (getTotalPassengersPilot()*(107));?> lbs</td>

<td colspan="5"></td><BR>

</tbody>

</table>

Hope this will be helpfull for your VA

Best Regards