[Koha-bugs] [Bug 22435] Clarify account_offset types by converting them to clear codes
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Jul 19 14:09:09 CEST 2021
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22435
--- Comment #194 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
(In reply to Martin Renvoize from comment #193)
> (In reply to Jonathan Druart from comment #192)
> > Martin, shouldn't we apply the following change to make the db rev
> > idempotent?
> >
> > - $dbh->do( "UPDATE account_offsets SET type = 'CREATE' WHERE type !=
> > 'OVERDUE_INCREASE' AND type != 'OVERDUE_DECREASE' AND ( debit_id IS NULL OR
> > credit_id IS NULL)" );
> > + $dbh->do( "UPDATE account_offsets SET type = 'CREATE' WHERE type !=
> > 'OVERDUE_INCREASE' AND type != 'OVERDUE_DECREASE' AND type != 'APPLY' AND (
> > debit_id IS NULL OR credit_id IS NULL)" );
>
> Hmm, it wouldn't do any harm, though I believe we shouldn't have any cases
> where APPLY exists where debit_id or credit_id is null.
Correct, forget that!
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list