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

(-)a/Koha/Schema/Result/ReportsBranch.pm (+86 lines)
Line 0 Link Here
1
use utf8;
2
3
package Koha::Schema::Result::ReportsBranch;
4
5
# Created by DBIx::Class::Schema::Loader
6
# DO NOT MODIFY THE FIRST PART OF THIS FILE
7
8
=head1 NAME
9
10
Koha::Schema::Result::ItemtypesBranch
11
12
=cut
13
14
use strict;
15
use warnings;
16
17
use base 'DBIx::Class::Core';
18
19
=head1 TABLE: C<itemtypes_branches>
20
21
=cut
22
23
__PACKAGE__->table("reports_branches");
24
25
=head1 ACCESSORS
26
27
=head2 report_id
28
29
  data_type: 'varchar'
30
  is_foreign_key: 1
31
  is_nullable: 1
32
  size: 80
33
34
=head2 branchcode
35
36
  data_type: 'varchar'
37
  is_foreign_key: 1
38
  is_nullable: 0
39
  size: 10
40
41
=cut
42
43
__PACKAGE__->add_columns(
44
    "report_id",
45
    { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
46
    "branchcode",
47
    { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
48
);
49
50
=head1 RELATIONS
51
52
=head2 branchcode
53
54
Type: belongs_to
55
56
Related object: L<Koha::Schema::Result::Branch>
57
58
=cut
59
60
__PACKAGE__->belongs_to(
61
    "branchcode",
62
    "Koha::Schema::Result::Branch",
63
    { branchcode    => "branchcode" },
64
    { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
65
);
66
67
=head2 itemtype
68
69
Type: belongs_to
70
71
Related object: L<Koha::Schema::Result::Itemtype>
72
73
=cut
74
75
__PACKAGE__->belongs_to(
76
    "report_id",
77
    "Koha::Schema::Result::Report",
78
    { report_id     => "report_id" },
79
    { is_deferrable => 1, on_delete => "CASCADE", on_update => "RESTRICT" },
80
);
81
82
# Created by DBIx::Class::Schema::Loader v0.07048 @ 2019-07-04 04:56:48
83
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cBTswjKV8VWN1iueB+PygQ
84
85
# You can replace this text with custom code or comments, and it will be preserved on regeneration
86
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