'cwst', 'label'
)
);
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('items_out', 'Patron Items Out', 1, TRUE, 'en-US', 'text/html', '');
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ circulations = template_data.circulations;
+%]
+<div>
+ <div>Welcome to [% staff_org.name %]</div>
+ <div>You have the following items:</div>
+ <hr/>
+ <ol>
+ [% FOR checkout IN circulations %]
+ <li>
+ <div>[% checkout.title %]</div>
+ <div>
+ [% IF checkout.copy %]Barcode: [% checkout.copy.barcode %][% END %]
+ Due: [% date.format(helpers.format_date(checkout.dueDate, staff_org_timezone), '%x %r') %]
+ </div>
+ </li>
+ [% END %]
+ </ol>
+ <hr/>
+ <div>[% staff_org.name %] [% date.format(date.now, '%x %r') %]</div>
+ <div>You were helped by [% staff.first_given_name %]</div>
+ <br/>
+</div>
+$TEMPLATE$ WHERE name = 'items_out';
+
+UPDATE config.print_template SET active = TRUE WHERE name = 'patron_address';
+
+-- insert then update for easier iterative development tweaks
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('bills_current', 'Bills, Current', 1, TRUE, 'en-US', 'text/html', '');
+
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET xacts = template_data.xacts;
+%]
+<div>
+ <style>td { padding: 1px 3px 1px 3px; }</style>
+ <div>Welcome to [% staff_org.name %]</div>
+ <div>You have the following bills:</div>
+ <hr/>
+ <ol>
+ [% FOR xact IN xacts %]
+ <li>
+ <table>
+ <tr>
+ <td>Bill #:</td>
+ <td>[% xact.id %]</td>
+ </tr>
+ <tr>
+ <td>Date:</td>
+ <td>[% date.format(helpers.format_date(
+ xact.xact_start, staff_org_timezone), '%x %r') %]
+ </td>
+ </tr>
+ <tr>
+ <td>Last Billing:</td>
+ <td>[% xact.last_billing_type %]</td>
+ </tr>
+ <tr>
+ <td>Total Billed:</td>
+ <td>[% money(xact.total_owed) %]</td>
+ </tr>
+ <tr>
+ <td>Last Payment:</td>
+ <td>
+ [% xact.last_payment_type %]
+ [% IF xact.last_payment_ts %]
+ at [% date.format(
+ helpers.format_date(
+ xact.last_payment_ts, staff_org_timezone), '%x %r') %]
+ [% END %]
+ </td>
+ </tr>
+ <tr>
+ <td>Total Paid:</td>
+ <td>[% money(xact.total_paid) %]</td>
+ </tr>
+ <tr>
+ <td>Balance:</td>
+ <td>[% money(xact.balance_owed) %]</td>
+ </tr>
+ </table>
+ </li>
+ [% END %]
+ </ol>
+ <hr/>
+ <div>[% staff_org.name %] [% date.format(date.now, '%x %r') %]</div>
+ <div>You were helped by [% staff.first_given_name %]</div>
+ <br/>
+</div>
+$TEMPLATE$ WHERE name = 'bills_current';
+
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('bills_payment', 'Bills, Payment', 1, TRUE, 'en-US', 'text/html', '');
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET payments = template_data.payments;
+ SET previous_balance = template_data.previous_balance;
+ SET new_balance = template_data.new_balance;
+ SET payment_type = template_data.payment_type;
+ SET payment_total = template_data.payment_total;
+ SET payment_applied = template_data.payment_applied;
+ SET amount_voided = template_data.amount_voided;
+ SET change_given = template_data.change_given;
+ SET payment_note = template_data.payment_note;
+ SET copy_barcode = template_data.copy_barcode;
+ SET title = template_data.title;
+%]
+<div>
+ <style>td { padding: 1px 3px 1px 3px; }</style>
+ <div>Welcome to [% staff_org.name %]</div>
+ <div>A receipt of your transaction:</div>
+ <hr/>
+
+ <table style="width:100%">
+ <tr>
+ <td>Original Balance:</td>
+ <td align="right">[% money(previous_balance) %]</td>
+ </tr>
+ <tr>
+ <td>Payment Method:</td>
+ <td align="right">
+ [% SWITCH payment_type %]
+ [% CASE "cash_payment" %]Cash
+ [% CASE "check_payment" %]Check
+ [% CASE "credit_card_payment" %]Credit Card
+ [% CASE "debit_card_payment" %]Debit Card
+ [% CASE "credit_payment" %]Patron Credit
+ [% CASE "work_payment" %]Work
+ [% CASE "forgive_payment" %]Forgive
+ [% CASE "goods_payment" %]Goods
+ [% END %]
+ </td>
+ </tr>
+ <tr>
+ <td>Payment Received:</td>
+ <td align="right">[% money(payment_total) %]</td>
+ </tr>
+ <tr>
+ <td>Payment Applied:</td>
+ <td align="right">[% money(payment_applied) %]</td>
+ </tr>
+ <tr>
+ <td>Billings Voided:</td>
+ <td align="right">[% money(amount_voided) %]</td>
+ </tr>
+ <tr>
+ <td>Change Given:</td>
+ <td align="right">[% money(change_given) %]</td>
+ </tr>
+ <tr>
+ <td>New Balance:</td>
+ <td align="right">[% money(new_balance) %]</td>
+ </tr>
+ </table>
+ <p>Note: [% payment_note %]</p>
+ <p>
+ Specific Bills
+ <blockquote>
+ [% FOR payment IN payments %]
+ <table style="width:100%">
+ <tr>
+ <td>Bill # [% payment.xact.id %]</td>
+ <td>[% payment.xact.summary.last_billing_type %]</td>
+ <td>Received: [% money(payment.amount) %]</td>
+ </tr>
+ [% IF payment.copy_barcode %]
+ <tr>
+ <td colspan="5">[% payment.copy_barcode %] [% payment.title %]</td>
+ </tr>
+ [% END %]
+ </table>
+ <br/>
+ [% END %]
+ </blockquote>
+ </p>
+ <hr/>
+ <br/><br/>
+ <div>[% staff_org.name %] [% date.format(date.now, '%x %r') %]</div>
+ <div>You were helped by [% staff.first_given_name %]</div>
+</div>
+$TEMPLATE$ WHERE name = 'bills_payment';
+
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('patron_data', 'Patron Data', 1, TRUE, 'en-US', 'text/html', '');
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET patron = template_data.patron;
+%]
+<table>
+ <tr><td>Barcode:</td><td>[% patron.card.barcode %]</td></tr>
+ <tr><td>Patron's Username:</td><td>[% patron.usrname %]</td></tr>
+ <tr><td>Prefix/Title:</td><td>[% patron.prefix %]</td></tr>
+ <tr><td>First Name:</td><td>[% patron.first_given_name %]</td></tr>
+ <tr><td>Middle Name:</td><td>[% patron.second_given_name %]</td></tr>
+ <tr><td>Last Name:</td><td>[% patron.family_name %]</td></tr>
+ <tr><td>Suffix:</td><td>[% patron.suffix %]</td></tr>
+ <tr><td>Holds Alias:</td><td>[% patron.alias %]</td></tr>
+ <tr><td>Date of Birth:</td><td>[% patron.dob %]</td></tr>
+ <tr><td>Juvenile:</td><td>[% patron.juvenile %]</td></tr>
+ <tr><td>Primary Identification Type:</td><td>[% patron.ident_type.name %]</td></tr>
+ <tr><td>Primary Identification:</td><td>[% patron.ident_value %]</td></tr>
+ <tr><td>Secondary Identification Type:</td><td>[% patron.ident_type2.name %]</td></tr>
+ <tr><td>Secondary Identification:</td><td>[% patron.ident_value2 %]</td></tr>
+ <tr><td>Email Address:</td><td>[% patron.email %]</td></tr>
+ <tr><td>Daytime Phone:</td><td>[% patron.day_phone %]</td></tr>
+ <tr><td>Evening Phone:</td><td>[% patron.evening_phone %]</td></tr>
+ <tr><td>Other Phone:</td><td>[% patron.other_phone %]</td></tr>
+ <tr><td>Home Library:</td><td>[% patron.home_ou.name %]</td></tr>
+ <tr><td>Main (Profile) Permission Group:</td><td>[% patron.profile.name %]</td></tr>
+ <tr><td>Privilege Expiration Date:</td><td>[% patron.expire_date %]</td></tr>
+ <tr><td>Internet Access Level:</td><td>[% patron.net_access_level.name %]</td></tr>
+ <tr><td>Active:</td><td>[% patron.active %]</td></tr>
+ <tr><td>Barred:</td><td>[% patron.barred %]</td></tr>
+ <tr><td>Is Group Lead Account:</td><td>[% patron.master_account %]</td></tr>
+ <tr><td>Claims-Returned Count:</td><td>[% patron.claims_returned_count %]</td></tr>
+ <tr><td>Claims-Never-Checked-Out Count:</td><td>[% patron.claims_never_checked_out_count %]</td></tr>
+ <tr><td>Alert Message:</td><td>[% patron.alert_message %]</td></tr>
+
+ [% FOR addr IN patron.addresses %]
+ <tr><td colspan="2">----------</td></tr>
+ <tr><td>Type:</td><td>[% addr.address_type %]</td></tr>
+ <tr><td>Street (1):</td><td>[% addr.street1 %]</td></tr>
+ <tr><td>Street (2):</td><td>[% addr.street2 %]</td></tr>
+ <tr><td>City:</td><td>[% addr.city %]</td></tr>
+ <tr><td>County:</td><td>[% addr.county %]</td></tr>
+ <tr><td>State:</td><td>[% addr.state %]</td></tr>
+ <tr><td>Postal Code:</td><td>[% addr.post_code %]</td></tr>
+ <tr><td>Country:</td><td>[% addr.country %]</td></tr>
+ <tr><td>Valid Address?:</td><td>[% addr.valid %]</td></tr>
+ <tr><td>Within City Limits?:</td><td>[% addr.within_city_limits %]</td></tr>
+ [% END %]
+
+ [% FOR entry IN patron.stat_cat_entries %]
+ <tr><td>-----------</td></tr>
+ <tr><td>[% entry.stat_cat.name %]</td><td>[% entry.stat_cat_entry %]</td></tr>
+ [% END %]
+
+</table>
+
+$TEMPLATE$ WHERE name = 'patron_data';
+
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('hold_shelf_slip', 'Hold Shelf Slip', 1, TRUE, 'en-US', 'text/html', '');
+
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET copy = template_data.checkin.copy;
+ SET hold = template_data.checkin.hold;
+ SET volume = template_data.checkin.volume;
+ SET hold = template_data.checkin.hold;
+ SET record = template_data.checkin.record;
+ SET patron = template_data.checkin.patron;
+%]
+
+<div>
+ [% IF hold.behind_desk == 't' %]
+ This item needs to be routed to the <strong>Private Holds Shelf</strong>.
+ [% ELSE %]
+ This item needs to be routed to the <strong>Public Holds Shelf</strong>.
+ [% END %]
+</div>
+<br/>
+
+<div>Barcode: [% copy.barcode %]</div>
+<div>Title: [% checkin.title %]</div>
+<div>Call Number: [% volume.prefix.label %] [% volume.label %] [% volume.suffix.label %]</div>
+
+<br/>
+
+<div>Hold for patron: [% patron.family_name %],
+ [% patron.first_given_name %] [% patron.second_given_name %]</div>
+<div>Barcode: [% patron.card.barcode %]</div>
+
+[% IF hold.phone_notify %]
+ <div>Notify by phone: [% hold.phone_notify %]</div>
+[% END %]
+[% IF hold.sms_notify %]
+ <div>Notify by text: [% hold.sms_notify %]</div>
+[% END %]
+[% IF hold.email_notify %]
+ <div>Notify by email: [% patron.email %]</div>
+[% END %]
+
+[% FOR note IN hold.notes %]
+ <ul>
+ [% IF note.slip == 't' %]
+ <li><strong>[% note.title %]</strong> - [% note.body %]</li>
+ [% END %]
+ </ul>
+[% END %]
+<br/>
+
+<div>Request Date: [%
+ date.format(helpers.format_date(hold.request_time, staff_org_timezone), '%x %r') %]</div>
+<div>Slip Date: [% date.format(date.now, '%x %r') %]</div>
+<div>Printed by [% staff.first_given_name %] at [% staff_org.shortname %]</div>
+
+</div>
+
+$TEMPLATE$ WHERE name = 'hold_shelf_slip';
+
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('transit_slip', 'Transit Slip', 1, TRUE, 'en-US', 'text/html', '');
+
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET checkin = template_data.checkin;
+ SET copy = checkin.copy;
+ SET destOrg = checkin.destOrg;
+ SET destAddress = checkin.destAddress;
+ SET destCourierCode = checkin.destCourierCode;
+%]
+<div>
+ <div>This item needs to be routed to <b>[% destOrg.shortname %]</b></div>
+ <div>[% destOrg.name %]</div>
+ [% IF destCourierCode %]Courier Code: [% destCourierCode %][% END %]
+
+ [% IF destAddress %]
+ <div>[% destAddress.street1 %]</div>
+ <div>[% destAddress.street2 %]</div>
+ <div>[% destAddress.city %],
+ [% destAddress.state %]
+ [% destAddress.post_code %]</div>
+ [% ELSE %]
+ <div>We do not have a holds address for this library.</div>
+ [% END %]
+
+ <br/>
+ <div>Barcode: [% copy.barcode %]</div>
+ <div>Title: [% checkin.title %]</div>
+ <div>Author: [% checkin.author %]</div>
+
+ <br/>
+ <div>Slip Date: [% date.format(date.now, '%x %r') %]</div>
+ <div>Printed by [% staff.first_given_name %] at [% staff_org.shortname %]</div>
+</div>
+
+$TEMPLATE$ WHERE name = 'transit_slip';
+
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('hold_transit_slip', 'Hold Transit Slip', 1, TRUE, 'en-US', 'text/html', '');
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET checkin = template_data.checkin;
+ SET copy = checkin.copy;
+ SET hold = checkin.hold;
+ SET patron = checkin.patron;
+ SET destOrg = checkin.destOrg;
+ SET destAddress = checkin.destAddress;
+ SET destCourierCode = checkin.destCourierCode;
+%]
+<div>
+ <div>This item needs to be routed to <b>[% destOrg.shortname %]</b></div>
+ <div>[% destOrg.name %]</div>
+ [% IF destCourierCode %]Courier Code: [% destCourierCode %][% END %]
+
+ [% IF destAddress %]
+ <div>[% destAddress.street1 %]</div>
+ <div>[% destAddress.street2 %]</div>
+ <div>[% destAddress.city %],
+ [% destAddress.state %]
+ [% destAddress.post_code %]</div>
+ [% ELSE %]
+ <div>We do not have a holds address for this library.</div>
+ [% END %]
+
+ <br/>
+ <div>Barcode: [% copy.barcode %]</div>
+ <div>Title: [% checkin.title %]</div>
+ <div>Author: [% checkin.author %]</div>
+
+ <br/>
+ <div>Hold for patron [% patron.card.barcode %]</div>
+
+ <br/>
+ <div>Request Date: [%
+ date.format(helpers.format_date(hold.request_time, staff_org_timezone), '%x %r') %]
+ </div>
+ <div>Slip Date: [% date.format(date.now, '%x %r') %]</div>
+ <div>Printed by [% staff.first_given_name %] at [% staff_org.shortname %]</div>
+</div>
+
+$TEMPLATE$ WHERE name = 'transit_slip';
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('checkin', 'Checkin', 1, TRUE, 'en-US', 'text/html', '');
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET checkins = template_data.checkins;
+%]
+
+<div>
+ <div>Welcome to [% staff_org.name %]</div>
+ <div>You checked in the following items:</div>
+ <hr/>
+ <ol>
+ [% FOR checkin IN checkins %]
+ <li>
+ <div>[% checkin.title %]</div>
+ <span>Barcode: </span>
+ <span>[% checkin.copy.barcode %]</span>
+ <span>Call Number: </span>
+ <span>
+ [% IF checkin.volume %]
+ [% volume.prefix.label %] [% volume.label %] [% volume.suffix.label %]
+ [% ELSE %]
+ Not Cataloged
+ [% END %]
+ </span>
+ </li>
+ [% END %]
+ </ol>
+ <hr/>
+ <div>Slip Date: [% date.format(date.now, '%x %r') %]</div>
+ <div>Printed by [% staff.first_given_name %] at [% staff_org.shortname %]</div>
+</div>
+
+$TEMPLATE$ WHERE name = 'checkin';
+
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('holds_for_patron', 'Holds For Patron', 1, TRUE, 'en-US', 'text/html', '');
+
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET holds = template_data;
+%]
+
+<div>
+ <div>Welcome to [% staff_org.name %]</div>
+ <div>You have the following items on hold:</div>
+ <hr/>
+ <ol>
+ [% FOR hold IN holds %]
+ <li>
+ <div>[% hold.title %]</div>
+ </li>
+ [% END %]
+ </ol>
+ <hr/>
+ <div>Slip Date: [% date.format(date.now, '%x %r') %]</div>
+ <div>Printed by [% staff.first_given_name %] at [% staff_org.shortname %]</div>
+</div>
+
+$TEMPLATE$ WHERE name = 'holds_for_patron';
+
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('bills_historical', 'Bills, Historical', 1, TRUE, 'en-US', 'text/html', '');
+
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET xacts = template_data.xacts;
+%]
+<div>
+ <style>td { padding: 1px 3px 1px 3px; }</style>
+ <div>Welcome to [% staff_org.name %]</div>
+ <div>You have the following bills:</div>
+ <hr/>
+ <ol>
+ [% FOR xact IN xacts %]
+ <li>
+ <table>
+ <tr>
+ <td>Bill #:</td>
+ <td>[% xact.id %]</td>
+ </tr>
+ <tr>
+ <td>Date:</td>
+ <td>[% date.format(helpers.format_date(
+ xact.xact_start, staff_org_timezone), '%x %r') %]
+ </td>
+ </tr>
+ <tr>
+ <td>Last Billing:</td>
+ <td>[% xact.last_billing_type %]</td>
+ </tr>
+ <tr>
+ <td>Total Billed:</td>
+ <td>[% money(xact.total_owed) %]</td>
+ </tr>
+ <tr>
+ <td>Last Payment:</td>
+ <td>
+ [% xact.last_payment_type %]
+ [% IF xact.last_payment_ts %]
+ at [% date.format(
+ helpers.format_date(
+ xact.last_payment_ts, staff_org_timezone), '%x %r') %]
+ [% END %]
+ </td>
+ </tr>
+ <tr>
+ <td>Total Paid:</td>
+ <td>[% money(xact.total_paid) %]</td>
+ </tr>
+ <tr>
+ <td>Balance:</td>
+ <td>[% money(xact.balance_owed) %]</td>
+ </tr>
+ </table>
+ </li>
+ [% END %]
+ </ol>
+ <hr/>
+ <div>[% staff_org.name %] [% date.format(date.now, '%x %r') %]</div>
+ <div>You were helped by [% staff.first_given_name %]</div>
+ <br/>
+</div>
+$TEMPLATE$ WHERE name = 'bills_historical';
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('checkout', 'Checkout', 1, TRUE, 'en-US', 'text/html', '');
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET checkouts = template_data.checkouts;
+%]
+
+<div>
+ <div>Welcome to [% staff_org.name %]</div>
+ <div>You checked out the following items:</div>
+ <hr/>
+ <ol>
+ [% FOR checkout IN checkouts %]
+ <li>
+ <div>[% checkout.title %]</div>
+ <span>Barcode: </span>
+ <span>[% checkout.copy.barcode %]</span>
+ <span>Call Number: </span>
+ <span>
+ [% IF checkout.volume %]
+ [% volume.prefix.label %] [% volume.label %] [% volume.suffix.label %]
+ [% ELSE %]
+ Not Cataloged
+ [% END %]
+ </span>
+ </li>
+ [% END %]
+ </ol>
+ <hr/>
+ <div>Slip Date: [% date.format(date.now, '%x %r') %]</div>
+ <div>Printed by [% staff.first_given_name %] at [% staff_org.shortname %]</div>
+</div>
+
+$TEMPLATE$ WHERE name = 'checkout';
+
+INSERT INTO config.print_template
+ (name, label, owner, active, locale, content_type, template)
+VALUES ('renew', 'renew', 1, TRUE, 'en-US', 'text/html', '');
+
+UPDATE config.print_template SET template = $TEMPLATE$
+[%
+ USE date;
+ USE money = format('$%.2f');
+ SET renewals = template_data.renewals;
+%]
+
+<div>
+ <div>Welcome to [% staff_org.name %]</div>
+ <div>You renewed the following items:</div>
+ <hr/>
+ <ol>
+ [% FOR renewal IN renewals %]
+ <li>
+ <div>[% renewal.title %]</div>
+ <span>Barcode: </span>
+ <span>[% renewal.copy.barcode %]</span>
+ <span>Call Number: </span>
+ <span>
+ [% IF renewal.volume %]
+ [% volume.prefix.label %] [% volume.label %] [% volume.suffix.label %]
+ [% ELSE %]
+ Not Cataloged
+ [% END %]
+ </span>
+ </li>
+ [% END %]
+ </ol>
+ <hr/>
+ <div>Slip Date: [% date.format(date.now, '%x %r') %]</div>
+ <div>Printed by [% staff.first_given_name %] at [% staff_org.shortname %]</div>
+</div>
+
+$TEMPLATE$ WHERE name = 'renew';
+
projects / evergreen-equinox.git / commitdiff