Lines 1-21
Link Here
|
1 |
use utf8; |
|
|
2 |
package Koha::Schema::Result::Subscription; |
1 |
package Koha::Schema::Result::Subscription; |
3 |
|
2 |
|
4 |
# Created by DBIx::Class::Schema::Loader |
3 |
# Created by DBIx::Class::Schema::Loader |
5 |
# DO NOT MODIFY THE FIRST PART OF THIS FILE |
4 |
# DO NOT MODIFY THE FIRST PART OF THIS FILE |
6 |
|
5 |
|
7 |
=head1 NAME |
|
|
8 |
|
9 |
Koha::Schema::Result::Subscription |
10 |
|
11 |
=cut |
12 |
|
13 |
use strict; |
6 |
use strict; |
14 |
use warnings; |
7 |
use warnings; |
15 |
|
8 |
|
16 |
use base 'DBIx::Class::Core'; |
9 |
use base 'DBIx::Class::Core'; |
17 |
|
10 |
|
18 |
=head1 TABLE: C<subscription> |
11 |
|
|
|
12 |
=head1 NAME |
13 |
|
14 |
Koha::Schema::Result::Subscription |
19 |
|
15 |
|
20 |
=cut |
16 |
=cut |
21 |
|
17 |
|
Lines 45-51
__PACKAGE__->table("subscription");
Link Here
|
45 |
=head2 startdate |
41 |
=head2 startdate |
46 |
|
42 |
|
47 |
data_type: 'date' |
43 |
data_type: 'date' |
48 |
datetime_undef_if_invalid: 1 |
|
|
49 |
is_nullable: 1 |
44 |
is_nullable: 1 |
50 |
|
45 |
|
51 |
=head2 aqbooksellerid |
46 |
=head2 aqbooksellerid |
Lines 86-100
__PACKAGE__->table("subscription");
Link Here
|
86 |
|
81 |
|
87 |
=head2 periodicity |
82 |
=head2 periodicity |
88 |
|
83 |
|
89 |
data_type: 'integer' |
84 |
data_type: 'tinyint' |
90 |
is_foreign_key: 1 |
85 |
default_value: 0 |
91 |
is_nullable: 1 |
86 |
is_nullable: 1 |
92 |
|
87 |
|
93 |
=head2 countissuesperunit |
88 |
=head2 dow |
94 |
|
89 |
|
95 |
data_type: 'integer' |
90 |
data_type: 'varchar' |
96 |
default_value: 1 |
91 |
default_value: (empty string) |
97 |
is_nullable: 0 |
92 |
is_nullable: 1 |
|
|
93 |
size: 100 |
94 |
|
95 |
=head2 numberingmethod |
96 |
|
97 |
data_type: 'varchar' |
98 |
default_value: (empty string) |
99 |
is_nullable: 1 |
100 |
size: 100 |
98 |
|
101 |
|
99 |
=head2 notes |
102 |
=head2 notes |
100 |
|
103 |
|
Lines 108-138
__PACKAGE__->table("subscription");
Link Here
|
108 |
is_nullable: 0 |
111 |
is_nullable: 0 |
109 |
size: 100 |
112 |
size: 100 |
110 |
|
113 |
|
|
|
114 |
=head2 add1 |
115 |
|
116 |
data_type: 'integer' |
117 |
default_value: 0 |
118 |
is_nullable: 1 |
119 |
|
120 |
=head2 every1 |
121 |
|
122 |
data_type: 'integer' |
123 |
default_value: 0 |
124 |
is_nullable: 1 |
125 |
|
126 |
=head2 whenmorethan1 |
127 |
|
128 |
data_type: 'integer' |
129 |
default_value: 0 |
130 |
is_nullable: 1 |
131 |
|
132 |
=head2 setto1 |
133 |
|
134 |
data_type: 'integer' |
135 |
is_nullable: 1 |
136 |
|
111 |
=head2 lastvalue1 |
137 |
=head2 lastvalue1 |
112 |
|
138 |
|
113 |
data_type: 'integer' |
139 |
data_type: 'integer' |
114 |
is_nullable: 1 |
140 |
is_nullable: 1 |
115 |
|
141 |
|
116 |
=head2 innerloop1 |
142 |
=head2 add2 |
|
|
143 |
|
144 |
data_type: 'integer' |
145 |
default_value: 0 |
146 |
is_nullable: 1 |
147 |
|
148 |
=head2 every2 |
149 |
|
150 |
data_type: 'integer' |
151 |
default_value: 0 |
152 |
is_nullable: 1 |
153 |
|
154 |
=head2 whenmorethan2 |
117 |
|
155 |
|
118 |
data_type: 'integer' |
156 |
data_type: 'integer' |
119 |
default_value: 0 |
157 |
default_value: 0 |
120 |
is_nullable: 1 |
158 |
is_nullable: 1 |
121 |
|
159 |
|
|
|
160 |
=head2 setto2 |
161 |
|
162 |
data_type: 'integer' |
163 |
is_nullable: 1 |
164 |
|
122 |
=head2 lastvalue2 |
165 |
=head2 lastvalue2 |
123 |
|
166 |
|
124 |
data_type: 'integer' |
167 |
data_type: 'integer' |
125 |
is_nullable: 1 |
168 |
is_nullable: 1 |
126 |
|
169 |
|
127 |
=head2 innerloop2 |
170 |
=head2 add3 |
128 |
|
171 |
|
129 |
data_type: 'integer' |
172 |
data_type: 'integer' |
130 |
default_value: 0 |
173 |
default_value: 0 |
131 |
is_nullable: 1 |
174 |
is_nullable: 1 |
132 |
|
175 |
|
133 |
=head2 lastvalue3 |
176 |
=head2 every3 |
|
|
177 |
|
178 |
data_type: 'integer' |
179 |
default_value: 0 |
180 |
is_nullable: 1 |
181 |
|
182 |
=head2 innerloop1 |
134 |
|
183 |
|
135 |
data_type: 'integer' |
184 |
data_type: 'integer' |
|
|
185 |
default_value: 0 |
186 |
is_nullable: 1 |
187 |
|
188 |
=head2 innerloop2 |
189 |
|
190 |
data_type: 'integer' |
191 |
default_value: 0 |
136 |
is_nullable: 1 |
192 |
is_nullable: 1 |
137 |
|
193 |
|
138 |
=head2 innerloop3 |
194 |
=head2 innerloop3 |
Lines 141-150
__PACKAGE__->table("subscription");
Link Here
|
141 |
default_value: 0 |
197 |
default_value: 0 |
142 |
is_nullable: 1 |
198 |
is_nullable: 1 |
143 |
|
199 |
|
|
|
200 |
=head2 whenmorethan3 |
201 |
|
202 |
data_type: 'integer' |
203 |
default_value: 0 |
204 |
is_nullable: 1 |
205 |
|
206 |
=head2 setto3 |
207 |
|
208 |
data_type: 'integer' |
209 |
is_nullable: 1 |
210 |
|
211 |
=head2 lastvalue3 |
212 |
|
213 |
data_type: 'integer' |
214 |
is_nullable: 1 |
215 |
|
216 |
=head2 issuesatonce |
217 |
|
218 |
data_type: 'tinyint' |
219 |
default_value: 1 |
220 |
is_nullable: 0 |
221 |
|
144 |
=head2 firstacquidate |
222 |
=head2 firstacquidate |
145 |
|
223 |
|
146 |
data_type: 'date' |
224 |
data_type: 'date' |
147 |
datetime_undef_if_invalid: 1 |
|
|
148 |
is_nullable: 1 |
225 |
is_nullable: 1 |
149 |
|
226 |
|
150 |
=head2 manualhistory |
227 |
=head2 manualhistory |
Lines 158-169
__PACKAGE__->table("subscription");
Link Here
|
158 |
data_type: 'text' |
235 |
data_type: 'text' |
159 |
is_nullable: 1 |
236 |
is_nullable: 1 |
160 |
|
237 |
|
161 |
=head2 skip_serialseq |
|
|
162 |
|
163 |
data_type: 'tinyint' |
164 |
default_value: 0 |
165 |
is_nullable: 0 |
166 |
|
167 |
=head2 letter |
238 |
=head2 letter |
168 |
|
239 |
|
169 |
data_type: 'varchar' |
240 |
data_type: 'varchar' |
Lines 172-186
__PACKAGE__->table("subscription");
Link Here
|
172 |
|
243 |
|
173 |
=head2 numberpattern |
244 |
=head2 numberpattern |
174 |
|
245 |
|
175 |
data_type: 'integer' |
246 |
data_type: 'tinyint' |
176 |
is_foreign_key: 1 |
247 |
default_value: 0 |
177 |
is_nullable: 1 |
|
|
178 |
|
179 |
=head2 locale |
180 |
|
181 |
data_type: 'varchar' |
182 |
is_nullable: 1 |
248 |
is_nullable: 1 |
183 |
size: 80 |
|
|
184 |
|
249 |
|
185 |
=head2 distributedto |
250 |
=head2 distributedto |
186 |
|
251 |
|
Lines 211-216
__PACKAGE__->table("subscription");
Link Here
|
211 |
is_nullable: 0 |
276 |
is_nullable: 0 |
212 |
size: 10 |
277 |
size: 10 |
213 |
|
278 |
|
|
|
279 |
=head2 hemisphere |
280 |
|
281 |
data_type: 'tinyint' |
282 |
default_value: 0 |
283 |
is_nullable: 1 |
284 |
|
214 |
=head2 lastbranch |
285 |
=head2 lastbranch |
215 |
|
286 |
|
216 |
data_type: 'varchar' |
287 |
data_type: 'varchar' |
Lines 244-250
__PACKAGE__->table("subscription");
Link Here
|
244 |
=head2 enddate |
315 |
=head2 enddate |
245 |
|
316 |
|
246 |
data_type: 'date' |
317 |
data_type: 'date' |
247 |
datetime_undef_if_invalid: 1 |
|
|
248 |
is_nullable: 1 |
318 |
is_nullable: 1 |
249 |
|
319 |
|
250 |
=head2 closed |
320 |
=head2 closed |
Lines 256-262
__PACKAGE__->table("subscription");
Link Here
|
256 |
=head2 reneweddate |
326 |
=head2 reneweddate |
257 |
|
327 |
|
258 |
data_type: 'date' |
328 |
data_type: 'date' |
259 |
datetime_undef_if_invalid: 1 |
|
|
260 |
is_nullable: 1 |
329 |
is_nullable: 1 |
261 |
|
330 |
|
262 |
=cut |
331 |
=cut |
Lines 269-275
__PACKAGE__->add_columns(
Link Here
|
269 |
"librarian", |
338 |
"librarian", |
270 |
{ data_type => "varchar", default_value => "", is_nullable => 1, size => 100 }, |
339 |
{ data_type => "varchar", default_value => "", is_nullable => 1, size => 100 }, |
271 |
"startdate", |
340 |
"startdate", |
272 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
341 |
{ data_type => "date", is_nullable => 1 }, |
273 |
"aqbooksellerid", |
342 |
"aqbooksellerid", |
274 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
343 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
275 |
"cost", |
344 |
"cost", |
Lines 283-321
__PACKAGE__->add_columns(
Link Here
|
283 |
"numberlength", |
352 |
"numberlength", |
284 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
353 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
285 |
"periodicity", |
354 |
"periodicity", |
286 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, |
355 |
{ data_type => "tinyint", default_value => 0, is_nullable => 1 }, |
287 |
"countissuesperunit", |
356 |
"dow", |
288 |
{ data_type => "integer", default_value => 1, is_nullable => 0 }, |
357 |
{ data_type => "varchar", default_value => "", is_nullable => 1, size => 100 }, |
|
|
358 |
"numberingmethod", |
359 |
{ data_type => "varchar", default_value => "", is_nullable => 1, size => 100 }, |
289 |
"notes", |
360 |
"notes", |
290 |
{ data_type => "mediumtext", is_nullable => 1 }, |
361 |
{ data_type => "mediumtext", is_nullable => 1 }, |
291 |
"status", |
362 |
"status", |
292 |
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 100 }, |
363 |
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 100 }, |
|
|
364 |
"add1", |
365 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
366 |
"every1", |
367 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
368 |
"whenmorethan1", |
369 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
370 |
"setto1", |
371 |
{ data_type => "integer", is_nullable => 1 }, |
293 |
"lastvalue1", |
372 |
"lastvalue1", |
294 |
{ data_type => "integer", is_nullable => 1 }, |
373 |
{ data_type => "integer", is_nullable => 1 }, |
295 |
"innerloop1", |
374 |
"add2", |
296 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
375 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
|
|
376 |
"every2", |
377 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
378 |
"whenmorethan2", |
379 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
380 |
"setto2", |
381 |
{ data_type => "integer", is_nullable => 1 }, |
297 |
"lastvalue2", |
382 |
"lastvalue2", |
298 |
{ data_type => "integer", is_nullable => 1 }, |
383 |
{ data_type => "integer", is_nullable => 1 }, |
|
|
384 |
"add3", |
385 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
386 |
"every3", |
387 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
388 |
"innerloop1", |
389 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
299 |
"innerloop2", |
390 |
"innerloop2", |
300 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
391 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
301 |
"lastvalue3", |
|
|
302 |
{ data_type => "integer", is_nullable => 1 }, |
303 |
"innerloop3", |
392 |
"innerloop3", |
304 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
393 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
|
|
394 |
"whenmorethan3", |
395 |
{ data_type => "integer", default_value => 0, is_nullable => 1 }, |
396 |
"setto3", |
397 |
{ data_type => "integer", is_nullable => 1 }, |
398 |
"lastvalue3", |
399 |
{ data_type => "integer", is_nullable => 1 }, |
400 |
"issuesatonce", |
401 |
{ data_type => "tinyint", default_value => 1, is_nullable => 0 }, |
305 |
"firstacquidate", |
402 |
"firstacquidate", |
306 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
403 |
{ data_type => "date", is_nullable => 1 }, |
307 |
"manualhistory", |
404 |
"manualhistory", |
308 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
405 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
309 |
"irregularity", |
406 |
"irregularity", |
310 |
{ data_type => "text", is_nullable => 1 }, |
407 |
{ data_type => "text", is_nullable => 1 }, |
311 |
"skip_serialseq", |
|
|
312 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
313 |
"letter", |
408 |
"letter", |
314 |
{ data_type => "varchar", is_nullable => 1, size => 20 }, |
409 |
{ data_type => "varchar", is_nullable => 1, size => 20 }, |
315 |
"numberpattern", |
410 |
"numberpattern", |
316 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, |
411 |
{ data_type => "tinyint", default_value => 0, is_nullable => 1 }, |
317 |
"locale", |
|
|
318 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
319 |
"distributedto", |
412 |
"distributedto", |
320 |
{ data_type => "text", is_nullable => 1 }, |
413 |
{ data_type => "text", is_nullable => 1 }, |
321 |
"internalnotes", |
414 |
"internalnotes", |
Lines 326-331
__PACKAGE__->add_columns(
Link Here
|
326 |
{ data_type => "varchar", default_value => "", is_nullable => 1, size => 80 }, |
419 |
{ data_type => "varchar", default_value => "", is_nullable => 1, size => 80 }, |
327 |
"branchcode", |
420 |
"branchcode", |
328 |
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, |
421 |
{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, |
|
|
422 |
"hemisphere", |
423 |
{ data_type => "tinyint", default_value => 0, is_nullable => 1 }, |
329 |
"lastbranch", |
424 |
"lastbranch", |
330 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
425 |
{ data_type => "varchar", is_nullable => 1, size => 10 }, |
331 |
"serialsadditems", |
426 |
"serialsadditems", |
Lines 337-359
__PACKAGE__->add_columns(
Link Here
|
337 |
"graceperiod", |
432 |
"graceperiod", |
338 |
{ data_type => "integer", default_value => 0, is_nullable => 0 }, |
433 |
{ data_type => "integer", default_value => 0, is_nullable => 0 }, |
339 |
"enddate", |
434 |
"enddate", |
340 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
435 |
{ data_type => "date", is_nullable => 1 }, |
341 |
"closed", |
436 |
"closed", |
342 |
{ data_type => "integer", default_value => 0, is_nullable => 0 }, |
437 |
{ data_type => "integer", default_value => 0, is_nullable => 0 }, |
343 |
"reneweddate", |
438 |
"reneweddate", |
344 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
439 |
{ data_type => "date", is_nullable => 1 }, |
345 |
); |
440 |
); |
346 |
|
|
|
347 |
=head1 PRIMARY KEY |
348 |
|
349 |
=over 4 |
350 |
|
351 |
=item * L</subscriptionid> |
352 |
|
353 |
=back |
354 |
|
355 |
=cut |
356 |
|
357 |
__PACKAGE__->set_primary_key("subscriptionid"); |
441 |
__PACKAGE__->set_primary_key("subscriptionid"); |
358 |
|
442 |
|
359 |
=head1 RELATIONS |
443 |
=head1 RELATIONS |
Lines 373-418
__PACKAGE__->has_many(
Link Here
|
373 |
{ cascade_copy => 0, cascade_delete => 0 }, |
457 |
{ cascade_copy => 0, cascade_delete => 0 }, |
374 |
); |
458 |
); |
375 |
|
459 |
|
376 |
=head2 numberpattern |
|
|
377 |
|
378 |
Type: belongs_to |
379 |
|
380 |
Related object: L<Koha::Schema::Result::SubscriptionNumberpattern> |
381 |
|
382 |
=cut |
383 |
|
384 |
__PACKAGE__->belongs_to( |
385 |
"numberpattern", |
386 |
"Koha::Schema::Result::SubscriptionNumberpattern", |
387 |
{ id => "numberpattern" }, |
388 |
{ |
389 |
is_deferrable => 1, |
390 |
join_type => "LEFT", |
391 |
on_delete => "CASCADE", |
392 |
on_update => "CASCADE", |
393 |
}, |
394 |
); |
395 |
|
396 |
=head2 periodicity |
397 |
|
398 |
Type: belongs_to |
399 |
|
400 |
Related object: L<Koha::Schema::Result::SubscriptionFrequency> |
401 |
|
402 |
=cut |
403 |
|
404 |
__PACKAGE__->belongs_to( |
405 |
"periodicity", |
406 |
"Koha::Schema::Result::SubscriptionFrequency", |
407 |
{ id => "periodicity" }, |
408 |
{ |
409 |
is_deferrable => 1, |
410 |
join_type => "LEFT", |
411 |
on_delete => "CASCADE", |
412 |
on_update => "CASCADE", |
413 |
}, |
414 |
); |
415 |
|
416 |
=head2 subscriptionroutinglists |
460 |
=head2 subscriptionroutinglists |
417 |
|
461 |
|
418 |
Type: has_many |
462 |
Type: has_many |
Lines 429-436
__PACKAGE__->has_many(
Link Here
|
429 |
); |
473 |
); |
430 |
|
474 |
|
431 |
|
475 |
|
432 |
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-30 02:42:01 |
476 |
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-10-31 07:41:39 |
433 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JoTdms86n/xfPo8YUnDHUQ |
477 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2vGQeK1QqRxFYpYz+fafWg |
434 |
|
478 |
|
435 |
|
479 |
|
436 |
# You can replace this text with custom content, and it will be preserved on regeneration |
480 |
# You can replace this text with custom content, and it will be preserved on regeneration |