$overbudgetColorArray

line 19 overbudget.inc
$overUnderBudget = round($device['projected_color_cpc']) - round($device['budgeted_color_cpc']);

SELECT fpm.commencement_black_meter, 
me.black_meter, me.color_meter
FROM Y2019_floorplan_machines fpm
LEFT JOIN Y2019_meter me ON fpm.id = me.machine_id

AND me.date_timestamp = (SELECT max(i.date_timestamp) FROM Y2019_meter i
	WHERE i.machine_id = fpm.id and black_meter > 0 and date_timestamp <  date_format(NOW(),'Y/m/d H:i:s')) and date_timestamp > date_format($startingDate,'Y/m/d H:i:s'))



$cm_date = date_format($device_commencement_date,'Y-m-d');
	$sql = "select datediff('".$currDate."','".$cm_date."')";
	$cm_diff = ew_ExecuteScalar($sql); //Get the number of days between the device commencement date and the current date
	$sql = "select datediff('".$endDate."','".$org_comm_date."')";
	$org_fiscal_days = ew_ExecuteScalar($sql); //Get the number of days between the organization commencement date and the ending fiscal date

$projected_black     = $consumed_black      / $cm_diff * min($org_fiscal_days, 345);

Sylvio J. Gilbert School