From bfea5be35e97ff46bc322ebdc2b6c1b690255915 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Tue, 28 Jun 2011 00:11:40 +0200 Subject: [PATCH] borrower_message_preferences --- ferlib2koha.pl | 21 ++++++++++++++++++++- 1 file changed, 20 insertions(+), 1 deletion(-) diff --git a/ferlib2koha.pl b/ferlib2koha.pl index 47e1a3c..fdec3c7 100755 --- a/ferlib2koha.pl +++ b/ferlib2koha.pl @@ -107,12 +107,29 @@ sub borrowers { insert 'borrowers' => $row; + my $borrowernumber = $k->{mysql_insertid}; + insert 'borrower_attributes' => { - borrowernumber => $k->{mysql_insertid}, + borrowernumber => $borrowernumber, code => 'JMBG', attribute => $jmbg, } if $jmbg; + foreach my $id ( 6,1,4,5,2 ) { + + insert 'borrower_message_preferences' => { + borrowernumber => $borrowernumber, + message_attribute_id => $id, + days_in_advance => $id == 2 ? 0 : undef, + }; + + insert 'borrower_message_transport_preferences' => { + borrower_message_preference_id => $k->{mysql_insertid}, + message_transport_type => 'email', + } if $id == 4; + + } + } } @@ -132,6 +149,8 @@ delete from borrowers; alter table borrowers auto_increment = 1; delete from borrower_attributes; alter table borrower_attributes auto_increment = 1; +delete from borrower_message_preferences where borrowernumber is not null ; +alter table borrower_message_preferences auto_increment = 1; }; -- 2.20.1