Attachment #133096 for bug #23528

View | Details | Raw Unified | Return to bug 23528
Collapse All | Expand All





        $dbh->do(q{INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES ( 'members', 'OPAC_REG', '', 'New OPAC self-registration submitted', 1, 'New OPAC self-registration',
            '<h3>New OPAC self-registration</h3>
            <p><h4>Self-registration made:</h4>
            <ul>
            <li>[% borrower.firstname %] [% borrower.surname %]</li>
            [% IF borrower.cardnumber %]<li>Cardnumber: [% borrower.cardnumber %]</li>[% END %]
            [% IF borrower.email %]<li>Email: [% borrower.email %]</li>[% END %]
            [% IF borrower.phone %]<li>Phone: [% borrower.phone %]</li>[% END %]
            [% IF borrower.mobile %]<li>Mobile: [% borrower.mobile %]</li>[% END %]
            [% IF borrower.fax %]<li>Fax: [% borrower.fax %]</li>[% END %]
            [% IF borrower.emailpro %]<li>Secondary email: [% borrower.emailpro %]</li>[% END %]
            [% IF borrower.phonepro %]<li>Secondary phone:[% borrower.phonepro %]</li>[% END %]
            [% IF borrower.branchcode %]<li>Home library: [% borrower.branchcode %]</li>[% END %]
            [% IF borrower.categorycode %]<li>Patron category: [% borrower.categorycode %]</li>[% END %]
            </ul>
            </p>', 'email', 'default') });
    },




          lang: default
          content:
            - "<h3>New OPAC self-registration</h3>"
            - "<p><h4>Self-registration made:</h4>"
            - "<ul>"
            - "<li> [% borrower.firstname %] [% borrower.surname %]</li>"
            - "[% IF borrower.cardnumber %]<li>Cardnumber: [% borrower.cardnumber %]</li>[% END %]"
            - "[% IF borrower.email %]<li>Email: [% borrower.email %]</li>[% END %]"
            - "[% IF borrower.phone %]<li>Phone: [% borrower.phone %]</li>[% END %]"
            - "[% IF borrower.mobile %]<li>Mobile: [% borrower.mobile %]</li>[% END %]"
            - "[% IF borrower.fax %]<li>Fax: [% borrower.fax %]</li>[% END %]"
            - "[% IF borrower.emailpro %]<li>Secondary email: [% borrower.emailpro %]</li>[% END %]"
            - "[% IF borrower.phonepro %]<li>Secondary phone: [% borrower.phonepro %]</li>[% END %]"
            - "[% IF borrower.branchcode %]<li>Home library: [% borrower.branchcode %]</li>[% END %]"
            - "[% IF borrower.categorycode %]<li>Temporary patron category: [% borrower.categorycode %]</li>[% END %]"
            - "</ul>"
            - "</p>"




    [% END %]
[% END %]
", 'email');

INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES ( 'members', 'OPAC_REG', '', 'New OPAC self-registration submitted', 1, 'New OPAC self-registration','<h3>New OPAC self-registration</h3>
    <p><h4>Self-registration made:</h4>
    <ul>
    <li>[% borrower.firstname %] [% borrower.surname %]</li>
    [% IF borrower.cardnumber %]<li>Cardnumber: [% borrower.cardnumber %]</li>[% END %]
    [% IF borrower.email %]<li>Email: [% borrower.email %]</li>[% END %]
    [% IF borrower.phone %]<li>Phone: [% borrower.phone %]</li>[% END %]
    [% IF borrower.mobile %]<li>Mobile: [% borrower.mobile %]</li>[% END %]
    [% IF borrower.fax %]<li>Fax: [% borrower.fax %]</li>[% END %]
    [% IF borrower.emailpro %]<li>Secondary email: [% borrower.emailpro %]</li>[% END %]
    [% IF borrower.phonepro %]<li>Secondary phone:[% borrower.phonepro %]</li>[% END %]
    [% IF borrower.branchcode %]<li>Home library: [% borrower.branchcode %]</li>[% END %]
    [% IF borrower.categorycode %]<li>Patron category: [% borrower.categorycode %]</li>[% END %]
    </ul>
   </p>', 'email', 'default')

Return to bug 23528

Lines 11-27 return { Link Here

(-)a/installer/data/mysql/atomicupdate/bug23538-add_EmailPatronRegistrations_and_EmailAddressForPatronRegistrations_sysprefs.pl (-10 / +11 lines)
11		11
12	$dbh->do(q{INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES ( 'members', 'OPAC_REG', '', 'New OPAC self-registration submitted', 1, 'New OPAC self-registration',	12	$dbh->do(q{INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES ( 'members', 'OPAC_REG', '', 'New OPAC self-registration submitted', 1, 'New OPAC self-registration',
13	'<h3>New OPAC self-registration</h3>	13	'<h3>New OPAC self-registration</h3>
14	<p><h4>Self-registration made by</h4>	14	<p><h4>Self-registration made:</h4>
15	<ul>	15	<ul>
16	<li><<borrowers.firstname>> <<borrowers.surname>></li>	16	<li>[% borrower.firstname %] [% borrower.surname %]</li>
17	<li>Email: <<borrowers.email>></li>	17	[% IF borrower.cardnumber %]<li>Cardnumber: [% borrower.cardnumber %]</li>[% END %]
18	<li>Phone: <<borrowers.phone>></li>	18	[% IF borrower.email %]<li>Email: [% borrower.email %]</li>[% END %]
19	<li>Mobile: <<borrowers.mobile>></li>	19	[% IF borrower.phone %]<li>Phone: [% borrower.phone %]</li>[% END %]
20	<li>Fax: <<borrowers.fax>></li>	20	[% IF borrower.mobile %]<li>Mobile: [% borrower.mobile %]</li>[% END %]
21	<li>Secondary email: <<borrowers.emailpro>></li>	21	[% IF borrower.fax %]<li>Fax: [% borrower.fax %]</li>[% END %]
22	<li>Secondary phone:<<borrowers.phonepro>></li>	22	[% IF borrower.emailpro %]<li>Secondary email: [% borrower.emailpro %]</li>[% END %]
23	<li>Home library: <<borrowers.branchcode>></li>	23	[% IF borrower.phonepro %]<li>Secondary phone:[% borrower.phonepro %]</li>[% END %]
24	<li>Patron category: <<borrowers.categorycode>></li>	24	[% IF borrower.branchcode %]<li>Home library: [% borrower.branchcode %]</li>[% END %]
		25	[% IF borrower.categorycode %]<li>Patron category: [% borrower.categorycode %]</li>[% END %]
25	</ul>	26	</ul>
26	</p>', 'email', 'default') });	27	</p>', 'email', 'default') });
27	},	28	},

Lines 1646-1661 tables: Link Here

(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-10 / +11 lines)
1646	lang: default	1646	lang: default
1647	content:	1647	content:
1648	- "<h3>New OPAC self-registration</h3>"	1648	- "<h3>New OPAC self-registration</h3>"
1649	- "<p><h4>Self-registration made by</h4>"	1649	- "<p><h4>Self-registration made:</h4>"
1650	- "<ul>"	1650	- "<ul>"
1651	- "<li><<borrowers.firstname>> <<borrowers.surname>></li>"	1651	- "<li> [% borrower.firstname %] [% borrower.surname %]</li>"
1652	- "<li>Email: <<borrowers.email>></li>"	1652	- "[% IF borrower.cardnumber %]<li>Cardnumber: [% borrower.cardnumber %]</li>[% END %]"
1653	- "<li>Phone: <<borrowers.phone>></li>"	1653	- "[% IF borrower.email %]<li>Email: [% borrower.email %]</li>[% END %]"
1654	- "<li>Mobile: <<borrowers.mobile>></li>"	1654	- "[% IF borrower.phone %]<li>Phone: [% borrower.phone %]</li>[% END %]"
1655	- "<li>Fax: <<borrowers.fax>></li>"	1655	- "[% IF borrower.mobile %]<li>Mobile: [% borrower.mobile %]</li>[% END %]"
1656	- "<li>Secondary email: <<borrowers.emailpro>></li>"	1656	- "[% IF borrower.fax %]<li>Fax: [% borrower.fax %]</li>[% END %]"
1657	- "<li>Secondary phone:<<borrowers.phonepro>></li>"	1657	- "[% IF borrower.emailpro %]<li>Secondary email: [% borrower.emailpro %]</li>[% END %]"
1658	- "<li>Home library: <<borrowers.branchcode>></li>"	1658	- "[% IF borrower.phonepro %]<li>Secondary phone: [% borrower.phonepro %]</li>[% END %]"
1659	- "<li>Temporary patron category: <<borrowers.categorycode>></li>"	1659	- "[% IF borrower.branchcode %]<li>Home library: [% borrower.branchcode %]</li>[% END %]"
		1660	- "[% IF borrower.categorycode %]<li>Temporary patron category: [% borrower.categorycode %]</li>[% END %]"
1660	- "</ul>"	1661	- "</ul>"
1661	- "</p>"	1662	- "</p>"

Lines 503-505 INSERT IGNORE INTO letter (module, code, name, title, content, message_transport Link Here

(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (-1 / +16 lines)
503	[% END %]	503	[% END %]
504	[% END %]	504	[% END %]
505	", 'email');	505	", 'email');
506	-	506
		507	INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`) VALUES ( 'members', 'OPAC_REG', '', 'New OPAC self-registration submitted', 1, 'New OPAC self-registration','<h3>New OPAC self-registration</h3>
		508	<p><h4>Self-registration made:</h4>
		509	<ul>
		510	<li>[% borrower.firstname %] [% borrower.surname %]</li>
		511	[% IF borrower.cardnumber %]<li>Cardnumber: [% borrower.cardnumber %]</li>[% END %]
		512	[% IF borrower.email %]<li>Email: [% borrower.email %]</li>[% END %]
		513	[% IF borrower.phone %]<li>Phone: [% borrower.phone %]</li>[% END %]
		514	[% IF borrower.mobile %]<li>Mobile: [% borrower.mobile %]</li>[% END %]
		515	[% IF borrower.fax %]<li>Fax: [% borrower.fax %]</li>[% END %]
		516	[% IF borrower.emailpro %]<li>Secondary email: [% borrower.emailpro %]</li>[% END %]
		517	[% IF borrower.phonepro %]<li>Secondary phone:[% borrower.phonepro %]</li>[% END %]
		518	[% IF borrower.branchcode %]<li>Home library: [% borrower.branchcode %]</li>[% END %]
		519	[% IF borrower.categorycode %]<li>Patron category: [% borrower.categorycode %]</li>[% END %]
		520	</ul>
		521	</p>', 'email', 'default')