{
$num = cal_days_in_month(CAL_GREGORIAN, $month, $year);
$dates_month = array();
for ($i = 1; $i <= $num; $i++) {
$mktime = mktime(0, 0, 0, $month, $i, $year);
$date = date("d-M-Y", $mktime);
$dates_month[$i] = $date;
}
return $dates_month;
}
$days = dates_month(date("m"), date("Y"));
foreach ($days as $day) {
if (date("d", strtotime($day)) > 31) {
continue;
}
$fleetData = $fleetdayobj->pullT24FleetData(date("d", strtotime($day)));
$fleet_trucks = (array) array();
foreach ($fleetData as $row) {
$fleet_trucks[$row["fleet_id"]][] = $row;
}
unset($fleetData);
// print_r($fleet_trucks);
$t24Budget = (array) array();
foreach ($fleet_trucks as $fleetId => $truck) {
$trucks = (string) "";
foreach ($truck as $data) {
$trucks .= $data["truck_id"] . ",";
}
$budgets = $fleetdayobj->getBudgetsInDateRange(date("Y-m-d", strtotime($day)), date("Y-m-d", strtotime($day) + 86400), substr($trucks, 0, -1));
// print_r($budgets);
$t24Budget[$fleetId] = (array) array();
foreach ($budgets as $truck_id => $budgetrow) {
//print_r($budgetrow);
foreach ($budgetrow as $val) {
$days[] = $val["date"];
}
break;
}
$t24Budget = (array) array();
foreach ($days as $day) {
//: Get the trucks in a fleet on a specific day
$date = intval(substr($day, strrpos($day, "-") + 1));
//echo $date;
if ($date > 1) {
continue;
}
$trucksinafleet = $fleetdayobj->pullT24FleetData($date);
print_r($trucksinafleet);
//: End
//: Sum the budget amounts per truck
foreach ($trucksinafleet as $row) {
//: Get the budget for this truck
if (array_key_exists($row["truck_id"], $budgets)) {
$t24Budget[$row["fleet_id"]][$day] = array();
$t24Budget[$row["fleet_id"]][$day]["fleetid"] = $row["fleet_id"];
if (!isset($t24Budget[$row["fleet_id"]][$day]["budget"])) {
$t24Budget[$row["fleet_id"]][$day]["budget"] = (double) 0;
}
if (!isset($t24Budget[$row["fleet_id"]][$day]["budgetcontrib"])) {
$t24Budget[$row["fleet_id"]][$day]["budgetcontrib"] = (double) 0;
}
if (!isset($t24Budget[$row["fleet_id"]][$day]["budkms"])) {
