Attachment #34633 for bug #9303

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




$DBversion = "3.19.00.XXX";
if(CheckVersion($DBversion)) {
    $dbh->do(q{
        ALTER TABLE borrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy
    });
    $dbh->do(q{
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy
    });
    $dbh->do(q{
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL PRIMARY KEY FIRST
    });
    $dbh->do(q{
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST




            [% END %]
            <input id="guarantordelete" type="button" value="Delete" />
        </li>
    [% IF guarantorid && Koha.Preference('AllowStaffToSetCheckoutsVisibilityForGuarantor') %]
        <li>
            <label for="privacy_guarantor_checkouts">Show checkouts to guarantor</label>
            <select name="privacy_guarantor_checkouts" id="privacy_guarantor_checkouts">
                [% IF privacy_guarantor_checkouts %]
                    <option value="0">No</option>
                    <option value="1" selected>Yes</option>
                [% ELSE %]
                    <option value="0" selected>No</option>
                    <option value="1">Yes</option>
                [% END %]
            </select>
            <div class="hint">Allow guarantor of this patron to view this patron's checkouts from the OPAC</div>
        </li>
    [% END %]
        </ol>
    </fieldset>


			[% END %]
	  [% IF ( mandatorypassword ) %]<span class="required">Required</span>[% END %][% IF ( ERROR_password_mismatch ) %]<span class="required">Passwords do not match</span>[% END %]
		</li>
        [% IF guarantorid && Koha.Preference('AllowStaffToSetCheckoutsVisibilityForGuarantor') %]
            <li>
                <label for="privacy_guarantor_checkouts">Show checkouts to guarantor</label>
                <select name="privacy_guarantor_checkouts" id="privacy_guarantor_checkouts">
                    [% IF privacy_guarantor_checkouts %]
                        <option value="0">No</option>
                        <option value="1" selected>Yes</option>
                    [% ELSE %]
                        <option value="0" selected>No</option>
                        <option value="1">Yes</option>
                    [% END %]
                </select>
                <div class="hint">Allow guarantor of this patron to view this patron's checkouts from the OPAC</div>
            </li>
        [% END %]
		</ol>
		</fieldset>
        [% END # hide fieldset %][% END %]
- 

Return to bug 9303

Lines 9612-9624 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-3 / +3 lines)
9612	$DBversion = "3.19.00.XXX";	9612	$DBversion = "3.19.00.XXX";
9613	if(CheckVersion($DBversion)) {	9613	if(CheckVersion($DBversion)) {
9614	$dbh->do(q{	9614	$dbh->do(q{
9615	ALTER TABLE borrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'	9615	ALTER TABLE borrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy
9616	});	9616	});
9617	$dbh->do(q{	9617	$dbh->do(q{
9618	ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0'	9618	ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy
9619	});	9619	});
9620	$dbh->do(q{	9620	$dbh->do(q{
9621	ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST	9621	ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL PRIMARY KEY FIRST
9622	});	9622	});
9623	$dbh->do(q{	9623	$dbh->do(q{
9624	ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST	9624	ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST

Lines 442-447 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/members/memberentrygen.tt (-16 / +15 lines)
442	[% END %]	442	[% END %]
443	<input id="guarantordelete" type="button" value="Delete" />	443	<input id="guarantordelete" type="button" value="Delete" />
444	</li>	444	</li>
		445	[% IF guarantorid && Koha.Preference('AllowStaffToSetCheckoutsVisibilityForGuarantor') %]
		446	<li>
		447	<label for="privacy_guarantor_checkouts">Show checkouts to guarantor</label>
		448	<select name="privacy_guarantor_checkouts" id="privacy_guarantor_checkouts">
		449	[% IF privacy_guarantor_checkouts %]
		450	<option value="0">No</option>
		451	<option value="1" selected>Yes</option>
		452	[% ELSE %]
		453	<option value="0" selected>No</option>
		454	<option value="1">Yes</option>
		455	[% END %]
		456	</select>
		457	<div class="hint">Allow guarantor of this patron to view this patron's checkouts from the OPAC</div>
		458	</li>
		459	[% END %]
445	</ol>	460	</ol>
446	</fieldset>	461	</fieldset>
447		462
Lines 1186-1206 Link Here
1186	[% END %]	1201	[% END %]
1187	[% IF ( mandatorypassword ) %]<span class="required">Required</span>[% END %][% IF ( ERROR_password_mismatch ) %]<span class="required">Passwords do not match</span>[% END %]	1202	[% IF ( mandatorypassword ) %]<span class="required">Required</span>[% END %][% IF ( ERROR_password_mismatch ) %]<span class="required">Passwords do not match</span>[% END %]
1188	</li>	1203	</li>
1189	[% IF guarantorid && Koha.Preference('AllowStaffToSetCheckoutsVisibilityForGuarantor') %]
1190	<li>
1191	<label for="privacy_guarantor_checkouts">Show checkouts to guarantor</label>
1192	<select name="privacy_guarantor_checkouts" id="privacy_guarantor_checkouts">
1193	[% IF privacy_guarantor_checkouts %]
1194	<option value="0">No</option>
1195	<option value="1" selected>Yes</option>
1196	[% ELSE %]
1197	<option value="0" selected>No</option>
1198	<option value="1">Yes</option>
1199	[% END %]
1200	</select>
1201	<div class="hint">Allow guarantor of this patron to view this patron's checkouts from the OPAC</div>
1202	</li>
1203	[% END %]
1204	</ol>	1204	</ol>
1205	</fieldset>	1205	</fieldset>
1206	[% END # hide fieldset %][% END %]	1206	[% END # hide fieldset %][% END %]
1207	-