Merged main into feature/training-content

src/dashboards/Corporate/index.tsx

@@ -1,405 +1,546 @@
 /* eslint-disable @next/next/no-img-element */
 import Modal from "@/components/Modal";
 import useFilterRecordsByUser from "@/hooks/useFilterRecordsByUser";
-import useUsers, {userHashStudent, userHashTeacher, userHashCorporate} from "@/hooks/useUsers";
+import useUsers, {
-import {CorporateUser, Group, MasterCorporateUser, Stat, User} from "@/interfaces/user";
+  userHashStudent,
-import UserList from "@/pages/(admin)/Lists/UserList";
+  userHashTeacher,
-import {dateSorter} from "@/utils";
+  userHashCorporate,
-import moment from "moment";
+} from "@/hooks/useUsers";
-import {useEffect, useMemo, useState} from "react";
 import {
-	BsArrowLeft,
+  CorporateUser,
-	BsClipboard2Data,
+  Group,
-	BsClipboard2DataFill,
+  MasterCorporateUser,
-	BsClock,
+  Stat,
-	BsGlobeCentralSouthAsia,
+  User,
-	BsPaperclip,
+} from "@/interfaces/user";
-	BsPerson,
+import UserList from "@/pages/(admin)/Lists/UserList";
-	BsPersonAdd,
+import { dateSorter } from "@/utils";
-	BsPersonFill,
+import moment from "moment";
-	BsPersonFillGear,
+import { useEffect, useMemo, useState } from "react";
-	BsPersonGear,
+import {
-	BsPencilSquare,
+  BsArrowLeft,
-	BsPersonBadge,
+  BsClipboard2Data,
-	BsPersonCheck,
+  BsClipboard2DataFill,
-	BsPeople,
+  BsClock,
-	BsArrowRepeat,
+  BsGlobeCentralSouthAsia,
-	BsPlus,
+  BsPaperclip,
-	BsEnvelopePaper,
+  BsPerson,
-	BsDatabase,
+  BsPersonAdd,
+  BsPersonFill,
+  BsPersonFillGear,
+  BsPersonGear,
+  BsPencilSquare,
+  BsPersonBadge,
+  BsPersonCheck,
+  BsPeople,
+  BsArrowRepeat,
+  BsPlus,
+  BsEnvelopePaper,
+  BsDatabase,
 } from "react-icons/bs";
 import UserCard from "@/components/UserCard";
 import useGroups from "@/hooks/useGroups";
-import {averageLevelCalculator, calculateAverageLevel, calculateBandScore} from "@/utils/score";
+import {
-import {MODULE_ARRAY} from "@/utils/moduleUtils";
+  averageLevelCalculator,
-import {Module} from "@/interfaces";
+  calculateAverageLevel,
-import {groupByExam} from "@/utils/stats";
+  calculateBandScore,
+} from "@/utils/score";
+import { MODULE_ARRAY } from "@/utils/moduleUtils";
+import { Module } from "@/interfaces";
+import { groupByExam } from "@/utils/stats";
 import IconCard from "../IconCard";
 import GroupList from "@/pages/(admin)/Lists/GroupList";
 import useFilterStore from "@/stores/listFilterStore";
-import {useRouter} from "next/router";
+import { useRouter } from "next/router";
 import useCodes from "@/hooks/useCodes";
-import {getUserCorporate} from "@/utils/groups";
+import { getUserCorporate } from "@/utils/groups";
 import useAssignments from "@/hooks/useAssignments";
-import {Assignment} from "@/interfaces/results";
+import { Assignment } from "@/interfaces/results";
 import AssignmentView from "../AssignmentView";
 import AssignmentCreator from "../AssignmentCreator";
 import clsx from "clsx";
 import AssignmentCard from "../AssignmentCard";
-import {createColumnHelper} from "@tanstack/react-table";
+import { createColumnHelper } from "@tanstack/react-table";
 import Checkbox from "@/components/Low/Checkbox";
 import List from "@/components/List";
-import {getUserCompanyName} from "@/resources/user";
+import { getUserCompanyName } from "@/resources/user";
-import {futureAssignmentFilter, pastAssignmentFilter, archivedAssignmentFilter, activeAssignmentFilter} from "@/utils/assignments";
+import {
+  futureAssignmentFilter,
+  pastAssignmentFilter,
+  archivedAssignmentFilter,
+  activeAssignmentFilter,
+} from "@/utils/assignments";
 import useUserBalance from "@/hooks/useUserBalance";
 import AssignmentsPage from "../views/AssignmentsPage";
 import StudentPerformancePage from "./StudentPerformancePage";
 import MasterStatistical from "../MasterCorporate/MasterStatistical";
-import MasterStatisticalPage from "./MasterStatisticalPage";
 
 interface Props {
-	user: CorporateUser;
+  user: CorporateUser;
-	linkedCorporate?: CorporateUser | MasterCorporateUser;
+  linkedCorporate?: CorporateUser | MasterCorporateUser;
 }
 
 const studentHash = {
-	type: "student",
+  type: "student",
-	orderBy: "registrationDate",
+  orderBy: "registrationDate",
-	size: 25,
+  size: 25,
 };
 
 const teacherHash = {
-	type: "teacher",
+  type: "teacher",
-	orderBy: "registrationDate",
+  orderBy: "registrationDate",
-	size: 25,
+  size: 25,
 };
 
-export default function CorporateDashboard({user, linkedCorporate}: Props) {
+export default function CorporateDashboard({ user, linkedCorporate }: Props) {
-	const [selectedUser, setSelectedUser] = useState<User>();
+  const [selectedUser, setSelectedUser] = useState<User>();
-	const [showModal, setShowModal] = useState(false);
+  const [showModal, setShowModal] = useState(false);
 
-	const {data: stats} = useFilterRecordsByUser<Stat[]>();
+  const { data: stats } = useFilterRecordsByUser<Stat[]>();
-	const {groups} = useGroups({admin: user.id});
+  const { groups } = useGroups({ admin: user.id });
-	const {assignments, isLoading: isAssignmentsLoading, reload: reloadAssignments} = useAssignments({corporate: user.id});
+  const {
-	const {balance} = useUserBalance();
+    assignments,
+    isLoading: isAssignmentsLoading,
+    reload: reloadAssignments,
+  } = useAssignments({ corporate: user.id });
+  const { balance } = useUserBalance();
 
-	const {users: students, total: totalStudents, reload: reloadStudents, isLoading: isStudentsLoading} = useUsers(studentHash);
+  const {
-	const {users: teachers, total: totalTeachers, reload: reloadTeachers, isLoading: isTeachersLoading} = useUsers(teacherHash);
+    users: students,
+    total: totalStudents,
+    reload: reloadStudents,
+    isLoading: isStudentsLoading,
+  } = useUsers(studentHash);
+  const {
+    users: teachers,
+    total: totalTeachers,
+    reload: reloadTeachers,
+    isLoading: isTeachersLoading,
+  } = useUsers(teacherHash);
 
-	const appendUserFilters = useFilterStore((state) => state.appendUserFilter);
+  const appendUserFilters = useFilterStore((state) => state.appendUserFilter);
-	const router = useRouter();
+  const router = useRouter();
 
-	const assignmentsGroups = useMemo(() => groups.filter((x) => x.admin === user.id || x.participants.includes(user.id)), [groups, user.id]);
+  const assignmentsGroups = useMemo(
+    () =>
+      groups.filter(
+        (x) => x.admin === user.id || x.participants.includes(user.id)
+      ),
+    [groups, user.id]
+  );
 
-	const assignmentsUsers = useMemo(
+  const assignmentsUsers = useMemo(
-		() =>
+    () =>
-			[...teachers, ...students].filter((x) =>
+      [...teachers, ...students].filter((x) =>
-				!!selectedUser
+        !!selectedUser
-					? groups
+          ? groups
-							.filter((g) => g.admin === selectedUser.id)
+              .filter((g) => g.admin === selectedUser.id)
-							.flatMap((g) => g.participants)
+              .flatMap((g) => g.participants)
-							.includes(x.id) || false
+              .includes(x.id) || false
-					: groups.flatMap((g) => g.participants).includes(x.id),
+          : groups.flatMap((g) => g.participants).includes(x.id)
-			),
+      ),
-		[groups, teachers, students, selectedUser],
+    [groups, teachers, students, selectedUser]
-	);
+  );
 
-	useEffect(() => {
+  useEffect(() => {
-		setShowModal(!!selectedUser && router.asPath === "/#");
+    setShowModal(!!selectedUser && router.asPath === "/#");
-	}, [selectedUser, router.asPath]);
+  }, [selectedUser, router.asPath]);
 
-	const getStatsByStudent = (user: User) => stats.filter((s) => s.user === user.id);
+  const getStatsByStudent = (user: User) =>
+    stats.filter((s) => s.user === user.id);
 
-	const UserDisplay = (displayUser: User) => (
+  const UserDisplay = (displayUser: User) => (
-		<div
+    <div
-			onClick={() => setSelectedUser(displayUser)}
+      onClick={() => setSelectedUser(displayUser)}
-			className="flex w-full p-4 gap-4 items-center hover:bg-mti-purple-ultralight cursor-pointer transition ease-in-out duration-300">
+      className="flex w-full p-4 gap-4 items-center hover:bg-mti-purple-ultralight cursor-pointer transition ease-in-out duration-300"
-			<img src={displayUser.profilePicture} alt={displayUser.name} className="rounded-full w-10 h-10" />
+    >
-			<div className="flex flex-col gap-1 items-start">
+      <img
-				<span>{displayUser.name}</span>
+        src={displayUser.profilePicture}
-				<span className="text-sm opacity-75">{displayUser.email}</span>
+        alt={displayUser.name}
-			</div>
+        className="rounded-full w-10 h-10"
-		</div>
+      />
-	);
+      <div className="flex flex-col gap-1 items-start">
+        <span>{displayUser.name}</span>
+        <span className="text-sm opacity-75">{displayUser.email}</span>
+      </div>
+    </div>
+  );
 
-	const GroupsList = () => {
+  // this workaround will allow us toreuse the master statistical due to master corporate restraints
-		const filter = (x: Group) => x.admin === user.id || x.participants.includes(user.id);
+  // while still being able to use the corporate user
+  const groupedByNameCorporateIds = useMemo(
+    () => ({
+      [user.corporateInformation?.companyInformation?.name || user.name]: [
+        user.id,
+      ],
+    }),
+    [user]
+  );
+  const teachersAndStudents = useMemo(
+    () => [...students, ...teachers],
+    [students, teachers]
+  );
+  const MasterStatisticalPage = () => {
+    return (
+      <>
+        <div className="flex flex-col gap-4">
+          <div
+            onClick={() => router.push("/")}
+            className="flex gap-2 items-center text-mti-purple-light cursor-pointer hover:text-mti-purple-dark transition ease-in-out duration-300"
+          >
+            <BsArrowLeft className="text-xl" />
+            <span>Back</span>
+          </div>
+          <h2 className="text-2xl font-semibold">Master Statistical</h2>
+        </div>
+        <MasterStatistical
+          users={teachersAndStudents}
+          corporateUsers={groupedByNameCorporateIds}
+          displaySelection={false}
+        />
+      </>
+    );
+  };
 
-		return (
+  const GroupsList = () => {
-			<>
+    const filter = (x: Group) =>
-				<div className="flex flex-col gap-4">
+      x.admin === user.id || x.participants.includes(user.id);
-					<div
-						onClick={() => router.push("/")}
-						className="flex gap-2 items-center text-mti-purple-light cursor-pointer hover:text-mti-purple-dark transition ease-in-out duration-300">
-						<BsArrowLeft className="text-xl" />
-						<span>Back</span>
-					</div>
-					<h2 className="text-2xl font-semibold">Groups ({groups.filter(filter).length})</h2>
-				</div>
 
-				<GroupList user={user} />
+    return (
-			</>
+      <>
-		);
+        <div className="flex flex-col gap-4">
-	};
+          <div
+            onClick={() => router.push("/")}
+            className="flex gap-2 items-center text-mti-purple-light cursor-pointer hover:text-mti-purple-dark transition ease-in-out duration-300"
+          >
+            <BsArrowLeft className="text-xl" />
+            <span>Back</span>
+          </div>
+          <h2 className="text-2xl font-semibold">
+            Groups ({groups.filter(filter).length})
+          </h2>
+        </div>
 
-	const averageLevelCalculator = (studentStats: Stat[]) => {
+        <GroupList user={user} />
-		const formattedStats = studentStats
+      </>
-			.map((s) => ({
+    );
-				focus: students.find((u) => u.id === s.user)?.focus,
+  };
-				score: s.score,
-				module: s.module,
-			}))
-			.filter((f) => !!f.focus);
-		const bandScores = formattedStats.map((s) => ({
-			module: s.module,
-			level: calculateBandScore(s.score.correct, s.score.total, s.module, s.focus!),
-		}));
 
-		const levels: {[key in Module]: number} = {
+  const averageLevelCalculator = (studentStats: Stat[]) => {
-			reading: 0,
+    const formattedStats = studentStats
-			listening: 0,
+      .map((s) => ({
-			writing: 0,
+        focus: students.find((u) => u.id === s.user)?.focus,
-			speaking: 0,
+        score: s.score,
-			level: 0,
+        module: s.module,
-		};
+      }))
-		bandScores.forEach((b) => (levels[b.module] += b.level));
+      .filter((f) => !!f.focus);
+    const bandScores = formattedStats.map((s) => ({
+      module: s.module,
+      level: calculateBandScore(
+        s.score.correct,
+        s.score.total,
+        s.module,
+        s.focus!
+      ),
+    }));
 
-		return calculateAverageLevel(levels);
+    const levels: { [key in Module]: number } = {
-	};
+      reading: 0,
+      listening: 0,
+      writing: 0,
+      speaking: 0,
+      level: 0,
+    };
+    bandScores.forEach((b) => (levels[b.module] += b.level));
 
-	if (router.asPath === "/#students")
+    return calculateAverageLevel(levels);
-		return (
+  };
-			<UserList
-				user={user}
-				type="student"
-				renderHeader={(total) => (
-					<div className="flex flex-col gap-4">
-						<div
-							onClick={() => router.push("/")}
-							className="flex gap-2 items-center text-mti-purple-light cursor-pointer hover:text-mti-purple-dark transition ease-in-out duration-300">
-							<BsArrowLeft className="text-xl" />
-							<span>Back</span>
-						</div>
-						<h2 className="text-2xl font-semibold">Students ({total})</h2>
-					</div>
-				)}
-			/>
-		);
 
-	if (router.asPath === "/#teachers")
+  if (router.asPath === "/#students")
-		return (
+    return (
-			<UserList
+      <UserList
-				user={user}
+        user={user}
-				type="teacher"
+        type="student"
-				renderHeader={(total) => (
+        renderHeader={(total) => (
-					<div className="flex flex-col gap-4">
+          <div className="flex flex-col gap-4">
-						<div
+            <div
-							onClick={() => router.push("/")}
+              onClick={() => router.push("/")}
-							className="flex gap-2 items-center text-mti-purple-light cursor-pointer hover:text-mti-purple-dark transition ease-in-out duration-300">
+              className="flex gap-2 items-center text-mti-purple-light cursor-pointer hover:text-mti-purple-dark transition ease-in-out duration-300"
-							<BsArrowLeft className="text-xl" />
+            >
-							<span>Back</span>
+              <BsArrowLeft className="text-xl" />
-						</div>
+              <span>Back</span>
-						<h2 className="text-2xl font-semibold">Teachers ({total})</h2>
+            </div>
-					</div>
+            <h2 className="text-2xl font-semibold">Students ({total})</h2>
-				)}
+          </div>
-			/>
+        )}
-		);
+      />
+    );
 
-	if (router.asPath === "/#groups") return <GroupsList />;
+  if (router.asPath === "/#teachers")
-	if (router.asPath === "/#studentsPerformance") return <StudentPerformancePage user={user} />;
+    return (
+      <UserList
+        user={user}
+        type="teacher"
+        renderHeader={(total) => (
+          <div className="flex flex-col gap-4">
+            <div
+              onClick={() => router.push("/")}
+              className="flex gap-2 items-center text-mti-purple-light cursor-pointer hover:text-mti-purple-dark transition ease-in-out duration-300"
+            >
+              <BsArrowLeft className="text-xl" />
+              <span>Back</span>
+            </div>
+            <h2 className="text-2xl font-semibold">Teachers ({total})</h2>
+          </div>
+        )}
+      />
+    );
 
-	if (router.asPath === "/#assignments")
+  if (router.asPath === "/#groups") return <GroupsList />;
-		return (
+  if (router.asPath === "/#studentsPerformance")
-			<AssignmentsPage
+    return <StudentPerformancePage user={user} />;
-				assignments={assignments}
-				user={user}
-				groups={assignmentsGroups}
-				reloadAssignments={reloadAssignments}
-				isLoading={isAssignmentsLoading}
-				onBack={() => router.push("/")}
-			/>
-		);
 
-	if (router.asPath === "/#statistical") return <MasterStatisticalPage user={user} />;
+  if (router.asPath === "/#assignments")
+    return (
+      <AssignmentsPage
+        assignments={assignments}
+        user={user}
+        groups={assignmentsGroups}
+        reloadAssignments={reloadAssignments}
+        isLoading={isAssignmentsLoading}
+        onBack={() => router.push("/")}
+      />
+    );
 
-	return (
+  if (router.asPath === "/#statistical") return <MasterStatisticalPage />;
-		<>
-			<Modal isOpen={showModal} onClose={() => setSelectedUser(undefined)}>
-				<>
-					{selectedUser && (
-						<div className="w-full flex flex-col gap-8">
-							<UserCard
-								loggedInUser={user}
-								onClose={(shouldReload) => {
-									setSelectedUser(undefined);
-									if (shouldReload && selectedUser!.type === "student") reloadStudents();
-									if (shouldReload && selectedUser!.type === "teacher") reloadTeachers();
-								}}
-								onViewStudents={
-									selectedUser.type === "corporate" || selectedUser.type === "teacher"
-										? () => {
-												appendUserFilters({
-													id: "view-students",
-													filter: (x: User) => x.type === "student",
-												});
-												appendUserFilters({
-													id: "belongs-to-admin",
-													filter: (x: User) =>
-														groups
-															.filter((g) => g.admin === selectedUser.id || g.participants.includes(selectedUser.id))
-															.flatMap((g) => g.participants)
-															.includes(x.id),
-												});
 
-												router.push("/list/users");
+  return (
-										  }
+    <>
-										: undefined
+      <Modal isOpen={showModal} onClose={() => setSelectedUser(undefined)}>
-								}
+        <>
-								onViewTeachers={
+          {selectedUser && (
-									selectedUser.type === "corporate" || selectedUser.type === "student"
+            <div className="w-full flex flex-col gap-8">
-										? () => {
+              <UserCard
-												appendUserFilters({
+                loggedInUser={user}
-													id: "view-teachers",
+                onClose={(shouldReload) => {
-													filter: (x: User) => x.type === "teacher",
+                  setSelectedUser(undefined);
-												});
+                  if (shouldReload && selectedUser!.type === "student")
-												appendUserFilters({
+                    reloadStudents();
-													id: "belongs-to-admin",
+                  if (shouldReload && selectedUser!.type === "teacher")
-													filter: (x: User) =>
+                    reloadTeachers();
-														groups
+                }}
-															.filter((g) => g.admin === selectedUser.id || g.participants.includes(selectedUser.id))
+                onViewStudents={
-															.flatMap((g) => g.participants)
+                  selectedUser.type === "corporate" ||
-															.includes(x.id),
+                  selectedUser.type === "teacher"
-												});
+                    ? () => {
+                        appendUserFilters({
+                          id: "view-students",
+                          filter: (x: User) => x.type === "student",
+                        });
+                        appendUserFilters({
+                          id: "belongs-to-admin",
+                          filter: (x: User) =>
+                            groups
+                              .filter(
+                                (g) =>
+                                  g.admin === selectedUser.id ||
+                                  g.participants.includes(selectedUser.id)
+                              )
+                              .flatMap((g) => g.participants)
+                              .includes(x.id),
+                        });
 
-												router.push("/list/users");
+                        router.push("/list/users");
-										  }
+                      }
-										: undefined
+                    : undefined
-								}
+                }
-								user={selectedUser}
+                onViewTeachers={
-							/>
+                  selectedUser.type === "corporate" ||
-						</div>
+                  selectedUser.type === "student"
-					)}
+                    ? () => {
-				</>
+                        appendUserFilters({
-			</Modal>
+                          id: "view-teachers",
+                          filter: (x: User) => x.type === "teacher",
+                        });
+                        appendUserFilters({
+                          id: "belongs-to-admin",
+                          filter: (x: User) =>
+                            groups
+                              .filter(
+                                (g) =>
+                                  g.admin === selectedUser.id ||
+                                  g.participants.includes(selectedUser.id)
+                              )
+                              .flatMap((g) => g.participants)
+                              .includes(x.id),
+                        });
 
-			<>
+                        router.push("/list/users");
-				{!!linkedCorporate && (
+                      }
-					<div className="absolute top-4 right-4 bg-neutral-200 px-2 rounded-lg py-1">
+                    : undefined
-						Linked to: <b>{linkedCorporate?.corporateInformation?.companyInformation.name || linkedCorporate.name}</b>
+                }
-					</div>
+                user={selectedUser}
-				)}
+              />
-				<section className="grid grid-cols-5 -md:grid-cols-2 gap-4 text-center">
+            </div>
-					<IconCard
+          )}
-						onClick={() => router.push("/#students")}
+        </>
-						isLoading={isStudentsLoading}
+      </Modal>
-						Icon={BsPersonFill}
-						label="Students"
-						value={totalStudents}
-						color="purple"
-					/>
-					<IconCard
-						onClick={() => router.push("/#teachers")}
-						isLoading={isTeachersLoading}
-						Icon={BsPencilSquare}
-						label="Teachers"
-						value={totalTeachers}
-						color="purple"
-					/>
-					<IconCard
-						Icon={BsClipboard2Data}
-						label="Exams Performed"
-						value={stats.filter((s) => groups.flatMap((g) => g.participants).includes(s.user)).length}
-						color="purple"
-					/>
-					<IconCard
-						Icon={BsPaperclip}
-						isLoading={isStudentsLoading}
-						label="Average Level"
-						value={averageLevelCalculator(stats.filter((s) => groups.flatMap((g) => g.participants).includes(s.user))).toFixed(1)}
-						color="purple"
-					/>
-					<IconCard onClick={() => router.push("/#groups")} Icon={BsPeople} label="Groups" value={groups.length} color="purple" />
-					<IconCard
-						Icon={BsPersonCheck}
-						label="User Balance"
-						value={`${balance}/${user.corporateInformation?.companyInformation?.userAmount || 0}`}
-						color="purple"
-					/>
-					<IconCard
-						Icon={BsClock}
-						label="Expiration Date"
-						value={user.subscriptionExpirationDate ? moment(user.subscriptionExpirationDate).format("DD/MM/yyyy") : "Unlimited"}
-						color="rose"
-					/>
-					<IconCard
-						Icon={BsPersonFillGear}
-						isLoading={isStudentsLoading}
-						label="Student Performance"
-						value={totalStudents}
-						color="purple"
-						onClick={() => router.push("/#studentsPerformance")}
-					/>
-					<IconCard Icon={BsDatabase} label="Master Statistical" color="purple" onClick={() => router.push("/#statistical")} />
-					<button
-						disabled={isAssignmentsLoading}
-						onClick={() => router.push("/#assignments")}
-						className="bg-white col-span-2 rounded-xl shadow p-4 flex flex-col gap-4 items-center w-96 h-52 justify-center cursor-pointer hover:shadow-xl transition ease-in-out duration-300">
-						<BsEnvelopePaper className="text-6xl text-mti-purple-light" />
-						<span className="flex flex-col gap-1 items-center text-xl">
-							<span className="text-lg">Assignments</span>
-							<span className="font-semibold text-mti-purple-light">
-								{isAssignmentsLoading ? "Loading..." : assignments.filter((a) => !a.archived).length}
-							</span>
-						</span>
-					</button>
-				</section>
 
-				<section className="grid grid-cols-1 md:grid-cols-2 gap-4 w-full justify-between">
+      <>
-					<div className="bg-white shadow flex flex-col rounded-xl w-full">
+        {!!linkedCorporate && (
-						<span className="p-4">Latest students</span>
+          <div className="absolute top-4 right-4 bg-neutral-200 px-2 rounded-lg py-1">
-						<div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
+            Linked to:{" "}
-							{students
+            <b>
-								.sort((a, b) => dateSorter(a, b, "desc", "registrationDate"))
+              {linkedCorporate?.corporateInformation?.companyInformation.name ||
-								.map((x) => (
+                linkedCorporate.name}
-									<UserDisplay key={x.id} {...x} />
+            </b>
-								))}
+          </div>
-						</div>
+        )}
-					</div>
+        <section className="grid grid-cols-5 -md:grid-cols-2 gap-4 text-center">
-					<div className="bg-white shadow flex flex-col rounded-xl w-full">
+          <IconCard
-						<span className="p-4">Latest teachers</span>
+            onClick={() => router.push("/#students")}
-						<div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
+            isLoading={isStudentsLoading}
-							{teachers
+            Icon={BsPersonFill}
-								.sort((a, b) => dateSorter(a, b, "desc", "registrationDate"))
+            label="Students"
-								.map((x) => (
+            value={totalStudents}
-									<UserDisplay key={x.id} {...x} />
+            color="purple"
-								))}
+          />
-						</div>
+          <IconCard
-					</div>
+            onClick={() => router.push("/#teachers")}
-					<div className="bg-white shadow flex flex-col rounded-xl w-full">
+            isLoading={isTeachersLoading}
-						<span className="p-4">Highest level students</span>
+            Icon={BsPencilSquare}
-						<div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
+            label="Teachers"
-							{students
+            value={totalTeachers}
-								.sort((a, b) => calculateAverageLevel(b.levels) - calculateAverageLevel(a.levels))
+            color="purple"
-								.map((x) => (
+          />
-									<UserDisplay key={x.id} {...x} />
+          <IconCard
-								))}
+            Icon={BsClipboard2Data}
-						</div>
+            label="Exams Performed"
-					</div>
+            value={
-					<div className="bg-white shadow flex flex-col rounded-xl w-full">
+              stats.filter((s) =>
-						<span className="p-4">Highest exam count students</span>
+                groups.flatMap((g) => g.participants).includes(s.user)
-						<div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
+              ).length
-							{students
+            }
-								.sort(
+            color="purple"
-									(a, b) =>
+          />
-										Object.keys(groupByExam(getStatsByStudent(b))).length - Object.keys(groupByExam(getStatsByStudent(a))).length,
+          <IconCard
-								)
+            Icon={BsPaperclip}
-								.map((x) => (
+            isLoading={isStudentsLoading}
-									<UserDisplay key={x.id} {...x} />
+            label="Average Level"
-								))}
+            value={averageLevelCalculator(
-						</div>
+              stats.filter((s) =>
-					</div>
+                groups.flatMap((g) => g.participants).includes(s.user)
-				</section>
+              )
-			</>
+            ).toFixed(1)}
-		</>
+            color="purple"
-	);
+          />
+          <IconCard
+            onClick={() => router.push("/#groups")}
+            Icon={BsPeople}
+            label="Groups"
+            value={groups.length}
+            color="purple"
+          />
+          <IconCard
+            Icon={BsPersonCheck}
+            label="User Balance"
+            value={`${balance}/${
+              user.corporateInformation?.companyInformation?.userAmount || 0
+            }`}
+            color="purple"
+          />
+          <IconCard
+            Icon={BsClock}
+            label="Expiration Date"
+            value={
+              user.subscriptionExpirationDate
+                ? moment(user.subscriptionExpirationDate).format("DD/MM/yyyy")
+                : "Unlimited"
+            }
+            color="rose"
+          />
+          <IconCard
+            Icon={BsPersonFillGear}
+            isLoading={isStudentsLoading}
+            label="Student Performance"
+            value={totalStudents}
+            color="purple"
+            onClick={() => router.push("/#studentsPerformance")}
+          />
+          <IconCard
+            Icon={BsDatabase}
+            label="Master Statistical"
+            color="purple"
+            onClick={() => router.push("/#statistical")}
+          />
+          <button
+            disabled={isAssignmentsLoading}
+            onClick={() => router.push("/#assignments")}
+            className="bg-white col-span-2 rounded-xl shadow p-4 flex flex-col gap-4 items-center w-96 h-52 justify-center cursor-pointer hover:shadow-xl transition ease-in-out duration-300"
+          >
+            <BsEnvelopePaper className="text-6xl text-mti-purple-light" />
+            <span className="flex flex-col gap-1 items-center text-xl">
+              <span className="text-lg">Assignments</span>
+              <span className="font-semibold text-mti-purple-light">
+                {isAssignmentsLoading
+                  ? "Loading..."
+                  : assignments.filter((a) => !a.archived).length}
+              </span>
+            </span>
+          </button>
+        </section>
+
+        <section className="grid grid-cols-1 md:grid-cols-2 gap-4 w-full justify-between">
+          <div className="bg-white shadow flex flex-col rounded-xl w-full">
+            <span className="p-4">Latest students</span>
+            <div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
+              {students
+                .sort((a, b) => dateSorter(a, b, "desc", "registrationDate"))
+                .map((x) => (
+                  <UserDisplay key={x.id} {...x} />
+                ))}
+            </div>
+          </div>
+          <div className="bg-white shadow flex flex-col rounded-xl w-full">
+            <span className="p-4">Latest teachers</span>
+            <div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
+              {teachers
+                .sort((a, b) => dateSorter(a, b, "desc", "registrationDate"))
+                .map((x) => (
+                  <UserDisplay key={x.id} {...x} />
+                ))}
+            </div>
+          </div>
+          <div className="bg-white shadow flex flex-col rounded-xl w-full">
+            <span className="p-4">Highest level students</span>
+            <div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
+              {students
+                .sort(
+                  (a, b) =>
+                    calculateAverageLevel(b.levels) -
+                    calculateAverageLevel(a.levels)
+                )
+                .map((x) => (
+                  <UserDisplay key={x.id} {...x} />
+                ))}
+            </div>
+          </div>
+          <div className="bg-white shadow flex flex-col rounded-xl w-full">
+            <span className="p-4">Highest exam count students</span>
+            <div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
+              {students
+                .sort(
+                  (a, b) =>
+                    Object.keys(groupByExam(getStatsByStudent(b))).length -
+                    Object.keys(groupByExam(getStatsByStudent(a))).length
+                )
+                .map((x) => (
+                  <UserDisplay key={x.id} {...x} />
+                ))}
+            </div>
+          </div>
+        </section>
+      </>
+    </>
+  );
 }

src/dashboards/MasterCorporate/MasterStatistical.tsx

@@ -1,5 +1,5 @@
 import React, {useEffect, useMemo, useState} from "react";
-import {CorporateUser, StudentUser, User} from "@/interfaces/user";
+import {CorporateUser, User} from "@/interfaces/user";
 import {BsFileExcel, BsBank, BsPersonFill} from "react-icons/bs";
 import IconCard from "../IconCard";
 
@@ -28,7 +28,7 @@ interface Props {
 }
 
 interface TableData {
-	user: User | undefined;
+	user: string;
 	email: string;
 	correct: number;
 	corporate: string;
@@ -62,7 +62,7 @@ const MasterStatistical = (props: Props) => {
 	const [startDate, setStartDate] = React.useState<Date | null>(moment("01/01/2023").toDate());
 	const [endDate, setEndDate] = React.useState<Date | null>(moment().endOf("year").toDate());
 
-	const {assignments, isLoading} = useAssignmentsCorporates({
+	const {assignments} = useAssignmentsCorporates({
 		corporates: selectedCorporates,
 		startDate,
 		endDate,
@@ -74,11 +74,11 @@ const MasterStatistical = (props: Props) => {
 		() =>
 			assignments.reduce((accmA: TableData[], a: AssignmentWithCorporateId) => {
 				const userResults = a.assignees.map((assignee) => {
-					const userData = users.find((u) => u.id === assignee);
 					const userStats = a.results.find((r) => r.user === assignee)?.stats || [];
+					const userData = users.find((u) => u.id === assignee);
 					const corporate = getUserName(users.find((u) => u.id === a.assigner));
 					const commonData = {
-						user: userData,
+						user: userData?.name || "N/A",
 						email: userData?.email || "N/A",
 						userId: assignee,
 						corporateId: a.corporateId,
@@ -86,7 +86,6 @@ const MasterStatistical = (props: Props) => {
 						corporate,
 						assignment: a.name,
 					};
-
 					if (userStats.length === 0) {
 						return {
 							...commonData,
@@ -109,6 +108,8 @@ const MasterStatistical = (props: Props) => {
 		[assignments, users],
 	);
 
+	useEffect(() => console.log(assignments), [assignments]);
+
 	const getCorporateScores = (corporateId: string): UserCount => {
 		const corporateAssignmentsUsers = assignments.filter((a) => a.corporateId === corporateId).reduce((acc, a) => acc + a.assignees.length, 0);
 
@@ -150,7 +151,7 @@ const MasterStatistical = (props: Props) => {
 			header: "User",
 			id: "user",
 			cell: (info) => {
-				return <span>{info.getValue()?.name || "N/A"}</span>;
+				return <span>{info.getValue()}</span>;
 			},
 		}),
 		columnHelper.accessor("email", {
@@ -160,13 +161,6 @@ const MasterStatistical = (props: Props) => {
 				return <span>{info.getValue()}</span>;
 			},
 		}),
-		columnHelper.accessor("user", {
-			header: "Student ID",
-			id: "studentID",
-			cell: (info) => {
-				return <span>{(info.getValue() as StudentUser)?.studentID || "N/A"}</span>;
-			},
-		}),
 		...(displaySelection
 			? [
 					columnHelper.accessor("corporate", {
@@ -287,7 +281,6 @@ const MasterStatistical = (props: Props) => {
 					<IconCard
 						Icon={BsBank}
 						label="Consolidate"
-						isLoading={isLoading}
 						value={getConsolidateScoreStr(consolidateScore)}
 						color="purple"
 						onClick={() => {
@@ -309,7 +302,6 @@ const MasterStatistical = (props: Props) => {
 							<IconCard
 								key={corporateName}
 								Icon={BsBank}
-								isLoading={isLoading}
 								label={corporateName}
 								value={value}
 								color="purple"
@@ -351,7 +343,7 @@ const MasterStatistical = (props: Props) => {
 				</div>
 				{renderSearch()}
 				<div className="flex flex-col gap-3 justify-end">
-					<Button className="w-[200px] h-[70px]" variant="outline" isLoading={downloading} onClick={triggerDownload}>
+					<Button className="max-w-[200px] h-[70px]" variant="outline" onClick={triggerDownload}>
 						Download
 					</Button>
 				</div>
@@ -367,7 +359,7 @@ const MasterStatistical = (props: Props) => {
 							{page * SIZE + 1} - {(page + 1) * SIZE > filteredRows.length ? filteredRows.length : (page + 1) * SIZE} /{" "}
 							{filteredRows.length}
 						</span>
-						<Button className="w-[200px]" disabled={(page + 1) * SIZE >= filteredRows.length} onClick={() => setPage((prev) => prev + 1)}>
+						<Button className="w-[200px]" disabled={(page + 1) * SIZE >= rows.length} onClick={() => setPage((prev) => prev + 1)}>
 							Next Page
 						</Button>
 					</div>

src/dashboards/views/AssignmentsPage.tsx

@@ -55,7 +55,7 @@ export default function AssignmentsPage({assignments, corporateAssignments, user
 				<AssignmentCreator
 					assignment={selectedAssignment}
 					groups={groups}
-					users={[...users, user]}
+					users={users}
 					user={user}
 					isCreating={isCreatingAssignment}
 					cancelCreation={() => {

src/hooks/useListSearch.tsx

@@ -1,6 +1,6 @@
 import {useState, useMemo} from "react";
 import Input from "@/components/Low/Input";
-import {search} from "@/utils/search";
+import { search } from "@/utils/search";
 
 export function useListSearch<T>(fields: string[][], rows: T[]) {
 	const [text, setText] = useState("");
@@ -8,8 +8,7 @@ export function useListSearch<T>(fields: string[][], rows: T[]) {
 	const renderSearch = () => <Input label="Search" type="text" name="search" onChange={setText} placeholder="Enter search text" value={text} />;
 
 	const updatedRows = useMemo(() => {
-		if (text.length > 0) return search(text, fields, rows);
+		return search(text, fields, rows);
-		return rows;
 	}, [fields, rows, text]);
 
 	return {

src/hooks/usePagination.tsx

@@ -1,28 +0,0 @@
-import Button from "@/components/Low/Button";
-import {useMemo, useState} from "react";
-
-export default function usePagination<T>(list: T[], size = 25) {
-	const [page, setPage] = useState(0);
-
-	const items = useMemo(() => list.slice(page * size, (page + 1) * size), [page, size, list]);
-
-	const render = () => (
-		<div className="w-full flex gap-2 justify-between items-center">
-			<div className="flex items-center gap-4 w-fit">
-				<Button className="w-[200px] h-fit" disabled={page === 0} onClick={() => setPage((prev) => prev - 1)}>
-					Previous Page
-				</Button>
-			</div>
-			<div className="flex items-center gap-4 w-fit">
-				<span className="opacity-80">
-					{page * size + 1} - {(page + 1) * size > list.length ? list.length : (page + 1) * size} / {list.length}
-				</span>
-				<Button className="w-[200px]" disabled={(page + 1) * size >= list.length} onClick={() => setPage((prev) => prev + 1)}>
-					Next Page
-				</Button>
-			</div>
-		</div>
-	);
-
-	return {page, items, setPage, render};
-}

src/hooks/useUsers.tsx

@@ -9,7 +9,7 @@ export const userHashStudent = {type: "student"} as {type: Type};
 export const userHashTeacher = {type: "teacher"} as {type: Type};
 export const userHashCorporate = {type: "corporate"} as {type: Type};
 
-export default function useUsers(props?: {type?: string; page?: number; size?: number; orderBy?: string; direction?: "asc" | "desc"}) {
+export default function useUsers(props?: {type?: string; page?: number; size?: number; orderBy?: string; direction?: "asc" | "desc", searchTerm?: string | undefined}) {
 	const [users, setUsers] = useState<User[]>([]);
 	const [total, setTotal] = useState(0);
 	const [isLoading, setIsLoading] = useState(false);
@@ -23,6 +23,8 @@ export default function useUsers(props?: {type?: string; page?: number; size?: n
 				if (props[key as keyof typeof props] !== undefined) params.append(key, props[key as keyof typeof props]!.toString());
 			});
 
+		console.log(params.toString());
+
 		setIsLoading(true);
 		axios
 			.get<{users: User[]; total: number}>(`/api/users/list?${params.toString()}`, {headers: {page: "register"}})
@@ -33,7 +35,7 @@ export default function useUsers(props?: {type?: string; page?: number; size?: n
 			.finally(() => setIsLoading(false));
 	};
 	// eslint-disable-next-line react-hooks/exhaustive-deps
-	useEffect(getData, [props?.page, props?.size, props?.type, props?.orderBy, props?.direction]);
+	useEffect(getData, [props?.page, props?.size, props?.type, props?.orderBy, props?.direction, props?.searchTerm]);
 
 	return {users, total, isLoading, isError, reload: getData};
 }

src/pages/(admin)/Lists/UserList.tsx

@@ -1,34 +1,34 @@
 import Button from "@/components/Low/Button";
-import {PERMISSIONS} from "@/constants/userPermissions";
+import { PERMISSIONS } from "@/constants/userPermissions";
 import useGroups from "@/hooks/useGroups";
 import useUsers from "@/hooks/useUsers";
-import {Type, User, userTypes, CorporateUser, Group} from "@/interfaces/user";
+import { Type, User, userTypes, CorporateUser, Group } from "@/interfaces/user";
-import {Popover, Transition} from "@headlessui/react";
+import { Popover, Transition } from "@headlessui/react";
-import {createColumnHelper, flexRender, getCoreRowModel, useReactTable} from "@tanstack/react-table";
+import { createColumnHelper, flexRender, getCoreRowModel, useReactTable } from "@tanstack/react-table";
 import axios from "axios";
 import clsx from "clsx";
-import {capitalize, reverse} from "lodash";
+import { capitalize, reverse } from "lodash";
 import moment from "moment";
-import {Fragment, useEffect, useState, useMemo} from "react";
+import { Fragment, useEffect, useState, useMemo } from "react";
-import {BsArrowDown, BsArrowDownUp, BsArrowUp, BsCheck, BsCheckCircle, BsEye, BsFillExclamationOctagonFill, BsPerson, BsTrash} from "react-icons/bs";
+import { BsArrowDown, BsArrowDownUp, BsArrowUp, BsCheck, BsCheckCircle, BsEye, BsFillExclamationOctagonFill, BsPerson, BsTrash } from "react-icons/bs";
-import {toast} from "react-toastify";
+import { toast } from "react-toastify";
-import {countries, TCountries} from "countries-list";
+import { countries, TCountries } from "countries-list";
 import countryCodes from "country-codes-list";
 import Modal from "@/components/Modal";
 import UserCard from "@/components/UserCard";
-import {getUserCompanyName, isAgentUser, USER_TYPE_LABELS} from "@/resources/user";
+import { getUserCompanyName, isAgentUser, USER_TYPE_LABELS } from "@/resources/user";
 import useFilterStore from "@/stores/listFilterStore";
-import {useRouter} from "next/router";
+import { useRouter } from "next/router";
-import {isCorporateUser} from "@/resources/user";
+import { isCorporateUser } from "@/resources/user";
-import {useListSearch} from "@/hooks/useListSearch";
+import { useListSearch } from "@/hooks/useListSearch";
-import {getUserCorporate} from "@/utils/groups";
+import { getUserCorporate } from "@/utils/groups";
-import {asyncSorter} from "@/utils";
+import { asyncSorter } from "@/utils";
-import {exportListToExcel, UserListRow} from "@/utils/users";
+import { exportListToExcel, UserListRow } from "@/utils/users";
-import {checkAccess} from "@/utils/permissions";
+import { checkAccess } from "@/utils/permissions";
-import {PermissionType} from "@/interfaces/permissions";
+import { PermissionType } from "@/interfaces/permissions";
 import usePermissions from "@/hooks/usePermissions";
 import useUserBalance from "@/hooks/useUserBalance";
-import usePagination from "@/hooks/usePagination";
+import Input from "@/components/Low/Input";
 const columnHelper = createColumnHelper<User>();
 const searchFields = [["name"], ["email"], ["corporateInformation", "companyInformation", "name"]];
 
@@ -63,15 +63,11 @@ export default function UserList({
 	const [sorter, setSorter] = useState<string>();
 	const [displayUsers, setDisplayUsers] = useState<User[]>([]);
 	const [selectedUser, setSelectedUser] = useState<User>();
+	const [page, setPage] = useState(0);
+	const [searchTerm, setSearchTerm] = useState<string | undefined>(undefined);
 
-	const userHash = useMemo(
+	const { users, total, isLoading, reload } = useUsers({type: type, size: 16, page: page, searchTerm: searchTerm});
-		() => ({
-			type,
-		}),
-		[type],
-	);
 
-	const {users, total, isLoading, reload} = useUsers(userHash);
 	const {users: corporates} = useUsers(corporatesHash);
 
 	const totalUsers = useMemo(() => [...users, ...corporates], [users, corporates]);
@@ -100,9 +96,9 @@ export default function UserList({
 		(async () => {
 			if (users && users.length > 0) {
 				const filteredUsers = filters.reduce((d, f) => d.filter(f), users);
-				// const sortedUsers = await asyncSorter<User>(filteredUsers, sortFunction);
+				const sortedUsers = await asyncSorter<User>(filteredUsers, sortFunction);
 
-				setDisplayUsers([...filteredUsers]);
+				setDisplayUsers([...sortedUsers]);
 			}
 		})();
 		// eslint-disable-next-line react-hooks/exhaustive-deps
@@ -112,20 +108,20 @@ export default function UserList({
 		if (!confirm(`Are you sure you want to delete ${user.name}'s account?`)) return;
 
 		axios
-			.delete<{ok: boolean}>(`/api/user?id=${user.id}`)
+			.delete<{ ok: boolean }>(`/api/user?id=${user.id}`)
 			.then(() => {
 				toast.success("User deleted successfully!");
 				reload();
 			})
 			.catch(() => {
-				toast.error("Something went wrong!", {toastId: "delete-error"});
+				toast.error("Something went wrong!", { toastId: "delete-error" });
 			})
 			.finally(reload);
 	};
 
 	const verifyAccount = (user: User) => {
 		axios
-			.post<{user?: User; ok?: boolean}>(`/api/users/update?id=${user.id}`, {
+			.post<{ user?: User; ok?: boolean }>(`/api/users/update?id=${user.id}`, {
 				...user,
 				isVerified: true,
 			})
@@ -134,22 +130,21 @@ export default function UserList({
 				reload();
 			})
 			.catch(() => {
-				toast.error("Something went wrong!", {toastId: "update-error"});
+				toast.error("Something went wrong!", { toastId: "update-error" });
 			});
 	};
 
 	const toggleDisableAccount = (user: User) => {
 		if (
 			!confirm(
-				`Are you sure you want to ${user.status === "disabled" ? "enable" : "disable"} ${
+				`Are you sure you want to ${user.status === "disabled" ? "enable" : "disable"} ${user.name
-					user.name
 				}'s account? This change is usually related to their payment state.`,
 			)
 		)
 			return;
 
 		axios
-			.post<{user?: User; ok?: boolean}>(`/api/users/update?id=${user.id}`, {
+			.post<{ user?: User; ok?: boolean }>(`/api/users/update?id=${user.id}`, {
 				...user,
 				status: user.status === "disabled" ? "active" : "disabled",
 			})
@@ -158,18 +153,18 @@ export default function UserList({
 				reload();
 			})
 			.catch(() => {
-				toast.error("Something went wrong!", {toastId: "update-error"});
+				toast.error("Something went wrong!", { toastId: "update-error" });
 			});
 	};
 
-	const SorterArrow = ({name}: {name: string}) => {
+	const SorterArrow = ({ name }: { name: string }) => {
 		if (sorter === name) return <BsArrowUp />;
 		if (sorter === reverseString(name)) return <BsArrowDown />;
 
 		return <BsArrowDownUp />;
 	};
 
-	const actionColumn = ({row}: {row: {original: User}}) => {
+	const actionColumn = ({ row }: { row: { original: User } }) => {
 		const updateUserPermission = PERMISSIONS.updateUser[row.original.type] as {
 			list: Type[];
 			perm: PermissionType;
@@ -214,11 +209,11 @@ export default function UserList({
 					<SorterArrow name="name" />
 				</button>
 			) as any,
-			cell: ({row, getValue}) => (
+			cell: ({ row, getValue }) => (
 				<div
 					className={clsx(
 						checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) &&
-							"underline text-mti-purple-light hover:text-mti-purple-dark transition ease-in-out duration-300 cursor-pointer",
+						"underline text-mti-purple-light hover:text-mti-purple-dark transition ease-in-out duration-300 cursor-pointer",
 					)}
 					onClick={() =>
 						checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) ? setSelectedUser(row.original) : null
@@ -236,9 +231,8 @@ export default function UserList({
 			) as any,
 			cell: (info) =>
 				info.getValue()
-					? `${countryCodes.findOne("countryCode" as any, info.getValue())?.flag} ${
+					? `${countryCodes.findOne("countryCode" as any, info.getValue())?.flag} ${countries[info.getValue() as unknown as keyof TCountries]?.name
-							countries[info.getValue() as unknown as keyof TCountries]?.name
+					} (+${countryCodes.findOne("countryCode" as any, info.getValue())?.countryCallingCode})`
-					  } (+${countryCodes.findOne("countryCode" as any, info.getValue())?.countryCallingCode})`
 					: "N/A",
 		}),
 		columnHelper.accessor("demographicInformation.phone", {
@@ -304,11 +298,11 @@ export default function UserList({
 					<SorterArrow name="name" />
 				</button>
 			) as any,
-			cell: ({row, getValue}) => (
+			cell: ({ row, getValue }) => (
 				<div
 					className={clsx(
 						checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) &&
-							"underline text-mti-purple-light hover:text-mti-purple-dark transition ease-in-out duration-300 cursor-pointer",
+						"underline text-mti-purple-light hover:text-mti-purple-dark transition ease-in-out duration-300 cursor-pointer",
 					)}
 					onClick={() =>
 						checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) ? setSelectedUser(row.original) : null
@@ -324,11 +318,11 @@ export default function UserList({
 					<SorterArrow name="email" />
 				</button>
 			) as any,
-			cell: ({row, getValue}) => (
+			cell: ({ row, getValue }) => (
 				<div
 					className={clsx(
 						PERMISSIONS.updateExpiryDate[row.original.type]?.includes(user.type) &&
-							"underline text-mti-purple-light hover:text-mti-purple-dark transition ease-in-out duration-300 cursor-pointer",
+						"underline text-mti-purple-light hover:text-mti-purple-dark transition ease-in-out duration-300 cursor-pointer",
 					)}
 					onClick={() => (PERMISSIONS.updateExpiryDate[row.original.type]?.includes(user.type) ? setSelectedUser(row.original) : null)}>
 					{getValue()}
@@ -511,23 +505,17 @@ export default function UserList({
 		return a.id.localeCompare(b.id);
 	};
 
-	const {rows: filteredRows, renderSearch, text: searchText} = useListSearch<User>(searchFields, displayUsers);
-	const {items, setPage, render: renderPagination} = usePagination<User>(filteredRows, 16);
-
-	// eslint-disable-next-line react-hooks/exhaustive-deps
-	useEffect(() => setPage(0), [searchText]);
-
 	const table = useReactTable({
-		data: items,
+		data: displayUsers,
 		columns: (!showDemographicInformation ? defaultColumns : demographicColumns) as any,
 		getCoreRowModel: getCoreRowModel(),
 	});
 
 	const downloadExcel = () => {
-		const csv = exportListToExcel(filteredRows, users, groups);
+		const csv = exportListToExcel(displayUsers, users, groups);
 
 		const element = document.createElement("a");
-		const file = new Blob([csv], {type: "text/csv"});
+		const file = new Blob([csv], { type: "text/csv" });
 		element.href = URL.createObjectURL(file);
 		element.download = "users.csv";
 		document.body.appendChild(element);
@@ -561,53 +549,53 @@ export default function UserList({
 					onViewStudents={
 						(selectedUser.type === "corporate" || selectedUser.type === "teacher") && studentsFromAdmin.length > 0
 							? () => {
-									appendUserFilters({
+								appendUserFilters({
-										id: "view-students",
+									id: "view-students",
-										filter: viewStudentFilter,
+									filter: viewStudentFilter,
-									});
+								});
-									appendUserFilters({
+								appendUserFilters({
-										id: "belongs-to-admin",
+									id: "belongs-to-admin",
-										filter: belongsToAdminFilter,
+									filter: belongsToAdminFilter,
-									});
+								});
 
-									router.push("/list/users");
+								router.push("/list/users");
-							  }
+							}
 							: undefined
 					}
 					onViewTeachers={
 						(selectedUser.type === "corporate" || selectedUser.type === "student") && teachersFromAdmin.length > 0
 							? () => {
-									appendUserFilters({
+								appendUserFilters({
-										id: "view-teachers",
+									id: "view-teachers",
-										filter: viewTeacherFilter,
+									filter: viewTeacherFilter,
-									});
+								});
-									appendUserFilters({
+								appendUserFilters({
-										id: "belongs-to-admin",
+									id: "belongs-to-admin",
-										filter: belongsToAdminFilter,
+									filter: belongsToAdminFilter,
-									});
+								});
 
-									router.push("/list/users");
+								router.push("/list/users");
-							  }
+							}
 							: undefined
 					}
 					onViewCorporate={
 						selectedUser.type === "teacher" || selectedUser.type === "student"
 							? () => {
-									appendUserFilters({
+								appendUserFilters({
-										id: "view-corporate",
+									id: "view-corporate",
-										filter: (x: User) => x.type === "corporate",
+									filter: (x: User) => x.type === "corporate",
-									});
+								});
-									appendUserFilters({
+								appendUserFilters({
-										id: "belongs-to-admin",
+									id: "belongs-to-admin",
-										filter: (x: User) =>
+									filter: (x: User) =>
-											groups
+										groups
-												.filter((g) => g.participants.includes(selectedUser.id))
+											.filter((g) => g.participants.includes(selectedUser.id))
-												.flatMap((g) => [g.admin, ...g.participants])
+											.flatMap((g) => [g.admin, ...g.participants])
-												.includes(x.id),
+											.includes(x.id),
-									});
+								});
 
-									router.push("/list/users");
+								router.push("/list/users");
-							  }
+							}
 							: undefined
 					}
 					onClose={(shouldReload) => {
@@ -629,12 +617,32 @@ export default function UserList({
 				</Modal>
 				<div className="w-full flex flex-col gap-2">
 					<div className="w-full flex gap-2 items-end">
-						{renderSearch()}
+						<Input label="Search" type="text" name="search" onChange={setSearchTerm} placeholder="Enter search text" value={searchTerm} />
 						<Button className="w-full max-w-[200px] mb-1" variant="outline" onClick={downloadExcel}>
 							Download List
 						</Button>
 					</div>
-					{renderPagination()}
+					<div className="w-full flex gap-2 justify-between">
+						<Button
+							isLoading={isLoading}
+							className="w-full max-w-[200px]"
+							disabled={page === 0}
+							onClick={() => setPage((prev) => prev - 1)}>
+							Previous Page
+						</Button>
+						<div className="flex items-center gap-4 w-fit">
+							<span className="opacity-80">
+								{page * userHash.size + 1} - {(page + 1) * userHash.size > total ? total : (page + 1) * userHash.size} / {total}
+							</span>
+							<Button
+								isLoading={isLoading}
+								className="w-[200px]"
+								disabled={(page + 1) * userHash.size >= total}
+								onClick={() => setPage((prev) => prev + 1)}>
+								Next Page
+							</Button>
+						</div>
+					</div>
 					<table className="rounded-xl bg-mti-purple-ultralight/40 w-full">
 						<thead>
 							{table.getHeaderGroups().map((headerGroup) => (

src/pages/api/assignments/corporate/[id].ts

@@ -22,7 +22,7 @@ async function handler(req: NextApiRequest, res: NextApiResponse) {
 async function GET(req: NextApiRequest, res: NextApiResponse) {
 	const {id} = req.query as {id: string};
 
-	const assigners = await getAllAssignersByCorporate(id, req.session.user!.type);
+	const assigners = await getAllAssignersByCorporate(id);
 	const assignments = await getAssignmentsByAssigners([...assigners, id]);
 
 	res.status(200).json(uniqBy(assignments, "id"));

src/pages/api/assignments/corporate/index.ts

@@ -29,7 +29,7 @@ async function GET(req: NextApiRequest, res: NextApiResponse) {
 	try {
 		const idsList = ids.split(",");
 
-		const assignments = await getAssignmentsForCorporates(req.session.user!.type, idsList, startDateParsed, endDateParsed);
+		const assignments = await getAssignmentsForCorporates(idsList, startDateParsed, endDateParsed);
 		res.status(200).json(assignments);
 	} catch (err: any) {
 		res.status(500).json({error: err.message});

src/pages/api/assignments/statistical/excel.ts

@@ -1,255 +1,254 @@
-import type {NextApiRequest, NextApiResponse} from "next";
+import type { NextApiRequest, NextApiResponse } from "next";
-import {storage} from "@/firebase";
+import { storage } from "@/firebase";
-import {withIronSessionApiRoute} from "iron-session/next";
+import { withIronSessionApiRoute } from "iron-session/next";
-import {sessionOptions} from "@/lib/session";
+import { sessionOptions } from "@/lib/session";
-import {ref, uploadBytes, getDownloadURL} from "firebase/storage";
+import { ref, uploadBytes, getDownloadURL } from "firebase/storage";
-import {AssignmentWithCorporateId} from "@/interfaces/results";
+import { AssignmentWithCorporateId } from "@/interfaces/results";
 import moment from "moment-timezone";
 import ExcelJS from "exceljs";
-import {getSpecificUsers} from "@/utils/users.be";
+import { getSpecificUsers } from "@/utils/users.be";
-import {checkAccess} from "@/utils/permissions";
+import { checkAccess } from "@/utils/permissions";
-import {getAssignmentsForCorporates} from "@/utils/assignments.be";
+import { getAssignmentsForCorporates } from "@/utils/assignments.be";
-import {search} from "@/utils/search";
+import { search } from "@/utils/search";
-import {getGradingSystem} from "@/utils/grading.be";
+import { getGradingSystem } from "@/utils/grading.be";
-import {StudentUser, User} from "@/interfaces/user";
+import { User } from "@/interfaces/user";
-import {calculateBandScore, getGradingLabel} from "@/utils/score";
+import { calculateBandScore, getGradingLabel } from "@/utils/score";
-import {Module} from "@/interfaces";
+import { Module } from "@/interfaces";
-import {uniq} from "lodash";
-import {getUserName} from "@/utils/users";
-import {LevelExam} from "@/interfaces/exam";
-import {getSpecificExams} from "@/utils/exams.be";
 
 export default withIronSessionApiRoute(handler, sessionOptions);
 
 interface TableData {
-	user: string;
+  user: string;
-	studentID: string;
+  email: string;
-	passportID: string;
+  correct: number;
-	exams: string;
+  corporate: string;
-	email: string;
+  submitted: boolean;
-	correct: number;
+  date: moment.Moment;
-	corporate: string;
+  assignment: string;
-	submitted: boolean;
+  corporateId: string;
-	date: moment.Moment;
+  score: number;
-	assignment: string;
+  level: string;
-	corporateId: string;
+  part1?: string;
-	score: number;
+  part2?: string;
-	level: string;
+  part3?: string;
-	part1?: string;
+  part4?: string;
-	part2?: string;
+  part5?: string;
-	part3?: string;
-	part4?: string;
-	part5?: string;
 }
 
 async function handler(req: NextApiRequest, res: NextApiResponse) {
-	// if (req.method === "GET") return get(req, res);
+  // if (req.method === "GET") return get(req, res);
-	if (req.method === "POST") return await post(req, res);
+  if (req.method === "POST") return await post(req, res);
 }
 
-const searchFilters = [["email"], ["user"], ["userId"], ["assignment"], ["exams"]];
+const searchFilters = [["email"], ["user"], ["userId"]];
 
 async function post(req: NextApiRequest, res: NextApiResponse) {
-	// verify if it's a logged user that is trying to export
+  // verify if it's a logged user that is trying to export
-	if (req.session.user) {
+  if (req.session.user) {
-		if (!checkAccess(req.session.user, ["mastercorporate", "corporate", "developer", "admin"])) {
+    if (
-			return res.status(403).json({error: "Unauthorized"});
+      !checkAccess(req.session.user, ["mastercorporate", "corporate", "developer", "admin"])
-		}
+    ) {
-		const {
+      return res.status(403).json({ error: "Unauthorized" });
-			ids,
+    }
-			startDate,
+    const {
-			endDate,
+      ids,
-			searchText,
+      startDate,
-			displaySelection = true,
+      endDate,
-		} = req.body as {
+      searchText,
-			ids: string[];
+      displaySelection = true,
-			startDate?: string;
+    } = req.body as {
-			endDate?: string;
+      ids: string[];
-			searchText: string;
+      startDate?: string;
-			displaySelection?: boolean;
+      endDate?: string;
-		};
+      searchText: string;
-		const startDateParsed = startDate ? new Date(startDate) : undefined;
+      displaySelection?: boolean;
-		const endDateParsed = endDate ? new Date(endDate) : undefined;
+    };
-		const assignments = await getAssignmentsForCorporates(req.session.user.type, ids, startDateParsed, endDateParsed);
+    const startDateParsed = startDate ? new Date(startDate) : undefined;
+    const endDateParsed = endDate ? new Date(endDate) : undefined;
+    const assignments = await getAssignmentsForCorporates(
+      ids,
+      startDateParsed,
+      endDateParsed
+    );
 
-		const assignmentUsers = uniq([...assignments.flatMap((x) => x.assignees), ...assignments.flatMap((x) => x.assigner)]);
+    const assignmentUsers = [
-		const assigners = [...new Set(assignments.map((a) => a.assigner))];
+      ...new Set(assignments.flatMap((a) => a.assignees)),
-		const users = await getSpecificUsers(assignmentUsers);
+    ];
-		const assignerUsers = await getSpecificUsers(assigners);
+    const assigners = [...new Set(assignments.map((a) => a.assigner))];
-		const exams = await getSpecificExams(uniq(assignments.flatMap((x) => x.exams.map((x) => x.id))));
+    const users = await getSpecificUsers(assignmentUsers);
+    const assignerUsers = await getSpecificUsers(assigners);
 
-		const assignerUsersGradingSystems = await Promise.all(
+    const assignerUsersGradingSystems = await Promise.all(
-			assignerUsers.map(async (user: User) => {
+      assignerUsers.map(async (user: User) => {
-				const data = await getGradingSystem(user);
+        const data = await getGradingSystem(user);
-				// in this context I need to override as I'll have to match to the assigner
+        // in this context I need to override as I'll have to match to the assigner
-				return {...data, user: user.id};
+        return { ...data, user: user.id };
-			}),
+      })
-		);
+    );
 
-		const getGradingSystemHelper = (
+    const getGradingSystemHelper = (
-			exams: {id: string; module: Module; assignee: string}[],
+      exams: { id: string; module: Module; assignee: string }[],
-			assigner: string,
+      assigner: string,
-			user: User,
+      user: User,
-			correct: number,
+      correct: number,
-			total: number,
+      total: number
-		) => {
+    ) => {
-			if (exams.some((e) => e.module === "level")) {
+      if (exams.some((e) => e.module === "level")) {
-				const gradingSystem = assignerUsersGradingSystems.find((gs) => gs.user === assigner);
+        const gradingSystem = assignerUsersGradingSystems.find(
-				if (gradingSystem) {
+          (gs) => gs.user === assigner
-					const bandScore = calculateBandScore(correct, total, "level", user?.focus || "academic");
+        );
-					return {
+        if (gradingSystem) {
-						label: getGradingLabel(bandScore, gradingSystem.steps || []),
+          const bandScore = calculateBandScore(
-						score: bandScore,
+            correct,
-					};
+            total,
-				}
+            "level",
-			}
+            user.focus
+          );
+          return {
+            label: getGradingLabel(bandScore, gradingSystem?.steps || []),
+            score: bandScore,
+          };
+        }
+      }
 
-			return {score: -1, label: "N/A"};
+      return { score: -1, label: "N/A" };
-		};
+    };
 
-		const tableResults = assignments
+    const tableResults = assignments
-			.reduce((accmA: TableData[], a: AssignmentWithCorporateId) => {
+      .reduce((accmA: TableData[], a: AssignmentWithCorporateId) => {
-				const userResults = a.assignees.map((assignee) => {
+        const userResults = a.assignees.map((assignee) => {
-					const userStats = a.results.find((r) => r.user === assignee)?.stats || [];
+          const userStats =
-					const userData = users.find((u) => u.id === assignee);
+            a.results.find((r) => r.user === assignee)?.stats || [];
-					const corporateUser = users.find((u) => u.id === a.assigner);
+          const userData = users.find((u) => u.id === assignee);
-					const correct = userStats.reduce((n, e) => n + e.score.correct, 0);
+          const corporateUser = users.find((u) => u.id === a.assigner);
-					const total = userStats.reduce((n, e) => n + e.score.total, 0);
+          const correct = userStats.reduce((n, e) => n + e.score.correct, 0);
-					const {label: level, score} = getGradingSystemHelper(a.exams, a.assigner, userData!, correct, total);
+          const total = userStats.reduce((n, e) => n + e.score.total, 0);
+          const { label: level, score } = getGradingSystemHelper(
+            a.exams,
+            a.assigner,
+            userData!,
+            correct,
+            total
+          );
 
-					const commonData = {
+          console.log("Level", level);
-						user: userData?.name || "",
+          const commonData = {
-						email: userData?.email || "",
+            user: userData?.name || "",
-						studentID: (userData as StudentUser)?.studentID || "",
+            email: userData?.email || "",
-						passportID: (userData as StudentUser)?.demographicInformation?.passport_id || "",
+            userId: assignee,
-						userId: assignee,
+            corporateId: a.corporateId,
-						exams: a.exams.map((x) => x.id).join(", "),
+            corporate: corporateUser?.name || "",
-						corporateId: a.corporateId,
+            assignment: a.name,
-						corporate: !corporateUser ? "" : getUserName(corporateUser),
+            level,
-						assignment: a.name,
+            score,
-						level,
+          };
-						score,
+          if (userStats.length === 0) {
-					};
+            return {
-					if (userStats.length === 0) {
+              ...commonData,
-						return {
+              correct: 0,
-							...commonData,
+              submitted: false,
-							correct: 0,
+              // date: moment(),
-							submitted: false,
+            };
-							// date: moment(),
+          }
-						};
-					}
 
-					let data: {total: number; correct: number}[] = [];
+          const partsData = userStats.every((e) => e.module === "level")
-					if (a.exams.every((x) => x.module === "level")) {
+            ? userStats.reduce((acc, e, index) => {
-						const exam = exams.find((x) => x.id === a.exams.find((x) => x.assignee === assignee)?.id) as LevelExam;
+                return {
-						data = exam.parts.map((x) => {
+                  ...acc,
-							const exerciseIDs = x.exercises.map((x) => x.id);
+                  [`part${index}`]: `${e.score.correct}/${e.score.total}`,
-							const stats = userStats.filter((x) => exerciseIDs.includes(x.exercise));
+                };
+              }, {})
+            : {};
 
-							const total = stats.reduce((acc, curr) => acc + curr.score.total, 0);
+          return {
-							const correct = stats.reduce((acc, curr) => acc + curr.score.correct, 0);
+            ...commonData,
+            correct,
+            submitted: true,
+            date: moment.max(userStats.map((e) => moment(e.date))),
+            ...partsData,
+          };
+        }) as TableData[];
 
-							return {total, correct};
+        return [...accmA, ...userResults];
-						});
+      }, [])
-					}
+      .sort((a, b) => b.score - a.score);
 
-					const partsData =
+    // Create a new workbook and add a worksheet
-						data.length > 0 ? data.reduce((acc, e, index) => ({...acc, [`part${index}`]: `${e.correct}/${e.total}`}), {}) : {};
+    const workbook = new ExcelJS.Workbook();
+    const worksheet = workbook.addWorksheet("Master Statistical");
 
-					return {
+    const headers = [
-						...commonData,
+      {
-						correct,
+        label: "User",
-						submitted: true,
+        value: (entry: TableData) => entry.user,
-						date: moment.max(userStats.map((e) => moment(e.date))),
+      },
-						...partsData,
+      {
-					};
+        label: "Email",
-				}) as TableData[];
+        value: (entry: TableData) => entry.email,
+      },
+      ...(displaySelection
+        ? [
+            {
+              label: "Corporate",
+              value: (entry: TableData) => entry.corporate,
+            },
+          ]
+        : []),
+      {
+        label: "Assignment",
+        value: (entry: TableData) => entry.assignment,
+      },
+      {
+        label: "Submitted",
+        value: (entry: TableData) => (entry.submitted ? "Yes" : "No"),
+      },
+      {
+        label: "Correct",
+        value: (entry: TableData) => entry.correct,
+      },
+      {
+        label: "Date",
+        value: (entry: TableData) => entry.date?.format("YYYY/MM/DD") || "",
+      },
+      {
+        label: "Level",
+        value: (entry: TableData) => entry.level,
+      },
+      ...new Array(5).fill(0).map((_, index) => ({
+        label: `Part ${index + 1}`,
+        value: (entry: TableData) => {
+          const key = `part${index}` as keyof TableData;
+          return entry[key] || "";
+        },
+      })),
+    ];
 
-				return [...accmA, ...userResults];
+    const filteredSearch = searchText
-			}, [])
+      ? search(searchText, searchFilters, tableResults)
-			.sort((a, b) => b.score - a.score);
+      : tableResults;
 
-		// Create a new workbook and add a worksheet
+    worksheet.addRow(headers.map((h) => h.label));
-		const workbook = new ExcelJS.Workbook();
+    (filteredSearch as TableData[]).forEach((entry) => {
-		const worksheet = workbook.addWorksheet("Master Statistical");
+      worksheet.addRow(headers.map((h) => h.value(entry)));
+    });
 
-		const headers = [
+    // Convert workbook to Buffer (Node.js) or Blob (Browser)
-			{
+    const buffer = await workbook.xlsx.writeBuffer();
-				label: "User",
-				value: (entry: TableData) => entry.user,
-			},
-			{
-				label: "Email",
-				value: (entry: TableData) => entry.email,
-			},
-			{
-				label: "Student ID",
-				value: (entry: TableData) => entry.studentID,
-			},
-			{
-				label: "Passport ID",
-				value: (entry: TableData) => entry.passportID,
-			},
-			...(displaySelection
-				? [
-						{
-							label: "Corporate",
-							value: (entry: TableData) => entry.corporate,
-						},
-				  ]
-				: []),
-			{
-				label: "Assignment",
-				value: (entry: TableData) => entry.assignment,
-			},
-			{
-				label: "Submitted",
-				value: (entry: TableData) => (entry.submitted ? "Yes" : "No"),
-			},
-			{
-				label: "Score",
-				value: (entry: TableData) => entry.correct,
-			},
-			{
-				label: "Date",
-				value: (entry: TableData) => entry.date?.format("YYYY/MM/DD") || "",
-			},
-			{
-				label: "Level",
-				value: (entry: TableData) => entry.level,
-			},
-			...new Array(5).fill(0).map((_, index) => ({
-				label: `Part ${index + 1}`,
-				value: (entry: TableData) => {
-					const key = `part${index}` as keyof TableData;
-					return entry[key] || "";
-				},
-			})),
-		];
 
-		const filteredSearch = !!searchText ? search(searchText, searchFilters, tableResults) : tableResults;
+    // generate the file ref for storage
+    const fileName = `${Date.now().toString()}.xlsx`;
+    const refName = `statistical/${fileName}`;
+    const fileRef = ref(storage, refName);
+    // upload the pdf to storage
+    await uploadBytes(fileRef, buffer, {
+      contentType:
+        "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
+    });
 
-		worksheet.addRow(headers.map((h) => h.label));
+    const url = await getDownloadURL(fileRef);
-		(filteredSearch as TableData[]).forEach((entry) => {
+    res.status(200).end(url);
-			worksheet.addRow(headers.map((h) => h.value(entry)));
+    return;
-		});
+  }
 
-		// Convert workbook to Buffer (Node.js) or Blob (Browser)
+  return res.status(401).json({ error: "Unauthorized" });
-		const buffer = await workbook.xlsx.writeBuffer();
-
-		// generate the file ref for storage
-		const fileName = `${Date.now().toString()}.xlsx`;
-		const refName = `statistical/${fileName}`;
-		const fileRef = ref(storage, refName);
-		// upload the pdf to storage
-		await uploadBytes(fileRef, buffer, {
-			contentType: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
-		});
-
-		const url = await getDownloadURL(fileRef);
-		res.status(200).end(url);
-		return;
-	}
-
-	return res.status(401).json({error: "Unauthorized"});
 }

src/pages/api/users/list.ts

@@ -4,7 +4,6 @@ import {withIronSessionApiRoute} from "iron-session/next";
 import {sessionOptions} from "@/lib/session";
 import {getLinkedUsers} from "@/utils/users.be";
 import {Type} from "@/interfaces/user";
-import {uniqBy} from "lodash";
 
 export default withIronSessionApiRoute(handler, sessionOptions);
 
@@ -20,7 +19,8 @@ async function handler(req: NextApiRequest, res: NextApiResponse) {
 		page,
 		orderBy,
 		direction = "desc",
-	} = req.query as {size?: string; type?: Type; page?: string; orderBy?: string; direction?: "asc" | "desc"};
+		searchTerm
+	} = req.query as {size?: string; type?: Type; page?: string; orderBy?: string; direction?: "asc" | "desc"; searchTerm?: string | undefined};
 
 	const {users, total} = await getLinkedUsers(
 		req.session.user?.id,
@@ -30,7 +30,8 @@ async function handler(req: NextApiRequest, res: NextApiResponse) {
 		size !== undefined ? parseInt(size) : undefined,
 		orderBy,
 		direction,
+		searchTerm
 	);
 
-	res.status(200).json({users: uniqBy([...users], "id"), total});
+	res.status(200).json({users, total});
 }

src/utils/assignments.be.ts

@@ -1,7 +1,6 @@
 import client from "@/lib/mongodb";
 import {Assignment} from "@/interfaces/results";
 import {getAllAssignersByCorporate} from "@/utils/groups.be";
-import {Type} from "@/interfaces/user";
 
 const db = client.db(process.env.MONGODB_DB);
 
@@ -37,10 +36,10 @@ export const getAssignmentsByAssigners = async (ids: string[], startDate?: Date,
 		.toArray();
 };
 
-export const getAssignmentsForCorporates = async (userType: Type, idsList: string[], startDate?: Date, endDate?: Date) => {
+export const getAssignmentsForCorporates = async (idsList: string[], startDate?: Date, endDate?: Date) => {
 	const assigners = await Promise.all(
 		idsList.map(async (id) => {
-			const assigners = await getAllAssignersByCorporate(id, userType);
+			const assigners = await getAllAssignersByCorporate(id);
 			return {
 				corporateId: id,
 				assigners,

src/utils/exams.be.ts

@@ -6,28 +6,6 @@ import {Module} from "@/interfaces";
 import {getCorporateUser} from "@/resources/user";
 import {getUserCorporate} from "./groups.be";
 import {Db, ObjectId} from "mongodb";
-import client from "@/lib/mongodb";
-import {MODULE_ARRAY} from "./moduleUtils";
-
-const db = client.db(process.env.MONGODB_DB);
-
-export async function getSpecificExams(ids: string[]) {
-	if (ids.length === 0) return [];
-
-	const exams: Exam[] = (
-		await Promise.all(
-			MODULE_ARRAY.flatMap(
-				async (module) =>
-					await db
-						.collection(module)
-						.find<Exam>({id: {$in: ids}})
-						.toArray(),
-			),
-		)
-	).flat();
-
-	return exams;
-}
 
 export const getExams = async (
 	db: Db,

src/utils/groups.be.ts

@@ -1,6 +1,6 @@
 import {app} from "@/firebase";
 import {Assignment} from "@/interfaces/results";
-import {CorporateUser, Group, MasterCorporateUser, StudentUser, TeacherUser, Type, User} from "@/interfaces/user";
+import {CorporateUser, Group, MasterCorporateUser, StudentUser, TeacherUser, User} from "@/interfaces/user";
 import client from "@/lib/mongodb";
 import moment from "moment";
 import {getLinkedUsers, getUser} from "./users.be";
@@ -71,9 +71,9 @@ export const getUsersGroups = async (ids: string[]) => {
 		.toArray();
 };
 
-export const getAllAssignersByCorporate = async (corporateID: string, type: Type): Promise<string[]> => {
+export const getAllAssignersByCorporate = async (corporateID: string): Promise<string[]> => {
-	const linkedTeachers = await getLinkedUsers(corporateID, type, "teacher");
+	const linkedTeachers = await getLinkedUsers(corporateID, "mastercorporate", "teacher");
-	const linkedCorporates = await getLinkedUsers(corporateID, type, "corporate");
+	const linkedCorporates = await getLinkedUsers(corporateID, "mastercorporate", "corporate");
 
 	return [...linkedTeachers.users.map((x) => x.id), ...linkedCorporates.users.map((x) => x.id)];
 };

src/utils/search.ts

@@ -1,3 +1,4 @@
+
 /*fields example = [
     ['id'],
     ['companyInformation', 'companyInformation', 'name']
@@ -12,17 +13,17 @@ const getFieldValue = (fields: string[], data: any): string => {
 };
 
 export const search = (text: string, fields: string[][], rows: any[]) => {
-	const searchText = text.toLowerCase();
+    const searchText = text.toLowerCase();
-	return rows.filter((row) => {
+    return rows.filter((row) => {
-		return fields.some((fieldsKeys) => {
+        return fields.some((fieldsKeys) => {
-			const value = getFieldValue(fieldsKeys, row);
+            const value = getFieldValue(fieldsKeys, row);
-			if (typeof value === "string") {
+            if (typeof value === "string") {
-				return value.toLowerCase().includes(searchText);
+                return value.toLowerCase().includes(searchText);
-			}
+            }
 
-			if (typeof value === "number") {
+            if (typeof value === "number") {
-				return (value as Number).toString().includes(searchText);
+                return (value as Number).toString().includes(searchText);
-			}
+            }
-		});
+        });
-	});
+    });
-};
+}

src/utils/users.be.ts

@@ -1,7 +1,7 @@
-import {CorporateUser, Group, Type, User} from "@/interfaces/user";
+import { CorporateUser, Group, Type, User } from "@/interfaces/user";
-import {getGroupsForUser, getParticipantGroups, getUserGroups, getUsersGroups} from "./groups.be";
+import { getGroupsForUser, getParticipantGroups, getUserGroups, getUsersGroups } from "./groups.be";
-import {last, uniq, uniqBy} from "lodash";
+import { last, uniq, uniqBy } from "lodash";
-import {getUserCodes} from "./codes.be";
+import { getUserCodes } from "./codes.be";
 import moment from "moment";
 import client from "@/lib/mongodb";
 
@@ -12,7 +12,7 @@ export async function getUsers() {
 }
 
 export async function getUser(id: string): Promise<User | undefined> {
-	const user = await db.collection("users").findOne<User>({id});
+	const user = await db.collection("users").findOne<User>({ id });
 	return !!user ? user : undefined;
 }
 
@@ -21,7 +21,7 @@ export async function getSpecificUsers(ids: string[]) {
 
 	return await db
 		.collection("users")
-		.find<User>({id: {$in: ids}})
+		.find<User>({ id: { $in: ids } })
 		.toArray();
 }
 
@@ -33,21 +33,32 @@ export async function getLinkedUsers(
 	size?: number,
 	sort?: string,
 	direction?: "asc" | "desc",
+	searchTerm?: string | undefined,
 ) {
-	const filters = {
+	const filters: any = {};
-		...(!!type ? {type} : {}),
+
-	};
+	if (type) {
+		filters.type = type;
+	}
+
+	if (searchTerm) {
+		filters.$or = [
+			{ name: { $regex: searchTerm, $options: 'i' } },
+			{ email: { $regex: searchTerm, $options: 'i' } },
+			{ company: { $regex: searchTerm, $options: 'i' } },
+		];
+	}
 
 	if (!userID || userType === "admin" || userType === "developer") {
 		const users = await db
 			.collection("users")
 			.find<User>(filters)
-			.sort(sort ? {[sort]: direction === "desc" ? -1 : 1} : {})
+			.sort(sort ? { [sort]: direction === "desc" ? -1 : 1 } : {})
 			.skip(page && size ? page * size : 0)
 			.limit(size || 0)
 			.toArray();
 		const total = await db.collection("users").countDocuments(filters);
-		return {users, total};
+		return { users, total };
 	}
 
 	const adminGroups = await getUserGroups(userID);
@@ -61,17 +72,17 @@ export async function getLinkedUsers(
 	]);
 
 	//  ⨯ [FirebaseError: Invalid Query. A non-empty array is required for 'in' filters.] {
-	if (participants.length === 0) return {users: [], total: 0};
+	if (participants.length === 0) return { users: [], total: 0 };
 
 	const users = await db
 		.collection("users")
-		.find<User>({...filters, id: {$in: participants}})
+		.find<User>({ ...filters, id: { $in: participants } })
 		.skip(page && size ? page * size : 0)
 		.limit(size || 0)
 		.toArray();
-	const total = await db.collection("users").countDocuments({...filters, id: {$in: participants}});
+	const total = await db.collection("users").countDocuments({ ...filters, id: { $in: participants } });
 
-	return {users, total};
+	return { users, total };
 }
 
 export async function getUserBalance(user: User) {