[Koha-bugs] [Bug 8991] Add a script to delete old orders

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

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

--- Comment #19 from M. de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to M. de Rooy from comment #18)
> Note: get_baskets_to_delete will not return all deletable baskets in dry-run
> mode. Not sure if you should really need that, but the information now is
> not accurate..

I reread one of my earlier comments on this report.
I still prefer to delete in terms of completed baskets than completed orders.
Actually the Koha basket is "the order" and the Koha order is "an order line".
If all order lines have been processed and pass the date filter, the basket
could be deleted via DelBasket with a cascading effect to aqorders and
aqorders_items.

I agree with Galen for the folder. I would also suggest to move it to
misc/maintenance. No problem to run a cron job from there, but most people will
probably run this at most annually and manually :)

In order to meet the concerns raised about deleting valuable acquisition
history, what do you think about adding a few lines that copy aqbasket,
aqorders and aqorders_items for the selected baskets into some [temporary]
archive tables and dumping these tables to file? The archive and sqldump steps
could be parametrized.

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