Get a result of a range based on for which day it was provided.

[lisovsk]

When we provide a range can we get the result based on for which day it was provided instead when it was provided?
http://prntscr.com/merjik
It will be more useful.
I really thank you for helping me out.

[mnvx]

Currently you can find provided spent time in csv (column spent_at):

I use date when it was provided in interface, because this approach exclude manipulations with spent time in past.

[lisovsk]

In my case for a specific range I want to now all spent_at times. For that I need a result based on for which day it was provided. Is it hard to fix? Can you explain how fix that?

[mnvx]

I think it is better to

• add new filter "Spent At" (filter by spent_at column)
• rename current column "Spent at" to "Created at"
• add new column "Spent at" with date from column spent_at

It is not hard. Must be changed next places:

• repository SpentRepositoryEloquent::getListQuery() - add filter by spent_at by analogue with note.gitlab_created_at
• view gitpab/time/index_filter_form.blade.php - add filter control (range)
• view gitpab/time/index_table.blade.blade.php - rename old column and add new column

[lisovsk]

How can I add column with spent_at? I thought I could do it that way - http://prntscr.com/n9keph

[mnvx]

If you don't plan to push changes, it is simplest way, yes.

If you plan to push changes into this repo, solution described above is recomendated

[lisovsk]

I went through the simplest way but It show date for - gitlab created_at

[mnvx]

You need to replace next line to {{ \App\Helper\Date::formatDateTime($item->spent_at) }}

And for orderings:

Replace next line to 'column' => 'spent.spent_at',

Also add line 'spent.spent_at', into this array