Bug 33283

Summary: Curbside pickups - Rogue curbside pickups
Product: Koha Reporter: Caroline Cyr La Rose <caroline.cyr-la-rose>
Component: CirculationAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: gmcharlt, kyle.m.hall
Version: unspecified   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Caroline Cyr La Rose 2023-03-20 19:19:29 UTC
Not sure if this is something that would happen IRL, but I have some rogue curbside pickup appointments in my installation that I can't remove except by going into the database.

I think maybe it's the filters in the curbside pickup lists that are a bit too restrictive, removing anything that is not today?

Not sure how to replicate this one except make appointments and leave them there...

In the patron's account, I have two notifications about curbside pickups https://snipboard.io/whQPBJ.jpg

There is nothing in the "To be staged" report https://snipboard.io/GTkiNZ.jpg

There is no "Delivered" report except "Delivered today", which is also empty https://snipboard.io/jdF8gW.jpg

The patron doesn't currently have any holds, so I can't cancel the holds to cancel the pickups.

In the database, for this patron

select * from curbside_pickups where borrowernumber = 37 \G;
*************************** 1. row ***************************
                       id: 9
           borrowernumber: 37
               branchcode: CPL
scheduled_pickup_datetime: 2023-02-04 13:00:00
          staged_datetime: NULL
                staged_by: NULL
         arrival_datetime: NULL
       delivered_datetime: NULL
             delivered_by: NULL
                    notes: 
*************************** 2. row ***************************
                       id: 23
           borrowernumber: 37
               branchcode: CPL
scheduled_pickup_datetime: 2023-02-06 13:40:00
          staged_datetime: 2023-02-06 11:37:52
                staged_by: 51
         arrival_datetime: 2023-02-06 11:39:20
       delivered_datetime: 2023-02-06 11:39:35
             delivered_by: 51
                    notes: 
2 rows in set (0.000 sec)