1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
@mysql_query("TRUNCATE TABLE vol");
@mysql_query("INSERT INTO vol (id, UserName, CompanyName, PilotName, FlightId, FlightDate, rbilletsv, rcargov, rcollationsv, totalrecettesv, dfuelv, dsalairesv, dcrewcostv, dassurancesv, dtaxesv, dpenalitesv, dmaintenancev, totaldepensesv, beneficev)
SELECT id,
UserName,
CompanyName,
PilotName,
FlightId,
FlightDate,
REPLACE(TotalDistance,',','') * NbrPassengers * $PrixTicket / $Refdistance AS rbilletsv,
CargoWeight * $Prixkgcargo * REPLACE(TotalDistance,',','') / $Refdistance AS rcargov,
NbrPassengers * $Prixcollation AS rcollationsv,
NbrPassengers * $PrixTicket * REPLACE(TotalDistance,',','') / $Refdistance + CargoWeight * $Prixkgcargo * REPLACE(TotalDistance,',','') / $Refdistance + NbrPassengers * $Prixcollation AS totalrecettesv,
StartFuelQuantity * $Prixkgfuel - EndFuelQuantity * $Prixkgfuel AS dfuelv,
time_to_sec(TotalBlockTime) * $Prixsalarypilotperh / 3600 AS dsalairesv,
time_to_sec(TotalBlockTime) * $Prixsalarycrewperh / 3600 AS dcrewcostv,
(NbrPassengers * $PrixTicket * REPLACE(TotalDistance,',','') / $Refdistance + CargoWeight * $Prixkgcargo * REPLACE(TotalDistance,',','') / $Refdistance + NbrPassengers * $Prixcollation) * $Percentinsurance * REPLACE(TotalDistance,',','') / $Refdistance AS dassurancesv,
(NbrPassengers * $PrixTicket * REPLACE(TotalDistance,',','') / $Refdistance + CargoWeight * $Prixkgcargo * REPLACE(TotalDistance,',','') / $Refdistance + NbrPassengers * $Prixcollation) * $Percentairporttaxe * REPLACE(TotalDistance,',','') / $Refdistance AS dtaxesv,
PenalityPoints * $PrixPenalityPointscost AS dpenalitesv,
time_to_sec(TotalBlockTime) * $Prixmaintenancej / 3600 AS dmaintenancev,
StartFuelQuantity * $Prixkgfuel - EndFuelQuantity * $Prixkgfuel + time_to_sec(TotalBlockTime) * $Prixsalarypilotperh / 3600 + time_to_sec(TotalBlockTime) * $Prixsalarycrewperh / 3600 + (NbrPassengers * $PrixTicket * REPLACE(TotalDistance,',','') / $Refdistance + CargoWeight * $Prixkgcargo * REPLACE(TotalDistance,',','') / $Refdistance + NbrPassengers * $Prixcollation) * $Percentinsurance * REPLACE(TotalDistance,',','') / $Refdistance + (NbrPassengers * $PrixTicket * REPLACE(TotalDistance,',','') / $Refdistance + CargoWeight * $Prixkgcargo * REPLACE(TotalDistance,',','') / $Refdistance + NbrPassengers * $Prixcollation) * $Percentairporttaxe * REPLACE(TotalDistance,',','') / $Refdistance + PenalityPoints * $PrixPenalityPointscost + time_to_sec(TotalBlockTime) * $Prixmaintenancej / 3600 AS totaldepensesv,
(NbrPassengers * $PrixTicket * REPLACE(TotalDistance,',','') / $Refdistance + CargoWeight * $Prixkgcargo * REPLACE(TotalDistance,',','') / $Refdistance + NbrPassengers * $Prixcollation) - (StartFuelQuantity * $Prixkgfuel - EndFuelQuantity * $Prixkgfuel + time_to_sec(TotalBlockTime) * $Prixsalarypilotperh / 3600 + time_to_sec(TotalBlockTime) * $Prixsalarycrewperh / 3600 + (NbrPassengers * $PrixTicket * REPLACE(TotalDistance,',','') / $Refdistance + CargoWeight * $Prixkgcargo * REPLACE(TotalDistance,',','') / $Refdistance + NbrPassengers * $Prixcollation) * $Percentinsurance * REPLACE(TotalDistance,',','') / $Refdistance + (NbrPassengers * $PrixTicket * REPLACE(TotalDistance,',','') / $Refdistance + CargoWeight * $Prixkgcargo * REPLACE(TotalDistance,',','') / $Refdistance + NbrPassengers * $Prixcollation) * $Percentairporttaxe * REPLACE(TotalDistance,',','') / $Refdistance + PenalityPoints * $PrixPenalityPointscost + time_to_sec(TotalBlockTime) * $Prixmaintenancej / 3600) AS beneficev FROM flights"); |
Partager