Performance improvement authorities-list.pl

[koha.git] / authorities / authorities-list.pl

diff --git a/authorities/authorities-list.pl b/authorities/authorities-list.pl
index 4359489..9c472f1 100644 (file)
--- a/authorities/authorities-list.pl
+++ b/authorities/authorities-list.pl
@@ -4,6 +4,8 @@ use warnings;
 use C4::Context;
 use C4::AuthoritiesMarc;
 use utf8;
+use open qw( :std :utf8 );
+
 my $dbh=C4::Context->dbh;
 my $datatypes_query = $dbh->prepare(<<ENDSQL);
 SELECT authtypecode,authtypetext,auth_tag_to_report from auth_types;
@@ -17,10 +19,13 @@ SELECT authid, authtypecode from auth_header
 ENDSQL
 $data_query->execute;
 my $dataauthorities=$data_query->fetchall_arrayref({});
-print "id;authtype;heading;count usage\n";
 foreach my $authority (@$dataauthorities){
   my $marcauthority=GetAuthority($authority->{'authid'});
+  my $query;
+  $query= "an=".$authority->{'authid'};
+  # search for biblios mapped
+  my ($err,$res,$used) = C4::Search::SimpleSearch($query,0,10);
   if ($marcauthority && $marcauthority->field($authtypes{$authority->{'authtypecode'}}->{'tag'})){
-    print qq($authority->{'authid'};"),$authtypes{$authority->{'authtypecode'}}->{'lib'},qq(";"),$marcauthority->field($authtypes{$authority->{'authtypecode'}}->{"tag"})->as_string(),qq(";), CountUsage($authority->{authid}),"\n";
+    print qq("),$marcauthority->field($authtypes{$authority->{'authtypecode'}}->{"tag"})->as_string(),qq(";),qq($authority->{'authid'};"),$authtypes{$authority->{'authtypecode'}}->{'lib'},qq(";$used\n);
   }
 }