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