Merged in feature/IO-3255-simplified-part-management (pull request #2530)

Feature/IO-3255 simplified part management

client/.env.development.imex

@@ -14,3 +14,5 @@ VITE_APP_SPLIT_API=ts615lqgnmk84thn72uk18uu5pgce6e0l4rc
 VITE_APP_INSTANCE=IMEX
 TEST_USERNAME="test@imex.dev"
 TEST_PASSWORD="test123"
+VITE_PUBLIC_POSTHOG_KEY=phc_xtLmBIu0rjWwExY73Oj5DTH1bGbwq1G1Y8jnlTceien
+VITE_PUBLIC_POSTHOG_HOST=https://us.i.posthog.com

client/.env.development.rome

@@ -16,3 +16,5 @@ VITE_APP_COUNTRY=USA
 VITE_APP_INSTANCE=ROME
 TEST_USERNAME="test@imex.dev"
 TEST_PASSWORD="test123"
+VITE_PUBLIC_POSTHOG_KEY=phc_xtLmBIu0rjWwExY73Oj5DTH1bGbwq1G1Y8jnlTceien
+VITE_PUBLIC_POSTHOG_HOST=https://us.i.posthog.com

client/.env.production.imex

@@ -13,3 +13,5 @@ VITE_APP_AXIOS_BASE_API_URL=https://api.imex.online/
 VITE_APP_REPORTS_SERVER_URL=https://reports.imex.online
 VITE_APP_SPLIT_API=et9pjkik6bn67he5evpmpr1agoo7gactphgk
 VITE_APP_INSTANCE=IMEX
+VITE_PUBLIC_POSTHOG_KEY=phc_xtLmBIu0rjWwExY73Oj5DTH1bGbwq1G1Y8jnlTceien
+VITE_PUBLIC_POSTHOG_HOST=https://us.i.posthog.com

client/.env.production.rome

@@ -13,3 +13,5 @@ VITE_APP_AXIOS_BASE_API_URL=https://api.romeonline.io/
 VITE_APP_REPORTS_SERVER_URL=https://reports.romeonline.io
 VITE_APP_SPLIT_API=et9pjkik6bn67he5evpmpr1agoo7gactphgk
 VITE_APP_INSTANCE=ROME
+VITE_PUBLIC_POSTHOG_KEY=phc_xtLmBIu0rjWwExY73Oj5DTH1bGbwq1G1Y8jnlTceien
+VITE_PUBLIC_POSTHOG_HOST=https://us.i.posthog.com

client/.env.test.imex

@@ -13,3 +13,5 @@ VITE_APP_REPORTS_SERVER_URL=https://reports.test.imex.online
 VITE_APP_IS_TEST=true
 VITE_APP_SPLIT_API=ts615lqgnmk84thn72uk18uu5pgce6e0l4rc
 VITE_APP_INSTANCE=IMEX
+VITE_PUBLIC_POSTHOG_KEY=phc_xtLmBIu0rjWwExY73Oj5DTH1bGbwq1G1Y8jnlTceien
+VITE_PUBLIC_POSTHOG_HOST=https://us.i.posthog.com

client/.env.test.rome

@@ -13,3 +13,5 @@ VITE_APP_REPORTS_SERVER_URL=https://reports.test.romeonline.io
 VITE_APP_IS_TEST=true
 VITE_APP_SPLIT_API=ts615lqgnmk84thn72uk18uu5pgce6e0l4rc
 VITE_APP_INSTANCE=ROME
+VITE_PUBLIC_POSTHOG_KEY=phc_xtLmBIu0rjWwExY73Oj5DTH1bGbwq1G1Y8jnlTceien
+VITE_PUBLIC_POSTHOG_HOST=https://us.i.posthog.com

client/package.json

@@ -8,6 +8,7 @@
   "private": true,
   "proxy": "http://localhost:4000",
   "dependencies": {
+    "@amplitude/analytics-browser": "^2.23.1",
     "@ant-design/pro-layout": "^7.22.6",
     "@apollo/client": "^3.13.9",
     "@emotion/is-prop-valid": "^1.3.1",
@@ -48,6 +49,7 @@
     "normalize-url": "^8.0.2",
     "object-hash": "^3.0.0",
     "phone": "^3.1.67",
+    "posthog-js": "^1.260.2",
     "prop-types": "^15.8.1",
     "query-string": "^9.2.2",
     "raf-schd": "^4.0.3",

client/src/App/App.container.jsx

@@ -1,20 +1,20 @@
 import { ApolloProvider } from "@apollo/client";
+import * as Sentry from "@sentry/react";
 import { SplitFactoryProvider, useSplitClient } from "@splitsoftware/splitio-react";
 import { ConfigProvider } from "antd";
 import enLocale from "antd/es/locale/en_US";
 import { useEffect, useMemo } from "react";
+import { CookiesProvider } from "react-cookie";
 import { useTranslation } from "react-i18next";
 import { connect, useSelector } from "react-redux";
+import { createStructuredSelector } from "reselect";
 import GlobalLoadingBar from "../components/global-loading-bar/global-loading-bar.component";
+import { setDarkMode } from "../redux/application/application.actions";
+import { selectDarkMode } from "../redux/application/application.selectors";
+import { selectCurrentUser } from "../redux/user/user.selectors.js";
 import client from "../utils/GraphQLClient";
 import App from "./App";
-import * as Sentry from "@sentry/react";
 import getTheme from "./themeProvider";
-import { CookiesProvider } from "react-cookie";
-import { createStructuredSelector } from "reselect";
-import { selectCurrentUser } from "../redux/user/user.selectors.js";
-import { selectDarkMode } from "../redux/application/application.selectors";
-import { setDarkMode } from "../redux/application/application.actions";
 
 // Base Split configuration
 const config = {

client/src/components/job-detail-lines/job-lines-part-price-change.component.jsx

@@ -12,13 +12,15 @@ import InstanceRenderManager from "../../utils/instanceRenderMgr";
 import CurrencyFormItemComponent from "../form-items-formatted/currency-form-item.component";
 import JobLineConvertToLabor from "../job-line-convert-to-labor/job-line-convert-to-labor.component";
 import { useNotification } from "../../contexts/Notifications/notificationContext.jsx";
+import { selectIsPartsEntry } from "../../redux/application/application.selectors.js";
 
 const mapStateToProps = createStructuredSelector({
-  technician: selectTechnician
+  technician: selectTechnician,
+  isPartsEntry: selectIsPartsEntry
 });
 const mapDispatchToProps = () => ({});
 
-export function JobLinesPartPriceChange({ job, line, refetch, technician }) {
+export function JobLinesPartPriceChange({ job, line, refetch, technician, isPartsEntry }) {
   const [loading, setLoading] = useState(false);
   const [updatePartPrice] = useMutation(UPDATE_LINE_PPC);
   const notification = useNotification();
@@ -64,6 +66,7 @@ export function JobLinesPartPriceChange({ job, line, refetch, technician }) {
 
   const popcontent =
     !technician &&
+    !isPartsEntry &&
     InstanceRenderManager({
       imex: null,
       rome: (

client/src/components/job-detail-lines/job-lines.component.jsx

@@ -481,48 +481,50 @@ export function JobLinesComponent({
             {Enhanced_Payroll.treatment === "on" && (
               <JobLineBulkAssignComponent selectedLines={selectedLines} setSelectedLines={setSelectedLines} job={job} />
             )}
-            <Button
-              disabled={(job && !job.converted) || (selectedLines.length > 0 ? false : true) || jobRO || technician}
-              onClick={() => {
-                setBillEnterContext({
-                  actions: { refetch: refetch },
-                  context: {
-                    disableInvNumber: true,
-                    job: { id: job.id },
-                    bill: {
-                      vendorid: bodyshop.inhousevendorid,
-                      invoice_number: "ih",
-                      isinhouse: true,
-                      date: dayjs(),
-                      total: 0,
-                      billlines: selectedLines.map((p) => {
-                        return {
-                          joblineid: p.id,
-                          actual_price: p.act_price,
-                          actual_cost: 0, //p.act_price,
-                          line_desc: p.line_desc,
-                          line_remarks: p.line_remarks,
-                          part_type: p.part_type,
-                          quantity: p.quantity || 1,
-                          applicable_taxes: {
-                            local: false,
-                            state: false,
-                            federal: false
-                          }
-                        };
-                      })
+            {!isPartsEntry && (
+              <Button
+                disabled={(job && !job.converted) || (selectedLines.length > 0 ? false : true) || jobRO || technician}
+                onClick={() => {
+                  setBillEnterContext({
+                    actions: { refetch: refetch },
+                    context: {
+                      disableInvNumber: true,
+                      job: { id: job.id },
+                      bill: {
+                        vendorid: bodyshop.inhousevendorid,
+                        invoice_number: "ih",
+                        isinhouse: true,
+                        date: dayjs(),
+                        total: 0,
+                        billlines: selectedLines.map((p) => {
+                          return {
+                            joblineid: p.id,
+                            actual_price: p.act_price,
+                            actual_cost: 0, //p.act_price,
+                            line_desc: p.line_desc,
+                            line_remarks: p.line_remarks,
+                            part_type: p.part_type,
+                            quantity: p.quantity || 1,
+                            applicable_taxes: {
+                              local: false,
+                              state: false,
+                              federal: false
+                            }
+                          };
+                        })
+                      }
                     }
-                  }
-                });
+                  });
 
-                //Clear out the selected lines. IO-785
-                setSelectedLines([]);
-              }}
-            >
-              <HomeOutlined />
-              {t("parts.actions.orderinhouse")}
-              {selectedLines.length > 0 && ` (${selectedLines.length})`}
-            </Button>
+                  //Clear out the selected lines. IO-785
+                  setSelectedLines([]);
+                }}
+              >
+                <HomeOutlined />
+                {t("parts.actions.orderinhouse")}
+                {selectedLines.length > 0 && ` (${selectedLines.length})`}
+              </Button>
+            )}
             <Button
               id="job-lines-order-parts-button"
               disabled={(job && !job.converted) || (selectedLines.length > 0 ? false : true) || jobRO || technician}
@@ -578,7 +580,8 @@ export function JobLinesComponent({
                 {t("joblines.actions.new")}
               </Button>
             )}
-            {InstanceRenderManager({ rome: <JobSendPartPriceChangeComponent job={job} disabled={technician} /> })}
+            {!isPartsEntry &&
+              InstanceRenderManager({ rome: <JobSendPartPriceChangeComponent job={job} disabled={technician} /> })}
             <JobCreateIOU job={job} selectedJobLines={selectedLines} />
             <Input.Search
               placeholder={t("general.labels.search")}

client/src/components/jobs-change-status/jobs-change-status.component.jsx

@@ -8,19 +8,20 @@ import { createStructuredSelector } from "reselect";
 import { useNotification } from "../../contexts/Notifications/notificationContext.jsx";
 import { UPDATE_JOB_STATUS } from "../../graphql/jobs.queries";
 import { insertAuditTrail } from "../../redux/application/application.actions";
-import { selectJobReadOnly } from "../../redux/application/application.selectors";
+import { selectIsPartsEntry, selectJobReadOnly } from "../../redux/application/application.selectors";
 import { selectBodyshop } from "../../redux/user/user.selectors";
 import AuditTrailMapping from "../../utils/AuditTrailMappings";
 
 const mapStateToProps = createStructuredSelector({
   bodyshop: selectBodyshop,
-  jobRO: selectJobReadOnly
+  jobRO: selectJobReadOnly,
+  isPartsEntry: selectIsPartsEntry
 });
 const mapDispatchToProps = (dispatch) => ({
   insertAuditTrail: ({ jobid, operation, type }) => dispatch(insertAuditTrail({ jobid, operation, type }))
 });
 
-export function JobsChangeStatus({ job, bodyshop, jobRO, insertAuditTrail }) {
+export function JobsChangeStatus({ job, bodyshop, jobRO, insertAuditTrail, isPartsEntry }) {
   const { t } = useTranslation();
 
   const [availableStatuses, setAvailableStatuses] = useState([]);
@@ -45,25 +46,43 @@ export function JobsChangeStatus({ job, bodyshop, jobRO, insertAuditTrail }) {
       });
   };
 
+  // Updates available statuses based on job and bodyshop context
   useEffect(() => {
-    //Figure out what scenario were in, populate accodingly
-    if (job && bodyshop) {
-      if (bodyshop.md_ro_statuses.pre_production_statuses.includes(job.status)) {
-        setAvailableStatuses(bodyshop.md_ro_statuses.pre_production_statuses);
-      } else if (bodyshop.md_ro_statuses.production_statuses.includes(job.status)) {
-        setAvailableStatuses(bodyshop.md_ro_statuses.production_statuses);
-      } else if (bodyshop.md_ro_statuses.post_production_statuses.includes(job.status)) {
-        setAvailableStatuses(
-          bodyshop.md_ro_statuses.post_production_statuses.filter(
-            (s) => s !== bodyshop.md_ro_statuses.default_invoiced && s !== bodyshop.md_ro_statuses.default_exported
-          )
-        );
-      } else {
-        console.log("Status didn't match any restrictions. Allowing all status changes.");
-        setAvailableStatuses(bodyshop.md_ro_statuses.statuses);
-      }
+    if (!job || !bodyshop) return;
+
+    const { md_ro_statuses } = bodyshop;
+    const {
+      parts_statuses,
+      pre_production_statuses,
+      production_statuses,
+      post_production_statuses,
+      statuses,
+      default_invoiced,
+      default_exported
+    } = md_ro_statuses;
+
+    if (isPartsEntry) {
+      // Set parts-specific statuses for parts entry scenario
+      setAvailableStatuses(parts_statuses);
+      return;
     }
-  }, [job, setAvailableStatuses, bodyshop]);
+
+    // Handle non-parts entry scenarios based on job status
+    if (pre_production_statuses.includes(job.status)) {
+      setAvailableStatuses(pre_production_statuses);
+    } else if (production_statuses.includes(job.status)) {
+      setAvailableStatuses(production_statuses);
+    } else if (post_production_statuses.includes(job.status)) {
+      // Filter out invoiced and exported statuses for post-production
+      setAvailableStatuses(
+        post_production_statuses.filter((status) => status !== default_invoiced && status !== default_exported)
+      );
+    } else {
+      // Default to all statuses if no specific restrictions apply
+      console.log("Status didn't match any restrictions. Allowing all status changes.");
+      setAvailableStatuses(statuses);
+    }
+  }, [job, bodyshop, isPartsEntry, setAvailableStatuses]);
 
   const statusMenu = {
     items: [

client/src/components/jobs-detail-header/jobs-detail-header.component.jsx

@@ -139,17 +139,18 @@ export function JobsDetailHeader({ job, bodyshop, disabled, insertAuditTrail, is
               <DataLabel label={t("jobs.fields.comment")} valueStyle={{ overflow: "hidden", textOverflow: "ellipsis" }}>
                 <ProductionListColumnComment record={job} />
               </DataLabel>
-              <DataLabel label={t("jobs.fields.ins_co_nm_short")}>{job.ins_co_nm}</DataLabel>
+              {!isPartsEntry && <DataLabel label={t("jobs.fields.ins_co_nm_short")}>{job.ins_co_nm}</DataLabel>}
               <DataLabel label={t("jobs.fields.clm_no")}>{job.clm_no}</DataLabel>
               <DataLabel label={t("jobs.fields.ponumber")} hideIfNull>
                 {job.po_number}
               </DataLabel>
-              <DataLabel label={t("jobs.fields.repairtotal")}>
-                <CurrencyFormatter>{job.clm_total}</CurrencyFormatter>
-                <span style={{ margin: "0rem .5rem" }}>/</span>
-                <CurrencyFormatter>{job.owner_owing}</CurrencyFormatter>
-              </DataLabel>
-
+              {!isPartsEntry && (
+                <DataLabel label={t("jobs.fields.repairtotal")}>
+                  <CurrencyFormatter>{job.clm_total}</CurrencyFormatter>
+                  <span style={{ margin: "0rem .5rem" }}>/</span>
+                  <CurrencyFormatter>{job.owner_owing}</CurrencyFormatter>
+                </DataLabel>
+              )}
               {!isPartsEntry && (
                 <>
                   <DataLabel label={t("jobs.fields.alt_transport")}>

client/src/components/print-center-jobs/print-center-jobs-parts.component.jsx

@@ -37,7 +37,7 @@ export function PrintCenterJobsPartsComponent({ printCenterModal, bodyshop, tech
           .filter(
             (temp) =>
               (!temp.regions ||
-                (temp.regions && temp.regions[bodyshop.region_config]) ||
+                temp.regions?.[bodyshop.region_config] ||
                 (temp.regions && bodyshop.region_config.includes(Object.keys(temp.regions)) === true)) &&
               (!temp.dms || temp.dms === false)
           )
@@ -46,7 +46,7 @@ export function PrintCenterJobsPartsComponent({ printCenterModal, bodyshop, tech
           .filter(
             (temp) =>
               !temp.regions ||
-              (temp.regions && temp.regions[bodyshop.region_config]) ||
+              temp.regions?.[bodyshop.region_config] ||
               (temp.regions && bodyshop.region_config.includes(Object.keys(temp.regions)) === true)
           );
 
@@ -82,7 +82,7 @@ export function PrintCenterJobsPartsComponent({ printCenterModal, bodyshop, tech
         variables: { id: jobId }
       },
       {
-        to: job && job.ownr_ea,
+        to: job?.ownr_ea,
         subject: cards.find((c) => c.key === key)?.subject
       },
       "e",
@@ -129,7 +129,7 @@ export function PrintCenterJobsPartsComponent({ printCenterModal, bodyshop, tech
           const columns = `repeat(${actions.length}, 1fr)`;
 
           return (
-            <Col key={item.key} xs={24} sm={12}>
+            <Col key={item.key} xs={24} sm={24} md={24} lg={24} xl={24}>
               <Card hoverable style={{ minHeight: 100 }}>
                 <div style={{ display: "flex", alignItems: "center", gap: 12 }}>
                   <div style={{ flex: "1 1 70%", minWidth: 0 }}>

client/src/components/simplified-parts-jobs-list/simplified-parts-jobs-list.component.jsx

@@ -9,7 +9,6 @@ import { connect } from "react-redux";
 import { Link, useLocation, useNavigate } from "react-router-dom";
 import { createStructuredSelector } from "reselect";
 import { selectBodyshop } from "../../redux/user/user.selectors";
-import CurrencyFormatter from "../../utils/CurrencyFormatter";
 import { pageLimit } from "../../utils/config";
 import { alphaSort, statusSort } from "../../utils/sorters";
 import useLocalStorage from "../../utils/useLocalStorage";
@@ -96,13 +95,15 @@ export function SimplifiedPartsJobsListComponent({
       key: "status",
 
       ellipsis: true,
-      sorter: search?.search ? (a, b) => statusSort(a.status, b.status, bodyshop.md_ro_statuses.active_statuses) : true,
+      sorter: search?.search
+        ? (a, b) => statusSort(a.status, b.status, bodyshop.md_ro_statuses.parts_active_statuses)
+        : true,
       sortOrder: sortcolumn === "status" && sortorder,
       render: (text, record) => {
         return record.status || t("general.labels.na");
       },
       filteredValue: filter?.status || null,
-      filters: bodyshop.md_ro_statuses.statuses.map((s) => {
+      filters: bodyshop.md_ro_statuses.parts_statuses.map((s) => {
         return { text: s, value: [s] };
       }),
       onFilter: (value, record) => value.includes(record.status)
@@ -142,26 +143,6 @@ export function SimplifiedPartsJobsListComponent({
       sortOrder: sortcolumn === "clm_no" && sortorder,
       render: (text, record) => `${record.clm_no || ""}${record.po_number ? ` (PO: ${record.po_number})` : ""}`
     },
-    {
-      title: t("jobs.fields.ins_co_nm"),
-      dataIndex: "ins_co_nm",
-      key: "ins_co_nm",
-      ellipsis: true
-    },
-    {
-      title: t("jobs.fields.clm_total"),
-      dataIndex: "clm_total",
-      key: "clm_total",
-      sorter: search?.search ? (a, b) => a.clm_total - b.clm_total : true,
-      sortOrder: sortcolumn === "clm_total" && sortorder,
-      render: (text, record) => {
-        return record.clm_total ? (
-          <CurrencyFormatter>{record.clm_total}</CurrencyFormatter>
-        ) : (
-          t("general.labels.unknown")
-        );
-      }
-    },
     {
       title: t("jobs.fields.partsstatus"),
       dataIndex: "partsstatus",

client/src/firebase/firebase.utils.js

@@ -4,6 +4,8 @@ import { getAuth, updatePassword, updateProfile } from "@firebase/auth";
 import { getFirestore } from "@firebase/firestore";
 import { getMessaging, getToken, onMessage } from "@firebase/messaging";
 import { store } from "../redux/store";
+import * as amplitude from '@amplitude/analytics-browser';
+import posthog from 'posthog-js'
 
 const config = JSON.parse(import.meta.env.VITE_APP_FIREBASE_CONFIG);
 initializeApp(config);
@@ -71,25 +73,33 @@ onMessage(messaging, (payload) => {
 });
 
 export const logImEXEvent = (eventName, additionalParams, stateProp = null) => {
-  const state = stateProp || store.getState();
-  const eventParams = {
-    shop: (state.user && state.user.bodyshop && state.user.bodyshop.shopname) || null,
-    user: (state.user && state.user.currentUser && state.user.currentUser.email) || null,
-    ...additionalParams
-  };
-  // axios.post("/ioevent", {
-  //   useremail: (state.user && state.user.currentUser && state.user.currentUser.email) || null,
-  //   bodyshopid: (state.user && state.user.bodyshop && state.user.bodyshop.id) || null,
-  //   operationName: eventName,
-  //   variables: additionalParams,
-  //   dbevent: false,
-  //   env: `master-AIO|${import.meta.env.VITE_APP_GIT_SHA_DATE}`
-  // });
-  // console.log(
-  //   "%c[Analytics]",
-  //   "background-color: green ;font-weight:bold;",
-  //   eventName,
-  //   eventParams
-  // );
-  logEvent(analytics, eventName, eventParams);
+  try {
+
+    const state = stateProp || store.getState();
+    const eventParams = {
+      shop: (state.user && state.user.bodyshop && state.user.bodyshop.shopname) || null,
+      user: (state.user && state.user.currentUser && state.user.currentUser.email) || null,
+      ...additionalParams
+    };
+    // axios.post("/ioevent", {
+    //   useremail: (state.user && state.user.currentUser && state.user.currentUser.email) || null,
+    //   bodyshopid: (state.user && state.user.bodyshop && state.user.bodyshop.id) || null,
+    //   operationName: eventName,
+    //   variables: additionalParams,
+    //   dbevent: false,
+    //   env: `master-AIO|${import.meta.env.VITE_APP_GIT_SHA_DATE}`
+    // });
+    // console.log(
+    //   "%c[Analytics]",
+    //   "background-color: green ;font-weight:bold;",
+    //   eventName,
+    //   eventParams
+    // );
+    logEvent(analytics, eventName, eventParams);
+    amplitude.track(eventName, eventParams);
+    posthog.capture(eventName, eventParams);
+
+  } finally {
+    //If it fails, just keep going.
+  }
 };

client/src/index.jsx

@@ -14,6 +14,9 @@ import { persistor, store } from "./redux/store";
 import reportWebVitals from "./reportWebVitals";
 import "./translations/i18n";
 import "./utils/CleanAxios";
+import * as amplitude from "@amplitude/analytics-browser";
+import { PostHogProvider } from "posthog-js/react";
+import posthog from "posthog-js";
 
 window.global ||= window;
 
@@ -23,10 +26,32 @@ registerSW({ immediate: true });
 // Dinero.globalLocale = "en-CA";
 Dinero.globalRoundingMode = "HALF_EVEN";
 
+amplitude.init("6228a598e57cd66875cfd41604f1f891", {
+  defaultTracking: true
+  //  {
+  //     attribution: {
+  //       excludeReferrers: true,
+  //       initialEmptyValue: true,
+  //       resetSessionOnNewCampaign: true,
+  //     },
+  //     fileDownloads: true,
+  //     formInteractions: true,
+  //     pageViews: {
+  //       trackHistoryChanges: 'all'
+  //     },
+  //     sessions: true
+  //   }
+});
+
+posthog.init(import.meta.env.VITE_PUBLIC_POSTHOG_KEY, {
+  autocapture: false,
+  capture_exceptions: true,
+  api_host: import.meta.env.VITE_PUBLIC_POSTHOG_HOST
+});
+
 const sentryCreateBrowserRouter = Sentry.wrapCreateBrowserRouterV6(createBrowserRouter);
 
 const router = sentryCreateBrowserRouter(createRoutesFromElements(<Route path="*" element={<AppContainer />} />));
-
 if (import.meta.env.DEV) {
   let styles =
     "font-weight: bold; font-size: 50px;color: red;  6px 6px 0 rgb(226,91,14) , 9px 9px 0 rgb(245,221,8) , 12px 12px 0 rgb(5,148,68) ";
@@ -37,7 +62,9 @@ function App() {
   return (
     <PersistGate loading={<LoadingSpinner message="Restoring your settings..." />} persistor={persistor}>
       <Provider store={store}>
-        <RouterProvider router={router} />
+        <PostHogProvider client={posthog}>
+          <RouterProvider router={router} />
+        </PostHogProvider>
       </Provider>
     </PersistGate>
   );

client/src/redux/user/user.sagas.js

@@ -49,6 +49,8 @@ import {
   validatePasswordResetSuccess
 } from "./user.actions";
 import UserActionTypes from "./user.types";
+import * as amplitude from '@amplitude/analytics-browser';
+import posthog from 'posthog-js';
 
 const fpPromise = FingerprintJS.load();
 
@@ -83,8 +85,6 @@ export function* onCheckUserSession() {
 
 export function* isUserAuthenticated() {
   try {
-    logImEXEvent("redux_auth_check");
-
     const user = yield getCurrentUser();
     if (!user) {
       yield put(unauthorizedUser());
@@ -92,6 +92,8 @@ export function* isUserAuthenticated() {
     }
 
     LogRocket.identify(user.email);
+    amplitude.setUserId(user.email);
+    posthog.identify(user.email);
 
     const eulaQuery = yield client.query({
       query: QUERY_EULA,
@@ -137,6 +139,7 @@ export function* signOutStart() {
         imexshopid: state.user.bodyshop.imexshopid,
         type: "messaging"
       });
+      amplitude.reset();
     } catch {
       console.log("No FCM token. Skipping unsubscribe.");
     }
@@ -266,11 +269,11 @@ export function* signInSuccessSaga({ payload }) {
         instanceSeg,
         ...(isParts
           ? [
-              InstanceRenderManager({
-                imex: "ImexPartsManagement",
-                rome: "RomePartsManagement"
-              })
-            ]
+            InstanceRenderManager({
+              imex: "ImexPartsManagement",
+              rome: "RomePartsManagement"
+            })
+          ]
           : [])
       ];
       window.$crisp.push(["set", "session:segments", [segs]]);
@@ -295,7 +298,7 @@ export function* signInSuccessSaga({ payload }) {
 
   setUserId(analytics, payload.email);
   setUserProperties(analytics, payload);
-  yield logImEXEvent("redux_sign_in_success");
+  yield;
 }
 
 export function* onSendPasswordResetStart() {
@@ -362,6 +365,7 @@ export function* SetAuthLevelFromShopDetails({ payload }) {
     }
 
     try {
+      amplitude.setGroup('Shop', payload.shopname);
       window.$crisp.push(["set", "user:company", [payload.shopname]]);
       if (authRecord[0] && authRecord[0].user.validemail) {
         window.$crisp.push(["set", "user:email", [authRecord[0].user.email]]);

client/src/utils/GraphQLClient.js

@@ -181,7 +181,10 @@ const cache = new InMemoryCache({
 const client = new ApolloClient({
   link: ApolloLink.from(middlewares),
   cache,
-  connectToDevTools: import.meta.env.DEV,
+  devtools: {
+    name: "Imex Client",
+    enabled: import.meta.env.DEV
+  },
   defaultOptions: {
     watchQuery: {
       fetchPolicy: "network-only",

package.json

@@ -18,14 +18,14 @@
     "job-totals-fixtures:local": "docker exec node-app /usr/bin/node /app/download-job-totals-fixtures.js"
   },
   "dependencies": {
-    "@aws-sdk/client-cloudwatch-logs": "^3.873.0",
-    "@aws-sdk/client-elasticache": "^3.872.0",
-    "@aws-sdk/client-s3": "^3.872.0",
-    "@aws-sdk/client-secrets-manager": "^3.872.0",
-    "@aws-sdk/client-ses": "^3.872.0",
-    "@aws-sdk/credential-provider-node": "^3.873.0",
-    "@aws-sdk/lib-storage": "^3.872.0",
-    "@aws-sdk/s3-request-presigner": "^3.872.0",
+    "@aws-sdk/client-cloudwatch-logs": "^3.876.0",
+    "@aws-sdk/client-elasticache": "^3.876.0",
+    "@aws-sdk/client-s3": "^3.876.0",
+    "@aws-sdk/client-secrets-manager": "^3.876.0",
+    "@aws-sdk/client-ses": "^3.876.0",
+    "@aws-sdk/credential-provider-node": "^3.876.0",
+    "@aws-sdk/lib-storage": "^3.876.0",
+    "@aws-sdk/s3-request-presigner": "^3.876.0",
     "@opensearch-project/opensearch": "^2.13.0",
     "@socket.io/admin-ui": "^0.5.1",
     "@socket.io/redis-adapter": "^8.3.0",
@@ -33,14 +33,14 @@
     "aws4": "^1.13.2",
     "axios": "^1.11.0",
     "better-queue": "^3.8.12",
-    "bullmq": "^5.58.0",
+    "bullmq": "^5.58.2",
     "chart.js": "^4.5.0",
     "cloudinary": "^2.7.0",
     "compression": "^1.8.1",
     "cookie-parser": "^1.4.7",
     "cors": "^2.8.5",
     "crisp-status-reporter": "^1.2.2",
-    "dd-trace": "^5.63.3",
+    "dd-trace": "^5.64.0",
     "dinero.js": "^1.9.1",
     "dotenv": "^17.2.1",
     "express": "^4.21.1",
@@ -62,7 +62,7 @@
     "query-string": "7.1.3",
     "recursive-diff": "^1.0.9",
     "rimraf": "^6.0.1",
-    "skia-canvas": "^3.0.3",
+    "skia-canvas": "^3.0.4",
     "soap": "^1.3.0",
     "socket.io": "^4.8.1",
     "socket.io-adapter": "^2.5.5",
@@ -76,8 +76,8 @@
     "yazl": "^3.3.1"
   },
   "devDependencies": {
-    "@eslint/js": "^9.33.0",
-    "eslint": "^9.33.0",
+    "@eslint/js": "^9.34.0",
+    "eslint": "^9.34.0",
     "eslint-plugin-react": "^7.37.5",
     "globals": "^15.15.0",
     "mock-require": "^3.0.3",

server/data/data.js

@@ -6,4 +6,5 @@ exports.kaizen = require("./kaizen").default;
 exports.usageReport = require("./usageReport").default;
 exports.podium = require("./podium").default;
 exports.emsUpload = require("./emsUpload").default;
-exports.carfax = require("./carfax").default;
+exports.carfax = require("./carfax").default;
+exports.vehicletype = require("./vehicletype/vehicletype").default;

server/data/vehicletype/cargovans.json

@@ -0,0 +1,126 @@
+[
+  "PROMASTER 1500",
+  "PROMASTER 2500",
+  "PROMASTER CITY",
+  "NV 1500",
+  "NV 200",
+  "NV 2500",
+  "NV 3500",
+  "NV1500",
+  "NV200",
+  "NV2500",
+  "NV3500",
+  "SPRINTER",
+  "E150 ECONOLINE CARGO VAN",
+  "E150 ECONOLINE XL",
+  "E250 ECONOLINE CARGO",
+  "E250 ECONOLINE CARGO (AMALGAM)",
+  "E250 ECONOLINE CARGO (INSPECT)",
+  "E250 ECONOLINE CARGO VAN EXT",
+  "E250 ECONOLINE SUPER CARGO VAN",
+  "E350 CUTAWAY VAN",
+  "E350 ECONO SD CARGO VAN EXT",
+  "E350 ECONOLINE CARGO VAN",
+  "E350 ECONOLINE CUTAWAY",
+  "E350 ECONOLINE SD CARGO VAN",
+  "E350 ECONOLINE SD XL",
+  "E350 ECONOLINE SD XL EXT",
+  "E350 ECONOLINE SD XLT",
+  "E350 ECONOLINE SD XLT EXT",
+  "E350 SD CUTAWAY",
+  "E450",
+  "E450 ECONOLINE",
+  "E450 ECONOLINE SD",
+  "E450 ECONOLINE SD CUTAWAY",
+  "TRANSIT 150 WB 130 CARGO VAN",
+  "TRANSIT 150 WB 130 XLT",
+  "TRANSIT 150 WB 148 CARGO VAN",
+  "TRANSIT 250 WB 130 CARGO VAN",
+  "TRANSIT 250 WB 148 CARGO VAN",
+  "TRANSIT 250 WB 148 EL CARGO",
+  "TRANSIT 350 WB 148 CARGO VAN",
+  "TRANSIT 350 WB 148 EL CARGO",
+  "TRANSIT CONNECT XL CARGO VAN",
+  "TRANSIT CONNECT XLT CARGO VAN",
+  "250 TRANSIT",
+  "CITY EXPRESS LS CARGO VAN",
+  "CITY EXPRESS LT CARGO VAN",
+  "EXPRESS 1500",
+  "EXPRESS 1500 CARGO VAN",
+  "EXPRESS 1500 LS",
+  "EXPRESS 1500 LT",
+  "EXPRESS 2500 CARGO VAN",
+  "EXPRESS 2500 CARGO VAN EXT",
+  "EXPRESS 2500 LS",
+  "EXPRESS 2500 LT",
+  "EXPRESS 3500",
+  "EXPRESS 3500 CARGO VAN",
+  "EXPRESS 3500 CARGO VAN EXT",
+  "EXPRESS 3500 EXT",
+  "EXPRESS 3500 LS",
+  "EXPRESS 3500 LS EXT",
+  "EXPRESS 3500 LT",
+  "EXPRESS 3500 LT EXT",
+  "G3500 EXPRESS CUTAWAY",
+  "SAVANA 1500 CARGO VAN",
+  "SAVANA 1500 SL",
+  "SAVANA 1500 SLE",
+  "SAVANA 2500",
+  "2500 SAVANA",
+  "SAVANA 2500 CARGO VAN",
+  "SAVANA 2500 CARGO VAN EXT",
+  "SAVANA 2500 LT",
+  "SAVANA 2500 SLE",
+  "SAVANA 3500",
+  "SAVANA 3500 CARGO VAN",
+  "SAVANA 3500 CARGO VAN EXT",
+  "SAVANA 3500 EXT",
+  "SAVANA 3500 LT EXT",
+  "SAVANA 3500 SLE EXT",
+  "SAVANA G3500 CUTAWAY",
+  "SAVANA G4500 CUTAWAY",
+  "EXPRESS 1500 LS CARGO VAN",
+  "G20 SPORTVAN",
+  "NV 3500 S V8 CARGO VAN",
+  "E-150",
+  "E-250",
+  "E-350",
+  "E-450",
+  "E150",
+  "E250",
+  "E350",
+  "TRANSIT",
+  "CITY",
+  "CITY EXPRESS",
+  "EXPRESS",
+  "EXPRESS 2500",
+  "G3500",
+  "SAVANA",
+  "SAVANA 1500",
+  "CHEVY EXPRESS G2500",
+  "CLUBWAGON E350",
+  "TRANSIT CONNECT",
+  "SPRINTER 2500",
+  "TRANSIT 150",
+  "ECONOLINE E250",
+  "TRANSIT 250",
+  "ECONOLINE E350",
+  "NV3500 HD",
+  "TRANSIT 350HD",
+  "ECONOLINE E150",
+  "E250 ECONOLINE",
+  "C/V",
+  "E350 CHSCAB",
+  "G1500 CHEVY EXPRESS",
+  "2500 SPRINTER",
+  "E150 ECONOLINE",
+  "350 TRANSIT",
+  "E450 CUTAWAY",
+  "PROMASTER 3500",
+  "CHEVY EXPRESS G3500",
+  "SAVANA G3500",
+  "1500 PROMASTER",
+  "2500 EXPRESS",
+  "3500 EXPRESS",
+  "3500 SPRINTER"
+]

server/data/vehicletype/passengervans.json

@@ -0,0 +1,33 @@
+[
+  "GRAND CARAVAN",
+  "GRANDCARAVAN",
+  "GRAND CARAVAN CREW",
+  "GRAND CARAVAN CV",
+  "GRAND CARAVAN CVP",
+  "GRAND CARAVAN SE",
+  "GRAND CARAVAN SXT",
+  "CARAVAN CV",
+  "SIENNA CE V6",
+  "SIENNA LE V6",
+  "SIENNA XLE V6",
+  "SIENNA",
+  "ODYSSEY",
+  "SEDONA",
+  "PACIFICA (NEW)",
+  "QUEST",
+  "CARAVAN",
+  "MONTANA SV6",
+  "FREESTAR",
+  "UPLANDER",
+  "MONTANA",
+  "VOYAGER",
+  "ENTOURAGE",
+  "PACIFICA",
+  "CARNIVAL",
+  "VENTURE",
+  "SAFARI",
+  "VANAGON",
+  "WINDSTAR",
+  "TOWN&COUNTRY",
+  "ROUTAN"
+]

server/data/vehicletype/suvs.json

@@ -0,0 +1,485 @@
+[
+  "EDGE SEL",
+  "ESCAPE",
+  "ESCAPE SE",
+  "ESCAPE SEL",
+  "ESCAPE XLT V6",
+  "EXPEDITION",
+  "EXPEDITION LIMITED",
+  "EXPEDITION MAX",
+  "EXPEDITION MAX LIMITED",
+  "EXPLORER",
+  "EXCURSION",
+  "EXPLORER LIMITED",
+  "EXPLORER PLATINUM ECOBOOST",
+  "EXPLORER XLT",
+  "FLEX",
+  "FLEX SE",
+  "ECOSPORT",
+  "ESCAPE HYBRID",
+  "MUSTANG MACH-E",
+  "BRONCO",
+  "BRONCO SPORT",
+  "TRAILBLAZER",
+  "BLAZER LT",
+  "CHEROKEE",
+  "CHEROKEE CLASSIC",
+  "CHEROKEE COUNTRY",
+  "CHEROKEE LIMITED",
+  "CHEROKEE NORTH",
+  "CHEROKEE OVERLAND",
+  "CHEROKEE SPORT",
+  "CHEROKEE TRAILHAWK",
+  "CJ",
+  "CJ7",
+  "CJ7 RENEGADE",
+  "COMMANDER",
+  "COMMANDER LIMITED",
+  "COMMANDER SPORT",
+  "COMPASS",
+  "COMPASS HIGH ALTITUDE",
+  "COMPASS LATITUDE",
+  "COMPASS LIMITED",
+  "COMPASS NORTH",
+  "COMPASS SPORT",
+  "COMPASS TRAILHAWK",
+  "GLADIATOR OVERLAND",
+  "GLADIATOR RUBICON",
+  "GRAND CHEROKEE LAREDO",
+  "GRAND CHEROKEE LIMITED",
+  "GRAND CHEROKEE OVERLAND",
+  "GRAND CHEROKEE SE",
+  "GRAND CHEROKEE SRT",
+  "GRAND CHEROKEE SRT8",
+  "GRAND CHEROKEE SUMMIT",
+  "GRAND CHEROKEE TRACKHAWK",
+  "GRAND CHEROKEE TRAILHAWK",
+  "GRAND CHEROKEE",
+  "GRANDCHEROKEE",
+  "LIBERTY LIMITED",
+  "LIBERTY RENEGADE",
+  "LIBERTY SPORT",
+  "LIBERTY",
+  "PATRIOT",
+  "PATRIOT HIGH ALTITUDE",
+  "PATRIOT LATITUDE",
+  "PATRIOT LIMITED",
+  "PATRIOT NORTH",
+  "PATRIOT SPORT",
+  "RENEGADE LIMITED",
+  "RENEGADE NORTH",
+  "RENEGADE SPORT",
+  "RENEGADE TRAILHAWK",
+  "TJ",
+  "TJ RUBICON",
+  "TJ SAHARA",
+  "TJ SPORT",
+  "TJ UNLIMITED",
+  "WRANGLER",
+  "WRANGLER RUBICON",
+  "WRANGLER SAHARA",
+  "WRANGLER SPORT",
+  "WRANGLER UNLIMITED",
+  "WRANGLER UNLIMITED 70TH ANNIV",
+  "WRANGLER UNLIMITED RUBICON",
+  "WRANGLER UNLIMITED SAHARA",
+  "WRANGLER UNLIMITED SPORT",
+  "WRANGLER UNLIMITED X",
+  "WRANGLER X",
+  "YJ WRANGLER",
+  "AVIATOR",
+  "AVIATOR RESERVE",
+  "MKC",
+  "MKC RESERVE",
+  "MKC SELECT",
+  "MKT",
+  "MKT ECOBOOST",
+  "MKX",
+  "MKX RESERVE",
+  "NAUTILUS RESERVE",
+  "NAUTILUS RESERVE V6",
+  "NAVIGATOR",
+  "NAVIGATOR L",
+  "NAVIGATOR L RESERVE",
+  "NAVIGATOR L SELECT",
+  "NAVIGATOR RESERVE",
+  "PILOT",
+  "PILOT BLACK EDITION",
+  "PILOT ELITE",
+  "PILOT EX",
+  "PILOT EX-L",
+  "PILOT GRANITE",
+  "PILOT LX",
+  "PILOT SE",
+  "PILOT SE-L",
+  "PILOT TOURING",
+  "DURANGO R/T",
+  "DURANGO SLT PLUS",
+  "DURANGO SRT",
+  "DURANGO",
+  "JOURNEY",
+  "JOURNEY CROSSROAD",
+  "JOURNEY CVP",
+  "JOURNEY LIMITED",
+  "JOURNEY R/T",
+  "JOURNEY SXT",
+  "NITRO SE",
+  "NITRO",
+  "K1500 SUBURBAN",
+  "SUBURBAN 1500 LT",
+  "SUBURBAN 1500 LTZ",
+  "SUBURBAN 1500 PREMIER",
+  "SUBURBAN 2500 LS",
+  "TAHOE LT",
+  "TRAVERSE LS",
+  "TRAVERSE LT",
+  "TRAVERSE PREMIER",
+  "TRAX LT",
+  "TRAX PREMIER",
+  "UPLANDER LT EXT",
+  "SUBURBAN",
+  "TAHOE",
+  "TRAVERSE",
+  "TRAX",
+  "UPLANDER",
+  "YUKON",
+  "YUKON DENALI",
+  "YUKON XL",
+  "YUKON XL DENALI",
+  "EQUINOX LS",
+  "EQUINOX LT",
+  "EQUINOX PREMIER",
+  "EQUINOX",
+  "RAV4 LE",
+  "RAV4 XLE",
+  "HIGHLANDER SPORT V6",
+  "4RUNNER SR5 V6",
+  "RAV4",
+  "RAV4 HYBRID",
+  "RAV4 XLE HYBRID",
+  "HIGHLANDER",
+  "4RUNNER",
+  "SEQUOIA",
+  "PATHFINDER SE",
+  "PATHFINDER SL",
+  "PATHFINDER",
+  "MURANO PLATINUM",
+  "MURANO SV",
+  "MURANO",
+  "TUCSON",
+  "TERRAIN",
+  "SORENTO",
+  "EDGE",
+  "KICKS",
+  "QASHQAI",
+  "SANTA FE",
+  "ARMADA",
+  "TELLURIDE",
+  "PALISADE",
+  "SELTOS",
+  "TORRENT",
+  "C-HR",
+  "SPORTAGE",
+  "VENZA",
+  "ACADIA",
+  "CR-V",
+  "HR-V",
+  "CX-5",
+  "CX-50",
+  "CX-7",
+  "CX-9",
+  "CX-3",
+  "Q3",
+  "Q5",
+  "Q7",
+  "Q8",
+  "JUKE SV",
+  "JUKE",
+  "ROGUE",
+  "ROGUE SV",
+  "XTERRA",
+  "COROLLA CROSS",
+  "ACADIA DENALI",
+  "TAURUS X",
+  "MACAN",
+  "FJ CRUISER",
+  "BRONCO SPORT BADLANDS",
+  "ESCALADE",
+  "RX 350",
+  "KONA",
+  "MDX",
+  "RDX",
+  "COOPER COUNTRYMAN",
+  "V70",
+  "OUTLANDER",
+  "RIO5",
+  "GLC300 COUPE",
+  "ENCORE",
+  "SRX",
+  "SANTA FE SPORT",
+  "NX 300",
+  "WRANGLER UNLIMITE",
+  "WRANGLER JK UNLIM",
+  "RANGEROVER EVOQUE",
+  "CROSSTREK",
+  "FORESTER",
+  "TIGUAN",
+  "XV CROSSTREK",
+  "ENDEAVOR",
+  "RX 330",
+  "ATLAS",
+  "XC90",
+  "TOUAREG",
+  "STELVIO",
+  "RANGE ROVER SPORT",
+  "GLE350D",
+  "EX35",
+  "RVR",
+  "MONTERO",
+  "X-TRAIL",
+  "GRAND VITARA",
+  "TRIBUTE",
+  "X3",
+  "XC60",
+  "GLK250 BLUETEC",
+  "ENVOY",
+  "ML350 BLUETEC",
+  "ENVISION",
+  "FX35",
+  "X1",
+  "VENUE",
+  "TAOS",
+  "KONA ELECTRIC",
+  "OUTLANDER PHEV",
+  "PASSPORT",
+  "H3",
+  "EXPLORERSPORTTRAC",
+  "F-PACE",
+  "ML320 BLUETEC",
+  "REGAL SPORTBACK",
+  "DISCOVERY SPORT",
+  "RENDEZVOUS",
+  "XC70",
+  "COMPASS (NEW)",
+  "CUBE",
+  "V60 CROSS COUNTRY",
+  "QX70",
+  "X6",
+  "ELEMENT",
+  "RX 400H",
+  "VUE",
+  "RANGE ROVER VELAR",
+  "E-PACE",
+  "RAV4 PRIME",
+  "LX 570",
+  "GX 470",
+  "EX37",
+  "GLE43",
+  "NAUTILUS",
+  "XT6",
+  "RX 450H",
+  "ESCALADE ESV",
+  "OUTLOOK",
+  "CAYENNE",
+  "XC90 PLUG-IN",
+  "MODEL X",
+  "MODEL Y",
+  "GLC300",
+  "SANTA FE HYBRID",
+  "G63",
+  "XV CROSSTREK HYBR",
+  "JX35",
+  "JIMMY",
+  "TUCSON HYBRID",
+  "XC40 ELECTRIC",
+  "RX 300",
+  "ML320",
+  "WRANGLER JK UNLIMITED",
+  "POLICE INTERCEPTOR UTILITY",
+  "WRANGLER JK",
+  "TRIBECA",
+  "E-TRON SPORTBACK",
+  "500X",
+  "RX 350H",
+  "GL350 BLUETEC",
+  "WRANGLER UNLIMITED 4XE",
+  "GV80",
+  "GL550",
+  "Q5 E",
+  "H2 SUV",
+  "Q5 HYBRID",
+  "IONIQ 5",
+  "SQ5 SPORTBACK",
+  "LEVANTE",
+  "TONALE",
+  "GLE43 COUPE",
+  "GRAND CHEROKEE WK",
+  "DEFENDER",
+  "NX 450H+",
+  "ML400",
+  "LX 600",
+  "RX 450HL",
+  "SORENTO HYBRID",
+  "NX 350",
+  "TRACKER",
+  "GLE450",
+  "Q5 SPORTBACK",
+  "CR-V HYBRID",
+  "LX 470",
+  "EQS580 SUV",
+  "H2",
+  "EV9",
+  "SORENTO PLUG-IN",
+  "LYRIQ",
+  "GLE550",
+  "RX 500H",
+  "X1 SAV",
+  "E-TRON S SPORTBACK",
+  "ML500",
+  "GRAND HIGHLANDER HYBRID",
+  "RS Q8",
+  "GLS550",
+  "GLS580",
+  "IX",
+  "CAYENNE COUPE",
+  "SOLTERRA",
+  "PATHFINDER HYBRID",
+  "Q8 E-TRON",
+  "TX 350",
+  "TX 500H",
+  "EQUINOX EV",
+  "NAUTILUS HYBRID",
+  "TRAVERSE LIMITED",
+  "CX-70",
+  "SANTA FE XL",
+  "RENEGADE",
+  "QX50",
+  "ECLIPSE CROSS",
+  "QX80",
+  "X5",
+  "X3",
+  "X1",
+  "X4",
+  "ENCLAVE",
+  "ENCORE GX",
+  "CAYENNE HYBRID",
+  "SOUL",
+  "GX 460",
+  "UX 250H",
+  "XT5",
+  "GLE53",
+  "XT4",
+  "SQ7",
+  "NX 350H",
+  "GLK350",
+  "GLE350",
+  "NX 300H",
+  "NX 200T",
+  "RANGE ROVER EVOQUE",
+  "GLS450",
+  "TERRAIN DENALI",
+  "GRAND CHEROKEE L",
+  "GLE400",
+  "TUCSON PLUG-IN",
+  "BLAZER",
+  "ASCENT",
+  "HIGHLANDER HYBRID",
+  "ATLAS CROSS SPORT",
+  "XC40",
+  "VENZA HYBRID",
+  "GLA45",
+  "GLB250",
+  "GRAND HIGHLANDER",
+  "GV70",
+  "NIRO",
+  "NIRO EV",
+  "GLA250",
+  "ESCAPE PLUG-IN",
+  "WAGONEER",
+  "CX-30",
+  "QX60",
+  "GRAND CHEROKEE 4XE",
+  "SPORTAGE HYBRID",
+  "EV6",
+  "TONALE PLUG-IN",
+  "GLC43 COUPE",
+  "X2",
+  "RX 350L",
+  "HORNET",
+  "ENVISTA",
+  "LEVANTE S",
+  "SPORTAGE PLUG-IN",
+  "ORLANDO",
+  "X5 M",
+  "EXPLORER HYBRID",
+  "FREESTYLE",
+  "CORSAIR",
+  "K1500 YUKON XL",
+  "RANGE ROVER",
+  "SUV W/O LABOR",
+  "ID.4",
+  "CX-90",
+  "X7",
+  "CORSAIR PLUG-IN",
+  "ESCALADE EXT",
+  "QX55",
+  "DISCOVERY",
+  "BOLT EUV",
+  "C40 ELECTRIC",
+  "LR4",
+  "GRAND WAGONEER",
+  "XC60 PLUG-IN",
+  "LR2",
+  "EQE350 SUV",
+  "COROLLA CROSS HYBRID",
+  "SOUL EV",
+  "GRECALE",
+  "SUV W/O LABOR",
+  "QX30",
+  "SQ5",
+  "NIRO PLUG-IN",
+  "BORREGO",
+  "CX-90 PLUG-IN",
+  "XL-7",
+  "SUV W/O LABOR",
+  "SUV W/O LABOR",
+  "I-PACE",
+  "HORNET PLUG-IN",
+  "UX 300H",
+  "ML320 CDI",
+  "VERACRUZ",
+  "SQ8",
+  "GLE53 COUPE",
+  "ZDX",
+  "9-7X",
+  "ARIYA",
+  "ASPEN",
+  "AVIATOR PLUG-IN",
+  "B9 TRIBECA",
+  "BRAVADA",
+  "ENVOY XL",
+  "EQB350",
+  "EQB350 SUV",
+  "ESCALADE-V",
+  "E-TRON",
+  "FX37",
+  "GL320 CDI",
+  "GLADIATOR",
+  "GLC43",
+  "GLE450 COUPE",
+  "GLE63",
+  "GV60",
+  "MKT TOWN CAR",
+  "ML350",
+  "ML550",
+  "ML63",
+  "NX 250",
+  "Q4 E-TRON",
+  "Q8 E-TRON SPORTBACK",
+  "QX4",
+  "QX56",
+  "SANTA FE PLUG-IN",
+  "UX 200",
+  "WAGONEER L",
+  "XB"
+]

server/data/vehicletype/trucks.json

@@ -0,0 +1,567 @@
+[
+  "MARK LT",
+  
+  "F-150",
+  "F-250",
+  "F-350",
+  "F-450",
+  "F-550",
+  "F-650",
+  "F100 PICKUP",
+  "F150 FX2 SUPERCAB",
+  "F150 FX4 PICKUP",
+  "F150 FX4 SUPERCAB",
+  "F150 FX4 SUPERCREW",
+  "F150 HARLEY DAVIDSON SUPERCAB",
+  "F150 HARLEY DAVIDSON SUPERCREW",
+  "F150 KING RANCH SUPERCREW",
+  "F150 LARIAT FX4 SUPERCREW",
+  "F150 LARIAT HARLEY DAVIDSON SC",
+  "F150 LARIAT KING RANCH SUPCREW",
+  "F150 LARIAT LIMITED SUPERCREW",
+  "F150 LARIAT PICKUP",
+  "F150 LARIAT SUPERCAB",
+  "F150 LARIAT SUPERCAB (AMALGAM)",
+  "F150 LARIAT SUPERCREW",
+  "F150 LARIAT SUPERCREW (AMALGA)",
+  "F150 LIMITED SUPERCREW",
+  "F150 PICKUP",
+  "F150 PLATINUM SUPERCREW",
+  "F150 RAPTOR SUPERCAB",
+  "F150 RAPTOR SUPERCREW",
+  "F150 STX PICKUP",
+  "F150 STX SUPERCAB",
+  "F150 SUPERCAB",
+  "F150 SUPERCREW",
+  "F150 SUPERCREW (AMALGAMATED)",
+  "F150 SVT RAPTOR SUPERCAB",
+  "F150 XL PICKUP",
+  "F150 XL SUPERCAB",
+  "F150 XL SUPERCREW",
+  "F150 XLT LARIAT SUPERCAB",
+  "F150 XLT PICKUP",
+  "F150 XLT SUPERCAB",
+  "F150 XLT SUPERCREW",
+  "F150 XLT SUPERCREW (AMALGAMAT)",
+  "F150 XTR SUPERCAB",
+  "F250 PICKUP",
+  "F250 SD CREW CAB",
+  "F250 SD FX4 CREW CAB",
+  "F250 SD FX4 SUPERCAB",
+  "F250 SD KING RANCH CREW CAB",
+  "F250 SD LARIAT CREW CAB",
+  "F250 SD LARIAT CREW CAB (AMAL)",
+  "F250 SD LARIAT PICKUP",
+  "F250 SD LARIAT SUPERCAB",
+  "F250 SD LIMITED CREW CAB",
+  "F250 SD PLATINUM CREW CAB",
+  "F250 SD SUPERCAB",
+  "F250 SD XL CREW CAB",
+  "F250 SD XL PICKUP",
+  "F250 SD XL SUPERCAB",
+  "F250 SD XLT CREW CAB",
+  "F250 SD XLT PICKUP",
+  "F250 SD XLT SUPERCAB",
+  "F250 SUPERCAB",
+  "F250 XL CREW CAB",
+  "F350 CREW CAB",
+  "F350 PICKUP",
+  "F350 PICKUP 2WD",
+  "F350 SD CABELAS CREW CAB",
+  "F350 SD CREW CAB",
+  "F350 SD FX4 CREW CAB",
+  "F350 SD FX4 SUPERCAB",
+  "F350 SD HARLEY DAVIDSON",
+  "F350 SD KING RANCH CREW CAB",
+  "F350 SD LARIAT CREW CAB",
+  "F350 SD LARIAT CREW CAB (AMAL)",
+  "F350 SD LARIAT KING RANCH",
+  "F350 SD LARIAT SUPERCAB",
+  "F350 SD LIMITED CREW CAB",
+  "F350 SD PICKUP",
+  "F350 SD PLATINUM CREW CAB",
+  "F350 SD SUPERCAB",
+  "F350 SD XL CREW CAB",
+  "F350 SD XL PICKUP",
+  "F350 SD XL SUPERCAB",
+  "F350 SD XLT CREW CAB",
+  "F350 SD XLT SUPERCAB",
+  "F350 SUPER DUTY",
+  "F350 SUPER DUTY XL",
+  "F350 XL PICKUP",
+  "F450",
+  "F450 Pickup",
+  "F450 SD KING RANCH CREW CAB",
+  "F450 SD LARIAT CREW CAB",
+  "F450 SD PICKUP",
+  "F450 SD PLATINUM CREW CAB",
+  "F450 SD XL",
+  "F450 SD XL CREW CAB",
+  "F450 SD XL PICKUP",
+  "F450 SD XLT CREW CAB",
+  "F450 SUPER DUTY XLT",
+  "F550",
+  "F550 SD",
+  "F550 SD XL",
+  "F550 SD XL PICKUP",
+  "F550 SD XLT CREW CAB",
+  "F550 SD XLT SUPERCAB",
+  "F550 SUPER DUTY",
+  "F550 SUPER DUTY XL",
+  "F550 SUPER DUTY XLT",
+  "F550 SUPER DUTY XLT CREW CAB",
+  "F550 XL",
+  "F650 SD XLT SUPERCAB",
+  "F68",
+  "F750 XL",
+
+  "RANGER",
+  "RANGER EDGE SUPERCAB",
+  "RANGER FX4 SUPERCAB",
+  "RANGER LARIAT SUPERCREW",
+  "RANGER SPORT SUPERCAB",
+  "RANGER STX SUPERCAB",
+  "RANGER SUPERCAB",
+  "RANGER XL",
+  "RANGER XL SUPERCAB",
+  "RANGER XLT",
+  "RANGER XLT SUPERCAB",
+  "RANGER XLT SUPERCREW",
+
+  "FRONTIER LE CREW CAB V6",
+  "FRONTIER NISMO CREW CAB V6",
+  "FRONTIER NISMO KING CAB V6",
+  "FRONTIER PRO-4X CREW CAB V6",
+  "FRONTIER PRO-4X KING CAB V6",
+  "FRONTIER S KING CAB",
+  "FRONTIER SC CREW CAB V6",
+  "FRONTIER SC V6",
+  "FRONTIER SE CREW CAB V6",
+  "FRONTIER SE KING CAB V6",
+  "FRONTIER SL CREW CAB V6",
+  "FRONTIER SV CREW CAB V6",
+  "FRONTIER SV KING CAB V6",
+  "FRONTIER XE KING CAB",
+  "FRONTIER XE KING CAB V6",
+  "KING CAB",
+
+  "TITAN 5.6 LE CREW CAB",
+  "TITAN 5.6 LE KING CAB",
+  "TITAN 5.6 MIDNIGHT CREW CAB",
+  "TITAN 5.6 PLATINUM RESERVE CC",
+  "TITAN 5.6 PRO-4X CREW CAB",
+  "TITAN 5.6 PRO-4X KING CAB",
+  "TITAN 5.6 S CREW CAB",
+  "TITAN 5.6 SE CREW CAB",
+  "TITAN 5.6 SE KING CAB",
+  "TITAN 5.6 SL CREW CAB",
+  "TITAN 5.6 SV CREW CAB",
+  "TITAN 5.6 SV KING CAB",
+  "TITAN 5.6 XE CREW CAB",
+  "TITAN 5.6 XE KING CAB",
+  "TITAN XD PLATINUM CREW CAB",
+  "TITAN XD PRO-4X CREW CAB",
+  "TITAN XD S CREW CAB",
+  "TITAN XD SL CREW CAB",
+  "TITAN XD SV CREW CAB",
+
+  "PICKUP SR5",
+
+  "TACOMA",
+  "TACOMA ACCESS CAB",
+  "TACOMA DOUBLE CAB V6",
+  "TACOMA LIMITED DOUBLE CAB V6",
+  "TACOMA PRERUNNER DOUBLE CAB V6",
+  "TACOMA PRERUNNER V6 ACCESS CAB",
+  "TACOMA PRERUNNER XTRACAB",
+  "TACOMA PRERUNNER XTRACAB V6",
+  "TACOMA SR5 DOUBLE CAB V6",
+  "TACOMA SR5 V6 ACCESS CAB",
+  "TACOMA SR5 V6 XTRACAB",
+  "TACOMA V6 ACCESS CAB",
+  "TACOMA XTRACAB",
+  "TACOMA XTRACAB V6",
+  "TUNDRA ACCESS CAB V8",
+  "TUNDRA DOUBLE CAB V8",
+  "TUNDRA LIMITED ACCESS CAB V8",
+  "TUNDRA LIMITED SR5 DBLCAB V8",
+  "TUNDRA LIMITED V8",
+  "TUNDRA LIMITED V8 CREWMAX",
+  "TUNDRA LIMITED V8 DOUBLE CAB",
+  "TUNDRA PLATINUM V8 CREWMAX",
+  "TUNDRA SR DOUBLE CAB V8",
+  "TUNDRA SR V8",
+  "TUNDRA SR5 DOUBLE CAB V8",
+  "TUNDRA SR5 TRD DOUBLE CAB V8",
+  "TUNDRA SR5 V8 CREWMAX",
+  "TUNDRA V8",
+  "TUNDRA V8 CREWMAX",
+  "XTRACAB LONG BOX",
+
+  "AVALANCHE 1500",
+  "AVALANCHE 1500 LS",
+  "AVALANCHE 1500 LS Z71",
+  "AVALANCHE 1500 LT",
+  "AVALANCHE 1500 LT Z71",
+  "AVALANCHE 1500 LTZ",
+  "C/R 10/1500 4+CAB",
+  "C/R 10/1500 PICKUP",
+  "C/R 20/2500 4+CAB",
+  "C/R 20/2500 PICKUP",
+  "C3500",
+
+  "COLORADO",
+  "COLORADO EXT CAB",
+  "COLORADO LS",
+  "COLORADO LS CREW CAB",
+  "COLORADO LS EXT CAB",
+  "COLORADO LT",
+  "COLORADO LT CREW CAB",
+  "COLORADO LT EXT CAB",
+  "COLORADO WT CREW CAB",
+  "COLORADO WT EXT CAB",
+  "COLORADO Z71 CREW CAB",
+  "COLORADO Z71 EXT CAB",
+  "COLORADO ZR2 CREW CAB",
+  "COLORADO ZR2 EXT CAB",
+
+  "HHR LS PANEL",
+  "K/V 10/1500 4+CAB",
+  "K/V 10/1500 PICKUP",
+  "K/V 20/2500 4+CAB",
+  "K/V 20/2500 PICKUP",
+  "K/V 30/3500 4+CAB",
+  "Pickup K3500",
+  "Pickup Silverado C2500 HD",
+  "S10 4+CAB",
+  "S10 LS 4+CAB",
+  "SILVERADO 1500",
+  "SILVERADO 1500 CHEYENNE CREW",
+  "SILVERADO 1500 CREW CAB",
+  "SILVERADO 1500 CREW CAB (AMAL)",
+  "SILVERADO 1500 CUST TRAIL DC",
+  "SILVERADO 1500 CUSTOM CREW CAB",
+  "SILVERADO 1500 CUSTOM DC",
+  "SILVERADO 1500 CUSTOM TRAIL CC",
+  "SILVERADO 1500 DOUBLE (AMALGA)",
+  "SILVERADO 1500 EXT CAB",
+  "SILVERADO 1500 HD LS CREW CAB",
+  "SILVERADO 1500 HD LT CREW CAB",
+  "SILVERADO 1500 HIGH COUNTRY CC",
+  "SILVERADO 1500 HYBRID CREW CAB",
+  "SILVERADO 1500 LS",
+  "SILVERADO 1500 LS CREW CAB",
+  "SILVERADO 1500 LS DOUBLE CAB",
+  "SILVERADO 1500 LS EXT CAB",
+  "SILVERADO 1500 LT",
+  "SILVERADO 1500 LT CC (AMALGAM)",
+  "SILVERADO 1500 LT CREW CAB",
+  "SILVERADO 1500 LT DOUBLE CAB",
+  "SILVERADO 1500 LT EXT CAB",
+  "SILVERADO 1500 LT TRAIL CC",
+  "SILVERADO 1500 LT TRAIL DC",
+  "SILVERADO 1500 LTZ CREW CAB",
+  "SILVERADO 1500 LTZ DOUBLE CAB",
+  "SILVERADO 1500 LTZ EXT CAB",
+  "SILVERADO 1500 RST CREW CAB",
+  "SILVERADO 1500 RST DOUBLE CAB",
+  "SILVERADO 1500 SS EXT CAB",
+  "SILVERADO 1500 WT",
+  "SILVERADO 1500 WT CREW CAB",
+  "SILVERADO 1500 WT DOUBLE CAB",
+  "SILVERADO 1500 WT EXT CAB",
+  "SILVERADO 2500 EXT CAB",
+  "SILVERADO 2500 HD",
+  "SILVERADO 2500 HD CREW CAB",
+  "SILVERADO 2500 HD EXT CAB",
+  "SILVERADO 2500 HD HC CREW CAB",
+  "SILVERADO 2500 HD LS CREW CAB",
+  "SILVERADO 2500 HD LS EXT CAB",
+  "SILVERADO 2500 HD LT",
+  "SILVERADO 2500 HD LT CREW CAB",
+  "SILVERADO 2500 HD LT DBL CAB",
+  "SILVERADO 2500 HD LT EXT CAB",
+  "SILVERADO 2500 HD LTZ CREW CAB",
+  "SILVERADO 2500 HD LTZ DBL CAB",
+  "SILVERADO 2500 HD LTZ EXT CAB",
+  "SILVERADO 2500 HD WT",
+  "SILVERADO 2500 HD WT CREW CAB",
+  "SILVERADO 2500 HD WT DBL CAB",
+  "SILVERADO 2500 HD WT EXT CAB",
+  "SILVERADO 3500",
+  "SILVERADO 3500 CREW CAB",
+  "SILVERADO 3500 CREW CAB (AMAL)",
+  "SILVERADO 3500 EXT CAB",
+  "SILVERADO 3500 HC CREW CAB",
+  "SILVERADO 3500 HD (AMALGAMATE)",
+  "SILVERADO 3500 LS",
+  "SILVERADO 3500 LS CREW CAB",
+  "SILVERADO 3500 LS EXT CAB",
+  "SILVERADO 3500 LT CREW CAB",
+  "SILVERADO 3500 LT DOUBLE CAB",
+  "SILVERADO 3500 LT EXT CAB",
+  "SILVERADO 3500 LTZ CREW CAB",
+  "SILVERADO 3500 LTZ EXT CAB",
+  "SILVERADO 3500 WT CREW CAB",
+  "Silverado 3500HD",
+
+  "B250 SPORTSMAN",
+
+  "DAKOTA CLUB CAB",
+  "DAKOTA LARAMIE V8 CLUB CAB",
+  "DAKOTA LARAMIE V8 QUAD CAB",
+  "DAKOTA QUAD CAB",
+  "DAKOTA SLT CREW CAB",
+  "DAKOTA SLT EXT CAB",
+  "DAKOTA SLT PLUS QUAD CAB",
+  "DAKOTA SLT PLUS V8 CLUB CAB",
+  "DAKOTA SLT PLUS V8 QUAD CAB",
+  "DAKOTA SLT QUAD CAB",
+  "DAKOTA SLT V8 CLUB CAB",
+  "DAKOTA SLT V8 CREW CAB",
+  "DAKOTA SLT V8 EXT CAB",
+  "DAKOTA SLT V8 QUAD CAB",
+  "DAKOTA SPORT V8",
+  "DAKOTA SPORT V8 CLUB CAB",
+  "DAKOTA SPORT V8 QUAD CAB",
+  "DAKOTA ST CLUB CAB",
+  "DAKOTA ST QUAD CAB",
+  "DAKOTA ST V8 QUAD CAB",
+  "DAKOTA SXT CREW CAB",
+  "DAKOTA SXT EXT CAB",
+  "DAKOTA SXT V8 CREW CAB",
+  "DAKOTA SXT V8 EXT CAB",
+  "DAKOTA V8 CLUB CAB",
+  "DAKOTA V8 QUAD CAB",
+
+  "RAM 1500",
+  "RAM 1500 BIG HORN CREW CAB",
+  "RAM 1500 BIG HORN QUAD CAB",
+  "RAM 1500 CLUB CAB",
+  "RAM 1500 CREW CAB (AMALGAMATE)",
+  "RAM 1500 EXPRESS",
+  "RAM 1500 LARAMIE CREW (AMALGA)",
+  "RAM 1500 LARAMIE CREW CAB",
+  "RAM 1500 LARAMIE LONGHORN CREW",
+  "RAM 1500 LARAMIE MEGA CAB",
+  "RAM 1500 LARAMIE QUAD CAB",
+  "RAM 1500 LARAMIE SLT QUAD CAB",
+  "RAM 1500 LIMITED CREW CAB",
+  "RAM 1500 LONGHORN CREW CAB",
+  "RAM 1500 OUTDOORSMAN CREW CAB",
+  "RAM 1500 OUTDOORSMAN QC (AMAL)",
+  "RAM 1500 OUTDOORSMAN QUAD CAB",
+  "RAM 1500 QUAD CAB",
+  "RAM 1500 R/T",
+  "RAM 1500 REBEL CREW CAB",
+  "RAM 1500 REBEL QUAD CAB",
+  "RAM 1500 SLT",
+  "RAM 1500 SLT CREW (AMALGAMATE)",
+  "RAM 1500 SLT CREW CAB",
+  "RAM 1500 SLT MEGA CAB",
+  "RAM 1500 SLT QUAD (AMALGAMATE)",
+  "RAM 1500 SLT QUAD CAB",
+  "RAM 1500 SPORT",
+  "RAM 1500 SPORT CLUB CAB",
+  "RAM 1500 SPORT CREW CAB",
+  "RAM 1500 SPORT CREW CAB (AMAL)",
+  "RAM 1500 SPORT QUAD CAB",
+  "RAM 1500 ST",
+  "RAM 1500 ST CREW CAB",
+  "RAM 1500 ST QUAD CAB",
+  "RAM 1500 SXT CREW CAB",
+  "RAM 1500 SXT QUAD CAB",
+  "RAM 1500 TRADESMAN CREW CAB",
+  "RAM 1500 TRADESMAN QUAD CAB",
+  "RAM 1500 TRX QUAD CAB",
+  "RAM 2500",
+  "RAM 2500 BIG HORN CREW CAB",
+  "RAM 2500 BIG HORN MEGA CAB",
+  "RAM 2500 CLUB CAB",
+  "RAM 2500 LARAMIE CREW CAB",
+  "RAM 2500 LARAMIE LONGHORN CREW",
+  "RAM 2500 LARAMIE LONGHORN MEGA",
+  "RAM 2500 LARAMIE MEGA CAB",
+  "RAM 2500 LARAMIE QUAD CAB",
+  "RAM 2500 LARAMIE SLT",
+  "RAM 2500 LARAMIE SLT QUAD CAB",
+  "RAM 2500 LIMITED CREW CAB",
+  "RAM 2500 OUTDOORSMAN CREW CAB",
+  "RAM 2500 POWER WAGON CREW CAB",
+  "RAM 2500 QUAD CAB",
+  "RAM 2500 SLT",
+  "RAM 2500 SLT CREW CAB",
+  "RAM 2500 SLT MEGA CAB",
+  "RAM 2500 SLT QUAD CAB",
+  "RAM 2500 SLT QUAD CAB (AMALGA)",
+  "RAM 2500 SPORT QUAD CAB",
+  "RAM 2500 ST",
+  "RAM 2500 ST CREW CAB",
+  "RAM 2500 ST QUAD CAB",
+  "RAM 2500 SXT QUAD CAB",
+  "RAM 2500 TRADESMAN",
+  "RAM 2500 TRADESMAN CREW CAB",
+  "RAM 2500 TRX CREW CAB",
+  "RAM 2500 TRX QUAD CAB",
+  "RAM 3500",
+  "RAM 3500 4WD",
+  "RAM 3500 BIG HORN CREW CAB",
+  "RAM 3500 CREW CAB",
+  "RAM 3500 CREW CAB (AMALGAMATE)",
+  "RAM 3500 LARAMIE CREW CAB",
+  "RAM 3500 LARAMIE LONGHORN CREW",
+  "RAM 3500 LARAMIE LONGHORN MEGA",
+  "RAM 3500 LARAMIE MEGA CAB",
+  "RAM 3500 LARAMIE QUAD CAB",
+  "RAM 3500 LARAMIE SLT",
+  "RAM 3500 LARAMIE SLT QUAD CAB",
+  "RAM 3500 LIMITED MEGA CAB",
+  "RAM 3500 LONGHORN CREW CAB",
+  "RAM 3500 QUAD CAB",
+  "RAM 3500 SLT",
+  "RAM 3500 SLT CREW CAB",
+  "RAM 3500 SLT MEGA CAB",
+  "RAM 3500 SLT QUAD CAB",
+  "RAM 3500 SPORT QUAD CAB",
+  "RAM 3500 ST",
+  "RAM 3500 ST CREW CAB",
+  "RAM 3500 ST QUAD CAB",
+  "RAM 3500 TRX QUAD CAB",
+  "RAM 4500",
+  "RAM 4500 CREW CAB",
+  "RAM 5500",
+  "RAM 5500 CREW CAB",
+  "W250 TURBO DIESEL",
+
+  "C Series 5500",
+  "C/R 1500 4+CAB",
+  "C/R 1500 PICKUP",
+  "C/R 1500 SIERRA SL EXT CAB",
+  "C/R 3500",
+  "C/R 3500 PICKUP",
+  "CANYON ALL TERRAIN CREW CAB",
+  "CANYON CREW CAB",
+  "CANYON DENALI CREW CAB",
+  "CANYON EXT CAB",
+  "CANYON SL",
+  "CANYON SL EXT CAB",
+  "CANYON SLE",
+  "CANYON SLE CREW CAB",
+  "CANYON SLE EXT CAB",
+  "CANYON SLT CREW CAB",
+  "CANYON SLT CREW CAB (AMALGAMA)",
+  "K/V 1500 4+CAB",
+  "K/V 1500 PICKUP",
+  "K/V 2500 4+CAB",
+  "K/V 2500 PICKUP",
+  "K/V 3500 SIERRA SL CREW CAB",
+  "K/V 3500 SIERRA SLE CREW CAB",
+  "SIERRA 1500 AT4 CREW CAB",
+  "SIERRA 1500 AT4 DOUBLE CAB",
+  "SIERRA 1500 CREW CAB",
+  "SIERRA 1500 CREW CAB (AMALGAM)",
+  "SIERRA 1500 DENALI CREW CAB",
+  "SIERRA 1500 DENALI EXT CAB",
+  "SIERRA 1500 DOUBLE CAB",
+  "SIERRA 1500 ELEVATION CREW CAB",
+  "SIERRA 1500 ELEVATION DC",
+  "SIERRA 1500 EXT CAB",
+  "SIERRA 1500 HD CREW CAB",
+  "SIERRA 1500 HD SLE CREW CAB",
+  "SIERRA 1500 HD SLT CREW CAB",
+  "SIERRA 1500 NEVADA EDITION",
+  "SIERRA 1500 PICKUP",
+  "SIERRA 1500 SL CREW CAB",
+  "SIERRA 1500 SL EXT CAB",
+  "SIERRA 1500 SL PICKUP",
+  "SIERRA 1500 SLE CREW CAB",
+  "SIERRA 1500 SLE DC (AMALGAMAT)",
+  "SIERRA 1500 SLE DOUBLE CAB",
+  "SIERRA 1500 SLE EXT CAB",
+  "SIERRA 1500 SLE EXT CAB (AMAL)",
+  "SIERRA 1500 SLE PICKUP",
+  "SIERRA 1500 SLT CREW (AMALGAM)",
+  "SIERRA 1500 SLT CREW CAB",
+  "SIERRA 1500 SLT DOUBLE CAB",
+  "SIERRA 1500 SLT EXT CAB",
+  "SIERRA 1500 WT CREW CAB",
+  "SIERRA 1500 WT EXT CAB",
+  "SIERRA 1500 WT PICKUP",
+  "SIERRA 2500 EXT CAB",
+  "SIERRA 2500 HD AT4 CREW CAB",
+  "SIERRA 2500 HD CREW CAB",
+  "SIERRA 2500 HD DENALI CREW CAB",
+  "SIERRA 2500 HD DOUBLE CAB",
+  "SIERRA 2500 HD EXT CAB",
+  "SIERRA 2500 HD PICKUP",
+  "SIERRA 2500 HD SL EXT CAB",
+  "SIERRA 2500 HD SL PICKUP",
+  "SIERRA 2500 HD SLE CREW CAB",
+  "SIERRA 2500 HD SLE DOUBLE CAB",
+  "SIERRA 2500 HD SLE EXT CAB",
+  "SIERRA 2500 HD SLE PICKUP",
+  "SIERRA 2500 HD SLT CREW CAB",
+  "SIERRA 2500 HD SLT DOUBLE CAB",
+  "SIERRA 2500 HD SLT EXT CAB",
+  "SIERRA 2500 HD WT CREW CAB",
+  "SIERRA 2500 HD WT DOUBLE CAB",
+  "SIERRA 2500 HD WT EXT CAB",
+  "SIERRA 2500 HD WT PICKUP",
+  "SIERRA 2500 SLE EXT CAB",
+  "SIERRA 3500 AT4 CREW CAB",
+  "SIERRA 3500 CREW CAB",
+  "SIERRA 3500 DENALI CREW CAB",
+  "SIERRA 3500 EXT CAB",
+  "SIERRA 3500 PICKUP",
+  "SIERRA 3500 SL CREW CAB",
+  "SIERRA 3500 SLE",
+  "SIERRA 3500 SLE CREW CAB",
+  "SIERRA 3500 SLE EXT CAB",
+  "SIERRA 3500 SLT CREW CAB",
+  "SIERRA 3500 WT CREW CAB",
+  "SONOMA",
+  "SONOMA CREW CAB",
+  "SONOMA EXT CAB",
+
+  "1500",
+  "1500 Classic",
+  "Pickup 1500",
+  "Pickup 3500",
+  "ProMaster 1500",
+
+  "RIDGELINE",
+  "RIDGELINE BLACK EDITION",
+  "RIDGELINE DX",
+  "RIDGELINE EX-L",
+  "RIDGELINE LX",
+  "RIDGELINE RT",
+  "RIDGELINE RTL",
+  "RIDGELINE RTS",
+  "RIDGELINE RTX",
+  "RIDGELINE SE",
+  "RIDGELINE SPORT",
+  "RIDGELINE TOURING",
+  "RIDGELINE VP",
+
+  "TITAN",
+  "TACOMA",
+  "TUNDRA",
+  "AVALANCE",
+  "COLORADO",
+  "SILVERADO",
+  "SILVERADO 1500",
+  "SILVERADO 2500",
+  "SILVERADO 3500",
+  "DAKOTA",
+  "RAM 1500",
+  "RAM 2500",
+  "RAM 3500",
+  "RAM 4500",
+  "RAM 5500",
+  "CANYON",
+  "SIERRA 1500",
+  "SIERRA 2500",
+  "SIERRA 3500",
+  "SONOMA",
+  "1500"
+]

server/data/vehicletype/vehicletype.js

@@ -0,0 +1,39 @@
+const logger = require("../../utils/logger");
+const TrucksList = require("./trucks.json");
+const CargoVanList = require("./cargovans.json");
+const PassengerVanList = require("./passengervans.json");
+const SuvList = require("./suvs.json");
+
+
+const vehicletype = async (req, res) => {
+    try {
+        const { model } = req.body;
+        if (!model || model.trim() === "") {
+            res.status(400).json({ success: false, error: "Please provide a model" });
+        } else {
+
+            const type = getVehicleType(model.trim())
+            res.status(200).json({ success: true, ...type });
+        }
+    } catch (error) {
+        logger.log("vehicletype-error", "ERROR", req?.user?.email, null, {
+            error: error.message,
+            stack: error.stack
+        });
+        res.status(500).json({ error: error.message, stack: error.stack });
+    }
+};
+
+function getVehicleType(model) {
+    const inTrucks = TrucksList.includes(model.toUpperCase());
+    const inPV = PassengerVanList.includes(model.toUpperCase());
+    const inSuv = SuvList.includes(model.toUpperCase());
+    const inCv = CargoVanList.includes(model.toUpperCase());
+
+    if (inTrucks) return { type: "TK", match: true };
+    else if (inPV) return { type: "PC", match: true };
+    else if (inSuv) return { type: "SUV", match: true };
+    else if (inCv) return { type: "VN", match: true };
+    else return { type: "PC", match: false };
+}
+exports.default = vehicletype;

server/graphql-client/queries.js

@@ -1854,7 +1854,7 @@ exports.GET_CHATTER_SHOPS = `query GET_CHATTER_SHOPS {
 }`;
 
 exports.GET_CARFAX_SHOPS = `query GET_CARFAX_SHOPS {
-  bodyshops{
+  bodyshops(where: {external_shop_id: {_is_null: true}}){
       id
       shopname
       imexshopid

server/integrations/partsManagement/defaultNewShop.json

@@ -35,6 +35,11 @@
     "headerMargin": "135"
   },
   "md_ro_statuses": {
+    "parts_statuses": [
+      "Open",
+      "In Progress",
+      "Completed"
+    ],
     "statuses": [
       "Open",
       "Scheduled",
@@ -54,6 +59,10 @@
       "Void"
     ],
     "default_void": "Void",
+    "parts_active_statuses": [
+      "Open",
+      "In Progress"
+    ],
     "active_statuses": [
       "Open",
       "Scheduled",
@@ -766,6 +775,7 @@
     "csi:page": 11,
     "jobs:void": 80,
     "shop:rbac": 99,
+    "shop:responsibilitycenter": 99,
     "bills:list": 11,
     "bills:view": 11,
     "csi:export": 11,

server/integrations/partsManagement/endpoints/lib/extractPartsTaxRates.js

@@ -23,10 +23,16 @@ const KNOWN_PART_RATE_TYPES = [
  * @returns {object} The parts tax rates object.
  */
 
+//TODO: Major validation would be required on this - EMS files are inconsistent with things like 5% being passed as 5.0 or .05.
 const extractPartsTaxRates = (profile = {}) => {
   const rateInfos = Array.isArray(profile.RateInfo) ? profile.RateInfo : [profile.RateInfo || {}];
   const partsTaxRates = {};
 
+  /**
+   * In this context, r.RateType._ accesses the property named _ on the RateType object.
+   * This pattern is common when handling data parsed from XML, where element values are stored under the _ key. So,
+   * _ aligns to the actual value/content of the RateType field when RateType is an object (not a string).
+   */
   for (const r of rateInfos) {
     const rateTypeRaw =
       typeof r?.RateType === "string"

server/integrations/partsManagement/endpoints/lib/opCodes.json

@@ -0,0 +1,197 @@
+{
+  "OP0": {
+    "desc": "REMOVE / REPLACE PARTIAL",
+    "opcode": "OP11",
+    "partcode": "PAA"
+  },
+  "OP1": {
+    "desc": "REFINISH / REPAIR",
+    "opcode": "OP1",
+    "partcode": "PAE"
+  },
+  "OP2": {
+    "desc": "REMOVE / INSTALL",
+    "opcode": "OP2",
+    "partcode": "PAE"
+  },
+  "OP3": {
+    "desc": "ADDITIONAL LABOR",
+    "opcode": "OP9",
+    "partcode": "PAE"
+  },
+  "OP4": {
+    "desc": "ALIGNMENT",
+    "opcode": "OP4",
+    "partcode": "PAS"
+  },
+  "OP5": {
+    "desc": "OVERHAUL",
+    "opcode": "OP5",
+    "partcode": "PAE"
+  },
+  "OP6": {
+    "desc": "REFINISH",
+    "opcode": "OP6",
+    "partcode": "PAE"
+  },
+  "OP7": {
+    "desc": "INSPECT",
+    "opcode": "OP7",
+    "partcode": "PAE"
+  },
+  "OP8": {
+    "desc": "CHECK / ADJUST",
+    "opcode": "OP8",
+    "partcode": "PAE"
+  },
+  "OP9": {
+    "desc": "REPAIR",
+    "opcode": "OP9",
+    "partcode": "PAE"
+  },
+  "OP10": {
+    "desc": "REPAIR , PARTIAL",
+    "opcode": "OP9",
+    "partcode": "PAE"
+  },
+  "OP11": {
+    "desc": "REMOVE / REPLACE",
+    "opcode": "OP11",
+    "partcode": "PAN"
+  },
+  "OP12": {
+    "desc": "REMOVE / REPLACE PARTIAL",
+    "opcode": "OP11",
+    "partcode": "PAN"
+  },
+  "OP13": {
+    "desc": "ADDITIONAL COSTS",
+    "opcode": "OP13",
+    "partcode": "PAE"
+  },
+  "OP14": {
+    "desc": "ADDITIONAL OPERATIONS",
+    "opcode": "OP14",
+    "partcode": "PAE"
+  },
+  "OP15": {
+    "desc": "BLEND",
+    "opcode": "OP15",
+    "partcode": "PAE"
+  },
+  "OP16": {
+    "desc": "SUBLET",
+    "opcode": "OP16",
+    "partcode": "PAS"
+  },
+  "OP17": {
+    "desc": "POLICY LIMIT ADJUSTMENT",
+    "opcode": "OP9",
+    "partcode": "PAE"
+  },
+  "OP18": {
+    "desc": "APPEAR ALLOWANCE",
+    "opcode": "OP7",
+    "partcode": "PAE"
+  },
+  "OP20": {
+    "desc": "REMOVE AND REINSTALL",
+    "opcode": "OP20",
+    "partcode": "PAE"
+  },
+  "OP24": {
+    "desc": "CHIPGUARD",
+    "opcode": "OP6",
+    "partcode": "PAE"
+  },
+  "OP25": {
+    "desc": "TWO TONE",
+    "opcode": "OP6",
+    "partcode": "PAE"
+  },
+  "OP26": {
+    "desc": "PAINTLESS DENT REPAIR",
+    "opcode": "OP16",
+    "partcode": "PAE"
+  },
+  "OP100": {
+    "desc": "REPLACE PRE-PRICED",
+    "opcode": "OP11",
+    "partcode": "PAA"
+  },
+  "OP101": {
+    "desc": "REMOVE/REPLACE RECYCLED PART",
+    "opcode": "OP11",
+    "partcode": "PAL"
+  },
+  "OP103": {
+    "desc": "REMOVE / REPLACE PARTIAL",
+    "opcode": "OP11",
+    "partcode": "PAA"
+  },
+  "OP104": {
+    "desc": "REMOVE / REPLACE PARTIAL LABOUR",
+    "opcode": "OP11",
+    "partcode": "PAA"
+  },
+  "OP105": {
+    "desc": "!!ADJUST MANUALLY!!",
+    "opcode": "OP99",
+    "partcode": "PAE"
+  },
+  "OP106": {
+    "desc": "REPAIR , PARTIAL",
+    "opcode": "OP9",
+    "partcode": "PAE"
+  },
+  "OP107": {
+    "desc": "CHIPGUARD",
+    "opcode": "OP6",
+    "partcode": "PAE"
+  },
+  "OP108": {
+    "desc": "MULTI TONE",
+    "opcode": "OP6",
+    "partcode": "PAE"
+  },
+  "OP109": {
+    "desc": "REPLACE PRE-PRICED",
+    "opcode": "OP11",
+    "partcode": "PAA"
+  },
+  "OP110": {
+    "desc": "REFINISH / REPAIR",
+    "opcode": "OP1",
+    "partcode": "PAE"
+  },
+  "OP111": {
+    "desc": "REMOVE / REPLACE",
+    "opcode": "OP11",
+    "partcode": "PAN"
+  },
+  "OP112": {
+    "desc": "REMOVE / REPLACE",
+    "opcode": "OP11",
+    "partcode": "PAA"
+  },
+  "OP113": {
+    "desc": "REPLACE PRE-PRICED",
+    "opcode": "OP11",
+    "partcode": "PAA"
+  },
+  "OP114": {
+    "desc": "REPLACE PRE-PRICED",
+    "opcode": "OP11",
+    "partcode": "PAA"
+  },
+  "OP120": {
+    "desc": "REPAIR , PARTIAL",
+    "opcode": "OP9",
+    "partcode": "PAE"
+  },
+  "OP260": {
+    "desc": "SUBLET",
+    "opcode": "OP16",
+    "partcode": "PAE"
+  }
+}

server/integrations/partsManagement/endpoints/partsManagementDeprovisioning.js

@@ -83,78 +83,80 @@ const deleteJobsByIds = async (jobIds) => {
  */
 const partsManagementDeprovisioning = async (req, res) => {
   const { logger } = req;
-  const p = req.body;
+  const body = req.body;
 
   if (process.env.NODE_ENV === "production") {
     return res.status(403).json({ error: "Deprovisioning not allowed in production environment." });
   }
 
   try {
-    if (!p.shopId) {
+    if (!body.shopId) {
       throw { status: 400, message: "shopId is required." };
     }
 
     // Fetch bodyshop and check external_shop_id
-    const shopResp = await client.request(GET_BODYSHOP, { id: p.shopId });
+    const shopResp = await client.request(GET_BODYSHOP, { id: body.shopId });
     const shop = shopResp.bodyshops_by_pk;
     if (!shop) {
-      throw { status: 404, message: `Bodyshop with id ${p.shopId} not found.` };
+      throw { status: 404, message: `Bodyshop with id ${body.shopId} not found.` };
     }
     if (!shop.external_shop_id) {
       throw { status: 400, message: "Cannot delete bodyshop without external_shop_id." };
     }
 
     logger.log("admin-delete-shop", "debug", null, null, {
-      shopId: p.shopId,
+      shopId: body.shopId,
       shopname: shop.shopname,
       ioadmin: true
     });
 
     // Get vendors
-    const vendorsResp = await client.request(GET_VENDORS, { shopId: p.shopId });
+    const vendorsResp = await client.request(GET_VENDORS, { shopId: body.shopId });
     const deletedVendors = vendorsResp.vendors.map((v) => v.name);
 
     // Get associated users
-    const assocResp = await client.request(GET_ASSOCIATED_USERS, { shopId: p.shopId });
+    const assocResp = await client.request(GET_ASSOCIATED_USERS, { shopId: body.shopId });
     const associatedUsers = assocResp.associations.map((assoc) => ({
       authId: assoc.user.authid,
       email: assoc.user.email
     }));
 
     // Delete associations for the shop
-    const assocDeleteResp = await client.request(DELETE_ASSOCIATIONS_BY_SHOP, { shopId: p.shopId });
+    const assocDeleteResp = await client.request(DELETE_ASSOCIATIONS_BY_SHOP, { shopId: body.shopId });
     const associationsDeleted = assocDeleteResp.delete_associations.affected_rows;
 
     // For each user, check if they have remaining associations; if not, delete user and Firebase account
     const deletedUsers = [];
     for (const user of associatedUsers) {
       const countResp = await client.request(GET_USER_ASSOCIATIONS_COUNT, { userEmail: user.email });
-      const assocCount = countResp.associations_aggregate.aggregate.count;
-      if (assocCount === 0) {
-        await client.request(DELETE_USER, { email: user.email });
-        await deleteFirebaseUser(user.authId);
-        deletedUsers.push(user.email);
-      }
+      // Determine which users now have zero associations and should be deleted (defer deletion until end)
+      const emailsToAuthId = associatedUsers.reduce((acc, u) => {
+        acc[u.email] = u.authId;
+        return acc;
+      }, {});
+      const emailsToDelete = [];
+      await client.request(DELETE_USER, { email: user.email });
+      await deleteFirebaseUser(user.authId);
+      deletedUsers.push(user.email);
     }
-
-    // Get all job ids for this shop, then delete joblines and jobs (joblines first)
-    const jobIds = await getJobIdsForShop(p.shopId);
+    emailsToDelete.push(user.email);
+    const jobIds = await getJobIdsForShop(body.shopId);
     const joblinesDeleted = await deleteJoblinesForJobs(jobIds);
     const jobsDeleted = await deleteJobsByIds(jobIds);
 
     // Delete any audit trail entries tied to this bodyshop to avoid FK violations
-    const auditResp = await client.request(DELETE_AUDIT_TRAIL_BY_SHOP, { shopId: p.shopId });
+    const auditResp = await client.request(DELETE_AUDIT_TRAIL_BY_SHOP, { shopId: body.shopId });
     const auditDeleted = auditResp.delete_audit_trail.affected_rows;
 
     // Delete vendors
-    await deleteVendorsByShop(p.shopId);
+    await deleteVendorsByShop(body.shopId);
 
     // Delete shop
-    await deleteBodyshop(p.shopId);
+    await deleteBodyshop(body.shopId);
 
     // Summary log
     logger.log("admin-delete-shop-summary", "info", null, null, {
-      shopId: p.shopId,
+      shopId: body.shopId,
       shopname: shop.shopname,
       associationsDeleted,
       deletedUsers,
@@ -165,8 +167,8 @@ const partsManagementDeprovisioning = async (req, res) => {
     });
 
     return res.status(200).json({
-      message: `Bodyshop ${p.shopId} and associated resources deleted successfully.`,
-      deletedShop: { id: p.shopId, name: shop.shopname },
+      message: `Bodyshop ${body.shopId} and associated resources deleted successfully.`,
+      deletedShop: { id: body.shopId, name: shop.shopname },
       deletedAssociationsCount: associationsDeleted,
       deletedUsers: deletedUsers,
       deletedVendors: deletedVendors,
@@ -174,6 +176,16 @@ const partsManagementDeprovisioning = async (req, res) => {
       deletedJobsCount: jobsDeleted,
       deletedAuditTrailCount: auditDeleted
     });
+    // Now delete users that have no remaining associations and their Firebase accounts
+    const deletedUsers = [];
+    for (const email of emailsToDelete) {
+      await client.request(DELETE_USER, { email });
+      const authId = emailsToAuthId[email];
+      if (authId) {
+        await deleteFirebaseUser(authId);
+      }
+      deletedUsers.push(email);
+    }
   } catch (err) {
     logger.log("admin-delete-shop-error", "error", null, null, {
       message: err.message,

server/integrations/partsManagement/endpoints/partsManagementProvisioning.js

@@ -123,7 +123,7 @@ const insertUserAssociation = async (uid, email, shopId) => {
       authid: uid,
       validemail: true,
       associations: {
-        data: [{ shopid: shopId, authlevel: 80, active: true }]
+        data: [{ shopid: shopId, authlevel: 99, active: true }]
       }
     }
   };
@@ -139,11 +139,11 @@ const insertUserAssociation = async (uid, email, shopId) => {
  */
 const partsManagementProvisioning = async (req, res) => {
   const { logger } = req;
-  const p = { ...req.body, userEmail: req.body.userEmail?.toLowerCase() };
+  const body = { ...req.body, userEmail: req.body.userEmail?.toLowerCase() };
 
   try {
-    await ensureEmailNotRegistered(p.userEmail);
-    requireFields(p, [
+    await ensureEmailNotRegistered(body.userEmail);
+    requireFields(body, [
       "external_shop_id",
       "shopname",
       "address1",
@@ -155,33 +155,33 @@ const partsManagementProvisioning = async (req, res) => {
       "phone",
       "userEmail"
     ]);
-    await ensureExternalIdUnique(p.external_shop_id);
+    await ensureExternalIdUnique(body.external_shop_id);
 
-    logger.log("admin-create-shop-user", "debug", p.userEmail, null, {
+    logger.log("admin-create-shop-user", "debug", body.userEmail, null, {
       request: req.body,
       ioadmin: true
     });
 
     const shopInput = {
-      shopname: p.shopname,
-      address1: p.address1,
-      address2: p.address2 || null,
-      city: p.city,
-      state: p.state,
-      zip_post: p.zip_post,
-      country: p.country,
-      email: p.email,
-      external_shop_id: p.external_shop_id,
-      timezone: p.timezone || DefaultNewShop.timezone,
-      phone: p.phone,
+      shopname: body.shopname,
+      address1: body.address1,
+      address2: body.address2 || null,
+      city: body.city,
+      state: body.state,
+      zip_post: body.zip_post,
+      country: body.country,
+      email: body.email,
+      external_shop_id: body.external_shop_id,
+      timezone: body.timezone || DefaultNewShop.timezone,
+      phone: body.phone,
       logo_img_path: {
-        src: p.logoUrl,
+        src: body.logoUrl,
         width: "",
         height: "",
         headerMargin: DefaultNewShop.logo_img_path.headerMargin
       },
       features: {
-        allAccess: true, // TODO: should be false?
+        allAccess: false,
         partsManagementOnly: true
       },
       md_ro_statuses: DefaultNewShop.md_ro_statuses,
@@ -191,16 +191,16 @@ const partsManagementProvisioning = async (req, res) => {
       md_messaging_presets: DefaultNewShop.md_messaging_presets,
       md_rbac: DefaultNewShop.md_rbac,
       md_classes: DefaultNewShop.md_classes,
-      md_ins_cos: DefaultNewShop.md_ins_cos, // TODO need?
-      md_categories: DefaultNewShop.md_categories, // TODO need?
-      md_labor_rates: DefaultNewShop.md_labor_rates, // TODO need?
-      md_payment_types: DefaultNewShop.md_payment_types, // TODO need?
-      md_hour_split: DefaultNewShop.md_hour_split, // TODO need?
-      md_ccc_rates: DefaultNewShop.md_ccc_rates, // TODO need?
-      appt_alt_transport: DefaultNewShop.appt_alt_transport, // TODO need?
-      md_jobline_presets: DefaultNewShop.md_jobline_presets, // TODO need?
+      md_ins_cos: DefaultNewShop.md_ins_cos,
+      md_categories: DefaultNewShop.md_categories,
+      md_labor_rates: DefaultNewShop.md_labor_rates,
+      md_payment_types: DefaultNewShop.md_payment_types,
+      md_hour_split: DefaultNewShop.md_hour_split,
+      md_ccc_rates: DefaultNewShop.md_ccc_rates,
+      appt_alt_transport: DefaultNewShop.appt_alt_transport,
+      md_jobline_presets: DefaultNewShop.md_jobline_presets,
       vendors: {
-        data: p.vendors.map((v) => ({
+        data: body.vendors.map((v) => ({
           name: v.name,
           street1: v.street1 || null,
           street2: v.street2 || null,
@@ -221,14 +221,14 @@ const partsManagementProvisioning = async (req, res) => {
     };
 
     const newShopId = await insertBodyshop(shopInput);
-    const userRecord = await createFirebaseUser(p.userEmail, p.userPassword);
+    const userRecord = await createFirebaseUser(body.userEmail, body.userPassword);
     let resetLink = null;
-    if (!p.userPassword) resetLink = await generateResetLink(p.userEmail);
+    if (!body.userPassword) resetLink = await generateResetLink(body.userEmail);
 
-    const createdUser = await insertUserAssociation(userRecord.uid, p.userEmail, newShopId);
+    const createdUser = await insertUserAssociation(userRecord.uid, body.userEmail, newShopId);
 
     return res.status(200).json({
-      shop: { id: newShopId, shopname: p.shopname },
+      shop: { id: newShopId, shopname: body.shopname },
       user: {
         id: createdUser.id,
         email: createdUser.email,
@@ -236,7 +236,7 @@ const partsManagementProvisioning = async (req, res) => {
       }
     });
   } catch (err) {
-    logger.log("admin-create-shop-user-error", "error", p.userEmail, null, {
+    logger.log("admin-create-shop-user-error", "error", body.userEmail, null, {
       message: err.message,
       detail: err.detail || err
     });

server/integrations/partsManagement/endpoints/vehicleDamageEstimateAddRq.js

@@ -14,7 +14,7 @@ const {
 } = require("../partsManagement.queries");
 
 // Defaults
-const FALLBACK_DEFAULT_ORDER_STATUS = "OPEN";
+const FALLBACK_DEFAULT_JOB_STATUS = "Open";
 
 /**
  * Fetches the default order status for a bodyshop.
@@ -22,13 +22,13 @@ const FALLBACK_DEFAULT_ORDER_STATUS = "OPEN";
  * @param {object} logger - The logger instance.
  * @returns {Promise<string>} The default status or fallback.
  */
-const getDefaultOrderStatus = async (shopId, logger) => {
+const getDefaultJobStatus = async (shopId, logger) => {
   try {
     const { bodyshop_by_pk } = await client.request(GET_BODYSHOP_STATUS, { id: shopId });
-    return bodyshop_by_pk?.md_order_statuses?.default_open || FALLBACK_DEFAULT_ORDER_STATUS;
+    return bodyshop_by_pk?.md_ro_statuses?.default_imported || FALLBACK_DEFAULT_JOB_STATUS;
   } catch (err) {
     logger.log("parts-bodyshop-fetch-failed", "warn", shopId, null, { error: err });
-    return FALLBACK_DEFAULT_ORDER_STATUS;
+    return FALLBACK_DEFAULT_JOB_STATUS;
   }
 };
 /**
@@ -66,6 +66,7 @@ const extractJobData = (rq) => {
 
   return {
     shopId: rq.ShopID || rq.shopId,
+    //     status: ci.ClaimStatus || null, Proper, setting it default for now
     refClaimNum: rq.RefClaimNum,
     ciecaid: rq.RqUID || null,
     // Pull Cieca_ttl from ClaimInfo per schema/sample
@@ -81,7 +82,6 @@ const extractJobData = (rq) => {
     scheduled_in: ev.RepairEvent?.RequestedPickUpDateTime || null,
     scheduled_completion: ev.RepairEvent?.TargetCompletionDateTime || null,
     clm_no: ci.ClaimNum || null,
-    status: ci.ClaimStatus || null,
     policy_no: ci.PolicyInfo?.PolicyInfo?.PolicyNum || ci.PolicyInfo?.PolicyNum || null,
     ded_amt: parseFloat(ci.PolicyInfo?.CoverageInfo?.Coverage?.DeductibleInfo?.DeductibleAmt || 0)
   };
@@ -100,17 +100,19 @@ const extractOwnerData = (rq, shopId) => {
   const personName = personInfo.PersonName || {};
   const address = personInfo.Communications?.Address || {};
 
-  let ownr_ph1, ownr_ph2, ownr_ea, ownr_alt_ph;
+  let ownr_ph1, ownr_ph2, ownr_ea;
 
   const comms = Array.isArray(ownerOrClaimant.ContactInfo?.Communications)
     ? ownerOrClaimant.ContactInfo.Communications
     : [ownerOrClaimant.ContactInfo?.Communications || {}];
 
   for (const c of comms) {
+    // TODO: Should document this logic. 1 and 2 don't
+    //  typically indicate type in EMS. This makes sense, but good to document.
     if (c.CommQualifier === "CP") ownr_ph1 = c.CommPhone;
     if (c.CommQualifier === "WP") ownr_ph2 = c.CommPhone;
     if (c.CommQualifier === "EM") ownr_ea = c.CommEmail;
-    if (c.CommQualifier === "AL") ownr_alt_ph = c.CommPhone;
+    // if (c.CommQualifier === "AL") ownr_alt_ph = c.CommPhone;
   }
 
   return {
@@ -126,8 +128,8 @@ const extractOwnerData = (rq, shopId) => {
     ownr_ctry: address.Country || null,
     ownr_ph1,
     ownr_ph2,
-    ownr_ea,
-    ownr_alt_ph
+    ownr_ea
+    // ownr_alt_ph
     // ownr_id_qualifier: ownerOrClaimant.IDInfo?.IDQualifierCode || null // New
     // ownr_id_num: ownerOrClaimant.IDInfo?.IDNum || null, // New
     // ownr_preferred_contact: ownerOrClaimant.PreferredContactMethod || null // New
@@ -158,37 +160,40 @@ const extractEstimatorData = (rq) => {
  * @param {object} rq - The VehicleDamageEstimateAddRq object.
  * @returns {object} Adjuster data.
  */
-const extractAdjusterData = (rq) => {
-  const adjParty = rq.AdminInfo?.Adjuster?.Party || {};
-  const adjComms = Array.isArray(adjParty.ContactInfo?.Communications)
-    ? adjParty.ContactInfo.Communications
-    : [adjParty.ContactInfo?.Communications || {}];
-
-  return {
-    agt_ct_fn: adjParty.PersonInfo?.PersonName?.FirstName || null,
-    agt_ct_ln: adjParty.PersonInfo?.PersonName?.LastName || null,
-    agt_ct_ph: adjComms.find((c) => c.CommQualifier === "CP")?.CommPhone || null,
-    agt_ea: adjComms.find((c) => c.CommQualifier === "EM")?.CommEmail || null
-  };
-};
+// const extractAdjusterData = (rq) => {
+//   const adjParty = rq.AdminInfo?.Adjuster?.Party || {};
+//   const adjComms = Array.isArray(adjParty.ContactInfo?.Communications)
+//     ? adjParty.ContactInfo.Communications
+//     : [adjParty.ContactInfo?.Communications || {}];
+//
+//   return {
+//     //TODO: I dont think we display agt_ct_* fields in app. Have they typically been sending data here?
+//     agt_ct_fn: adjParty.PersonInfo?.PersonName?.FirstName || null,
+//     agt_ct_ln: adjParty.PersonInfo?.PersonName?.LastName || null,
+//     agt_ct_ph: adjComms.find((c) => c.CommQualifier === "CP")?.CommPhone || null,
+//     agt_ea: adjComms.find((c) => c.CommQualifier === "EM")?.CommEmail || null
+//   };
+// };
 
 /**
  * Extracts repair facility data from the XML request.
  * @param {object} rq - The VehicleDamageEstimateAddRq object.
  * @returns {object} Repair facility data.
  */
-const extractRepairFacilityData = (rq) => {
-  const rfParty = rq.AdminInfo?.RepairFacility?.Party || {};
-  const rfComms = Array.isArray(rfParty.ContactInfo?.Communications)
-    ? rfParty.ContactInfo.Communications
-    : [rfParty.ContactInfo?.Communications || {}];
-
-  return {
-    servicing_dealer: rfParty.OrgInfo?.CompanyName || null,
-    servicing_dealer_contact:
-      rfComms.find((c) => c.CommQualifier === "WP" || c.CommQualifier === "FX")?.CommPhone || null
-  };
-};
+// const extractRepairFacilityData = (rq) => {
+//   const rfParty = rq.AdminInfo?.RepairFacility?.Party || {};
+//   const rfComms = Array.isArray(rfParty.ContactInfo?.Communications)
+//     ? rfParty.ContactInfo.Communications
+//     : [rfParty.ContactInfo?.Communications || {}];
+//
+//   return {
+//     servicing_dealer: rfParty.OrgInfo?.CompanyName || null,
+//     // TODO:  The servicing dealer fields are a relic from synergy for a few folks
+//     // TODO:  I suspect RF data could be ignored since they are the RF.
+//     servicing_dealer_contact:
+//       rfComms.find((c) => c.CommQualifier === "WP" || c.CommQualifier === "FX")?.CommPhone || null
+//   };
+// };
 
 /**
  * Extracts loss information from the XML request.
@@ -202,10 +207,12 @@ const extractLossInfo = (rq) => {
     loss_date: loss.LossDateTime || null,
     loss_type: custom.LossTypeCode || null,
     loss_desc: custom.LossTypeDesc || null
-    // primary_poi: loss.PrimaryPOI?.POICode || null,
-    // secondary_poi: loss.SecondaryPOI?.POICode || null,
+    // area_of_impact: {
+    //   impact_1: loss.PrimaryPOI?.POICode || null,
+    //   imact_2 :loss.SecondaryPOI?.POICode || null,
+    // },
+    // tlosind:  rq.ClaimInfo?.LossInfo?.TotalLossInd || null,
     // damage_memo: loss.DamageMemo || null, //(maybe ins_memo)
-    // total_loss_ind: rq.ClaimInfo?.LossInfo?.TotalLossInd || null // New
   };
 };
 
@@ -287,8 +294,10 @@ const extractVehicleData = (rq, shopId) => {
     v_color: exterior.Color?.ColorName || null,
     v_bstyle: desc.BodyStyle || null,
     v_engine: desc.EngineDesc || null,
+    // TODO Need to confirm with exact data, but this is typically a list of options. Not used AFAIK.
     v_options: desc.SubModelDesc || null,
     v_type: desc.FuelType || null,
+    // TODO  there is a separate driveable flag on the job.
     v_cond: rq.VehicleInfo?.Condition?.DrivableInd,
     v_trimcode: desc.TrimCode || null,
     v_tone: exterior.Tone || null,
@@ -341,6 +350,7 @@ const extractJobLines = (rq) => {
         line.ManualLineInd === true ||
         line.ManualLineInd === 1 ||
         line.ManualLineInd === "1" ||
+        // TODO: manual line tracks manual in IO or not, this woudl presumably always be false
         (typeof line.ManualLineInd === "string" && line.ManualLineInd.toUpperCase() === "Y");
     } else {
       lineOut.manual_line = null;
@@ -354,7 +364,9 @@ const extractJobLines = (rq) => {
       const price = parseFloat(partInfo.PartPrice || partInfo.ListPrice || 0);
       lineOut.part_type = partInfo.PartType || null ? String(partInfo.PartType).toUpperCase() : null;
       lineOut.part_qty = parseFloat(partInfo.Quantity || 0) || 1;
+      //TODO: if aftermarket part, we have alt_part_no to capture.
       lineOut.oem_partno = partInfo.OEMPartNum || partInfo.PartNum || null;
+      //TODO: the Db and act price often are different. These should map back to their EMS equivalents.
       lineOut.db_price = isNaN(price) ? 0 : price;
       lineOut.act_price = isNaN(price) ? 0 : price;
 
@@ -371,7 +383,10 @@ const extractJobLines = (rq) => {
           partInfo.TaxableInd === "1" ||
           (typeof partInfo.TaxableInd === "string" && partInfo.TaxableInd.toUpperCase() === "Y");
       }
-    } else if (hasSublet) {
+    }
+    //TODO: Some nuance here. Usually a part and sublet amount shouldnt be on the same line, but they theoretically
+    // could.May require additional discussion.
+    else if (hasSublet) {
       const amt = parseFloat(subletInfo.SubletAmount || 0);
       lineOut.part_type = "PAS"; // Sublet as parts-as-service
       lineOut.part_qty = 1;
@@ -388,10 +403,14 @@ const extractJobLines = (rq) => {
     if (hasLabor) {
       lineOut.mod_lbr_ty = laborInfo.LaborType || null;
       lineOut.mod_lb_hrs = isNaN(hrs) ? 0 : hrs;
+      //TODO: can add lbr_op_desc according to mapping available in new partner.
       lineOut.lbr_op = laborInfo.LaborOperation || null;
       lineOut.lbr_amt = isNaN(amt) ? 0 : amt;
     }
 
+    //TODO:  what's the BMS logic for this? Body and refinish operations can often happen to the same part,
+    // but most systems output a second line for the refinish labor.
+    //TODO: 2nd line may include a duplicate of the part price, but that can be removed. This is the case for CCC.
     // Refinish labor (if present) recorded on the same line using secondary labor fields
     const rHrs = parseFloat(refinishInfo.LaborHours || 0);
     const rAmt = parseFloat(refinishInfo.LaborAmt || 0);
@@ -402,9 +421,9 @@ const extractJobLines = (rq) => {
         !isNaN(rAmt) ||
         !!refinishInfo.LaborOperation);
     if (hasRefinish) {
-      lineOut.lbr_typ_j = refinishInfo.LaborType || "LAR";
-      lineOut.lbr_hrs_j = isNaN(rHrs) ? 0 : rHrs;
-      lineOut.lbr_op_j = refinishInfo.LaborOperation || null;
+      lineOut.lbr_typ_j = refinishInfo.LaborType || "LAR"; //TODO: _j fields indicate judgement, and are bool type.
+      lineOut.lbr_hrs_j = isNaN(rHrs) ? 0 : rHrs; //TODO: _j fields indicate judgement, and are bool type.
+      lineOut.lbr_op_j = refinishInfo.LaborOperation || null; //TODO: _j fields indicate judgement, and are bool type.
       // Aggregate refinish labor amount into the total labor amount for the line
       if (!isNaN(rAmt)) {
         lineOut.lbr_amt = (Number.isFinite(lineOut.lbr_amt) ? lineOut.lbr_amt : 0) + rAmt;
@@ -420,26 +439,26 @@ const extractJobLines = (rq) => {
 };
 
 // Helper to extract a GRAND TOTAL amount from RepairTotalsInfo
-const extractGrandTotal = (rq) => {
-  const rti = rq.RepairTotalsInfo;
-  const groups = Array.isArray(rti) ? rti : rti ? [rti] : [];
-  for (const grp of groups) {
-    const sums = Array.isArray(grp.SummaryTotalsInfo)
-      ? grp.SummaryTotalsInfo
-      : grp.SummaryTotalsInfo
-        ? [grp.SummaryTotalsInfo]
-        : [];
-    for (const s of sums) {
-      const type = (s.TotalType || "").toString().toUpperCase();
-      const desc = (s.TotalTypeDesc || "").toString().toUpperCase();
-      if (type.includes("GRAND") || type === "TOTAL" || desc.includes("GRAND")) {
-        const amt = parseFloat(s.TotalAmt ?? "NaN");
-        if (!isNaN(amt)) return amt;
-      }
-    }
-  }
-  return null;
-};
+// const extractGrandTotal = (rq) => {
+//   const rti = rq.RepairTotalsInfo;
+//   const groups = Array.isArray(rti) ? rti : rti ? [rti] : [];
+//   for (const grp of groups) {
+//     const sums = Array.isArray(grp.SummaryTotalsInfo)
+//       ? grp.SummaryTotalsInfo
+//       : grp.SummaryTotalsInfo
+//         ? [grp.SummaryTotalsInfo]
+//         : [];
+//     for (const s of sums) {
+//       const type = (s.TotalType || "").toString().toUpperCase();
+//       const desc = (s.TotalTypeDesc || "").toString().toUpperCase();
+//       if (type.includes("GRAND") || type === "TOTAL" || desc.includes("GRAND")) {
+//         const amt = parseFloat(s.TotalAmt ?? "NaN");
+//         if (!isNaN(amt)) return amt;
+//       }
+//     }
+//   }
+//   return null;
+// };
 
 /**
  * Inserts an owner and returns the owner ID.
@@ -458,24 +477,26 @@ const insertOwner = async (ownerInput, logger) => {
 };
 
 // Fallback: compute a naive total from joblines (parts + sublet + labor amounts)
-const computeLinesTotal = (joblines = []) => {
-  let parts = 0;
-  let labor = 0;
-  for (const jl of joblines) {
-    if (jl?.part_type) {
-      const qty = Number.isFinite(jl.part_qty) ? jl.part_qty : 1;
-      const price = Number.isFinite(jl.act_price) ? jl.act_price : 0;
-      parts += price * (qty || 1);
-    } else if (!jl.part_type && Number.isFinite(jl.act_price)) {
-      parts += jl.act_price;
-    }
-    if (Number.isFinite(jl.lbr_amt)) {
-      labor += jl.lbr_amt;
-    }
-  }
-  const total = parts + labor;
-  return Number.isFinite(total) && total > 0 ? total : 0;
-};
+// const computeLinesTotal = (joblines = []) => {
+//   let parts = 0;
+//   let labor = 0;
+//   for (const jl of joblines) {
+//     if (jl?.part_type) {
+//       const qty = Number.isFinite(jl.part_qty) ? jl.part_qty : 1;
+//       const price = Number.isFinite(jl.act_price) ? jl.act_price : 0;
+//       parts += price * (qty || 1);
+//     } else if (!jl.part_type && Number.isFinite(jl.act_price)) {
+//       parts += jl.act_price;
+//     }
+//     if (Number.isFinite(jl.lbr_amt)) {
+//       labor += jl.lbr_amt;
+//     }
+//   }
+//   const total = parts + labor;
+//
+//   //TODO: clm_total is the 100% full amount of the repair including deductible, betterment and taxes. Typically provided by the source system.
+//   return Number.isFinite(total) && total > 0 ? total : 0;
+// };
 
 /**
  * Handles the VehicleDamageEstimateAddRq XML request from parts management.
@@ -512,9 +533,9 @@ const vehicleDamageEstimateAddRq = async (req, res) => {
       scheduled_in,
       scheduled_completion,
       clm_no,
-      status,
       policy_no,
       ded_amt
+      // status,
     } = extractJobData(rq);
 
     if (!shopId) {
@@ -522,22 +543,22 @@ const vehicleDamageEstimateAddRq = async (req, res) => {
     }
 
     // Get default status
-    const defaultStatus = await getDefaultOrderStatus(shopId, logger);
+    const defaultStatus = await getDefaultJobStatus(shopId, logger);
 
     // Extract additional data
     const parts_tax_rates = extractPartsTaxRates(rq.ProfileInfo);
     const ownerData = extractOwnerData(rq, shopId);
     const estimatorData = extractEstimatorData(rq);
-    const adjusterData = extractAdjusterData(rq);
-    const repairFacilityData = extractRepairFacilityData(rq);
+    // const adjusterData = extractAdjusterData(rq);
+    // const repairFacilityData = extractRepairFacilityData(rq);
     const vehicleData = extractVehicleData(rq, shopId);
     const lossInfo = extractLossInfo(rq);
     const joblinesData = extractJobLines(rq);
     const insuranceData = extractInsuranceData(rq);
 
     // Derive clm_total: prefer RepairTotalsInfo SummaryTotals GRAND TOTAL; else sum from lines
-    const grandTotal = extractGrandTotal(rq);
-    const computedTotal = grandTotal ?? computeLinesTotal(joblinesData);
+    // const grandTotal = extractGrandTotal(rq);
+    // const computedTotal = grandTotal ?? computeLinesTotal(joblinesData);
 
     // Find or create relationships
     const ownerid = await insertOwner(ownerData, logger);
@@ -556,8 +577,8 @@ const vehicleDamageEstimateAddRq = async (req, res) => {
       class: classType,
       parts_tax_rates,
       clm_no,
-      status: status || defaultStatus,
-      clm_total: computedTotal || null,
+      status: defaultStatus,
+      clm_total: 0, // computedTotal || null,
       policy_no,
       ded_amt,
       comment,
@@ -572,8 +593,8 @@ const vehicleDamageEstimateAddRq = async (req, res) => {
       ...lossInfo,
       ...ownerData,
       ...estimatorData,
-      ...adjusterData,
-      ...repairFacilityData,
+      // ...adjusterData,
+      // ...repairFacilityData,
       // Inline vehicle data
       v_vin: vehicleData.v_vin,
       v_model_yr: vehicleData.v_model_yr,

server/integrations/partsManagement/endpoints/vehicleDamageEstimateChgRq.js

@@ -6,22 +6,23 @@ const { parseXml, normalizeXmlObject } = require("../partsManagementUtils");
 const { extractPartsTaxRates } = require("./lib/extractPartsTaxRates");
 
 const {
-  GET_JOB_BY_CLAIM,
+  GET_JOB_BY_ID,
   UPDATE_JOB_BY_ID,
   SOFT_DELETE_JOBLINES_BY_IDS,
-  INSERT_JOBLINES
+  INSERT_JOBLINES,
+  GET_JOBLINES_NOTES_BY_JOBID_UNQSEQ
 } = require("../partsManagement.queries");
 
 /**
  * Finds a job by shop ID and claim number.
  * @param shopId
- * @param claimNum
+ * @param jobId
  * @param logger
  * @returns {Promise<*|null>}
  */
-const findJob = async (shopId, claimNum, logger) => {
+const findJob = async (shopId, jobId, logger) => {
   try {
-    const { jobs } = await client.request(GET_JOB_BY_CLAIM, { shopid: shopId, clm_no: claimNum });
+    const { jobs } = await client.request(GET_JOB_BY_ID, { shopid: shopId, jobid: jobId });
     return jobs?.[0] || null;
   } catch (err) {
     logger.log("parts-job-lookup-failed", "error", null, null, { error: err });
@@ -37,13 +38,15 @@ const findJob = async (shopId, claimNum, logger) => {
 const extractUpdatedJobData = (rq) => {
   const doc = rq.DocumentInfo || {};
   const claim = rq.ClaimInfo || {};
-
+  //TODO: In the full BMS world, much more can change, this will need to be expanded
+  // before it can be considered an generic BMS importer, currently it is bespoke to webest
   const policyNo = claim.PolicyInfo?.PolicyInfo?.PolicyNum || claim.PolicyInfo?.PolicyNum || null;
 
   const out = {
     comment: doc.Comment || null,
     clm_no: claim.ClaimNum || null,
-    status: claim.ClaimStatus || null,
+    // TODO: Commented out so they do not blow over with 'Auth Cust'
+    // status: claim.ClaimStatus || null,
     policy_no: policyNo
   };
 
@@ -60,8 +63,9 @@ const extractUpdatedJobData = (rq) => {
  * - Keep part and labor on the same jobline
  * - Aggregate RefinishLabor into secondary labor fields and add its amount to lbr_amt
  * - SUBLET-only lines become PAS part_type with act_price = SubletAmount
+ * Accepts currentJobLineNotes map for notes merging.
  */
-const extractUpdatedJobLines = (addsChgs = {}, jobId) => {
+const extractUpdatedJobLines = (addsChgs = {}, jobId, currentJobLineNotes = {}) => {
   const linesIn = Array.isArray(addsChgs.DamageLineInfo) ? addsChgs.DamageLineInfo : [addsChgs.DamageLineInfo || {}];
 
   const coerceManual = (val) =>
@@ -83,12 +87,33 @@ const extractUpdatedJobLines = (addsChgs = {}, jobId) => {
       unq_seq: parseInt(line.UniqueSequenceNum || 0, 10),
       status: line.LineStatusCode || null,
       line_desc: line.LineDesc || null,
-      notes: line.LineMemo || null,
+      // notes will be set below
       manual_line: line.ManualLineInd !== undefined ? coerceManual(line.ManualLineInd) : null
     };
 
     const lineOut = { ...base };
 
+    // --- Notes merge logic ---
+    const unqSeq = lineOut.unq_seq;
+    const currentNotes = currentJobLineNotes?.[unqSeq] || null;
+    const newNotes = line.LineMemo || null;
+    if (newNotes && currentNotes) {
+      if (currentNotes === newNotes) {
+        lineOut.notes = currentNotes;
+      } else if (currentNotes.includes(newNotes)) {
+        lineOut.notes = currentNotes;
+      } else {
+        lineOut.notes = `${currentNotes} | ${newNotes}`;
+      }
+    } else if (newNotes) {
+      lineOut.notes = newNotes;
+    } else if (currentNotes) {
+      lineOut.notes = currentNotes;
+    } else {
+      lineOut.notes = null;
+    }
+    // --- End notes merge logic ---
+
     const hasPart = Object.keys(partInfo).length > 0;
     const hasSublet = Object.keys(subletInfo).length > 0;
 
@@ -191,28 +216,45 @@ const partsManagementVehicleDamageEstimateChgRq = async (req, res) => {
     if (!rq) return res.status(400).send("Missing <VehicleDamageEstimateChgRq>");
 
     const shopId = rq.ShopID;
-    const claimNum = rq.ClaimInfo?.ClaimNum;
+    const jobId = rq.JobID;
 
-    if (!shopId || !claimNum) return res.status(400).send("Missing ShopID or ClaimNum");
+    if (!shopId || !jobId) return res.status(400).send("Missing ShopID or JobID");
+
+    const job = await findJob(shopId, jobId, logger);
 
-    const job = await findJob(shopId, claimNum, logger);
     if (!job) return res.status(404).send("Job not found");
 
+    // --- Get updated lines and their unq_seq ---
+    const linesIn = Array.isArray(rq.AddsChgs?.DamageLineInfo)
+      ? rq.AddsChgs.DamageLineInfo
+      : [rq.AddsChgs?.DamageLineInfo || {}];
+    const updatedSeqs = Array.from(
+      new Set((linesIn || []).map((l) => parseInt(l?.UniqueSequenceNum || 0, 10)).filter((v) => Number.isInteger(v)))
+    );
+    let currentJobLineNotes = {};
+    if (updatedSeqs.length > 0) {
+      const resp = await client.request(GET_JOBLINES_NOTES_BY_JOBID_UNQSEQ, { jobid: job.id, unqSeqs: updatedSeqs });
+      if (resp?.joblines) {
+        for (const jl of resp.joblines) {
+          currentJobLineNotes[jl.unq_seq] = jl.notes;
+        }
+      }
+    }
+    // --- End fetch current notes ---
+
     const updatedJobData = extractUpdatedJobData(rq);
-    const updatedLines = extractUpdatedJobLines(rq.AddsChgs, job.id);
+    const updatedLines = extractUpdatedJobLines(rq.AddsChgs, job.id, currentJobLineNotes);
     const deletedLineIds = extractDeletions(rq.Deletions);
 
     await client.request(UPDATE_JOB_BY_ID, { id: job.id, job: updatedJobData });
 
-    // Build a set of unq_seq that will be updated (replaced). We delete them first to avoid duplicates.
-    const updatedSeqs = Array.from(
-      new Set((updatedLines || []).map((l) => l?.unq_seq).filter((v) => Number.isInteger(v)))
-    );
-
+    //TODO: for changed lines, are they deleted and then reinserted?
+    //TODO: Updated lines should get an upsert to update things like desc, price, etc.
     if (deletedLineIds?.length || updatedSeqs?.length) {
       const allToDelete = Array.from(new Set([...(deletedLineIds || []), ...(updatedSeqs || [])]));
       if (allToDelete.length) {
         await client.request(SOFT_DELETE_JOBLINES_BY_IDS, { jobid: job.id, unqSeqs: allToDelete });
+        //TODO: appears to soft delete updated lines as well.
       }
     }
 

server/integrations/partsManagement/partsManagement.queries.js

@@ -2,7 +2,7 @@
 const GET_BODYSHOP_STATUS = `
   query GetBodyshopStatus($id: uuid!) {
     bodyshops_by_pk(id: $id) {
-      md_order_statuses
+      md_ro_statuses
     }
   }
 `;
@@ -44,60 +44,22 @@ const GET_JOB_BY_CLAIM = `
   }
 `;
 
-const UPDATE_JOB_BY_ID = `
-  mutation UpdateJobById($id: uuid!, $job: jobs_set_input!) {
-    update_jobs_by_pk(pk_columns: { id: $id }, _set: $job) {
+const GET_JOB_BY_ID = `
+  query GetJobByID($shopid: uuid!, $jobid: uuid!) {
+    jobs(
+      where: { shopid: { _eq: $shopid }, id: { _eq: $jobid } }
+      order_by: { created_at: desc }
+      limit: 1
+    ) {
       id
     }
   }
 `;
 
-const UPSERT_JOBLINES = `
-mutation UpsertJoblines($joblines: [joblines_insert_input!]!) {
-  insert_joblines(
-    objects: $joblines
-    on_conflict: {
-      constraint: joblines_pkey
-      update_columns: [
-        jobid
-        status
-        line_desc
-        part_type
-        part_qty
-        oem_partno
-        db_price
-        act_price
-        mod_lbr_ty
-        mod_lb_hrs
-        lbr_op
-        lbr_amt
-        notes
-        manual_line
-      ]
-    }
-  ) {
-    affected_rows
-  }
-}
-`;
-
-const DELETE_JOBLINES_BY_JOBID = `
-  mutation DeleteJoblinesByJobId($jobid: uuid!) {
-    delete_joblines(where: { jobid: { _eq: $jobid } }) {
-      affected_rows
-    }
-  }
-`;
-
-const DELETE_JOBLINES_BY_IDS = `
-  mutation DeleteJoblinesByIds($jobid: uuid!, $unqSeqs: [Int!]!) {
-    delete_joblines(
-      where: {
-        jobid: { _eq: $jobid },
-        unq_seq: { _in: $unqSeqs }
-      }
-    ) {
-      affected_rows
+const UPDATE_JOB_BY_ID = `
+  mutation UpdateJobById($id: uuid!, $job: jobs_set_input!) {
+    update_jobs_by_pk(pk_columns: { id: $id }, _set: $job) {
+      id
     }
   }
 `;
@@ -245,6 +207,45 @@ const DELETE_AUDIT_TRAIL_BY_SHOP = `
   }
 `;
 
+const GET_JOBLINES_NOTES_BY_JOBID_UNQSEQ = `
+  query GetJoblinesNotesByJobIdUnqSeq($jobid: uuid!, $unqSeqs: [Int!]!) {
+    joblines(where: { jobid: { _eq: $jobid }, unq_seq: { _in: $unqSeqs }, removed: { _neq: true } }) {
+      unq_seq
+      notes
+    }
+  }
+`;
+
+// Clear task links to parts orders for all jobs in a shop to avoid FK violations when deleting parts orders
+const CLEAR_TASKS_PARTSORDER_LINKS_BY_JOBIDS = `
+  mutation ClearTasksPartsOrderLinks($jobIds: [uuid!]!) {
+    update_tasks(
+      where: { parts_order: { jobid: { _in: $jobIds } } },
+      _set: { partsorderid: null }
+    ) {
+      affected_rows
+    }
+  }
+`;
+
+// Delete parts order lines where the parent order belongs to any of the provided job IDs
+const DELETE_PARTS_ORDER_LINES_BY_JOB_IDS = `
+  mutation DeletePartsOrderLinesByJobIds($jobIds: [uuid!]!) {
+    delete_parts_order_lines(where: { parts_order: { jobid: { _in: $jobIds } } }) {
+      affected_rows
+    }
+  }
+`;
+
+// Delete parts orders for the given job IDs
+const DELETE_PARTS_ORDERS_BY_JOB_IDS = `
+  mutation DeletePartsOrdersByJobIds($jobIds: [uuid!]!) {
+    delete_parts_orders(where: { jobid: { _in: $jobIds } }) {
+      affected_rows
+    }
+  }
+`;
+
 module.exports = {
   GET_BODYSHOP_STATUS,
   GET_VEHICLE_BY_SHOP_VIN,
@@ -252,9 +253,6 @@ module.exports = {
   INSERT_JOB_WITH_LINES,
   GET_JOB_BY_CLAIM,
   UPDATE_JOB_BY_ID,
-  UPSERT_JOBLINES,
-  DELETE_JOBLINES_BY_JOBID,
-  DELETE_JOBLINES_BY_IDS,
   SOFT_DELETE_JOBLINES_BY_IDS,
   INSERT_JOBLINES,
   CHECK_EXTERNAL_SHOP_ID,
@@ -271,5 +269,11 @@ module.exports = {
   GET_JOBS_BY_SHOP,
   DELETE_JOBLINES_BY_JOB_IDS,
   DELETE_JOBS_BY_IDS,
-  DELETE_AUDIT_TRAIL_BY_SHOP
+  DELETE_AUDIT_TRAIL_BY_SHOP,
+  GET_JOBLINES_NOTES_BY_JOBID_UNQSEQ,
+  GET_JOB_BY_ID,
+  // newly added exports
+  CLEAR_TASKS_PARTSORDER_LINKS_BY_JOBIDS,
+  DELETE_PARTS_ORDER_LINES_BY_JOB_IDS,
+  DELETE_PARTS_ORDERS_BY_JOB_IDS
 };

server/render/canvas-handler.js

@@ -73,37 +73,23 @@ const processCanvasRequest = async (req, res) => {
   // Default width and height
   const width = isNumber(w) && w > 0 ? w : 500;
   const height = isNumber(h) && h > 0 ? h : 275;
-
   const configuration = getChartConfiguration(keys, values, override);
 
-  let canvas = null;
-  let ctx = null;
   let chart = null;
-  let chartImage = null;
 
   try {
-    // Create the canvas
-    canvas = new Canvas(width, height);
-    ctx = canvas.getContext("2d");
+    const canvas = new Canvas(width, height);
+    const ctx = canvas.getContext("2d");
 
-    // Render the chart
     chart = new Chart(ctx, configuration);
 
-    // Generate and send the image
-    chartImage = (await canvas.toBuffer("image/png")).toString("base64");
+    const chartImage = (await canvas.toBuffer("image/png")).toString("base64");
     res.status(200).send(`data:image/png;base64,${chartImage}`);
   } catch (error) {
-    // Log the error and send the response
     logger.log("canvas-error", "error", "jsr", null, { error: error.message });
-    res.status(500).send("Failed to generate canvas.");
+    res.status(500).send("Error generating canvas");
   } finally {
-    // Cleanup resources
-    if (chart) {
-      chart.destroy();
-    }
-    ctx = null;
-    canvas = null;
-    chartImage = null;
+    chart?.destroy();
   }
 };
 
@@ -118,15 +104,18 @@ const enqueueRequest = (req, res) => {
 };
 
 const processNextInQueue = async () => {
-  while (requestQueue.length > 0) {
-    const { req, res } = requestQueue.shift();
-    try {
-      await processCanvasRequest(req, res);
-    } catch (err) {
-      console.error("canvas-queue-error", "error", "jsr", null, { error: err.message });
+  try {
+    while (requestQueue.length > 0) {
+      const { req, res } = requestQueue.shift();
+      try {
+        await processCanvasRequest(req, res);
+      } catch (err) {
+        console.error("canvas-queue-error", "error", "jsr", null, { error: err.message });
+      }
     }
+  } finally {
+    isProcessing = false;
   }
-  isProcessing = false;
 };
 
 exports.canvastest = function (req, res) {
@@ -134,7 +123,10 @@ exports.canvastest = function (req, res) {
 };
 
 exports.canvas = async (req, res) => {
-  if (isProcessing || !enqueueRequest(req, res)) return;
-  isProcessing = true;
-  processNextInQueue().catch((err) => console.error("canvas-processing-error", { error: err.message }));
+  if (!enqueueRequest(req, res)) return;
+
+  if (!isProcessing) {
+    isProcessing = true;
+    processNextInQueue().catch((err) => console.error("canvas-processing-error", { error: err.message }));
+  }
 };

server/routes/intergrationRoutes.js

@@ -38,7 +38,7 @@ if (typeof PARTS_MANAGEMENT_INTEGRATION_SECRET === "string" && PARTS_MANAGEMENT_
    * Route to handle Vehicle Damage Estimate Change Request
    */
   router.post(
-    "/parts-management/VehicleDamageEstimateChqRq",
+    "/parts-management/VehicleDamageEstimateChgRq",
     express.raw({ type: "application/xml", limit: XML_BODY_LIMIT }), // Parse XML body
     partsManagementIntegrationMiddleware,
     partsManagementVehicleDamageEstimateChqRq

server/routes/miscellaneousRoutes.js

@@ -144,6 +144,9 @@ router.post("/emsupload", validateFirebaseIdTokenMiddleware, data.emsUpload);
 // Redis Cache Routes
 router.post("/bodyshop-cache", eventAuthorizationMiddleware, updateBodyshopCache);
 
+// Estimate Scrubber Vehicle Type
+router.post("/es/vehicletype", data.vehicletype);
+
 // Health Check for docker-compose-cluster load balancer, only available in development
 if (process.env.NODE_ENV === "development") {
   router.get("/health", (req, res) => {