E. php / usuario-modifica.php

1
<?php
2
3
require_once __DIR__ . "/lib/manejaErrores.php";
4
require_once __DIR__ . "/lib/recibeEnteroObligatorio.php";
5
require_once __DIR__ . "/lib/recibeTextoObligatorio.php";
6
require_once __DIR__ . "/lib/recibeArray.php";
7
require_once __DIR__ . "/lib/usuRolAgrega.php";
8
require_once __DIR__ . "/lib/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::pdo();
18
$bd->beginTransaction();
19
20
$stmt = $bd->prepare(
21
 "UPDATE USUARIO
22
   SET
23
    USU_SAN = :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
34
usuRolAgrega($bd, $usuId, $rolIds);
35
36
$bd->commit();
37
38
devuelveJson([
39
 "id" => ["value" => $usuId],
40
 "san" => ["value" => $san],
41
 "roles" => ["innerHTML" =>  rolCheckboxes()],
42
 "rolIds" => ["value" => $rolIds],
43
]);
44
skip_previous skip_next