connectPg();
$query = "SELECT reports.estate, count(*) as total FROM reports WHERE is_active='1' AND status_activity='1' and DATETIME >= '2024-01-01' GROUP BY reports.estate ORDER BY total DESC";
$query_all = $pg_con->query($query);
$total_by_states_array = [];
$state_labels_array = [];
foreach($query_all as $row){
$total_by_states_array[] = $row['total'];
$state_labels_array[] = "'".$row['estate']."'";
}
$state_labels = implode(",", $state_labels_array);
$total_states = implode(", ", $total_by_states_array);
?>