/**
* @param {number[][]} grid
* @return {number}
*/
var minFallingPathSum = function(grid) {
const n = grid.length;
const dp = Array(n).fill(0).map(() => Array(n).fill(Infinity));
// Initialize the first row of dp with the first row of grid
for (let j = 0; j < n; j++) {
dp[0][j] = grid[0][j];
}
for (let i = 1; i < n; i++) {
for (let j = 0; j < n; j++) {
for (let k = 0; k < n; k++) {
// If the columns of the current cel
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