function getOrderDetail($link, $order)
{
include 'config.php';
$handle = $link->prepare('SELECT articulo code, cantidadPendiente requestQuantity, renglon row FROM ' . $table_inventory_detail . ' WHERE ID = :id');
$handle->bindParam(':id', $order->id);
$handle->execute();
$company = $order->company;
$warehouse = $order->warehouse;
if ($orderDetails = $handle->fetchAll(PDO::FETCH_OBJ)) {
$detailsLen = count($orderDetails);
for ($i = 0; $i < $detailsLen; $i++) {
$productCode = $orderDetails[$i]->code;
$orderDetails[$i]->barcodes = getProductBarCodes($link, $productCode);
$orderDetails[$i]->inventoryQuantity = getInventoryQuantity($link, $company, $warehouse, $productCode);
}
}
return $orderDetails;
}
function getOrderDetail($link, $order)
{
include 'config.php';
$handle = $link->prepare('SELECT invD.articulo code, invD.cantidad requestQuantity, invD.renglon row, invExistence.inventario inventoryQuantity FROM ' . $table_inventory_detail . ' invD JOIN ' . $table_article . ' art ON invD.articulo = art.articulo JOIN ' . $table_inventory_existence . ' invExistence ON invD.Articulo=invExistence.Articulo AND invExistence.Almacen=invD.Almacen WHERE invD.id = :id AND invD.seccion IS NULL AND invExistence.inventario > 0 ORDER BY art.fabricante, invD.articulo');
$handle->bindParam(':id', $order->id);
$handle->execute();
//$company = $order->company;
//$warehouse = $order->warehouse;
if ($orderDetails = $handle->fetchAll(PDO::FETCH_OBJ)) {
$detailsLen = count($orderDetails);
error_log(json_encode($detailsLen));
for ($i = 0; $i < $detailsLen; $i++) {
$productCode = $orderDetails[$i]->code;
$orderDetails[$i]->barcodes = getProductBarCodes($link, $productCode);
//$orderDetails[$i]->inventoryQuantity = getInventoryQuantity($link, $company, $warehouse , $productCode);
}
}
return $orderDetails;
}
