Bug 21392 - Some tables not available to AUTO_RENEW letter
Summary: Some tables not available to AUTO_RENEW letter
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Command-line Utilities (show other bugs)
Version: master
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on: 15705
Blocks:
  Show dependency treegraph
 
Reported: 2018-09-21 12:17 UTC by Magnus Enger
Modified: 2018-11-01 16:40 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Magnus Enger 2018-09-21 12:17:47 UTC
The AUTO_RENEW letter is prepared like so, including data from 4 tables:

 105            my $letter = C4::Letters::GetPreparedLetter(
 106                 module      => 'circulation',
 107                 letter_code => 'AUTO_RENEWALS',
 108                 tables      => {
 109                     borrowers => $patron->borrowernumber,
 110                     issues    => $issue->itemnumber,
 111                     items     => $issue->itemnumber,
 112                     biblio    => $item->biblionumber,
 113                 },
 114             );

http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=misc/cronjobs/automatic_renewals.pl;h=6a170ca20f5f0aabc81f340b2c70b25dd8d4206a;hb=HEAD#l105

But when you go to Tools > Notices & slips to edit the contents of AUTO_RENEWALS, several more tables are listed as available. This includes: 

- branches
- biblioitems
- opac_news

If you try to include information from these three tables it will be missing from the final letter.