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
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
265
  `altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower
266
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
266
  `smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on)
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
  `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 8672-8677 if ( CheckVersion($DBversion) ) { Link Here
8672
    print "Upgrade to $DBversion done (Bug 10402: Move bookseller contacts to separate table)\n";
8672
    print "Upgrade to $DBversion done (Bug 10402: Move bookseller contacts to separate table)\n";
8673
    SetVersion($DBversion);
8673
    SetVersion($DBversion);
8674
}
8674
}
8675
$DBversion = "XXX";
8676
if ( CheckVersion($DBversion) ) {
8677
    $dbh->do("ALTER TABLE `borrowers` ADD COLUMN `primary_contact_method` VARCHAR(45) NULL DEFAULT NULL;");
8678
    print "Upgrade to $DBversion done (Bug 11879: Add a new borrower field : main contact method)\n";
8679
    SetVersion($DBversion);
8680
}
8675
8681
8676
$DBversion = "3.17.00.017";
8682
$DBversion = "3.17.00.017";
8677
if ( CheckVersion($DBversion) ) {
8683
if ( CheckVersion($DBversion) ) {
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/members/memberentrygen.tt (-2 / +37 lines)
Lines 164-170 Link Here
164
164
165
                <form name="form_double" action="/cgi-bin/koha/members/memberentry.pl" method="post" autocomplete="off">
165
                <form name="form_double" action="/cgi-bin/koha/members/memberentry.pl" method="post" autocomplete="off">
166
				<input type="hidden" name="nodouble" value="1" />
166
				<input type="hidden" name="nodouble" value="1" />
167
				<input class="new" type="submit" value="Not a duplicate. Save as new record" />
167
                <input class="new" type="submit" value="Not a duplicate. Save as new record" />
168
			</div>
168
			</div>
169
	[% END %]
169
	[% END %]
170
170
Lines 648-653 Link Here
648
        <input type="text" id="fax" name="fax" value="[% fax %]" />
648
        <input type="text" id="fax" name="fax" value="[% fax %]" />
649
	  [% IF ( mandatoryfax ) %]<span class="required">Required</span>[% END %]
649
	  [% IF ( mandatoryfax ) %]<span class="required">Required</span>[% END %]
650
    </li>
650
    </li>
651
    <li>
652
       <label for="primary_contact_method">Main Contact Method</label>
653
       <select id="primary_contact_method" name="primary_contact_method">
654
       <option value=""></option>
655
            [% IF ( primary_contact_method == 'phone' ) %]
656
                <option value="phone" selected="selected">Primary phone</option>
657
            [% ELSE %]
658
                <option value="phone">Primary phone</option>
659
            [% END %]
660
            [% IF ( primary_contact_method == 'phonepro' ) %]
661
                <option value="phonepro" selected="selected">Secondary phone</option>
662
            [% ELSE %]
663
                <option value="phonepro">Secondary phone</option>
664
            [% END %]
665
            [% IF ( primary_contact_method == 'mobile' ) %]
666
                <option value="mobile" selected="selected">Other phone</option>
667
            [% ELSE %]
668
                <option value="mobile">Other phone</option>
669
            [% END %]
670
            [% IF ( primary_contact_method == 'email' ) %]
671
                <option value="email" selected="selected">Primary email</option>
672
            [% ELSE %]
673
                <option value="email">Primary email</option>
674
            [% END %]
675
            [% IF ( primary_contact_method == 'emailpro' ) %]
676
                <option value="emailpro" selected="selected">Secondary email</option>
677
            [% ELSE %]
678
                <option value="emailpro">Secondary email</option>
679
            [% END %]
680
            [% IF ( primary_contact_method == 'fax' ) %]
681
                <option value="fax" selected="selected">Fax</option>
682
            [% ELSE %]
683
                <option value="fax">Fax</option>
684
            [% END %]
685
       </select>
686
    </li>
651
        [% END %]
687
        [% END %]
652
	</ol>
688
	</ol>
653
  </fieldset>
689
  </fieldset>
654
- 

Return to bug 11879