";
echo "";
$result1 = mysqli_query($enlace, "SELECT COUNT(*) as TotalRegistros FROM unicuadro");
echo "";
echo "";
echo "| Registros Totales | ";
echo " ";
while ($row = mysqli_fetch_array($result1)){
echo "";
echo "| ".$row['TotalRegistros']." | ";
echo " ";
}
echo " ";
echo " | ";
//Ordenes Cumplidas
echo "";
$result2 = mysqli_query($enlace, "SELECT COUNT(pedido) as Cumplidas FROM unicuadro where Fecha_EA_Almacen<=Fecha_EA_Pintura");
echo "";
echo "";
echo "| Ordenes Cumplidas | ";
echo " ";
while ($row = mysqli_fetch_array($result2)){
echo "";
echo "| ".$row['Cumplidas']." | ";
echo " ";
}
echo " ";
echo " | ";
//Ordenes En Proceso
echo "";
$result4 = mysqli_query($enlace, "SELECT COUNT(Pedido) as Proceso FROM unicuadro where isnull(Fecha_EA_Almacen) and Fecha_EA_Pintura>'$today'");
echo "";
echo "";
echo "| Ordenes En Proceso | ";
echo " ";
while ($row = mysqli_fetch_array($result4)){
echo "";
echo "| ".$row['Proceso']." | ";
echo " ";
}
echo " ";
echo " | ";
//Ordenes no Cumplidas
echo "";
$result3 = mysqli_query($enlace, "SELECT COUNT(Pedido) as NoCumplidas FROM unicuadro where Fecha_EA_Pintura<=Fecha_EA_Almacen");
echo "";
echo "";
echo "| Ordenes no Cumplidas | ";
echo " ";
while ($row = mysqli_fetch_array($result3)){
echo "";
echo "| ".$row['NoCumplidas']." | ";
echo " ";
}
echo " ";
echo " | ";
//Ordenes Vencidas
echo "";
$result4 = mysqli_query($enlace, "SELECT COUNT(Pedido) as vencidas FROM unicuadro where isnull(Fecha_EA_Almacen) and Fecha_EA_Pintura<'$today'");
echo "";
echo "";
echo "| Ordenes Vencidas | ";
echo " ";
while ($row = mysqli_fetch_array($result4)){
echo "";
echo "| ".$row['vencidas']." | ";
echo " ";
}
echo " ";
echo " | ";
//Ordenes no Asignadas
echo "";
$result5 = mysqli_query($enlace, "SELECT COUNT(Pedido) as NoAsignadas FROM unicuadro where isnull(Fecha_EA_Pintura) ");
echo "";
echo "";
echo "| Ordenes no Asignadas | ";
echo " ";
while ($row = mysqli_fetch_array($result5)){
echo "";
echo "| ".$row['NoAsignadas']." | ";
echo " ";
}
echo " ";
echo " |
";
echo "