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

(-)a/Koha/Schema/Result/Subscription.pm (-2 / +56 lines)
Lines 29-40 __PACKAGE__->table("subscription"); Link Here
29
  is_foreign_key: 1
29
  is_foreign_key: 1
30
  is_nullable: 0
30
  is_nullable: 0
31
31
32
foreign key for biblio.biblionumber that this subscription is attached to
33
32
=head2 subscriptionid
34
=head2 subscriptionid
33
35
34
  data_type: 'integer'
36
  data_type: 'integer'
35
  is_auto_increment: 1
37
  is_auto_increment: 1
36
  is_nullable: 0
38
  is_nullable: 0
37
39
40
unique key for this subscription
41
38
=head2 librarian
42
=head2 librarian
39
43
40
  data_type: 'varchar'
44
  data_type: 'varchar'
Lines 42-59 __PACKAGE__->table("subscription"); Link Here
42
  is_nullable: 1
46
  is_nullable: 1
43
  size: 100
47
  size: 100
44
48
49
the librarian's username from borrowers.userid
50
45
=head2 startdate
51
=head2 startdate
46
52
47
  data_type: 'date'
53
  data_type: 'date'
48
  datetime_undef_if_invalid: 1
54
  datetime_undef_if_invalid: 1
49
  is_nullable: 1
55
  is_nullable: 1
50
56
57
start date for this subscription
58
51
=head2 aqbooksellerid
59
=head2 aqbooksellerid
52
60
53
  data_type: 'integer'
61
  data_type: 'integer'
54
  default_value: 0
62
  default_value: 0
55
  is_nullable: 1
63
  is_nullable: 1
56
64
65
foreign key for aqbooksellers.id to link to the vendor
66
57
=head2 cost
67
=head2 cost
58
68
59
  data_type: 'integer'
69
  data_type: 'integer'
Lines 72-95 __PACKAGE__->table("subscription"); Link Here
72
  default_value: 0
82
  default_value: 0
73
  is_nullable: 1
83
  is_nullable: 1
74
84
85
subscription length in weeks (will not be filled in if monthlength or numberlength is set)
86
75
=head2 monthlength
87
=head2 monthlength
76
88
77
  data_type: 'integer'
89
  data_type: 'integer'
78
  default_value: 0
90
  default_value: 0
79
  is_nullable: 1
91
  is_nullable: 1
80
92
93
subscription length in weeks (will not be filled in if weeklength or numberlength is set)
94
81
=head2 numberlength
95
=head2 numberlength
82
96
83
  data_type: 'integer'
97
  data_type: 'integer'
84
  default_value: 0
98
  default_value: 0
85
  is_nullable: 1
99
  is_nullable: 1
86
100
101
subscription length in weeks (will not be filled in if monthlength or weeklength is set)
102
87
=head2 periodicity
103
=head2 periodicity
88
104
89
  data_type: 'integer'
105
  data_type: 'integer'
90
  is_foreign_key: 1
106
  is_foreign_key: 1
91
  is_nullable: 1
107
  is_nullable: 1
92
108
109
frequency type links to subscription_frequencies.id
110
93
=head2 countissuesperunit
111
=head2 countissuesperunit
94
112
95
  data_type: 'integer'
113
  data_type: 'integer'
Lines 101-106 __PACKAGE__->table("subscription"); Link Here
101
  data_type: 'longtext'
119
  data_type: 'longtext'
102
  is_nullable: 1
120
  is_nullable: 1
103
121
122
notes
123
104
=head2 status
124
=head2 status
105
125
106
  data_type: 'varchar'
126
  data_type: 'varchar'
Lines 108-113 __PACKAGE__->table("subscription"); Link Here
108
  is_nullable: 0
128
  is_nullable: 0
109
  size: 100
129
  size: 100
110
130
131
status of this subscription
132
111
=head2 lastvalue1
133
=head2 lastvalue1
112
134
113
  data_type: 'integer'
135
  data_type: 'integer'
Lines 147-168 __PACKAGE__->table("subscription"); Link Here
147
  datetime_undef_if_invalid: 1
169
  datetime_undef_if_invalid: 1
148
  is_nullable: 1
170
  is_nullable: 1
149
171
172
first issue received date
173
150
=head2 manualhistory
174
=head2 manualhistory
151
175
152
  data_type: 'tinyint'
176
  data_type: 'tinyint'
153
  default_value: 0
177
  default_value: 0
154
  is_nullable: 0
178
  is_nullable: 0
155
179
180
yes or no to managing the history manually
181
156
=head2 irregularity
182
=head2 irregularity
157
183
158
  data_type: 'mediumtext'
184
  data_type: 'mediumtext'
159
  is_nullable: 1
185
  is_nullable: 1
160
186
187
any irregularities in the subscription
188
161
=head2 permanent_irregularity
189
=head2 permanent_irregularity
162
190
163
  data_type: 'mediumtext'
191
  data_type: 'mediumtext'
164
  is_nullable: 1
192
  is_nullable: 1
165
193
194
permanent irregularities for renewal
195
166
=head2 skip_serialseq
196
=head2 skip_serialseq
167
197
168
  data_type: 'tinyint'
198
  data_type: 'tinyint'
Lines 181-192 __PACKAGE__->table("subscription"); Link Here
181
  is_foreign_key: 1
211
  is_foreign_key: 1
182
  is_nullable: 1
212
  is_nullable: 1
183
213
214
the numbering pattern used links to subscription_numberpatterns.id
215
184
=head2 locale
216
=head2 locale
185
217
186
  data_type: 'varchar'
218
  data_type: 'varchar'
187
  is_nullable: 1
219
  is_nullable: 1
188
  size: 80
220
  size: 80
189
221
222
for foreign language subscriptions to display months, seasons, etc correctly
223
190
=head2 distributedto
224
=head2 distributedto
191
225
192
  data_type: 'mediumtext'
226
  data_type: 'mediumtext'
Lines 202-207 __PACKAGE__->table("subscription"); Link Here
202
  data_type: 'mediumtext'
236
  data_type: 'mediumtext'
203
  is_nullable: 1
237
  is_nullable: 1
204
238
239
default call number
240
205
=head2 location
241
=head2 location
206
242
207
  data_type: 'varchar'
243
  data_type: 'varchar'
Lines 209-214 __PACKAGE__->table("subscription"); Link Here
209
  is_nullable: 1
245
  is_nullable: 1
210
  size: 80
246
  size: 80
211
247
248
default shelving location (items.location)
249
212
=head2 branchcode
250
=head2 branchcode
213
251
214
  data_type: 'varchar'
252
  data_type: 'varchar'
Lines 216-221 __PACKAGE__->table("subscription"); Link Here
216
  is_nullable: 0
254
  is_nullable: 0
217
  size: 10
255
  size: 10
218
256
257
default branches (items.homebranch)
258
219
=head2 lastbranch
259
=head2 lastbranch
220
260
221
  data_type: 'varchar'
261
  data_type: 'varchar'
Lines 228-269 __PACKAGE__->table("subscription"); Link Here
228
  default_value: 0
268
  default_value: 0
229
  is_nullable: 0
269
  is_nullable: 0
230
270
271
does receiving this serial create an item record
272
231
=head2 staffdisplaycount
273
=head2 staffdisplaycount
232
274
233
  data_type: 'varchar'
275
  data_type: 'varchar'
234
  is_nullable: 1
276
  is_nullable: 1
235
  size: 10
277
  size: 10
236
278
279
how many issues to show to the staff
280
237
=head2 opacdisplaycount
281
=head2 opacdisplaycount
238
282
239
  data_type: 'varchar'
283
  data_type: 'varchar'
240
  is_nullable: 1
284
  is_nullable: 1
241
  size: 10
285
  size: 10
242
286
287
how many issues to show to the public
288
243
=head2 graceperiod
289
=head2 graceperiod
244
290
245
  data_type: 'integer'
291
  data_type: 'integer'
246
  default_value: 0
292
  default_value: 0
247
  is_nullable: 0
293
  is_nullable: 0
248
294
295
grace period in days
296
249
=head2 enddate
297
=head2 enddate
250
298
251
  data_type: 'date'
299
  data_type: 'date'
252
  datetime_undef_if_invalid: 1
300
  datetime_undef_if_invalid: 1
253
  is_nullable: 1
301
  is_nullable: 1
254
302
303
subscription end date
304
255
=head2 closed
305
=head2 closed
256
306
257
  data_type: 'tinyint'
307
  data_type: 'tinyint'
258
  default_value: 0
308
  default_value: 0
259
  is_nullable: 0
309
  is_nullable: 0
260
310
311
yes / no if the subscription is closed
312
261
=head2 reneweddate
313
=head2 reneweddate
262
314
263
  data_type: 'date'
315
  data_type: 'date'
264
  datetime_undef_if_invalid: 1
316
  datetime_undef_if_invalid: 1
265
  is_nullable: 1
317
  is_nullable: 1
266
318
319
date of last renewal for the subscription
320
267
=head2 itemtype
321
=head2 itemtype
268
322
269
  data_type: 'varchar'
323
  data_type: 'varchar'
Lines 504-511 __PACKAGE__->has_many( Link Here
504
);
558
);
505
559
506
560
507
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-03-04 15:52:23
561
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-31 13:26:10
508
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0Pt/RPOtwhz5vHtPGljxfg
562
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wDJLtdGZhJCDErsMHif/Ag
509
563
510
__PACKAGE__->has_many(
564
__PACKAGE__->has_many(
511
  "additional_field_values",
565
  "additional_field_values",
(-)a/serials/subscription-renew.pl (-2 / +1 lines)
Lines 52-58 use C4::Auth qw( get_template_and_user ); Link Here
52
use C4::Context;
52
use C4::Context;
53
use C4::Auth qw( get_template_and_user );
53
use C4::Auth qw( get_template_and_user );
54
use C4::Output qw( output_and_exit output_html_with_http_headers );
54
use C4::Output qw( output_and_exit output_html_with_http_headers );
55
use C4::Serials qw( GetSubscription GetSubscriptionLength NewSubscription ReNewSubscription );
55
use C4::Serials qw( GetSubscription GetSubscriptionLength NewSubscription ReNewSubscription GetSerials GetNextExpected);
56
use C4::Serials::Frequency;
56
use C4::Serials::Frequency;
57
use C4::Serials::Numberpattern;
57
use C4::Serials::Numberpattern;
58
use Koha::DateUtils qw( dt_from_string output_pref );
58
use Koha::DateUtils qw( dt_from_string output_pref );
59
- 

Return to bug 17656