Attachment #24753 for bug #11622

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

Lines 58-63 sub IsValid { Link Here

(-)a/Koha/Accounts/CreditTypes.pm (+10 lines)
58	\|\| $string eq Koha::Accounts::CreditTypes::Credit()	58	\|\| $string eq Koha::Accounts::CreditTypes::Credit()
59	\|\| $string eq Koha::Accounts::CreditTypes::Forgiven() );	59	\|\| $string eq Koha::Accounts::CreditTypes::Forgiven() );
60		60
		61	$is_valid \|\|= $string eq Koha::Accounts::CreditTypes::PayPal();
		62
61	unless ($is_valid) {	63	unless ($is_valid) {
62	$is_valid =	64	$is_valid =
63	Koha::Database->new()->schema->resultset('AuthorisedValue')	65	Koha::Database->new()->schema->resultset('AuthorisedValue')
Lines 108-113 sub Forgiven { Link Here
108	return 'FORGIVEN';	110	return 'FORGIVEN';
109	}	111	}
110		112
		113	=head2 PayPal
		114
		115	=cut
		116
		117	sub PayPal {
		118	return 'PAYPAL';
		119	}
		120
111	1;	121	1;
112		122
113	=head1 AUTHOR	123	=head1 AUTHOR




            - pref: PatronSelfRegistrationAdditionalInstructions
              type: textarea
              class: html
    Payments:
        -
            - pref: EnablePayPalOpacPayments
              default: 1
              choices:
                  yes: Allow
                  no: "Don't allow"
            - "patrons to make payments from the OPAC via PayPal in"
            - pref: PayPalSandboxMode 
              default: 1
              choices:
                  yes: "Sandbox"
                  no: "Production"
            - "mode."
        -
            - "The email address to recieve PayPal payments is "
            - pref: PayPalUser
              class: long
        -
            - "The password for the PayPal account to recieve payments is "
            - pref: PayPalPwd
              class: long
        -
            - "The signature for the PayPal account to recieve payments is "
            - pref: PayPalSignature
              class: long
        -
            - "The patron should see the charge description as "
            - pref: PayPalChargeDescription 
              class: long




[% USE Koha %]
[% USE KohaDates %]
[% USE Currency %]

[% INCLUDE 'doc-head-open.inc' %][% IF ( LibraryNameTitle ) %][% LibraryNameTitle %][% ELSE %]Koha online[% END %] catalog &rsaquo; Your fines and charges
[% INCLUDE 'doc-head-close.inc' %]
[% BLOCK cssinclude %][% END %]


</head>
<body id="opac-account" class="scrollto">
[% INCLUDE 'masthead.inc' %]

<div class="main">
    <ul class="breadcrumb">
        <li><a href="/cgi-bin/koha/opac-main.pl">Home</a> <span class="divider">&rsaquo;</span></li>
        <li><a href="/cgi-bin/koha/opac-user.pl">[% borrower.firstname %] [% borrower.surname %]</a> <span class="divider">&rsaquo;</span></li>
        <li><a href="#">Your fines and charges</a></li>
    </ul>

    <div class="container-fluid">
        <div class="row-fluid">
            <div class="span2">
                <div id="navigation">
                    [% INCLUDE 'navigation.inc' IsPatronPage=1 %]
                </div>
            </div>
            <div class="span10">
                <div id="useraccount" class="maincontent">
                    [% IF error %]
                        <div id="error" class="dialog alert">
                            <p><strong>Error:</strong> there was an problem processing your payment</p>

                            [% IF error == "PAYPAL_UNABLE_TO_CONNECT" %]
                                <p>Unable to connect to PayPal.</p>
                                <p>Please try again later.</p>
                            [% ELSIF error == "PAYPAL_ERROR_PROCESSING" %]
                                <p>Unable to verify payment.</p>
                                <p>Please contact the library to verify your payment.</p>
                            [% END %]
                        </div>
                    [% ELSIF credit %]
                        <div class="dialog message">
                            <p><strong>Payment applied:</strong> your payment of [% credit.amount_paid %] has been applied to your account</p>
                        </div>
                    [% END %]

                    <a href="/cgi-bin/koha/opac-account.pl">Return to fine details</a>
                </div> <!-- / #useraccount -->
            </div> <!-- / .span10 -->
        </div> <!-- / .row-fluid -->
    </div> <!-- / .container-fluid -->
</div> <!-- / .main -->

[% INCLUDE 'opac-bottom.inc' %]
[% INCLUDE 'datatables.inc' %]

<script type="text/javascript">
//<![CDATA[
$(document).ready(function() {
    $('#account-credits').hide();
    $('#account-debits-switcher').click(function() {
         $('#account-debits').slideUp();
         $('#account-credits').slideDown();
    });
    $('#account-credits-switcher').click(function() {
         $('#account-credits').slideUp();
         $('#account-debits').slideDown();
    });

    var anOpen = [];
    var sImageUrl = "[% interface %]/[% theme %]/images/";

    var debitsTable = $('#debits-table').dataTable( {
        "bProcessing": true,
        "aoColumns": [
            {
                "mDataProp": null,
                "sClass": "control center",
                "sDefaultContent": '<img src="'+sImageUrl+'details_open.png'+'">'
            },
            { "mDataProp": "debit_id" },
            { "mDataProp": "description" },
            { "mDataProp": "type" },
            { "mDataProp": "amount_original" },
            { "mDataProp": "amount_outstanding" },
            { "mDataProp": "created_on" },
            { "mDataProp": "updated_on" },
            {
                /* Payment selection checkboxes */
                [% UNLESS Koha.Preference('EnablePayPalOpacPayments') %]
                    "bVisible": false,
                [% END %]
                "mDataProp": null,
                "sDefaultContent": "", 
                "fnRender": function ( o, val ) {
                    return val;
                },
                "mRender": function ( data, type, full ) {
                    if ( full.amount_outstanding_unformatted > 0 ) {
                        return "<input class='pay-checkbox' name='debit_id' value='" + full.debit_id + "' type='checkbox'/>"
                            + "<input type='hidden' id='amount_outstanding_" + full.debit_id + "' value='" + full.amount_outstanding_unformatted + "'/>";
                    }
                }
            },
        ],
        "aaData": [
            [% FOREACH d IN debits %]
                {
                    [% PROCESS format_data data=d highlight='debit' %]

                    // Data for related item if there is one linked
                    "title": "[% d.item.biblio.title || d.deleted_item.biblio.title || d.deleted_item.deleted_biblio.title %]",
                    "biblionumber": "[% d.item.biblio.biblionumber || d.deleted_item.biblio.biblionumber %]",
                    "barcode": "[% d.item.barcode || d.deleted_item.barcode %]",
                    "itemnumber": "[% d.item.itemnumber %]", //This way itemnumber will be undef if deleted


                    // Data for related issue if there is one linked
                    [% IF d.issue %]
                        [% SET table = 'issue' %]
                    [% ELSIF d.old_issue %]
                        [% SET table = 'old_issue' %]
                    [% END %]

                    [% IF table %]
                        "issue": {
                            [% PROCESS format_data data=d.$table %]
                        },
                    [% END %]


                    "account_offsets": [
                        [% FOREACH ao IN d.account_offsets %]
                            {
                                [% PROCESS format_data data=ao highlight='offset'%]

                                "credit": {
                                    [% PROCESS format_data data=ao.credit highlight='credit' %]
                                }
                            },
                        [% END %]
                    ]

                },
            [% END %]
        ]
    } );

    $('#debits-table td.control').live( 'click', function () {
        var nTr = this.parentNode;
        var i = $.inArray( nTr, anOpen );

        if ( i === -1 ) {
            $('img', this).attr( 'src', sImageUrl+"details_close.png" );
            var nDetailsRow = debitsTable.fnOpen( nTr, fnFormatDebitDetails(debitsTable, nTr), 'details' );
            $('div.innerDetails', nDetailsRow).slideDown();
            anOpen.push( nTr );
        }
        else {
            $('img', this).attr( 'src', sImageUrl+"details_open.png" );
            $('div.innerDetails', $(nTr).next()[0]).slideUp( function () {
                debitsTable.fnClose( nTr );
                anOpen.splice( i, 1 );
            } );
        }
    } );

    var creditsTable = $('#credits-table').dataTable( {
        "bProcessing": true,
        "aoColumns": [
            {
                "mDataProp": null,
                "sClass": "control center",
                "sDefaultContent": '<img src="'+sImageUrl+'details_open.png'+'">'
            },
            { "mDataProp": "credit_id" },
            { "mDataProp": "notes" },
            { "mDataProp": "type" },
            { "mDataProp": "amount_paid" },
            { "mDataProp": "amount_remaining" },
            { "mDataProp": "created_on" },
            { "mDataProp": "updated_on" }
        ],
        "aaData": [
            [% FOREACH c IN credits %]
                {
                    [% PROCESS format_data data=c highlight='credit' %]

                    "account_offsets": [
                        [% FOREACH ao IN c.account_offsets %]
                            {
                                [% PROCESS format_data data=ao highlight='offset' %]

                                "debit": {
                                    [% PROCESS format_data data=ao.debit highlight='debit' %]
                                }
                            },
                        [% END %]
                    ]

                },
            [% END %]
        ]
    } );

    $('#credits-table td.control').live( 'click', function () {
        var nTr = this.parentNode;
        var i = $.inArray( nTr, anOpen );

        if ( i === -1 ) {
            $('img', this).attr( 'src', sImageUrl+"details_close.png" );
            var nDetailsRow = creditsTable.fnOpen( nTr, fnFormatCreditDetails(creditsTable, nTr), 'details' );
            $('div.innerDetails', nDetailsRow).slideDown();
            anOpen.push( nTr );
        }
        else {
            $('img', this).attr( 'src', sImageUrl+"details_open.png" );
            $('div.innerDetails', $(nTr).next()[0]).slideUp( function () {
                creditsTable.fnClose( nTr );
                anOpen.splice( i, 1 );
            } );
        }
    } );

    // Allow only numbers in ammount to pay
    $('#amount_to_pay').keypress(function(event) {
        end = $(this).val().split('.')[1];
        if (typeof end === 'undefined') {
            end = '';
        }

        if ( ( ( event.which != 46 || $(this).val().indexOf('.') != -1 ) && ( event.which < 48 || event.which > 57 ) ) || ( end.length > 1 ) ) {
            event.preventDefault();
        }
    });

    // Update the "amount to pay" field whenever a fee checkbox is changed
    // Note, this is just a payment suggestion and can be changed to any amount
    $(".pay-checkbox" ).change(function() {
        var sum = 0;
        $("input[name='debit_id']:checked" ).each(function(i,n){
            sum += parseFloat( $( "#amount_outstanding_" + $(this).val() ).val() );
        });
        $('#amount_to_pay').val( sum.toFixed(2) );
    });

} );

function fnFormatDebitDetails( debitsTable, nTr ) {
    var oData = debitsTable.fnGetData( nTr );

    var sOut = "<div class='innerDetails' style='display:none;'>";

    var account_offsets = oData.account_offsets;

    sOut += "<ul>";
    if ( oData.title ) {
        sOut += "<li>" + _("Title: ");
        if ( oData.biblionumber ) {
            sOut += "<a href='/cgi-bin/koha/opac-detail.pl?biblionumber=" + oData.biblionumber + "'>";
        }

        sOut += oData.title;

        if ( oData.biblionumber ) {
            sOut += "</a>";
        }

        sOut += "</li>";
    }

    if ( oData.barcode ) {
        sOut += "<li>" + _("Barcode: ") + oData.barcode + "</li>";
    }

    if ( oData.notes ) {
        sOut += "<li>" + _("Notes: ") + oData.notes + "</li>";
    }

    sOut += "</ul>";

    if ( account_offsets.length ) {
        sOut +=
            "<div class='innerDetails'>" +
                "<table cellpadding='5' cellspacing='0' border='0' style='margin:10px;'>" +
                    "<thead>" +
                        "<tr><th colspan='99'>" + _("Payments applied") + "</th></tr>" +
                        "<tr>" +
                            "<th>" + _("ID") + "</th>" +
                            "<th>" + _("Created on") + "</th>" +
                            "<th>" + _("Payment amount") + "</th>" +
                            "<th>" + _("Applied amount") + "</th>" +
                            "<th>" + _("Type") + "</th>" +
                            "<th>" + _("Notes") + "</th>" +
                        "</tr>" +
                    "</thead>" +
                    "<tbody>";

        for ( var i = 0; i < account_offsets.length; i++ ) {
            ao = account_offsets[i];
            sOut +=
            "<tr>" +
                "<td>" + ao.credit_id + "</td>" +
                "<td>" + ao.created_on + "</td>" +
                "<td>" + ao.credit.amount_paid + "</td>" +
                "<td>" + ao.amount + "</td>" +
                "<td>" + ao.credit.type + "</td>" +
                "<td>" + ao.credit.notes + "</td>" +
            "</tr>";
        }

        sOut +=
            "</tbody>"+
            "</table>";
    }

    sOut +=
        "</div>";

    return sOut;
}

function fnFormatCreditDetails( creditsTable, nTr ) {
    var oData = creditsTable.fnGetData( nTr );

    var sOut = "<div class='innerDetails' style='display:none;'>";

    var account_offsets = oData.account_offsets;

    if ( account_offsets.length ) {
        sOut +=
                "<table cellpadding='5' cellspacing='0' border='0' style='margin:10px;'>" +
                    "<thead>" +
                        "<tr><th colspan='99'>" + _("Fees paid") + "</th></tr>" +
                        "<tr>" +
                            "<th>" + _("ID") + "</th>" +
                            "<th>" + _("Description") + "</th>" +
                            "<th>" + _("Type") + "</th>" +
                            "<th>" + _("Amount") + "</th>" +
                            "<th>" + _("Remaining") + "</th>" +
                            "<th>" + _("Created on") + "</th>" +
                            "<th>" + _("Updated on") + "</th>" +
                            "<th>" + _("Notes") + "</th>" +
                        "</tr>" +
                    "</thead>" +
                    "<tbody>";

        for ( var i = 0; i < account_offsets.length; i++ ) {
            ao = account_offsets[i];
            sOut +=
            "<tr>" +
                "<td>" + ao.debit.debit_id + "</td>" +
                "<td>" + ao.debit.description + "</td>" +
                "<td>" + ao.debit.type + "</td>" +
                "<td>" + ao.debit.amount_original + "</td>" +
                "<td>" + ao.debit.amount_outstanding + "</td>" +
                "<td>" + ao.debit.created_on + "</td>" +
                "<td>" + ao.debit.updated_on + "</td>" +
                "<td>" + ao.debit.notes + "</td>" +
            "</tr>";
        }

        sOut +=
            "</tbody>"+
            "</table>";
    }

    sOut +=
        "</div>";

    return sOut;
}

//]]>
</script>

[% BLOCK jsinclude %][% END %]

[% BLOCK format_data %]
    [% FOREACH key IN data.result_source.columns %]
        [% IF key.match('^amount') %]
            "[% key %]": "[% data.$key FILTER $Currency %]",
            "[% key %]_unformatted": "[% data.$key %]",
        [% ELSIF key.match('_on$') %]
            "[% key %]": "[% data.$key | $KohaDates %]",
            "[% key %]_unformatted": "[% data.$key %]",
        [% ELSE %]
            "[% key %]": "[% data.$key %]",
        [% END %]
    [% END %]
[% END %]




                            <h3>Account balance: [% borrower.account_balance | $Currency %]</h3>
                        </p>

                        <form action="/cgi-bin/koha/opac-account-pay.pl" method="post">
                            <div>
                                <div id="account-debits">
                                    <a id="account-debits-switcher" href="#" onclick="return false">View payments</a>
                                    <table cellpadding="0" cellspacing="0" border="0" class="display" id="debits-table">
                                        <thead>
                                            <tr>
                                                <th colspan="99">Fees</th>
                                            </tr>
                                            <tr>
                                                <th></th>
                                                <th>ID</th>
                                                <th>Description</th>
                                                <th>Type</th>
                                                <th>Amount</th>
                                                <th>Outsanding</th>
                                                <th>Created on</th>
                                                <th>Updated on</th>
                                                <th>Pay</th>
                                            </tr>
                                        </thead>
                                        <tbody></tbody>
                                    </table>
                                </div>

                                <div id="account-credits">
                                    <a id="account-credits-switcher" href="#"  onclick="return false">View fees</a>
                                    <table cellpadding="0" cellspacing="0" border="0" class="display" id="credits-table">
                                        <thead>
                                            <tr>
                                                <th colspan="99">Payments</th>
                                            </tr>
                                            <tr>
                                                <th></th>
                                                <th>ID</th>
                                                <th>Notes</th>
                                                <th>Type</th>
                                                <th>Amount</th>
                                                <th>Remaining</th>
                                                <th>Created on</th>
                                                <th>Updated on</th>
                                            </tr>
                                        </thead>
                                        <tbody></tbody>
                                    </table>
                                </div>

                                [% IF Koha.Preference('EnablePayPalOpacPayments') %]
                                    <fieldset>
                                        <legend>Pay online</legend>

                                        <div>
                                            Amount to pay:
                                            [% Currency.symbol() %]<input type="text" id="amount_to_pay" name="amount_to_pay"/>
                                        </div>

                                        <div>
                                            <h6>Payment method:</h6>
                                            <input type="radio" name="payment_method" value="paypal" checked="checked"/>
                                            <label for="payment-method">
                                                <img src="https://www.paypal.com/en_US/i/logo/PayPal_mark_37x23.gif" align="left" style="margin-right:7px;">
                                            </label>
                                        </div>

                                        <br/>

                                        <div>
                                            <input type="submit" value="Make payment">
                                        </div>
                                    </fieldset>
                                [% END %]
                            </div>
                        </form>
                            <div id="account-credits">
                                <a id="account-credits-switcher" href="#"  onclick="return false">View fees</a>
                                <table cellpadding="0" cellspacing="0" border="0" class="display" id="credits-table">
                                    <thead>
                                        <tr>
                                            <th colspan="99">Payments</th>
                                        </tr>
                                        <tr>
                                            <th></th>
                                            <th>ID</th>
                                            <th>Notes</th>
                                            <th>Type</th>
                                            <th>Amount</th>
                                            <th>Remaining</th>
                                            <th>Created on</th>
                                            <th>Updated on</th>
                                        </tr>
                                    </thead>
                                    <tbody></tbody>
                                </table>
                            </div>
                        </div>
                    [% ELSE %]
                        <h4>You have no fines or charges</h4>
                    [% END %]

            { "mDataProp": "amount_original" },
            { "mDataProp": "amount_outstanding" },
            { "mDataProp": "created_on" },
            { "mDataProp": "updated_on" },
            {
                /* Payment selection checkboxes */
                [% UNLESS Koha.Preference('EnablePayPalOpacPayments') %]
                    "bVisible": false,
                [% END %]
                "mDataProp": null,
                "sDefaultContent": "", 
                "fnRender": function ( o, val ) {
                    return val;
                },
                "mRender": function ( data, type, full ) {
                    if ( full.amount_outstanding_unformatted > 0 ) {
                        return "<input class='pay-checkbox' name='debit_id' value='" + full.debit_id + "' type='checkbox'/>"
                            + "<input type='hidden' id='amount_outstanding_" + full.debit_id + "' value='" + full.amount_outstanding_unformatted + "'/>";
                    }
                }
            },
        ],
        "aaData": [
            [% FOREACH d IN debits %]

        }
    } );

    // Allow only numbers in ammount to pay
    $('#amount_to_pay').keypress(function(event) {
        end = $(this).val().split('.')[1];
        if (typeof end === 'undefined') {
            end = '';
        }

        if ( ( ( event.which != 46 || $(this).val().indexOf('.') != -1 ) && ( event.which < 48 || event.which > 57 ) ) || ( end.length > 1 ) ) {
            event.preventDefault();
        }
    });

    // Update the "amount to pay" field whenever a fee checkbox is changed
    // Note, this is just a payment suggestion and can be changed to any amount
    $(".pay-checkbox" ).change(function() {
        var sum = 0;
        $("input[name='debit_id']:checked" ).each(function(i,n){
            sum += parseFloat( $( "#amount_outstanding_" + $(this).val() ).val() );
        });
        $('#amount_to_pay').val( sum.toFixed(2) );
    });

} );

function fnFormatDebitDetails( debitsTable, nTr ) {

function fnFormatCreditDetails( creditsTable, nTr ) {
    var oData = creditsTable.fnGetData( nTr );

    var sOut = "<div class='innerDetails' style='display:none;'>";

    var account_offsets = oData.account_offsets;


    [% FOREACH key IN data.result_source.columns %]
        [% IF key.match('^amount') %]
            "[% key %]": "[% data.$key FILTER $Currency %]",
            "[% key %]_unformatted": "[% data.$key %]",
        [% ELSIF key.match('_on$') %]
            "[% key %]": "[% data.$key | $KohaDates %]",
            "[% key %]_unformatted": "[% data.$key %]",
        [% ELSE %]
            "[% key %]": "[% data.$key %]",
        [% END %]

Lines 25-30 Link Here

(-)a/koha-tmpl/opac-tmpl/prog/en/includes/browser-strings.inc (+1 lines)
25	"WRITEOFF" : _("Writeoff"),	25	"WRITEOFF" : _("Writeoff"),
26	"FOUND" : _("Lost item found"),	26	"FOUND" : _("Lost item found"),
27	"FORGIVEN" : _("Forgiven"),	27	"FORGIVEN" : _("Forgiven"),
		28	"PAYPAL" : _("PayPal"),
28	[% FOREACH a IN AuthorisedValues.Get('MANUAL_CREDIT') %]	29	[% FOREACH a IN AuthorisedValues.Get('MANUAL_CREDIT') %]
29	"[% a.authorised_value %]" : "[% a.lib %]",	30	"[% a.authorised_value %]" : "[% a.lib %]",
30	[% END %]	31	[% END %]




[% SET accountview = 1 %]

[% USE Koha %]
[% USE KohaDates %]
[% USE Currency %]

[% INCLUDE 'doc-head-open.inc' %][% IF ( LibraryNameTitle ) %][% LibraryNameTitle %][% ELSE %]Koha online[% END %] catalog &rsaquo; Your fines and charges
[% INCLUDE 'doc-head-close.inc' %]
</head>
<body id="opac-account">
<div id="doc3" class="yui-t1">
    <div id="bd">
        [% INCLUDE 'masthead.inc' %]
        <div id="yui-main">
            <div class="yui-b">
                <div class="yui-g">
                    <div id="useraccount" class="container">
                        <h3><a href="/cgi-bin/koha/opac-user.pl">[% borrower.firstname %] [% borrower.surname %]'s account</a> &#8674; Fines and charges</h3>

                        [% IF error %]
                            <div id="error" class="dialog alert">
                                <p><strong>Error:</strong> there was an problem processing your payment</p>

                                [% IF error == "PAYPAL_UNABLE_TO_CONNECT" %]
                                    <p>Unable to connect to PayPal.</p>
                                    <p>Please try again later.</p>
                                [% ELSIF error == "PAYPAL_ERROR_PROCESSING" %]
                                    <p>Unable to verify payment.</p>
                                    <p>Please contact the library to verify your payment.</p>
                                [% END %]
                            </div>
                        [% ELSIF credit %]
                            <div class="dialog message">
                                <p><strong>Payment applied:</strong> your payment of [% credit.amount_paid %] has been applied to your account</p>
                            </div>
                        [% END %]

                        <a href="/cgi-bin/koha/opac-account.pl">Return to fine details</a>
                    </div>
                </div>
            </div>
        </div>

    <div class="yui-b">
        <div id="leftmenus" class="container">
            [% INCLUDE 'navigation.inc' IsPatronPage=1 %]
        </div>
    </div>
</div>
[% INCLUDE 'opac-bottom.inc' %]

[% INCLUDE 'datatables.inc' %]
[% INCLUDE 'browser-strings.inc' %]

<script type="text/javascript">
//<![CDATA[
$(document).ready(function() {
    $('#account-credits').hide();
    $('#account-debits-switcher').click(function() {
         $('#account-debits').slideUp();
         $('#account-credits').slideDown();
    });
    $('#account-credits-switcher').click(function() {
         $('#account-credits').slideUp();
         $('#account-debits').slideDown();
    });

    var anOpen = [];
    var sImageUrl = "[% interface %]/[% theme %]/images/";

    var debitsTable = $('#debits-table').dataTable( {
        "bProcessing": true,
        "aoColumns": [
            {
                "mDataProp": null,
                "sClass": "control center",
                "sDefaultContent": '<img src="'+sImageUrl+'details_open.png'+'">'
            },
            { "mDataProp": "debit_id" },
            { "mDataProp": "description" },
            {
                "mDataProp": "type",
                "fnRender": function ( o, val ) {
                    return STRINGS['DebitTypes'][val];
                },
            },
            { "mDataProp": "amount_original" },
            { "mDataProp": "amount_outstanding" },
            { "mDataProp": "created_on" },
            { "mDataProp": "updated_on" },
            {
                "mDataProp": null,
                "sDefaultContent": "", 
                "fnRender": function ( o, val ) {
                    return val;
                },
                "mRender": function ( data, type, full ) {
                    if ( full.amount_outstanding_unformatted > 0 ) {
                        return "<input class='pay-checkbox' name='debit_id' value='" + full.debit_id + "' type='checkbox'/>"
                            + "<input type='hidden' id='amount_outstanding_" + full.debit_id + "' value='" + full.amount_outstanding_unformatted + "'/>";
                    }
                }
            },
        ],
        "aaData": [
            [% FOREACH d IN debits %]
                {
                    [% PROCESS format_data data=d highlight='debit' %]

                    // Data for related item if there is one linked
                    "title": "[% d.item.biblio.title || d.deleted_item.biblio.title || d.deleted_item.deleted_biblio.title %]",
                    "biblionumber": "[% d.item.biblio.biblionumber || d.deleted_item.biblio.biblionumber %]",
                    "barcode": "[% d.item.barcode || d.deleted_item.barcode %]",
                    "itemnumber": "[% d.item.itemnumber %]", //This way itemnumber will be undef if deleted


                    // Data for related issue if there is one linked
                    [% IF d.issue %]
                        [% SET table = 'issue' %]
                    [% ELSIF d.old_issue %]
                        [% SET table = 'old_issue' %]
                    [% END %]

                    [% IF table %]
                        "issue": {
                            [% PROCESS format_data data=d.$table %]
                        },
                    [% END %]


                    "account_offsets": [
                        [% FOREACH ao IN d.account_offsets %]
                            {
                                [% PROCESS format_data data=ao highlight='offset'%]

                                "credit": {
                                    [% PROCESS format_data data=ao.credit highlight='credit' %]
                                }
                            },
                        [% END %]
                    ]

                },
            [% END %]
        ]
    } );

    $('#debits-table td.control').live( 'click', function () {
        var nTr = this.parentNode;
        var i = $.inArray( nTr, anOpen );

        if ( i === -1 ) {
            $('img', this).attr( 'src', sImageUrl+"details_close.png" );
            var nDetailsRow = debitsTable.fnOpen( nTr, fnFormatDebitDetails(debitsTable, nTr), 'details' );
            $('div.innerDetails', nDetailsRow).slideDown();
            anOpen.push( nTr );
        }
        else {
            $('img', this).attr( 'src', sImageUrl+"details_open.png" );
            $('div.innerDetails', $(nTr).next()[0]).slideUp( function () {
                debitsTable.fnClose( nTr );
                anOpen.splice( i, 1 );
            } );
        }
    } );

    var creditsTable = $('#credits-table').dataTable( {
        "bProcessing": true,
        "aoColumns": [
            {
                "mDataProp": null,
                "sClass": "control center",
                "sDefaultContent": '<img src="'+sImageUrl+'details_open.png'+'">'
            },
            { "mDataProp": "credit_id" },
            { "mDataProp": "notes" },
            {
                "mDataProp": "type",
                "fnRender": function ( o, val ) {
                    return STRINGS['CreditTypes'][val];
                },
            },
            { "mDataProp": "amount_paid" },
            { "mDataProp": "amount_remaining" },
            { "mDataProp": "created_on" },
            { "mDataProp": "updated_on" }
        ],
        "aaData": [
            [% FOREACH c IN credits %]
                {
                    [% PROCESS format_data data=c highlight='credit' %]

                    "account_offsets": [
                        [% FOREACH ao IN c.account_offsets %]
                            {
                                [% PROCESS format_data data=ao highlight='offset' %]

                                "debit": {
                                    [% PROCESS format_data data=ao.debit highlight='debit' %]
                                }
                            },
                        [% END %]
                    ]

                },
            [% END %]
        ]
    } );

    $('#credits-table td.control').live( 'click', function () {
        var nTr = this.parentNode;
        var i = $.inArray( nTr, anOpen );

        if ( i === -1 ) {
            $('img', this).attr( 'src', sImageUrl+"details_close.png" );
            var nDetailsRow = creditsTable.fnOpen( nTr, fnFormatCreditDetails(creditsTable, nTr), 'details' );
            $('div.innerDetails', nDetailsRow).slideDown();
            anOpen.push( nTr );
        }
        else {
            $('img', this).attr( 'src', sImageUrl+"details_open.png" );
            $('div.innerDetails', $(nTr).next()[0]).slideUp( function () {
                creditsTable.fnClose( nTr );
                anOpen.splice( i, 1 );
            } );
        }
    } );

    // Allow only numbers in ammount to pay
    $('#amount_to_pay').keypress(function(event) {
        end = $(this).val().split('.')[1];
        if (typeof end === 'undefined') {
            end = '';
        }

        if ( ( ( event.which != 46 || $(this).val().indexOf('.') != -1 ) && ( event.which < 48 || event.which > 57 ) ) || ( end.length > 1 ) ) {
            event.preventDefault();
        }
    });

    // Update the "amount to pay" field whenever a fee checkbox is changed
    // Note, this is just a payment suggestion and can be changed to any amount
    $(".pay-checkbox" ).change(function() {
        var sum = 0;
        $("input[name='debit_id']:checked" ).each(function(i,n){
            sum += parseFloat( $( "#amount_outstanding_" + $(this).val() ).val() );
        });
        $('#amount_to_pay').val( sum.toFixed(2) );
    });


} );

function fnFormatDebitDetails( debitsTable, nTr ) {
    var oData = debitsTable.fnGetData( nTr );

    var sOut = "<div class='innerDetails' style='display:none;'>";

    var account_offsets = oData.account_offsets;

    sOut += "<ul>";
    if ( oData.title ) {
        sOut += "<li>" + _("Title: ");
        if ( oData.biblionumber ) {
            sOut += "<a href='/cgi-bin/koha/opac-detail.pl?biblionumber=" + oData.biblionumber + "'>";
        }

        sOut += oData.title;

        if ( oData.biblionumber ) {
            sOut += "</a>";
        }

        sOut += "</li>";
    }

    if ( oData.barcode ) {
        sOut += "<li>" + _("Barcode: ") + oData.barcode + "</li>";
    }

    if ( oData.notes ) {
        sOut += "<li>" + _("Notes: ") + oData.notes + "</li>";
    }

    sOut += "</ul>";

    if ( account_offsets.length ) {
        sOut +=
            "<div class='innerDetails'>" +
                "<table cellpadding='5' cellspacing='0' border='0' style='margin:10px;'>" +
                    "<thead>" +
                        "<tr><th colspan='99'>" + _("Payments applied") + "</th></tr>" +
                        "<tr>" +
                            "<th>" + _("ID") + "</th>" +
                            "<th>" + _("Created on") + "</th>" +
                            "<th>" + _("Payment amount") + "</th>" +
                            "<th>" + _("Applied amount") + "</th>" +
                            "<th>" + _("Type") + "</th>" +
                            "<th>" + _("Notes") + "</th>" +
                        "</tr>" +
                    "</thead>" +
                    "<tbody>";

        for ( var i = 0; i < account_offsets.length; i++ ) {
            ao = account_offsets[i];
            sOut +=
            "<tr>" +
                "<td>" + ao.credit_id + "</td>" +
                "<td>" + ao.created_on + "</td>" +
                "<td>" + ao.credit.amount_paid + "</td>" +
                "<td>" + ao.amount + "</td>" +
                "<td>" + ao.credit.type + "</td>" +
                "<td>" + ao.credit.notes + "</td>" +
            "</tr>";
        }

        sOut +=
            "</tbody>"+
            "</table>";
    }

    sOut +=
        "</div>";

    return sOut;
}

function fnFormatCreditDetails( creditsTable, nTr ) {
    var oData = creditsTable.fnGetData( nTr );

    var sOut = '<div class="innerDetails" style="display:none;">';

    var account_offsets = oData.account_offsets;

    if ( account_offsets.length ) {
        sOut +=
                "<table cellpadding='5' cellspacing='0' border='0' style='margin:10px;'>" +
                    "<thead>" +
                        "<tr><th colspan='99'>" + _("Fees paid") + "</th></tr>" +
                        "<tr>" +
                            "<th>" + _("ID") + "</th>" +
                            "<th>" + _("Description") + "</th>" +
                            "<th>" + _("Type") + "</th>" +
                            "<th>" + _("Amount") + "</th>" +
                            "<th>" + _("Remaining") + "</th>" +
                            "<th>" + _("Created on") + "</th>" +
                            "<th>" + _("Updated on") + "</th>" +
                            "<th>" + _("Notes") + "</th>" +
                        "</tr>" +
                    "</thead>" +
                    "<tbody>";

        for ( var i = 0; i < account_offsets.length; i++ ) {
            ao = account_offsets[i];
            sOut +=
            "<tr>" +
                "<td>" + ao.debit.debit_id + "</td>" +
                "<td>" + ao.debit.description + "</td>" +
                "<td>" + ao.debit.type + "</td>" +
                "<td>" + ao.debit.amount_original + "</td>" +
                "<td>" + ao.debit.amount_outstanding + "</td>" +
                "<td>" + ao.debit.created_on + "</td>" +
                "<td>" + ao.debit.updated_on + "</td>" +
                "<td>" + ao.debit.notes + "</td>" +
            "</tr>";
        }

        sOut +=
            "</tbody>"+
            "</table>";
    }

    sOut +=
        "</div>";

    return sOut;
}

//]]>
</script>

[% BLOCK jsinclude %][% END %]

[% BLOCK format_data %]
    [% FOREACH key IN data.result_source.columns %]
        [% IF key.match('^amount') %]
            "[% key %]": "[% data.$key FILTER $Currency %]",
            "[% key %]_unformatted": "[% data.$key %]",
        [% ELSIF key.match('_on$') %]
            "[% key %]": "[% data.$key | $KohaDates %]",
            "[% key %]_unformatted": "[% data.$key %]",
        [% ELSE %]
            "[% key %]": "[% data.$key %]",
        [% END %]
    [% END %]
[% END %]




                                <h3>Account balance: [% borrower.account_balance | $Currency %]</h3>
                            </p>

                            <form action="/cgi-bin/koha/opac-account-pay.pl" method="post">
                                <div>
                                    <div id="account-debits">
                                        <a id="account-debits-switcher" href="#" onclick="return false">View payments</a>
                                        <table cellpadding="0" cellspacing="0" border="0" class="display" id="debits-table">
                                            <thead>
                                                <tr>
                                                    <th colspan="99">Fees</th>
                                                </tr>
                                                <tr>
                                                    <th></th>
                                                    <th>ID</th>
                                                    <th>Description</th>
                                                    <th>Type</th>
                                                    <th>Amount</th>
                                                    <th>Outsanding</th>
                                                    <th>Created on</th>
                                                    <th>Updated on</th>
                                                    <th>Pay</th>
                                                </tr>
                                            </thead>
                                            <tbody></tbody>
                                        </table>
                                    </div>

                                    <div id="account-credits">
                                        <a id="account-credits-switcher" href="#"  onclick="return false">View fees</a>
                                        <table cellpadding="0" cellspacing="0" border="0" class="display" id="credits-table">
                                            <thead>
                                                <tr>
                                                    <th colspan="99">Payments</th>
                                                </tr>
                                                <tr>
                                                    <th></th>
                                                    <th>ID</th>
                                                    <th>Notes</th>
                                                    <th>Type</th>
                                                    <th>Amount</th>
                                                    <th>Remaining</th>
                                                    <th>Created on</th>
                                                    <th>Updated on</th>
                                                </tr>
                                            </thead>
                                            <tbody></tbody>
                                        </table>
                                    </div>

                                    [% IF Koha.Preference('EnablePayPalOpacPayments') %]
                                        <fieldset>
                                            <legend>Pay online</legend>

                                            <div>
                                                Amount to pay:
                                                [% Currency.symbol() %]<input type="text" id="amount_to_pay" name="amount_to_pay"/>
                                            </div>

                                            <div>
                                                <h6>Payment method:</h6>
                                                <input type="radio" name="payment_method" value="paypal" checked="checked"/>
                                                <label for="payment-method">
                                                    <img src="https://www.paypal.com/en_US/i/logo/PayPal_mark_37x23.gif" align="left" style="margin-right:7px;">
                                                </label>
                                            </div>

                                            <br/>

                                            <div>
                                                <input type="submit" value="Make payment">
                                            </div>
                                        </fieldset>
                                    [% END %]
                                </div>
                            </form>
                                <div id="account-credits">
                                    <a id="account-credits-switcher" href="#"  onclick="return false">View fees</a>
                                    <table cellpadding="0" cellspacing="0" border="0" class="display" id="credits-table">
                                        <thead>
                                            <tr>
                                                <th colspan="99">Payments</th>
                                            </tr>
                                            <tr>
                                                <th></th>
                                                <th>ID</th>
                                                <th>Notes</th>
                                                <th>Type</th>
                                                <th>Amount</th>
                                                <th>Remaining</th>
                                                <th>Created on</th>
                                                <th>Updated on</th>
                                            </tr>
                                        </thead>
                                        <tbody></tbody>
                                    </table>
                                </div>
                            </div>
                        [% ELSE %]
                            <h4>You have no fines or charges</h4>
                        [% END %]

            { "mDataProp": "amount_original" },
            { "mDataProp": "amount_outstanding" },
            { "mDataProp": "created_on" },
            { "mDataProp": "updated_on" },
            {
                /* Payment selection checkboxes */
                [% UNLESS Koha.Preference('EnablePayPalOpacPayments') %]
                    "bVisible": false,
                [% END %]
                "mDataProp": null,
                "sDefaultContent": "", 
                "fnRender": function ( o, val ) {
                    return val;
                },
                "mRender": function ( data, type, full ) {
                    if ( full.amount_outstanding_unformatted > 0 ) {
                        return "<input class='pay-checkbox' name='debit_id' value='" + full.debit_id + "' type='checkbox'/>"
                            + "<input type='hidden' id='amount_outstanding_" + full.debit_id + "' value='" + full.amount_outstanding_unformatted + "'/>";
                    }
                }
            },
        ],
        "aaData": [
            [% FOREACH d IN debits %]

            { "mDataProp": "amount_paid" },
            { "mDataProp": "amount_remaining" },
            { "mDataProp": "created_on" },
            { "mDataProp": "updated_on" },
            {
                /* Payment selection checkboxes */
                [% UNLESS Koha.Preference('EnablePayPalOpacPayments') %]
                    "bVisible": false,
                [% END %]
                "mDataProp": null,
                "sDefaultContent": "", 
                "fnRender": function ( o, val ) {
                    return val;
                },
                "mRender": function ( data, type, full ) {
                    if ( full.amount_outstanding_unformatted > 0 ) {
                        return "<input class='pay-checkbox' name='debit_id' value='" + full.debit_id + "' type='checkbox'/>"
                            + "<input type='hidden' id='amount_outstanding_" + full.debit_id + "' value='" + full.amount_outstanding_unformatted + "'/>";
                    }
                }
            },
        ],
        "aaData": [
            [% FOREACH c IN credits %]

        }
    } );

    // Allow only numbers in ammount to pay
    $('#amount_to_pay').keypress(function(event) {
        end = $(this).val().split('.')[1];
        if (typeof end === 'undefined') {
            end = '';
        }

        if ( ( ( event.which != 46 || $(this).val().indexOf('.') != -1 ) && ( event.which < 48 || event.which > 57 ) ) || ( end.length > 1 ) ) {
            event.preventDefault();
        }
    });

    // Update the "amount to pay" field whenever a fee checkbox is changed
    // Note, this is just a payment suggestion and can be changed to any amount
    $(".pay-checkbox" ).change(function() {
        var sum = 0;
        $("input[name='debit_id']:checked" ).each(function(i,n){
            sum += parseFloat( $( "#amount_outstanding_" + $(this).val() ).val() );
        });
        $('#amount_to_pay').val( sum.toFixed(2) );
    });


} );

function fnFormatDebitDetails( debitsTable, nTr ) {

    [% FOREACH key IN data.result_source.columns %]
        [% IF key.match('^amount') %]
            "[% key %]": "[% data.$key FILTER $Currency %]",
            "[% key %]_unformatted": "[% data.$key %]",
        [% ELSIF key.match('_on$') %]
            "[% key %]": "[% data.$key | $KohaDates %]",
            "[% key %]_unformatted": "[% data.$key %]",
        [% ELSE %]
            "[% key %]": "[% data.$key %]",
        [% END %]




#!/usr/bin/perl

# Copyright Katipo Communications 2002
# Copyright Biblibre 2007,2010
#
# This file is part of Koha.
#
# Koha is free software; you can redistribute it and/or modify it under the
# terms of the GNU General Public License as published by the Free Software
# Foundation; either version 2 of the License, or (at your option) any later
# version.
#
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with Koha; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

use strict;
use warnings;
use utf8;

use CGI;
use HTTP::Request::Common;
use LWP::UserAgent;
use URL::Encode qw(url_params_mixed);

use C4::Auth;
use C4::Output;
use C4::Members;
use Koha::Database;
use Koha::Accounts qw(AddCredit);
use Koha::Accounts::CreditTypes;

my $cgi = new CGI;

unless ( C4::Context->preference('EnablePayPalOpacPayments') ) {
    print $cgi->redirect("/cgi-bin/koha/errors/404.pl");
    exit;
}

my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
    {
        template_name   => "opac-account-pay-return.tt",
        query           => $cgi,
        type            => "opac",
        authnotrequired => 0,
        flagsrequired   => { borrow => 1 },
        debug           => 1,
    }
);

my $token    = $cgi->param('token');
my $payer_id = $cgi->param('PayerID');
my $amount   = $cgi->param('amount');
my @debit_id = $cgi->param('debit_id');

my $ua = LWP::UserAgent->new;

my $url =
  C4::Context->preference('PayPalSandboxMode')
  ? 'https://api-3t.sandbox.paypal.com/nvp'
  : 'https://api-3t.paypal.com/nvp';

my $nvp_params = {
    'USER'      => C4::Context->preference('PayPalUser'),
    'PWD'       => C4::Context->preference('PayPalPwd'),
    'SIGNATURE' => C4::Context->preference('PayPalSignature'),

    # API Version and Operation
    'METHOD'  => 'DoExpressCheckoutPayment',
    'VERSION' => '82.0',

    # API specifics for DoExpressCheckout
    'PAYMENTREQUEST_0_PAYMENTACTION' => 'Sale',
    'PAYERID'                        => $payer_id,
    'TOKEN'                          => $token,
    'PAYMENTREQUEST_0_AMT'           => $amount,
};

my $response = $ua->request( POST $url, $nvp_params );

if ( $response->is_success ) {
    my $params = url_params_mixed( $response->decoded_content );

    if ( $params->{ACK} eq "Success" ) {
        $amount = $params->{PAYMENTINFO_0_AMT};

        my $borrower =
          Koha::Database->new()->schema->resultset('Borrower')
          ->find($borrowernumber);

        my $credit = AddCredit(
            {
                borrower => $borrower,
                amount   => $amount,
                type     => Koha::Accounts::CreditTypes::PayPal,
                debit_id => \@debit_id,
            }
        );

        $template->param( credit => $credit );

    }
    else {
        $template->param( error => "PAYPAL_ERROR_PROCESSING" );
    }

}
else {
    $template->param( error => "PAYPAL_UNABLE_TO_CONNECT" );
}

$template->param(
    borrower    => GetMemberDetails($borrowernumber),
    accountview => 1
);

output_html_with_http_headers( $cgi, $cookie, $template->output );




#!/usr/bin/perl

# Copyright Katipo Communications 2002
# Copyright Biblibre 2007,2010
#
# This file is part of Koha.
#
# Koha is free software; you can redistribute it and/or modify it under the
# terms of the GNU General Public License as published by the Free Software
# Foundation; either version 2 of the License, or (at your option) any later
# version.
#
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License along
# with Koha; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

use strict;
use warnings;
use utf8;

use CGI;
use HTTP::Request::Common;
use LWP::UserAgent;
use URL::Encode qw(url_encode url_params_mixed);
use URI;

use C4::Auth;

my $cgi = new CGI;

unless ( C4::Context->preference('EnablePayPalOpacPayments') ) {
    print $cgi->redirect("/cgi-bin/koha/errors/404.pl");
    exit;
}

my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
    {
        template_name   => "opac-account-pay-return.tt",
        query           => $cgi,
        type            => "opac",
        authnotrequired => 0,
        flagsrequired   => { borrow => 1 },
        debug           => 1,
    }
);

my $amount_to_pay  = $cgi->param('amount_to_pay');
my $payment_method = $cgi->param('payment_method');
my @debit_id       = $cgi->param('debit_id');

my $error = 0;
if ( $payment_method eq 'paypal' ) {
    my $ua = LWP::UserAgent->new;

    my $amount = url_encode($amount_to_pay);

    my $url =
      C4::Context->preference('PayPalSandboxMode')
      ? 'https://api-3t.sandbox.paypal.com/nvp'
      : 'https://api-3t.paypal.com/nvp';

    my $opac_base_url = C4::Context->preference('OPACBaseURL');

    my $return_url =
      URI->new( "http://"
          . $opac_base_url
          . "/cgi-bin/koha/opac-account-pay-paypal-return.pl" );
    $return_url->query_form( { amount => $amount, debit_id => \@debit_id } );

    my $cancel_url =
      URI->new( "http://" . $opac_base_url . "/cgi-bin/koha/opac-account.pl" );

    my $nvp_params = {
        'USER'      => C4::Context->preference('PayPalUser'),
        'PWD'       => C4::Context->preference('PayPalPwd'),
        'SIGNATURE' => C4::Context->preference('PayPalSignature'),

        # API Version and Operation
        'METHOD'  => 'SetExpressCheckout',
        'VERSION' => '82.0',

        # API specifics for SetExpressCheckout
        'NOSHIPPING'           => 1,
        'REQCONFIRMSHIPPING'   => 0,
        'ALLOWNOTE'            => 0,
        'BRANDNAME'            => C4::Context->preference('LibraryName'),
        'CANCELURL'            => $cancel_url->as_string(),
        'RETURNURL'            => $return_url->as_string(),
        'PAYMENTREQUEST_0_AMT' => $amount_to_pay,
        'PAYMENTREQUEST_0_PAYMENTACTION'        => 'Sale',
        'PAYMENTREQUEST_0_ALLOWEDPAYMENTMETHOD' => 'InstantPaymentOnly',
        'PAYMENTREQUEST_0_DESC' =>
          C4::Context->preference('PayPalChargeDescription'),
    };

    my $response = $ua->request( POST $url, $nvp_params );

    if ( $response->is_success ) {
        my $params = url_params_mixed( $response->decoded_content );

        if ( $params->{ACK} eq "Success" ) {
            my $token = $params->{TOKEN};

            my $redirect_url =
              C4::Context->preference('PayPalSandboxMode')
              ? "https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token="
              : "https://www.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token=";
            print $cgi->redirect( $redirect_url . $token );

        }
        else {
            $template->param( error => "PAYPAL_ERROR_PROCESSING" );
            $error = 1;
        }

    }
    else {
        $template->param( error => "PAYPAL_UNABLE_TO_CONNECT" );
        $error = 1;
    }
}

output_html_with_http_headers( $cgi, $cookie, $template->output ) if $error;

Lines 21-27 Link Here

(-)a/opac/opac-account.pl (-2 lines)
21	use strict;	21	use strict;
22	use CGI;	22	use CGI;
23	use C4::Members;	23	use C4::Members;
24	use C4::Circulation;
25	use C4::Auth;	24	use C4::Auth;
26	use C4::Output;	25	use C4::Output;
27	use warnings;	26	use warnings;
28	-

Return to bug 11622

Lines 619-621 OPAC: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (+30 lines)
619	- pref: PatronSelfRegistrationAdditionalInstructions	619	- pref: PatronSelfRegistrationAdditionalInstructions
620	type: textarea	620	type: textarea
621	class: html	621	class: html
		622	Payments:
		623	-
		624	- pref: EnablePayPalOpacPayments
		625	default: 1
		626	choices:
		627	yes: Allow
		628	no: "Don't allow"
		629	- "patrons to make payments from the OPAC via PayPal in"
		630	- pref: PayPalSandboxMode
		631	default: 1
		632	choices:
		633	yes: "Sandbox"
		634	no: "Production"
		635	- "mode."
		636	-
		637	- "The email address to recieve PayPal payments is "
		638	- pref: PayPalUser
		639	class: long
		640	-
		641	- "The password for the PayPal account to recieve payments is "
		642	- pref: PayPalPwd
		643	class: long
		644	-
		645	- "The signature for the PayPal account to recieve payments is "
		646	- pref: PayPalSignature
		647	class: long
		648	-
		649	- "The patron should see the charge description as "
		650	- pref: PayPalChargeDescription
		651	class: long

Line 0 Link Here

(-)a/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-account-pay-return.tt (+392 lines)
		1	[% USE Koha %]
		2	[% USE KohaDates %]
		3	[% USE Currency %]
		4
		5	[% INCLUDE 'doc-head-open.inc' %][% IF ( LibraryNameTitle ) %][% LibraryNameTitle %][% ELSE %]Koha online[% END %] catalog &rsaquo; Your fines and charges
		6	[% INCLUDE 'doc-head-close.inc' %]
		7	[% BLOCK cssinclude %][% END %]
		8
		9
		10	</head>
		11	<body id="opac-account" class="scrollto">
		12	[% INCLUDE 'masthead.inc' %]
		13
		14	<div class="main">
		15	<ul class="breadcrumb">
		16	<li><a href="/cgi-bin/koha/opac-main.pl">Home</a> <span class="divider">&rsaquo;</span></li>
		17	<li><a href="/cgi-bin/koha/opac-user.pl">[% borrower.firstname %] [% borrower.surname %]</a> <span class="divider">&rsaquo;</span></li>
		18	<li><a href="#">Your fines and charges</a></li>
		19	</ul>
		20
		21	<div class="container-fluid">
		22	<div class="row-fluid">
		23	<div class="span2">
		24	<div id="navigation">
		25	[% INCLUDE 'navigation.inc' IsPatronPage=1 %]
		26	</div>
		27	</div>
		28	<div class="span10">
		29	<div id="useraccount" class="maincontent">
		30	[% IF error %]
		31	<div id="error" class="dialog alert">
		32	<p><strong>Error:</strong> there was an problem processing your payment</p>
		33
		34	[% IF error == "PAYPAL_UNABLE_TO_CONNECT" %]
		35	<p>Unable to connect to PayPal.</p>
		36	<p>Please try again later.</p>
		37	[% ELSIF error == "PAYPAL_ERROR_PROCESSING" %]
		38	<p>Unable to verify payment.</p>
		39	<p>Please contact the library to verify your payment.</p>
		40	[% END %]
		41	</div>
		42	[% ELSIF credit %]
		43	<div class="dialog message">
		44	<p><strong>Payment applied:</strong> your payment of [% credit.amount_paid %] has been applied to your account</p>
		45	</div>
		46	[% END %]
		47
		48	<a href="/cgi-bin/koha/opac-account.pl">Return to fine details</a>
		49	</div> <!-- / #useraccount -->
		50	</div> <!-- / .span10 -->
		51	</div> <!-- / .row-fluid -->
		52	</div> <!-- / .container-fluid -->
		53	</div> <!-- / .main -->
		54
		55	[% INCLUDE 'opac-bottom.inc' %]
		56	[% INCLUDE 'datatables.inc' %]
		57
		58	<script type="text/javascript">
		59	//<![CDATA[
		60	$(document).ready(function() {
		61	$('#account-credits').hide();
		62	$('#account-debits-switcher').click(function() {
		63	$('#account-debits').slideUp();
		64	$('#account-credits').slideDown();
65	});
66	$('#account-credits-switcher').click(function() {
67	$('#account-credits').slideUp();
68	$('#account-debits').slideDown();
69	});
70
71	var anOpen = [];
72	var sImageUrl = "[% interface %]/[% theme %]/images/";
73
74	var debitsTable = $('#debits-table').dataTable( {
75	"bProcessing": true,
76	"aoColumns": [
77	{
78	"mDataProp": null,
79	"sClass": "control center",
80	"sDefaultContent": '<img src="'+sImageUrl+'details_open.png'+'">'
81	},
82	{ "mDataProp": "debit_id" },
83	{ "mDataProp": "description" },
84	{ "mDataProp": "type" },
85	{ "mDataProp": "amount_original" },
86	{ "mDataProp": "amount_outstanding" },
87	{ "mDataProp": "created_on" },
88	{ "mDataProp": "updated_on" },
89	{
90	/* Payment selection checkboxes */
91	[% UNLESS Koha.Preference('EnablePayPalOpacPayments') %]
92	"bVisible": false,
93	[% END %]
94	"mDataProp": null,
95	"sDefaultContent": "",
96	"fnRender": function ( o, val ) {
97	return val;
98	},
99	"mRender": function ( data, type, full ) {
100	if ( full.amount_outstanding_unformatted > 0 ) {
101	return "<input class='pay-checkbox' name='debit_id' value='" + full.debit_id + "' type='checkbox'/>"
102	+ "<input type='hidden' id='amount_outstanding_" + full.debit_id + "' value='" + full.amount_outstanding_unformatted + "'/>";
103	}
104	}
105	},
106	],
107	"aaData": [
108	[% FOREACH d IN debits %]
109	{
110	[% PROCESS format_data data=d highlight='debit' %]
111
112	// Data for related item if there is one linked
113	"title": "[% d.item.biblio.title \|\| d.deleted_item.biblio.title \|\| d.deleted_item.deleted_biblio.title %]",
114	"biblionumber": "[% d.item.biblio.biblionumber \|\| d.deleted_item.biblio.biblionumber %]",
115	"barcode": "[% d.item.barcode \|\| d.deleted_item.barcode %]",
116	"itemnumber": "[% d.item.itemnumber %]", //This way itemnumber will be undef if deleted
117
118
119	// Data for related issue if there is one linked
120	[% IF d.issue %]
121	[% SET table = 'issue' %]
122	[% ELSIF d.old_issue %]
123	[% SET table = 'old_issue' %]
124	[% END %]
125
126	[% IF table %]
127	"issue": {
128	[% PROCESS format_data data=d.$table %]
129	},
130	[% END %]
131
132
133	"account_offsets": [
134	[% FOREACH ao IN d.account_offsets %]
135	{
136	[% PROCESS format_data data=ao highlight='offset'%]
137
138	"credit": {
139	[% PROCESS format_data data=ao.credit highlight='credit' %]
140	}
141	},
142	[% END %]
143	]
144
145	},
146	[% END %]
147	]
148	} );
149
150	$('#debits-table td.control').live( 'click', function () {
151	var nTr = this.parentNode;
152	var i = $.inArray( nTr, anOpen );
153
154	if ( i === -1 ) {
155	$('img', this).attr( 'src', sImageUrl+"details_close.png" );
156	var nDetailsRow = debitsTable.fnOpen( nTr, fnFormatDebitDetails(debitsTable, nTr), 'details' );
157	$('div.innerDetails', nDetailsRow).slideDown();
158	anOpen.push( nTr );
159	}
160	else {
161	$('img', this).attr( 'src', sImageUrl+"details_open.png" );
162	$('div.innerDetails', $(nTr).next()[0]).slideUp( function () {
163	debitsTable.fnClose( nTr );
164	anOpen.splice( i, 1 );
165	} );
166	}
167	} );
168
169	var creditsTable = $('#credits-table').dataTable( {
170	"bProcessing": true,
171	"aoColumns": [
172	{
173	"mDataProp": null,
174	"sClass": "control center",
175	"sDefaultContent": '<img src="'+sImageUrl+'details_open.png'+'">'
176	},
177	{ "mDataProp": "credit_id" },
178	{ "mDataProp": "notes" },
179	{ "mDataProp": "type" },
180	{ "mDataProp": "amount_paid" },
181	{ "mDataProp": "amount_remaining" },
182	{ "mDataProp": "created_on" },
183	{ "mDataProp": "updated_on" }
184	],
185	"aaData": [
186	[% FOREACH c IN credits %]
187	{
188	[% PROCESS format_data data=c highlight='credit' %]
189
190	"account_offsets": [
191	[% FOREACH ao IN c.account_offsets %]
192	{
193	[% PROCESS format_data data=ao highlight='offset' %]
194
195	"debit": {
196	[% PROCESS format_data data=ao.debit highlight='debit' %]
197	}
198	},
199	[% END %]
200	]
201
202	},
203	[% END %]
204	]
205	} );
206
207	$('#credits-table td.control').live( 'click', function () {
208	var nTr = this.parentNode;
209	var i = $.inArray( nTr, anOpen );
210
211	if ( i === -1 ) {
212	$('img', this).attr( 'src', sImageUrl+"details_close.png" );
213	var nDetailsRow = creditsTable.fnOpen( nTr, fnFormatCreditDetails(creditsTable, nTr), 'details' );
214	$('div.innerDetails', nDetailsRow).slideDown();
215	anOpen.push( nTr );
216	}
217	else {
218	$('img', this).attr( 'src', sImageUrl+"details_open.png" );
219	$('div.innerDetails', $(nTr).next()[0]).slideUp( function () {
220	creditsTable.fnClose( nTr );
221	anOpen.splice( i, 1 );
222	} );
223	}
224	} );
225
226	// Allow only numbers in ammount to pay
227	$('#amount_to_pay').keypress(function(event) {
228	end = $(this).val().split('.')[1];
229	if (typeof end === 'undefined') {
230	end = '';
231	}
232
233	if ( ( ( event.which != 46 \|\| $(this).val().indexOf('.') != -1 ) && ( event.which < 48 \|\| event.which > 57 ) ) \|\| ( end.length > 1 ) ) {
234	event.preventDefault();
235	}
236	});
237
238	// Update the "amount to pay" field whenever a fee checkbox is changed
239	// Note, this is just a payment suggestion and can be changed to any amount
240	$(".pay-checkbox" ).change(function() {
241	var sum = 0;
242	$("input[name='debit_id']:checked" ).each(function(i,n){
243	sum += parseFloat( $( "#amount_outstanding_" + $(this).val() ).val() );
244	});
245	$('#amount_to_pay').val( sum.toFixed(2) );
246	});
247
248	} );
249
250	function fnFormatDebitDetails( debitsTable, nTr ) {
251	var oData = debitsTable.fnGetData( nTr );
252
253	var sOut = "<div class='innerDetails' style='display:none;'>";
254
255	var account_offsets = oData.account_offsets;
256
257	sOut += "<ul>";
258	if ( oData.title ) {
259	sOut += "<li>" + _("Title: ");
260	if ( oData.biblionumber ) {
261	sOut += "<a href='/cgi-bin/koha/opac-detail.pl?biblionumber=" + oData.biblionumber + "'>";
262	}
263
264	sOut += oData.title;
265
266	if ( oData.biblionumber ) {
267	sOut += "</a>";
268	}
269
270	sOut += "</li>";
271	}
272
273	if ( oData.barcode ) {
274	sOut += "<li>" + _("Barcode: ") + oData.barcode + "</li>";
275	}
276
277	if ( oData.notes ) {
278	sOut += "<li>" + _("Notes: ") + oData.notes + "</li>";
279	}
280
281	sOut += "</ul>";
282
283	if ( account_offsets.length ) {
284	sOut +=
285	"<div class='innerDetails'>" +
286	"<table cellpadding='5' cellspacing='0' border='0' style='margin:10px;'>" +
287	"<thead>" +
288	"<tr><th colspan='99'>" + _("Payments applied") + "</th></tr>" +
289	"<tr>" +
290	"<th>" + _("ID") + "</th>" +
291	"<th>" + _("Created on") + "</th>" +
292	"<th>" + _("Payment amount") + "</th>" +
293	"<th>" + _("Applied amount") + "</th>" +
294	"<th>" + _("Type") + "</th>" +
295	"<th>" + _("Notes") + "</th>" +
296	"</tr>" +
297	"</thead>" +
298	"<tbody>";
299
300	for ( var i = 0; i < account_offsets.length; i++ ) {
301	ao = account_offsets[i];
302	sOut +=
303	"<tr>" +
304	"<td>" + ao.credit_id + "</td>" +
305	"<td>" + ao.created_on + "</td>" +
306	"<td>" + ao.credit.amount_paid + "</td>" +
307	"<td>" + ao.amount + "</td>" +
308	"<td>" + ao.credit.type + "</td>" +
309	"<td>" + ao.credit.notes + "</td>" +
310	"</tr>";
311	}
312
313	sOut +=
314	"</tbody>"+
315	"</table>";
316	}
317
318	sOut +=
319	"</div>";
320
321	return sOut;
322	}
323
324	function fnFormatCreditDetails( creditsTable, nTr ) {
325	var oData = creditsTable.fnGetData( nTr );
326
327	var sOut = "<div class='innerDetails' style='display:none;'>";
328
329	var account_offsets = oData.account_offsets;
330
331	if ( account_offsets.length ) {
332	sOut +=
333	"<table cellpadding='5' cellspacing='0' border='0' style='margin:10px;'>" +
334	"<thead>" +
335	"<tr><th colspan='99'>" + _("Fees paid") + "</th></tr>" +
336	"<tr>" +
337	"<th>" + _("ID") + "</th>" +
338	"<th>" + _("Description") + "</th>" +
339	"<th>" + _("Type") + "</th>" +
340	"<th>" + _("Amount") + "</th>" +
341	"<th>" + _("Remaining") + "</th>" +
342	"<th>" + _("Created on") + "</th>" +
343	"<th>" + _("Updated on") + "</th>" +
344	"<th>" + _("Notes") + "</th>" +
345	"</tr>" +
346	"</thead>" +
347	"<tbody>";
348
349	for ( var i = 0; i < account_offsets.length; i++ ) {
350	ao = account_offsets[i];
351	sOut +=
352	"<tr>" +
353	"<td>" + ao.debit.debit_id + "</td>" +
354	"<td>" + ao.debit.description + "</td>" +
355	"<td>" + ao.debit.type + "</td>" +
356	"<td>" + ao.debit.amount_original + "</td>" +
357	"<td>" + ao.debit.amount_outstanding + "</td>" +
358	"<td>" + ao.debit.created_on + "</td>" +
359	"<td>" + ao.debit.updated_on + "</td>" +
360	"<td>" + ao.debit.notes + "</td>" +
361	"</tr>";
362	}
363
364	sOut +=
365	"</tbody>"+
366	"</table>";
367	}
368
369	sOut +=
370	"</div>";
371
372	return sOut;
373	}
374
375	//]]>
376	</script>
377
378	[% BLOCK jsinclude %][% END %]
379
380	[% BLOCK format_data %]
381	[% FOREACH key IN data.result_source.columns %]
382	[% IF key.match('^amount') %]
383	"[% key %]": "[% data.$key FILTER $Currency %]",
384	"[% key %]_unformatted": "[% data.$key %]",
385	[% ELSIF key.match('_on$') %]
386	"[% key %]": "[% data.$key \| $KohaDates %]",
387	"[% key %]_unformatted": "[% data.$key %]",
388	[% ELSE %]
389	"[% key %]": "[% data.$key %]",
390	[% END %]
391	[% END %]
392	[% END %]

Lines 34-84 Link Here

(-)a/koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-account.tt (-46 / +115 lines)
34	<h3>Account balance: [% borrower.account_balance \| $Currency %]</h3>	34	<h3>Account balance: [% borrower.account_balance \| $Currency %]</h3>
35	</p>	35	</p>
36		36
37	<div>	37	<form action="/cgi-bin/koha/opac-account-pay.pl" method="post">
38	<div id="account-debits">	38	<div>
39	<a id="account-debits-switcher" href="#" onclick="return false">View payments</a>	39	<div id="account-debits">
40	<table cellpadding="0" cellspacing="0" border="0" class="display" id="debits-table">	40	<a id="account-debits-switcher" href="#" onclick="return false">View payments</a>
41	<thead>	41	<table cellpadding="0" cellspacing="0" border="0" class="display" id="debits-table">
42	<tr>	42	<thead>
43	<th colspan="99">Fees</th>	43	<tr>
44	</tr>	44	<th colspan="99">Fees</th>
45	<tr>	45	</tr>
46	<th></th>	46	<tr>
47	<th>ID</th>	47	<th></th>
48	<th>Description</th>	48	<th>ID</th>
49	<th>Type</th>	49	<th>Description</th>
50	<th>Amount</th>	50	<th>Type</th>
51	<th>Outsanding</th>	51	<th>Amount</th>
52	<th>Created on</th>	52	<th>Outsanding</th>
53	<th>Updated on</th>	53	<th>Created on</th>
54	</tr>	54	<th>Updated on</th>
55	</thead>	55	<th>Pay</th>
56	<tbody></tbody>	56	</tr>
57	</table>	57	</thead>
		58	<tbody></tbody>
		59	</table>
		60	</div>
		61
		62	<div id="account-credits">
		63	<a id="account-credits-switcher" href="#" onclick="return false">View fees</a>
		64	<table cellpadding="0" cellspacing="0" border="0" class="display" id="credits-table">
		65	<thead>
		66	<tr>
		67	<th colspan="99">Payments</th>
		68	</tr>
		69	<tr>
		70	<th></th>
		71	<th>ID</th>
		72	<th>Notes</th>
		73	<th>Type</th>
		74	<th>Amount</th>
		75	<th>Remaining</th>
		76	<th>Created on</th>
		77	<th>Updated on</th>
		78	</tr>
		79	</thead>
		80	<tbody></tbody>
		81	</table>
		82	</div>
		83
		84	[% IF Koha.Preference('EnablePayPalOpacPayments') %]
		85	<fieldset>
		86	<legend>Pay online</legend>
		87
		88	<div>
		89	Amount to pay:
		90	[% Currency.symbol() %]<input type="text" id="amount_to_pay" name="amount_to_pay"/>
		91	</div>
		92
		93	<div>
		94	<h6>Payment method:</h6>
		95	<input type="radio" name="payment_method" value="paypal" checked="checked"/>
		96	<label for="payment-method">
		97	<img src="https://www.paypal.com/en_US/i/logo/PayPal_mark_37x23.gif" align="left" style="margin-right:7px;">
		98	</label>
		99	</div>
		100
		101	<br/>
		102
		103	<div>
		104	<input type="submit" value="Make payment">
		105	</div>
		106	</fieldset>
		107	[% END %]
58	</div>	108	</div>
59		109	</form>
60	<div id="account-credits">
61	<a id="account-credits-switcher" href="#" onclick="return false">View fees</a>
62	<table cellpadding="0" cellspacing="0" border="0" class="display" id="credits-table">
63	<thead>
64	<tr>
65	<th colspan="99">Payments</th>
66	</tr>
67	<tr>
68	<th></th>
69	<th>ID</th>
70	<th>Notes</th>
71	<th>Type</th>
72	<th>Amount</th>
73	<th>Remaining</th>
74	<th>Created on</th>
75	<th>Updated on</th>
76	</tr>
77	</thead>
78	<tbody></tbody>
79	</table>
80	</div>
81	</div>
82	[% ELSE %]	110	[% ELSE %]
83	<h4>You have no fines or charges</h4>	111	<h4>You have no fines or charges</h4>
84	[% END %]	112	[% END %]
Lines 121-127 $(document).ready(function() { Link Here
121	{ "mDataProp": "amount_original" },	149	{ "mDataProp": "amount_original" },
122	{ "mDataProp": "amount_outstanding" },	150	{ "mDataProp": "amount_outstanding" },
123	{ "mDataProp": "created_on" },	151	{ "mDataProp": "created_on" },
124	{ "mDataProp": "updated_on" }	152	{ "mDataProp": "updated_on" },
		153	{
		154	/* Payment selection checkboxes */
		155	[% UNLESS Koha.Preference('EnablePayPalOpacPayments') %]
		156	"bVisible": false,
		157	[% END %]
		158	"mDataProp": null,
		159	"sDefaultContent": "",
		160	"fnRender": function ( o, val ) {
		161	return val;
		162	},
		163	"mRender": function ( data, type, full ) {
		164	if ( full.amount_outstanding_unformatted > 0 ) {
		165	return "<input class='pay-checkbox' name='debit_id' value='" + full.debit_id + "' type='checkbox'/>"
		166	+ "<input type='hidden' id='amount_outstanding_" + full.debit_id + "' value='" + full.amount_outstanding_unformatted + "'/>";
		167	}
		168	}
		169	},
125	],	170	],
126	"aaData": [	171	"aaData": [
127	[% FOREACH d IN debits %]	172	[% FOREACH d IN debits %]
Lines 242-247 $(document).ready(function() { Link Here
242	}	287	}
243	} );	288	} );
244		289
		290	// Allow only numbers in ammount to pay
		291	$('#amount_to_pay').keypress(function(event) {
		292	end = $(this).val().split('.')[1];
		293	if (typeof end === 'undefined') {
		294	end = '';
		295	}
		296
		297	if ( ( ( event.which != 46 \|\| $(this).val().indexOf('.') != -1 ) && ( event.which < 48 \|\| event.which > 57 ) ) \|\| ( end.length > 1 ) ) {
		298	event.preventDefault();
		299	}
		300	});
		301
		302	// Update the "amount to pay" field whenever a fee checkbox is changed
		303	// Note, this is just a payment suggestion and can be changed to any amount
		304	$(".pay-checkbox" ).change(function() {
		305	var sum = 0;
		306	$("input[name='debit_id']:checked" ).each(function(i,n){
		307	sum += parseFloat( $( "#amount_outstanding_" + $(this).val() ).val() );
		308	});
		309	$('#amount_to_pay').val( sum.toFixed(2) );
		310	});
		311
245	} );	312	} );
246		313
247	function fnFormatDebitDetails( debitsTable, nTr ) {	314	function fnFormatDebitDetails( debitsTable, nTr ) {
Lines 321-327 function fnFormatDebitDetails( debitsTable, nTr ) { Link Here
321	function fnFormatCreditDetails( creditsTable, nTr ) {	388	function fnFormatCreditDetails( creditsTable, nTr ) {
322	var oData = creditsTable.fnGetData( nTr );	389	var oData = creditsTable.fnGetData( nTr );
323		390
324	var sOut = "<div class="innerDetails" style="display:none;">";	391	var sOut = "<div class='innerDetails' style='display:none;'>";
325		392
326	var account_offsets = oData.account_offsets;	393	var account_offsets = oData.account_offsets;
327		394
Lines 378-385 function fnFormatCreditDetails( creditsTable, nTr ) { Link Here
378	[% FOREACH key IN data.result_source.columns %]	445	[% FOREACH key IN data.result_source.columns %]
379	[% IF key.match('^amount') %]	446	[% IF key.match('^amount') %]
380	"[% key %]": "[% data.$key FILTER $Currency %]",	447	"[% key %]": "[% data.$key FILTER $Currency %]",
		448	"[% key %]_unformatted": "[% data.$key %]",
381	[% ELSIF key.match('_on$') %]	449	[% ELSIF key.match('_on$') %]
382	"[% key %]": "[% data.$key \| $KohaDates %]",	450	"[% key %]": "[% data.$key \| $KohaDates %]",
		451	"[% key %]_unformatted": "[% data.$key %]",
383	[% ELSE %]	452	[% ELSE %]
384	"[% key %]": "[% data.$key %]",	453	"[% key %]": "[% data.$key %]",
385	[% END %]	454	[% END %]

Line 0 Link Here

(-)a/koha-tmpl/opac-tmpl/prog/en/modules/opac-account-pay-return.tt (+396 lines)
		1	[% SET accountview = 1 %]
		2
		3	[% USE Koha %]
		4	[% USE KohaDates %]
		5	[% USE Currency %]
		6
		7	[% INCLUDE 'doc-head-open.inc' %][% IF ( LibraryNameTitle ) %][% LibraryNameTitle %][% ELSE %]Koha online[% END %] catalog &rsaquo; Your fines and charges
		8	[% INCLUDE 'doc-head-close.inc' %]
		9	</head>
		10	<body id="opac-account">
		11	<div id="doc3" class="yui-t1">
		12	<div id="bd">
		13	[% INCLUDE 'masthead.inc' %]
		14	<div id="yui-main">
		15	<div class="yui-b">
		16	<div class="yui-g">
		17	<div id="useraccount" class="container">
		18	<h3><a href="/cgi-bin/koha/opac-user.pl">[% borrower.firstname %] [% borrower.surname %]'s account</a> ⇢ Fines and charges</h3>
		19
		20	[% IF error %]
		21	<div id="error" class="dialog alert">
		22	<p><strong>Error:</strong> there was an problem processing your payment</p>
		23
		24	[% IF error == "PAYPAL_UNABLE_TO_CONNECT" %]
		25	<p>Unable to connect to PayPal.</p>
		26	<p>Please try again later.</p>
		27	[% ELSIF error == "PAYPAL_ERROR_PROCESSING" %]
		28	<p>Unable to verify payment.</p>
		29	<p>Please contact the library to verify your payment.</p>
		30	[% END %]
		31	</div>
		32	[% ELSIF credit %]
		33	<div class="dialog message">
		34	<p><strong>Payment applied:</strong> your payment of [% credit.amount_paid %] has been applied to your account</p>
		35	</div>
		36	[% END %]
		37
		38	<a href="/cgi-bin/koha/opac-account.pl">Return to fine details</a>
		39	</div>
		40	</div>
		41	</div>
		42	</div>
		43
		44	<div class="yui-b">
		45	<div id="leftmenus" class="container">
		46	[% INCLUDE 'navigation.inc' IsPatronPage=1 %]
		47	</div>
		48	</div>
		49	</div>
		50	[% INCLUDE 'opac-bottom.inc' %]
		51
		52	[% INCLUDE 'datatables.inc' %]
		53	[% INCLUDE 'browser-strings.inc' %]
		54
		55	<script type="text/javascript">
		56	//<![CDATA[
		57	$(document).ready(function() {
		58	$('#account-credits').hide();
		59	$('#account-debits-switcher').click(function() {
		60	$('#account-debits').slideUp();
		61	$('#account-credits').slideDown();
		62	});
		63	$('#account-credits-switcher').click(function() {
		64	$('#account-credits').slideUp();
65	$('#account-debits').slideDown();
66	});
67
68	var anOpen = [];
69	var sImageUrl = "[% interface %]/[% theme %]/images/";
70
71	var debitsTable = $('#debits-table').dataTable( {
72	"bProcessing": true,
73	"aoColumns": [
74	{
75	"mDataProp": null,
76	"sClass": "control center",
77	"sDefaultContent": '<img src="'+sImageUrl+'details_open.png'+'">'
78	},
79	{ "mDataProp": "debit_id" },
80	{ "mDataProp": "description" },
81	{
82	"mDataProp": "type",
83	"fnRender": function ( o, val ) {
84	return STRINGS['DebitTypes'][val];
85	},
86	},
87	{ "mDataProp": "amount_original" },
88	{ "mDataProp": "amount_outstanding" },
89	{ "mDataProp": "created_on" },
90	{ "mDataProp": "updated_on" },
91	{
92	"mDataProp": null,
93	"sDefaultContent": "",
94	"fnRender": function ( o, val ) {
95	return val;
96	},
97	"mRender": function ( data, type, full ) {
98	if ( full.amount_outstanding_unformatted > 0 ) {
99	return "<input class='pay-checkbox' name='debit_id' value='" + full.debit_id + "' type='checkbox'/>"
100	+ "<input type='hidden' id='amount_outstanding_" + full.debit_id + "' value='" + full.amount_outstanding_unformatted + "'/>";
101	}
102	}
103	},
104	],
105	"aaData": [
106	[% FOREACH d IN debits %]
107	{
108	[% PROCESS format_data data=d highlight='debit' %]
109
110	// Data for related item if there is one linked
111	"title": "[% d.item.biblio.title \|\| d.deleted_item.biblio.title \|\| d.deleted_item.deleted_biblio.title %]",
112	"biblionumber": "[% d.item.biblio.biblionumber \|\| d.deleted_item.biblio.biblionumber %]",
113	"barcode": "[% d.item.barcode \|\| d.deleted_item.barcode %]",
114	"itemnumber": "[% d.item.itemnumber %]", //This way itemnumber will be undef if deleted
115
116
117	// Data for related issue if there is one linked
118	[% IF d.issue %]
119	[% SET table = 'issue' %]
120	[% ELSIF d.old_issue %]
121	[% SET table = 'old_issue' %]
122	[% END %]
123
124	[% IF table %]
125	"issue": {
126	[% PROCESS format_data data=d.$table %]
127	},
128	[% END %]
129
130
131	"account_offsets": [
132	[% FOREACH ao IN d.account_offsets %]
133	{
134	[% PROCESS format_data data=ao highlight='offset'%]
135
136	"credit": {
137	[% PROCESS format_data data=ao.credit highlight='credit' %]
138	}
139	},
140	[% END %]
141	]
142
143	},
144	[% END %]
145	]
146	} );
147
148	$('#debits-table td.control').live( 'click', function () {
149	var nTr = this.parentNode;
150	var i = $.inArray( nTr, anOpen );
151
152	if ( i === -1 ) {
153	$('img', this).attr( 'src', sImageUrl+"details_close.png" );
154	var nDetailsRow = debitsTable.fnOpen( nTr, fnFormatDebitDetails(debitsTable, nTr), 'details' );
155	$('div.innerDetails', nDetailsRow).slideDown();
156	anOpen.push( nTr );
157	}
158	else {
159	$('img', this).attr( 'src', sImageUrl+"details_open.png" );
160	$('div.innerDetails', $(nTr).next()[0]).slideUp( function () {
161	debitsTable.fnClose( nTr );
162	anOpen.splice( i, 1 );
163	} );
164	}
165	} );
166
167	var creditsTable = $('#credits-table').dataTable( {
168	"bProcessing": true,
169	"aoColumns": [
170	{
171	"mDataProp": null,
172	"sClass": "control center",
173	"sDefaultContent": '<img src="'+sImageUrl+'details_open.png'+'">'
174	},
175	{ "mDataProp": "credit_id" },
176	{ "mDataProp": "notes" },
177	{
178	"mDataProp": "type",
179	"fnRender": function ( o, val ) {
180	return STRINGS['CreditTypes'][val];
181	},
182	},
183	{ "mDataProp": "amount_paid" },
184	{ "mDataProp": "amount_remaining" },
185	{ "mDataProp": "created_on" },
186	{ "mDataProp": "updated_on" }
187	],
188	"aaData": [
189	[% FOREACH c IN credits %]
190	{
191	[% PROCESS format_data data=c highlight='credit' %]
192
193	"account_offsets": [
194	[% FOREACH ao IN c.account_offsets %]
195	{
196	[% PROCESS format_data data=ao highlight='offset' %]
197
198	"debit": {
199	[% PROCESS format_data data=ao.debit highlight='debit' %]
200	}
201	},
202	[% END %]
203	]
204
205	},
206	[% END %]
207	]
208	} );
209
210	$('#credits-table td.control').live( 'click', function () {
211	var nTr = this.parentNode;
212	var i = $.inArray( nTr, anOpen );
213
214	if ( i === -1 ) {
215	$('img', this).attr( 'src', sImageUrl+"details_close.png" );
216	var nDetailsRow = creditsTable.fnOpen( nTr, fnFormatCreditDetails(creditsTable, nTr), 'details' );
217	$('div.innerDetails', nDetailsRow).slideDown();
218	anOpen.push( nTr );
219	}
220	else {
221	$('img', this).attr( 'src', sImageUrl+"details_open.png" );
222	$('div.innerDetails', $(nTr).next()[0]).slideUp( function () {
223	creditsTable.fnClose( nTr );
224	anOpen.splice( i, 1 );
225	} );
226	}
227	} );
228
229	// Allow only numbers in ammount to pay
230	$('#amount_to_pay').keypress(function(event) {
231	end = $(this).val().split('.')[1];
232	if (typeof end === 'undefined') {
233	end = '';
234	}
235
236	if ( ( ( event.which != 46 \|\| $(this).val().indexOf('.') != -1 ) && ( event.which < 48 \|\| event.which > 57 ) ) \|\| ( end.length > 1 ) ) {
237	event.preventDefault();
238	}
239	});
240
241	// Update the "amount to pay" field whenever a fee checkbox is changed
242	// Note, this is just a payment suggestion and can be changed to any amount
243	$(".pay-checkbox" ).change(function() {
244	var sum = 0;
245	$("input[name='debit_id']:checked" ).each(function(i,n){
246	sum += parseFloat( $( "#amount_outstanding_" + $(this).val() ).val() );
247	});
248	$('#amount_to_pay').val( sum.toFixed(2) );
249	});
250
251
252	} );
253
254	function fnFormatDebitDetails( debitsTable, nTr ) {
255	var oData = debitsTable.fnGetData( nTr );
256
257	var sOut = "<div class='innerDetails' style='display:none;'>";
258
259	var account_offsets = oData.account_offsets;
260
261	sOut += "<ul>";
262	if ( oData.title ) {
263	sOut += "<li>" + _("Title: ");
264	if ( oData.biblionumber ) {
265	sOut += "<a href='/cgi-bin/koha/opac-detail.pl?biblionumber=" + oData.biblionumber + "'>";
266	}
267
268	sOut += oData.title;
269
270	if ( oData.biblionumber ) {
271	sOut += "</a>";
272	}
273
274	sOut += "</li>";
275	}
276
277	if ( oData.barcode ) {
278	sOut += "<li>" + _("Barcode: ") + oData.barcode + "</li>";
279	}
280
281	if ( oData.notes ) {
282	sOut += "<li>" + _("Notes: ") + oData.notes + "</li>";
283	}
284
285	sOut += "</ul>";
286
287	if ( account_offsets.length ) {
288	sOut +=
289	"<div class='innerDetails'>" +
290	"<table cellpadding='5' cellspacing='0' border='0' style='margin:10px;'>" +
291	"<thead>" +
292	"<tr><th colspan='99'>" + _("Payments applied") + "</th></tr>" +
293	"<tr>" +
294	"<th>" + _("ID") + "</th>" +
295	"<th>" + _("Created on") + "</th>" +
296	"<th>" + _("Payment amount") + "</th>" +
297	"<th>" + _("Applied amount") + "</th>" +
298	"<th>" + _("Type") + "</th>" +
299	"<th>" + _("Notes") + "</th>" +
300	"</tr>" +
301	"</thead>" +
302	"<tbody>";
303
304	for ( var i = 0; i < account_offsets.length; i++ ) {
305	ao = account_offsets[i];
306	sOut +=
307	"<tr>" +
308	"<td>" + ao.credit_id + "</td>" +
309	"<td>" + ao.created_on + "</td>" +
310	"<td>" + ao.credit.amount_paid + "</td>" +
311	"<td>" + ao.amount + "</td>" +
312	"<td>" + ao.credit.type + "</td>" +
313	"<td>" + ao.credit.notes + "</td>" +
314	"</tr>";
315	}
316
317	sOut +=
318	"</tbody>"+
319	"</table>";
320	}
321
322	sOut +=
323	"</div>";
324
325	return sOut;
326	}
327
328	function fnFormatCreditDetails( creditsTable, nTr ) {
329	var oData = creditsTable.fnGetData( nTr );
330
331	var sOut = '<div class="innerDetails" style="display:none;">';
332
333	var account_offsets = oData.account_offsets;
334
335	if ( account_offsets.length ) {
336	sOut +=
337	"<table cellpadding='5' cellspacing='0' border='0' style='margin:10px;'>" +
338	"<thead>" +
339	"<tr><th colspan='99'>" + _("Fees paid") + "</th></tr>" +
340	"<tr>" +
341	"<th>" + _("ID") + "</th>" +
342	"<th>" + _("Description") + "</th>" +
343	"<th>" + _("Type") + "</th>" +
344	"<th>" + _("Amount") + "</th>" +
345	"<th>" + _("Remaining") + "</th>" +
346	"<th>" + _("Created on") + "</th>" +
347	"<th>" + _("Updated on") + "</th>" +
348	"<th>" + _("Notes") + "</th>" +
349	"</tr>" +
350	"</thead>" +
351	"<tbody>";
352
353	for ( var i = 0; i < account_offsets.length; i++ ) {
354	ao = account_offsets[i];
355	sOut +=
356	"<tr>" +
357	"<td>" + ao.debit.debit_id + "</td>" +
358	"<td>" + ao.debit.description + "</td>" +
359	"<td>" + ao.debit.type + "</td>" +
360	"<td>" + ao.debit.amount_original + "</td>" +
361	"<td>" + ao.debit.amount_outstanding + "</td>" +
362	"<td>" + ao.debit.created_on + "</td>" +
363	"<td>" + ao.debit.updated_on + "</td>" +
364	"<td>" + ao.debit.notes + "</td>" +
365	"</tr>";
366	}
367
368	sOut +=
369	"</tbody>"+
370	"</table>";
371	}
372
373	sOut +=
374	"</div>";
375
376	return sOut;
377	}
378
379	//]]>
380	</script>
381
382	[% BLOCK jsinclude %][% END %]
383
384	[% BLOCK format_data %]
385	[% FOREACH key IN data.result_source.columns %]
386	[% IF key.match('^amount') %]
387	"[% key %]": "[% data.$key FILTER $Currency %]",
388	"[% key %]_unformatted": "[% data.$key %]",
389	[% ELSIF key.match('_on$') %]
390	"[% key %]": "[% data.$key \| $KohaDates %]",
391	"[% key %]_unformatted": "[% data.$key %]",
392	[% ELSE %]
393	"[% key %]": "[% data.$key %]",
394	[% END %]
395	[% END %]
396	[% END %]

Line 0 Link Here

(-)a/opac/opac-account-pay-paypal-return.pl (+121 lines)
		1	#!/usr/bin/perl
		2
		3	# Copyright Katipo Communications 2002
		4	# Copyright Biblibre 2007,2010
		5	#
		6	# This file is part of Koha.
		7	#
		8	# Koha is free software; you can redistribute it and/or modify it under the
		9	# terms of the GNU General Public License as published by the Free Software
		10	# Foundation; either version 2 of the License, or (at your option) any later
		11	# version.
		12	#
		13	# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
		14	# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
		15	# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
		16	#
		17	# You should have received a copy of the GNU General Public License along
		18	# with Koha; if not, write to the Free Software Foundation, Inc.,
		19	# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
		20
		21	use strict;
		22	use warnings;
		23	use utf8;
		24
		25	use CGI;
		26	use HTTP::Request::Common;
		27	use LWP::UserAgent;
		28	use URL::Encode qw(url_params_mixed);
		29
		30	use C4::Auth;
		31	use C4::Output;
		32	use C4::Members;
		33	use Koha::Database;
		34	use Koha::Accounts qw(AddCredit);
		35	use Koha::Accounts::CreditTypes;
		36
		37	my $cgi = new CGI;
		38
		39	unless ( C4::Context->preference('EnablePayPalOpacPayments') ) {
		40	print $cgi->redirect("/cgi-bin/koha/errors/404.pl");
		41	exit;
		42	}
		43
		44	my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
		45	{
		46	template_name => "opac-account-pay-return.tt",
		47	query => $cgi,
		48	type => "opac",
		49	authnotrequired => 0,
		50	flagsrequired => { borrow => 1 },
		51	debug => 1,
		52	}
		53	);
		54
		55	my $token = $cgi->param('token');
		56	my $payer_id = $cgi->param('PayerID');
		57	my $amount = $cgi->param('amount');
		58	my @debit_id = $cgi->param('debit_id');
		59
		60	my $ua = LWP::UserAgent->new;
		61
		62	my $url =
		63	C4::Context->preference('PayPalSandboxMode')
		64	? 'https://api-3t.sandbox.paypal.com/nvp'
65	: 'https://api-3t.paypal.com/nvp';
66
67	my $nvp_params = {
68	'USER' => C4::Context->preference('PayPalUser'),
69	'PWD' => C4::Context->preference('PayPalPwd'),
70	'SIGNATURE' => C4::Context->preference('PayPalSignature'),
71
72	# API Version and Operation
73	'METHOD' => 'DoExpressCheckoutPayment',
74	'VERSION' => '82.0',
75
76	# API specifics for DoExpressCheckout
77	'PAYMENTREQUEST_0_PAYMENTACTION' => 'Sale',
78	'PAYERID' => $payer_id,
79	'TOKEN' => $token,
80	'PAYMENTREQUEST_0_AMT' => $amount,
81	};
82
83	my $response = $ua->request( POST $url, $nvp_params );
84
85	if ( $response->is_success ) {
86	my $params = url_params_mixed( $response->decoded_content );
87
88	if ( $params->{ACK} eq "Success" ) {
89	$amount = $params->{PAYMENTINFO_0_AMT};
90
91	my $borrower =
92	Koha::Database->new()->schema->resultset('Borrower')
93	->find($borrowernumber);
94
95	my $credit = AddCredit(
96	{
97	borrower => $borrower,
98	amount => $amount,
99	type => Koha::Accounts::CreditTypes::PayPal,
100	debit_id => \@debit_id,
101	}
102	);
103
104	$template->param( credit => $credit );
105
106	}
107	else {
108	$template->param( error => "PAYPAL_ERROR_PROCESSING" );
109	}
110
111	}
112	else {
113	$template->param( error => "PAYPAL_UNABLE_TO_CONNECT" );
114	}
115
116	$template->param(
117	borrower => GetMemberDetails($borrowernumber),
118	accountview => 1
119	);
120
121	output_html_with_http_headers( $cgi, $cookie, $template->output );

Line 0 Link Here

(-)a/opac/opac-account-pay.pl (+127 lines)
		1	#!/usr/bin/perl
		2
		3	# Copyright Katipo Communications 2002
		4	# Copyright Biblibre 2007,2010
		5	#
		6	# This file is part of Koha.
		7	#
		8	# Koha is free software; you can redistribute it and/or modify it under the
		9	# terms of the GNU General Public License as published by the Free Software
		10	# Foundation; either version 2 of the License, or (at your option) any later
		11	# version.
		12	#
		13	# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
		14	# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
		15	# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
		16	#
		17	# You should have received a copy of the GNU General Public License along
		18	# with Koha; if not, write to the Free Software Foundation, Inc.,
		19	# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
		20
		21	use strict;
		22	use warnings;
		23	use utf8;
		24
		25	use CGI;
		26	use HTTP::Request::Common;
		27	use LWP::UserAgent;
		28	use URL::Encode qw(url_encode url_params_mixed);
		29	use URI;
		30
		31	use C4::Auth;
		32
		33	my $cgi = new CGI;
		34
		35	unless ( C4::Context->preference('EnablePayPalOpacPayments') ) {
		36	print $cgi->redirect("/cgi-bin/koha/errors/404.pl");
		37	exit;
		38	}
		39
		40	my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
		41	{
		42	template_name => "opac-account-pay-return.tt",
		43	query => $cgi,
		44	type => "opac",
		45	authnotrequired => 0,
		46	flagsrequired => { borrow => 1 },
		47	debug => 1,
		48	}
		49	);
		50
		51	my $amount_to_pay = $cgi->param('amount_to_pay');
		52	my $payment_method = $cgi->param('payment_method');
		53	my @debit_id = $cgi->param('debit_id');
		54
		55	my $error = 0;
		56	if ( $payment_method eq 'paypal' ) {
		57	my $ua = LWP::UserAgent->new;
		58
		59	my $amount = url_encode($amount_to_pay);
		60
		61	my $url =
		62	C4::Context->preference('PayPalSandboxMode')
		63	? 'https://api-3t.sandbox.paypal.com/nvp'
		64	: 'https://api-3t.paypal.com/nvp';
65
66	my $opac_base_url = C4::Context->preference('OPACBaseURL');
67
68	my $return_url =
69	URI->new( "http://"
70	. $opac_base_url
71	. "/cgi-bin/koha/opac-account-pay-paypal-return.pl" );
72	$return_url->query_form( { amount => $amount, debit_id => \@debit_id } );
73
74	my $cancel_url =
75	URI->new( "http://" . $opac_base_url . "/cgi-bin/koha/opac-account.pl" );
76
77	my $nvp_params = {
78	'USER' => C4::Context->preference('PayPalUser'),
79	'PWD' => C4::Context->preference('PayPalPwd'),
80	'SIGNATURE' => C4::Context->preference('PayPalSignature'),
81
82	# API Version and Operation
83	'METHOD' => 'SetExpressCheckout',
84	'VERSION' => '82.0',
85
86	# API specifics for SetExpressCheckout
87	'NOSHIPPING' => 1,
88	'REQCONFIRMSHIPPING' => 0,
89	'ALLOWNOTE' => 0,
90	'BRANDNAME' => C4::Context->preference('LibraryName'),
91	'CANCELURL' => $cancel_url->as_string(),
92	'RETURNURL' => $return_url->as_string(),
93	'PAYMENTREQUEST_0_AMT' => $amount_to_pay,
94	'PAYMENTREQUEST_0_PAYMENTACTION' => 'Sale',
95	'PAYMENTREQUEST_0_ALLOWEDPAYMENTMETHOD' => 'InstantPaymentOnly',
96	'PAYMENTREQUEST_0_DESC' =>
97	C4::Context->preference('PayPalChargeDescription'),
98	};
99
100	my $response = $ua->request( POST $url, $nvp_params );
101
102	if ( $response->is_success ) {
103	my $params = url_params_mixed( $response->decoded_content );
104
105	if ( $params->{ACK} eq "Success" ) {
106	my $token = $params->{TOKEN};
107
108	my $redirect_url =
109	C4::Context->preference('PayPalSandboxMode')
110	? "https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token="
111	: "https://www.paypal.com/cgi-bin/webscr?cmd=_express-checkout&token=";
112	print $cgi->redirect( $redirect_url . $token );
113
114	}
115	else {
116	$template->param( error => "PAYPAL_ERROR_PROCESSING" );
117	$error = 1;
118	}
119
120	}
121	else {
122	$template->param( error => "PAYPAL_UNABLE_TO_CONNECT" );
123	$error = 1;
124	}
125	}
126
127	output_html_with_http_headers( $cgi, $cookie, $template->output ) if $error;