Attachment #174382 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 subscriptions

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-11-11 15:30:10
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c2KX3rFyF5f3ISRpCXrLVA

__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-11-11 15:30:10
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qaiJdkKP05sr/Xw7Ec/nxA

__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

=head2 match_field

  data_type: 'varchar'
  is_nullable: 1
  size: 10

the field that a vendor account has been mapped to in a marc record

=head2 match_value

  data_type: 'varchar'
  is_nullable: 1
  size: 50

the value to be matched against the marc record

=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 },
  "match_field",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "match_value",
  { 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-11-11 15:30:10
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fbpPZlp8dGbDfmdsYTW0GQ

__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 subscriptions	512	=head2 subscriptions
498		513
499	Type: has_many	514	Type: has_many
Lines 525-532 __PACKAGE__->has_many( Link Here
525	);	540	);
526		541
527		542
528	# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-11-11 14:57:58	543	# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-11-11 15:30:10
529	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+pD8f2kCNELUE8Ns/kabog	544	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c2KX3rFyF5f3ISRpCXrLVA
530		545
531	__PACKAGE__->add_columns(	546	__PACKAGE__->add_columns(
532	'+active' => { is_boolean => 1 },	547	'+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-11-11 15:30:10
348	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5solU2GxDRyXxtWgpbcGVQ	363	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qaiJdkKP05sr/Xw7Ec/nxA
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 / +231 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	=head2 match_field
120
121	data_type: 'varchar'
122	is_nullable: 1
123	size: 10
124
125	the field that a vendor account has been mapped to in a marc record
126
127	=head2 match_value
128
129	data_type: 'varchar'
130	is_nullable: 1
131	size: 50
132
133	the value to be matched against the marc record
134
135	=cut
136
137	__PACKAGE__->add_columns(
138	"id",
139	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
140	"description",
141	{ data_type => "varchar", is_nullable => 0, size => 250 },
142	"vendor_id",
143	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
144	"budget_id",
145	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
146	"download_directory",
147	{ data_type => "mediumtext", is_nullable => 1 },
148	"matcher_id",
149	{ data_type => "integer", is_nullable => 1 },
150	"overlay_action",
151	{ data_type => "varchar", is_nullable => 1, size => 50 },
152	"nomatch_action",
153	{ data_type => "varchar", is_nullable => 1, size => 50 },
154	"item_action",
155	{ data_type => "varchar", is_nullable => 1, size => 50 },
156	"parse_items",
157	{ data_type => "tinyint", is_nullable => 1 },
158	"record_type",
159	{ data_type => "varchar", is_nullable => 1, size => 50 },
160	"encoding",
161	{ data_type => "varchar", is_nullable => 1, size => 50 },
162	"match_field",
163	{ data_type => "varchar", is_nullable => 1, size => 10 },
164	"match_value",
165	{ data_type => "varchar", is_nullable => 1, size => 50 },
166	);
167
168	=head1 PRIMARY KEY
169
170	=over 4
171
172	=item * L</id>
173
174	=back
175
176	=cut
177
178	__PACKAGE__->set_primary_key("id");
179
180	=head1 RELATIONS
181
182	=head2 budget
183
184	Type: belongs_to
185
186	Related object: L<Koha::Schema::Result::Aqbudget>
187
188	=cut
189
190	__PACKAGE__->belongs_to(
191	"budget",
192	"Koha::Schema::Result::Aqbudget",
193	{ budget_id => "budget_id" },
194	{
195	is_deferrable => 1,
196	join_type => "LEFT",
197	on_delete => "CASCADE",
198	on_update => "CASCADE",
199	},
200	);
201
202	=head2 vendor
203
204	Type: belongs_to
205
206	Related object: L<Koha::Schema::Result::Aqbookseller>
207
208	=cut
209
210	__PACKAGE__->belongs_to(
211	"vendor",
212	"Koha::Schema::Result::Aqbookseller",
213	{ id => "vendor_id" },
214	{
215	is_deferrable => 1,
216	join_type => "LEFT",
217	on_delete => "CASCADE",
218	on_update => "CASCADE",
219	},
220	);
221
222
223	# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-11-11 15:30:10
224	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fbpPZlp8dGbDfmdsYTW0GQ
225
226	__PACKAGE__->add_columns(
227	'+parse_items' => { is_boolean => 1 },
228	);
229
230	# You can replace this text with custom code or comments, and it will be preserved on regeneration
231	1;