query("SELECT COUNT(*) AS cnt FROM tb_cotizaciones WHERE idEstado = 3")->fetch_assoc()['cnt'];
$ventasProc = $conn->query("SELECT COUNT(*) AS cnt FROM tb_ventas WHERE idEstado = 1")->fetch_assoc()['cnt'];
$ventasSinEnvio = $conn->query("SELECT COUNT(*) AS cnt FROM tb_ventas v LEFT JOIN tb_envios e ON v.id=e.idVenta WHERE e.id IS NULL")->fetch_assoc()['cnt'];
$pedidosProc = $conn->query("SELECT COUNT(*) AS cnt FROM tb_ordenes_de_compra WHERE idEstadoOrden = 1")->fetch_assoc()['cnt'];
$pedidosPorRecoger = $conn->query("SELECT COUNT(*) AS cnt FROM tb_ordenes_de_compra WHERE idEstadoOrden = 2")->fetch_assoc()['cnt'];
$pedidosPorCruzar = $conn->query("SELECT COUNT(*) AS cnt FROM tb_ordenes_de_compra WHERE idEstadoOrden = 4")->fetch_assoc()['cnt'];
$productosSolicit = $conn->query("
SELECT COUNT(*) AS cnt
FROM tb_productos_variantes pv
LEFT JOIN (
SELECT idProductoVariante, SUM(cantidad) AS total_compras
FROM tb_ordenes_de_compra_detalle GROUP BY idProductoVariante
) c ON c.idProductoVariante = pv.id
LEFT JOIN (
SELECT idProductoVariante, SUM(cantidad) AS total_ventas
FROM tb_ventas_detalle GROUP BY idProductoVariante
) v ON v.idProductoVariante = pv.id
WHERE pv.referenciaCPN NOT LIKE 'CPN-M%'
AND pv.referenciaCPN NOT LIKE 'CPN-S%'
AND COALESCE(c.total_compras,0)-COALESCE(v.total_ventas,0) < 0
")->fetch_assoc()['cnt'];
$impresionesProc = $conn->query("SELECT COUNT(*) AS cnt FROM tb_impresores_trabajos WHERE idEstadoTrabajo < 5")->fetch_assoc()['cnt'];
$prodPendientes = $conn->query("SELECT COUNT(*) AS cnt FROM tb_productos WHERE idEstado = 3")->fetch_assoc()['cnt'];
$prodChecklist = $conn->query("SELECT COUNT(*) AS cnt FROM tb_productos WHERE checklistStatus = 0")->fetch_assoc()['cnt'];
?>
Tablero de Control