my $sth_select_authors = $dbh->prepare(q{
select
- biblionumber,
+ biblioitems.biblionumber,
itemtype,
- marcxml
+ metadata as marcxml
from biblioitems
+join biblio_metadata on (biblio_metadata.biblionumber = biblioitems.biblionumber)
where
agerestriction > 0
});
}
+my $authid_fullname;
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";
+ $authid_fullname->{ $row->{authid} } = $row->{full_name};
+
my $path = "html/$row->{authid}";
open(my $fh, '>:encoding(utf-8)', "$path.new");
print $fh html_title($row->{full_name}, "bibliografija");
debug 'auth_header' => $auth_header;
+debug 'authid_fullname' => $authid_fullname;
my $department_category_author;
foreach my $department ( sort keys %$auth_department ) {
foreach my $bib_num ( @biblionumber ) {
my @li = li_biblio( $bib_num );
my $li_html = join('', @li);
- $li_html =~ s{<a name="col-\d+"></a>}{}gs;
+ $li_html =~ s{<a name="(col-\d+)"/a>}{<!-- $1 -->}gs;
print $fh $li_html;
next unless $csv_fh;
my $year = $li[1];
my @html;
foreach ( split(/<a name="col-/, $li[4]) ) {
- if ( s{(\d+)"></a>}{} ) {
- $html[$1] = $_;
+ if ( s{^(\d+)"></a>}{} ) {
+ my $nr = $1;
+ s{\s+}{ }gs;
+ $html[$nr] = $_;
} else {
warn "SKIPPED: Can't find col in [$_] from $li[4]" unless m/^<[^>]+>$/;
}
my $label;
my $sub_labels;
-open(my $report, '<:encoding(utf-8)', 'AZVO.txt');
+open(my $report, '<:encoding(utf-8)', 'nAZVO.txt');
while( <$report> ) {
chomp;
if ( /^([^\t]+)\t+(.+)/ ) {
} # group
-debug 'table', $table;
+#debug 'table', $table;
open(my $fh, '>:encoding(utf-8)', 'html/azvo.new');
open(my $fh2, '>:encoding(utf-8)', 'html/azvo2.new');
rename 'html/azvo.new', 'html/azvo.html';
rename 'html/azvo2.new', 'html/azvo2.html';
+my $dep_au_count;
+
+foreach my $department ( @departments ) {
+ foreach my $line ( @report_lines ) {
+ my $label = $line->[0];
+ my @biblionumbers;
+ foreach ( 1 .. $#$line ) {
+ my ( $category, $type ) = @{ $line->[ $_ ] };
+
+ foreach my $authid ( @{ $auth_department->{$department} } ) {
+ next unless exists $authors->{$authid}->{$type}->{$category};
+ my @biblionumbers = @{ $authors->{$authid}->{$type}->{$category} };
+
+ $dep_au_count->{ $department }->{ $authid }->{ $label } += scalar @biblionumbers;
+ }
+ }
+ }
+}
+
+debug 'dep_au_count', $dep_au_count;
+
+mkdir 'html/dep_au' unless -d 'html/dep_au';
+open(my $dep_fh, '>', 'html/dep_au/index.new');
+print $dep_fh html_title('Odsjeci Filozofskog fakulteta u Zagrebu'), qq|<ul>\n|;
+foreach my $department ( sort keys %{ $dep_au_count } ) {
+
+ 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/dep_au/$dep_file.new");
+
+ print $fh html_title($department . ' bibliografija tablica');
+
+ # FIXME table
+ print $fh qq|<table>\n<tr><th></th><th>|
+ , join('</th><th>', @report_labels )
+ , qq|</th></tr>\n|
+ ;
+
+ foreach my $authid ( keys %{ $dep_au_count->{ $department } } ) {
+ print $fh qq|<tr><th>$authid_fullname->{$authid}</th><th>|
+ , join('</th><th>', map { $dep_au_count->{$department}->{$authid}->{$_} || '-' } @report_labels )
+ , qq|</th></tr>\n|
+ ;
+ }
+
+
+ print $fh qq|</table>\n|;
+
+ print $fh html_end;
+ close($fh);
+ rename "html/dep_au/$dep_file.new", "html/dep_au/$dep_file.html";
+}
+
+print $dep_fh html_end;
+close($dep_fh);
+rename "html/dep_au/index.new", "html/dep_au/index.html";
+
unlink $pid_file;