generate csv output for AAA_ukupno
[koha-bibliografija] / html.pl
diff --git a/html.pl b/html.pl
index ac4aeb3..8467a55 100755 (executable)
--- a/html.pl
+++ b/html.pl
@@ -21,6 +21,20 @@ use C4::Context;
 use XML::LibXML;
 use XML::LibXSLT;
 
+my $pid_file = '/dev/shm/bibliografija.pid';
+{
+       if ( -e $pid_file ) {
+               open(my $fh, '<', $pid_file);
+               my $pid = <$fh>;
+               no autodie; # it will die on kill
+               kill 0, $pid || die "$0 allready running as pid $pid";
+       }
+       open(my $fh, '>', $pid_file);
+       print $fh $$;
+       close($fh);
+}
+
+
 my $dbh = C4::Context->dbh;
 
 sub debug {
@@ -100,7 +114,7 @@ while( my $row = $sth_auth->fetchrow_hashref ) {
 debug 'department_in_group' => $department_in_group;
 
 foreach my $department ( keys %$department_in_sum ) {
-       $department_in_sum->{$department} = 0 unless $department =~ m/(centar|croaticum|katedra|odsjek)/i;
+#      $department_in_sum->{$department} = 0 unless $department =~ m/(centar|croaticum|katedra|odsjek)/i;
 }
 
 debug 'auth_department' => $auth_department;
@@ -311,13 +325,14 @@ while( my $row = $sth_select_authors->fetchrow_hashref ) {
 
                                $type_stats->{$type}++;
 
-                               my @types = split(/\s+/, $type);
+                               my @types = split(/[\s\/]+/, $type);
 
                                foreach my $type ( @types ) {
+                                       my $type = substr($type,0,3);
                                        $type_stats->{_count_each_type}->{$type}++;
 
                                        if ( $type =~ m/(edt|trl|com|ctb)/ ) {
-                                               push @{ $authors->{$authid}->{sec}->{ $category } }, $row->{biblionumber};
+                                               push @{ $authors->{$authid}->{__sec}->{ $category } }, $row->{biblionumber};
                                                push @{ $authors->{$authid}->{$type}->{ $category } }, $row->{biblionumber};
                                                $type =~ s/(com|ctb)/_ostalo/;
                                                push @{ $authors->{$authid}->{$type}->{ $category } }, $row->{biblionumber};
@@ -373,6 +388,7 @@ sub html_title {
 <title>|, join(" ", @_), qq|</title>
 <link href="style.css" type="text/css" rel="stylesheet" />
 <script src="//code.jquery.com/jquery-1.11.2.js"></script>
+<script src="filters.js"></script>
 </head>
 <body>
 |;
@@ -403,15 +419,19 @@ sub li_biblio {
                qq|</li>\n|;
 }
 
+sub unique {
+       my $unique;
+       $unique->{$_}++ foreach @_;
+       return keys %$unique;
+}
+
 sub unique_biblionumber {
-       my @v = @_;
-       my $u;
-       $u->{$_}++ foreach @v;
+       my @v = unique @_;
        return sort {
                $biblio_year->{$b} <=> $biblio_year->{$a} ||
                $biblio_full_name->{$a} cmp $biblio_full_name->{$b} ||
                $a <=> $b
-       } keys %$u;
+       } @v;
 }
 
 sub author_html {
@@ -431,30 +451,33 @@ sub author_html {
        }
 }
 
+my @toc_type_label = (
+'aut' => 'Primarno autorstvo',
+'edt' => 'Uredništva',
+'trl' => 'Prijevodi',
+'_ostalo' => 'Ostalo',
+);
+
 
 sub count_author_years {
        my $years = shift;
        my ($authid) = @_;
        foreach my $type ( keys %{ $authors->{$authid} } ) {
+#              next if $type =~ m/^_/; # FIXME
                foreach my $category ( keys %{ $authors->{$authid}->{$type} } ) {
-                       foreach my $biblionumber ( @{ $authors->{$authid}->{$type}->{$category} } ) {
-                               $years->{ $biblio_year->{ $biblionumber } }->{ $type . '-' . $category }++;
+                       foreach my $biblionumber ( unique_biblionumber @{ $authors->{$authid}->{$type}->{$category} } ) {
+                               $years->{ $biblio_year->{ $biblionumber } }->{ $type . '-' . $category }->{ $biblionumber }++;
                        }
                }
        }
        return $years;
 }
 
-my @toc_type_label = (
-'aut' => 'Primarno autorstvo',
-'edt' => 'Uredništva',
-'trl' => 'Prijevodi',
-'_ostalo' => 'Ostalo',
-);
-
 sub html_year_selection {
        my $fh = shift;
-       my @authids = @_;
+       my @authids = unique @_;
+
+       debug 'html_year_selection authids=', [ @authids ];
 
        print $fh qq|<span id="years">Godine:\n|;
        my $type_cat_count = {};
@@ -464,13 +487,17 @@ sub html_year_selection {
                $years = count_author_years( $years, $authid );
        }
 
+       debug 'years' => $years;
+
        foreach my $year ( sort { $b <=> $a } keys %$years ) {
                print $fh qq|<label><input name="year_selection" value="$year" type=checkbox onClick="toggle_year($year, this)" checked="checked">$year</label>&nbsp;\n|;
                foreach my $type_cat ( keys %{ $years->{$year} } ) {
-                       $type_cat_count->{ $type_cat } += $years->{$year}->{$type_cat};
+                       my $count = scalar keys %{ $years->{$year}->{$type_cat} };
+                       $years->{$year}->{$type_cat} = $count; # remove biblionumbers and use count
+                       $type_cat_count->{ $type_cat } += $count;
                        my ($type,$cat) = split(/-/, $type_cat);
                        $type_cat_count->{_toc}->{$type}->{$cat}++;
-                       $type_cat_count->{_toc_count}->{$type} += $years->{$year}->{$type_cat};
+                       $type_cat_count->{_toc_count}->{$type} += $count;
                }
        }
 
@@ -488,68 +515,12 @@ var years = |, encode_json($years), q|;
 
 var type_cat_count = |, encode_json($type_cat_count), q|;
 
-function year_show(year) {
-       $('.y'+year).show();
-       console.debug('show', year);
-       for(var type_cat in years[year]) {
-               if ( ( type_cat_count[ type_cat ] += years[year][type_cat] ) == years[year][type_cat]) {
-                       $('a[name="'+type_cat+'"]').show();
-                       console.debug(type_cat, 'show');
-               }
-               $('#toc-count-'+type_cat.replace('.','-')).text( type_cat_count[ type_cat ] );
-       }
-}
-
-function year_hide(year) {
-       $('.y'+year).hide();
-       console.debug('hide', year);
-       for(var type_cat in years[year]) {
-               if ( ( type_cat_count[ type_cat ] -= years[year][type_cat] ) == 0 ) {
-                       $('a[name="'+type_cat+'"]').hide();
-                       console.debug(type_cat, 'hide');
-               }
-               $('#toc-count-'+type_cat.replace('.','-')).text( type_cat_count[ type_cat ] );
-       }
-}
-
-function toggle_year(year, el) {
-       if ( el.checked ) {
-               year_show(year);
-       } else {
-               year_hide(year);
-       }
-}
-
-function all_years( turn_on ) {
-       $('input[name=year_selection]').each( function(i,el) {
-               if ( turn_on ) {
-                       if ( ! el.checked ) {
-                               el.checked = true;
-                               year_show( el.value );
-                       }
-               } else {
-                       if ( el.checked ) {
-                               el.checked = false;
-                               year_hide( el.value );
-                       }
-               }
-       } );
-}
-
-$(document).ready( function() {
-       console.info('ready');
-
-       $('input[name=year_selection]').each( function(i, el) {
-               var year = el.value;
-               console.debug( 'on load', year, el.checked );
-               if (! el.checked) year_hide(year);
-       });
-
-});
 </script>
 
        |;
 
+       debug 'type_cat_count' => $type_cat_count;
+
        # TOC
        print $fh qq|<ul id="toc">\n|;
        my $i = 0;
@@ -557,13 +528,13 @@ $(document).ready( function() {
                my $type  = $toc_type_label[$i++] || die "type";
                my $label = $toc_type_label[$i++] || die "label";
                next unless exists $type_cat_count->{_toc}->{$type};
-               print $fh qq| <li id="toc-$type"><a href="#$type">$label</a> <tt id="toc-count-$type">$type_cat_count->{_toc_count}->{$type}</tt></li>\n <ul>\n|;
+               print $fh qq| <li class="toc" id="toc-$type"><a href="#$type">$label</a> <tt id="toc-count-$type">$type_cat_count->{_toc_count}->{$type}</tt></li>\n <ul>\n|;
                foreach my $category ( sort keys %{ $type_cat_count->{_toc}->{$type} } ) {
                        my $label = $category_label->{$category} || 'Bez kategorije';
                        my $count = $type_cat_count->{ $type . '-' . $category };
                        my $cat_html = $category;
                        $cat_html =~ s/\./-/g;
-                       print $fh qq|  <li id="toc-$category"><a href="#$type-$category">$label</a> <tt id="toc-count-$type-$cat_html">$count</tt></li>\n|;
+                       print $fh qq|  <li class="toc" id="toc-$category"><a href="#$type-$category">$label</a> <tt id="toc-count-$type-$cat_html">$count</tt></li>\n|;
                }
                print $fh qq| </ul>\n|;
        }
@@ -613,7 +584,7 @@ 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} };
+               push @categories,  keys %{ $authors->{$authid}->{__sec} };
                foreach my $category ( sort @categories ) {
                        push @{ $department_category_author->{$department}->{$category} }, $authid;
                        push @{ $department_category_author->{'AAA_ukupno'}->{$category} }, $authid if $department_in_sum->{$department};
@@ -630,7 +601,7 @@ debug 'department_category_author' => $department_category_author;
 
 
 sub department_html {
-       my ( $fh, $department, $type, $label ) = @_;
+       my ( $fh, $department, $type, $label, $csv_fh ) = @_;
 
        print $fh qq|<a name="$type"><h2>$label</h2></a>\n|;
 
@@ -643,10 +614,24 @@ sub department_html {
 
                next unless @biblionumber;
 
-               my $label = $category_label->{$category} || 'Bez kategorije';
-               print $fh qq|<a name="$type-$category"><h3>$label</h3></a>\n<ol>\n|;
+               my $cat_label = $category_label->{$category} || 'Bez kategorije';
+               print $fh qq|<a name="$type-$category"><h3>$cat_label</h3></a>\n<ol>\n|;
+
+               foreach my $bib_num ( @biblionumber ) {
+                       my @li = li_biblio( $bib_num );
+                       my $li_html = join('', @li);
+                       $li_html =~ s{<hr/?>}{}g;
+                       print $fh $li_html;
+
+                       next unless $csv_fh;
 
-               print $fh li_biblio( $_ ) foreach @biblionumber;
+                       my $year = $li[1];
+                       my $html = $li[4];
+                       $html =~ s{<hr/?>}{\t}gs;
+#                      $html =~ s{</?[^>]*>}{}gs;
+                       $html =~ s{\s+$}{}gs;
+                       print $csv_fh "$bib_num\t$year\t$type\t$label\t$category\t$cat_label\t$html\n";
+               }
 
                print $fh qq|</ol>|;
        }
@@ -673,16 +658,24 @@ foreach my $department ( sort keys %$department_category_author ) {
        }
        html_year_selection $fh => @authids;
 
-       department_html( $fh, $department, 'aut', 'Primarno autorstvo' );
+       my $csv_fh;
+       if ( $department eq 'AAA_ukupno' ) {
+               open($csv_fh, '>:encoding(utf-8)', "html/departments/$department.csv");
+       }
 
-#      department_html( $fh, $department, 'sec', 'Sekundarno autorstvo' );
-       department_html( $fh, $department, 'edt', 'Uredništva' );
-       department_html( $fh, $department, 'trl', 'Prijevodi' );
-       department_html( $fh, $department, '_ostalo', 'Ostalo' );
+       my $i = 0;
+       while ( $i < $#toc_type_label ) {
+               my $type  = $toc_type_label[$i++] || die "type";
+               my $label = $toc_type_label[$i++] || die "label";
+               department_html( $fh, $department, $type, $label, $csv_fh );
+       }
+
+       close($csv_fh) if $csv_fh;
 
        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);
@@ -757,12 +750,9 @@ sub table_count {
        my $label = shift @_;
        my $department = shift @_;
        my $group = shift @_;
-       my @biblionumbers = @_;
-       my $unique;
-       $unique->{$_}++ foreach @biblionumbers;
-       my @bibs = keys %$unique;
-       $table->{ffzg}->{$group}->[ $label2row->{ $label } ]->[ $department2col->{$department} ] = scalar @bibs;
-       $table->{external}->{$group}->[ $label2row->{ $label } ]->[ $department2col->{$department} ] = scalar grep { $biblio_author_external->{$_} } @bibs;
+       my @biblionumbers = unique @_;
+       $table->{ffzg}->{$group}->[ $label2row->{ $label } ]->[ $department2col->{$department} ] = scalar @biblionumbers;
+       $table->{external}->{$group}->[ $label2row->{ $label } ]->[ $department2col->{$department} ] = scalar grep { $biblio_author_external->{$_} } @biblionumbers;
 }
 
 foreach my $group ( '', keys %$azvo_group_title ) {
@@ -854,3 +844,5 @@ close($fh2);
 rename 'html/azvo.new', 'html/azvo.html';
 rename 'html/azvo2.new', 'html/azvo2.html';
 
+unlink $pid_file;
+