$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);
 public static function getAsObject($records, $fields)
 {
     $result = parent::getAsObject($records, $fields);
     return $result;
 }
Example #3
0
 public static function getAsParameter($request, $fields)
 {
     $result = parent::getAsParameter($request, $fields);
     return $result;
 }