Attachment #131262 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 @ 2021-10-14 15:07:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6YO2t5VoWcG/tM+8uOP/wg

__PACKAGE__->has_many(
  "biblioitem",




  { 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




  { 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 @ 2022-02-15 02:16:34
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PR2GOpldAnNtyB2DRLsE9g

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




=head2 reason

  data_type: 'enum'
  extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve","Recall","CancelRecall"]}
  is_nullable: 1

what triggered the transfer

=head2 cancellation_reason

  data_type: 'enum'

        "Reserve",
        "LostReserve",
        "CancelReserve",
        "Recall",
        "CancelRecall",
      ],
    },
    is_nullable => 1,

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-10-14 15:07:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:APOPxPO4uRpPHgSEhXbnTw

sub koha_object_class {
    '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 @ 2021-10-14 15:07:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yRbholcHil9qRF5t+83jdA

__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 @ 2021-10-14 15:07:03
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3OJBkRJzqxZpuRp0GYGixw


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

Return to bug 19532

Lines 375-380 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +17 lines)
375	{ cascade_copy => 0, cascade_delete => 0 },	375	{ cascade_copy => 0, cascade_delete => 0 },
376	);	376	);
377		377
		378	=head2 recalls
		379
		380	Type: has_many
		381
		382	Related object: L<Koha::Schema::Result::Recall>
		383
		384	=cut
		385
		386	__PACKAGE__->has_many(
		387	"recalls",
		388	"Koha::Schema::Result::Recall",
		389	{ "foreign.biblionumber" => "self.biblionumber" },
		390	{ cascade_copy => 0, cascade_delete => 0 },
		391	);
		392
378	=head2 reserves	393	=head2 reserves
379		394
380	Type: has_many	395	Type: has_many
Lines 526-533 __PACKAGE__->has_many( Link Here
526	);	541	);
527		542
528		543
529	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-09-20 12:00:15	544	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-10-14 15:07:03
530	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:troBZEbpX+2RhgH2jptVZQ	545	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6YO2t5VoWcG/tM+8uOP/wg
531		546
532	__PACKAGE__->has_many(	547	__PACKAGE__->has_many(
533	"biblioitem",	548	"biblioitem",

Lines 1559-1564 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Borrower.pm (+15 lines)
1559	{ cascade_copy => 0, cascade_delete => 0 },	1559	{ cascade_copy => 0, cascade_delete => 0 },
1560	);	1560	);
1561		1561
		1562	=head2 recalls
		1563
		1564	Type: has_many
		1565
		1566	Related object: L<Koha::Schema::Result::Recall>
		1567
		1568	=cut
		1569
		1570	__PACKAGE__->has_many(
		1571	"recalls",
		1572	"Koha::Schema::Result::Recall",
		1573	{ "foreign.borrowernumber" => "self.borrowernumber" },
		1574	{ cascade_copy => 0, cascade_delete => 0 },
		1575	);
		1576
1562	=head2 reserves	1577	=head2 reserves
1563		1578
1564	Type: has_many	1579	Type: has_many

Lines 761-766 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
761	{ cascade_copy => 0, cascade_delete => 0 },	761	{ cascade_copy => 0, cascade_delete => 0 },
762	);	762	);
763		763
		764	=head2 recalls
		765
		766	Type: has_many
		767
		768	Related object: L<Koha::Schema::Result::Recall>
		769
		770	=cut
		771
		772	__PACKAGE__->has_many(
		773	"recalls",
		774	"Koha::Schema::Result::Recall",
		775	{ "foreign.branchcode" => "self.branchcode" },
		776	{ cascade_copy => 0, cascade_delete => 0 },
		777	);
		778
764	=head2 repeatable_holidays	779	=head2 repeatable_holidays
765		780
766	Type: has_many	781	Type: has_many
Lines 867-874 __PACKAGE__->has_many( Link Here
867	);	882	);
868		883
869		884
870	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-11-19 14:20:11	885	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2022-02-15 02:16:34
871	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:v83MNP0UpFzlnax8rSQWSA	886	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PR2GOpldAnNtyB2DRLsE9g
872		887
873	__PACKAGE__->add_columns(	888	__PACKAGE__->add_columns(
874	'+pickup_location' => { is_boolean => 1 },	889	'+pickup_location' => { is_boolean => 1 },

Lines 103-113 any comments related to the transfer Link Here

(-)a/Koha/Schema/Result/Branchtransfer.pm (-6 / +5 lines)
103	=head2 reason	103	=head2 reason
104		104
105	data_type: 'enum'	105	data_type: 'enum'
106	extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve","TransferCancellation"]}	106	extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve","Recall","CancelRecall"]}
107	is_nullable: 1	107	is_nullable: 1
108		108
109	what triggered the transfer
110
111	=head2 cancellation_reason	109	=head2 cancellation_reason
112		110
113	data_type: 'enum'	111	data_type: 'enum'
Lines 185-191 __PACKAGE__->add_columns( Link Here
185	"Reserve",	183	"Reserve",
186	"LostReserve",	184	"LostReserve",
187	"CancelReserve",	185	"CancelReserve",
188	"TransferCancellation",	186	"Recall",
		187	"CancelRecall",
189	],	188	],
190	},	189	},
191	is_nullable => 1,	190	is_nullable => 1,
Lines 272-279 __PACKAGE__->belongs_to( Link Here
272	);	271	);
273		272
274		273
275	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-06-08 08:13:08	274	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-10-14 15:07:03
276	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+ABUZOo6IHbiRH1LTy3t+A	275	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:APOPxPO4uRpPHgSEhXbnTw
277		276
278	sub koha_object_class {	277	sub koha_object_class {
279	'Koha::Item::Transfer';	278	'Koha::Item::Transfer';

Lines 789-794 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Item.pm (-2 / +17 lines)
789	{ cascade_copy => 0, cascade_delete => 0 },	789	{ cascade_copy => 0, cascade_delete => 0 },
790	);	790	);
791		791
		792	=head2 recalls
		793
		794	Type: has_many
		795
		796	Related object: L<Koha::Schema::Result::Recall>
		797
		798	=cut
		799
		800	__PACKAGE__->has_many(
		801	"recalls",
		802	"Koha::Schema::Result::Recall",
		803	{ "foreign.itemnumber" => "self.itemnumber" },
		804	{ cascade_copy => 0, cascade_delete => 0 },
		805	);
		806
792	=head2 reserves	807	=head2 reserves
793		808
794	Type: has_many	809	Type: has_many
Lines 865-872 __PACKAGE__->has_many( Link Here
865	);	880	);
866		881
867		882
868	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-08-27 08:42:21	883	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-10-14 15:07:03
869	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SjZn3haOtUZWu1jrMigjNQ	884	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yRbholcHil9qRF5t+83jdA
870		885
871	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );	886	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
872		887

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 @ 2021-10-14 15:07:03
269	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3OJBkRJzqxZpuRp0GYGixw
270
271
272	# You can replace this text with custom code or comments, and it will be preserved on regeneration
273	1;