hackerschool / hs-tms Goto Github PK

We need to dockerize our project to make it more portable and easier to deploy. Dockerization will also help us ensure consistent behavior across different environments.

When using the pg module in Node.js to query a resource with a date column, the retrieved date value is different from the expected value. For example, if the date column in the database has '2023-05-21' stored, the pg module query result is '2023-05-20T23:00:00.000Z'.

From the frontend POV, it would be helpful to distinguish users who have tried to log in but are not authorized from those who haven't tried, so the authentication error is not displayed to those who haven't tried to log in.

Setting the API to return different error codes depending on whether an error occurred, the user is unauthorized, or not authenticated would suffice.

Currently, the transactions table has the value and balance columns. The balance column is supposed to represent the balance of the organization after each transaction, where balance = previous transaction's balance + value.

However, the balance column is not updated automatically after each transaction is inserted into the table.

We should create a trigger function that updates the balance column automatically after each INSERT operation on the transactions table.

This function is not working properly when filtering transactions made by certain projects.
For example, if we have the following projects and transactions:

Projects:
[
  { id: 1, name: 'Project 1', active: true },
  { id: 2, name: 'Project 2', active: true },
  { id: 3, name: 'Project 3', active: true }
]

Transactions:
[
  {
    id: 1,
    date: '2023-04-29',
    description: 'Transaction 1',
    value: '1000',
    file_path: 'file1.pdf',
    has_nif: true,
    projects: 'Project 1 / Project 2 / Project 3'
  }
]

If we call it to get only the transactions made by Project 1 and Project 2, it returns

[
  {
    id: 1,
    date: '2023-04-29',
    description: 'Transaction 1',
    value: '1000',
    file_path: 'file1.pdf',
    has_nif: true,
    projects: 'Project 1 / Project 2'
  }
]

instead of

[
  {
    id: 1,
    date: '2023-04-29',
    description: 'Transaction 1',
    value: '1000',
    file_path: 'file1.pdf',
    has_nif: true,
    projects: 'Project 1 / Project 2 / Project 3'
  }
]

(the projects field should include all projects linked to that transaction)