trunk/vhost/webpac2.cgi

#!/usr/bin/perl

use warnings;
use strict;

use CGI qw/:standard/;
use CGI::Carp qw/fatalsToBrowser/;
use File::Slurp;
use YAML;
use Data::Page;
use Data::Dump qw/dump/;
use SWISH::API;
use JSON;

my $range_around = 5;
my $entries_per_page = 30;
my $debug = param('debug');

print header(
        -charset => 'utf-8',
);

sub dump_yaml {
        my $name = shift;
        print qq|<pre># $name\n|, YAML::Dump( @_ ), qq|</pre>| if $debug;
}

sub show_pager {
        my ($pager) = @_;

        my @show_pages;
        my $after_current = 0;

        if ( $pager->current_page <= $range_around + 2 ) {
                @show_pages = ( $pager->first_page .. $pager->current_page );
                $after_current = $range_around - $pager->current_page;
        } else {
                @show_pages = ( $pager->first_page, '', $pager->current_page - $range_around .. $pager->current_page );
        }

        if ( $pager->current_page + $after_current + $range_around + 1 >= $pager->last_page ) {
                push @show_pages, ( $pager->current_page + 1 .. $pager->last_page );
        } else {
                push @show_pages, ( $pager->current_page + 1 .. $pager->current_page + $after_current + $range_around, '', $pager->last_page );
        }

#       dump_yaml( 'show_pages', \@show_pages );

        return '' unless $#show_pages;

        my ( $prev, $next ) = ( '&lt;&lt;', '&gt;&gt;' );

        sub li_a_href {
                my ( $page, $label, $attr ) = @_;
                param( 'current_page', $page );
                my $url = self_url( -query => 1 );
                $attr ||= '';
                $label ||= $page;
                qq|<li$attr><a href="$url" title="$page">$label</a></li>|;
        }

        return
                  $pager->previous_page ? li_a_href( $pager->previous_page, $prev ) : qq|<li class=skip>$prev</li>|
                , ( map {
                        if ( $_ eq $pager->current_page ) {
                                qq|<li class=current_page>$_</li>|;
                        } elsif ( $_ eq '' ) {
                                qq|<li class=skip>...</li>|;
                        } else {
                                li_a_href( $_ );
                        }
                } @show_pages )
                , $pager->next_page ? li_a_href( $pager->next_page, $next ) : qq|<li class=skip>$next</li>|
                ;
                
}

my $path = $ENV{PATH_INFO} || 'ecas';
my $dir = $0;
$dir =~ s{/[^/]+.cgi}{};

my $config = YAML::LoadFile( "$dir/$path/config.yml" );

my $database = (keys %{ $config->{databases} })[0];
die "$database not in $path" unless $path =~ m{\Q$database\E};

my $html_markup = "$dir/$path/html.pm";
my $html_markup_skip;
if ( -e $html_markup ) {
        require $html_markup;
        $html_markup = $database . '::html';
} else {
        undef $html_markup;
}

my $stats;
{
        my $path = "$dir/../var/swish/$database.yaml";
        $stats = YAML::LoadFile( $path );
        dump_yaml( "stats $path", $stats );
}

my $db = $config->{databases}->{$database};

my @attr = keys %{ $stats->{attr} }; # FIXME replace with real gnerated lookup

# XXX pipe delimit list!
my $select_attr_operators = << '__ATTR_OPERATORS__';
Q*                      |       Bilo koja riječ
BW Q            |       Početak
BW Q EW         |       Točan oblik
__ATTR_OPERATORS__

my $attr_operator;

foreach ( split(/[\n\r]+/, $select_attr_operators ) ) {
        my ( $operator,$label ) = split(/\s+\|\s+/,$_,2);
        push @{ $attr_operator->{ '-values' } }, $operator;
                $attr_operator->{ '-labels' }->{$operator} = $label;
}

warn "## attr_operator = ", dump( $attr_operator );

my $only_input;

foreach ( @{ $db->{input} } ) {
        my $input = $_->{name} || die "no name in ",dump( $_ );
        if ( ! $only_input->{'-labels'}->{$input} ) {
                push @{ $only_input->{'-values'} }, $input;
                        $only_input->{'-labels'}->{$input} = $_->{description} || $input;
        }
}

warn "## only_input = ", dump( $only_input );

print
        start_html(
                -title => $db->{name},
                -style => '../../style.css',
        ),
        h1( $db->{name} ),
        qq|<div id=description>|, $db->{description}, qq|</div>|,
        start_form( -action => self_url( query => 0 ) ),
                radio_group(
                        -name => 'attr',
                        -values => [ @attr ],
#                       -linebreak => 0,
                ),
                textfield( -name => 'search' ),
                popup_menu( -name => 'attr_operator', %$attr_operator ),
                submit,
                hidden( -name => 'entries_per_page', -default => $entries_per_page ),
                hidden( -name => 'current_page', -default => 1 ),
                checkbox( -name => 'debug', -default => 0 ), # FIXME hidden?
                qq|<div id=inputs>|,
                h2( 'Select input' ),
                checkbox_group(
                        -name => 'only_input',
                        %$only_input,
                        -linebreak=> 'true',
                ),
                qq|</div>|,

;

print   end_form;

if ( my $search = param('search') ) {

        print qq|<div id="results">|;

        my $swish = SWISH::API->new( "$dir/../var/swish/$database" );
        $swish->abort_last_error if $swish->Error;

        param( 'entries_per_page', $entries_per_page ) unless param('entries_per_page'); # FIXME not needed?
        my $pager = Data::Page->new;
        $pager->total_entries( param('current_page') * param('entries_per_page') );
        $pager->$_( param($_) ) foreach ( qw/entries_per_page current_page/ );

        dump_yaml( 'pager', $pager );

        my @search = (); 
        if ( $search =~ m{(=|"|AND|OR)} ) {
                push @search, $search;
        } elsif ( my $op = param('attr_operator') ) {
                my $attr = param('attr');
                my $v = $search;
                $v =~ s/^\s+//;
                warn "-- v: $v\n";
                sub rewrite {
                        my ( $whitespace, $v ) = @_;
                        warn "## filter $op $whitespace $v\n";
                        my $template = $op;
                           $template =~ s{Q}{$v};
                        $whitespace = " AND " if $whitespace;

                        return
                                $whitespace .
                                $attr . '="' . $template . '"';
                                ;
                };
                $v =~ s{(\s*)(\S+)}{rewrite($1,$2)}ge;

                push @search, $v;
        
                my @only_input = param('only_input');
                push @search, '(' . join(') OR (', map { "input=$_" } @only_input) . ')' if @only_input;
        } else {
                push @search, "all=\"$search\"";
        }

        my $q = '(' . join(') AND (', @search) . ')';
        $q =~ s{\(\((.+)\)\)}{($1)};
        warn "# query: $q\n";
        my $swish_results = $swish->query( $q );

        dump_yaml( 'swish_results', $swish_results );

        $pager->total_entries( $swish_results->hits );

        if ( ! $pager->total_entries ) {
                my $no_results = 'No results for search <b>%s</b>';
                $no_results = $swish->error_string . '<br><b>%s</b>' if $swish->error;
                printf qq|<div class="error">$no_results</div>\n\n|, $q;
        } else {

                my $results = "<b>%d</b> results for search <b>%s</b> showing results %d - %d";
                printf qq|<div class="message">$results</div>\n\n|, $pager->total_entries, $q, $pager->first, $pager->last;

                my $pager_html = join("\n", show_pager( $pager ));

                print qq|<ul class="pager">$pager_html</ul>\n\n| if $pager_html;

                my $start = $pager->first;
                print qq|<ol start=$start>\n|;

                while ( my $result = $swish_results->next_result ) {
                        my $data = from_json $result->property('data');

                        dump_yaml( 'data', $data );

                        print qq|<li>|;
                        foreach my $attr ( @attr ) {
                                next unless defined $data->{$attr};
                                my $v = $data->{$attr};
                                if ( $html_markup && ! $html_markup_skip->{$attr} ) {
                                        eval "\$v = $html_markup->$attr( \$v );";
                                        if ( $@ ) {
                                                warn "disable html markup for $attr: $@";
                                                $html_markup_skip->{$attr} = $@;
                                        }
                                }
                                print qq|<div><label>$attr</label><span class=$attr>$v</span></div>\n|;
                        }
                        print qq|</li>\n|;
                }
                print qq|</ol>\n\n|;

                print qq|<ul class="pager bottom">$pager_html</ul>\n\n| if $pager_html;
        }
        print qq|</div>|;

        dump_yaml( 'pager', $pager );

}

dump_yaml( "config databases $database", $db );
dump_yaml( 'html_markup_skip', $html_markup_skip );

print   end_html;
1	dpavlin	1132	#!/usr/bin/perl
2
3			use warnings;
4			use strict;
5
6			use CGI qw/:standard/;
7			use CGI::Carp qw/fatalsToBrowser/;
8			use File::Slurp;
9			use YAML;
10	dpavlin	1138	use Data::Page;
11			use Data::Dump qw/dump/;
12	dpavlin	1149	use SWISH::API;
13			use JSON;
14	dpavlin	1132
15	dpavlin	1138	my $range_around = 5;
16			my $entries_per_page = 30;
17	dpavlin	1141	my $debug = param('debug');
18	dpavlin	1138
19	dpavlin	1142	print header(
20			-charset => 'utf-8',
21			);
22	dpavlin	1132
23			sub dump_yaml {
24	dpavlin	1135	my $name = shift;
25	dpavlin	1141	print qq\|<pre># $name\n\|, YAML::Dump( @_ ), qq\|</pre>\| if $debug;
26	dpavlin	1132	}
27
28	dpavlin	1139	sub show_pager {
29	dpavlin	1141	my ($pager) = @_;
30	dpavlin	1138
31			my @show_pages;
32			my $after_current = 0;
33
34			if ( $pager->current_page <= $range_around + 2 ) {
35			@show_pages = ( $pager->first_page .. $pager->current_page );
36			$after_current = $range_around - $pager->current_page;
37			} else {
38			@show_pages = ( $pager->first_page, '', $pager->current_page - $range_around .. $pager->current_page );
39			}
40
41	dpavlin	1139	if ( $pager->current_page + $after_current + $range_around + 1 >= $pager->last_page ) {
42	dpavlin	1138	push @show_pages, ( $pager->current_page + 1 .. $pager->last_page );
43			} else {
44			push @show_pages, ( $pager->current_page + 1 .. $pager->current_page + $after_current + $range_around, '', $pager->last_page );
45			}
46
47	dpavlin	1140	# dump_yaml( 'show_pages', \@show_pages );
48	dpavlin	1138
49	dpavlin	1139	return '' unless $#show_pages;
50
51			my ( $prev, $next ) = ( '<<', '>>' );
52
53	dpavlin	1141	sub li_a_href {
54			my ( $page, $label, $attr ) = @_;
55			param( 'current_page', $page );
56			my $url = self_url( -query => 1 );
57			$attr \|\|= '';
58			$label \|\|= $page;
59			qq\|<li$attr><a href="$url" title="$page">$label</a></li>\|;
60			}
61
62	dpavlin	1139	return
63	dpavlin	1141	$pager->previous_page ? li_a_href( $pager->previous_page, $prev ) : qq\|<li class=skip>$prev</li>\|
64			, ( map {
65	dpavlin	1142	if ( $_ eq $pager->current_page ) {
66	dpavlin	1141	qq\|<li class=current_page>$_</li>\|;
67	dpavlin	1139	} elsif ( $_ eq '' ) {
68	dpavlin	1141	qq\|<li class=skip>...</li>\|;
69	dpavlin	1139	} else {
70	dpavlin	1141	li_a_href( $_ );
71	dpavlin	1139	}
72			} @show_pages )
73	dpavlin	1141	, $pager->next_page ? li_a_href( $pager->next_page, $next ) : qq\|<li class=skip>$next</li>\|
74	dpavlin	1139	;
75
76	dpavlin	1138	}
77
78	dpavlin	1137	my $path = $ENV{PATH_INFO} \|\| 'ecas';
79	dpavlin	1132	my $dir = $0;
80			$dir =~ s{/[^/]+.cgi}{};
81
82			my $config = YAML::LoadFile( "$dir/$path/config.yml" );
83
84			my $database = (keys %{ $config->{databases} })[0];
85			die "$database not in $path" unless $path =~ m{\Q$database\E};
86
87	dpavlin	1137	my $html_markup = "$dir/$path/html.pm";
88			my $html_markup_skip;
89			if ( -e $html_markup ) {
90			require $html_markup;
91			$html_markup = $database . '::html';
92			} else {
93			undef $html_markup;
94			}
95
96	dpavlin	1165	my $stats;
97			{
98			my $path = "$dir/../var/swish/$database.yaml";
99			$stats = YAML::LoadFile( $path );
100			dump_yaml( "stats $path", $stats );
101			}
102	dpavlin	1132
103			my $db = $config->{databases}->{$database};
104
105	dpavlin	1165	my @attr = keys %{ $stats->{attr} }; # FIXME replace with real gnerated lookup
106	dpavlin	1132
107	dpavlin	1155	# XXX pipe delimit list!
108			my $select_attr_operators = << '__ATTR_OPERATORS__';
109			Q* \| Bilo koja riječ
110			BW Q \| Početak
111			BW Q EW \| Točan oblik
112			__ATTR_OPERATORS__
113
114			my $attr_operator;
115
116			foreach ( split(/[\n\r]+/, $select_attr_operators ) ) {
117			my ( $operator,$label ) = split(/\s+\\|\s+/,$_,2);
118			push @{ $attr_operator->{ '-values' } }, $operator;
119			$attr_operator->{ '-labels' }->{$operator} = $label;
120			}
121
122			warn "## attr_operator = ", dump( $attr_operator );
123
124	dpavlin	1157	my $only_input;
125
126			foreach ( @{ $db->{input} } ) {
127			my $input = $_->{name} \|\| die "no name in ",dump( $_ );
128			if ( ! $only_input->{'-labels'}->{$input} ) {
129			push @{ $only_input->{'-values'} }, $input;
130			$only_input->{'-labels'}->{$input} = $_->{description} \|\| $input;
131			}
132			}
133
134			warn "## only_input = ", dump( $only_input );
135
136	dpavlin	1132	print
137			start_html(
138			-title => $db->{name},
139			-style => '../../style.css',
140			),
141			h1( $db->{name} ),
142			qq\|<div id=description>\|, $db->{description}, qq\|</div>\|,
143	dpavlin	1139	start_form( -action => self_url( query => 0 ) ),
144	dpavlin	1132	radio_group(
145			-name => 'attr',
146	dpavlin	1133	-values => [ @attr ],
147	dpavlin	1132	# -linebreak => 0,
148			),
149			textfield( -name => 'search' ),
150	dpavlin	1155	popup_menu( -name => 'attr_operator', %$attr_operator ),
151	dpavlin	1138	submit,
152	dpavlin	1142	hidden( -name => 'entries_per_page', -default => $entries_per_page ),
153			hidden( -name => 'current_page', -default => 1 ),
154			checkbox( -name => 'debug', -default => 0 ), # FIXME hidden?
155	dpavlin	1143	qq\|<div id=inputs>\|,
156			h2( 'Select input' ),
157			checkbox_group(
158			-name => 'only_input',
159	dpavlin	1157	%$only_input,
160	dpavlin	1143	-linebreak=> 'true',
161			),
162			qq\|</div>\|,
163
164	dpavlin	1132	;
165
166			print end_form;
167
168			if ( my $search = param('search') ) {
169
170	dpavlin	1135	print qq\|<div id="results">\|;
171	dpavlin	1132
172	dpavlin	1149	my $swish = SWISH::API->new( "$dir/../var/swish/$database" );
173			$swish->abort_last_error if $swish->Error;
174	dpavlin	1132
175	dpavlin	1138	param( 'entries_per_page', $entries_per_page ) unless param('entries_per_page'); # FIXME not needed?
176	dpavlin	1139	my $pager = Data::Page->new;
177			$pager->total_entries( param('current_page') * param('entries_per_page') );
178			$pager->$_( param($_) ) foreach ( qw/entries_per_page current_page/ );
179	dpavlin	1138
180	dpavlin	1139	dump_yaml( 'pager', $pager );
181
182	dpavlin	1157	my @search = ();
183	dpavlin	1155	if ( $search =~ m{(=\|"\|AND\|OR)} ) {
184			push @search, $search;
185			} elsif ( my $op = param('attr_operator') ) {
186			my $attr = param('attr');
187			my $v = $search;
188			$v =~ s/^\s+//;
189			warn "-- v: $v\n";
190			sub rewrite {
191			my ( $whitespace, $v ) = @_;
192			warn "## filter $op $whitespace $v\n";
193			my $template = $op;
194			$template =~ s{Q}{$v};
195			$whitespace = " AND " if $whitespace;
196	dpavlin	1142
197	dpavlin	1155	return
198			$whitespace .
199			$attr . '="' . $template . '"';
200			;
201			};
202			$v =~ s{(\s*)(\S+)}{rewrite($1,$2)}ge;
203
204			push @search, $v;
205	dpavlin	1157
206			my @only_input = param('only_input');
207			push @search, '(' . join(') OR (', map { "input=$_" } @only_input) . ')' if @only_input;
208	dpavlin	1155	} else {
209	dpavlin	1162	push @search, "all=\"$search\"";
210	dpavlin	1155	}
211
212	dpavlin	1157	my $q = '(' . join(') AND (', @search) . ')';
213	dpavlin	1155	$q =~ s{\(\((.+)\)\)}{($1)};
214	dpavlin	1149	warn "# query: $q\n";
215			my $swish_results = $swish->query( $q );
216	dpavlin	1132
217	dpavlin	1149	dump_yaml( 'swish_results', $swish_results );
218	dpavlin	1138
219	dpavlin	1149	$pager->total_entries( $swish_results->hits );
220
221			if ( ! $pager->total_entries ) {
222	dpavlin	1155	my $no_results = 'No results for search <b>%s</b>';
223			$no_results = $swish->error_string . '<br><b>%s</b>' if $swish->error;
224			printf qq\|<div class="error">$no_results</div>\n\n\|, $q;
225	dpavlin	1132	} else {
226	dpavlin	1138
227	dpavlin	1153	my $results = "<b>%d</b> results for search <b>%s</b> showing results %d - %d";
228	dpavlin	1155	printf qq\|<div class="message">$results</div>\n\n\|, $pager->total_entries, $q, $pager->first, $pager->last;
229	dpavlin	1135
230	dpavlin	1141	my $pager_html = join("\n", show_pager( $pager ));
231	dpavlin	1140
232	dpavlin	1141	print qq\|<ul class="pager">$pager_html</ul>\n\n\| if $pager_html;
233
234	dpavlin	1138	my $start = $pager->first;
235	dpavlin	1141	print qq\|<ol start=$start>\n\|;
236	dpavlin	1138
237	dpavlin	1149	while ( my $result = $swish_results->next_result ) {
238			my $data = from_json $result->property('data');
239
240	dpavlin	1166	dump_yaml( 'data', $data );
241
242	dpavlin	1132	print qq\|<li>\|;
243	dpavlin	1137	foreach my $attr ( @attr ) {
244	dpavlin	1149	next unless defined $data->{$attr};
245			my $v = $data->{$attr};
246			if ( $html_markup && ! $html_markup_skip->{$attr} ) {
247	dpavlin	1137	eval "\$v = $html_markup->$attr( \$v );";
248			if ( $@ ) {
249			warn "disable html markup for $attr: $@";
250			$html_markup_skip->{$attr} = $@;
251			}
252			}
253			print qq\|<div><label>$attr</label><span class=$attr>$v</span></div>\n\|;
254			}
255	dpavlin	1132	print qq\|</li>\n\|;
256			}
257	dpavlin	1141	print qq\|</ol>\n\n\|;
258	dpavlin	1140
259	dpavlin	1141	print qq\|<ul class="pager bottom">$pager_html</ul>\n\n\| if $pager_html;
260	dpavlin	1132	}
261			print qq\|</div>\|;
262	dpavlin	1138
263			dump_yaml( 'pager', $pager );
264
265	dpavlin	1132	}
266
267	dpavlin	1165	dump_yaml( "config databases $database", $db );
268	dpavlin	1137	dump_yaml( 'html_markup_skip', $html_markup_skip );
269	dpavlin	1132
270			print end_html;