BEGIN; -- SELECT evergreen.upgrade_deps_block_check('TODO', :eg_version); CREATE TABLE config.print_template ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, -- programatic name label TEXT NOT NULL, -- i18n owner INT NOT NULL REFERENCES actor.org_unit (id), active BOOLEAN NOT NULL DEFAULT FALSE, locale TEXT REFERENCES config.i18n_locale(code) ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, content_type TEXT NOT NULL DEFAULT 'text/html', template TEXT NOT NULL, CONSTRAINT name_once_per_lib UNIQUE (owner, name), CONSTRAINT label_once_per_lib UNIQUE (owner, label) ); INSERT INTO config.print_template (id, name, locale, active, owner, label, template) VALUES ( 1, 'patron_address', 'en-US', FALSE, (SELECT id FROM actor.org_unit WHERE parent_ou IS NULL), oils_i18n_gettext(1, 'Address Label', 'cpt', 'label'), $TEMPLATE$ [%- SET patron = template_data.patron; SET addr = template_data.address; -%]
Request Date | Patron Barcode | Patron Last | Patron Alias | Current Item |
---|---|---|---|---|
[% date.format(helpers.format_date( hold.request_time, staff_org_timezone), '%x %r', locale) %] | [% hold.ucard_barcode %] | [% hold.usr_family_name %] | [% hold.usr_alias %] | [% hold.cp_barcode %] |