[Koha-bugs] [Bug 11027] add a column for basketgroups in late orders table

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11027

--- Comment #1 from mathieu saby <mathieu.saby at univ-rennes2.fr> ---
Created attachment 21951
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=21951&action=edit
PATCH] Bug 11027 : Add a column for basketgroups in late orders table and
improve other columns

To apply ON TOP of bug bug 7298

This patch makes 4 changes in late orders page : 
- adding a new column for basketgroup, displaying the name and number of the
basketgroup
- displaying the name of the basket as well as its number
- displaying fund in a separate column to make sorting easier, and renaming it
from "budget" to "fund" (the confusion can be found elsewhere in Koha...)
- displaying branch in a separate column to make sorting easier (this column
could be improved later, by getting branch from basketgroup if there is one)

For that, in Aquisition.pm, I made some changes to GetLateOrders :
- 3 new columns in SELECT, 1 new join
- cosmetic : rename "closedate" to "aqbasket.closedate" in 4 occurences : it
will be usefull later, because I am envisonning an other patch that will create
a "closedate" column in basketgroup table, and I don't want MySQL to crash
because of ambiguous column.

To test :
1. display the list of late orders of your instanc.
2. You should have 3 new columns for basketgroups, fund and branch
3. In basketgroup column you should have "name of basket group (number)"
4. In basket column you should have "name of basket (number)"

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.