timesheet | simple timetracker

Since getData is async, the constant timesheetsData does not contain anything in the first render cycle and since you are not triggering a state change when the data is ready, no rerender is triggered, resulting in an empty FlatList.

This could be solved by using a useEffect and introducing a state variable as follows.

Here is what I've understood from your question: plot some time series data and highlight the weekends by coloring the background. One possible way to get this would be to create datablock with all days within your time range and draw boxes (check help boxxyerror) which are colored (check help lc variable) depending of the weekday (check help tm_wday).

• first you have to plot the boxes in the background and then the data
• the background color should span the whole vertical graph size. For this you need to know the y-range of the data. You can get STATS_min and STATS_max from stats (check help stats).
• in order to span the whole graph you can extend the y-range of the boxes (by adding the range again on top and on bottom) but do not apply autoscale for the boxes (check help noautoscale). Autoscale will be only used for the data.
• Maybe you have a fixed known y-range, then you can simply set it via set yrange and suitable size of the boxes.

I hope you can adapt the following example to your needs.

Code:

I think you should create another field for type of time. You cannot have both in the same field. Even if it would be not readable for some reasons. I suggest such solution:

Add another field of type and use CHOICES there:

The problem here is that you are using Map.identity(). Read the documentation here on Map.identity constructor.

An identity map uses identical for equality and identityHashCode for hash codes of keys instead of the intrinsic Object.== and Object.hashCode of the keys.

According to the docs, a map constructed with Map.identity does not use == and hashCode.

You should define your map like this instead:

Consider conditional aggregation:

Let's use pivot_table then stack level 0 to convert column MultiIndex to row MultiIndex:

The slowness is caused by having to hit the database 4 times per Cost instance to get all the related ExcelJobsList.

To avoid this and make it more efficient, you can use select_related to the related ExcelJobsList like this:

you have to wrap your request into a useEffect.

So, there are a few things to improve your code.

Replace watcher with a method

Watchers are pretty hard to debug and can cause side effects. They should be only used when really necessary. Instead, create a method, which adds a row: