|
Lines 97-104
__PACKAGE__->table("article_requests");
Link Here
|
| 97 |
=head2 status |
97 |
=head2 status |
| 98 |
|
98 |
|
| 99 |
data_type: 'enum' |
99 |
data_type: 'enum' |
| 100 |
default_value: 'PENDING' |
100 |
default_value: 'REQUESTED' |
| 101 |
extra: {list => ["PENDING","PROCESSING","COMPLETED","CANCELED"]} |
101 |
extra: {list => ["REQUESTED","PENDING","PROCESSING","COMPLETED","CANCELED"]} |
| 102 |
is_nullable: 0 |
102 |
is_nullable: 0 |
| 103 |
|
103 |
|
| 104 |
=head2 notes |
104 |
=head2 notes |
|
Lines 106-111
__PACKAGE__->table("article_requests");
Link Here
|
| 106 |
data_type: 'mediumtext' |
106 |
data_type: 'mediumtext' |
| 107 |
is_nullable: 1 |
107 |
is_nullable: 1 |
| 108 |
|
108 |
|
|
|
109 |
=head2 debit_line_id |
| 110 |
|
| 111 |
data_type: 'integer' |
| 112 |
is_foreign_key: 1 |
| 113 |
is_nullable: 1 |
| 114 |
|
| 115 |
Debit line with cost for article scan request |
| 116 |
|
| 109 |
=head2 format |
117 |
=head2 format |
| 110 |
|
118 |
|
| 111 |
data_type: 'enum' |
119 |
data_type: 'enum' |
|
Lines 118-123
__PACKAGE__->table("article_requests");
Link Here
|
| 118 |
data_type: 'mediumtext' |
126 |
data_type: 'mediumtext' |
| 119 |
is_nullable: 1 |
127 |
is_nullable: 1 |
| 120 |
|
128 |
|
|
|
129 |
=head2 cancellation_reason |
| 130 |
|
| 131 |
data_type: 'varchar' |
| 132 |
is_nullable: 1 |
| 133 |
size: 80 |
| 134 |
|
| 135 |
optional authorised value AR_CANCELLATION |
| 136 |
|
| 121 |
=head2 created_on |
137 |
=head2 created_on |
| 122 |
|
138 |
|
| 123 |
data_type: 'timestamp' |
139 |
data_type: 'timestamp' |
|
Lines 133-138
Be careful with two timestamps in one table not allowing NULL
Link Here
|
| 133 |
default_value: current_timestamp |
149 |
default_value: current_timestamp |
| 134 |
is_nullable: 0 |
150 |
is_nullable: 0 |
| 135 |
|
151 |
|
|
|
152 |
=head2 toc_request |
| 153 |
|
| 154 |
data_type: 'tinyint' |
| 155 |
default_value: 0 |
| 156 |
is_nullable: 0 |
| 157 |
|
| 136 |
=cut |
158 |
=cut |
| 137 |
|
159 |
|
| 138 |
__PACKAGE__->add_columns( |
160 |
__PACKAGE__->add_columns( |
|
Lines 165-176
__PACKAGE__->add_columns(
Link Here
|
| 165 |
"status", |
187 |
"status", |
| 166 |
{ |
188 |
{ |
| 167 |
data_type => "enum", |
189 |
data_type => "enum", |
| 168 |
default_value => "PENDING", |
190 |
default_value => "REQUESTED", |
| 169 |
extra => { list => ["PENDING", "PROCESSING", "COMPLETED", "CANCELED"] }, |
191 |
extra => { |
|
|
192 |
list => ["REQUESTED", "PENDING", "PROCESSING", "COMPLETED", "CANCELED"], |
| 193 |
}, |
| 170 |
is_nullable => 0, |
194 |
is_nullable => 0, |
| 171 |
}, |
195 |
}, |
| 172 |
"notes", |
196 |
"notes", |
| 173 |
{ data_type => "mediumtext", is_nullable => 1 }, |
197 |
{ data_type => "mediumtext", is_nullable => 1 }, |
|
|
198 |
"debit_line_id", |
| 199 |
{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, |
| 174 |
"format", |
200 |
"format", |
| 175 |
{ |
201 |
{ |
| 176 |
data_type => "enum", |
202 |
data_type => "enum", |
|
Lines 180-185
__PACKAGE__->add_columns(
Link Here
|
| 180 |
}, |
206 |
}, |
| 181 |
"urls", |
207 |
"urls", |
| 182 |
{ data_type => "mediumtext", is_nullable => 1 }, |
208 |
{ data_type => "mediumtext", is_nullable => 1 }, |
|
|
209 |
"cancellation_reason", |
| 210 |
{ data_type => "varchar", is_nullable => 1, size => 80 }, |
| 183 |
"created_on", |
211 |
"created_on", |
| 184 |
{ |
212 |
{ |
| 185 |
data_type => "timestamp", |
213 |
data_type => "timestamp", |
|
Lines 193-198
__PACKAGE__->add_columns(
Link Here
|
| 193 |
default_value => \"current_timestamp", |
221 |
default_value => \"current_timestamp", |
| 194 |
is_nullable => 0, |
222 |
is_nullable => 0, |
| 195 |
}, |
223 |
}, |
|
|
224 |
"toc_request", |
| 225 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
| 196 |
); |
226 |
); |
| 197 |
|
227 |
|
| 198 |
=head1 PRIMARY KEY |
228 |
=head1 PRIMARY KEY |
|
Lines 259-264
__PACKAGE__->belongs_to(
Link Here
|
| 259 |
}, |
289 |
}, |
| 260 |
); |
290 |
); |
| 261 |
|
291 |
|
|
|
292 |
=head2 debit_line |
| 293 |
|
| 294 |
Type: belongs_to |
| 295 |
|
| 296 |
Related object: L<Koha::Schema::Result::Accountline> |
| 297 |
|
| 298 |
=cut |
| 299 |
|
| 300 |
__PACKAGE__->belongs_to( |
| 301 |
"debit_line", |
| 302 |
"Koha::Schema::Result::Accountline", |
| 303 |
{ accountlines_id => "debit_line_id" }, |
| 304 |
{ |
| 305 |
is_deferrable => 1, |
| 306 |
join_type => "LEFT", |
| 307 |
on_delete => "SET NULL", |
| 308 |
on_update => "CASCADE", |
| 309 |
}, |
| 310 |
); |
| 311 |
|
| 262 |
=head2 itemnumber |
312 |
=head2 itemnumber |
| 263 |
|
313 |
|
| 264 |
Type: belongs_to |
314 |
Type: belongs_to |
|
Lines 280-287
__PACKAGE__->belongs_to(
Link Here
|
| 280 |
); |
330 |
); |
| 281 |
|
331 |
|
| 282 |
|
332 |
|
| 283 |
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:41:15 |
333 |
# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-09-23 12:32:28 |
| 284 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GVaBsoeXb0EiuKTJYkWLEg |
334 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MgIKxsOJtbpcT9ZT6iAShA |
| 285 |
|
335 |
|
| 286 |
|
336 |
|
| 287 |
# You can replace this text with custom code or comments, and it will be preserved on regeneration |
337 |
# You can replace this text with custom code or comments, and it will be preserved on regeneration |
| 288 |
- |
|
|