IO-2383 TimeTicket Employee Range Filter

Release/2023 08 11

client/src/utils/TemplateConstants.js

@@ -1040,7 +1040,7 @@ export const TemplateList = (type, context) => {
             disabled: false,
             rangeFilter: {
               object: i18n.t("reportcenter.labels.objects.jobs"),
-              field: i18n.t("jobs.fields.date_open"),
+              field: i18n.t("jobs.fields.date_invoiced"),
             },
             group: "jobs",
           },
@@ -1135,6 +1135,10 @@ export const TemplateList = (type, context) => {
             key: "timetickets_employee",
             idtype: "employee",
             disabled: false,
+            rangeFilter: {
+              object: i18n.t("reportcenter.labels.objects.timetickets"),
+              field: i18n.t("timetickets.fields.date"),
+            },
             group: "payroll",
           },
           attendance_detail: {

hasura/migrations/1691177401095_create_index_parts_dispatch_employeeid/down.sql

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

hasura/migrations/1691177401095_create_index_parts_dispatch_employeeid/up.sql

@@ -0,0 +1,2 @@
+CREATE  INDEX "parts_dispatch_employeeid" on
+  "public"."parts_dispatch" using btree ("employeeid");

hasura/migrations/1691177452060_create_index_parts_dispatch_dispatchid/down.sql

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

hasura/migrations/1691177452060_create_index_parts_dispatch_dispatchid/up.sql

@@ -0,0 +1,2 @@
+CREATE  INDEX "parts_dispatch_dispatchid" on
+  "public"."parts_dispatch_lines" using btree ("partsdispatchid");

hasura/migrations/1691177467690_create_index_parts_dispatch_line_accepted_at/down.sql

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

hasura/migrations/1691177467690_create_index_parts_dispatch_line_accepted_at/up.sql

@@ -0,0 +1,2 @@
+CREATE  INDEX "parts_dispatch_line_accepted_at" on
+  "public"."parts_dispatch_lines" using btree ("accepted_at");

server/graphql-client/queries.js

@@ -620,6 +620,7 @@ exports.QUERY_EMPLOYEE_PIN = `query QUERY_EMPLOYEE_PIN($shopId: uuid!, $employee
     employee_number
     id
     pin
+    active
   }
 }`;
 

server/tech/tech.js

@@ -23,7 +23,7 @@ exports.techLogin = async (req, res) => {
     let technician;
     if (result.employees && result.employees[0]) {
       const dbRecord = result.employees[0];
-      if (dbRecord.pin === pin) {
+      if (dbRecord.pin === pin && dbRecord.active === true) {
         valid = true;
         delete dbRecord.pin;
         technician = dbRecord;