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

(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
Lines 905-910 __PACKAGE__->has_many( Link Here
905
  { cascade_copy => 0, cascade_delete => 0 },
905
  { cascade_copy => 0, cascade_delete => 0 },
906
);
906
);
907
907
908
=head2 reports_branches
909
910
Type: has_many
911
912
Related object: L<Koha::Schema::Result::ReportsBranch>
913
914
=cut
915
916
__PACKAGE__->has_many(
917
  "reports_branches",
918
  "Koha::Schema::Result::ReportsBranch",
919
  { "foreign.branchcode" => "self.branchcode" },
920
  { cascade_copy => 0, cascade_delete => 0 },
921
);
922
908
=head2 reserves
923
=head2 reserves
909
924
910
Type: has_many
925
Type: has_many
Lines 996-1003 __PACKAGE__->has_many( Link Here
996
);
1011
);
997
1012
998
1013
999
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-03 13:13:25
1014
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-08-25 23:49:56
1000
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HiH1QNlDqKcq9GeM85Pu0A
1015
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FzlapmLTM+K9Lh7Fq4BwdQ
1001
1016
1002
__PACKAGE__->has_many(
1017
__PACKAGE__->has_many(
1003
    "additional_field_values",
1018
    "additional_field_values",
(-)a/Koha/Schema/Result/ReportsBranch.pm (+85 lines)
Line 0 Link Here
1
use utf8;
2
package Koha::Schema::Result::ReportsBranch;
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::ReportsBranch
10
11
=cut
12
13
use strict;
14
use warnings;
15
16
use base 'DBIx::Class::Core';
17
18
=head1 TABLE: C<reports_branches>
19
20
=cut
21
22
__PACKAGE__->table("reports_branches");
23
24
=head1 ACCESSORS
25
26
=head2 report_id
27
28
  data_type: 'integer'
29
  is_foreign_key: 1
30
  is_nullable: 0
31
32
=head2 branchcode
33
34
  data_type: 'varchar'
35
  is_foreign_key: 1
36
  is_nullable: 0
37
  size: 10
38
39
=cut
40
41
__PACKAGE__->add_columns(
42
  "report_id",
43
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
44
  "branchcode",
45
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
46
);
47
48
=head1 RELATIONS
49
50
=head2 branchcode
51
52
Type: belongs_to
53
54
Related object: L<Koha::Schema::Result::Branch>
55
56
=cut
57
58
__PACKAGE__->belongs_to(
59
  "branchcode",
60
  "Koha::Schema::Result::Branch",
61
  { branchcode => "branchcode" },
62
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
63
);
64
65
=head2 report
66
67
Type: belongs_to
68
69
Related object: L<Koha::Schema::Result::SavedSql>
70
71
=cut
72
73
__PACKAGE__->belongs_to(
74
  "report",
75
  "Koha::Schema::Result::SavedSql",
76
  { id => "report_id" },
77
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
78
);
79
80
81
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2026-01-13 13:34:12
82
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LSVMHGqx1OhVm8DsYQprmg
83
84
# You can replace this text with custom code or comments, and it will be preserved on regeneration
85
1;
(-)a/Koha/Schema/Result/SavedSql.pm (-1 / +220 lines)
Lines 185-190 __PACKAGE__->add_columns( Link Here
185
185
186
__PACKAGE__->set_primary_key("id");
186
__PACKAGE__->set_primary_key("id");
187
187
188
=head1 RELATIONS
189
190
=head2 reports_branches
191
192
Type: has_many
193
194
Related object: L<Koha::Schema::Result::ReportsBranch>
195
196
=cut
197
198
__PACKAGE__->has_many(
199
  "reports_branches",
200
  "Koha::Schema::Result::ReportsBranch",
201
  { "foreign.report_id" => "self.id" },
202
  { cascade_copy => 0, cascade_delete => 0 },
203
);
204
205
206
# Created by DBIx::Class::Schema::Loader v0.07051 @ 2025-07-26 01:58:59
207
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:w7XKvOV/ylS6Dq8tsUNmSg
208
# These lines were loaded from '/kohadevbox/koha/Koha/Schema/Result/SavedSql.pm' found in @INC.
209
# They are now part of the custom portion of this file
210
# for you to hand-edit.  If you do not either delete
211
# this section or remove that file from @INC, this section
212
# will be repeated redundantly when you re-create this
213
# file again via Loader!  See skip_load_external to disable
214
# this feature.
215
216
use utf8;
217
package Koha::Schema::Result::SavedSql;
218
219
# Created by DBIx::Class::Schema::Loader
220
# DO NOT MODIFY THE FIRST PART OF THIS FILE
221
222
=head1 NAME
223
224
Koha::Schema::Result::SavedSql
225
226
=cut
227
228
use strict;
229
use warnings;
230
231
use base 'DBIx::Class::Core';
232
233
=head1 TABLE: C<saved_sql>
234
235
=cut
236
237
__PACKAGE__->table("saved_sql");
238
239
=head1 ACCESSORS
240
241
=head2 id
242
243
  data_type: 'integer'
244
  is_auto_increment: 1
245
  is_nullable: 0
246
247
unique id and primary key assigned by Koha
248
249
=head2 borrowernumber
250
251
  data_type: 'integer'
252
  is_nullable: 1
253
254
the staff member who created this report (borrowers.borrowernumber)
255
256
=head2 date_created
257
258
  data_type: 'datetime'
259
  datetime_undef_if_invalid: 1
260
  is_nullable: 1
261
262
the date this report was created
263
264
=head2 last_modified
265
266
  data_type: 'datetime'
267
  datetime_undef_if_invalid: 1
268
  is_nullable: 1
269
270
the date this report was last edited
271
272
=head2 savedsql
273
274
  data_type: 'mediumtext'
275
  is_nullable: 1
276
277
the SQL for this report
278
279
=head2 last_run
280
281
  data_type: 'datetime'
282
  datetime_undef_if_invalid: 1
283
  is_nullable: 1
284
285
=head2 report_name
286
287
  data_type: 'varchar'
288
  default_value: (empty string)
289
  is_nullable: 0
290
  size: 255
291
292
the name of this report
293
294
=head2 type
295
296
  data_type: 'varchar'
297
  is_nullable: 1
298
  size: 255
299
300
always 1 for tabular
301
302
=head2 notes
303
304
  data_type: 'mediumtext'
305
  is_nullable: 1
306
307
the notes or description given to this report
308
309
=head2 cache_expiry
310
311
  data_type: 'integer'
312
  default_value: 300
313
  is_nullable: 0
314
315
=head2 public
316
317
  data_type: 'tinyint'
318
  default_value: 0
319
  is_nullable: 0
320
321
=head2 report_area
322
323
  data_type: 'varchar'
324
  is_nullable: 1
325
  size: 6
326
327
=head2 report_group
328
329
  data_type: 'varchar'
330
  is_nullable: 1
331
  size: 80
332
333
=head2 report_subgroup
334
335
  data_type: 'varchar'
336
  is_nullable: 1
337
  size: 80
338
339
=head2 mana_id
340
341
  data_type: 'integer'
342
  is_nullable: 1
343
344
=cut
345
346
__PACKAGE__->add_columns(
347
  "id",
348
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
349
  "borrowernumber",
350
  { data_type => "integer", is_nullable => 1 },
351
  "date_created",
352
  {
353
    data_type => "datetime",
354
    datetime_undef_if_invalid => 1,
355
    is_nullable => 1,
356
  },
357
  "last_modified",
358
  {
359
    data_type => "datetime",
360
    datetime_undef_if_invalid => 1,
361
    is_nullable => 1,
362
  },
363
  "savedsql",
364
  { data_type => "mediumtext", is_nullable => 1 },
365
  "last_run",
366
  {
367
    data_type => "datetime",
368
    datetime_undef_if_invalid => 1,
369
    is_nullable => 1,
370
  },
371
  "report_name",
372
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
373
  "type",
374
  { data_type => "varchar", is_nullable => 1, size => 255 },
375
  "notes",
376
  { data_type => "mediumtext", is_nullable => 1 },
377
  "cache_expiry",
378
  { data_type => "integer", default_value => 300, is_nullable => 0 },
379
  "public",
380
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
381
  "report_area",
382
  { data_type => "varchar", is_nullable => 1, size => 6 },
383
  "report_group",
384
  { data_type => "varchar", is_nullable => 1, size => 80 },
385
  "report_subgroup",
386
  { data_type => "varchar", is_nullable => 1, size => 80 },
387
  "mana_id",
388
  { data_type => "integer", is_nullable => 1 },
389
);
390
391
=head1 PRIMARY KEY
392
393
=over 4
394
395
=item * L</id>
396
397
=back
398
399
=cut
400
401
__PACKAGE__->set_primary_key("id");
402
188
403
189
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
404
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
190
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:198dNG9DGQzop+s5IHy7sw
405
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:198dNG9DGQzop+s5IHy7sw
Lines 214-216 sub koha_objects_class { Link Here
214
}
429
}
215
430
216
1;
431
1;
217
- 
432
# End of lines loaded from '/kohadevbox/koha/Koha/Schema/Result/SavedSql.pm'
433
434
435
# You can replace this text with custom code or comments, and it will be preserved on regeneration
436
1;

Return to bug 16631