user_list.ts

import Application from "../models/Application";
import { Request, Response, application } from "express";
import { getGenericList } from "./common";
import { groupBy } from "lodash";
import { STATUS } from "../constants";
import { prepopulateMeetInfo } from "./meet_info";

export function getUserList(req: Request, res: Response) {
  return getGenericList(req, res, Application);
}

export async function getMeetList(req: Request, res: Response) {
  const results = await Application.find(
    {
      $and: [
        { status: STATUS.ADMISSION_CONFIRMED },
        { "forms.meet_info": { $exists: true } },
        { "forms.meet_info.showProfile": true },
      ],
    },
    {
      "user.id": 1,
      "forms.meet_info": 1,
      "forms.application_info.first_name": 1,
      "forms.application_info.last_name": 1,
      "forms.team_info.teamList": 1,
    }
  );

  let finalResults = results.map((result) => {
    let obj = result.toObject();
    prepopulateMeetInfo(obj);
    return obj;
  });
  res.status(200).json({
    results: finalResults,
    count: results.length,
  });
}

const facetStatsRequest = async () => {
  const result = await Application.aggregate([
    {
      $facet: {
        gender: [{ $sortByCount: "$forms.application_info.gender" }],
        race: [
          {
            // "More than one" if multiple races are selected.
            $sortByCount: {
              $cond: {
                if: {
                  $lte: [
                    {
                      $size: { $ifNull: ["$forms.application_info.race", []] },
                    },
                    1,
                  ],
                },
                then: "$forms.application_info.race",
                else: ["More than one"],
              },
            },
          },
          { $unwind: "$_id" },
        ],
        hackathon_experience: [
          { $sortByCount: "$forms.application_info.hackathon_experience" },
        ],
        skill_level: [{ $sortByCount: "$forms.application_info.skill_level" }],
        university: [{ $sortByCount: "$forms.application_info.university" }],
        location: [{ $sortByCount: "$location" }],
        type: [{ $sortByCount: "$type" }],
        status: [{ $sortByCount: "$status" }],
        graduation_year: [{ $sortByCount: "$forms.application_info.graduation_year" }],
      },
    },
  ]);
  return result[0];
};
const timelineStatsRequest = async () => {
  const applications = (await Application.find({}, { type: 1, status: 1, _id: 1 }).lean())
    .map((application) => ({
      ...application,
      date_created: application._id.getTimestamp(),
    }))
    .sort((a, b) => a.date_created - b.date_created);
  let groupedByDay = groupBy(applications, (e) => e.date_created.toDateString());
  let counter: { [x: string]: any } = {
    type: { is: 0, oos: 0, stanford: 0 },
    status: { submitted: 0, incomplete: 0 },
  };
  let results = [];
  let i = 0;
  for (let day in groupedByDay) {
    for (let application of groupedByDay[day]) {
      counter.type[application.type] = counter.type[application.type] + 1;
      counter.status[application.status] = counter.status[application.status] + 1;
      i++;
    }
    results.push({
      num_is: counter.type.is,
      num_oos: counter.type.oos,
      num_stanford: counter.type.stanford,
      num_incomplete: counter.status.incomplete,
      num_submitted: counter.status.submitted,
      date: new Date(day),
      num_total: i,
    });
  }
  return results;
};

export async function getUserStats(req: Request, res: Response) {
  const [facetStatsResponse, timelineStatsResponse] = await Promise.all([
    facetStatsRequest(),
    timelineStatsRequest(),
  ]);
  res.json({
    ...facetStatsResponse,
    timeline: timelineStatsResponse,
  });
}