include('../engine/connect.php');
$sql = "SELECT * FROM VT9000_IngresosPorClientePorMesAgoVe ORDER BY AgoVe DESC";
$sql2 = "SELECT
SUM(CASE WHEN AgoLz > 0 THEN 1 ELSE 0 END) AS LZ_CTS,
SUM(CASE WHEN AgoMx > 0 THEN 1 ELSE 0 END) AS MX_CTS,
SUM(CASE WHEN AgoMz > 0 THEN 1 ELSE 0 END) AS MZ_CTS,
SUM(CASE WHEN AgoVe > 0 THEN 1 ELSE 0 END) AS VE_CTS,
SUM(AgoLz) AS LZ_MONTO,
SUM(AgoMx) AS MX_MONTO,
SUM(AgoMz) AS MZ_MONTO,
SUM(AgoVe) AS VE_MONTO
FROM VT9000_IngresosPorClientePorMes";
//Ejecutar Query
$result = sqlsrv_query($con_comercial, $sql);
$result2 = sqlsrv_query($con_comercial, $sql2);
?>
No |
Cliente |
Porcentaje |
$self = $_SERVER['PHP_SELF'];
header("refresh:1800; url=$self");
$i = 0;
$x = 0;
$total = 0;
$row2 = sqlsrv_fetch_array($result2);
$total_MONTO = $row2['VE_MONTO'];
$total_MONTO = number_format($total_MONTO);
echo "".
"".$row2['VE_CTS']." | ".
"Total | ".
"".(100 * $row2['VE_MONTO'])/$row2['VE_MONTO']." % | ";
while($row = sqlsrv_fetch_array($result)){
$monto = number_format($row['AgoVe'],2);
$porcent = (100 * $row['AgoVe'])/$row2['VE_MONTO'];
$porcent = number_format($porcent, 2);
$i = $i + 1;
echo "
".
"".$i." | ".
"".$row["Cliente"]." | ".
"".$porcent." % | ".
"
";
}
sqlsrv_free_stmt($result);
sqlsrv_free_stmt($result2);
sqlsrv_close($con_comercial);
?>