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

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
Lines 265-270 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
265
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
265
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
266
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
266
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
267
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
267
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
268
  `primary_contact_method` varchar(45) DEFAULT NULL, --  useful for reporting purposes
268
  UNIQUE KEY `cardnumber` (`cardnumber`),
269
  UNIQUE KEY `cardnumber` (`cardnumber`),
269
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
270
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
270
  KEY `categorycode` (`categorycode`),
271
  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 204-210 Link Here
204
204
205
                <form name="form_double" action="/cgi-bin/koha/members/memberentry.pl" method="post" autocomplete="off">
205
                <form name="form_double" action="/cgi-bin/koha/members/memberentry.pl" method="post" autocomplete="off">
206
				<input type="hidden" name="nodouble" value="1" />
206
				<input type="hidden" name="nodouble" value="1" />
207
				<input class="new" type="submit" value="Not a duplicate. Save as new record" />
207
                <input class="new" type="submit" value="Not a duplicate. Save as new record" />
208
			</div>
208
			</div>
209
	[% END %]
209
	[% END %]
210
210
Lines 593-598 Link Here
593
        <input type="text" id="fax" name="fax" value="[% fax %]" />
593
        <input type="text" id="fax" name="fax" value="[% fax %]" />
594
	  [% IF ( mandatoryfax ) %]<span class="required">Required</span>[% END %]
594
	  [% IF ( mandatoryfax ) %]<span class="required">Required</span>[% END %]
595
    </li>
595
    </li>
596
    <li>
597
       <label for="primary_contact_method">Main Contact Method</label>
598
       <select id="primary_contact_method" name="primary_contact_method">
599
       <option value=""></option>
600
            [% IF ( primary_contact_method == 'phone' ) %]
601
                <option value="phone" selected="selected">Primary phone</option>
602
            [% ELSE %]
603
                <option value="phone">Primary phone</option>
604
            [% END %]
605
            [% IF ( primary_contact_method == 'phonepro' ) %]
606
                <option value="phonepro" selected="selected">Secondary phone</option>
607
            [% ELSE %]
608
                <option value="phonepro">Secondary phone</option>
609
            [% END %]
610
            [% IF ( primary_contact_method == 'mobile' ) %]
611
                <option value="mobile" selected="selected">Other phone</option>
612
            [% ELSE %]
613
                <option value="mobile">Other phone</option>
614
            [% END %]
615
            [% IF ( primary_contact_method == 'email' ) %]
616
                <option value="email" selected="selected">Primary email</option>
617
            [% ELSE %]
618
                <option value="email">Primary email</option>
619
            [% END %]
620
            [% IF ( primary_contact_method == 'emailpro' ) %]
621
                <option value="emailpro" selected="selected">Secondary email</option>
622
            [% ELSE %]
623
                <option value="emailpro">Secondary email</option>
624
            [% END %]
625
            [% IF ( primary_contact_method == 'fax' ) %]
626
                <option value="fax" selected="selected">Fax</option>
627
            [% ELSE %]
628
                <option value="fax">Fax</option>
629
            [% END %]
630
       </select>
631
    </li>
596
        [% END %]
632
        [% END %]
597
	</ol>
633
	</ol>
598
  </fieldset>
634
  </fieldset>
599
- 

Return to bug 11879