IO-3435 SpeedPrint Filtering in Config

Signed-off-by: Allan Carr <allan@imexsystems.ca>

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

@@ -4,10 +4,18 @@ import { useTranslation } from "react-i18next";
 import { TemplateList } from "../../utils/TemplateConstants";
 import FormListMoveArrows from "../form-list-move-arrows/form-list-move-arrows.component";
 import LayoutFormRow from "../layout-form-row/layout-form-row.component";
+import InstanceRenderManager from "../../utils/instanceRenderMgr";
 
 export default function ShopInfoSpeedPrint() {
   const { t } = useTranslation();
-  const TemplateListGenerated = TemplateList("job");
+  const allTemplates = TemplateList("job");
+  const TemplateListGenerated = InstanceRenderManager({
+    imex: Object.fromEntries(
+      Object.entries(allTemplates).filter(([, { enhanced_payroll }]) => !enhanced_payroll)
+    ),
+    rome: allTemplates
+  });
+
   return (
     <Form.List name={["speedprint"]}>
       {(fields, { add, remove, move }) => {

hasura/migrations/1762815418708_set_fk_public_media_analytics_detail_jobid/down.sql

@@ -1,5 +0,0 @@
-alter table "public"."media_analytics_detail" drop constraint "media_analytics_detail_jobid_fkey",
-  add constraint "media_analytics_detail_jobid_fkey"
-  foreign key ("jobid")
-  references "public"."jobs"
-  ("id") on update restrict on delete restrict;

hasura/migrations/1762815418708_set_fk_public_media_analytics_detail_jobid/up.sql

@@ -1,5 +0,0 @@
-alter table "public"."media_analytics_detail" drop constraint "media_analytics_detail_jobid_fkey",
-  add constraint "media_analytics_detail_jobid_fkey"
-  foreign key ("jobid")
-  references "public"."jobs"
-  ("id") on update set null on delete set null;

hasura/migrations/1762816491980_media_analytics_fk_trigger/down.sql

@@ -1,23 +0,0 @@
--- Could not auto-generate a down migration.
--- Please write an appropriate down migration for the SQL below:
--- CREATE OR REPLACE FUNCTION set_fk_to_null_if_invalid_media_analytics()
--- RETURNS TRIGGER AS $$
--- BEGIN
---     -- Check if the foreign key value is not NULL
---     IF NEW.jobid IS NOT NULL THEN
---         -- Check if the corresponding record exists in the parent table
---         IF NOT EXISTS (SELECT 1 FROM jobs WHERE id = NEW.jobid) THEN
---             -- If it doesn't exist, set the foreign key to NULL
---             NEW.jobid = NULL;
---         END IF;
---     END IF;
---
---     -- Return the (potentially modified) record to be inserted/updated
---     RETURN NEW;
--- END;
--- $$ LANGUAGE plpgsql;
---
--- CREATE TRIGGER media_analytics_fk_null
--- BEFORE INSERT OR UPDATE ON media_analytics_detail
--- FOR EACH ROW
--- EXECUTE FUNCTION set_fk_to_null_if_invalid_media_analytics();

hasura/migrations/1762816491980_media_analytics_fk_trigger/up.sql

@@ -1,21 +0,0 @@
-CREATE OR REPLACE FUNCTION set_fk_to_null_if_invalid_media_analytics()
-RETURNS TRIGGER AS $$
-BEGIN
-    -- Check if the foreign key value is not NULL
-    IF NEW.jobid IS NOT NULL THEN
-        -- Check if the corresponding record exists in the parent table
-        IF NOT EXISTS (SELECT 1 FROM jobs WHERE id = NEW.jobid) THEN
-            -- If it doesn't exist, set the foreign key to NULL
-            NEW.jobid = NULL;
-        END IF;
-    END IF;
-    
-    -- Return the (potentially modified) record to be inserted/updated
-    RETURN NEW;
-END;
-$$ LANGUAGE plpgsql;
-
-CREATE TRIGGER media_analytics_fk_null
-BEFORE INSERT OR UPDATE ON media_analytics_detail
-FOR EACH ROW
-EXECUTE FUNCTION set_fk_to_null_if_invalid_media_analytics();

hasura/migrations/1762823244230_create_index_media_analytics_detail_bodyshopid/down.sql

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

hasura/migrations/1762823244230_create_index_media_analytics_detail_bodyshopid/up.sql

@@ -1,2 +0,0 @@
-CREATE  INDEX "media_analytics_detail_bodyshopid" on
-  "public"."media_analytics_detail" using btree ("bodyshopid");

hasura/migrations/1762823258200_create_index_media_analytics_detail_jobid/down.sql

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

hasura/migrations/1762823258200_create_index_media_analytics_detail_jobid/up.sql

@@ -1,2 +0,0 @@
-CREATE  INDEX "media_analytics_detail_jobid" on
-  "public"."media_analytics_detail" using btree ("jobid");

hasura/migrations/1762823298618_create_index_media_analytics_detail_media_analytics/down.sql

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

hasura/migrations/1762823298618_create_index_media_analytics_detail_media_analytics/up.sql

@@ -1,2 +0,0 @@
-CREATE  INDEX "media_analytics_detail_media_analytics" on
-  "public"."media_analytics_detail" using btree ("media_analytics_id");

hasura/migrations/1763425916748_alter_table_public_media_analytics_add_column_unique_documents/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"."media_analytics" add column "unique_documents" numeric
---  null;

hasura/migrations/1763425916748_alter_table_public_media_analytics_add_column_unique_documents/up.sql

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

hasura/migrations/1763425927136_alter_table_public_media_analytics_add_column_duplicate_documents/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"."media_analytics" add column "duplicate_documents" numeric
---  null;

hasura/migrations/1763425927136_alter_table_public_media_analytics_add_column_duplicate_documents/up.sql

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

hasura/migrations/1763425947348_alter_table_public_media_analytics_detail_add_column_unique_documents/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"."media_analytics_detail" add column "unique_documents" numeric
---  null;

hasura/migrations/1763425947348_alter_table_public_media_analytics_detail_add_column_unique_documents/up.sql

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

hasura/migrations/1763425960252_alter_table_public_media_analytics_detail_add_column_duplicate_documents/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"."media_analytics_detail" add column "duplicate_documents" numeric
---  null;

hasura/migrations/1763425960252_alter_table_public_media_analytics_detail_add_column_duplicate_documents/up.sql

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

hasura/migrations/1763426307543_alter_table_public_media_analytics_detail_alter_column_unique_documents/down.sql

@@ -1 +0,0 @@
-alter table "public"."media_analytics_detail" rename column "unique_document_count" to "unique_documents";

hasura/migrations/1763426307543_alter_table_public_media_analytics_detail_alter_column_unique_documents/up.sql

@@ -1 +0,0 @@
-alter table "public"."media_analytics_detail" rename column "unique_documents" to "unique_document_count";

hasura/migrations/1763426323408_alter_table_public_media_analytics_detail_alter_column_duplicate_documents/down.sql

@@ -1 +0,0 @@
-alter table "public"."media_analytics_detail" rename column "duplicate_count" to "duplicate_documents";

hasura/migrations/1763426323408_alter_table_public_media_analytics_detail_alter_column_duplicate_documents/up.sql

@@ -1 +0,0 @@
-alter table "public"."media_analytics_detail" rename column "duplicate_documents" to "duplicate_count";