@@ -, +, @@ --- .../atomicupdate/Bug-12395-add-column-aqorders.created_by.sql | 1 + installer/data/mysql/kohastructure.sql | 1 + koha-tmpl/intranet-tmpl/prog/en/modules/acqui/orderreceive.tt | 7 +------ koha-tmpl/intranet-tmpl/prog/en/modules/acqui/showorder.tt | 2 +- 4 files changed, 4 insertions(+), 7 deletions(-) --- a/installer/data/mysql/atomicupdate/Bug-12395-add-column-aqorders.created_by.sql +++ a/installer/data/mysql/atomicupdate/Bug-12395-add-column-aqorders.created_by.sql @@ -1,2 +1,3 @@ ALTER TABLE aqorders ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived; +ALTER TABLE aqorders ADD CONSTRAINT aqorders_created_by FOREIGN KEY (created_by) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE; UPDATE aqorders, aqbasket SET aqorders.created_by = aqbasket.authorisedby WHERE aqorders.basketno = aqbasket.basketno; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3202,6 +3202,7 @@ CREATE TABLE `aqorders` ( -- information related to the basket line items KEY `budget_id` (`budget_id`), KEY `parent_ordernumber` (`parent_ordernumber`), KEY `orderstatus` (`orderstatus`), + CONSTRAINT aqorders_created_by FOREIGN KEY (created_by) REFERENCES borrowers (borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE, --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/orderreceive.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/orderreceive.tt @@ -176,12 +176,7 @@
  • - [% IF creator and (creator.firstname or creator.surname) %] - [% creator.firstname %] - [% creator.surname %] - [% ELSE %] - No name - [% END %] + [% INCLUDE 'patron-title.inc' patron = creator %]
  • --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/showorder.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/showorder.tt @@ -13,7 +13,7 @@
  • Ordered by: - [% creator.firstname %] [% creator.surname %] + [% INCLUDE 'patron-title.inc' patron = creator %]
  • Claims count: --