|
Lines 22-52
return {
Link Here
|
| 22 |
|
22 |
|
| 23 |
say $out "Added new table 'item_bundles'"; |
23 |
say $out "Added new table 'item_bundles'"; |
| 24 |
|
24 |
|
| 25 |
my ($lost_val) = $dbh->selectrow_array( "SELECT MAX(CAST(authorised_value AS SIGNED)) FROM authorised_values WHERE category = 'LOST'", {} ); |
25 |
my ($exists) = $dbh->selectrow_array( "SELECT EXISTS(SELECT * FROM authorised_value WHERE lib = 'Missing from bundle'" ); |
| 26 |
$lost_val++; |
26 |
if ( !$exists ) { |
| 27 |
|
27 |
my ($lost_val) = $dbh->selectrow_array( "SELECT MAX(CAST(authorised_value AS SIGNED)) FROM authorised_values WHERE category = 'LOST'", {} ); |
| 28 |
$dbh->do(qq{ |
28 |
$lost_val++; |
| 29 |
INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('LOST',$lost_val,'Missing from bundle') |
29 |
|
| 30 |
}); |
30 |
$dbh->do(qq{ |
| 31 |
say $out "Missing from bundle LOST AV added"; |
31 |
INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('LOST',$lost_val,'Missing from bundle') |
| 32 |
|
32 |
}); |
| 33 |
my ($nfl_val) = $dbh->selectrow_array( "SELECT MAX(CAST(authorised_value AS SIGNED)) FROM authorised_values WHERE category = 'NOT_LOAN'", {} ); |
33 |
say $out "Missing from bundle LOST AV added"; |
| 34 |
$nfl_val++; |
34 |
|
| 35 |
|
35 |
my ($nfl_val) = $dbh->selectrow_array( "SELECT MAX(CAST(authorised_value AS SIGNED)) FROM authorised_values WHERE category = 'NOT_LOAN'", {} ); |
| 36 |
$dbh->do(qq{ |
36 |
$nfl_val++; |
| 37 |
INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('NOT_LOAN',$nfl_val,'Added to bundle') |
37 |
|
| 38 |
}); |
38 |
$dbh->do(qq{ |
| 39 |
say $out "Added to bundle NOT_LOAN AV added"; |
39 |
INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('NOT_LOAN',$nfl_val,'Added to bundle') |
| 40 |
|
40 |
}); |
| 41 |
$dbh->do(qq{ |
41 |
say $out "Added to bundle NOT_LOAN AV added"; |
| 42 |
INSERT IGNORE INTO systempreferences( `variable`, `value`, `options`, `explanation`, `type` ) |
42 |
|
| 43 |
VALUES |
43 |
|
| 44 |
( 'BundleLostValue', $lost_val, '', 'Sets the LOST AV value that represents "Missing from bundle" as a lost value', 'Free' ), |
44 |
$dbh->do(qq{ |
| 45 |
( 'BundleNotLoanValue', $nfl_val, '', 'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value', 'Free') |
45 |
INSERT IGNORE INTO systempreferences( `variable`, `value`, `options`, `explanation`, `type` ) |
| 46 |
}); |
46 |
VALUES |
| 47 |
|
47 |
( 'BundleLostValue', $lost_val, '', 'Sets the LOST AV value that represents "Missing from bundle" as a lost value', 'Free' ), |
| 48 |
say $out "Added new system preference 'BundleLostValue'"; |
48 |
( 'BundleNotLoanValue', $nfl_val, '', 'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value', 'Free') |
| 49 |
say $out "Added new system preference 'BundleNotLoanValue'"; |
49 |
}); |
|
|
50 |
|
| 51 |
say $out "Added new system preference 'BundleLostValue'"; |
| 52 |
say $out "Added new system preference 'BundleNotLoanValue'"; |
| 53 |
} |
| 50 |
|
54 |
|
| 51 |
if( index_exists( 'return_claims', 'issue_id' ) ) { |
55 |
if( index_exists( 'return_claims', 'issue_id' ) ) { |
| 52 |
$dbh->do(q{ |
56 |
$dbh->do(q{ |
| 53 |
- |
|
|