2 package Koha::Schema::Result::Aqbudget;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Aqbudget
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<aqbudgets>
22 __PACKAGE__->table("aqbudgets");
32 primary key and unique number assigned to each fund by Koha
34 =head2 budget_parent_id
39 if this fund is a child of another this will include the parent id (aqbudgets.budget_id)
47 code assigned to the fund by the user
55 name assigned to the fund by the user
57 =head2 budget_branchcode
63 branch that this fund belongs to (branches.branchcode)
68 default_value: 0.000000
72 total amount for this fund
77 default_value: 0.000000
81 budget warning at percentage
86 default_value: 0.000000
90 budget warning at amount
97 notes related to this fund
101 data_type: 'timestamp'
102 datetime_undef_if_invalid: 1
103 default_value: current_timestamp
106 date and time this fund was last touched (created or modified)
108 =head2 budget_period_id
114 id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id)
122 statistical category for this fund
130 second statistical category for this fund
132 =head2 budget_owner_id
137 borrowernumber of the person who owns this fund (borrowers.borrowernumber)
139 =head2 budget_permission
145 level of permission for this fund (used only by the owner, only by the library, or anyone)
149 __PACKAGE__->add_columns(
151 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
153 { data_type => "integer", is_nullable => 1 },
155 { data_type => "varchar", is_nullable => 1, size => 30 },
157 { data_type => "varchar", is_nullable => 1, size => 80 },
159 { data_type => "varchar", is_nullable => 1, size => 10 },
162 data_type => "decimal",
163 default_value => "0.000000",
169 data_type => "decimal",
170 default_value => "0.000000",
176 data_type => "decimal",
177 default_value => "0.000000",
182 { data_type => "longtext", is_nullable => 1 },
185 data_type => "timestamp",
186 datetime_undef_if_invalid => 1,
187 default_value => \"current_timestamp",
191 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
193 { data_type => "varchar", is_nullable => 1, size => 80 },
195 { data_type => "varchar", is_nullable => 1, size => 80 },
197 { data_type => "integer", is_nullable => 1 },
199 { data_type => "integer", default_value => 0, is_nullable => 1 },
206 =item * L</budget_id>
212 __PACKAGE__->set_primary_key("budget_id");
216 =head2 aqbudgetborrowers
220 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
224 __PACKAGE__->has_many(
226 "Koha::Schema::Result::Aqbudgetborrower",
227 { "foreign.budget_id" => "self.budget_id" },
228 { cascade_copy => 0, cascade_delete => 0 },
231 =head2 aqbudgets_plannings
235 Related object: L<Koha::Schema::Result::AqbudgetsPlanning>
239 __PACKAGE__->has_many(
240 "aqbudgets_plannings",
241 "Koha::Schema::Result::AqbudgetsPlanning",
242 { "foreign.budget_id" => "self.budget_id" },
243 { cascade_copy => 0, cascade_delete => 0 },
246 =head2 aqinvoice_adjustments
250 Related object: L<Koha::Schema::Result::AqinvoiceAdjustment>
254 __PACKAGE__->has_many(
255 "aqinvoice_adjustments",
256 "Koha::Schema::Result::AqinvoiceAdjustment",
257 { "foreign.budget_id" => "self.budget_id" },
258 { cascade_copy => 0, cascade_delete => 0 },
265 Related object: L<Koha::Schema::Result::Aqinvoice>
269 __PACKAGE__->has_many(
271 "Koha::Schema::Result::Aqinvoice",
272 { "foreign.shipmentcost_budgetid" => "self.budget_id" },
273 { cascade_copy => 0, cascade_delete => 0 },
280 Related object: L<Koha::Schema::Result::Aqorder>
284 __PACKAGE__->has_many(
286 "Koha::Schema::Result::Aqorder",
287 { "foreign.budget_id" => "self.budget_id" },
288 { cascade_copy => 0, cascade_delete => 0 },
295 Related object: L<Koha::Schema::Result::Aqbudgetperiod>
299 __PACKAGE__->belongs_to(
301 "Koha::Schema::Result::Aqbudgetperiod",
302 { budget_period_id => "budget_period_id" },
306 on_delete => "CASCADE",
307 on_update => "CASCADE",
315 Related object: L<Koha::Schema::Result::Suggestion>
319 __PACKAGE__->has_many(
321 "Koha::Schema::Result::Suggestion",
322 { "foreign.budgetid" => "self.budget_id" },
323 { cascade_copy => 0, cascade_delete => 0 },
326 =head2 vendor_edi_accounts
330 Related object: L<Koha::Schema::Result::VendorEdiAccount>
334 __PACKAGE__->has_many(
335 "vendor_edi_accounts",
336 "Koha::Schema::Result::VendorEdiAccount",
337 { "foreign.shipment_budget" => "self.budget_id" },
338 { cascade_copy => 0, cascade_delete => 0 },
341 =head2 borrowernumbers
345 Composing rels: L</aqbudgetborrowers> -> borrowernumber
349 __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
352 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
353 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sl+TGQXY85UWwS+Ld/vvyQ
355 __PACKAGE__->belongs_to(
357 "Koha::Schema::Result::Aqbudgetperiod",
358 { "foreign.budget_period_id" => "self.budget_period_id" },
359 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
362 sub koha_object_class {
363 'Koha::Acquisition::Fund';
365 sub koha_objects_class {
366 'Koha::Acquisition::Funds';