Open-ILS/src/sql/Pg/upgrade/0642.data.acq-worksheet-hold-count.sql

   1 -- Evergreen DB patch 0642.data.acq-worksheet-hold-count.sql
   2 BEGIN;
   3
   4 -- check whether patch can be applied
   5 SELECT evergreen.upgrade_deps_block_check('0642', :eg_version);
   6
   7 UPDATE action_trigger.event_definition SET template =
   8 $$
   9 [%- USE date -%]
  10 [%- SET li = target; -%]
  11 <div class="wrapper">
  12     <div class="summary" style='font-size:110%; font-weight:bold;'>
  13
  14         <div>Title: [% helpers.get_li_attr("title", "", li.attributes) %]</div>
  15         <div>Author: [% helpers.get_li_attr("author", "", li.attributes) %]</div>
  16         <div class="count">Item Count: [% li.lineitem_details.size %]</div>
  17         <div class="lineid">Lineitem ID: [% li.id %]</div>
  18         <div>Open Holds: [% helpers.bre_open_hold_count(li.eg_bib_id) %]</div>
  19
  20         [% IF li.distribution_formulas.size > 0 %]
  21             [% SET forms = [] %]
  22             [% FOREACH form IN li.distribution_formulas; forms.push(form.formula.name); END %]
  23             <div>Distribution Formulas: [% forms.join(',') %]</div>
  24         [% END %]
  25
  26         [% IF li.lineitem_notes.size > 0 %]
  27             Lineitem Notes:
  28             <ul>
  29                 [%- FOR note IN li.lineitem_notes -%]
  30                     <li>
  31                     [% IF note.alert_text %]
  32                         [% note.alert_text.code -%]
  33                         [% IF note.value -%]
  34                             : [% note.value %]
  35                         [% END %]
  36                     [% ELSE %]
  37                         [% note.value -%]
  38                     [% END %]
  39                     </li>
  40                 [% END %]
  41             </ul>
  42         [% END %]
  43     </div>
  44     <br/>
  45     <table>
  46         <thead>
  47             <tr>
  48                 <th>Branch</th>
  49                 <th>Barcode</th>
  50                 <th>Call Number</th>
  51                 <th>Fund</th>
  52                 <th>Shelving Location</th>
  53                 <th>Recd.</th>
  54                 <th>Notes</th>
  55             </tr>
  56         </thead>
  57         <tbody>
  58         [% FOREACH detail IN li.lineitem_details.sort('owning_lib') %]
  59             [%
  60                 IF detail.eg_copy_id;
  61                     SET copy = detail.eg_copy_id;
  62                     SET cn_label = copy.call_number.label;
  63                 ELSE;
  64                     SET copy = detail;
  65                     SET cn_label = detail.cn_label;
  66                 END
  67             %]
  68             <tr>
  69                 <!-- acq.lineitem_detail.id = [%- detail.id -%] -->
  70                 <td style='padding:5px;'>[% detail.owning_lib.shortname %]</td>
  71                 <td style='padding:5px;'>[% IF copy.barcode   %]<span class="barcode"  >[% detail.barcode   %]</span>[% END %]</td>
  72                 <td style='padding:5px;'>[% IF cn_label %]<span class="cn_label" >[% cn_label  %]</span>[% END %]</td>
  73                 <td style='padding:5px;'>[% IF detail.fund %]<span class="fund">[% detail.fund.code %] ([% detail.fund.year %])</span>[% END %]</td>
  74                 <td style='padding:5px;'>[% copy.location.name %]</td>
  75                 <td style='padding:5px;'>[% IF detail.recv_time %]<span class="recv_time">[% detail.recv_time %]</span>[% END %]</td>
  76                 <td style='padding:5px;'>[% detail.note %]</td>
  77             </tr>
  78         [% END %]
  79         </tbody>
  80     </table>
  81 </div>
  82 $$
  83 WHERE id = 14;
  84
  85 COMMIT;