Processes DDL

Ver en Git

---

Creación de la DB

#! ToDo: Agregar secuencias automágicas en los ids

------------------------------------ PROCESS -------------------------------------------------
DROP TABLE "proc_tasks";
DROP TABLE "proc_users_roles";
DROP TABLE "proc_groups";
DROP TABLE "proc_processes";
DROP TABLE "proc_roles";
DROP TABLE "proc_def_processes";
DROP TABLE "proc_def_roles";
DROP TABLE "proc_def_tasks";


CREATE TABLE "proc_def_processes"(
    "id" serial4 PRIMARY KEY,
    "name" TEXT NOT NULL,
    "description" TEXT null,
    "notifications_config" jsonb null
);
CREATE TABLE "proc_processes"(
    "id" serial4 PRIMARY KEY,
    "def_process_id" int4 NOT NULL,
    "last_task_id" int4 NULL,
    "created_at" TIMESTAMP NOT NULL,
    "deleted_at" TIMESTAMP NULL,
    "completed_at" TIMESTAMP NULL,
    "updated_at" TIMESTAMP NULL,
    "created_by" int4 NOT NULL,
    "data" jsonb NULL,
    CONSTRAINT "proc_processes_def_process_id_foreign" FOREIGN KEY("def_process_id") REFERENCES "proc_def_processes"("id")
);
CREATE TABLE "proc_def_roles"(
    "id" serial4 PRIMARY KEY,
    "name" TEXT NOT NULL,
    "description" TEXT NULL,
    "create" BOOLEAN DEFAULT false NULL,
    "read" BOOLEAN DEFAULT false NULL,
    "update" BOOLEAN DEFAULT false NULL,
    "delete" BOOLEAN DEFAULT false NULL,
    "only_owner" BOOLEAN DEFAULT true NULL
);
CREATE TABLE "proc_def_tasks"(
    "id" serial4 PRIMARY KEY,
    "name" TEXT NOT NULL,
    "description" TEXT NOT NULL,
    "starts_process" BOOLEAN DEFAULT false NULL,
    "completes_process" BOOLEAN DEFAULT false NULL,
    "def_process_id" int4 NOT NULL,
    "next_def_task_id" int4[] null,
    "schema" jsonb NOT NULL
);
CREATE TABLE "proc_roles"(
    "id" serial4 PRIMARY KEY,
    "def_role_id" int4 NOT NULL,
    "def_task_id" int4 NULL,
    "def_process_id" int4 NULL,
    "description" TEXT NOT NULL,
    CONSTRAINT "proc_roles_def_role_id_foreign" FOREIGN KEY("def_role_id") REFERENCES "proc_def_roles"("id"),
    CONSTRAINT "proc_roles_def_process_id_foreign" FOREIGN KEY("def_process_id") REFERENCES "proc_def_processes"("id"),
    CONSTRAINT "proc_roles_def_task_id_foreign" FOREIGN KEY("def_task_id") REFERENCES "proc_def_tasks"("id")
);
CREATE TABLE "proc_groups"(
    "id" serial4 PRIMARY KEY,
    "role_id" _INT4 NOT NULL,
    "description" TEXT NOT NULL
);
CREATE TABLE "proc_users_roles"(
    "id" serial4 PRIMARY KEY,
    "user_id" int4 NOT NULL,
    "group_id" int4 NOT NULL,
    CONSTRAINT "proc_users_roles_group_id_foreign" FOREIGN KEY("group_id") REFERENCES "proc_groups"("id"),
    constraint "proc_users_roles_usuarios_id_foreign" foreign key("user_id") references "usuarios"("id")
);
CREATE TABLE "proc_tasks"(
    "id" serial4 PRIMARY KEY,
    "def_task_id" int4 NOT NULL,
    "previous_task_id" int4 NULL,
    "responsible_role_id" int4 NULL,
    "process_id" int4 NOT NULL,
    "created_by" int4 NOT NULL,
    "responsible_user_id" int4 NULL,
    "created_at" TIMESTAMP NOT NULL,
    "updated_at" TIMESTAMP NULL,
    "completed_at" TIMESTAMP NULL,
    "deleted_at" TIMESTAMP NULL,
    "data" jsonb NULL,
    CONSTRAINT "proc_tasks_process_id_foreign" FOREIGN KEY("process_id") REFERENCES "proc_processes"("id"),
    CONSTRAINT "proc_tasks_def_task_id_foreign" FOREIGN KEY("def_task_id") REFERENCES "proc_def_tasks"("id"),
    CONSTRAINT "proc_tasks_responsible_role_id_foreign" FOREIGN KEY("responsible_role_id") REFERENCES "proc_roles"("id")
);

Proceso de pedidos de insumos

------------------------------------ 'PEDIDO DE INSUMOS' PROCESS -------------------------------------------------
INSERT INTO public.proc_def_processes (id,name,description)
    VALUES (1,'Pedidos','Pedidos de insumos');

INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process,  next_def_task_id,schema)
VALUES (1, 'Crear_pedido_en_borrador', 'Inicio del pedido en borrador', 1, true, ARRAY[4,8,11],'{
	"type": "object",
	"properties": {
		"status": {
			"type": "integer",
			"enum": [
				1
			]
		},
		"fecha_entrega_estimada": {
			"type": "string"
		},
        "creador": {
			"type": "object",
			"properties": {
				"email": {
					"type": "string"
				},
				"name":{
					"type": "string"
				},
                "uuid": {
					"type": "string"
				}
			},
			"required": [
				"email",
				"name",
                "uuid"
			]
        },
		"observaciones_operador": {
			"type": "string", "default":""
		},
		"productos_operador": {
			"type": "array",
			"items": {
				"type": "object",
				"properties": {
					"albor_uuid_insumo": {
						"type": "string",
						"format": "uuid"
					},
                    "uuid_insumo": {"type": "string", "format": "uuid"},
					"cantidad_solicitada": {
						"type": "number"
					},
					"destino": {
						"type": "string"
					}
				},
				"required": [
					"albor_uuid_insumo",
                    "uuid_insumo",
					"cantidad_solicitada",
					"destino"
				],
				"additionalProperties": false
			}
		},
		"carga_parcial": {
			"type": "boolean"
		},
		"tipo_insumo": {
			"type": "string"
		},
		"opcion_retiro": {
			"type": "integer",
			"enum": [
				1,
				2
			]
		}
	},
	"required": [
		"status",
		"fecha_entrega_estimada",
        "creador",
		"productos_operador",
		"carga_parcial",
		"tipo_insumo",
		"opcion_retiro"
	],
	"additionalProperties": false
}');


INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, completes_process, schema)
VALUES (2, 'Crear_pedido_en_borrador_cancelado', 'Inicio del pedido en borrador cancelado', 1, true, true,'{
	"type": "object",
	"properties": {
		"status": {
			"type": "integer",
			"enum": [
				
				2
			]
		},
		"fecha_entrega_estimada": {
			"type": "string"
		},
        "creador": {
			"type": "object",
			"properties": {
				"email": {
					"type": "string"
				},
				"name":{
					"type": "string"
				},
                "uuid": {
					"type": "string"
				}
			},
			"required": [
				"email",
				"name",
                "uuid"
			]
        },
		"observaciones_operador": {
			"type": "string", "default":""
		},
		"productos_operador": {
			"type": "array",
			"items": {
				"type": "object",
				"properties": {
					"albor_uuid_insumo": {
						"type": "string",
						"format": "uuid"
					},
                    "uuid_insumo": {"type": "string", "format": "uuid"},
					"cantidad_solicitada": {
						"type": "number"
					},
					"destino": {
						"type": "string"
					}
				},
				"required": [
					"albor_uuid_insumo",
                    "uuid_insumo",
					"cantidad_solicitada",
					"destino"
				],
				"additionalProperties": false
			}
		},
		"carga_parcial": {
			"type": "boolean"
		},
		"tipo_insumo": {
			"type": "string"
		},
		"opcion_retiro": {
			"type": "integer",
			"enum": [
				1,
				2
			]
		}
	},
	"required": [
		"status",
		"fecha_entrega_estimada",
        "creador",
		"productos_operador",
		"carga_parcial",
		"tipo_insumo",
		"opcion_retiro"
	],
	"additionalProperties": false
}');
INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process,  next_def_task_id,schema)
VALUES (3, 'Crear_pedido_pendiente_insumos', 'Inicio del pedido en pendiente de insumos', 1, true,ARRAY[5,9,12,13,14,16],'{
	"type": "object",
	"properties": {
		"status": {
			"type": "integer",
			"enum": [
				3
			]
		},
		"fecha_entrega_estimada": {
			"type": "string"
		},
        "creador": {
			"type": "object",
			"properties": {
				"email": {
					"type": "string"
				},
				"name":{
					"type": "string"
				},
                "uuid": {
					"type": "string"
				}
			},
			"required": [
				"email",
				"name",
                "uuid"
			]
        },
		"observaciones_operador": {
			"type": "string", "default":""
		},"productos_enc_insumos": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "albor_uuid_insumo": {
                        "type": "string",
                        "format": "uuid"
                    },
                   "uuid_insumo": {"type": "string", "format": "uuid"},
                    "cantidad_solicitada": {
                        "type": "number"
                    },
                    "destino": {
                        "type": "string"
                    },
                    "factor_ajuste": {
                        "type": "number",
                        "default": 1
                    },
                    "punto_origen": {
                        "type": "string",
                        "default": ""
                    },
                    "fecha_estimada_entrega_proveedor": {
                        "type": "string",
                        "default": ""
                    },
                    "origen": {
                        "type": "object",
                        "properties": {
                            "orden_compra": {
                                "type": "string"
                            },
                            "transferencia_stock": {
                                "type": "string"
                            }
                        },
                        "additionalProperties": false,
                        "default": {}
                    }
                },
                "required": [
                    "albor_uuid_insumo",
                    "uuid_insumo",
                    "cantidad_solicitada",
                    "destino"
                ],
                "additionalProperties": false
            }
        },
		"productos_operador": {
			"type": "array",
			"items": {
				"type": "object",
				"properties": {
					"albor_uuid_insumo": {
						"type": "string",
						"format": "uuid"
					},
                    "uuid_insumo": {"type": "string", "format": "uuid"},
					"cantidad_solicitada": {
						"type": "number"
					},
					"destino": {
						"type": "string"
					}
				},
				"required": [
					"albor_uuid_insumo",
                    "uuid_insumo",
					"cantidad_solicitada",
					"destino"
				],
				"additionalProperties": false
			}
		},
		"carga_parcial": {
			"type": "boolean"
		},
		"tipo_insumo": {
			"type": "string"
		},
		"opcion_retiro": {
			"type": "integer",
			"enum": [
				1,
				2
			]
		}
	},
	"required": [
		"status",
		"fecha_entrega_estimada",
        "creador",
		"productos_operador",
		"carga_parcial",
		"tipo_insumo",
		"opcion_retiro"
	],
	"additionalProperties": false
}');

INSERT INTO public.proc_def_tasks  (id, name, description, def_process_id, starts_process,  next_def_task_id,schema)
VALUES (4, 'Editar_borrador', 'Editar borrador de pedido', 1, false, ARRAY[4,8,11],'{
	"type": "object",
	"properties": {
		"fecha_entrega_estimada": {
			"type": "string"
		},
		"observaciones_operador": {
			"type": "string"
		},
		"productos_operador": {
			"type": "array",
			"items": {
				"type": "object",
				"properties": {
					"albor_uuid_insumo": {
						"type": "string",
						"format": "uuid"
					},
					"uuid_insumo": {
						"type": "string"
					},
					"cantidad_solicitada": {
						"type": "number"
					},
					"destino": {
						"type": "string"
					}
				},
				"required": [
					"albor_uuid_insumo",
					"uuid_insumo",
					"cantidad_solicitada",
					"destino"
				],
				"additionalProperties": false
			}
		},
		"carga_parcial": {
			"type": "boolean"
		},
		"tipo_insumo": {
			"type": "string"
		},
		"opcion_retiro": {
			"type": "integer",
			"enum": [
				1,
				2
			]
		}
	},
	"required": [
		"fecha_entrega_estimada",
		"observaciones_operador",
		"productos_operador",
		"carga_parcial",
		"tipo_insumo",
		"opcion_retiro"
	],
	"additionalProperties": false
}');




INSERT INTO public.proc_def_tasks  (id, name, description, def_process_id, starts_process,  next_def_task_id,schema)
VALUES (5, 'editar_pendiente_insumos', 'Editar pedido pendiente de insumos', 1, false, ARRAY[5,9,12,13,14,16],'{
	"type": "object",
	"properties": {
		"observaciones_enc_insumos": {
			"type": "string",
			"default":""
		},
		"tipo_insumo": { "type": "string"},
		"productos_enc_insumos": {
			"type": "array",
			"items": {
				"type": "object",
				"properties": {
					"albor_uuid_insumo": {
						"type": "string",
						"format": "uuid"
					},
					"uuid_insumo": {
						"type": "string"
					},
					"cantidad_solicitada": {
						"type": "number"
					},
					"destino": {
						"type": "string"
					},
					"factor_ajuste": {
						"type": "number",
						"default": 1
					},
					"punto_origen": {
						"type": "string"
					},
					"fecha_estimada_entrega_proveedor": {
						"type": "string"
					},
					"origen": {
						"type": "object",
						"properties": {
							"orden_compra": {
								"type": "string"
							},
							"transferencia_stock": {
								"type": "string"
							}
						},
						"additionalProperties": false
					}
				},
				"additionalProperties": false
			}
		}
	},
	"required": [
		"tipo_insumo",
		"productos_enc_insumos"
	],
	"additionalProperties": false
}');

INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process,  next_def_task_id, schema)
VALUES (6, 'Editar_pendiente_Logistica', 'Editar pedido pendiente de logistica', 1, false, ARRAY[6,10,13,15,20],'{
	"type": "object",
	"properties": {
		"observaciones_enc_logistica": {
			"type": "string"
		},
		"camiones": {
			"type": "array",
			"items": {
				"type": "object",
				"properties": {
					"uuid_camion": {
						"type": "string",
						"format": "uuid"
					},
					"insumos_asociados": {
						"type": "array",
						"items": {
							"type": "string"
						}
					},
					"transportista": {
						"type": "string"
					},
					"nombre_chofer": {
						"type": "string"
					},
					"cuil": {
						"type": "string"
					},
					"patente_camion": {
						"type": "string"
					},
					"patente_acoplado": {
						"type": "string"
					},
					"auto_descarga": {
						"type": "boolean",
						"default": false
					},
					"aforo": {
						"type": "boolean",
						"default": false
					},
					"cantidad_aforo": {
						"type": "number"
					}
				},
				"required": [
					"uuid_camion",
					"insumos_asociados",
					"transportista",
					"nombre_chofer",
					"cuil",
					"patente_camion",
					"patente_acoplado"
				],
				"additionalProperties": false
			}
		},

				"solicitado": {
					"type": "boolean",
					"default": false
				},
				"asignado": {
					"type": "boolean",
					"default": false
				
			},
		"fecha_estimada_retiro_origen": {
			"type": "string"
		},
		"preconfirmado": {
			"type": "boolean",
			"default": false
		},
		"fecha_estimada_entrega_destino": {
			"type": "string"
		}
	},
	"additionalProperties": false
}');


INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, next_def_task_id, schema)
VALUES (7, 'Pendiente_carga', 'Editar pedido pendiente de carga', 1, false, ARRAY[7,15,16], '{
    "type": "object",
    "properties": {
        "productos_enc_insumos": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "albor_uuid_insumo": {
                        "type": "string",
                        "format": "uuid"
                    },
                    "uuid_insumo": {
                        "type": "string"
                    },
                    "cantidad_solicitada": {
                        "type": "number"
                    },
                    "destino": {
                        "type": "string"
                    },
                    "factor_ajuste": {
                        "type": "number",
						"default": 1
                    },
                    "punto_origen": {
                        "type": "string"
                    },
                    "fecha_estimada_entrega_proveedor": {
                        "type": "string"
                    },
                    "origen": {
                        "type": "object",
                        "properties": {
                            "orden_compra": {
                                "type": "string"
                            },
                            "transferencia_stock": {
                                "type": "string"
                            }
                        },
                        "additionalProperties": false
                    }
                },
                "required": [
                    "albor_uuid_insumo",
                    "uuid_insumo",
                    "cantidad_solicitada",
                    "destino",
                    "punto_origen",
                    "factor_ajuste",
                    "fecha_estimada_entrega_proveedor"
                ],
                "additionalProperties": false
            }
        }
    },
    "required": ["productos_enc_insumos"],
    "additionalProperties": false
}');


INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process,completes_process, schema)
VALUES (8, 'A_borrador_cancelado', 'Pasar pedido a borrador cancelado', 1, false, true,'{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [2]
        }
    },
    "required": ["status"],
    "additionalProperties": false
}');



INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process,  next_def_task_id,schema)
VALUES (9, 'Volver_a_borrador', 'Volver pedido a borrador desde pendiente de insumos', 1, false, ARRAY[8,4,11],'{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [1]
        },
        "productos_enc_insumos": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "albor_uuid_insumo": {
                        "type": "string",
                        "format": "uuid"
                    },
                    "uuid_insumo": {
                        "type": "string"
                    },
                    "cantidad_solicitada": {
                        "type": "number"
                    },
                    "destino": {
                        "type": "string"
                    },
                    "factor_ajuste": {
                        "type": "number",
                        "default": 1
                    },
                    "punto_origen": {
                        "type": "string",
                        "default": ""
                    },
                    "fecha_estimada_entrega_proveedor": {
                        "type": "string",
                        "default": ""
                    },
                    "origen": {
                        "type": "object",
                        "properties": {
                            "orden_compra": {
                                "type": "string"
                            },
                            "transferencia_stock": {
                                "type": "string"
                            }
                        },
                        "additionalProperties": false,
                        "default": {}
                    }
                },
                "required": [
                    "albor_uuid_insumo",
                    "uuid_insumo",
                    "cantidad_solicitada",
                    "destino"
                ],
                "additionalProperties": false
            }
        }
    },
    "required": ["status", "productos_enc_insumos"],
    "additionalProperties": false
}');



INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process,  next_def_task_id, schema)
VALUES (10, 'Volver_a_pendiente_insumos', 'Volver pedido a pendiente de insumos', 1, false, ARRAY[5,9,10,12,13,14,16],'{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [3]
        },
        "observaciones_enc_logistica": {
            "type": "string",
            "default": ""
        },
        "camiones": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "uuid_camion": {
                        "type": "string",
                        "format": "uuid"
                    },
                    "insumos_asociados": {
                        "type": "array",
                        "items": {
                            "type": "number"
                        }
                    },
                    "transportista": {
                        "type": "string"
                    },
                    "nombre_chofer": {
                        "type": "string"
                    },
                    "cuil": {
                        "type": "string"
                    },
                    "patente_camion": {
                        "type": "string"
                    },
                    "patente_acoplado": {
                        "type": "string"
                    },
                    "auto_descarga": {
                        "type": "boolean",
                        "default": false
                    },
                    "aforo": {
                        "type": "boolean",
                        "default": false
                    },
                    "cantidad_aforo": {
                        "type": "number"
                    }
                },
                "required": [
                    "uuid_camion",
                    "insumos_asociados",
                    "transportista",
                    "nombre_chofer",
                    "cuil",
                    "patente_camion",
                    "patente_acoplado"
                ],
                "additionalProperties": false
            }
        },
  
                "solicitado": {
                    "type": "boolean",
                    "default": false
                },
                "asignado": {
                    "type": "boolean",
                    "default": false
                
            },
        "fecha_estimada_retiro_origen": {
            "type": "string",
            "default": ""
        },
        "preconfirmado": {
            "type": "boolean",
            "default": false
        },
        "fecha_estimada_entrega_destino": {
            "type": "string",
            "default": ""
        }
    },
    "required": [
        "status"
    ],
    "additionalProperties": false
}');




INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process,  next_def_task_id, schema)
VALUES (11, 'A_pendiente_de_insumos', 'Pasar de borrador a pendiente de insumos', 1, false, ARRAY[5,9,11,12,13,14,16],'{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [3]
        },"productos_enc_insumos": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "albor_uuid_insumo": {
                        "type": "string",
                        "format": "uuid"
                    },
                    "uuid_insumo": {
                        "type": "string"
                    },
                    "cantidad_solicitada": {
                        "type": "number"
                    },
                    "destino": {
                        "type": "string"
                    },
                    "factor_ajuste": {
                        "type": "number",
                        "default": 1
                    },
                    "punto_origen": {
                        "type": "string",
                        "default": ""
                    },
                    "fecha_estimada_entrega_proveedor": {
                        "type": "string",
                        "default": ""
                    },
                    "origen": {
                        "type": "object",
                        "properties": {
                            "orden_compra": {
                                "type": "string"
                            },
                            "transferencia_stock": {
                                "type": "string"
                            }
                        },
                        "additionalProperties": false,
                        "default": {}
                    }
                },
                "required": [
                    "albor_uuid_insumo",
                    "uuid_insumo",
                    "cantidad_solicitada",
                    "destino"
                ],
                "additionalProperties": false
            }
        }
    },
    "required": ["status","productos_enc_insumos"],
    "additionalProperties": false
}');



INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, completes_process,schema)
VALUES (12, 'A_pedido_cancelado', 'Pasar pedido a pedido cancelado', 1, false, true,'{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [4]
        }
    },
    "required": ["status"],
    "additionalProperties": false
}');



INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process,  next_def_task_id, schema)
VALUES (13, 'A_pendiente_carga', 'Pasar pedido a pendiente de carga', 1, false,ARRAY[7,15,16], '{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [5]
        }
    },
    "required": ["status"],
    "additionalProperties": false
}');


INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, next_def_task_id, schema)
VALUES (14, 'A_pendiente_logistica', 'Pasar pedido a pendiente de logistica', 1, false,ARRAY[6,10,13,15,20], '{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [6]
        },
	"motivo_rechazo":{"type":"string","default":""}
    },
    "required": ["status"],
    "additionalProperties": false
}');



INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, next_def_task_id, schema)
VALUES (15, 'A_en_camino', 'Pasar pedido a en camino', 1, false, ARRAY[10,17,18,19],'{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [7]
        }
    },
    "required": ["status"],
    "additionalProperties": false
}');



INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, next_def_task_id, schema)
VALUES (16, 'A_retirar', 'Pasar pedido a retirar', 1, false, ARRAY[10,17,18,19],'{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [8]
        }
    },
    "required": ["status"],
    "additionalProperties": false
}');



INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, next_def_task_id, schema)
VALUES (17, 'Agregar_remito', 'Agregar remito al pedido', 1, false, ARRAY[17,18,19], '{
    "type": "object",
    "properties": {
        "remitos": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "uuid_insumo": {"type": "string", "format": "uuid"},
                    "remito_id": {"type": "string"},
                    "cantidad_remitida": {"type": "number"}
                },
                "required": ["uuid_insumo", "remito_id", "cantidad_remitida"],
                "additionalProperties": false
            }
        }
    },
    "required": ["remitos"],
    "additionalProperties": false
}');



INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, completes_process,schema)
VALUES (18, 'A_completado', 'Pasar pedido a completado', 1, false, true ,'{
    "type": "object",
    "properties": {
        "status": {"type": "integer", "enum": [9]}
    },
    "required": ["status"],
    "additionalProperties": false
}');


INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, completes_process, schema)
VALUES (19, 'A_anulado', 'Pasar pedido a anulado', 1, false, true,'{
    "type": "object",
    "properties": {
        "status": {"type": "integer", "enum": [10]},
        "motivo_anulacion": {"type": "string"}
    },
    "required": ["status", "motivo_anulacion"],
    "additionalProperties": false
}');

INSERT INTO public.proc_def_tasks (id, name, description, def_process_id, starts_process, next_def_task_id, schema)
VALUES (20, 'Rechazar_pedido', 'Encargado de logistica rechaza el pedido y vuelve a pendiente de insumos', 1, false, ARRAY[5,9,12,13,14,16,20],'{
    "type": "object",
    "properties": {
        "status": {
            "type": "integer",
            "enum": [3]
        },
		"motivo_rechazo":{"type":"string"}
		,
        "observaciones_enc_logistica": {
            "type": "string",
            "default": ""
        },
        "camiones": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "uuid_camion": {
                        "type": "string",
                        "format": "uuid"
                    },
                    "insumos_asociados": {
                        "type": "array",
                        "items": {
                            "type": "number"
                        }
                    },
                    "transportista": {
                        "type": "string"
                    },
                    "nombre_chofer": {
                        "type": "string"
                    },
                    "cuil": {
                        "type": "string"
                    },
                    "patente_camion": {
                        "type": "string"
                    },
                    "patente_acoplado": {
                        "type": "string"
                    },
                    "auto_descarga": {
                        "type": "boolean",
                        "default": false
                    },
                    "aforo": {
                        "type": "boolean",
                        "default": false
                    },
                    "cantidad_aforo": {
                        "type": "number"
                    }
                },
                "required": [
                    "uuid_camion",
                    "insumos_asociados",
                    "transportista",
                    "nombre_chofer",
                    "cuil",
                    "patente_camion",
                    "patente_acoplado"
                ],
                "additionalProperties": false
            }
        },
        
                "solicitado": {
                    "type": "boolean",
                    "default": false
                },
                "asignado": {
                    "type": "boolean",
                    "default": false
                
            },
        "fecha_estimada_retiro_origen": {
            "type": "string",
            "default": ""
        },
        "preconfirmado": {
            "type": "boolean",
            "default": false
        },
        "fecha_estimada_entrega_destino": {
            "type": "string",
            "default": ""
        }
    },
    "required": [
        "status",
		"motivo_rechazo"
    ],
    "additionalProperties": false
}');




INSERT INTO public.proc_def_roles (id,name,description,"create" ,"read","update","delete")
    VALUES 
        (1,'Read','Read all information',false,true,false,false),
        (2,'Create','Create record',true,false,false,false),
        (3,'Update','Update record',false,false,true,false),
        (4,'Delete','Delete record',false,false,false,true);



-- TASK ID 1 es la de crear pedidos
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (1,2,1,NULL,'Crear pedido borrador');
        -- TASK ID 1 es la de crear pedidos
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (2,2,2,NULL,'Crear pedido borrador cancelado');
        -- TASK ID 1 es la de crear pedidos
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (3,2,3,NULL,'Crear pedido encargado insumos');
        
-- TASK ID 2 es la de editar borrador
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (4,2,4,NULL,'Editar borrador');
        
-- TASK ID 3 es la de editar pendiente de insumos
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (5,2,5,NULL,'Editar pendiente de insumos');

-- TASK ID 4 es la de editar pendiente de logistica
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (6,2,6,NULL,'Editar pendiente de logistica');

-- TASK ID 5 es la de editar pendiente de carga
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (7,2,7,NULL,'Editar pendiente de carga');

-- TASK ID 6 es la de pasar a borrador cancelado
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (8,2,8,NULL,'Pasar a borrador cancelado');

-- TASK ID 7 es la de volver a borrador
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (9,2,9,NULL,'Volver a borrador');

-- TASK ID 8 es la de volver a pendiente de insumos
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (10,2,10,NULL,'Volver a pendiente de insumos');

-- TASK ID 9 es la de a pendiente de insumos
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (11,2,11,NULL,'A pendiente de insumos');

-- TASK ID 10 es la de a pedido cancelado
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (12,2,12,NULL,'A pedido cancelado');

-- TASK ID 11 es la de a pendiente de carga
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (13,2,13,NULL,'A pendiente de carga');

-- TASK ID 12 es la de a pendiente de logistica
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (14,2,14,NULL,'A pendiente de logistica');

-- TASK ID 13 es la de a en camino
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (15,2,15,NULL,'A en camino');

-- TASK ID 14 es la de a retirar
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (16,2,16,NULL,'A retirar');

-- TASK ID 15 es la de agregar remito
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (17,2,17,NULL,'Agregar remito');

-- TASK ID 16 es la de a copmletado
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (18,2,18,NULL,'A completado');

-- TASK ID 17 es la de a anulado
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (19,2,19,NULL,'A anulado');

-- TASK ID 17 es la de a anulado
INSERT INTO public.proc_roles (id,def_role_id,def_task_id,def_process_id ,description)
    VALUES 
        (20,2,20,NULL,'Rechazar pedido');
-- GET de procesos

insert into public.proc_roles(id,def_role_id,def_task_id,def_process_id,description)
values (21,1,NULL,1,'');


INSERT INTO public.proc_groups (id,role_id,description)
    VALUES (1,'{1,2,3,4,8,9,11,17,18,19,21}','Operadores');

INSERT INTO public.proc_groups (id,role_id,description)
    VALUES (2,'{5,7,10,12,13,14,15,16,21}','Encargados de insumos');

INSERT INTO public.proc_groups (id,role_id,description)
    VALUES (3,'{6,13,15,20,21}','Encargados de logistica');


---- Roles de devhelp


INSERT INTO public.proc_users_roles (id,user_id,group_id)
VALUES (1,50891,1);

INSERT INTO public.proc_users_roles (id,user_id,group_id)
VALUES (2,50891,2);

INSERT INTO public.proc_users_roles (id, user_id, group_id)
VALUES (3, 50891, 3);



-- select * from proc_def_processes;
-- select * from proc_processes; 

-- select * from proc_def_tasks;
-- select * from proc_tasks;


-- select * from proc_def_roles;
-- select * from proc_roles;

-- select * from proc_users_roles;
-- select * from proc_groups;