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
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
266
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
267
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
267
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
268
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
268
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
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 77-83 Link Here
77
77
78
                <form name="form_double" action="/cgi-bin/koha/members/memberentry.pl" method="post" autocomplete="off">
78
                <form name="form_double" action="/cgi-bin/koha/members/memberentry.pl" method="post" autocomplete="off">
79
				<input type="hidden" name="nodouble" value="1" />
79
				<input type="hidden" name="nodouble" value="1" />
80
				<input class="new" type="submit" value="Not a duplicate. Save as new record" />
80
                <input class="new" type="submit" value="Not a duplicate. Save as new record" />
81
			</div>
81
			</div>
82
	[% END %]
82
	[% END %]
83
83
Lines 466-471 Link Here
466
        <input type="text" id="fax" name="fax" value="[% fax %]" />
466
        <input type="text" id="fax" name="fax" value="[% fax %]" />
467
	  [% IF ( mandatoryfax ) %]<span class="required">Required</span>[% END %]
467
	  [% IF ( mandatoryfax ) %]<span class="required">Required</span>[% END %]
468
    </li>
468
    </li>
469
    <li>
470
       <label for="primary_contact_method">Main Contact Method</label>
471
       <select id="primary_contact_method" name="primary_contact_method">
472
       <option value=""></option>
473
            [% IF ( primary_contact_method == 'phone' ) %]
474
                <option value="phone" selected="selected">Primary phone</option>
475
            [% ELSE %]
476
                <option value="phone">Primary phone</option>
477
            [% END %]
478
            [% IF ( primary_contact_method == 'phonepro' ) %]
479
                <option value="phonepro" selected="selected">Secondary phone</option>
480
            [% ELSE %]
481
                <option value="phonepro">Secondary phone</option>
482
            [% END %]
483
            [% IF ( primary_contact_method == 'mobile' ) %]
484
                <option value="mobile" selected="selected">Other phone</option>
485
            [% ELSE %]
486
                <option value="mobile">Other phone</option>
487
            [% END %]
488
            [% IF ( primary_contact_method == 'email' ) %]
489
                <option value="email" selected="selected">Primary email</option>
490
            [% ELSE %]
491
                <option value="email">Primary email</option>
492
            [% END %]
493
            [% IF ( primary_contact_method == 'emailpro' ) %]
494
                <option value="emailpro" selected="selected">Secondary email</option>
495
            [% ELSE %]
496
                <option value="emailpro">Secondary email</option>
497
            [% END %]
498
            [% IF ( primary_contact_method == 'fax' ) %]
499
                <option value="fax" selected="selected">Fax</option>
500
            [% ELSE %]
501
                <option value="fax">Fax</option>
502
            [% END %]
503
       </select>
504
    </li>
469
        [% END %]
505
        [% END %]
470
	</ol>
506
	</ol>
471
  </fieldset>
507
  </fieldset>
472
- 

Return to bug 11879