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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
import { databaseTimeToDate } from '$lib/Utility/time';
import sb from '../../sb';
export interface Badge {
id: number;
post: string;
image: string;
hidden: boolean;
shadow_hidden: boolean;
click_count: number;
time?: string;
description?: string | null;
category?: string | null;
source?: string | null;
designer?: string | null;
}
export interface BadgeInput {
post?: string;
image?: string;
description?: string | null;
time?: string;
category?: string | null;
hidden?: boolean;
source?: string | null;
designer?: string | null;
}
const getPagination = (page: number, size: number) => {
const from = page ? page * (size ? +size : 3) : 0;
return { from, to: page ? from + size - 1 : size - 1 };
};
export const getUserBadges = async (userId: number, page = 0, size = -1): Promise<Badge[]> => {
const { from, to } = getPagination(page, size);
let query = sb.from('user_badges').select('*').eq('user_id', userId);
if (size !== -1) query = query.range(from, to);
const { data, error } = await query;
if (error) return [];
return data.sort((a, b) =>
databaseTimeToDate((a as Badge).time ?? '').getTime() >
databaseTimeToDate((b as Badge).time ?? '').getTime()
? -1
: 1
) as Badge[];
};
export const addUserBadge = async (userId: number, badge: BadgeInput) => {
const { post, image, description, time, category, hidden, source, designer } = badge;
if (post === undefined || image === undefined) return;
if (time) {
await sb.from('user_badges').insert({
user_id: userId,
post,
image,
description,
time,
category,
hidden,
source,
designer
});
} else {
await sb
.from('user_badges')
.insert({ user_id: userId, post, image, description, category, hidden, source, designer });
}
};
export const removeUserBadge = async (userId: number, id: number) => {
if (!isNaN(id)) await sb.from('user_badges').delete().eq('id', id).eq('user_id', userId);
};
export const updateUserBadge = async (userId: number, id: number, badge: BadgeInput) => {
if (badge.post === undefined || badge.image === undefined) return;
await sb
.from('user_badges')
.update({
post: badge.post,
image: badge.image,
description: badge.description,
category: badge.category,
time: badge.time,
hidden: badge.hidden,
source: badge.source,
designer: badge.designer
})
.eq('id', id)
.eq('user_id', userId);
};
export const renameCategory = async (userId: number, oldName: string, newName: string) =>
await sb
.from('user_badges')
.update({ category: newName })
.eq('category', oldName)
.eq('user_id', userId);
export const removeAllUserBadges = async (userId: number) =>
await sb.from('user_badges').delete().eq('user_id', userId);
export const migrateCategory = async (userId: number, oldName: string, newName: string) =>
await sb
.from('user_badges')
.update({ category: newName })
.eq('category', oldName)
.eq('user_id', userId);
export const setShadowHidden = async (userId: number, shadowHide: boolean) =>
await sb.from('user_badges').update({ shadow_hidden: shadowHide }).eq('user_id', userId);
export const setShadowHiddenBadge = async (id: number, shadowHide: boolean) =>
await sb.from('user_badges').update({ shadow_hidden: shadowHide }).eq('id', id);
export const incrementClickCount = async (id: number) =>
await sb.rpc('user_badges_increment_click_count', { user_badge_id: id });
|