3 OR o.authorization_status IS NULL) AND tcf.cfield_id = {$costField} AND tcf.cfield_value > 0 AND o.data_abertura >= '{$datesBegin[0]}' AND o.data_abertura <= '" . date('Y-m-d 23:59:59') . "' {$areasTerms} GROUP BY s.sistema, s.sis_id ORDER BY s.sistema; "; $result = $conn->query($sql); foreach ($result->fetchAll() as $row) { $i = 0; foreach ($datesBegin as $dateStart) { /* Em cada intervalo de tempo busco os totais de cada área */ $sqlEach = "SELECT SUM(CAST(REPLACE(REPLACE(tcf.cfield_value, '.', ''), ',', '.') AS DECIMAL(10,2))) as total, s.sistema FROM ocorrencias o, sistemas s, `status` st, usuarios ua, tickets_x_cfields tcf WHERE s.sis_id = {$aliasAreasFilter} AND {$aliasAreasFilter} = {$row['sis_id']} AND o.aberto_por = ua.user_id AND o.status = st.stat_id AND st.stat_ignored <> 1 AND o.numero = tcf.ticket AND tcf.cfield_id = {$costField} AND o.data_abertura >= '{$dateStart}' AND o.data_abertura <= '{$datesEnd[$i]}' AND (o.authorization_status <> 3 OR o.authorization_status IS NULL) {$qry_filter_clients} {$qry_filter_areas} GROUP BY s.sistema "; $resultEach = $conn->query($sqlEach); $countResults = $resultEach->rowCount(); if ($countResults) { foreach ($resultEach->fetchAll() as $rowEach) { if ($rowEach['sistema']) { $areas[] = $rowEach['sistema']; // $totais[] = (int)$rowEach['total']; $meses[] = $months[$i]; $areasDados[$rowEach['sistema']][] = $rowEach['total']; // $areasDados[$rowEach['sistema']][] = priceScreen($rowEach['total']); } else { $areas[] = $row['sistema']; $meses[] = $months[$i]; $areasDados[$row['sistema']][] = 0; } } } else { $areas[] = $row['sistema']; $meses[] = $months[$i]; $areasDados[$row['sistema']][] = 0; } $i++; } } /* Ajusto os arrays de labels para não ter repetidos */ $meses = array_unique($meses); $areas = array_unique($areas); /* Separo o conteúdo para organizar o JSON */ $data['areas'] = $areas; $data['months'] = $meses; $data['totais'] = $areasDados; $data['chart_title'] = ($_SESSION['requester_areas'] ? TRANS('COST_BY_REQUESTER_AREA_LAST_MONTHS', '', 1) : TRANS('COST_BY_AREA_LAST_MONTHS', '', 1)); // var_dump($areas, $totais, $meses, $areasDados, $data); echo json_encode($data); ?>