[Koha-bugs] [Bug 9293] New: action_logs not tracking payments

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

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

            Bug ID: 9293
           Summary: action_logs not tracking payments
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Transaction logs
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: nengard at gmail.com

I have been checking the action_logs table to find payments and which user paid
the fines, but I'm not seeing them at all. Below are my queries on the table.
Logging is on, and it's tracking fines charged automatically and manually and
it's tracking dropbox forgiving fines and writeoffs (i think). But not payments
that I can see. The log should log all fines actions.


mysql> select timestamp, user, action, object, info from action_logs where
module='FINES' and user != 0 limit 10;
+---------------------+--------+--------+---------+-----------------------------------------------------+
| timestamp           | user   | action | object  | info                       
                        |
+---------------------+--------+--------+---------+-----------------------------------------------------+
| 2012-09-02 11:40:50 | 146258 |        | 1058715 | due=09/01/2012 23:59 
amount=0.1 itemnumber=252043  |
| 2012-09-02 11:41:51 | 146258 |        | 1034172 | due=08/24/2012 23:59 
amount=0.9 itemnumber=468810  |
| 2012-09-02 11:43:23 | 146258 |        | 1098788 | due=02/06/2012 23:59 
amount=3.00 itemnumber=292689 |
| 2012-09-02 11:44:48 | 146258 |        | 1098788 | due=01/30/2012 23:59 
amount=3.00 itemnumber=395796 |
| 2012-09-02 11:45:09 | 146258 |        | 1034172 | due=08/24/2012 23:59 
amount=0.9 itemnumber=486769  |
| 2012-09-02 11:47:06 | 146258 |        | 1058402 | due=09/01/2012 23:59 
amount=0.1 itemnumber=491656  |
| 2012-09-02 11:47:12 | 146258 |        | 1058402 | due=09/01/2012 23:59 
amount=0.1 itemnumber=526858  |
| 2012-09-02 11:47:16 | 146258 |        | 1058402 | due=09/01/2012 23:59 
amount=0.1 itemnumber=537406  |
| 2012-09-02 11:47:22 | 146258 |        | 1058402 | due=09/01/2012 23:59 
amount=0.1 itemnumber=511679  |
| 2012-09-02 11:47:41 | 146258 |        | 1098788 | due=02/06/2012 23:59 
amount=3.00 itemnumber=489449 |
+---------------------+--------+--------+---------+-----------------------------------------------------+
10 rows in set (0.00 sec)

mysql> select timestamp, user, action, object, info from action_logs where
module='FINES' and action='MODIFY' and user != 0 limit 10;
+---------------------+--------+--------+---------+-----------------------------------+
| timestamp           | user   | action | object  | info                       
      |
+---------------------+--------+--------+---------+-----------------------------------+
| 2012-09-02 11:51:09 | 146257 | MODIFY | 1149266 | Dropbox adjustment 0, item
399887 |
| 2012-09-02 11:51:18 | 146257 | MODIFY | 1149266 | Dropbox adjustment 0, item
537469 |
| 2012-09-02 11:51:23 | 146257 | MODIFY | 1066164 | Dropbox adjustment 0, item
4588   |
| 2012-09-02 11:56:03 | 146257 | MODIFY | 1104714 | Dropbox adjustment 0, item
541027 |
| 2012-09-02 11:56:12 | 146257 | MODIFY | 1104714 | Dropbox adjustment 0, item
12471  |
| 2012-09-02 11:57:03 | 146257 | MODIFY | 1182366 | Dropbox adjustment 0, item
84270  |
| 2012-09-02 11:58:51 | 146257 | MODIFY | 1033313 | Dropbox adjustment 0, item
331794 |
| 2012-09-02 11:59:27 | 146257 | MODIFY | 1066164 | Dropbox adjustment 0, item
538578 |
| 2012-09-02 12:01:12 | 146257 | MODIFY | 1149753 | Dropbox adjustment 0, item
190944 |
| 2012-09-02 14:17:32 | 146254 | MODIFY | 1052342 | Dropbox adjustment 0, item
553366 |
+---------------------+--------+--------+---------+-----------------------------------+
10 rows in set (0.00 sec)

Database changed
mysql> select timestamp, user, action, object, info from action_logs where
module='FINES' and action='MODIFY' and user != 0 and info not like '%dropbox%'
limit 10;
+---------------------+--------+--------+---------+-------------------------------+
| timestamp           | user   | action | object  | info                       
  |
+---------------------+--------+--------+---------+-------------------------------+
| 2012-09-04 08:38:51 | 146257 | MODIFY | 1175137 | Overdue forgiven: item
384714 |
| 2012-09-04 08:39:23 | 146257 | MODIFY | 1164307 | Overdue forgiven: item
205688 |
| 2012-09-04 08:40:24 | 146257 | MODIFY | 1175137 | Overdue forgiven: item
394110 |
| 2012-09-04 08:40:32 | 146257 | MODIFY | 1164307 | Overdue forgiven: item
93445  |
| 2012-09-04 08:40:36 | 146257 | MODIFY | 1164307 | Overdue forgiven: item
366920 |
| 2012-09-04 08:40:41 | 146257 | MODIFY | 1164307 | Overdue forgiven: item
373410 |
| 2012-09-04 09:14:13 | 146257 | MODIFY |  751038 | Overdue forgiven: item
372751 |
| 2012-09-04 09:18:16 | 146272 | MODIFY | 1180787 | Overdue forgiven: item
208422 |
| 2012-09-04 09:23:14 | 146272 | MODIFY | 1180787 | Overdue forgiven: item
517498 |
| 2012-09-04 09:25:53 | 146272 | MODIFY | 1180787 | Overdue forgiven: item
415316 |
+---------------------+--------+--------+---------+-------------------------------+
10 rows in set (0.01 sec)

mysql> select timestamp, user, action, object, info from action_logs where
module='FINES' and action='MODIFY' and user != 0 and info not like '%dropbox%'
and info not like '%forgiven%' limit 10;
Empty set (2.28 sec)

mysql> select timestamp, user, action, object, info from action_logs where
module='FINES' and user != 0 and info not like '%dropbox%' and info not like
'%forgiven%' limit 10;
+---------------------+--------+--------+---------+-----------------------------------------------------+
| timestamp           | user   | action | object  | info                       
                        |
+---------------------+--------+--------+---------+-----------------------------------------------------+
| 2012-09-02 11:40:50 | 146258 |        | 1058715 | due=09/01/2012 23:59 
amount=0.1 itemnumber=252043  |
| 2012-09-02 11:41:51 | 146258 |        | 1034172 | due=08/24/2012 23:59 
amount=0.9 itemnumber=468810  |
| 2012-09-02 11:43:23 | 146258 |        | 1098788 | due=02/06/2012 23:59 
amount=3.00 itemnumber=292689 |
| 2012-09-02 11:44:48 | 146258 |        | 1098788 | due=01/30/2012 23:59 
amount=3.00 itemnumber=395796 |
| 2012-09-02 11:45:09 | 146258 |        | 1034172 | due=08/24/2012 23:59 
amount=0.9 itemnumber=486769  |
| 2012-09-02 11:47:06 | 146258 |        | 1058402 | due=09/01/2012 23:59 
amount=0.1 itemnumber=491656  |
| 2012-09-02 11:47:12 | 146258 |        | 1058402 | due=09/01/2012 23:59 
amount=0.1 itemnumber=526858  |
| 2012-09-02 11:47:16 | 146258 |        | 1058402 | due=09/01/2012 23:59 
amount=0.1 itemnumber=537406  |
| 2012-09-02 11:47:22 | 146258 |        | 1058402 | due=09/01/2012 23:59 
amount=0.1 itemnumber=511679  |
| 2012-09-02 11:47:41 | 146258 |        | 1098788 | due=02/06/2012 23:59 
amount=3.00 itemnumber=489449 |
+---------------------+--------+--------+---------+-----------------------------------------------------+
10 rows in set (0.00 sec)

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