vacation | Employee vacation tracker | Runtime Evironment library

I have the calendar table with all the dates of the month of December 2021 (I will only exemplify some dates within the table, but it is understood that it actually contains all the days of said month):

I have the users table:

I have the table assistances

I have a query to display the employee number, their name, the days they attended and the days they were absent:

Suppose I want to achieve something like this in flutter how can i do this?

note: first digit(8) should be exactly aligned below first letter of above word (v of vacation) and similarly last digit(6) should be exactly aligned below last letter of above word (n of vacation).

So far i am trying to do it like this and have been unsuccessful.

I have a table with vacation houses which have some availability (column value, value 1 means available ). How can I find all houses (column unit_id) that are are available between 2 dates.

table

Hi I have 2 tables to model a vacation request and the approvers who will approve the request. A request can have several approvers.

When an approver approves, the approver row has its approved_at column set to the current date.

The request table also has an approved_at column. This is set when ALL the approvers have approved and it is set to the most recent approver's approved_at date.

I need to backfill the requests table's approved at column with the most recent approver's approved_at time but only if all the approvers have approved.

I have solved it using a CTE with window functions but I'm wondering what other ways are there to solve this? I'd prefer a solution compliant with postgres.

Here's my solution

I got Users, Absences and Reasons tables:

I am trying to write a program that overloads the + operator. When I input 7 and 3, it correctly prints: First vacation: Days: 7, People: 3 But incorrectly prints: Second vacation: Days: -158458720, People: 32764 It should be outputting: Second vacation: Days: 12, People: 3

Apologies in advance for any unclarities, I am extremely new to coding.

I found this code by Rick Pastoor (https://rickpastoor.com/2019/05/30/google-calendar-color-coder.html) to automatically colour code events in my Google Calendar based on what character the events start with (in this case !, [ and #).The code is for Google Apps Script

I need to calculate the amount of vacation hours taken between two datetimes. Since this is a vacation (leave, PTO) application, it's important that I find the amount of elapsed vacation time taken between two datetimes.

Vacation time is measured by the number of hours taken off during the company business hours, which is between 9:00:00 and 18:00:00.

For example :

hello everyone good evening,

I have array of object set in state and i would like to change some object in the array.

so here is my array us you can see: