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 553-558 tables: Link Here
553
            - "----"
553
            - "----"
554
            - "Thank you."
554
            - "Thank you."
555
555
556
        - module: circulation
557
          code: CHECKIN
558
          branchcode: ""
559
          name: "Item check-in (digest)"
560
          is_html: 0
561
          title: "Check-ins"
562
          message_transport_type: sms
563
          lang: default
564
          content:
565
            - "The following items have been checked in:"
566
            - "----"
567
            - "[% biblio.title %]"
568
            - "----"
569
            - "Thank you."
570
556
        - module: circulation
571
        - module: circulation
557
          code: CHECKOUT
572
          code: CHECKOUT
558
          branchcode: ""
573
          branchcode: ""
Lines 568-573 tables: Link Here
568
            - "----"
583
            - "----"
569
            - "Thank you for visiting [% branch.branchname %]."
584
            - "Thank you for visiting [% branch.branchname %]."
570
585
586
        - module: circulation
587
          code: CHECKOUT
588
          branchcode: ""
589
          name: "Item check-out (digest)"
590
          is_html: 0
591
          title: "Checkouts"
592
          message_transport_type: sms
593
          lang: default
594
          content:
595
            - "The following items have been checked out:"
596
            - "----"
597
            - "[% biblio.title %]"
598
            - "----"
599
            - "Thank you for visiting [% branch.branchname %]."
600
571
        - module: circulation
601
        - module: circulation
572
          code: CHECKOUT_NOTE
602
          code: CHECKOUT_NOTE
573
          branchcode: ""
603
          branchcode: ""
Lines 594-599 tables: Link Here
594
            - ""
624
            - ""
595
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
625
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
596
626
627
        - module: circulation
628
          code: DUE
629
          branchcode: ""
630
          name: "Item due reminder"
631
          is_html: 0
632
          title: "Item due reminder"
633
          message_transport_type: sms
634
          lang: default
635
          content:
636
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
637
            - ""
638
            - "The following item is now due:"
639
            - ""
640
            - "<<biblio.title>>"
641
597
        - module: circulation
642
        - module: circulation
598
          code: DUEDGST
643
          code: DUEDGST
599
          branchcode: ""
644
          branchcode: ""
Lines 611-616 tables: Link Here
611
            - ""
656
            - ""
612
            - "Thank you."
657
            - "Thank you."
613
658
659
        - module: circulation
660
          code: DUEDGST
661
          branchcode: ""
662
          name: "Item due reminder (digest)"
663
          is_html: 0
664
          title: "Item due reminder"
665
          message_transport_type: sms
666
          lang: default
667
          content:
668
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
669
            - ""
670
            - "You have <<count>> item(s) that are now due"
671
            - ""
672
            - "Thank you."
673
614
        - module: circulation
674
        - module: circulation
615
          code: HOLD_SLIP
675
          code: HOLD_SLIP
616
          branchcode: ""
676
          branchcode: ""
Lines 778-783 tables: Link Here
778
            - ""
838
            - ""
779
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
839
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
780
840
841
        - module: circulation
842
          code: PREDUE
843
          branchcode: ""
844
          name: "Advance notice of item due"
845
          is_html: 0
846
          title: "Advance notice of item due"
847
          message_transport_type: sms
848
          lang: default
849
          content:
850
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
851
            - ""
852
            - "The following item will be due soon:"
853
            - ""
854
            - "<<biblio.title>>"
855
781
        - module: circulation
856
        - module: circulation
782
          code: PREDUEDGST
857
          code: PREDUEDGST
783
          branchcode: ""
858
          branchcode: ""
Lines 795-800 tables: Link Here
795
            - ""
870
            - ""
796
            - "Thank you."
871
            - "Thank you."
797
872
873
        - module: circulation
874
          code: PREDUEDGST
875
          branchcode: ""
876
          name: "Advance notice of item due (digest)"
877
          is_html: 0
878
          title: "Advance notice of item due"
879
          message_transport_type: sms
880
          lang: default
881
          content:
882
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
883
            - ""
884
            - "You have <<count>> item(s) that will be due soon."
885
            - ""
886
            - "Thank you."
887
798
        - module: circulation
888
        - module: circulation
799
          code: RENEWAL
889
          code: RENEWAL
800
          branchcode: ""
890
          branchcode: ""
Lines 1681-1686 tables: Link Here
1681
            - "<<branches.branchaddress3>>"
1771
            - "<<branches.branchaddress3>>"
1682
            - "<<branches.branchcity>> <<branches.branchzip>>"
1772
            - "<<branches.branchcity>> <<branches.branchzip>>"
1683
1773
1774
        - module: reserves
1775
          code: HOLD
1776
          branchcode: ""
1777
          name: "Hold available for pickup"
1778
          is_html: 0
1779
          title: "Hold available for pickup at <<branches.branchname>>"
1780
          message_transport_type: sms
1781
          lang: default
1782
          content:
1783
            - "Dear <<borrowers.firstname>> <<borrowers.surname>>,"
1784
            - ""
1785
            - "Your hold for <<biblio.title>> is available for pickup."
1786
1684
        - module: reserves
1787
        - module: reserves
1685
          code: HOLD
1788
          code: HOLD
1686
          branchcode: ""
1789
          branchcode: ""
1687
- 

Return to bug 30555