api/src/routes/discoverable-guilds.ts


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

import { Guild, Config } from "@fosscord/util";

import { Router, Request, Response } from "express";
import { route } from "@fosscord/api";

const router = Router();

router.get("/", route({}), async (req: Request, res: Response) => {
	const { limit, categories } = req.query;
	var showAllGuilds = Config.get().guild.showAllGuildsInDiscovery;
	// ! this only works using SQL querys
	// TODO: implement this with default typeorm query
	// const guilds = await Guild.find({ where: { features: "DISCOVERABLE" } }); //, take: Math.abs(Number(limit)) });
	let guilds;
	let total;
	switch (categories) {
		case "1":
			guilds = showAllGuilds
				? await Guild.find({ take: Math.abs(Number(limit || 24)) })
				: await Guild.find({ where: `"primary_category_id" = 1 AND "features" LIKE '%COMMUNITY%'`, take: Math.abs(Number(limit || 24)) });
			total = guilds.length;
		default:
			guilds = showAllGuilds
				? await Guild.find({ take: Math.abs(Number(limit || 24)) })
				: await Guild.find({ where: `"features" LIKE '%COMMUNITY%'`, take: Math.abs(Number(limit || 24)) });
			total = guilds.length;
	}
	res.send({ total: total, guilds: guilds, offset: 0, limit: limit});
});

export default router;