Sucursal |
Empleados |
Clientes |
Monto |
Prom. por Cliente |
Prom. por Empleado |
% |
/*
while($row = sqlsrv_fetch_array($result)){
if ($row["B"] > 1) {
echo "".
"".$row["CRAZONSOCIAL"]." | ".
"".$row["CFOLIO"]." | ".
"".$row["CFECHA"]." | ".
"".$row["B"]." | ".
"".$row["Total"]." | ".
"".$row["Doc"]." | ".
"
";
} else if ($row["B"] <= 1) {
echo "".
"".$row["CRAZONSOCIAL"]." | ".
"".$row["CFOLIO"]." | ".
"".$row["CFECHA"]." | ".
"".$row["B"]." | ".
"".$row["Total"]." | ".
"".$row["Doc"]." | ".
"
";
}
} */
$row = sqlsrv_fetch_array($result);
$total_CTS = $row['MZ_CTS'] + $row['LZ_CTS'] + $row['MX_CTS'] + $row['VE_CTS'];
$total_MONTO = $row['MZ_MONTO'] + $row['LZ_MONTO'] + $row['MX_MONTO'] + $row['VE_MONTO'];
$prom_mz = number_format((float)$row['MZ_MONTO']/$row['MZ_CTS'], 2, '.', '');
$prom_lz = number_format((float)$row['LZ_MONTO']/$row['LZ_CTS'], 2, '.', '');
$prom_mx = number_format((float)$row['MX_MONTO']/$row['MX_CTS'], 2, '.', '');
$prom_ve = number_format((float)$row['VE_MONTO']/$row['VE_CTS'], 2, '.', '');
$promedio_mz = number_format($prom_mz);
$promedio_lz = number_format($prom_lz);
$promedio_mx = number_format($prom_mx);
$promedio_ve = number_format($prom_ve);
$promedio_total = number_format($total_MONTO/$total_CTS);
$porcent_mz = ($row["MZ_MONTO"]/$total_MONTO)*100;
$porcent_mz = number_format((float)$porcent_mz, 2, '.', '');
$porcent_mx = ($row["MX_MONTO"]/$total_MONTO)*100;
$porcent_mx = number_format((float)$porcent_mx, 2, '.', '');
$porcent_lz = ($row["LZ_MONTO"]/$total_MONTO)*100;
$porcent_lz = number_format((float)$porcent_lz, 2, '.', '');
$porcent_ve = ($row["VE_MONTO"]/$total_MONTO)*100;
$porcent_ve = number_format((float)$porcent_ve, 2, '.', '');
$promemp_mz = number_format($row["MZ_MONTO"]/48);
$promemp_lz = number_format($row["LZ_MONTO"]/7);
$promemp_mx = number_format($row["MX_MONTO"]/11);
$promemp_ve = number_format($row["VE_MONTO"]/7);
$total_promemp = number_format($total_MONTO/73);
$row['MZ_MONTO'] = number_format($row['MZ_MONTO']);
$row['LZ_MONTO'] = number_format($row['LZ_MONTO']);
$row['MX_MONTO'] = number_format($row['MX_MONTO']);
$row['VE_MONTO'] = number_format($row['VE_MONTO']);
$total_MONTO = number_format($total_MONTO);
echo "".
"Manzanillo | ".
"48 | ".
"".$row['MZ_CTS']." | ".
"$".$row['MZ_MONTO']." | ".
"$".$promedio_mz." | ".
"$".$promemp_mz." | ".
"".$porcent_mz." % | ".
"
";
echo "".
"Lázaro Cárdenas | ".
"7 | ".
"".$row['LZ_CTS']." | ".
"$".$row['LZ_MONTO']." | ".
"$".$promedio_lz." | ".
"$".$promemp_lz." | ".
"".$porcent_lz." % | ".
"
";
echo "".
"México | ".
"11 | ".
"".$row['MX_CTS']." | ".
"$".$row['MX_MONTO']." | ".
"$".$promedio_mx." | ".
"$".$promemp_mx." | ".
"".$porcent_mx." % | ".
"
";
echo "".
"Veracruz | ".
"7 | ".
"".$row['VE_CTS']." | ".
"$".$row['VE_MONTO']." | ".
"$".$promedio_ve." | ".
"$".$promemp_ve." | ".
"".$porcent_ve." % | ".
"
";
echo "".
"Total | ".
"73 | ".
"".$total_CTS." | ".
"$".$total_MONTO." | ".
"$".$promedio_total." | ".
"$".$total_promemp." | ".
"100 % | ".
"
";
sqlsrv_free_stmt($result);
sqlsrv_close($con_comercial);
?>
Promedio Ingreso por Cliente
Porcentaje de Participación