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

(-)a/installer/data/mysql/atomicupdate/bug_30555-add_sample_notice_sms.pl (+22 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "30555",
5
    description => "Add more sample notice for sms messages",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
            INSERT IGNORE INTO letter
11
            (module,code,branchcode,name,is_html,title,content,message_transport_type,lang)
12
            VALUES
13
            ('circulation','CHECKIN','','Item check-in (digest)',0,'Check-ins','The following items have been checked in:\r\n----\r\n[% biblio.title %]\r\n----\r\nThank you.','sms','default'),
14
            ('circulation','CHECKOUT','','Item check-out (digest)',0,'Checkouts','The following items have been checked out:\r\n----\r\n[% biblio.title %]\r\n----\r\nThank you for visiting [% branch.branchname %].','sms','default'),
15
            ('circulation','DUE','','Item due reminder',0,'Item due reminder','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item is now due:\r\n\r\n<<biblio.title>>','sms','default'),
16
            ('circulation','DUEDGST','','Item due reminder (digest)',0,'Item due reminder','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYou have <<count>> item(s) that are now due\r\n\r\nThank you.','sms','default'),
17
            ('circulation','PREDUE','','Advance notice of item due',0,'Advance notice of item due','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item will be due soon:\r\n\r\n<<biblio.title>>','sms','default'),
18
            ('circulation','PREDUEDGST','','Advance notice of item due (digest)',0,'Advance notice of item due','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYou have <<count>> item(s) that will be due soon.\r\n\r\nThank you.','sms','default'),
19
            ('reserves','HOLD','','Hold available for pickup',0,'Hold available for pickup at <<branches.branchname>>','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYour hold for <<biblio.title>> is available for pickup.','sms','default')
20
        });
21
    },
22
};
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-1 / +103 lines)
Lines 402-407 tables: Link Here
402
            - "----"
402
            - "----"
403
            - "Thank you."
403
            - "Thank you."
404
404
405
        - module: circulation
406
          code: CHECKIN
407
          branchcode: ""
408
          name: "Item check-in (digest)"
409
          is_html: 0
410
          title: "Check-ins"
411
          message_transport_type: sms
412
          lang: default
413
          content:
414
            - "The following items have been checked in:"
415
            - "----"
416
            - "[% biblio.title %]"
417
            - "----"
418
            - "Thank you."
419
405
        - module: circulation
420
        - module: circulation
406
          code: CHECKOUT
421
          code: CHECKOUT
407
          branchcode: ""
422
          branchcode: ""
Lines 417-422 tables: Link Here
417
            - "----"
432
            - "----"
418
            - "Thank you for visiting [% branch.branchname %]."
433
            - "Thank you for visiting [% branch.branchname %]."
419
434
435
        - module: circulation
436
          code: CHECKOUT
437
          branchcode: ""
438
          name: "Item check-out (digest)"
439
          is_html: 0
440
          title: "Checkouts"
441
          message_transport_type: sms
442
          lang: default
443
          content:
444
            - "The following items have been checked out:"
445
            - "----"
446
            - "[% biblio.title %]"
447
            - "----"
448
            - "Thank you for visiting [% branch.branchname %]."
449
420
        - module: circulation
450
        - module: circulation
421
          code: CHECKOUT_NOTE
451
          code: CHECKOUT_NOTE
422
          branchcode: ""
452
          branchcode: ""
Lines 443-448 tables: Link Here
443
            - ""
473
            - ""
444
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
474
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
445
475
476
        - module: circulation
477
          code: DUE
478
          branchcode: ""
479
          name: "Item due reminder"
480
          is_html: 0
481
          title: "Item due reminder"
482
          message_transport_type: sms
483
          lang: default
484
          content:
485
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
486
            - ""
487
            - "The following item is now due:"
488
            - ""
489
            - "<<biblio.title>>"
490
446
        - module: circulation
491
        - module: circulation
447
          code: DUEDGST
492
          code: DUEDGST
448
          branchcode: ""
493
          branchcode: ""
Lines 460-465 tables: Link Here
460
            - ""
505
            - ""
461
            - "Thank you."
506
            - "Thank you."
462
507
508
        - module: circulation
509
          code: DUEDGST
510
          branchcode: ""
511
          name: "Item due reminder (digest)"
512
          is_html: 0
513
          title: "Item due reminder"
514
          message_transport_type: sms
515
          lang: default
516
          content:
517
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
518
            - ""
519
            - "You have <<count>> item(s) that are now due"
520
            - ""
521
            - "Thank you."
522
463
        - module: circulation
523
        - module: circulation
464
          code: HOLD_SLIP
524
          code: HOLD_SLIP
465
          branchcode: ""
525
          branchcode: ""
Lines 627-632 tables: Link Here
627
            - ""
687
            - ""
628
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
688
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
629
689
690
        - module: circulation
691
          code: PREDUE
692
          branchcode: ""
693
          name: "Advance notice of item due"
694
          is_html: 0
695
          title: "Advance notice of item due"
696
          message_transport_type: sms
697
          lang: default
698
          content:
699
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
700
            - ""
701
            - "The following item will be due soon:"
702
            - ""
703
            - "<<biblio.title>>"
704
630
        - module: circulation
705
        - module: circulation
631
          code: PREDUEDGST
706
          code: PREDUEDGST
632
          branchcode: ""
707
          branchcode: ""
Lines 644-649 tables: Link Here
644
            - ""
719
            - ""
645
            - "Thank you."
720
            - "Thank you."
646
721
722
        - module: circulation
723
          code: PREDUEDGST
724
          branchcode: ""
725
          name: "Advance notice of item due (digest)"
726
          is_html: 0
727
          title: "Advance notice of item due"
728
          message_transport_type: sms
729
          lang: default
730
          content:
731
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
732
            - ""
733
            - "You have <<count>> item(s) that will be due soon."
734
            - ""
735
            - "Thank you."
736
647
        - module: circulation
737
        - module: circulation
648
          code: RENEWAL
738
          code: RENEWAL
649
          branchcode: ""
739
          branchcode: ""
Lines 1265-1270 tables: Link Here
1265
            - "<<branches.branchaddress3>>"
1355
            - "<<branches.branchaddress3>>"
1266
            - "<<branches.branchcity>> <<branches.branchzip>>"
1356
            - "<<branches.branchcity>> <<branches.branchzip>>"
1267
1357
1358
        - module: reserves
1359
          code: HOLD
1360
          branchcode: ""
1361
          name: "Hold available for pickup"
1362
          is_html: 0
1363
          title: "Hold available for pickup at <<branches.branchname>>"
1364
          message_transport_type: sms
1365
          lang: default
1366
          content:
1367
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
1368
            - ""
1369
            - "Your hold for <<biblio.title>> is available for pickup."
1370
1268
        - module: reserves
1371
        - module: reserves
1269
          code: HOLD
1372
          code: HOLD
1270
          branchcode: ""
1373
          branchcode: ""
1271
- 

Return to bug 30555