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; }