Compare commits
18 Commits
feature/tr
...
bugfix/mon
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
3c1c4489f8 | ||
|
|
044ec8d966 | ||
|
|
07c9074d15 | ||
|
|
71bac76c3a | ||
|
|
fb293dc98c | ||
|
|
3ce97b4dcd | ||
|
|
7bfd000213 | ||
|
|
2a10933206 | ||
|
|
33a46c227b | ||
|
|
5153c3d5f1 | ||
|
|
85c8f622ee | ||
|
|
b9c097d42c | ||
|
|
192132559b | ||
|
|
392eac2ef9 | ||
|
|
a073ca1cce | ||
|
|
7e30ca5750 | ||
|
|
2e065eddcb | ||
|
|
4e91b2f1fb |
@@ -1,546 +1,405 @@
|
|||||||
/* eslint-disable @next/next/no-img-element */
|
/* eslint-disable @next/next/no-img-element */
|
||||||
import Modal from "@/components/Modal";
|
import Modal from "@/components/Modal";
|
||||||
import useFilterRecordsByUser from "@/hooks/useFilterRecordsByUser";
|
import useFilterRecordsByUser from "@/hooks/useFilterRecordsByUser";
|
||||||
import useUsers, {
|
import useUsers, {userHashStudent, userHashTeacher, userHashCorporate} from "@/hooks/useUsers";
|
||||||
userHashStudent,
|
import {CorporateUser, Group, MasterCorporateUser, Stat, User} from "@/interfaces/user";
|
||||||
userHashTeacher,
|
|
||||||
userHashCorporate,
|
|
||||||
} from "@/hooks/useUsers";
|
|
||||||
import {
|
|
||||||
CorporateUser,
|
|
||||||
Group,
|
|
||||||
MasterCorporateUser,
|
|
||||||
Stat,
|
|
||||||
User,
|
|
||||||
} from "@/interfaces/user";
|
|
||||||
import UserList from "@/pages/(admin)/Lists/UserList";
|
import UserList from "@/pages/(admin)/Lists/UserList";
|
||||||
import { dateSorter } from "@/utils";
|
import {dateSorter} from "@/utils";
|
||||||
import moment from "moment";
|
import moment from "moment";
|
||||||
import { useEffect, useMemo, useState } from "react";
|
import {useEffect, useMemo, useState} from "react";
|
||||||
import {
|
import {
|
||||||
BsArrowLeft,
|
BsArrowLeft,
|
||||||
BsClipboard2Data,
|
BsClipboard2Data,
|
||||||
BsClipboard2DataFill,
|
BsClipboard2DataFill,
|
||||||
BsClock,
|
BsClock,
|
||||||
BsGlobeCentralSouthAsia,
|
BsGlobeCentralSouthAsia,
|
||||||
BsPaperclip,
|
BsPaperclip,
|
||||||
BsPerson,
|
BsPerson,
|
||||||
BsPersonAdd,
|
BsPersonAdd,
|
||||||
BsPersonFill,
|
BsPersonFill,
|
||||||
BsPersonFillGear,
|
BsPersonFillGear,
|
||||||
BsPersonGear,
|
BsPersonGear,
|
||||||
BsPencilSquare,
|
BsPencilSquare,
|
||||||
BsPersonBadge,
|
BsPersonBadge,
|
||||||
BsPersonCheck,
|
BsPersonCheck,
|
||||||
BsPeople,
|
BsPeople,
|
||||||
BsArrowRepeat,
|
BsArrowRepeat,
|
||||||
BsPlus,
|
BsPlus,
|
||||||
BsEnvelopePaper,
|
BsEnvelopePaper,
|
||||||
BsDatabase,
|
BsDatabase,
|
||||||
} from "react-icons/bs";
|
} from "react-icons/bs";
|
||||||
import UserCard from "@/components/UserCard";
|
import UserCard from "@/components/UserCard";
|
||||||
import useGroups from "@/hooks/useGroups";
|
import useGroups from "@/hooks/useGroups";
|
||||||
import {
|
import {averageLevelCalculator, calculateAverageLevel, calculateBandScore} from "@/utils/score";
|
||||||
averageLevelCalculator,
|
import {MODULE_ARRAY} from "@/utils/moduleUtils";
|
||||||
calculateAverageLevel,
|
import {Module} from "@/interfaces";
|
||||||
calculateBandScore,
|
import {groupByExam} from "@/utils/stats";
|
||||||
} from "@/utils/score";
|
|
||||||
import { MODULE_ARRAY } from "@/utils/moduleUtils";
|
|
||||||
import { Module } from "@/interfaces";
|
|
||||||
import { groupByExam } from "@/utils/stats";
|
|
||||||
import IconCard from "../IconCard";
|
import IconCard from "../IconCard";
|
||||||
import GroupList from "@/pages/(admin)/Lists/GroupList";
|
import GroupList from "@/pages/(admin)/Lists/GroupList";
|
||||||
import useFilterStore from "@/stores/listFilterStore";
|
import useFilterStore from "@/stores/listFilterStore";
|
||||||
import { useRouter } from "next/router";
|
import {useRouter} from "next/router";
|
||||||
import useCodes from "@/hooks/useCodes";
|
import useCodes from "@/hooks/useCodes";
|
||||||
import { getUserCorporate } from "@/utils/groups";
|
import {getUserCorporate} from "@/utils/groups";
|
||||||
import useAssignments from "@/hooks/useAssignments";
|
import useAssignments from "@/hooks/useAssignments";
|
||||||
import { Assignment } from "@/interfaces/results";
|
import {Assignment} from "@/interfaces/results";
|
||||||
import AssignmentView from "../AssignmentView";
|
import AssignmentView from "../AssignmentView";
|
||||||
import AssignmentCreator from "../AssignmentCreator";
|
import AssignmentCreator from "../AssignmentCreator";
|
||||||
import clsx from "clsx";
|
import clsx from "clsx";
|
||||||
import AssignmentCard from "../AssignmentCard";
|
import AssignmentCard from "../AssignmentCard";
|
||||||
import { createColumnHelper } from "@tanstack/react-table";
|
import {createColumnHelper} from "@tanstack/react-table";
|
||||||
import Checkbox from "@/components/Low/Checkbox";
|
import Checkbox from "@/components/Low/Checkbox";
|
||||||
import List from "@/components/List";
|
import List from "@/components/List";
|
||||||
import { getUserCompanyName } from "@/resources/user";
|
import {getUserCompanyName} from "@/resources/user";
|
||||||
import {
|
import {futureAssignmentFilter, pastAssignmentFilter, archivedAssignmentFilter, activeAssignmentFilter} from "@/utils/assignments";
|
||||||
futureAssignmentFilter,
|
|
||||||
pastAssignmentFilter,
|
|
||||||
archivedAssignmentFilter,
|
|
||||||
activeAssignmentFilter,
|
|
||||||
} from "@/utils/assignments";
|
|
||||||
import useUserBalance from "@/hooks/useUserBalance";
|
import useUserBalance from "@/hooks/useUserBalance";
|
||||||
import AssignmentsPage from "../views/AssignmentsPage";
|
import AssignmentsPage from "../views/AssignmentsPage";
|
||||||
import StudentPerformancePage from "./StudentPerformancePage";
|
import StudentPerformancePage from "./StudentPerformancePage";
|
||||||
import MasterStatistical from "../MasterCorporate/MasterStatistical";
|
import MasterStatistical from "../MasterCorporate/MasterStatistical";
|
||||||
|
import MasterStatisticalPage from "./MasterStatisticalPage";
|
||||||
|
|
||||||
interface Props {
|
interface Props {
|
||||||
user: CorporateUser;
|
user: CorporateUser;
|
||||||
linkedCorporate?: CorporateUser | MasterCorporateUser;
|
linkedCorporate?: CorporateUser | MasterCorporateUser;
|
||||||
}
|
}
|
||||||
|
|
||||||
const studentHash = {
|
const studentHash = {
|
||||||
type: "student",
|
type: "student",
|
||||||
orderBy: "registrationDate",
|
orderBy: "registrationDate",
|
||||||
size: 25,
|
size: 25,
|
||||||
};
|
};
|
||||||
|
|
||||||
const teacherHash = {
|
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 {
|
const {assignments, isLoading: isAssignmentsLoading, reload: reloadAssignments} = useAssignments({corporate: user.id});
|
||||||
assignments,
|
const {balance} = useUserBalance();
|
||||||
isLoading: isAssignmentsLoading,
|
|
||||||
reload: reloadAssignments,
|
|
||||||
} = useAssignments({ corporate: user.id });
|
|
||||||
const { balance } = useUserBalance();
|
|
||||||
|
|
||||||
const {
|
const {users: students, total: totalStudents, reload: reloadStudents, isLoading: isStudentsLoading} = useUsers(studentHash);
|
||||||
users: students,
|
const {users: teachers, total: totalTeachers, reload: reloadTeachers, isLoading: isTeachersLoading} = useUsers(teacherHash);
|
||||||
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(
|
const assignmentsGroups = useMemo(() => groups.filter((x) => x.admin === user.id || x.participants.includes(user.id)), [groups, user.id]);
|
||||||
() =>
|
|
||||||
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) =>
|
const getStatsByStudent = (user: User) => stats.filter((s) => s.user === user.id);
|
||||||
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" />
|
||||||
<img
|
<div className="flex flex-col gap-1 items-start">
|
||||||
src={displayUser.profilePicture}
|
<span>{displayUser.name}</span>
|
||||||
alt={displayUser.name}
|
<span className="text-sm opacity-75">{displayUser.email}</span>
|
||||||
className="rounded-full w-10 h-10"
|
</div>
|
||||||
/>
|
</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>
|
|
||||||
);
|
|
||||||
|
|
||||||
// this workaround will allow us toreuse the master statistical due to master corporate restraints
|
const GroupsList = () => {
|
||||||
// while still being able to use the corporate user
|
const filter = (x: Group) => x.admin === user.id || x.participants.includes(user.id);
|
||||||
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}
|
|
||||||
/>
|
|
||||||
</>
|
|
||||||
);
|
|
||||||
};
|
|
||||||
|
|
||||||
const GroupsList = () => {
|
return (
|
||||||
const filter = (x: Group) =>
|
<>
|
||||||
x.admin === user.id || x.participants.includes(user.id);
|
<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>
|
||||||
|
|
||||||
return (
|
<GroupList user={user} />
|
||||||
<>
|
</>
|
||||||
<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>
|
|
||||||
|
|
||||||
<GroupList user={user} />
|
const averageLevelCalculator = (studentStats: Stat[]) => {
|
||||||
</>
|
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 averageLevelCalculator = (studentStats: Stat[]) => {
|
const levels: {[key in Module]: number} = {
|
||||||
const formattedStats = studentStats
|
reading: 0,
|
||||||
.map((s) => ({
|
listening: 0,
|
||||||
focus: students.find((u) => u.id === s.user)?.focus,
|
writing: 0,
|
||||||
score: s.score,
|
speaking: 0,
|
||||||
module: s.module,
|
level: 0,
|
||||||
}))
|
};
|
||||||
.filter((f) => !!f.focus);
|
bandScores.forEach((b) => (levels[b.module] += b.level));
|
||||||
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 } = {
|
return calculateAverageLevel(levels);
|
||||||
reading: 0,
|
};
|
||||||
listening: 0,
|
|
||||||
writing: 0,
|
|
||||||
speaking: 0,
|
|
||||||
level: 0,
|
|
||||||
};
|
|
||||||
bandScores.forEach((b) => (levels[b.module] += b.level));
|
|
||||||
|
|
||||||
return calculateAverageLevel(levels);
|
if (router.asPath === "/#students")
|
||||||
};
|
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 === "/#students")
|
if (router.asPath === "/#teachers")
|
||||||
return (
|
return (
|
||||||
<UserList
|
<UserList
|
||||||
user={user}
|
user={user}
|
||||||
type="student"
|
type="teacher"
|
||||||
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" />
|
||||||
<BsArrowLeft className="text-xl" />
|
<span>Back</span>
|
||||||
<span>Back</span>
|
</div>
|
||||||
</div>
|
<h2 className="text-2xl font-semibold">Teachers ({total})</h2>
|
||||||
<h2 className="text-2xl font-semibold">Students ({total})</h2>
|
</div>
|
||||||
</div>
|
)}
|
||||||
)}
|
/>
|
||||||
/>
|
);
|
||||||
);
|
|
||||||
|
|
||||||
if (router.asPath === "/#teachers")
|
if (router.asPath === "/#groups") return <GroupsList />;
|
||||||
return (
|
if (router.asPath === "/#studentsPerformance") return <StudentPerformancePage user={user} />;
|
||||||
<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 === "/#groups") return <GroupsList />;
|
if (router.asPath === "/#assignments")
|
||||||
if (router.asPath === "/#studentsPerformance")
|
return (
|
||||||
return <StudentPerformancePage user={user} />;
|
<AssignmentsPage
|
||||||
|
assignments={assignments}
|
||||||
|
user={user}
|
||||||
|
groups={assignmentsGroups}
|
||||||
|
reloadAssignments={reloadAssignments}
|
||||||
|
isLoading={isAssignmentsLoading}
|
||||||
|
onBack={() => router.push("/")}
|
||||||
|
/>
|
||||||
|
);
|
||||||
|
|
||||||
if (router.asPath === "/#assignments")
|
if (router.asPath === "/#statistical") return <MasterStatisticalPage user={user} />;
|
||||||
return (
|
|
||||||
<AssignmentsPage
|
|
||||||
assignments={assignments}
|
|
||||||
user={user}
|
|
||||||
groups={assignmentsGroups}
|
|
||||||
reloadAssignments={reloadAssignments}
|
|
||||||
isLoading={isAssignmentsLoading}
|
|
||||||
onBack={() => router.push("/")}
|
|
||||||
/>
|
|
||||||
);
|
|
||||||
|
|
||||||
if (router.asPath === "/#statistical") return <MasterStatisticalPage />;
|
return (
|
||||||
|
<>
|
||||||
|
<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),
|
||||||
|
});
|
||||||
|
|
||||||
return (
|
router.push("/list/users");
|
||||||
<>
|
}
|
||||||
<Modal isOpen={showModal} onClose={() => setSelectedUser(undefined)}>
|
: undefined
|
||||||
<>
|
}
|
||||||
{selectedUser && (
|
onViewTeachers={
|
||||||
<div className="w-full flex flex-col gap-8">
|
selectedUser.type === "corporate" || selectedUser.type === "student"
|
||||||
<UserCard
|
? () => {
|
||||||
loggedInUser={user}
|
appendUserFilters({
|
||||||
onClose={(shouldReload) => {
|
id: "view-teachers",
|
||||||
setSelectedUser(undefined);
|
filter: (x: User) => x.type === "teacher",
|
||||||
if (shouldReload && selectedUser!.type === "student")
|
});
|
||||||
reloadStudents();
|
appendUserFilters({
|
||||||
if (shouldReload && selectedUser!.type === "teacher")
|
id: "belongs-to-admin",
|
||||||
reloadTeachers();
|
filter: (x: User) =>
|
||||||
}}
|
groups
|
||||||
onViewStudents={
|
.filter((g) => g.admin === selectedUser.id || g.participants.includes(selectedUser.id))
|
||||||
selectedUser.type === "corporate" ||
|
.flatMap((g) => g.participants)
|
||||||
selectedUser.type === "teacher"
|
.includes(x.id),
|
||||||
? () => {
|
});
|
||||||
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
|
||||||
}
|
}
|
||||||
onViewTeachers={
|
user={selectedUser}
|
||||||
selectedUser.type === "corporate" ||
|
/>
|
||||||
selectedUser.type === "student"
|
</div>
|
||||||
? () => {
|
)}
|
||||||
appendUserFilters({
|
</>
|
||||||
id: "view-teachers",
|
</Modal>
|
||||||
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 && (
|
||||||
: undefined
|
<div className="absolute top-4 right-4 bg-neutral-200 px-2 rounded-lg py-1">
|
||||||
}
|
Linked to: <b>{linkedCorporate?.corporateInformation?.companyInformation.name || linkedCorporate.name}</b>
|
||||||
user={selectedUser}
|
</div>
|
||||||
/>
|
)}
|
||||||
</div>
|
<section className="grid grid-cols-5 -md:grid-cols-2 gap-4 text-center">
|
||||||
)}
|
<IconCard
|
||||||
</>
|
onClick={() => router.push("/#students")}
|
||||||
</Modal>
|
isLoading={isStudentsLoading}
|
||||||
|
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">
|
||||||
{!!linkedCorporate && (
|
<div className="bg-white shadow flex flex-col rounded-xl w-full">
|
||||||
<div className="absolute top-4 right-4 bg-neutral-200 px-2 rounded-lg py-1">
|
<span className="p-4">Latest students</span>
|
||||||
Linked to:{" "}
|
<div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
|
||||||
<b>
|
{students
|
||||||
{linkedCorporate?.corporateInformation?.companyInformation.name ||
|
.sort((a, b) => dateSorter(a, b, "desc", "registrationDate"))
|
||||||
linkedCorporate.name}
|
.map((x) => (
|
||||||
</b>
|
<UserDisplay key={x.id} {...x} />
|
||||||
</div>
|
))}
|
||||||
)}
|
</div>
|
||||||
<section className="grid grid-cols-5 -md:grid-cols-2 gap-4 text-center">
|
</div>
|
||||||
<IconCard
|
<div className="bg-white shadow flex flex-col rounded-xl w-full">
|
||||||
onClick={() => router.push("/#students")}
|
<span className="p-4">Latest teachers</span>
|
||||||
isLoading={isStudentsLoading}
|
<div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
|
||||||
Icon={BsPersonFill}
|
{teachers
|
||||||
label="Students"
|
.sort((a, b) => dateSorter(a, b, "desc", "registrationDate"))
|
||||||
value={totalStudents}
|
.map((x) => (
|
||||||
color="purple"
|
<UserDisplay key={x.id} {...x} />
|
||||||
/>
|
))}
|
||||||
<IconCard
|
</div>
|
||||||
onClick={() => router.push("/#teachers")}
|
</div>
|
||||||
isLoading={isTeachersLoading}
|
<div className="bg-white shadow flex flex-col rounded-xl w-full">
|
||||||
Icon={BsPencilSquare}
|
<span className="p-4">Highest level students</span>
|
||||||
label="Teachers"
|
<div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
|
||||||
value={totalTeachers}
|
{students
|
||||||
color="purple"
|
.sort((a, b) => calculateAverageLevel(b.levels) - calculateAverageLevel(a.levels))
|
||||||
/>
|
.map((x) => (
|
||||||
<IconCard
|
<UserDisplay key={x.id} {...x} />
|
||||||
Icon={BsClipboard2Data}
|
))}
|
||||||
label="Exams Performed"
|
</div>
|
||||||
value={
|
</div>
|
||||||
stats.filter((s) =>
|
<div className="bg-white shadow flex flex-col rounded-xl w-full">
|
||||||
groups.flatMap((g) => g.participants).includes(s.user)
|
<span className="p-4">Highest exam count students</span>
|
||||||
).length
|
<div className="flex flex-col items-start h-96 overflow-scroll scrollbar-hide">
|
||||||
}
|
{students
|
||||||
color="purple"
|
.sort(
|
||||||
/>
|
(a, b) =>
|
||||||
<IconCard
|
Object.keys(groupByExam(getStatsByStudent(b))).length - Object.keys(groupByExam(getStatsByStudent(a))).length,
|
||||||
Icon={BsPaperclip}
|
)
|
||||||
isLoading={isStudentsLoading}
|
.map((x) => (
|
||||||
label="Average Level"
|
<UserDisplay key={x.id} {...x} />
|
||||||
value={averageLevelCalculator(
|
))}
|
||||||
stats.filter((s) =>
|
</div>
|
||||||
groups.flatMap((g) => g.participants).includes(s.user)
|
</div>
|
||||||
)
|
</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>
|
|
||||||
</>
|
|
||||||
</>
|
|
||||||
);
|
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -1,5 +1,5 @@
|
|||||||
import React, {useEffect, useMemo, useState} from "react";
|
import React, {useEffect, useMemo, useState} from "react";
|
||||||
import {CorporateUser, User} from "@/interfaces/user";
|
import {CorporateUser, StudentUser, User} from "@/interfaces/user";
|
||||||
import {BsFileExcel, BsBank, BsPersonFill} from "react-icons/bs";
|
import {BsFileExcel, BsBank, BsPersonFill} from "react-icons/bs";
|
||||||
import IconCard from "../IconCard";
|
import IconCard from "../IconCard";
|
||||||
|
|
||||||
@@ -28,7 +28,7 @@ interface Props {
|
|||||||
}
|
}
|
||||||
|
|
||||||
interface TableData {
|
interface TableData {
|
||||||
user: string;
|
user: User | undefined;
|
||||||
email: string;
|
email: string;
|
||||||
correct: number;
|
correct: number;
|
||||||
corporate: string;
|
corporate: string;
|
||||||
@@ -62,7 +62,7 @@ const MasterStatistical = (props: Props) => {
|
|||||||
const [startDate, setStartDate] = React.useState<Date | null>(moment("01/01/2023").toDate());
|
const [startDate, setStartDate] = React.useState<Date | null>(moment("01/01/2023").toDate());
|
||||||
const [endDate, setEndDate] = React.useState<Date | null>(moment().endOf("year").toDate());
|
const [endDate, setEndDate] = React.useState<Date | null>(moment().endOf("year").toDate());
|
||||||
|
|
||||||
const {assignments} = useAssignmentsCorporates({
|
const {assignments, isLoading} = useAssignmentsCorporates({
|
||||||
corporates: selectedCorporates,
|
corporates: selectedCorporates,
|
||||||
startDate,
|
startDate,
|
||||||
endDate,
|
endDate,
|
||||||
@@ -74,11 +74,11 @@ const MasterStatistical = (props: Props) => {
|
|||||||
() =>
|
() =>
|
||||||
assignments.reduce((accmA: TableData[], a: AssignmentWithCorporateId) => {
|
assignments.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 userData = users.find((u) => u.id === assignee);
|
const userData = users.find((u) => u.id === assignee);
|
||||||
|
const userStats = a.results.find((r) => r.user === assignee)?.stats || [];
|
||||||
const corporate = getUserName(users.find((u) => u.id === a.assigner));
|
const corporate = getUserName(users.find((u) => u.id === a.assigner));
|
||||||
const commonData = {
|
const commonData = {
|
||||||
user: userData?.name || "N/A",
|
user: userData,
|
||||||
email: userData?.email || "N/A",
|
email: userData?.email || "N/A",
|
||||||
userId: assignee,
|
userId: assignee,
|
||||||
corporateId: a.corporateId,
|
corporateId: a.corporateId,
|
||||||
@@ -86,6 +86,7 @@ const MasterStatistical = (props: Props) => {
|
|||||||
corporate,
|
corporate,
|
||||||
assignment: a.name,
|
assignment: a.name,
|
||||||
};
|
};
|
||||||
|
|
||||||
if (userStats.length === 0) {
|
if (userStats.length === 0) {
|
||||||
return {
|
return {
|
||||||
...commonData,
|
...commonData,
|
||||||
@@ -108,8 +109,6 @@ const MasterStatistical = (props: Props) => {
|
|||||||
[assignments, users],
|
[assignments, users],
|
||||||
);
|
);
|
||||||
|
|
||||||
useEffect(() => console.log(assignments), [assignments]);
|
|
||||||
|
|
||||||
const getCorporateScores = (corporateId: string): UserCount => {
|
const getCorporateScores = (corporateId: string): UserCount => {
|
||||||
const corporateAssignmentsUsers = assignments.filter((a) => a.corporateId === corporateId).reduce((acc, a) => acc + a.assignees.length, 0);
|
const corporateAssignmentsUsers = assignments.filter((a) => a.corporateId === corporateId).reduce((acc, a) => acc + a.assignees.length, 0);
|
||||||
|
|
||||||
@@ -151,7 +150,7 @@ const MasterStatistical = (props: Props) => {
|
|||||||
header: "User",
|
header: "User",
|
||||||
id: "user",
|
id: "user",
|
||||||
cell: (info) => {
|
cell: (info) => {
|
||||||
return <span>{info.getValue()}</span>;
|
return <span>{info.getValue()?.name || "N/A"}</span>;
|
||||||
},
|
},
|
||||||
}),
|
}),
|
||||||
columnHelper.accessor("email", {
|
columnHelper.accessor("email", {
|
||||||
@@ -161,6 +160,13 @@ const MasterStatistical = (props: Props) => {
|
|||||||
return <span>{info.getValue()}</span>;
|
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
|
...(displaySelection
|
||||||
? [
|
? [
|
||||||
columnHelper.accessor("corporate", {
|
columnHelper.accessor("corporate", {
|
||||||
@@ -281,6 +287,7 @@ const MasterStatistical = (props: Props) => {
|
|||||||
<IconCard
|
<IconCard
|
||||||
Icon={BsBank}
|
Icon={BsBank}
|
||||||
label="Consolidate"
|
label="Consolidate"
|
||||||
|
isLoading={isLoading}
|
||||||
value={getConsolidateScoreStr(consolidateScore)}
|
value={getConsolidateScoreStr(consolidateScore)}
|
||||||
color="purple"
|
color="purple"
|
||||||
onClick={() => {
|
onClick={() => {
|
||||||
@@ -302,6 +309,7 @@ const MasterStatistical = (props: Props) => {
|
|||||||
<IconCard
|
<IconCard
|
||||||
key={corporateName}
|
key={corporateName}
|
||||||
Icon={BsBank}
|
Icon={BsBank}
|
||||||
|
isLoading={isLoading}
|
||||||
label={corporateName}
|
label={corporateName}
|
||||||
value={value}
|
value={value}
|
||||||
color="purple"
|
color="purple"
|
||||||
@@ -343,7 +351,7 @@ const MasterStatistical = (props: Props) => {
|
|||||||
</div>
|
</div>
|
||||||
{renderSearch()}
|
{renderSearch()}
|
||||||
<div className="flex flex-col gap-3 justify-end">
|
<div className="flex flex-col gap-3 justify-end">
|
||||||
<Button className="max-w-[200px] h-[70px]" variant="outline" onClick={triggerDownload}>
|
<Button className="w-[200px] h-[70px]" variant="outline" isLoading={downloading} onClick={triggerDownload}>
|
||||||
Download
|
Download
|
||||||
</Button>
|
</Button>
|
||||||
</div>
|
</div>
|
||||||
@@ -359,7 +367,7 @@ const MasterStatistical = (props: Props) => {
|
|||||||
{page * SIZE + 1} - {(page + 1) * SIZE > filteredRows.length ? filteredRows.length : (page + 1) * SIZE} /{" "}
|
{page * SIZE + 1} - {(page + 1) * SIZE > filteredRows.length ? filteredRows.length : (page + 1) * SIZE} /{" "}
|
||||||
{filteredRows.length}
|
{filteredRows.length}
|
||||||
</span>
|
</span>
|
||||||
<Button className="w-[200px]" disabled={(page + 1) * SIZE >= rows.length} onClick={() => setPage((prev) => prev + 1)}>
|
<Button className="w-[200px]" disabled={(page + 1) * SIZE >= filteredRows.length} onClick={() => setPage((prev) => prev + 1)}>
|
||||||
Next Page
|
Next Page
|
||||||
</Button>
|
</Button>
|
||||||
</div>
|
</div>
|
||||||
|
|||||||
@@ -55,7 +55,7 @@ export default function AssignmentsPage({assignments, corporateAssignments, user
|
|||||||
<AssignmentCreator
|
<AssignmentCreator
|
||||||
assignment={selectedAssignment}
|
assignment={selectedAssignment}
|
||||||
groups={groups}
|
groups={groups}
|
||||||
users={users}
|
users={[...users, user]}
|
||||||
user={user}
|
user={user}
|
||||||
isCreating={isCreatingAssignment}
|
isCreating={isCreatingAssignment}
|
||||||
cancelCreation={() => {
|
cancelCreation={() => {
|
||||||
|
|||||||
@@ -287,7 +287,9 @@ export default function Finish({user, scores, modules, information, solutions, i
|
|||||||
<div className="flex w-fit cursor-pointer flex-col items-center gap-1">
|
<div className="flex w-fit cursor-pointer flex-col items-center gap-1">
|
||||||
<button
|
<button
|
||||||
onClick={() => window.location.reload()}
|
onClick={() => window.location.reload()}
|
||||||
disabled={user.type === "admin"}
|
// disabled={user.type === "admin"}
|
||||||
|
// TODO: temporarily disabled
|
||||||
|
disabled
|
||||||
className="bg-mti-purple-light hover:bg-mti-purple flex h-11 w-11 items-center justify-center rounded-full transition duration-300 ease-in-out">
|
className="bg-mti-purple-light hover:bg-mti-purple flex h-11 w-11 items-center justify-center rounded-full transition duration-300 ease-in-out">
|
||||||
<BsArrowCounterclockwise className="h-7 w-7 text-white" />
|
<BsArrowCounterclockwise className="h-7 w-7 text-white" />
|
||||||
</button>
|
</button>
|
||||||
|
|||||||
@@ -1,6 +1,6 @@
|
|||||||
import {useState, useMemo} from "react";
|
import {useState, useMemo} from "react";
|
||||||
import Input from "@/components/Low/Input";
|
import Input from "@/components/Low/Input";
|
||||||
import { search } from "@/utils/search";
|
import {search} from "@/utils/search";
|
||||||
|
|
||||||
export function useListSearch<T>(fields: string[][], rows: T[]) {
|
export function useListSearch<T>(fields: string[][], rows: T[]) {
|
||||||
const [text, setText] = useState("");
|
const [text, setText] = useState("");
|
||||||
@@ -8,7 +8,8 @@ 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 renderSearch = () => <Input label="Search" type="text" name="search" onChange={setText} placeholder="Enter search text" value={text} />;
|
||||||
|
|
||||||
const updatedRows = useMemo(() => {
|
const updatedRows = useMemo(() => {
|
||||||
return search(text, fields, rows);
|
if (text.length > 0) return search(text, fields, rows);
|
||||||
|
return rows;
|
||||||
}, [fields, rows, text]);
|
}, [fields, rows, text]);
|
||||||
|
|
||||||
return {
|
return {
|
||||||
|
|||||||
28
src/hooks/usePagination.tsx
Normal file
28
src/hooks/usePagination.tsx
Normal file
@@ -0,0 +1,28 @@
|
|||||||
|
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};
|
||||||
|
}
|
||||||
@@ -9,7 +9,7 @@ export const userHashStudent = {type: "student"} as {type: Type};
|
|||||||
export const userHashTeacher = {type: "teacher"} as {type: Type};
|
export const userHashTeacher = {type: "teacher"} as {type: Type};
|
||||||
export const userHashCorporate = {type: "corporate"} 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", searchTerm?: string | undefined}) {
|
export default function useUsers(props?: {type?: string; page?: number; size?: number; orderBy?: string; direction?: "asc" | "desc"}) {
|
||||||
const [users, setUsers] = useState<User[]>([]);
|
const [users, setUsers] = useState<User[]>([]);
|
||||||
const [total, setTotal] = useState(0);
|
const [total, setTotal] = useState(0);
|
||||||
const [isLoading, setIsLoading] = useState(false);
|
const [isLoading, setIsLoading] = useState(false);
|
||||||
@@ -23,8 +23,6 @@ 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());
|
if (props[key as keyof typeof props] !== undefined) params.append(key, props[key as keyof typeof props]!.toString());
|
||||||
});
|
});
|
||||||
|
|
||||||
console.log(params.toString());
|
|
||||||
|
|
||||||
setIsLoading(true);
|
setIsLoading(true);
|
||||||
axios
|
axios
|
||||||
.get<{users: User[]; total: number}>(`/api/users/list?${params.toString()}`, {headers: {page: "register"}})
|
.get<{users: User[]; total: number}>(`/api/users/list?${params.toString()}`, {headers: {page: "register"}})
|
||||||
@@ -35,7 +33,7 @@ export default function useUsers(props?: {type?: string; page?: number; size?: n
|
|||||||
.finally(() => setIsLoading(false));
|
.finally(() => setIsLoading(false));
|
||||||
};
|
};
|
||||||
// eslint-disable-next-line react-hooks/exhaustive-deps
|
// eslint-disable-next-line react-hooks/exhaustive-deps
|
||||||
useEffect(getData, [props?.page, props?.size, props?.type, props?.orderBy, props?.direction, props?.searchTerm]);
|
useEffect(getData, [props?.page, props?.size, props?.type, props?.orderBy, props?.direction]);
|
||||||
|
|
||||||
return {users, total, isLoading, isError, reload: getData};
|
return {users, total, isLoading, isError, reload: getData};
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -1,34 +1,34 @@
|
|||||||
import Button from "@/components/Low/Button";
|
import Button from "@/components/Low/Button";
|
||||||
import { PERMISSIONS } from "@/constants/userPermissions";
|
import {PERMISSIONS} from "@/constants/userPermissions";
|
||||||
import useGroups from "@/hooks/useGroups";
|
import useGroups from "@/hooks/useGroups";
|
||||||
import useUsers from "@/hooks/useUsers";
|
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 axios from "axios";
|
||||||
import clsx from "clsx";
|
import clsx from "clsx";
|
||||||
import { capitalize, reverse } from "lodash";
|
import {capitalize, reverse} from "lodash";
|
||||||
import moment from "moment";
|
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 countryCodes from "country-codes-list";
|
||||||
import Modal from "@/components/Modal";
|
import Modal from "@/components/Modal";
|
||||||
import UserCard from "@/components/UserCard";
|
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 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 usePermissions from "@/hooks/usePermissions";
|
||||||
import useUserBalance from "@/hooks/useUserBalance";
|
import useUserBalance from "@/hooks/useUserBalance";
|
||||||
import Input from "@/components/Low/Input";
|
import usePagination from "@/hooks/usePagination";
|
||||||
const columnHelper = createColumnHelper<User>();
|
const columnHelper = createColumnHelper<User>();
|
||||||
const searchFields = [["name"], ["email"], ["corporateInformation", "companyInformation", "name"]];
|
const searchFields = [["name"], ["email"], ["corporateInformation", "companyInformation", "name"]];
|
||||||
|
|
||||||
@@ -63,11 +63,15 @@ export default function UserList({
|
|||||||
const [sorter, setSorter] = useState<string>();
|
const [sorter, setSorter] = useState<string>();
|
||||||
const [displayUsers, setDisplayUsers] = useState<User[]>([]);
|
const [displayUsers, setDisplayUsers] = useState<User[]>([]);
|
||||||
const [selectedUser, setSelectedUser] = useState<User>();
|
const [selectedUser, setSelectedUser] = useState<User>();
|
||||||
const [page, setPage] = useState(0);
|
|
||||||
const [searchTerm, setSearchTerm] = useState<string | undefined>(undefined);
|
|
||||||
|
|
||||||
const { users, total, isLoading, reload } = useUsers({type: type, size: 16, page: page, searchTerm: searchTerm});
|
const userHash = useMemo(
|
||||||
|
() => ({
|
||||||
|
type,
|
||||||
|
}),
|
||||||
|
[type],
|
||||||
|
);
|
||||||
|
|
||||||
|
const {users, total, isLoading, reload} = useUsers(userHash);
|
||||||
const {users: corporates} = useUsers(corporatesHash);
|
const {users: corporates} = useUsers(corporatesHash);
|
||||||
|
|
||||||
const totalUsers = useMemo(() => [...users, ...corporates], [users, corporates]);
|
const totalUsers = useMemo(() => [...users, ...corporates], [users, corporates]);
|
||||||
@@ -96,9 +100,9 @@ export default function UserList({
|
|||||||
(async () => {
|
(async () => {
|
||||||
if (users && users.length > 0) {
|
if (users && users.length > 0) {
|
||||||
const filteredUsers = filters.reduce((d, f) => d.filter(f), users);
|
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([...sortedUsers]);
|
setDisplayUsers([...filteredUsers]);
|
||||||
}
|
}
|
||||||
})();
|
})();
|
||||||
// eslint-disable-next-line react-hooks/exhaustive-deps
|
// eslint-disable-next-line react-hooks/exhaustive-deps
|
||||||
@@ -108,20 +112,20 @@ export default function UserList({
|
|||||||
if (!confirm(`Are you sure you want to delete ${user.name}'s account?`)) return;
|
if (!confirm(`Are you sure you want to delete ${user.name}'s account?`)) return;
|
||||||
|
|
||||||
axios
|
axios
|
||||||
.delete<{ ok: boolean }>(`/api/user?id=${user.id}`)
|
.delete<{ok: boolean}>(`/api/user?id=${user.id}`)
|
||||||
.then(() => {
|
.then(() => {
|
||||||
toast.success("User deleted successfully!");
|
toast.success("User deleted successfully!");
|
||||||
reload();
|
reload();
|
||||||
})
|
})
|
||||||
.catch(() => {
|
.catch(() => {
|
||||||
toast.error("Something went wrong!", { toastId: "delete-error" });
|
toast.error("Something went wrong!", {toastId: "delete-error"});
|
||||||
})
|
})
|
||||||
.finally(reload);
|
.finally(reload);
|
||||||
};
|
};
|
||||||
|
|
||||||
const verifyAccount = (user: User) => {
|
const verifyAccount = (user: User) => {
|
||||||
axios
|
axios
|
||||||
.post<{ user?: User; ok?: boolean }>(`/api/users/update?id=${user.id}`, {
|
.post<{user?: User; ok?: boolean}>(`/api/users/update?id=${user.id}`, {
|
||||||
...user,
|
...user,
|
||||||
isVerified: true,
|
isVerified: true,
|
||||||
})
|
})
|
||||||
@@ -130,21 +134,22 @@ export default function UserList({
|
|||||||
reload();
|
reload();
|
||||||
})
|
})
|
||||||
.catch(() => {
|
.catch(() => {
|
||||||
toast.error("Something went wrong!", { toastId: "update-error" });
|
toast.error("Something went wrong!", {toastId: "update-error"});
|
||||||
});
|
});
|
||||||
};
|
};
|
||||||
|
|
||||||
const toggleDisableAccount = (user: User) => {
|
const toggleDisableAccount = (user: User) => {
|
||||||
if (
|
if (
|
||||||
!confirm(
|
!confirm(
|
||||||
`Are you sure you want to ${user.status === "disabled" ? "enable" : "disable"} ${user.name
|
`Are you sure you want to ${user.status === "disabled" ? "enable" : "disable"} ${
|
||||||
|
user.name
|
||||||
}'s account? This change is usually related to their payment state.`,
|
}'s account? This change is usually related to their payment state.`,
|
||||||
)
|
)
|
||||||
)
|
)
|
||||||
return;
|
return;
|
||||||
|
|
||||||
axios
|
axios
|
||||||
.post<{ user?: User; ok?: boolean }>(`/api/users/update?id=${user.id}`, {
|
.post<{user?: User; ok?: boolean}>(`/api/users/update?id=${user.id}`, {
|
||||||
...user,
|
...user,
|
||||||
status: user.status === "disabled" ? "active" : "disabled",
|
status: user.status === "disabled" ? "active" : "disabled",
|
||||||
})
|
})
|
||||||
@@ -153,18 +158,18 @@ export default function UserList({
|
|||||||
reload();
|
reload();
|
||||||
})
|
})
|
||||||
.catch(() => {
|
.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 === name) return <BsArrowUp />;
|
||||||
if (sorter === reverseString(name)) return <BsArrowDown />;
|
if (sorter === reverseString(name)) return <BsArrowDown />;
|
||||||
|
|
||||||
return <BsArrowDownUp />;
|
return <BsArrowDownUp />;
|
||||||
};
|
};
|
||||||
|
|
||||||
const actionColumn = ({ row }: { row: { original: User } }) => {
|
const actionColumn = ({row}: {row: {original: User}}) => {
|
||||||
const updateUserPermission = PERMISSIONS.updateUser[row.original.type] as {
|
const updateUserPermission = PERMISSIONS.updateUser[row.original.type] as {
|
||||||
list: Type[];
|
list: Type[];
|
||||||
perm: PermissionType;
|
perm: PermissionType;
|
||||||
@@ -209,11 +214,11 @@ export default function UserList({
|
|||||||
<SorterArrow name="name" />
|
<SorterArrow name="name" />
|
||||||
</button>
|
</button>
|
||||||
) as any,
|
) as any,
|
||||||
cell: ({ row, getValue }) => (
|
cell: ({row, getValue}) => (
|
||||||
<div
|
<div
|
||||||
className={clsx(
|
className={clsx(
|
||||||
checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) &&
|
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={() =>
|
onClick={() =>
|
||||||
checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) ? setSelectedUser(row.original) : null
|
checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) ? setSelectedUser(row.original) : null
|
||||||
@@ -231,8 +236,9 @@ export default function UserList({
|
|||||||
) as any,
|
) as any,
|
||||||
cell: (info) =>
|
cell: (info) =>
|
||||||
info.getValue()
|
info.getValue()
|
||||||
? `${countryCodes.findOne("countryCode" as any, info.getValue())?.flag} ${countries[info.getValue() as unknown as keyof TCountries]?.name
|
? `${countryCodes.findOne("countryCode" as any, info.getValue())?.flag} ${
|
||||||
} (+${countryCodes.findOne("countryCode" as any, info.getValue())?.countryCallingCode})`
|
countries[info.getValue() as unknown as keyof TCountries]?.name
|
||||||
|
} (+${countryCodes.findOne("countryCode" as any, info.getValue())?.countryCallingCode})`
|
||||||
: "N/A",
|
: "N/A",
|
||||||
}),
|
}),
|
||||||
columnHelper.accessor("demographicInformation.phone", {
|
columnHelper.accessor("demographicInformation.phone", {
|
||||||
@@ -298,11 +304,11 @@ export default function UserList({
|
|||||||
<SorterArrow name="name" />
|
<SorterArrow name="name" />
|
||||||
</button>
|
</button>
|
||||||
) as any,
|
) as any,
|
||||||
cell: ({ row, getValue }) => (
|
cell: ({row, getValue}) => (
|
||||||
<div
|
<div
|
||||||
className={clsx(
|
className={clsx(
|
||||||
checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) &&
|
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={() =>
|
onClick={() =>
|
||||||
checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) ? setSelectedUser(row.original) : null
|
checkAccess(user, ["admin", "corporate", "developer", "mastercorporate"]) ? setSelectedUser(row.original) : null
|
||||||
@@ -318,11 +324,11 @@ export default function UserList({
|
|||||||
<SorterArrow name="email" />
|
<SorterArrow name="email" />
|
||||||
</button>
|
</button>
|
||||||
) as any,
|
) as any,
|
||||||
cell: ({ row, getValue }) => (
|
cell: ({row, getValue}) => (
|
||||||
<div
|
<div
|
||||||
className={clsx(
|
className={clsx(
|
||||||
PERMISSIONS.updateExpiryDate[row.original.type]?.includes(user.type) &&
|
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)}>
|
onClick={() => (PERMISSIONS.updateExpiryDate[row.original.type]?.includes(user.type) ? setSelectedUser(row.original) : null)}>
|
||||||
{getValue()}
|
{getValue()}
|
||||||
@@ -505,17 +511,23 @@ export default function UserList({
|
|||||||
return a.id.localeCompare(b.id);
|
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({
|
const table = useReactTable({
|
||||||
data: displayUsers,
|
data: items,
|
||||||
columns: (!showDemographicInformation ? defaultColumns : demographicColumns) as any,
|
columns: (!showDemographicInformation ? defaultColumns : demographicColumns) as any,
|
||||||
getCoreRowModel: getCoreRowModel(),
|
getCoreRowModel: getCoreRowModel(),
|
||||||
});
|
});
|
||||||
|
|
||||||
const downloadExcel = () => {
|
const downloadExcel = () => {
|
||||||
const csv = exportListToExcel(displayUsers, users, groups);
|
const csv = exportListToExcel(filteredRows, users, groups);
|
||||||
|
|
||||||
const element = document.createElement("a");
|
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.href = URL.createObjectURL(file);
|
||||||
element.download = "users.csv";
|
element.download = "users.csv";
|
||||||
document.body.appendChild(element);
|
document.body.appendChild(element);
|
||||||
@@ -549,53 +561,53 @@ export default function UserList({
|
|||||||
onViewStudents={
|
onViewStudents={
|
||||||
(selectedUser.type === "corporate" || selectedUser.type === "teacher") && studentsFromAdmin.length > 0
|
(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
|
: undefined
|
||||||
}
|
}
|
||||||
onViewTeachers={
|
onViewTeachers={
|
||||||
(selectedUser.type === "corporate" || selectedUser.type === "student") && teachersFromAdmin.length > 0
|
(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
|
: undefined
|
||||||
}
|
}
|
||||||
onViewCorporate={
|
onViewCorporate={
|
||||||
selectedUser.type === "teacher" || selectedUser.type === "student"
|
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
|
: undefined
|
||||||
}
|
}
|
||||||
onClose={(shouldReload) => {
|
onClose={(shouldReload) => {
|
||||||
@@ -617,32 +629,12 @@ export default function UserList({
|
|||||||
</Modal>
|
</Modal>
|
||||||
<div className="w-full flex flex-col gap-2">
|
<div className="w-full flex flex-col gap-2">
|
||||||
<div className="w-full flex gap-2 items-end">
|
<div className="w-full flex gap-2 items-end">
|
||||||
<Input label="Search" type="text" name="search" onChange={setSearchTerm} placeholder="Enter search text" value={searchTerm} />
|
{renderSearch()}
|
||||||
<Button className="w-full max-w-[200px] mb-1" variant="outline" onClick={downloadExcel}>
|
<Button className="w-full max-w-[200px] mb-1" variant="outline" onClick={downloadExcel}>
|
||||||
Download List
|
Download List
|
||||||
</Button>
|
</Button>
|
||||||
</div>
|
</div>
|
||||||
<div className="w-full flex gap-2 justify-between">
|
{renderPagination()}
|
||||||
<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">
|
<table className="rounded-xl bg-mti-purple-ultralight/40 w-full">
|
||||||
<thead>
|
<thead>
|
||||||
{table.getHeaderGroups().map((headerGroup) => (
|
{table.getHeaderGroups().map((headerGroup) => (
|
||||||
|
|||||||
@@ -22,7 +22,7 @@ async function handler(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
async function GET(req: NextApiRequest, res: NextApiResponse) {
|
async function GET(req: NextApiRequest, res: NextApiResponse) {
|
||||||
const {id} = req.query as {id: string};
|
const {id} = req.query as {id: string};
|
||||||
|
|
||||||
const assigners = await getAllAssignersByCorporate(id);
|
const assigners = await getAllAssignersByCorporate(id, req.session.user!.type);
|
||||||
const assignments = await getAssignmentsByAssigners([...assigners, id]);
|
const assignments = await getAssignmentsByAssigners([...assigners, id]);
|
||||||
|
|
||||||
res.status(200).json(uniqBy(assignments, "id"));
|
res.status(200).json(uniqBy(assignments, "id"));
|
||||||
|
|||||||
@@ -29,7 +29,7 @@ async function GET(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
try {
|
try {
|
||||||
const idsList = ids.split(",");
|
const idsList = ids.split(",");
|
||||||
|
|
||||||
const assignments = await getAssignmentsForCorporates(idsList, startDateParsed, endDateParsed);
|
const assignments = await getAssignmentsForCorporates(req.session.user!.type, idsList, startDateParsed, endDateParsed);
|
||||||
res.status(200).json(assignments);
|
res.status(200).json(assignments);
|
||||||
} catch (err: any) {
|
} catch (err: any) {
|
||||||
res.status(500).json({error: err.message});
|
res.status(500).json({error: err.message});
|
||||||
|
|||||||
@@ -1,254 +1,255 @@
|
|||||||
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 moment from "moment-timezone";
|
||||||
import ExcelJS from "exceljs";
|
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 { User } from "@/interfaces/user";
|
import {StudentUser, 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);
|
export default withIronSessionApiRoute(handler, sessionOptions);
|
||||||
|
|
||||||
interface TableData {
|
interface TableData {
|
||||||
user: string;
|
user: string;
|
||||||
email: string;
|
studentID: string;
|
||||||
correct: number;
|
passportID: string;
|
||||||
corporate: string;
|
exams: string;
|
||||||
submitted: boolean;
|
email: string;
|
||||||
date: moment.Moment;
|
correct: number;
|
||||||
assignment: string;
|
corporate: string;
|
||||||
corporateId: string;
|
submitted: boolean;
|
||||||
score: number;
|
date: moment.Moment;
|
||||||
level: string;
|
assignment: string;
|
||||||
part1?: string;
|
corporateId: string;
|
||||||
part2?: string;
|
score: number;
|
||||||
part3?: string;
|
level: string;
|
||||||
part4?: string;
|
part1?: string;
|
||||||
part5?: string;
|
part2?: string;
|
||||||
|
part3?: string;
|
||||||
|
part4?: string;
|
||||||
|
part5?: string;
|
||||||
}
|
}
|
||||||
|
|
||||||
async function handler(req: NextApiRequest, res: NextApiResponse) {
|
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"]];
|
const searchFilters = [["email"], ["user"], ["userId"], ["assignment"], ["exams"]];
|
||||||
|
|
||||||
async function post(req: NextApiRequest, res: NextApiResponse) {
|
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 (
|
if (!checkAccess(req.session.user, ["mastercorporate", "corporate", "developer", "admin"])) {
|
||||||
!checkAccess(req.session.user, ["mastercorporate", "corporate", "developer", "admin"])
|
return res.status(403).json({error: "Unauthorized"});
|
||||||
) {
|
}
|
||||||
return res.status(403).json({ error: "Unauthorized" });
|
const {
|
||||||
}
|
ids,
|
||||||
const {
|
startDate,
|
||||||
ids,
|
endDate,
|
||||||
startDate,
|
searchText,
|
||||||
endDate,
|
displaySelection = true,
|
||||||
searchText,
|
} = req.body as {
|
||||||
displaySelection = true,
|
ids: string[];
|
||||||
} = req.body as {
|
startDate?: string;
|
||||||
ids: string[];
|
endDate?: string;
|
||||||
startDate?: string;
|
searchText: string;
|
||||||
endDate?: string;
|
displaySelection?: boolean;
|
||||||
searchText: string;
|
};
|
||||||
displaySelection?: boolean;
|
const startDateParsed = startDate ? new Date(startDate) : undefined;
|
||||||
};
|
const endDateParsed = endDate ? new Date(endDate) : undefined;
|
||||||
const startDateParsed = startDate ? new Date(startDate) : undefined;
|
const assignments = await getAssignmentsForCorporates(req.session.user.type, ids, startDateParsed, endDateParsed);
|
||||||
const endDateParsed = endDate ? new Date(endDate) : undefined;
|
|
||||||
const assignments = await getAssignmentsForCorporates(
|
|
||||||
ids,
|
|
||||||
startDateParsed,
|
|
||||||
endDateParsed
|
|
||||||
);
|
|
||||||
|
|
||||||
const assignmentUsers = [
|
const assignmentUsers = uniq([...assignments.flatMap((x) => x.assignees), ...assignments.flatMap((x) => x.assigner)]);
|
||||||
...new Set(assignments.flatMap((a) => a.assignees)),
|
const assigners = [...new Set(assignments.map((a) => a.assigner))];
|
||||||
];
|
const users = await getSpecificUsers(assignmentUsers);
|
||||||
const assigners = [...new Set(assignments.map((a) => a.assigner))];
|
const assignerUsers = await getSpecificUsers(assigners);
|
||||||
const users = await getSpecificUsers(assignmentUsers);
|
const exams = await getSpecificExams(uniq(assignments.flatMap((x) => x.exams.map((x) => x.id))));
|
||||||
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(
|
const gradingSystem = assignerUsersGradingSystems.find((gs) => gs.user === assigner);
|
||||||
(gs) => gs.user === assigner
|
if (gradingSystem) {
|
||||||
);
|
const bandScore = calculateBandScore(correct, total, "level", user?.focus || "academic");
|
||||||
if (gradingSystem) {
|
return {
|
||||||
const bandScore = calculateBandScore(
|
label: getGradingLabel(bandScore, gradingSystem.steps || []),
|
||||||
correct,
|
score: bandScore,
|
||||||
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 =
|
const userStats = a.results.find((r) => r.user === assignee)?.stats || [];
|
||||||
a.results.find((r) => r.user === assignee)?.stats || [];
|
const userData = users.find((u) => u.id === assignee);
|
||||||
const userData = users.find((u) => u.id === assignee);
|
const corporateUser = users.find((u) => u.id === a.assigner);
|
||||||
const corporateUser = users.find((u) => u.id === a.assigner);
|
const correct = userStats.reduce((n, e) => n + e.score.correct, 0);
|
||||||
const correct = userStats.reduce((n, e) => n + e.score.correct, 0);
|
const total = userStats.reduce((n, e) => n + e.score.total, 0);
|
||||||
const total = userStats.reduce((n, e) => n + e.score.total, 0);
|
const {label: level, score} = getGradingSystemHelper(a.exams, a.assigner, userData!, correct, total);
|
||||||
const { label: level, score } = getGradingSystemHelper(
|
|
||||||
a.exams,
|
|
||||||
a.assigner,
|
|
||||||
userData!,
|
|
||||||
correct,
|
|
||||||
total
|
|
||||||
);
|
|
||||||
|
|
||||||
console.log("Level", level);
|
const commonData = {
|
||||||
const commonData = {
|
user: userData?.name || "",
|
||||||
user: userData?.name || "",
|
email: userData?.email || "",
|
||||||
email: userData?.email || "",
|
studentID: (userData as StudentUser)?.studentID || "",
|
||||||
userId: assignee,
|
passportID: (userData as StudentUser)?.demographicInformation?.passport_id || "",
|
||||||
corporateId: a.corporateId,
|
userId: assignee,
|
||||||
corporate: corporateUser?.name || "",
|
exams: a.exams.map((x) => x.id).join(", "),
|
||||||
assignment: a.name,
|
corporateId: a.corporateId,
|
||||||
level,
|
corporate: !corporateUser ? "" : getUserName(corporateUser),
|
||||||
score,
|
assignment: a.name,
|
||||||
};
|
level,
|
||||||
if (userStats.length === 0) {
|
score,
|
||||||
return {
|
};
|
||||||
...commonData,
|
if (userStats.length === 0) {
|
||||||
correct: 0,
|
return {
|
||||||
submitted: false,
|
...commonData,
|
||||||
// date: moment(),
|
correct: 0,
|
||||||
};
|
submitted: false,
|
||||||
}
|
// date: moment(),
|
||||||
|
};
|
||||||
|
}
|
||||||
|
|
||||||
const partsData = userStats.every((e) => e.module === "level")
|
let data: {total: number; correct: number}[] = [];
|
||||||
? userStats.reduce((acc, e, index) => {
|
if (a.exams.every((x) => x.module === "level")) {
|
||||||
return {
|
const exam = exams.find((x) => x.id === a.exams.find((x) => x.assignee === assignee)?.id) as LevelExam;
|
||||||
...acc,
|
data = exam.parts.map((x) => {
|
||||||
[`part${index}`]: `${e.score.correct}/${e.score.total}`,
|
const exerciseIDs = x.exercises.map((x) => x.id);
|
||||||
};
|
const stats = userStats.filter((x) => exerciseIDs.includes(x.exercise));
|
||||||
}, {})
|
|
||||||
: {};
|
|
||||||
|
|
||||||
return {
|
const total = stats.reduce((acc, curr) => acc + curr.score.total, 0);
|
||||||
...commonData,
|
const correct = stats.reduce((acc, curr) => acc + curr.score.correct, 0);
|
||||||
correct,
|
|
||||||
submitted: true,
|
|
||||||
date: moment.max(userStats.map((e) => moment(e.date))),
|
|
||||||
...partsData,
|
|
||||||
};
|
|
||||||
}) as TableData[];
|
|
||||||
|
|
||||||
return [...accmA, ...userResults];
|
return {total, correct};
|
||||||
}, [])
|
});
|
||||||
.sort((a, b) => b.score - a.score);
|
}
|
||||||
|
|
||||||
// Create a new workbook and add a worksheet
|
const partsData =
|
||||||
const workbook = new ExcelJS.Workbook();
|
data.length > 0 ? data.reduce((acc, e, index) => ({...acc, [`part${index}`]: `${e.correct}/${e.total}`}), {}) : {};
|
||||||
const worksheet = workbook.addWorksheet("Master Statistical");
|
|
||||||
|
|
||||||
const headers = [
|
return {
|
||||||
{
|
...commonData,
|
||||||
label: "User",
|
correct,
|
||||||
value: (entry: TableData) => entry.user,
|
submitted: true,
|
||||||
},
|
date: moment.max(userStats.map((e) => moment(e.date))),
|
||||||
{
|
...partsData,
|
||||||
label: "Email",
|
};
|
||||||
value: (entry: TableData) => entry.email,
|
}) as TableData[];
|
||||||
},
|
|
||||||
...(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] || "";
|
|
||||||
},
|
|
||||||
})),
|
|
||||||
];
|
|
||||||
|
|
||||||
const filteredSearch = searchText
|
return [...accmA, ...userResults];
|
||||||
? search(searchText, searchFilters, tableResults)
|
}, [])
|
||||||
: tableResults;
|
.sort((a, b) => b.score - a.score);
|
||||||
|
|
||||||
worksheet.addRow(headers.map((h) => h.label));
|
// Create a new workbook and add a worksheet
|
||||||
(filteredSearch as TableData[]).forEach((entry) => {
|
const workbook = new ExcelJS.Workbook();
|
||||||
worksheet.addRow(headers.map((h) => h.value(entry)));
|
const worksheet = workbook.addWorksheet("Master Statistical");
|
||||||
});
|
|
||||||
|
|
||||||
// Convert workbook to Buffer (Node.js) or Blob (Browser)
|
const headers = [
|
||||||
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] || "";
|
||||||
|
},
|
||||||
|
})),
|
||||||
|
];
|
||||||
|
|
||||||
// generate the file ref for storage
|
const filteredSearch = !!searchText ? search(searchText, searchFilters, tableResults) : tableResults;
|
||||||
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);
|
worksheet.addRow(headers.map((h) => h.label));
|
||||||
res.status(200).end(url);
|
(filteredSearch as TableData[]).forEach((entry) => {
|
||||||
return;
|
worksheet.addRow(headers.map((h) => h.value(entry)));
|
||||||
}
|
});
|
||||||
|
|
||||||
return res.status(401).json({ error: "Unauthorized" });
|
// Convert workbook to Buffer (Node.js) or Blob (Browser)
|
||||||
|
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"});
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -1,11 +1,11 @@
|
|||||||
// Next.js API route support: https://nextjs.org/docs/api-routes/introduction
|
// Next.js API route support: https://nextjs.org/docs/api-routes/introduction
|
||||||
import type {NextApiRequest, NextApiResponse} from "next";
|
import type { NextApiRequest, NextApiResponse } from "next";
|
||||||
import client from "@/lib/mongodb";
|
import client from "@/lib/mongodb";
|
||||||
import {withIronSessionApiRoute} from "iron-session/next";
|
import { withIronSessionApiRoute } from "iron-session/next";
|
||||||
import {sessionOptions} from "@/lib/session";
|
import { sessionOptions } from "@/lib/session";
|
||||||
import axios, {AxiosResponse} from "axios";
|
import axios, { AxiosResponse } from "axios";
|
||||||
import {Stat} from "@/interfaces/user";
|
import { Stat } from "@/interfaces/user";
|
||||||
import {writingReverseMarking} from "@/utils/score";
|
import { writingReverseMarking } from "@/utils/score";
|
||||||
|
|
||||||
interface Body {
|
interface Body {
|
||||||
question: string;
|
question: string;
|
||||||
@@ -24,7 +24,7 @@ export default withIronSessionApiRoute(handler, sessionOptions);
|
|||||||
|
|
||||||
async function handler(req: NextApiRequest, res: NextApiResponse) {
|
async function handler(req: NextApiRequest, res: NextApiResponse) {
|
||||||
if (!req.session.user) {
|
if (!req.session.user) {
|
||||||
res.status(401).json({ok: false});
|
res.status(401).json({ ok: false });
|
||||||
return;
|
return;
|
||||||
}
|
}
|
||||||
|
|
||||||
@@ -36,27 +36,29 @@ async function handler(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
|
|
||||||
const correspondingStat = await getCorrespondingStat(req.body.id, 1);
|
const correspondingStat = await getCorrespondingStat(req.body.id, 1);
|
||||||
|
|
||||||
const solutions = correspondingStat.solutions.map((x) => ({...x, evaluation: backendRequest.data}));
|
const solutions = correspondingStat.solutions.map((x) => ({ ...x, evaluation: backendRequest.data }));
|
||||||
await db.collection("stats").updateOne(
|
await db.collection("stats").updateOne(
|
||||||
{ id: (req.body as Body).id},
|
{ id: (req.body as Body).id },
|
||||||
{
|
{
|
||||||
id: (req.body as Body).id,
|
$set: {
|
||||||
solutions,
|
id: (req.body as Body).id,
|
||||||
score: {
|
solutions,
|
||||||
correct: writingReverseMarking[backendRequest.data.overall],
|
score: {
|
||||||
total: 100,
|
correct: writingReverseMarking[backendRequest.data.overall],
|
||||||
missing: 0,
|
total: 100,
|
||||||
},
|
missing: 0,
|
||||||
isDisabled: false,
|
},
|
||||||
|
isDisabled: false,
|
||||||
|
}
|
||||||
},
|
},
|
||||||
{upsert: true},
|
{ upsert: true },
|
||||||
);
|
);
|
||||||
console.log("🌱 - Updated the DB");
|
console.log("🌱 - Updated the DB");
|
||||||
}
|
}
|
||||||
|
|
||||||
async function getCorrespondingStat(id: string, index: number): Promise<Stat> {
|
async function getCorrespondingStat(id: string, index: number): Promise<Stat> {
|
||||||
console.log(`🌱 - Try number ${index} - ${id}`);
|
console.log(`🌱 - Try number ${index} - ${id}`);
|
||||||
const correspondingStat = await db.collection("stats").findOne<Stat>({ id: id});
|
const correspondingStat = await db.collection("stats").findOne<Stat>({ id: id });
|
||||||
|
|
||||||
if (correspondingStat) return correspondingStat;
|
if (correspondingStat) return correspondingStat;
|
||||||
|
|
||||||
|
|||||||
@@ -72,6 +72,9 @@ async function registerIndividual(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
...(passport_id ? {demographicInformation: {passport_id}} : {}),
|
...(passport_id ? {demographicInformation: {passport_id}} : {}),
|
||||||
registrationDate: new Date().toISOString(),
|
registrationDate: new Date().toISOString(),
|
||||||
status: code ? "active" : "paymentDue",
|
status: code ? "active" : "paymentDue",
|
||||||
|
// apparently there's an issue with the verification email system
|
||||||
|
// therefore we will skip this requirement for now
|
||||||
|
isVerified: true,
|
||||||
};
|
};
|
||||||
|
|
||||||
await db.collection("users").insertOne(user);
|
await db.collection("users").insertOne(user);
|
||||||
@@ -117,6 +120,9 @@ async function registerCorporate(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
subscriptionExpirationDate: req.body.subscriptionExpirationDate || null,
|
subscriptionExpirationDate: req.body.subscriptionExpirationDate || null,
|
||||||
status: "paymentDue",
|
status: "paymentDue",
|
||||||
registrationDate: new Date().toISOString(),
|
registrationDate: new Date().toISOString(),
|
||||||
|
// apparently there's an issue with the verification email system
|
||||||
|
// therefore we will skip this requirement for now
|
||||||
|
isVerified: true,
|
||||||
};
|
};
|
||||||
|
|
||||||
const defaultTeachersGroup: Group = {
|
const defaultTeachersGroup: Group = {
|
||||||
|
|||||||
@@ -16,5 +16,5 @@ async function GET(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
const snapshot = await db.collection("stats").findOne({ id: id as string});
|
const snapshot = await db.collection("stats").findOne({ id: id as string});
|
||||||
if (!snapshot) return res.status(404).json({id: id as string});
|
if (!snapshot) return res.status(404).json({id: id as string});
|
||||||
|
|
||||||
res.status(200).json({...snapshot.data(), id: snapshot.id});
|
res.status(200).json({...snapshot, id: snapshot.id});
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -4,6 +4,7 @@ import {withIronSessionApiRoute} from "iron-session/next";
|
|||||||
import {sessionOptions} from "@/lib/session";
|
import {sessionOptions} from "@/lib/session";
|
||||||
import {getLinkedUsers} from "@/utils/users.be";
|
import {getLinkedUsers} from "@/utils/users.be";
|
||||||
import {Type} from "@/interfaces/user";
|
import {Type} from "@/interfaces/user";
|
||||||
|
import {uniqBy} from "lodash";
|
||||||
|
|
||||||
export default withIronSessionApiRoute(handler, sessionOptions);
|
export default withIronSessionApiRoute(handler, sessionOptions);
|
||||||
|
|
||||||
@@ -19,8 +20,7 @@ async function handler(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
page,
|
page,
|
||||||
orderBy,
|
orderBy,
|
||||||
direction = "desc",
|
direction = "desc",
|
||||||
searchTerm
|
} = req.query as {size?: string; type?: Type; page?: string; orderBy?: string; direction?: "asc" | "desc"};
|
||||||
} = req.query as {size?: string; type?: Type; page?: string; orderBy?: string; direction?: "asc" | "desc"; searchTerm?: string | undefined};
|
|
||||||
|
|
||||||
const {users, total} = await getLinkedUsers(
|
const {users, total} = await getLinkedUsers(
|
||||||
req.session.user?.id,
|
req.session.user?.id,
|
||||||
@@ -30,8 +30,7 @@ async function handler(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
size !== undefined ? parseInt(size) : undefined,
|
size !== undefined ? parseInt(size) : undefined,
|
||||||
orderBy,
|
orderBy,
|
||||||
direction,
|
direction,
|
||||||
searchTerm
|
|
||||||
);
|
);
|
||||||
|
|
||||||
res.status(200).json({users, total});
|
res.status(200).json({users: uniqBy([...users], "id"), total});
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -158,7 +158,7 @@ async function handler(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
delete updatedUser.password;
|
delete updatedUser.password;
|
||||||
delete updatedUser.newPassword;
|
delete updatedUser.newPassword;
|
||||||
|
|
||||||
await db.collection("users").updateOne({id: queryId}, {$set: updatedUser});
|
await db.collection("users").updateOne({id: queryId ? (queryId as string) : req.session.user.id}, {$set: updatedUser});
|
||||||
|
|
||||||
if (!queryId) {
|
if (!queryId) {
|
||||||
req.session.user = updatedUser ? {...updatedUser, id: req.session.user.id} : null;
|
req.session.user = updatedUser ? {...updatedUser, id: req.session.user.id} : null;
|
||||||
@@ -169,7 +169,7 @@ async function handler(req: NextApiRequest, res: NextApiResponse) {
|
|||||||
await managePaymentRecords({...updatedUser, id: req.session.user!.id}, queryId);
|
await managePaymentRecords({...updatedUser, id: req.session.user!.id}, queryId);
|
||||||
}
|
}
|
||||||
|
|
||||||
res.status(200).json({user: {...updatedUser, id: req.session.user!.id}});
|
res.status(200).json({user: {...updatedUser, ...user, id: req.session.user!.id}});
|
||||||
}
|
}
|
||||||
|
|
||||||
export const config = {
|
export const config = {
|
||||||
|
|||||||
@@ -79,7 +79,7 @@ export default function Home({user: propsUser, linkedCorporate}: Props) {
|
|||||||
|
|
||||||
useEffect(() => {
|
useEffect(() => {
|
||||||
if (user) {
|
if (user) {
|
||||||
// setShowDemographicInput(!user.demographicInformation || !user.demographicInformation.country || !user.demographicInformation.phone);
|
setShowDemographicInput(!user.demographicInformation || !user.demographicInformation.country || !user.demographicInformation.phone);
|
||||||
setShowDiagnostics(user.isFirstLogin && user.type === "student");
|
setShowDiagnostics(user.isFirstLogin && user.type === "student");
|
||||||
}
|
}
|
||||||
}, [user]);
|
}, [user]);
|
||||||
|
|||||||
@@ -1,6 +1,7 @@
|
|||||||
import client from "@/lib/mongodb";
|
import client from "@/lib/mongodb";
|
||||||
import {Assignment} from "@/interfaces/results";
|
import {Assignment} from "@/interfaces/results";
|
||||||
import {getAllAssignersByCorporate} from "@/utils/groups.be";
|
import {getAllAssignersByCorporate} from "@/utils/groups.be";
|
||||||
|
import {Type} from "@/interfaces/user";
|
||||||
|
|
||||||
const db = client.db(process.env.MONGODB_DB);
|
const db = client.db(process.env.MONGODB_DB);
|
||||||
|
|
||||||
@@ -36,10 +37,10 @@ export const getAssignmentsByAssigners = async (ids: string[], startDate?: Date,
|
|||||||
.toArray();
|
.toArray();
|
||||||
};
|
};
|
||||||
|
|
||||||
export const getAssignmentsForCorporates = async (idsList: string[], startDate?: Date, endDate?: Date) => {
|
export const getAssignmentsForCorporates = async (userType: Type, idsList: string[], startDate?: Date, endDate?: Date) => {
|
||||||
const assigners = await Promise.all(
|
const assigners = await Promise.all(
|
||||||
idsList.map(async (id) => {
|
idsList.map(async (id) => {
|
||||||
const assigners = await getAllAssignersByCorporate(id);
|
const assigners = await getAllAssignersByCorporate(id, userType);
|
||||||
return {
|
return {
|
||||||
corporateId: id,
|
corporateId: id,
|
||||||
assigners,
|
assigners,
|
||||||
|
|||||||
@@ -6,6 +6,28 @@ import {Module} from "@/interfaces";
|
|||||||
import {getCorporateUser} from "@/resources/user";
|
import {getCorporateUser} from "@/resources/user";
|
||||||
import {getUserCorporate} from "./groups.be";
|
import {getUserCorporate} from "./groups.be";
|
||||||
import {Db, ObjectId} from "mongodb";
|
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 (
|
export const getExams = async (
|
||||||
db: Db,
|
db: Db,
|
||||||
|
|||||||
@@ -1,6 +1,6 @@
|
|||||||
import {app} from "@/firebase";
|
import {app} from "@/firebase";
|
||||||
import {Assignment} from "@/interfaces/results";
|
import {Assignment} from "@/interfaces/results";
|
||||||
import {CorporateUser, Group, MasterCorporateUser, StudentUser, TeacherUser, User} from "@/interfaces/user";
|
import {CorporateUser, Group, MasterCorporateUser, StudentUser, TeacherUser, Type, User} from "@/interfaces/user";
|
||||||
import client from "@/lib/mongodb";
|
import client from "@/lib/mongodb";
|
||||||
import moment from "moment";
|
import moment from "moment";
|
||||||
import {getLinkedUsers, getUser} from "./users.be";
|
import {getLinkedUsers, getUser} from "./users.be";
|
||||||
@@ -71,9 +71,9 @@ export const getUsersGroups = async (ids: string[]) => {
|
|||||||
.toArray();
|
.toArray();
|
||||||
};
|
};
|
||||||
|
|
||||||
export const getAllAssignersByCorporate = async (corporateID: string): Promise<string[]> => {
|
export const getAllAssignersByCorporate = async (corporateID: string, type: Type): Promise<string[]> => {
|
||||||
const linkedTeachers = await getLinkedUsers(corporateID, "mastercorporate", "teacher");
|
const linkedTeachers = await getLinkedUsers(corporateID, type, "teacher");
|
||||||
const linkedCorporates = await getLinkedUsers(corporateID, "mastercorporate", "corporate");
|
const linkedCorporates = await getLinkedUsers(corporateID, type, "corporate");
|
||||||
|
|
||||||
return [...linkedTeachers.users.map((x) => x.id), ...linkedCorporates.users.map((x) => x.id)];
|
return [...linkedTeachers.users.map((x) => x.id), ...linkedCorporates.users.map((x) => x.id)];
|
||||||
};
|
};
|
||||||
|
|||||||
@@ -1,4 +1,3 @@
|
|||||||
|
|
||||||
/*fields example = [
|
/*fields example = [
|
||||||
['id'],
|
['id'],
|
||||||
['companyInformation', 'companyInformation', 'name']
|
['companyInformation', 'companyInformation', 'name']
|
||||||
@@ -13,17 +12,17 @@ const getFieldValue = (fields: string[], data: any): string => {
|
|||||||
};
|
};
|
||||||
|
|
||||||
export const search = (text: string, fields: string[][], rows: any[]) => {
|
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);
|
||||||
}
|
}
|
||||||
});
|
});
|
||||||
});
|
});
|
||||||
}
|
};
|
||||||
|
|||||||
@@ -1,18 +1,18 @@
|
|||||||
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 moment from "moment";
|
||||||
import client from "@/lib/mongodb";
|
import client from "@/lib/mongodb";
|
||||||
|
|
||||||
const db = client.db(process.env.MONGODB_DB);
|
const db = client.db(process.env.MONGODB_DB);
|
||||||
|
|
||||||
export async function getUsers() {
|
export async function getUsers() {
|
||||||
return await db.collection("users").find<User>({}).toArray();
|
return await db.collection("users").find<User>({}, { projection: { _id: 0 } }).toArray();
|
||||||
}
|
}
|
||||||
|
|
||||||
export async function getUser(id: string): Promise<User | undefined> {
|
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: id}, { projection: { _id: 0 } });
|
||||||
return !!user ? user : undefined;
|
return !!user ? user : undefined;
|
||||||
}
|
}
|
||||||
|
|
||||||
@@ -21,7 +21,7 @@ export async function getSpecificUsers(ids: string[]) {
|
|||||||
|
|
||||||
return await db
|
return await db
|
||||||
.collection("users")
|
.collection("users")
|
||||||
.find<User>({ id: { $in: ids } })
|
.find<User>({id: {$in: ids}}, { projection: { _id: 0 } })
|
||||||
.toArray();
|
.toArray();
|
||||||
}
|
}
|
||||||
|
|
||||||
@@ -33,32 +33,21 @@ export async function getLinkedUsers(
|
|||||||
size?: number,
|
size?: number,
|
||||||
sort?: string,
|
sort?: string,
|
||||||
direction?: "asc" | "desc",
|
direction?: "asc" | "desc",
|
||||||
searchTerm?: string | undefined,
|
|
||||||
) {
|
) {
|
||||||
const filters: any = {};
|
const filters = {
|
||||||
|
...(!!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") {
|
if (!userID || userType === "admin" || userType === "developer") {
|
||||||
const users = await db
|
const users = await db
|
||||||
.collection("users")
|
.collection("users")
|
||||||
.find<User>(filters)
|
.find<User>(filters)
|
||||||
.sort(sort ? { [sort]: direction === "desc" ? -1 : 1 } : {})
|
.sort(sort ? {[sort]: direction === "desc" ? -1 : 1} : {})
|
||||||
.skip(page && size ? page * size : 0)
|
.skip(page && size ? page * size : 0)
|
||||||
.limit(size || 0)
|
.limit(size || 0)
|
||||||
.toArray();
|
.toArray();
|
||||||
const total = await db.collection("users").countDocuments(filters);
|
const total = await db.collection("users").countDocuments(filters);
|
||||||
return { users, total };
|
return {users, total};
|
||||||
}
|
}
|
||||||
|
|
||||||
const adminGroups = await getUserGroups(userID);
|
const adminGroups = await getUserGroups(userID);
|
||||||
@@ -72,17 +61,17 @@ export async function getLinkedUsers(
|
|||||||
]);
|
]);
|
||||||
|
|
||||||
// ⨯ [FirebaseError: Invalid Query. A non-empty array is required for 'in' filters.] {
|
// ⨯ [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
|
const users = await db
|
||||||
.collection("users")
|
.collection("users")
|
||||||
.find<User>({ ...filters, id: { $in: participants } })
|
.find<User>({...filters, id: {$in: participants}})
|
||||||
.skip(page && size ? page * size : 0)
|
.skip(page && size ? page * size : 0)
|
||||||
.limit(size || 0)
|
.limit(size || 0)
|
||||||
.toArray();
|
.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) {
|
export async function getUserBalance(user: User) {
|
||||||
|
|||||||
Reference in New Issue
Block a user