Bugzilla – Attachment 20304 Details for
Bug 8367
How long is a hold waiting for pickup at a more granular level
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 8367: Fix the maxpickupdate when we set waitingdate to NOW()
Bug-8367-Fix-the-maxpickupdate-when-we-set-waiting.patch (text/plain), 1.91 KB, created by
Jonathan Druart
on 2013-08-13 13:11:28 UTC
(
hide
)
Description:
Bug 8367: Fix the maxpickupdate when we set waitingdate to NOW()
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2013-08-13 13:11:28 UTC
Size:
1.91 KB
patch
obsolete
>From 61290bba8debc38cb424cf117f6eb83bf923dc44 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Wed, 3 Jul 2013 11:52:42 +0200 >Subject: [PATCH] Bug 8367: Fix the maxpickupdate when we set waitingdate to > NOW() > >ModReserveAffect get the maxpickupdate before changing the waitingdate >to NOW. >We should update the waitingdate and next calculate the maxpickupdate. > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > C4/Reserves.pm | 15 +++++++++++---- > 1 file changed, 11 insertions(+), 4 deletions(-) > >diff --git a/C4/Reserves.pm b/C4/Reserves.pm >index 42f17c6..7c8e38f 100644 >--- a/C4/Reserves.pm >+++ b/C4/Reserves.pm >@@ -1375,20 +1375,27 @@ sub ModReserveAffect { > } > else { > # affect the reserve to Waiting as well. >- my $item = C4::Items::GetItem( $itemnumber ); >- my $maxpickupdate = GetMaxPickupDate( undef, $item ); > $query = " > UPDATE reserves > SET priority = 0, > found = 'W', > waitingdate = NOW(), >- maxpickupdate = ?, > itemnumber = ? > WHERE borrowernumber = ? > AND biblionumber = ? > "; > $sth = $dbh->prepare($query); >- $sth->execute( $maxpickupdate, $itemnumber, $borrowernumber,$biblionumber); >+ $sth->execute( $itemnumber, $borrowernumber,$biblionumber); >+ my $item = C4::Items::GetItem( $itemnumber ); >+ $query = " >+ UPDATE reserves >+ SET maxpickupdate = ? >+ WHERE borrowernumber = ? >+ AND biblionumber = ? >+ "; >+ my $maxpickupdate = GetMaxPickupDate( undef, $item ); >+ $sth = $dbh->prepare($query); >+ $sth->execute( $maxpickupdate, $borrowernumber, $biblionumber ); > } > _koha_notify_reserve( $itemnumber, $borrowernumber, $biblionumber ) if ( !$transferToDo && !$already_on_shelf ); > >-- >1.7.10.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 8367
:
12130
|
13139
|
13602
|
13603
|
13604
|
13624
|
15334
|
15335
|
15369
|
15498
|
15613
|
15658
|
15659
|
19093
|
19094
|
19095
|
19096
|
19104
|
19105
|
19107
|
19108
|
19116
|
19180
|
19181
|
19182
|
19360
|
19361
|
19362
|
20300
|
20301
|
20302
|
20303
|
20304
|
32786
|
32826
|
32884
|
32885
|
32916
|
32930
|
42706
|
42754
|
79790
|
79791
|
79798
|
79799
|
79800
|
79853
|
79854
|
79855
|
79859
|
92412
|
92413
|
92414
|
92415
|
92416
|
92417
|
92418
|
92419
|
92420
|
92421
|
92422
|
92423
|
92424
|
92425
|
92426
|
92427
|
92428
|
92958
|
92959
|
92960
|
92961
|
103425
|
113211
|
117284
|
118017
|
118021
|
124568
|
125087
|
131299
|
131300
|
131301
|
131302
|
131646
|
131647
|
131718
|
131719
|
131720
|
131722
|
131723
|
131724
|
133089
|
133090
|
133091
|
133092
|
133093
|
133094
|
142897
|
142898
|
142899
|
142900
|
142901
|
142902
|
142903
|
144097
|
144098
|
144099
|
144100
|
144101
|
144102
|
144103
|
144146
|
145644
|
145657
|
147798
|
147799
|
147800
|
147801
|
147802
|
147803
|
147804
|
147805
|
147806
|
147807
|
148536
|
148537
|
148538
|
148539
|
148540
|
148541
|
148542
|
148543
|
148544
|
148545
|
150437
|
150438
|
150439
|
153235
|
153237
|
153238
|
153239
|
153240
|
153241
|
153242
|
153243
|
153244
|
153245
|
153246
|
157138
|
157139
|
157140
|
157141
|
157142
|
157143
|
157144
|
157145
|
157146
|
157147
|
157148
|
157149
|
157150
|
157298
|
157343
|
157344
|
157345
|
157346
|
157347
|
157348
|
157349
|
157350
|
157351
|
157352
|
157354
|
157355
|
157356
|
157697
|
157698
|
157699
|
157700
|
157701
|
157702
|
157703
|
157704
|
157705
|
157706
|
157707
|
157708
|
157709
|
157715
|
158023
|
158024
|
158025
|
158026
|
158027
|
158028
|
158029
|
158030
|
158031
|
158032
|
158033
|
158034
|
158035
|
158254
|
158255