<?php 
//=====================================================================================
//INICIO LA SESION---------------------------------------------------------------------
//=====================================================================================
session_start();
//=====================================================================================
//CONEXION-----------------------------------------------------------------------------
//=====================================================================================
require_once '../../../conn/conexion.php';
$bd = new connexion();
//=====================================================================================
//----------------VARIBLES-------------------------------------------------------------
//=====================================================================================
$app = "GESTOR_V";
$acc = $_POST["acc"];
$user = $_POST["user"];
$user_cod = $user[0];
$user_text = $_POST["user_text"];
//=====================================================================================
//----------------ACCIONES-------------------------------------------------------------
//=====================================================================================
//=====================================================================================
switch ($acc) {
    case 1:
        $exist = verificaExistenciaTablaAppsPermisos($bd, $app, $user_cod);
        if ($exist == 0) {
            insertUserAuth($bd, $app, $user_cod);
            $r_code = 400;
            $r_msg = "success : request success";
        }else {
            $r_code = 401;
            $r_msg = "error : user has auth already";
        }
        break;
    
    case 2:
        $exist = verificaExistenciaTablaAppsPermisos($bd, $app, $user_cod);
        if ($exist == 1) {
            $r_code = 400;
            deletetUserAuth($bd, $app, $user_cod);
            $r_msg = "success : request success";
        }else {
            $r_code = 401;
            $r_msg = "error : user has auth already";
        }
        break;
}
//=====================================================================================
//----------------RESPONSE-------------------------------------------------------------
//=====================================================================================

//$r_msg = "success : request success";
//RESPUESTA============================================================================
$response[] = array ( 
    "code" => $r_code,
    "message" => $r_msg,
);
mysqli_close($bd);
header("Content-type: application/json; charset=utf-8");
echo json_encode($response);
//=====================================================================================
//----------------FUNCIONES------------------------------------------------------------
//=====================================================================================
function verificaExistenciaTablaAppsPermisos($bd, $app, $user_cod)
{
    $sql =  "   SELECT COUNT(P.USUARIO) AS EXIST
                FROM APPS_PERMISOS P
                WHERE P.USUARIO = ? AND P.CLAVE = ?";
    $base = $bd->prepare($sql);
    $base->bind_param('ss', $user_cod, $app);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result["EXIST"];
}
function insertUserAuth($bd, $app, $user_cod)
{
	$sql =  " INSERT INTO APPS_PERMISOS (CLAVE, USUARIO) 
              VALUES ( ?, ?)";
    $base = $bd->prepare($sql);
    $base->bind_param('ss', $app, $user_cod);
    $base->execute();
}
function deletetUserAuth($bd, $app, $user_cod)
{
	$sql =  " DELETE FROM APPS_PERMISOS
              WHERE CLAVE = ? AND USUARIO = ?";
    $base = $bd->prepare($sql);
    $base->bind_param('ss', $app, $user_cod);
    $base->execute();
}
?>