0 AND id_embalse = d.id_embalse ORDER BY hora DESC LIMIT 1) ORDER BY cota_actual DESC LIMIT 1) AS cota_actual FROM datos_embalse d, embalses e WHERE e.id_embalse = d.id_embalse AND e.estatus = 'activo' AND d.estatus = 'activo' AND d.id_embalse = '$id' AND YEAR(fecha) >= '$periodo' GROUP BY d.fecha;"; } if ($tipo == "line") { $aux = "SELECT * FROM datos_embalse WHERE estatus = 'activo' AND id_embalse = '$id' AND cota_actual <> 0 AND YEAR(fecha) >= '$periodo' ORDER BY fecha,hora DESC;"; } $bati = new Batimetria($id, $conn); $batimetria = $bati->getBatimetria(); $res = mysqli_query($conn, $aux); $r = mysqli_query($conn, "SELECT cota_min,cota_nor,cota_max FROM embalses WHERE estatus = 'activo' AND id_embalse = '$id';"); $count = mysqli_num_rows($r); if ($count >= 1) { $count = mysqli_num_rows($res); if ($count >= 1) { function obtenerEtiquetas($y) { $etiquetas = array(); $meses = range(1, 12); foreach ($meses as $mes) { /*$primerDia = strftime('%b', strtotime("$y-$mes-01")) . date('-01', strtotime("$y-$mes-01")); $ultimoDia = strftime('%b', strtotime("$y-$mes-01")) . date('-t', strtotime("$y-$mes-01"));*/ $primerDia = date('M-d', strtotime("$y-$mes-01")); $ultimoDia = date('M-t', strtotime("$y-$mes-01")); $etiquetas[] = "(" . $primerDia . "/" . $ultimoDia . ")"; } $etiquetas[count($etiquetas) - 1] = rtrim(end($etiquetas), ','); echo json_encode($etiquetas); } $count = mysqli_num_rows($res); $datos_embalses = mysqli_fetch_all($res, MYSQLI_ASSOC); $embalses = mysqli_fetch_all($r, MYSQLI_ASSOC); ?>
No hay datos registrados en el embalse
'; } } else { echo '
Error:Embalse inactivo o inexistente
'; } closeConection($conn); ?>