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

(-)a/installer/data/mysql/db_revs/220600015.pl (-26 / +29 lines)
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
- 

Return to bug 34881