Forecast and Budget Control

[rslemer]

I will use the cbemployee module as a base

I created a block for the monthly goal value
goal start day (which is always the 9th of each month)
goal end day (which is the 10th of the following month)
Accumulated value

I need to do a function with the sql command to sum up the confirmed payments for this user (I thought of a custom function because of the period that is not the full month, but from 9 to 10 of the following month)

and I wanted to make a list of the payments that made up this calculation (I think this is developer blocks, right)

Does the custom function have a model that I can follow? I think doing a sql command that returns the calculated value, I need the system to take this value and put it in the field