IO-2518 Null coalesce for v_vin for warning

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

@@ -221,6 +221,11 @@ export function JobsDetailHeader({ job, bodyshop, disabled }) {
               <VehicleVinDisplay>
                 {`${job.v_vin || t("general.labels.na")}`}
               </VehicleVinDisplay>
+              {bodyshop.pbs_serialnumber || bodyshop.cdk_dealerid ? (
+                job.v_vin?.length !== 17 ? (
+                  <WarningFilled style={{ color: "tomato", marginLeft: ".3rem" }} />
+                ) : null
+              ) : null}
             </DataLabel>
             <DataLabel label={t("jobs.fields.regie_number")}>
               {job.regie_number || t("general.labels.na")}

hasura/metadata/tables.yaml

@@ -2023,24 +2023,24 @@
                   - active:
                       _eq: true
         columns:
-          - created_at
-          - employeeid
-          - id
           - labor_rates
           - percentage
-          - teamid
+          - created_at
           - updated_at
+          - employeeid
+          - id
+          - teamid
   select_permissions:
     - role: user
       permission:
         columns:
-          - created_at
-          - employeeid
-          - id
           - labor_rates
           - percentage
-          - teamid
+          - created_at
           - updated_at
+          - employeeid
+          - id
+          - teamid
         filter:
           employee_team:
             bodyshop:
@@ -2055,13 +2055,13 @@
     - role: user
       permission:
         columns:
-          - created_at
-          - employeeid
-          - id
           - labor_rates
           - percentage
-          - teamid
+          - created_at
           - updated_at
+          - employeeid
+          - id
+          - teamid
         filter:
           employee_team:
             bodyshop:
@@ -2123,23 +2123,21 @@
                     _eq: true
         columns:
           - active
-          - bodyshopid
-          - created_at
-          - id
-          - max_load
           - name
+          - created_at
           - updated_at
+          - bodyshopid
+          - id
   select_permissions:
     - role: user
       permission:
         columns:
           - active
-          - bodyshopid
-          - created_at
-          - id
-          - max_load
           - name
+          - created_at
           - updated_at
+          - bodyshopid
+          - id
         filter:
           bodyshop:
             associations:
@@ -2155,7 +2153,6 @@
         columns:
           - active
           - bodyshopid
-          - max_load
           - name
           - updated_at
         filter:

hasura/migrations/1704401074280_alter_table_public_employee_team_members_add_column_max_load/down.sql

@@ -1,4 +0,0 @@
--- Could not auto-generate a down migration.
--- Please write an appropriate down migration for the SQL below:
--- alter table "public"."employee_team_members" add column "max_load" numeric
---  not null default '10000';

hasura/migrations/1704401074280_alter_table_public_employee_team_members_add_column_max_load/up.sql

@@ -1,2 +0,0 @@
-alter table "public"."employee_team_members" add column "max_load" numeric
- not null default '10000';

hasura/migrations/1704403786392_alter_table_public_employee_team_members_drop_column_max_load/down.sql

@@ -1,3 +0,0 @@
-alter table "public"."employee_team_members" alter column "max_load" set default '10000'::numeric;
-alter table "public"."employee_team_members" alter column "max_load" drop not null;
-alter table "public"."employee_team_members" add column "max_load" numeric;

hasura/migrations/1704403786392_alter_table_public_employee_team_members_drop_column_max_load/up.sql

@@ -1 +0,0 @@
-alter table "public"."employee_team_members" drop column "max_load" cascade;

hasura/migrations/1704403846373_alter_table_public_employee_teams_add_column_max_load/down.sql

@@ -1,4 +0,0 @@
--- Could not auto-generate a down migration.
--- Please write an appropriate down migration for the SQL below:
--- alter table "public"."employee_teams" add column "max_load" numeric
---  not null default '10000';

hasura/migrations/1704403846373_alter_table_public_employee_teams_add_column_max_load/up.sql

@@ -1,2 +0,0 @@
-alter table "public"."employee_teams" add column "max_load" numeric
- not null default '10000';