function getUserObjs($appID, $data, $iv)
{
$json = json_decode(decrypt_data($appID, $data, $iv));
$userID = $json->idusuario;
$response["status"] = 1;
$dbh = getConnection();
foreach ($patrimonio as $data) {
$objType = $data[0];
$possui = $data[1];
$table = "obj{$objType}";
$sql = "select {$table}.* from {$table} left join {$possui} on\n\t\t\t\t\t\tfk_idUser = :userID where fk_id{$objType} = id{$objType}";
$stmt = $dbh->prepare($sql);
$stmt->bindParam(":userID", $userID);
$stmt->execute();
$tmp = $stmt->fetchAll(PDO::FETCH_CLASS);
$objType = strtolower($objType);
$response[$objType . "s"] = storeElements($objType, $tmp);
if ($response[$objType . "s"]) {
$response["status"] = 1;
}
}
closeConnection($dbh);
$json = json_encode($response);
$data = encrypt_data($appID, $json);
echo json_encode($data);
return;
}
function getFriendsRequest($appID, $data, $iv)
{
global $friendTable;
$json = json_decode(decrypt_data($appID, $data, $iv));
$id1 = $json->idusuario_a;
$response["status"] = 0;
$dbh = getConnection();
$sql = "SELECT idusuario, nome, email, addressLat, addressLong, imagePath\n\t\t\t\tfrom usuario, (SELECT idusuario_b AS friend FROM {$friendTable}\n\t\t\t\t\tWHERE idusuario_a = :id1 and status = 0 UNION SELECT\n\t\t\t\t\t\tidusuario_a AS friend FROM {$friendTable} WHERE\n\t\t\t\t\t\t\tidusuario_b = :id1 and status = 0) as tmp WHERE\n\t\t\t\t\t\t\t\t\t\t\t\t\tidusuario = tmp.friend";
$stmt = $dbh->prepare($sql);
$stmt->bindParam(":id1", $id1);
$stmt->execute();
/* get user information as a associative array */
$tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
$response["users"] = storeElements("user", $tmp);
if ($response["users"]) {
$response["status"] = 1;
}
closeConnection($dbh);
$json = json_encode($response);
$data = encrypt_data($appID, $json);
echo json_encode($data);
}
function getObjFilmInfo($appID, $data, $iv)
{
global $filmTable;
$json = json_decode(decrypt_data($appID, $data, $iv));
$id = $json->idFilme;
$response["status"] = 0;
$dbh = getConnection();
$sql = "select * from {$filmTable} where idFilme = :id";
$stmt = $dbh->prepare($sql);
$stmt->bindParam(":id", $id);
$stmt->execute();
/* get all Film information as a associative array */
$tmp = $stmt->fetchAll(PDO::FETCH_CLASS);
$response["filmes"] = storeElements("filme", $tmp);
if ($response["filmes"]) {
$response["status"] = 1;
}
closeConnection($dbh);
$json = json_encode($response);
$data = encrypt_data($appID, $json);
echo json_encode($data);
return;
}
function getSimilarObjGames($appID, $data, $iv)
{
global $gameTable;
$json = json_decode(decrypt_data($appID, $data, $iv));
$titulo = $json->titulo;
$response["status"] = 0;
$dbh = getConnection();
$sql = "select * from {$gameTable} where titulo like '%{$titulo}%'";
$stmt = $dbh->prepare($sql);
$stmt->execute();
/* get user information as a associative array */
$tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
$response["jogos"] = storeElements("jogo", $tmp);
if ($response["jogos"]) {
$response["status"] = 1;
}
closeConnection($dbh);
$json = json_encode($response);
$data = encrypt_data($appID, $json);
echo json_encode($data);
return;
}
function getEmpRequestDeMim($appID, $data, $iv)
{
global $loanTable;
$json = json_decode(decrypt_data($appID, $data, $iv));
$id = $json->idusuario;
$response["status"] = 1;
$dbh = getConnection();
$sql = "select * from {$loanTable} where fk_idUser2 = :id and status = 0";
$stmt = $dbh->prepare($sql);
$stmt->bindParam(":id", $id);
$stmt->execute();
/* get laon information as a associative array */
$tmp = $stmt->fetchAll(PDO::FETCH_CLASS);
$response["emprestimos"] = storeElements("emprestimo", $tmp);
if ($response["emprestimos"]) {
$response["status"] = 1;
}
closeConnection($dbh);
$json = json_encode($response);
$data = encrypt_data($appID, $json);
echo json_encode($data);
return;
}
function getAllUsersByName($appID, $data, $iv)
{
global $userTable;
$json = json_decode(decrypt_data($appID, $data, $iv));
$response["status"] = 0;
$name = $json->nome;
$dbh = getConnection();
$sql = "select idusuario, nome, email, addressLat, addressLong, imagePath\n\t\t\t\t\t\t\t\t\t\tfrom {$userTable} where nome like '%{$name}%'";
$stmt = $dbh->prepare($sql);
$stmt->execute();
/* get user information as a associative array */
$tmp = $stmt->fetchAll(PDO::FETCH_ASSOC);
$response["users"] = storeElements("user", $tmp);
if ($response["users"]) {
$response["status"] = 1;
}
closeConnection($dbh);
$json = json_encode($response);
$data = encrypt_data($appID, $json);
echo json_encode($data);
return;
}
