Bug 21560: Optimize ODS export of gather_print_notices.pl
authorFridolin Somers <fridolin.somers@biblibre.com>
Fri, 7 Dec 2018 09:30:30 +0000 (10:30 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Tue, 26 Mar 2019 06:30:20 +0000 (07:30 +0100)
commite14da89d104ed1fd62136baafba60d42de9380b7
treee6793a675bd584ffff66f4acad0abbcf1792fd4e
parent04a9bf6b7f7ba3618a0e50ae9c589b0026bef5d1
Bug 21560: Optimize ODS export of gather_print_notices.pl

Like previous patch, the call on OpenOffice-OODoc lib can be optimized.
Based on https://grep.metacpan.org/search?qci=&q=expandTable&qft=&qd=OpenOffice-OODoc&f=examples%2Ftext2table

Test plan inspired from Bug 11679.

Test plan:
- define your ODUE notice for the print template as:
cardnumber:patron:email:item
<<borrowers.cardnumber>>:<<borrowers.firstname>> <<borrowers.surname>>:<<borrowers.email>>:<item><<items.barcode>></item>
- define overdues rules for a patron category
- check-out 2 items using a due date in order to generate the overdue notices
- check-in these 2 items
- launch the script /misc/cronjobs/overdue_notices.pl
- the 'message_queue' table should now contain 2 new entries
- launch the gather_print_notices cronjob :
  perl misc/cronjobs/gather_print_notices.pl /tmp/test --ods --letter_code=OVERDUE -d=:
- A ods file should be generated in your /tmp/test directory
- Compare times with and without patch

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit 5d4f80feac811a9d6e177975b50c57ba85e3434d)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit 4bc7751e4abe80973e991fbd80506c23f39910d8)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
(cherry picked from commit ef6d4aef4b34fa22a8850146615adf70411065ea)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
misc/cronjobs/gather_print_notices.pl