FFZG: remove debarrment from borrowers with expirydate next year

[koha_ffzg] / ffzg / remove-debarred / remove-debared.sql

diff --git a/ffzg/remove-debarred/remove-debared.sql b/ffzg/remove-debarred/remove-debared.sql
new file mode 100644 (file)
index 0000000..b51f697
--- /dev/null
+++ b/ffzg/remove-debarred/remove-debared.sql
@@ -0,0 +1,9 @@
+create temporary table remove_debarred as 
+select b.borrowernumber, userid, dateexpiry from borrower_debarments bd join borrowers b on b.borrowernumber = bd.borrowernumber where bd.type = 'DISCHARGE' and year(dateexpiry) = year( now() + interval 1 year ) ;
+
+select * from remove_debarred ;
+
+delete from borrower_debarments where borrowernumber in (select borrowernumber from remove_debarred);
+
+update borrowers set debarred = null, debarredcomment = null where borrowernumber in (select borrowernumber from remove_debarred);
+