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"; break; case '09':$sql = "SELECT SUM(CASE WHEN SepLz > 0 THEN 1 ELSE 0 END) AS LZ_CTS, SUM(CASE WHEN SepMx > 0 THEN 1 ELSE 0 END) AS MX_CTS, SUM(CASE WHEN SepMz > 0 THEN 1 ELSE 0 END) AS MZ_CTS, SUM(CASE WHEN SepVe > 0 THEN 1 ELSE 0 END) AS VE_CTS, SUM(SepLz) AS LZ_MONTO, SUM(SepMx) AS MX_MONTO, SUM(SepMz) AS MZ_MONTO, SUM(SepVe) AS VE_MONTO FROM VT9000_IngresosPorClientePorMes"; break; case '10':$sql = "SELECT SUM(CASE WHEN OctLz > 0 THEN 1 ELSE 0 END) AS LZ_CTS, SUM(CASE WHEN OctMx > 0 THEN 1 ELSE 0 END) AS MX_CTS, SUM(CASE WHEN OctMz > 0 THEN 1 ELSE 0 END) AS MZ_CTS, SUM(CASE WHEN OctVe > 0 THEN 1 ELSE 0 END) AS VE_CTS, SUM(OctLz) AS LZ_MONTO, SUM(OctMx) AS MX_MONTO, SUM(OctMz) AS MZ_MONTO, SUM(OctVe) AS VE_MONTO FROM VT9000_IngresosPorClientePorMes"; break; default: $sql = "SELECT SUM(CASE WHEN OctLz > 0 THEN 1 ELSE 0 END) AS LZ_CTS, SUM(CASE WHEN OctMx > 0 THEN 1 ELSE 0 END) AS MX_CTS, SUM(CASE WHEN OctMz > 0 THEN 1 ELSE 0 END) AS MZ_CTS, SUM(CASE WHEN OctVe > 0 THEN 1 ELSE 0 END) AS VE_CTS, SUM(OctLz) AS LZ_MONTO, SUM(OctMx) AS MX_MONTO, SUM(OctMz) AS MZ_MONTO, SUM(OctVe) AS VE_MONTO FROM VT9000_IngresosPorClientePorMes"; break; } } else { $sql = "SELECT SUM(CASE WHEN OctLz > 0 THEN 1 ELSE 0 END) AS LZ_CTS, SUM(CASE WHEN OctMx > 0 THEN 1 ELSE 0 END) AS MX_CTS, SUM(CASE WHEN OctMz > 0 THEN 1 ELSE 0 END) AS MZ_CTS, SUM(CASE WHEN OctVe > 0 THEN 1 ELSE 0 END) AS VE_CTS, SUM(OctLz) AS LZ_MONTO, SUM(OctMx) AS MX_MONTO, SUM(OctMz) AS MZ_MONTO, SUM(OctVe) AS VE_MONTO FROM VT9000_IngresosPorClientePorMes"; } //Ejecutar Query $result = sqlsrv_query($con_comercial, $sql); ?>

INGRESOS 2018

Actualizar Hermes Movil Jaguar
0){ $promedio_total = number_format($total_MONTO/$total_CTS); } if($total_MONTO > 0){ $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, '.', ''); } else { $porcent_mz = "Sin Operaciones por el momento 0"; $porcent_lz = "Sin Operaciones por el momento 0"; $porcent_mx = "Sin Operaciones por el momento 0"; $porcent_ve = "Sin Operaciones por el momento 0"; } $promemp_mz = number_format($row["MZ_MONTO"]/46); $promemp_lz = number_format($row["LZ_MONTO"]/8); $promemp_mx = number_format($row["MX_MONTO"]/11); $promemp_ve = number_format($row["VE_MONTO"]/7); $total_promemp = number_format($total_MONTO/72); $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 "". "". "". "". "". ""; echo "". "". "". "". "". ""; echo "". "". "". "". "". ""; echo "". "". "". "". "". ""; $total_porcent = $porcent_mz+$porcent_lz+$porcent_mx+$porcent_ve; echo "". "". "". "". "". ""; sqlsrv_free_stmt($result); sqlsrv_close($con_comercial); ?>
Sucursal Empleados Clientes %
Manzanillo48".$row['MZ_CTS']."".$porcent_mz." %
Lázaro Cárdenas7".$row['LZ_CTS']."".$porcent_lz." %
México11".$row['MX_CTS']."".$porcent_mx." %
Veracruz7".$row['VE_CTS']."".$porcent_ve." %
Total72".$total_CTS."".$total_porcent." %

No. de Clientes

Porcentaje de Participación


Fatal error: Uncaught Error: Call to undefined function microtime_float() in C:\xampp73\htdocs\direccion\ingresos.php:318 Stack trace: #0 {main} thrown in C:\xampp73\htdocs\direccion\ingresos.php on line 318