<?php include 'sesion.php';?>
<?php include 'concha.php';
$mes = $_POST['mes'];
$ano = $_POST['ano'];
?>
<!DOCTYPE html>
<html lang="es">
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<!-- Required meta tags -->

	<meta name="description" content="Panel de Administracion">
	<meta name="author" content="<?php echo $nombresitio ?>">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <title><?php echo $nombresitio ?> - Panel de Administracion</title>
  <!--link href='http://fonts.googleapis.com/css?family=Oswald' rel='stylesheet' type='text/css'-->
  <link href="https://fonts.googleapis.com/css?family=Montserrat:100,100i,200,200i,300,300i,400,400i,500,500i,600,600i,700,700i,800,800i,900&display=swap" rel="stylesheet">
  <link rel="shortcut icon" href="" type="image/x-icon">
	<link rel="apple-touch-icon" href="">

	<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
  <!-- Link to your css file -->
	<link rel="stylesheet" href="">
<script src="https://code.jquery.com/jquery-3.4.1.min.js" integrity="sha256-CSXorXvZcTkaix6Yvo6HppcZGetbYMGWSFlBw8HfCJo=" crossorigin="anonymous"></script>
  <!--script type="text/javascript" src="//recursos.radiosnethosting.com/ckeditor/ckeditor.js"></script-->
 <script type="text/javascript" src="https://www.google.com/jsapi"></script>
    <style>

        .carousel-cell {
          width: 66%;
          margin-right: 5px;
        }

        .display-flex{
            display: flex;
            justify-content: center;
            align-items: center;
        }

        *{
            border-radius: 0!important;

        }

        body {
            background-image: url(../fondeux.jpg);
            background-position:top center;
            background-repeat: repeat-x;
            background-color:#EBEBEB;
            height:100%;
        }

        .btn, a, h1, h2, h3, h4, h5, h6, b{
          font-family: 'Montserrat', sans-serif;
        }

        .btn, h1, h2, h3, h4, h5, h6 {
          font-weight: 600;
        }

        .navbar {
            position: relative;
        min-height: 50px;
        padding-bottom:  20px;
        /* border: 1px solid transparent; */

        }

      .btn-primary {
        color: #fff!important;
        background-color: #0066FF;
        border-color: #0066FF;
            }

        .page-header{
            margin: 0;
            padding: 1em;
            background-color: #0066FF;
            border: 0;
            text-align:center;
        }

        .page-header h2{

            color: #ffffff;
            font-weight: bold;
        }

        .bloqueAzul{
          /*  background-color: #0066FF;*/
          /* border: 1px solid #e4e4e4;*/
          /*  padding: 1em;*/
            text-align: center;
        }

        .bloqueAzul .div {
          border: 1px solid #e4e4e4;
            background-color: #fff;
        }

        ul{
            list-style: none;
            padding: 0;
        }

        .far{
            color:#0066FF;
        }
        .faso {
            color:#fff;
        }

        .colorAzul h3{
            color:#0066FF;

        }

    </style>

    <script language=javascript>
      function ventanaSecundaria (URL){
        window.open(URL,"ventana1","width=550,height=450,scrollbars=NO")
      }
    </script>

</head>

<body>

<div class="container" style="background-color:#F1F2ED;">



        <?php include 'menu.php';  ?>



</div>

<div role="main" style="background-color:#fff;" class="container pt-3">

            <div class="page-header" style="text-align:center;">

                <h2><? echo $asd6 ?>Estadísticas</h2>

            </div>

        <div class="col-12">


          <div align="center" class="col-12">


        <p>&nbsp;</p>

        <form id="form2" name="form2" method="post" action="ver_estadisticas.php">
          <p>

             <select name="mes" class="form-control" id="mes">
                        <?php
  $M1 = date('m');
  $i = 0;
  while($i <= 11) { $i += 1;
?>
                        <option  <?php if ($M1 == $i) {?> selected="selected" <? } else {};?>><?php echo $i ?></option>
                        <? } ?>
                      </select>
                      <select name="ano" class="form-control" id="ano">
                        <?php
  $A1 = date('Y');
  $i = 2008;
  while($i <= 2035){$i += 1;
?>
                        <option  <?php if ($A1 == $i) {?> selected="selected" <? } else {};?>><?php echo $i ?></option>
                        <? } ?>
                      </select>


          </p>
          <p>
            <input name="button" type="submit" class="btn btn-outline-primary" id="button" value="VER ESTADISTICAS" />
          </p>
        </form>
        <p><HR /></p>
        <p>MES <?php echo $mes  ?> / Año <?php echo $ano ?></p>
        <p>





    <div id="chart_div" style="width: 900px; height: 500px;"></div>
  </body>
</html>




<table width="20%" border="1" cellspacing="0" cellpadding="0">
               <tr>
    <td>DIA</td>
    <td>VISITAS</td>
  </tr>

<?php $N = 0;
include('concha.php');


$sql = "SELECT * FROM visitas WHERE m = '$mes' AND a = '$ano' ORDER BY d";

$consulta = $conn->query($sql);
while ($row = $consulta->fetch_assoc())
{
$n = $row["n"];
$d = $row["d"];

$tot = $tot + $n;
?>

  <tr>
    <td><?php echo $d ?></td>
    <td><?php echo $n ?></td>
  </tr>



  <?
}
$consulta->free_result();?>


       </table>
TOTAL VISITAS MES: <?php echo $tot ?>

        </p>
        <p>&nbsp;</p>
      </div></td>

      </div>
</div>

<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>


 <script type="text/javascript">
      google.load("visualization", "1", {packages:["corechart"]});
      google.setOnLoadCallback(drawChart);
      function drawChart() {
        var data = google.visualization.arrayToDataTable([
          ['DIA', 'VISITAS'],


<?php $N = 0;
include('concha.php');


$sql = "SELECT * FROM visitas WHERE m = '$mes' AND a = '$ano' ORDER BY d";

$consulta = $conn->query($sql);
while ($row = $consulta->fetch_assoc())
{
$n = $row["n"];
$d = $row["d"];

?>


 ['<?php echo $d ?>',  <?php echo $n ?>],

  <?}$consulta->free_result();?>




        ]);

        var options = {
          title: 'Estadisticas mes <?php echo $mes ?> / Año <?php echo $ano ?>',
          hAxis: {title: 'DIA',  titleTextStyle: {color: '#333'}},
          vAxis: {minValue: 0}
        };

        var chart = new google.visualization.AreaChart(document.getElementById('chart_div'));
        chart.draw(data, options);
      }
    </script>

 <script defer src="https://use.fontawesome.com/releases/v5.8.1/js/all.js" integrity="sha384-g5uSoOSBd7KkhAMlnQILrecXvzst9TdC09/VM+pjDTCM+1il8RHz5fKANTFFb+gQ" crossorigin="anonymous"></script>
</body>
</html>
