blob: d22eeb4776d146b9fc2734c9c4e75a21f20685d7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
<?php
class Badge
{
public string $id;
public static function from_array(array $arr, string $prefix = ""): Badge|null
{
if (!empty($prefix)) {
$prefix .= "_";
}
if (!isset($arr["{$prefix}badge_id"])) {
return null;
}
$b = new Badge();
$b->id = $arr["{$prefix}badge_id"];
return $b;
}
}
class Role
{
public string $name;
public Badge|null $badge;
public static function from_array(array $arr): Role|null
{
if (!isset($arr["role_name"])) {
return null;
}
$r = new Role();
$r->name = $arr["role_name"];
$r->badge = Badge::from_array($arr, "role");
return $r;
}
}
class User
{
public string $id;
public string $username;
public int $joined_at;
public int $last_active_at;
public Badge|null $custom_badge;
public Role|null $role;
public bool $private_profile;
public static function from_array(array $arr): User
{
$u = new User();
$u->id = $arr["id"];
$u->username = $arr["username"];
$u->joined_at = strtotime($arr["joined_at"] ?? "0");
$u->last_active_at = strtotime($arr["last_active_at"] ?? "0");
$u->private_profile = $row["private_profile"] ?? false;
$u->custom_badge = Badge::from_array($arr, "custom");
$u->role = Role::from_array($arr);
return $u;
}
public static function get_user_by_id(PDO &$db, string $user_id): User|null
{
$stmt = $db->prepare("SELECT
u.id,
u.username,
u.joined_at,
u.last_active_at,
up.private_profile,
r.name AS role_name,
r.badge_id AS role_badge_id,
ub.badge_id AS custom_badge_id
FROM users u
INNER JOIN user_preferences up ON up.id = u.id
LEFT JOIN role_assigns ra ON ra.user_id = u.id
LEFT JOIN roles r ON r.id = ra.role_id
LEFT JOIN user_badges ub ON ub.user_id = u.id
WHERE u.id = ?
");
$stmt->execute([$user_id]);
$u = null;
if ($uploader_row = $stmt->fetch()) {
$u = User::from_array($uploader_row);
}
return $u;
}
}
|
