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

(-)a/installer/data/mysql/en/mandatory/sample_numberpatterns.sql (-25 lines)
Lines 1-25 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No. {X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol. {X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol. {X}, No. {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/en/mandatory/sample_numberpatterns.txt (-1 lines)
Line 1 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/en/mandatory/sample_numberpatterns.yml (-1 / +119 lines)
Line 0 Link Here
0
- 
1
---
2
#
3
#  Copyright 2020 Koha Development Team
4
#
5
#  This file is part of Koha.
6
#
7
#  Koha is free software; you can redistribute it and/or modify it under the
8
#  terms of the GNU General Public License as published by the Free Software
9
#  Foundation; either version 2 of the License, or (at your option) any later
10
#  version.
11
#
12
#  Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13
#  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14
#  A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
15
#
16
#  You should have received a copy of the GNU General Public License along
17
#  with Koha; if not, write to the Free Software Foundation, Inc.,
18
#  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19
#
20
21
description:
22
  - "Sample numbering patterns for subscriptions"
23
24
tables:
25
  - subscription_numberpatterns:
26
      translatable: [ label, description, numberingmethod, label1, label2, label3 ]
27
      multiline: []
28
      rows:
29
        - label: "Number"
30
          displayorder: 1
31
          description: "Simple Numbering method"
32
          numberingmethod: "No. {X}"
33
          label1: "Number"
34
          add1: 1
35
          every1: 1
36
          whenmorethan1: 99999
37
          setto1: 1
38
          numbering1: ~
39
          label2: ""
40
          add2: ~
41
          every2: ~
42
          whenmorethan2: ~
43
          setto2: ~
44
          numbering2: ~
45
          label3: ""
46
          add3: ~
47
          every3: ~
48
          whenmorethan3: ~
49
          setto3: ~
50
          numbering3: ~
51
52
        - label: "Volume, Number, Issue"
53
          displayorder: 2
54
          description: "Volume Number Issue 1"
55
          numberingmethod: "Vol. {X}, Number {Y}, Issue {Z}"
56
          label1: "Volume"
57
          add1: 1
58
          every1: 48
59
          whenmorethan1: 99999
60
          setto1: 1
61
          numbering1: ~
62
          label2: "Number"
63
          add2: 1
64
          every2: 4
65
          whenmorethan2: 12
66
          setto2: 1
67
          numbering2: ~
68
          label3: "Issue"
69
          add3: 1
70
          every3: 1
71
          whenmorethan3: 4
72
          setto3: 1
73
          numbering3: ~
74
75
        - label: "Volume, Number"
76
          displayorder: 3
77
          description: "Volume Number 1"
78
          numberingmethod: "Vol. {X}, No. {Y}"
79
          label1: "Volume"
80
          add1: 1
81
          every1: 12
82
          whenmorethan1: 99999
83
          setto1: 1
84
          numbering1: ~
85
          label2: "Number"
86
          add2: 1
87
          every2: 1
88
          whenmorethan2: 12
89
          setto2: 1
90
          numbering2: ~
91
          label3: ""
92
          add3: ~
93
          every3: ~
94
          whenmorethan3: ~
95
          setto3: ~
96
          numbering3: ~
97
98
        - label: "Seasonal"
99
          displayorder: 4
100
          description: "Season Year"
101
          numberingmethod: "{X} {Y}"
102
          label1: "Season"
103
          add1: 1
104
          every1: 1
105
          whenmorethan1: 3
106
          setto1: 0
107
          numbering1: season
108
          label2: "Year"
109
          add2: 1
110
          every2: 4
111
          whenmorethan2: 99999
112
          setto2: 1
113
          numbering2: ~
114
          label3: ""
115
          add3: ~
116
          every3: ~
117
          whenmorethan3: ~
118
          setto3: ~
119
          numbering3: ~

Return to bug 24583