IO-3222 Vendor Name Open Search

Signed-off-by: Allan Carr <allan.carr@thinkimex.com>

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

@@ -188,6 +188,9 @@ export function JobsDetailGeneral({ bodyshop, jobRO, job, form }) {
             <Form.Item label={t("jobs.fields.tlos_ind")} name="tlos_ind" valuePropName="checked">
               <Switch disabled={jobRO} />
             </Form.Item>
+            <Form.Item label={t("jobs.fields.acv_amount")} name="acv_amount">
+              <CurrencyInput disabled={jobRO} min={0} />
+            </Form.Item>
           </FormRow>
         </Col>
         <Col {...lossColDamage}>

client/src/graphql/jobs.queries.js

@@ -423,6 +423,7 @@ export const GET_JOB_BY_PK = gql`
       actual_completion
       actual_delivery
       actual_in
+      acv_amount
       adjustment_bottom_line
       alt_transport
       area_of_damage

client/src/translations/en_us/common.json

@@ -1636,6 +1636,7 @@
         "actual_completion": "Actual Completion",
         "actual_delivery": "Actual Delivery",
         "actual_in": "Actual In",
+        "acv_amount": "ACV Amount",
         "adjustment_bottom_line": "Adjustments",
         "adjustmenthours": "Adjustment Hours",
         "alt_transport": "Alt. Trans.",

client/src/translations/es/common.json

@@ -1636,6 +1636,7 @@
         "actual_completion": "Realización real",
         "actual_delivery": "Entrega real",
         "actual_in": "Real en",
+        "acv_amount": "",
         "adjustment_bottom_line": "Ajustes",
         "adjustmenthours": "",
         "alt_transport": "",

client/src/translations/fr/common.json

@@ -1637,6 +1637,7 @@
         "actual_completion": "Achèvement réel",
         "actual_delivery": "Livraison réelle",
         "actual_in": "En réel",
+        "acv_amount": "",
         "adjustment_bottom_line": "Ajustements",
         "adjustmenthours": "",
         "alt_transport": "",

hasura/metadata/tables.yaml

@@ -3595,6 +3595,7 @@
           - actual_completion
           - actual_delivery
           - actual_in
+          - acv_amount
           - adj_g_disc
           - adj_strdis
           - adj_towdis
@@ -3700,6 +3701,7 @@
           - federal_tax_rate
           - flat_rate_ats
           - g_bett_amt
+          - hit_and_run
           - id
           - inproduction
           - ins_addr1
@@ -3866,6 +3868,7 @@
           - actual_completion
           - actual_delivery
           - actual_in
+          - acv_amount
           - adj_g_disc
           - adj_strdis
           - adj_towdis
@@ -3972,6 +3975,7 @@
           - federal_tax_rate
           - flat_rate_ats
           - g_bett_amt
+          - hit_and_run
           - id
           - inproduction
           - ins_addr1
@@ -4150,6 +4154,7 @@
           - actual_completion
           - actual_delivery
           - actual_in
+          - acv_amount
           - adj_g_disc
           - adj_strdis
           - adj_towdis
@@ -4256,6 +4261,7 @@
           - federal_tax_rate
           - flat_rate_ats
           - g_bett_amt
+          - hit_and_run
           - id
           - inproduction
           - ins_addr1

hasura/migrations/1745438734125_alter_table_public_jobs_add_column_acv_amount/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"."jobs" add column "acv_amount" numeric
+--  null;

hasura/migrations/1745438734125_alter_table_public_jobs_add_column_acv_amount/up.sql

@@ -0,0 +1,2 @@
+alter table "public"."jobs" add column "acv_amount" numeric
+ null;

server/opensearch/os-handler.js

@@ -64,7 +64,7 @@ async function OpenSearchUpdateHandler(req, res) {
           document = pick(req.body.event.data.new, ["id", "ownr_fn", "ownr_ln", "ownr_co_nm", "ownr_ph1", "ownr_ph2"]);
           document.bodyshopid = req.body.event.data.new.shopid;
           break;
-        case "bills":
+        case "bills": {
           const bill = await client.request(
             `query ADMIN_GET_BILL_BY_ID($billId: uuid!) {
             bills_by_pk(id: $billId) {
@@ -97,7 +97,8 @@ async function OpenSearchUpdateHandler(req, res) {
             bodyshopid: bill.bills_by_pk.job.shopid
           };
           break;
-        case "payments":
+        }
+        case "payments": {
           //Query to get the job and RO number
 
           const payment = await client.request(
@@ -141,6 +142,7 @@ async function OpenSearchUpdateHandler(req, res) {
             bodyshopid: payment.payments_by_pk.job.shopid
           };
           break;
+        }
       }
       const payload = {
         id: req.body.event.data.new.id,
@@ -255,6 +257,7 @@ async function OpenSearchSearchHandler(req, res) {
                           "*ownr_co_nm^8",
                           "*ownr_ph1^8",
                           "*ownr_ph2^8",
+                          "*vendor.name^8",
                           "*comment^6"
                           //  "*"
                         ]