[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')|;