Bug 17208

Summary: Classification sources and filing rules shouldn't allow 'New' with same code
Product: Koha Reporter: Aleisha Amohia <aleisha>
Component: System AdministrationAssignee: Aleisha Amohia <aleisha>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: gmcharlt, kyle, veron
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: Sponsored Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Bug 17208: Checking if classification source or filing rule already exists before adding
Bug 17208: Checking if classification source or filing rule already exists before adding
Bug 17208: Checking if classification source or filing rule already exists before adding

Description Aleisha Amohia 2016-08-29 02:29:20 UTC

    
Comment 1 Aleisha Amohia 2016-08-29 02:31:47 UTC
Hit enter too early. At the moment, you can attempt to create sources and filing rules using codes that already exist, and you receive a message saying that the new source or filing rule was created, however it isn't actually added to the database (as the codes must be unique), so it doesn't work. 
There should be some kind of check upon submission of the form that checks if the code already exists (like the check of a barcode before creating a new item).
Comment 2 Aleisha Amohia 2016-12-02 04:13:43 UTC
Created attachment 57878 [details] [review]
Bug 17208: Checking if classification source or filing rule already exists before adding

To test:
1) Go to Admin -> Classification sources
2) Attempt to reproduce bug before applying patch. Notice the message
saying the add was successful, but was not added to the table
3) Apply patch and refresh page (restart plack if necessary)
4) Add new classification source with same code as existing one. Notice
you are now told that the add failed.
5) Confirm adding new classification source with unique code works
6) Add new classification filing rule with same code as existing one.
Notice you are told that add failed.
7) Confirm adding new classification filing rule with unique code works

Sponsored-by: Catalyst IT
Comment 3 Marc Véron 2016-12-16 09:17:49 UTC
Created attachment 58237 [details] [review]
Bug 17208: Checking if classification source or filing rule already exists before adding

To test:
1) Go to Admin -> Classification sources
2) Attempt to reproduce bug before applying patch. Notice the message
saying the add was successful, but was not added to the table
3) Apply patch and refresh page (restart plack if necessary)
4) Add new classification source with same code as existing one. Notice
you are now told that the add failed.
5) Confirm adding new classification source with unique code works
6) Add new classification filing rule with same code as existing one.
Notice you are told that add failed.
7) Confirm adding new classification filing rule with unique code works

Sponsored-by: Catalyst IT

Followed test plan, works as expected.
Signed-off-by: Marc Véron <veron@veron.ch>
Comment 4 Jonathan Druart 2016-12-20 17:38:05 UTC
Created attachment 58315 [details] [review]
Bug 17208: Checking if classification source or filing rule already exists before adding

To test:
1) Go to Admin -> Classification sources
2) Attempt to reproduce bug before applying patch. Notice the message
saying the add was successful, but was not added to the table
3) Apply patch and refresh page (restart plack if necessary)
4) Add new classification source with same code as existing one. Notice
you are now told that the add failed.
5) Confirm adding new classification source with unique code works
6) Add new classification filing rule with same code as existing one.
Notice you are told that add failed.
7) Confirm adding new classification filing rule with unique code works

Sponsored-by: Catalyst IT

Followed test plan, works as expected.
Signed-off-by: Marc Véron <veron@veron.ch>

Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
This is not the way to go, we should use an eval instead.
But since we do not have RaiseError set, it will not work.
This module will need to be moved to Koha::Objects to be implemented
correctly.
Comment 5 Kyle M Hall (khall) 2016-12-23 11:34:02 UTC
Pushed to master for 17.05, thanks Aleisha!
Comment 6 Katrin Fischer 2016-12-27 22:11:14 UTC
This won't get ported back to 16.11.x as it is an enhancement.