";
}
// Procesar búsqueda de factura
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['id_factura'])) {
$id_factura = $_POST['id_factura'];
// Consulta SQL para obtener los detalles del pedido
$sql = "SELECT
cd.rowid AS id_linea,
s.nom AS Cliente,
c.rowid AS id_pedido,
c.ref AS Ref_Pedido,
c.date_creation AS Fecha_Creacion,
p.rowid AS id_producto,
p.label AS Producto,
cd.description AS descripcion,
cd.qty AS Cantidad,
u.nom_unidad AS Tipo_despacho,
extra2.cantidad_despacho AS Cantidad_Despacho,
c.fk_statut AS Estado_Pedido
FROM
llx_element_element AS ee
INNER JOIN
llx_commande AS c ON ee.fk_source = c.rowid
INNER JOIN
llx_societe AS s ON c.fk_soc = s.rowid
INNER JOIN
llx_commandedet AS cd ON c.rowid = cd.fk_commande
LEFT JOIN
llx_projet AS pj ON c.fk_projet = pj.rowid
LEFT JOIN
llx_user AS uc ON c.fk_user_author = uc.rowid
LEFT JOIN
llx_user AS uv ON c.fk_user_valid = uv.rowid
LEFT JOIN
llx_commande_extrafields AS extra ON c.rowid = extra.fk_object
LEFT JOIN
llx_commandedet_extrafields AS extra2 ON cd.rowid = extra2.fk_object
LEFT JOIN
llx_udd AS u ON extra2.cestas = u.cod_unidad
LEFT JOIN
llx_product AS p ON cd.fk_product = p.rowid
LEFT JOIN
llx_product_extrafields AS extra3 ON p.rowid = extra3.fk_object
WHERE
ee.fk_target = '$id_factura'
AND ee.targettype = 'facture'
AND c.entity IN (1)";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Asignar valores a las variables (solo para la primera fila)
$row = $result->fetch_assoc();
$Pcantidad = $row['Cantidad'];
$Prowid = $row['id_producto'];
$Corigen = $row['id_pedido'];
$estadoPedido = $row['Estado_Pedido']; // Obtener el estado del pedido
// Reiniciar el puntero del resultado para iterar desde el principio
$result->data_seek(0);
}
}
?>
Sistema de Gestión de Pedidos
