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 |
Monto |
Porcentaje |
".
"".$row2['LZ_CTS']." | ".
"Total | ".
"$".$total_MONTO." | ".
"".(100 * $row2['LZ_MONTO'])/$row2['LZ_MONTO']." % | ";
while($row = sqlsrv_fetch_array($result)){
$monto = number_format($row['AgoLz'],2);
$porcent = (100 * $row['AgoLz'])/$row2['LZ_MONTO'];
$porcent = number_format($porcent, 2);
$i = $i + 1;
echo "".
"| ".$i." | ".
"".$row["Cliente"]." | ".
"".$monto." | ".
"".$porcent." % | ".
"
";
}
sqlsrv_free_stmt($result);
sqlsrv_free_stmt($result2);
sqlsrv_close($con_comercial);
?>