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','Hi <<borrowers.firstname>> <<borrowers.surname>>,\r\nThe 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','Hi <<borrowers.firstname>> <<borrowers.surname>>,\r\nThe following items have been checked out:\r\n----\r\n[% biblio.title %]\r\n----\r\nThank you.','sms','default'),
15
            ('circulation','DUE','','Item due reminder',0,'Item due reminder','Hi,\r\nThe following item(s) are now due:\r\n<<biblio.title>>','sms','default'),
16
            ('circulation','DUEDGST','','Item due reminder (digest)',0,'Item due reminder','Hi\r\nYou have <<count>> item(s) that are now due','sms','default'),
17
            ('circulation','PREDUE','','Advance notice of item due',0,'Advance notice of item due','Hi\r\nThe following item will be due soon:\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)','sms','default'),
18
            ('circulation','PREDUEDGST','','Advance notice of item due (digest)',0,'Advance notice of item due','Hi\r\nYou have <<count>> item(s) that will be due soon.','sms','default'),
19
            ('reserves','HOLD','','Hold available for pickup',0,'Hold available for pickup at <<branches.branchname>>','Hi\r\nYour hold for <<biblio.title>> is available for pickup as of <<reserves.waitingdate>>','sms','default')
20
        });
21
    },
22
};
(-)a/installer/data/mysql/en/mandatory/sample_notices.yml (-1 / +94 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
            - "Hi <<borrowers.firstname>> <<borrowers.surname>>,"
415
            - "The following items have been checked in:"
416
            - "----"
417
            - "[% biblio.title %]"
418
            - "----"
419
            - "Thank you."
420
405
        - module: circulation
421
        - module: circulation
406
          code: CHECKOUT
422
          code: CHECKOUT
407
          branchcode: ""
423
          branchcode: ""
Lines 417-422 tables: Link Here
417
            - "----"
433
            - "----"
418
            - "Thank you for visiting [% branch.branchname %]."
434
            - "Thank you for visiting [% branch.branchname %]."
419
435
436
        - module: circulation
437
          code: CHECKOUT
438
          branchcode: ""
439
          name: "Item check-out (digest)"
440
          is_html: 0
441
          title: "Checkouts"
442
          message_transport_type: sms
443
          lang: default
444
          content:
445
            - "Hi <<borrowers.firstname>> <<borrowers.surname>>,"
446
            - "The following items have been checked out:"
447
            - "----"
448
            - "[% biblio.title %]"
449
            - "----"
450
            - "Thank you."
451
420
        - module: circulation
452
        - module: circulation
421
          code: CHECKOUT_NOTE
453
          code: CHECKOUT_NOTE
422
          branchcode: ""
454
          branchcode: ""
Lines 443-448 tables: Link Here
443
            - ""
475
            - ""
444
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
476
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
445
477
478
        - module: circulation
479
          code: DUE
480
          branchcode: ""
481
          name: "Item due reminder"
482
          is_html: 0
483
          title: "Item due reminder"
484
          message_transport_type: sms
485
          lang: default
486
          content:
487
            - "Hi,"
488
            - "The following item(s) are now due:"
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
            - "Hi"
518
            - "You have <<count>> item(s) that are now due"
519
463
        - module: circulation
520
        - module: circulation
464
          code: HOLD_SLIP
521
          code: HOLD_SLIP
465
          branchcode: ""
522
          branchcode: ""
Lines 627-632 tables: Link Here
627
            - ""
684
            - ""
628
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
685
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
629
686
687
        - module: circulation
688
          code: PREDUE
689
          branchcode: ""
690
          name: "Advance notice of item due"
691
          is_html: 0
692
          title: "Advance notice of item due"
693
          message_transport_type: sms
694
          lang: default
695
          content:
696
            - "Hi"
697
            - "The following item will be due soon:"
698
            - "<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)"
699
630
        - module: circulation
700
        - module: circulation
631
          code: PREDUEDGST
701
          code: PREDUEDGST
632
          branchcode: ""
702
          branchcode: ""
Lines 644-649 tables: Link Here
644
            - ""
714
            - ""
645
            - "Thank you."
715
            - "Thank you."
646
716
717
        - module: circulation
718
          code: PREDUEDGST
719
          branchcode: ""
720
          name: "Advance notice of item due (digest)"
721
          is_html: 0
722
          title: "Advance notice of item due"
723
          message_transport_type: sms
724
          lang: default
725
          content:
726
            - "Hi"
727
            - "You have <<count>> item(s) that will be due soon."
728
647
        - module: circulation
729
        - module: circulation
648
          code: RENEWAL
730
          code: RENEWAL
649
          branchcode: ""
731
          branchcode: ""
Lines 1265-1270 tables: Link Here
1265
            - "<<branches.branchaddress3>>"
1347
            - "<<branches.branchaddress3>>"
1266
            - "<<branches.branchcity>> <<branches.branchzip>>"
1348
            - "<<branches.branchcity>> <<branches.branchzip>>"
1267
1349
1350
        - module: reserves
1351
          code: HOLD
1352
          branchcode: ""
1353
          name: "Hold available for pickup"
1354
          is_html: 0
1355
          title: "Hold available for pickup at <<branches.branchname>>"
1356
          message_transport_type: sms
1357
          lang: default
1358
          content:
1359
            - "Hi"
1360
            - "Your hold for <<biblio.title>> is available for pickup as of <<reserves.waitingdate>>"
1361
1268
        - module: reserves
1362
        - module: reserves
1269
          code: HOLD
1363
          code: HOLD
1270
          branchcode: ""
1364
          branchcode: ""
1271
- 

Return to bug 30555