[Koha-bugs] [Bug 7671] add a real primary key "accountlinesid" in accountlines

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Aug 6 10:22:40 CEST 2012


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

Chris Cormack <chris at bigballofwax.co.nz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Signed Off

--- Comment #18 from Chris Cormack <chris at bigballofwax.co.nz> ---
Before

+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
| borrowernumber | accountno | itemnumber | date       | amount   | description
| dispute | accounttype | amountoutstanding | lastincrement | timestamp        
  | notify_id | notify_level | note | manager_id |
+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
|              1 |         1 |       NULL | 2012-08-06 | 2.000000 | NULL       
| NULL    | Pay         |              NULL |          NULL | 2012-08-06
20:15:58 |         0 |            0 | NULL |       NULL |
+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+

After patch

+----------------+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
| accountlinesid | borrowernumber | accountno | itemnumber | date       |
amount   | description | dispute | accounttype | amountoutstanding |
lastincrement | timestamp           | notify_id | notify_level | note |
manager_id |
+----------------+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+
|              1 |              1 |         1 |       NULL | 2012-08-06 |
2.000000 | NULL        | NULL    | Pay         |              NULL |         
NULL | 2012-08-06 20:15:58 |         0 |            0 | NULL |       NULL |
+----------------+----------------+-----------+------------+------------+----------+-------------+---------+-------------+-------------------+---------------+---------------------+-----------+--------------+------+------------+


I then tested creating manual invoices, credits, reversing payments, paying,
and writing off.

The only thing I didnt test was overdue charges being added correctly. But as 2
others have already signed off on this. Marking signed off

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


More information about the Koha-bugs mailing list