E. api / usuario-modifica.php

1
<?php
2
3
require_once __DIR__ . "/../libservidorphp/manejaErrores.php";
4
require_once __DIR__ . "/../libservidorphp/recibeEnteroObligatorio.php";
5
require_once __DIR__ . "/../libservidorphp/recibeTextoObligatorio.php";
6
require_once __DIR__ . "/../libservidorphp/recibeArray.php";
7
require_once __DIR__ . "/../libservidorphp/usuRolAgrega.php";
8
require_once __DIR__ . "/../libservidorphp/devuelveJson.php";
9
require_once __DIR__ . "/Bd.php";
10
require_once __DIR__ . "/usuRolElimina.php";
11
require_once __DIR__ . "/rolCheckboxes.php";
12
13
$usuId = recibeEnteroObligatorio("id");
14
$san = recibeTextoObligatorio("san");
15
$rolIds = recibeArray("rolIds");
16
17
$bd = Bd::conexion();
18
$bd->beginTransaction();
19
20
$stmt = $bd->prepare(
21
 "UPDATE USUARIO
22
   SET
23
    USU_SAN = TRIM(:USU_SAN)
24
   WHERE
25
    USU_ID = :USU_ID"
26
);
27
$stmt->execute([
28
 ":USU_SAN" => $san,
29
 ":USU_ID" => $usuId,
30
]);
31
32
usuRolElimina($bd, $usuId);
33
usuRolAgrega($bd, $usuId, $rolIds);
34
35
$bd->commit();
36
37
devuelveJson([
38
 "id" => ["value" => $usuId],
39
 "san" => ["value" => $san],
40
 "roles" => ["innerHTML" =>  rolCheckboxes()],
41
 "rolIds" => ["value" => $rolIds],
42
]);
43
skip_previous skip_next