Attachment #102422 for bug #25037

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




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

=head2 issues

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "issues",
  "Koha::Schema::Result::Issue",
  { "foreign.checkout_type" => "self.authorised_value" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 old_issues

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "old_issues",
  "Koha::Schema::Result::OldIssue",
  { "foreign.checkout_type" => "self.authorised_value" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-01 16:24:27
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3/nSpPKD664Mmv6ce/Y1pA


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

Lines 96-106 __PACKAGE__->table("issues"); Link Here

(-)a/Koha/Schema/Result/Issue.pm (-9 / +36 lines)
96	datetime_undef_if_invalid: 1	96	datetime_undef_if_invalid: 1
97	is_nullable: 1	97	is_nullable: 1
98		98
99	=head2 onsite_checkout	99	=head2 checkout_type
100		100
101	data_type: 'integer'	101	data_type: 'varchar'
102	default_value: 0	102	default_value: 'C'
103	is_nullable: 0	103	is_foreign_key: 1
		104	is_nullable: 1
		105	size: 80
104		106
105	=head2 note	107	=head2 note
106		108
Lines 166-173 __PACKAGE__->add_columns( Link Here
166	datetime_undef_if_invalid => 1,	168	datetime_undef_if_invalid => 1,
167	is_nullable => 1,	169	is_nullable => 1,
168	},	170	},
169	"onsite_checkout",	171	"checkout_type",
170	{ data_type => "integer", default_value => 0, is_nullable => 0 },	172	{
		173	data_type => "varchar",
		174	default_value => "C",
		175	is_foreign_key => 1,
		176	is_nullable => 1,
		177	size => 80,
		178	},
171	"note",	179	"note",
172	{ data_type => "longtext", is_nullable => 1 },	180	{ data_type => "longtext", is_nullable => 1 },
173	"notedate",	181	"notedate",
Lines 228-233 __PACKAGE__->belongs_to( Link Here
228	},	236	},
229	);	237	);
230		238
		239	=head2 checkout_type
		240
		241	Type: belongs_to
		242
		243	Related object: L<Koha::Schema::Result::AuthorisedValue>
		244
		245	=cut
		246
		247	__PACKAGE__->belongs_to(
		248	"checkout_type",
		249	"Koha::Schema::Result::AuthorisedValue",
		250	{ authorised_value => "checkout_type" },
		251	{
		252	is_deferrable => 1,
		253	join_type => "LEFT",
		254	on_delete => "SET NULL",
		255	on_update => "CASCADE",
		256	},
		257	);
		258
231	=head2 itemnumber	259	=head2 itemnumber
232		260
233	Type: belongs_to	261	Type: belongs_to
Lines 264-275 __PACKAGE__->might_have( Link Here
264	);	292	);
265		293
266		294
267	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-31 12:18:38	295	# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-05 20:13:49
268	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QVmFa5b0Pe5OhUI92n9kzQ	296	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:utJ0C/oqCqQTAKmso8GP2A
269		297
270	__PACKAGE__->add_columns(	298	__PACKAGE__->add_columns(
271	'+auto_renew' => { is_boolean => 1 },	299	'+auto_renew' => { is_boolean => 1 },
272	'+onsite_checkout' => { is_boolean => 1 }
273	);	300	);
274		301
275	__PACKAGE__->belongs_to(	302	__PACKAGE__->belongs_to(




  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 checkout_type

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

=head2 note


    datetime_undef_if_invalid => 1,
    is_nullable => 1,
  },
  "checkout_type",
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
  "note",
  { data_type => "longtext", is_nullable => 1 },
  "notedate",

  },
);

=head2 checkout_type

Type: belongs_to

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

=cut

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

=head2 itemnumber

Type: belongs_to

);


# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-01 16:24:27
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LQNWHEvYKH767RYxYfYPHw

__PACKAGE__->add_columns(
    '+auto_renew'      => { is_boolean => 1 },
    '+onsite_checkout' => { is_boolean => 1 }
);

__PACKAGE__->belongs_to(
- 

Return to bug 25037

Lines 144-152 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/AuthorisedValue.pm (-2 / +32 lines)
144	{ cascade_copy => 0, cascade_delete => 0 },	144	{ cascade_copy => 0, cascade_delete => 0 },
145	);	145	);
146		146
		147	=head2 issues
147		148
148	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-02-22 14:32:48	149	Type: has_many
149	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hDlebhEn+f+thqwBo/LOqQ	150
		151	Related object: L<Koha::Schema::Result::Issue>
		152
		153	=cut
		154
		155	__PACKAGE__->has_many(
		156	"issues",
		157	"Koha::Schema::Result::Issue",
		158	{ "foreign.checkout_type" => "self.authorised_value" },
		159	{ cascade_copy => 0, cascade_delete => 0 },
		160	);
		161
		162	=head2 old_issues
		163
		164	Type: has_many
		165
		166	Related object: L<Koha::Schema::Result::OldIssue>
		167
		168	=cut
		169
		170	__PACKAGE__->has_many(
		171	"old_issues",
		172	"Koha::Schema::Result::OldIssue",
		173	{ "foreign.checkout_type" => "self.authorised_value" },
		174	{ cascade_copy => 0, cascade_delete => 0 },
		175	);
		176
		177
		178	# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-01 16:24:27
		179	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3/nSpPKD664Mmv6ce/Y1pA
150		180
151		181
152	# You can replace this text with custom code or comments, and it will be preserved on regeneration	182	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 95-105 __PACKAGE__->table("old_issues"); Link Here

(-)a/Koha/Schema/Result/OldIssue.pm (-10 / +29 lines)
95	datetime_undef_if_invalid: 1	95	datetime_undef_if_invalid: 1
96	is_nullable: 1	96	is_nullable: 1
97		97
98	=head2 onsite_checkout	98	=head2 checkout_type
99		99
100	data_type: 'integer'	100	data_type: 'varchar'
101	default_value: 0	101	is_foreign_key: 1
102	is_nullable: 0	102	is_nullable: 1
		103	size: 80
103		104
104	=head2 note	105	=head2 note
105		106
Lines 165-172 __PACKAGE__->add_columns( Link Here
165	datetime_undef_if_invalid => 1,	166	datetime_undef_if_invalid => 1,
166	is_nullable => 1,	167	is_nullable => 1,
167	},	168	},
168	"onsite_checkout",	169	"checkout_type",
169	{ data_type => "integer", default_value => 0, is_nullable => 0 },	170	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
170	"note",	171	"note",
171	{ data_type => "longtext", is_nullable => 1 },	172	{ data_type => "longtext", is_nullable => 1 },
172	"notedate",	173	"notedate",
Lines 213-218 __PACKAGE__->belongs_to( Link Here
213	},	214	},
214	);	215	);
215		216
		217	=head2 checkout_type
		218
		219	Type: belongs_to
		220
		221	Related object: L<Koha::Schema::Result::AuthorisedValue>
		222
		223	=cut
		224
		225	__PACKAGE__->belongs_to(
		226	"checkout_type",
		227	"Koha::Schema::Result::AuthorisedValue",
		228	{ authorised_value => "checkout_type" },
		229	{
		230	is_deferrable => 1,
		231	join_type => "LEFT",
		232	on_delete => "SET NULL",
		233	on_update => "CASCADE",
		234	},
		235	);
		236
216	=head2 itemnumber	237	=head2 itemnumber
217		238
218	Type: belongs_to	239	Type: belongs_to
Lines 234-245 __PACKAGE__->belongs_to( Link Here
234	);	255	);
235		256
236		257
237	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-10 19:55:44	258	# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-01 16:24:27
238	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E2N2paWcCHg916100ry+2A	259	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LQNWHEvYKH767RYxYfYPHw
239		260
240	__PACKAGE__->add_columns(	261	__PACKAGE__->add_columns(
241	'+auto_renew' => { is_boolean => 1 },	262	'+auto_renew' => { is_boolean => 1 },
242	'+onsite_checkout' => { is_boolean => 1 }
243	);	263	);
244		264
245	__PACKAGE__->belongs_to(	265	__PACKAGE__->belongs_to(
246	-