Attachment #109463 for bug #19532

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




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 recalls

Type: has_many

Related object: L<Koha::Schema::Result::Recall>

=cut

__PACKAGE__->has_many(
  "recalls",
  "Koha::Schema::Result::Recall",
  { "foreign.biblionumber" => "self.biblionumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 reserves

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:52
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eIgM7SPwLPvI3MR+TDm3RQ


__PACKAGE__->has_one(




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 recalls

Type: has_many

Related object: L<Koha::Schema::Result::Recall>

=cut

__PACKAGE__->has_many(
  "recalls",
  "Koha::Schema::Result::Recall",
  { "foreign.borrowernumber" => "self.borrowernumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 reserves

Type: has_many

__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:53
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BKDgwFG/aXt9L2ltSjP4Yw

__PACKAGE__->add_columns(
    '+anonymized'    => { is_boolean => 1 },




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 recalls

Type: has_many

Related object: L<Koha::Schema::Result::Recall>

=cut

__PACKAGE__->has_many(
  "recalls",
  "Koha::Schema::Result::Recall",
  { "foreign.branchcode" => "self.branchcode" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 repeatable_holidays

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:53
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tKW4/JGHF3WiKPz07XDv8A

__PACKAGE__->add_columns(
    '+pickup_location' => { is_boolean => 1 }

Lines 79-85 __PACKAGE__->table("branchtransfers"); Link Here

(-)a/Koha/Schema/Result/Branchtransfer.pm (-3 / +5 lines)
79	=head2 reason	79	=head2 reason
80		80
81	data_type: 'enum'	81	data_type: 'enum'
82	extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve"]}	82	extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve","Recall","CancelRecall"]}
83	is_nullable: 1	83	is_nullable: 1
84		84
85	=cut	85	=cut
Lines 145-150 __PACKAGE__->add_columns( Link Here
145	"Reserve",	145	"Reserve",
146	"LostReserve",	146	"LostReserve",
147	"CancelReserve",	147	"CancelReserve",
		148	"Recall",
		149	"CancelRecall",
148	],	150	],
149	},	151	},
150	is_nullable => 1,	152	is_nullable => 1,
Lines 211-218 __PACKAGE__->belongs_to( Link Here
211	);	213	);
212		214
213		215
214	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-20 12:30:59	216	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:53
215	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:G5GZTxF8X/mcIKXmuGVWIQ	217	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xhhlVrbmOa0ThDChL8XCRw
216		218
217	sub koha_object_class {	219	sub koha_object_class {
218	'Koha::Item::Transfer';	220	'Koha::Item::Transfer';




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 recalls

Type: has_many

Related object: L<Koha::Schema::Result::Recall>

=cut

__PACKAGE__->has_many(
  "recalls",
  "Koha::Schema::Result::Recall",
  { "foreign.itemnumber" => "self.itemnumber" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 reserves

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:53
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e3FVrUD2MyMAtSnck7pQrw

__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );





use utf8;
package Koha::Schema::Result::Recall;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::Recall

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<recalls>

=cut

__PACKAGE__->table("recalls");

=head1 ACCESSORS

=head2 recall_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 borrowernumber

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

=head2 recalldate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 biblionumber

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

=head2 branchcode

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10

=head2 cancellationdate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 recallnotes

  data_type: 'mediumtext'
  is_nullable: 1

=head2 priority

  data_type: 'smallint'
  is_nullable: 1

=head2 status

  data_type: 'varchar'
  is_nullable: 1
  size: 1

=head2 timestamp

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

=head2 itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 waitingdate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 expirationdate

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 old

  data_type: 'tinyint'
  is_nullable: 1

=head2 item_level_recall

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

=cut

__PACKAGE__->add_columns(
  "recall_id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "borrowernumber",
  {
    data_type      => "integer",
    default_value  => 0,
    is_foreign_key => 1,
    is_nullable    => 0,
  },
  "recalldate",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "biblionumber",
  {
    data_type      => "integer",
    default_value  => 0,
    is_foreign_key => 1,
    is_nullable    => 0,
  },
  "branchcode",
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
  "cancellationdate",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "recallnotes",
  { data_type => "mediumtext", is_nullable => 1 },
  "priority",
  { data_type => "smallint", is_nullable => 1 },
  "status",
  { data_type => "varchar", is_nullable => 1, size => 1 },
  "timestamp",
  {
    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => \"current_timestamp",
    is_nullable => 0,
  },
  "itemnumber",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "waitingdate",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "expirationdate",
  {
    data_type => "datetime",
    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "old",
  { data_type => "tinyint", is_nullable => 1 },
  "item_level_recall",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);

=head1 PRIMARY KEY

=over 4

=item * L</recall_id>

=back

=cut

__PACKAGE__->set_primary_key("recall_id");

=head1 RELATIONS

=head2 biblionumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Biblio>

=cut

__PACKAGE__->belongs_to(
  "biblionumber",
  "Koha::Schema::Result::Biblio",
  { biblionumber => "biblionumber" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 borrowernumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Borrower>

=cut

__PACKAGE__->belongs_to(
  "borrowernumber",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "borrowernumber" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 branchcode

Type: belongs_to

Related object: L<Koha::Schema::Result::Branch>

=cut

__PACKAGE__->belongs_to(
  "branchcode",
  "Koha::Schema::Result::Branch",
  { branchcode => "branchcode" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

=head2 itemnumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Item>

=cut

__PACKAGE__->belongs_to(
  "itemnumber",
  "Koha::Schema::Result::Item",
  { itemnumber => "itemnumber" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:53
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CmeEcDhKl64qRkuBlsFMcg


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;

Return to bug 19532

Lines 315-320 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +17 lines)
315	{ cascade_copy => 0, cascade_delete => 0 },	315	{ cascade_copy => 0, cascade_delete => 0 },
316	);	316	);
317		317
		318	=head2 recalls
		319
		320	Type: has_many
		321
		322	Related object: L<Koha::Schema::Result::Recall>
		323
		324	=cut
		325
		326	__PACKAGE__->has_many(
		327	"recalls",
		328	"Koha::Schema::Result::Recall",
		329	{ "foreign.biblionumber" => "self.biblionumber" },
		330	{ cascade_copy => 0, cascade_delete => 0 },
		331	);
		332
318	=head2 reserves	333	=head2 reserves
319		334
320	Type: has_many	335	Type: has_many
Lines 451-458 __PACKAGE__->has_many( Link Here
451	);	466	);
452		467
453		468
454	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 09:15:51	469	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:52
455	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p2SIq565zPyE3ZUkSuXyBA	470	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eIgM7SPwLPvI3MR+TDm3RQ
456		471
457		472
458	__PACKAGE__->has_one(	473	__PACKAGE__->has_one(

Lines 1337-1342 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-2 / +17 lines)
1337	{ cascade_copy => 0, cascade_delete => 0 },	1337	{ cascade_copy => 0, cascade_delete => 0 },
1338	);	1338	);
1339		1339
		1340	=head2 recalls
		1341
		1342	Type: has_many
		1343
		1344	Related object: L<Koha::Schema::Result::Recall>
		1345
		1346	=cut
		1347
		1348	__PACKAGE__->has_many(
		1349	"recalls",
		1350	"Koha::Schema::Result::Recall",
		1351	{ "foreign.borrowernumber" => "self.borrowernumber" },
		1352	{ cascade_copy => 0, cascade_delete => 0 },
		1353	);
		1354
1340	=head2 reserves	1355	=head2 reserves
1341		1356
1342	Type: has_many	1357	Type: has_many
Lines 1668-1675 Composing rels: L</aqorder_users> -> ordernumber Link Here
1668	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1683	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1669		1684
1670		1685
1671	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-07-20 10:54:51	1686	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:53
1672	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pH5cKJCrjwfiLnk7iCO4tA	1687	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BKDgwFG/aXt9L2ltSjP4Yw
1673		1688
1674	__PACKAGE__->add_columns(	1689	__PACKAGE__->add_columns(
1675	'+anonymized' => { is_boolean => 1 },	1690	'+anonymized' => { is_boolean => 1 },

Lines 713-718 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
713	{ cascade_copy => 0, cascade_delete => 0 },	713	{ cascade_copy => 0, cascade_delete => 0 },
714	);	714	);
715		715
		716	=head2 recalls
		717
		718	Type: has_many
		719
		720	Related object: L<Koha::Schema::Result::Recall>
		721
		722	=cut
		723
		724	__PACKAGE__->has_many(
		725	"recalls",
		726	"Koha::Schema::Result::Recall",
		727	{ "foreign.branchcode" => "self.branchcode" },
		728	{ cascade_copy => 0, cascade_delete => 0 },
		729	);
		730
716	=head2 repeatable_holidays	731	=head2 repeatable_holidays
717		732
718	Type: has_many	733	Type: has_many
Lines 819-826 __PACKAGE__->has_many( Link Here
819	);	834	);
820		835
821		836
822	# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-06-12 14:01:29	837	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:53
823	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hU6Ldf0uN2iV1h7llLH+4g	838	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tKW4/JGHF3WiKPz07XDv8A
824		839
825	__PACKAGE__->add_columns(	840	__PACKAGE__->add_columns(
826	'+pickup_location' => { is_boolean => 1 }	841	'+pickup_location' => { is_boolean => 1 }

Lines 678-683 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Item.pm (-2 / +17 lines)
678	{ cascade_copy => 0, cascade_delete => 0 },	678	{ cascade_copy => 0, cascade_delete => 0 },
679	);	679	);
680		680
		681	=head2 recalls
		682
		683	Type: has_many
		684
		685	Related object: L<Koha::Schema::Result::Recall>
		686
		687	=cut
		688
		689	__PACKAGE__->has_many(
		690	"recalls",
		691	"Koha::Schema::Result::Recall",
		692	{ "foreign.itemnumber" => "self.itemnumber" },
		693	{ cascade_copy => 0, cascade_delete => 0 },
		694	);
		695
681	=head2 reserves	696	=head2 reserves
682		697
683	Type: has_many	698	Type: has_many
Lines 754-761 __PACKAGE__->has_many( Link Here
754	);	769	);
755		770
756		771
757	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-06-05 20:21:47	772	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:53
758	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9AxhV/hJnavWY4OTDTNRcQ	773	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e3FVrUD2MyMAtSnck7pQrw
759		774
760	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );	775	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
761		776

Line 0 Link Here

(-)a/Koha/Schema/Result/Recall.pm (-1 / +273 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::Recall;
		3
		4	# Created by DBIx::Class::Schema::Loader
		5	# DO NOT MODIFY THE FIRST PART OF THIS FILE
		6
		7	=head1 NAME
		8
		9	Koha::Schema::Result::Recall
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<recalls>
		19
		20	=cut
		21
		22	__PACKAGE__->table("recalls");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 recall_id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 borrowernumber
		33
		34	data_type: 'integer'
		35	default_value: 0
		36	is_foreign_key: 1
		37	is_nullable: 0
		38
		39	=head2 recalldate
		40
		41	data_type: 'datetime'
		42	datetime_undef_if_invalid: 1
		43	is_nullable: 1
		44
		45	=head2 biblionumber
		46
		47	data_type: 'integer'
		48	default_value: 0
		49	is_foreign_key: 1
		50	is_nullable: 0
		51
		52	=head2 branchcode
		53
		54	data_type: 'varchar'
		55	is_foreign_key: 1
		56	is_nullable: 1
		57	size: 10
		58
		59	=head2 cancellationdate
		60
		61	data_type: 'datetime'
		62	datetime_undef_if_invalid: 1
		63	is_nullable: 1
		64
		65	=head2 recallnotes
66
67	data_type: 'mediumtext'
68	is_nullable: 1
69
70	=head2 priority
71
72	data_type: 'smallint'
73	is_nullable: 1
74
75	=head2 status
76
77	data_type: 'varchar'
78	is_nullable: 1
79	size: 1
80
81	=head2 timestamp
82
83	data_type: 'timestamp'
84	datetime_undef_if_invalid: 1
85	default_value: current_timestamp
86	is_nullable: 0
87
88	=head2 itemnumber
89
90	data_type: 'integer'
91	is_foreign_key: 1
92	is_nullable: 1
93
94	=head2 waitingdate
95
96	data_type: 'datetime'
97	datetime_undef_if_invalid: 1
98	is_nullable: 1
99
100	=head2 expirationdate
101
102	data_type: 'datetime'
103	datetime_undef_if_invalid: 1
104	is_nullable: 1
105
106	=head2 old
107
108	data_type: 'tinyint'
109	is_nullable: 1
110
111	=head2 item_level_recall
112
113	data_type: 'tinyint'
114	default_value: 0
115	is_nullable: 0
116
117	=cut
118
119	__PACKAGE__->add_columns(
120	"recall_id",
121	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
122	"borrowernumber",
123	{
124	data_type => "integer",
125	default_value => 0,
126	is_foreign_key => 1,
127	is_nullable => 0,
128	},
129	"recalldate",
130	{
131	data_type => "datetime",
132	datetime_undef_if_invalid => 1,
133	is_nullable => 1,
134	},
135	"biblionumber",
136	{
137	data_type => "integer",
138	default_value => 0,
139	is_foreign_key => 1,
140	is_nullable => 0,
141	},
142	"branchcode",
143	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
144	"cancellationdate",
145	{
146	data_type => "datetime",
147	datetime_undef_if_invalid => 1,
148	is_nullable => 1,
149	},
150	"recallnotes",
151	{ data_type => "mediumtext", is_nullable => 1 },
152	"priority",
153	{ data_type => "smallint", is_nullable => 1 },
154	"status",
155	{ data_type => "varchar", is_nullable => 1, size => 1 },
156	"timestamp",
157	{
158	data_type => "timestamp",
159	datetime_undef_if_invalid => 1,
160	default_value => \"current_timestamp",
161	is_nullable => 0,
162	},
163	"itemnumber",
164	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
165	"waitingdate",
166	{
167	data_type => "datetime",
168	datetime_undef_if_invalid => 1,
169	is_nullable => 1,
170	},
171	"expirationdate",
172	{
173	data_type => "datetime",
174	datetime_undef_if_invalid => 1,
175	is_nullable => 1,
176	},
177	"old",
178	{ data_type => "tinyint", is_nullable => 1 },
179	"item_level_recall",
180	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
181	);
182
183	=head1 PRIMARY KEY
184
185	=over 4
186
187	=item * L</recall_id>
188
189	=back
190
191	=cut
192
193	__PACKAGE__->set_primary_key("recall_id");
194
195	=head1 RELATIONS
196
197	=head2 biblionumber
198
199	Type: belongs_to
200
201	Related object: L<Koha::Schema::Result::Biblio>
202
203	=cut
204
205	__PACKAGE__->belongs_to(
206	"biblionumber",
207	"Koha::Schema::Result::Biblio",
208	{ biblionumber => "biblionumber" },
209	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
210	);
211
212	=head2 borrowernumber
213
214	Type: belongs_to
215
216	Related object: L<Koha::Schema::Result::Borrower>
217
218	=cut
219
220	__PACKAGE__->belongs_to(
221	"borrowernumber",
222	"Koha::Schema::Result::Borrower",
223	{ borrowernumber => "borrowernumber" },
224	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
225	);
226
227	=head2 branchcode
228
229	Type: belongs_to
230
231	Related object: L<Koha::Schema::Result::Branch>
232
233	=cut
234
235	__PACKAGE__->belongs_to(
236	"branchcode",
237	"Koha::Schema::Result::Branch",
238	{ branchcode => "branchcode" },
239	{
240	is_deferrable => 1,
241	join_type => "LEFT",
242	on_delete => "CASCADE",
243	on_update => "CASCADE",
244	},
245	);
246
247	=head2 itemnumber
248
249	Type: belongs_to
250
251	Related object: L<Koha::Schema::Result::Item>
252
253	=cut
254
255	__PACKAGE__->belongs_to(
256	"itemnumber",
257	"Koha::Schema::Result::Item",
258	{ itemnumber => "itemnumber" },
259	{
260	is_deferrable => 1,
261	join_type => "LEFT",
262	on_delete => "CASCADE",
263	on_update => "CASCADE",
264	},
265	);
266
267
268	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-02 09:43:53
269	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CmeEcDhKl64qRkuBlsFMcg
270
271
272	# You can replace this text with custom code or comments, and it will be preserved on regeneration
273	1;