http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11682
--- Comment #7 from Galen Charlton <gmcha...@gmail.com> --- (In reply to Jonathan Druart from comment #4) > (In reply to Galen Charlton from comment #0) > > [3] Create a new serial_issue_status column to manage the statuses. It > > might look like this: > > > > id INTEGER -- status ID > > name VARCHAR(255) -- label of status > > missing BOOLEAN -- whether or not the status should be considered to > > represent an issue that was never received > > I'm not sure it is enough. > The status value is checked at several places in the code: > > 1/ (planneddate < now() AND serial.status=1) OR serial.STATUS IN (3, 4, 41, > 42, 43, 44) > > 2/ WHERE ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3) > > and some others. > > The "missing" boolean won't permit to write a SQL query doing the same thing. Good point. Additional flags would cover the cases you've listed, e.g., is_expected_status is_late_status is_claimed_status However, we could also pin the IDs for those statuses and use named constants in the code for those, and use an deletable flag in the serial_issue_status to control whether the user can remove that status. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/