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

(-)a/installer/data/mysql/atomicupdate/bug_14576_add_UpdateItemLocationOnCheckin.perl (-1 / +1 lines)
Lines 1-7 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
3
    $dbh->do(q{
4
        INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('UpdateItemLocationOnCheckin', 'PROC: _PERM_\n', 'NULL', 'This a list of value pairs. When an item is checked in, if the location value on the left matches the items location value t will be updated to the right-hand value. E.g. ''PROC: FIC'' will cause an item that was set to ''Book Cart'' to now be in the ''Fiction'' shelving location. Note that PROC and CART are special values, for these locations only can location and permanent_location differ.  In all other cases an update will affect both.  Items in the CART location will be returned to their permanent location on checkout.  You can also use the special term _BLANK_ on either side of a pair to update/remove items with no locaiton assigned.  You can use the special term _ALL_ on the left side to affect all items and the special term _PERM_ on the right side to return items to their permanent location', 'Free');
4
        INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('UpdateItemLocationOnCheckin', 'PROC: _PERM_\n', 'NULL', 'This a list of value pairs. When an item is checked in, if the location value on the left matches the items location value t will be updated to the right-hand value. E.g. ''PROC: FIC'' will cause an item that was set to ''Processing Center'' to now be in the ''Fiction'' shelving location. Note that PROC and CART are special values, for these locations only can location and permanent_location differ, in all other cases an update will affect both.  Items in the CART location will be returned to their permanent location on checkout.  You can also use the special term _BLANK_ on either side of a pair to update/remove items with no locaiton assigned.  You can use the special term _ALL_ on the left side to affect all items and the special term _PERM_ on the right side to return items to their permanent location', 'Free');
5
    });
5
    });
6
    $dbh->do(q{
6
    $dbh->do(q{
7
        UPDATE systempreferences s1, (SELECT IF(value,'PROC: CART\n','') AS p2c FROM systempreferences WHERE variable='InProcessingToShelvingCart') s2 SET s1.value= CONCAT(s2.p2c, REPLACE(s1.value,'PROC: _PERM_\n','') ) WHERE s1.variable='UpdateItemLocationOnCheckin' AND s1.value NOT LIKE '%PROC: CART%';
7
        UPDATE systempreferences s1, (SELECT IF(value,'PROC: CART\n','') AS p2c FROM systempreferences WHERE variable='InProcessingToShelvingCart') s2 SET s1.value= CONCAT(s2.p2c, REPLACE(s1.value,'PROC: _PERM_\n','') ) WHERE s1.variable='UpdateItemLocationOnCheckin' AND s1.value NOT LIKE '%PROC: CART%';
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-8 / +7 lines)
Lines 524-536 Circulation: Link Here
524
            - This is is a list of value pairs, the first value is followed immediately by colon space then the second value i.e.:<br/>
524
            - This is is a list of value pairs, the first value is followed immediately by colon space then the second value i.e.:<br/>
525
            - "PROC: FIC"
525
            - "PROC: FIC"
526
            - <br/> When an item is checked in, if the location value on the left matches the items location value
526
            - <br/> When an item is checked in, if the location value on the left matches the items location value
527
            - "it will be updated to the right-hand value.<br/> E.g. ''PROC: FIC'' will cause an item that was set to ''Book Cart'' to now be in the ''Fiction'' shelving location."
527
            - "it will be updated to the right-hand value.<br/> E.g. ''PROC: FIC'' will cause an item that was set to ''Processing Center'' to now be in the ''Fiction'' shelving location."
528
            - <br/>Note that PROC and CART are special values, for these locations only can location and permanent_location differ.  In all other cases an update will affect both.
528
            - <br/>Note that PROC and CART are special values, for these locations only can location and permanent_location differ, in all other cases an update will affect both.
529
            - <br/>Items in the CART location will be returned to their permanent location on checkout
529
            - <br/>Items in the CART location will be returned to their permanent location on checkout.
530
            - <br/>You can use the special term _BLANK_ on either side of a pair to update/remove items with no location assigned
530
            - <br/>You can use the special term _BLANK_ on either side of a pair to update/remove items with no location assigned.
531
            - <br>You can use the special term _ALL_ on the left side to affect all items
531
            - <br>You can use the special term _ALL_ on the left side to affect all items.
532
            - and the special term _PERM_ on the right side to return items to their permanent location
532
            - and the special term _PERM_ on the right side to return items to their permanent location.
533
            - <br>**Use of an _ALL_ rule will override/ignore any other values**
533
            - <br><b>Use of an _ALL_ rule will override/ignore any other values.</b>
534
            - <br>Each pair of values should be on a separate line.
534
            - <br>Each pair of values should be on a separate line.
535
        -
535
        -
536
            - pref: UpdateNotForLoanStatusOnCheckin
536
            - pref: UpdateNotForLoanStatusOnCheckin
537
- 

Return to bug 14576