Attachment #81550 for bug #19532

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




package Koha::Old::Recall;

# Copyright 2017 Aleisha Amohia <aleisha@catalyst.net.nz>
#
# This file is part of Koha.
#
# Koha is free software; you can redistribute it and/or modify it under the
# terms of the GNU General Public License as published by the Free Software
# Foundation; either version 3 of the License, or (at your option) any later
# version.
#
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with Koha; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

use Modern::Perl;

use Koha::Database;

use base qw( Koha::Object );

=head1 NAME

Koha::Old::Recall - Koha Old Recall Object class

=head1 API

=head2 Class Methods

=cut

=head3 type

=cut

sub type {
    return 'OldRecall';
}

=head1 AUTHOR

Aleisha Amohia <aleisha@catalyst.net.nz>
Catalyst IT

=cut

1;




package Koha::Old::Recalls;

# Copyright 2017 Aleisha Amohia <aleisha@catalyst.net.nz>
#
# This file is part of Koha.
#
# Koha is free software; you can redistribute it and/or modify it under the
# terms of the GNU General Public License as published by the Free Software
# Foundation; either version 3 of the License, or (at your option) any later
# version.
#
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with Koha; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

use Modern::Perl;

use Koha::Database;
use Koha::Old::Recall;

use base qw( Koha::Objects );

=head1 NAME

Koha::Old::Recalls - Koha Old Recalls Object Set class

=head1 API

=head2 Class Methods

=cut

=head3 type

=cut

sub type {
    return 'OldRecall';
}

=head3 object_class

=cut

sub object_class {
    return 'Koha::Old::Recall';
}

=head1 AUTHOR

Aleisha Amohia <aleisha@catalyst.net.nz>
Catalyst IT

=cut

1;




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

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

=head1 NAME

Koha::Schema::Result::OldRecall

=cut

use strict;
use warnings;

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

=head1 TABLE: C<old_recalls>

=cut

__PACKAGE__->table("old_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: 1

=head2 recalldate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 biblionumber

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

=head2 branchcode

  data_type: 'varchar'
  is_nullable: 1
  size: 10

=head2 cancellationdate

  data_type: 'date'
  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 found

  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: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 expirationdate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 itemtype

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

=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    => 1,
  },
  "recalldate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "biblionumber",
  {
    data_type      => "integer",
    default_value  => 0,
    is_foreign_key => 1,
    is_nullable    => 1,
  },
  "branchcode",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "cancellationdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "recallnotes",
  { data_type => "mediumtext", is_nullable => 1 },
  "priority",
  { data_type => "smallint", is_nullable => 1 },
  "found",
  { 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 => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "expirationdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "itemtype",
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
);

=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,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "SET NULL",
  },
);

=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,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "SET NULL",
  },
);

=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     => "SET NULL",
    on_update     => "SET NULL",
  },
);

=head2 itemtype

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "itemtype",
  "Koha::Schema::Result::Itemtype",
  { itemtype => "itemtype" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "SET NULL",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-25 23:50:29
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:afOsAbeAPcdHR79LfYH9Hg


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

Lines 72-78 __PACKAGE__->table("recalls"); Link Here

(-)a/Koha/Schema/Result/Recall.pm (-5 / +11 lines)
72	data_type: 'smallint'	72	data_type: 'smallint'
73	is_nullable: 1	73	is_nullable: 1
74		74
75	=head2 found	75	=head2 status
76		76
77	data_type: 'varchar'	77	data_type: 'varchar'
78	is_nullable: 1	78	is_nullable: 1
Lines 110-115 __PACKAGE__->table("recalls"); Link Here
110	is_nullable: 1	110	is_nullable: 1
111	size: 10	111	size: 10
112		112
		113	=head2 old
		114
		115	data_type: 'integer'
		116	is_nullable: 1
		117
113	=cut	118	=cut
114		119
115	__PACKAGE__->add_columns(	120	__PACKAGE__->add_columns(
Lines 139-145 __PACKAGE__->add_columns( Link Here
139	{ data_type => "mediumtext", is_nullable => 1 },	144	{ data_type => "mediumtext", is_nullable => 1 },
140	"priority",	145	"priority",
141	{ data_type => "smallint", is_nullable => 1 },	146	{ data_type => "smallint", is_nullable => 1 },
142	"found",	147	"status",
143	{ data_type => "varchar", is_nullable => 1, size => 1 },	148	{ data_type => "varchar", is_nullable => 1, size => 1 },
144	"timestamp",	149	"timestamp",
145	{	150	{
Lines 156-161 __PACKAGE__->add_columns( Link Here
156	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	161	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
157	"itemtype",	162	"itemtype",
158	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },	163	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
		164	"old",
		165	{ data_type => "integer", is_nullable => 1 },
159	);	166	);
160		167
161	=head1 PRIMARY KEY	168	=head1 PRIMARY KEY
Lines 263-270 __PACKAGE__->belongs_to( Link Here
263	);	270	);
264		271
265		272
266	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-25 23:50:29	273	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-26 21:41:54
267	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0dtkOcX0Cuc8MdpKxhcPUA	274	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xfJWg4QPl54jccP/p991LA
268		275
269		276
270	# You can replace this text with custom code or comments, and it will be preserved on regeneration	277	# You can replace this text with custom code or comments, and it will be preserved on regeneration
271	-

Return to bug 19532

Lines 1-51 Link Here

(-)a/Koha/Old/Recall.pm (-51 lines)
1	package Koha::Old::Recall;
2
3	# Copyright 2017 Aleisha Amohia <aleisha@catalyst.net.nz>
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 3 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	use Modern::Perl;
21
22	use Koha::Database;
23
24	use base qw( Koha::Object );
25
26	=head1 NAME
27
28	Koha::Old::Recall - Koha Old Recall Object class
29
30	=head1 API
31
32	=head2 Class Methods
33
34	=cut
35
36	=head3 type
37
38	=cut
39
40	sub type {
41	return 'OldRecall';
42	}
43
44	=head1 AUTHOR
45
46	Aleisha Amohia <aleisha@catalyst.net.nz>
47	Catalyst IT
48
49	=cut
50
51	1;

Lines 1-60 Link Here

(-)a/Koha/Old/Recalls.pm (-60 lines)
1	package Koha::Old::Recalls;
2
3	# Copyright 2017 Aleisha Amohia <aleisha@catalyst.net.nz>
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 3 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	use Modern::Perl;
21
22	use Koha::Database;
23	use Koha::Old::Recall;
24
25	use base qw( Koha::Objects );
26
27	=head1 NAME
28
29	Koha::Old::Recalls - Koha Old Recalls Object Set class
30
31	=head1 API
32
33	=head2 Class Methods
34
35	=cut
36
37	=head3 type
38
39	=cut
40
41	sub type {
42	return 'OldRecall';
43	}
44
45	=head3 object_class
46
47	=cut
48
49	sub object_class {
50	return 'Koha::Old::Recall';
51	}
52
53	=head1 AUTHOR
54
55	Aleisha Amohia <aleisha@catalyst.net.nz>
56	Catalyst IT
57
58	=cut
59
60	1;

Lines 1-260 Link Here

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