[Koha-bugs] [Bug 31727] Orphan records in circulation_rules and false positives after attempt to fix values to be empty or zeroes instead of missing

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31727

--- Comment #2 from Andrew Nugged <nugged at gmail.com> ---
Here I preselected from the code which rule_name's we have (indented column),
one can double-check me.
This was handy for me to fix databases after the "noise-making" session, but I
think we should create an atomic-update normalizer which will wipe out "the
noise" from the database (but operators will be surprised! :) ):


Defining circulation and fine rules for all libraries
Defining circulation and fine rules for "BRANCH_NAME"
table 1:

    article_requests
    auto_renew
    cap_fine_to_replacement_price
    chargeperiod
    chargeperiod_charge_at
    daysmode
    decreaseloanholds
    fine
    finedays
    firstremind
    hardduedate
    hardduedatecompare
    holds_per_day
    holds_per_record
    issuelength
    lengthunit
    maxissueqty
    maxonsiteissueqty
    maxsuspensiondays
    no_auto_renewal_after
    no_auto_renewal_after_hard_limit
    norenewalbefore
    note
    on_shelf_recalls
    onshelfholds
    opacitemholds
    overduefinescap
    recall_due_date_interval
    recall_overdue_fine
    recall_shelf_time
    recalls_allowed
    recalls_per_record
    renewalperiod
    renewalsallowed
    rentaldiscount
    reservesallowed
    suspension_chargeperiod
    unseen_renewals_allowed

Default checkout, hold and return policy
Default checkout, hold and return policy for BRANCH_NAME
table 2: set-branch-defaults
    hold_fulfillment_policy
    holdallowed
    max_holds
    patron_maxissueqty
    patron_maxonsiteissueqty
    returnbranch

Default checkout, hold policy by patron category
Checkout, hold policy by patron category for BRANCH_NAME
table 3: add-branch-cat
    max_holds
    patron_maxissueqty
    patron_maxonsiteissueqty



Default open article requests limit
Daily open article requests limit for BRANCH_NAME
table 4: add-open-article-requests-limit

    open_article_requests_limit



Default article request fees
Article request fees for BRANCH_NAME
table 5: set-article-request-fee

    article_request_fee



Default lost item fee refund on return policy
Lost item fee refund on return policy for BRANCH_NAME
table 6: mod-refund-lost-item-fee-rule

    lostreturn



Default holds policy by item type
Holds policy by item type for BRANCH_NAME
table 7: set-waiting-hold-cancellation

    waiting_hold_cancellation

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.