<?php
$queryAsis = mysqli_query($connect,"SELECT id FROM Asistentes ");
$queryActv = mysqli_query($connect,"SELECT id FROM Agenda ");
$querySpe = mysqli_query($connect,"SELECT id FROM Conferencistas ");
$queryNuevos = mysqli_query($connect,"SELECT id FROM Asistentes WHERE tratamientos = 'on' ");
$completo = 0;
$queryPreregistro = mysqli_query($connect,"SELECT * FROM Asistentes WHERE origen = 1 ");
while($dataPreregistro = mysqli_fetch_array($queryPreregistro)){
if( $dataPreregistro["tratamientos"] == "on" ){
$completo ++;
}
}
?>
<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">
<canvas id="canvas" style="width:100%; height:300px"></canvas>
</div>
</div>
</div>
<!-- FICHA -->
<div class="col-md-6">
<table width="100%" style="background-color: #ff5a23; color: #ffffff;">
<tr>
<td width="100" style="padding: 15px; background-color: rgba(0,0,0,0.2);">
<i class="fa fa-user btn-left" style=" font-size: 60px "></i>
</td>
<td align="center" style="font-size: 20px; line-height: 35px;">
Personas totales en bases de datos<br>
<b style="font-size: 50px;"><?php echo $queryAsis->num_rows; ?></b>
<div style="margin-top: 3px; margin-bottom: 3px">
<a href="<?php echo $url_admin; ?>/?pg=asistentes">
<input type="button" class="btn btn-light btn-sm" value="Detalle">
</a>
</div>
</td>
</tr>
</table>
</div>
<!-- FICHA -->
<div class="col-md-6">
<table width="100%" style="background-color: #3F51B5; color: #ffffff;">
<tr>
<td width="100" style="padding: 15px; background-color: rgba(0,0,0,0.2);">
<i class="fa fa-address-book btn-left" style=" font-size: 60px "></i>
</td>
<td align="center" style="font-size: 20px; line-height: 35px;">
No. de personas que completaron registro para el evento - leads<br>
<b style="font-size: 50px;"><?php echo $queryNuevos->num_rows+$completo; ?></b>
<div style="margin-top: 3px; margin-bottom: 3px">
<a href="<?php echo $url_admin; ?>/?pg=registrados">
<input type="button" class="btn btn-light btn-sm" value="Detalle">
</a>
</div>
</td>
</tr>
</table>
</div>
<!-- FICHA -->
<div class="col-md-12" align="center">
<h1>Detallado</h1>
</div>
<!-- FICHA -->
<div class="col-md-4">
<table width="100%" style="background-color: #607d8b; color: #ffffff;">
<tr>
<td width="100" style="padding: 15px; background-color: rgba(0,0,0,0.2);">
<i class="fa fa-address-book btn-left" style=" font-size: 60px "></i>
</td>
<td align="center" style="line-height: 16px; font-size: 12px;">
No. de personas de la base de datos que NO completaron registro para el evento - Remarketing<br>
<b style="font-size: 20px;"><?php echo $queryPreregistro->num_rows - $completo; ?></b>
<div style="margin-top: 3px; margin-bottom: 3px">
<a href="<?php echo $url_admin; ?>/?pg=asistentes&fil=1">
<input type="button" class="btn btn-light btn-sm" value="Detalle">
</a>
</div>
</td>
</tr>
</table>
</div>
<!-- FICHA -->
<div class="col-md-4">
<table width="100%" style="background-color: #009688; color: #ffffff;">
<tr>
<td width="100" style="padding: 15px; background-color: rgba(0,0,0,0.2);">
<i class="fa fa-address-book btn-left" style=" font-size: 60px "></i>
</td>
<td align="center" style="line-height: 16px; font-size: 12px;">
No. de personas de la base de datos que completaron registro para el evento - Recurrentes<br>
<b style="font-size: 20px;"><?php echo $completo; ?></b>
<div style="margin-top: 3px; margin-bottom: 3px">
<a href="<?php echo $url_admin; ?>/?pg=asistentes&fil=2">
<input type="button" class="btn btn-light btn-sm" value="Detalle">
</a>
</div>
</td>
</tr>
</table>
</div>
<!-- FICHA -->
<div class="col-md-4">
<table width="100%" style="background-color: #ff9800; color: #ffffff;">
<tr>
<td width="100" style="padding: 15px; background-color: rgba(0,0,0,0.2);">
<i class="fa fa-address-book btn-left" style=" font-size: 60px "></i>
</td>
<td align="center" style="line-height: 16px; font-size: 12px;">
No. de personas nuevas que se registraron para este evento<br>
<b style="font-size: 20px;"><?php echo $queryNuevos->num_rows; ?></b>
<div style="margin-top: 3px; margin-bottom: 3px">
<a href="<?php echo $url_admin; ?>/?pg=asistentes&fil=3">
<input type="button" class="btn btn-light btn-sm" value="Detalle">
</a>
</div>
</td>
</tr>
</table>
</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>
