Changeset 9430 for trunk/Open-ILS/src/reporter/clark-kent.pl

Timestamp:

04/22/08 14:32:12 (5 months ago)

Author:

erickson

Message:

added support for taking pivot info from the report def

Files:

• trunk/Open-ILS/src/reporter/clark-kent.pl (modified) (3 diffs)

trunk/Open-ILS/src/reporter/clark-kent.pl

@@ -15 +15 @@
 use OpenSRF::Utils qw/:daemon/;
 use OpenSRF::Utils::JSON;
-#use OpenSRF::Utils::Logger qw/:level/;
+use OpenSRF::Utils::Logger qw/$logger/;
 use OpenSRF::System;
 use OpenSRF::AppSession;
@@ -134 +134 @@
 
         my $b = OpenILS::Reporter::SQLBuilder->new;
-        $b->register_params( OpenSRF::Utils::JSON->JSON2perl( $r->{report}->{data} ) );
+        my $report_data = OpenSRF::Utils::JSON->JSON2perl( $r->{report}->{data} );
+        $b->register_params( $report_data );
 
         $r->{resultset} = $b->parse_report( OpenSRF::Utils::JSON->JSON2perl( $r->{report}->{template}->{data} ) );
+        $r->{resultset}->set_pivot_data($report_data->{__pivot_data}) if $report_data->{__pivot_data};
+        $r->{resultset}->set_pivot_label($report_data->{__pivot_label}) if $report_data->{__pivot_label};
+        $r->{resultset}->set_pivot_default($report_data->{__pivot_default}) if $report_data->{__pivot_default};
         $r->{resultset}->relative_time($r->{run_time});
         push @reports, $r;
@@ -162 +166 @@
                 SQL
 
+            $logger->debug('Report SQL: ' . $r->{resultset}->toSQL);
                 $sth = $dbh->prepare($r->{resultset}->toSQL);