inventario | Home Inventory Management System | Continuous Deployment library

I am confused when I try to insert record from a "GET" request

I will try to explain what I want to do.

I am creating an application to take inventory of assets.

I have 3 tables in my database.

I have a main table called fixed asset("ActFijo") where all the assets of my company are registered.

Another call Inventory ("Inventario"), which stores the name of each inventory

and another call Inventory_detail ("Inventario_detalle"), where the details or assets in which they are being counted are stored to verify that the equipament or furniture is not being stolen in that location.

From the main table ("ActFijo") I have to search for the furniture or asset and store it in the detail table ("Inventario_detalle")

I'm confused I don't know how to work on a GET request and then do a POST all in one request

Do I have to write my code in parts in a GET request and then POST? Or can I do everything in the GET request?

This is the code I have so far I don't know if it's ok, please I need guidance

For example my code does not pass the validation of the form.

I am executing a report created in IReport 3.0 in Jaspersoft Studio 6.18.1, I have made several migrations, but this has been a bit complicated for me, when executing it in IReport 3.0 it works correctly, in Jaspersoft Studio it does not, however there are times that the reports appear to me and when I replicate the changes it does not take effect either, for example: (the following instruction is in the where of the query)

I am creating some inputs based on the value of another input, my problem is I don't know how to get the value of these new inputs that are generated.

This is my View Part:

so I searched for the answers for my problem on the internet but didn't find something that helped, basically a need to have a ManyToOne Relationship between two classes, of which one of them has an EmbeddedId, I'm going to leave the code here and the error message that it gives (I'm using wildfly to run the server).

I have two components, the main one that is called first and the other that is the content of the modal that is called second, in the first component I have an input with a "+" button that when I click it is loading a modal and inside the modal I am loading the second component where it loads a pagination with its respective records and each record appears with the "+" until there, well, what I need is that when I give any record that appears with the "+" sign, I copy the content from the field "name" to the input of the first component and I close the modal

https://codesandbox.io/s/nice-thunder-zqqlx?file=/src/App.js

First

I am trying to find an object from an array of objects. I am using NextJs, React 17.0.2, typescript 4.5.4, framer-motion and tailwindcss.

Here's the array:

I want to set a fixed width to a VStack but it doesn't work, the container wraps to the text and each box is independent for a list

This is the container:

Trying to do a query whith an IN Clause, but having the following error:

Mensagem 468, Nível 16, Estado 9, Linha 7 Não foi possível resolver o conflito de agrupamento entre "SQL_Latin1_General_CP1_CI_AS" e "SQL_Latin1_General_CP850_CI_AS" na operação equal to.

My Translation: Not possible to solve the collation conflict....

Both Databases Have Same Collation and are in the same sql server

following, the query:

---edit --- From the code given by oh_my_lawdy (THANks!!) i got the result seen in picture. It's like joining lists in a dataframe but gets NAN for every column i add

--- final df with code by oh_my_lawdy

-end of edit--

i'm trying to get data (multiple cells from one sheet) from different excel files (Daily report) and make only one excel file with daily data to use it in plots (actual vs budget, forecasting...)

So Far i can get the results i want, but i think is not an efficient or "elegant" way to do it.

I read excel files with a FOR and I defined a Function for read specific cells from daily report, pass this function for the FOR loop, and append data through the loop, that creates one column dataframes, and then i use CONCAT to get just one dataframe, then i write output to excel file.

I need to read at least 8 cells from this daily report, each one would be a column in a Dataframe, so coding is really long, and i'm thinking using this code for other reports but i'm feeling like it's not "clean"

For now, daily reports don't change cell positions

Any help would be appreciated (maybe function could read several cells at once?)

Reading excel files