View | Details | Raw Unified | Return to bug 11879
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 266-271 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
266
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
266
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
267
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
267
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
268
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
268
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
269
  `primary_contact_method` varchar(45) DEFAULT NULL, --  useful for reporting purposes
269
  UNIQUE KEY `cardnumber` (`cardnumber`),
270
  UNIQUE KEY `cardnumber` (`cardnumber`),
270
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
271
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
271
  KEY `categorycode` (`categorycode`),
272
  KEY `categorycode` (`categorycode`),
(-)a/installer/data/mysql/updatedatabase.pl (+6 lines)
Lines 8719-8724 if ( CheckVersion($DBversion) ) { Link Here
8719
    print "Upgrade to $DBversion done (Bug 10402: Move bookseller contacts to separate table)\n";
8719
    print "Upgrade to $DBversion done (Bug 10402: Move bookseller contacts to separate table)\n";
8720
    SetVersion($DBversion);
8720
    SetVersion($DBversion);
8721
}
8721
}
8722
$DBversion = "XXX";
8723
if ( CheckVersion($DBversion) ) {
8724
    $dbh->do("ALTER TABLE `borrowers` ADD COLUMN `primary_contact_method` VARCHAR(45) NULL DEFAULT NULL;");
8725
    print "Upgrade to $DBversion done (Bug 11879: Add a new borrower field : main contact method)\n";
8726
    SetVersion($DBversion);
8727
}
8722
8728
8723
$DBversion = "3.17.00.017";
8729
$DBversion = "3.17.00.017";
8724
if ( CheckVersion($DBversion) ) {
8730
if ( CheckVersion($DBversion) ) {
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/members/memberentrygen.tt (-2 / +37 lines)
Lines 203-209 Link Here
203
203
204
                <form name="form_double" action="/cgi-bin/koha/members/memberentry.pl" method="post" autocomplete="off">
204
                <form name="form_double" action="/cgi-bin/koha/members/memberentry.pl" method="post" autocomplete="off">
205
				<input type="hidden" name="nodouble" value="1" />
205
				<input type="hidden" name="nodouble" value="1" />
206
				<input class="new" type="submit" value="Not a duplicate. Save as new record" />
206
                <input class="new" type="submit" value="Not a duplicate. Save as new record" />
207
			</div>
207
			</div>
208
	[% END %]
208
	[% END %]
209
209
Lines 577-582 Link Here
577
        <input type="text" id="fax" name="fax" value="[% fax %]" />
577
        <input type="text" id="fax" name="fax" value="[% fax %]" />
578
	  [% IF ( mandatoryfax ) %]<span class="required">Required</span>[% END %]
578
	  [% IF ( mandatoryfax ) %]<span class="required">Required</span>[% END %]
579
    </li>
579
    </li>
580
    <li>
581
       <label for="primary_contact_method">Main Contact Method</label>
582
       <select id="primary_contact_method" name="primary_contact_method">
583
       <option value=""></option>
584
            [% IF ( primary_contact_method == 'phone' ) %]
585
                <option value="phone" selected="selected">Primary phone</option>
586
            [% ELSE %]
587
                <option value="phone">Primary phone</option>
588
            [% END %]
589
            [% IF ( primary_contact_method == 'phonepro' ) %]
590
                <option value="phonepro" selected="selected">Secondary phone</option>
591
            [% ELSE %]
592
                <option value="phonepro">Secondary phone</option>
593
            [% END %]
594
            [% IF ( primary_contact_method == 'mobile' ) %]
595
                <option value="mobile" selected="selected">Other phone</option>
596
            [% ELSE %]
597
                <option value="mobile">Other phone</option>
598
            [% END %]
599
            [% IF ( primary_contact_method == 'email' ) %]
600
                <option value="email" selected="selected">Primary email</option>
601
            [% ELSE %]
602
                <option value="email">Primary email</option>
603
            [% END %]
604
            [% IF ( primary_contact_method == 'emailpro' ) %]
605
                <option value="emailpro" selected="selected">Secondary email</option>
606
            [% ELSE %]
607
                <option value="emailpro">Secondary email</option>
608
            [% END %]
609
            [% IF ( primary_contact_method == 'fax' ) %]
610
                <option value="fax" selected="selected">Fax</option>
611
            [% ELSE %]
612
                <option value="fax">Fax</option>
613
            [% END %]
614
       </select>
615
    </li>
580
        [% END %]
616
        [% END %]
581
	</ol>
617
	</ol>
582
  </fieldset>
618
  </fieldset>
583
- 

Return to bug 11879