Cacher is the code snippet organizer for pro developers

import { getAccessToken, withApiAuthRequired } from "@auth0/nextjs-auth0";

export default withApiAuthRequired(async function handler(req, res) {
  const { accessToken } = await getAccessToken(req, res);
  const fetchOptions = {
    method: "POST",
    headers: {
      "Content-Type": "application/json",
      "Access-Control-Request-Headers": "*",
      jwtTokenString: accessToken,
    },
  };
  const fetchBody = {
    dataSource: process.env.MONGODB_DATA_SOURCE,
    database: "so

import { getAccessToken, withApiAuthRequired } from "@auth0/nextjs-auth0";

export default withApiAuthRequired(async function handler(req, res) {
  const { accessToken } = await getAccessToken(req, res);
  const fetchOptions = {
    method: "POST",
    headers: {
      "Content-Type": "application/json",
      "Access-Control-Request-Headers": "*",
      jwtTokenString: accessToken,
    },
  };
  const fetchBody = {
    dataSource: process.env.MONGODB_DATA_SOURCE,
    database: "so

import ExcelJS from 'exceljs';
import { saveAs } from 'file-saver';

const workbook = new ExcelJS.Workbook();
const worksheet = workbook.addWorksheet('ExchangeRates');
let counter = 1;

worksheet.columns = data.headers.map((title) => ({
  key: title,
  width: 25,
  style: {
    numFmt: title === 'date' ? 'yyyy.mm.dd' : '#,##0.000000',
  },
}));

const table = worksheet.addTable({
  name: 'Table',
  ref: `A${counter}`,
  headerRow: true,
  totalsRow: false,
  style: {
    theme: 'TableStyleLight8

// Importing necessary modules
const express = require('express');
const dotenv = require('dotenv');
const connectDB = require('./database');
const authRoutes = require('./routes/authRoutes');
const noteRoutes = require('./routes/noteRoutes'); // Import note routes

// Initialize dotenv to load environment variables
dotenv.config();

// Connect to MongoDB
connectDB();

// Initialize express
const app = express();

// Middleware to parse JSON bodies
app.use(express.json());

//

SELECT
    dbo.dmprod.pr_codenum,
    dbo.dmd3.d3_value AS picklocation
FROM
    dbo.dtd2
    INNER JOIN dbo.dmd3 ON CAST(dbo.dtd2.d2_value AS int) = dbo.dmd3.d3_id
    INNER JOIN dbo.dmprod ON dbo.dtd2.d2_recid = dbo.dmprod.pr_id
WHERE
    (dbo.dtd2.d2_d1id = 134)

SELECT
    jo_jobnum,
    jo_closed,
    iif(
        jo_closed <> min(gl_date),
        FORMAT(min(gl_date), 'MM/dd/yyyy'),
        ''
    ) AS gl_date,
    dtjob3.ch_account AS paydetacct,
    dtjob3.payrolldetail,
    gldet.ch_account AS gldetacct,
    SUM(gl_debits) AS gldetail,
    dtjob3.payrolldetail - SUM(gl_debits) AS variance
FROM
    dtjob
    JOIN (
        SELECT
            j3_jobnum,
            ch_id,
            ch_account,
            SUM(ROUND(j3_modhour * 

SELECT
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip,
    SUM(dbo.dtpur.pu_ordman) AS Ordquant
FROM
    dbo.dtpur
    INNER JOIN dbo.dttpur ON dbo.dttpur.tp_recevd IS NULL
    AND dbo.dttpur.tp_ordtype IN ('p', 'r')
    AND dbo.dttpur.tp_id = dbo.dtpur.pu_tpid
    INNER JOIN dbo.dmprod ON dbo.dmprod.pr_id = dbo.dtpur.pu_prid
GROUP BY
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip

SELECT
    dbo.dmprod.pr_codenum AS PartNumber,
    dbo.dmprod.pr_descrip AS Description,
    ISNULL(lots.'lotquant', 0) AS Onhand,
    ISNULL(pur.'purquant', 0) AS OpenPurchaseOrders
FROM
    dbo.dmprod
    LEFT OUTER JOIN (
        SELECT
            SUM(fi_quant) AS 'lotquant',
            fi_prid
        FROM
            dbo.dtfifo
        WHERE
            (fi_zeroed IS NULL)
            AND (fi_type = '')
        GROUP BY
            fi_prid
    ) AS lots ON lots.fi_prid 

SELECT
    h.to_ordnum AS ordnum,
    h.to_dueship AS dueship,
    lastmoduser.userid
FROM
    dbo.dttord AS h
    INNER JOIN (
        SELECT
            MAX(to_id) AS id,
            to_ordnum
        FROM
            dbo.dttord
        WHERE
            (to_status = 'h')
        GROUP BY
            to_ordnum
    ) AS lastsale ON lastsale.id = h.to_id
    INNER JOIN (
        SELECT
            MAX(lo_id) AS logid,
            lo_recid
        FROM
            dbo.dxlog

SELECT
    dbo.dmprod.pr_retail AS [FB Code],
    dbo.dmprod.pr_codenum AS [Part Number],
    dbo.dmprod.pr_descrip AS Description,
    dbo.dtfifo.fi_userlot AS Lot,
    dbo.dtfifo.fi_balance AS Quantity,
    dbo.dtfifo.fi_postref AS Postref,
    dbo.dmware.wa_name AS Facility,
    dbo.dtfifo.fi_lotnum AS [System Lot],
    dbo.dmloc.lo_name AS Location,
    dbo.dtfifo.fi_date AS Date,
    dbo.dtfifo.fi_cost AS [Lot Cost],
    dbo.dtfifo.fi_cost * dbo.dtfifo.fi_balance AS Value,
    

SELECT
    dbo.dmprod.pr_codenum AS PartNumber,
    dbo.dmprod.pr_descrip AS Description,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmunit.un_factor AS Unit,
    dbo.dtd2.d2_value AS OzWeight,
    dbo.dmpr1.p1_name AS Protein
FROM
    dbo.dmprod
    LEFT OUTER JOIN dbo.dmpr5 ON dbo.dmpr5.p5_id = dbo.dmprod.pr_user9
    LEFT OUTER JOIN dbo.dmunit ON dbo.dmunit.un_id = dbo.dmprod.pr_unid
    LEFT OUTER JOIN dbo.dtd2 ON dbo.dtd2.d2_recid = dbo.dmprod.pr_id
    AND dbo.dtd2.d2_d1id = 32
 

SELECT
    dbo.dtjob.jo_jobnum,
    dbo.dtjob.jo_planstart,
    dbo.dtjob.jo_type,
    dbo.dtjob.jo_remarks,
    dbo.dtjob.jo_notes,
    dbo.dmware.wa_name,
    dbo.dtd2.d2_value,
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip,
    a.lj_quant,
    dbo.dmunit.un_name,
    dbo.dmpr3.p3_name,
    screencount.screen,
    RTEcount.RTE,
    Rawcount.Raw
FROM
    dbo.dtjob
    INNER JOIN dbo.dtljob AS a ON dbo.dtjob.jo_id = a.lj_joid
    INNER JOIN dbo.dmware ON dbo.dtjob.jo_wa

SELECT
    j4_jobnum,
    SUM(j4_fixmat * j4_quant) AS stanmat,
    SUM(j4_fixlab * j4_quant) AS stanlab,
    SUM(j4_fixmat * j4_quant + j4_fixlab * j4_quant) AS stantot
FROM
    dbo.dtjob4
GROUP BY
    j4_jobnum

SELECT
    colorpicklist.d3_value AS Color,
    dbo.dmprod.pr_unitwgt,
    dbo.dmunit.un_factor,
    0 AS avg_pct_increase,
    dbo.dmpr5.p5_name AS Brand,
    dbo.dmunit.un_name,
    dbo.dmprod.pr_codenum,
    dbo.dmprod.pr_descrip,
    CASE
        WHEN eggs.d2_value = 'Yes' THEN 'Eggs, '
        ELSE ''
    END + CASE
        WHEN fish.d2_value = 'Yes' THEN 'Fish, '
        ELSE ''
    END + CASE
        WHEN milk.d2_value = 'Yes' THEN 'Milk, '
        ELSE ''
    END + CASE

Collection<SampleModel> samples = getSamples();
ProcessTrackedRecord.SAMPLE.load(samples, exemplarContext);

Multimap<String, Long> activeExperimentRecIdsBySampleId = HashMultimap.create();

var enbManager = Manager.NOTEBOOK_EXPERIMENT_MANAGER.get(exemplarContext);

var templateNameById = enbManager.getTemplateExperimentInfoList(user).stream()
        .collect(Collectors.toMap(TemplateExperimentInfo::getTemplateId, TemplateExperimentInfo::getTemplateName));

var relatedExperiments = en