// 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
var categories = Enum.GetValues(typeof(CategoryType)).Cast<CategoryType>().ToList();
categories.Dump();
categories.ForEach(t => {
(t == CategoryType.Category2).Dump();
});
public enum CategoryType
{
Category1 = 1,
Category2 = 2,
Category3 = 3,
Category4 = 4,
Category5 = 5,
Category6 = 6,
Category7 = 7,
Category8 = 8,
}
// 1. Clear mods
const chkBoxes = document.querySelectorAll('#tab-general .table tbody tr td:first-child input[type="checkbox"]');
chkBoxes.forEach(
chkBox => {
chkBox.checked = true;
}
);
const clrBtn = document.querySelector('.page-header > .container-fluid > .pull-right > a[data-original-title="Clear"]');
clrBtn.click();
// 2. Refresh mods
const chkBoxes = document.querySelectorAll('#tab-general .table tbody tr td:first-child input[type="checkbox"]');
chkBoxes.forEach(
chkBox => {
chk
/**
* @param {string} s
* @param {number} k
* @return {number}
*/
var longestIdealString = function(s, k) {
// Initialize an array to keep track of the longest ideal string ending with each letter
var dp = new Array(26).fill(0);
// Iterate over each character in the string
for (var i = 0; i < s.length; i++) {
// Convert the current character to its corresponding integer (0-25)
var c = s.charCodeAt(i) - 'a'.charCodeAt(0);
// Initialize the maximum len