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

(-)a/installer/data/mysql/atomicupdate/bug_14048_refundlostitemfeeonreturn.perl (-31 lines)
Lines 1-31 Link Here
1
$DBversion = "16.06.00.XXX";
2
if ( CheckVersion($DBversion) ) {
3
    $dbh->do(q{
4
        CREATE TABLE `refund_lost_item_fee_rules` (
5
		  `branchcode` varchar(10) NOT NULL default '',
6
		  `refund` tinyint(1) NOT NULL default 0,
7
		  PRIMARY KEY  (`branchcode`)
8
		) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
9
    });
10
    $dbh->do(q{
11
        INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
12
        VALUES( 'RefundLostOnReturnControl',
13
                'CheckinLibrary',
14
                'If a lost item is returned, choose which branch to pick rules for refunding.',
15
                'CheckinLibrary|PatronLibrary|ItemHomeBranch|ItemHoldingbranch',
16
                'Choice')
17
    });
18
    # Pick the old syspref as the default rule
19
    $dbh->do(q{
20
        INSERT INTO refund_lost_item_fee_rules (branchcode,refund)
21
            SELECT '*', value FROM systempreferences WHERE variable='RefundLostItemFeeOnReturn'
22
    });
23
    # Delete the old syspref
24
    $dbh->do(q{
25
        DELETE IGNORE FROM systempreferences
26
        WHERE variable='RefundLostItemFeeOnReturn'
27
    });
28
29
    print "Upgrade to $DBversion done (Bug 14048: Change RefundLostItemFeeOnReturn to be branch specific)\n";
30
    SetVersion($DBversion);
31
}
(-)a/installer/data/mysql/atomicupdate/bug_14048_refundlostitemfeeonreturn.sql (-1 / +49 lines)
Line 0 Link Here
0
- 
1
CREATE TABLE `refund_lost_item_fee_rules` (
2
  `branchcode` varchar(10) NOT NULL default '',
3
  `refund` tinyint(1) NOT NULL default 0,
4
  PRIMARY KEY  (`branchcode`)
5
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
6
7
INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
8
VALUES( 'RefundLostOnReturnControl',
9
        'CheckinLibrary',
10
        'If a lost item is returned, choose which branch to pick rules for refunding.',
11
        'CheckinLibrary|PatronLibrary|ItemHomeBranch|ItemHoldingbranch',
12
        'Choice');
13
14
INSERT INTO refund_lost_item_fee_rules (branchcode,refund)
15
    SELECT '*', COALESCE(value,'1') FROM systempreferences WHERE variable='RefundLostItemFeeOnReturn';
16
17
DELETE IGNORE FROM systempreferences;
18
19
-- $DBversion = "16.06.00.XXX";
20
-- if ( CheckVersion($DBversion) ) {
21
--     $dbh->do(q{
22
--         CREATE TABLE `refund_lost_item_fee_rules` (
23
--           `branchcode` varchar(10) NOT NULL default '',
24
--           `refund` tinyint(1) NOT NULL default 0,
25
--           PRIMARY KEY  (`branchcode`)
26
--         ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
27
--     });
28
--     $dbh->do(q{
29
--         INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
30
--         VALUES( 'RefundLostOnReturnControl',
31
--                 'CheckinLibrary',
32
--                 'If a lost item is returned, choose which branch to pick rules for refunding.',
33
--                 'CheckinLibrary|PatronLibrary|ItemHomeBranch|ItemHoldingbranch',
34
--                 'Choice')
35
--     });
36
--     # Pick the old syspref as the default rule
37
--     $dbh->do(q{
38
--         INSERT INTO refund_lost_item_fee_rules (branchcode,refund)
39
--             SELECT '*', COALESCE(value,'1') FROM systempreferences WHERE variable='RefundLostItemFeeOnReturn'
40
--     });
41
--     # Delete the old syspref
42
--     $dbh->do(q{
43
--         DELETE IGNORE FROM systempreferences
44
--         WHERE variable='RefundLostItemFeeOnReturn'
45
--     });
46
47
--     print "Upgrade to $DBversion done (Bug 14048: Change RefundLostItemFeeOnReturn to be branch specific)\n";
48
--     SetVersion($DBversion);
49
-- }

Return to bug 14048