| 1 | <?php |
| 2 | |
| 3 | require_once __DIR__ . "/../lib/php/ejecutaServicio.php"; |
| 4 | require_once __DIR__ . "/../lib/php/recuperaIdEntero.php"; |
| 5 | require_once __DIR__ . "/../lib/php/selectFirst.php"; |
| 6 | require_once __DIR__ . "/../lib/php/delete.php"; |
| 7 | require_once __DIR__ . "/../lib/php/devuelveNoContent.php"; |
| 8 | require_once __DIR__ . "/Bd.php"; |
| 9 | require_once __DIR__ . "/TABLA_PRODUCTO.php"; |
| 10 | require_once __DIR__ . "/TABLA_ARCHIVO.php"; |
| 11 | |
| 12 | ejecutaServicio(function () { |
| 13 | |
| 14 | $prodId = recuperaIdEntero("id"); |
| 15 | |
| 16 | $pdo = Bd::pdo(); |
| 17 | $pdo->beginTransaction(); |
| 18 | |
| 19 | $producto = |
| 20 | selectFirst(pdo: $pdo, from: PRODUCTO, where: [PROD_ID => $prodId]); |
| 21 | if ($producto !== false) { |
| 22 | delete(pdo: $pdo, from: PRODUCTO, where: [PROD_ID => $prodId]); |
| 23 | if ($producto[ARCH_ID] !== null) { |
| 24 | delete(pdo: $pdo, from: ARCHIVO, where: [ARCH_ID => $producto[ARCH_ID]]); |
| 25 | } |
| 26 | } |
| 27 | |
| 28 | $pdo->commit(); |
| 29 | |
| 30 | devuelveNoContent(); |
| 31 | }); |
| 32 | |