[Koha-cvs] koha/misc/cronjobs j2a.pl [rel_3_0]

[Bruno Toumi]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_3_0
Changes by:     Bruno Toumi <btoumi>    06/12/21 15:21:02

Modified files:
        misc/cronjobs  : j2a.pl 

Log message:
        add delete  the guarantorid for members j2a script

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/cronjobs/j2a.pl?cvsroot=koha&only_with_tag=rel_3_0&r1=1.1.2.1&r2=1.1.2.2

Patches:
Index: j2a.pl
===================================================================
RCS file: /sources/koha/koha/misc/cronjobs/j2a.pl,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -b -r1.1.2.1 -r1.1.2.2
--- j2a.pl      7 Dec 2006 17:05:22 -0000       1.1.2.1
+++ j2a.pl      21 Dec 2006 15:21:02 -0000      1.1.2.2
@@ -15,7 +15,8 @@
 my $itsyourbirthday = "$year-$mon-$mday";
 
 my $query=qq|UPDATE borrowers 
-          SET categorycode='A' 
+          SET categorycode='A',
+           guarantorid ='0'     
           WHERE dateofbirth<=? 
           AND dateofbirth!='0000-00-00' 
           AND categorycode IN (select categorycode from categories where 
category_type='C')|;