aboutsummaryrefslogtreecommitdiff
path: root/src/lib/Database
diff options
context:
space:
mode:
authorFuwn <[email protected]>2024-05-20 23:53:10 -0700
committerFuwn <[email protected]>2024-05-20 23:53:10 -0700
commit15e98c91124866a342b3eb491a55c6054c8ddecb (patch)
tree8b8f104aee7c9552b18fb096c50483cfb4f9be15 /src/lib/Database
parentfeat(skeleton): animation delay (diff)
downloaddue.moe-15e98c91124866a342b3eb491a55c6054c8ddecb.tar.xz
due.moe-15e98c91124866a342b3eb491a55c6054c8ddecb.zip
feat(badges): individual badges shadow hiding
Diffstat (limited to 'src/lib/Database')
-rw-r--r--src/lib/Database/userBadges.ts133
1 files changed, 68 insertions, 65 deletions
diff --git a/src/lib/Database/userBadges.ts b/src/lib/Database/userBadges.ts
index 0b2e2491..c29f06d5 100644
--- a/src/lib/Database/userBadges.ts
+++ b/src/lib/Database/userBadges.ts
@@ -2,94 +2,97 @@ import { databaseTimeToDate } from '$lib/Utility/time';
import supabase from './supabase';
export interface Badge {
- post?: string;
- image?: string;
- description?: string | null;
- id?: number;
- time?: string;
- category?: string | null;
- hidden?: boolean;
- source?: string | null;
- designer?: string | null;
- shadow_hidden?: boolean;
+ post?: string;
+ image?: string;
+ description?: string | null;
+ id?: number;
+ time?: string;
+ category?: string | null;
+ hidden?: boolean;
+ source?: string | null;
+ designer?: string | null;
+ shadow_hidden?: boolean;
}
export const getUserBadges = async (userId: number): Promise<Badge[]> => {
- const { data, error } = await supabase.from('user_badges').select('*').eq('user_id', userId);
+ const { data, error } = await supabase.from('user_badges').select('*').eq('user_id', userId);
- if (error) return [];
+ if (error) return [];
- return data.sort((a, b) =>
- databaseTimeToDate((a as Badge).time ?? '').getTime() >
- databaseTimeToDate((b as Badge).time ?? '').getTime()
- ? -1
- : 1
- ) as Badge[];
+ 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: Badge) => {
- const { post, image, description, time, category, hidden, source, designer } = badge;
+ const { post, image, description, time, category, hidden, source, designer } = badge;
- if (post === undefined || image === undefined) return;
+ if (post === undefined || image === undefined) return;
- if (time) {
- await supabase.from('user_badges').insert({
- user_id: userId,
- post,
- image,
- description,
- time,
- category,
- hidden,
- source,
- designer
- });
- } else {
- await supabase
- .from('user_badges')
- .insert({ user_id: userId, post, image, description, category, hidden, source, designer });
- }
+ if (time) {
+ await supabase.from('user_badges').insert({
+ user_id: userId,
+ post,
+ image,
+ description,
+ time,
+ category,
+ hidden,
+ source,
+ designer
+ });
+ } else {
+ await supabase
+ .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 supabase.from('user_badges').delete().eq('id', id).eq('user_id', userId);
+ if (!isNaN(id)) await supabase.from('user_badges').delete().eq('id', id).eq('user_id', userId);
};
export const updateUserBadge = async (userId: number, id: number, badge: Badge) => {
- if (badge.post === undefined || badge.image === undefined) return;
+ if (badge.post === undefined || badge.image === undefined) return;
- await supabase
- .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);
+ await supabase
+ .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 supabase
- .from('user_badges')
- .update({ category: newName })
- .eq('category', oldName)
- .eq('user_id', userId);
+ await supabase
+ .from('user_badges')
+ .update({ category: newName })
+ .eq('category', oldName)
+ .eq('user_id', userId);
export const removeAllUserBadges = async (userId: number) =>
- await supabase.from('user_badges').delete().eq('user_id', userId);
+ await supabase.from('user_badges').delete().eq('user_id', userId);
export const migrateCategory = async (userId: number, oldName: string, newName: string) =>
- await supabase
- .from('user_badges')
- .update({ category: newName })
- .eq('category', oldName)
- .eq('user_id', userId);
+ await supabase
+ .from('user_badges')
+ .update({ category: newName })
+ .eq('category', oldName)
+ .eq('user_id', userId);
export const setShadowHidden = async (userId: number, shadowHide: boolean) =>
- await supabase.from('user_badges').update({ shadow_hidden: shadowHide }).eq('user_id', userId);
+ await supabase.from('user_badges').update({ shadow_hidden: shadowHide }).eq('user_id', userId);
+
+export const setShadowHiddenBadge = async (userId: number, id: number, shadowHide: boolean) =>
+ await supabase.from('user_badges').update({ shadow_hidden: shadowHide }).eq('id', id).eq('user_id', userId);