| 1 | <?php |
| 2 | |
| 3 | require_once __DIR__ . "/../lib/php/ejecutaServicio.php"; |
| 4 | require_once __DIR__ . "/../lib/php/select.php"; |
| 5 | require_once __DIR__ . "/../lib/php/devuelveJson.php"; |
| 6 | require_once __DIR__ . "/Bd.php"; |
| 7 | require_once __DIR__ . "/TABLA_PRODUCTO.php"; |
| 8 | require_once __DIR__ . "/TABLA_ARCHIVO.php"; |
| 9 | |
| 10 | ejecutaServicio(function () { |
| 11 | |
| 12 | $lista = select(pdo: Bd::pdo(), from: PRODUCTO, orderBy: PROD_NOMBRE); |
| 13 | |
| 14 | $render = ""; |
| 15 | foreach ($lista as $modelo) { |
| 16 | $prodId = htmlentities($modelo[PROD_ID]); |
| 17 | $prodNombre = htmlentities($modelo[PROD_NOMBRE]); |
| 18 | $encodeArchId = $modelo[ARCH_ID] === null ? "" : urlencode($modelo[ARCH_ID]); |
| 19 | $archId = $encodeArchId === "" ? "" : htmlentities($encodeArchId); |
| 20 | $src = $archId === "" ? "" : "srv/archivo.php?id=$archId"; |
| 21 | $render .= |
| 22 | "<div style='display: flex; flex-direction: row-reverse; |
| 23 | align-items: center; gap: 0.5rem'> |
| 24 | <dt style='flex: 1 1 0'> |
| 25 | <a href='modifica.html?id=$prodId'>$prodNombre</a> |
| 26 | </dt> |
| 27 | <dd style='flex: 1 1 0; margin: 0'> |
| 28 | <a href='modifica.html?id=$prodId'><img |
| 29 | style='width: 100%; aspect-ratio:16/9; object-fit: cover' |
| 30 | alt='Imagen del producto' src='$src'></a> |
| 31 | </dd> |
| 32 | </div>"; |
| 33 | } |
| 34 | |
| 35 | devuelveJson(["lista" => ["innerHTML" => $render]]); |
| 36 | }); |
| 37 | |