$dataset_budget['highlightFill'] = "rgba(220,220,220,0.75)"; $dataset_budget['highlightStroke'] = "rgba(220,220,220,1)"; $dataset_budget['data'] = $data_budget; $dataset[] = $dataset_budget; foreach ($periods as $dt) { $dt_end = clone $dt; $start = $dt->modify('first day of this month'); $end = $dt_end->modify('last day of this month'); $d = '{' . $start->format('d') . '...' . $end->format('d') . '}'; $m = $start->format('m'); $y = $start->format('Y'); $events = new Events(); $search = array('date' => "{$m}/{$d}/{$y}", 'client_id' => $client_id, 'service_id' => $service_id); $parameter = Events::getAsParameter($search, Events::getFields()); $parameter = json_encode($parameter); $foundEvents = $events->find($parameter, $inclusionFirst); error_log("{$m}/{$d}/{$y}"); if (!FileMaker::isError($foundEvents)) { $data_scheduled[] = FM_Table::summarize($foundEvents, 'duration_unix') / 60 / 60; } else { $data_scheduled[] = 0; } } $dataset_scheduled['fillColor'] = "rgba(151,187,205,0.5)"; $dataset_scheduled['strokeColor'] = "rgba(151,187,205,0.8)"; $dataset_scheduled['highlightFill'] = "rgba(151,187,205,0.75)"; $dataset_scheduled['highlightStroke'] = "rgba(151,187,205,1)"; $dataset_scheduled['data'] = $data_scheduled; $dataset[] = $dataset_scheduled; $data['datasets'] = $dataset; echo json_encode($data);