AutoSelfCheckPatronDoesNotHaveSelfCheckPerm => not ( $has_self_checkout_perm ),
AutoSelfCheckPatronHasTooManyPerm => $has_other_permissions,
);
-
-
}
+{
+ my $dbh = C4::Context->dbh;
+ my $patrons = $dbh->selectall_arrayref(
+ q|select b.borrowernumber from borrowers b join deletedborrowers db on b.borrowernumber=db.borrowernumber|,
+ { Slice => {} }
+ );
+ my $biblios = $dbh->selectall_arrayref(
+ q|select b.biblionumber from biblio b join deletedbiblio db on b.biblionumber=db.biblionumber|,
+ { Slice => {} }
+ );
+ my $items = $dbh->selectall_arrayref(
+ q|select i.itemnumber from items i join deleteditems di on i.itemnumber=di.itemnumber|,
+ { Slice => {} }
+ );
+ my $checkouts = $dbh->selectall_arrayref(
+ q|select i.issue_id from issues i join old_issues oi on i.issue_id=oi.issue_id|,
+ { Slice => {} }
+ );
+ my $holds = $dbh->selectall_arrayref(
+ q|select r.reserve_id from reserves r join old_reserves o on r.reserve_id=o.reserve_id|,
+ { Slice => {} }
+ );
+ if ( @$patrons or @$biblios or @$items or @$checkouts or @$holds ) {
+ $template->param(
+ has_ai_issues => 1,
+ ai_patrons => $patrons,
+ ai_biblios => $biblios,
+ ai_items => $items,
+ ai_checkouts => $checkouts,
+ ai_holds => $holds,
+ );
+ }
+}
my %versions = C4::Context::get_versions();
$template->param(
shift @lines; #remove header row
foreach (@lines) {
- my ( $date, $desc, $tag ) = split(/\t/);
+ my ( $epoch, $date, $desc, $tag ) = split(/\t/);
if(!$desc && $date=~ /(?<=\d{4})\s+/) {
($date, $desc)= ($`, $');
}