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; |