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

(-)a/installer/data/mysql/atomicupdate/bug_25090-add_STAFF_VER_OPAC_REG_and_SELF_REG_APPROVED_notices.perl (+51 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
5
<p><h4>Submitted Opac patron self registration:<h4>
6
    <ul>
7
    <li><<borrower_modifications.cardnumber>></li>
8
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
9
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
10
    <li>Email: <<borrower_modifications.email>></li>
11
    <li>Phone: <<borrower_modifications.phone>></li>
12
    <li>Mobile: <<borrower_modifications.mobile>></li>
13
    <li>Fax: <<borrower_modifications.fax>></li>
14
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
15
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
16
    <li>Home library: <<borrower_modifications.branchcode>></li>
17
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
18
    </ul>
19
    </p>
20
    <p>
21
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
22
    </p>
23
    <p>
24
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
25
    </p>
26
    <p>
27
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
28
    </p>
29
    </p>', 1, 'email')
30
    });
31
32
    $dbh->do(q{
33
        INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
34
    <p>Before we can create your library account two things need to happen:
35
    <br>1. You verify your email address - To do this please click this link:<br>
36
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
37
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
38
    </p>
39
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email')
40
    });
41
42
    $dbh->do(q{
43
        INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
44
    <p>
45
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
46
    </p>', 1, 'email')
47
    });
48
49
    SetVersion( $DBversion );
50
    print "Upgrade to $DBversion done (Bug 25090 - Choose to send OPAC self registration verification emails to the library and/or patron allowing libraries to moderate which registrations get Koha accounts)\n";
51
}
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (+35 lines)
Lines 407-409 Your total unpaid fines are too high. Link Here
407
[% ELSE %]
407
[% ELSE %]
408
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
408
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
409
[% END %]", 'email');
409
[% END %]", 'email');
410
411
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
412
<p><h4>Submitted Opac patron self registration:<h4>
413
    <ul>
414
    <li><<borrower_modifications.cardnumber>></li>
415
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
416
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
417
    <li>Email: <<borrower_modifications.email>></li>
418
    <li>Phone: <<borrower_modifications.phone>></li>
419
    <li>Mobile: <<borrower_modifications.mobile>></li>
420
    <li>Fax: <<borrower_modifications.fax>></li>
421
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
422
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
423
    <li>Home library: <<borrower_modifications.branchcode>></li>
424
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
425
    </ul>
426
    </p>
427
    <p>
428
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
429
    <p>
430
    <p>
431
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
432
    </p>
433
    <p>
434
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
435
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
436
    <p>Before we can create your library account two things need to happen:
437
    <br>1. You verify your email address - To do this please click this link:<br>
438
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
439
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
440
    </p>
441
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
442
    <p>
443
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
444
    </p>', 1, 'email');
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (+65 lines)
Lines 734-739 tables: Link Here
734
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
734
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
735
            - ""
735
            - ""
736
            - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
736
            - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
737
        - module: members
738
          code: PATRON_AND_LIB_VER
739
          branchcode: ""
740
          name: "Opac Self-Registration Verify Your Email"
741
          is_html: 1
742
          title: "Verify your entered OPAC Self registration email address"
743
          message_transport_type: email
744
          lang: default
745
          content:
746
            - "Hello!"
747
            - ""
748
            - "<p>Before we can create your library account two things need to happen:"
749
            - "<br>1. You verify your email address - To do this please click this link:<br>"
750
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>"
751
            - "<br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password."
752
            - "</p>"
753
            - "<p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>"
754
755
        - module: members
756
          code: STAFF_VER_OPAC_REG
757
          branchode: ""
758
          name: "New patron Opac Self-Registration to verify"
759
          is_html: 1
760
          title: "Verify new Opac patron self registration"
761
          message_transport_type: email
762
          lang: default
763
          content:
764
              - "<h3>Opac self registration pending verification</h3>"
765
              - "<p><h4>Submitted Opac patron self registration:<h4>"
766
              - "<ul>"
767
              - "<li><<borrower_modifications.cardnumber>></li>"
768
              - "<li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>"
769
              - "<li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>"
770
              - "<li>Email: <<borrower_modifications.email>></li>"
771
              - "<li>Phone: <<borrower_modifications.phone>></li>"
772
              - "<li>Mobile: <<borrower_modifications.mobile>></li>"
773
              - "<li>Fax: <<borrower_modifications.fax>></li>"
774
              - "<li>Secondary email: <<borrower_modifications.emailpro>></li>"
775
              - "<li>Secondary phone:<<borrower_modifications.phonepro>></li>"
776
              - "<li>Home library: <<borrower_modifications.branchcode>></li>"
777
              - "<li>Temporary patron category: <<borrower_modifications.categorycode>></li>"
778
              - "</ul>"
779
              - "</p>"
780
              - "<p>"
781
              - "If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:"
782
              - "<p>"
783
              - "<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1"
784
              - "</p>"
785
              - "If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly."
786
              - "</p>"
787
788
        - module: members
789
          code: SELF_REG_APPROVED
790
          branchcode: ""
791
          name: "Self registration approved"
792
          is_html: 1
793
          title: "Your self registration has been approved"
794
          message_transport_type: email
795
          lang: default
796
          content:
797
            - "<html>"
798
            - "<h3>Please click the password reset link below to reset your Koha password then you'll be able to login to the OPAC:</h3>"
799
            - "<p>"
800
            - "<<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>"
801
            - "</p>"
737
802
738
        - module: members
803
        - module: members
739
          code: PASSWORD_RESET
804
          code: PASSWORD_RESET
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+35 lines)
Lines 289-291 Your total unpaid fines are too high. Link Here
289
[% ELSE %]
289
[% ELSE %]
290
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
290
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
291
[% END %]", 'email');
291
[% END %]", 'email');
292
293
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
294
<p><h4>Submitted Opac patron self registration:<h4>
295
    <ul>
296
    <li><<borrower_modifications.cardnumber>></li>
297
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
298
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
299
    <li>Email: <<borrower_modifications.email>></li>
300
    <li>Phone: <<borrower_modifications.phone>></li>
301
    <li>Mobile: <<borrower_modifications.mobile>></li>
302
    <li>Fax: <<borrower_modifications.fax>></li>
303
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
304
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
305
    <li>Home library: <<borrower_modifications.branchcode>></li>
306
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
307
    </ul>
308
    </p>
309
    <p>
310
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
311
    <p>
312
    <p>
313
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
314
    </p>
315
    <p>
316
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
317
    </s>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
318
    <p>Before we can create your library account two things need to happen:
319
    <br>1. You verify your email address - To do this please click this link:<br>
320
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
321
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
322
    </p>
323
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
324
    <p>
325
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
326
    </p>', 1, 'email');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+35 lines)
Lines 400-402 Your total unpaid fines are too high. Link Here
400
[% ELSE %]
400
[% ELSE %]
401
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
401
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
402
[% END %]", 'email');
402
[% END %]", 'email');
403
404
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
405
<p><h4>Submitted Opac patron self registration:<h4>
406
    <ul>
407
    <li><<borrower_modifications.cardnumber>></li>
408
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
409
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
410
    <li>Email: <<borrower_modifications.email>></li>
411
    <li>Phone: <<borrower_modifications.phone>></li>
412
    <li>Mobile: <<borrower_modifications.mobile>></li>
413
    <li>Fax: <<borrower_modifications.fax>></li>
414
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
415
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
416
    <li>Home library: <<borrower_modifications.branchcode>></li>
417
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
418
    </ul>
419
    </p>
420
    <p>
421
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
422
    <p>
423
    <p>
424
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
425
    </p>
426
    <p>
427
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
428
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
429
    <p>Before we can create your library account two things need to happen:
430
    <br>1. You verify your email address - To do this please click this link:<br>
431
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
432
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
433
    </p>
434
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
435
    <p>
436
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
437
    </p>', 1, 'email');
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+35 lines)
Lines 403-405 Your total unpaid fines are too high. Link Here
403
[% ELSE %]
403
[% ELSE %]
404
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
404
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
405
[% END %]", 'email');
405
[% END %]", 'email');
406
407
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
408
<p><h4>Submitted Opac patron self registration:<h4>
409
    <ul>
410
    <li><<borrower_modifications.cardnumber>></li>
411
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
412
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
413
    <li>Email: <<borrower_modifications.email>></li>
414
    <li>Phone: <<borrower_modifications.phone>></li>
415
    <li>Mobile: <<borrower_modifications.mobile>></li>
416
    <li>Fax: <<borrower_modifications.fax>></li>
417
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
418
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
419
    <li>Home library: <<borrower_modifications.branchcode>></li>
420
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
421
    </ul>
422
    </p>
423
    <p>
424
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
425
    <p>
426
    <p>
427
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
428
    </p>
429
    <p>
430
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
431
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
432
    <p>Before we can create your library account two things need to happen:
433
    <br>1. You verify your email address - To do this please click this link:<br>
434
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
435
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
436
    </p>
437
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
438
    <p>
439
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
440
    </p>', 1, 'email');
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+35 lines)
Lines 419-421 Your total unpaid fines are too high. Link Here
419
[% ELSE %]
419
[% ELSE %]
420
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
420
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
421
[% END %]", 'email');
421
[% END %]", 'email');
422
423
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
424
<p><h4>Submitted Opac patron self registration:<h4>
425
    <ul>
426
    <li><<borrower_modifications.cardnumber>></li>
427
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
428
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
429
    <li>Email: <<borrower_modifications.email>></li>
430
    <li>Phone: <<borrower_modifications.phone>></li>
431
    <li>Mobile: <<borrower_modifications.mobile>></li>
432
    <li>Fax: <<borrower_modifications.fax>></li>
433
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
434
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
435
    <li>Home library: <<borrower_modifications.branchcode>></li>
436
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
437
    </ul>
438
    </p>
439
    <p>
440
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
441
    <p>
442
    <p>
443
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
444
    </p>
445
    <p>
446
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
447
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
448
    <p>Before we can create your library account two things need to happen:
449
    <br>1. You verify your email address - To do this please click this link:<br>
450
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
451
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
452
    </p>
453
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
454
    <p>
455
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
456
    </p>', 1, 'email');
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+35 lines)
Lines 397-399 Your total unpaid fines are too high. Link Here
397
[% ELSE %]
397
[% ELSE %]
398
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
398
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
399
[% END %]", 'email');
399
[% END %]", 'email');
400
401
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
402
<p><h4>Submitted Opac patron self registration:<h4>
403
    <ul>
404
    <li><<borrower_modifications.cardnumber>></li>
405
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
406
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
407
    <li>Email: <<borrower_modifications.email>></li>
408
    <li>Phone: <<borrower_modifications.phone>></li>
409
    <li>Mobile: <<borrower_modifications.mobile>></li>
410
    <li>Fax: <<borrower_modifications.fax>></li>
411
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
412
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
413
    <li>Home library: <<borrower_modifications.branchcode>></li>
414
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
415
    </ul>
416
    </p>
417
    <p>
418
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
419
    <p>
420
    <p>
421
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
422
    </p>
423
    <p>
424
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
425
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
426
    <p>Before we can create your library account two things need to happen:
427
    <br>1. You verify your email address - To do this please click this link:<br>
428
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
429
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
430
    </p>
431
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
432
    <p>
433
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
434
    </p>', 1, 'email');
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+35 lines)
Lines 399-401 Your total unpaid fines are too high. Link Here
399
[% ELSE %]
399
[% ELSE %]
400
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
400
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
401
[% END %]", 'email');
401
[% END %]", 'email');
402
403
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
404
<p><h4>Submitted Opac patron self registration:<h4>
405
    <ul>
406
    <li><<borrower_modifications.cardnumber>></li>
407
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
408
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
409
    <li>Email: <<borrower_modifications.email>></li>
410
    <li>Phone: <<borrower_modifications.phone>></li>
411
    <li>Mobile: <<borrower_modifications.mobile>></li>
412
    <li>Fax: <<borrower_modifications.fax>></li>
413
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
414
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
415
    <li>Home library: <<borrower_modifications.branchcode>></li>
416
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
417
    </ul>
418
    </p>
419
    <p>
420
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
421
    <p>
422
    <p>
423
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
424
    </p>
425
    <p>
426
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
427
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
428
    <p>Before we can create your library account two things need to happen:
429
    <br>1. You verify your email address - To do this please click this link:<br>
430
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
431
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
432
    </p>
433
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
434
    <p>
435
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
436
    </p>', 1, 'email');
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +35 lines)
Lines 490-492 Your total unpaid fines are too high. Link Here
490
[% ELSE %]
490
[% ELSE %]
491
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
491
The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due | $KohaDates as_due_date => 1 %]
492
[% END %]", 'email');
492
[% END %]", 'email');
493
- 
493
494
INSERT IGNORE INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES ('members', 'STAFF_VER_OPAC_REG', 'New patron Opac Self-Registration to verify', 'Verify new Opac patron self registration', '<h3>Opac self registration pending verification</h3>
495
<p><h4>Submitted Opac patron self registration:<h4>
496
    <ul>
497
    <li><<borrower_modifications.cardnumber>></li>
498
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
499
    <li>Physical address: <<borrower_modifications.streetnumber>> <<borrower_modifications.streettype>> <<borrower_modifications.address>> <<borrower_modifications.address2>>, <<borrower_modifications.city>>, <<borrower_modifications.state>> <<borrower_modifications.zipcode>>, <<borrower_modifications.country>></li>
500
    <li>Email: <<borrower_modifications.email>></li>
501
    <li>Phone: <<borrower_modifications.phone>></li>
502
    <li>Mobile: <<borrower_modifications.mobile>></li>
503
    <li>Fax: <<borrower_modifications.fax>></li>
504
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
505
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
506
    <li>Home library: <<borrower_modifications.branchcode>></li>
507
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
508
    </ul>
509
    </p>
510
    <p>
511
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
512
    <p>
513
    <p>
514
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
515
    </p>
516
    <p>
517
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
518
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
519
    <p>Before we can create your library account two things need to happen:
520
    <br>1. You verify your email address - To do this please click this link:<br>
521
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
522
    <br>2. A librarian will review your registration and if approved you will receive an email containing a link to the Koha password reset page where you can set a Koha password.
523
    </p>
524
    <p>If you did not initiate this request, you may safely ignore this one-time message the request will expire shortly.</p>', 1, 'email'), ('members', 'SELF_REG_APPROVED', 'Self registration approved', 'Your self registration has been approved', '<h3>Please click the password reset link below to reset your Koha password then you will be able to login to the OPAC:</h3>
525
    <p>
526
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
527
    </p>', 1, 'email');

Return to bug 25090