use Data::Dump qw(dump);
use autodie;
use locale;
+use Text::Unaccent;
+use Carp qw(confess);
use lib '/srv/koha_ffzg';
use C4::Context;
use XML::LibXML;
use XML::LibXSLT;
-use XML::Simple;
my $dbh = C4::Context->dbh;
+sub debug {
+ my ($title, $data) = @_;
+ print "# $title ",dump($data), $/;
+}
+
my $xslfilename = 'compact.xsl';
+my $auth_header;
+my $auth_department;
+my @authors;
+
+my $skip;
+
+my $sth_auth = $dbh->prepare(q{
+select
+ authid,
+ ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code="a"]') as full_name,
+ ExtractValue(marcxml,'//datafield[@tag="680"]/subfield[@code="a"]') as department
+from auth_header
+});
+
+$sth_auth->execute();
+while( my $row = $sth_auth->fetchrow_hashref ) {
+ if ( $row->{department} !~ m/Filozofski fakultet u Zagrebu/ ) {
+ push @{ $skip->{nije_ffzg} }, $row;
+ next;
+ }
+ $auth_header->{ $row->{authid} } = $row->{full_name};
+ $row->{department} =~ s/, Filozofski fakultet u Zagrebu.*$//;
+ $row->{department} =~ s/^.+\.\s*//;
+# warn dump( $row );
+ push @{ $auth_department->{ $row->{department} } }, $row->{authid};
+ push @authors, $row;
+
+}
+
+debug 'auth_department' => $auth_department;
+
+
my $authors;
my $marcxml;
my $sth_select_authors = $dbh->prepare(q{
select
biblionumber,
- ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code="9"]') as first_author,
- ExtractValue(marcxml,'//datafield[@tag="700"]/subfield[@code="9"]') as other_authors,
- ExtractValue(marcxml,'//datafield[@tag="942"]/subfield[@code="t"]') as category,
itemtype,
marcxml
from biblioitems
where
agerestriction > 0
- and SUBSTR(ExtractValue(marcxml,'//controlfield[@tag="008"]'),8,4) between 2008 and 2013
-order by SUBSTR(ExtractValue(marcxml,'//controlfield[@tag="008"]'),8,4) desc
});
+=for sql
+-- ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code="9"]') as first_author,
+-- ExtractValue(marcxml,'//datafield[@tag="700"]/subfield[@code="9"]') as other_authors,
+-- ExtractValue(marcxml,'//datafield[@tag="942"]/subfield[@code="t"]') as category,
+
+-- and SUBSTR(ExtractValue(marcxml,'//controlfield[@tag="008"]'),8,4) between 2008 and 2013
+-- order by SUBSTR(ExtractValue(marcxml,'//controlfield[@tag="008"]'),8,4) desc
+=cut
+
+my $biblio_year;
+my $type_stats;
+
+my $parser = XML::LibXML->new();
+$parser->recover_silently(0); # don't die when you find &, >, etc
+my $style_doc = $parser->parse_file($xslfilename);
+my $xslt = XML::LibXSLT->new();
+my $parsed = $xslt->parse_stylesheet($style_doc);
+
+my $biblio_html;
+
+open(my $xml_fh, '>', '/tmp/bibliografija.xml') if $ENV{XML};
+
+sub biblioitem_html {
+ my $biblionumber = shift;
+
+ return $biblio_html->{$biblionumber} if exists $biblio_html->{$biblionumber};
+
+ my $xmlrecord = $marcxml->{$biblionumber} || confess "missing $biblionumber marcxml";
+
+ print $xml_fh $xmlrecord if $ENV{XML};
+
+ my $source = eval { $parser->parse_string($xmlrecord) };
+ if ( $@ ) {
+# warn "SKIP $biblionumber corrupt XML";
+ push @{ $skip->{XML_corrupt} }, $biblionumber;
+ return;
+ }
+
+ my $transformed = $parsed->transform($source);
+ $biblio_html->{$biblionumber} = $parsed->output_string( $transformed );
+
+ return ( $biblio_html->{$biblionumber}, $source ) if wantarray;
+ return $biblio_html->{$biblionumber};
+}
+
$sth_select_authors->execute();
while( my $row = $sth_select_authors->fetchrow_hashref ) {
# warn dump($row),$/;
- if ( $row->{first_author} || $row->{itemtype} !~ m/^KNJ/ ) {
- my $all_authors = join(' ', $row->{first_author}, $row->{other_authors});
- foreach my $authid ( split(/\s+/, $all_authors) ) {
- push @{ $authors->{$authid}->{ $row->{category} } }, $row->{biblionumber};
- $marcxml->{ $row->{biblionumber} } = $row->{marcxml};
- }
- } else {
- my $xml = XMLin( $row->{marcxml}, ForceArray => [ 'subfield' ] );
- foreach my $f700 ( map { $_->{subfield} } grep { $_->{tag} eq 700 } @{ $xml->{datafield} } ) {
- my $authid = 0;
- my $is_edt = 0;
- foreach my $sf ( @$f700 ) {
- if ( $sf->{code} eq '4' && $sf->{content} =~ m/^edt/ ) {
- $is_edt++;
- } elsif ( $sf->{code} eq '9' ) {
- $authid = $sf->{content};
- }
+
+ my $biblio;
+
+ $marcxml->{ $row->{biblionumber} } = $row->{marcxml};
+
+ my ( undef, $doc ) = biblioitem_html( $row->{biblionumber} );
+ if ( ! $doc ) {
+ warn "ERROR can't parse MARCXML ", $row->{biblionumber}, " ", $row->{marcxml}, "\n";
+ next;
+ }
+
+ my $root = $doc->documentElement;
+=for leader
+ my @leaders = $root->getElementsByLocalName('leader');
+ if (@leaders) {
+ my $leader = $leaders[0]->textContent;
+ warn "leader $leader\n";
+ }
+=cut
+
+ my $extract = {
+ '008' => undef,
+ '100' => '9',
+ '700' => '(9|4)',
+ '942' => 't'
+ };
+
+ my $data;
+
+ foreach my $elt ($root->getChildrenByLocalName('*')) {
+ my $tag = $elt->getAttribute('tag');
+ next if ! $tag;
+ next unless exists $extract->{ $tag };
+
+ if ($elt->localname eq 'controlfield') {
+ if ( $tag eq '008' ) {
+ $biblio_year->{ $row->{biblionumber} } = substr($elt->textContent, 7, 4 );
}
- if ( $authid && $is_edt ) {
-# warn "# ++ ", $row->{biblionumber}, " $authid f700 ", dump( $f700 );
- push @{ $authors->{$authid}->{ $row->{category} } }, $row->{biblionumber};
- $marcxml->{ $row->{biblionumber} } = $row->{marcxml};
- } else {
-# warn "# -- ", $row->{biblionumber}, " f700 ", dump( $f700 );
+ next;
+ } elsif ($elt->localname eq 'datafield') {
+ my $sf_data;
+ foreach my $sfelt ($elt->getChildrenByLocalName('subfield')) {
+ my $sf = $sfelt->getAttribute('code');
+ next unless $sf =~ m/$extract->{$tag}/;
+ if ( exists $sf_data->{$sf} ) {
+ $sf_data->{$sf} .= " " . $sfelt->textContent();
+ } else {
+ $sf_data->{$sf} = $sfelt->textContent();
+ }
}
- }
+ push @{ $data->{$tag} }, $sf_data if $sf_data;
+ }
+ }
+
+# warn "# ", $row->{biblionumber}, " data ",dump($data);
+
+ my $category = $data->{942}->[0]->{'t'};
+ if ( ! $category ) {
+# warn "# SKIP ", $row->{biblionumber}, " no category in ", dump($data);
+ push @{ $skip->{no_category} }, $row->{biblionumber};
+ next;
}
-}
-my $auth_header;
-my @authors;
-my $all_authids = join(',', grep { length($_) > 0 } keys %$authors);
-my $sth_auth = $dbh->prepare(q{
-select
- authid,
- ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code="a"]') as full_name
-from auth_header
-where
- ExtractValue(marcxml,'//datafield[@tag="024"]/subfield[@code="a"]') <> '' and
- authid in (} . $all_authids . q{)
-});
+ my $have_100 = 1;
-$sth_auth->execute();
-while( my $row = $sth_auth->fetchrow_hashref ) {
-# warn dump( $row );
- $auth_header->{ $row->{authid} } = $row->{full_name};
- push @authors, $row;
+ if ( exists $data->{100} ) {
+ my @first_author = map { $_->{'9'} } @{ $data->{100} };
+ foreach my $authid ( @first_author ) {
+ push @{ $authors->{$authid}->{aut}->{ $category } }, $row->{biblionumber};
+ }
+ } else {
+ $have_100 = 0;
+ }
+
+ my $have_edt;
+
+ if ( exists $data->{700} ) {
+ foreach my $auth ( @{ $data->{700} } ) {
+ my $authid = $auth->{9} || next;
+ my $type = $auth->{4} || next; #die "no 4 in ",dump($data);
+
+ $type_stats->{$type}++;
+
+ if ( $type =~ m/(edt|trl|com|ctb)/ ) {
+ push @{ $authors->{$authid}->{sec}->{ $category } }, $row->{biblionumber};
+ push @{ $authors->{$authid}->{$1}->{ $category } }, $row->{biblionumber};
+ } elsif ( $type =~ m/aut/ ) {
+ if ( ! $have_100 ) {
+ $have_edt = grep { exists $_->{4} && $_->{4} =~ m/edt/ } @{ $data->{700} } if ! defined $have_edt;
+ if ( $have_edt ) {
+ $skip->{ have_700_edt }->{ $row->{biblionumber} }++;
+ } else {
+ push @{ $authors->{$authid}->{aut}->{ $category } }, $row->{biblionumber};
+ }
+ } else {
+ push @{ $authors->{$authid}->{aut}->{ $category } }, $row->{biblionumber};
+ }
+ } else {
+# warn "# SKIP ", $row->{biblionumber}, ' no 700$4 in ', dump($data);
+ $skip->{ 'no_700$4' }->{ $row->{biblionumber} }++;
+ }
+ }
+ }
}
+debug 'authors' => $authors;
+debug 'type_stats' => $type_stats;
+debug 'skip' => $skip;
+debug 'biblio_year' => $biblio_year;
+
my $category_label;
my $sth_categories = $dbh->prepare(q{
select authorised_value, lib from authorised_values where category = 'BIBCAT'
$category_label->{ $row->{authorised_value} } = $row->{lib};
}
-#warn dump( $category_label );
+debug 'category_label' => $category_label;
sub html_title {
return qq|<html>
return qq|</body>\n</html\n|;
}
+mkdir 'html' unless -d 'html';
-sub biblioitem_html {
- my $biblionumber = shift;
+open(my $index, '>:encoding(utf-8)', 'html/index.new');
+print $index html_title('Bibliografija Filozofskog fakulteta');
- my $xmlrecord = $marcxml->{$biblionumber} || die "missing $biblionumber marcxml";
+my $first_letter = '';
- my $parser = XML::LibXML->new();
- $parser->recover_silently(0); # don't die when you find &, >, etc
- my $source = $parser->parse_string($xmlrecord);
- my $style_doc = $parser->parse_file($xslfilename);
+debug 'authors' => \@authors;
- my $xslt = XML::LibXSLT->new();
- my $parsed = $xslt->parse_stylesheet($style_doc);
- my $transformed = $parsed->transform($source);
- return $parsed->output_string( $transformed );
+sub li_biblio {
+ my ($biblionumber) = @_;
+ return qq|<li>|,
+ qq|<a href="https://koha.ffzg.hr/cgi-bin/koha/opac-detail.pl?biblionumber=$biblionumber">$biblionumber</a>|,
+ biblioitem_html($biblionumber),
+ qq|<a href="https://koha.ffzg.hr:8443/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=$biblionumber">edit</a>|,
+ qq|</li>\n|;
}
+sub author_html {
+ my ( $fh, $authid, $type, $label ) = @_;
-mkdir 'html' unless -d 'html';
+ return unless exists $authors->{$authid}->{$type};
-open(my $index, '>:encoding(utf-8)', 'html/index.html');
-print $index html_title('Bibliografija Filozogskog fakulteta');
+ print $fh qq|<h2>$label</h2>\n|;
-my $first_letter;
+ foreach my $category ( sort keys %{ $authors->{$authid}->{$type} } ) {
+ my $label = $category_label->{$category} || 'Bez kategorije';
+ print $fh qq|<h3>$label</h3>\n<ul>\n|;
+ foreach my $biblionumber ( @{ $authors->{$authid}->{$type}->{$category} } ) {
+ print $fh li_biblio( $biblionumber );
+ }
+ print $fh qq|</ul>\n|;
+ }
+}
foreach my $row ( sort { $a->{full_name} cmp $b->{full_name} } @authors ) {
}
print $index qq{<li><a href="}, $row->{authid}, qq{.html">}, $row->{full_name}, "</a></li>\n";
- open(my $fh, '>:encoding(utf-8)', "html/$row->{authid}.html");
+ my $path = "html/$row->{authid}";
+ open(my $fh, '>:encoding(utf-8)', "$path.new");
print $fh html_title($row->{full_name}, "bibliografija");
- foreach my $category ( sort keys %{ $authors->{ $row->{authid} } } ) {
- my $label = $category_label->{$category} || 'Bez kategorije';
- print $fh qq|<h1>$label</h1>\n<ul>\n|;
- foreach my $biblionumber ( @{ $authors->{ $row->{authid} }->{$category} } ) {
- print $fh qq|<li><a href="https://koha.ffzg.hr/cgi-bin/koha/opac-detail.pl?biblionumber=$biblionumber">$biblionumber</a>|, biblioitem_html($biblionumber), qq|</li>\n|;
- }
- print $fh qq|</ul>\n|;
- }
+ print $fh qq|<h1>$row->{full_name} - bibliografija za razdoblje 2008-2013</h1>|;
+
+ author_html( $fh, $row->{authid}, 'aut' => 'Primarno autorstvo' );
+ author_html( $fh, $row->{authid}, 'sec' => 'Sekundarno autorstvo' );
+
print $fh html_end;
close($fh);
+ rename "$path.new", "$path.html";
}
print $index html_end;
+close($index);
+rename 'html/index.new', 'html/index.html';
+
+debug 'auth_header' => $auth_header;
+
+
+my $department_category_author;
+foreach my $department ( sort keys %$auth_department ) {
+ foreach my $authid ( sort @{ $auth_department->{$department} } ) {
+ my @categories = keys %{ $authors->{$authid}->{aut} };
+ push @categories, keys %{ $authors->{$authid}->{sec} };
+ foreach my $category ( sort @categories ) {
+ push @{ $department_category_author->{$department}->{$category} }, $authid;
+ }
+ }
+}
+
+debug 'department_category_author' => $department_category_author;
+
+mkdir 'html/departments' unless -d 'html/departments';
+
+sub unique_biblionumber {
+ my @v = @_;
+ my $u;
+ $u->{$_}++ foreach @v;
+ return sort { $biblio_year->{$b} <=> $biblio_year->{$a} || $a <=> $b } keys %$u;
+}
+
+open(my $dep_fh, '>:encoding(utf-8)', 'html/departments/index.new');
+print $dep_fh html_title('Odsijeci Filozofskog fakulteta u Zagrebu'), qq|<ul>\n|;
+foreach my $department ( sort keys %$department_category_author ) {
+ my $dep = $department || 'Nema odsjeka';
+ my $dep_file = unac_string('utf-8',$dep);
+ print $dep_fh qq|<li><a href="$dep_file.html">$dep</a></li>\n|;
+ open(my $fh, '>:encoding(utf-8)', "html/departments/$dep_file.new");
+
+ print $fh html_title($department . ' bibliografija');
+ print $fh qq|<h1>$department bibliografija</h1>\n|;
+
+ print $fh qq|<h2>Primarno autorstvo</h2>\n|;
+
+ foreach my $category ( sort keys %{ $department_category_author->{$department} } ) {
+
+ my @authids = @{ $department_category_author->{$department}->{$category} };
+ next unless @authids;
+
+ my @biblionumber = unique_biblionumber map { @{ $authors->{$_}->{aut}->{$category} } } grep { exists $authors->{$_}->{aut}->{$category} } @authids;
+ my $unique;
+ $unique->{$_}++ foreach @biblionumber;
+
+ next unless @biblionumber;
+
+ my $label = $category_label->{$category} || 'Bez kategorije';
+ print $fh qq|<h3>$label</h3>\n<ul>\n|;
+
+ print $fh li_biblio( $_ ) foreach @biblionumber;
+
+ print $fh qq|</ul>|;
+ }
+
+
+ print $fh qq|<h2>Sekundarno autorstvo</h2>\n|;
+
+ foreach my $category ( sort keys %{ $department_category_author->{$department} } ) {
+
+ my @authids = @{ $department_category_author->{$department}->{$category} };
+ next unless @authids;
+
+ my @biblionumber = unique_biblionumber map { @{ $authors->{$_}->{sec}->{$category} } } grep { exists $authors->{$_}->{sec}->{$category} } @authids;
+
+ next unless @biblionumber;
+
+ my $label = $category_label->{$category} || 'Bez kategorije';
+ print $fh qq|<h3>$label</h3>\n<ul>\n|;
+
+ print $fh li_biblio( $_ ) foreach @biblionumber;
+
+ print $fh qq|</ul>|;
+ }
+
+
+ print $fh html_end;
+ close($fh);
+ rename "html/departments/$dep_file.new", "html/departments/$dep_file.html";
+}
+print $dep_fh qq|</ul>\n|, html_end;
+close($dep_fh);
+rename 'html/departments/index.new', 'html/departments/index.html';
+
+my $azvo_stat;
+
+foreach my $department ( sort keys %$department_category_author ) {
+ foreach my $category ( sort keys %{ $department_category_author->{$department} } ) {
+ foreach my $authid ( @{ $department_category_author->{$department}->{$category} } ) {
+ foreach my $type ( keys %{ $authors->{$authid} } ) {
+ next unless exists $authors->{$authid}->{$type}->{$category};
+ $azvo_stat->{ $department }->{ $category }->{ $type } += $#{ $authors->{$authid}->{$type}->{$category} } + 1;
+ }
+ }
+ }
+}
+
+debug 'azvo_stat' => $azvo_stat;
-#print dump( $authors );
+=for later
+open(my $fh, '>', 'html/azvo.new');
-#print dump( $auth_header );
+close($fh);
+rename 'html/azvo.new', 'html/azvo.html';
+=cut
projects / koha-bibliografija / blobdiff