From a09fc08c373c924e06b457f16c05d592aa12fd26 Mon Sep 17 00:00:00 2001 From: wolfpac444 Date: Tue, 25 Mar 2003 05:13:26 +0000 Subject: [PATCH] Added the stuff for the text messaging field -- Fixed bug #219 --- insertdata.pl | 6 +++--- .../default/en/members/memberentry.tmpl | 18 ++++++++++++++++-- .../default/en/members/moremember.tmpl | 2 +- .../intranet-tmpl/default/en/newmember.tmpl | 10 +++++++++- memberentry.pl | 1 + misc/koha.mysql | 1 + newmember.pl | 1 + 7 files changed, 32 insertions(+), 7 deletions(-) diff --git a/insertdata.pl b/insertdata.pl index 9e2f4bdfd7..fcc873ccd9 100755 --- a/insertdata.pl +++ b/insertdata.pl @@ -59,7 +59,7 @@ if (my $data=$sth->fetchrow_hashref){ categorycode='$data{'categorycode'}',city='$data{'city'}',area='$data{'area'}',phone='$data{'phone'}', borrowernotes='$data{'borrowernotes'}',altphone='$data{'altphone'}',surname='$data{'surname'}', initials='$data{'initials'}',physstreet='$data{'address'}',ethnicity='$data{'ethnicity'}', - gonenoaddress='$data{'gna'}',lost='$data{'lost'}',debarred='$data{'debarred'}' + gonenoaddress='$data{'gna'}',lost='$data{'lost'}',debarred='$data{'debarred'}',textmessaging='$data{'textmessaging'}' where borrowernumber=$data{'borrowernumber'}"; # print $query; @@ -69,11 +69,11 @@ if (my $data=$sth->fetchrow_hashref){ $data{'joining'}=ParseDate($data{'joining'}); $data{'joining'}=UnixDate($data{'joining'},'%Y-%m-%d'); $query="insert into borrowers (title,expiry,cardnumber,sex,ethnotes,streetaddress,faxnumber, - firstname,altnotes,dateofbirth,contactname,emailaddress,dateenrolled,streetcity, + firstname,altnotes,dateofbirth,contactname,emailaddress,textmessaging,dateenrolled,streetcity, altrelationship,othernames,phoneday,categorycode,city,area,phone,borrowernotes,altphone,surname, initials,ethnicity,borrowernumber) values ('$data{'title'}','$data{'expiry'}','$data{'cardnumber'}', '$data{'sex'}','$data{'ethnotes'}','$data{'address'}','$data{'faxnumber'}', - '$data{'firstname'}','$data{'altnotes'}','$data{'dateofbirth'}','$data{'contactname'}','$data{'emailaddress'}', + '$data{'firstname'}','$data{'altnotes'}','$data{'dateofbirth'}','$data{'contactname'}','$data{'emailaddress'}','$data{'textmessaging'}', '$data{'joining'}','$data{'streetcity'}','$data{'altrelationship'}','$data{'othernames'}', '$data{'phoneday'}','$data{'categorycode'}','$data{'city'}','$data{'area'}','$data{'phone'}', '$data{'borrowernotes'}','$data{'altphone'}','$data{'surname'}','$data{'initials'}', diff --git a/koha-tmpl/intranet-tmpl/default/en/members/memberentry.tmpl b/koha-tmpl/intranet-tmpl/default/en/members/memberentry.tmpl index 82f11c7e09..3d2667c539 100644 --- a/koha-tmpl/intranet-tmpl/default/en/members/memberentry.tmpl +++ b/koha-tmpl/intranet-tmpl/default/en/members/memberentry.tmpl @@ -115,16 +115,30 @@ - + Phone (Home) - Phone (day) Fax Email + Text Messaging + + + + + + + + + + + Phone (Day) + + + diff --git a/koha-tmpl/intranet-tmpl/default/en/members/moremember.tmpl b/koha-tmpl/intranet-tmpl/default/en/members/moremember.tmpl index 0db9b03eff..4b281c74bb 100644 --- a/koha-tmpl/intranet-tmpl/default/en/members/moremember.tmpl +++ b/koha-tmpl/intranet-tmpl/default/en/members/moremember.tmpl @@ -28,7 +28,7 @@ Phone (Daytime):
Fax:
E-mail: ">
- Textmessaging:

+ Text messaging:

Membership Number:
Membership:
Area:
diff --git a/koha-tmpl/intranet-tmpl/default/en/newmember.tmpl b/koha-tmpl/intranet-tmpl/default/en/newmember.tmpl index b789a5d507..66e85d4a17 100644 --- a/koha-tmpl/intranet-tmpl/default/en/newmember.tmpl +++ b/koha-tmpl/intranet-tmpl/default/en/newmember.tmpl @@ -187,6 +187,14 @@ + + + Text messaging + + + + + " > "> ALTERNATIVE CONTACT DETAIL @@ -255,4 +263,4 @@ - \ No newline at end of file + diff --git a/memberentry.pl b/memberentry.pl index 054a1522bc..a8f029e981 100755 --- a/memberentry.pl +++ b/memberentry.pl @@ -195,6 +195,7 @@ if ($delete){ phoneday => $data->{'phoneday'}, faxnumber => $data->{'faxnumber'}, emailaddress => $data->{'emailaddress'}, + textmessaging => $data->{'textmessaging'}, contactname => $data->{'contactname'}, altphone => $data->{'altphone'}, altnotes => $data->{'altnotes'}, diff --git a/misc/koha.mysql b/misc/koha.mysql index f7532d6872..7fa45e5ad7 100644 --- a/misc/koha.mysql +++ b/misc/koha.mysql @@ -266,6 +266,7 @@ CREATE TABLE borrowers ( phone text NOT NULL, emailaddress text, faxnumber text, + textmessaging text, altstreetaddress text, altsuburb text, altcity text, diff --git a/newmember.pl b/newmember.pl index 070293c72e..5d1bee5fcf 100755 --- a/newmember.pl +++ b/newmember.pl @@ -167,6 +167,7 @@ if ($ok == 0) { phoneday => $data{'phoneday'}, faxnumber => $data{'faxnumber'}, emailaddress => $data{'emailaddress'}, + textmessaging => $data{'textmessaging'}, contactname => $data{'contactname'}, altphone => $data{'altphone'}, altrelationship => $data{'altrelationship'}, -- 2.39.2