[Koha-bugs] [Bug 26693] Add option to update dateaccessioned when receiving an order

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26693

Tomás Cohen Arazi <tomascohen at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ASSIGNED                    |In Discussion

--- Comment #9 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
Ok, I implemented this all:
- Syspref
- Checkboxes per item, set by default using the syspref
- Tweaked finishreceive.pl so it reads the checkboxes and updates
dateaccessioned when required.

Coool.

BUT disabling the date didn't work. So I tried without any patches:

MariaDB [koha_kohadev]> SELECT items.itemnumber, dateaccessioned FROM items
WHERE itemnumber IN (SELECT itemnumber FROM aqorders_items WHERE ordernumber IN
(SELECT ordernumber FROM aqorders WHERE basketno=1));
+------------+-----------------+
| itemnumber | dateaccessioned |
+------------+-----------------+
|        973 | 2021-02-11      |
|        974 | 2021-02-11      |
+------------+-----------------+
2 rows in set (0.00 sec)

MariaDB [koha_kohadev]> UPDATE items SET dateaccessioned='2021-02-09' WHERE
itemnumber IN (SELECT itemnumber FROM aqorders_items WHERE ordernumber IN
(SELECT ordernumber FROM aqorders WHERE basketno=1));
Query OK, 10 rows affected (0.01 sec)
Rows matched: 10  Changed: 10  Warnings: 0

MariaDB [koha_kohadev]> SELECT items.itemnumber, dateaccessioned FROM items
WHERE itemnumber IN (SELECT itemnumber FROM aqorders_items WHERE ordernumber IN
(SELECT ordernumber FROM aqorders WHERE basketno=1));
+------------+-----------------+
| itemnumber | dateaccessioned |
+------------+-----------------+
|        973 | 2021-02-09      |
|        974 | 2021-02-09      |
+------------+-----------------+
2 rows in set (0.00 sec)

MariaDB [koha_kohadev]> SELECT items.itemnumber, dateaccessioned FROM items
WHERE itemnumber IN (SELECT itemnumber FROM aqorders_items WHERE ordernumber IN
(SELECT ordernumber FROM aqorders WHERE basketno=1));
+------------+-----------------+
| itemnumber | dateaccessioned |
+------------+-----------------+
|        973 | 2021-02-11      |
|        974 | 2021-02-11      |
+------------+-----------------+
2 rows in set (0.00 sec)

BUMMER. So the actual behavior is that dateaccessioned gets updated regardless.
I will upload my patches here anyway, just in case this behavior I found is
incorrect and gets fixed on another bug report, and then we come back to this!

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