HubStats Class

[Taran]

IT WORKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Thank you all!

[Taran]

Hey, one more thing that other VA's might find handy as well. We'll be inputting cargo operations soon, is there a code available to pull total cargo carried out of and into that HUB?

[Taran]

anyone?

[Taran]

Would this be it? I highly doubt it, but it's worth a shot?

public static function TotalCargoBetweenDates($icao, $startdate, $enddate) { //Count total cargo
$query = "SELECT SUM(cargo) as hours FROM phpvms_pireps WHERE depicao = '$icao' OR arricao = '$icao' AND DATE(submitdate) >= '$startdate' AND DATE(submitdate) <= '$enddate'";
$result = DB::get_row($query);
return $result->cargo;
}

[Tom]

Would this be it? I highly doubt it, but it's worth a shot?

public static function TotalCargoBetweenDates($icao, $startdate, $enddate) { //Count total cargo
$query = "SELECT SUM(cargo) as hours FROM phpvms_pireps WHERE depicao = '$icao' OR arricao = '$icao' AND DATE(submitdate) >= '$startdate' AND DATE(submitdate) <= '$enddate'";
$result = DB::get_row($query);
return $result->cargo;
}

I believe the 'load' column is used for both pax and cargo, so you'll need to use the 'flightType' to differentiate between them.

[Taran]

Ok, so what would the official code be for that?

[freshJet]

public static function TotalCargoBetweenDates($icao, $startdate, $enddate) { //Count total cargo
$query = "SELECT SUM(cargo) as cargo FROM phpvms_pireps WHERE depicao = '$icao' OR arricao = '$icao' AND flighttype = 'C' AND DATE(submitdate) >= '$startdate' AND DATE(submitdate) <= '$enddate'";
$result = DB::get_row($query);
return $result->cargo;
}

[Taran]

Thanks!

[Taran]

I hate to ask for more, but is there a way to get the data from only ACCEPTED PIREPs and have it ignore the data from rejected PIREPs? right now we have completely delete the rejected pireps for the data to stay correct.

[Strider]

In the where clause put in accepted = 1

[freshJet]

I hate to ask for more, but is there a way to get the data from only ACCEPTED PIREPs and have it ignore the data from rejected PIREPs? right now we have completely delete the rejected pireps for the data to stay correct.

public static function TotalCargoBetweenDates($icao, $startdate, $enddate) { //Count total cargo
$query = "SELECT SUM(cargo) as cargo FROM phpvms_pireps WHERE depicao = '$icao' OR arricao = '$icao' AND flighttype = 'C' AND DATE(submitdate) >= '$startdate' AND DATE(submitdate) <= '$enddate' AND accepted = '1'";
$result = DB::get_row($query);
return $result->cargo;
}

[Taran]

thanks itrobb,

[Taran]

how about an example that's not by month?

[Taran]

Ok, it appears that it's not calculating correctly at all by month. It just reduced the numbers but I can't tell exactly what it's calculating. At the start of February UTC time it should have reset to 0 for all, but did not. Any ideas?

[Tom]

Ok, it appears that it's not calculating correctly at all by month. It just reduced the numbers but I can't tell exactly what it's calculating. At the start of February UTC time it should have reset to 0 for all, but did not. Any ideas?

What's your code?

[freshJet]

Ok, it appears that it's not calculating correctly at all by month. It just reduced the numbers but I can't tell exactly what it's calculating. At the start of February UTC time it should have reset to 0 for all, but did not. Any ideas?

Try clearing your cache.

[Taran]

My code is what we posted earlier in the thread exactly. and clearing my cache didn't do it either

[Taran]

anyone?

[freshJet]

What start and end dates are you passing in?

[Taran]

<?php echo HubStats::TotalHoursBetweenDates('KSEA', date("Y-m-01"), date("Y-m-t"));?>

[Taran]

still nothing on this issue?

[flyalaska]

AM I missing something? I have

public static function TotalHoursBetweenDates($icao, $startdate, $enddate) { //Count total hours
$query = "SELECT SUM(flighttime) as hours FROM phpvms_pireps WHERE depicao = '$icao' OR arricao = '$icao' AND DATE(submitdate) >= '$startdate' AND DATE(submitdate) <= '$enddate'";
$result = DB::get_row($query);
return $result->hours;
}

in my HubStats.class

and this on my frontpage_main.php

<?php echo HubStats::TotalHoursBetweenDates('PANC', date("Y-m-01"), date("Y-m-t"));?>

Still getting a blank return.

Any help would be appreciated!

[freshJet]

Only thing I can suggest is that you don't have phpvms_ as your table prefix. Other than that, you could always do

$startdate = date("Y-m-01");
$enddate = date("Y-m-t");
HubStats::TotalHoursBetweenDates('PANC', date("Y-m-01"), date("Y-m-t"));

Shouldn't make a difference but give it shot.

EDIT: You might have to set your timezone:

date_default_timezone_set('Europe/London');

Change as necessary of course.

[flyalaska]

I use phpvms_ as my prefix. I am using phpVMS Extended from SImpilot. Would that make a difference?

[freshJet]

I don't know, I have no experience in using it. It may well do.

[Strider]

have a look in the error_log and see if any error shows up there. It may tell you why you are getting a blank.

[Tato123]

Hello,

i have a problem ...

if i try in local (127.0.0.1) <?php echo HubStats::CountFlightsTo('LIRA'); ?> work great

On line don't work

All the others stats works, only CountFlightsTo not work online

Do yuo have a solution please?

Thanks

[servetas]

Is the CountFlightsTo function included on the online version of HubStats module?

[Tato123]

Yes i have update also that file

[servetas]

Can you attach this here in order to check its functions?