Send Koha-devel mailing list submissions to
    koha-devel@lists.koha-community.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
    koha-devel-request@lists.koha-community.org

You can reach the person managing the list at
    koha-devel-owner@lists.koha-community.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."


Today's Topics:

1. Re: Changing the lost card value (Jonathan Druart)
2. Re: Changing the lost card value (Cab Vinton)
3. Re: Changing the lost card value (Tomas Cohen Arazi)


----------------------------------------------------------------------

Message: 1
Date: Mon, 18 Oct 2021 15:34:56 +0200
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
To: Stephen Graham <s.graham4@herts.ac.uk>
Cc: koha-devel <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Changing the lost card value
Message-ID:
    <CAJzKNY6f1W4UVmwZFJSnvy+c36zd-4ygwtzTgP7sA40gH2a9JQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

The trick is in the AUTOLOAD of Koha::Object, any attributes (column's
names) will be a getter/setter.

To login as the koha user and set the correct env vars you need to use
the `koha-shell` command.

Le lun. 18 oct. 2021 à 15:18, Stephen Graham <s.graham4@herts.ac.uk> a écrit :
>
> Actually I just testing this now and cannot get it to work. I'm getting an error about not being able to write to the plack-opac-error.log file. I'm logged in as the usual koha user, and it's for a non-web script - never seen that before. I guess it's not working and it's trying to log the error to the plack log.
>
> I have the below, it's print User has a lost card, and then bombs out.
>
> my $user = Koha::Patrons->find($userid);
> if ($user->lost) {
> print "User has a lost card\n";
> $user->lost(0)->store();
> } else {
> print "NO lost card\n";
> }
>
> Stephen
>
> -----Original Message-----
> From: Stephen Graham
> Sent: 18 October 2021 14:04
> To: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
> Cc: koha-devel <koha-devel@lists.koha-community.org>
> Subject: RE: [Koha-devel] Changing the lost card value
>
> Thanks Jonathan. I understand that the find method returns a Patron object, but don't understand where lost comes from. It's not a method in Patron is it? I guess it's a shortcut to update any individual database field value?
>
> Stephen
>
> -----Original Message-----
> From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
> Sent: 18 October 2021 12:37
> To: Stephen Graham <s.graham4@herts.ac.uk>
> Cc: koha-devel <koha-devel@lists.koha-community.org>
> Subject: Re: [Koha-devel] Changing the lost card value
>
> Hi Stephen,
>
> You can use
> Koha::Patrons->find(42)->lost(0)->store;
> to set borrowers.lost to 0 for patron with borrowernumber=42.
>
> Cheers,
> Jonathan
>
> Le lun. 18 oct. 2021 à 12:47, Stephen Graham <s.graham4@herts.ac.uk> a écrit :
> >
> > Sorry if this is a basic question. I’ve searched through the Koha::Patron and C4::Members perldoc and had a quick look through the memberentry.pl code to see how this handles it, but I can’t seem to work out how it done. I want to change the value of the lost card field to zero. I can see the “lost” field in the borrowers table, so could update the value directly via SQL, but there must be a Koha method that I can use to do this? Any help/advice much appreciated!
> >
> >
> >
> > Cheers, Stephen
> >
> >
> >
> > --------------------------------------
> >
> > Stephen Graham
> >
> > Library Technology Consultant
> >
> > Library and Computing Services
> >
> >
> >
> > University of Hertfordshire
> >
> > Hatfield, Hertfordshire, AL10 9AB
> >
> >
> >
> > Tel: +44(0)1707 286111
> >
> > Ext: 77751
> >
> > Email: s.graham4@herts.ac.uk
> >
> > Website: herts.ac.uk
> >
> >
> >
> > _______________________________________________
> > Koha-devel mailing list
> > Koha-devel@lists.koha-community.org
> > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> > website : https://www.koha-community.org/ git :
> > https://git.koha-community.org/ bugs :
> > https://bugs.koha-community.org/


------------------------------

Message: 2
Date: Mon, 18 Oct 2021 09:55:49 -0400
From: Cab Vinton <bibliwho@gmail.com>
To: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Cc: Stephen Graham <s.graham4@herts.ac.uk>, koha-devel
    <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Changing the lost card value
Message-ID:
    <CABW43URqiFbUHZ1LbnvX9iaN3UOUraF-OB7DuLDg1XQ1KHzj5g@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

I think another option would be the Patron Import tool:
...tools/import_borrowers.pl

Cheers,

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH

On Mon, Oct 18, 2021 at 9:43 AM Jonathan Druart
<jonathan.druart@bugs.koha-community.org> wrote:
>
> Hi Stephen,
>
> You can use
> Koha::Patrons->find(42)->lost(0)->store;
> to set borrowers.lost to 0 for patron with borrowernumber=42.
>
> Cheers,
> Jonathan
>
> Le lun. 18 oct. 2021 à 12:47, Stephen Graham <s.graham4@herts.ac.uk> a écrit :
> >
> > Sorry if this is a basic question. I’ve searched through the Koha::Patron and C4::Members perldoc and had a quick look through the memberentry.pl code to see how this handles it, but I can’t seem to work out how it done. I want to change the value of the lost card field to zero. I can see the “lost” field in the borrowers table, so could update the value directly via SQL, but there must be a Koha method that I can use to do this? Any help/advice much appreciated!
> >
> >
> >
> > Cheers, Stephen
> >
> >
> >
> > --------------------------------------
> >
> > Stephen Graham
> >
> > Library Technology Consultant
> >
> > Library and Computing Services
> >
> >
> >
> > University of Hertfordshire
> >
> > Hatfield, Hertfordshire, AL10 9AB
> >
> >
> >
> > Tel: +44(0)1707 286111
> >
> > Ext: 77751
> >
> > Email: s.graham4@herts.ac.uk
> >
> > Website: herts.ac.uk
> >
> >
> >
> > _______________________________________________
> > Koha-devel mailing list
> > Koha-devel@lists.koha-community.org
> > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> > website : https://www.koha-community.org/
> > git : https://git.koha-community.org/
> > bugs : https://bugs.koha-community.org/
> _______________________________________________
> Koha-devel mailing list
> Koha-devel@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/


------------------------------

Message: 3
Date: Mon, 18 Oct 2021 12:36:31 -0300
From: Tomas Cohen Arazi <tomascohen@gmail.com>
To: Stephen Graham <s.graham4@herts.ac.uk>
Cc: Jonathan Druart <jonathan.druart@bugs.koha-community.org>,
    koha-devel <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Changing the lost card value
Message-ID:
    <CABZfb=WYB0RMZ1g9foAs3zhkZx3REY_oz_gOku6ttev3-TYgaw@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

You need to run it inside koha-shell

El lun., 18 oct. 2021 12:30, Stephen Graham <s.graham4@herts.ac.uk>
escribió:

> Actually I just testing this now and cannot get it to work. I'm getting an
> error about not being able to write to the plack-opac-error.log file. I'm
> logged in as the usual koha user, and it's for a non-web script - never
> seen that before. I guess it's not working and it's trying to log the error
> to the plack log.
>
> I have the below, it's print User has a lost card, and then bombs out.
>
> my $user = Koha::Patrons->find($userid);
> if ($user->lost) {
> print "User has a lost card\n";
> $user->lost(0)->store();
> } else {
> print "NO lost card\n";
> }
>
> Stephen
>
> -----Original Message-----
> From: Stephen Graham
> Sent: 18 October 2021 14:04
> To: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
> Cc: koha-devel <koha-devel@lists.koha-community.org>
> Subject: RE: [Koha-devel] Changing the lost card value
>
> Thanks Jonathan. I understand that the find method returns a Patron
> object, but don't understand where lost comes from. It's not a method in
> Patron is it? I guess it's a shortcut to update any individual database
> field value?
>
> Stephen
>
> -----Original Message-----
> From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
> Sent: 18 October 2021 12:37
> To: Stephen Graham <s.graham4@herts.ac.uk>
> Cc: koha-devel <koha-devel@lists.koha-community.org>
> Subject: Re: [Koha-devel] Changing the lost card value
>
> Hi Stephen,
>
> You can use
> Koha::Patrons->find(42)->lost(0)->store;
> to set borrowers.lost to 0 for patron with borrowernumber=42.
>
> Cheers,
> Jonathan
>
> Le lun. 18 oct. 2021 à 12:47, Stephen Graham <s.graham4@herts.ac.uk> a
> écrit :
> >
> > Sorry if this is a basic question. I’ve searched through the
> Koha::Patron and C4::Members perldoc and had a quick look through the
> memberentry.pl code to see how this handles it, but I can’t seem to work
> out how it done. I want to change the value of the lost card field to zero.
> I can see the “lost” field in the borrowers table, so could update the
> value directly via SQL, but there must be a Koha method that I can use to
> do this? Any help/advice much appreciated!
> >
> >
> >
> > Cheers, Stephen
> >
> >
> >
> > --------------------------------------
> >
> > Stephen Graham
> >
> > Library Technology Consultant
> >
> > Library and Computing Services
> >
> >
> >
> > University of Hertfordshire
> >
> > Hatfield, Hertfordshire, AL10 9AB
> >
> >
> >
> > Tel: +44(0)1707 286111
> >
> > Ext: 77751
> >
> > Email: s.graham4@herts.ac.uk
> >
> > Website: herts.ac.uk
> >
> >
> >
> > _______________________________________________
> > Koha-devel mailing list
> > Koha-devel@lists.koha-community.org
> > https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> > website : https://www.koha-community.org/ git :
> > https://git.koha-community.org/ bugs :
> > https://bugs.koha-community.org/
> _______________________________________________
> Koha-devel mailing list
> Koha-devel@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20211018/d4487b3d/attachment-0001.htm>

------------------------------

Subject: Digest Footer

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


------------------------------

End of Koha-devel Digest, Vol 191, Issue 12
*******************************************