Re: [Koha-devel] Can we do away with items.onloan?

[Martha Fuerst]

So this is interesting - with as muddy as some of our data can get, I only got 
one result. It’s an item that was checked out to a “problems” account back in 
October 2017 with a due date of April 2nd, 2018. I thought maybe it was due to 
an extension of the due date from the checkout screen (but then clearly we 
would have way more instances of this).

I edited the query a bit and pulled this. So it’s off, but only by a little 
bit. Has anyone else seen it be off by a bunch? Or is it due to the difference 
in the datetime vs date formats of the fields?

select i.itemnumber, i.date_due, c.onloan from issues i inner join items c 
using (itemnumber) where date(i.date_due) != c.onloan

itemnumber  date_dueonloan
611020  2018-04-02 23:59:00 2018-04-01


Marti Fuerst
Systems Librarian
Huntsville-Madison County Public Library
915 Monroe St, Huntsville, AL 35801
http://hmcpl.org/ — mfue...@hmcpl.org

> On May 19, 2018, at 11:50 PM, Barton Chittenden  
> wrote:
> 
> select count(*) from issues inner join items using (itemnumber) where 
> date(issues.date_due) != items.onloan

___
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Re: [Koha-devel] Clear OPAC self-registration form when back button pressed

[Martha Fuerst]

I’m for it! Thanks for this!

Marti Fuerst
Systems Librarian
Huntsville-Madison County Public Library
915 Monroe St, Huntsville, AL 35801
http://hmcpl.org/ — mfue...@hmcpl.org

> On Apr 12, 2018, at 8:55 PM, David Cook  wrote:
> 
> What do people think about clearing the OPAC self-registration form when back 
> button pressed? 
>  
> I used some code* from 
> https://stackoverflow.com/questions/8861181/clear-all-fields-in-a-form-upon-going-back-with-browser-back-button
>  
> 
>  to implement it and it worked pretty well on the latest Chrome on Windows 10.
>  
> That way you don’t have people finding personal information about other 
> people just by pressing “Back” on a public computer. 
>  
>  
> *
> $(window).bind("pageshow", function() {
> var form = $('#memberentry-form'); 
> // let the browser natively reset defaults
> form[0].reset();
> });
>  
> David Cook
> Systems Librarian
> Prosentient Systems
> 72/330 Wattle St
> Ultimo, NSW 2007
> Australia
>  
> Office: 02 9212 0899
> Direct: 02 8005 0595
>  
> ___
> Koha-devel mailing list
> Koha-devel@lists.koha-community.org 
> 
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel 
> 
> website : http://www.koha-community.org/ 
> git : http://git.koha-community.org/ 
> bugs : http://bugs.koha-community.org/ 
___
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/