require_once ('../classes/conexion.php'); require_once ('../classes/globales.php'); require_once ('../classes/cache_control.php'); ?> function getRolById($id) { $query = "SELECT * FROM risk_rol WHERE id = '$id' AND activo = 'Y'"; $rs_query = mysql_query($query); $row = mysql_fetch_assoc($rs_query); $rol = $row['rol']; return $rol; } function getAllUsers() { $query = "SELECT * FROM risk_users"; return $query; } function getRoles() { $query = "SELECT * FROM risk_rol"; return $query; } function insertUsuarios($nombre,$apellido,$usuario,$password,$cedula,$activo) { $query = "INSERT INTO risk_users(`Names`,`LastNames`,`user`,`password`,`ci`,`active`) VALUES ('".$nombre."','".$apellido."','".$usuario."','".$password."','".$cedula."','".$activo."')"; $rs_query = mysql_query($query); return $rs_query; } function getListAccountsByEnterprise($enterprise) { $query = "SELECT * FROM risk_balances WHERE activo = 'S' and id_enterprise = '".$enterprise."' order by id_cta"; $rs_query = mysql_query($query); return $rs_query; } function getUsersByCi($id) { $query = "SELECT * FROM `risk_users` WHERE `ci` ='$id'"; $rs_query = mysql_query($query); return $rs_query; //$row_user = mysql_fetch_assoc(rs_query); //return $row_user; } function updateUsuarios($nombre,$apellido,$usuario,$password,$cedula,$activo) { $query = "UPDATE risk_users SET Names='$nombre',LastNames='$apellido', user='$usuario',password='$password', active='$activo' WHERE ci='$cedula'"; $rs_query = mysql_query($query); return $rs_query; } ?>