Attachment #27717 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;




# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ig/fobzvZf1OgAHZFtkyyQ

__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(
  "biblio",
  "Koha::Schema::Result::Biblio",
  { biblionumber => "biblionumber" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

# You can replace this text with custom content, and it will be preserved on regeneration
1;




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');

    $template->param(DisplayClearScreenButton => 1);
}

if (C4::Context->preference("UseTablesortForCirc")) {
    $template->param(UseTablesortForCirc => 1);
}

my $barcode        = $query->param('barcode') || q{};
$barcode =~  s/^\s*|\s*$//g; # remove leading/trailing whitespace


        }
    }
    
    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.....

# BUILD HTML
# show all reserves of this borrower, and the position of the reservation ....
if ($borrowernumber) {
    $template->param(
        holds_count => Koha::Database->new()->schema()->resultset('Reserve')
          ->count( { borrowernumber => $borrowernumber } ) );

    # new op dev
    # now we show the status of the borrower's reservations
    my @borrowerreserv = GetReservesFromBorrowernumber($borrowernumber );
    my @reservloop;
    my @WaitingReserveLoop;
    
    foreach my $num_res (@borrowerreserv) {
        my %getreserv;
        my %getWaitingReserveInfo;
        my $getiteminfo  = GetBiblioFromItemNumber( $num_res->{'itemnumber'} );
        my $itemtypeinfo = getitemtypeinfo( (C4::Context->preference('item-level_itypes')) ? $getiteminfo->{'itype'} : $getiteminfo->{'itemtype'} );
        my ( $transfertwhen, $transfertfrom, $transfertto ) =
          GetTransfers( $num_res->{'itemnumber'} );

        $getreserv{waiting}       = 0;
        $getreserv{transfered}    = 0;
        $getreserv{nottransfered} = 0;

        $getreserv{reservedate}    = format_date( $num_res->{'reservedate'} );
        $getreserv{reserve_id}  = $num_res->{'reserve_id'};
        $getreserv{title}          = $getiteminfo->{'title'};
        $getreserv{subtitle}       = GetRecordValue('subtitle', GetMarcBiblio($getiteminfo->{biblionumber}), GetFrameworkCode($getiteminfo->{biblionumber}));
        $getreserv{itemtype}       = $itemtypeinfo->{'description'};
        $getreserv{author}         = $getiteminfo->{'author'};
        $getreserv{barcodereserv}  = $getiteminfo->{'barcode'};
        $getreserv{itemcallnumber} = $getiteminfo->{'itemcallnumber'};
        $getreserv{biblionumber}   = $getiteminfo->{'biblionumber'};
        $getreserv{waitingat}      = GetBranchName( $num_res->{'branchcode'} );
        $getreserv{suspend}        = $num_res->{'suspend'};
        $getreserv{suspend_until}  = $num_res->{'suspend_until'};
        #         check if we have a waiting status for reservations
        if ( $num_res->{'found'} && $num_res->{'found'} eq 'W' ) {
            $getreserv{color}   = 'reserved';
            $getreserv{waiting} = 1;
#     genarate information displaying only waiting reserves
        $getWaitingReserveInfo{title}        = $getiteminfo->{'title'};
        $getWaitingReserveInfo{biblionumber} = $getiteminfo->{'biblionumber'};
        $getWaitingReserveInfo{itemtype}     = $itemtypeinfo->{'description'};
        $getWaitingReserveInfo{author}       = $getiteminfo->{'author'};
        $getWaitingReserveInfo{itemcallnumber} = $getiteminfo->{'itemcallnumber'};
        $getWaitingReserveInfo{reservedate}  = format_date( $num_res->{'reservedate'} );
        $getWaitingReserveInfo{waitingat}    = GetBranchName( $num_res->{'branchcode'} );
        $getWaitingReserveInfo{waitinghere}  = 1 if $num_res->{'branchcode'} eq $branch;
        }
        #         check transfers with the itemnumber foud in th reservation loop
        if ($transfertwhen) {
            $getreserv{color}      = 'transfered';
            $getreserv{transfered} = 1;
            $getreserv{datesent}   = format_date($transfertwhen);
            $getreserv{frombranch} = GetBranchName($transfertfrom);
        } elsif ($getiteminfo->{'holdingbranch'} ne $num_res->{'branchcode'}) {
            $getreserv{nottransfered}   = 1;
            $getreserv{nottransferedby} = GetBranchName( $getiteminfo->{'holdingbranch'} );
        }

#         if we don't have a reserv on item, we put the biblio infos and the waiting position
        if ( $getiteminfo->{'title'} eq '' ) {
            my $getbibinfo = GetBiblioData( $num_res->{'biblionumber'} );

            $getreserv{color}           = 'inwait';
            $getreserv{title}           = $getbibinfo->{'title'};
            $getreserv{subtitle}        = GetRecordValue('subtitle', GetMarcBiblio($num_res->{biblionumber}), GetFrameworkCode($num_res->{biblionumber}));
            $getreserv{nottransfered}   = 0;
            $getreserv{itemtype}        = $itemtypeinfo->{'description'};
            $getreserv{author}          = $getbibinfo->{'author'};
            $getreserv{biblionumber}    = $num_res->{'biblionumber'};
        }
        $getreserv{waitingposition} = $num_res->{'priority'};
        $getreserv{expirationdate} = $num_res->{'expirationdate'};
        push( @reservloop, \%getreserv );

#         if we have a reserve waiting, initiate waitingreserveloop
        if ($getreserv{waiting} == 1) {
        push (@WaitingReserveLoop, \%getWaitingReserveInfo)
        }
      
    }

    # return result to the template
    $template->param( 
        countreserv => scalar @reservloop,
        reservloop  => \@reservloop ,
        WaitingReserveLoop  => \@WaitingReserveLoop,
    );
    $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

        $it->{'soonestrenewdate'} = output_pref(
            C4::Circulation::GetSoonestRenewDate(
                $it->{borrowernumber}, $it->{itemnumber}
            )
        );
    }
}

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,
    is_child          => ($borrower->{'category_type'} eq 'C'),
    circview => 1,

    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 415-421 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (-1 lines)
415	('UseICU','0','1','Tell Koha if ICU indexing is in use for Zebra or not.','YesNo'),	415	('UseICU','0','1','Tell Koha if ICU indexing is in use for Zebra or not.','YesNo'),
416	('UseKohaPlugins','0','','Enable or disable the ability to use Koha Plugins.','YesNo'),	416	('UseKohaPlugins','0','','Enable or disable the ability to use Koha Plugins.','YesNo'),
417	('UseQueryParser','0',NULL,'If enabled, try to use QueryParser for queries.','YesNo'),	417	('UseQueryParser','0',NULL,'If enabled, try to use QueryParser for queries.','YesNo'),
418	('UseTablesortForCirc','0','','If on, use the JQuery tablesort function on the list of current borrower checkouts on the circulation page. Note that the use of this function may slow down circ for patrons with may checkouts.','YesNo'),
419	('UseTransportCostMatrix','0','','Use Transport Cost Matrix when filling holds','YesNo'),	418	('UseTransportCostMatrix','0','','Use Transport Cost Matrix when filling holds','YesNo'),
420	('viewISBD','1','','Allow display of ISBD view of bibiographic records','YesNo'),	419	('viewISBD','1','','Allow display of ISBD view of bibiographic records','YesNo'),
421	('viewLabeledMARC','0','','Allow display of labeled MARC view of bibiographic records','YesNo'),	420	('viewLabeledMARC','0','','Allow display of labeled MARC view of bibiographic records','YesNo'),




/*
* File:        jquery.dataTables.grouping.js
* Version:     1.2.9.
* Author:      Jovan Popovic
*
* Copyright 2013 Jovan Popovic, all rights reserved.
*
* This source file is free software, under either the GPL v2 license or a
* BSD style license, as supplied with this software.
*
* This source file 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.
* Parameters:
* @iGroupingColumnIndex                                 Integer             Index of the column that will be used for grouping - default 0
* @sGroupingColumnSortDirection                         Enumeration         Sort direction of the group
* @iGroupingOrderByColumnIndex                          Integer             Index of the column that will be used for ordering groups
* @sGroupingClass                                       String              Class that will be associated to the group row. Default - "group"
* @sGroupItemClass                                      String              Class that will be associated to the group row of group items. Default - "group-item"
* @bSetGroupingClassOnTR                                Boolean             If set class will be set to the TR instead of the TD withing the grouping TR
* @bHideGroupingColumn                                  Boolean             Hide column used for grouping once results are grouped. Default - true
* @bHideGroupingOrderByColumn                           Boolean             Hide column used for ordering groups once results are grouped. Default - true
* @sGroupBy                                             Enumeration         Type of grouping that should be applied. Values "name"(default), "letter", "year"
* @sGroupLabelPrefix                                    String              Prefix that will be added to each group cell
* @bExpandableGrouping                                  Boolean             Attach expand/collapse handlers to the grouping rows
* @bExpandSingleGroup                                   Boolean             Use accordon grouping
* @iExpandGroupOffset                                   Integer             Number of pixels to set scroll position above the currently selected group. If -1 scroll will be alligned to the table
* General settings
* @sDateFormat: "dd/MM/yyyy"                            String              Date format used for grouping
* @sEmptyGroupLabel                                     String              Lable that will be placed as group if grouping cells are empty. Default "-"

* Parameters used in the second level grouping
* @iGroupingColumnIndex2                                Integer             Index of the secondary column that will be used for grouping - default 0
* @sGroupingColumnSortDirection2                        Enumeration         Sort direction of the secondary group
* @iGroupingOrderByColumnIndex2                         Integer             Index of the column that will be used for ordering secondary groups
* @sGroupingClass2                                      String              Class that will be associated to the secondary group row. Default "subgroup"
* @sGroupItemClass2                                     String              Class that will be associated to the secondary group row of group items. Default "subgroup-item"
* @bHideGroupingColumn2                                 Boolean             Hide column used for secondary grouping once results are grouped. Default - true,
* @bHideGroupingOrderByColumn2                          Boolean             Hide column used for ordering secondary groups once results are grouped. Default - true,
* @sGroupBy2                                            Enumeration         Type of grouping that should be applied to secondary column. Values "name"(default), "letter", "year",
* @sGroupLabelPrefix2                                   String              Prefix that will be added to each secondary group cell
* @fnOnGrouped                                          Function            Function that is called when grouping is finished. Function has no parameters.
*/
(function ($) {

 "use strict";

    $.fn.rowGrouping = function (options) {

        function _fnOnGrouped() {

        }

        function _fnOnGroupCreated(oGroup, sGroup, iLevel) {
            ///<summary>
            ///Function called when a new grouping row is created(it should be overriden in properties)
            ///</summary>
        }

           function _fnOnGroupCompleted(oGroup, sGroup, iLevel) {
            ///<summary>
            ///Function called when a new grouping row is created(it should be overriden in properties)
            ///</summary>
        }

        function _getMonthName(iMonth) {
            var asMonths = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
            return asMonths[iMonth - 1];
        }

        var defaults = {

            iGroupingColumnIndex: 0,
            sGroupingColumnSortDirection: "",
            iGroupingOrderByColumnIndex: -1,
            sGroupingClass: "group",
                        sGroupItemClass: "group-item",
            bHideGroupingColumn: true,
            bHideGroupingOrderByColumn: true,
            sGroupBy: "name",
            sGroupLabelPrefix: "",
            fnGroupLabelFormat: function (label) { return label; },
            bExpandableGrouping: false,
            bExpandSingleGroup: false,
            iExpandGroupOffset: 100,
            asExpandedGroups: null,

            sDateFormat: "dd/MM/yyyy",
            sEmptyGroupLabel: "-",
            bSetGroupingClassOnTR: false,

            iGroupingColumnIndex2: -1,
            sGroupingColumnSortDirection2: "",
            iGroupingOrderByColumnIndex2: -1,
            sGroupingClass2: "subgroup",
            sGroupItemClass2: "subgroup-item",
            bHideGroupingColumn2: true,
            bHideGroupingOrderByColumn2: true,
            sGroupBy2: "name",
            sGroupLabelPrefix2: "",
            fnGroupLabelFormat2: function (label) { return label; },
            bExpandableGrouping2: false,

            fnOnGrouped: _fnOnGrouped,

            fnOnGroupCreated: _fnOnGroupCreated,
            fnOnGroupCompleted: _fnOnGroupCompleted,

            oHideEffect: null, // { method: "hide", duration: "fast", easing: "linear" },
            oShowEffect: null,//{ method: "show", duration: "slow", easing: "linear" }

                   bUseFilteringForGrouping: false // This is still work in progress option
        };
        return this.each(function (index, elem) {

            var oTable = $(elem).dataTable();

            var aoGroups = new Array();
            $(this).dataTableExt.aoGroups = aoGroups;

            function fnCreateGroupRow(sGroupCleaned, sGroup, iColspan) {
                var nGroup = document.createElement('tr');
                var nCell = document.createElement('td');
                nGroup.id = "group-id-" + oTable.attr("id") + "_" + sGroupCleaned;

                var oGroup = { id: nGroup.id, key: sGroupCleaned, text: sGroup, level: 0, groupItemClass: ".group-item-" + sGroupCleaned, dataGroup: sGroupCleaned, aoSubgroups: new Array() };



                if (properties.bSetGroupingClassOnTR) {
                    nGroup.className = properties.sGroupingClass + " " + sGroupCleaned;
                } else {
                    nCell.className = properties.sGroupingClass + " " + sGroupCleaned;
                }

                nCell.colSpan = iColspan;
                nCell.innerHTML = properties.sGroupLabelPrefix + properties.fnGroupLabelFormat(sGroup == "" ? properties.sEmptyGroupLabel : sGroup, oGroup );
                if (properties.bExpandableGrouping) {

                    if (!_fnIsGroupCollapsed(sGroupCleaned)) {
                        nCell.className += " expanded-group";
                        oGroup.state = "expanded";
                    } else {
                        nCell.className += " collapsed-group";
                        oGroup.state = "collapsed";
                    }
                    nCell.className += " group-item-expander";
                    $(nCell).attr('data-group', oGroup.dataGroup); //Fix provided by mssskhalsa (Issue 5)
                    $(nCell).attr("data-group-level", oGroup.level);
                    $(nCell).click(_fnOnGroupClick);
                }
                nGroup.appendChild(nCell);
                aoGroups[sGroupCleaned] = oGroup;
                oGroup.nGroup = nGroup;
                properties.fnOnGroupCreated(oGroup, sGroupCleaned, 1);
                return oGroup;
            }

            function _fnCreateGroup2Row(sGroup2, sGroupLabel, iColspan, oParentGroup) {

                var nGroup2 = document.createElement('tr');
                nGroup2.id = oParentGroup.id + "_" + sGroup2;
                var nCell2 = document.createElement('td');
                var dataGroup = oParentGroup.dataGroup + '_' + sGroup2;

                var oGroup = { id: nGroup2.id, key: sGroup2, text: sGroupLabel, level: oParentGroup.level + 1, groupItemClass: ".group-item-" + dataGroup,
                    dataGroup: dataGroup, aoSubgroups: new Array()
                };

                if (properties.bSetGroupingClassOnTR) {
                    nGroup2.className = properties.sGroupingClass2 + " " + sGroup2;
                } else {
                    nCell2.className = properties.sGroupingClass2 + " " + sGroup2;
                }

                nCell2.colSpan = iColspan;
                nCell2.innerHTML = properties.sGroupLabelPrefix2 + properties.fnGroupLabelFormat2(sGroupLabel == "" ? properties.sEmptyGroupLabel : sGroupLabel, oGroup);

                if (properties.bExpandableGrouping) {

                    nGroup2.className += " group-item-" + oParentGroup.dataGroup;
                }


                if (properties.bExpandableGrouping && properties.bExpandableGrouping2) {

                    if (!_fnIsGroupCollapsed(oGroup.dataGroup)) {
                        nCell2.className += " expanded-group";
                        oGroup.state = "expanded";
                    } else {
                        nCell2.className += " collapsed-group";
                        oGroup.state = "collapsed";
                    }
                    nCell2.className += " group-item-expander";
                    $(nCell2).attr('data-group', oGroup.dataGroup);
                    $(nCell2).attr("data-group-level", oGroup.level);
                    $(nCell2).click(_fnOnGroupClick);
                }

                nGroup2.appendChild(nCell2);

                oParentGroup.aoSubgroups[oGroup.dataGroup] = oGroup;
                aoGroups[oGroup.dataGroup] = oGroup;
                oGroup.nGroup = nGroup2;
                properties.fnOnGroupCreated(oGroup, sGroup2, 2);
                return oGroup;
            }

            function _fnIsGroupCollapsed(sGroup) {
                if (aoGroups[sGroup] != null)
                    return (aoGroups[sGroup].state == "collapsed");
                else
                    if (sGroup.indexOf("_") > -1)
                        true;
                    else
                                             if(bInitialGrouping && (asExpandedGroups==null || asExpandedGroups.length == 0))
                                                       return false;// initially if asExpandedGroups is empty - no one is collapsed
                                           else
                                                   return ($.inArray(sGroup, asExpandedGroups) == -1); //the last chance check asExpandedGroups
            }

            function _fnGetYear(x) {
                               if(x.length< (iYearIndex+iYearLength) )
                                        return x;
                              else
                                   return x.substr(iYearIndex, iYearLength);
            }
            function _fnGetGroupByName(x) {
                return x;
            }

            function _fnGetGroupByLetter(x) {
                return x.substr(0, 1);
            }

            function _fnGetGroupByYear(x) {
                return _fnGetYear(x);
                //return Date.parseExact(x, properties.sDateFormat).getFullYear();//slooooow
            }

            function _fnGetGroupByYearMonth(x) {
                //var date = Date.parseExact(x, "dd/MM/yyyy");
                //return date.getFullYear() + " / " + date.getMonthName();
                //return x.substr(iYearIndex, iYearLength) + '/' + x.substr(iMonthIndex, iMonthLength);
                return x.substr(iYearIndex, iYearLength) + ' ' + _getMonthName(x.substr(iMonthIndex, iMonthLength));
            }

            function _fnGetCleanedGroup(sGroup) {

                if (sGroup === "") return "-";
                return sGroup.toLowerCase().replace(/[^a-zA-Z0-9\u0080-\uFFFF]+/g, "-"); //fix for unicode characters (Issue 23)
                //return sGroup.toLowerCase().replace(/\W+/g, "-"); //Fix provided by bmathews (Issue 7)
            }

                       function _rowGroupingRowFilter(oSettings, aData, iDataIndex) {
                     ///<summary>Used to expand/collapse groups with DataTables filtering</summary>
                if (oSettings.nTable.id !== oTable[0].id) return true;
                var sColData = aData[properties.iGroupingColumnIndex];
                if (typeof sColData === "undefined")
                    sColData = aData[oSettings.aoColumns[properties.iGroupingColumnIndex].mDataProp];
                if (_fnIsGroupCollapsed(_fnGetCleanedGroup(sColData))) {
                    if (oTable.fnIsOpen(oTable.fnGetNodes(iDataIndex)))
                                   {
                                              if (properties.fnOnRowClosed != null) {
                            properties.fnOnRowClosed(this); //    $(this.cells[0].children[0]).attr('src', '../../Images/details.png');
                        }
                        oTable.fnClose(oTable.fnGetNodes(iDataIndex));
                    }
                    return false;
                };
                            return true;
            } //end of function _rowGroupingRowFilter


            function fnExpandGroup(sGroup) {
                ///<summary>Expand group if expanadable grouping is used</summary>

                      aoGroups[sGroup].state = "expanded";

                              $("td[data-group^='" + sGroup + "']").removeClass("collapsed-group");
                $("td[data-group^='" + sGroup + "']").addClass("expanded-group");


                              if(properties.bUseFilteringForGrouping)
                                {
                                      oTable.fnDraw();
                                       return;//Because rows are expanded with _rowGroupingRowFilter function
                         }

                             if (jQuery.inArray(sGroup, asExpandedGroups)==-1)
                    asExpandedGroups.push(sGroup);

                if (properties.oHideEffect != null)
                    $(".group-item-" + sGroup, oTable)
                                       [properties.oShowEffect.method](properties.oShowEffect.duration,
                                                                       properties.oShowEffect.easing,
                                                                 function () { });
                else
                    $(".group-item-" + sGroup, oTable).show();


            } //end of function fnExpandGroup

            function fnCollapseGroup(sGroup) {
                ///<summary>Collapse group if expanadable grouping is used</summary>

                            aoGroups[sGroup].state = "collapsed";
                          $("td[data-group^='" + sGroup + "']").removeClass("expanded-group");
                $("td[data-group^='" + sGroup + "']").addClass("collapsed-group");

                               if(properties.bUseFilteringForGrouping)
                                {
                                      oTable.fnDraw();
                                       return;//Because rows are expanded with _rowGroupingRowFilter function
                         }
                              //var index = $.inArray(sGroup, asExpandedGroups);
                //asExpandedGroups.splice(index, 1);

                $('.group-item-' + sGroup).each(function () {
                    //Issue 24 - Patch provided by Bob Graham
                    if (oTable.fnIsOpen(this)) {
                        if (properties.fnOnRowClosed != null) {
                            properties.fnOnRowClosed(this); //    $(this.cells[0].children[0]).attr('src', '../../Images/details.png');
                        }
                        oTable.fnClose(this);
                    }
                });

                if (properties.oHideEffect != null)
                    $(".group-item-" + sGroup, oTable)
                                    [properties.oHideEffect.method](properties.oHideEffect.duration,
                                                                       properties.oHideEffect.easing,
                                                                 function () { });
                else
                    $(".group-item-" + sGroup, oTable).hide();

            } //end of function fnCollapseGroup

            function _fnOnGroupClick(e) {
                ///<summary>
                ///Function that is called when user click on the group cell in order to
                ///expand of collapse group
                ///</summary>

                //var sGroup = $(this).attr("rel");
                var sGroup = $(this).attr("data-group");
                var iGroupLevel = $(this).attr("data-group-level");

                var bIsExpanded = !_fnIsGroupCollapsed(sGroup);
                if (properties.bExpandSingleGroup) {
                    if (!bIsExpanded) {
                        var sCurrentGroup = $("td.expanded-group").attr("data-group");
                        fnCollapseGroup(sCurrentGroup);
                        fnExpandGroup(sGroup);

                        if (properties.iExpandGroupOffset != -1) {
                            var position = $("#group-id-" + oTable.attr("id") + "_" + sGroup).offset().top - properties.iExpandGroupOffset;
                            window.scroll(0, position);
                        } else {
                            var position = oTable.offset().top;
                            window.scroll(0, position);
                        }
                    }
                } else {
                    if (bIsExpanded) {
                        fnCollapseGroup(sGroup);
                    } else {
                        fnExpandGroup(sGroup);
                    }
                }
                e.preventDefault();

            }; //end function _fnOnGroupClick


                     function _fnDrawCallBackWithGrouping (oSettings) {

                if (oTable.fnSettings().oFeatures.bServerSide)
                    bInitialGrouping = true;
                var bUseSecondaryGrouping = false;

                if (properties.iGroupingColumnIndex2 != -1)
                    bUseSecondaryGrouping = true;

                //-----Start grouping

                if (oSettings.aiDisplayMaster.length == 0) { //aiDisplay
                    return;
                }

                var nTrs = $('tbody tr', oTable);
                var iColspan = 0; //nTrs[0].getElementsByTagName('td').length;
                for (var iColIndex = 0; iColIndex < oSettings.aoColumns.length; iColIndex++) {
                    if (oSettings.aoColumns[iColIndex].bVisible)
                        iColspan += 1;
                }
                var sLastGroup = null;
                var sLastGroup2 = null;
                if (oSettings.aiDisplay.length > 0) {
                    for (var i = 0; i < nTrs.length; i++) {


                        var iDisplayIndex = oSettings._iDisplayStart + i;
                        if (oTable.fnSettings().oFeatures.bServerSide)
                            iDisplayIndex = i;
                        var sGroupData = "";
                        var sGroup = null;
                        var sGroupData2 = "";
                        var sGroup2 = null;

                        //Issue 31 - Start fix provided by Fabien Taysse
//                      sGroupData = oSettings.aoData[oSettings.aiDisplay[iDisplayIndex]]._aData[properties.iGroupingColumnIndex];
//                      if (sGroupData == undefined)
//                          sGroupData = oSettings.aoData[oSettings.aiDisplay[iDisplayIndex]]._aData[oSettings.aoColumns[properties.iGroupingColumnIndex].mDataProp];
                        sGroupData = this.fnGetData(nTrs[i], properties.iGroupingColumnIndex);
                        //Issue 31 - End fix provided by Fabien Taysse

                        var sGroup = sGroupData;
                        if (properties.sGroupBy != "year")
                            sGroup = fnGetGroup(sGroupData);

                        if (bUseSecondaryGrouping) {
                            sGroupData2 = oSettings.aoData[oSettings.aiDisplay[iDisplayIndex]]._aData[properties.iGroupingColumnIndex2];
                            if (sGroupData2 == undefined)
                                sGroupData2 = oSettings.aoData[oSettings.aiDisplay[iDisplayIndex]]._aData[oSettings.aoColumns[properties.iGroupingColumnIndex2].mDataProp];
                            if (properties.sGroupBy2 != "year")
                                sGroup2 = fnGetGroup(sGroupData2);
                        }


                        if (sLastGroup == null || _fnGetCleanedGroup(sGroup) != _fnGetCleanedGroup(sLastGroup)) { // new group encountered (or first of group)
                            var sGroupCleaned = _fnGetCleanedGroup(sGroup);

                            if(sLastGroup != null)
                            {
                              properties.fnOnGroupCompleted(aoGroups[_fnGetCleanedGroup(sLastGroup)]);
                            }
                                                   /*
                            if (properties.bExpandableGrouping && bInitialGrouping) {
                                if (properties.bExpandSingleGroup) {
                                    if (asExpandedGroups.length == 0)
                                        asExpandedGroups.push(sGroupCleaned);
                                } else {
                                    asExpandedGroups.push(sGroupCleaned);
                                }
                            }
                                                   */
                                                     if(properties.bAddAllGroupsAsExpanded && jQuery.inArray(sGroupCleaned,asExpandedGroups) == -1)
                                                         asExpandedGroups.push(sGroupCleaned);

                            var oGroup = fnCreateGroupRow(sGroupCleaned, sGroup, iColspan);
                            var nGroup = oGroup.nGroup;

                                                    if(nTrs[i].parentNode!=null)
                                                           nTrs[i].parentNode.insertBefore(nGroup, nTrs[i]);
                                                      else
                                                           $(nTrs[i]).before(nGroup);

                            sLastGroup = sGroup;
                            sLastGroup2 = null; //to reset second level grouping





                        } // end if (sLastGroup == null || sGroup != sLastGroup)

                                           $(nTrs[i]).attr("data-group", aoGroups[sGroupCleaned].dataGroup);

                        $(nTrs[i]).addClass(properties.sGroupItemClass);
                        $(nTrs[i]).addClass("group-item-" + sGroupCleaned);
                        if (properties.bExpandableGrouping) {
                            if (_fnIsGroupCollapsed(sGroupCleaned) && !properties.bUseFilteringForGrouping) {
                                $(nTrs[i]).hide();
                            }
                        }


                        if (bUseSecondaryGrouping) {

                            if (sLastGroup2 == null || _fnGetCleanedGroup(sGroup2) != _fnGetCleanedGroup(sLastGroup2)) {
                                var sGroup2Id = _fnGetCleanedGroup(sGroup) + '-' + _fnGetCleanedGroup(sGroup2);
                                var oGroup2 = _fnCreateGroup2Row(sGroup2Id, sGroup2, iColspan, aoGroups[sGroupCleaned])
                                var nGroup2 = oGroup2.nGroup;
                                nTrs[i].parentNode.insertBefore(nGroup2, nTrs[i]);

                                sLastGroup2 = sGroup2;
                            }

                            $(nTrs[i]).attr("data-group", oGroup2.dataGroup)
                                                                           .addClass(properties.sGroupItemClass2)
                                        .addClass("group-item-" + oGroup2.dataGroup);
                        } //end if (bUseSecondaryGrouping)



                    } // end for (var i = 0; i < nTrs.length; i++)
                }; // if (oSettings.aiDisplay.length > 0)

                               if(sLastGroup != null)
                     {
                                properties.fnOnGroupCompleted(aoGroups[_fnGetCleanedGroup(sLastGroup)]);
                         }


                //-----End grouping
                properties.fnOnGrouped(aoGroups);

                bInitialGrouping = false;

            }; // end of _fnDrawCallBackWithGrouping = function (oSettings)


            //var oTable = this;
            var iYearIndex = 6;
            var iYearLength = 4;
            var asExpandedGroups = new Array();
            var bInitialGrouping = true;

            var properties = $.extend(defaults, options);

            if (properties.iGroupingOrderByColumnIndex == -1) {
                properties.bCustomColumnOrdering = false;
                properties.iGroupingOrderByColumnIndex = properties.iGroupingColumnIndex;
            } else {
                properties.bCustomColumnOrdering = true;
            }

            if (properties.sGroupingColumnSortDirection == "") {
                if (properties.sGroupBy == "year")
                    properties.sGroupingColumnSortDirection = "desc";
                else
                    properties.sGroupingColumnSortDirection = "asc";
            }


            if (properties.iGroupingOrderByColumnIndex2 == -1) {
                properties.bCustomColumnOrdering2 = false;
                properties.iGroupingOrderByColumnIndex2 = properties.iGroupingColumnIndex2;
            } else {
                properties.bCustomColumnOrdering2 = true;
            }

            if (properties.sGroupingColumnSortDirection2 == "") {
                if (properties.sGroupBy2 == "year")
                    properties.sGroupingColumnSortDirection2 = "desc";
                else
                    properties.sGroupingColumnSortDirection2 = "asc";
            }



            iYearIndex = properties.sDateFormat.toLowerCase().indexOf('yy');
            iYearLength = properties.sDateFormat.toLowerCase().lastIndexOf('y') - properties.sDateFormat.toLowerCase().indexOf('y') + 1;

            var iMonthIndex = properties.sDateFormat.toLowerCase().indexOf('mm');
            var iMonthLength = properties.sDateFormat.toLowerCase().lastIndexOf('m') - properties.sDateFormat.toLowerCase().indexOf('m') + 1;

            var fnGetGroup = _fnGetGroupByName;
            switch (properties.sGroupBy) {
                case "letter": fnGetGroup = _fnGetGroupByLetter;
                    break;
                case "year": fnGetGroup = _fnGetGroupByYear;
                    break;
                case "month": fnGetGroup = _fnGetGroupByYearMonth;
                    break;
                default: fnGetGroup = _fnGetGroupByName;
                    break;
            }


            if (properties.asExpandedGroups != null) {
                if (properties.asExpandedGroups == "NONE") {
                    properties.asExpandedGroups = [];
                    asExpandedGroups = properties.asExpandedGroups;
                    bInitialGrouping = false;
                } else if (properties.asExpandedGroups == "ALL") {
                                     properties.bAddAllGroupsAsExpanded = true;
                } else if (properties.asExpandedGroups.constructor == String) {
                    var currentGroup = properties.asExpandedGroups;
                    properties.asExpandedGroups = new Array();
                    properties.asExpandedGroups.push(_fnGetCleanedGroup(currentGroup));
                    asExpandedGroups = properties.asExpandedGroups;
                    bInitialGrouping = false;
                } else if (properties.asExpandedGroups.constructor == Array) {
                    for (var i = 0; i < properties.asExpandedGroups.length; i++) {
                        asExpandedGroups.push(_fnGetCleanedGroup(properties.asExpandedGroups[i]));
                        if (properties.bExpandSingleGroup)
                            break;
                    }
                    bInitialGrouping = false;
                }
            }else{
                            properties.asExpandedGroups = new Array();
                             properties.bAddAllGroupsAsExpanded = true;
                     }
                      if(properties.bExpandSingleGroup){
                         var nTrs = $('tbody tr', oTable);
                          var sGroupData = oTable.fnGetData(nTrs[0], properties.iGroupingColumnIndex);

                          var sGroup = sGroupData;
                if (properties.sGroupBy != "year")
                    sGroup = fnGetGroup(sGroupData);

                              var sGroupCleaned = _fnGetCleanedGroup(sGroup);
                                properties.asExpandedGroups = new Array();
                             properties.asExpandedGroups.push(sGroupCleaned);

                      }

            oTable.fnSetColumnVis(properties.iGroupingColumnIndex, !properties.bHideGroupingColumn);
            if (properties.bCustomColumnOrdering) {
                oTable.fnSetColumnVis(properties.iGroupingOrderByColumnIndex, !properties.bHideGroupingOrderByColumn);
            }
            if (properties.iGroupingColumnIndex2 != -1) {
                oTable.fnSetColumnVis(properties.iGroupingColumnIndex2, !properties.bHideGroupingColumn2);
            }
            if (properties.bCustomColumnOrdering2) {
                oTable.fnSetColumnVis(properties.iGroupingOrderByColumnIndex2, !properties.bHideGroupingOrderByColumn2);
            }
            oTable.fnSettings().aoDrawCallback.push({
                "fn": _fnDrawCallBackWithGrouping,
                "sName": "fnRowGrouping"
            });

            var aaSortingFixed = new Array();
            aaSortingFixed.push([properties.iGroupingOrderByColumnIndex, properties.sGroupingColumnSortDirection]);
            if (properties.iGroupingColumnIndex2 != -1) {
                aaSortingFixed.push([properties.iGroupingOrderByColumnIndex2, properties.sGroupingColumnSortDirection2]);
            } // end of if (properties.iGroupingColumnIndex2 != -1)

            oTable.fnSettings().aaSortingFixed = aaSortingFixed;
            //Old way
            //oTable.fnSettings().aaSortingFixed = [[properties.iGroupingOrderByColumnIndex, properties.sGroupingColumnSortDirection]];

            switch (properties.sGroupBy) {
                case "name":
                    break;


                case "letter":

                    /* Create an array with the values of all the input boxes in a column */
                    oTable.fnSettings().aoColumns[properties.iGroupingOrderByColumnIndex].sSortDataType = "rg-letter";
                    $.fn.dataTableExt.afnSortData['rg-letter'] = function (oSettings, iColumn) {
                        var aData = [];
                        $('td:eq(' + iColumn + ')', oSettings.oApi._fnGetTrNodes(oSettings)).each(function () {
                            aData.push(_fnGetGroupByLetter(this.innerHTML));
                        });
                        return aData;
                    }


                    break;


                case "year":
                    /* Create an array with the values of all the input boxes in a column */
                    oTable.fnSettings().aoColumns[properties.iGroupingOrderByColumnIndex].sSortDataType = "rg-date";
                    $.fn.dataTableExt.afnSortData['rg-date'] = function (oSettings, iColumn) {
                        var aData = [];
                                              var nTrs = oSettings.oApi._fnGetTrNodes(oSettings);
                                            for(i = 0; i< nTrs.length; i++)
                                                {
                                                      aData.push(_fnGetYear( oTable.fnGetData( nTrs[i], iColumn) ));
                                         }

/*
                        $('td:eq(' + iColumn + ')', oSettings.oApi._fnGetTrNodes(oSettings)).each(function () {
                            aData.push(_fnGetYear(this.innerHTML));
                        });
*/
                        return aData;
                    }
                    break;
                default:
                    break;

            } // end of switch (properties.sGroupBy)

                     if(properties.bUseFilteringForGrouping)
                                        $.fn.dataTableExt.afnFiltering.push(_rowGroupingRowFilter);

            oTable.fnDraw();



        });
    };
})(jQuery);

Lines 274-280 tr.even td, tr.even.highlight td { Link Here

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

Lines 1-6 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table-footer.inc (-1 / +1 lines)
1	<tfoot>	1	<tfoot>
2	<tr>	2	<tr>
3	<td colspan="6" style="text-align: right; font-weight:bold;">Totals:</td>	3	<td colspan="8" style="text-align: right; font-weight:bold;">Totals:</td>
4	<td>[% totaldue %]</td>	4	<td>[% totaldue %]</td>
5	<td>[% totalprice %]</td>	5	<td>[% totalprice %]</td>
6	<td colspan="3"><div class="date-select">	6	<td colspan="3"><div class="date-select">




<script type="text/javascript">
//<![CDATA[
    var CIRCULATION_RETURNED = _("Returned");
    var CIRCULATION_NOT_RETURNED = _("Unable to return");
    var CIRCULATION_RENEWED_DUE = _("Renewed, due:");
    var CIRCULATION_RENEW_FAILED = _("Renew failed:")
    var NOT_CHECKED_OUT = _("not checked out");
    var TOO_MANY_RENEWALS = _("too many renewals");
    var ON_RESERVE = _("on reserve");
    var REASON_UNKNOWN = _("reason unkown");
    var TODAYS_CHECKOUTS = _("Today's checkouts");
    var PREVIOUS_CHECKOUTS = _("Previous checkouts");
    var BY = _("by");
    var ON_HOLD = _("On hold");
    var NOT_RENEWABLE = _("Not renewable");
    var OF = _("of");
    var RENEWALS_REMAINING = _("renewals remaining");
    var HOLD_IS = _("Hold is");
    var SUSPENDED = _("suspended");
    var UNTIL = _("until");
    var ITEM_IS = _("Item is");
    var WAITING = _("waiting");
    var AT = _("at");
    var IN_TRANSIT = _("in transit");
    var FROM = _("from");
    var NOT_TRANSFERRED_YET = _("Item hasn't been transferred yet from");
    var NO = _("No");
    var YES = _("Yes");
//]]>
</script>




$(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;
    });
    $("#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;
    });

    // 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");
        }
    });
    $(document).on("change", '.checkin', function(){
        if ( $(this).is(":checked") ) {
            $( "#renew_" + $(this).val() ).removeAttr("checked");
        }
    });

    // 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();
          });
        }
    });

    // Handle renewals and returns
    $("#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/svc/checkin.pl", params, function( data ) {
                id = "#checkin_" + data.itemnumber;

                content = "";
                if ( data.returned ) {
                    content = CIRCULATION_RETURNED;
                } else {
                    content = CIRCULATION_NOT_RETURNED;
                }

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

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

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

            $(this).parent().parent().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/svc/renew.pl", params, function( data ) {
                var id = "#renew_" + data.itemnumber;

                var content = "";
                if ( data.renew_okay ) {
                    content = CIRCULATION_RENEWED_DUE + " " + data.date_due;
                } else {
                    content = CIRCULATION_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;
    });

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

    var issuesTable;
    var drawn = 0;
    issuesTable = $("#issues-table").dataTable({
        "sDom": "<'row-fluid'<'span6'><'span6'>r>t<'row-fluid'>t",
        "aaSorting": [[ 0, "desc" ]],
        "aoColumns": [
            {
                "mDataProp": function( oObj ) {
                    if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
                        return "<strong>" + TODAYS_CHECKOUTS + "</strong>";
                    } else {
                        return "<strong>" + PREVIOUS_CHECKOUTS + "</strong>";
                    }
                }
            },
            {
                "mDataProp": "date_due",
                "bVisible": false,
            },
            {
                "iDataSort": 1, // Sort on hidden unformatted date due column
                "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>";
                    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>";
                    }

                    content += "</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": false,
        "sAjaxSource": '/cgi-bin/koha/svc/checkouts.pl',
        "fnServerData": function ( sSource, aoData, fnCallback ) {
            aoData.push( { "name": "borrowernumber", "value": borrowernumber } );

            $.getJSON( sSource, aoData, function (json) {
                fnCallback(json)
            } );
        },
        "fnInitComplete": function(oSettings) {
            // Disable rowGrouping plugin after first use
            // so any sorting on the table doesn't use it
            var oSettings = issuesTable.fnSettings();

            for (f = 0; f < oSettings.aoDrawCallback.length; f++) {
                if (oSettings.aoDrawCallback[f].sName == 'fnRowGrouping') {
                    oSettings.aoDrawCallback.splice(f, 1);
                    break;
                }
            }

            oSettings.aaSortingFixed = null;
        },
    }).rowGrouping(
        {
            iGroupingOrderByColumnIndex: 0,
            sGroupingColumnSortDirection: "desc"
        }
    );

    if ( $("#issues-table").length ) {
        $("#issues-table_processing").position({
            of: $( "#issues-table" ),
            collision: "none"
        });
    }

    // 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/svc/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)
                    } );
                },
            });
        }
    });

    if ( $("#relatives-issues-table").length ) {
        $("#relatives-issues-table_processing").position({
            of: $( "#relatives-issues-table" ),
            collision: "none"
        });
    }

    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() {
    // Don't load holds table unless it is clicked on
    var holdsTable;
    $("#holds-tab").click( function() {
        if ( ! holdsTable ) {
            holdsTable = $("#holds-table").dataTable({
                "sDom": "<'row-fluid'<'span6'><'span6'>r>t<'row-fluid'>t",
                "aoColumns": [
                    {
                        "mDataProp": "reservedate_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": function( oObj ) {
                            return oObj.itemcallnumber || "";
                        }
                    },
                    {
                        "mDataProp": function( oObj ) {
                            var data = "";

                            if ( oObj.suspend == 1 ) {
                                data += "<p>" + HOLD_IS + " <strong> " + SUSPENDED + " </strong>";
                                if ( oObj.suspend_until ) {
                                    data += " " + UNTIL + " " + oObj.suspend_until_formatted;
                                }
                                data += "</p>";
                            }

                            if ( oObj.barcode ) {
                                data += "<em>";
                                if ( oObj.found == "W" ) {
                                    data += ITEM_IS + " <strong> " + WAITING + " </strong>";

                                    if ( ! oObj.waiting_here ) {
                                        data += " " + AT + " " + oObj.waiting_at;
                                    }
                                } else if ( oObj.transferred ) {
                                    data += ITEM_IS + " <strong> " + IN_TRANSIT + " </strong> " + FROM + oObj.from_branch;
                                } else if ( oObj.not_transferred ) {
                                    data += NOT_TRANSFERRED_YET + " " + oObj.not_transferred_by;
                                }                                 data += "</em>";

                                data += " <a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
                                     + oObj.biblionumber + "'>" + oObj.barcode + "</a>";
                            }

                            return data;
                        }
                    },
                    { "mDataProp": "expirationdate_formatted" },
                    {
                        "mDataProp": function( oObj ) {
                            if ( oObj.priority && parseInt( oObj.priority ) && parseInt( oObj.priority ) > 0 ) {
                                return oObj.priority;
                            } else {
                                return "";
                            }
                        }
                    },
                    {
                        "mDataProp": function( oObj ) {
                            return "<select name='rank-request'>"
                                 + "<option value='n'>" + NO + "</option>"
                                 + "<option value='del'>" + YES  + "</option>"
                                 + "</select>"
                                 + "<input type='hidden' name='biblionumber' value='" + oObj.biblionumber + "'>"
                                 + "<input type='hidden' name='borrowernumber' value='" + borrowernumber + "'>"
                                 + "<input type='hidden' name='reserve_id' value='" + oObj.reserve_id + "'>";
                        }
                    }
                ],
                "bPaginate": false,
                "bProcessing": true,
                "bServerSide": true,
                "sAjaxSource": '/cgi-bin/koha/svc/holds.pl',
                "fnServerData": function ( sSource, aoData, fnCallback ) {
                    aoData.push( { "name": "borrowernumber", "value": borrowernumber } );

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

            if ( $("#holds-table").length ) {
                $("#holds-table_processing").position({
                    of: $( "#holds-table" ),
                    collision: "none"
                });
            }
        }
    });

});




$(document).ready(function() {
    $("#CheckAllExports").on("click",function(){
        $(".export:visible").attr("checked", "checked" );
    $("#renew_all").on("click",function(){
        allcheckboxes.checkCheckboxes(":input[name*=items]");
        allcheckboxes.unCheckCheckboxes(":input[name*=barcodes]");
    });
    $("#CheckAllitems").on("click",function(){
        allcheckboxes.checkCheckboxes(":input[name*=items]");
        allcheckboxes.unCheckCheckboxes(":input[name*=barcodes]"); return false;
    });
    $("#CheckNoitems").on("click",function(){
        allcheckboxes.unCheckCheckboxes(":input[name*=items]"); return false;
    });
    $("#CheckAllreturns").on("click",function(){
        allcheckboxes.checkCheckboxes(":input[name*=barcodes]");
        allcheckboxes.unCheckCheckboxes(":input[name*=items]"); return false;
    });
    $("#CheckNoreturns" ).on("click",function(){
        allcheckboxes.unCheckCheckboxes(":input[name*=barcodes]"); return false;
    });

    $("#CheckAllexports").on("click",function(){
        allcheckboxes.checkCheckboxes(":input[name*=biblionumbers]");
        return false;
    });
    $("#UncheckAllExports").on("click",function(){
        $(".export:visible").removeAttr("checked");
        return false;
    });

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

        allcheckboxes.unCheckCheckboxes(":input[name*=barcodes]");
    });
    $("#relCheckAllitems").on("click",function(){
        allcheckboxes.checkCheckboxes(":input[name*=items]");
        allcheckboxes.unCheckCheckboxes(":input[name*=barcodes]"); return false;
    });
    $("#relCheckNoitems").on("click",function(){
        allcheckboxes.unCheckCheckboxes(":input[name*=items]"); return false;
    });
    $("#relCheckAllreturns").on("click",function(){
        allcheckboxes.checkCheckboxes(":input[name*=barcodes]");
        allcheckboxes.unCheckCheckboxes(":input[name*=items]"); return false;
    });
    $("#relCheckNoreturns").on("click",function(){
        allcheckboxes.unCheckCheckboxes(":input[name*=barcodes]"); return false;
    });
    $("#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;
    });

    $("td").on("click",function(e){
        if(e.target.tagName.toLowerCase() == 'td'){
          $(this).find("input:checkbox:visible").each( function() {
            $(this).click();
          });
        }
    });
});

function export_checkouts(format) {

    } 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) {

        return false;
     }
}

// prevent adjacent checkboxes from being checked simultaneously
function radioCheckBox(box){
    box.parents("td").siblings().find("input:checkbox.radio").each(function(){
        $(this).removeAttr("checked");
    });
 }




                  desc: latest to earliest
            - due date.
        -
            - pref: UseTablesortForCirc
              choices:
                  yes: "Enable"
                  no: "Don't enable"
            - "the sorting of current patron checkouts on the circulation screen. <br/>NOTE: Enabling this function may slow down circulation time for patrons with many checkouts."
        -
            - pref: soundon
              choices: 
                 yes: "Enable"




</title>
[% INCLUDE 'doc-head-close.inc' %]
[% INCLUDE 'calendar.inc' %]

<link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" />
[% INCLUDE 'datatables.inc' %][% END %]
<script type="text/javascript" src="[% interface %]/lib/jquery/plugins/jquery.checkboxes.min.js"></script>
[% INCLUDE 'strings.inc' %]
<script type="text/javascript" src="[% interface %]/lib/jquery/plugins/jquery-ui-timepicker-addon.min.js"></script>
[% INCLUDE 'timepicker.inc' %]
<script type="text/javascript" src="[% interface %]/lib/jquery/plugins/jquery.dataTables.rowGrouping.js"></script>
<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" src="[% themelang %]/js/holds.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": "anti-the" },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": "anti-the" },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 %]
    [% IF AutoResumeSuspendedHolds %]
        $("#suspend_until").datepicker("option", "minDate", 1); // require that hold suspended until date is after today
    [% END %]
});
//]]>
</script>
</head>

    [% ELSE %]
	    <input type="text" name="barcode" id="barcode" class="barcode focus" size="14" />
    [% END %]
    <button type="submit" class="btn">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;" >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 ( displayrelissues ) %]
<li><a href="#relissues">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/reserve/renewscript.pl" method="post" class="checkboxed">
    <input type="hidden" value="circ" name="destination" />
    <input type="hidden" name="cardnumber" value="[% cardnumber %]" />
    <input type="hidden" name="borrowernumber" value="[% borrowernumber %]" />
    <input type="hidden" name="branch" value="[% branch %]" />
        <table id="issuest">
    <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="CheckAllitems">select all</a> | <a href="#" id="CheckNoitems">none</a></p></th>
        <th scope="col">Check in <p class="column-tool"><a href="#" id="CheckAllreturns">select all</a> | <a href="#" id="CheckNoreturns">none</a></p></th>
        [% IF ( exports_enabled ) %]
          <th scope="col">Export <p class="column-tool"><a href="#" id="CheckAllexports">select all</a> | <a href="#" id="CheckNoexports">none</a></p></th>
        [% END %]
    </li>
[% IF ( todayissues ) %]
[% INCLUDE 'checkouts-table-footer.inc' %]
	<tbody>

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

    [% IF relatives_issues_count %]
        <li><a id="relatives-issues-tab" href="#relatives-issues">Relatives' checkouts</a></li>
            [% 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 && !todayissue.renew_error_too_soon %]
                    <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>
            [% ELSIF ( todayissue.renew_error_too_many ) %]
                Not renewable
            [% ELSIF ( todayissue.renew_error_too_soon ) %]
                No renewal before [% todayissue.soonestrenewdate %]
                <span class="renewals">([% todayissue.renewsleft %] of [% todayissue.renewsallowed %] renewals remaining)</span>
            [% END %]
            [% IF ( todayissue.can_confirm ) %]
                </span>
            [% END %]
        [% 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>

    <li>
        [% IF ( holds_count ) %]
            <a href="#reserves" id="holds-tab">[% holds_count %] Hold(s)</a>
            [% IF ( previssue.damaged ) %]
                <span class="dmg">[% AuthorisedValues.GetByCode( 'DAMAGED', previssue.damaged ) %]</span>
            [% END %]
        </td>
        <td><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% previssue.biblionumber %]&amp;type=intra"><strong>[% previssue.title |html %][% FOREACH subtitl IN previssue.subtitle %] [% subtitl.subfield %][% END %]</strong></a>[% IF ( previssue.author ) %], by [% previssue.author %][% END %] [% IF ( previssue.itemnotes ) %]- [% previssue.itemnotes %][% END %] <a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% previssue.biblionumber %]&amp;itemnumber=[% previssue.itemnumber %]#item[% previssue.itemnumber %]">[% previssue.barcode %]</a></td>
        <td>
            [% previssue.itemtype %]
        </td>
        <td><span title="[% previssue.displaydate_sort %]">[% previssue.displaydate %]</span></td>
        [% IF ( previssue.multiple_borrowers ) %]<td>[% previssue.firstname %] [% previssue.surname %]</td>[% END %]
        <td>[% previssue.issuingbranchname %]</td>
        <td>[% previssue.itemcallnumber %]</td>
        <td>[% previssue.charge %]</td>
        <td>[% previssue.replacementprice %]</td>
      [% IF ( previssue.renew_failed ) %]
            <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 && !previssue.renew_error_too_soon %]
                    <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>
            [% ELSIF ( previssue.renew_error_too_many ) %]
                Not renewable
            [% ELSIF ( previssue.renew_error_too_soon ) %]
                No renewal before [% previssue.soonestrenewdate %]
                <span class="renewals">([% previssue.renewsleft %] of [% previssue.renewsallowed %] renewals remaining)</span>
            [% END %]
            [% IF ( previssue.can_confirm ) %]
                </span>
            [% END %]
        [% END %]
        </td>
        [% END %]
		  [% IF ( previssue.return_failed ) %]
            <td class="problem">Check-in failed</td>
        [% ELSE %]
            <a href="#reserves" id="holds-tab">0 Holds</a>
               <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 %]
    </li>
    </form>
[% ELSE %]
<p>Patron has nothing checked out.</p>
[% END %]

</div>


    <li><a id="debarments-tab-link" href="#reldebarments">[% debarments.size %] Restrictions</a></li>
</ul>
    <table id="relissuest">
    <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>

<!-- SUMMARY : TODAY & PREVIOUS ISSUES -->
<div id="checkouts">
    [% IF ( issuecount ) %]
        <table id="issues-table">
            <thead>
                <tr>
                    <th scope="col">&nbsp;</th>
                    <th scope="col">Due date</th>
                    <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>

        <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 %]
            <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>
        <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 %]
        <p>Patron has nothing checked out.</p>
    [% 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>

[% 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>
        </table>
    </div>
[% END %]

[% INCLUDE borrower_debarments.inc %]

<div id="reserves">
[% IF ( holds_count ) %]
    <form action="/cgi-bin/koha/reserve/modrequest.pl" method="post">
        <input type="hidden" name="from" value="circ" />
        <table id="holds-table" style="width: 100% !Important;">
            <thead>
                <tr>
                    <th>Hold date</th>
                    <th>Title</th>
                    <th>Call number</th>
                    <th>Barcode</th>
                    <th>Expiration</th>
                    <th>Priority</th>
                    <th>Delete?</th>
                </tr>
            </thead>
        </table>

        <fieldset class="action">
            <input type="submit" class="cancel" name="submit" value="Cancel marked holds" />
        </fieldset>
					<td><em>[% IF ( reservloo.barcodereserv ) %]Item [% reservloo.barcodereserv %]
                        [% END %][% IF ( reservloo.waiting ) %] <strong>waiting at [% reservloo.waitingat %]</strong>
                        [% END %]
                        [% IF ( reservloo.transfered ) %] <strong>in transit</strong> from
                        [% reservloo.frombranch %] since [% reservloo.datesent %]
                        [% END %]
                        [% IF ( reservloo.nottransfered ) %] hasn't been transferred yet from [% reservloo.nottransferedby %]</i>
                        [% END %]</em></td>
                    <td>[% reservloo.expirationdate | $KohaDates %]</td>
                    <td>
                        [% IF ( reservloo.waitingposition ) %]<b> [% reservloo.waitingposition %] </b>[% END %]
                    </td>
				<td><select name="rank-request">
                    <option value="n">No</option>
                    <option value="del">Yes</option>
                </select>
                <input type="hidden" name="biblionumber" value="[% reservloo.biblionumber %]" />
                <input type="hidden" name="borrowernumber" value="[% borrowernumber %]" />
                <input type="hidden" name="reserve_id" value="[% reservloo.reserve_id %]" />
            </td>
            <td>[% IF ( reservloo.suspend ) %]Suspended [% IF ( reservloo.suspend_until ) %] until [% reservloo.suspend_until | $KohaDates %][% END %][% END %]</td>
            </tr>
        [% END %]</tbody>
    </table>
            <fieldset class="action"><input type="submit" class="cancel" name="submit" value="Cancel marked holds" /></fieldset>
    </form>

    [% IF SuspendHoldsIntranet %]

Lines 9-21 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/members/moremember.tt (-280 / +124 lines)
9	</title>	9	</title>
10	[% INCLUDE 'doc-head-close.inc' %]	10	[% INCLUDE 'doc-head-close.inc' %]
11	[% INCLUDE 'calendar.inc' %]	11	[% INCLUDE 'calendar.inc' %]
12	<link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" />	12	<link rel="stylesheet" type="text/css" href="[% interface %]/[% theme %]/en/css/datatables.css" />
13	[% INCLUDE 'datatables.inc' %]	13	[% INCLUDE 'datatables.inc' %]
14	<script type="text/javascript" src="[% interface %]/lib/jquery/plugins/jquery.checkboxes.min.js"></script>	14	[% INCLUDE 'strings.inc' %]
		15	<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.checkboxes.min.js"></script>
15	<script type="text/javascript" src="[% interface %]/lib/jquery/plugins/jquery-ui-timepicker-addon.min.js"></script>	16	<script type="text/javascript" src="[% interface %]/lib/jquery/plugins/jquery-ui-timepicker-addon.min.js"></script>
16	[% INCLUDE 'timepicker.inc' %]	17	[% INCLUDE 'timepicker.inc' %]
		18	<script type="text/javascript" src="[% interface %]/lib/jquery/plugins/jquery.dataTables.rowGrouping.js"></script>
		19	<script type="text/javascript" src="[% themelang %]/js/checkouts.js"></script>
		20	<script type="text/javascript" src="[% themelang %]/js/holds.js"></script>
17	<script type="text/JavaScript">	21	<script type="text/JavaScript">
18	//<![CDATA[	22	//<![CDATA[
		23	/* Set some variable needed in circulation.js */
		24	var interface = "[% interface %]";
		25	var theme = "[% theme %]";
		26	var borrowernumber = "[% borrowernumber %]";
		27	var branchcode = "[% branch %]";
		28	var exports_enabled = "[% exports_enabled %]";
		29	var AllowRenewalLimitOverride = [% CAN_user_circulate_override_renewals && AllowRenewalLimitOverride %];
		30	var relatives_borrowernumbers = new Array();
		31	[% FOREACH b IN relatives_borrowernumbers %]
		32	relatives_borrowernumbers.push("[% b %]");
		33	[% END %]
		34
19	$(document).ready(function() {	35	$(document).ready(function() {
20	$('#finesholdsissues').tabs({	36	$('#finesholdsissues').tabs({
21	// Correct table sizing for tables hidden in tabs	37	// Correct table sizing for tables hidden in tabs
Lines 27-49 $(document).ready(function() { Link Here
27	}	43	}
28	}	44	}
29	} );	45	} );
30	$("#issuest").dataTable($.extend(true, {}, dataTablesDefaults, {
31	"sDom": 't',
32	"aoColumnDefs": [
33	{ "aTargets": [ -1,-2 ], "bSortable": false, "bSearchable": false }
34	],
35	"aoColumns": [
36	{ "sType": "title-string" },{ "sType": "anti-the" },null,{ "sType": "title-string" },null,null,null,null,null,null
37	],
38	"bPaginate": false
39	}));
40	$("#relissuest").dataTable($.extend(true, {}, dataTablesDefaults, {
41	"sDom": 't',
42	"aoColumns": [
43	{ "sType": "title-string" },{ "sType": "anti-the" },null,{ "sType": "title-string" },null,null,null,null,null
44	],
45	"bPaginate": false
46	}));
47	$("#holdst").dataTable($.extend(true, {}, dataTablesDefaults, {	46	$("#holdst").dataTable($.extend(true, {}, dataTablesDefaults, {
48	"sDom": 't',	47	"sDom": 't',
49	"aoColumnDefs": [	48	"aoColumnDefs": [
Lines 66-107 $(document).ready(function() { Link Here
66	}	65	}
67	return confirm(_("Are you sure you want to replace the current patron image? This cannot be undone."));	66	return confirm(_("Are you sure you want to replace the current patron image? This cannot be undone."));
68	});[% END %]	67	});[% END %]
69	$("#renew_all" ).click(function(){ $(".checkboxed").checkCheckboxes(":input[name=items]" ); $(".checkboxed").unCheckCheckboxes(":input[name=barcodes]"); });	68
70	$("#CheckAllitems" ).click(function(){ $(".checkboxed").checkCheckboxes(":input[name=items]" ); $(".checkboxed").unCheckCheckboxes(":input[name=barcodes]"); return false; });
71	$("#CheckNoitems" ).click(function(){ $(".checkboxed").unCheckCheckboxes(":input[name*=items]"); return false; });
72	$("#CheckAllreturns").click(function(){ $(".checkboxed").checkCheckboxes(":input[name=barcodes]"); $(".checkboxed").unCheckCheckboxes(":input[name=items]"); return false; });
73	$("#CheckNoreturns" ).click(function(){ $(".checkboxed").unCheckCheckboxes(":input[name*=barcodes]"); return false; });
74
75	$("#relrenew_all" ).click(function(){ $(".checkboxed").checkCheckboxes(":input[name=items]" ); $(".checkboxed").unCheckCheckboxes(":input[name=barcodes]"); });
76	$("#relCheckAllitems" ).click(function(){ $(".checkboxed").checkCheckboxes(":input[name=items]" ); $(".checkboxed").unCheckCheckboxes(":input[name=barcodes]"); return false; });
77	$("#relCheckNoitems" ).click(function(){ $(".checkboxed").unCheckCheckboxes(":input[name*=items]"); return false; });
78	$("#relCheckAllreturns").click(function(){ $(".checkboxed").checkCheckboxes(":input[name=barcodes]"); $(".checkboxed").unCheckCheckboxes(":input[name=items]"); return false; });
79	$("#relCheckNoreturns" ).click(function(){ $(".checkboxed").unCheckCheckboxes(":input[name*=barcodes]"); return false; });
80
81
82	[% IF ( CAN_user_circulate_override_renewals ) %]
83	[% IF ( AllowRenewalLimitOverride ) %]
84	$( '#override_limit' ).click( function () {
85	if ( this.checked ) {
86	$( '.renewals-allowed' ).show(); $( '.renewals-disabled' ).hide();
87	} else {
88	$( '.renewals-allowed' ).hide(); $( '.renewals-disabled' ).show();
89	}
90	} ).attr( 'checked', false );
91	[% END %]
92	[% END %]
93	$("td").click(function(e){
94	if(e.target.tagName.toLowerCase() == 'td'){
95	$(this).find("input:checkbox").each( function() {
96	$(this).attr('checked', !$(this).attr('checked'));
97	if($(this).attr('checked')){
98	$(this).parent().siblings().find("input:checkbox").each(function(){
99	if($(this).attr('checked')){ $(this).removeAttr('checked'); }
100	});
101	}
102	});
103	}
104	});
105	$("#suspend_until").datepicker({ minDate: 1 }); // require that hold suspended until date is after today	69	$("#suspend_until").datepicker({ minDate: 1 }); // require that hold suspended until date is after today
106	$("#newduedate").datetimepicker({	70	$("#newduedate").datetimepicker({
107	minDate: 1, // require that renewal date is after today	71	minDate: 1, // require that renewal date is after today
Lines 424-613 function validate1(date) { Link Here
424		388
425	<div id="finesholdsissues" class="toptabs">	389	<div id="finesholdsissues" class="toptabs">
426	<ul>	390	<ul>
427	<li><a href="#checkedout">[% issueloop.size %] Checkout(s)</a></li>	391	<li><a href="#checkouts">[% issueloop.size %] Checkout(s)</a></li>
428	[% IF relissueloop.size %]	392	[% IF relatives_issues_count %]
429	<li><a href="#relissues">Relatives' Checkouts</a></li>	393	<li><a href="#relatives-issues" id="relatives-issues-tab">Relatives' checkouts</a></li>
430	[% END %]	394	[% END %]
431	<li><a href="#finesandcharges">Fines & Charges</a></li>	395	<li><a href="#finesandcharges">Fines & Charges</a></li>
432	<li>[% IF ( countreserv ) %]	396	<li>
433	<a href="#onhold">[% countreserv %] Hold(s)</a> [% ELSE %]	397	[% IF ( holds_count ) %]
434	<a href="#onhold">0 Holds</a>	398	<a href="#reserves" id="holds-tab">[% holds_count %] Hold(s)</a>
435	[% END %]</li>	399	[% ELSE %]
		400	<a href="#reserves" id="holds-tab">0 Holds</a>
		401	[% END %]
		402	</li>
436	<li><a id="debarments-tab-link" href="#reldebarments">[% debarments.size %] Restrictions</a></li>	403	<li><a id="debarments-tab-link" href="#reldebarments">[% debarments.size %] Restrictions</a></li>
437	</ul>	404	</ul>
438		405
439	<form action="/cgi-bin/koha/reserve/renewscript.pl" method="post" class="checkboxed">	406	<div id="checkouts">
440	<input type="hidden" name="borrowernumber" value="[% borrowernumber %]" />	407	[% IF ( issuecount ) %]
441	<input type="hidden" name="branch" value="[% branch %]" />	408	<form name="issues" action="/cgi-bin/koha/tools/export.pl" method="post" class="checkboxed">
442	<div id="checkedout">	409	<table id="issues-table" style="width: 100% !Important;">
443	[% IF ( issueloop ) %]	410	<thead>
444	<table id="issuest">	411	<tr>
445	<thead>	412	<th scope="col"> </th>
446	<tr>	413	<th scope="col">Due date</th>
447	<th scope="col">Due date</th>	414	<th scope="col">Due date</th>
448	<th scope="col">Title</th>	415	<th scope="col">Title</th>
449	<th scope="col">Item type</th>	416	<th scope="col">Item type</th>
450	<th scope="col">Checked out on</th>	417	<th scope="col">Checked out on</th>
451	<th scope="col">Checked out from</th>	418	<th scope="col">Checked out from</th>
452	<th scope="col">Call no.</th>	419	<th scope="col">Call no</th>
453	<th scope="col">Charge</th>	420	<th scope="col">Charge</th>
454	<th scope="col">Price</th>	421	<th scope="col">Price</th>
455	<th scope="col">Renew <p class="column-tool"><a href="#" id="CheckAllitems">select all</a> \| <a href="#" id="CheckNoitems">none</a></p></th>	422	<th scope="col">Renew <p class="column-tool"><a href="#" id="CheckAllRenewals">select all</a> \| <a href="#" id="UncheckAllRenewals">none</a></p></th>
456	<th scope="col">Check in <p class="column-tool"><a href="#" id="CheckAllreturns">select all</a> \| <a href="#" id="CheckNoreturns">none</a></p></th>	423	<th scope="col">Check in <p class="column-tool"><a href="#" id="CheckAllCheckins">select all</a> \| <a href="#" id="UncheckAllCheckins">none</a></p></th>
457	</tr></thead>	424	<th scope="col">Export <p class="column-tool"><a href="#" id="CheckAllExports">select all</a> \| <a href="#" id="UncheckAllExports">none</a></p></th>
458	[% INCLUDE 'checkouts-table-footer.inc' %]	425	</tr>
459	<tbody>	426	</thead>
460	[% FOREACH issueloo IN issueloop %]	427	[% INCLUDE 'checkouts-table-footer.inc' %]
461		428	</table>
462	[% IF ( issueloo.overdue ) %]	429
463	<tr class="problem">	430	[% IF ( issuecount ) %]
464	[% ELSE %]	431	<fieldset class="action">
465	<tr>	432	[% IF ( CAN_user_circulate_override_renewals ) %]
466	[% END %]	433	[% IF ( AllowRenewalLimitOverride ) %]
467	[% IF ( issueloo.red ) %]	434	<label for="override_limit">Override renewal limit:</label>
468	<td class="od">	435	<input type="checkbox" name="override_limit" id="override_limit" value="1" />
469	[% ELSE %]	436	[% END %]
470	<td>	437	[% END %]
471	[% END %]	438	<button class="btn" id="RenewCheckinChecked"><i class="icon-check"></i> Renew or return checked items</button>
472	<span title="[% issueloo.date_due %]">[% issueloo.date_due \| $KohaDates %]</span>	439	<button class="btn" id="RenewAll"><i class="icon-book"></i> Renew all</button>
473	[% IF ( issueloo.itemlost ) %]	440	</fieldset>
474	<span class="lost">[% issueloo.itemlost %]</span>	441
		442	[% IF ( exports_enabled ) %]
		443	<fieldset>
		444	<label for="export_formats"><b>Export checkouts using format:</b></label>
		445	<select name="export_formats" id="export_formats">
		446	<option value="iso2709_995">ISO2709 with items</option>
		447	<option value="iso2709">ISO2709 without items</option>
		448	[% IF ( export_with_csv_profile ) %]
		449	<option value="csv">CSV</option>
		450	[% END %]
		451	</select>
		452
		453	<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" />
		454	<input type="hidden" name="op" value="export" />
		455	<input type="hidden" id="export_format" name="format" value="iso2709" />
		456	<input type="hidden" id="dont_export_item" name="dont_export_item" value="0" />
		457	<input type="hidden" id="record_type" name="record_type" value="bibs" />
		458	<button class="btn btn-small" id="export_submit"><i class="icon-download-alt"></i> Export</button>
		459	</fieldset>
475	[% END %]	460	[% END %]
476	[% IF ( issueloo.damaged ) %]
477	<span class="dmg">[% issueloo.itemdamaged %]</span>
478	[% END %]
479	</td>
480	<td><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% issueloo.biblionumber %]"><strong>[% issueloo.title \|html %][% FOREACH subtitl IN issueloo.subtitle %] [% subtitl.subfield %][% END %]</strong></a>[% IF ( issueloo.author ) %], by [% issueloo.author %][% END %] [% IF ( issueloo.publishercode ) %]; [% issueloo.publishercode %] [% END %] [% IF ( issueloo.publicationyear ) %], [% issueloo.publicationyear %][% END %] <a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% issueloo.biblionumber %]&itemnumber=[% issueloo.itemnumber %]#item[% issueloo.itemnumber %]">[% issueloo.barcode %]</a></td>
481	<td>[% UNLESS ( noItemTypeImages ) %] [% IF ( issueloo.itemtype_image ) %]<img src="[% issueloo.itemtype_image %]" alt="" />[% END %][% END %][% issueloo.itemtype_description %]</td>
482	<td><span title="[% issueloo.issuedate %]">[% issueloo.issuedate \| $KohaDates%]</span></td>
483	<td>[% issueloo.issuingbranchname %]</td>
484	<td>[% issueloo.itemcallnumber %]</td>
485	<td>[% issueloo.charge %]</td>
486	<td>[% issueloo.replacementprice %]</td>
487	[% IF ( issueloo.renew_failed ) %]
488	<td class="problem">Renewal Failed</td>
489	[% ELSE %]
490	<td><span style="padding: 0 1em;">[% IF ( issueloo.renewals ) %][% issueloo.renewals %][% ELSE %]0[% END %]</span>
491	[% IF ( issueloo.norenew ) %]
492	[% IF ( issueloo.can_confirm ) %]<span class="renewals-allowed" style="display: none">
493	<input type="checkbox" name="all_items[]" value="[% issueloo.itemnumber %]" checked="checked" style="display: none;" />
494	[% IF ( issueloo.od ) %]
495	<input type="checkbox" name="items[]" value="[% issueloo.itemnumber %]" checked="checked" />
496	[% ELSE %]
497	<input type="checkbox" name="items[]" value="[% issueloo.itemnumber %]" />
498	[% END %]
499	</span>
500	[% IF issueloo.renewsallowed && issueloo.renewsleft && !issueloo.norenew_reason_too_soon %]
501	<span class="renewals">([% issueloo.renewsleft %] of [% issueloo.renewsallowed %] renewals remaining)</span>
502	[% END %]
503	<span class="renewals-disabled">
504	[% END %]
505	[% IF ( issueloo.norenew_reason_on_reserve ) %]
506	<a href="/cgi-bin/koha/reserve/request.pl?biblionumber=[% issueloo.biblionumber %]">On Hold</a>
507	[% ELSIF ( issueloo.norenew_reason_too_many ) %]
508	Not renewable
509	[% ELSIF ( issueloo.norenew_reason_too_soon ) %]
510	No renewal before [% issueloo.soonestrenewdate %]
511	<span class="renewals">([% issueloo.renewsleft %] of [% issueloo.renewsallowed %] renewals remaining)</span>
512	[% END %]	461	[% END %]
513	[% IF ( issueloo.can_confirm ) %]	462	</form>
514	</span>
515	[% END %]
516	[% ELSE %]
517	<input type="checkbox" name="all_items[]" value="[% issueloo.itemnumber %]" checked="checked" style="display: none;" />
518	[% IF ( issueloo.red ) %]
519	<input type="checkbox" name="items[]" value="[% issueloo.itemnumber %]" checked="checked" onclick="uncheck_sibling(this);" />
520	[% ELSE %]
521	<input type="checkbox" name="items[]" value="[% issueloo.itemnumber %]" onclick="uncheck_sibling(this);" />
522	[% END %]
523	[% IF issueloo.renewsallowed && issueloo.renewsleft %]
524	<span class="renewals">([% issueloo.renewsleft %] of [% issueloo.renewsallowed %] renewals remaining)</span>
525	[% END %]
526	[% END %]
527	</td>
528	[% END %]
529	[% IF ( issueloo.return_failed ) %]
530	<td class="problem">Check-in failed</td>
531	[% ELSE %]
532	[% IF ( issueloo.norenew_reason_on_reserve ) %]
533	<td><a href="/cgi-bin/koha/reserve/request.pl?biblionumber=[% issueloo.biblionumber %]">On hold</a></td>
534	[% ELSE %]	463	[% ELSE %]
535	<td><input type="checkbox" name="barcodes[]" value="[% issueloo.barcode %]" onclick="uncheck_sibling(this);" />	464	<p>Patron has nothing checked out.</p>
536	<input type="checkbox" name="all_barcodes[]" value="[% issueloo.barcode %]" checked="checked" style="display: none;" />
537	</td>
538	[% END %]
539	[% END %]
540	</tr>
541	[% END %]
542	</tbody>
543	</table>
544	<fieldset class="action">
545	[% IF ( CAN_user_circulate_override_renewals ) %]
546	[% IF ( AllowRenewalLimitOverride ) %]
547	<label for="override_limit">Override renewal limit:</label>
548	<input type="checkbox" name="override_limit" id="override_limit" value="1" />
549	[% END %]	465	[% END %]
550	[% END %]	466	</div>
551	<input type="submit" name="renew_checked" value="Renew or return checked items" />
552	<input type="submit" id="renew_all" name="renew_all" value="Renew all" />
553	</fieldset>
554	[% ELSE %]<p>Patron has nothing checked out.</p>
555	[% END %]
556	</div>
557
558		467
559	[% IF relissueloop %]	468	[% IF ( relatives_issues_count ) %]
560	<div id="relissues">	469	<div id="relatives-issues">
561	<table id="relissuest">	470	<table id="relatives-issues-table" style="width: 100% !Important;">
562	<thead>	471	<thead>
563	<tr>	472	<tr>
564	<th scope="col">Due date</th>	473	<th scope="col">Due date</th>
565	<th scope="col">Title</th>	474	<th scope="col">Title</th>
566	<th scope="col">Item type</th>	475	<th scope="col">Item type</th>
567	<th scope="col">Checked out on</th>	476	<th scope="col">Checked out on</th>
568	<th scope="col">Checked out from</th>	477	<th scope="col">Checked out from</th>
569	<th scope="col">Call no.</th>	478	<th scope="col">Call no</th>
570	<th scope="col">Charge</th>	479	<th scope="col">Charge</th>
571	<th scope="col">Price</th>	480	<th scope="col">Price</th>
572	<th scope="col">Patron</th>	481	<th scope="col">Patron</th>
573	</tr>	482	</tr>
574	</thead>	483	</thead>
575	<tbody>	484	</table>
576	[% FOREACH relissueloo IN relissueloop %]
577
578	[% IF ( relissueloo.overdue ) %]
579	<tr class="problem">
580	[% ELSE %]
581	<tr>
582	[% END %]
583	[% IF ( relissueloo.red ) %]
584	<td class="od">
585	[% ELSE %]
586	<td>
587	[% END %]
588	<span title="[% relissueloo.date_due %]">[% relissueloo.date_due \| $KohaDates %]</span>
589	[% IF ( relissueloo.itemlost ) %]
590	<span class="lost">[% relissueloo.itemlost %]</span>
591	[% END %]
592	[% IF ( relissueloo.damaged ) %]
593	<span class="dmg">[% relissueloo.itemdamaged %]</span>
594	[% END %]
595	</td>
596	<td><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% relissueloo.biblionumber %]"><strong>[% relissueloo.title \|html %][% FOREACH subtitl IN relissueloo.subtitle %] [% subtitl.subfield %][% END %]</strong></a>[% IF relissueloo.author %], by [% relissueloo.author %][% END %] [% IF relissueloo.publishercode %]; [% relissueloo.publishercode %] [% END %] [% IF relissueloo.publicationyear %], [% relissueloo.publicationyear %][% END %] <a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% relissueloo.biblionumber %]&itemnumber=[% relissueloo.itemnumber %]#item[% relissueloo.itemnumber %]">[% relissueloo.barcode %]</a></td>
597	<td>[% UNLESS ( noItemTypeImages ) %] [% IF ( relissueloo.itemtype_image ) %]<img src="[% relissueloo.itemtype_image %]" alt="" />[% END %][% END %][% relissueloo.itemtype_description %]</td>
598	<td><span title="[% relissueloo.issuedate %]">[% relissueloo.issuedate \| $KohaDates %]</span></td>
599	<td>[% relissueloo.issuingbranchname %]</td>
600	<td>[% relissueloo.itemcallnumber %]</td>
601	<td>[% relissueloo.charge %]</td>
602	<td>[% relissueloo.replacementprice %]</td>
603	<td><a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% relissueloo.borrowernumber %]">[% relissueloo.firstname %] [% relissueloo.surname %] ([% relissueloo.cardnumber %])</a></td>
604	</tr>
605	[% END %]
606	</tbody>
607	</table>
608	</div>	485	</div>
609	[% END %]	486	[% END %]
610	</form>
611		487
612	<div id="finesandcharges">	488	<div id="finesandcharges">
613	[% IF ( totaldue_raw ) %]	489	[% IF ( totaldue_raw ) %]
Lines 619-677 function validate1(date) { Link Here
619		495
620	[% INCLUDE borrower_debarments.inc %]	496	[% INCLUDE borrower_debarments.inc %]
621		497
622	<div id="onhold">	498	<div id="reserves">
623	[% IF ( reservloop ) %]	499	[% IF ( holds_count ) %]
624	<form action="/cgi-bin/koha/reserve/modrequest.pl" method="post">	500	<form action="/cgi-bin/koha/reserve/modrequest.pl" method="post">
625	<input type="hidden" name="from" value="borrower" />	501	<input type="hidden" name="from" value="circ" />
626	<table id="holdst">	502	<table id="holds-table" style="width: 100% !Important;">
627	<thead><tr>	503	<thead>
628	<th>Hold date</th>	504	<tr>
629	<th>Title</th>	505	<th>Hold date</th>
630	<th>Call number</th>	506	<th>Title</th>
631	<th>Barcode</th>	507	<th>Call number</th>
632	<th>Expiration</th>	508	<th>Barcode</th>
633	<th>Priority</th>	509	<th>Expiration</th>
634	<th>Delete?</th>	510	<th>Priority</th>
635	<th> </th>	511	<th>Delete?</th>
636	</tr></thead>	512	</tr>
637	<tbody>[% FOREACH reservloo IN reservloop %]	513	</thead>
638	<tr class="[% reservloo.color %]">	514	</table>
639	<td><span title="[% reservloo.reservedate %]">[% reservloo.reservedate \| $KohaDates %]</span></td>
640	<td>
641	<a href="/cgi-bin/koha/reserve/request.pl?biblionumber=[% reservloo.biblionumber %]">[% reservloo.title \|html %][% FOREACH subtitl IN reservloo.subtitle %] [% subtitl.subfield %][% END %]</a>[% IF ( reservloo.author ) %], by [% reservloo.author %][% END %]
642	</td>
643	<td>[% reservloo.itemcallnumber %]</td>
644	<td>[% IF ( reservloo.waiting ) %]
645	<em>Item is <strong>waiting</strong></em>
646	[% END %]
647	[% IF ( reservloo.transfered ) %]
648	<em>Item <strong>in transit</strong> from
649	[% reservloo.frombranch %] since [% reservloo.datesent %] </em>
650	[% END %]
651		515
652	[% IF ( reservloo.nottransfered ) %]	516	<fieldset class="action">
653	<em>Item hasn't been transferred yet from [% reservloo.nottransferedby %]</em>	517	<input type="submit" class="cancel" name="submit" value="Cancel marked holds" />
654	[% END %]	518	</fieldset>
655	[% IF ( reservloo.barcodereserv ) %]
656	<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% reservloo.biblionumber %]">[% reservloo.barcodereserv %]</a>
657	[% END %]
658	</td>
659	<td>[% reservloo.expirationdate \| $KohaDates %]</td>
660	<td>[% IF ( reservloo.waitingposition ) %]<strong>[% reservloo.waitingposition %]</strong>[% END %]</td>
661	<td><select name="rank-request">
662	<option value="n">No</option>
663	<option value="del">Yes</option>
664	</select>
665	<input type="hidden" name="biblionumber" value="[% reservloo.biblionumber %]" />
666	<input type="hidden" name="borrowernumber" value="[% borrowernumber %]" />
667	<input type="hidden" name="reserve_id" value="[% reservloo.reserve_id %]" />
668	</td>
669	<td>[% IF ( reservloo.suspend ) %]Suspended [% IF ( reservloo.suspend_until ) %] until [% reservloo.suspend_until \| $KohaDates %][% END %][% END %]</td>
670	</tr>
671	[% END %]</tbody>
672	</table>
673
674	<fieldset class="action"><input type="submit" class="cancel" name="submit" value="Cancel marked holds" /></fieldset>
675	</form>	519	</form>
676		520
677	[% IF SuspendHoldsIntranet %]	521	[% IF SuspendHoldsIntranet %]





# Copyright 2000-2002 Katipo Communications
# Copyright 2010 BibLibre
# Copyright 2014 ByWater Solutions
#
# This file is part of Koha.
#

use List::MoreUtils qw/uniq/;
use C4::Members::Attributes qw(GetBorrowerAttributes);
use Koha::Borrower::Debarments qw(GetDebarments);
#use Smart::Comments;
#use Data::Dumper;
use DateTime;
use Koha::DateUtils;
use Koha::Database;

use vars qw($debug);


my $input = CGI->new;
$debug or $debug = $input->param('debug') || 0;
my $print = $input->param('print');
my $override_limit = $input->param("override_limit") || 0;
my @failedrenews = $input->param('failedrenew');
my @failedreturns = $input->param('failedreturn');
my $error = $input->param('error');
my %renew_failed;
for my $renew (@failedrenews) { $renew_failed{$renew} = 1; }
my %return_failed;
for my $failedret (@failedreturns) { $return_failed{$failedret} = 1; }

my $template_name;
my $quickslip = 0;

);
my $borrowernumber = $input->param('borrowernumber');

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

my $data = GetMember( 'borrowernumber' => $borrowernumber );

if ( not defined $data ) {
    $template->param (unknowuser => 1);


my $category_type = $data->{'category_type'};

### $category_type

$debug and printf STDERR "dates (enrolled,expiry,birthdate) raw: (%s, %s, %s)\n", map {$data->{$_}} qw(dateenrolled dateexpiry dateofbirth);
foreach (qw(dateenrolled dateexpiry dateofbirth)) {
		my $userdate = $data->{$_};

    $template->param( "privacy".$data->{'privacy'} => 1);
}

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

if ( @borrowernumbers ) {
    $relissue    = GetPendingIssues(@borrowernumbers);
}
my $roadtype = C4::Koha::GetAuthorisedValueByCode( 'ROADTYPE', $data->{streettype} );
my $today       = DateTime->now( time_zone => C4::Context->tz);
$today->truncate(to => 'day');

my $overdues_exist = 0;
my $totalprice = 0;

my @issuedata = build_issue_data($issue);
my @relissuedata = build_issue_data($relissue);


### ###############################################################################
# BUILD HTML
# show all reserves of this borrower, and the position of the reservation ....
if ($borrowernumber) {
    $template->param(
        holds_count => Koha::Database->new()->schema()->resultset('Reserve')
          ->count( { borrowernumber => $borrowernumber } ) );
    my @borrowerreserv = GetReservesFromBorrowernumber($borrowernumber );
    my @reservloop;
    foreach my $num_res (@borrowerreserv) {
        my %getreserv;
        my $getiteminfo  = GetBiblioFromItemNumber( $num_res->{'itemnumber'} );
        my $itemtypeinfo = getitemtypeinfo( $getiteminfo->{'itemtype'} );
        my ( $transfertwhen, $transfertfrom, $transfertto ) =
            GetTransfers( $num_res->{'itemnumber'} );

        foreach (qw(waiting transfered nottransfered)) {
            $getreserv{$_} = 0;
        }
        $getreserv{reservedate}  = $num_res->{'reservedate'};
        foreach (qw(biblionumber title author itemcallnumber )) {
            $getreserv{$_} = $getiteminfo->{$_};
        }
        $getreserv{barcodereserv}  = $getiteminfo->{'barcode'};
        $getreserv{itemtype}  = $itemtypeinfo->{'description'};

        # 		check if we have a waitin status for reservations
        if ( $num_res->{'found'} eq 'W' ) {
            $getreserv{color}   = 'reserved';
            $getreserv{waiting} = 1;
        }

        # 		check transfers with the itemnumber foud in th reservation loop
        if ($transfertwhen) {
            $getreserv{color}      = 'transfered';
            $getreserv{transfered} = 1;
            $getreserv{datesent}   = C4::Dates->new($transfertwhen, 'iso')->output('syspref') or die "Cannot get new($transfertwhen, 'iso') from C4::Dates";
            $getreserv{frombranch} = GetBranchName($transfertfrom);
        }

        if ( ( $getiteminfo->{'holdingbranch'} ne $num_res->{'branchcode'} )
            and not $transfertwhen )
        {
            $getreserv{nottransfered}   = 1;
            $getreserv{nottransferedby} =
                GetBranchName( $getiteminfo->{'holdingbranch'} );
        }
        $getreserv{title}          = $getiteminfo->{'title'};
        $getreserv{subtitle}       = GetRecordValue('subtitle', GetMarcBiblio($getiteminfo->{biblionumber}), GetFrameworkCode($getiteminfo->{biblionumber}));

# 		if we don't have a reserv on item, we put the biblio infos and the waiting position
        if ( $getiteminfo->{'title'} eq '' ) {
            my $getbibinfo = GetBiblioData( $num_res->{'biblionumber'} );
            my $getbibtype = getitemtypeinfo( $getbibinfo->{'itemtype'} );
            $getreserv{color}           = 'inwait';
            $getreserv{title}           = $getbibinfo->{'title'};
            $getreserv{subtitle}        = GetRecordValue('subtitle', GetMarcBiblio($num_res->{biblionumber}), GetFrameworkCode($num_res->{biblionumber}));
            $getreserv{nottransfered}   = 0;
            $getreserv{itemtype}        = $getbibtype->{'description'};
            $getreserv{author}          = $getbibinfo->{'author'};
            $getreserv{biblionumber}  = $num_res->{'biblionumber'};	
        }
        $getreserv{waitingposition} = $num_res->{'priority'};
        $getreserv{suspend} = $num_res->{'suspend'};
        $getreserv{suspend_until} = $num_res->{'suspend_until'};
        $getreserv{expirationdate} = $num_res->{'expirationdate'};
        $getreserv{reserve_id} = $num_res->{'reserve_id'};

        push( @reservloop, \%getreserv );
    }

    # return result to the template
    $template->param( reservloop => \@reservloop,
        countreserv => scalar @reservloop,
	 );
}

# current alert subscriptions

    totalprice      => sprintf("%.2f", $totalprice),
    totaldue        => sprintf("%.2f", $total),
    totaldue_raw    => $total,
    issueloop       => @issuedata,
    relissueloop    => @relissuedata,
    overdues_exist  => $overdues_exist,
    error           => $error,
    StaffMember     => ($category_type eq 'S'),
    is_child        => ($category_type eq 'C'),
#   reserveloop     => \@reservedata,
    samebranch     => $samebranch,
    quickslip		  => $quickslip,
    activeBorrowerRelationship => (C4::Context->preference('borrowerRelationship') ne ''),

    SuspendHoldsIntranet => C4::Context->preference('SuspendHoldsIntranet'),
    RoutingSerials => C4::Context->preference('RoutingSerials'),
    debarments => GetDebarments({ borrowernumber => $borrowernumber }),
    relatives_issues_count => $relatives_issues_count,
    relatives_borrowernumbers => \@relatives,
);
$template->param( $error => 1 ) if $error;

output_html_with_http_headers $input, $cookie, $template->output;

sub build_issue_data {
    my $issues = shift;

    my $localissue;

    foreach my $issue ( @{$issues} ) {

        # Getting borrower details
        my $memberdetails = GetMemberDetails( $issue->{borrowernumber} );
        $issue->{borrowername} =
          $memberdetails->{firstname} . ' ' . $memberdetails->{surname};
        $issue->{cardnumber} = $memberdetails->{cardnumber};
        my $issuedate;
        if ($issue->{issuedate} ) {
           $issuedate = $issue->{issuedate}->clone();
        }
        $issue->{subtitle} = GetRecordValue('subtitle', GetMarcBiblio($issue->{biblionumber}), GetFrameworkCode($issue->{biblionumber}));
        $issue->{issuingbranchname} = GetBranchName($issue->{branchcode});
        my %row          = %{$issue};
        $totalprice += $issue->{replacementprice};

        # item lost, damaged loops
        if ( $row{'itemlost'} ) {
            my $fw       = GetFrameworkCode( $issue->{biblionumber} );
            my $category = GetAuthValCode( 'items.itemlost', $fw );
            my $lostdbh  = C4::Context->dbh;
            my $sth      = $lostdbh->prepare(
"select lib from authorised_values where category=? and authorised_value =? "
            );
            $sth->execute( $category, $row{'itemlost'} );
            my $loststat = $sth->fetchrow;
            if ($loststat) {
                $row{'itemlost'} = $loststat;
            }
        }
        if ( $row{'damaged'} ) {
            my $fw         = GetFrameworkCode( $issue->{biblionumber} );
            my $category   = GetAuthValCode( 'items.damaged', $fw );
            my $damageddbh = C4::Context->dbh;
            my $sth        = $damageddbh->prepare(
"select lib from authorised_values where category=? and authorised_value =? "
            );
            $sth->execute( $category, $row{'damaged'} );
            my $damagedstat = $sth->fetchrow;
            if ($damagedstat) {
                $row{'itemdamaged'} = $damagedstat;
            }
        }

        # end lost, damaged
        if ( $issue->{overdue} ) {
            $overdues_exist = 1;
            $row{red} = 1;
        }
        if ($issuedate) {
            $issuedate->truncate( to => 'day' );
            if ( DateTime->compare( $issuedate, $today ) == 0 ) {
                $row{today} = 1;
            }
        }

        #find the charge for an item
        my ( $charge, $itemtype ) =
          GetIssuingCharges( $issue->{itemnumber}, $borrowernumber );

        my $itemtypeinfo = getitemtypeinfo($itemtype);
        $row{'itemtype_description'} = $itemtypeinfo->{description};
        $row{'itemtype_image'}       = $itemtypeinfo->{imageurl};

        $row{'charge'} = sprintf( "%.2f", $charge );

        my ( $renewokay, $renewerror ) =
          CanBookBeRenewed( $borrowernumber, $issue->{itemnumber},
            $override_limit );
        $row{'norenew'} = !$renewokay;
        $row{'can_confirm'} = ( !$renewokay && $renewerror ne 'on_reserve' );
        $row{"norenew_reason_$renewerror"} = 1 if $renewerror;
        $row{renew_failed}  = $renew_failed{ $issue->{itemnumber} };
        $row{return_failed} = $return_failed{ $issue->{barcode} };
        ($row{'renewcount'},$row{'renewsallowed'},$row{'renewsleft'}) = C4::Circulation::GetRenewCount($issue->{'borrowernumber'},$issue->{'itemnumber'}); #Add renewal count to item data display

        $row{'soonestrenewdate'} = output_pref(
            C4::Circulation::GetSoonestRenewDate(
                $issue->{borrowernumber},
                $issue->{itemnumber}
            )
        );

        push( @{$localissue}, \%row );
    }
    return $localissue;
}




#!/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 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::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 strict;
use warnings;

use CGI;
use JSON qw(to_json);

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

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 @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') || -1;
my $sorting_column   = $sort_columns[ $input->param('iSortCol_0') ]
  || 'issuedate';
my $sorting_direction = $input->param('sSortDir_0') eq 'asc' ? 'asc' : '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 @parameters;
my $sql = '
    SELECT
        issuedate,
        date_due,

        biblionumber,
        biblio.title,
        author,

        itemnumber,
        barcode,
        itemnotes,
        itemcallnumber,
        replacementprice,

        issues.branchcode,
        branchname,

        itype,
        itemtype,

        borrowernumber,
        surname,
        firstname,
        cardnumber
    FROM issues
        LEFT JOIN items USING ( itemnumber )
        LEFT JOIN biblio USING ( biblionumber )
        LEFT JOIN biblioitems USING ( biblionumber )
        LEFT JOIN borrowers USING ( borrowernumber )
        LEFT JOIN branches ON ( issues.branchcode = branches.branchcode )
    WHERE borrowernumber
';

if ( @borrowernumber == 1 ) {
    $sql .= '= ?';
}
else {
    $sql = ' IN (' . join( ',', ('?') x @borrowernumber ) . ') ';
}
push( @parameters, @borrowernumber );

$sql .= " ORDER BY $sorting_column $sorting_direction ";

my $dbh = C4::Context->dbh();
my $sth = $dbh->prepare($sql);
$sth->execute( @parameters );

my $item_level_itypes = C4::Context->preference('item-level_itypes');

my @checkouts;
while ( my $c = $sth->fetchrow_hashref() ) {
    my ($charge) = GetIssuingCharges( $c->{itemnumber}, $c->{borrowernumber} );

    my ( $can_renew, $can_renew_error ) =
      CanBookBeRenewed( $c->{borrowernumber}, $c->{itemnumber} );

    my ( $renewals_count, $renewals_allowed, $renewals_remaining ) =
      GetRenewCount( $c->{borrowernumber}, $c->{itemnumber} );
    push(
        @checkouts,
        {
            DT_RowId   => $c->{itemnumber} . '-' . $c->{borrowernumber},
            title      => $c->{title},
            author     => $c->{author},
            barcode    => $c->{barcode},
            itemtype   => $item_level_itypes ? $c->{itype} : $c->{itemtype},
            itemnotes  => $c->{itemnotes},
            branchcode => $c->{branchcode},
            branchname => $c->{branchname},
            itemcallnumber => $c->{itemcallnumber}   || q{},
            charge         => $charge,
            price          => $c->{replacementprice} || q{},
            can_renew      => $can_renew,
            can_renew_error    => $can_renew_error,
            itemnumber         => $c->{itemnumber},
            borrowernumber     => $c->{borrowernumber},
            biblionumber       => $c->{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( $c->{biblionumber} ),
                GetFrameworkCode( $c->{biblionumber} )
            ),
            borrower => {
                surname    => $c->{surname},
                firstname  => $c->{firstname},
                cardnumber => $c->{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

# 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::Branch qw(GetBranchName);
use C4::Charset;
use C4::Circulation qw(GetTransfers);
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 $branch = C4::Context->userenv->{'branch'};

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

my @sort_columns =
  qw/reservedate title itemcallnumber barcode expirationdate priority/;

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

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

my $holds_rs = $schema->resultset('Reserve')->search(
    { borrowernumber => $borrowernumber },
    {
        prefetch => { 'item'                => 'biblio' },
        order_by => { "-$sorting_direction" => $sorting_column }
    }
);

my $borrower;
my @holds;
while ( my $h = $holds_rs->next() ) {
    my $item = $h->item();

    my $biblionumber = $h->biblio()->biblionumber();

    my $hold = {
        DT_RowId       => $h->reserve_id(),
        biblionumber   => $biblionumber,
        title          => $h->biblio()->title(),
        author         => $h->biblio()->author(),
        reserve_id     => $h->reserve_id(),
        reservedate    => $h->reservedate(),
        expirationdate => $h->expirationdate(),
        suspend        => $h->suspend(),
        suspend_until  => $h->suspend_until(),
        found          => $h->found(),
        waiting        => $h->found() eq 'W',
        waiting_at     => $h->branchcode()->branchname(),
        waiting_here   => $h->branchcode()->branchcode() eq $branch,
        priority       => $h->priority(),
        subtitle       => GetRecordValue(
            'subtitle', GetMarcBiblio($biblionumber),
            GetFrameworkCode($biblionumber)
        ),
        reservedate_formatted => $h->reservedate()
        ? output_pref_due( dt_from_string( $h->reservedate() ) )
        : q{},
        suspend_until_formatted => $h->suspend_until()
        ? output_pref_due( dt_from_string( $h->suspend_until() ) )
        : q{},
        expirationdate_formatted => $h->expirationdate()
        ? output_pref_due( dt_from_string( $h->expirationdate() ) )
        : q{},
    };

    $hold->{transfered}     = 0;
    $hold->{not_transfered} = 0;

    if ($item) {
        $hold->{itemnumber}     = $item->itemnumber();
        $hold->{barcode}        = $item->barcode();
        $hold->{itemtype}       = $item->effective_itemtype();
        $hold->{itemcallnumber} = $item->itemcallnumber() || q{};

        my ( $transferred_when, $transferred_from, $transferred_to ) =
          GetTransfers( $item->itemnumber() );
        if ($transferred_when) {
            $hold->{color}       = 'transferred';
            $hold->{transferred} = 1;
            $hold->{date_sent}   = format_date($transferred_when);
            $hold->{from_branch} = GetBranchName($transferred_from);
        }
        elsif ( $item->holdingbranch()->branchcode() ne
            $h->branchcode()->branchcode() )
        {
            $hold->{not_transferred}    = 1;
            $hold->{not_transferred_by} = $h->branchcode()->branchname();
        }
    }

    push( @holds, $hold );
}

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

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 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::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);

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 288-293 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/Reserve.pm (-1 / +23 lines)
288	# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21	288	# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
289	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ig/fobzvZf1OgAHZFtkyyQ	289	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ig/fobzvZf1OgAHZFtkyyQ
290		290
		291	__PACKAGE__->belongs_to(
		292	"item",
		293	"Koha::Schema::Result::Item",
		294	{ itemnumber => "itemnumber" },
		295	{
		296	is_deferrable => 1,
		297	join_type => "LEFT",
		298	on_delete => "CASCADE",
		299	on_update => "CASCADE",
		300	},
		301	);
		302
		303	__PACKAGE__->belongs_to(
		304	"biblio",
		305	"Koha::Schema::Result::Biblio",
		306	{ biblionumber => "biblionumber" },
		307	{
		308	is_deferrable => 1,
		309	join_type => "LEFT",
		310	on_delete => "CASCADE",
		311	on_update => "CASCADE",
		312	},
		313	);
291		314
292	# You can replace this text with custom content, and it will be preserved on regeneration
293	1;	315	1;

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

(-)a/circ/circulation.pl (-205 / +13 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 121-130 if (C4::Context->preference("DisplayClearScreenButton")) { Link Here
121	$template->param(DisplayClearScreenButton => 1);	114	$template->param(DisplayClearScreenButton => 1);
122	}	115	}
123		116
124	if (C4::Context->preference("UseTablesortForCirc")) {
125	$template->param(UseTablesortForCirc => 1);
126	}
127
128	my $barcode = $query->param('barcode') \|\| q{};	117	my $barcode = $query->param('barcode') \|\| q{};
129	$barcode =~ s/^\s\|\s$//g; # remove leading/trailing whitespace	118	$barcode =~ s/^\s\|\s$//g; # remove leading/trailing whitespace
130		119
Lines 354-362 if ($barcode) { Link Here
354	}	343	}
355	}	344	}
356		345
357	# FIXME If the issue is confirmed, we launch another time GetMemberIssuesAndFines, now display the issue count after issue	346	my ( $od, $issue, $fines ) = GetMemberIssuesAndFines($borrowernumber);
358	my ( $od, $issue, $fines ) = GetMemberIssuesAndFines( $borrowernumber );	347	$template->param( issuecount => $issue );
359	$template->param( issuecount => $issue );
360	}	348	}
361		349
362	# reload the borrower info for the sake of reseting the flags.....	350	# reload the borrower info for the sake of reseting the flags.....
Lines 368-561 if ($borrowernumber) { Link Here
368	# BUILD HTML	356	# BUILD HTML
369	# show all reserves of this borrower, and the position of the reservation ....	357	# show all reserves of this borrower, and the position of the reservation ....
370	if ($borrowernumber) {	358	if ($borrowernumber) {
		359	$template->param(
		360	holds_count => Koha::Database->new()->schema()->resultset('Reserve')
		361	->count( { borrowernumber => $borrowernumber } ) );
371		362
372	# new op dev
373	# now we show the status of the borrower's reservations
374	my @borrowerreserv = GetReservesFromBorrowernumber($borrowernumber );
375	my @reservloop;
376	my @WaitingReserveLoop;
377
378	foreach my $num_res (@borrowerreserv) {
379	my %getreserv;
380	my %getWaitingReserveInfo;
381	my $getiteminfo = GetBiblioFromItemNumber( $num_res->{'itemnumber'} );
382	my $itemtypeinfo = getitemtypeinfo( (C4::Context->preference('item-level_itypes')) ? $getiteminfo->{'itype'} : $getiteminfo->{'itemtype'} );
383	my ( $transfertwhen, $transfertfrom, $transfertto ) =
384	GetTransfers( $num_res->{'itemnumber'} );
385
386	$getreserv{waiting} = 0;
387	$getreserv{transfered} = 0;
388	$getreserv{nottransfered} = 0;
389
390	$getreserv{reservedate} = format_date( $num_res->{'reservedate'} );
391	$getreserv{reserve_id} = $num_res->{'reserve_id'};
392	$getreserv{title} = $getiteminfo->{'title'};
393	$getreserv{subtitle} = GetRecordValue('subtitle', GetMarcBiblio($getiteminfo->{biblionumber}), GetFrameworkCode($getiteminfo->{biblionumber}));
394	$getreserv{itemtype} = $itemtypeinfo->{'description'};
395	$getreserv{author} = $getiteminfo->{'author'};
396	$getreserv{barcodereserv} = $getiteminfo->{'barcode'};
397	$getreserv{itemcallnumber} = $getiteminfo->{'itemcallnumber'};
398	$getreserv{biblionumber} = $getiteminfo->{'biblionumber'};
399	$getreserv{waitingat} = GetBranchName( $num_res->{'branchcode'} );
400	$getreserv{suspend} = $num_res->{'suspend'};
401	$getreserv{suspend_until} = $num_res->{'suspend_until'};
402	# check if we have a waiting status for reservations
403	if ( $num_res->{'found'} && $num_res->{'found'} eq 'W' ) {
404	$getreserv{color} = 'reserved';
405	$getreserv{waiting} = 1;
406	# genarate information displaying only waiting reserves
407	$getWaitingReserveInfo{title} = $getiteminfo->{'title'};
408	$getWaitingReserveInfo{biblionumber} = $getiteminfo->{'biblionumber'};
409	$getWaitingReserveInfo{itemtype} = $itemtypeinfo->{'description'};
410	$getWaitingReserveInfo{author} = $getiteminfo->{'author'};
411	$getWaitingReserveInfo{itemcallnumber} = $getiteminfo->{'itemcallnumber'};
412	$getWaitingReserveInfo{reservedate} = format_date( $num_res->{'reservedate'} );
413	$getWaitingReserveInfo{waitingat} = GetBranchName( $num_res->{'branchcode'} );
414	$getWaitingReserveInfo{waitinghere} = 1 if $num_res->{'branchcode'} eq $branch;
415	}
416	# check transfers with the itemnumber foud in th reservation loop
417	if ($transfertwhen) {
418	$getreserv{color} = 'transfered';
419	$getreserv{transfered} = 1;
420	$getreserv{datesent} = format_date($transfertwhen);
421	$getreserv{frombranch} = GetBranchName($transfertfrom);
422	} elsif ($getiteminfo->{'holdingbranch'} ne $num_res->{'branchcode'}) {
423	$getreserv{nottransfered} = 1;
424	$getreserv{nottransferedby} = GetBranchName( $getiteminfo->{'holdingbranch'} );
425	}
426
427	# if we don't have a reserv on item, we put the biblio infos and the waiting position
428	if ( $getiteminfo->{'title'} eq '' ) {
429	my $getbibinfo = GetBiblioData( $num_res->{'biblionumber'} );
430
431	$getreserv{color} = 'inwait';
432	$getreserv{title} = $getbibinfo->{'title'};
433	$getreserv{subtitle} = GetRecordValue('subtitle', GetMarcBiblio($num_res->{biblionumber}), GetFrameworkCode($num_res->{biblionumber}));
434	$getreserv{nottransfered} = 0;
435	$getreserv{itemtype} = $itemtypeinfo->{'description'};
436	$getreserv{author} = $getbibinfo->{'author'};
437	$getreserv{biblionumber} = $num_res->{'biblionumber'};
438	}
439	$getreserv{waitingposition} = $num_res->{'priority'};
440	$getreserv{expirationdate} = $num_res->{'expirationdate'};
441	push( @reservloop, \%getreserv );
442
443	# if we have a reserve waiting, initiate waitingreserveloop
444	if ($getreserv{waiting} == 1) {
445	push (@WaitingReserveLoop, \%getWaitingReserveInfo)
446	}
447
448	}
449
450	# return result to the template
451	$template->param(
452	countreserv => scalar @reservloop,
453	reservloop => \@reservloop ,
454	WaitingReserveLoop => \@WaitingReserveLoop,
455	);
456	$template->param( adultborrower => 1 ) if ( $borrower->{'category_type'} eq 'A' );	363	$template->param( adultborrower => 1 ) if ( $borrower->{'category_type'} eq 'A' );
457	}	364	}
458		365
459	# make the issued books table.
460	my $todaysissues = '';
461	my $previssues = '';
462	our @todaysissues = ();
463	our @previousissues = ();
464	our @relissues = ();
465	our @relprevissues = ();
466	my $displayrelissues;
467
468	our $totalprice = 0;
469
470	sub build_issue_data {
471	my $issueslist = shift;
472	my $relatives = shift;
473
474	# split in 2 arrays for today & previous
475	foreach my $it ( @$issueslist ) {
476	my $itemtypeinfo = getitemtypeinfo( (C4::Context->preference('item-level_itypes')) ? $it->{'itype'} : $it->{'itemtype'} );
477
478	# set itemtype per item-level_itype syspref - FIXME this is an ugly hack
479	$it->{'itemtype'} = ( C4::Context->preference( 'item-level_itypes' ) ) ? $it->{'itype'} : $it->{'itemtype'};
480
481	($it->{'charge'}, $it->{'itemtype_charge'}) = GetIssuingCharges(
482	$it->{'itemnumber'}, $it->{'borrowernumber'}
483	);
484	$it->{'charge'} = sprintf("%.2f", $it->{'charge'});
485	my ($can_renew, $can_renew_error) = CanBookBeRenewed(
486	$it->{'borrowernumber'},$it->{'itemnumber'}
487	);
488	$it->{"renew_error_${can_renew_error}"} = 1 if defined $can_renew_error;
489	my $restype = C4::Reserves::GetReserveStatus( $it->{'itemnumber'} );
490	$it->{'can_renew'} = $can_renew;
491	$it->{'can_confirm'} = !$can_renew && !$restype;
492	$it->{'renew_error'} = ( $restype eq "Waiting" or $restype eq "Reserved" ) ? 1 : 0;
493	$it->{'checkoutdate'} = C4::Dates->new($it->{'issuedate'},'iso')->output('syspref');
494	$it->{'issuingbranchname'} = GetBranchName($it->{'branchcode'});
495
496	$totalprice += $it->{'replacementprice'} \|\| 0;
497	$it->{'itemtype'} = $itemtypeinfo->{'description'};
498	$it->{'itemtype_image'} = $itemtypeinfo->{'imageurl'};
499	$it->{'dd_sort'} = $it->{'date_due'};
500	$it->{'dd'} = output_pref($it->{'date_due'});
501	$it->{'displaydate_sort'} = $it->{'issuedate'};
502	$it->{'displaydate'} = output_pref($it->{'issuedate'});
503	#$it->{'od'} = ( $it->{'date_due'} lt $todaysdate ) ? 1 : 0 ;
504	$it->{'od'} = $it->{'overdue'};
505	$it->{'subtitle'} = GetRecordValue('subtitle', GetMarcBiblio($it->{biblionumber}), GetFrameworkCode($it->{biblionumber}));
506	$it->{'renew_failed'} = $renew_failed{$it->{'itemnumber'}};
507	$it->{'return_failed'} = $return_failed{$it->{'barcode'}};
508
509	if ( ( $it->{'issuedate'} && $it->{'issuedate'} gt $todaysdate )
510	\|\| ( $it->{'lastreneweddate'} && $it->{'lastreneweddate'} gt $todaysdate ) ) {
511	(!$relatives) ? push @todaysissues, $it : push @relissues, $it;
512	} else {
513	(!$relatives) ? push @previousissues, $it : push @relprevissues, $it;
514	}
515	($it->{'renewcount'},$it->{'renewsallowed'},$it->{'renewsleft'}) = C4::Circulation::GetRenewCount($it->{'borrowernumber'},$it->{'itemnumber'}); #Add renewal count to item data display
516
517	$it->{'soonestrenewdate'} = output_pref(
518	C4::Circulation::GetSoonestRenewDate(
519	$it->{borrowernumber}, $it->{itemnumber}
520	)
521	);
522	}
523	}
524
525	if ($borrower) {
526
527	# Getting borrower relatives
528	my @relborrowernumbers = GetMemberRelatives($borrower->{'borrowernumber'});
529	#push @borrowernumbers, $borrower->{'borrowernumber'};
530
531	# get each issue of the borrower & separate them in todayissues & previous issues
532	my $issueslist = GetPendingIssues($borrower->{'borrowernumber'});
533	my $relissueslist = [];
534	if ( @relborrowernumbers ) {
535	$relissueslist = GetPendingIssues(@relborrowernumbers);
536	}
537
538	build_issue_data($issueslist, 0);
539	build_issue_data($relissueslist, 1);
540
541	$displayrelissues = scalar($relissueslist);
542
543	if ( C4::Context->preference( "todaysIssuesDefaultSortOrder" ) eq 'asc' ) {
544	@todaysissues = sort { $a->{'timestamp'} cmp $b->{'timestamp'} } @todaysissues;
545	}
546	else {
547	@todaysissues = sort { $b->{'timestamp'} cmp $a->{'timestamp'} } @todaysissues;
548	}
549
550	if ( C4::Context->preference( "previousIssuesDefaultSortOrder" ) eq 'asc' ){
551	@previousissues = sort { $a->{'date_due'} cmp $b->{'date_due'} } @previousissues;
552	}
553	else {
554	@previousissues = sort { $b->{'date_due'} cmp $a->{'date_due'} } @previousissues;
555	}
556	}
557
558
559	my @values;	366	my @values;
560	my %labels;	367	my %labels;
561	my $CGIselectborrower;	368	my $CGIselectborrower;
Lines 688-693 if (C4::Context->preference('ExtendedPatronAttributes')) { Link Here
688	);	495	);
689	}	496	}
690		497
		498	my @relatives = GetMemberRelatives( $borrower->{'borrowernumber'} );
		499	my $relatives_issues_count =
		500	Koha::Database->new()->schema()->resultset('Issue')
		501	->count( { borrowernumber => \@relatives } );
		502
691	$template->param(	503	$template->param(
692	lib_messages_loop => $lib_messages_loop,	504	lib_messages_loop => $lib_messages_loop,
693	bor_messages_loop => $bor_messages_loop,	505	bor_messages_loop => $bor_messages_loop,
Lines 725-737 $template->param( Link Here
725	duedatespec => $duedatespec,	537	duedatespec => $duedatespec,
726	message => $message,	538	message => $message,
727	CGIselectborrower => $CGIselectborrower,	539	CGIselectborrower => $CGIselectborrower,
728	totalprice => sprintf('%.2f', $totalprice),
729	totaldue => sprintf('%.2f', $total),	540	totaldue => sprintf('%.2f', $total),
730	todayissues => \@todaysissues,
731	previssues => \@previousissues,
732	relissues => \@relissues,
733	relprevissues => \@relprevissues,
734	displayrelissues => $displayrelissues,
735	inprocess => $inprocess,	541	inprocess => $inprocess,
736	is_child => ($borrower->{'category_type'} eq 'C'),	542	is_child => ($borrower->{'category_type'} eq 'C'),
737	circview => 1,	543	circview => 1,
Lines 742-747 $template->param( Link Here
742	SuspendHoldsIntranet => C4::Context->preference('SuspendHoldsIntranet'),	548	SuspendHoldsIntranet => C4::Context->preference('SuspendHoldsIntranet'),
743	AutoResumeSuspendedHolds => C4::Context->preference('AutoResumeSuspendedHolds'),	549	AutoResumeSuspendedHolds => C4::Context->preference('AutoResumeSuspendedHolds'),
744	RoutingSerials => C4::Context->preference('RoutingSerials'),	550	RoutingSerials => C4::Context->preference('RoutingSerials'),
		551	relatives_issues_count => $relatives_issues_count,
		552	relatives_borrowernumbers => \@relatives,
745	);	553	);
746		554
747	# save stickyduedate to session	555	# save stickyduedate to session

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/js/checkouts.js (+435 lines)
		1	$(document).ready(function() {
		2	// Handle the select all/none links for checkouts table columns
		3	$("#CheckAllRenewals").on("click",function(){
		4	$("#UncheckAllCheckins").click();
		5	$(".renew:visible").attr("checked", "checked" );
		6	return false;
		7	});
		8	$("#UncheckAllRenewals").on("click",function(){
		9	$(".renew:visible").removeAttr("checked");
		10	return false;
		11	});
		12
		13	$("#CheckAllCheckins").on("click",function(){
		14	$("#UncheckAllRenewals").click();
		15	$(".checkin:visible").attr("checked", "checked" );
		16	return false;
		17	});
		18	$("#UncheckAllCheckins").on("click",function(){
		19	$(".checkin:visible").removeAttr("checked");
		20	return false;
		21	});
		22
		23	// Don't allow both return and renew checkboxes to be checked
		24	$(document).on("change", '.renew', function(){
		25	if ( $(this).is(":checked") ) {
		26	$( "#checkin_" + $(this).val() ).removeAttr("checked");
		27	}
		28	});
		29	$(document).on("change", '.checkin', function(){
		30	if ( $(this).is(":checked") ) {
		31	$( "#renew_" + $(this).val() ).removeAttr("checked");
		32	}
		33	});
		34
		35	// Clicking the table cell checks the checkbox inside it
		36	$(document).on("click", 'td', function(e){
		37	if(e.target.tagName.toLowerCase() == 'td'){
		38	$(this).find("input:checkbox:visible").each( function() {
		39	$(this).click();
		40	});
		41	}
		42	});
		43
		44	// Handle renewals and returns
		45	$("#RenewCheckinChecked").on("click",function(){
		46	$(".checkin:checked:visible").each(function() {
		47	itemnumber = $(this).val();
		48
		49	$(this).replaceWith("<img id='checkin_" + itemnumber + "' src='" + interface + "/" + theme + "/img/loading-small.gif' />");
		50
		51	params = {
		52	itemnumber: itemnumber,
		53	borrowernumber: borrowernumber,
		54	branchcode: branchcode,
		55	exempt_fine: $("#exemptfine").is(':checked')
		56	};
		57
		58	$.post( "/cgi-bin/koha/svc/checkin.pl", params, function( data ) {
		59	id = "#checkin_" + data.itemnumber;
		60
		61	content = "";
		62	if ( data.returned ) {
		63	content = CIRCULATION_RETURNED;
		64	} else {
65	content = CIRCULATION_NOT_RETURNED;
66	}
67
68	$(id).replaceWith( content );
69	}, "json")
70	});
71
72	$(".renew:checked:visible").each(function() {
73	var override_limit = $("#override_limit").is(':checked') ? 1 : 0;
74
75	var itemnumber = $(this).val();
76
77	$(this).parent().parent().replaceWith("<img id='renew_" + itemnumber + "' src='" + interface + "/" + theme + "/img/loading-small.gif' />");
78
79	var params = {
80	itemnumber: itemnumber,
81	borrowernumber: borrowernumber,
82	branchcode: branchcode,
83	override_limit: override_limit,
84	date_due: $("#newduedate").val()
85	};
86
87	$.post( "/cgi-bin/koha/svc/renew.pl", params, function( data ) {
88	var id = "#renew_" + data.itemnumber;
89
90	var content = "";
91	if ( data.renew_okay ) {
92	content = CIRCULATION_RENEWED_DUE + " " + data.date_due;
93	} else {
94	content = CIRCULATION_RENEW_FAILED + " ";
95	if ( data.error == "no_checkout" ) {
96	content += NOT_CHECKED_OUT;
97	} else if ( data.error == "too_many" ) {
98	content += TOO_MANY_RENEWALS;
99	} else if ( data.error == "on_reserve" ) {
100	content += ON_RESERVE;
101	} else if ( data.error ) {
102	content += data.error;
103	} else {
104	content += REASON_UNKNOWN;
105	}
106	}
107
108	$(id).replaceWith( content );
109	}, "json")
110	});
111
112	// Prevent form submit
113	return false;
114	});
115
116	$("#RenewAll").on("click",function(){
117	$("#CheckAllRenewals").click();
118	$("#UncheckAllCheckins").click();
119	$("#RenewCheckinChecked").click();
120
121	// Prevent form submit
122	return false;
123	});
124
125	var ymd = $.datepicker.formatDate('yy-mm-dd', new Date());
126
127	var issuesTable;
128	var drawn = 0;
129	issuesTable = $("#issues-table").dataTable({
130	"sDom": "<'row-fluid'<'span6'><'span6'>r>t<'row-fluid'>t",
131	"aaSorting": [[ 0, "desc" ]],
132	"aoColumns": [
133	{
134	"mDataProp": function( oObj ) {
135	if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
136	return "<strong>" + TODAYS_CHECKOUTS + "</strong>";
137	} else {
138	return "<strong>" + PREVIOUS_CHECKOUTS + "</strong>";
139	}
140	}
141	},
142	{
143	"mDataProp": "date_due",
144	"bVisible": false,
145	},
146	{
147	"iDataSort": 1, // Sort on hidden unformatted date due column
148	"mDataProp": function( oObj ) {
149	var today = new Date();
150	var due = new Date( oObj.date_due );
151	if ( today > due ) {
152	return "<span class='overdue'>" + oObj.date_due_formatted + "</span>";
153	} else {
154	return oObj.date_due_formatted;
155	}
156	}
157	},
158	{
159	"mDataProp": function ( oObj ) {
160	title = "<a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
161	+ oObj.biblionumber
162	+ "'>"
163	+ oObj.title;
164
165	$.each(oObj.subtitle, function( index, value ) {
166	title += " " + value.subfield;
167	});
168
169	title += "</a>";
170
171	if ( oObj.author ) {
172	title += " " + BY + " " + oObj.author;
173	}
174
175	if ( oObj.itemnotes ) {
176	var span_class = "";
177	if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
178	span_class = "circ-hlt";
179	}
180	title += " - <span class='" + span_class + "'>" + oObj.itemnotes + "</span>"
181	}
182
183	title += " "
184	+ "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
185	+ oObj.biblionumber
186	+ "&itemnumber="
187	+ oObj.itemnumber
188	+ "#"
189	+ oObj.itemnumber
190	+ "'>"
191	+ oObj.barcode
192	+ "</a>";
193
194	return title;
195	}
196	},
197	{ "mDataProp": "itemtype" },
198	{ "mDataProp": "issuedate" },
199	{ "mDataProp": "branchname" },
200	{ "mDataProp": "itemcallnumber" },
201	{
202	"bSortable": false,
203	"mDataProp": function ( oObj ) {
204	return parseFloat(oObj.charge).toFixed(2);
205	}
206	},
207	{
208	"bSortable": false,
209	"mDataProp": "price" },
210	{
211	"bSortable": false,
212	"mDataProp": function ( oObj ) {
213	var content = "";
214	var span_style = "";
215	var span_class = "";
216
217	content += "<span>";
218	content += "<span style='padding: 0 1em;'>" + oObj.renewals_count + "</span>";
219
220	if ( oObj.can_renew ) {
221	// Do nothing
222	} else if ( oObj.can_renew_error == "on_reserve" ) {
223	content += "<span class='renewals-disabled'>"
224	+ "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + ON_HOLD + "</a>"
225	+ "</span>";
226
227	span_style = "display: none";
228	span_class = "renewals-allowed";
229	} else if ( oObj.can_renew_error == "too_many" ) {
230	content += "<span class='renewals-disabled'>"
231	+ NOT_RENEWABLE
232	+ "</span>";
233
234	span_style = "display: none";
235	span_class = "renewals-allowed";
236	} else {
237	content += "<span class='renewals-disabled'>"
238	+ oObj.can_renew_error
239	+ "</span>";
240
241	span_style = "display: none";
242	span_class = "renewals-allowed";
243	}
244
245	content += "<span class='" + span_class + "' style='" + span_style + "'>"
246	+ "<input type='checkbox' class='renew' id='renew_" + oObj.itemnumber + "' name='renew' value='" + oObj.itemnumber +"'/>"
247	+ "</span>";
248
249	if ( oObj.renewals_remaining ) {
250	content += "<span class='renewals'>("
251	+ oObj.renewals_remaining
252	+ " " + OF + " "
253	+ oObj.renewals_allowed + " "
254	+ RENEWALS_REMAINING + ")</span>";
255	}
256
257	content += "</span>";
258
259
260	return content;
261	}
262	},
263	{
264	"bSortable": false,
265	"mDataProp": function ( oObj ) {
266	if ( oObj.can_renew_error == "on_reserve" ) {
267	return "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + ON_HOLD + "</a>";
268	} else {
269	return "<input type='checkbox' class='checkin' id='checkin_" + oObj.itemnumber + "' name='checkin' value='" + oObj.itemnumber +"'></input>";
270	}
271	}
272	},
273	{
274	"bVisible": exports_enabled ? true : false,
275	"bSortable": false,
276	"mDataProp": function ( oObj ) {
277	return "<input type='checkbox' class='export' id='export_" + oObj.biblionumber + "' name='biblionumbers' value='" + oObj.biblionumber + "' />";
278	}
279	}
280	],
281	"fnFooterCallback": function ( nRow, aaData, iStart, iEnd, aiDisplay ) {
282	var total_charge = 0;
283	var total_price = 0;
284	for ( var i=0; i < aaData.length; i++ ) {
285	total_charge += aaData[i]['charge'] * 1;
286	total_price += aaData[i]['price'] * 1;
287	}
288	var nCells = nRow.getElementsByTagName('td');
289	nCells[1].innerHTML = total_charge.toFixed(2);
290	nCells[2].innerHTML = total_price.toFixed(2);
291	},
292	"bPaginate": false,
293	"bProcessing": true,
294	"bServerSide": false,
295	"sAjaxSource": '/cgi-bin/koha/svc/checkouts.pl',
296	"fnServerData": function ( sSource, aoData, fnCallback ) {
297	aoData.push( { "name": "borrowernumber", "value": borrowernumber } );
298
299	$.getJSON( sSource, aoData, function (json) {
300	fnCallback(json)
301	} );
302	},
303	"fnInitComplete": function(oSettings) {
304	// Disable rowGrouping plugin after first use
305	// so any sorting on the table doesn't use it
306	var oSettings = issuesTable.fnSettings();
307
308	for (f = 0; f < oSettings.aoDrawCallback.length; f++) {
309	if (oSettings.aoDrawCallback[f].sName == 'fnRowGrouping') {
310	oSettings.aoDrawCallback.splice(f, 1);
311	break;
312	}
313	}
314
315	oSettings.aaSortingFixed = null;
316	},
317	}).rowGrouping(
318	{
319	iGroupingOrderByColumnIndex: 0,
320	sGroupingColumnSortDirection: "desc"
321	}
322	);
323
324	if ( $("#issues-table").length ) {
325	$("#issues-table_processing").position({
326	of: $( "#issues-table" ),
327	collision: "none"
328	});
329	}
330
331	// Don't load relatives' issues table unless it is clicked on
332	var relativesIssuesTable;
333	$("#relatives-issues-tab").click( function() {
334	if ( ! relativesIssuesTable ) {
335	relativesIssuesTable = $("#relatives-issues-table").dataTable({
336	"sDom": "<'row-fluid'<'span6'><'span6'>r>t<'row-fluid'>t",
337	"aaSorting": [],
338	"aoColumns": [
339	{
340	"mDataProp": function( oObj ) {
341	var today = new Date();
342	var due = new Date( oObj.date_due );
343	if ( today > due ) {
344	return "<span class='overdue'>" + oObj.date_due_formatted + "</span>";
345	} else {
346	return oObj.date_due_formatted;
347	}
348	}
349	},
350	{
351	"mDataProp": function ( oObj ) {
352	title = "<a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
353	+ oObj.biblionumber
354	+ "'>"
355	+ oObj.title;
356
357	$.each(oObj.subtitle, function( index, value ) {
358	title += " " + value.subfield;
359	});
360
361	title += "</a>";
362
363	if ( oObj.author ) {
364	title += " " + BY + " " + oObj.author;
365	}
366
367	if ( oObj.itemnotes ) {
368	var span_class = "";
369	if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
370	span_class = "circ-hlt";
371	}
372	title += " - <span class='" + span_class + "'>" + oObj.itemnotes + "</span>"
373	}
374
375	title += " "
376	+ "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
377	+ oObj.biblionumber
378	+ "&itemnumber="
379	+ oObj.itemnumber
380	+ "#"
381	+ oObj.itemnumber
382	+ "'>"
383	+ oObj.barcode
384	+ "</a>";
385
386	return title;
387	}
388	},
389	{ "mDataProp": "itemtype" },
390	{ "mDataProp": "issuedate" },
391	{ "mDataProp": "branchname" },
392	{ "mDataProp": "itemcallnumber" },
393	{ "mDataProp": "charge" },
394	{ "mDataProp": "price" },
395	{
396	"mDataProp": function( oObj ) {
397	return "<a href='/cgi-bin/koha/members/moremember.pl?borrowernumber=" + oObj.borrowernumber + "'>"
398	+ oObj.borrower.firstname + " " + oObj.borrower.surname + " (" + oObj.borrower.cardnumber + ")</a>"
399	}
400	},
401	],
402	"bPaginate": false,
403	"bProcessing": true,
404	"bServerSide": true,
405	"sAjaxSource": '/cgi-bin/koha/svc/checkouts.pl',
406	"fnServerData": function ( sSource, aoData, fnCallback ) {
407	$.each(relatives_borrowernumbers, function( index, value ) {
408	aoData.push( { "name": "borrowernumber", "value": value } );
409	});
410
411	$.getJSON( sSource, aoData, function (json) {
412	fnCallback(json)
413	} );
414	},
415	});
416	}
417	});
418
419	if ( $("#relatives-issues-table").length ) {
420	$("#relatives-issues-table_processing").position({
421	of: $( "#relatives-issues-table" ),
422	collision: "none"
423	});
424	}
425
426	if ( AllowRenewalLimitOverride ) {
427	$( '#override_limit' ).click( function () {
428	if ( this.checked ) {
429	$( '.renewals-allowed' ).show(); $( '.renewals-disabled' ).hide();
430	} else {
431	$( '.renewals-allowed' ).hide(); $( '.renewals-disabled' ).show();
432	}
433	} ).attr( 'checked', false );
434	}
435	});

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/js/holds.js (+133 lines)
		1	$(document).ready(function() {
		2	// Don't load holds table unless it is clicked on
		3	var holdsTable;
		4	$("#holds-tab").click( function() {
		5	if ( ! holdsTable ) {
		6	holdsTable = $("#holds-table").dataTable({
		7	"sDom": "<'row-fluid'<'span6'><'span6'>r>t<'row-fluid'>t",
		8	"aoColumns": [
		9	{
		10	"mDataProp": "reservedate_formatted"
		11	},
		12	{
		13	"mDataProp": function ( oObj ) {
		14	title = "<a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
		15	+ oObj.biblionumber
		16	+ "'>"
		17	+ oObj.title;
		18
		19	$.each(oObj.subtitle, function( index, value ) {
		20	title += " " + value.subfield;
		21	});
		22
		23	title += "</a>";
		24
		25	if ( oObj.author ) {
		26	title += " " + BY + " " + oObj.author;
		27	}
		28
		29	if ( oObj.itemnotes ) {
		30	var span_class = "";
		31	if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
		32	span_class = "circ-hlt";
		33	}
		34	title += " - <span class='" + span_class + "'>" + oObj.itemnotes + "</span>"
		35	}
		36
		37	title += " "
		38	+ "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
		39	+ oObj.biblionumber
		40	+ "&itemnumber="
		41	+ oObj.itemnumber
		42	+ "#"
		43	+ oObj.itemnumber
		44	+ "'>"
		45	+ oObj.barcode
		46	+ "</a>";
		47
		48	return title;
		49	}
		50	},
		51	{
		52	"mDataProp": function( oObj ) {
		53	return oObj.itemcallnumber \|\| "";
		54	}
		55	},
		56	{
		57	"mDataProp": function( oObj ) {
		58	var data = "";
		59
		60	if ( oObj.suspend == 1 ) {
		61	data += "<p>" + HOLD_IS + " <strong> " + SUSPENDED + " </strong>";
		62	if ( oObj.suspend_until ) {
		63	data += " " + UNTIL + " " + oObj.suspend_until_formatted;
		64	}
65	data += "</p>";
66	}
67
68	if ( oObj.barcode ) {
69	data += "<em>";
70	if ( oObj.found == "W" ) {
71	data += ITEM_IS + " <strong> " + WAITING + " </strong>";
72
73	if ( ! oObj.waiting_here ) {
74	data += " " + AT + " " + oObj.waiting_at;
75	}
76	} else if ( oObj.transferred ) {
77	data += ITEM_IS + " <strong> " + IN_TRANSIT + " </strong> " + FROM + oObj.from_branch;
78	} else if ( oObj.not_transferred ) {
79	data += NOT_TRANSFERRED_YET + " " + oObj.not_transferred_by;
80	} data += "</em>";
81
82	data += " <a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
83	+ oObj.biblionumber + "'>" + oObj.barcode + "</a>";
84	}
85
86	return data;
87	}
88	},
89	{ "mDataProp": "expirationdate_formatted" },
90	{
91	"mDataProp": function( oObj ) {
92	if ( oObj.priority && parseInt( oObj.priority ) && parseInt( oObj.priority ) > 0 ) {
93	return oObj.priority;
94	} else {
95	return "";
96	}
97	}
98	},
99	{
100	"mDataProp": function( oObj ) {
101	return "<select name='rank-request'>"
102	+ "<option value='n'>" + NO + "</option>"
103	+ "<option value='del'>" + YES + "</option>"
104	+ "</select>"
105	+ "<input type='hidden' name='biblionumber' value='" + oObj.biblionumber + "'>"
106	+ "<input type='hidden' name='borrowernumber' value='" + borrowernumber + "'>"
107	+ "<input type='hidden' name='reserve_id' value='" + oObj.reserve_id + "'>";
108	}
109	}
110	],
111	"bPaginate": false,
112	"bProcessing": true,
113	"bServerSide": true,
114	"sAjaxSource": '/cgi-bin/koha/svc/holds.pl',
115	"fnServerData": function ( sSource, aoData, fnCallback ) {
116	aoData.push( { "name": "borrowernumber", "value": borrowernumber } );
117
118	$.getJSON( sSource, aoData, function (json) {
119	fnCallback(json)
120	} );
121	},
122	});
123
124	if ( $("#holds-table").length ) {
125	$("#holds-table_processing").position({
126	of: $( "#holds-table" ),
127	collision: "none"
128	});
129	}
130	}
131	});
132
133	});

Lines 40-51 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-6 lines)
40	desc: latest to earliest	40	desc: latest to earliest
41	- due date.	41	- due date.
42	-	42	-
43	- pref: UseTablesortForCirc
44	choices:
45	yes: "Enable"
46	no: "Don't enable"
47	- "the sorting of current patron checkouts on the circulation screen. <br/>NOTE: Enabling this function may slow down circulation time for patrons with many checkouts."
48	-
49	- pref: soundon	43	- pref: soundon
50	choices:	44	choices:
51	yes: "Enable"	45	yes: "Enable"

Lines 2-7 Link Here

(-)a/members/moremember.pl (-195 / +16 lines)
2		2
3	# Copyright 2000-2002 Katipo Communications	3	# Copyright 2000-2002 Katipo Communications
4	# Copyright 2010 BibLibre	4	# Copyright 2010 BibLibre
		5	# Copyright 2014 ByWater Solutions
5	#	6	#
6	# This file is part of Koha.	7	# This file is part of Koha.
7	#	8	#
Lines 52-61 use C4::Form::MessagingPreferences; Link Here
52	use List::MoreUtils qw/uniq/;	53	use List::MoreUtils qw/uniq/;
53	use C4::Members::Attributes qw(GetBorrowerAttributes);	54	use C4::Members::Attributes qw(GetBorrowerAttributes);
54	use Koha::Borrower::Debarments qw(GetDebarments);	55	use Koha::Borrower::Debarments qw(GetDebarments);
55	#use Smart::Comments;
56	#use Data::Dumper;
57	use DateTime;	56	use DateTime;
58	use Koha::DateUtils;	57	use Koha::DateUtils;
		58	use Koha::Database;
59		59
60	use vars qw($debug);	60	use vars qw($debug);
61		61
Lines 68-81 my $dbh = C4::Context->dbh; Link Here
68	my $input = CGI->new;	68	my $input = CGI->new;
69	$debug or $debug = $input->param('debug') \|\| 0;	69	$debug or $debug = $input->param('debug') \|\| 0;
70	my $print = $input->param('print');	70	my $print = $input->param('print');
71	my $override_limit = $input->param("override_limit") \|\| 0;
72	my @failedrenews = $input->param('failedrenew');
73	my @failedreturns = $input->param('failedreturn');
74	my $error = $input->param('error');
75	my %renew_failed;
76	for my $renew (@failedrenews) { $renew_failed{$renew} = 1; }
77	my %return_failed;
78	for my $failedret (@failedreturns) { $return_failed{$failedret} = 1; }
79		71
80	my $template_name;	72	my $template_name;
81	my $quickslip = 0;	73	my $quickslip = 0;
Lines 115-122 my ( $template, $loggedinuser, $cookie ) = get_template_and_user( Link Here
115	);	107	);
116	my $borrowernumber = $input->param('borrowernumber');	108	my $borrowernumber = $input->param('borrowernumber');
117		109
118	#start the page and read in includes	110	my ( $od, $issue, $fines ) = GetMemberIssuesAndFines($borrowernumber);
119	my $data = GetMember( 'borrowernumber' => $borrowernumber );	111	$template->param( issuecount => $issue );
		112
		113	my $data = GetMember( 'borrowernumber' => $borrowernumber );
120		114
121	if ( not defined $data ) {	115	if ( not defined $data ) {
122	$template->param (unknowuser => 1);	116	$template->param (unknowuser => 1);
Lines 126-133 if ( not defined $data ) { Link Here
126		120
127	my $category_type = $data->{'category_type'};	121	my $category_type = $data->{'category_type'};
128		122
129	### $category_type
130
131	$debug and printf STDERR "dates (enrolled,expiry,birthdate) raw: (%s, %s, %s)\n", map {$data->{$_}} qw(dateenrolled dateexpiry dateofbirth);	123	$debug and printf STDERR "dates (enrolled,expiry,birthdate) raw: (%s, %s, %s)\n", map {$data->{$_}} qw(dateenrolled dateexpiry dateofbirth);
132	foreach (qw(dateenrolled dateexpiry dateofbirth)) {	124	foreach (qw(dateenrolled dateexpiry dateofbirth)) {
133	my $userdate = $data->{$_};	125	my $userdate = $data->{$_};
Lines 251-264 if ( C4::Context->preference('OPACPrivacy') ) { Link Here
251	$template->param( "privacy".$data->{'privacy'} => 1);	243	$template->param( "privacy".$data->{'privacy'} => 1);
252	}	244	}
253		245
254	# current issues	246	my @relatives = GetMemberRelatives($borrowernumber);
255	#	247	my $relatives_issues_count =
256	my @borrowernumbers = GetMemberRelatives($borrowernumber);	248	Koha::Database->new()->schema()->resultset('Issue')
257	my $issue = GetPendingIssues($borrowernumber);	249	->count( { borrowernumber => \@relatives } );
258	my $relissue = [];	250
259	if ( @borrowernumbers ) {
260	$relissue = GetPendingIssues(@borrowernumbers);
261	}
262	my $roadtype = C4::Koha::GetAuthorisedValueByCode( 'ROADTYPE', $data->{streettype} );	251	my $roadtype = C4::Koha::GetAuthorisedValueByCode( 'ROADTYPE', $data->{streettype} );
263	my $today = DateTime->now( time_zone => C4::Context->tz);	252	my $today = DateTime->now( time_zone => C4::Context->tz);
264	$today->truncate(to => 'day');	253	$today->truncate(to => 'day');
Lines 266-350 my @borrowers_with_issues; Link Here
266	my $overdues_exist = 0;	255	my $overdues_exist = 0;
267	my $totalprice = 0;	256	my $totalprice = 0;
268		257
269	my @issuedata = build_issue_data($issue);
270	my @relissuedata = build_issue_data($relissue);
271
272
273	### ###############################################################################	258	### ###############################################################################
274	# BUILD HTML	259	# BUILD HTML
275	# show all reserves of this borrower, and the position of the reservation ....	260	# show all reserves of this borrower, and the position of the reservation ....
276	if ($borrowernumber) {	261	if ($borrowernumber) {
277		262	$template->param(
278	# new op dev	263	holds_count => Koha::Database->new()->schema()->resultset('Reserve')
279	# now we show the status of the borrower's reservations	264	->count( { borrowernumber => $borrowernumber } ) );
280	my @borrowerreserv = GetReservesFromBorrowernumber($borrowernumber );
281	my @reservloop;
282	foreach my $num_res (@borrowerreserv) {
283	my %getreserv;
284	my $getiteminfo = GetBiblioFromItemNumber( $num_res->{'itemnumber'} );
285	my $itemtypeinfo = getitemtypeinfo( $getiteminfo->{'itemtype'} );
286	my ( $transfertwhen, $transfertfrom, $transfertto ) =
287	GetTransfers( $num_res->{'itemnumber'} );
288
289	foreach (qw(waiting transfered nottransfered)) {
290	$getreserv{$_} = 0;
291	}
292	$getreserv{reservedate} = $num_res->{'reservedate'};
293	foreach (qw(biblionumber title author itemcallnumber )) {
294	$getreserv{$_} = $getiteminfo->{$_};
295	}
296	$getreserv{barcodereserv} = $getiteminfo->{'barcode'};
297	$getreserv{itemtype} = $itemtypeinfo->{'description'};
298
299	# check if we have a waitin status for reservations
300	if ( $num_res->{'found'} eq 'W' ) {
301	$getreserv{color} = 'reserved';
302	$getreserv{waiting} = 1;
303	}
304
305	# check transfers with the itemnumber foud in th reservation loop
306	if ($transfertwhen) {
307	$getreserv{color} = 'transfered';
308	$getreserv{transfered} = 1;
309	$getreserv{datesent} = C4::Dates->new($transfertwhen, 'iso')->output('syspref') or die "Cannot get new($transfertwhen, 'iso') from C4::Dates";
310	$getreserv{frombranch} = GetBranchName($transfertfrom);
311	}
312
313	if ( ( $getiteminfo->{'holdingbranch'} ne $num_res->{'branchcode'} )
314	and not $transfertwhen )
315	{
316	$getreserv{nottransfered} = 1;
317	$getreserv{nottransferedby} =
318	GetBranchName( $getiteminfo->{'holdingbranch'} );
319	}
320	$getreserv{title} = $getiteminfo->{'title'};
321	$getreserv{subtitle} = GetRecordValue('subtitle', GetMarcBiblio($getiteminfo->{biblionumber}), GetFrameworkCode($getiteminfo->{biblionumber}));
322
323	# if we don't have a reserv on item, we put the biblio infos and the waiting position
324	if ( $getiteminfo->{'title'} eq '' ) {
325	my $getbibinfo = GetBiblioData( $num_res->{'biblionumber'} );
326	my $getbibtype = getitemtypeinfo( $getbibinfo->{'itemtype'} );
327	$getreserv{color} = 'inwait';
328	$getreserv{title} = $getbibinfo->{'title'};
329	$getreserv{subtitle} = GetRecordValue('subtitle', GetMarcBiblio($num_res->{biblionumber}), GetFrameworkCode($num_res->{biblionumber}));
330	$getreserv{nottransfered} = 0;
331	$getreserv{itemtype} = $getbibtype->{'description'};
332	$getreserv{author} = $getbibinfo->{'author'};
333	$getreserv{biblionumber} = $num_res->{'biblionumber'};
334	}
335	$getreserv{waitingposition} = $num_res->{'priority'};
336	$getreserv{suspend} = $num_res->{'suspend'};
337	$getreserv{suspend_until} = $num_res->{'suspend_until'};
338	$getreserv{expirationdate} = $num_res->{'expirationdate'};
339	$getreserv{reserve_id} = $num_res->{'reserve_id'};
340
341	push( @reservloop, \%getreserv );
342	}
343
344	# return result to the template
345	$template->param( reservloop => \@reservloop,
346	countreserv => scalar @reservloop,
347	);
348	}	265	}
349		266
350	# current alert subscriptions	267	# current alert subscriptions
Lines 435-447 $template->param( Link Here
435	totalprice => sprintf("%.2f", $totalprice),	352	totalprice => sprintf("%.2f", $totalprice),
436	totaldue => sprintf("%.2f", $total),	353	totaldue => sprintf("%.2f", $total),
437	totaldue_raw => $total,	354	totaldue_raw => $total,
438	issueloop => @issuedata,
439	relissueloop => @relissuedata,
440	overdues_exist => $overdues_exist,	355	overdues_exist => $overdues_exist,
441	error => $error,
442	StaffMember => ($category_type eq 'S'),	356	StaffMember => ($category_type eq 'S'),
443	is_child => ($category_type eq 'C'),	357	is_child => ($category_type eq 'C'),
444	# reserveloop => \@reservedata,
445	samebranch => $samebranch,	358	samebranch => $samebranch,
446	quickslip => $quickslip,	359	quickslip => $quickslip,
447	activeBorrowerRelationship => (C4::Context->preference('borrowerRelationship') ne ''),	360	activeBorrowerRelationship => (C4::Context->preference('borrowerRelationship') ne ''),
Lines 449-548 $template->param( Link Here
449	SuspendHoldsIntranet => C4::Context->preference('SuspendHoldsIntranet'),	362	SuspendHoldsIntranet => C4::Context->preference('SuspendHoldsIntranet'),
450	RoutingSerials => C4::Context->preference('RoutingSerials'),	363	RoutingSerials => C4::Context->preference('RoutingSerials'),
451	debarments => GetDebarments({ borrowernumber => $borrowernumber }),	364	debarments => GetDebarments({ borrowernumber => $borrowernumber }),
		365	relatives_issues_count => $relatives_issues_count,
		366	relatives_borrowernumbers => \@relatives,
452	);	367	);
453	$template->param( $error => 1 ) if $error;
454		368
455	output_html_with_http_headers $input, $cookie, $template->output;	369	output_html_with_http_headers $input, $cookie, $template->output;
456
457	sub build_issue_data {
458	my $issues = shift;
459
460	my $localissue;
461
462	foreach my $issue ( @{$issues} ) {
463
464	# Getting borrower details
465	my $memberdetails = GetMemberDetails( $issue->{borrowernumber} );
466	$issue->{borrowername} =
467	$memberdetails->{firstname} . ' ' . $memberdetails->{surname};
468	$issue->{cardnumber} = $memberdetails->{cardnumber};
469	my $issuedate;
470	if ($issue->{issuedate} ) {
471	$issuedate = $issue->{issuedate}->clone();
472	}
473	$issue->{subtitle} = GetRecordValue('subtitle', GetMarcBiblio($issue->{biblionumber}), GetFrameworkCode($issue->{biblionumber}));
474	$issue->{issuingbranchname} = GetBranchName($issue->{branchcode});
475	my %row = %{$issue};
476	$totalprice += $issue->{replacementprice};
477
478	# item lost, damaged loops
479	if ( $row{'itemlost'} ) {
480	my $fw = GetFrameworkCode( $issue->{biblionumber} );
481	my $category = GetAuthValCode( 'items.itemlost', $fw );
482	my $lostdbh = C4::Context->dbh;
483	my $sth = $lostdbh->prepare(
484	"select lib from authorised_values where category=? and authorised_value =? "
485	);
486	$sth->execute( $category, $row{'itemlost'} );
487	my $loststat = $sth->fetchrow;
488	if ($loststat) {
489	$row{'itemlost'} = $loststat;
490	}
491	}
492	if ( $row{'damaged'} ) {
493	my $fw = GetFrameworkCode( $issue->{biblionumber} );
494	my $category = GetAuthValCode( 'items.damaged', $fw );
495	my $damageddbh = C4::Context->dbh;
496	my $sth = $damageddbh->prepare(
497	"select lib from authorised_values where category=? and authorised_value =? "
498	);
499	$sth->execute( $category, $row{'damaged'} );
500	my $damagedstat = $sth->fetchrow;
501	if ($damagedstat) {
502	$row{'itemdamaged'} = $damagedstat;
503	}
504	}
505
506	# end lost, damaged
507	if ( $issue->{overdue} ) {
508	$overdues_exist = 1;
509	$row{red} = 1;
510	}
511	if ($issuedate) {
512	$issuedate->truncate( to => 'day' );
513	if ( DateTime->compare( $issuedate, $today ) == 0 ) {
514	$row{today} = 1;
515	}
516	}
517
518	#find the charge for an item
519	my ( $charge, $itemtype ) =
520	GetIssuingCharges( $issue->{itemnumber}, $borrowernumber );
521
522	my $itemtypeinfo = getitemtypeinfo($itemtype);
523	$row{'itemtype_description'} = $itemtypeinfo->{description};
524	$row{'itemtype_image'} = $itemtypeinfo->{imageurl};
525
526	$row{'charge'} = sprintf( "%.2f", $charge );
527
528	my ( $renewokay, $renewerror ) =
529	CanBookBeRenewed( $borrowernumber, $issue->{itemnumber},
530	$override_limit );
531	$row{'norenew'} = !$renewokay;
532	$row{'can_confirm'} = ( !$renewokay && $renewerror ne 'on_reserve' );
533	$row{"norenew_reason_$renewerror"} = 1 if $renewerror;
534	$row{renew_failed} = $renew_failed{ $issue->{itemnumber} };
535	$row{return_failed} = $return_failed{ $issue->{barcode} };
536	($row{'renewcount'},$row{'renewsallowed'},$row{'renewsleft'}) = C4::Circulation::GetRenewCount($issue->{'borrowernumber'},$issue->{'itemnumber'}); #Add renewal count to item data display
537
538	$row{'soonestrenewdate'} = output_pref(
539	C4::Circulation::GetSoonestRenewDate(
540	$issue->{borrowernumber},
541	$issue->{itemnumber}
542	)
543	);
544
545	push( @{$localissue}, \%row );
546	}
547	return $localissue;
548	}

Line 0 Link Here

(-)a/svc/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 3 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/svc/checkouts.pl (+167 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 strict;
		23	use warnings;
		24
		25	use CGI;
		26	use JSON qw(to_json);
		27
		28	use C4::Auth qw(check_cookie_auth);
		29	use C4::Biblio qw(GetMarcBiblio GetFrameworkCode GetRecordValue );
		30	use C4::Circulation qw(GetIssuingCharges CanBookBeRenewed GetRenewCount);
		31	use C4::Context;
		32
		33	use Koha::DateUtils;
		34
		35	my $input = new CGI;
		36
		37	my ( $auth_status, $sessionID ) =
		38	check_cookie_auth( $input->cookie('CGISESSID'),
		39	{ circulate => 'circulate_remaining_permissions' } );
		40
		41	if ( $auth_status ne "ok" ) {
		42	exit 0;
		43	}
		44
		45	my @sort_columns = qw/date_due title itype issuedate branchcode itemcallnumber/;
		46
		47	my @borrowernumber = $input->param('borrowernumber');
		48	my $offset = $input->param('iDisplayStart');
		49	my $results_per_page = $input->param('iDisplayLength') \|\| -1;
		50	my $sorting_column = $sort_columns[ $input->param('iSortCol_0') ]
		51	\|\| 'issuedate';
		52	my $sorting_direction = $input->param('sSortDir_0') eq 'asc' ? 'asc' : 'desc';
		53
		54	$results_per_page = undef if ( $results_per_page == -1 );
		55
		56	binmode STDOUT, ":encoding(UTF-8)";
		57	print $input->header( -type => 'text/plain', -charset => 'UTF-8' );
		58
		59	my @parameters;
		60	my $sql = '
		61	SELECT
		62	issuedate,
		63	date_due,
		64
65	biblionumber,
66	biblio.title,
67	author,
68
69	itemnumber,
70	barcode,
71	itemnotes,
72	itemcallnumber,
73	replacementprice,
74
75	issues.branchcode,
76	branchname,
77
78	itype,
79	itemtype,
80
81	borrowernumber,
82	surname,
83	firstname,
84	cardnumber
85	FROM issues
86	LEFT JOIN items USING ( itemnumber )
87	LEFT JOIN biblio USING ( biblionumber )
88	LEFT JOIN biblioitems USING ( biblionumber )
89	LEFT JOIN borrowers USING ( borrowernumber )
90	LEFT JOIN branches ON ( issues.branchcode = branches.branchcode )
91	WHERE borrowernumber
92	';
93
94	if ( @borrowernumber == 1 ) {
95	$sql .= '= ?';
96	}
97	else {
98	$sql = ' IN (' . join( ',', ('?') x @borrowernumber ) . ') ';
99	}
100	push( @parameters, @borrowernumber );
101
102	$sql .= " ORDER BY $sorting_column $sorting_direction ";
103
104	my $dbh = C4::Context->dbh();
105	my $sth = $dbh->prepare($sql);
106	$sth->execute( @parameters );
107
108	my $item_level_itypes = C4::Context->preference('item-level_itypes');
109
110	my @checkouts;
111	while ( my $c = $sth->fetchrow_hashref() ) {
112	my ($charge) = GetIssuingCharges( $c->{itemnumber}, $c->{borrowernumber} );
113
114	my ( $can_renew, $can_renew_error ) =
115	CanBookBeRenewed( $c->{borrowernumber}, $c->{itemnumber} );
116
117	my ( $renewals_count, $renewals_allowed, $renewals_remaining ) =
118	GetRenewCount( $c->{borrowernumber}, $c->{itemnumber} );
119	push(
120	@checkouts,
121	{
122	DT_RowId => $c->{itemnumber} . '-' . $c->{borrowernumber},
123	title => $c->{title},
124	author => $c->{author},
125	barcode => $c->{barcode},
126	itemtype => $item_level_itypes ? $c->{itype} : $c->{itemtype},
127	itemnotes => $c->{itemnotes},
128	branchcode => $c->{branchcode},
129	branchname => $c->{branchname},
130	itemcallnumber => $c->{itemcallnumber} \|\| q{},
131	charge => $charge,
132	price => $c->{replacementprice} \|\| q{},
133	can_renew => $can_renew,
134	can_renew_error => $can_renew_error,
135	itemnumber => $c->{itemnumber},
136	borrowernumber => $c->{borrowernumber},
137	biblionumber => $c->{biblionumber},
138	issuedate => $c->{issuedate},
139	date_due => $c->{date_due},
140	renewals_count => $renewals_count,
141	renewals_allowed => $renewals_allowed,
142	renewals_remaining => $renewals_remaining,
143	issuedate_formatted =>
144	output_pref( dt_from_string( $c->{issuedate} ) ),
145	date_due_formatted =>
146	output_pref_due( dt_from_string( $c->{date_due} ) ),
147	subtitle => GetRecordValue(
148	'subtitle',
149	GetMarcBiblio( $c->{biblionumber} ),
150	GetFrameworkCode( $c->{biblionumber} )
151	),
152	borrower => {
153	surname => $c->{surname},
154	firstname => $c->{firstname},
155	cardnumber => $c->{cardnumber},
156	}
157	}
158	);
159	}
160
161	my $data;
162	$data->{'iTotalRecords'} = scalar @checkouts; #FIXME
163	$data->{'iTotalDisplayRecords'} = scalar @checkouts;
164	$data->{'sEcho'} = $input->param('sEcho') \|\| undef;
165	$data->{'aaData'} = \@checkouts;
166
167	print to_json($data);

Line 0 Link Here

(-)a/svc/holds.pl (+143 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::Branch qw(GetBranchName);
		30	use C4::Charset;
		31	use C4::Circulation qw(GetTransfers);
		32	use C4::Context;
		33
		34	use Koha::Database;
		35	use Koha::DateUtils;
		36
		37	my $input = new CGI;
		38
		39	my ( $auth_status, $sessionID ) =
		40	check_cookie_auth( $input->cookie('CGISESSID'),
		41	{ circulate => 'circulate_remaining_permissions' } );
		42
		43	if ( $auth_status ne "ok" ) {
		44	exit 0;
		45	}
		46
		47	my $branch = C4::Context->userenv->{'branch'};
		48
		49	my $schema = Koha::Database->new()->schema();
		50
		51	my @sort_columns =
		52	qw/reservedate title itemcallnumber barcode expirationdate priority/;
		53
		54	my $borrowernumber = $input->param('borrowernumber');
		55	my $offset = $input->param('iDisplayStart');
		56	my $results_per_page = $input->param('iDisplayLength');
		57	my $sorting_direction = $input->param('sSortDir_0') \|\| 'desc';
		58	my $sorting_column = $sort_columns[ $input->param('iSortCol_0') ]
		59	\|\| 'reservedate';
		60
		61	binmode STDOUT, ":encoding(UTF-8)";
		62	print $input->header( -type => 'text/plain', -charset => 'UTF-8' );
		63
		64	my $holds_rs = $schema->resultset('Reserve')->search(
65	{ borrowernumber => $borrowernumber },
66	{
67	prefetch => { 'item' => 'biblio' },
68	order_by => { "-$sorting_direction" => $sorting_column }
69	}
70	);
71
72	my $borrower;
73	my @holds;
74	while ( my $h = $holds_rs->next() ) {
75	my $item = $h->item();
76
77	my $biblionumber = $h->biblio()->biblionumber();
78
79	my $hold = {
80	DT_RowId => $h->reserve_id(),
81	biblionumber => $biblionumber,
82	title => $h->biblio()->title(),
83	author => $h->biblio()->author(),
84	reserve_id => $h->reserve_id(),
85	reservedate => $h->reservedate(),
86	expirationdate => $h->expirationdate(),
87	suspend => $h->suspend(),
88	suspend_until => $h->suspend_until(),
89	found => $h->found(),
90	waiting => $h->found() eq 'W',
91	waiting_at => $h->branchcode()->branchname(),
92	waiting_here => $h->branchcode()->branchcode() eq $branch,
93	priority => $h->priority(),
94	subtitle => GetRecordValue(
95	'subtitle', GetMarcBiblio($biblionumber),
96	GetFrameworkCode($biblionumber)
97	),
98	reservedate_formatted => $h->reservedate()
99	? output_pref_due( dt_from_string( $h->reservedate() ) )
100	: q{},
101	suspend_until_formatted => $h->suspend_until()
102	? output_pref_due( dt_from_string( $h->suspend_until() ) )
103	: q{},
104	expirationdate_formatted => $h->expirationdate()
105	? output_pref_due( dt_from_string( $h->expirationdate() ) )
106	: q{},
107	};
108
109	$hold->{transfered} = 0;
110	$hold->{not_transfered} = 0;
111
112	if ($item) {
113	$hold->{itemnumber} = $item->itemnumber();
114	$hold->{barcode} = $item->barcode();
115	$hold->{itemtype} = $item->effective_itemtype();
116	$hold->{itemcallnumber} = $item->itemcallnumber() \|\| q{};
117
118	my ( $transferred_when, $transferred_from, $transferred_to ) =
119	GetTransfers( $item->itemnumber() );
120	if ($transferred_when) {
121	$hold->{color} = 'transferred';
122	$hold->{transferred} = 1;
123	$hold->{date_sent} = format_date($transferred_when);
124	$hold->{from_branch} = GetBranchName($transferred_from);
125	}
126	elsif ( $item->holdingbranch()->branchcode() ne
127	$h->branchcode()->branchcode() )
128	{
129	$hold->{not_transferred} = 1;
130	$hold->{not_transferred_by} = $h->branchcode()->branchname();
131	}
132	}
133
134	push( @holds, $hold );
135	}
136
137	my $data;
138	$data->{'iTotalRecords'} = scalar @holds;
139	$data->{'iTotalDisplayRecords'} = scalar @holds;
140	$data->{'sEcho'} = $input->param('sEcho') \|\| undef;
141	$data->{'aaData'} = \@holds;
142
143	print to_json($data);

Line 0 Link Here

(-)a/svc/renew.pl (-1 / +69 lines)
0	-	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 3 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);