Attachment #25986 for bug #11703

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




# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZEh31EKBmURMKxDxI+H3EA

__PACKAGE__->belongs_to(
    "borrower",
    "Koha::Schema::Result::Borrower",
    { borrowernumber => "borrowernumber" },
    { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
);

__PACKAGE__->belongs_to(
  "item",
  "Koha::Schema::Result::Item",
  { itemnumber => "itemnumber" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

__PACKAGE__->belongs_to(
  "branch",
  "Koha::Schema::Result::Branch",
  { branchcode => "branchcode" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

1;




#!/usr/bin/perl

# Copyright 2014 ByWater Solutions
#
# 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 Modern::Perl;

use CGI;
use JSON qw(to_json);

use C4::Circulation;
use C4::Items qw(GetBarcodeFromItemnumber);
use C4::Context;
use C4::Auth qw(check_cookie_auth);

use Koha::DateUtils qw(output_pref_due);

my $input = new CGI;

my ( $auth_status, $sessionID ) =
  check_cookie_auth( $input->cookie('CGISESSID'),
    { circulate => 'circulate_remaining_permissions' } );

if ( $auth_status ne "ok" ) {
    exit 0;
}

binmode STDOUT, ":encoding(UTF-8)";
print $input->header( -type => 'text/plain', -charset => 'UTF-8' );

my $itemnumber     = $input->param('itemnumber');
my $borrowernumber = $input->param('borrowernumber');
my $override_limit = $input->param('override_limit');
my $exempt_fine    = $input->param('exempt_fine');
my $branchcode     = $input->param('branchcode')
  || C4::Context->userenv->{'branch'};

my $barcode = GetBarcodeFromItemnumber($itemnumber);

my $data;
$data->{itemnumber}     = $itemnumber;
$data->{borrowernumber} = $borrowernumber;
$data->{branchcode}     = $branchcode;

if ( C4::Context->preference("InProcessingToShelvingCart") ) {
    my $item = GetItem($itemnumber);
    if ( $item->{'location'} eq 'PROC' ) {
        $item->{'location'} = 'CART';
        ModItem( $item, $item->{'biblionumber'}, $item->{'itemnumber'} );
    }
}

if ( C4::Context->preference("ReturnToShelvingCart") ) {
    my $item = GetItem($itemnumber);
    $item->{'location'} = 'CART';
    ModItem( $item, $item->{'biblionumber'}, $item->{'itemnumber'} );
}

( $data->{returned} ) = AddReturn( $barcode, $branchcode, $exempt_fine );

print to_json($data);




#!/usr/bin/perl

# This software is placed under the gnu General Public License, v2 (http://www.gnu.org/licenses/gpl.html)

# Copyright 2014 ByWater Solutions
#
# 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 3 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 Modern::Perl;

use CGI;
use JSON qw(to_json);

use C4::Auth qw(check_cookie_auth);
use C4::Biblio qw(GetMarcBiblio GetFrameworkCode GetRecordValue );
use C4::Charset;
use C4::Circulation qw(GetIssuingCharges CanBookBeRenewed GetRenewCount);
use C4::Context;

use Koha::Database;
use Koha::DateUtils;

my $input = new CGI;

my ( $auth_status, $sessionID ) =
  check_cookie_auth( $input->cookie('CGISESSID'),
    { circulate => 'circulate_remaining_permissions' } );

if ( $auth_status ne "ok" ) {
    exit 0;
}

my $schema = Koha::Database->new()->schema();

my @sort_columns = qw/date_due title itype issuedate branchcode itemcallnumber/;

my @borrowernumber    = $input->param('borrowernumber');
my $offset            = $input->param('iDisplayStart');
my $results_per_page  = $input->param('iDisplayLength');
my $sorting_column    = $sort_columns[ $input->param('iSortCol_0') ] || 'issuedate';
my $sorting_direction = $input->param('sSortDir_0') || 'desc';

$results_per_page = undef if ( $results_per_page == -1 );

binmode STDOUT, ":encoding(UTF-8)";
print $input->header( -type => 'text/plain', -charset => 'UTF-8' );

my $checkouts_rs = $schema->resultset('Issue')->search(
    { borrowernumber => \@borrowernumber },
    {
        prefetch => { 'item'                => 'biblio' },
        order_by => { "-$sorting_direction" => $sorting_column }
    }
);

my $borrower;
my @checkouts;
while ( my $c = $checkouts_rs->next() ) {

    # No point in fetching this every time if only one borrower
    $borrower = $c->borrower()
      if ( !$borrower || @borrowernumber > 1 );

    my $borrowernumber = $borrower->borrowernumber();
    my $itemnumber     = $c->item()->itemnumber();
    my $biblionumber   = $c->item()->biblionumber();

    my ($charge) =
      GetIssuingCharges( $c->itemnumber()->itemnumber(), $borrowernumber );

    my ( $can_renew, $can_renew_error ) =
      CanBookBeRenewed( $borrowernumber, $itemnumber );

    my ( $renewals_count, $renewals_allowed, $renewals_remaining ) =
      GetRenewCount( $borrowernumber, $itemnumber );

    push(
        @checkouts,
        {
            DT_RowId           => "$itemnumber-$borrowernumber",
            title              => $c->item()->biblio()->title(),
            author             => $c->item()->biblio()->author(),
            barcode            => $c->item()->barcode(),
            itemtype           => $c->item()->effective_itemtype(),
            itemnotes          => $c->item()->itemnotes(),
            branchcode         => $c->branchcode(),
            branchname         => $c->branch->branchname(),
            itemcallnumber     => $c->item()->itemcallnumber() || q{},
            charge             => $charge,
            price              => $c->item->replacementprice() || q{},
            can_renew          => $can_renew,
            can_renew_error    => $can_renew_error,
            itemnumber         => $itemnumber,
            borrowernumber     => $borrowernumber,
            biblionumber       => $biblionumber,
            issuedate          => $c->issuedate(),
            date_due           => $c->date_due(),
            renewals_count     => $renewals_count,
            renewals_allowed   => $renewals_allowed,
            renewals_remaining => $renewals_remaining,
            issuedate_formatted =>
              output_pref( dt_from_string( $c->issuedate() ) ),
            date_due_formatted =>
              output_pref_due( dt_from_string( $c->date_due() ) ),
            subtitle => GetRecordValue(
                'subtitle', GetMarcBiblio($biblionumber),
                GetFrameworkCode($biblionumber)
            ),
            borrower => {
                surname    => $borrower->surname(),
                firstname  => $borrower->firstname(),
                cardnumber => $borrower->cardnumber(),
            }
        }
    );
}

my $data;
$data->{'iTotalRecords'}        = scalar @checkouts;                 #FIXME
$data->{'iTotalDisplayRecords'} = scalar @checkouts;
$data->{'sEcho'}                = $input->param('sEcho') || undef;
$data->{'aaData'}               = \@checkouts;

print to_json($data);




#!/usr/bin/perl

# Copyright 2014 ByWater Solutions
#
# 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 Modern::Perl;

use CGI;
use JSON qw(to_json);

use C4::Circulation;
use C4::Context;
use C4::Auth qw(check_cookie_auth);

use Koha::DateUtils qw(output_pref_due dt_from_string);

my $input = new CGI;

my ( $auth_status, $sessionID ) =
  check_cookie_auth( $input->cookie('CGISESSID'),
    { circulate => 'circulate_remaining_permissions' } );

if ( $auth_status ne "ok" ) {
    exit 0;
}

binmode STDOUT, ":encoding(UTF-8)";
print $input->header( -type => 'text/plain', -charset => 'UTF-8' );

my $itemnumber     = $input->param('itemnumber');
my $borrowernumber = $input->param('borrowernumber');
my $override_limit = $input->param('override_limit');
my $branchcode     = $input->param('branchcode')
  || C4::Context->userenv->{'branch'};
my $date_due;
if ( $input->param('date_due') ) {
    $date_due = dt_from_string( $input->param('date_due') );
    $date_due->set_hour(23);
    $date_due->set_minute(59);
}

my $data;
$data->{itemnumber} = $itemnumber;
$data->{borrowernumber} = $borrowernumber;
$data->{branchcode} = $branchcode;

( $data->{renew_okay}, $data->{error} ) =
  CanBookBeRenewed( $borrowernumber, $itemnumber, $override_limit );

if ( $data->{renew_okay} ) {
    $date_due = AddRenewal( $borrowernumber, $itemnumber, $branchcode, $date_due );
    $data->{date_due} = output_pref_due( $date_due );
}

print to_json($data);




use C4::Members::Attributes qw(GetBorrowerAttributes);
use Koha::Borrower::Debarments qw(GetDebarments);
use Koha::DateUtils;
use Koha::Database;

use Date::Calc qw(
  Today


my $branches = GetBranches();

my @failedrenews = $query->param('failedrenew');    # expected to be itemnumbers 
our %renew_failed = ();
for (@failedrenews) { $renew_failed{$_} = 1; }

my @failedreturns = $query->param('failedreturn');
our %return_failed = ();
for (@failedreturns) { $return_failed{$_} = 1; }

my $findborrower = $query->param('findborrower') || q{};
$findborrower =~ s|,| |g;
my $borrowernumber = $query->param('borrowernumber');

        }
    }
    
    my ( $od, $issue, $fines ) = GetMemberIssuesAndFines($borrowernumber);
    $template->param( issuecount => $issue );
    $template->param( issuecount   => $issue );
}

# reload the borrower info for the sake of reseting the flags.....

    $template->param( adultborrower => 1 ) if ( $borrower->{'category_type'} eq 'A' );
}

# make the issued books table.
my $todaysissues = '';
my $previssues   = '';
our @todaysissues   = ();
our @previousissues = ();
our @relissues      = ();
our @relprevissues  = ();
my $displayrelissues;

our $totalprice = 0;

sub build_issue_data {
    my $issueslist = shift;
    my $relatives = shift;

    # split in 2 arrays for today & previous
    foreach my $it ( @$issueslist ) {
        my $itemtypeinfo = getitemtypeinfo( (C4::Context->preference('item-level_itypes')) ? $it->{'itype'} : $it->{'itemtype'} );

        # set itemtype per item-level_itype syspref - FIXME this is an ugly hack
        $it->{'itemtype'} = ( C4::Context->preference( 'item-level_itypes' ) ) ? $it->{'itype'} : $it->{'itemtype'};

        ($it->{'charge'}, $it->{'itemtype_charge'}) = GetIssuingCharges(
            $it->{'itemnumber'}, $it->{'borrowernumber'}
        );
        $it->{'charge'} = sprintf("%.2f", $it->{'charge'});
        my ($can_renew, $can_renew_error) = CanBookBeRenewed( 
            $it->{'borrowernumber'},$it->{'itemnumber'}
        );
        $it->{"renew_error_${can_renew_error}"} = 1 if defined $can_renew_error;
        my $restype = C4::Reserves::GetReserveStatus( $it->{'itemnumber'} );
        $it->{'can_renew'} = $can_renew;
        $it->{'can_confirm'} = !$can_renew && !$restype;
        $it->{'renew_error'} = ( $restype eq "Waiting" or $restype eq "Reserved" ) ? 1 : 0;
        $it->{'checkoutdate'} = C4::Dates->new($it->{'issuedate'},'iso')->output('syspref');
        $it->{'issuingbranchname'} = GetBranchName($it->{'branchcode'});

        $totalprice += $it->{'replacementprice'} || 0;
        $it->{'itemtype'} = $itemtypeinfo->{'description'};
        $it->{'itemtype_image'} = $itemtypeinfo->{'imageurl'};
        $it->{'dd_sort'} = $it->{'date_due'};
        $it->{'dd'} = output_pref($it->{'date_due'});
        $it->{'displaydate_sort'} = $it->{'issuedate'};
        $it->{'displaydate'} = output_pref($it->{'issuedate'});
        #$it->{'od'} = ( $it->{'date_due'} lt $todaysdate ) ? 1 : 0 ;
        $it->{'od'} = $it->{'overdue'};
        $it->{'subtitle'} = GetRecordValue('subtitle', GetMarcBiblio($it->{biblionumber}), GetFrameworkCode($it->{biblionumber}));
        $it->{'renew_failed'} = $renew_failed{$it->{'itemnumber'}};
        $it->{'return_failed'} = $return_failed{$it->{'barcode'}};

        if ( ( $it->{'issuedate'} && $it->{'issuedate'} gt $todaysdate )
          || ( $it->{'lastreneweddate'} && $it->{'lastreneweddate'} gt $todaysdate ) ) {
            (!$relatives) ? push @todaysissues, $it : push @relissues, $it;
        } else {
            (!$relatives) ? push @previousissues, $it : push @relprevissues, $it;
        }
        ($it->{'renewcount'},$it->{'renewsallowed'},$it->{'renewsleft'}) = C4::Circulation::GetRenewCount($it->{'borrowernumber'},$it->{'itemnumber'}); #Add renewal count to item data display
    }
}

if ($borrower) {

    # Getting borrower relatives
    my @relborrowernumbers = GetMemberRelatives($borrower->{'borrowernumber'});
    #push @borrowernumbers, $borrower->{'borrowernumber'};

    # get each issue of the borrower & separate them in todayissues & previous issues
    my $issueslist = GetPendingIssues($borrower->{'borrowernumber'});
    my $relissueslist = [];
    if ( @relborrowernumbers ) {
        $relissueslist = GetPendingIssues(@relborrowernumbers);
    }

    build_issue_data($issueslist, 0);
    build_issue_data($relissueslist, 1);
  
    $displayrelissues = scalar($relissueslist);

    if ( C4::Context->preference( "todaysIssuesDefaultSortOrder" ) eq 'asc' ) {
        @todaysissues   = sort { $a->{'timestamp'} cmp $b->{'timestamp'} } @todaysissues;
    }
    else {
        @todaysissues   = sort { $b->{'timestamp'} cmp $a->{'timestamp'} } @todaysissues;
    }

    if ( C4::Context->preference( "previousIssuesDefaultSortOrder" ) eq 'asc' ){
        @previousissues = sort { $a->{'date_due'} cmp $b->{'date_due'} } @previousissues;
    }
    else {
        @previousissues = sort { $b->{'date_due'} cmp $a->{'date_due'} } @previousissues;
    }
}


my @values;
my %labels;
my $CGIselectborrower;

    );
}

my @relatives = GetMemberRelatives( $borrower->{'borrowernumber'} );
my $relatives_issues_count =
  Koha::Database->new()->schema()->resultset('Issue')
  ->count( { borrowernumber => \@relatives } );

$template->param(
    lib_messages_loop => $lib_messages_loop,
    bor_messages_loop => $bor_messages_loop,

    duedatespec       => $duedatespec,
    message           => $message,
    CGIselectborrower => $CGIselectborrower,
    totalprice        => sprintf('%.2f', $totalprice),
    totaldue          => sprintf('%.2f', $total),
    todayissues       => \@todaysissues,
    previssues        => \@previousissues,
    relissues			=> \@relissues,
    relprevissues		=> \@relprevissues,
    displayrelissues		=> $displayrelissues,
    inprocess         => $inprocess,
    memberofinstution => $member_of_institution,
    CGIorganisations  => $CGIorganisations,

    SuspendHoldsIntranet => C4::Context->preference('SuspendHoldsIntranet'),
    AutoResumeSuspendedHolds => C4::Context->preference('AutoResumeSuspendedHolds'),
    RoutingSerials => C4::Context->preference('RoutingSerials'),
    relatives_issues_count => $relatives_issues_count,
    relatives_borrowernumbers => \@relatives,
);

# save stickyduedate to session

Lines 270-276 tr.even td, tr.even.highlight td { Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css (-1 / +1 lines)
270	border-right : 1px solid #BCBCBC;	270	border-right : 1px solid #BCBCBC;
271	}	271	}
272		272
273	td.od {	273	.overdue td.od {
274	color : #cc0000;	274	color : #cc0000;
275	font-weight : bold;	275	font-weight : bold;
276	}	276	}




$(document).ready(function() {
    var ymd = $.datepicker.formatDate('yy-mm-dd', new Date());

    $("#issues-table").dataTable({
        "sDom": "<'row-fluid'<'span6'><'span6'>r>t<'row-fluid'>t",
        "aaSorting": [],
        "aoColumns": [
            {
                "mDataProp": function( oObj ) {
                    var today = new Date();
                    var due = new Date( oObj.date_due );
                    if ( today > due ) {
                        return "<span class='overdue'>" + oObj.date_due_formatted + "</span>";
                    } else {
                        return oObj.date_due_formatted;
                    }
                }
            },
            {
                "mDataProp": function ( oObj ) {
                    title = "<a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
                          + oObj.biblionumber
                          + "'>"
                          + oObj.title;

                    $.each(oObj.subtitle, function( index, value ) {
                              title += " " + value.subfield;
                    });

                    title += "</a>";

                    if ( oObj.author ) {
                        title += " " + _("by") + " " + oObj.author;
                    }

                    if ( oObj.itemnotes ) {
                        var span_class = "";
                        if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
                            span_class = "circ-hlt";
                        }
                        title += " - <span class='" + span_class + "'>" + oObj.itemnotes + "</span>"
                    }

                    title += " "
                          + "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
                          + oObj.biblionumber
                          + "&itemnumber="
                          + oObj.itemnumber
                          + "#"
                          + oObj.itemnumber
                          + "'>"
                          + oObj.barcode
                          + "</a>";

                    return title;
                }
            },
            { "mDataProp": "itemtype" },
            { "mDataProp": "issuedate" },
            { "mDataProp": "branchname" },
            { "mDataProp": "itemcallnumber" },
            {
                "bSortable": false,
                "mDataProp": function ( oObj ) {
                    return parseFloat(oObj.charge).toFixed(2);
                }
            },
            {
                "bSortable": false,
                "mDataProp": "price" },
            {
                "bSortable": false,
                "mDataProp": function ( oObj ) {
                    var content = "";
                    var span_style = "";
                    var span_class = "";

                    content += "<span style='padding: 0 1em;'>" + oObj.renewals_count + "</span>";

                    if ( oObj.can_renew ) {
                        // Do nothing
                    } else if ( oObj.can_renew_error == "on_reserve" ) {
                        content += "<span class='renewals-disabled'>"
                                + "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + _("On hold") + "</a>"
                                + "</span>";

                        span_style = "display: none";
                        span_class = "renewals-allowed";
                    } else if ( oObj.can_renew_error == "too_many" ) {
                        content += "<span class='renewals-disabled'>"
                                + _("Not renewable")
                                + "</span>";

                        span_style = "display: none";
                        span_class = "renewals-allowed";
                    } else {
                        content += "<span class='renewals-disabled'>"
                                + oObj.can_renew_error
                                + "</span>";

                        span_style = "display: none";
                        span_class = "renewals-allowed";
                    }

                    content += "<span class='" + span_class + "' style='" + span_style + "'>"
                            +  "<input type='checkbox' class='renew' id='renew_" + oObj.itemnumber + "' name='renew' value='" + oObj.itemnumber +"'/>"
                            +  "</span>";

                    if ( oObj.renewals_remaining ) {
                        content += "<span class='renewals'>("
                                + oObj.renewals_remaining
                                + " " + _("of") + " "
                                + oObj.renewals_allowed + " "
                                + _("renewals remaining") + ")</span>"
                    }


                    return content;
                }
            },
            {
                "bSortable": false,
                "mDataProp": function ( oObj ) {
                    if ( oObj.can_renew_error == "on_reserve" ) {
                        return "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + _("On hold") + "</a>";
                    } else {
                        return "<input type='checkbox' class='checkin' id='checkin_" + oObj.itemnumber + "' name='checkin' value='" + oObj.itemnumber +"'></input>";
                    }
                }
            },
            {
                "bVisible": exports_enabled ? true : false,
                "bSortable": false,
                "mDataProp": function ( oObj ) {
                    return "<input type='checkbox' class='export' id='export_" + oObj.biblionumber + "' name='biblionumbers' value='" + oObj.biblionumber + "' />";
                }
            }
        ],
        "fnFooterCallback": function ( nRow, aaData, iStart, iEnd, aiDisplay ) {
            var total_charge = 0;
            var total_price = 0;
            for ( var i=0; i < aaData.length; i++ ) {
                total_charge += aaData[i]['charge'] * 1;
                total_price  += aaData[i]['price'] * 1;
            }
            var nCells = nRow.getElementsByTagName('td');
            nCells[1].innerHTML = total_charge.toFixed(2);
            nCells[2].innerHTML = total_price.toFixed(2);
        },
        "bPaginate": false,
        "bProcessing": true,
        "bServerSide": true,
        "sAjaxSource": '/cgi-bin/koha/api/checkouts.pl',
        "fnServerData": function ( sSource, aoData, fnCallback ) {
            aoData.push( { "name": "borrowernumber", "value": borrowernumber } );

            $.getJSON( sSource, aoData, function (json) {
                fnCallback(json)
            } );
        },
    });

    // Don't load relatives' issues table unless it is clicked on
    var relativesIssuesTable;
    $("#relatives-issues-tab").click( function() {
        if ( ! relativesIssuesTable ) {
            relativesIssuesTable = $("#relatives-issues-table").dataTable({
                "sDom": "<'row-fluid'<'span6'><'span6'>r>t<'row-fluid'>t",
                "aaSorting": [],
                "aoColumns": [
                    {
                        "mDataProp": function( oObj ) {
                            var today = new Date();
                            var due = new Date( oObj.date_due );
                            if ( today > due ) {
                                return "<span class='overdue'>" + oObj.date_due_formatted + "</span>";
                            } else {
                                return oObj.date_due_formatted;
                            }
                        }
                    },
                    {
                        "mDataProp": function ( oObj ) {
                            title = "<a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
                                  + oObj.biblionumber
                                  + "'>"
                                  + oObj.title;

                            $.each(oObj.subtitle, function( index, value ) {
                                      title += " " + value.subfield;
                            });

                            title += "</a>";

                            if ( oObj.author ) {
                                title += " " + _("by") + " " + oObj.author;
                            }

                            if ( oObj.itemnotes ) {
                                var span_class = "";
                                if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
                                    span_class = "circ-hlt";
                                }
                                title += " - <span class='" + span_class + "'>" + oObj.itemnotes + "</span>"
                            }

                            title += " "
                                  + "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
                                  + oObj.biblionumber
                                  + "&itemnumber="
                                  + oObj.itemnumber
                                  + "#"
                                  + oObj.itemnumber
                                  + "'>"
                                  + oObj.barcode
                                  + "</a>";

                            return title;
                        }
                    },
                    { "mDataProp": "itemtype" },
                    { "mDataProp": "issuedate" },
                    { "mDataProp": "branchname" },
                    { "mDataProp": "itemcallnumber" },
                    { "mDataProp": "charge" },
                    { "mDataProp": "price" },
                    {
                        "mDataProp": function( oObj ) {
                            return "<a href='/cgi-bin/koha/members/moremember.pl?borrowernumber=" + oObj.borrowernumber + "'>"
                                 + oObj.borrower.firstname + " " + oObj.borrower.surname + " (" + oObj.borrower.cardnumber + ")</a>"
                        }
                    },
                ],
                "bPaginate": false,
                "bProcessing": true,
                "bServerSide": true,
                "sAjaxSource": '/cgi-bin/koha/api/checkouts.pl',
                "fnServerData": function ( sSource, aoData, fnCallback ) {
                    $.each(relatives_borrowernumbers, function( index, value ) {
                        aoData.push( { "name": "borrowernumber", "value": value } );
                    });

                    $.getJSON( sSource, aoData, function (json) {
                        fnCallback(json)
                    } );
                },
            });
        }
    });

    $("#issues-table").on("sort",function() {
        $("#previous").hide();  // Don't want to see "previous checkouts" header sorted with other rows
    });
    $("#relatives-issues-table").on("sort",function() {
        $("#relprevious").hide();  // Don't want to see "previous checkouts" header sorted with other rows
    });

    if ( AllowRenewalLimitOverride ) {
        $( '#override_limit' ).click( function () {
            if ( this.checked ) {
                $( '.renewals-allowed' ).show(); $( '.renewals-disabled' ).hide();
            } else {
                $( '.renewals-allowed' ).hide(); $( '.renewals-disabled' ).show();
            }
        } ).attr( 'checked', false );
    }
 });




$(document).ready(function() {
    // Handle the select all/none links for checkouts table columns
    $("#CheckAllRenewals").on("click",function(){
        $("#UncheckAllCheckins").click();
        $(".renew:visible").attr("checked", "checked" );
        return false;
    });
    $("#CheckAllitems").on("click",function(){
        allcheckboxes.checkCheckboxes(":input[name*=items]");
        allcheckboxes.unCheckCheckboxes(":input[name*=barcodes]"); return false;
    });
    $("#UncheckAllRenewals").on("click",function(){
        $(".renew:visible").removeAttr("checked");
        return false;
    });

    $("#CheckAllCheckins").on("click",function(){
        $("#UncheckAllRenewals").click();
        $(".checkin:visible").attr("checked", "checked" );
        return false;
    });
    $("#UncheckAllCheckins").on("click",function(){
        $(".checkin:visible").removeAttr("checked");
        return false;
    });

    $("#CheckAllExports").on("click",function(){
        $(".export:visible").attr("checked", "checked" );
        return false;
    });
    $("#UncheckAllExports").on("click",function(){
        $(".export:visible").removeAttr("checked");
        return false;
    });

    // Don't allow both return and renew checkboxes to be checked
    $(document).on("change", '.renew', function(){
        if ( $(this).is(":checked") ) {
            $( "#checkin_" + $(this).val() ).removeAttr("checked");
        }
        allcheckboxes.checkCheckboxes(":input[name*=items]");
        allcheckboxes.unCheckCheckboxes(":input[name*=barcodes]"); return false;
    });
    $(document).on("change", '.checkin', function(){
        if ( $(this).is(":checked") ) {
            $( "#renew_" + $(this).val() ).removeAttr("checked");
        }
    });

    // Handle renewals
    $("#RenewCheckinChecked").on("click",function(){
        $(".checkin:checked:visible").each(function() {
            itemnumber = $(this).val();

            $(this).replaceWith("<img id='checkin_" + itemnumber + "' src='" + interface + "/" + theme + "/img/loading-small.gif' />");

            params = {
                itemnumber:     itemnumber,
                borrowernumber: borrowernumber,
                branchcode:     branchcode,
                exempt_fine:    $("#exemptfine").is(':checked')
            };

            $.post( "/cgi-bin/koha/api/checkin.pl", params, function( data ) {
                id = "#checkin_" + data.itemnumber;

                content = "";
                if ( data.returned ) {
                    content = _("Returned");
                } else {
                    content = _("Unable to return");
                }

                $(id).replaceWith( content );
            }, "json")
        });

        $(".renew:checked:visible").each(function() {
            var override_limit = $("#override_limit").is(':checked') ? 1 : 0;

            var itemnumber = $(this).val();

            $(this).replaceWith("<img id='renew_" + itemnumber + "' src='" + interface + "/" + theme + "/img/loading-small.gif' />");

            var params = {
                itemnumber:     itemnumber,
                borrowernumber: borrowernumber,
                branchcode:     branchcode,
                override_limit: override_limit,
                date_due:       $("#newduedate").val()
            };

            $.post( "/cgi-bin/koha/api/renew.pl", params, function( data ) {
                var id = "#renew_" + data.itemnumber;

                var content = "";
                if ( data.renew_okay ) {
                    content = _("Renewed, due: ") + data.date_due;
                } else {
                    content = _("Renew failed: ");
                    if ( data.error == "no_checkout" ) {
                        content += _("not checked out");
                    } else if ( data.error == "too_many" ) {
                        content += _("too many renewals");
                    } else if ( data.error == "on_reserve" ) {
                        content += _("on reserve");
                    } else if ( data.error ) {
                        content += data.error;
                    } else {
                        content += _("reason unknown");
                    }
                }

                $(id).replaceWith( content );
            }, "json")
        });

        // Prevent form submit
        return false;
    });

    $("#RenewAll").on("click",function(){
        $("#CheckAllRenewals").click();
        $("#UncheckAllCheckins").click();
        $("#RenewCheckinChecked").click();

        // Prevent form submit
        return false;
    });

    $('#patronlists').tabs();

    $("#messages ul").after("<a href=\"#\" id=\"addmessage\">"+MSG_ADD_MESSAGE+"</a>");

    $("#borrower_messages .cancel").on("click",function(){
        $("#add_message_form").hide();
        $("#addmessage").show();
    });

    $("#addmessage").on("click",function(){
        $(this).hide();
        $("#add_message_form").show();

        export_checkouts(export_format);
        return false;
    });

    // Clicking the table cell checks the checkbox inside it
    $(document).on("click", 'td', function(e){
        if(e.target.tagName.toLowerCase() == 'td'){
          $(this).find("input:checkbox:visible").each( function() {
            $(this).click();

    } else if (format == 'iso2709') {
        $("#dont_export_item").val(1);
    }

    document.getElementById("export_format").value = format;
    document.issues.submit();

    /* Reset form action to its initial value */
    document.issues.action="/cgi-bin/koha/reserve/renewscript.pl";

}

function validate1(date) {




</title>
[% INCLUDE 'doc-head-close.inc' %]
[% INCLUDE 'calendar.inc' %]
<link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" />
<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.dataTables.min.js"></script>
[% INCLUDE 'datatables-strings.inc' %]
<!-- <script type="text/javascript" src="[% themelang %]/js/datatables.js"></script> -->
<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.checkboxes.min.js"></script>
<script type="text/javascript" src="[% interface %]/lib/jquery/plugins/jquery-ui-timepicker-addon.min.js"></script>
[% INCLUDE 'timepicker.inc' %]
<script type="text/javascript" src="[% themelang %]/js/pages/circulation.js"></script>
<script type="text/javascript" src="[% themelang %]/js/checkouts.js"></script>
<script type="text/javascript">
//<![CDATA[
/* Set some variable needed in circulation.js */
var interface = "[% interface %]";
var theme = "[% theme %]";
var borrowernumber = "[% borrowernumber %]";
var branchcode = "[% branch %]";
var exports_enabled = "[% exports_enabled %]";
var AllowRenewalLimitOverride = [% CAN_user_circulate_override_renewals && AllowRenewalLimitOverride %];
var relatives_borrowernumbers = new Array();
[% FOREACH b IN relatives_borrowernumbers %]
    relatives_borrowernumbers.push("[% b %]");
[% END %]

var MSG_ADD_MESSAGE = _("Add a new message");
var MSG_EXPORT_SELECT_CHECKOUTS = _("You must select checkout(s) to export");
[% IF ( UseTablesortForCirc && dateformat == 'metric' ) %]dt_add_type_uk_date();[% END %]
[% IF ( borrowernumber ) %]if($.cookie("holdfor") != [% borrowernumber %]){ $.cookie("holdfor",null, { path: "/", expires: 0 }); }[% ELSE %]$.cookie("holdfor",null, { path: "/", expires: 0 });[% END %]
[% UNLESS ( borrowernumber ) %][% UNLESS ( CGIselectborrower ) %]window.onload=function(){ $('#findborrower').focus(); };[% END %][% END %]

$(document).ready(function() {
    [% IF !( CircAutoPrintQuickSlip == 'clear' ) %]
            // http://www.datatables.net/examples/api/tabs_and_scrolling.html
            "show": function(event, ui) {
                var oTable = $('div.dataTables_wrapper>table', ui.panel).dataTable();
                if ( oTable.length > 0 ) {
                    oTable.fnAdjustColumnSizing();
                }
            }
        }[% END %]);
        [% IF ( UseTablesortForCirc ) %]
        $("#issuest").dataTable($.extend(true, {}, dataTablesDefaults, {
            "sDom": 't',
            "aaSorting": [],
            "aoColumnDefs": [
                { "aTargets": [ -1, -2[% IF ( exports_enabled ) %], -3[% END %] ], "bSortable": false, "bSearchable": false }
            ],
            "aoColumns": [
                { "sType": "title-string" },{ "sType": "html" },null,{ "sType": "title-string" },null,null,null,null,null,null[% IF ( exports_enabled ) %],null[% END %]
            ],
            "bPaginate": false
        }));

        $("#relissuest").dataTable($.extend(true, {}, dataTablesDefaults, {
            "sDom": 't',
            "aaSorting": [],
            "aoColumns": [
                { "sType": "title-string" },{ "sType": "html" },null,{ "sType": "title-string" },null,null,null,null,{ "sType": "html" }
            ],
            "bPaginate": false
        }));

        $("#issuest").on("sort",function() {
            $("#previous").hide();  // Don't want to see "previous checkouts" header sorted with other rows
        });
        $("#relissuest").on("sort",function() {
            $("#relprevious").hide();  // Don't want to see "previous checkouts" header sorted with other rows
        });
        [% END %]
        [% IF ( AllowRenewalLimitOverride ) %]
        $( '#override_limit' ).click( function () {
            if ( this.checked ) {
                $( '.renewals-allowed' ).show(); $( '.renewals-disabled' ).hide();
            } else {
                $( '.renewals-allowed' ).hide(); $( '.renewals-disabled' ).show();
            }
        } ).attr( 'checked', false );
        [% END %][% IF !( CircAutoPrintQuickSlip == 'clear' ) %]
        // listen submit to trigger qslip on empty checkout
        $('#mainform').bind('submit',function() {
            if ($('#barcode').val() == '') {
                return printx_window( '[% CircAutoPrintQuickSlip %]' );
            }
        });
    [% IF ( CAN_user_circulate_override_renewals ) %]
    [% IF ( AllowRenewalLimitOverride ) %]
    $( '#override_limit' ).click( function () {
        if ( this.checked ) {
           $( '.renewals-allowed' ).show(); $( '.renewals-disabled' ).hide();
        } else {
           $( '.renewals-allowed' ).hide(); $( '.renewals-disabled' ).show();
        }
    } ).attr( 'checked', false );
    [% END %]
    [% END %]
});
//]]>
</script>
</head>

    [% ELSE %]
	    <input type="text" name="barcode" id="barcode" class="barcode focus" size="14" />
    [% END %]
    <button type="submit" class="btn"><i class="icon-barcode"></i> Check out</button>

    [% IF ( SpecifyDueDate ) %]<div class="date-select">
        <div class="hint">Specify due date [% INCLUDE 'date-format.inc' %]: </div>

[% ELSE %]
<input type="checkbox" id="stickyduedate" onclick="this.form.barcode.focus();" name="stickyduedate" />
[% END %]
          <button class="btn btn-small action" id="cleardate" name="cleardate" onclick="this.checked = false; this.form.duedatespec.value = ''; this.form.stickyduedate.checked = false; this.form.barcode.focus(); return false;" ><i class="icon-remove-circle"></i> Clear</button>
</div>[% END %]
          <input type="hidden" name="borrowernumber" id="borrowernumber" value="[% borrowernumber %]" />
          <input type="hidden" name="branch" value="[% branch %]" />

<div class="yui-g"><div id="patronlists" class="toptabs">

<ul>
    <li>
        [% IF ( issuecount ) %]
            <a href="#checkouts">[% issuecount %] Checkout(s)</a>
        [% ELSE %]
            <a href="#checkouts">0 Checkouts</a>
        [% END %]
    </li>

    [% IF relatives_issues_count %]
        <li><a id="relatives-issues-tab" href="#relatives-issues">Relatives' checkouts</a></li>
    [% END %]

    <li>
        [% IF ( countreserv ) %]
            <a href="#reserves">[% countreserv %] Hold(s)</a>
        [% ELSE %]
            <a href="#reserves">0 Holds</a>
        [% END %]
    </li>

    <li><a id="debarments-tab-link" href="#reldebarments">[% debarments.size %] Restrictions</a></li>
</ul>

<!-- SUMMARY : TODAY & PREVIOUS ISSUES -->
<div id="checkouts">
[% IF ( issuecount ) %]
    <form name="issues" action="/cgi-bin/koha/tools/export.pl" method="post" class="checkboxed">
        <table id="issues-table">
            <thead>
                <tr>
                    <th scope="col">Due date</th>
                    <th scope="col">Title</th>
                    <th scope="col">Item type</th>
                    <th scope="col">Checked out on</th>
                    <th scope="col">Checked out from</th>
                    <th scope="col">Call no</th>
                    <th scope="col">Charge</th>
                    <th scope="col">Price</th>
                    <th scope="col">Renew <p class="column-tool"><a href="#" id="CheckAllRenewals">select all</a> | <a href="#" id="UncheckAllRenewals">none</a></p></th>
                    <th scope="col">Check in <p class="column-tool"><a href="#" id="CheckAllCheckins">select all</a> | <a href="#" id="UncheckAllCheckins">none</a></p></th>
                    <th scope="col">Export <p class="column-tool"><a href="#" id="CheckAllExports">select all</a> | <a href="#" id="UncheckAllExports">none</a></p></th>
                </tr>
            </thead>
            [% INCLUDE 'checkouts-table-footer.inc' %]
        </table>

        [% IF ( issuecount ) %]
            <fieldset class="action">
                [% IF ( CAN_user_circulate_override_renewals ) %]
                    [% IF ( AllowRenewalLimitOverride ) %]
                        <label for="override_limit">Override renewal limit:</label>
                        <input type="checkbox" name="override_limit" id="override_limit" value="1" />
                    [% END %]
    <tr>
    [% ELSE %]
    <tr class="highlight">
    [% END %]
        [% IF ( todayissue.od ) %]<td class="od">[% ELSE %]<td>[% END %]
        <span title="[% todayissue.dd_sort %]">[% todayissue.dd %]</span>

            [% IF ( todayissue.itemlost ) %]
                <span class="lost">[% AuthorisedValues.GetByCode( 'LOST', todayissue.itemlost ) %]</span>
            [% END %]
            [% IF ( todayissue.damaged ) %]
                <span class="dmg">[% AuthorisedValues.GetByCode( 'DAMAGED', todayissue.damaged ) %]</span>
            [% END %]
        </td>
        <td><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% todayissue.biblionumber %]&amp;type=intra"><strong>[% todayissue.title |html %][% FOREACH subtitl IN todayissue.subtitle %] [% subtitl.subfield %][% END %]</strong></a>[% IF ( todayissue.author ) %], by [% todayissue.author %][% END %][% IF ( todayissue.itemnotes ) %]- <span class="circ-hlt">[% todayissue.itemnotes %]</span>[% END %] <a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% todayissue.biblionumber %]&amp;itemnumber=[% todayissue.itemnumber %]#item[% todayissue.itemnumber %]">[% todayissue.barcode %]</a></td>
        <td>[% UNLESS ( noItemTypeImages ) %] [% IF ( todayissue.itemtype_image ) %]<img src="[% todayissue.itemtype_image %]" alt="" />[% END %][% END %][% todayissue.itemtype %]</td>
        <td><span title="[% todayissue.displaydate_sort %]">[% todayissue.checkoutdate %]</span></td>
        [% IF ( todayissue.multiple_borrowers ) %]<td>[% todayissue.firstname %] [% todayissue.surname %]</td>[% END %]
        <td>[% todayissue.issuingbranchname %]</td>
        <td>[% todayissue.itemcallnumber %]</td>
            <td>[% todayissue.charge %]</td>
            <td>[% todayissue.replacementprice %]</td>
      [% IF ( todayissue.renew_failed ) %]
            <td class="problem">Renewal failed</td>
      [% ELSE %]
        <td><span style="padding: 0 1em;">[% IF ( todayissue.renewals ) %][% todayissue.renewals %][% ELSE %]0[% END %]</span>
        [% IF ( todayissue.can_renew ) %]
        <input type="checkbox" name="all_items[]" value="[% todayissue.itemnumber %]" checked="checked" style="display: none;" />
        [% IF ( todayissue.od ) %]
            <input type="checkbox" class="radio" name="items[]" value="[% todayissue.itemnumber %]" checked="checked" />
        [% ELSE %]
            <input type="checkbox" class="radio" name="items[]" value="[% todayissue.itemnumber %]" />
        [% END %]
            [% IF todayissue.renewsallowed && todayissue.renewsleft %]
                <span class="renewals">([% todayissue.renewsleft %] of [% todayissue.renewsallowed %] renewals remaining)</span>
            [% END %]
        [% ELSE %]
            [% IF ( todayissue.can_confirm ) %]<span class="renewals-allowed" style="display: none">
                <input type="checkbox" name="all_items[]" value="[% todayissue.itemnumber %]" checked="checked" style="display: none;" />
                [% IF ( todayissue.od ) %]
                    <input type="checkbox" class="radio" name="items[]" value="[% todayissue.itemnumber %]" checked="checked" />
                [% ELSE %]
                    <input type="checkbox" class="radio" name="items[]" value="[% todayissue.itemnumber %]" />
                [% END %]
                </span>
                [% IF todayissue.renewsallowed && todayissue.renewsleft %]
                    <span class="renewals">([% todayissue.renewsleft %] of [% todayissue.renewsallowed %] renewals remaining)</span>
                [% END %]
                <span class="renewals-disabled">
            [% END %]
		[% IF ( todayissue.renew_error_on_reserve ) %]
            <a href="/cgi-bin/koha/reserve/request.pl?biblionumber=[% todayissue.biblionumber %]">On hold</a>
		[% END %]
                [% IF ( todayissue.renew_error_too_many ) %]
            Not renewable
                [% END %]
                <button class="btn" id="RenewCheckinChecked"><i class="icon-check"></i> Renew or return checked items</button>
                <button class="btn" id="RenewAll"><i class="icon-book"></i> Renew all</button>
            </fieldset>
        [% END %]
        </td>
        [% END %]
        [% IF ( todayissue.return_failed ) %]
            <td class="problem">Checkin failed</td>
        [% ELSE %]
            [% IF ( todayissue.renew_error_on_reserve ) %]
               <td><a href="/cgi-bin/koha/reserve/request.pl?biblionumber=[% todayissue.biblionumber %]">On hold</a>
                <input type="checkbox" name="all_barcodes[]" value="[% todayissue.barcode %]" checked="checked" style="display: none;" />
                </td>
            [% ELSE %]
            <td><input type="checkbox" class="radio" name="barcodes[]"  value="[% todayissue.barcode %]" />
                <input type="checkbox" name="all_barcodes[]" value="[% todayissue.barcode %]" checked="checked" style="display: none;" />
            </td>
            [% END %]
        [% END %]
        [% IF ( exports_enabled ) %]
          <td style="text-align:center;">
            <input type="checkbox" id="export_[% todayissue.biblionumber %]" name="biblionumbers" value="[% todayissue.biblionumber %]" />
            <input type="checkbox" name="itemnumbers" value="[% todayissue.itemnumber %]" style="visibility:hidden;" />
          </td>
        [% END %]
    </tr>
    [% END %] <!-- /loop todayissues -->
    <!-- /if todayissues -->[% END %]

[% IF ( previssues ) %]
    [% UNLESS ( todayissues ) %]
    [% INCLUDE 'checkouts-table-footer.inc' %]
        <tbody>
    [% END %]
    [% IF ( UseTablesortForCirc ) %]<tr id="previous"><th><span title="">Previous checkouts</span></th><th></th><th></th><th><span title=""></span></th><th></th><th></th><th></th><th></th><th></th><th></th>[% IF ( exports_enabled ) %]<th></th>[% END %]</tr>[% ELSE %]<tr id="previous">[% IF ( exports_enabled ) %]<th colspan="11">[% ELSE %]<th colspan="10">[% END %]Previous checkouts</th></tr>[% END %]
    [% FOREACH previssue IN previssues %]
    [% IF ( loop.odd ) %]
        <tr>
    [% ELSE %]
        <tr class="highlight">
    [% END %]
        [% IF ( previssue.od ) %]<td class="od">[% ELSE %]<td>[% END %]
        <span title="[% previssue.dd_sort %]">[% previssue.dd %]</span>

            [% IF ( exports_enabled ) %]
                <fieldset>
                    <label for="export_formats"><b>Export checkouts using format:</b></label>
                    <select name="export_formats" id="export_formats">
                        <option value="iso2709_995">ISO2709 with items</option>
                        <option value="iso2709">ISO2709 without items</option>
                        [% IF ( export_with_csv_profile ) %]
                            <option value="csv">CSV</option>
                        [% END %]
                    </select>

                   <label for="export_remove_fields">Don't export fields:</label> <input type="text" id="export_remove_fields" name="export_remove_fields" value="[% export_remove_fields %]" title="Use for iso2709 exports" />
                    <input type="hidden" name="op" value="export" />
                    <input type="hidden" id="export_format" name="format" value="iso2709" />
                    <input type="hidden" id="dont_export_item" name="dont_export_item" value="0" />
                    <input type="hidden" id="record_type" name="record_type" value="bibs" />
                    <button class="btn btn-small" id="export_submit"><i class="icon-download-alt"></i> Export</button>
                </fieldset>
            <td class="problem">Renewal failed</td>
      [% ELSE %]
        <td><span style="padding: 0 1em;">[% IF ( previssue.renewals ) %][% previssue.renewals %][% ELSE %]0[% END %]</span>
        [% IF ( previssue.can_renew ) %]
        <input type="checkbox" name="all_items[]" value="[% previssue.itemnumber %]" checked="checked" style="display: none;" />
        [% IF ( previssue.od ) %]
            <input type="checkbox" class="radio" name="items[]" value="[% previssue.itemnumber %]" checked="checked" />
        [% ELSE %]
            <input type="checkbox" class="radio" name="items[]" value="[% previssue.itemnumber %]" />
        [% END %]
            [% IF previssue.renewsallowed && previssue.renewsleft %]
                <span class="renewals">([% previssue.renewsleft %] of [% previssue.renewsallowed %] renewals remaining)</span>
            [% END %]
        [% ELSE %]
            [% IF ( previssue.can_confirm ) %]<span class="renewals-allowed" style="display: none">
                <input type="checkbox" name="all_items[]" value="[% previssue.itemnumber %]" checked="checked" style="display: none;" />
                [% IF ( previssue.od ) %]
                    <input type="checkbox" class="radio" name="items[]" value="[% previssue.itemnumber %]" checked="checked" />
                [% ELSE %]
                    <input type="checkbox" class="radio" name="items[]" value="[% previssue.itemnumber %]" />
                [% END %]
                </span>
                [% IF previssue.renewsallowed && previssue.renewsleft %]
                    <span class="renewals">([% previssue.renewsleft %] of [% previssue.renewsallowed %] renewals remaining)</span>
                [% END %]
                <span class="renewals-disabled">
            [% END %]
		[% IF ( previssue.renew_error_on_reserve ) %]
            <a href="/cgi-bin/koha/reserve/request.pl?biblionumber=[% previssue.biblionumber %]">On hold</a>
		[% END %]
                [% IF ( previssue.renew_error_too_many ) %]
            Not renewable
                [% END %]
            [% IF ( previssue.can_confirm ) %]
                </span>
            [% END %]
        [% END %]
        </td>
        [% END %]
		  [% IF ( previssue.return_failed ) %]
            <td class="problem">Check-in failed</td>
        [% ELSE %]
            [% IF ( previssue.renew_error_on_reserve ) %]
               <td><a href="/cgi-bin/koha/reserve/request.pl?biblionumber=[% previssue.biblionumber %]">On hold</a>
                <input type="checkbox" name="all_barcodes[]" value="[% previssue.barcode %]" checked="checked" style="display: none;" />
                </td>
            [% ELSE %]
            <td><input type="checkbox" class="radio" name="barcodes[]"  value="[% previssue.barcode %]" />
                <input type="checkbox" name="all_barcodes[]" value="[% previssue.barcode %]" checked="checked" style="display: none;" />
            </td>
            [% END %]
        [% END %]
        [% IF ( exports_enabled ) %]
          <td style="text-align:center;">
            <input type="checkbox" id="export_[% previssue.biblionumber %]" name="biblionumbers" value="[% previssue.biblionumber %]" />
            <input type="checkbox" name="itemnumbers" value="[% previssue.itemnumber %]" style="visibility:hidden;" />
          </td>
        [% END %]
    </tr>
    <!-- /loop previssues -->[% END %]
<!--/if previssues -->[% END %]
      </tbody>
    </table>
    [% IF ( issuecount ) %]
    <fieldset class="action">
        [% IF ( CAN_user_circulate_override_renewals ) %]
        [% IF ( AllowRenewalLimitOverride ) %]
        <label for="override_limit">Override renewal limit:</label>
        <input type="checkbox" name="override_limit" id="override_limit" value="1" />
        [% END %]
        [% END %]
        <input type="submit" name="renew_checked" value="Renew or Return checked items" />
        <input type="submit" id="renew_all" name="renew_all" value="Renew all" />
    </fieldset>
        [% IF ( exports_enabled ) %]
            <fieldset>
            <label for="export_formats"><b>Export checkouts using format:</b></label>
            <select name="export_formats" id="export_formats">
                <option value="iso2709_995">ISO2709 with items</option>
                <option value="iso2709">ISO2709 without items</option>
                [% IF ( export_with_csv_profile ) %]
                    <option value="csv">CSV</option>
                [% END %]

            </select>
           <label for="export_remove_fields">Don't export fields:</label> <input type="text" id="export_remove_fields" name="export_remove_fields" value="[% export_remove_fields %]" title="Use for iso2709 exports" />
            <input type="hidden" name="op" value="export" />
            <input type="hidden" id="export_format" name="format" value="iso2709" />
            <input type="hidden" id="dont_export_item" name="dont_export_item" value="0" />
            <input type="hidden" id="record_type" name="record_type" value="bibs" />
            <input type="button" id="export_submit" value="Export" />
            </fieldset>
        [% END %]
    [% END %]
    </form>
[% ELSE %]
    <p>Patron has nothing checked out.</p>
[% END %]

</div>


[% IF ( relatives_issues_count ) %]
<div id="relatives-issues">
    <table id="relatives-issues-table">
        <thead>
            <tr>
                <th scope="col">Due date</th>
                <th scope="col">Title</th>
                <th scope="col">Item type</th>
                <th scope="col">Checked out on</th>
                <th scope="col">Checked out from</th>
                <th scope="col">Call no</th>
                <th scope="col">Charge</th>
                <th scope="col">Price</th>
                <th scope="col">Patron</th>
            </tr>
        </thead>
[% IF ( relissues ) %]	<tbody>

    [% FOREACH relissue IN relissues %]
    [% IF ( loop.odd ) %]
    <tr>
    [% ELSE %]
    <tr class="highlight">
    [% END %]
        [% IF ( relissue.overdue ) %]<td class="od">[% ELSE %]<td>[% END %]
            <span title="[% relissue.dd_sort %]">[% relissue.dd %]</span></td>

            [% IF ( relissue.itemlost ) %]
                <span class="lost">[% AuthorisedValues.GetByCode( 'LOST', relissue.itemlost ) %]</span>
            [% END %]
            [% IF ( relissue.damaged ) %]
                <span class="dmg">[% AuthorisedValues.GetByCode( 'DAMAGED', relissue.damaged ) %]</span>
            [% END %]
        </td>
        <td><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% relissue.biblionumber %]&amp;type=intra"><strong>[% relissue.title |html %][% FOREACH subtitl IN relissue.subtitle %] [% subtitl.subfield %][% END %]</strong></a>[% IF ( relissue.author ) %], by [% relissue.author %][% END %][% IF ( relissue.itemnotes ) %]- <span class="circ-hlt">[% relissue.itemnotes %]</span>[% END %] <a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% relissue.biblionumber %]&amp;itemnumber=[% relissue.itemnumber %]#item[% relissue.itemnumber %]">[% relissue.barcode %]</a></td>
        <td>[% UNLESS ( noItemTypeImages ) %] [% IF ( relissue.itemtype_image ) %]<img src="[% relissue.itemtype_image %]" alt="" />[% END %][% END %][% relissue.itemtype %]</td>
        <td><span title="[% relissue.displaydate_sort %]">[% relissue.displaydate %]</span></td>
        <td>[% relissue.issuingbranchname %]</td>
        <td>[% relissue.itemcallnumber %]</td>
        <td>[% relissue.charge %]</td>
        <td>[% relissue.replacementprice %]</td><td><a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% relissue.borrowernumber %]">[% relissue.firstname %] [% relissue.surname %] ([% relissue.cardnumber %])</a></td>
     </tr>
    [% END %] <!-- /loop relissues -->
    <!-- /if relissues -->[% END %]
[% IF ( relprevissues ) %]
    [% IF ( UseTablesortForCirc ) %]<tr id="relprevious"><th><span title="">Previous checkouts</span></th><th></th><th></th><th><span title=""></span></th><th></th><th></th><th></th><th></th><th></th></tr>[% ELSE %]<tr id="relprevious"><th colspan="9">Previous checkouts</th></tr>[% END %]
    [% FOREACH relprevissue IN relprevissues %]
    [% IF ( loop.odd ) %]
        <tr>
    [% ELSE %]
        <tr class="highlight">
    [% END %]
        [% IF ( relprevissue.overdue ) %]<td class="od">[% ELSE %]<td>[% END %]
        <span title="[% relprevissue.dd_sort %]">[% relprevissue.dd %]</span>
        </td>
        <td><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% relprevissue.biblionumber %]&amp;type=intra"><strong>[% relprevissue.title |html %][% FOREACH subtitl IN relprevissue.subtitle %] [% subtitl.subfield %][% END %]</strong></a>[% IF ( relprevissue.author ) %], by [% relprevissue.author %][% END %] [% IF ( relprevissue.itemnotes ) %]- [% relprevissue.itemnotes %][% END %] <a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% relprevissue.biblionumber %]&amp;itemnumber=[% relprevissue.itemnumber %]#item[% relprevissue.itemnumber %]">[% relprevissue.barcode %]</a></td>
        <td>[% UNLESS noItemTypeImages %][% IF relprevissue.itemtype_image %]<img src="[% relprevissue.itemtype_image %]" alt="" />[% END %][% END %][% relprevissue.itemtype %]</td>
        <td><span title="[% relprevissue.displaydate_sort %]">[% relprevissue.displaydate %]</span></td>
        <td>[% relprevissue.issuingbranchname %]</td>
        <td>[% relprevissue.itemcallnumber %]</td>
	[% IF ( relprevissue.multiple_borrowers ) %]<td>[% relprevissue.firstname %] [% relprevissue.surname %]</td>[% END %]
        <td>[% relprevissue.charge %]</td>
        <td>[% relprevissue.replacementprice %]</td>
        <td><a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% relprevissue.borrowernumber %]">[% relprevissue.firstname %] [% relprevissue.surname %] ([% relprevissue.cardnumber %])</a></td>

    </tr>
    <!-- /loop relprevissue -->[% END %]
<!--/if relprevissues -->[% END %]
      </tbody>
    </table>

</div>
[% END %]

[% INCLUDE borrower_debarments.inc %]

- 

Return to bug 11703

Lines 184-193 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/Issue.pm (-4 / +28 lines)
184	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZEh31EKBmURMKxDxI+H3EA	184	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZEh31EKBmURMKxDxI+H3EA
185		185
186	__PACKAGE__->belongs_to(	186	__PACKAGE__->belongs_to(
187	"borrower",	187	"borrower",
188	"Koha::Schema::Result::Borrower",	188	"Koha::Schema::Result::Borrower",
189	{ borrowernumber => "borrowernumber" },	189	{ borrowernumber => "borrowernumber" },
190	{ join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },	190	{ join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
		191	);
		192
		193	__PACKAGE__->belongs_to(
		194	"item",
		195	"Koha::Schema::Result::Item",
		196	{ itemnumber => "itemnumber" },
		197	{
		198	is_deferrable => 1,
		199	join_type => "LEFT",
		200	on_delete => "CASCADE",
		201	on_update => "CASCADE",
		202	},
		203	);
		204
		205	__PACKAGE__->belongs_to(
		206	"branch",
		207	"Koha::Schema::Result::Branch",
		208	{ branchcode => "branchcode" },
		209	{
		210	is_deferrable => 1,
		211	join_type => "LEFT",
		212	on_delete => "CASCADE",
		213	on_update => "CASCADE",
		214	},
191	);	215	);
192		216
193	1;	217	1;

Lines 42-47 use CGI::Session; Link Here

(-)a/circ/circulation.pl (-111 / +10 lines)
42	use C4::Members::Attributes qw(GetBorrowerAttributes);	42	use C4::Members::Attributes qw(GetBorrowerAttributes);
43	use Koha::Borrower::Debarments qw(GetDebarments);	43	use Koha::Borrower::Debarments qw(GetDebarments);
44	use Koha::DateUtils;	44	use Koha::DateUtils;
		45	use Koha::Database;
45		46
46	use Date::Calc qw(	47	use Date::Calc qw(
47	Today	48	Today
Lines 96-109 my ( $template, $loggedinuser, $cookie ) = get_template_and_user ( Link Here
96		97
97	my $branches = GetBranches();	98	my $branches = GetBranches();
98		99
99	my @failedrenews = $query->param('failedrenew'); # expected to be itemnumbers
100	our %renew_failed = ();
101	for (@failedrenews) { $renew_failed{$_} = 1; }
102
103	my @failedreturns = $query->param('failedreturn');
104	our %return_failed = ();
105	for (@failedreturns) { $return_failed{$_} = 1; }
106
107	my $findborrower = $query->param('findborrower') \|\| q{};	100	my $findborrower = $query->param('findborrower') \|\| q{};
108	$findborrower =~ s\|,\| \|g;	101	$findborrower =~ s\|,\| \|g;
109	my $borrowernumber = $query->param('borrowernumber');	102	my $borrowernumber = $query->param('borrowernumber');
Lines 355-363 if ($barcode) { Link Here
355	}	348	}
356	}	349	}
357		350
358	# FIXME If the issue is confirmed, we launch another time GetMemberIssuesAndFines, now display the issue count after issue	351	my ( $od, $issue, $fines ) = GetMemberIssuesAndFines($borrowernumber);
359	my ( $od, $issue, $fines ) = GetMemberIssuesAndFines( $borrowernumber );	352	$template->param( issuecount => $issue );
360	$template->param( issuecount => $issue );
361	}	353	}
362		354
363	# reload the borrower info for the sake of reseting the flags.....	355	# reload the borrower info for the sake of reseting the flags.....
Lines 457-556 if ($borrowernumber) { Link Here
457	$template->param( adultborrower => 1 ) if ( $borrower->{'category_type'} eq 'A' );	449	$template->param( adultborrower => 1 ) if ( $borrower->{'category_type'} eq 'A' );
458	}	450	}
459		451
460	# make the issued books table.
461	my $todaysissues = '';
462	my $previssues = '';
463	our @todaysissues = ();
464	our @previousissues = ();
465	our @relissues = ();
466	our @relprevissues = ();
467	my $displayrelissues;
468
469	our $totalprice = 0;
470
471	sub build_issue_data {
472	my $issueslist = shift;
473	my $relatives = shift;
474
475	# split in 2 arrays for today & previous
476	foreach my $it ( @$issueslist ) {
477	my $itemtypeinfo = getitemtypeinfo( (C4::Context->preference('item-level_itypes')) ? $it->{'itype'} : $it->{'itemtype'} );
478
479	# set itemtype per item-level_itype syspref - FIXME this is an ugly hack
480	$it->{'itemtype'} = ( C4::Context->preference( 'item-level_itypes' ) ) ? $it->{'itype'} : $it->{'itemtype'};
481
482	($it->{'charge'}, $it->{'itemtype_charge'}) = GetIssuingCharges(
483	$it->{'itemnumber'}, $it->{'borrowernumber'}
484	);
485	$it->{'charge'} = sprintf("%.2f", $it->{'charge'});
486	my ($can_renew, $can_renew_error) = CanBookBeRenewed(
487	$it->{'borrowernumber'},$it->{'itemnumber'}
488	);
489	$it->{"renew_error_${can_renew_error}"} = 1 if defined $can_renew_error;
490	my $restype = C4::Reserves::GetReserveStatus( $it->{'itemnumber'} );
491	$it->{'can_renew'} = $can_renew;
492	$it->{'can_confirm'} = !$can_renew && !$restype;
493	$it->{'renew_error'} = ( $restype eq "Waiting" or $restype eq "Reserved" ) ? 1 : 0;
494	$it->{'checkoutdate'} = C4::Dates->new($it->{'issuedate'},'iso')->output('syspref');
495	$it->{'issuingbranchname'} = GetBranchName($it->{'branchcode'});
496
497	$totalprice += $it->{'replacementprice'} \|\| 0;
498	$it->{'itemtype'} = $itemtypeinfo->{'description'};
499	$it->{'itemtype_image'} = $itemtypeinfo->{'imageurl'};
500	$it->{'dd_sort'} = $it->{'date_due'};
501	$it->{'dd'} = output_pref($it->{'date_due'});
502	$it->{'displaydate_sort'} = $it->{'issuedate'};
503	$it->{'displaydate'} = output_pref($it->{'issuedate'});
504	#$it->{'od'} = ( $it->{'date_due'} lt $todaysdate ) ? 1 : 0 ;
505	$it->{'od'} = $it->{'overdue'};
506	$it->{'subtitle'} = GetRecordValue('subtitle', GetMarcBiblio($it->{biblionumber}), GetFrameworkCode($it->{biblionumber}));
507	$it->{'renew_failed'} = $renew_failed{$it->{'itemnumber'}};
508	$it->{'return_failed'} = $return_failed{$it->{'barcode'}};
509
510	if ( ( $it->{'issuedate'} && $it->{'issuedate'} gt $todaysdate )
511	\|\| ( $it->{'lastreneweddate'} && $it->{'lastreneweddate'} gt $todaysdate ) ) {
512	(!$relatives) ? push @todaysissues, $it : push @relissues, $it;
513	} else {
514	(!$relatives) ? push @previousissues, $it : push @relprevissues, $it;
515	}
516	($it->{'renewcount'},$it->{'renewsallowed'},$it->{'renewsleft'}) = C4::Circulation::GetRenewCount($it->{'borrowernumber'},$it->{'itemnumber'}); #Add renewal count to item data display
517	}
518	}
519
520	if ($borrower) {
521
522	# Getting borrower relatives
523	my @relborrowernumbers = GetMemberRelatives($borrower->{'borrowernumber'});
524	#push @borrowernumbers, $borrower->{'borrowernumber'};
525
526	# get each issue of the borrower & separate them in todayissues & previous issues
527	my $issueslist = GetPendingIssues($borrower->{'borrowernumber'});
528	my $relissueslist = [];
529	if ( @relborrowernumbers ) {
530	$relissueslist = GetPendingIssues(@relborrowernumbers);
531	}
532
533	build_issue_data($issueslist, 0);
534	build_issue_data($relissueslist, 1);
535
536	$displayrelissues = scalar($relissueslist);
537
538	if ( C4::Context->preference( "todaysIssuesDefaultSortOrder" ) eq 'asc' ) {
539	@todaysissues = sort { $a->{'timestamp'} cmp $b->{'timestamp'} } @todaysissues;
540	}
541	else {
542	@todaysissues = sort { $b->{'timestamp'} cmp $a->{'timestamp'} } @todaysissues;
543	}
544
545	if ( C4::Context->preference( "previousIssuesDefaultSortOrder" ) eq 'asc' ){
546	@previousissues = sort { $a->{'date_due'} cmp $b->{'date_due'} } @previousissues;
547	}
548	else {
549	@previousissues = sort { $b->{'date_due'} cmp $a->{'date_due'} } @previousissues;
550	}
551	}
552
553
554	my @values;	452	my @values;
555	my %labels;	453	my %labels;
556	my $CGIselectborrower;	454	my $CGIselectborrower;
Lines 702-707 if (C4::Context->preference('ExtendedPatronAttributes')) { Link Here
702	);	600	);
703	}	601	}
704		602
		603	my @relatives = GetMemberRelatives( $borrower->{'borrowernumber'} );
		604	my $relatives_issues_count =
		605	Koha::Database->new()->schema()->resultset('Issue')
		606	->count( { borrowernumber => \@relatives } );
		607
705	$template->param(	608	$template->param(
706	lib_messages_loop => $lib_messages_loop,	609	lib_messages_loop => $lib_messages_loop,
707	bor_messages_loop => $bor_messages_loop,	610	bor_messages_loop => $bor_messages_loop,
Lines 739-751 $template->param( Link Here
739	duedatespec => $duedatespec,	642	duedatespec => $duedatespec,
740	message => $message,	643	message => $message,
741	CGIselectborrower => $CGIselectborrower,	644	CGIselectborrower => $CGIselectborrower,
742	totalprice => sprintf('%.2f', $totalprice),
743	totaldue => sprintf('%.2f', $total),	645	totaldue => sprintf('%.2f', $total),
744	todayissues => \@todaysissues,
745	previssues => \@previousissues,
746	relissues => \@relissues,
747	relprevissues => \@relprevissues,
748	displayrelissues => $displayrelissues,
749	inprocess => $inprocess,	646	inprocess => $inprocess,
750	memberofinstution => $member_of_institution,	647	memberofinstution => $member_of_institution,
751	CGIorganisations => $CGIorganisations,	648	CGIorganisations => $CGIorganisations,
Lines 758-763 $template->param( Link Here
758	SuspendHoldsIntranet => C4::Context->preference('SuspendHoldsIntranet'),	655	SuspendHoldsIntranet => C4::Context->preference('SuspendHoldsIntranet'),
759	AutoResumeSuspendedHolds => C4::Context->preference('AutoResumeSuspendedHolds'),	656	AutoResumeSuspendedHolds => C4::Context->preference('AutoResumeSuspendedHolds'),
760	RoutingSerials => C4::Context->preference('RoutingSerials'),	657	RoutingSerials => C4::Context->preference('RoutingSerials'),
		658	relatives_issues_count => $relatives_issues_count,
		659	relatives_borrowernumbers => \@relatives,
761	);	660	);
762		661
763	# save stickyduedate to session	662	# save stickyduedate to session

Line 0 Link Here

(-)a/api/checkin.pl (+75 lines)
		1	#!/usr/bin/perl
		2
		3	# Copyright 2014 ByWater Solutions
		4	#
		5	# This file is part of Koha.
		6	#
		7	# Koha is free software; you can redistribute it and/or modify it under the
		8	# terms of the GNU General Public License as published by the Free Software
		9	# Foundation; either version 2 of the License, or (at your option) any later
		10	# version.
		11	#
		12	# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
		13	# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
		14	# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
		15	#
		16	# You should have received a copy of the GNU General Public License along
		17	# with Koha; if not, write to the Free Software Foundation, Inc.,
		18	# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
		19
		20	use Modern::Perl;
		21
		22	use CGI;
		23	use JSON qw(to_json);
		24
		25	use C4::Circulation;
		26	use C4::Items qw(GetBarcodeFromItemnumber);
		27	use C4::Context;
		28	use C4::Auth qw(check_cookie_auth);
		29
		30	use Koha::DateUtils qw(output_pref_due);
		31
		32	my $input = new CGI;
		33
		34	my ( $auth_status, $sessionID ) =
		35	check_cookie_auth( $input->cookie('CGISESSID'),
		36	{ circulate => 'circulate_remaining_permissions' } );
		37
		38	if ( $auth_status ne "ok" ) {
		39	exit 0;
		40	}
		41
		42	binmode STDOUT, ":encoding(UTF-8)";
		43	print $input->header( -type => 'text/plain', -charset => 'UTF-8' );
		44
		45	my $itemnumber = $input->param('itemnumber');
		46	my $borrowernumber = $input->param('borrowernumber');
		47	my $override_limit = $input->param('override_limit');
		48	my $exempt_fine = $input->param('exempt_fine');
		49	my $branchcode = $input->param('branchcode')
		50	\|\| C4::Context->userenv->{'branch'};
		51
		52	my $barcode = GetBarcodeFromItemnumber($itemnumber);
		53
		54	my $data;
		55	$data->{itemnumber} = $itemnumber;
		56	$data->{borrowernumber} = $borrowernumber;
		57	$data->{branchcode} = $branchcode;
		58
		59	if ( C4::Context->preference("InProcessingToShelvingCart") ) {
		60	my $item = GetItem($itemnumber);
		61	if ( $item->{'location'} eq 'PROC' ) {
		62	$item->{'location'} = 'CART';
		63	ModItem( $item, $item->{'biblionumber'}, $item->{'itemnumber'} );
		64	}
65	}
66
67	if ( C4::Context->preference("ReturnToShelvingCart") ) {
68	my $item = GetItem($itemnumber);
69	$item->{'location'} = 'CART';
70	ModItem( $item, $item->{'biblionumber'}, $item->{'itemnumber'} );
71	}
72
73	( $data->{returned} ) = AddReturn( $barcode, $branchcode, $exempt_fine );
74
75	print to_json($data);

Line 0 Link Here

(-)a/api/checkouts.pl (+137 lines)
		1	#!/usr/bin/perl
		2
		3	# This software is placed under the gnu General Public License, v2 (http://www.gnu.org/licenses/gpl.html)
		4
		5	# Copyright 2014 ByWater Solutions
		6	#
		7	# This file is part of Koha.
		8	#
		9	# Koha is free software; you can redistribute it and/or modify it under the
		10	# terms of the GNU General Public License as published by the Free Software
		11	# Foundation; either version 3 of the License, or (at your option) any later
		12	# version.
		13	#
		14	# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
		15	# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
		16	# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
		17	#
		18	# You should have received a copy of the GNU General Public License along
		19	# with Koha; if not, write to the Free Software Foundation, Inc.,
		20	# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
		21
		22	use Modern::Perl;
		23
		24	use CGI;
		25	use JSON qw(to_json);
		26
		27	use C4::Auth qw(check_cookie_auth);
		28	use C4::Biblio qw(GetMarcBiblio GetFrameworkCode GetRecordValue );
		29	use C4::Charset;
		30	use C4::Circulation qw(GetIssuingCharges CanBookBeRenewed GetRenewCount);
		31	use C4::Context;
		32
		33	use Koha::Database;
		34	use Koha::DateUtils;
		35
		36	my $input = new CGI;
		37
		38	my ( $auth_status, $sessionID ) =
		39	check_cookie_auth( $input->cookie('CGISESSID'),
		40	{ circulate => 'circulate_remaining_permissions' } );
		41
		42	if ( $auth_status ne "ok" ) {
		43	exit 0;
		44	}
		45
		46	my $schema = Koha::Database->new()->schema();
		47
		48	my @sort_columns = qw/date_due title itype issuedate branchcode itemcallnumber/;
		49
		50	my @borrowernumber = $input->param('borrowernumber');
		51	my $offset = $input->param('iDisplayStart');
		52	my $results_per_page = $input->param('iDisplayLength');
		53	my $sorting_column = $sort_columns[ $input->param('iSortCol_0') ] \|\| 'issuedate';
		54	my $sorting_direction = $input->param('sSortDir_0') \|\| 'desc';
		55
		56	$results_per_page = undef if ( $results_per_page == -1 );
		57
		58	binmode STDOUT, ":encoding(UTF-8)";
		59	print $input->header( -type => 'text/plain', -charset => 'UTF-8' );
		60
		61	my $checkouts_rs = $schema->resultset('Issue')->search(
		62	{ borrowernumber => \@borrowernumber },
		63	{
		64	prefetch => { 'item' => 'biblio' },
65	order_by => { "-$sorting_direction" => $sorting_column }
66	}
67	);
68
69	my $borrower;
70	my @checkouts;
71	while ( my $c = $checkouts_rs->next() ) {
72
73	# No point in fetching this every time if only one borrower
74	$borrower = $c->borrower()
75	if ( !$borrower \|\| @borrowernumber > 1 );
76
77	my $borrowernumber = $borrower->borrowernumber();
78	my $itemnumber = $c->item()->itemnumber();
79	my $biblionumber = $c->item()->biblionumber();
80
81	my ($charge) =
82	GetIssuingCharges( $c->itemnumber()->itemnumber(), $borrowernumber );
83
84	my ( $can_renew, $can_renew_error ) =
85	CanBookBeRenewed( $borrowernumber, $itemnumber );
86
87	my ( $renewals_count, $renewals_allowed, $renewals_remaining ) =
88	GetRenewCount( $borrowernumber, $itemnumber );
89
90	push(
91	@checkouts,
92	{
93	DT_RowId => "$itemnumber-$borrowernumber",
94	title => $c->item()->biblio()->title(),
95	author => $c->item()->biblio()->author(),
96	barcode => $c->item()->barcode(),
97	itemtype => $c->item()->effective_itemtype(),
98	itemnotes => $c->item()->itemnotes(),
99	branchcode => $c->branchcode(),
100	branchname => $c->branch->branchname(),
101	itemcallnumber => $c->item()->itemcallnumber() \|\| q{},
102	charge => $charge,
103	price => $c->item->replacementprice() \|\| q{},
104	can_renew => $can_renew,
105	can_renew_error => $can_renew_error,
106	itemnumber => $itemnumber,
107	borrowernumber => $borrowernumber,
108	biblionumber => $biblionumber,
109	issuedate => $c->issuedate(),
110	date_due => $c->date_due(),
111	renewals_count => $renewals_count,
112	renewals_allowed => $renewals_allowed,
113	renewals_remaining => $renewals_remaining,
114	issuedate_formatted =>
115	output_pref( dt_from_string( $c->issuedate() ) ),
116	date_due_formatted =>
117	output_pref_due( dt_from_string( $c->date_due() ) ),
118	subtitle => GetRecordValue(
119	'subtitle', GetMarcBiblio($biblionumber),
120	GetFrameworkCode($biblionumber)
121	),
122	borrower => {
123	surname => $borrower->surname(),
124	firstname => $borrower->firstname(),
125	cardnumber => $borrower->cardnumber(),
126	}
127	}
128	);
129	}
130
131	my $data;
132	$data->{'iTotalRecords'} = scalar @checkouts; #FIXME
133	$data->{'iTotalDisplayRecords'} = scalar @checkouts;
134	$data->{'sEcho'} = $input->param('sEcho') \|\| undef;
135	$data->{'aaData'} = \@checkouts;
136
137	print to_json($data);

Line 0 Link Here

(-)a/api/renew.pl (+69 lines)
		1	#!/usr/bin/perl
		2
		3	# Copyright 2014 ByWater Solutions
		4	#
		5	# This file is part of Koha.
		6	#
		7	# Koha is free software; you can redistribute it and/or modify it under the
		8	# terms of the GNU General Public License as published by the Free Software
		9	# Foundation; either version 2 of the License, or (at your option) any later
		10	# version.
		11	#
		12	# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
		13	# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
		14	# A PARTICULAR PURPOSE. See the GNU General Public License for more details.
		15	#
		16	# You should have received a copy of the GNU General Public License along
		17	# with Koha; if not, write to the Free Software Foundation, Inc.,
		18	# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
		19
		20	use Modern::Perl;
		21
		22	use CGI;
		23	use JSON qw(to_json);
		24
		25	use C4::Circulation;
		26	use C4::Context;
		27	use C4::Auth qw(check_cookie_auth);
		28
		29	use Koha::DateUtils qw(output_pref_due dt_from_string);
		30
		31	my $input = new CGI;
		32
		33	my ( $auth_status, $sessionID ) =
		34	check_cookie_auth( $input->cookie('CGISESSID'),
		35	{ circulate => 'circulate_remaining_permissions' } );
		36
		37	if ( $auth_status ne "ok" ) {
		38	exit 0;
		39	}
		40
		41	binmode STDOUT, ":encoding(UTF-8)";
		42	print $input->header( -type => 'text/plain', -charset => 'UTF-8' );
		43
		44	my $itemnumber = $input->param('itemnumber');
		45	my $borrowernumber = $input->param('borrowernumber');
		46	my $override_limit = $input->param('override_limit');
		47	my $branchcode = $input->param('branchcode')
		48	\|\| C4::Context->userenv->{'branch'};
		49	my $date_due;
		50	if ( $input->param('date_due') ) {
		51	$date_due = dt_from_string( $input->param('date_due') );
		52	$date_due->set_hour(23);
		53	$date_due->set_minute(59);
		54	}
		55
		56	my $data;
		57	$data->{itemnumber} = $itemnumber;
		58	$data->{borrowernumber} = $borrowernumber;
		59	$data->{branchcode} = $branchcode;
		60
		61	( $data->{renew_okay}, $data->{error} ) =
		62	CanBookBeRenewed( $borrowernumber, $itemnumber, $override_limit );
		63
		64	if ( $data->{renew_okay} ) {
65	$date_due = AddRenewal( $borrowernumber, $itemnumber, $branchcode, $date_due );
66	$data->{date_due} = output_pref_due( $date_due );
67	}
68
69	print to_json($data);

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/js/checkouts.js (+267 lines)
		1	$(document).ready(function() {
		2	var ymd = $.datepicker.formatDate('yy-mm-dd', new Date());
		3
		4	$("#issues-table").dataTable({
		5	"sDom": "<'row-fluid'<'span6'><'span6'>r>t<'row-fluid'>t",
		6	"aaSorting": [],
		7	"aoColumns": [
		8	{
		9	"mDataProp": function( oObj ) {
		10	var today = new Date();
		11	var due = new Date( oObj.date_due );
		12	if ( today > due ) {
		13	return "<span class='overdue'>" + oObj.date_due_formatted + "</span>";
		14	} else {
		15	return oObj.date_due_formatted;
		16	}
		17	}
		18	},
		19	{
		20	"mDataProp": function ( oObj ) {
		21	title = "<a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
		22	+ oObj.biblionumber
		23	+ "'>"
		24	+ oObj.title;
		25
		26	$.each(oObj.subtitle, function( index, value ) {
		27	title += " " + value.subfield;
		28	});
		29
		30	title += "</a>";
		31
		32	if ( oObj.author ) {
		33	title += " " + _("by") + " " + oObj.author;
		34	}
		35
		36	if ( oObj.itemnotes ) {
		37	var span_class = "";
		38	if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
		39	span_class = "circ-hlt";
		40	}
		41	title += " - <span class='" + span_class + "'>" + oObj.itemnotes + "</span>"
		42	}
		43
		44	title += " "
		45	+ "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
		46	+ oObj.biblionumber
		47	+ "&itemnumber="
		48	+ oObj.itemnumber
		49	+ "#"
		50	+ oObj.itemnumber
		51	+ "'>"
		52	+ oObj.barcode
		53	+ "</a>";
		54
		55	return title;
		56	}
		57	},
		58	{ "mDataProp": "itemtype" },
		59	{ "mDataProp": "issuedate" },
		60	{ "mDataProp": "branchname" },
		61	{ "mDataProp": "itemcallnumber" },
		62	{
		63	"bSortable": false,
		64	"mDataProp": function ( oObj ) {
65	return parseFloat(oObj.charge).toFixed(2);
66	}
67	},
68	{
69	"bSortable": false,
70	"mDataProp": "price" },
71	{
72	"bSortable": false,
73	"mDataProp": function ( oObj ) {
74	var content = "";
75	var span_style = "";
76	var span_class = "";
77
78	content += "<span style='padding: 0 1em;'>" + oObj.renewals_count + "</span>";
79
80	if ( oObj.can_renew ) {
81	// Do nothing
82	} else if ( oObj.can_renew_error == "on_reserve" ) {
83	content += "<span class='renewals-disabled'>"
84	+ "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + _("On hold") + "</a>"
85	+ "</span>";
86
87	span_style = "display: none";
88	span_class = "renewals-allowed";
89	} else if ( oObj.can_renew_error == "too_many" ) {
90	content += "<span class='renewals-disabled'>"
91	+ _("Not renewable")
92	+ "</span>";
93
94	span_style = "display: none";
95	span_class = "renewals-allowed";
96	} else {
97	content += "<span class='renewals-disabled'>"
98	+ oObj.can_renew_error
99	+ "</span>";
100
101	span_style = "display: none";
102	span_class = "renewals-allowed";
103	}
104
105	content += "<span class='" + span_class + "' style='" + span_style + "'>"
106	+ "<input type='checkbox' class='renew' id='renew_" + oObj.itemnumber + "' name='renew' value='" + oObj.itemnumber +"'/>"
107	+ "</span>";
108
109	if ( oObj.renewals_remaining ) {
110	content += "<span class='renewals'>("
111	+ oObj.renewals_remaining
112	+ " " + _("of") + " "
113	+ oObj.renewals_allowed + " "
114	+ _("renewals remaining") + ")</span>"
115	}
116
117
118	return content;
119	}
120	},
121	{
122	"bSortable": false,
123	"mDataProp": function ( oObj ) {
124	if ( oObj.can_renew_error == "on_reserve" ) {
125	return "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + _("On hold") + "</a>";
126	} else {
127	return "<input type='checkbox' class='checkin' id='checkin_" + oObj.itemnumber + "' name='checkin' value='" + oObj.itemnumber +"'></input>";
128	}
129	}
130	},
131	{
132	"bVisible": exports_enabled ? true : false,
133	"bSortable": false,
134	"mDataProp": function ( oObj ) {
135	return "<input type='checkbox' class='export' id='export_" + oObj.biblionumber + "' name='biblionumbers' value='" + oObj.biblionumber + "' />";
136	}
137	}
138	],
139	"fnFooterCallback": function ( nRow, aaData, iStart, iEnd, aiDisplay ) {
140	var total_charge = 0;
141	var total_price = 0;
142	for ( var i=0; i < aaData.length; i++ ) {
143	total_charge += aaData[i]['charge'] * 1;
144	total_price += aaData[i]['price'] * 1;
145	}
146	var nCells = nRow.getElementsByTagName('td');
147	nCells[1].innerHTML = total_charge.toFixed(2);
148	nCells[2].innerHTML = total_price.toFixed(2);
149	},
150	"bPaginate": false,
151	"bProcessing": true,
152	"bServerSide": true,
153	"sAjaxSource": '/cgi-bin/koha/api/checkouts.pl',
154	"fnServerData": function ( sSource, aoData, fnCallback ) {
155	aoData.push( { "name": "borrowernumber", "value": borrowernumber } );
156
157	$.getJSON( sSource, aoData, function (json) {
158	fnCallback(json)
159	} );
160	},
161	});
162
163	// Don't load relatives' issues table unless it is clicked on
164	var relativesIssuesTable;
165	$("#relatives-issues-tab").click( function() {
166	if ( ! relativesIssuesTable ) {
167	relativesIssuesTable = $("#relatives-issues-table").dataTable({
168	"sDom": "<'row-fluid'<'span6'><'span6'>r>t<'row-fluid'>t",
169	"aaSorting": [],
170	"aoColumns": [
171	{
172	"mDataProp": function( oObj ) {
173	var today = new Date();
174	var due = new Date( oObj.date_due );
175	if ( today > due ) {
176	return "<span class='overdue'>" + oObj.date_due_formatted + "</span>";
177	} else {
178	return oObj.date_due_formatted;
179	}
180	}
181	},
182	{
183	"mDataProp": function ( oObj ) {
184	title = "<a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
185	+ oObj.biblionumber
186	+ "'>"
187	+ oObj.title;
188
189	$.each(oObj.subtitle, function( index, value ) {
190	title += " " + value.subfield;
191	});
192
193	title += "</a>";
194
195	if ( oObj.author ) {
196	title += " " + _("by") + " " + oObj.author;
197	}
198
199	if ( oObj.itemnotes ) {
200	var span_class = "";
201	if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
202	span_class = "circ-hlt";
203	}
204	title += " - <span class='" + span_class + "'>" + oObj.itemnotes + "</span>"
205	}
206
207	title += " "
208	+ "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
209	+ oObj.biblionumber
210	+ "&itemnumber="
211	+ oObj.itemnumber
212	+ "#"
213	+ oObj.itemnumber
214	+ "'>"
215	+ oObj.barcode
216	+ "</a>";
217
218	return title;
219	}
220	},
221	{ "mDataProp": "itemtype" },
222	{ "mDataProp": "issuedate" },
223	{ "mDataProp": "branchname" },
224	{ "mDataProp": "itemcallnumber" },
225	{ "mDataProp": "charge" },
226	{ "mDataProp": "price" },
227	{
228	"mDataProp": function( oObj ) {
229	return "<a href='/cgi-bin/koha/members/moremember.pl?borrowernumber=" + oObj.borrowernumber + "'>"
230	+ oObj.borrower.firstname + " " + oObj.borrower.surname + " (" + oObj.borrower.cardnumber + ")</a>"
231	}
232	},
233	],
234	"bPaginate": false,
235	"bProcessing": true,
236	"bServerSide": true,
237	"sAjaxSource": '/cgi-bin/koha/api/checkouts.pl',
238	"fnServerData": function ( sSource, aoData, fnCallback ) {
239	$.each(relatives_borrowernumbers, function( index, value ) {
240	aoData.push( { "name": "borrowernumber", "value": value } );
241	});
242
243	$.getJSON( sSource, aoData, function (json) {
244	fnCallback(json)
245	} );
246	},
247	});
248	}
249	});
250
251	$("#issues-table").on("sort",function() {
252	$("#previous").hide(); // Don't want to see "previous checkouts" header sorted with other rows
253	});
254	$("#relatives-issues-table").on("sort",function() {
255	$("#relprevious").hide(); // Don't want to see "previous checkouts" header sorted with other rows
256	});
257
258	if ( AllowRenewalLimitOverride ) {
259	$( '#override_limit' ).click( function () {
260	if ( this.checked ) {
261	$( '.renewals-allowed' ).show(); $( '.renewals-disabled' ).hide();
262	} else {
263	$( '.renewals-allowed' ).hide(); $( '.renewals-disabled' ).show();
264	}
265	} ).attr( 'checked', false );
266	}
267	});