[Koha-bugs] [Bug 10758] Show bibliographic information of deleted records in acquisitions

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

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

--- Comment #4 from mathieu saby <mathieu.saby at univ-rennes2.fr> ---
I think we also need a way to pass to the basket template the information about
the "deletion status" of each record, in order to suppress the HTML link
pointing to the biblio for each order (if the biblio is deleted, the title
should be display in plain text without link).
The ideal would be that the "deletion status" of each record should be included
in the results of GetOrders, for each order.

Currently there is a "ON DELETE SET NULL" constraint on biblio.biblionumber on
table aqorders : 
  CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio`
(`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE

I suppose one solution could be alter this constraint to suppress the "ON
DELETE SET NULL", so that the biblionumber is kept in aqorders table, even if
the biblio is deleted.

But maybe it would be better to keep this column unchanged, and to create a new
one, "aqorders.deletedbiblionumber", to be filled when a record is suppressed.
The advantage would be to be able to know direclty if an order is linked to an
existing record or to a deleted record.

In fact I wonder why we have deleted(biblio/biblioitems/items) tables. Would
not have been simplier to keep suppressed items and records in the main table,
and to add a colum "deleted" in those tables? So the subs about Orders,
reserves, circulation... won't have to use union between deleted* and main
tables.

M. Saby

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