Merged in test-beta (pull request #1355)

[DO NOT MERGE] - 3/15/2024 - Beta Release

Approved-by: Allan Carr

.prettierrc.js

@@ -0,0 +1,16 @@
+exports.default = {
+  printWidth: 120,
+  useTabs: false,
+  tabWidth: 2,
+  trailingComma: "es5",
+  semi: true,
+  singleQuote: false,
+  bracketSpacing: true,
+  arrowParens: "always",
+  jsxSingleQuote: false,
+  bracketSameLine: false,
+  endOfLine: "lf",
+  importOrder: ["^@core/(.*)$", "^@server/(.*)$", "^@ui/(.*)$", "^[./]"],
+  importOrderSeparation: true,
+  importOrderSortSpecifiers: true,
+};

_reference/TeamsSlackInvestigationFinalVersion.md

@@ -0,0 +1,316 @@
+## Microsoft Teams
+
+Integrating Microsoft Teams into your Node.js backend and React frontend application can enhance communication and workflow efficiency,
+especially in a body shop management context for the automotive industry. Microsoft Teams provides several ways to integrate its functionalities into your application, 
+including bots, tabs, messaging extensions, webhooks, and connectors. Here's an overview of the options and how to implement them:
+
+### 0.5 - Share to Teams (TM)
+
+- https://learn.microsoft.com/en-us/microsoftteams/platform/concepts/build-and-test/share-to-teams-from-web-apps
+- https://learn.microsoft.com/en-us/microsoftteams/platform/concepts/build-and-test/share-to-teams-from-personal-app-or-tab
+- https://learn.microsoft.com/en-us/microsoftteams/platform/concepts/device-capabilities/people-picker-capability
+- (Example of some Teams code Integrations) https://github.com/microsoft/teams-powerapps-app-templates/
+
+### 1. Microsoft Graph API
+The Microsoft Graph API is the gateway to data and intelligence in Microsoft 365, including Teams. It allows you to work with Teams data like channels, messages, and more. You can use it to post status changes back to Teams or read data from Teams to affect your site.
+
+Backend (Node.js): Use the @microsoft/microsoft-graph-client package to make API calls to Teams. You will need to handle authentication with Azure AD, which can be done using the @azure/identity package to get tokens for Graph API requests.
+
+*Implementation Steps*:
+
+Register your application in Azure AD to get the client_id and client_secret.
+
+(Is client_id and client_secret going to be something required for every customer or is it going to be a singleton)
+Implement OAuth 2.0 authorization flow to obtain access tokens.
+(This will need to be tracked by association to a bodyshop)
+
+bodyshop->Channels | People ->Messages
+
+Use the access token to make requests to the Microsoft Graph API to interact with Teams.
+
+### 2. Webhooks and Connectors
+Webhooks allow your application to send notifications to a Teams channel, which is useful for posting status changes. Connectors are a set of predefined webhooks that offer a more integrated experience.
+
+Setup:
+In Microsoft Teams, configure an incoming webhook for the channel you want to post messages to.
+Use the webhook URL to send JSON payloads from your Node.js backend, which can then be displayed in Teams.
+
+
+### 3. Bots
+Bots in Teams can interact with users to take commands or post information. You can use the Bot Framework along with the Teams activity handler to create bots that can communicate with your React frontend and Node.js backend.
+
+Backend (Node.js): Use the botbuilder package to create and manage your bot's interactions with Teams.
+
+*Implementation Steps*:
+
+Create a bot registration in Azure Bot Services.
+Implement the bot logic in your Node.js application using the Bot Framework SDK.
+Use the Microsoft Bot Framework's TeamsActivityHandler to respond to Teams-specific activities.
+
+### 4. Tabs
+Tabs in Teams allow you to integrate web-based content as part of Teams, which can be your React application or specific parts of it. This is particularly useful for creating a seamless experience within Teams.
+
+*Implementation Steps*:
+- Create a Teams app manifest that defines your tab and its configuration.
+- Host your React application or the specific parts you want to embed as a tab.
+- Use the Teams SDK in your React application to interact with Teams context and APIs.
+
+*Getting Started*:
+Microsoft Teams Toolkit for Visual Studio Code: This toolkit simplifies the process of setting up your Teams application, including authentication, configuration, and deployment.
+Documentation and Samples: Microsoft provides extensive documentation and sample code for developing Teams applications, which can be invaluable for getting started and solving specific challenges.
+Implementing these features requires a good understanding of both the Microsoft Teams platform and your application's architecture. 
+Start small, perhaps by implementing notifications via webhooks, and gradually add more complex integrations like bots or tabs based on your needs and user feedback.
+
+### Examples:
+
+##### Posting Messages to a Teams Channel Using Incoming Webhooks
+
+1 - Set up an Incoming Webhook in Microsoft Teams:
+- Go to the Teams channel where you want to post messages.
+- Click on the three dots (...) next to the channel name and select Connectors.
+- Search for Incoming Webhook, click Add, and then Configure.
+- Name your webhook, upload an image if desired, and click Create.
+- Copy the webhook URL provided.
+
+  (Patrick Note: The clients might have issues with setting up webhooks, it requires a lot of user configuration and our users are not technical).
+
+2 - Node.js Code to Post a Message:
+
+Ensure you have axios or any HTTP client library installed in your Node.js project. If not, you can install axios via npm: npm install axios.
+Use the following code snippet to post a message to the Teams channel:
+
+```javascript 
+const axios = require('axios');
+
+// Replace 'YOUR_WEBHOOK_URL' with your actual webhook URL
+const webhookUrl = 'YOUR_WEBHOOK_URL';
+
+const message = {
+  "@type": "MessageCard",
+  "@context": "http://schema.org/extensions",
+  "summary": "Issue 176715375",
+  "themeColor": "0078D7",
+  "title": "Issue opened: \"Push notifications not working\"",
+  "sections": [{
+    "activityTitle": "A new issue was created",
+    "activitySubtitle": "Today, 2:36 PM",
+    "activityImage": "https://example.com/issues/image.png",
+    "facts": [{
+        "name": "Repository:",
+        "value": "Repo name"
+      },
+      {
+        "name": "Issue #:",
+        "value": "176715375"
+      }
+    ],
+    "markdown": true
+  }]
+};
+
+axios.post(webhookUrl, message)
+  .then(response => console.log('Successfully sent message to Teams channel'))
+  .catch(error => console.error('Error sending message to Teams channel', error));
+```
+
+#### Creating a Simple Bot for Teams
+1 Prerequisites:
+- Register your bot with the Microsoft Bot Framework and get your bot's App ID and App Password.
+- Use the Bot Framework SDK for JavaScript.
+  2 Install Dependencies:
+- You need to install the botbuilder package. Run npm install botbuilder.
+
+The following example demonstrates a simple bot that echoes back received messages.
+
+```javascript
+const { BotFrameworkAdapter, MemoryStorage, ConversationState, TurnContext } = require('botbuilder');
+
+// Create adapter.
+// See https://aka.ms/about-bot-adapter to learn more about adapters.
+const adapter = new BotFrameworkAdapter({
+    appId: process.env.MicrosoftAppId,
+    appPassword: process.env.MicrosoftAppPassword
+});
+
+// Create conversation state with in-memory storage provider.
+const conversationState = new ConversationState(new MemoryStorage());
+adapter.use(conversationState);
+
+// Listen for incoming requests.
+server.post('/api/messages', (req, res) => {
+    adapter.processActivity(req, res, async (context) => {
+        // Echo back what the user said
+        if (context.activity.type === 'message') {
+            await context.sendActivity(`You said '${context.activity.text}'`);
+        }
+    });
+});
+```
+
+Running Your Bot:
+- Make sure to expose your bot endpoint (/api/messages in this case) to the internet using a service like ngrok.
+- Update your bot's messaging endpoint in the Microsoft Bot Framework portal to point to the ngrok URL.
+
+### Slash Commands (Bot)
+1 -  Create a Microsoft Teams App: You need to develop a Teams app that can interact with users through commands. This involves using the Microsoft Teams Developer Platform and possibly the Bot Framework.
+2 - Use Bots for Custom Commands: The primary way to introduce custom slash commands in Teams is through bots. Bots can respond to specific commands (or messages) that are input by users. When you create a bot for Teams, you can define custom commands that the bot will recognize and respond to.
+3 - Developing the Bot: You can develop a bot using the Microsoft Bot Framework. This allows your bot to receive and send messages to a Teams channel or chat. Within your bot's code, you can define what actions to take when it receives specific commands.
+4 - Register Your Bot with Microsoft Bot Framework: Register your bot with the Microsoft Bot Framework and configure it to work with Microsoft Teams. This step involves getting a Microsoft App ID and password that are necessary for your bot to communicate with the Teams platform.
+5 - Add Your Bot to Microsoft Teams: Once your bot is developed and registered, you can package your Teams app (which includes the bot) and upload it to Microsoft Teams. This will make your bot available to users within Teams, where they can interact with it using the custom commands you've defined.
+6 - Handling Slash Commands: In the context of your bot's code, you will need to interpret messages that start with a slash (/) as commands. You can then parse the command text and perform the appropriate actions or respond accordingly.
+7 - Publish Your App: For broader distribution, you can publish your Teams app to the Teams app store or distribute it within your organization through the Teams admin center.
+/ <command> <arb> ....
+(Unrelated to teams but then used in teams for functionality)
+- A Job has a todo list
+- a todo item may have an employee
+- a todo item may have a due date
+- a todo item may have a priority
+
+--- Call notes ----
+- Tasks (TODO List)
+- EMail reminders
+
+## Slack
+
+Integrating Slack into your Node.js backend and React frontend application can significantly streamline communication and operations for your automotive industry body shop management software. Slack offers various integration points including bots, apps, webhooks, and its rich API to facilitate interactions between your application and Slack workspace. Here's how you can leverage these integration points:
+
+### 1. **Slack Web API**
+
+The Slack Web API allows you to interact with Slack, enabling functionalities like sending messages, managing channels, and more directly from your application.
+
+- **Backend (Node.js)**: Utilize the `@slack/web-api` package to make API calls from your Node.js backend. This will be the backbone for actions such as posting status updates to Slack channels or handling commands from Slack that can affect your site.
+
+- **Implementation Steps**:
+    1. Create a Slack app in your Slack workspace and obtain the API tokens.
+    2. Use the `@slack/web-api` package to authenticate and interact with Slack API endpoints.
+    3. Implement features such as sending messages or processing events from Slack.
+
+### 2. **Incoming Webhooks**
+
+For simpler integrations focused on sending notifications to Slack channels, incoming webhooks are straightforward and effective. They allow you to send messages to a specific channel without a full-blown app.
+
+- **Setup**:
+    1. Create an incoming webhook from the Slack app configuration page.
+    2. Use the webhook URL to send messages from your Node.js backend by making simple HTTP POST requests with your message payload.
+
+### 3. **Bots**
+
+Slack bots can facilitate interactive experiences within your Slack workspace, responding to commands, posting notifications, or even pulling data from your site on demand.
+
+- **Backend (Node.js)**: Leverage the `@slack/bolt` framework, which simplifies creating Slack bots with event handling, messaging, and built-in OAuth support.
+
+- **Implementation Steps**:
+    1. Create a Slack app and enable bot features.
+    2. Use the `@slack/bolt` package to develop your bot, handling events like messages or commands.
+    3. Deploy your bot and set it to listen to incoming events from Slack.
+
+### 4. **Slack Block Kit**
+
+For more engaging and interactive messages, Slack's Block Kit provides a UI framework that allows you to create richly formatted messages, modals, and more.
+
+- **Frontend (React)** and **Backend (Node.js)**: Utilize Slack's Block Kit to design complex messages with buttons, sections, and interactive components. You can send these payloads through the Web API or from bots to enhance your app's interaction with users.
+
+### Getting Started
+
+- **Slack API Documentation and Tools**: Slack's API documentation is comprehensive and includes tutorials, tooling (like Block Kit Builder), and SDK documentation to help you get started.
+
+- **Testing and Development**: Slack provides a sandbox environment for you to test your app's integrations and interactions without affecting your live workspace.
+
+To integrate Slack into your application effectively, start by planning out the interactions you need (e.g., notifications, commands, information retrieval) and map these to the appropriate Slack features. Then, incrementally build and test each integration, utilizing Slack's development tools and your existing Node.js and React knowledge to create a seamless experience for your users.
+
+#### Examples
+
+1. Incoming Webhooks
+   Incoming Webhooks are a simple way to post messages from your Node.js application into Slack channels. They're perfect for notifying team members about status changes or updates.
+
+Setup:
+
+1 - Create a new Slack app in your workspace and enable incoming webhooks.
+2 - Add a new webhook to your app and choose the channel it will post to.
+3 - Use the webhook URL to send messages from your backend.
+
+Node.js Example:
+
+```javascript
+
+const axios = require('axios');
+const webhookUrl = 'YOUR_SLACK_WEBHOOK_URL';
+
+async function postMessageToSlack(message) {
+  await axios.post(webhookUrl, {
+    text: message, // Your message here
+  });
+}
+
+postMessageToSlack('New status update on the automotive project!').catch(console.error);
+```
+2. Bots
+   Slack bots can interact with users via messages, respond to commands, and even post updates. They're great for building interactive features.
+
+Setup:
+
+1 - Create a Slack app and add the Bot Token Scopes (like chat:write).
+2 - Install the app to your workspace to get your bot token.
+3 - Use the @slack/bolt framework for easy bot development in Node.js.
+
+Node.js Example:
+
+```javascript
+const { App } = require('@slack/bolt');
+
+const app = new App({
+  token: process.env.SLACK_BOT_TOKEN, // Set your bot's access token here
+  signingSecret: process.env.SLACK_SIGNING_SECRET // Set your app's signing secret here
+});
+
+app.message('hello', async ({ message, say }) => {
+  await say(`Hey there <@${message.user}>!`);
+});
+
+(async () => {
+  await app.start(process.env.PORT || 3000);
+  console.log('Slack bot is running!');
+})();
+```
+
+3. Slash Commands
+   Slash Commands allow users to interact with your application directly from Slack by typing commands that start with /.
+
+Setup:
+
+1 - Create a Slack app and configure a new Slash Command (e.g., /statusupdate).
+2 - Point the command request URL to your Node.js backend endpoint.
+3 - Implement the endpoint to handle the command and respond accordingly.
+
+Node.js Example:
+
+```javascript
+const express = require('express');
+const bodyParser = require('body-parser');
+
+const app = express();
+app.use(bodyParser.urlencoded({ extended: false }));
+
+app.post('/slack/commands/statusupdate', (req, res) => {
+  const { text, user_name } = req.body; // Command input and user info
+  // Logic to handle the command goes here. For example, update a status or fetch information.
+  res.send(`Status update received: ${text} - from ${user_name}`);
+});
+
+app.listen(process.env.PORT || 3000, () => console.log('Server is running'));
+```
+
+4. Interactive Components
+   Interactive components like buttons or menus can make your Slack messages more engaging and interactive.
+
+Setup:
+1 - Enable Interactivity in your Slack app settings.
+2 - Implement an endpoint in your Node.js backend to handle interactions.
+3 - Send messages with interactive components from your backend.
+
+Implementing these features into your Node.js and React application will enable a more dynamic and integrated experience for users of your body shop management software. Start with the simpler integrations like webhooks and progressively incorporate bots and interactive components as needed.
+
+ACTION ITEMS:
+- Slot in tasks, this will be a dependency for things we want to do in the future.
+- This would involve GUI components
+- This would involve a backend component

_reference/reportFiltersAndSorters.md

@@ -3,7 +3,13 @@
 This documentation details the schema required for `.filters` files on the report server. It is used to dynamically
 modify the graphQL query and provide the user more power over their reports.
 
-# Special Notes
+For filters and sorters, valid types include (`type` key in the schema):
+- string (default)
+- number
+- bool or boolean
+- date
+
+## Special Notes
 - When passing the data to the template server, the property filters and sorters is added to the data object and will reflect the filters and sorters the user has selected
 
 ## High level Schema Overview
@@ -40,9 +46,10 @@ Filters effect the where clause of the graphQL query. They are used to filter th
 A note on special notation used in the `name` field.
 
 ## Reflection
+
 Filters can make use of reflection to pre-fill select boxes, the following is an example of that in the filters file.
 
-```
+```json
     {
       "name": "jobs.status",
       "translation": "jobs.fields.status",
@@ -52,7 +59,7 @@ Filters can make use of reflection to pre-fill select boxes, the following is an
         "type": "internal",
         "name": "special.job_statuses"
       }
-    },
+    }
 ```
 
 in this example, a reflector with the type 'internal' (all types at the moment require this, and it is used for future functionality), with a name of `special.job_statuses`
@@ -67,7 +74,13 @@ The following cases are available
 - `special.employees` - This will reflect the employees `bodyshop.employees`
 - `special.first_names` - This will reflect the first names `bodyshop.employees`
 - `special.last_names` - This will reflect the last names `bodyshop.employees`
-- 
+- `special.referral_sources` - This will reflect the referral sources `bodyshop.md_referral_sources`
+- `special.class`- This will reflect the class `bodyshop.md_classes`
+- `special.lost_sale_reasons` - This will reflect the lost sale reasons `bodyshop.md_lost_sale_reasons`
+- `special.alt_transports` - This will reflect the alternative transports `bodyshop.appt_alt_transport`
+- `special.payment_types` - This will reflect the payment types `bodyshop.md_payment_types`
+- `special.payment_payers` - This is a special case with a key value set of [Customer, Insurance]
+
 ### Path without brackets, multi level
 
 `"name": "jobs.joblines.mod_lb_hrs",`
@@ -142,12 +155,12 @@ query gendoc_hours_sold_detail_open($starttz: timestamptz!, $endtz: timestamptz!
 
 - Will only support two level of nesting in the graphQL query `jobs.joblines.mod_lb_hrs` vs `[jobs].joblines.mod_lb_hrs`
   is fine, but `jobs.[joblines.].some_table.mod_lb_hrs` is not.
-- The `dates` object is not yet implemented and will be added in a future release.
-- The type object must be 'string' or 'number' and is case-sensitive.
+- The type object must be 'string' or 'number'  or 'bool' or 'boolean' or 'date' and is case-sensitive.
 - The `translation` key is used to look up the label in the GUI, if it is not found, the `label` key is used.
 - Do not add the ability to filter things that are already filtered as part of the original query, this would be
   redundant and could cause issues.
 - Do not add the ability to filter on things like FK constraints, must like the above example.
+- *INHERITANCE CAVEAT* If you have a filters file on a parent report that has a child that you do not want the filters inherited from, you must place a blank filters file (valid json so {}) on the child report level. This will than fetch the child filters, which are empty and move along, versus inheriting the parent filters.
 
 ## Sorters
 
@@ -158,6 +171,7 @@ query gendoc_hours_sold_detail_open($starttz: timestamptz!, $endtz: timestamptz!
   using the sorters.
 
 ### Default Sorters
+
 - A sorter can be given a default object containing a `order` and `direction` key value. This will be used to sort the report if the user does not select any of the sorters themselves.
 - The `order` key is the order in which the sorters are applied, and the `direction` key is the direction of the sort, either `asc` or `desc`.
 
@@ -172,4 +186,4 @@ query gendoc_hours_sold_detail_open($starttz: timestamptz!, $endtz: timestamptz!
         "direction": "asc"
     }
 }
-```
+```

client/package-lock.json

@@ -17,8 +17,8 @@
         "@jsreport/browser-client": "^3.1.0",
         "@reduxjs/toolkit": "^2.2.1",
         "@sentry/cli": "^2.28.6",
-        "@sentry/react": "^7.102.1",
-        "@sentry/tracing": "^7.102.1",
+        "@sentry/react": "^7.104.0",
+        "@sentry/tracing": "^7.104.0",
         "@splitsoftware/splitio-react": "^1.11.0",
         "@tanem/react-nprogress": "^5.0.51",
         "antd": "^5.14.2",
@@ -33,7 +33,7 @@
         "enquire-js": "^0.2.1",
         "env-cmd": "^10.1.0",
         "exifr": "^7.1.3",
-        "firebase": "^10.8.0",
+        "firebase": "^10.8.1",
         "graphql": "^16.6.0",
         "i18next": "^23.10.0",
         "i18next-browser-languagedetector": "^7.0.2",
@@ -46,11 +46,11 @@
         "phone": "^3.1.42",
         "preval.macro": "^5.0.0",
         "prop-types": "^15.8.1",
-        "query-string": "^8.2.0",
+        "query-string": "^9.0.0",
         "rc-queue-anim": "^2.0.0",
         "rc-scroll-anim": "^2.7.6",
         "react": "^18.2.0",
-        "react-big-calendar": "^1.10.3",
+        "react-big-calendar": "^1.11.0",
         "react-color": "^2.19.3",
         "react-cookie": "^7.1.0",
         "react-dom": "^18.2.0",
@@ -62,15 +62,15 @@
         "react-image-lightbox": "^5.1.4",
         "react-intersection-observer": "^9.8.1",
         "react-markdown": "^9.0.1",
-        "react-number-format": "^5.1.4",
+        "react-number-format": "^5.3.3",
         "react-redux": "^9.1.0",
         "react-resizable": "^3.0.5",
-        "react-router-dom": "^6.22.1",
+        "react-router-dom": "^6.22.2",
         "react-scripts": "^5.0.1",
         "react-sticky": "^6.0.3",
         "react-sublime-video": "^0.2.5",
         "react-virtualized": "^9.22.5",
-        "recharts": "^2.12.1",
+        "recharts": "^2.12.2",
         "redux": "^5.0.1",
         "redux-persist": "^6.0.0",
         "redux-saga": "^1.3.0",
@@ -88,7 +88,7 @@
         "workbox-precaching": "^7.0.0",
         "workbox-routing": "^7.0.0",
         "workbox-strategies": "^7.0.0",
-        "yauzl": "^3.1.0"
+        "yauzl": "^3.1.1"
       },
       "devDependencies": {
         "@babel/plugin-proposal-private-property-in-object": "^7.21.11",
@@ -2991,9 +2991,9 @@
       }
     },
     "node_modules/@fastify/busboy": {
-      "version": "2.1.0",
-      "resolved": "https://registry.npmjs.org/@fastify/busboy/-/busboy-2.1.0.tgz",
-      "integrity": "sha512-+KpH+QxZU7O4675t3mnkQKcZZg56u+K/Ct2K+N2AZYNVK8kyeo/bI18tI8aPm3tvNNRyTWfj6s5tnGNlcbQRsA==",
+      "version": "2.1.1",
+      "resolved": "https://registry.npmjs.org/@fastify/busboy/-/busboy-2.1.1.tgz",
+      "integrity": "sha512-vBZP4NlzfOlerQTnba4aqZoMhE/a9HY7HRqoOPaETQcSQuWEIyZMHGfVu6w9wGtGK5fED5qRs2DteVCjOH60sA==",
       "engines": {
         "node": ">=14"
       }
@@ -3042,9 +3042,9 @@
       "integrity": "sha512-iRP+QKI2+oz3UAh4nPEq14CsEjrjD6a5+fuypjScisAh9kXKFvdJOZJDwk7kikLvWVLGEs9+kIUS4LPQV7VZVw=="
     },
     "node_modules/@firebase/app": {
-      "version": "0.9.27",
-      "resolved": "https://registry.npmjs.org/@firebase/app/-/app-0.9.27.tgz",
-      "integrity": "sha512-p2Dvl1ge4kRsyK5+wWcmdAIE9MSwZ0pDKAYB51LZgZuz6wciUZk4E1yAEdkfQlRxuHehn+Ol9WP5Qk2XQZiHGg==",
+      "version": "0.9.28",
+      "resolved": "https://registry.npmjs.org/@firebase/app/-/app-0.9.28.tgz",
+      "integrity": "sha512-MS0+EtNixrwJbVDs5Bt/lhUhzeWGUtUoP6X+zYZck5GAZwI5g4F91noVA9oIXlFlpn6Q1xIbiaHA2GwGk7/7Ag==",
       "dependencies": {
         "@firebase/component": "0.6.5",
         "@firebase/logger": "0.4.0",
@@ -3094,11 +3094,11 @@
       "integrity": "sha512-uwSUj32Mlubybw7tedRzR24RP8M8JUVR3NPiMk3/Z4bCmgEKTlQBwMXrehDAZ2wF+TsBq0SN1c6ema71U/JPyQ=="
     },
     "node_modules/@firebase/app-compat": {
-      "version": "0.2.27",
-      "resolved": "https://registry.npmjs.org/@firebase/app-compat/-/app-compat-0.2.27.tgz",
-      "integrity": "sha512-SYlqocfUDKPHR6MSFC8hree0BTiWFu5o8wbf6zFlYXyG41w7TcHp4wJi4H/EL5V6cM4kxwruXTJtqXX/fRAZtw==",
+      "version": "0.2.28",
+      "resolved": "https://registry.npmjs.org/@firebase/app-compat/-/app-compat-0.2.28.tgz",
+      "integrity": "sha512-Mr2NbeM1Oaayuw5unUAMzt+7/MN+e2uklT1l87D+ZLJl2UvhZAZmMt74GjEI9N3sDYKMeszSbszBqtJ1fGVafQ==",
       "dependencies": {
-        "@firebase/app": "0.9.27",
+        "@firebase/app": "0.9.28",
         "@firebase/component": "0.6.5",
         "@firebase/logger": "0.4.0",
         "@firebase/util": "1.9.4",
@@ -3111,15 +3111,15 @@
       "integrity": "sha512-AeweANOIo0Mb8GiYm3xhTEBVCmPwTYAu9Hcd2qSkLuga/6+j9b1Jskl5bpiSQWy9eJ/j5pavxj6eYogmnuzm+Q=="
     },
     "node_modules/@firebase/auth": {
-      "version": "1.6.0",
-      "resolved": "https://registry.npmjs.org/@firebase/auth/-/auth-1.6.0.tgz",
-      "integrity": "sha512-Qhl35eJTV6BwvuueTPCY6x8kUlYyzALtjp/Ws0X3fw3AnjVVfuVb7oQ3Xh5VPVfMFhaIuUAd1KXwcAuIklkSDw==",
+      "version": "1.6.1",
+      "resolved": "https://registry.npmjs.org/@firebase/auth/-/auth-1.6.1.tgz",
+      "integrity": "sha512-oOuQVOxtxKr+kTTqEkkI2qXIeGbkNLpA8FzO030LF4KXmMcETqsPaIqw7Aw1Y4Zl82l1qpZtpc4vN4Da2qZdfQ==",
       "dependencies": {
         "@firebase/component": "0.6.5",
         "@firebase/logger": "0.4.0",
         "@firebase/util": "1.9.4",
         "tslib": "^2.1.0",
-        "undici": "5.26.5"
+        "undici": "5.28.3"
       },
       "peerDependencies": {
         "@firebase/app": "0.x",
@@ -3132,16 +3132,16 @@
       }
     },
     "node_modules/@firebase/auth-compat": {
-      "version": "0.5.2",
-      "resolved": "https://registry.npmjs.org/@firebase/auth-compat/-/auth-compat-0.5.2.tgz",
-      "integrity": "sha512-pRgje5BPCNR1vXyvGOVXwOHtv88A2WooXfklI8sV7/jWi03ExFqNfpJT26GUo/oD39NoKJ3Kt6rD5gVvdV7lMw==",
+      "version": "0.5.3",
+      "resolved": "https://registry.npmjs.org/@firebase/auth-compat/-/auth-compat-0.5.3.tgz",
+      "integrity": "sha512-2pVtVEvu8P7SF6jSPfLPKWUClQFj+StqAZ0fD/uQ6mv8DyWn7AuuANFEu7Pv96JPcaL6Gy9jC5dFqjpptjqSRA==",
       "dependencies": {
-        "@firebase/auth": "1.6.0",
+        "@firebase/auth": "1.6.1",
         "@firebase/auth-types": "0.12.0",
         "@firebase/component": "0.6.5",
         "@firebase/util": "1.9.4",
         "tslib": "^2.1.0",
-        "undici": "5.26.5"
+        "undici": "5.28.3"
       },
       "peerDependencies": {
         "@firebase/app-compat": "0.x"
@@ -3207,9 +3207,9 @@
       }
     },
     "node_modules/@firebase/firestore": {
-      "version": "4.4.2",
-      "resolved": "https://registry.npmjs.org/@firebase/firestore/-/firestore-4.4.2.tgz",
-      "integrity": "sha512-YaX6ypa/RzU6OkxzUQlpSxwhOIWdTraCNz7sMsbaSEjjl/pj/QvX6TqjkdWGzuBYh2S6rz7ErhDO0g39oZZw/g==",
+      "version": "4.4.3",
+      "resolved": "https://registry.npmjs.org/@firebase/firestore/-/firestore-4.4.3.tgz",
+      "integrity": "sha512-Ix61zbeuTsHf0WFbk6+67n89Vzd9M8MMTdnz7c7z+BRE3BS5Vuc3gX5ZcHFjqPkQJ7rpLB1egHsYe4Przp5C2g==",
       "dependencies": {
         "@firebase/component": "0.6.5",
         "@firebase/logger": "0.4.0",
@@ -3218,7 +3218,7 @@
         "@grpc/grpc-js": "~1.9.0",
         "@grpc/proto-loader": "^0.7.8",
         "tslib": "^2.1.0",
-        "undici": "5.26.5"
+        "undici": "5.28.3"
       },
       "engines": {
         "node": ">=10.10.0"
@@ -3228,12 +3228,12 @@
       }
     },
     "node_modules/@firebase/firestore-compat": {
-      "version": "0.3.25",
-      "resolved": "https://registry.npmjs.org/@firebase/firestore-compat/-/firestore-compat-0.3.25.tgz",
-      "integrity": "sha512-+xI7WmsgZCBhMn/+uhDKcg+lsOUJ9FJyt5PGTzkFPbCsozWfeQZ7eVnfPh0rMkUOf0yIQ924RIe04gwvEIbcoQ==",
+      "version": "0.3.26",
+      "resolved": "https://registry.npmjs.org/@firebase/firestore-compat/-/firestore-compat-0.3.26.tgz",
+      "integrity": "sha512-dNrKiH5Cn6ItANV9nJI2Y0msKBj/skO7skDlRo/BUSQE1DKbNzumxpJEz+PK/PV1nTegnRgVvs47gpQeVWXtYQ==",
       "dependencies": {
         "@firebase/component": "0.6.5",
-        "@firebase/firestore": "4.4.2",
+        "@firebase/firestore": "4.4.3",
         "@firebase/firestore-types": "3.0.0",
         "@firebase/util": "1.9.4",
         "tslib": "^2.1.0"
@@ -3252,9 +3252,9 @@
       }
     },
     "node_modules/@firebase/functions": {
-      "version": "0.11.1",
-      "resolved": "https://registry.npmjs.org/@firebase/functions/-/functions-0.11.1.tgz",
-      "integrity": "sha512-3uUa1hB79Gmy6E1gHTfzoHeZolBeHc/I/n3+lOCDe6BOos9AHmzRjKygcFE/7VA2FJjitCE0K+OHI6+OuoY8fQ==",
+      "version": "0.11.2",
+      "resolved": "https://registry.npmjs.org/@firebase/functions/-/functions-0.11.2.tgz",
+      "integrity": "sha512-2NULTYOZbu0rXczwfYdqQH0w1FmmYrKjTy1YPQSHLCAkMBdfewoKmVm4Lyo2vRn0H9ZndciLY7NszKDFt9MKCQ==",
       "dependencies": {
         "@firebase/app-check-interop-types": "0.3.0",
         "@firebase/auth-interop-types": "0.2.1",
@@ -3262,19 +3262,19 @@
         "@firebase/messaging-interop-types": "0.2.0",
         "@firebase/util": "1.9.4",
         "tslib": "^2.1.0",
-        "undici": "5.26.5"
+        "undici": "5.28.3"
       },
       "peerDependencies": {
         "@firebase/app": "0.x"
       }
     },
     "node_modules/@firebase/functions-compat": {
-      "version": "0.3.7",
-      "resolved": "https://registry.npmjs.org/@firebase/functions-compat/-/functions-compat-0.3.7.tgz",
-      "integrity": "sha512-uXe6Kmku5lNogp3OpPBcOJbSvnaCOn+YxS3zlXKNU6Q/NLwcvO3RY1zwYyctCos2RemEw3KEQ7YdzcECXjHWLw==",
+      "version": "0.3.8",
+      "resolved": "https://registry.npmjs.org/@firebase/functions-compat/-/functions-compat-0.3.8.tgz",
+      "integrity": "sha512-VDHSw6UOu8RxfgAY/q8e+Jn+9Fh60Fc28yck0yfMsi2e0BiWgonIMWkFspFGGLgOJebTHl+hc+9v91rhzU6xlg==",
       "dependencies": {
         "@firebase/component": "0.6.5",
-        "@firebase/functions": "0.11.1",
+        "@firebase/functions": "0.11.2",
         "@firebase/functions-types": "0.6.0",
         "@firebase/util": "1.9.4",
         "tslib": "^2.1.0"
@@ -3441,26 +3441,26 @@
       "integrity": "sha512-RtEH4vdcbXZuZWRZbIRmQVBNsE7VDQpet2qFvq6vwKLBIQRQR5Kh58M4ok3A3US8Sr3rubYnaGqZSurCwI8uMA=="
     },
     "node_modules/@firebase/storage": {
-      "version": "0.12.1",
-      "resolved": "https://registry.npmjs.org/@firebase/storage/-/storage-0.12.1.tgz",
-      "integrity": "sha512-KJ5NV7FUh54TeTlEjdkTTX60ciCKOp9EqlbLnpdcXUYRJg0Z4810TXbilPc1z7fTIG4iPjtdi95bGE9n4dBX8A==",
+      "version": "0.12.2",
+      "resolved": "https://registry.npmjs.org/@firebase/storage/-/storage-0.12.2.tgz",
+      "integrity": "sha512-MzanOBcxDx9oOwDaDPMuiYxd6CxcN1xZm+os5uNE3C1itbRKLhM9rzpODDKWzcbnHHFtXk3Q3lsK/d3Xa1WYYw==",
       "dependencies": {
         "@firebase/component": "0.6.5",
         "@firebase/util": "1.9.4",
         "tslib": "^2.1.0",
-        "undici": "5.26.5"
+        "undici": "5.28.3"
       },
       "peerDependencies": {
         "@firebase/app": "0.x"
       }
     },
     "node_modules/@firebase/storage-compat": {
-      "version": "0.3.4",
-      "resolved": "https://registry.npmjs.org/@firebase/storage-compat/-/storage-compat-0.3.4.tgz",
-      "integrity": "sha512-Y0m5e2gS/wB9Ioth2X/Sgz76vcxvqgQrCmfa9qwhss/N31kxY2Gks6Frv0nrE18AjVfcSmcfDitqUwxcMOTRSg==",
+      "version": "0.3.5",
+      "resolved": "https://registry.npmjs.org/@firebase/storage-compat/-/storage-compat-0.3.5.tgz",
+      "integrity": "sha512-5dJXfY5NxCF5NAk4dLvJqC+m6cgcf0Fr29nrMHwhwI34pBheQq2PdRZqALsqZCES9dnHTuFNlqGQDpLr+Ph4rw==",
       "dependencies": {
         "@firebase/component": "0.6.5",
-        "@firebase/storage": "0.12.1",
+        "@firebase/storage": "0.12.2",
         "@firebase/storage-types": "0.8.0",
         "@firebase/util": "1.9.4",
         "tslib": "^2.1.0"
@@ -4394,9 +4394,9 @@
       }
     },
     "node_modules/@remix-run/router": {
-      "version": "1.15.1",
-      "resolved": "https://registry.npmjs.org/@remix-run/router/-/router-1.15.1.tgz",
-      "integrity": "sha512-zcU0gM3z+3iqj8UX45AmWY810l3oUmXM7uH4dt5xtzvMhRtYVhKGOmgOd1877dOPPepfCjUv57w+syamWIYe7w==",
+      "version": "1.15.2",
+      "resolved": "https://registry.npmjs.org/@remix-run/router/-/router-1.15.2.tgz",
+      "integrity": "sha512-+Rnav+CaoTE5QJc4Jcwh5toUpnVLKYbpU6Ys0zqbakqbaLQHeglLVHPfxOiQqdNmUy5C2lXz5dwC6tQNX2JW2Q==",
       "engines": {
         "node": ">=14.0.0"
       }
@@ -4500,89 +4500,40 @@
       "integrity": "sha512-2/U3GXA6YiPYQDLGwtGlnNgKYBSwCFIHf8Y9LUY5VATHdtbLlU0Y1R3QoBnT0aB4qv/BEiVVsj7LJXoQCgJ2vA=="
     },
     "node_modules/@sentry-internal/feedback": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry-internal/feedback/-/feedback-7.102.1.tgz",
-      "integrity": "sha512-vY4hpLLMNLjICtWiizc7KeGbWOTUMGrF7C+9dPCztZww3CLgzWy9A7DvPj5hodRiYzpdRnAMl8yQnMFbYXh7bA==",
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry-internal/feedback/-/feedback-7.104.0.tgz",
+      "integrity": "sha512-+OWqm+X9ZfEQQmxVoZsc9lpzd85pabAT+bEj57StRMTnfdRbD9TippS20nCD9N2Ql5v2/41NfiPONMejGbnOwg==",
       "dependencies": {
-        "@sentry/core": "7.102.1",
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
+        "@sentry/core": "7.104.0",
+        "@sentry/types": "7.104.0",
+        "@sentry/utils": "7.104.0"
       },
       "engines": {
         "node": ">=12"
       }
     },
-    "node_modules/@sentry-internal/feedback/node_modules/@sentry/core": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/core/-/core-7.102.1.tgz",
-      "integrity": "sha512-QjY+LSP3du3J/C8x/FfEbRxgZgsWd0jfTJ4P7s9f219I1csK4OeBMC3UA1HwEa0pY/9OF6H/egW2CjOcMM5Pdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry-internal/feedback/node_modules/@sentry/types": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/types/-/types-7.102.1.tgz",
-      "integrity": "sha512-htKorf3t/D0XYtM7foTcmG+rM47rDP6XdbvCcX5gBCuCYlzpM1vqCt2rl3FLktZC6TaIpFRJw1TLfx6m+x5jdA==",
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry-internal/feedback/node_modules/@sentry/utils": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/utils/-/utils-7.102.1.tgz",
-      "integrity": "sha512-+8WcFjHVV/HROXSAwMuUzveElBFC43EiTG7SNEBNgOUeQzQVTmbUZXyTVgLrUmtoWqvnIxCacoLxtZo1o67kdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
     "node_modules/@sentry-internal/replay-canvas": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry-internal/replay-canvas/-/replay-canvas-7.102.1.tgz",
-      "integrity": "sha512-GUX4RWI10uRjdjeyvCLtAAhWRVqnAnG6+yNxWfqUQ3qMA7B7XxG43KT2UhSnulmErNzODQ6hA68rGPwwYeRIww==",
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry-internal/replay-canvas/-/replay-canvas-7.104.0.tgz",
+      "integrity": "sha512-gfdnkFIpxAveKNghkvRCqv+hSiBkxYVoyFZLTvUPuM9Cmvmket1/PpnuWMC2jNtCEewG3gxkPDd4EaT9oa1HZQ==",
       "dependencies": {
-        "@sentry/core": "7.102.1",
-        "@sentry/replay": "7.102.1",
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
+        "@sentry/core": "7.104.0",
+        "@sentry/replay": "7.104.0",
+        "@sentry/types": "7.104.0",
+        "@sentry/utils": "7.104.0"
       },
       "engines": {
         "node": ">=12"
       }
     },
-    "node_modules/@sentry-internal/replay-canvas/node_modules/@sentry/core": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/core/-/core-7.102.1.tgz",
-      "integrity": "sha512-QjY+LSP3du3J/C8x/FfEbRxgZgsWd0jfTJ4P7s9f219I1csK4OeBMC3UA1HwEa0pY/9OF6H/egW2CjOcMM5Pdg==",
+    "node_modules/@sentry-internal/tracing": {
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry-internal/tracing/-/tracing-7.104.0.tgz",
+      "integrity": "sha512-2z7OijM1J5ndJUiJJElC3iH9qb/Eb8eYm2v8oJhM8WVdc5uCKfrQuYHNgGOnmY2FOCfEUlTmMQGpDw7DJ67L5w==",
       "dependencies": {
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry-internal/replay-canvas/node_modules/@sentry/types": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/types/-/types-7.102.1.tgz",
-      "integrity": "sha512-htKorf3t/D0XYtM7foTcmG+rM47rDP6XdbvCcX5gBCuCYlzpM1vqCt2rl3FLktZC6TaIpFRJw1TLfx6m+x5jdA==",
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry-internal/replay-canvas/node_modules/@sentry/utils": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/utils/-/utils-7.102.1.tgz",
-      "integrity": "sha512-+8WcFjHVV/HROXSAwMuUzveElBFC43EiTG7SNEBNgOUeQzQVTmbUZXyTVgLrUmtoWqvnIxCacoLxtZo1o67kdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1"
+        "@sentry/core": "7.104.0",
+        "@sentry/types": "7.104.0",
+        "@sentry/utils": "7.104.0"
       },
       "engines": {
         "node": ">=8"
@@ -4598,61 +4549,17 @@
       }
     },
     "node_modules/@sentry/browser": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/browser/-/browser-7.102.1.tgz",
-      "integrity": "sha512-7BOfPBiM7Kp6q/iy0JIbsBTxIASV+zWXByqqjuEMWGj3X2u4oRIfm3gv4erPU/l+CORQUVQZLSPGoIoM1gbB/A==",
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry/browser/-/browser-7.104.0.tgz",
+      "integrity": "sha512-HsqO+mr1SowGoP0VbuWrQ2DZT0t5PLomy7LEYa6+4lbOemnY+5YV2NSwBTKbjYysvKipSwaRtPhXrsXsMaz8Bg==",
       "dependencies": {
-        "@sentry-internal/feedback": "7.102.1",
-        "@sentry-internal/replay-canvas": "7.102.1",
-        "@sentry-internal/tracing": "7.102.1",
-        "@sentry/core": "7.102.1",
-        "@sentry/replay": "7.102.1",
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/browser/node_modules/@sentry-internal/tracing": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry-internal/tracing/-/tracing-7.102.1.tgz",
-      "integrity": "sha512-RkFlFyAC0fQOvBbBqnq0CLmFW5m3JJz9pKbZd5vXPraWAlniKSb1bC/4DF9SlNx0FN1LWG+IU3ISdpzwwTeAGg==",
-      "dependencies": {
-        "@sentry/core": "7.102.1",
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/browser/node_modules/@sentry/core": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/core/-/core-7.102.1.tgz",
-      "integrity": "sha512-QjY+LSP3du3J/C8x/FfEbRxgZgsWd0jfTJ4P7s9f219I1csK4OeBMC3UA1HwEa0pY/9OF6H/egW2CjOcMM5Pdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/browser/node_modules/@sentry/types": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/types/-/types-7.102.1.tgz",
-      "integrity": "sha512-htKorf3t/D0XYtM7foTcmG+rM47rDP6XdbvCcX5gBCuCYlzpM1vqCt2rl3FLktZC6TaIpFRJw1TLfx6m+x5jdA==",
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/browser/node_modules/@sentry/utils": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/utils/-/utils-7.102.1.tgz",
-      "integrity": "sha512-+8WcFjHVV/HROXSAwMuUzveElBFC43EiTG7SNEBNgOUeQzQVTmbUZXyTVgLrUmtoWqvnIxCacoLxtZo1o67kdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1"
+        "@sentry-internal/feedback": "7.104.0",
+        "@sentry-internal/replay-canvas": "7.104.0",
+        "@sentry-internal/tracing": "7.104.0",
+        "@sentry/core": "7.104.0",
+        "@sentry/replay": "7.104.0",
+        "@sentry/types": "7.104.0",
+        "@sentry/utils": "7.104.0"
       },
       "engines": {
         "node": ">=8"
@@ -4858,15 +4765,27 @@
         "node": ">=10"
       }
     },
-    "node_modules/@sentry/react": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/react/-/react-7.102.1.tgz",
-      "integrity": "sha512-X4j2DgbktlEifnd21YJKCayAmff5hnaS+9MNz9OonEwD0ARi0ks7bo0wtWHMjPK20992MO+JwczVg/1BXJYDdQ==",
+    "node_modules/@sentry/core": {
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry/core/-/core-7.104.0.tgz",
+      "integrity": "sha512-XPndD6IGQGd07/EntvYVzOWQUo/Gd7L3DwYFeEKeBv6ByWjbBNmVZFRhU0GPPsCHKyW9yMU9OO9diLSS4ijsRg==",
       "dependencies": {
-        "@sentry/browser": "7.102.1",
-        "@sentry/core": "7.102.1",
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1",
+        "@sentry/types": "7.104.0",
+        "@sentry/utils": "7.104.0"
+      },
+      "engines": {
+        "node": ">=8"
+      }
+    },
+    "node_modules/@sentry/react": {
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry/react/-/react-7.104.0.tgz",
+      "integrity": "sha512-JdPzX/rJ4sSr/pVFOKwVrUhr8McCn38w5Q+/wdCabO8fdUkoBe4P05LRCH4Rng0uOk8MeEQ+EvfMVB79DmxIgQ==",
+      "dependencies": {
+        "@sentry/browser": "7.104.0",
+        "@sentry/core": "7.104.0",
+        "@sentry/types": "7.104.0",
+        "@sentry/utils": "7.104.0",
         "hoist-non-react-statics": "^3.3.2"
       },
       "engines": {
@@ -4876,145 +4795,45 @@
         "react": "15.x || 16.x || 17.x || 18.x"
       }
     },
-    "node_modules/@sentry/react/node_modules/@sentry/core": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/core/-/core-7.102.1.tgz",
-      "integrity": "sha512-QjY+LSP3du3J/C8x/FfEbRxgZgsWd0jfTJ4P7s9f219I1csK4OeBMC3UA1HwEa0pY/9OF6H/egW2CjOcMM5Pdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/react/node_modules/@sentry/types": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/types/-/types-7.102.1.tgz",
-      "integrity": "sha512-htKorf3t/D0XYtM7foTcmG+rM47rDP6XdbvCcX5gBCuCYlzpM1vqCt2rl3FLktZC6TaIpFRJw1TLfx6m+x5jdA==",
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/react/node_modules/@sentry/utils": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/utils/-/utils-7.102.1.tgz",
-      "integrity": "sha512-+8WcFjHVV/HROXSAwMuUzveElBFC43EiTG7SNEBNgOUeQzQVTmbUZXyTVgLrUmtoWqvnIxCacoLxtZo1o67kdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
     "node_modules/@sentry/replay": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/replay/-/replay-7.102.1.tgz",
-      "integrity": "sha512-HR/j9dGIvbrId8fh8mQlODx7JrhRmawEd9e9P3laPtogWCg/5TI+XPb2VGSaXOX9VWtb/6Z2UjHsaGjgg6YcuA==",
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry/replay/-/replay-7.104.0.tgz",
+      "integrity": "sha512-HmWBr/u+SNeULxCxM8lJb2iqhjizeLGJtuKSShPEguEXIUT4kzdoqLh6wn7BAjiKzhmyjrnBcosR5LUqJtGYZQ==",
       "dependencies": {
-        "@sentry-internal/tracing": "7.102.1",
-        "@sentry/core": "7.102.1",
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
+        "@sentry-internal/tracing": "7.104.0",
+        "@sentry/core": "7.104.0",
+        "@sentry/types": "7.104.0",
+        "@sentry/utils": "7.104.0"
       },
       "engines": {
         "node": ">=12"
       }
     },
-    "node_modules/@sentry/replay/node_modules/@sentry-internal/tracing": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry-internal/tracing/-/tracing-7.102.1.tgz",
-      "integrity": "sha512-RkFlFyAC0fQOvBbBqnq0CLmFW5m3JJz9pKbZd5vXPraWAlniKSb1bC/4DF9SlNx0FN1LWG+IU3ISdpzwwTeAGg==",
-      "dependencies": {
-        "@sentry/core": "7.102.1",
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/replay/node_modules/@sentry/core": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/core/-/core-7.102.1.tgz",
-      "integrity": "sha512-QjY+LSP3du3J/C8x/FfEbRxgZgsWd0jfTJ4P7s9f219I1csK4OeBMC3UA1HwEa0pY/9OF6H/egW2CjOcMM5Pdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/replay/node_modules/@sentry/types": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/types/-/types-7.102.1.tgz",
-      "integrity": "sha512-htKorf3t/D0XYtM7foTcmG+rM47rDP6XdbvCcX5gBCuCYlzpM1vqCt2rl3FLktZC6TaIpFRJw1TLfx6m+x5jdA==",
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/replay/node_modules/@sentry/utils": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/utils/-/utils-7.102.1.tgz",
-      "integrity": "sha512-+8WcFjHVV/HROXSAwMuUzveElBFC43EiTG7SNEBNgOUeQzQVTmbUZXyTVgLrUmtoWqvnIxCacoLxtZo1o67kdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
     "node_modules/@sentry/tracing": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/tracing/-/tracing-7.102.1.tgz",
-      "integrity": "sha512-9VQEox0R7ouhhUVHtBwlGlXG5beDCM/Uo0BY+G0M1H03aFJsLAwnxPNeWnK3WvPejxf94EgdimKMjDjv9l2Sbg==",
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry/tracing/-/tracing-7.104.0.tgz",
+      "integrity": "sha512-p1mmqNKrCVlA4b6js3twZotAIdS1cLXh05oU9WmSAW3iDo1Vf9QO5+/9K1Vh3a9fPQt3nDJeD/OgAb7C4VBIsA==",
       "dependencies": {
-        "@sentry-internal/tracing": "7.102.1"
+        "@sentry-internal/tracing": "7.104.0"
       },
       "engines": {
         "node": ">=8"
       }
     },
-    "node_modules/@sentry/tracing/node_modules/@sentry-internal/tracing": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry-internal/tracing/-/tracing-7.102.1.tgz",
-      "integrity": "sha512-RkFlFyAC0fQOvBbBqnq0CLmFW5m3JJz9pKbZd5vXPraWAlniKSb1bC/4DF9SlNx0FN1LWG+IU3ISdpzwwTeAGg==",
-      "dependencies": {
-        "@sentry/core": "7.102.1",
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
+    "node_modules/@sentry/types": {
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry/types/-/types-7.104.0.tgz",
+      "integrity": "sha512-5bs0xe0+GZR4QBm9Nrqw59o0sv3kBtCosrZDVxBru/dQbrfnB+/kVorvuM0rV3+coNITTKcKDegSZmK1d2uOGQ==",
       "engines": {
         "node": ">=8"
       }
     },
-    "node_modules/@sentry/tracing/node_modules/@sentry/core": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/core/-/core-7.102.1.tgz",
-      "integrity": "sha512-QjY+LSP3du3J/C8x/FfEbRxgZgsWd0jfTJ4P7s9f219I1csK4OeBMC3UA1HwEa0pY/9OF6H/egW2CjOcMM5Pdg==",
+    "node_modules/@sentry/utils": {
+      "version": "7.104.0",
+      "resolved": "https://registry.npmjs.org/@sentry/utils/-/utils-7.104.0.tgz",
+      "integrity": "sha512-ZVg+xZirI9DlOi0NegNVocswdh/8p6QkzlQzDQY2LP2CC6JQdmwi64o0S4rPH4YIHNKQJTpIjduoxeKgd1EO5g==",
       "dependencies": {
-        "@sentry/types": "7.102.1",
-        "@sentry/utils": "7.102.1"
-      },
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/tracing/node_modules/@sentry/types": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/types/-/types-7.102.1.tgz",
-      "integrity": "sha512-htKorf3t/D0XYtM7foTcmG+rM47rDP6XdbvCcX5gBCuCYlzpM1vqCt2rl3FLktZC6TaIpFRJw1TLfx6m+x5jdA==",
-      "engines": {
-        "node": ">=8"
-      }
-    },
-    "node_modules/@sentry/tracing/node_modules/@sentry/utils": {
-      "version": "7.102.1",
-      "resolved": "https://registry.npmjs.org/@sentry/utils/-/utils-7.102.1.tgz",
-      "integrity": "sha512-+8WcFjHVV/HROXSAwMuUzveElBFC43EiTG7SNEBNgOUeQzQVTmbUZXyTVgLrUmtoWqvnIxCacoLxtZo1o67kdg==",
-      "dependencies": {
-        "@sentry/types": "7.102.1"
+        "@sentry/types": "7.104.0"
       },
       "engines": {
         "node": ">=8"
@@ -11230,25 +11049,25 @@
       }
     },
     "node_modules/firebase": {
-      "version": "10.8.0",
-      "resolved": "https://registry.npmjs.org/firebase/-/firebase-10.8.0.tgz",
-      "integrity": "sha512-UJpC24vw8JFuHEOQyArBGKTUd7+kohLISCzHyn0M/prP0KOTx2io1eyLliEid330QqnWI7FOlPxoU97qecCSfQ==",
+      "version": "10.8.1",
+      "resolved": "https://registry.npmjs.org/firebase/-/firebase-10.8.1.tgz",
+      "integrity": "sha512-4B2jzhU/aumfKL446MG41/T5+t+9d9urf5XGrjC0HRQUm4Ya/amV48HBchnje69ExaJP5f2WxO9OX3wh9ee4wA==",
       "dependencies": {
         "@firebase/analytics": "0.10.1",
         "@firebase/analytics-compat": "0.2.7",
-        "@firebase/app": "0.9.27",
+        "@firebase/app": "0.9.28",
         "@firebase/app-check": "0.8.2",
         "@firebase/app-check-compat": "0.3.9",
-        "@firebase/app-compat": "0.2.27",
+        "@firebase/app-compat": "0.2.28",
         "@firebase/app-types": "0.9.0",
-        "@firebase/auth": "1.6.0",
-        "@firebase/auth-compat": "0.5.2",
+        "@firebase/auth": "1.6.1",
+        "@firebase/auth-compat": "0.5.3",
         "@firebase/database": "1.0.3",
         "@firebase/database-compat": "1.0.3",
-        "@firebase/firestore": "4.4.2",
-        "@firebase/firestore-compat": "0.3.25",
-        "@firebase/functions": "0.11.1",
-        "@firebase/functions-compat": "0.3.7",
+        "@firebase/firestore": "4.4.3",
+        "@firebase/firestore-compat": "0.3.26",
+        "@firebase/functions": "0.11.2",
+        "@firebase/functions-compat": "0.3.8",
         "@firebase/installations": "0.6.5",
         "@firebase/installations-compat": "0.2.5",
         "@firebase/messaging": "0.12.6",
@@ -11257,8 +11076,8 @@
         "@firebase/performance-compat": "0.2.5",
         "@firebase/remote-config": "0.4.5",
         "@firebase/remote-config-compat": "0.2.5",
-        "@firebase/storage": "0.12.1",
-        "@firebase/storage-compat": "0.3.4",
+        "@firebase/storage": "0.12.2",
+        "@firebase/storage-compat": "0.3.5",
         "@firebase/util": "1.9.4"
       }
     },
@@ -18174,16 +17993,16 @@
       }
     },
     "node_modules/query-string": {
-      "version": "8.2.0",
-      "resolved": "https://registry.npmjs.org/query-string/-/query-string-8.2.0.tgz",
-      "integrity": "sha512-tUZIw8J0CawM5wyGBiDOAp7ObdRQh4uBor/fUR9ZjmbZVvw95OD9If4w3MQxr99rg0DJZ/9CIORcpEqU5hQG7g==",
+      "version": "9.0.0",
+      "resolved": "https://registry.npmjs.org/query-string/-/query-string-9.0.0.tgz",
+      "integrity": "sha512-4EWwcRGsO2H+yzq6ddHcVqkCQ2EFUSfDMEjF8ryp8ReymyZhIuaFRGLomeOQLkrzacMHoyky2HW0Qe30UbzkKw==",
       "dependencies": {
         "decode-uri-component": "^0.4.1",
         "filter-obj": "^5.1.0",
         "split-on-first": "^3.0.0"
       },
       "engines": {
-        "node": ">=14.16"
+        "node": ">=18"
       },
       "funding": {
         "url": "https://github.com/sponsors/sindresorhus"
@@ -19048,9 +18867,9 @@
       }
     },
     "node_modules/react-big-calendar": {
-      "version": "1.10.3",
-      "resolved": "https://registry.npmjs.org/react-big-calendar/-/react-big-calendar-1.10.3.tgz",
-      "integrity": "sha512-LmIWlFfGUn8yt4RxcVkGNmjM3GcWynr1bfDwKrrz4KKj517+DH3OGmQzErURN6Zb0OB88HF4oH2dvDHpBQJgIw==",
+      "version": "1.11.0",
+      "resolved": "https://registry.npmjs.org/react-big-calendar/-/react-big-calendar-1.11.0.tgz",
+      "integrity": "sha512-CabU9UCYIjbAew4GpDJa6ycrRINEEONbXEfO0YU7hHuHA2lhyMjnONY+GcpnJvhpOZC3wTtUa7krCriCm+iuKg==",
       "dependencies": {
         "@babel/runtime": "^7.20.7",
         "clsx": "^1.2.1",
@@ -19336,9 +19155,9 @@
       }
     },
     "node_modules/react-number-format": {
-      "version": "5.3.1",
-      "resolved": "https://registry.npmjs.org/react-number-format/-/react-number-format-5.3.1.tgz",
-      "integrity": "sha512-qpYcQLauIeEhCZUZY9jXZnnroOtdy3jYaS1zQ3M1Sr6r/KMOBEIGNIb7eKT19g2N1wbYgFgvDzs19hw5TrB8XQ==",
+      "version": "5.3.3",
+      "resolved": "https://registry.npmjs.org/react-number-format/-/react-number-format-5.3.3.tgz",
+      "integrity": "sha512-maGHWmOvwYzyeRIpL0YC6drWqYaX6iFqjisdJXpZ+HzEtSEJsL6nqw4azTpF5Sm6SAvwUeAr7JY924Ebqq8EdA==",
       "dependencies": {
         "prop-types": "^15.7.2"
       },
@@ -19413,11 +19232,11 @@
       }
     },
     "node_modules/react-router": {
-      "version": "6.22.1",
-      "resolved": "https://registry.npmjs.org/react-router/-/react-router-6.22.1.tgz",
-      "integrity": "sha512-0pdoRGwLtemnJqn1K0XHUbnKiX0S4X8CgvVVmHGOWmofESj31msHo/1YiqcJWK7Wxfq2a4uvvtS01KAQyWK/CQ==",
+      "version": "6.22.2",
+      "resolved": "https://registry.npmjs.org/react-router/-/react-router-6.22.2.tgz",
+      "integrity": "sha512-YD3Dzprzpcq+tBMHBS822tCjnWD3iIZbTeSXMY9LPSG541EfoBGyZ3bS25KEnaZjLcmQpw2AVLkFyfgXY8uvcw==",
       "dependencies": {
-        "@remix-run/router": "1.15.1"
+        "@remix-run/router": "1.15.2"
       },
       "engines": {
         "node": ">=14.0.0"
@@ -19427,12 +19246,12 @@
       }
     },
     "node_modules/react-router-dom": {
-      "version": "6.22.1",
-      "resolved": "https://registry.npmjs.org/react-router-dom/-/react-router-dom-6.22.1.tgz",
-      "integrity": "sha512-iwMyyyrbL7zkKY7MRjOVRy+TMnS/OPusaFVxM2P11x9dzSzGmLsebkCvYirGq0DWB9K9hOspHYYtDz33gE5Duw==",
+      "version": "6.22.2",
+      "resolved": "https://registry.npmjs.org/react-router-dom/-/react-router-dom-6.22.2.tgz",
+      "integrity": "sha512-WgqxD2qySEIBPZ3w0sHH+PUAiamDeszls9tzqMPBDA1YYVucTBXLU7+gtRfcSnhe92A3glPnvSxK2dhNoAVOIQ==",
       "dependencies": {
-        "@remix-run/router": "1.15.1",
-        "react-router": "6.22.1"
+        "@remix-run/router": "1.15.2",
+        "react-router": "6.22.2"
       },
       "engines": {
         "node": ">=14.0.0"
@@ -19662,9 +19481,9 @@
       }
     },
     "node_modules/recharts": {
-      "version": "2.12.1",
-      "resolved": "https://registry.npmjs.org/recharts/-/recharts-2.12.1.tgz",
-      "integrity": "sha512-35vUCEBPf+pM+iVgSgVTn86faKya5pc4JO6cYJL63qOK2zDEyzDn20Tdj+CDI/3z+VcpKyQ8ZBQ9OiQ+vuAbjg==",
+      "version": "2.12.2",
+      "resolved": "https://registry.npmjs.org/recharts/-/recharts-2.12.2.tgz",
+      "integrity": "sha512-9bpxjXSF5g81YsKkTSlaX7mM4b6oYI1mIYck6YkUcWuL3tomADccI51/6thY4LmvhYuRTwpfrOvE80Zc3oBRfQ==",
       "dependencies": {
         "clsx": "^2.0.0",
         "eventemitter3": "^4.0.1",
@@ -22605,9 +22424,9 @@
       "integrity": "sha512-hEQt0+ZLDVUMhebKxL4x1BTtDY7bavVofhZ9KZ4aI26X9SRaE+Y3m83XUL1UP2jn8ynjndwCCpEHdUG+9pP1Tw=="
     },
     "node_modules/undici": {
-      "version": "5.26.5",
-      "resolved": "https://registry.npmjs.org/undici/-/undici-5.26.5.tgz",
-      "integrity": "sha512-cSb4bPFd5qgR7qr2jYAi0hlX9n5YKK2ONKkLFkxl+v/9BvC0sOpZjBHDBSXc5lWAf5ty9oZdRXytBIHzgUcerw==",
+      "version": "5.28.3",
+      "resolved": "https://registry.npmjs.org/undici/-/undici-5.28.3.tgz",
+      "integrity": "sha512-3ItfzbrhDlINjaP0duwnNsKpDQk3acHI3gVJ1z4fmwMK31k5G9OVIAMLSIaP6w4FaGkaAkN6zaQO9LUvZ1t7VA==",
       "dependencies": {
         "@fastify/busboy": "^2.0.0"
       },
@@ -24162,9 +23981,9 @@
       }
     },
     "node_modules/yauzl": {
-      "version": "3.1.0",
-      "resolved": "https://registry.npmjs.org/yauzl/-/yauzl-3.1.0.tgz",
-      "integrity": "sha512-zbff6SaAPyewVextulqeBjJm+1ZhS69vSN7cRpqVD7jMNSE9oXEdQ1SGF+ydfB+gKE2a3GiWfXf/pnwVZ1/tOA==",
+      "version": "3.1.1",
+      "resolved": "https://registry.npmjs.org/yauzl/-/yauzl-3.1.1.tgz",
+      "integrity": "sha512-MPxA7oN5cvGV0wzfkeHKF2/+Q4TkMpHSWGRy/96I4Cozljmx0ph91+Muxh6HegEtDC4GftJ8qYDE51vghFiEYA==",
       "dependencies": {
         "buffer-crc32": "~0.2.3",
         "pend": "~1.2.0"

client/package.json

@@ -13,8 +13,8 @@
     "@jsreport/browser-client": "^3.1.0",
     "@reduxjs/toolkit": "^2.2.1",
     "@sentry/cli": "^2.28.6",
-    "@sentry/react": "^7.102.1",
-    "@sentry/tracing": "^7.102.1",
+    "@sentry/react": "^7.104.0",
+    "@sentry/tracing": "^7.104.0",
     "@splitsoftware/splitio-react": "^1.11.0",
     "@tanem/react-nprogress": "^5.0.51",
     "antd": "^5.14.2",
@@ -29,7 +29,7 @@
     "enquire-js": "^0.2.1",
     "env-cmd": "^10.1.0",
     "exifr": "^7.1.3",
-    "firebase": "^10.8.0",
+    "firebase": "^10.8.1",
     "graphql": "^16.6.0",
     "i18next": "^23.10.0",
     "i18next-browser-languagedetector": "^7.0.2",
@@ -42,11 +42,11 @@
     "phone": "^3.1.42",
     "preval.macro": "^5.0.0",
     "prop-types": "^15.8.1",
-    "query-string": "^8.2.0",
+    "query-string": "^9.0.0",
     "rc-queue-anim": "^2.0.0",
     "rc-scroll-anim": "^2.7.6",
     "react": "^18.2.0",
-    "react-big-calendar": "^1.10.3",
+    "react-big-calendar": "^1.11.0",
     "react-color": "^2.19.3",
     "react-cookie": "^7.1.0",
     "react-dom": "^18.2.0",
@@ -58,15 +58,15 @@
     "react-image-lightbox": "^5.1.4",
     "react-intersection-observer": "^9.8.1",
     "react-markdown": "^9.0.1",
-    "react-number-format": "^5.1.4",
+    "react-number-format": "^5.3.3",
     "react-redux": "^9.1.0",
     "react-resizable": "^3.0.5",
-    "react-router-dom": "^6.22.1",
+    "react-router-dom": "^6.22.2",
     "react-scripts": "^5.0.1",
     "react-sticky": "^6.0.3",
     "react-sublime-video": "^0.2.5",
     "react-virtualized": "^9.22.5",
-    "recharts": "^2.12.1",
+    "recharts": "^2.12.2",
     "redux": "^5.0.1",
     "redux-persist": "^6.0.0",
     "redux-saga": "^1.3.0",
@@ -84,7 +84,7 @@
     "workbox-precaching": "^7.0.0",
     "workbox-routing": "^7.0.0",
     "workbox-strategies": "^7.0.0",
-    "yauzl": "^3.1.0"
+    "yauzl": "^3.1.1"
   },
   "scripts": {
     "analyze": "source-map-explorer 'build/static/js/*.js'",

client/src/components/accounting-payables-table/accounting-payables-table.component.jsx

@@ -1,21 +1,20 @@
-import {Card, Checkbox, Input, Space, Table} from "antd";
+import {Card, Checkbox, Input, Space, Table} from "antd";import queryString from "query-string";
 import React, {useState} from "react";
 import {useTranslation} from "react-i18next";
+import {connect } from "react-redux";
 import {Link} from "react-router-dom";
-import CurrencyFormatter from "../../utils/CurrencyFormatter";
-import {alphaSort, dateSort} from "../../utils/sorters";
-import PayableExportButton from "../payable-export-button/payable-export-button.component";
-import PayableExportAll from "../payable-export-all-button/payable-export-all-button.component";
-import {DateFormatter} from "../../utils/DateFormatter";
-import queryString from "query-string";
+import { createStructuredSelector } from "reselect";
 import {logImEXEvent} from "../../firebase/firebase.utils";
-import QboAuthorizeComponent from "../qbo-authorize/qbo-authorize.component";
-import {connect} from "react-redux";
-import {createStructuredSelector} from "reselect";
-import {selectBodyshop} from "../../redux/user/user.selectors";
+import { selectBodyshop } from "../../redux/user/user.selectors";
+import CurrencyFormatter from "../../utils/CurrencyFormatter";
+import {DateFormatter} from "../../utils/DateFormatter";
+import { pageLimit } from "../../utils/config";
+import {alphaSort, dateSort} from "../../utils/sorters";
 import ExportLogsCountDisplay from "../export-logs-count-display/export-logs-count-display.component";
+import PayableExportAll from "../payable-export-all-button/payable-export-all-button.component";
+import PayableExportButton from "../payable-export-button/payable-export-button.component";
 import BillMarkSelectedExported from "../payable-mark-selected-exported/payable-mark-selected-exported.component";
-import {pageLimit} from "../../utils/config";
+import QboAuthorizeComponent from "../qbo-authorize/qbo-authorize.component";
 
 const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
@@ -147,7 +146,7 @@ export function AccountingPayablesTableComponent({
             title: t("general.labels.actions"),
             dataIndex: "actions",
             key: "actions",
-            sorter: (a, b) => a.clm_total - b.clm_total,
+
 
             render: (text, record) => (
                 <PayableExportButton

client/src/components/accounting-payments-table/accounting-payments-table.component.jsx

@@ -8,14 +8,16 @@ import {logImEXEvent} from "../../firebase/firebase.utils";
 import {selectBodyshop} from "../../redux/user/user.selectors";
 import CurrencyFormatter from "../../utils/CurrencyFormatter";
 import {DateFormatter, DateTimeFormatter} from "../../utils/DateFormatter";
+import {pageLimit } from "../../utils/config";
 import {alphaSort, dateSort} from "../../utils/sorters";
 import ExportLogsCountDisplay from "../export-logs-count-display/export-logs-count-display.component";
-import OwnerNameDisplay from "../owner-name-display/owner-name-display.component";
+import OwnerNameDisplay, {
+  OwnerNameDisplayFunction,
+} from "../owner-name-display/owner-name-display.component";
 import PaymentExportButton from "../payment-export-button/payment-export-button.component";
 import PaymentMarkSelectedExported from "../payment-mark-selected-exported/payment-mark-selected-exported.component";
 import PaymentsExportAllButton from "../payments-export-all-button/payments-export-all-button.component";
 import QboAuthorizeComponent from "../qbo-authorize/qbo-authorize.component";
-import {pageLimit} from "../../utils/config";
 
 const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
@@ -75,7 +77,11 @@ export function AccountingPayablesTableComponent({
             dataIndex: "owner",
             key: "owner",
             ellipsis: true,
-            sorter: (a, b) => alphaSort(a.job.ownr_ln, b.job.ownr_ln),
+            sorter: (a, b) =>
+        alphaSort(
+          OwnerNameDisplayFunction(a.job),
+          OwnerNameDisplayFunction(b.job)
+        ),
             sortOrder:
                 state.sortedInfo.columnKey === "owner" && state.sortedInfo.order,
             render: (text, record) => {
@@ -94,7 +100,9 @@ export function AccountingPayablesTableComponent({
             title: t("payments.fields.amount"),
             dataIndex: "amount",
             key: "amount",
-            render: (text, record) => (
+            sorter: (a, b) => a.amount - b.amount,
+      sortOrder:
+        state.sortedInfo.columnKey === "amount" && state.sortedInfo.order,render: (text, record) => (
                 <CurrencyFormatter>{record.amount}</CurrencyFormatter>
             ),
         },
@@ -111,19 +119,21 @@ export function AccountingPayablesTableComponent({
         {
             title: t("payments.fields.created_at"),
             dataIndex: "created_at",
-            key: "created_at",
+            key: "created_at",sorter: (a, b) => dateSort(a.created_at, b.created_at),
+      sortOrder:
+        state.sortedInfo.columnKey === "created_at" && state.sortedInfo.order,
             render: (text, record) => (
                 <DateTimeFormatter>{record.created_at}</DateTimeFormatter>
             ),
         },
-        {
-            title: t("payments.fields.exportedat"),
-            dataIndex: "exportedat",
-            key: "exportedat",
-            render: (text, record) => (
-                <DateTimeFormatter>{record.exportedat}</DateTimeFormatter>
-            ),
-        },
+        //{
+          //  title: t("payments.fields.exportedat"),
+          //  dataIndex: "exportedat",
+          //  key: "exportedat",
+          //  render: (text, record) => (
+            //    <DateTimeFormatter>{record.exportedat}</DateTimeFormatter>
+          //  ),
+        //},
         {
             title: t("exportlogs.labels.attempts"),
             dataIndex: "attempts",
@@ -137,7 +147,7 @@ export function AccountingPayablesTableComponent({
             title: t("general.labels.actions"),
             dataIndex: "actions",
             key: "actions",
-            sorter: (a, b) => a.clm_total - b.clm_total,
+
 
             render: (text, record) => (
                 <PaymentExportButton

client/src/components/accounting-receivables-table/accounting-receivables-table.component.jsx

@@ -4,17 +4,19 @@ import {useTranslation} from "react-i18next";
 import {Link} from "react-router-dom";
 import {logImEXEvent} from "../../firebase/firebase.utils";
 import CurrencyFormatter from "../../utils/CurrencyFormatter";
-import {alphaSort, dateSort} from "../../utils/sorters";
+import {alphaSort, dateSort, statusSort } from "../../utils/sorters";
 import JobExportButton from "../jobs-close-export-button/jobs-close-export-button.component";
 import JobsExportAllButton from "../jobs-export-all-button/jobs-export-all-button.component";
 
 import {connect} from "react-redux";
 import {createStructuredSelector} from "reselect";
 import {selectBodyshop} from "../../redux/user/user.selectors";
-import QboAuthorizeComponent from "../qbo-authorize/qbo-authorize.component";
 import {DateFormatter} from "../../utils/DateFormatter";
-import OwnerNameDisplay from "../owner-name-display/owner-name-display.component";
 import ExportLogsCountDisplay from "../export-logs-count-display/export-logs-count-display.component";
+import OwnerNameDisplay, {
+  OwnerNameDisplayFunction,
+} from "../owner-name-display/owner-name-display.component";
+import QboAuthorizeComponent from "../qbo-authorize/qbo-authorize.component";
 
 const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
@@ -63,7 +65,7 @@ export function AccountingReceivablesTableComponent({
             title: t("jobs.fields.status"),
             dataIndex: "status",
             key: "status",
-            sorter: (a, b) => a.status - b.status,
+            sorter: (a, b) => statusSort(a, b, bodyshop.md_ro_statuses.statuses),
             sortOrder:
                 state.sortedInfo.columnKey === "status" && state.sortedInfo.order,
         },
@@ -83,7 +85,8 @@ export function AccountingReceivablesTableComponent({
             title: t("jobs.fields.owner"),
             dataIndex: "owner",
             key: "owner",
-            sorter: (a, b) => alphaSort(a.ownr_ln, b.ownr_ln),
+            sorter: (a, b) =>
+        alphaSort(OwnerNameDisplayFunction(a), OwnerNameDisplayFunction(b)),
             sortOrder:
                 state.sortedInfo.columnKey === "owner" && state.sortedInfo.order,
             render: (text, record) => {
@@ -103,7 +106,15 @@ export function AccountingReceivablesTableComponent({
             dataIndex: "vehicle",
             key: "vehicle",
             ellipsis: true,
-            render: (text, record) => {
+            sorter: (a, b) =>
+        alphaSort(
+          `${a.v_model_yr || ""} ${a.v_make_desc || ""} ${
+            a.v_model_desc || ""
+          }`,
+          `${b.v_model_yr || ""} ${b.v_make_desc || ""} ${b.v_model_desc || ""}`
+        ),
+      sortOrder:
+        state.sortedInfo.columnKey === "vehicle" && state.sortedInfo.order,render: (text, record) => {
                 return record.vehicleid ? (
                     <Link to={"/manage/vehicles/" + record.vehicleid}>
                         {`${record.v_model_yr || ""} ${record.v_make_desc || ""} ${

client/src/components/bill-delete-button/bill-delete-button.component.jsx

@@ -5,10 +5,22 @@ import React, {useState} from "react";
 import {useTranslation} from "react-i18next";
 import {DELETE_BILL} from "../../graphql/bills.queries";
 import RbacWrapper from "../rbac-wrapper/rbac-wrapper.component";
+import {insertAuditTrail} from "../../redux/application/application.actions";
+import AuditTrailMapping from "../../utils/AuditTrailMappings";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
 
-export default function BillDeleteButton({bill, callback}) {
+const mapStateToProps = createStructuredSelector({});
+const mapDispatchToProps = (dispatch) => ({
+    insertAuditTrail: ({ jobid, operation, type }) =>
+        dispatch(insertAuditTrail({ jobid, operation, type })),
+});
+
+export default connect(mapStateToProps, mapDispatchToProps)(BillDeleteButton);
+
+export function BillDeleteButton({ bill, jobid, callback, insertAuditTrail }) {
     const [loading, setLoading] = useState(false);
-    const {t} = useTranslation();
+    const { t } = useTranslation();
     const [deleteBill] = useMutation(DELETE_BILL);
 
     const handleDelete = async () => {
@@ -35,7 +47,12 @@ export default function BillDeleteButton({bill, callback}) {
         });
 
         if (!!!result.errors) {
-            notification["success"]({message: t("bills.successes.deleted")});
+            notification["success"]({ message: t("bills.successes.deleted") });
+            insertAuditTrail({
+                jobid: jobid,
+                operation: AuditTrailMapping.billdeleted(bill.invoice_number),
+            type: "billdeleted",
+      });
 
             if (callback && typeof callback === "function") callback(bill.id);
         } else {

client/src/components/bill-detail-edit/bill-detail-edit-component.jsx

@@ -30,8 +30,8 @@ const mapStateToProps = createStructuredSelector({
 const mapDispatchToProps = (dispatch) => ({
     setPartsOrderContext: (context) =>
         dispatch(setModalContext({context: context, modal: "partsOrder"})),
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export default connect(
@@ -145,7 +145,8 @@ export function BillDetailEditcontainer({setPartsOrderContext, insertAuditTrail,
             jobid: bill.jobid,
             billid: search.billid,
             operation: AuditTrailMapping.billupdated(bill.invoice_number),
-        });
+        type: "billupdated",
+    });
 
         await refetch();
         form.setFieldsValue(transformData(data));

client/src/components/bill-detail-edit/bill-detail-edit-return.component.jsx

@@ -16,8 +16,8 @@ const mapStateToProps = createStructuredSelector({
 const mapDispatchToProps = (dispatch) => ({
     setPartsOrderContext: (context) =>
         dispatch(setModalContext({context: context, modal: "partsOrder"})),
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export default connect(

client/src/components/bill-enter-modal/bill-enter-modal.container.jsx

@@ -31,8 +31,8 @@ const mapStateToProps = createStructuredSelector({
 });
 const mapDispatchToProps = (dispatch) => ({
     toggleModalVisible: () => dispatch(toggleModalVisible("billEnter")),
-    insertAuditTrail: ({jobid, billid, operation}) =>
-        dispatch(insertAuditTrail({jobid, billid, operation})),
+    insertAuditTrail: ({jobid, billid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, billid, operation, type })),
 });
 
 const Templates = TemplateList("job_special");
@@ -165,7 +165,7 @@ function BillEnterModalContainer({
                         mod_lbr_ty: key,
                         hours: adjustmentsToInsert[key].toFixed(1),
                     }),
-                });
+                type: "jobmodifylbradj",});
             });
 
             const jobUpdate = client.mutate({
@@ -314,7 +314,8 @@ function BillEnterModalContainer({
             operation: AuditTrailMapping.billposted(
                 r1.data.insert_bills.returning[0].invoice_number
             ),
-        });
+        type: "billposted",
+    });
 
         if (enterAgain) {
             form.resetFields();

client/src/components/bills-list-table/bills-list-table.component.jsx

@@ -50,17 +50,17 @@ export function BillsListTableComponent({
 
     const Templates = TemplateList("bill");
     const bills = billsQuery.data ? billsQuery.data.bills : [];
-    const {refetch} = billsQuery;
+    const { refetch } = billsQuery;
     const recordActions = (record, showView = false) => (
         <Space wrap>
             {showView && (
                 <Button onClick={() => handleOnRowClick(record)}>
-                    <EditFilled/>
+                    <EditFilled />
                 </Button>
             )}
-            <BillDeleteButton bill={record}/>
+            <BillDeleteButton bill={record} jobid={job.id} />
             <BillDetailEditReturnComponent
-                data={{bills_by_pk: {...record, jobid: job.id}}}
+                data={{ bills_by_pk: { ...record, jobid: job.id } }}
                 disabled={
                     record.is_credit_memo ||
                     record.vendorid === bodyshop.inhousevendorid ||

client/src/components/card-payment-modal/card-payment-modal.component..jsx

@@ -23,8 +23,8 @@ const mapStateToProps = createStructuredSelector({
 });
 
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type})),
     toggleModalVisible: () => dispatch(toggleModalVisible("cardPayment")),
 });
 
@@ -88,7 +88,7 @@ const CardPaymentModalComponent = ({
                 insertAuditTrail({
                     jobid: payment.jobid,
                     operation: AuditTrailMapping.failedpayment(),
-                })
+                type: "failedpayment",})
             );
         });
     };

client/src/components/courtesy-cars-list/courtesy-cars-list.component.jsx

@@ -1,22 +1,34 @@
-import {SyncOutlined, WarningFilled} from "@ant-design/icons";
-import {Button, Card, Dropdown, Input, Space, Table, Tooltip,} from "antd";
+import { SyncOutlined, WarningFilled } from "@ant-design/icons";
+import {
+    Button,
+    Card,
+    Dropdown,
+    Input,
+    Space,
+    Table,
+    Tooltip,
+} from "antd";
 import dayjs from "../../utils/day";
-import React, {useState} from "react";
-import {useTranslation} from "react-i18next";
-import {Link} from "react-router-dom";
-import {DateTimeFormatter} from "../../utils/DateFormatter";
-import {GenerateDocument} from "../../utils/RenderTemplate";
-import {TemplateList} from "../../utils/TemplateConstants";
-import {alphaSort} from "../../utils/sorters";
-import {OwnerNameDisplayFunction} from "../owner-name-display/owner-name-display.component";
+import React, { useState } from "react";
+import { useTranslation } from "react-i18next";
+import { Link } from "react-router-dom";
+import { DateTimeFormatter } from "../../utils/DateFormatter";
+import { GenerateDocument } from "../../utils/RenderTemplate";
+import { TemplateList } from "../../utils/TemplateConstants";
+import { alphaSort } from "../../utils/sorters";
+import useLocalStorage from "../../utils/useLocalStorage";
+import { OwnerNameDisplayFunction } from "../owner-name-display/owner-name-display.component";
 
-export default function CourtesyCarsList({loading, courtesycars, refetch}) {
+export default function CourtesyCarsList({ loading, courtesycars, refetch }) {
     const [state, setState] = useState({
         sortedInfo: {},
-        filteredInfo: {text: ""},
     });
     const [searchText, setSearchText] = useState("");
-    const {t} = useTranslation();
+    const [filter, setFilter] = useLocalStorage(
+        "filter_courtesy_cars_list",
+        null
+    );
+    const { t } = useTranslation();
 
     const columns = [
         {
@@ -42,6 +54,7 @@ export default function CourtesyCarsList({loading, courtesycars, refetch}) {
             dataIndex: "status",
             key: "status",
             sorter: (a, b) => alphaSort(a.status, b.status),
+            filteredValue: filter?.status || null,
             filters: [
                 {
                     text: t("courtesycars.status.in"),
@@ -64,7 +77,7 @@ export default function CourtesyCarsList({loading, courtesycars, refetch}) {
             sortOrder:
                 state.sortedInfo.columnKey === "status" && state.sortedInfo.order,
             render: (text, record) => {
-                const {nextservicedate, nextservicekm, mileage, insuranceexpires} =
+                const { nextservicedate, nextservicekm, mileage, insuranceexpires } =
                     record;
 
                 const mileageOver = nextservicekm ? nextservicekm <= mileage : false;
@@ -75,19 +88,23 @@ export default function CourtesyCarsList({loading, courtesycars, refetch}) {
                 const insuranceOver =
                     insuranceexpires &&
                     dayjs(insuranceexpires).endOf("day").isBefore(dayjs());
+
                 return (
                     <Space>
                         {t(record.status)}
                         {(mileageOver || dueForService || insuranceOver) && (
-                            <Tooltip title={(mileageOver || dueForService) && insuranceOver
-                                ? t("contracts.labels.insuranceexpired") +
-                                " / " +
-                                t("contracts.labels.cardueforservice")
-                                : insuranceOver
-                                    ? t("contracts.labels.insuranceexpired")
-                                    : t("contracts.labels.cardueforservice")
-                            }>
-                                <WarningFilled style={{color: "tomato"}}/>
+                            <Tooltip
+                                title={
+                                    (mileageOver || dueForService) && insuranceOver
+                                        ? t("contracts.labels.insuranceexpired") +
+                                        " / " +
+                                        t("contracts.labels.cardueforservice")
+                                        : insuranceOver
+                                            ? t("contracts.labels.insuranceexpired")
+                                            : t("contracts.labels.cardueforservice")
+                                }
+                            >
+                                <WarningFilled style={{ color: "tomato" }} />
                             </Tooltip>
                         )}
                     </Space>
@@ -99,6 +116,7 @@ export default function CourtesyCarsList({loading, courtesycars, refetch}) {
             dataIndex: "readiness",
             key: "readiness",
             sorter: (a, b) => alphaSort(a.readiness, b.readiness),
+            filteredValue: filter?.readiness || null,
             filters: [
                 {
                     text: t("courtesycars.readiness.ready"),
@@ -214,7 +232,8 @@ export default function CourtesyCarsList({loading, courtesycars, refetch}) {
     ];
 
     const handleTableChange = (pagination, filters, sorter) => {
-        setState({...state, filteredInfo: filters, sortedInfo: sorter});
+        setState({ ...state, sortedInfo: sorter });
+        setFilter(filters);
     };
 
     const tableData = searchText

client/src/components/dashboard-components/job-lifecycle/job-lifecycle-dashboard.component.jsx

@@ -0,0 +1,169 @@
+import {Card, Table, Tag} from "antd";
+import LoadingSkeleton from "../../loading-skeleton/loading-skeleton.component";
+import {useTranslation} from "react-i18next";
+import React, {useEffect, useState} from "react";
+import dayjs from '../../../utils/day';
+import DashboardRefreshRequired from "../refresh-required.component";
+import axios from "axios";
+
+const fortyFiveDaysAgo = () => dayjs().subtract(45, 'day').toLocaleString();
+
+export default function JobLifecycleDashboardComponent({data, bodyshop, ...cardProps}) {
+    const {t} = useTranslation();
+    const [loading, setLoading] = useState(false);
+    const [lifecycleData, setLifecycleData] = useState(null);
+
+    useEffect(() => {
+        async function getLifecycleData() {
+            if (data && data.job_lifecycle) {
+                setLoading(true);
+                const response = await axios.post("/job/lifecycle", {
+                    jobids: data.job_lifecycle.map(x => x.id),
+                    statuses: bodyshop.md_order_statuses
+                });
+                setLifecycleData(response.data.durations);
+                setLoading(false);
+            }
+        }
+
+        getLifecycleData().catch(e => {
+            console.error(`Error in getLifecycleData: ${e}`);
+        })
+    }, [data, bodyshop]);
+
+    const columns = [
+        {
+            title: t('job_lifecycle.columns.status'),
+            dataIndex: 'status',
+            bgColor: 'red',
+            key: 'status',
+            render: (text, record) => {
+                return <Tag color={record.color}>{record.status}</Tag>
+            }
+        },
+        {
+            title: t('job_lifecycle.columns.human_readable'),
+            dataIndex: 'humanReadable',
+            key: 'humanReadable',
+        },
+        {
+            title: t('job_lifecycle.columns.status_count'),
+            key: 'statusCount',
+            render: (text, record) => {
+                return lifecycleData.statusCounts[record.status];
+            }
+        },
+        {
+            title: t('job_lifecycle.columns.percentage'),
+            dataIndex: 'percentage',
+            key: 'percentage',
+            render: (text, record) => {
+                return record.percentage.toFixed(2) + '%';
+            }
+        },
+    ];
+
+    if (!data) return null;
+
+    if (!data.job_lifecycle || !lifecycleData) return <DashboardRefreshRequired {...cardProps} />;
+
+    const extra = `${t('job_lifecycle.content.calculated_based_on')} ${lifecycleData.jobs} ${t('job_lifecycle.content.jobs_in_since')} ${fortyFiveDaysAgo()}`
+
+    return (
+        <Card title={t("job_lifecycle.titles.dashboard")} {...cardProps}>
+            <LoadingSkeleton loading={loading}>
+                <div style={{overflow: 'scroll', height: "100%"}}>
+                    <div id="bar-container" style={{
+                        display: 'flex',
+                        width: '100%',
+                        height: '100px',
+                        textAlign: 'center',
+                        borderRadius: '5px',
+                        borderWidth: '5px',
+                        borderStyle: 'solid',
+                        borderColor: '#f0f2f5',
+                        margin: 0,
+                        padding: 0
+                    }}>
+                        {lifecycleData.summations.map((key, index, array) => {
+                            const isFirst = index === 0;
+                            const isLast = index === array.length - 1;
+                            return (
+                                <div key={key.status} style={{
+                                    overflow: 'hidden',
+                                    display: 'flex',
+                                    flexDirection: 'column',
+                                    justifyContent: 'center',
+                                    alignItems: 'center',
+                                    margin: 0,
+                                    padding: 0,
+
+                                    borderTop: '1px solid #f0f2f5',
+                                    borderBottom: '1px solid #f0f2f5',
+                                    borderLeft: isFirst ? '1px solid #f0f2f5' : undefined,
+                                    borderRight: isLast ? '1px solid #f0f2f5' : undefined,
+
+                                    backgroundColor: key.color,
+                                    width: `${key.percentage}%`
+                                }}
+                                     aria-label={`${key.status} | ${key.roundedPercentage} | ${key.humanReadable}`}
+                                     title={`${key.status} | ${key.roundedPercentage} | ${key.humanReadable}`}
+                                >
+
+                                    {key.percentage > 15 ?
+                                        <>
+                                            <div>{key.roundedPercentage}</div>
+                                            <div style={{
+                                                backgroundColor: '#f0f2f5',
+                                                borderRadius: '5px',
+                                                paddingRight: '2px',
+                                                paddingLeft: '2px',
+                                                fontSize: '0.8rem',
+                                            }}>
+                                                {key.status}
+                                            </div>
+                                        </>
+                                        : null}
+                                </div>
+                            );
+                        })}
+                    </div>
+                    <Card extra={extra} type='inner' title={t('job_lifecycle.content.legend_title')}
+                          style={{marginTop: '10px'}}>
+                        <div>
+                            {lifecycleData.summations.map((key) => (
+                                <Tag color={key.color} style={{width: '13vh', padding: '4px', margin: '4px'}}>
+                                    <div
+                                        aria-label={`${key.status} | ${key.roundedPercentage} | ${key.humanReadable}`}
+                                        title={`${key.status} | ${key.roundedPercentage} | ${key.humanReadable}`}
+                                        style={{
+                                            backgroundColor: '#f0f2f5',
+                                            color: '#000',
+                                            padding: '4px',
+                                            textAlign: 'center'
+                                        }}>
+                                        {key.status} [{lifecycleData.statusCounts[key.status]}] ({key.roundedPercentage})
+                                    </div>
+                                </Tag>
+                            ))}
+                        </div>
+                    </Card>
+                    <Card style={{marginTop: "5px"}} type='inner' title={t("job_lifecycle.titles.top_durations")}>
+                        <Table size="small" pagination={false} columns={columns}
+                               dataSource={lifecycleData.summations.sort((a, b) => b.value - a.value).slice(0, 3)}/>
+                    </Card>
+                </div>
+            </LoadingSkeleton>
+        </Card>
+    );
+}
+
+export const JobLifecycleDashboardGQL = `
+job_lifecycle: jobs(where: {
+    actual_in: {
+        _gte: "${dayjs().subtract(45, 'day').toISOString()}"
+    }
+}) {
+    id
+    actual_in
+} `;

client/src/components/dashboard-components/scheduled-in-today/scheduled-in-today.component.jsx

@@ -4,7 +4,7 @@ import {
   PauseCircleOutlined,
 } from "@ant-design/icons";
 import { Card, Space, Switch, Table, Tooltip, Typography } from "antd";
-import moment from "moment";
+import dayjs from "../../../utils/day";
 import React, { useState } from "react";
 import { useTranslation } from "react-i18next";
 import { Link } from "react-router-dom";
@@ -74,7 +74,7 @@ export default function DashboardScheduledInToday({ data, ...cardProps }) {
     }
   });
   appt.sort(function (a, b) {
-    return new moment(a.start) - new moment(b.start);
+    return  dayjs(a.start) -  dayjs(b.start);
   });
 
   const tvFontSize = 16;
@@ -419,7 +419,7 @@ export default function DashboardScheduledInToday({ data, ...cardProps }) {
   return (
     <Card
       title={t("dashboard.titles.scheduledindate", {
-        date: moment().startOf("day").format("MM/DD/YYYY"),
+        date: dayjs().startOf("day").format("MM/DD/YYYY"),
       })}
       extra={
         <Space>
@@ -449,9 +449,9 @@ export default function DashboardScheduledInToday({ data, ...cardProps }) {
 }
 
 export const DashboardScheduledInTodayGql = `
-  scheduled_in_today: appointments(where: {start: {_gte: "${moment()
+  scheduled_in_today: appointments(where: {start: {_gte: "${dayjs()
     .startOf("day")
-    .toISOString()}", _lte: "${moment()
+    .toISOString()}", _lte: "${dayjs()
   .endOf("day")
   .toISOString()}"}, canceled: {_eq: false}, block: {_neq: true}}) {
     canceled

client/src/components/dashboard-grid/dashboard-grid.component.jsx

@@ -42,6 +42,9 @@ import DashboardScheduledInToday, {
 import DashboardScheduledOutToday, {
     DashboardScheduledOutTodayGql,
 } from "../dashboard-components/scheduled-out-today/scheduled-out-today.component";
+import JobLifecycleDashboardComponent, {
+    JobLifecycleDashboardGQL
+} from "../dashboard-components/job-lifecycle/job-lifecycle-dashboard.component";
 import "./dashboard-grid.styles.scss";
 import {GenerateDashboardData} from "./dashboard-grid.utils";
 
@@ -260,6 +263,7 @@ const componentList = {
         w: 2,
         h: 2,
     },
+    // Typo in Efficency should be Efficiency, but changing it would reset users dashboard settings
     MonthlyEmployeeEfficency: {
         label: i18next.t("dashboard.titles.monthlyemployeeefficiency"),
         component: DashboardMonthlyEmployeeEfficiency,
@@ -287,6 +291,15 @@ const componentList = {
         w: 10,
         h: 3,
     },
+    JobLifecycle: {
+        label: i18next.t("dashboard.titles.joblifecycle"),
+        component: JobLifecycleDashboardComponent,
+        gqlFragment: JobLifecycleDashboardGQL,
+        minW: 6,
+        minH: 3,
+        w: 6,
+        h: 3,
+    },
 };
 
 const createDashboardQuery = (state) => {

client/src/components/job-at-change/schedule-event.container.jsx

@@ -53,7 +53,7 @@ export default function ScheduleEventContainer({bodyshop, event, refetch}) {
                     insertAuditTrail({
                         jobid: event.job.id,
                         operation: AuditTrailMapping.appointmentcancel(lost_sale_reason),
-                    })
+                    type: "appointmentcancel",})
                 );
             }
             if (!!jobUpdate.errors) {

client/src/components/job-checklist/components/job-checklist-form/job-checklist-form.component.jsx

@@ -28,8 +28,8 @@ const mapStateToProps = createStructuredSelector({
     currentUser: selectCurrentUser,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function JobChecklistForm({
@@ -183,7 +183,7 @@ export function JobChecklistForm({
                     (type === "intake" && bodyshop.md_ro_statuses.default_arrived) ||
                     (type === "deliver" && bodyshop.md_ro_statuses.default_delivered)
                 ),
-            });
+            type: "jobchecklist",});
         } else {
             notification["error"]({
                 message: t("checklist.errors.complete", {

client/src/components/job-detail-cards/job-detail-cards.totals.component.jsx

@@ -18,10 +18,8 @@ export default function JobDetailCardsTotalsComponent({loading, data}) {
                     />
                     <Statistic
                         className="imex-flex-row__margin-large"
-                        title={t("jobs.fields.ded_amt")}
-                        value={Dinero({
-                            amount: Math.round((data.ded_amt || 0) * 100),
-                        }).toFormat()}
+                        title={t("jobs.fields.customerowing")}
+                        value={Dinero(data.job_totals.totals.custPayable.total).toFormat()}
                     />
                     <Statistic
                         className="imex-flex-row__margin-large"

client/src/components/job-employee-assignments/job-employee-assignments.container.jsx

@@ -15,8 +15,8 @@ const mapStateToProps = createStructuredSelector({
     //currentUser: selectCurrentUser
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 export default connect(
     mapStateToProps,
@@ -47,7 +47,8 @@ export function JobEmployeeAssignmentsContainer({
         insertAuditTrail({
             jobid: job.id,
             operation: AuditTrailMapping.jobassignmentchange(operation, name),
-        });
+        type: "jobassignmentchange",
+    });
 
         if (!!result.errors) {
             notification["error"]({
@@ -77,7 +78,7 @@ export function JobEmployeeAssignmentsContainer({
         insertAuditTrail({
             jobid: job.id,
             operation: AuditTrailMapping.jobassignmentremoved(operation),
-        });
+        type: "jobassignmentremoved",});
         setLoading(false);
     };
 

client/src/components/job-line-convert-to-labor/job-line-convert-to-labor.component.jsx

@@ -17,8 +17,8 @@ const mapStateToProps = createStructuredSelector({
     //currentUser: selectCurrentUser
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 export default connect(
     mapStateToProps,
@@ -102,7 +102,7 @@ export function JobLineConvertToLabor({
                 hours: calculateAdjustment({mod_lbr_ty, job, jobline}).toFixed(1),
                 mod_lbr_ty,
             }),
-        });
+        type: "jobmodifylbradj",});
         setLoading(false);
         setVisibility(false);
     };

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

@@ -14,8 +14,8 @@ const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 export default connect(mapStateToProps, mapDispatchToProps)(JobsAdminStatus);
 
@@ -32,7 +32,7 @@ export function JobsAdminStatus({insertAuditTrail, bodyshop, job}) {
                 insertAuditTrail({
                     jobid: job.id,
                     operation: AuditTrailMapping.admin_jobstatuschange(status),
-                });
+                type: "admin_jobstatuschange",});
                 // refetch();
             })
             .catch((error) => {

client/src/components/jobs-admin-dates/jobs-admin-dates.component.jsx

@@ -20,8 +20,8 @@ const mapStateToProps = createStructuredSelector({
 });
 
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export default connect(
@@ -57,7 +57,7 @@ export function JobsAdminDatesChange({insertAuditTrail, job}) {
                         ? DateTimeFormat(changedAuditFields[key])
                         : changedAuditFields[key]
                 ),
-            });
+            type: "admin_jobfieldchange",});
         });
 
         if (!!!result.errors) {

client/src/components/jobs-admin-mark-reexport/jobs-admin-mark-reexport.component.jsx

@@ -24,8 +24,8 @@ const mapStateToProps = createStructuredSelector({
     currentUser: selectCurrentUser,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 export default connect(
     mapStateToProps,
@@ -60,7 +60,7 @@ export function JobAdminMarkReexport({
             insertAuditTrail({
                 jobid: job.id,
                 operation: AuditTrailMapping.admin_jobmarkforreexport(),
-            });
+            type: "admin_jobmarkforreexport",});
         } else {
             notification["error"]({
                 message: t("jobs.errors.saving", {
@@ -100,7 +100,7 @@ export function JobAdminMarkReexport({
             insertAuditTrail({
                 jobid: job.id,
                 operation: AuditTrailMapping.admin_jobmarkexported(),
-            });
+            type: "admin_jobmarkexported",});
         } else {
             notification["error"]({
                 message: t("jobs.errors.saving", {
@@ -125,7 +125,7 @@ export function JobAdminMarkReexport({
             insertAuditTrail({
                 jobid: job.id,
                 operation: AuditTrailMapping.admin_jobuninvoice(),
-            });
+            type: "admin_jobuninvoice",});
         } else {
             notification["error"]({
                 message: t("jobs.errors.saving", {

client/src/components/jobs-admin-remove-ar/jobs-admin-remove-ar.component.jsx

@@ -10,8 +10,8 @@ import AuditTrailMapping from "../../utils/AuditTrailMappings";
 
 const mapStateToProps = createStructuredSelector({});
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export default connect(mapStateToProps, mapDispatchToProps)(JobsAdminRemoveAR);
@@ -34,7 +34,7 @@ export function JobsAdminRemoveAR({insertAuditTrail, job}) {
             insertAuditTrail({
                 jobid: job.id,
                 operation: AuditTrailMapping.admin_job_remove_from_ar(value),
-            });
+            type: "admin_job_remove_from_ar",});
             setSwitchValue(value);
         } else {
             notification["error"]({

client/src/components/jobs-admin-unvoid/jobs-admin-unvoid.component.jsx

@@ -14,8 +14,8 @@ const mapStateToProps = createStructuredSelector({
     currentUser: selectCurrentUser,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 export default connect(mapStateToProps, mapDispatchToProps)(JobsAdminUnvoid);
 
@@ -46,6 +46,7 @@ export function JobsAdminUnvoid({
             insertAuditTrail({
                 jobid: job.id,
                 operation: AuditTrailMapping.admin_jobunvoid(),
+                type: "admin_jobunvoid",
             });
         } else {
             notification["error"]({

client/src/components/jobs-available-table/jobs-available-table.container.jsx

@@ -38,8 +38,8 @@ const mapStateToProps = createStructuredSelector({
     currentUser: selectCurrentUser,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+  insertAuditTrail: ({ jobid, operation, type }) =>
+    dispatch(insertAuditTrail({ jobid, operation, type })),
 });
 
 export function JobsAvailableContainer({bodyshop, currentUser, insertAuditTrail,}) {
@@ -177,10 +177,11 @@ export function JobsAvailableContainer({bodyshop, currentUser, insertAuditTrail,
             });
             //Job has been inserted. Clean up the available jobs record.
 
-            insertAuditTrail({
-                jobid: r.data.insert_jobs.returning[0].id,
-                operation: AuditTrailMapping.jobimported(),
-            });
+      insertAuditTrail({
+        jobid: r.data.insert_jobs.returning[0].id,
+        operation: AuditTrailMapping.jobimported(),
+        type: "jobimported",
+      });
 
             deleteJob({
                 variables: {id: estData.id},
@@ -325,24 +326,25 @@ export function JobsAvailableContainer({bodyshop, currentUser, insertAuditTrail,
                 setInsertLoading(false);
             });
 
-            await insertNote({
-                variables: {
-                    noteInput: [
-                        {
-                            jobid: selectedJob,
-                            created_by: currentUser.email,
-                            audit: true,
-                            text: t("jobs.labels.supplementnote"),
-                        },
-                    ],
-                },
-            });
-            insertAuditTrail({
-                jobid: selectedJob,
-                operation: AuditTrailMapping.jobsupplement(),
-            });
-        }
-    };
+      await insertNote({
+        variables: {
+          noteInput: [
+            {
+              jobid: selectedJob,
+              created_by: currentUser.email,
+              audit: true,
+              text: t("jobs.labels.supplementnote"),
+            },
+          ],
+        },
+      });
+      insertAuditTrail({
+        jobid: selectedJob,
+        operation: AuditTrailMapping.jobsupplement(),
+        type: "jobsupplement",
+      });
+    }
+  };
 
     const owner =
         estDataRaw.data &&

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

@@ -16,8 +16,8 @@ const mapStateToProps = createStructuredSelector({
     jobRO: selectJobReadOnly,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function JobsChangeStatus({job, bodyshop, jobRO, insertAuditTrail}) {
@@ -35,7 +35,7 @@ export function JobsChangeStatus({job, bodyshop, jobRO, insertAuditTrail}) {
                 insertAuditTrail({
                     jobid: job.id,
                     operation: AuditTrailMapping.jobstatuschange(status),
-                });
+                type: "jobstatuschange",});
                 // refetch();
             })
             .catch((error) => {

client/src/components/jobs-close-export-button/jobs-close-export-button.component.jsx

@@ -9,10 +9,12 @@ import {createStructuredSelector} from "reselect";
 import {auth, logImEXEvent} from "../../firebase/firebase.utils";
 import {INSERT_EXPORT_LOG} from "../../graphql/accounting.queries";
 import {UPDATE_JOB} from "../../graphql/jobs.queries";
+import { insertAuditTrail } from "../../redux/application/application.actions";
 import {
     selectBodyshop,
     selectCurrentUser,
 } from "../../redux/user/user.selectors";
+import AuditTrailMapping from "../../utils/AuditTrailMappings";
 import client from "../../utils/GraphQLClient";
 
 const mapStateToProps = createStructuredSelector({
@@ -20,6 +22,11 @@ const mapStateToProps = createStructuredSelector({
     currentUser: selectCurrentUser,
 });
 
+const mapDispatchToProps = (dispatch) => ({
+  insertAuditTrail: ({ jobid, operation, type }) =>
+    dispatch(insertAuditTrail({ jobid, operation, type })),
+});
+
 function updateJobCache(items) {
     client.cache.modify({
         id: "ROOT_QUERY",
@@ -40,9 +47,10 @@ export function JobsCloseExportButton({
                                           disabled,
                                           setSelectedJobs,
                                           refetch,
+                                          insertAuditTrail,
                                       }) {
     const history = useNavigate();
-    const {t} = useTranslation();
+    const { t } = useTranslation();
     const [updateJob] = useMutation(UPDATE_JOB);
     const [insertExportLog] = useMutation(INSERT_EXPORT_LOG);
     const [loading, setLoading] = useState(false);
@@ -181,6 +189,10 @@ export function JobsCloseExportButton({
                         key: "jobsuccessexport",
                         message: t("jobs.successes.exported"),
                     });
+                    insertAuditTrail({
+                        jobid: jobId,
+                        operation: AuditTrailMapping.jobexported(),
+                    type: "jobexported",});
                     updateJobCache(
                         jobUpdateResponse.data.update_jobs.returning.map((job) => job.id)
                     );
@@ -192,12 +204,20 @@ export function JobsCloseExportButton({
                     });
                 }
             }
-            if (bodyshop.accountingconfig && bodyshop.accountingconfig.qbo && successfulTransactions.length > 0) {
+            if (
+                bodyshop.accountingconfig &&
+                bodyshop.accountingconfig.qbo &&
+                successfulTransactions.length > 0
+            ) {
                 notification.open({
                     type: "success",
                     key: "jobsuccessexport",
                     message: t("jobs.successes.exported"),
                 });
+                insertAuditTrail({
+                    jobid: jobId,
+                    operation: AuditTrailMapping.jobexported(),type: "jobexported",
+                });
                 updateJobCache([
                     ...new Set(
                         successfulTransactions.map(
@@ -227,4 +247,7 @@ export function JobsCloseExportButton({
     );
 }
 
-export default connect(mapStateToProps, null)(JobsCloseExportButton);
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(JobsCloseExportButton);

client/src/components/jobs-convert-button/jobs-convert-button.component.jsx

@@ -17,8 +17,8 @@ const mapStateToProps = createStructuredSelector({
     jobRO: selectJobReadOnly,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function JobsConvertButton({
@@ -70,7 +70,8 @@ export function JobsConvertButton({
                 operation: AuditTrailMapping.jobconverted(
                     res.data.update_jobs.returning[0].ro_number
                 ),
-            });
+            type: "jobconverted",
+      });
 
             setOpen(false);
         }

client/src/components/jobs-detail-header-actions/jobs-detail-header-actions.addtoproduction.util.jsx

@@ -29,6 +29,7 @@ export default function AddToProduction(
                 insertAuditTrail({
                     jobid: jobId,
                     operation: AuditTrailMapping.jobinproductionchange(!remove),
+                    type: "jobinproductionchange",
                 })
             );
             if (completionCallback) completionCallback();
@@ -40,8 +41,4 @@ export default function AddToProduction(
                 }),
             });
         });
-
-    //insert the new job. call the callback with the returned ID when done.
-
-    return;
 }

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

@@ -48,8 +48,8 @@ const mapDispatchToProps = (dispatch) => ({
         dispatch(setModalContext({context: context, modal: "timeTicket"})),
     setCardPaymentContext: (context) =>
         dispatch(setModalContext({context: context, modal: "cardPayment"})),
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({ jobid, operation, type }) =>
+        dispatch(insertAuditTrail({ jobid, operation, type })),
     setEmailOptions: (e) => dispatch(setEmailOptions(e)),
     openChatByPhone: (phone) => dispatch(openChatByPhone(phone)),
     setMessage: (text) => dispatch(setMessage(text)),
@@ -237,6 +237,11 @@ export function JobsDetailHeaderActions({
                             message: JSON.stringify(result.errors),
                         }),
                     });
+                    insertAuditTrail({
+                        jobid: job.id,
+                        operation: AuditTrailMapping.jobvoid(),
+                        type: "jobvoid",
+                    });
                     return;
                 }
                 if (e.key === "email")
@@ -351,6 +356,11 @@ export function JobsDetailHeaderActions({
             notification["success"]({
                 message: t("jobs.successes.voided"),
             });
+            insertAuditTrail({
+                jobid: job.id,
+                operation: AuditTrailMapping.jobvoid(),
+                type: "jobvoid",
+            });
             //go back to jobs list.
             history(`/manage/`);
         } else {
@@ -467,9 +477,29 @@ export function JobsDetailHeaderActions({
                     ? !job.production_vars.alert
                     : true
             ),
+            type: "alertToggle",
         });
     };
 
+  const handleSuspend = (e) => {
+    logImEXEvent("production_toggle_alert");
+    //e.stopPropagation();
+    updateJob({
+      variables: {
+        jobId: job.id,
+        job: {
+          suspended: !job.suspended,
+        },
+      },
+    });
+    insertAuditTrail({
+      jobid: job.id,
+      operation: AuditTrailMapping.jobsuspend(
+        !!job.suspended ? !job.suspended : true
+      ),
+      type: "jobsuspend",
+    });
+  };
 
     // Function to handle OK
     const handleCancelScheduleOK = async () => {
@@ -499,24 +529,12 @@ export function JobsDetailHeaderActions({
                 jobid: job.id,
                 operation:
                     AuditTrailMapping.appointmentcancel(lost_sale_reason),
+                type: "appointmentcancel",
             });
 
         }
     };
 
-    const handleSuspend = (e) => {
-        logImEXEvent("production_toggle_alert");
-        //e.stopPropagation();
-        updateJob({
-            variables: {
-                jobId: job.id,
-                job: {
-                    suspended: !job.suspended,
-                },
-            },
-        });
-    };
-
     const popOverContent = (
         <Card>
             <div>

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

@@ -1,5 +1,5 @@
 import {BranchesOutlined, ExclamationCircleFilled, PauseCircleOutlined, WarningFilled,} from "@ant-design/icons";
-import {Card, Col, Row, Space, Tag, Tooltip} from "antd";
+import {Card, Col, Divider, Row, Space, Tag, Tooltip} from "antd";
 import React, {useState} from "react";
 import {useTranslation} from "react-i18next";
 import {connect} from "react-redux";
@@ -22,6 +22,7 @@ import ProductionListColumnProductionNote
     from "../production-list-columns/production-list-columns.productionnote.component";
 import VehicleVinDisplay from "../vehicle-vin-display/vehicle-vin-display.component";
 import "./jobs-detail-header.styles.scss";
+import dayjs from "../../utils/day";
 
 const mapStateToProps = createStructuredSelector({
     jobRO: selectJobReadOnly,
@@ -58,6 +59,13 @@ export function JobsDetailHeader({job, bodyshop, disabled}) {
   ${job.v_make_desc || ""} 
   ${job.v_model_desc || ""}`.trim();
 
+    const bodyHrs = job.joblines
+        .filter((j) => j.mod_lbr_ty !== "LAR")
+        .reduce((acc, val) => acc + val.mod_lb_hrs, 0);
+    const refinishHrs = job.joblines
+        .filter((line) => line.mod_lbr_ty === "LAR")
+        .reduce((acc, val) => acc + val.mod_lb_hrs, 0);
+
     const ownerTitle = OwnerNameDisplayFunction(job).trim();
 
     return (
@@ -89,7 +97,9 @@ export function JobsDetailHeader({job, bodyshop, disabled}) {
                                 {job.status === bodyshop.md_ro_statuses.default_scheduled &&
                                 job.scheduled_in ? (
                                     <Tag>
-                                        <DateTimeFormatter>{job.scheduled_in}</DateTimeFormatter>
+                                        <Link to={`/manage/schedule?date=${dayjs(job.scheduled_in).format('YYYY-MM-DD')}`}>
+                                            <DateTimeFormatter>{job.scheduled_in}</DateTimeFormatter>
+                                        </Link>
                                     </Tag>
                                 ) : null}
                             </Space>
@@ -295,6 +305,11 @@ export function JobsDetailHeader({job, bodyshop, disabled}) {
                 >
                     <div>
                         <JobEmployeeAssignments job={job}/>
+                        <Divider style={{ margin: ".5rem" }} />
+                        <DataLabel label={t("jobs.labels.labor_hrs")}>
+                            {bodyHrs.toFixed(1)} / {refinishHrs.toFixed(1)} /{" "}
+                            {(bodyHrs + refinishHrs).toFixed(1)}
+                        </DataLabel>
                     </div>
                 </Card>
             </Col>

client/src/components/jobs-export-all-button/jobs-export-all-button.component.jsx

@@ -9,7 +9,12 @@ import {createStructuredSelector} from "reselect";
 import {auth, logImEXEvent} from "../../firebase/firebase.utils";
 import {INSERT_EXPORT_LOG} from "../../graphql/accounting.queries";
 import {UPDATE_JOBS} from "../../graphql/jobs.queries";
-import {selectBodyshop, selectCurrentUser,} from "../../redux/user/user.selectors";
+import { insertAuditTrail } from "../../redux/application/application.actions";
+import AuditTrailMapping from "../../utils/AuditTrailMappings";
+import {
+    selectBodyshop,
+    selectCurrentUser,
+} from "../../redux/user/user.selectors";
 import client from "../../utils/GraphQLClient";
 
 const mapStateToProps = createStructuredSelector({
@@ -17,6 +22,11 @@ const mapStateToProps = createStructuredSelector({
     currentUser: selectCurrentUser,
 });
 
+const mapDispatchToProps = (dispatch) => ({
+  insertAuditTrail: ({ jobid, operation, type }) =>
+    dispatch(insertAuditTrail({ jobid, operation, type })),
+});
+
 function updateJobCache(items) {
     client.cache.modify({
         id: "ROOT_QUERY",
@@ -38,8 +48,9 @@ export function JobsExportAllButton({
                                         loadingCallback,
                                         completedCallback,
                                         refetch,
+                                        insertAuditTrail,
                                     }) {
-    const {t} = useTranslation();
+    const { t } = useTranslation();
     const [updateJob] = useMutation(UPDATE_JOBS);
     const [insertExportLog] = useMutation(INSERT_EXPORT_LOG);
 
@@ -168,47 +179,66 @@ export function JobsExportAllButton({
                             },
                         });
 
-                        if (!!!jobUpdateResponse.errors) {
-                            notification.open({
-                                type: "success",
-                                key: "jobsuccessexport",
-                                message: t("jobs.successes.exported"),
-                            });
-                            updateJobCache(
-                                jobUpdateResponse.data.update_jobs.returning.map(
-                                    (job) => job.id
-                                )
-                            );
-                        } else {
-                            notification["error"]({
-                                message: t("jobs.errors.exporting", {
-                                    error: JSON.stringify(jobUpdateResponse.error),
-                                }),
-                            });
-                        }
-                    }
-                    if (bodyshop.accountingconfig && bodyshop.accountingconfig.qbo && successfulTransactions.length > 0) {
-                        notification.open({
-                            type: "success",
-                            key: "jobsuccessexport",
-                            message: t("jobs.successes.exported"),
-                        });
-                        updateJobCache([
-                            ...new Set(
-                                successfulTransactions.map(
-                                    (st) =>
-                                        st[
-                                            bodyshop.accountingconfig && bodyshop.accountingconfig.qbo
-                                                ? "jobid"
-                                                : "id"
-                                            ]
-                                )
-                            ),
-                        ]);
-                    }
-                }
-            })
-        );
+            if (!!!jobUpdateResponse.errors) {
+              notification.open({
+                type: "success",
+                key: "jobsuccessexport",
+                message: t("jobs.successes.exported"),
+              });
+              jobUpdateResponse.data.update_jobs.returning.forEach((job) => {
+                insertAuditTrail({
+                  jobid: job.id,
+                  operation: AuditTrailMapping.jobexported(),
+                  type: "jobexported",
+                });
+              });
+              updateJobCache(
+                jobUpdateResponse.data.update_jobs.returning.map(
+                  (job) => job.id
+                )
+              );
+            } else {
+              notification["error"]({
+                message: t("jobs.errors.exporting", {
+                  error: JSON.stringify(jobUpdateResponse.error),
+                }),
+              });
+            }
+          }
+          if (
+            bodyshop.accountingconfig &&
+            bodyshop.accountingconfig.qbo &&
+            successfulTransactions.length > 0
+          ) {
+            notification.open({
+              type: "success",
+              key: "jobsuccessexport",
+              message: t("jobs.successes.exported"),
+            });
+            const successfulTransactionsSet = [
+              ...new Set(
+                successfulTransactions.map(
+                  (st) =>
+                    st[
+                      bodyshop.accountingconfig && bodyshop.accountingconfig.qbo
+                        ? "jobid"
+                        : "id"
+                    ]
+                )
+              ),
+            ];
+            if (successfulTransactionsSet.length > 0) {
+              insertAuditTrail({
+                jobid: successfulTransactionsSet[0],
+                operation: AuditTrailMapping.jobexported(),
+                type: "jobexported",
+              });
+            }
+            updateJobCache(successfulTransactionsSet);
+          }
+        }
+      })
+    );
 
         if (!!completedCallback) completedCallback([]);
         if (!!loadingCallback) loadingCallback(false);
@@ -222,4 +252,7 @@ export function JobsExportAllButton({
     );
 }
 
-export default connect(mapStateToProps, null)(JobsExportAllButton);
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(JobsExportAllButton);

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

@@ -16,6 +16,7 @@ import useLocalStorage from "../../utils/useLocalStorage";
 import AlertComponent from "../alert/alert.component";
 import ChatOpenButton from "../chat-open-button/chat-open-button.component";
 import OwnerNameDisplay from "../owner-name-display/owner-name-display.component";
+import { OwnerNameDisplayFunction } from "./../owner-name-display/owner-name-display.component";
 
 const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
@@ -142,7 +143,8 @@ export function JobsList({bodyshop}) {
             ellipsis: true,
 
             responsive: ["md"],
-            sorter: (a, b) => alphaSort(a.ownr_ln, b.ownr_ln),
+            sorter: (a, b) =>
+        alphaSort(OwnerNameDisplayFunction(a), OwnerNameDisplayFunction(b)),
             sortOrder:
                 state.sortedInfo.columnKey === "owner" && state.sortedInfo.order,
             render: (text, record) => {
@@ -187,7 +189,8 @@ export function JobsList({bodyshop}) {
             key: "status",
             ellipsis: true,
 
-            sorter: (a, b) => alphaSort(a.status, b.status),
+            sorter: (a, b) =>
+        statusSort(a.status, b.status, bodyshop.md_ro_statuses.active_statuses),
             sortOrder:
                 state.sortedInfo.columnKey === "status" && state.sortedInfo.order,
             filteredValue: filter?.status || null,
@@ -218,7 +221,15 @@ export function JobsList({bodyshop}) {
             dataIndex: "vehicle",
             key: "vehicle",
             ellipsis: true,
-            render: (text, record) => {
+            sorter: (a, b) =>
+        alphaSort(
+          `${a.v_model_yr || ""} ${a.v_make_desc || ""} ${
+            a.v_model_desc || ""
+          }`,
+          `${b.v_model_yr || ""} ${b.v_make_desc || ""} ${b.v_model_desc || ""}`
+        ),
+      sortOrder:
+        state.sortedInfo.columnKey === "vehicle" && state.sortedInfo.order,render: (text, record) => {
                 return record.vehicleid ? (
                     <Link
                         to={"/manage/vehicles/" + record.vehicleid}
@@ -265,7 +276,9 @@ export function JobsList({bodyshop}) {
             dataIndex: "ins_co_nm",
             key: "ins_co_nm",
             ellipsis: true,
-            filteredValue: filter?.ins_co_nm || null,
+            sorter: (a, b) => alphaSort(a.ins_co_nm, b.ins_co_nm),
+      sortOrder:
+        state.sortedInfo.columnKey === "ins_co_nm" && state.sortedInfo.order,filteredValue: filter?.ins_co_nm || null,
             filters:
                 (jobs &&
                     jobs
@@ -301,7 +314,13 @@ export function JobsList({bodyshop}) {
             dataIndex: "jobs.labels.estimator",
             key: "jobs.labels.estimator",
             ellipsis: true,
-            responsive: ["xl"],
+            responsive: ["xl"],sorter: (a, b) =>
+        alphaSort(
+          `${a.est_ct_fn || ""} ${a.est_ct_ln || ""}`.trim(),
+          `${b.est_ct_fn || ""} ${b.est_ct_ln || ""}`.trim()
+        ),
+      sortOrder:
+        state.sortedInfo.columnKey === "estimator" && state.sortedInfo.order,
             filterSearch: true,
             filteredValue: filter?.estimator || null,
             filters:

client/src/components/jobs-notes/jobs-notes.container.jsx

@@ -16,8 +16,8 @@ const mapStateToProps = createStructuredSelector({
     //currentUser: selectCurrentUser
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 export default connect(mapStateToProps, mapDispatchToProps)(JobNotesContainer);
 
@@ -46,7 +46,7 @@ export function JobNotesContainer({jobId, insertAuditTrail}) {
             insertAuditTrail({
                 jobid: jobId,
                 operation: AuditTrailMapping.jobnotedeleted(),
-            });
+            type: "jobnotedeleted",});
         });
         setDeleteLoading(false);
     };

client/src/components/labor-allocations-adjustment-edit/labor-allocations-adjustment-edit.component.jsx

@@ -21,8 +21,8 @@ const mapStateToProps = createStructuredSelector({
     //currentUser: selectCurrentUser
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 export default connect(
     mapStateToProps,
@@ -77,7 +77,7 @@ export function LaborAllocationsAdjustmentEdit({
                         values.hours -
                         ((adjustments && adjustments[mod_lbr_ty]) || 0).toFixed(1),
                 }),
-            });
+            type: "jobmodifylbradj",});
         }
         setLoading(false);
         setOpen(false);

client/src/components/note-upsert-modal/note-upsert-modal.container.jsx

@@ -19,8 +19,8 @@ const mapStateToProps = createStructuredSelector({
 });
 const mapDispatchToProps = (dispatch) => ({
     toggleModalVisible: () => dispatch(toggleModalVisible("noteUpsert")),
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function NoteUpsertModalContainer({
@@ -70,7 +70,7 @@ export function NoteUpsertModalContainer({
                 insertAuditTrail({
                     jobid: context.jobId,
                     operation: AuditTrailMapping.jobnoteupdated(),
-                });
+                type: "jobnoteupdated",});
             });
             if (refetch) refetch();
             toggleModalVisible();
@@ -102,7 +102,7 @@ export function NoteUpsertModalContainer({
                     insertAuditTrail({
                         jobid: newJobId,
                         operation: AuditTrailMapping.jobnoteadded(),
-                    });
+                    type: "jobnoteadded",});
                 });
             }
 
@@ -115,7 +115,7 @@ export function NoteUpsertModalContainer({
             insertAuditTrail({
                 jobid: context.jobId,
                 operation: AuditTrailMapping.jobnoteadded(),
-            });
+            type: "jobnoteadded",});
         }
     };
 

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

@@ -44,6 +44,15 @@ function OwnerDetailJobsComponent({bodyshop, owner}) {
             title: t("jobs.fields.vehicle"),
             dataIndex: "vehicleid",
             key: "vehicleid",
+            sorter: (a, b) =>
+                alphaSort(
+                    `${a.v_model_yr || ""} ${a.v_make_desc || ""} ${
+                        a.v_model_desc || ""
+                    }`,
+                    `${b.v_model_yr || ""} ${b.v_make_desc || ""} ${b.v_model_desc || ""}`
+                ),
+            sortOrder:
+                state.sortedInfo.columnKey === "vehicleid" && state.sortedInfo.order,
             render: (text, record) =>
                 record.vehicleid ? (
                     <Link to={`/manage/vehicles/${record.vehicleid}`}>
@@ -67,9 +76,15 @@ function OwnerDetailJobsComponent({bodyshop, owner}) {
             title: t("jobs.fields.status"),
             dataIndex: "status",
             key: "status",
-            sorter: (a, b) => statusSort(a.status, b.status, bodyshop.md_ro_statuses.statuses),
+            sorter: (a, b) =>
+                statusSort(a.status, b.status, bodyshop.md_ro_statuses.statuses),
             sortOrder:
                 state.sortedInfo.columnKey === "status" && state.sortedInfo.order,
+            filters: bodyshop.md_ro_statuses.statuses.map((status) => ({
+                text: status,
+                value: status,
+            })),
+            onFilter: (value, record) => value.includes(record.status),
         },
 
         {

client/src/components/parts-order-modal/parts-order-modal.container.jsx

@@ -1,19 +1,28 @@
-import {useApolloClient, useMutation, useQuery} from "@apollo/client";
-import {Form, Modal, notification} from "antd";
-import dayjs from "../../utils/day";
-import React, {useEffect, useState} from "react";
-import {useTranslation} from "react-i18next";
-import {connect} from "react-redux";
-import {createStructuredSelector} from "reselect";
-import {auth, logImEXEvent} from "../../firebase/firebase.utils";
-import {UPDATE_JOB_LINE_STATUS} from "../../graphql/jobs-lines.queries";
-import {INSERT_NEW_PARTS_ORDERS, QUERY_PARTS_ORDER_OEC,} from "../../graphql/parts-orders.queries";
-import {QUERY_ALL_VENDORS_FOR_ORDER} from "../../graphql/vendors.queries";
-import {insertAuditTrail} from "../../redux/application/application.actions";
-import {setEmailOptions} from "../../redux/email/email.actions";
-import {setModalContext, toggleModalVisible,} from "../../redux/modals/modals.actions";
-import {selectPartsOrder} from "../../redux/modals/modals.selectors";
-import {selectBodyshop, selectCurrentUser,} from "../../redux/user/user.selectors";
+import { useMutation, useQuery, useApolloClient } from "@apollo/client";
+import { Form, Modal, notification } from "antd";
+import dayjs from '../../utils/day';
+import React, { useEffect, useState } from "react";
+import { useTranslation } from "react-i18next";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { logImEXEvent, auth } from "../../firebase/firebase.utils";
+import { UPDATE_JOB_LINE_STATUS } from "../../graphql/jobs-lines.queries";
+import {
+  INSERT_NEW_PARTS_ORDERS,
+  QUERY_PARTS_ORDER_OEC,
+} from "../../graphql/parts-orders.queries";
+import { QUERY_ALL_VENDORS_FOR_ORDER } from "../../graphql/vendors.queries";
+import { insertAuditTrail } from "../../redux/application/application.actions";
+import { setEmailOptions } from "../../redux/email/email.actions";
+import {
+  setModalContext,
+  toggleModalVisible,
+} from "../../redux/modals/modals.actions";
+import { selectPartsOrder } from "../../redux/modals/modals.selectors";
+import {
+  selectBodyshop,
+  selectCurrentUser,
+} from "../../redux/user/user.selectors";
 import AuditTrailMapping from "../../utils/AuditTrailMappings";
 import {GenerateDocument} from "../../utils/RenderTemplate";
 import {TemplateList} from "../../utils/TemplateConstants";
@@ -36,8 +45,8 @@ const mapDispatchToProps = (dispatch) => ({
     toggleModalVisible: () => dispatch(toggleModalVisible("partsOrder")),
     setBillEnterContext: (context) =>
         dispatch(setModalContext({context: context, modal: "billEnter"})),
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function PartsOrderModalContainer({
@@ -135,7 +144,8 @@ export function PartsOrderModalContainer({
                 : AuditTrailMapping.jobspartsorder(
                     insertResult.data.insert_parts_orders.returning[0].order_number
                 ),
-        });
+        type: isReturn ? "jobspartsreturn" : "jobspartsorder",
+    });
 
         const jobLinesResult = await updateJobLines({
             variables: {

client/src/components/parts-queue-list/parts-queue.list.component.jsx

@@ -100,8 +100,7 @@ export function PartsQueueListComponent({bodyshop}) {
     };
 
     const handleOnRowClick = (record) => {
-        if (record) {
-            if (record.id) {
+            if (record?.id) {
                 history({
                     search: queryString.stringify({
                         ...searchParams,
@@ -109,7 +108,6 @@ export function PartsQueueListComponent({bodyshop}) {
                     }),
                 });
             }
-        }
     };
     const columns = [
         {
@@ -354,7 +352,15 @@ export function PartsQueueListComponent({bodyshop}) {
                     },
                     selectedRowKeys: [selected],
                     type: "radio",
-                }}/>
+                }}
+                onRow={(record, rowIndex) => {
+                    return {
+                        onClick: (event) => {
+                            handleOnRowClick(record);
+                        },
+                    };
+                }}
+            />
         </Card>
     );
 }

client/src/components/payment-expanded-row/payment-expanded-row.component.jsx

@@ -59,8 +59,8 @@ const PaymentExpandedRowComponent = ({record, bodyshop}) => {
         await insertPayment({
             variables: {
                 paymentInput: {
-                    amount: -refund_response.data.amount,
-                    transactionid: payment_response.response.receiptelements.transid,
+                    amount: -refund_response?.data?.amount,
+                    transactionid: payment_response?.response?.receiptelements?.transid,
                     payer: record.payer,
                     type: "Refund",
                     jobid: payment_response.jobid,

client/src/components/phonebook-form/phonebook-form.component.jsx

@@ -2,14 +2,17 @@ import {Button, Form, Input, Space} from "antd";
 import {PageHeader} from "@ant-design/pro-layout";
 import React from "react";
 import {useTranslation} from "react-i18next";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import {
+  selectAuthLevel,
+  selectBodyshop,
+} from "../../redux/user/user.selectors";
 import FormFieldsChanged from "../form-fields-changed-alert/form-fields-changed-alert.component";
 import FormItemEmail from "../form-items-formatted/email-form-item.component";
 import PhoneFormItem, {PhoneItemFormatterValidation,} from "../form-items-formatted/phone-form-item.component";
 import LayoutFormRow from "../layout-form-row/layout-form-row.component";
 import {HasRbacAccess} from "../rbac-wrapper/rbac-wrapper.component";
-import {connect} from "react-redux";
-import {createStructuredSelector} from "reselect";
-import {selectAuthLevel, selectBodyshop,} from "../../redux/user/user.selectors";
 
 const mapStateToProps = createStructuredSelector({
     authLevel: selectAuthLevel,
@@ -43,13 +46,16 @@ export function PhonebookFormComponent({
     return (
         <div>
             <PageHeader
-                title={`${form.getFieldValue("firstname") || ""} ${
+                title={<Form.Item shouldUpdate>
+            {() =>`${form.getFieldValue("firstname") || ""} ${
                     form.getFieldValue("lastname") || ""
                 }${
                     form.getFieldValue("company")
                         ? ` - ${form.getFieldValue("company")}`
-                        : ""
-                }`}
+                        : ""}`
+            }
+          </Form.Item>
+                }
                 extra={
                     <Space>
                         <Button

client/src/components/production-board-kanban/production-board-kanban.component.jsx

@@ -31,8 +31,8 @@ const mapStateToProps = createStructuredSelector({
 });
 
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function ProductionBoardKanbanComponent({
@@ -135,7 +135,8 @@ export function ProductionBoardKanbanComponent({
         insertAuditTrail({
             jobid: card.id,
             operation: AuditTrailMapping.jobstatuschange(destination.toColumnId),
-        });
+        type: "jobstatuschange",
+    });
 
         if (update.errors) {
             notification["error"]({

client/src/components/production-list-columns/production-list-columns.add.component.jsx

@@ -27,6 +27,7 @@ export function ProductionColumnsComponent({
                                                bodyshop,
                                                data,
                                                tableState,
+                                                refetch,
                                            }) {
     const [columns, setColumns] = columnState;
     const {t} = useTranslation();
@@ -50,6 +51,7 @@ export function ProductionColumnsComponent({
         data,
         state: tableState,
         activeStatuses: bodyshop.md_ro_statuses.active_statuses,
+        refetch,
     });
 
     const menu = {

client/src/components/production-list-columns/production-list-columns.alert.component.jsx

@@ -13,8 +13,8 @@ import AuditTrailMapping from "../../utils/AuditTrailMappings";
 const mapStateToProps = createStructuredSelector({});
 
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function ProductionListColumnAlert({record, insertAuditTrail}) {
@@ -46,7 +46,7 @@ export function ProductionListColumnAlert({record, insertAuditTrail}) {
                     ? !record.production_vars.alert
                     : true
             ),
-        }).then(() => {
+        type: "alertToggle",}).then(() => {
             if (record.refetch) record.refetch();
         });
     };

client/src/components/production-list-columns/production-list-columns.data.js

@@ -1,7 +1,6 @@
 import {BranchesOutlined, PauseCircleOutlined} from "@ant-design/icons";
-import {Space, Tooltip} from "antd";
+import {Checkbox,Space, Tooltip} from "antd";
 import i18n from "i18next";
-import dayjs from "../../utils/day";
 import {Link} from "react-router-dom";
 import CurrencyFormatter from "../../utils/CurrencyFormatter";
 import {TimeFormatter} from "../../utils/DateFormatter";
@@ -10,7 +9,9 @@ import {onlyUnique} from "../../utils/arrayHelper";
 import {alphaSort, dateSort, statusSort} from "../../utils/sorters";
 import JobAltTransportChange from "../job-at-change/job-at-change.component";
 import JobPartsQueueCount from "../job-parts-queue-count/job-parts-queue-count.component";
-import OwnerNameDisplay from "../owner-name-display/owner-name-display.component";
+import OwnerNameDisplay, {
+  OwnerNameDisplayFunction,
+} from "../owner-name-display/owner-name-display.component";
 import ProductionSubletsManageComponent from "../production-sublets-manage/production-sublets-manage.component";
 import ProductionListColumnAlert from "./production-list-columns.alert.component";
 import ProductionListColumnBodyPriority from "./production-list-columns.bodypriority.component";
@@ -26,7 +27,7 @@ import ProductionListColumnCategory from "./production-list-columns.status.categ
 import ProductionListColumnStatus from "./production-list-columns.status.component";
 import ProductionlistColumnTouchTime from "./prodution-list-columns.touchtime.component";
 
-const r = ({technician, state, activeStatuses, data, bodyshop}) => {
+const r = ({technician, state, activeStatuses, data, bodyshop, refetch}) => {
     return [
         {
             title: i18n.t("jobs.actions.viewdetail"),
@@ -84,7 +85,7 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
                         <OwnerNameDisplay ownerObject={record}/>
                     </Link>
                 ),
-            sorter: (a, b) => alphaSort(a.ownr_ln, b.ownr_ln),
+            sorter: (a, b) => alphaSort(OwnerNameDisplayFunction(a), OwnerNameDisplayFunction(b)),
             sortOrder:
                 state.sortedInfo.columnKey === "ownr" && state.sortedInfo.order,
         },
@@ -95,8 +96,10 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
             ellipsis: true,
             sorter: (a, b) =>
                 alphaSort(
-                    a.v_make_desc + a.v_model_desc,
-                    b.v_make_desc + b.v_model_desc
+                    `${a.v_model_yr || ""} ${a.v_make_desc || ""} ${
+            a.v_model_desc || ""
+                    }`,
+          `${b.v_model_yr || ""} ${b.v_make_desc || ""} ${b.v_model_desc || ""}`
                 ),
             sortOrder:
                 state.sortedInfo.columnKey === "vehicle" && state.sortedInfo.order,
@@ -185,17 +188,12 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
                 state.sortedInfo.columnKey === "date_next_contact" &&
                 state.sortedInfo.order,
             render: (text, record) => (
-                <span
-                    style={{
-                        color:
-                            record.date_next_contact &&
-                            dayjs(record.date_next_contact).isBefore(dayjs())
-                                ? "red"
-                                : "",
-                    }}
-                >
-          <ProductionListDate record={record} field="date_next_contact" time/>
-        </span>
+                <ProductionListDate
+                    record={record}
+                    field="date_next_contact"
+                    pastIndicator
+                    time
+                />
             ),
         },
         {
@@ -291,7 +289,21 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
             dataIndex: "special_coverage_policy",
             key: "special_coverage_policy",
             ellipsis: true,
-        },
+        sorter: (a, b) =>
+        Number(a.special_coverage_policy) - Number(b.special_coverage_policy),
+      sortOrder:
+        state.sortedInfo.columnKey === "special_coverage_policy" &&
+        state.sortedInfo.order,
+      filters: [
+        { text: "True", value: true },
+        { text: "False", value: false },
+      ],
+      onFilter: (value, record) =>
+        value.includes(record.special_coverage_policy),
+      render: (text, record) => (
+        <Checkbox disabled checked={record.special_coverage_policy} />
+      ),
+    },
 
         {
             title: i18n.t("jobs.fields.alt_transport"),
@@ -302,7 +314,16 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
             sortOrder:
                 state.sortedInfo.columnKey === "alt_transport" &&
                 state.sortedInfo.order,
-            render: (text, record) => (
+            filters:
+        (bodyshop &&
+          bodyshop.appt_alt_transport.map((s) => {
+            return {
+              text: s,
+              value: [s],
+            };
+          })) ||
+        [],
+      onFilter: (value, record) => value.includes(record.alt_transport),render: (text, record) => (
                 <div>
                     {record.alt_transport}
                     <JobAltTransportChange job={record}/>
@@ -382,7 +403,11 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
             title: i18n.t("production.labels.alert"),
             dataIndex: "alert",
             key: "alert",
-
+      sorter: (a, b) =>
+        Number(a.production_vars?.alert || false) -
+        Number(b.production_vars?.alert || false),
+      sortOrder:
+        state.sortedInfo.columnKey === "alert" && state.sortedInfo.order,
             render: (text, record) => <ProductionListColumnAlert record={record}/>,
         },
         {
@@ -473,6 +498,7 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
                 ),
             render: (text, record) => (
                 <ProductionListEmployeeAssignment
+                    refetch={refetch}
                     record={record}
                     type="employee_body"
                 />
@@ -493,6 +519,7 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
             render: (text, record) => (
                 <ProductionListEmployeeAssignment
                     record={record}
+                    refetch={refetch}
                     type="employee_prep"
                 />
             ),
@@ -509,7 +536,7 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
                     bodyshop.employees?.find((e) => e.id === b.employee_csr)?.first_name
                 ),
             render: (text, record) => (
-                <ProductionListEmployeeAssignment record={record} type="employee_csr"/>
+                <ProductionListEmployeeAssignment  refetch={refetch} record={record} type="employee_csr"/>
             ),
         },
         {
@@ -529,6 +556,7 @@ const r = ({technician, state, activeStatuses, data, bodyshop}) => {
             render: (text, record) => (
                 <ProductionListEmployeeAssignment
                     record={record}
+                    refetch={refetch}
                     type="employee_refinish"
                 />
             ),

client/src/components/production-list-columns/production-list-columns.empassignment.component.jsx

@@ -3,12 +3,12 @@ import {useMutation} from "@apollo/client";
 import {
     Button,
     Col,
-    notification,
+
     Popover,
     Row,
     Select,
     Space,
-    Spin,
+    Spin,notification,
 } from "antd";
 import React, {useState} from "react";
 import {useTranslation} from "react-i18next";
@@ -25,14 +25,15 @@ const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function ProductionListEmpAssignment({
                                                 insertAuditTrail,
                                                 bodyshop,
                                                 record,
+                                                refetch,
                                                 type,
                                             }) {
     const {t} = useTranslation();
@@ -55,7 +56,8 @@ export function ProductionListEmpAssignment({
         insertAuditTrail({
             jobid: record.id,
             operation: AuditTrailMapping.jobassignmentchange(empAssignment, name),
-        });
+        type: "jobassignmentchange",
+    });
 
         if (!!result.errors) {
             notification["error"]({
@@ -64,6 +66,9 @@ export function ProductionListEmpAssignment({
                 }),
             });
         }
+
+        await refetch();
+
         setLoading(false);
     };
     const handleRemove = async (operation) => {
@@ -80,7 +85,8 @@ export function ProductionListEmpAssignment({
         insertAuditTrail({
             jobid: record.id,
             operation: AuditTrailMapping.jobassignmentremoved(empAssignment),
-        });
+        type: "jobassignmentremoved",
+    });
 
         if (!!result.errors) {
             notification["error"]({
@@ -89,6 +95,9 @@ export function ProductionListEmpAssignment({
                 }),
             });
         }
+
+        await refetch();
+
         setLoading(false);
     };
 

client/src/components/production-list-columns/production-list-columns.status.category.jsx

@@ -12,8 +12,8 @@ const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function ProductionListColumnCategory({record, bodyshop}) {

client/src/components/production-list-columns/production-list-columns.status.component.jsx

@@ -5,16 +5,15 @@ import {connect} from "react-redux";
 import {createStructuredSelector} from "reselect";
 import {logImEXEvent} from "../../firebase/firebase.utils";
 import {UPDATE_JOB} from "../../graphql/jobs.queries";
-import {selectBodyshop} from "../../redux/user/user.selectors";
-import {insertAuditTrail} from "../../redux/application/application.actions";
+import {insertAuditTrail} from "../../redux/application/application.actions";import { selectBodyshop } from "../../redux/user/user.selectors";
 import AuditTrailMapping from "../../utils/AuditTrailMappings";
 
 const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
 });
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function ProductionListColumnStatus({
@@ -41,7 +40,8 @@ export function ProductionListColumnStatus({
         insertAuditTrail({
             jobid: record.id,
             operation: AuditTrailMapping.jobstatuschange(key),
-        });
+        type: "jobstatuschange",
+    });
 
         setLoading(false);
     };

client/src/components/production-list-table/production-list-table-view-select.component.jsx

@@ -18,6 +18,7 @@ const mapStateToProps = createStructuredSelector({
 });
 
 export function ProductionListTable({
+                                        refetch,
                                         bodyshop,
                                         technician,
                                         currentUser,
@@ -38,6 +39,7 @@ export function ProductionListTable({
                 return {
                     ...ProductionListColumns({
                         bodyshop,
+                        refetch,
                         technician,
                         state,
                         data: data,
@@ -95,6 +97,7 @@ export function ProductionListTable({
                     ...ProductionListColumns({
                         technician,
                         state,
+                        refetch,
                         data: data,
                         activeStatuses: bodyshop.md_ro_statuses.active_statuses,
                     }).find((e) => e.key === k.key),

client/src/components/production-list-table/production-list-table.component.jsx

@@ -64,6 +64,7 @@ export function ProductionListTable({loading, data, refetch, bodyshop, technicia
                 return {
                     ...ProductionListColumns({
                         bodyshop,
+                        refetch,
                         technician,
                         state,
                         data,
@@ -84,6 +85,7 @@ export function ProductionListTable({loading, data, refetch, bodyshop, technicia
                         ...ProductionListColumns({
                             bodyshop,
                             technician,
+                            refetch,
                             state,
                             data: data,
                             activeStatuses: bodyshop.md_ro_statuses.active_statuses,
@@ -262,6 +264,7 @@ export function ProductionListTable({loading, data, refetch, bodyshop, technicia
                             state={state}
                             setState={setState}
                             setColumns={setColumns}
+                            refetch={refetch}
                             data={data}
                         />
 

client/src/components/report-center-modal/report-center-modal-filters-sorters-component.jsx

@@ -6,7 +6,7 @@ import {useTranslation} from "react-i18next";
 import {getOrderOperatorsByType, getWhereOperatorsByType} from "../../utils/graphQLmodifier";
 import LoadingSkeleton from "../loading-skeleton/loading-skeleton.component";
 import {generateInternalReflections} from "./report-center-modal-utils";
-
+import {FormDatePicker} from "../form-date-picker/form-date-picker.component.jsx";
 
 export default function ReportCenterModalFiltersSortersComponent({form, bodyshop}) {
     return (
@@ -31,10 +31,9 @@ function FiltersSection({filters, form, bodyshop}) {
     const {t} = useTranslation();
 
     return (
-        <Card type='inner' title={t('reportcenter.labels.advanced_filters_filters')}
-                              style={{marginTop: '10px'}}>
+        <Card type='inner' title={t('reportcenter.labels.advanced_filters_filters')} style={{marginTop: '10px'}}>
             <Form.List name={["filters"]}>
-                {(fields, {add, remove, move}) => {
+                {(fields, {add, remove}) => {
                     return (
                         <div>
                             {fields.map((field, index) => (
@@ -72,7 +71,8 @@ function FiltersSection({filters, form, bodyshop}) {
                                         </Col>
                                         <Col span={6}>
                                             <Form.Item
-                                                                dependencies={[['filters', field.name, "field"]]}>
+                                                dependencies={[['filters', field.name, "field"],['filters', field.name, "value"]]}
+                                            >
                                                 {
                                                     () => {
                                                         const name = form.getFieldValue(['filters', field.name, "field"]);
@@ -82,7 +82,6 @@ function FiltersSection({filters, form, bodyshop}) {
                                                             key={`${index}operator`}
                                                             label={t('reportcenter.labels.advanced_filters_filter_operator')}
                                                             name={[field.name, "operator"]}
-                                                            dependencies={[]}
                                                             rules={[
                                                                 {
                                                                     required: true,
@@ -92,20 +91,32 @@ function FiltersSection({filters, form, bodyshop}) {
                                                         >
                                                             <Select
                                                                 getPopupContainer={trigger => trigger.parentNode}
-                                                                options={getWhereOperatorsByType(type)}/>
+                                                                options={   getWhereOperatorsByType(type)}
+                                                                onChange={() => {
+                                                                    // Clear related Fields
+
+                                                                    form.setFieldValue(['filters', field.name, 'value'], undefined);
+                                                                }}
+                                                            />
                                                         </Form.Item>
                                                     }
                                                 }
                                             </Form.Item>
                                         </Col>
                                         <Col span={6}>
-                                            <Form.Item
-                                                                dependencies={[['filters', field.name, "field"]]}>
+                                            <Form.Item dependencies={[
+                                                ['filters', field.name, "field"],
+                                                ['filters', field.name, "operator"]
+                                            ]}
+                                            >
                                                 {
                                                     () => {
+                                                        // Because it looks cleaner than inlining.
                                                         const name = form.getFieldValue(['filters', field.name, "field"]);
                                                         const type = filters.find(f => f.name === name)?.type;
                                                         const reflector = filters.find(f => f.name === name)?.reflector;
+                                                        const operator = form.getFieldValue(['filters', field.name, "operator"]);
+                                                        const operatorType = operator ? getWhereOperatorsByType(type).find((o) => o.value === operator)?.type : null;
 
                                                         return <Form.Item
                                                             key={`${index}value`}
@@ -131,14 +142,29 @@ function FiltersSection({filters, form, bodyshop}) {
                                                                         return generateInternalReflections({
                                                                             bodyshop,
                                                                             upperPath,
-                                                                            finalPath
+                                                                            finalPath,
+                                                                            t
                                                                         });
                                                                     };
 
                                                                     const reflections = reflector ? generateReflections(reflector) : [];
                                                                     const fieldPath = [[field.name, "value"]];
-
+                                                                    // We have reflections so we will use a select box
                                                                     if (reflections.length > 0) {
+                                                                        // We have reflections and the operator type is array, so we will use a select box with multiple options
+                                                                        if (operatorType === "array") {
+                                                                            return (
+                                                                                <Select
+                                                                                    disabled={!operator}
+                                                                                    mode="multiple"
+                                                                                    options={reflections}
+                                                                                    getPopupContainer={trigger => trigger.parentNode}
+                                                                                    onChange={(value) => {
+                                                                                        form.setFieldValue(fieldPath, value);
+                                                                                    }}
+                                                                                />
+                                                                            );
+                                                                        }
                                                                         return (
                                                                             <Select
                                                                                 options={reflections}
@@ -150,16 +176,50 @@ function FiltersSection({filters, form, bodyshop}) {
                                                                         );
                                                                     }
 
+                                                                    // We have a type of number, so we will use a number input
                                                                     if (type === "number") {
                                                                         return (
                                                                             <InputNumber
+                                                                                disabled={!operator}
                                                                                 onChange={(value) => form.setFieldValue(fieldPath, value)}/>
                                                                         );
                                                                     }
 
+                                                                    // We have a type of date, so we will use a date picker
+                                                                    if (type === "date") {
+                                                                        return (
+                                                                            <FormDatePicker
+                                                                                disabled={!operator}
+                                                                                onChange={(date) => form.setFieldValue(fieldPath, date)}
+                                                                            />
+                                                                        );
+                                                                    }
+
+                                                                    // we have a type of boolean, so we will use a select box with a true or false option.
+                                                                    if (type === "boolean" || type === "bool") {
+                                                                        return (
+                                                                            <Select
+                                                                                disabled={!operator}
+                                                                                getPopupContainer={trigger => trigger.parentNode}
+                                                                                options={[
+                                                                                    {
+                                                                                        label: t('reportcenter.labels.advanced_filters_true'),
+                                                                                        value: true
+                                                                                    },
+                                                                                    {
+                                                                                        label: t('reportcenter.labels.advanced_filters_false'),
+                                                                                        value: false
+                                                                                    }
+                                                                                ]}
+                                                                                onChange={(value) => form.setFieldValue(fieldPath, value)}
+                                                                            />
+                                                                        );
+                                                                    }
                                                                     return (
                                                                         <Input
-                                                                            onChange={(e) => form.setFieldValue(fieldPath, e.target.value)}/>
+                                                                            disabled={!operator}
+                                                                            onChange={(e) => form.setFieldValue(fieldPath, e.target.value)}
+                                                                        />
                                                                     );
                                                                 })()
                                                             }
@@ -206,13 +266,12 @@ function FiltersSection({filters, form, bodyshop}) {
  * @returns {JSX.Element}
  * @constructor
  */
-function SortersSection({sorters, form}) {
+function SortersSection({sorters}) {
     const {t} = useTranslation();
     return (
-        <Card type='inner' title={t('reportcenter.labels.advanced_filters_sorters')}
-                              style={{marginTop: '10px'}}>
+        <Card type='inner' title={t('reportcenter.labels.advanced_filters_sorters')} style={{marginTop: '10px'}}>
             <Form.List name={["sorters"]}>
-                {(fields, {add, remove, move}) => {
+                {(fields, {add, remove}) => {
                     return (
                         <div>
                             Sorters

client/src/components/report-center-modal/report-center-modal-utils.js

@@ -8,6 +8,20 @@ import {uniqBy} from "lodash";
  */
 const getValueFromPath = (obj, path) => path.split('.').reduce((prev, curr) => prev?.[curr], obj);
 
+/**
+ * Generate options from array
+ * @param bodyshop
+ * @param path
+ * @returns {unknown[]}
+ */
+const generateOptionsFromArray = (bodyshop, path) => {
+    const options = getValueFromPath(bodyshop, path);
+    return uniqBy(options.map((value) => ({
+        label: value,
+        value: value,
+    })), 'value');
+}
+
 /**
  * Valid internal reflections
  * Note: This is intended for future functionality
@@ -42,19 +56,44 @@ const generateOptionsFromObject = (bodyshop, path, labelPath, valuePath) => {
  * Generate special reflections
  * @param bodyshop
  * @param finalPath
+ * @param t - i18n
  * @returns {{label: *, value: *}[]|{label: *, value: *}[]|{label: string, value: *}[]|*[]}
  */
-const generateSpecialReflections = (bodyshop, finalPath) => {
+const generateSpecialReflections = (bodyshop, finalPath, t) => {
     switch (finalPath) {
+        case 'payment_payers':
+            return [
+                {
+                    label: t("payments.labels.customer"),
+                    value: t("payments.labels.customer"),
+                },
+                {
+                    label: t("payments.labels.insurance"),
+                    value: t("payments.labels.insurance"),
+                },
+                // This is a weird one supposedly only used by one shop and could potentially be
+                // placed behind a SplitSDK
+                {
+                    label: t("payments.labels.external"),
+                    value: t("payments.labels.external"),
+                }
+            ];
+        case 'payment_types':
+            return generateOptionsFromArray(bodyshop, 'md_payment_types');
+        case 'alt_transports':
+            return generateOptionsFromArray(bodyshop, 'appt_alt_transport');
+        case 'lost_sale_reasons':
+            return generateOptionsFromArray(bodyshop, 'md_lost_sale_reasons');
+        // Special case because Referral Sources is an Array, not an Object.
+        case 'referral_source':
+            return generateOptionsFromArray(bodyshop, 'md_referral_sources');
+        case 'class':
+            return generateOptionsFromArray(bodyshop, 'md_classes');
         case 'cost_centers':
             return generateOptionsFromObject(bodyshop, 'md_responsibility_centers.costs', 'name', 'name');
         // Special case because Categories is an Array, not an Object.
         case 'categories':
-            const catOptions = getValueFromPath(bodyshop, 'md_categories');
-            return uniqBy(catOptions.map((value) => ({
-                label: value,
-                value: value,
-            })), 'value');
+            return generateOptionsFromArray(bodyshop, 'md_categories');
         case 'insurance_companies':
             return generateOptionsFromObject(bodyshop, 'md_ins_cos', 'name', 'name');
         case 'employee_teams':
@@ -105,12 +144,13 @@ const generateBodyshopReflections = (bodyshop, finalPath) => {
  * @param bodyshop
  * @param upperPath
  * @param finalPath
+ * @param t - i18n
  * @returns {{label: *, value: *}[]|[]|{label: *, value: *}[]|{label: string, value: *}[]|{label: *, value: *}[]|*[]}
  */
-const generateInternalReflections = ({bodyshop, upperPath, finalPath}) => {
+const generateInternalReflections = ({bodyshop, upperPath, finalPath, t}) => {
     switch (upperPath) {
         case 'special':
-            return generateSpecialReflections(bodyshop, finalPath);
+            return generateSpecialReflections(bodyshop, finalPath, t);
         case 'bodyshop':
             return generateBodyshopReflections(bodyshop, finalPath);
         default:
@@ -118,4 +158,4 @@ const generateInternalReflections = ({bodyshop, upperPath, finalPath}) => {
     }
 };
 
-export {generateInternalReflections,}
+export {generateInternalReflections}

client/src/components/schedule-job-modal/schedule-job-modal.container.jsx

@@ -30,8 +30,8 @@ const mapStateToProps = createStructuredSelector({
 const mapDispatchToProps = (dispatch) => ({
     toggleModalVisible: () => dispatch(toggleModalVisible("schedule")),
     setEmailOptions: (e) => dispatch(setEmailOptions(e)),
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function ScheduleJobModalContainer({
@@ -142,7 +142,7 @@ export function ScheduleJobModalContainer({
                 operation: AuditTrailMapping.appointmentinsert(
                     DateTimeFormat(values.start)
                 ),
-            });
+            type: "appointmentinsert",});
         }
 
         if (!!appt.errors) {

client/src/components/scoreboard-day-stats/scoreboard-day-stats.component.jsx

@@ -26,6 +26,8 @@ export function ScoreboardDayStats({bodyshop, date, entries}) {
         return acc + value.bodyhrs;
     }, 0);
 
+    const numJobs = entries.length;
+
     return (
         <Card
             title={dayjs(date).format("D - ddd")}
@@ -34,17 +36,18 @@ export function ScoreboardDayStats({bodyshop, date, entries}) {
         >
             <Statistic
                 valueStyle={{color: dailyBodyTarget > bodyHrs ? "red" : "green"}}
-                label="B"
+                label="Body"
                 value={bodyHrs.toFixed(1)}
             />
             <Statistic
                 valueStyle={{color: dailyPaintTarget > paintHrs ? "red" : "green"}}
-                label="P"
+                label="Refinish"
                 value={paintHrs.toFixed(1)}
             />
             <Divider style={{margin: 0}}/>
-
-            <Statistic value={(bodyHrs + paintHrs).toFixed(1)}/>
+            <Statistic label="Total" value={(bodyHrs + paintHrs).toFixed(1)}/>
+            <Divider style={{ margin: 0 }} />
+            <Statistic label="Jobs" value={numJobs} />
         </Card>
     );
 }

client/src/components/scoreboard-targets-table/scoreboard-targets-table.component.jsx

@@ -26,227 +26,260 @@ export function ScoreboardTargetsTable({bodyshop, scoreBoardlist}) {
     const values = useMemo(() => {
         const dateHash = _.groupBy(scoreBoardlist, "date");
 
-        let ret = {
-            todayBody: 0,
-            todayPaint: 0,
-            weeklyPaint: 0,
-            weeklyBody: 0,
-            toDateBody: 0,
-            toDatePaint: 0,
-        };
+    let ret = {
+      todayBody: 0,
+      todayPaint: 0,
+      todayJobs: 0,
+      weeklyPaint: 0,
+      weeklyJobs: 0,
+      weeklyBody: 0,
+      toDateBody: 0,
+      toDatePaint: 0,
+      toDateJobs: 0,
+    };
 
-        const today = dayjs();
-        if (dateHash[today.format("YYYY-MM-DD")]) {
-            dateHash[today.format("YYYY-MM-DD")].forEach((d) => {
-                ret.todayBody = ret.todayBody + d.bodyhrs;
-                ret.todayPaint = ret.todayPaint + d.painthrs;
-            });
-        }
+    const today = dayjs();
+    if (dateHash[today.format("YYYY-MM-DD")]) {
+      dateHash[today.format("YYYY-MM-DD")].forEach((d) => {
+        ret.todayBody = ret.todayBody + d.bodyhrs;
+        ret.todayPaint = ret.todayPaint + d.painthrs;
+        ret.todayJobs++;
+      });
+    }
 
-        let StartOfWeek = dayjs().startOf("week");
-        while (StartOfWeek.isSameOrBefore(today)) {
-            if (dateHash[StartOfWeek.format("YYYY-MM-DD")]) {
-                dateHash[StartOfWeek.format("YYYY-MM-DD")].forEach((d) => {
-                    ret.weeklyBody = ret.weeklyBody + d.bodyhrs;
-                    ret.weeklyPaint = ret.weeklyPaint + d.painthrs;
-                });
-            }
-            StartOfWeek = StartOfWeek.add(1, "day");
-        }
+    let StartOfWeek = dayjs().startOf("week");
+    while (StartOfWeek.isSameOrBefore(today)) {
+      if (dateHash[StartOfWeek.format("YYYY-MM-DD")]) {
+        dateHash[StartOfWeek.format("YYYY-MM-DD")].forEach((d) => {
+          ret.weeklyBody = ret.weeklyBody + d.bodyhrs;
+          ret.weeklyPaint = ret.weeklyPaint + d.painthrs;
+          ret.weeklyJobs++;
+        });
+      }
+      StartOfWeek = StartOfWeek.add(1, "day");
+    }
 
-        let startOfMonth = dayjs().startOf("month");
-        while (startOfMonth.isSameOrBefore(today)) {
-            if (dateHash[startOfMonth.format("YYYY-MM-DD")]) {
-                dateHash[startOfMonth.format("YYYY-MM-DD")].forEach((d) => {
-                    ret.toDateBody = ret.toDateBody + d.bodyhrs;
-                    ret.toDatePaint = ret.toDatePaint + d.painthrs;
-                });
-            }
-            startOfMonth = startOfMonth.add(1, "day");
-        }
+    let startOfMonth = dayjs().startOf("month");
+    while (startOfMonth.isSameOrBefore(today)) {
+      if (dateHash[startOfMonth.format("YYYY-MM-DD")]) {
+        dateHash[startOfMonth.format("YYYY-MM-DD")].forEach((d) => {
+          ret.toDateBody = ret.toDateBody + d.bodyhrs;
+          ret.toDatePaint = ret.toDatePaint + d.painthrs;
+          ret.toDateJobs++;
+        });
+      }
+      startOfMonth = startOfMonth.add(1, "day");
+    }
 
         return ret;
     }, [scoreBoardlist]);
 
-    return (
-        <Card
-            title={t("scoreboard.labels.targets")}
-            extra={<ScoreboardJobsList scoreBoardlist={scoreBoardlist}/>}
-        >
-            <Row gutter={rowGutter}>
-                <Col xs={24} sm={{offset: 0, span: 4}} lg={{span: 4}}>
-                    <Statistic
-                        title={t("scoreboard.labels.workingdays")}
-                        value={Util.CalculateWorkingDaysThisMonth()}
-                        prefix={<CalendarOutlined/>}
-                    />
-                </Col>
-                <Col xs={24} sm={{offset: 0, span: 20}} lg={{offset: 0, span: 20}}>
-                    <Row>
-                        <Col {...statSpans}>
-                            <Statistic
-                                title={t("scoreboard.labels.dailytarget")}
-                                value={bodyshop.scoreboard_target.dailyBodyTarget}
-                                prefix="B"
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                title={t("scoreboard.labels.dailyactual")}
-                                value={values.todayBody.toFixed(1)}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                title={t("scoreboard.labels.weeklytarget")}
-                                value={Util.WeeklyTargetHrs(
-                                    bodyshop.scoreboard_target.dailyBodyTarget,
-                                    bodyshop
-                                )}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                title={t("scoreboard.labels.weeklyactual")}
-                                value={values.weeklyBody.toFixed(1)}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                title={t("scoreboard.labels.monthlytarget")}
-                                value={Util.MonthlyTargetHrs(
-                                    bodyshop.scoreboard_target.dailyBodyTarget,
-                                    bodyshop
-                                )}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                title={t("scoreboard.labels.asoftodaytarget")}
-                                value={Util.AsOfTodayTargetHrs(
-                                    bodyshop.scoreboard_target.dailyBodyTarget,
-                                    bodyshop
-                                )}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                title={t("scoreboard.labels.todateactual")}
-                                value={values.toDateBody.toFixed(1)}
-                            />
-                        </Col>
-                    </Row>
-                    <Row>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={bodyshop.scoreboard_target.dailyPaintTarget}
-                                prefix="P"
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic value={values.todayPaint.toFixed(1)}/>
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={Util.WeeklyTargetHrs(
-                                    bodyshop.scoreboard_target.dailyPaintTarget,
-                                    bodyshop
-                                )}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic value={values.weeklyPaint.toFixed(1)}/>
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={Util.MonthlyTargetHrs(
-                                    bodyshop.scoreboard_target.dailyPaintTarget,
-                                    bodyshop
-                                )}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={Util.AsOfTodayTargetHrs(
-                                    bodyshop.scoreboard_target.dailyPaintTarget,
-                                    bodyshop
-                                )}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic value={values.toDatePaint.toFixed(1)}/>
-                        </Col>
-                    </Row>
-                    <Row>
-                        <Divider style={{margin: 5}}/>
-                    </Row>
-                    <Row>
-                        <Col {...statSpans}></Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={(values.todayPaint + values.todayBody).toFixed(1)}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={(
-                                    Util.WeeklyTargetHrs(
-                                        bodyshop.scoreboard_target.dailyBodyTarget,
-                                        bodyshop
-                                    ) +
-                                    Util.WeeklyTargetHrs(
-                                        bodyshop.scoreboard_target.dailyPaintTarget,
-                                        bodyshop
-                                    )
-                                ).toFixed(1)}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={(values.weeklyPaint + values.weeklyBody).toFixed(1)}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={(
-                                    Util.MonthlyTargetHrs(
-                                        bodyshop.scoreboard_target.dailyBodyTarget,
-                                        bodyshop
-                                    ) +
-                                    Util.MonthlyTargetHrs(
-                                        bodyshop.scoreboard_target.dailyPaintTarget,
-                                        bodyshop
-                                    )
-                                ).toFixed(1)}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={(
-                                    Util.AsOfTodayTargetHrs(
-                                        bodyshop.scoreboard_target.dailyBodyTarget,
-                                        bodyshop
-                                    ) +
-                                    Util.AsOfTodayTargetHrs(
-                                        bodyshop.scoreboard_target.dailyPaintTarget,
-                                        bodyshop
-                                    )
-                                ).toFixed(1)}
-                            />
-                        </Col>
-                        <Col {...statSpans}>
-                            <Statistic
-                                value={(values.toDatePaint + values.toDateBody).toFixed(1)}
-                            />
-                        </Col>
-                    </Row>
-                </Col>
-            </Row>
-        </Card>
-    );
+  return (
+    <Card
+      title={t("scoreboard.labels.targets")}
+      extra={<ScoreboardJobsList scoreBoardlist={scoreBoardlist} />}
+    >
+      <Row gutter={rowGutter}>
+        <Col xs={24} sm={{ offset: 0, span: 4 }} lg={{ span: 4 }}>
+          <Statistic
+            title={t("scoreboard.labels.workingdays")}
+            value={Util.CalculateWorkingDaysThisMonth()}
+            prefix={<CalendarOutlined />}
+          />
+        </Col>
+        <Col xs={24} sm={{ offset: 0, span: 20 }} lg={{ offset: 0, span: 20 }}>
+          <Row>
+            <Col {...statSpans}>
+              <Statistic
+                title={t("scoreboard.labels.dailytarget")}
+                value={bodyshop.scoreboard_target.dailyBodyTarget}
+                prefix={t("scoreboard.labels.bodyabbrev")}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                title={t("scoreboard.labels.dailyactual")}
+                value={values.todayBody.toFixed(1)}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                title={t("scoreboard.labels.weeklytarget")}
+                value={Util.WeeklyTargetHrs(
+                  bodyshop.scoreboard_target.dailyBodyTarget,
+                  bodyshop
+                )}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                title={t("scoreboard.labels.weeklyactual")}
+                value={values.weeklyBody.toFixed(1)}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                title={t("scoreboard.labels.monthlytarget")}
+                value={Util.MonthlyTargetHrs(
+                  bodyshop.scoreboard_target.dailyBodyTarget,
+                  bodyshop
+                )}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                title={t("scoreboard.labels.asoftodaytarget")}
+                value={Util.AsOfTodayTargetHrs(
+                  bodyshop.scoreboard_target.dailyBodyTarget,
+                  bodyshop
+                )}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                title={t("scoreboard.labels.todateactual")}
+                value={values.toDateBody.toFixed(1)}
+              />
+            </Col>
+          </Row>
+          <Row>
+            <Col {...statSpans}>
+              <Statistic
+                value={bodyshop.scoreboard_target.dailyPaintTarget}
+                prefix={t("scoreboard.labels.refinishabbrev")}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic value={values.todayPaint.toFixed(1)} />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                value={Util.WeeklyTargetHrs(
+                  bodyshop.scoreboard_target.dailyPaintTarget,
+                  bodyshop
+                )}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic value={values.weeklyPaint.toFixed(1)} />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                value={Util.MonthlyTargetHrs(
+                  bodyshop.scoreboard_target.dailyPaintTarget,
+                  bodyshop
+                )}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                value={Util.AsOfTodayTargetHrs(
+                  bodyshop.scoreboard_target.dailyPaintTarget,
+                  bodyshop
+                )}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic value={values.toDatePaint.toFixed(1)} />
+            </Col>
+          </Row>
+          <Row>
+            <Divider style={{ margin: 5 }} />
+          </Row>
+          <Row>
+            <Col {...statSpans}>
+              <Statistic
+                value={"\u00A0"}
+                prefix={t("scoreboard.labels.total")}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                value={(values.todayPaint + values.todayBody).toFixed(1)}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                value={(
+                  Util.WeeklyTargetHrs(
+                    bodyshop.scoreboard_target.dailyBodyTarget,
+                    bodyshop
+                  ) +
+                  Util.WeeklyTargetHrs(
+                    bodyshop.scoreboard_target.dailyPaintTarget,
+                    bodyshop
+                  )
+                ).toFixed(1)}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                value={(values.weeklyPaint + values.weeklyBody).toFixed(1)}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                value={(
+                  Util.MonthlyTargetHrs(
+                    bodyshop.scoreboard_target.dailyBodyTarget,
+                    bodyshop
+                  ) +
+                  Util.MonthlyTargetHrs(
+                    bodyshop.scoreboard_target.dailyPaintTarget,
+                    bodyshop
+                  )
+                ).toFixed(1)}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                value={(
+                  Util.AsOfTodayTargetHrs(
+                    bodyshop.scoreboard_target.dailyBodyTarget,
+                    bodyshop
+                  ) +
+                  Util.AsOfTodayTargetHrs(
+                    bodyshop.scoreboard_target.dailyPaintTarget,
+                    bodyshop
+                  )
+                ).toFixed(1)}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic
+                value={(values.toDatePaint + values.toDateBody).toFixed(1)}
+              />
+            </Col>
+          </Row>
+          <Row>
+            <Divider style={{ margin: 5 }} />
+          </Row>
+          <Row>
+            <Col {...statSpans}>
+              <Statistic
+                value={"\u00A0"}
+                prefix={t("scoreboard.labels.jobs")}
+              />
+            </Col>
+            <Col {...statSpans}>
+              <Statistic value={values.todayJobs} />
+            </Col>
+            <Col {...statSpans} />
+            <Col {...statSpans}>
+              <Statistic value={values.weeklyJobs} />
+            </Col>
+            <Col {...statSpans} />
+            <Col {...statSpans} />
+            <Col {...statSpans}>
+              <Statistic value={values.toDateJobs} />
+            </Col>
+          </Row>
+        </Col>
+      </Row>
+    </Card>
+  );
 }
-
 export default connect(
-    mapStateToProps,
-    mapDispatchToProps
+  mapStateToProps,
+  mapDispatchToProps
 )(ScoreboardTargetsTable);

client/src/components/shop-info/shop-info.responsibilitycenters.component.jsx

@@ -1,5 +1,5 @@
 import {DeleteFilled} from "@ant-design/icons";
-import {Button, Form, Input, InputNumber, Select, Switch, Typography,} from "antd";
+import {Button, Form, Input, InputNumber, Select, Space, Switch, Typography,} from "antd";
 import React, {useState} from "react";
 import {useTranslation} from "react-i18next";
 import styled from "styled-components";
@@ -9,6 +9,7 @@ import {selectBodyshop} from "../../redux/user/user.selectors";
 import {connect} from "react-redux";
 import {createStructuredSelector} from "reselect";
 import {useSplitTreatments} from "@splitsoftware/splitio-react";
+import FormListMoveArrows from "../form-list-move-arrows/form-list-move-arrows.component";
 
 const SelectorDiv = styled.div`
     .ant-form-item .ant-select {
@@ -180,7 +181,7 @@ export function ShopInfoResponsibilityCenterComponent({bodyshop, form}) {
                     </LayoutFormRow>
                     <LayoutFormRow header={t("bodyshop.labels.dms.cdk.payers")}>
                         <Form.List name={["cdk_configuration", "payers"]}>
-                            {(fields, {add, remove}) => {
+                            {(fields, {add, remove,  move}) => {
                                 return (
                                     <div>
                                         {fields.map((field, index) => (
@@ -238,11 +239,18 @@ export function ShopInfoResponsibilityCenterComponent({bodyshop, form}) {
                                                         </Select>
                                                     </Form.Item>
 
-                                                    <DeleteFilled
-                                                        onClick={() => {
-                                                            remove(field.name);
-                                                        }}
-                                                    />
+                                                                                        <Space align="center">
+                                                                        d
+                                                            onClick={() => {
+                                                                remove(field.name);
+                                                            }}
+                                                        />
+                                                        <FormListMoveArrows
+                                                            move={move}
+                                                            index={index}
+                                                            total={fields.length}
+                                                        />
+                                                    </Space>
                                                 </LayoutFormRow>
                                             </Form.Item>
                                         ))}
@@ -334,7 +342,7 @@ export function ShopInfoResponsibilityCenterComponent({bodyshop, form}) {
                 id="costs"
             >
                 <Form.List name={["md_responsibility_centers", "costs"]}>
-                    {(fields, {add, remove}) => {
+                    {(fields, {add, remove, move}) => {
                         return (
                             <div>
                                 {fields.map((field, index) => (
@@ -451,12 +459,18 @@ export function ShopInfoResponsibilityCenterComponent({bodyshop, form}) {
                                                     <Input onBlur={handleBlur}/>
                                                 </Form.Item>
                                             )}
-
-                                            <DeleteFilled
-                                                onClick={() => {
-                                                    remove(field.name);
-                                                }}
-                                            />
+                                            <Space align="center">
+                                                <DeleteFilled
+                                                    onClick={() => {
+                                                        remove(field.name);
+                                                    }}
+                                                />
+                                                <FormListMoveArrows
+                                                    move={move}
+                                                    index={index}
+                                                    total={fields.length}
+                                                />
+                                            </Space>
                                         </LayoutFormRow>
                                     </Form.Item>
                                 ))}
@@ -482,7 +496,7 @@ export function ShopInfoResponsibilityCenterComponent({bodyshop, form}) {
                 id="profits"
             >
                 <Form.List name={["md_responsibility_centers", "profits"]}>
-                    {(fields, {add, remove}) => {
+                    {(fields, {add, remove, move}) => {
                         return (
                             <div>
                                 {fields.map((field, index) => (
@@ -584,11 +598,18 @@ export function ShopInfoResponsibilityCenterComponent({bodyshop, form}) {
                                                     <Input onBlur={handleBlur}/>
                                                 </Form.Item>
                                             )}
-                                            <DeleteFilled
-                                                onClick={() => {
-                                                    remove(field.name);
-                                                }}
-                                            />
+                                            <Space align="center">
+                                                <DeleteFilled
+                                                    onClick={() => {
+                                                        remove(field.name);
+                                                    }}
+                                                />
+                                                <FormListMoveArrows
+                                                    move={move}
+                                                    index={index}
+                                                    total={fields.length}
+                                                />
+                                            </Space>
                                         </LayoutFormRow>
                                     </Form.Item>
                                 ))}
@@ -613,7 +634,7 @@ export function ShopInfoResponsibilityCenterComponent({bodyshop, form}) {
                 {(bodyshop.cdk_dealerid || bodyshop.pbs_serialnumber) && (
                     <>
                         <Form.List name={["md_responsibility_centers", "dms_defaults"]}>
-                            {(fields, {add, remove}) => {
+                            {(fields, {add, remove, move}) => {
                                 return (
                                     <div>
                                         {fields.map((field, index) => (

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

@@ -6,8 +6,10 @@ import {Link} from "react-router-dom";
 import {createStructuredSelector} from "reselect";
 import {selectBodyshop} from "../../redux/user/user.selectors";
 import CurrencyFormatter from "../../utils/CurrencyFormatter";
-import {alphaSort, statusSort} from "../../utils/sorters";
-import OwnerNameDisplay from "../owner-name-display/owner-name-display.component";
+import { alphaSort, statusSort } from "../../utils/sorters";
+import OwnerNameDisplay, {
+    OwnerNameDisplayFunction,
+} from "../owner-name-display/owner-name-display.component";
 import VehicleDetailUpdateJobsComponent from "../vehicle-detail-update-jobs/vehicle-detail-update-jobs.component";
 
 const mapStateToProps = createStructuredSelector({
@@ -45,6 +47,10 @@ export function VehicleDetailJobsComponent({vehicle, bodyshop}) {
             title: t("jobs.fields.owner"),
             dataIndex: "owner",
             key: "owner",
+            sorter: (a, b) =>
+                alphaSort(OwnerNameDisplayFunction(a), OwnerNameDisplayFunction(b)),
+            sortOrder:
+                state.sortedInfo.columnKey === "owner" && state.sortedInfo.order,
             render: (text, record) => (
                 <Link to={`/manage/owners/${record.owner.id}`}>
                     <OwnerNameDisplay ownerObject={record}/>
@@ -63,9 +69,15 @@ export function VehicleDetailJobsComponent({vehicle, bodyshop}) {
             title: t("jobs.fields.status"),
             dataIndex: "status",
             key: "status",
-            sorter: (a, b) => statusSort(a.status, b.status, bodyshop.md_ro_statuses.statuses),
+            sorter: (a, b) =>
+                statusSort(a.status, b.status, bodyshop.md_ro_statuses.statuses),
             sortOrder:
                 state.sortedInfo.columnKey === "status" && state.sortedInfo.order,
+            filters: bodyshop.md_ro_statuses.statuses.map((status) => ({
+                text: status,
+                value: status,
+            })),
+            onFilter: (value, record) => value.includes(record.status),
         },
 
         {

client/src/components/vehicles-list/vehicles-list.component.jsx

@@ -6,6 +6,7 @@ import {useTranslation} from "react-i18next";
 import {Link, useLocation, useNavigate} from "react-router-dom";
 import VehicleVinDisplay from "../vehicle-vin-display/vehicle-vin-display.component";
 import {pageLimit} from "../../utils/config";
+import { alphaSort } from '../../utils/sorters';
 
 export default function VehiclesListComponent({
                                                   loading,
@@ -32,6 +33,8 @@ export default function VehiclesListComponent({
             title: t("vehicles.fields.v_vin"),
             dataIndex: "v_vin",
             key: "v_vin",
+            sorter: (a, b) => alphaSort(a.v_vin, b.v_vin),
+            sortOrder: state.sortedInfo.columnKey === "v_vin" && state.sortedInfo.order,
             render: (text, record) => (
                 <Link to={"/manage/vehicles/" + record.id}>
                     <VehicleVinDisplay>{record.v_vin || "N/A"}</VehicleVinDisplay>
@@ -52,8 +55,10 @@ export default function VehiclesListComponent({
         },
         {
             title: t("vehicles.fields.plate_no"),
-            dataIndex: "plate",
-            key: "plate",
+            dataIndex: "plate_no",
+            key: "plate_no",
+            sorter: (a, b) => alphaSort(a.plate_no, b.plate_no),
+            sortOrder: state.sortedInfo.columnKey === "plate_no" && state.sortedInfo.order,
             render: (text, record) => {
                 return (
                     <span>{`${record.plate_st || ""} | ${record.plate_no || ""}`}</span>

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 axios from "axios";
+import { checkBeta } from "../utils/handleBeta";
 
 const config = JSON.parse(process.env.REACT_APP_FIREBASE_CONFIG);
 initializeApp(config);
@@ -86,6 +88,17 @@ export const logImEXEvent = (eventName, additionalParams, stateProp = null) => {
             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: checkBeta() ? "beta" : "master",
+    });
     // console.log(
     //   "%c[Analytics]",
     //   "background-color: green ;font-weight:bold;",

client/src/graphql/audit_trail.queries.js

@@ -40,6 +40,7 @@ export const INSERT_AUDIT_TRAIL = gql`
             bodyshopid
             created
             operation
+            type
             useremail
         }
     }

client/src/graphql/vehicles.queries.js

@@ -1,47 +1,48 @@
 import {gql} from "@apollo/client";
 
 export const QUERY_VEHICLE_BY_ID = gql`
-    query QUERY_VEHICLE_BY_ID($id: uuid!) {
-        vehicles_by_pk(id: $id) {
-            created_at
-            db_v_code
-            id
-            plate_no
-            plate_st
-            v_vin
-            v_type
-            v_trimcode
-            v_tone
-            v_stage
-            v_prod_dt
-            v_paint_codes
-            v_options
-            v_model_yr
-            v_model_desc
-            v_mldgcode
-            v_makecode
-            v_make_desc
-            v_engine
-            v_cond
-            v_color
-            v_bstyle
-            updated_at
-            trim_color
-            notes
-            jobs(order_by: { date_open: desc }) {
-                id
-                ro_number
-                ownr_fn
-                ownr_ln
-                owner {
-                    id
-                }
-                clm_no
-                status
-                clm_total
-            }
+  query QUERY_VEHICLE_BY_ID($id: uuid!) {
+    vehicles_by_pk(id: $id) {
+      created_at
+      db_v_code
+      id
+      plate_no
+      plate_st
+      v_vin
+      v_type
+      v_trimcode
+      v_tone
+      v_stage
+      v_prod_dt
+      v_paint_codes
+      v_options
+      v_model_yr
+      v_model_desc
+      v_mldgcode
+      v_makecode
+      v_make_desc
+      v_engine
+      v_cond
+      v_color
+      v_bstyle
+      updated_at
+      trim_color
+      notes
+      jobs(order_by: { date_open: desc }) {
+        id
+        ro_number
+        ownr_co_nm
+        ownr_fn
+        ownr_ln
+        owner {
+          id
         }
+        clm_no
+        status
+        clm_total
+      }
     }
+  }
 `;
 
 export const UPDATE_VEHICLE = gql`

client/src/pages/dms/dms.container.jsx

@@ -16,8 +16,13 @@ import LoadingSpinner from "../../components/loading-spinner/loading-spinner.com
 import {OwnerNameDisplayFunction} from "../../components/owner-name-display/owner-name-display.component";
 import {auth} from "../../firebase/firebase.utils";
 import {QUERY_JOB_EXPORT_DMS} from "../../graphql/jobs.queries";
-import {setBreadcrumbs, setSelectedHeader,} from "../../redux/application/application.actions";
+import {
+    insertAuditTrail,
+    setBreadcrumbs,
+    setSelectedHeader,
+} from "../../redux/application/application.actions";
 import {selectBodyshop} from "../../redux/user/user.selectors";
+import AuditTrailMapping from "../../utils/AuditTrailMappings";
 
 const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
@@ -26,6 +31,8 @@ const mapStateToProps = createStructuredSelector({
 const mapDispatchToProps = (dispatch) => ({
     setBreadcrumbs: (breadcrumbs) => dispatch(setBreadcrumbs(breadcrumbs)),
     setSelectedHeader: (key) => dispatch(setSelectedHeader(key)),
+    insertAuditTrail: ({ jobid, operation, type }) =>
+        dispatch(insertAuditTrail({ jobid, operation, type })),
 });
 
 export default connect(mapStateToProps, mapDispatchToProps)(DmsContainer);
@@ -45,7 +52,12 @@ export const socket = SocketIO(
     }
 );
 
-export function DmsContainer({bodyshop, setBreadcrumbs, setSelectedHeader}) {
+export function DmsContainer({
+                                 bodyshop,
+                                 setBreadcrumbs,
+                                 setSelectedHeader,
+                                 insertAuditTrail,
+     }) {
     const {t} = useTranslation();
     const [logLevel, setLogLevel] = useState("DEBUG");
     const history = useNavigate();
@@ -103,6 +115,10 @@ export function DmsContainer({bodyshop, setBreadcrumbs, setSelectedHeader}) {
             notification.success({
                 message: t("jobs.successes.exported"),
             });
+            insertAuditTrail({
+                jobid: payload,
+                operation: AuditTrailMapping.jobexported(),
+            type: "jobexported",});
             history("/manage/accounting/receivables");
         });
 

client/src/pages/export-logs/export-logs.page.component.jsx

@@ -12,7 +12,8 @@ import AlertComponent from "../../components/alert/alert.component";
 import {QUERY_EXPORT_LOG_PAGINATED} from "../../graphql/accounting.queries";
 import {selectBodyshop} from "../../redux/user/user.selectors";
 import {DateTimeFormatter} from "../../utils/DateFormatter";
-import {pageLimit} from "../../utils/config";
+import { pageLimit } from "../../utils/config";
+import { alphaSort, dateSort } from "./../../utils/sorters";
 
 const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
@@ -34,11 +35,42 @@ export function ExportLogsPageComponent({bodyshop}) {
                 limit: pageLimit,
                 order: [
                     {
-                        [sortcolumn || "created_at"]: sortorder
+                        ...(sortcolumn === "ro_number"
+              ? {
+                  job: {
+                    [sortcolumn|| "created_at"]: sortorder
                             ? sortorder === "descend"
                                 ? "desc"
                                 : "asc"
-                            : "desc",
+                            : "desc",},
+                }
+              : sortcolumn === "invoice_number"
+              ? {
+                  bill: {
+                    [sortcolumn || "created_at"]: sortorder
+                      ? sortorder === "descend"
+                        ? "desc"
+                        : "asc"
+                      : "desc",
+                  },
+                }
+              : sortcolumn === "paymentnum"
+              ? {
+                  payment: {
+                    [sortcolumn || "created_at"]: sortorder
+                      ? sortorder === "descend"
+                        ? "desc"
+                        : "asc"
+                      : "desc",
+                  },
+                }
+              : {
+                  [sortcolumn || "created_at"]: sortorder
+                    ? sortorder === "descend"
+                      ? "desc"
+                      : "asc"
+                    : "desc",
+                }),
                     },
                 ],
             },
@@ -68,7 +100,8 @@ export function ExportLogsPageComponent({bodyshop}) {
             title: t("general.labels.created_at"),
             dataIndex: "created_at",
             key: "created_at",
-            render: (text, record) => (
+            sorter: (a, b) => dateSort(a.created_at, b.created_at),
+      sortOrder: sortcolumn === "created_at" && sortorder,render: (text, record) => (
                 <DateTimeFormatter>{record.created_at}</DateTimeFormatter>
             ),
         },
@@ -81,7 +114,8 @@ export function ExportLogsPageComponent({bodyshop}) {
             title: t("jobs.fields.ro_number"),
             dataIndex: "ro_number",
             key: "ro_number",
-
+sorter: (a, b) => alphaSort(a.ro_number, b.ro_number),
+      sortOrder: sortcolumn === "ro_number" && sortorder,
             render: (text, record) =>
                 record.job && (
                     <Link to={`/manage/jobs/${record.job.id}`}>
@@ -93,7 +127,8 @@ export function ExportLogsPageComponent({bodyshop}) {
             title: t("bills.fields.invoice_number"),
             dataIndex: "invoice_number",
             key: "invoice_number",
-            render: (text, record) =>
+            sorter: (a, b) => alphaSort(a.invoice_number, b.invoice_number),
+      sortOrder: sortcolumn === "invoice_number" && sortorder,render: (text, record) =>
                 record.bill && (
                     <Link to={"/manage/bills?billid=" + (record.bill && record.bill.id)}>
                         {record.bill && record.bill.invoice_number}
@@ -103,7 +138,8 @@ export function ExportLogsPageComponent({bodyshop}) {
         {
             title: t("payments.fields.paymentnum"),
             dataIndex: "paymentnum",
-            key: "paymentnum",
+            key: "paymentnum",sorter: (a, b) => alphaSort(a.paymentnum, b.paymentnum),
+      sortOrder: sortcolumn === "paymentnum" && sortorder,
             render: (text, record) =>
                 record.payment && (
                     <Link
@@ -119,7 +155,13 @@ export function ExportLogsPageComponent({bodyshop}) {
         {
             title: t("general.labels.successful"),
             dataIndex: "successful",
-            key: "successful",
+            key: "successful",sorter: (a, b) => Number(a.successful) - Number(b.successful),
+      sortOrder: sortcolumn === "successful" && sortorder,
+      filters: [
+        { text: "True", value: true },
+        { text: "False", value: false },
+      ],
+      onFilter: (value, record) => record.successful === value,
             render: (text, record) => (
                 <Checkbox disabled checked={record.successful}/>
             ),

client/src/pages/jobs-close/jobs-close.component.jsx

@@ -48,11 +48,11 @@ const mapStateToProps = createStructuredSelector({
 });
 
 const mapDispatchToProps = (dispatch) => ({
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
-export function JobsCloseComponent({job, bodyshop, jobRO, insertAuditTrail,}) {
+export function JobsCloseComponent({job, bodyshop, jobRO, insertAuditTrail}) {
     const {t} = useTranslation();
     const [form] = Form.useForm();
     const client = useApolloClient();
@@ -118,7 +118,7 @@ export function JobsCloseComponent({job, bodyshop, jobRO, insertAuditTrail,}) {
             insertAuditTrail({
                 jobid: job.id,
                 operation: AuditTrailMapping.jobinvoiced(),
-            });
+            type: "jobinvoiced",});
             // history.push(`/manage/jobs/${job.id}`);
         } else {
             setLoading(false);

client/src/pages/jobs-detail/jobs-detail.page.component.jsx

@@ -23,6 +23,7 @@ import {createStructuredSelector} from "reselect";
 import FormFieldsChanged from "../../components/form-fields-changed-alert/form-fields-changed-alert.component";
 import JobAuditTrail from "../../components/job-audit-trail/job-audit-trail.component";
 import JobsLinesContainer from "../../components/job-detail-lines/job-lines.container";
+import JobLifecycleComponent from "../../components/job-lifecycle/job-lifecycle.component";
 import JobLineUpsertModalContainer from "../../components/job-lines-upsert-modal/job-lines-upsert-modal.container";
 import JobReconciliationModal from "../../components/job-reconciliation-modal/job-reconciliation.modal.container";
 import JobSyncButton from "../../components/job-sync-button/job-sync-button.component";
@@ -49,7 +50,6 @@ import {selectBodyshop} from "../../redux/user/user.selectors";
 import AuditTrailMapping from "../../utils/AuditTrailMappings";
 import UndefinedToNull from "../../utils/undefinedtonull";
 import {DateTimeFormat} from "./../../utils/DateFormatter";
-import JobLifecycleComponent from "../../components/job-lifecycle/job-lifecycle.component";
 
 const mapStateToProps = createStructuredSelector({
     bodyshop: selectBodyshop,
@@ -58,8 +58,8 @@ const mapStateToProps = createStructuredSelector({
 const mapDispatchToProps = (dispatch) => ({
     setPrintCenterContext: (context) =>
         dispatch(setModalContext({context: context, modal: "printCenter"})),
-    insertAuditTrail: ({jobid, operation}) =>
-        dispatch(insertAuditTrail({jobid, operation})),
+    insertAuditTrail: ({jobid, operation, type}) =>
+        dispatch(insertAuditTrail({jobid, operation, type })),
 });
 
 export function JobsDetailPage({
@@ -172,7 +172,7 @@ export function JobsDetailPage({
                             ? DateTimeFormat(changedAuditFields[key])
                             : changedAuditFields[key]
                     ),
-                });
+                type: "jobfieldchange",});
             });
 
             await refetch();
@@ -304,7 +304,7 @@ export function JobsDetailPage({
                         {
                             key: 'lifecycle',
                             icon: <BarsOutlined/>,
-                            label: t('menus.jobsdetail.lifecycle'),
+                            label: t("menus.jobsdetail.lifecycle"),
                             children: <JobLifecycleComponent job={job} statuses={bodyshop.md_ro_statuses}/>,
                         },
                         {

client/src/redux/application/application.actions.js

@@ -54,9 +54,9 @@ export const setOnline = (isOnline) => ({
     payload: isOnline,
 });
 
-export const insertAuditTrail = ({jobid, billid, operation}) => ({
+export const insertAuditTrail = ({jobid, billid, operation, type}) => ({
     type: ApplicationActionTypes.INSERT_AUDIT_TRAIL,
-    payload: {jobid, billid, operation},
+    payload: {jobid, billid, operation, type },
 });
 export const setProblemJobs = (problemJobs) => ({
     type: ApplicationActionTypes.SET_PROBLEM_JOBS,

client/src/redux/application/application.sagas.js

@@ -263,7 +263,7 @@ export function* onInsertAuditTrail() {
 }
 
 export function* insertAuditTrailSaga({
-                                          payload: {jobid, billid, operation},
+                                          payload: {jobid, billid, operation, type},
                                       }) {
     const state = yield select();
     const bodyshop = state.user.bodyshop;
@@ -275,18 +275,18 @@ export function* insertAuditTrailSaga({
             jobid,
             billid,
             operation,
-            useremail: currentUser.email,
+            type,useremail: currentUser.email,
         },
     };
     yield client.mutate({
         mutation: INSERT_AUDIT_TRAIL,
         variables,
-        update(cache, {data}) {
+        update(cache, { data }) {
             cache.modify({
                 fields: {
-                    audit_trail(existingAuditTrail, {readField}) {
+                    audit_trail(existingAuditTrail, { readField }) {
                         const newAuditTrail = cache.writeQuery({
-                            data: data.insert_audit_trail_one,
+                            data: data,
                             query: INSERT_AUDIT_TRAIL,
                             variables,
                         });

client/src/translations/en_us/common.json

@@ -107,13 +107,14 @@
         "alerttoggle": "Alert Toggle set to {{status}}",
         "appointmentcancel": "Appointment canceled. Lost Reason: {{lost_sale_reason}}.",
         "appointmentinsert": "Appointment created. Appointment Date: {{start}}.",
-        "billposted": "Bill with invoice number {{invoice_number}} posted.",
+        "billdeleted": "Bill with invoice number {{invoice_number}} deleted.",
+				"billposted": "Bill with invoice number {{invoice_number}} posted.",
         "billupdated": "Bill with invoice number {{invoice_number}} updated.",
         "failedpayment": "Failed payment",
         "jobassignmentchange": "Employee {{name}} assigned to {{operation}}",
         "jobassignmentremoved": "Employee assignment removed for {{operation}}",
         "jobchecklist": "Checklist type \"{{type}}\" completed.  In production set to {{inproduction}}.  Status set to {{status}}.",
-        "jobconverted": "Job converted and assigned number {{ro_number}}.",
+        "jobconverted": "Job converted and assigned number {{ro_number}}.","jobexported": "Job has been exported.",
         "jobfieldchanged": "Job field $t(jobs.fields.{{field}}) changed to {{value}}.",
         "jobimported": "Job imported.",
         "jobinproductionchange": "Job production status set to {{inproduction}}",
@@ -126,8 +127,9 @@
         "jobspartsorder": "Parts order {{order_number}} added to Job.",
         "jobspartsreturn": "Parts return {{order_number}} added to Job.",
         "jobstatuschange": "Job status changed to {{status}}.",
-        "jobsupplement": "Job supplement imported."
-      }
+        "jobsupplement": "Job supplement imported.",
+      "jobsuspend": "Suspend Toggle set to {{status}}",
+				"jobvoid": "Job has been voided."}
     },
     "billlines": {
       "actions": {
@@ -255,6 +257,7 @@
         "saving": "Error encountered while saving. {{message}}"
       },
       "fields": {
+        "ReceivableCustomField": "QBO Receivable Custom Field {{number}}",
         "address1": "Address 1",
         "address2": "Address 2",
         "appt_alt_transport": "Appointment Alternative Transportation Options",
@@ -473,7 +476,7 @@
             "editaccess": "Users -> Edit access"
           }
         },
-        "ReceivableCustomField": "QBO Receivable Custom Field {{number}}",
+
         "responsibilitycenter": "Responsibility Center",
         "responsibilitycenter_accountdesc": "Account Description",
         "responsibilitycenter_accountitem": "Item",
@@ -604,7 +607,7 @@
         "dms": {
           "cdk": {
             "controllist": "Control Number List",
-            "payers": "CDK Payers"
+            "payers": " Payers"
           },
           "cdk_dealerid": "CDK Dealer ID",
           "pbs_serialnumber": "PBS Serial Number",
@@ -840,8 +843,8 @@
         "notconfigured": "You do not have any current CSI Question Sets configured.",
         "notfoundsubtitle": "We were unable to find a survey using the link you provided. Please ensure the URL is correct or reach out to your shop for more help.",
         "notfoundtitle": "No survey found.",
-        "surveycompletetitle": "Survey previously completed",
-        "surveycompletesubtitle": "This survey was already completed on {{date}}."
+        "surveycompletesubtitle": "This survey was already completed on {{date}}.",
+        "surveycompletetitle": "Survey previously completed"
       },
       "fields": {
         "completedon": "Completed On",
@@ -850,13 +853,13 @@
         "validuntil": "Valid Until"
       },
       "labels": {
+        "copyright": "Copyright © $t(titles.app). All Rights Reserved.",
+        "greeting": "Hi {{name}}!",
+        "intro": "At {{shopname}}, we value your feedback. We would love to hear what you have to say. Please fill out the form below.",
         "nologgedinuser": "Please log out of $t(titles.app)",
         "nologgedinuser_sub": "Users of $t(titles.app) cannot complete CSI surveys while logged in. Please log out and try again.",
         "noneselected": "No response selected.",
-        "title": "Customer Satisfaction Survey",
-        "greeting": "Hi {{name}}!",
-        "intro": "At {{shopname}}, we value your feedback. We would love to hear what you have to say. Please fill out the form below.",
-        "copyright": "Copyright © $t(titles.app). All Rights Reserved."
+        "title": "Customer Satisfaction Survey"
       },
       "successes": {
         "created": "CSI created successfully. ",
@@ -894,7 +897,8 @@
         "scheduledindate": "Sheduled In Today: {{date}}",
         "scheduledintoday": "Sheduled In Today",
         "scheduledoutdate": "Sheduled Out Today: {{date}}",
-        "scheduledouttoday": "Sheduled Out Today"
+        "scheduledouttoday": "Sheduled Out Today",
+        "joblifecycle": "Job Lifecycle"
       }
     },
     "dms": {
@@ -1267,7 +1271,15 @@
         "relative_end": "Relative End",
         "relative_start": "Relative Start",
         "start": "Start",
-        "value": "Value"
+        "value": "Value",
+        "status": "Status",
+        "percentage": "Percentage",
+        "human_readable": "Human Readable",
+        "status_count": "In Status"
+      },
+      "titles": {
+        "dashboard": "Job Lifecycle",
+        "top_durations": "Top Durations"
       },
       "content": {
         "current_status_accumulated_time": "Current Status Accumulated Time",
@@ -1279,7 +1291,9 @@
         "title": "Job Lifecycle Component",
         "title_durations": "Historical Status Durations",
         "title_loading": "Loading",
-        "title_transitions": "Transitions"
+        "title_transitions": "Transitions",
+        "calculated_based_on": "Calculated based on",
+        "jobs_in_since": "Jobs in since"
       },
       "errors": {
         "fetch": "Error getting Job Lifecycle Data"
@@ -1854,6 +1868,7 @@
         "job": "Job Details",
         "jobcosting": "Job Costing",
         "jobtotals": "Job Totals",
+        "labor_hrs": "B/P/T Hrs",
         "labor_rates_subtotal": "Labor Rates Subtotal",
         "laborallocations": "Labor Allocations",
         "labortotals": "Labor Totals",
@@ -2448,6 +2463,7 @@
         "invoice_total_payable": "Invoice (Total Payable)",
         "iou_form": "IOU Form",
         "job_costing_ro": "Job Costing",
+        "job_lifecycle_ro": "Job Lifecycle",
         "job_notes": "Job Notes",
         "key_tag": "Key Tag",
         "labels": {
@@ -2614,15 +2630,17 @@
       },
       "labels": {
         "advanced_filters": "Advanced Filters and Sorters",
-        "advanced_filters_show": "Show",
-        "advanced_filters_hide": "Hide",
-        "advanced_filters_filters": "Filters",
-        "advanced_filters_sorters": "Sorters",
+        "advanced_filters_false": "False",
         "advanced_filters_filter_field": "Field",
-        "advanced_filters_sorter_field": "Field",
-        "advanced_filters_sorter_direction": "Direction",
         "advanced_filters_filter_operator": "Operator",
         "advanced_filters_filter_value": "Value",
+        "advanced_filters_filters": "Filters",
+        "advanced_filters_hide": "Hide",
+        "advanced_filters_show": "Show",
+        "advanced_filters_sorter_direction": "Direction",
+        "advanced_filters_sorter_field": "Field",
+        "advanced_filters_sorters": "Sorters",
+        "advanced_filters_true": "True",
         "dates": "Dates",
         "employee": "Employee",
         "filterson": "Filters on {{object}}: {{field}}",
@@ -2704,6 +2722,8 @@
         "job_costing_ro_date_summary": "Job Costing by RO - Summary",
         "job_costing_ro_estimator": "Job Costing by Estimator",
         "job_costing_ro_ins_co": "Job Costing by RO Source",
+        "job_lifecycle_date_detail": "Job Lifecycle by Date - Detail",
+        "job_lifecycle_date_summary": "Job Lifecycle by Date - Summary",
         "jobs_completed_not_invoiced": "Jobs Completed not Invoiced",
         "jobs_invoiced_not_exported": "Jobs Invoiced not Exported",
         "jobs_reconcile": "Parts/Sublet/Labor Reconciliation",
@@ -2793,7 +2813,8 @@
         "allemployeetimetickets": "All Employee Time Tickets",
         "asoftodaytarget": "As of Today",
         "body": "Body",
-        "bodycharttitle": "Body Targets vs Actual",
+        "bodyabbrev": "B",
+				"bodycharttitle": "Body Targets vs Actual",
         "calendarperiod": "Periods based on calendar weeks/months.",
         "combinedcharttitle": "Combined Targets vs Actual",
         "dailyactual": "Actual (D)",
@@ -2808,14 +2829,14 @@
         "priorweek": "Prior Week",
         "productivestatistics": "Productive Hours Statistics",
         "productivetimeticketsoverdate": "Productive Hours over Selected Dates",
-        "refinish": "Refinish",
+        "refinish": "Refinish","refinishabbrev": "R",
         "refinishcharttitle": "Refinish Targets vs Actual",
         "targets": "Targets",
         "thismonth": "This Month",
         "thisweek": "This Week",
         "timetickets": "Time Tickets",
         "timeticketsemployee": "Time Tickets by Employee",
-        "todateactual": "Actual (MTD)",
+        "todateactual": "Actual (MTD)","total": "Total",
         "totalhrs": "Total Hours",
         "totaloverperiod": "Total over Selected Dates",
         "weeklyactual": "Actual (W)",

client/src/translations/es/common.json

@@ -107,14 +107,16 @@
         "alerttoggle": "",
         "appointmentcancel": "",
         "appointmentinsert": "",
-        "billposted": "",
+        "billdeleted": "",
+				"billposted": "",
         "billupdated": "",
         "failedpayment": "",
         "jobassignmentchange": "",
         "jobassignmentremoved": "",
         "jobchecklist": "",
         "jobconverted": "",
-        "jobfieldchanged": "",
+        "jobexported": "",
+				"jobfieldchanged": "",
         "jobimported": "",
         "jobinproductionchange": "",
         "jobinvoiced": "",
@@ -126,8 +128,9 @@
         "jobspartsorder": "",
         "jobspartsreturn": "",
         "jobstatuschange": "",
-        "jobsupplement": ""
-      }
+        "jobsupplement": "",
+      "jobsuspend": "",
+				"jobvoid": ""}
     },
     "billlines": {
       "actions": {
@@ -255,6 +258,7 @@
         "saving": ""
       },
       "fields": {
+        "ReceivableCustomField": "",
         "address1": "",
         "address2": "",
         "appt_alt_transport": "",
@@ -473,7 +477,7 @@
             "editaccess": ""
           }
         },
-        "ReceivableCustomField": "",
+
         "responsibilitycenter": "",
         "responsibilitycenter_accountdesc": "",
         "responsibilitycenter_accountitem": "",
@@ -840,8 +844,8 @@
         "notconfigured": "",
         "notfoundsubtitle": "",
         "notfoundtitle": "",
-        "surveycompletetitle": "",
-        "surveycompletesubtitle": ""
+        "surveycompletesubtitle": "",
+        "surveycompletetitle": ""
       },
       "fields": {
         "completedon": "",
@@ -850,13 +854,13 @@
         "validuntil": ""
       },
       "labels": {
+        "copyright": "",
+        "greeting": "",
+        "intro": "",
         "nologgedinuser": "",
         "nologgedinuser_sub": "",
         "noneselected": "",
-        "title": "",
-        "greeting": "",
-        "intro": "",
-        "copyright": ""
+        "title": ""
       },
       "successes": {
         "created": "",
@@ -894,7 +898,8 @@
         "scheduledindate": "",
         "scheduledintoday": "",
         "scheduledoutdate": "",
-        "scheduledouttoday": ""
+        "scheduledouttoday": "",
+        "joblifecycle": ""
       }
     },
     "dms": {
@@ -1267,7 +1272,15 @@
         "relative_end": "",
         "relative_start": "",
         "start": "",
-        "value": ""
+        "value": "",
+        "status": "",
+        "percentage": "",
+        "human_readable": "",
+        "status_count": ""
+      },
+      "titles": {
+        "dashboard": "",
+        "top_durations": ""
       },
       "content": {
         "current_status_accumulated_time": "",
@@ -1279,7 +1292,9 @@
         "title": "",
         "title_durations": "",
         "title_loading": "",
-        "title_transitions": ""
+        "title_transitions": "",
+        "calculated_based_on": "",
+        "jobs_in_since": ""
       },
       "errors": {
         "fetch": "Error al obtener los datos del ciclo de vida del trabajo"
@@ -1854,6 +1869,7 @@
         "job": "",
         "jobcosting": "",
         "jobtotals": "",
+        "labor_hrs": "",
         "labor_rates_subtotal": "",
         "laborallocations": "",
         "labortotals": "",
@@ -2448,6 +2464,7 @@
         "invoice_total_payable": "",
         "iou_form": "",
         "job_costing_ro": "",
+        "job_lifecycle_ro": "",
         "job_notes": "",
         "key_tag": "",
         "labels": {
@@ -2614,15 +2631,17 @@
       },
       "labels": {
         "advanced_filters": "",
-        "advanced_filters_show": "",
-        "advanced_filters_hide": "",
-        "advanced_filters_filters": "",
-        "advanced_filters_sorters": "",
+        "advanced_filters_false": "",
         "advanced_filters_filter_field": "",
-        "advanced_filters_sorter_field": "",
-        "advanced_filters_sorter_direction": "",
         "advanced_filters_filter_operator": "",
         "advanced_filters_filter_value": "",
+        "advanced_filters_filters": "",
+        "advanced_filters_hide": "",
+        "advanced_filters_show": "",
+        "advanced_filters_sorter_direction": "",
+        "advanced_filters_sorter_field": "",
+        "advanced_filters_sorters": "",
+        "advanced_filters_true": "",
         "dates": "",
         "employee": "",
         "filterson": "",
@@ -2704,6 +2723,8 @@
         "job_costing_ro_date_summary": "",
         "job_costing_ro_estimator": "",
         "job_costing_ro_ins_co": "",
+        "job_lifecycle_date_detail": "",
+        "job_lifecycle_date_summary": "",
         "jobs_completed_not_invoiced": "",
         "jobs_invoiced_not_exported": "",
         "jobs_reconcile": "",
@@ -2793,7 +2814,8 @@
         "allemployeetimetickets": "",
         "asoftodaytarget": "",
         "body": "",
-        "bodycharttitle": "",
+        "bodyabbrev": "",
+				"bodycharttitle": "",
         "calendarperiod": "",
         "combinedcharttitle": "",
         "dailyactual": "",
@@ -2809,13 +2831,14 @@
         "productivestatistics": "",
         "productivetimeticketsoverdate": "",
         "refinish": "",
-        "refinishcharttitle": "",
+        "refinishabbrev": "",
+				"refinishcharttitle": "",
         "targets": "",
         "thismonth": "",
         "thisweek": "",
         "timetickets": "",
         "timeticketsemployee": "",
-        "todateactual": "",
+        "todateactual": "","total": "",
         "totalhrs": "",
         "totaloverperiod": "",
         "weeklyactual": "",

client/src/translations/fr/common.json

@@ -107,14 +107,16 @@
         "alerttoggle": "",
         "appointmentcancel": "",
         "appointmentinsert": "",
-        "billposted": "",
+        "billdeleted": "",
+				"billposted": "",
         "billupdated": "",
         "failedpayment": "",
         "jobassignmentchange": "",
         "jobassignmentremoved": "",
         "jobchecklist": "",
         "jobconverted": "",
-        "jobfieldchanged": "",
+        "jobexported": "",
+				"jobfieldchanged": "",
         "jobimported": "",
         "jobinproductionchange": "",
         "jobinvoiced": "",
@@ -126,8 +128,9 @@
         "jobspartsorder": "",
         "jobspartsreturn": "",
         "jobstatuschange": "",
-        "jobsupplement": ""
-      }
+        "jobsupplement": "",
+      "jobsuspend": "",
+				"jobvoid": ""}
     },
     "billlines": {
       "actions": {
@@ -255,6 +258,7 @@
         "saving": ""
       },
       "fields": {
+        "ReceivableCustomField": "",
         "address1": "",
         "address2": "",
         "appt_alt_transport": "",
@@ -473,7 +477,7 @@
             "editaccess": ""
           }
         },
-        "ReceivableCustomField": "",
+
         "responsibilitycenter": "",
         "responsibilitycenter_accountdesc": "",
         "responsibilitycenter_accountitem": "",
@@ -840,8 +844,8 @@
         "notconfigured": "",
         "notfoundsubtitle": "",
         "notfoundtitle": "",
-        "surveycompletetitle": "",
-        "surveycompletesubtitle": ""
+        "surveycompletesubtitle": "",
+        "surveycompletetitle": ""
       },
       "fields": {
         "completedon": "",
@@ -850,13 +854,13 @@
         "validuntil": ""
       },
       "labels": {
+        "copyright": "",
+        "greeting": "",
+        "intro": "",
         "nologgedinuser": "",
         "nologgedinuser_sub": "",
         "noneselected": "",
-        "title": "",
-        "greeting": "",
-        "intro": "",
-        "copyright": ""
+        "title": ""
       },
       "successes": {
         "created": "",
@@ -1267,7 +1271,15 @@
         "relative_end": "",
         "relative_start": "",
         "start": "",
-        "value": ""
+        "value": "",
+        "status": "",
+        "percentage": "",
+        "human_readable": "",
+        "status_count": ""
+      },
+      "titles": {
+        "dashboard": "",
+        "top_durations": ""
       },
       "content": {
         "current_status_accumulated_time": "",
@@ -1279,7 +1291,10 @@
         "title": "",
         "title_durations": "",
         "title_loading": "",
-        "title_transitions": ""
+        "title_transitions": "",
+        "calculated_based_on": "",
+        "jobs_in_since": "",
+        "joblifecycle": ""
       },
       "errors": {
         "fetch": "Erreur lors de l'obtention des données du cycle de vie des tâches"
@@ -1854,6 +1869,7 @@
         "job": "",
         "jobcosting": "",
         "jobtotals": "",
+        "labor_hrs": "",
         "labor_rates_subtotal": "",
         "laborallocations": "",
         "labortotals": "",
@@ -2448,6 +2464,7 @@
         "invoice_total_payable": "",
         "iou_form": "",
         "job_costing_ro": "",
+        "job_lifecycle_ro": "",
         "job_notes": "",
         "key_tag": "",
         "labels": {
@@ -2614,15 +2631,17 @@
       },
       "labels": {
         "advanced_filters": "",
-        "advanced_filters_show": "",
-        "advanced_filters_hide": "",
-        "advanced_filters_filters": "",
-        "advanced_filters_sorters": "",
+        "advanced_filters_false": "",
         "advanced_filters_filter_field": "",
-        "advanced_filters_sorter_field": "",
-        "advanced_filters_sorter_direction": "",
         "advanced_filters_filter_operator": "",
         "advanced_filters_filter_value": "",
+        "advanced_filters_filters": "",
+        "advanced_filters_hide": "",
+        "advanced_filters_show": "",
+        "advanced_filters_sorter_direction": "",
+        "advanced_filters_sorter_field": "",
+        "advanced_filters_sorters": "",
+        "advanced_filters_true": "",
         "dates": "",
         "employee": "",
         "filterson": "",
@@ -2704,6 +2723,8 @@
         "job_costing_ro_date_summary": "",
         "job_costing_ro_estimator": "",
         "job_costing_ro_ins_co": "",
+        "job_lifecycle_date_detail": "",
+        "job_lifecycle_date_summary": "",
         "jobs_completed_not_invoiced": "",
         "jobs_invoiced_not_exported": "",
         "jobs_reconcile": "",
@@ -2793,7 +2814,8 @@
         "allemployeetimetickets": "",
         "asoftodaytarget": "",
         "body": "",
-        "bodycharttitle": "",
+        "bodyabbrev": "",
+				"bodycharttitle": "",
         "calendarperiod": "",
         "combinedcharttitle": "",
         "dailyactual": "",
@@ -2809,13 +2831,14 @@
         "productivestatistics": "",
         "productivetimeticketsoverdate": "",
         "refinish": "",
-        "refinishcharttitle": "",
+        "refinishabbrev": "",
+				"refinishcharttitle": "",
         "targets": "",
         "thismonth": "",
         "thisweek": "",
         "timetickets": "",
         "timeticketsemployee": "",
-        "todateactual": "",
+        "todateactual": "","total": "",
         "totalhrs": "",
         "totaloverperiod": "",
         "weeklyactual": "",

client/src/utils/AuditTrailMappings.js

@@ -20,6 +20,8 @@ const AuditTrailMapping = {
         i18n.t("audit_trail.messages.appointmentcancel", {lost_sale_reason}),
     appointmentinsert: (start) =>
         i18n.t("audit_trail.messages.appointmentinsert", {start}),
+    billdeleted: (invoice_number) =>
+        i18n.t("audit_trail.messages.billdeleted", { invoice_number }),
     billposted: (invoice_number) =>
         i18n.t("audit_trail.messages.billposted", {invoice_number}),
     billupdated: (invoice_number) =>
@@ -33,6 +35,7 @@ const AuditTrailMapping = {
         i18n.t("audit_trail.messages.jobchecklist", {type, inproduction, status}),
     jobconverted: (ro_number) =>
         i18n.t("audit_trail.messages.jobconverted", {ro_number}),
+    jobexported: () => i18n.t("audit_trail.messages.jobexported"),
     jobfieldchange: (field, value) =>
         i18n.t("audit_trail.messages.jobfieldchanged", {field, value}),
     jobimported: () => i18n.t("audit_trail.messages.jobimported"),
@@ -51,6 +54,8 @@ const AuditTrailMapping = {
     jobstatuschange: (status) =>
         i18n.t("audit_trail.messages.jobstatuschange", {status}),
     jobsupplement: () => i18n.t("audit_trail.messages.jobsupplement"),
+    jobsuspend: (status) => i18n.t("audit_trail.messages.jobsuspend", { status }),
+    jobvoid: () => i18n.t("audit_trail.messages.jobvoid"),
 };
 
 export default AuditTrailMapping;

client/src/utils/TemplateConstants.js

@@ -514,6 +514,14 @@ export const TemplateList = (type, context) => {
                     group: "financial",
                     dms: true,
                 },
+                job_lifecycle_ro: {
+                    title: i18n.t("printcenter.jobs.job_lifecycle_ro"),
+                    description: "",
+                    subject: i18n.t("printcenter.jobs.job_lifecycle_ro"),
+                    key: "job_lifecycle_ro",
+                    disabled: false,
+                    group: "post",
+                },
             }
             : {}),
         ...(!type || type === "job_special"
@@ -2048,6 +2056,30 @@ export const TemplateList = (type, context) => {
                     datedisable: true,
                     group: "customers",
                 },
+                job_lifecycle_date_detail: {
+                    title: i18n.t("reportcenter.templates.job_lifecycle_date_detail"),
+                    subject: i18n.t("reportcenter.templates.job_lifecycle_date_detail"),
+                    key: "job_lifecycle_date_detail",
+                    //idtype: "vendor",
+                    disabled: false,
+                    rangeFilter: {
+                        object: i18n.t("reportcenter.labels.objects.jobs"),
+                        field: i18n.t("jobs.fields.date_invoiced"),
+                    },
+                    group: "jobs",
+                },
+                job_lifecycle_date_summary: {
+                    title: i18n.t("reportcenter.templates.job_lifecycle_date_summary"),
+                    subject: i18n.t("reportcenter.templates.job_lifecycle_date_summary"),
+                    key: "job_lifecycle_date_summary",
+                    //idtype: "vendor",
+                    disabled: false,
+                    rangeFilter: {
+                        object: i18n.t("reportcenter.labels.objects.jobs"),
+                        field: i18n.t("jobs.fields.date_invoiced"),
+                    },
+                    group: "jobs",
+                },
             }
             : {}),
         ...(!type || type === "courtesycarcontract"

client/src/utils/graphQLmodifier.js

@@ -2,22 +2,66 @@ import {Kind, parse, print, visit} from "graphql";
 import client from "./GraphQLClient";
 import {gql} from "@apollo/client";
 
+/* eslint-disable no-loop-func */
+
+/**
+ * The available operators for filtering (string)
+ * @type {[{label: string, value: string},{label: string, value: string},{label: string, value: string},{label: string, value: string},{label: string, value: string},null,null,null]}
+ */
 const STRING_OPERATORS = [
     {value: "_eq", label: "equals"},
     {value: "_neq", label: "does not equal"},
     {value: "_like", label: "contains"},
     {value: "_nlike", label: "does not contain"},
     {value: "_ilike", label: "contains case-insensitive"},
-    {value: "_nilike", label: "does not contain case-insensitive"}
+    {value: "_nilike", label: "does not contain case-insensitive"},
+    {value: "_in", label: "in", type: "array"},
+    {value: "_nin", label: "not in", type: "array"}
 ];
+
+/**
+ * The available operators for filtering (dates)
+ * @type {[{label: string, value: string},{label: string, value: string},{label: string, value: string},{label: string, value: string},{label: string, value: string},null,null,null]}
+ */
+const DATE_OPERATORS = [
+    {value: "_eq", label: "equals"},
+    {value: "_neq", label: "does not equal"},
+    {value: "_gt", label: "greater than"},
+    {value: "_lt", label: "less than"},
+    {value: "_gte", label: "greater than or equal"},
+    {value: "_lte", label: "less than or equal"},
+    {value: "_in", label: "in", type: "array"},
+    {value: "_nin", label: "not in", type: "array"}
+];
+
+/**
+ * The available operators for filtering (booleans)
+ * @type {[{label: string, value: string},{label: string, value: string}]}
+ */
+const BOOLEAN_OPERATORS = [
+    {value: "_eq", label: "equals"},
+    {value: "_neq", label: "does not equal"},
+];
+
+/**
+ * The available operators for filtering (numbers)
+ * @type {[{label: string, value: string},{label: string, value: string},{label: string, value: string},{label: string, value: string},{label: string, value: string},null,null,null]}
+ */
 const NUMBER_OPERATORS = [
     {value: "_eq", label: "equals"},
     {value: "_neq", label: "does not equal"},
     {value: "_gt", label: "greater than"},
     {value: "_lt", label: "less than"},
     {value: "_gte", label: "greater than or equal"},
-    {value: "_lte", label: "less than or equal"}
+    {value: "_lte", label: "less than or equal"},
+    {value: "_in", label: "in", type: "array"},
+    {value: "_nin", label: "not in", type: "array"}
 ];
+
+/**
+ * The available operators for sorting
+ * @type {[{label: string, value: string},{label: string, value: string}]}
+ */
 const ORDER_BY_OPERATORS = [
     {value: "asc", label: "ascending"},
     {value: "desc", label: "descending"}
@@ -31,7 +75,6 @@ export function getOrderOperatorsByType() {
     return ORDER_BY_OPERATORS;
 }
 
-
 /**
  * Get the available operators for filtering
  * @param type
@@ -40,13 +83,14 @@ export function getOrderOperatorsByType() {
 export function getWhereOperatorsByType(type = 'string') {
     const operators = {
         string: STRING_OPERATORS,
-        number: NUMBER_OPERATORS
+        number: NUMBER_OPERATORS,
+        boolean: BOOLEAN_OPERATORS,
+        bool: BOOLEAN_OPERATORS,
+        date: DATE_OPERATORS
     };
     return operators[type];
 }
 
-/* eslint-disable no-loop-func */
-
 /**
  * Parse a GraphQL query into an AST
  * @param query
@@ -78,11 +122,9 @@ export async function generateTemplate(templateQueryToExecute, templateObject, u
     // Parse the query and apply the filters and sorters
     const ast = parseQuery(templateQueryToExecute);
 
-    let filterFields = [];
 
     if (templateObject?.filters && templateObject?.filters?.length) {
-        applyFilters(ast, templateObject.filters, filterFields);
-        wrapFiltersInAnd(ast, filterFields);
+        applyFilters(ast, templateObject.filters);
     }
 
     if (templateObject?.sorters && templateObject?.sorters?.length) {
@@ -109,7 +151,6 @@ export async function generateTemplate(templateQueryToExecute, templateObject, u
     return {contextData, useShopSpecificTemplate};
 }
 
-
 /**
  * Apply sorters to the AST
  * @param ast
@@ -170,10 +211,59 @@ export function applySorters(ast, sorters) {
     });
 }
 
+/**
+ * Apply Top Level Sub to the AST
+ * @param node
+ * @param fieldPath
+ * @param filterField
+ */
+function applyTopLevelSub(node, fieldPath, filterField) {
+    // Find or create the where argument for the top-level subfield
+    let whereArg = node.selectionSet.selections
+        .find(selection => selection.name.value === fieldPath[0])
+        ?.arguments.find(arg => arg.name.value === 'where');
+
+    if (!whereArg) {
+        whereArg = {
+            kind: Kind.ARGUMENT,
+            name: {kind: Kind.NAME, value: 'where'},
+            value: {kind: Kind.OBJECT, fields: []},
+        };
+        const topLevelSubSelection = node.selectionSet.selections.find(selection =>
+            selection.name.value === fieldPath[0]
+        );
+        if (topLevelSubSelection) {
+            topLevelSubSelection.arguments = topLevelSubSelection.arguments || [];
+            topLevelSubSelection.arguments.push(whereArg);
+        }
+    }
+
+    // Correctly position the nested filter without an extra 'where'
+    if (fieldPath.length > 2) { // More than one level deep
+        let currentField = whereArg.value;
+        fieldPath.slice(1, -1).forEach((path, index) => {
+            let existingField = currentField.fields.find(f => f.name.value === path);
+            if (!existingField) {
+                existingField = {
+                    kind: Kind.OBJECT_FIELD,
+                    name: {kind: Kind.NAME, value: path},
+                    value: {kind: Kind.OBJECT, fields: []}
+                };
+                currentField.fields.push(existingField);
+            }
+            currentField = existingField.value;
+        });
+        currentField.fields.push(filterField);
+    } else { // Directly under the top level
+        whereArg.value.fields.push(filterField);
+    }
+}
+
 /**
  * Apply filters to the AST
  * @param ast
  * @param filters
+ * @returns {ASTNode}
  */
 export function applyFilters(ast, filters) {
     return visit(ast, {
@@ -182,192 +272,197 @@ export function applyFilters(ast, filters) {
                 filters.forEach(filter => {
                     const fieldPath = filter.field.split('.');
                     let topLevel = false;
+                    let topLevelSub = false;
 
                     // Determine if the filter should be applied at the top level
-                    if (fieldPath[0].startsWith('[') && fieldPath[0].endsWith(']')) {
-                        fieldPath[0] = fieldPath[0].substring(1, fieldPath[0].length - 1); // Strip the brackets
+                    if (fieldPath.length === 2) {
                         topLevel = true;
                     }
 
-                    if (topLevel) {
-                        // Construct the filter for a top-level application
-                        const targetFieldName = fieldPath[fieldPath.length - 1];
-                        const filterValue = {
-                            kind: getGraphQLKind(filter.value),
-                            value: filter.value,
-                        };
-
-                        const nestedFilter = {
-                            kind: Kind.OBJECT_FIELD,
-                            name: {kind: Kind.NAME, value: targetFieldName},
-                            value: {
-                                kind: Kind.OBJECT,
-                                fields: [{
-                                    kind: Kind.OBJECT_FIELD,
-                                    name: {kind: Kind.NAME, value: filter.operator},
-                                    value: filterValue,
-                                }],
-                            },
-                        };
-
-                        // Find or create the where argument for the top-level field
-                        let whereArg = node.selectionSet.selections
-                            .find(selection => selection.name.value === fieldPath[0])
-                            ?.arguments.find(arg => arg.name.value === 'where');
-
-                        if (!whereArg) {
-                            whereArg = {
-                                kind: Kind.ARGUMENT,
-                                name: {kind: Kind.NAME, value: 'where'},
-                                value: {kind: Kind.OBJECT, fields: []},
-                            };
-                            const topLevelSelection = node.selectionSet.selections.find(selection =>
-                                selection.name.value === fieldPath[0]
-                            );
-                            if (topLevelSelection) {
-                                topLevelSelection.arguments = topLevelSelection.arguments || [];
-                                topLevelSelection.arguments.push(whereArg);
-                            }
-                        }
-
-                        // Correctly position the nested filter without an extra 'where'
-                        if (fieldPath.length > 2) { // More than one level deep
-                            let currentField = whereArg.value;
-                            fieldPath.slice(1, -1).forEach((path, index) => {
-                                let existingField = currentField.fields.find(f => f.name.value === path);
-                                if (!existingField) {
-                                    existingField = {
-                                        kind: Kind.OBJECT_FIELD,
-                                        name: {kind: Kind.NAME, value: path},
-                                        value: {kind: Kind.OBJECT, fields: []}
-                                    };
-                                    currentField.fields.push(existingField);
-                                }
-                                currentField = existingField.value;
-                            });
-                            currentField.fields.push(nestedFilter);
-                        } else { // Directly under the top level
-                            whereArg.value.fields.push(nestedFilter);
-                        }
-                    } else {
-                        // Initialize a reference to the current selection to traverse down the AST
-                        let currentSelection = node;
-                        let whereArgFound = false;
-
-                        // Iterate over the fieldPath, except for the last entry, to navigate the structure
-                        for (let i = 0; i < fieldPath.length - 1; i++) {
-                            const fieldName = fieldPath[i];
-                            let fieldFound = false;
-
-                            // Check if the current selection has a selectionSet and selections
-                            if (currentSelection.selectionSet && currentSelection.selectionSet.selections) {
-                                // Look for the field in the current selection's selections
-                                const selection = currentSelection.selectionSet.selections.find(sel => sel.name.value === fieldName);
-                                if (selection) {
-                                    // Move down the AST to the found selection
-                                    currentSelection = selection;
-                                    fieldFound = true;
-                                }
-                            }
-
-                            // If the field was not found in the current path, it's an issue
-                            if (!fieldFound) {
-                                console.error(`Field ${fieldName} not found in the current selection.`);
-                                return; // Exit the loop and function due to error
-                            }
-                        }
-
-                        // At this point, currentSelection should be the parent field where the filter needs to be applied
-                        // Check if the 'where' argument already exists in the current selection
-                        const whereArg = currentSelection.arguments.find(arg => arg.name.value === 'where');
-                        if (whereArg) {
-                            whereArgFound = true;
-                        } else {
-                            // If not found, create a new 'where' argument for the current selection
-                            currentSelection.arguments.push({
-                                kind: Kind.ARGUMENT,
-                                name: {kind: Kind.NAME, value: 'where'},
-                                value: {kind: Kind.OBJECT, fields: []} // Empty fields array to be populated with the filter
-                            });
-                        }
-
-                        // Assuming the last entry in fieldPath is the field to apply the filter on
-                        const targetField = fieldPath[fieldPath.length - 1];
-                        const filterValue = {
-                            kind: getGraphQLKind(filter.value),
-                            value: filter.value,
-                        };
-
-                        // Construct the filter field object
-                        const filterField = {
-                            kind: Kind.OBJECT_FIELD,
-                            name: {kind: Kind.NAME, value: targetField},
-                            value: {
-                                kind: Kind.OBJECT,
-                                fields: [{
-                                    kind: Kind.OBJECT_FIELD,
-                                    name: {kind: Kind.NAME, value: filter.operator},
-                                    value: filterValue,
-                                }],
-                            },
-                        };
-
-                        // Add the filter field to the 'where' clause of the current selection
-                        if (whereArgFound) {
-                            whereArg.value.fields.push(filterField);
-                        } else {
-                            // If the whereArg was newly created, find it again (since we didn't store its reference) and add the filter
-                            currentSelection.arguments.find(arg => arg.name.value === 'where').value.fields.push(filterField);
-                        }
+                    if (fieldPath.length > 2 && fieldPath[0].startsWith('[') && fieldPath[0].endsWith(']')) {
+                        fieldPath[0] = fieldPath[0].substring(1, fieldPath[0].length - 1); // Strip the brackets
+                        topLevelSub = true;
                     }
 
+                    // Construct the filter for a top-level application
+                    const targetFieldName = fieldPath[fieldPath.length - 1];
+
+                    let filterValue = createFilterValue(filter);
+                    let filterField = createFilterField(targetFieldName, filter, filterValue);
+
+                    if (topLevel) {
+                        applyTopLevelFilter(node, fieldPath, filterField);
+                    } else if (topLevelSub) {
+                        applyTopLevelSub(node, fieldPath, filterField);
+                    } else {
+                        applyNestedFilter(node, fieldPath, filterField);
+                    }
                 });
             }
         }
     });
 }
 
+/**
+ * Create a filter value based on the filter
+ * @param filter
+ * @returns {{kind: (Kind|Kind.INT), value}|{kind: Kind.LIST, values: *}}
+ */
+function createFilterValue(filter) {
+    if (Array.isArray(filter.value)) {
+        // If it's an array, create a list value with the array items
+        return {
+            kind: Kind.LIST,
+            values: filter.value.map(item => ({
+                kind: getGraphQLKind(item),
+                value: item,
+            })),
+        };
+    } else {
+        // If it's not an array, use the existing logic
+        return {
+            kind: getGraphQLKind(filter.value),
+            value: filter.value,
+        };
+    }
+}
+
+/**
+ * Create a filter field based on the target field and filter
+ * @param targetFieldName
+ * @param filter
+ * @param filterValue
+ * @returns {{kind: Kind.OBJECT_FIELD, name: {kind: Kind.NAME, value}, value: {kind: Kind.OBJECT, fields: [{kind: Kind.OBJECT_FIELD, name: {kind: Kind.NAME, value}, value}]}}}
+ */
+function createFilterField(targetFieldName, filter, filterValue) {
+    return {
+        kind: Kind.OBJECT_FIELD,
+        name: {kind: Kind.NAME, value: targetFieldName},
+        value: {
+            kind: Kind.OBJECT,
+            fields: [{
+                kind: Kind.OBJECT_FIELD,
+                name: {kind: Kind.NAME, value: filter.operator},
+                value: filterValue,
+            }],
+        },
+    };
+}
+
+/**
+ * Apply a top-level filter to the AST
+ * @param node
+ * @param fieldPath
+ * @param filterField
+ */
+function applyTopLevelFilter(node, fieldPath, filterField) {
+    // Find or create the where argument for the top-level field
+    let whereArg = node.selectionSet.selections
+        .find(selection => selection.name.value === fieldPath[0])
+        ?.arguments.find(arg => arg.name.value === 'where');
+
+    if (!whereArg) {
+        whereArg = {
+            kind: Kind.ARGUMENT,
+            name: {kind: Kind.NAME, value: 'where'},
+            value: {kind: Kind.OBJECT, fields: []},
+        };
+        const topLevelSelection = node.selectionSet.selections.find(selection =>
+            selection.name.value === fieldPath[0]
+        );
+        if (topLevelSelection) {
+            topLevelSelection.arguments = topLevelSelection.arguments || [];
+            topLevelSelection.arguments.push(whereArg);
+        }
+    }
+
+    // Correctly position the nested filter without an extra 'where'
+    if (fieldPath.length > 2) { // More than one level deep
+        let currentField = whereArg.value;
+        fieldPath.slice(1, -1).forEach((path, index) => {
+            let existingField = currentField.fields.find(f => f.name.value === path);
+            if (!existingField) {
+                existingField = {
+                    kind: Kind.OBJECT_FIELD,
+                    name: {kind: Kind.NAME, value: path},
+                    value: {kind: Kind.OBJECT, fields: []}
+                };
+                currentField.fields.push(existingField);
+            }
+            currentField = existingField.value;
+        });
+        currentField.fields.push(filterField);
+    } else { // Directly under the top level
+        whereArg.value.fields.push(filterField);
+    }
+}
+
+/**
+ * Apply a nested filter to the AST
+ * @param node
+ * @param fieldPath
+ * @param filterField
+ */
+function applyNestedFilter(node, fieldPath, filterField) {
+    // Initialize a reference to the current selection to traverse down the AST
+    let currentSelection = node;
+
+    // Iterate over the fieldPath, except for the last entry, to navigate the structure
+    for (let i = 0; i < fieldPath.length - 1; i++) {
+        const fieldName = fieldPath[i];
+        let fieldFound = false;
+
+        // Check if the current selection has a selectionSet and selections
+        if (currentSelection.selectionSet && currentSelection.selectionSet.selections) {
+            // Look for the field in the current selection's selections
+            const selection = currentSelection.selectionSet.selections.find(sel => sel.name.value === fieldName);
+            if (selection) {
+                // Move down the AST to the found selection
+                currentSelection = selection;
+                fieldFound = true;
+            }
+        }
+
+        // If the field was not found in the current path, it's an issue
+        if (!fieldFound) {
+            console.error(`Field ${fieldName} not found in the current selection.`);
+            return; // Exit the loop and function due to error
+        }
+    }
+
+    // At this point, currentSelection should be the parent field where the filter needs to be applied
+    // Check if the 'where' argument already exists in the current selection
+    const whereArg = currentSelection.arguments.find(arg => arg.name.value === 'where');
+    if (!whereArg) {
+        // If not found, create a new 'where' argument for the current selection
+        currentSelection.arguments.push({
+            kind: Kind.ARGUMENT,
+            name: {kind: Kind.NAME, value: 'where'},
+            value: {kind: Kind.OBJECT, fields: []} // Empty fields array to be populated with the filter
+        });
+    }
+
+    // Add the filter field to the 'where' clause of the current selection
+    currentSelection.arguments.find(arg => arg.name.value === 'where').value.fields.push(filterField);
+}
+
 /**
  * Get the GraphQL kind for a value
  * @param value
  * @returns {Kind|Kind.INT}
  */
 function getGraphQLKind(value) {
-    if (typeof value === 'number') {
+    if (Array.isArray(value)) {
+        return Kind.LIST;
+    } else if (typeof value === 'number') {
         return value % 1 === 0 ? Kind.INT : Kind.FLOAT;
     } else if (typeof value === 'boolean') {
         return Kind.BOOLEAN;
     } else if (typeof value === 'string') {
         return Kind.STRING;
+    } else if (value instanceof Date) {
+        return Kind.STRING; // GraphQL does not have a Date type, so we return it as a string
     }
-    // Extend with more types as needed
 }
 
-/**
- * Wrap filters in an 'and' object
- * @param ast
- * @param filterFields
- */
-export function wrapFiltersInAnd(ast, filterFields) {
-    visit(ast, {
-        OperationDefinition: {
-            enter(node) {
-                node.selectionSet.selections.forEach((selection) => {
-                    let whereArg = selection.arguments.find(arg => arg.name.value === 'where');
-                    if (filterFields.length > 1) {
-                        const andFilter = {
-                            kind: Kind.OBJECT_FIELD,
-                            name: {kind: Kind.NAME, value: '_and'},
-                            value: {kind: Kind.LIST, values: filterFields}
-                        };
-                        whereArg.value.fields.push(andFilter);
-                    } else if (filterFields.length === 1) {
-                        whereArg.value.fields.push(filterFields[0].fields[0]);
-                    }
-                });
-            }
-        }
-    });
-}
-
-/* eslint-enable no-loop-func */
+/* eslint-enable no-loop-func */

hasura/metadata/tables.yaml

@@ -259,28 +259,30 @@
                 - active:
                     _eq: true
         columns:
-          - id
+          - billid
+          - bodyshopid
           - created
-          - operation
+          - id
+          - jobid
           - new_val
           - old_val
+          - operation
+          - type
           - useremail
-          - bodyshopid
-          - jobid
-          - billid
   select_permissions:
     - role: user
       permission:
         columns:
+          - billid
+          - bodyshopid
+          - created
           - id
+          - jobid
           - new_val
           - old_val
           - operation
+          - type
           - useremail
-          - created
-          - billid
-          - bodyshopid
-          - jobid
         filter:
           bodyshop:
             associations:
@@ -4198,7 +4200,7 @@
         interval_sec: 10
         num_retries: 0
         timeout_sec: 60
-      webhook_from_env: HASURA_API_URL
+      webhook: https://worktest.home.irony.online
       headers:
         - name: event-secret
           value_from_env: EVENT_SECRET

hasura/migrations/1709671738458_alter_table_public_audit_trail_add_column_type/down.sql

@@ -0,0 +1,4 @@
+-- Could not auto-generate a down migration.
+-- Please write an appropriate down migration for the SQL below:
+-- alter table "public"."audit_trail" add column "type" text
+--  null;

hasura/migrations/1709671738458_alter_table_public_audit_trail_add_column_type/up.sql

@@ -0,0 +1,2 @@
+alter table "public"."audit_trail" add column "type" text
+ null;

hasura/migrations/1710520532230_alter_table_public_ioevents_add_column_useremail/down.sql

@@ -0,0 +1,4 @@
+-- Could not auto-generate a down migration.
+-- Please write an appropriate down migration for the SQL below:
+-- alter table "public"."ioevents" add column "useremail" text
+--  not null;

hasura/migrations/1710520532230_alter_table_public_ioevents_add_column_useremail/up.sql

@@ -0,0 +1 @@
+alter table "public"."ioevents" add column "useremail" text;

hasura/migrations/1710520551755_alter_table_public_ioevents_add_column_bodyshopid/down.sql

@@ -0,0 +1,4 @@
+-- Could not auto-generate a down migration.
+-- Please write an appropriate down migration for the SQL below:
+-- alter table "public"."ioevents" add column "bodyshopid" uuid
+--  null;

hasura/migrations/1710520551755_alter_table_public_ioevents_add_column_bodyshopid/up.sql

@@ -0,0 +1,2 @@
+alter table "public"."ioevents" add column "bodyshopid" uuid
+ null;

hasura/migrations/1710520563676_alter_table_public_ioevents_alter_column_useremail/down.sql

@@ -0,0 +1 @@
+alter table "public"."ioevents" alter column "useremail" set not null;

hasura/migrations/1710520563676_alter_table_public_ioevents_alter_column_useremail/up.sql

@@ -0,0 +1 @@
+alter table "public"."ioevents" alter column "useremail" drop not null;

hasura/migrations/1710520583458_alter_table_public_ioevents_add_column_env/down.sql

@@ -0,0 +1,4 @@
+-- Could not auto-generate a down migration.
+-- Please write an appropriate down migration for the SQL below:
+-- alter table "public"."ioevents" add column "env" text
+--  null;

hasura/migrations/1710520583458_alter_table_public_ioevents_add_column_env/up.sql

@@ -0,0 +1,2 @@
+alter table "public"."ioevents" add column "env" text
+ null;

hasura/migrations/1710520629475_create_index_ioevents_useremail/down.sql

@@ -0,0 +1 @@
+DROP INDEX IF EXISTS "public"."ioevents_useremail";

hasura/migrations/1710520629475_create_index_ioevents_useremail/up.sql

@@ -0,0 +1,2 @@
+CREATE  INDEX "ioevents_useremail" on
+  "public"."ioevents" using btree ("useremail");

hasura/migrations/1710520654372_set_fk_public_ioevents_useremail/down.sql

@@ -0,0 +1 @@
+alter table "public"."ioevents" drop constraint "ioevents_useremail_fkey";

hasura/migrations/1710520654372_set_fk_public_ioevents_useremail/up.sql

@@ -0,0 +1,5 @@
+alter table "public"."ioevents"
+  add constraint "ioevents_useremail_fkey"
+  foreign key ("useremail")
+  references "public"."users"
+  ("email") on update set null on delete set null;

hasura/migrations/1710520693899_set_fk_public_ioevents_bodyshopid/down.sql

@@ -0,0 +1 @@
+alter table "public"."ioevents" drop constraint "ioevents_bodyshopid_fkey";

hasura/migrations/1710520693899_set_fk_public_ioevents_bodyshopid/up.sql

@@ -0,0 +1,5 @@
+alter table "public"."ioevents"
+  add constraint "ioevents_bodyshopid_fkey"
+  foreign key ("bodyshopid")
+  references "public"."bodyshops"
+  ("id") on update set null on delete set null;

hasura/migrations/1710523428339_create_index_idx_audit_trail_type/down.sql

@@ -0,0 +1 @@
+DROP INDEX IF EXISTS "public"."idx_audit_trail_type";

hasura/migrations/1710523428339_create_index_idx_audit_trail_type/up.sql

@@ -0,0 +1,2 @@
+CREATE  INDEX "idx_audit_trail_type" on
+  "public"."audit_trail" using btree ("type");

package.json

@@ -18,49 +18,51 @@
     "start": "node server.js"
   },
   "dependencies": {
-    "@aws-sdk/client-secrets-manager": "^3.515.0",
-    "@aws-sdk/client-ses": "^3.515.0",
-    "@aws-sdk/credential-provider-node": "^3.515.0",
+    "@aws-sdk/client-secrets-manager": "^3.525.0",
+    "@aws-sdk/client-ses": "^3.525.0",
+    "@aws-sdk/credential-provider-node": "^3.525.0",
+    "@azure/storage-blob": "^12.17.0",
     "@opensearch-project/opensearch": "^2.5.0",
     "aws4": "^1.12.0",
     "axios": "^1.6.5",
     "bluebird": "^3.7.2",
     "body-parser": "^1.20.2",
-    "cloudinary": "^2.0.1",
+    "cloudinary": "^2.0.2",
     "compression": "^1.7.4",
     "cookie-parser": "^1.4.6",
     "cors": "2.8.5",
     "csrf": "^3.1.0",
     "dinero.js": "^1.9.1",
     "dotenv": "^16.4.5",
-    "express": "^4.18.2",
+    "express": "^4.18.3",
     "firebase-admin": "^12.0.0",
     "graphql": "^16.8.1",
     "graphql-request": "^6.1.0",
     "graylog2": "^0.2.1",
     "inline-css": "^4.0.2",
     "intuit-oauth": "^4.0.0",
-    "json-2-csv": "^5.2.0",
+    "json-2-csv": "^5.5.0",
     "lodash": "^4.17.21",
     "moment": "^2.30.1",
     "moment-timezone": "^0.5.45",
     "multer": "^1.4.5-lts.1",
     "node-mailjet": "^6.0.5",
     "node-persist": "^4.0.1",
-    "node-quickbooks": "^2.0.43",
-    "nodemailer": "^6.9.10",
+    "node-quickbooks": "^2.0.44",
+    "nodemailer": "^6.9.11",
     "phone": "^3.1.42",
     "rimraf": "^5.0.5",
     "soap": "^1.0.0",
     "socket.io": "^4.7.4",
     "ssh2-sftp-client": "^10.0.3",
-    "stripe": "^14.18.0",
-    "twilio": "^4.22.0",
+    "stripe": "^14.19.0",
+    "twilio": "^4.23.0",
     "uuid": "^9.0.1",
     "xml2js": "^0.6.2",
     "xmlbuilder2": "^3.1.1"
   },
   "devDependencies": {
+    "@trivago/prettier-plugin-sort-imports": "^4.3.0",
     "concurrently": "^8.2.2",
     "source-map-explorer": "^2.5.2"
   }

server/data/kaizen.js

@@ -193,28 +193,33 @@ exports.default = async (req, res) => {
                 });
             }
 
-            //***TODO  Change filing naming when creating the cron job. IM_ShopInternalName_DDMMYYYY_HHMMSS.xml
-        } catch (error) {
-            logger.log("kaizen-sftp-error", "ERROR", "api", null, {
-                ...error,
-            });
-        } finally {
-            sftp.end();
-        }
-        sendServerEmail({
-            subject: `Kaizen Report ${moment().format("MM-DD-YY")}`,
-            text: `Errors: ${allErrors.map((e) => JSON.stringify(e, null, 2))}
-      Uploaded: ${JSON.stringify(
-                allxmlsToUpload.map((x) => ({filename: x.filename, count: x.count})),
-                null,
-                2
-            )}
-      `,
-        });
-        res.sendStatus(200);
+      //***TODO  Change filing naming when creating the cron job. IM_ShopInternalName_DDMMYYYY_HHMMSS.xml
     } catch (error) {
-        res.status(200).json(error);
+      logger.log("kaizen-sftp-error", "ERROR", "api", null, {
+        ...error,
+      });
+    } finally {
+      sftp.end();
     }
+    // sendServerEmail({
+    //   subject: `Kaizen Report ${moment().format("MM-DD-YY")}`,
+    //   text: `Errors: ${allErrors.map((e) => JSON.stringify(e, null, 2))}
+    //   Uploaded: ${JSON.stringify(
+    //     allxmlsToUpload.map((x) => ({ filename: x.filename, count: x.count })),
+    //     null,
+    //     2
+    //   )}
+    //   `,
+    // });
+    res.sendStatus(200);
+  } catch (error) {
+    res.status(200).json(error);
+        sendServerEmail({
+            subject: `Kaizen Report ${moment().format("MM-DD-YY @ HH:mm:ss")}`,
+            text: `Errors: JSON.stringify(error)}
+      All Errors: ${allErrors.map((e) => JSON.stringify(e, null, 2))}`,
+        });
+  }
 };
 
 const CreateRepairOrderTag = (job, errorCallback) => {