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/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 291-293 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here
291
[% END %]", 'email');
291
[% END %]", 'email');
292
292
293
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
293
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
294
295
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>
296
<p><h4>Submitted Opac patron self registration:<h4>
297
    <ul>
298
    <li><<borrower_modifications.cardnumber>></li>
299
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
300
    <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>
301
    <li>Email: <<borrower_modifications.email>></li>
302
    <li>Phone: <<borrower_modifications.phone>></li>
303
    <li>Mobile: <<borrower_modifications.mobile>></li>
304
    <li>Fax: <<borrower_modifications.fax>></li>
305
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
306
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
307
    <li>Home library: <<borrower_modifications.branchcode>></li>
308
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
309
    </ul>
310
    </p>
311
    <p>
312
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
313
    <p>
314
    <p>
315
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
316
    </p>
317
    <p>
318
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
319
    </s>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
320
    <p>Before we can create your library account two things need to happen:
321
    <br>1. You verify your email address - To do this please click this link:<br>
322
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
323
    <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.
324
    </p>
325
    <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>
326
    <p>
327
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
328
    </p>', 1, 'email');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+35 lines)
Lines 402-404 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here
402
[% END %]", 'email');
402
[% END %]", 'email');
403
403
404
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
404
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
405
406
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>
407
<p><h4>Submitted Opac patron self registration:<h4>
408
    <ul>
409
    <li><<borrower_modifications.cardnumber>></li>
410
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
411
    <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>
412
    <li>Email: <<borrower_modifications.email>></li>
413
    <li>Phone: <<borrower_modifications.phone>></li>
414
    <li>Mobile: <<borrower_modifications.mobile>></li>
415
    <li>Fax: <<borrower_modifications.fax>></li>
416
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
417
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
418
    <li>Home library: <<borrower_modifications.branchcode>></li>
419
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
420
    </ul>
421
    </p>
422
    <p>
423
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
424
    <p>
425
    <p>
426
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
427
    </p>
428
    <p>
429
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
430
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
431
    <p>Before we can create your library account two things need to happen:
432
    <br>1. You verify your email address - To do this please click this link:<br>
433
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
434
    <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.
435
    </p>
436
    <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>
437
    <p>
438
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
439
    </p>', 1, 'email');
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+35 lines)
Lines 405-407 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here
405
[% END %]", 'email');
405
[% END %]", 'email');
406
406
407
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
407
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
408
409
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>
410
<p><h4>Submitted Opac patron self registration:<h4>
411
    <ul>
412
    <li><<borrower_modifications.cardnumber>></li>
413
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
414
    <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>
415
    <li>Email: <<borrower_modifications.email>></li>
416
    <li>Phone: <<borrower_modifications.phone>></li>
417
    <li>Mobile: <<borrower_modifications.mobile>></li>
418
    <li>Fax: <<borrower_modifications.fax>></li>
419
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
420
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
421
    <li>Home library: <<borrower_modifications.branchcode>></li>
422
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
423
    </ul>
424
    </p>
425
    <p>
426
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
427
    <p>
428
    <p>
429
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
430
    </p>
431
    <p>
432
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
433
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
434
    <p>Before we can create your library account two things need to happen:
435
    <br>1. You verify your email address - To do this please click this link:<br>
436
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
437
    <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.
438
    </p>
439
    <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>
440
    <p>
441
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
442
    </p>', 1, 'email');
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+35 lines)
Lines 420-422 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here
420
[% END %]", 'email');
420
[% END %]", 'email');
421
421
422
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
422
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
423
424
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>
425
<p><h4>Submitted Opac patron self registration:<h4>
426
    <ul>
427
    <li><<borrower_modifications.cardnumber>></li>
428
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
429
    <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>
430
    <li>Email: <<borrower_modifications.email>></li>
431
    <li>Phone: <<borrower_modifications.phone>></li>
432
    <li>Mobile: <<borrower_modifications.mobile>></li>
433
    <li>Fax: <<borrower_modifications.fax>></li>
434
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
435
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
436
    <li>Home library: <<borrower_modifications.branchcode>></li>
437
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
438
    </ul>
439
    </p>
440
    <p>
441
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
442
    <p>
443
    <p>
444
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
445
    </p>
446
    <p>
447
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
448
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
449
    <p>Before we can create your library account two things need to happen:
450
    <br>1. You verify your email address - To do this please click this link:<br>
451
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
452
    <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.
453
    </p>
454
    <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>
455
    <p>
456
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
457
    </p>', 1, 'email');
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+35 lines)
Lines 399-401 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here
399
[% END %]", 'email');
399
[% END %]", 'email');
400
400
401
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
401
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
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/ru-RU/mandatory/sample_notices.sql (+35 lines)
Lines 401-403 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here
401
[% END %]", 'email');
401
[% END %]", 'email');
402
402
403
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
403
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
404
405
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>
406
<p><h4>Submitted Opac patron self registration:<h4>
407
    <ul>
408
    <li><<borrower_modifications.cardnumber>></li>
409
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
410
    <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>
411
    <li>Email: <<borrower_modifications.email>></li>
412
    <li>Phone: <<borrower_modifications.phone>></li>
413
    <li>Mobile: <<borrower_modifications.mobile>></li>
414
    <li>Fax: <<borrower_modifications.fax>></li>
415
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
416
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
417
    <li>Home library: <<borrower_modifications.branchcode>></li>
418
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
419
    </ul>
420
    </p>
421
    <p>
422
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
423
    <p>
424
    <p>
425
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
426
    </p>
427
    <p>
428
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
429
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
430
    <p>Before we can create your library account two things need to happen:
431
    <br>1. You verify your email address - To do this please click this link:<br>
432
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
433
    <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.
434
    </p>
435
    <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>
436
    <p>
437
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
438
    </p>', 1, 'email');
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +35 lines)
Lines 492-494 The following item, [% biblio.title %], has correctly been renewed and is now du Link Here
492
[% END %]", 'email');
492
[% END %]", 'email');
493
493
494
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
494
INSERT INTO `letter` VALUES ('reserves','HOLD_CANCELLATION','','Hold Cancellation',0,'Your hold was canceled.','[%- USE AuthorisedValues -%]\r\nDear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nYour hold for [% biblio.title %] was canceled for the following reason: [% AuthorisedValues.GetByCode( \'HOLD_CANCELLATION\', hold.cancellation_reason ) %]','email','default');
495
- 
495
496
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>
497
<p><h4>Submitted Opac patron self registration:<h4>
498
    <ul>
499
    <li><<borrower_modifications.cardnumber>></li>
500
    <li><<borrower_modifications.title>> <<borrower_modifications.firstname>> <<borrower_modifications.surname>></li>
501
    <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>
502
    <li>Email: <<borrower_modifications.email>></li>
503
    <li>Phone: <<borrower_modifications.phone>></li>
504
    <li>Mobile: <<borrower_modifications.mobile>></li>
505
    <li>Fax: <<borrower_modifications.fax>></li>
506
    <li>Secondary email: <<borrower_modifications.emailpro>></li>
507
    <li>Secondary phone:<<borrower_modifications.phonepro>></li>
508
    <li>Home library: <<borrower_modifications.branchcode>></li>
509
    <li>Temporary patron category: <<borrower_modifications.categorycode>></li>
510
    </ul>
511
    </p>
512
    <p>
513
    If you wish to create a Koha patron account thereby giving this patron Opac access please click on this verification link:
514
    <p>
515
    <p>
516
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>&approved=1
517
    </p>
518
    <p>
519
    If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.
520
    </p>', 1, 'email'), ('members', 'PATRON_AND_LIB_VER', 'Opac Self-Registration Verify Your Email', 'Verify your entered OPAC Self registration email address', 'Hello!
521
    <p>Before we can create your library account two things need to happen:
522
    <br>1. You verify your email address - To do this please click this link:<br>
523
    <<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
524
    <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.
525
    </p>
526
    <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>
527
    <p>
528
    <<OPACBaseURL>>/cgi-bin/koha/opac-password-recovery.pl?borrowernumber=<<borrowers.borrowernumber>>
529
    </p>', 1, 'email');

Return to bug 25090