Bugzilla – Attachment 48073 Details for
Bug 11879
Add a new field to patron record: main contact method
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 11879 - Add a new borrower field : main contact method. (Was: Rebased on current master for testing)
Bug-11879---Add-a-new-borrower-field--main-contact.patch (text/plain), 5.16 KB, created by
Rémi Mayrand-Provencher
on 2016-02-15 19:06:24 UTC
(
hide
)
Description:
Bug 11879 - Add a new borrower field : main contact method. (Was: Rebased on current master for testing)
Filename:
MIME Type:
Creator:
Rémi Mayrand-Provencher
Created:
2016-02-15 19:06:24 UTC
Size:
5.16 KB
patch
obsolete
>From b15433c83509fb86cb6b6f720b144ddd825192f4 Mon Sep 17 00:00:00 2001 >From: simith <simith@inlibro.com> >Date: Tue, 2 Sep 2014 08:52:38 -0400 >Subject: [PATCH] Bug 11879 - Add a new borrower field : main contact method. > (Was: Rebased on current master for testing) > >http://bugs.koha-community.org/show_bug.cgi?id=11879 > >To test this patch: >Update database >Edit a borrower's informations. >The "Main Contact Method" selectbox appears in the form and its >value is correctly. > >Works as expected. >For handling of syspref BorrowerUnwantedField use second patch- > >Signed-off-by: Marc Veron <veron@veron.ch> > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > installer/data/mysql/kohastructure.sql | 1 + > installer/data/mysql/updatedatabase.pl | 6 ++++ > .../prog/en/modules/members/memberentrygen.tt | 38 +++++++++++++++++++++- > 3 files changed, 44 insertions(+), 1 deletion(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index b98b017..4756558 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -265,6 +265,7 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons > `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) > `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history > `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts >+ `primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes > UNIQUE KEY `cardnumber` (`cardnumber`), > PRIMARY KEY `borrowernumber` (`borrowernumber`), > KEY `categorycode` (`categorycode`), >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 8ee4088..22eb351 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -8719,6 +8719,12 @@ if ( CheckVersion($DBversion) ) { > print "Upgrade to $DBversion done (Bug 10402: Move bookseller contacts to separate table)\n"; > SetVersion($DBversion); > } >+$DBversion = "XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do("ALTER TABLE `borrowers` ADD COLUMN `primary_contact_method` VARCHAR(45) NULL DEFAULT NULL;"); >+ print "Upgrade to $DBversion done (Bug 11879: Add a new borrower field : main contact method)\n"; >+ SetVersion($DBversion); >+} > > $DBversion = "3.17.00.017"; > if ( CheckVersion($DBversion) ) { >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/members/memberentrygen.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/members/memberentrygen.tt >index 8a8d3d4..3b42c52 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/members/memberentrygen.tt >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/members/memberentrygen.tt >@@ -204,7 +204,7 @@ > > <form name="form_double" action="/cgi-bin/koha/members/memberentry.pl" method="post" autocomplete="off"> > <input type="hidden" name="nodouble" value="1" /> >- <input class="new" type="submit" value="Not a duplicate. Save as new record" /> >+ <input class="new" type="submit" value="Not a duplicate. Save as new record" /> > </div> > [% END %] > >@@ -593,6 +593,42 @@ > <input type="text" id="fax" name="fax" value="[% fax %]" /> > [% IF ( mandatoryfax ) %]<span class="required">Required</span>[% END %] > </li> >+ <li> >+ <label for="primary_contact_method">Main Contact Method</label> >+ <select id="primary_contact_method" name="primary_contact_method"> >+ <option value=""></option> >+ [% IF ( primary_contact_method == 'phone' ) %] >+ <option value="phone" selected="selected">Primary phone</option> >+ [% ELSE %] >+ <option value="phone">Primary phone</option> >+ [% END %] >+ [% IF ( primary_contact_method == 'phonepro' ) %] >+ <option value="phonepro" selected="selected">Secondary phone</option> >+ [% ELSE %] >+ <option value="phonepro">Secondary phone</option> >+ [% END %] >+ [% IF ( primary_contact_method == 'mobile' ) %] >+ <option value="mobile" selected="selected">Other phone</option> >+ [% ELSE %] >+ <option value="mobile">Other phone</option> >+ [% END %] >+ [% IF ( primary_contact_method == 'email' ) %] >+ <option value="email" selected="selected">Primary email</option> >+ [% ELSE %] >+ <option value="email">Primary email</option> >+ [% END %] >+ [% IF ( primary_contact_method == 'emailpro' ) %] >+ <option value="emailpro" selected="selected">Secondary email</option> >+ [% ELSE %] >+ <option value="emailpro">Secondary email</option> >+ [% END %] >+ [% IF ( primary_contact_method == 'fax' ) %] >+ <option value="fax" selected="selected">Fax</option> >+ [% ELSE %] >+ <option value="fax">Fax</option> >+ [% END %] >+ </select> >+ </li> > [% END %] > </ol> > </fieldset> >-- >1.9.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 11879
:
25745
|
25922
|
25941
|
31300
|
31301
|
31320
|
34351
|
34482
|
34502
|
34503
|
34571
|
34572
|
34573
|
41209
|
41220
|
41221
|
41222
|
46101
|
46284
|
46285
|
46286
|
48073
|
48074
|
48075
|
48076
|
48077
|
48078
|
48079
|
48556
|
48557
|
48558
|
48559
|
50433
|
52607
|
52608
|
52614
|
52615
|
52616
|
52617
|
52618
|
52619
|
52620
|
53229
|
53688
|
53695
|
53705
|
53707
|
53708
|
53709
|
53710
|
53711
|
53712
|
53713
|
55946
|
56285
|
56286
|
58580
|
58591
|
58592
|
58593
|
63238
|
63239
|
65811
|
65812
|
69028
|
69029
|
69050
|
71955
|
71956
|
71957
|
71958
|
72632
|
72633
|
72634
|
72635
|
73987
|
73988
|
73989
|
73990
|
74123
|
74124
|
74125
|
74126
|
74818
|
75652
|
83757
|
83758
|
84017
|
84018
|
84019
|
84020
|
84021
|
84022
|
88358
|
88359
|
88360
|
88361
|
88362
|
88363
|
88394
|
88395
|
88396
|
88397
|
88398
|
88399
|
88400
|
93850
|
93851
|
93852
|
93853
|
93854
|
93855
|
93856
|
93900
|
93901
|
94456
|
94457
|
94458
|
94459
|
94460
|
94461
|
94463
|
94464
|
94465
|
94466
|
94467
|
94468
|
96432
|
100817
|
100843
|
112062
|
112063
|
112064
|
112557
|
112559
|
112560
|
118959
|
118960
|
118961
|
118962
|
118985
|
118986
|
118987
|
118988
|
120947
|
120948
|
120949
|
120950
|
122778