https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26693
Tomás Cohen Arazi <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |In Discussion --- Comment #9 from Tomás Cohen Arazi <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
