Function getAdvancedGameStats

app/stats/stats.service.js:637–886

(
    year,
    team,
    week,
    opponent,
    excludeGarbageTime,
    seasonType
  )

  };

  const getAdvancedGameStats = async (
    year,
    team,
    week,
    opponent,
    excludeGarbageTime,
    seasonType
  ) => {
    let filter = "WHERE ";
    let params = [];
    let index = 1;

    if (year) {
      filter += `g.season = $${index}`;
      params.push(year);
      index++;
    }

    if (team) {
      filter += ` ${year ? "AND " : ""}LOWER(t.school) = LOWER($${index})`;
      params.push(team);
      index++;
    }

    if (opponent) {
      filter += ` ${
        params.length ? "AND " : ""
      }LOWER(t2.school) = LOWER($${index})`;
      params.push(opponent);
      index++;
    }

    if (week) {
      filter += ` ${params.length ? "AND " : ""}g.week = $${index}`;
      params.push(week);
      index++;
    }

    if (seasonType && seasonType.toLowerCase() !== "both") {
      filter += ` ${params.length ? "AND " : ""}g.season_type = $${index}`;
      params.push(seasonType);
      index++;
    }

    const results = await db.any(
      `
        WITH plays AS (
            SELECT  g.id,
                    g.season,
                    g.week,
                    t.school,
                    t2.school AS opponent,
                    p.drive_id,
                    p.down,
                    p.distance,
                    p.yards_gained,
                    CASE
                        WHEN p.offense_id = t.id THEN 'offense'