Attachment #174363 for bug #34355

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




  },
);

=head2 marc_order_accounts

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "marc_order_accounts",
  "Koha::Schema::Result::MarcOrderAccount",
  { "foreign.vendor_id" => "self.id" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 vendor_edi_accounts

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-07-31 11:04:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SIwFJFXaOTOGPs2AS27bHQ

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




  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 marc_order_accounts

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "marc_order_accounts",
  "Koha::Schema::Result::MarcOrderAccount",
  { "foreign.budget_id" => "self.budget_id" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 suggestions

Type: has_many

__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-07-31 11:04:04
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DCCt9sdoDfla/gzWSQC02Q

__PACKAGE__->belongs_to(
  "budget",




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

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

=head1 NAME

Koha::Schema::Result::MarcOrderAccount

=cut

use strict;
use warnings;

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

=head1 TABLE: C<marc_order_accounts>

=cut

__PACKAGE__->table("marc_order_accounts");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique identifier and primary key

=head2 description

  data_type: 'varchar'
  is_nullable: 0
  size: 250

description of this account

=head2 vendor_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

vendor id for this account

=head2 budget_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

budget id for this account

=head2 download_directory

  data_type: 'mediumtext'
  is_nullable: 1

download directory for this account

=head2 matcher_id

  data_type: 'integer'
  is_nullable: 1

the id of the match rule used (matchpoints.matcher_id)

=head2 overlay_action

  data_type: 'varchar'
  is_nullable: 1
  size: 50

how to handle duplicate records

=head2 nomatch_action

  data_type: 'varchar'
  is_nullable: 1
  size: 50

how to handle records where no match is found

=head2 item_action

  data_type: 'varchar'
  is_nullable: 1
  size: 50

what to do with item records

=head2 parse_items

  data_type: 'tinyint'
  is_nullable: 1

should items be parsed

=head2 record_type

  data_type: 'varchar'
  is_nullable: 1
  size: 50

type of record in the file

=head2 encoding

  data_type: 'varchar'
  is_nullable: 1
  size: 50

file encoding

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "description",
  { data_type => "varchar", is_nullable => 0, size => 250 },
  "vendor_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "budget_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "download_directory",
  { data_type => "mediumtext", is_nullable => 1 },
  "matcher_id",
  { data_type => "integer", is_nullable => 1 },
  "overlay_action",
  { data_type => "varchar", is_nullable => 1, size => 50 },
  "nomatch_action",
  { data_type => "varchar", is_nullable => 1, size => 50 },
  "item_action",
  { data_type => "varchar", is_nullable => 1, size => 50 },
  "parse_items",
  { data_type => "tinyint", is_nullable => 1 },
  "record_type",
  { data_type => "varchar", is_nullable => 1, size => 50 },
  "encoding",
  { data_type => "varchar", is_nullable => 1, size => 50 },
);

=head1 PRIMARY KEY

=over 4

=item * L</id>

=back

=cut

__PACKAGE__->set_primary_key("id");

=head1 RELATIONS

=head2 budget

Type: belongs_to

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

=cut

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

=head2 vendor

Type: belongs_to

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

=cut

__PACKAGE__->belongs_to(
  "vendor",
  "Koha::Schema::Result::Aqbookseller",
  { id => "vendor_id" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-07-31 13:01:54
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Fz6iYOJIQLrlYvAnmW6C4A

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

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

Return to bug 34355

Lines 494-499 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/Aqbookseller.pm (-2 / +17 lines)
494	},	494	},
495	);	495	);
496		496
		497	=head2 marc_order_accounts
		498
		499	Type: has_many
		500
		501	Related object: L<Koha::Schema::Result::MarcOrderAccount>
		502
		503	=cut
		504
		505	__PACKAGE__->has_many(
		506	"marc_order_accounts",
		507	"Koha::Schema::Result::MarcOrderAccount",
		508	{ "foreign.vendor_id" => "self.id" },
		509	{ cascade_copy => 0, cascade_delete => 0 },
		510	);
		511
497	=head2 vendor_edi_accounts	512	=head2 vendor_edi_accounts
498		513
499	Type: has_many	514	Type: has_many
Lines 510-517 __PACKAGE__->has_many( Link Here
510	);	525	);
511		526
512		527
513	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-06-30 09:54:35	528	# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-07-31 11:04:04
514	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xjeOqpcdN3Kb1wmLGDjzLg	529	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SIwFJFXaOTOGPs2AS27bHQ
515		530
516	__PACKAGE__->add_columns(	531	__PACKAGE__->add_columns(
517	'+active' => { is_boolean => 1 },	532	'+active' => { is_boolean => 1 },

Lines 303-308 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/Aqbudget.pm (-2 / +17 lines)
303	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },	303	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
304	);	304	);
305		305
		306	=head2 marc_order_accounts
		307
		308	Type: has_many
		309
		310	Related object: L<Koha::Schema::Result::MarcOrderAccount>
		311
		312	=cut
		313
		314	__PACKAGE__->has_many(
		315	"marc_order_accounts",
		316	"Koha::Schema::Result::MarcOrderAccount",
		317	{ "foreign.budget_id" => "self.budget_id" },
		318	{ cascade_copy => 0, cascade_delete => 0 },
		319	);
		320
306	=head2 suggestions	321	=head2 suggestions
307		322
308	Type: has_many	323	Type: has_many
Lines 344-351 Composing rels: L</aqbudgetborrowers> -> borrowernumber Link Here
344	__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");	359	__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
345		360
346		361
347	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-04-19 17:02:59	362	# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-07-31 11:04:04
348	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5solU2GxDRyXxtWgpbcGVQ	363	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DCCt9sdoDfla/gzWSQC02Q
349		364
350	__PACKAGE__->belongs_to(	365	__PACKAGE__->belongs_to(
351	"budget",	366	"budget",

Line 0 Link Here

(-)a/Koha/Schema/Result/MarcOrderAccount.pm (-1 / +211 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::MarcOrderAccount;
		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::MarcOrderAccount
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<marc_order_accounts>
		19
		20	=cut
		21
		22	__PACKAGE__->table("marc_order_accounts");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	unique identifier and primary key
		33
		34	=head2 description
		35
		36	data_type: 'varchar'
		37	is_nullable: 0
		38	size: 250
		39
		40	description of this account
		41
		42	=head2 vendor_id
		43
		44	data_type: 'integer'
		45	is_foreign_key: 1
		46	is_nullable: 1
		47
		48	vendor id for this account
		49
		50	=head2 budget_id
		51
		52	data_type: 'integer'
		53	is_foreign_key: 1
		54	is_nullable: 1
		55
		56	budget id for this account
		57
		58	=head2 download_directory
		59
		60	data_type: 'mediumtext'
		61	is_nullable: 1
		62
		63	download directory for this account
		64
		65	=head2 matcher_id
66
67	data_type: 'integer'
68	is_nullable: 1
69
70	the id of the match rule used (matchpoints.matcher_id)
71
72	=head2 overlay_action
73
74	data_type: 'varchar'
75	is_nullable: 1
76	size: 50
77
78	how to handle duplicate records
79
80	=head2 nomatch_action
81
82	data_type: 'varchar'
83	is_nullable: 1
84	size: 50
85
86	how to handle records where no match is found
87
88	=head2 item_action
89
90	data_type: 'varchar'
91	is_nullable: 1
92	size: 50
93
94	what to do with item records
95
96	=head2 parse_items
97
98	data_type: 'tinyint'
99	is_nullable: 1
100
101	should items be parsed
102
103	=head2 record_type
104
105	data_type: 'varchar'
106	is_nullable: 1
107	size: 50
108
109	type of record in the file
110
111	=head2 encoding
112
113	data_type: 'varchar'
114	is_nullable: 1
115	size: 50
116
117	file encoding
118
119	=cut
120
121	__PACKAGE__->add_columns(
122	"id",
123	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
124	"description",
125	{ data_type => "varchar", is_nullable => 0, size => 250 },
126	"vendor_id",
127	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
128	"budget_id",
129	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
130	"download_directory",
131	{ data_type => "mediumtext", is_nullable => 1 },
132	"matcher_id",
133	{ data_type => "integer", is_nullable => 1 },
134	"overlay_action",
135	{ data_type => "varchar", is_nullable => 1, size => 50 },
136	"nomatch_action",
137	{ data_type => "varchar", is_nullable => 1, size => 50 },
138	"item_action",
139	{ data_type => "varchar", is_nullable => 1, size => 50 },
140	"parse_items",
141	{ data_type => "tinyint", is_nullable => 1 },
142	"record_type",
143	{ data_type => "varchar", is_nullable => 1, size => 50 },
144	"encoding",
145	{ data_type => "varchar", is_nullable => 1, size => 50 },
146	);
147
148	=head1 PRIMARY KEY
149
150	=over 4
151
152	=item * L</id>
153
154	=back
155
156	=cut
157
158	__PACKAGE__->set_primary_key("id");
159
160	=head1 RELATIONS
161
162	=head2 budget
163
164	Type: belongs_to
165
166	Related object: L<Koha::Schema::Result::Aqbudget>
167
168	=cut
169
170	__PACKAGE__->belongs_to(
171	"budget",
172	"Koha::Schema::Result::Aqbudget",
173	{ budget_id => "budget_id" },
174	{
175	is_deferrable => 1,
176	join_type => "LEFT",
177	on_delete => "CASCADE",
178	on_update => "CASCADE",
179	},
180	);
181
182	=head2 vendor
183
184	Type: belongs_to
185
186	Related object: L<Koha::Schema::Result::Aqbookseller>
187
188	=cut
189
190	__PACKAGE__->belongs_to(
191	"vendor",
192	"Koha::Schema::Result::Aqbookseller",
193	{ id => "vendor_id" },
194	{
195	is_deferrable => 1,
196	join_type => "LEFT",
197	on_delete => "CASCADE",
198	on_update => "CASCADE",
199	},
200	);
201
202
203	# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-07-31 13:01:54
204	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Fz6iYOJIQLrlYvAnmW6C4A
205
206	__PACKAGE__->add_columns(
207	'+parse_items' => { is_boolean => 1 },
208	);
209
210	# You can replace this text with custom code or comments, and it will be preserved on regeneration
211	1;