Bug 39980

Summary: Vendors pages are broken when using Koha as a Mojolicious application
Product: Koha Reporter: Julian Maurice <julian.maurice>
Component: AcquisitionsAssignee: Julian Maurice <julian.maurice>
Status: Signed Off --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: david, dcook
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
This fixes vendor pages when running Koha as a Mojolicious application. You couldn't search for or create vendors (you get a page not found error). (This is related to bug 38010 - Migrate vendors to Vue, added to Koha 25.05.)
Version(s) released in:
Circulation function:
Bug Depends on: 38010    
Bug Blocks:    
Attachments: Bug 39980: Fix vendors pages when using Koha as a Mojo app
Bug 39980: Add tests for .../acquisition/vendors* in Mojo context
Bug 39980: Fix vendors pages when using Koha as a Mojo app
Bug 39980: Add tests for .../acquisition/vendors* in Mojo context

Description Julian Maurice 2025-05-23 11:17:04 UTC
Bug 38010 broke the vendors pages when Koha is running as a Mojolicious application

Steps to reproduce:
1. Run `bin/intranet daemon -l http://*:3000/`
2. Point your browser to http://localhost:3000 (replace localhost by the hostname/IP of koha's container, if needed)
3. Go to Acquisitions and search for a vendor. You will get an error 404.
Comment 1 Julian Maurice 2025-05-23 12:41:35 UTC
Created attachment 182768 [details] [review]
Bug 39980: Fix vendors pages when using Koha as a Mojo app

Bug 38010 broke the vendors pages when Koha is running as a Mojolicious
application

This adds new routes to Koha::App::Intranet to mimic the Apache rewrite
rules added in bug 38010.

To be able to do that, the CGIBinKoha plugin's code had to be moved to a
controller. The logic remains the same.

Test plan:
1. Run `bin/intranet daemon -l http://*:3000/`
2. Point your browser to http://localhost:3000 (replace localhost by the
   hostname/IP of koha's container, if needed)
3. Go to Acquisitions and search for a vendor. You should see the list
   of vendors.
4. Click on "New vendor" button. Notice the URL changed to
   .../acquisition/vendors/add.
5. Reload the page. You should still see the form to create a new vendor
6. Verify that you can create a vendor and that you are then redirected
   to the list of vendors
Comment 2 Julian Maurice 2025-05-23 12:41:37 UTC
Created attachment 182769 [details] [review]
Bug 39980: Add tests for .../acquisition/vendors* in Mojo context
Comment 3 Julian Maurice 2025-05-23 12:45:29 UTC
The tests are not executed inside a DB transaction because when they are, I get the following error:

DBIx::Class::Storage::DBI::mysql::_exec_svp_release(): DBI Exception: DBD::mysql::db do failed: SAVEPOINT savepoint_1 does not exist at /home/koha/koha/Koha/Object.pm line 174

Anyone knows how to fix this ?
Comment 4 David Nind 2025-05-23 20:53:00 UTC
I had a go at testing, but I can't get it to work for me using KTD.

Starting up:
  bin/intranet daemon -l http://*:3000/
  [2025-05-23 20:51:42.98851] [4056] [info] Listening at "http://*:3000/"
  Web application available at http://127.0.0.1:3000/

Accessing the URL:

  This site can’t be reached
  127.0.0.1 refused to connect.
  Try:

  Checking the connection
  Checking the proxy and the firewall
  ERR_CONNECTION_REFUSED
Comment 5 Julian Maurice 2025-05-26 07:13:09 UTC
(In reply to David Nind from comment #4)
> I had a go at testing, but I can't get it to work for me using KTD.
You have to point your browser to the KTD container's IP, not 127.0.0.1
Comment 6 David Nind 2025-05-31 03:41:30 UTC
Created attachment 182874 [details] [review]
Bug 39980: Fix vendors pages when using Koha as a Mojo app

Bug 38010 broke the vendors pages when Koha is running as a Mojolicious
application

This adds new routes to Koha::App::Intranet to mimic the Apache rewrite
rules added in bug 38010.

To be able to do that, the CGIBinKoha plugin's code had to be moved to a
controller. The logic remains the same.

Test plan:
1. Run `bin/intranet daemon -l http://*:3000/`
2. Point your browser to http://localhost:3000 (replace localhost by the
   hostname/IP of koha's container, if needed)
3. Go to Acquisitions and search for a vendor. You should see the list
   of vendors.
4. Click on "New vendor" button. Notice the URL changed to
   .../acquisition/vendors/add.
5. Reload the page. You should still see the form to create a new vendor
6. Verify that you can create a vendor and that you are then redirected
   to the list of vendors

Signed-off-by: David Nind <david@davidnind.com>
Comment 7 David Nind 2025-05-31 03:41:32 UTC
Created attachment 182875 [details] [review]
Bug 39980: Add tests for .../acquisition/vendors* in Mojo context

Signed-off-by: David Nind <david@davidnind.com>
Comment 8 David Nind 2025-05-31 03:49:48 UTC
Testing notes (using KTD):

1. Step 2 - to find the IP address of the koha docker container:
   - access a new terminal window on your computer
   - find the name of the koha container: docker ps 
     (it should be kohadev-koha-1)
   - find the IP address (for me, it was at the very end of the output - IPAddress): sudo docker container inspect kohadev-koha-1

2. Check that the tests pass: prove t/db_dependent/mojo/acquisition/vendors.t