Custom Report

[fbarbeau]

Hi,
is it possible to create custom report?

We would like to have the infos from the individual user report but for all the users. When I do the all users report I only have the total time of the day. I would like to see the break down of that day.

Thanks,

[kevinpapst]

Stop posting ChatGPT generated non-sense or I will block you.

This is related to the hidden comment, not the original post

[fbarbeau]

@kevinpapst Hi, I'm not sure I understand the ChatGPT part of your comment? Is it possible to have custom report or not?

Thanks,

[derStephan]

Is there some documentation on how to add own reports?

[kevinpapst]

https://github.com/kimai/DemoBundle/releases/tag/2.4.0

[kevinpapst]

I added a demo report to the DemoBundle, so you can see how it is done.
Here is the commit:
kimai/DemoBundle@a3e7d1e

[derStephan]

Thanks for that. I tried to understand how these things play together as I am not familiar with symfony. Can you give some example, where I would do a query on the database? Or is there any abstraction layer that I am missing?

[kevinpapst]

Kimai uses Symfony and adds its own API on top.
So I would suggest to read their documentation and then come back with detail questions.
If the demo bundle doesn't include an example for your use-case, I can probably add one.

[derStephan]

That would be very nice. I just want to have the data of the contract page inluding overtime in a report. So I thought, I can just assemble some SQL as given here but I don't know in which file I have to put it.

So for me it would be perfect if the demo bundle included some example SQL query including communication with the database and showing the results in a table.