{ $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"])) {