Bug 41865 - Add percent spent bar graph to acquisitions home page for budgets.
Summary: Add percent spent bar graph to acquisitions home page for budgets.
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Acquisitions (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-02-17 18:15 UTC by Rhonda Kuiper
Modified: 2026-02-17 20:09 UTC (History)
2 users (show)

See Also:
GIT URL:
Initiative type: ---
Sponsorship status: ---
Comma delimited list of Sponsors:
Crowdfunding goal: 0
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments
Code used to update with percentage spent. (3.18 KB, text/plain)
2026-02-17 18:15 UTC, Rhonda Kuiper
Details
Code for percentage of funds available (3.81 KB, text/plain)
2026-02-17 20:07 UTC, Barbara Johnson
Details
Budgets page display when using percentage available code (133.74 KB, image/png)
2026-02-17 20:09 UTC, Barbara Johnson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rhonda Kuiper 2026-02-17 18:15:52 UTC
Created attachment 193329 [details]
Code used to update with percentage spent.

Hi,
There is some java script floating around that adds a colored bar to the j'Total Available' column that indicates the percent budget spent.  We had it on our system but it stopped working with an upgrade.  It would be great if this code was added to the base code.  I have attached the code from our Intranetuserjs.  This is the code that doesn't work anymore.
Comment 1 Barbara Johnson 2026-02-17 20:03:48 UTC
We are using a slight variation of the code (see attachment) that displays the percent available. It is working on the budgets page but not on the acq home page. I think I personally would rather see it displaying the percent spent but I think this code uses percent available because it displays inside the Total Available column. I attached a screenshot showing what it currently looks like in our staff interface. 

Ultimately, it would be great if a new column could be added for this percentage info, whether it is for spent or available. The current jQuery is problematic when the user exports this table to Excel because it lives inside the Total Available column which means the spreadsheet has to be cleaned up in order to do calculations.

The progress bar as well as the green and red highlighting is very nice to see where you are in each fund. When working with money I think it is reasonable to provide percentages so that the user doesn't have to calculate these manually.
Comment 2 Barbara Johnson 2026-02-17 20:07:04 UTC
Created attachment 193331 [details]
Code for percentage of funds available
Comment 3 Barbara Johnson 2026-02-17 20:09:02 UTC
Created attachment 193332 [details]
Budgets page display when using percentage available code