<?php
    $id = $_GET["id"];
    $cant = $_GET["cant"];

    $filtro = " " ;
    if($_GET["ini"]){ $filtro .= " AND created_at >= '".$_GET["ini"]." 00:00:00' " ; } 
    if($_GET["ter"]){ $filtro .= " created_at <= '".$_GET["ter"]." 23:59:00' " ; } 

    $documentos = 0;
    $videos = 0;
    $chats = 0;
    $interactivo = 0;
    $documentos = 0;

    $queryStand = mysqli_query($connect,"SELECT * FROM Stands WHERE id = '".$id."' ");
    $dataStand = mysqli_fetch_array($queryStand);

	$queryAnalitica = mysqli_query($connect,"SELECT * FROM Analitica WHERE url = '".$id."' ".$filtro."  ");
	while($dataAnalitica = mysqli_fetch_array($queryAnalitica)){
		
		if($dataAnalitica["tipo"] == 1){ $documentos ++;}
        if($dataAnalitica["tipo"] == 2){ $videos ++;}
        if($dataAnalitica["tipo"] == 3){ $chats ++;}
        if($dataAnalitica["tipo"] == 5){ $interactivo ++;}
        if($dataAnalitica["tipo"] == 10){ $stand ++;}
	}
?>

<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.7.2/Chart.js"></script>
<div class="row" style="padding-top: 15px;">
    
    <!-- FICHA -->
	<div class="col-md-12" style="margin-bottom: 20px">
        <div class="card" align="center">
          <div class="card-body">
			<h1><?php echo $dataStand["nombre"]; ?></h1>
              Clicks en página <b><?php echo $cant; ?></b>
          </div>
        </div>
    </div>
    
    
    <!-- FICHA -->
	<div class="col-md-12" align="center">
        <h1>Interacciones</h1>
    </div>

    <!-- FICHA -->
	<div class="col-md-3">
        <table width="100%" style="background-color: #607d8b; color: #ffffff;">
			<tr>
				<td align="center" style="font-size: 20px; line-height: 35px;">
					Documentos<br>
					<b style="font-size: 50px;"><?php echo $documentos; ?></b>
				</td>
			</tr>
		</table>
    </div>
    
    
    <!-- FICHA -->
	<div class="col-md-3">
        <table width="100%" style="background-color: #607d8b; color: #ffffff;">
			<tr>
				<td align="center" style="font-size: 20px; line-height: 35px;">
					Videos<br>
					<b style="font-size: 50px;"><?php echo $videos; ?></b>
				</td>
			</tr>
		</table>
    </div>
    
    
    <!-- FICHA -->
	<div class="col-md-3">
        <table width="100%" style="background-color: #607d8b; color: #ffffff;">
			<tr>
				<td align="center" style="font-size: 20px; line-height: 35px;">
					Chats<br>
					<b style="font-size: 50px;"><?php echo $chats; ?></b>
				</td>
			</tr>
		</table>
    </div>
    
    <!-- FICHA -->
	<div class="col-md-3">
        <table width="100%" style="background-color: #607d8b; color: #ffffff;">
			<tr>
				<td align="center" style="font-size: 20px; line-height: 35px;">
					Interactivos<br>
					<b style="font-size: 50px;"><?php echo $interactivo; ?></b>
				</td>
			</tr>
		</table>
    </div>
    
	
	
	
	
	
	<!-- FICHA -->
	<div class="col-md-12" >
        
        <!-- INICIA -->
        <div class="card" style="margin-top: 20px">
            <div class="card-header">
                <h2>Descarga de documentos</h2>
            </div>
            <div class="card-body">
                <table class="table">
                  <thead>
                    <tr>
                      <th scope="col">#</th>
                      <th scope="col">Participante</th>
                      <th scope="col">Tipo</th>
                      <th scope="col">Fecha</th>
                    </tr>
                  </thead>
                  <tbody>
                      <?php
                        $count = 1;
                        $queryAna = mysqli_query($connect,"SELECT * FROM Analitica WHERE url = '".$id."' AND url = '".$id."' AND tipo = 1 ".$filtro." ");
                        while($dataAna = mysqli_fetch_array($queryAna)){

                            $queryUser = mysqli_query($connect,"SELECT * FROM Asistentes WHERE id = '".$dataAna["id_user"]."' ");
                            $dataUser = mysqli_fetch_array($queryUser);

                            echo '
                            <tr>
                              <th scope="row">'.$count.'</th>
                              <td>'.$dataUser["nombre"].'</td>
                              <td>'.$dataUser["titulo"].'</td>
                              <td>'.$dataAna["created_at"].'</td>
                            </tr>
                            ';
                            $count++;
                        }
                      ?>



                    </tbody>
                </table>
            </div>
        
        </div>
        <!-- TERMINA -->
        
        
        <!-- INICIA -->
        <div class="card" style="margin-top: 20px">
            <div class="card-header">
                <h2>Videos</h2>
            </div>
            <div class="card-body">
                <table class="table">
                  <thead>
                    <tr>
                      <th scope="col">#</th>
                      <th scope="col">Participante</th>
                      <th scope="col">Tipo</th>
                      <th scope="col">Fecha</th>
                    </tr>
                  </thead>
                  <tbody>
                      <?php
                        $count = 1;
                        $queryAna = mysqli_query($connect,"SELECT * FROM Analitica WHERE url = '".$id."' AND url = '".$id."' AND tipo = 2 ".$filtro." ");
                        while($dataAna = mysqli_fetch_array($queryAna)){

                            $queryUser = mysqli_query($connect,"SELECT * FROM Asistentes WHERE id = '".$dataAna["id_user"]."' ");
                            $dataUser = mysqli_fetch_array($queryUser);

                            echo '
                            <tr>
                              <th scope="row">'.$count.'</th>
                              <td>'.$dataUser["nombre"].'</td>
                              <td>Video</td>
                              <td>'.$dataAna["created_at"].'</td>
                            </tr>
                            ';
                            $count++;
                        }
                      ?>



                    </tbody>
                </table>
            </div>
        
        </div>
        <!-- TERMINA -->
        
        
        <!-- INICIA -->
        <div class="card" style="margin-top: 20px">
            <div class="card-header">
                <h2>Interacciones en Chat</h2>
            </div>
            <div class="card-body">
                <table class="table">
                  <thead>
                    <tr>
                      <th scope="col">#</th>
                      <th scope="col">Participante</th>
                      <th scope="col">Tipo</th>
                      <th scope="col">Fecha</th>
                    </tr>
                  </thead>
                  <tbody>
                      <?php
                        $count = 1;
                        $queryAna = mysqli_query($connect,"SELECT * FROM Analitica WHERE url = '".$id."' AND url = '".$id."' AND tipo = 3 ".$filtro." ");
                        while($dataAna = mysqli_fetch_array($queryAna)){

                            $queryUser = mysqli_query($connect,"SELECT * FROM Asistentes WHERE id = '".$dataAna["id_user"]."' ");
                            $dataUser = mysqli_fetch_array($queryUser);

                            echo '
                            <tr>
                              <th scope="row">'.$count.'</th>
                              <td>'.$dataUser["nombre"].'</td>
                              <td>Documentos</td>
                              <td>'.$dataAna["created_at"].'</td>
                            </tr>
                            ';
                            $count++;
                        }
                      ?>



                    </tbody>
                </table>
            </div>
        
        </div>
        <!-- TERMINA -->
        
        <!-- INICIA -->
        <div class="card" style="margin-top: 20px">
            <div class="card-header">
                <h2>Interactivos</h2>
            </div>
            <div class="card-body">
                <table class="table">
                  <thead>
                    <tr>
                      <th scope="col">#</th>
                      <th scope="col">Participante</th>
                      <th scope="col">Tipo</th>
                      <th scope="col">Fecha</th>
                    </tr>
                  </thead>
                  <tbody>
                      <?php
                        $count = 1;
                        $queryAna = mysqli_query($connect,"SELECT * FROM Analitica WHERE url = '".$id."' AND url = '".$id."' AND tipo = 5 ".$filtro." ");
                        while($dataAna = mysqli_fetch_array($queryAna)){

                            $queryUser = mysqli_query($connect,"SELECT * FROM Asistentes WHERE id = '".$dataAna["id_user"]."' ");
                            $dataUser = mysqli_fetch_array($queryUser);

                            echo '
                            <tr>
                              <th scope="row">'.$count.'</th>
                              <td>'.$dataUser["nombre"].'</td>
                              <td>Documentos</td>
                              <td>'.$dataAna["created_at"].'</td>
                            </tr>
                            ';
                            $count++;
                        }
                      ?>



                    </tbody>
                </table>
            </div>
        
        </div>
        <!-- TERMINA -->
        
        
        
    </div>


	
</div>


<style>
.col-md-4{
	margin-bottom:15px
}

.col-md-6{
	margin-bottom:15px
}

.btn-primary_blue{
	color: #fff;
    background-color: #2196f3;
    border-color: #2196f3;
}

</style>

<?php
$arrayFechas = array();
$arraycantidad = array();
$querySol = mysqli_query($connect,"SELECT COUNT(id),update_at FROM Asistentes WHERE acepto = 'on' GROUP BY DAYOFMONTH(update_at) ORDER BY update_at ASC  ");
while($dataSol = mysqli_fetch_array($querySol)){
    
    $fh = explode(" ", $dataSol["update_at"]);
	array_push($arrayFechas, $fh );
	array_push($arraycantidad, $dataSol["COUNT(id)"] );

}

?>

<script>
	var MONTHS = <?php echo json_encode($arrayFechas) ?>;
	var config = {
			type: 'line',
			data: {
				labels: MONTHS,
				datasets: [{
					label: 'Registros Días',
					backgroundColor: "#03A9F4",
					borderColor: "#035da5",
					data: <?php echo json_encode($arraycantidad) ?>,
					fill: false,
				}]
			},
			options: {
				responsive: true,
				title: {
					display: true,
					text: 'Registrados'
				},
				tooltips: {
					mode: 'index',
					intersect: false,
				},
				hover: {
					mode: 'nearest',
					intersect: true
				},
				scales: {
					x: {
						display: true,
						scaleLabel: {
							display: true,
							labelString: 'Month'
						}
					},
					y: {
						display: true,
						scaleLabel: {
							display: true,
							labelString: 'Value'
						}
					}
				}
			}
	};

	window.onload = function() {
		var ctx = document.getElementById('canvas').getContext('2d');
		window.myLine = new Chart(ctx, config);
	};

</script>




