Have some progress. Its not pulling the monthly stats correctly. It's the 4th of the month now way we have that many hours already. 
 
HubClass file 
 
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;
}
 
php file 
 
<?php echo HubStats::TotalHoursBetweenDates('CYQH', date("Y-m-01"), date("Y-m-t"));?>
 
Not sure why it showing data now and not before.