| 1 | <?php |
| 2 | |
| 3 | require_once __DIR__ . "/../libservidorphp/manejaErrores.php"; |
| 4 | require_once __DIR__ . "/../libservidorphp/recibeEnteroObligatorio.php"; |
| 5 | require_once __DIR__ . "/../libservidorphp/validaEntidadObligatoria.php"; |
| 6 | require_once __DIR__ . "/../libservidorphp/devuelveJson.php"; |
| 7 | require_once __DIR__ . "/Bd.php"; |
| 8 | require_once __DIR__ . "/productoBusca.php"; |
| 9 | require_once __DIR__ . "/ventaEnCapturaBusca.php"; |
| 10 | |
| 11 | $prodId = recibeEnteroObligatorio("prodId"); |
| 12 | |
| 13 | $bd = Bd::conexion(); |
| 14 | |
| 15 | $venta = ventaEnCapturaBusca($bd); |
| 16 | $venta = validaEntidadObligatoria("Venta en captura", $venta); |
| 17 | |
| 18 | $producto = productoBusca($bd, $prodId); |
| 19 | $producto = validaEntidadObligatoria("Producto", $producto); |
| 20 | |
| 21 | $stmt = $bd->prepare( |
| 22 | "SELECT * |
| 23 | FROM DET_VENTA |
| 24 | WHERE DTV_VNT_ID = :DTV_VNT_ID AND DTV_PRD_ID = :DTV_PRD_ID" |
| 25 | ); |
| 26 | $stmt->execute([":DTV_VNT_ID" => $venta["VNT_ID"], ":DTV_PRD_ID" => $prodId]); |
| 27 | $detVenta = $stmt->fetch(PDO::FETCH_ASSOC); |
| 28 | $detVenta = validaEntidadObligatoria("Detalle de venta", $detVenta); |
| 29 | |
| 30 | devuelveJson([ |
| 31 | "prodId" => ["value" => $prodId], |
| 32 | "prodNombre" => ["value" => $producto["PRD_NOMBRE"]], |
| 33 | "precio" => ["value" => "$" . number_format($detVenta["DTV_PRECIO"], 2)], |
| 34 | "cantidad" => ["valueAsNumber" => $detVenta["DTV_CANTIDAD"]], |
| 35 | ]); |
| 36 | |