Modify Annual income Report

[zitu4life]

Hello There

I am thinking  on a possibility   to edit   annual   income   report   to  add   budget. lets   say:

-   Now   I have   one year   income, so   I   want to modify   default   WHMCS   to add   on same   graphic   annual   income report   a   predefined   budget  for  2020,   so I will   be comparing   every   month   my performance   (if   on end of each month   if I   am   up  ⬆️or   below  ⬇️ pre-defined   budget).

-   I have   to insert   budget amount  $ (JAN  ,   FEV, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC for   2020)

I am not sure   if   all modifications   can   be done   only editing   annual_income_report.php

Or if   a module developing   is needed?

This is   a print   I created   on picture  editing   just to   show intended   idea.

 

If there  is   not enough   space   on currently     annual_income_report.php  to   fit   4   inputs   graphs   (3   years+budget),   I could   sacrifice   oldest   years    and  have only   3 graphs   instead   of 4. Also   Budget  could   be inserted   on same   year   graph.   Example   below.

There is any   similar module   ready to use   out-there?  Have you   ever   done similar   work. Perhaps   I have to   ask moderator   to   forward   this thread   to service   and offer  request, but for now   is just to   get input   if it can be done or how complexity   it will be.

Thank you!

 

[brian!]

20 hours ago, zitu4life said:

I am thinking  on a possibility   to edit   annual   income   report   to  add   budget. lets   say:

you would duplicate the report first and then edit the duplicated file, not the original.

21 hours ago, zitu4life said:

I am not sure   if   all modifications   can   be done   only editing   annual_income_report.php

I would have thought that after the report had created the results array from existing data, you were just adding 12 months of fake values (budget) in the same format to the array... these budget figures can't be read from the database (unless you have a custom table for them), so they'd have to be defined in the report.

21 hours ago, zitu4life said:

Or if   a module developing   is needed?

you shouldn't need a module for this.. though the only report module I can think of would be MG's Report Generator, but whether that would even work with this, I don't know as you're not running a specific query on real data, you're just adding fake values to an exisitng result.

21 hours ago, zitu4life said:

If there  is   not enough   space   on currently     annual_income_report.php  to   fit   4   inputs   graphs   (3   years+budget),   I could   sacrifice   oldest   years    and  have only   3 graphs   instead   of 4. Also   Budget  could   be inserted   on same   year   graph.   Example   below.

you can expand the report/graph to more than the current 3 years - it can go as far back as your data exists...

21 hours ago, zitu4life said:

There is any   similar module   ready to use   out-there?

it wouldn't be a module, but a custom report - off-hand, I can't think of an existing report that does what you want.

21 hours ago, zitu4life said:

Have you ever done similar work.

🙂

21 hours ago, zitu4life said:

if it can be done or how complexity it will be.

it could be done... though whether a report is the right vehicle for this i'm not sure (possibly if you need to see the output visually as a graph), but if it were just numerically, a widget would be another option.

[zitu4life]

apreciatte feeback. will contact you on PM, brian