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 $estraier = YAML::LoadFile( "$dir/../var/estraier/$database.yaml" );

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

my @attr = keys %{ $estraier->{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 );

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',
                        -values => [ map { $_->{name} } @{ $db->{input} } ],
                        -linebreak=> 'true',
                ),
                qq|</div>|,

;

dump_yaml( 'inputs', $db->{input} );
dump_yaml( 'input names', map { $_->{name} } @{ $db->{input} } );

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;
        } else {
                push @search, "xml=$search";
        }

        my @only_input = param('only_input');

        push @search, '(' . join(') or (', @only_input) . ')' if @only_input;

        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');

                        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( 'db', $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	1132	my $estraier = YAML::LoadFile( "$dir/../var/estraier/$database.yaml" );
97
98			my $db = $config->{databases}->{$database};
99
100			my @attr = keys %{ $estraier->{attr} }; # FIXME replace with real gnerated lookup
101
102	dpavlin	1155	# XXX pipe delimit list!
103			my $select_attr_operators = << '__ATTR_OPERATORS__';
104			Q* \| Bilo koja riječ
105			BW Q \| Početak
106			BW Q EW \| Točan oblik
107			__ATTR_OPERATORS__
108
109			my $attr_operator;
110
111			foreach ( split(/[\n\r]+/, $select_attr_operators ) ) {
112			my ( $operator,$label ) = split(/\s+\\|\s+/,$_,2);
113			push @{ $attr_operator->{ '-values' } }, $operator;
114			$attr_operator->{ '-labels' }->{$operator} = $label;
115			}
116
117			warn "## attr_operator = ", dump( $attr_operator );
118
119	dpavlin	1132	print
120			start_html(
121			-title => $db->{name},
122			-style => '../../style.css',
123			),
124			h1( $db->{name} ),
125			qq\|<div id=description>\|, $db->{description}, qq\|</div>\|,
126	dpavlin	1139	start_form( -action => self_url( query => 0 ) ),
127	dpavlin	1132	radio_group(
128			-name => 'attr',
129	dpavlin	1133	-values => [ @attr ],
130	dpavlin	1132	# -linebreak => 0,
131			),
132			textfield( -name => 'search' ),
133	dpavlin	1155	popup_menu( -name => 'attr_operator', %$attr_operator ),
134	dpavlin	1138	submit,
135	dpavlin	1142	hidden( -name => 'entries_per_page', -default => $entries_per_page ),
136			hidden( -name => 'current_page', -default => 1 ),
137			checkbox( -name => 'debug', -default => 0 ), # FIXME hidden?
138	dpavlin	1143	qq\|<div id=inputs>\|,
139			h2( 'Select input' ),
140			checkbox_group(
141			-name => 'only_input',
142			-values => [ map { $_->{name} } @{ $db->{input} } ],
143			-linebreak=> 'true',
144			),
145			qq\|</div>\|,
146
147	dpavlin	1132	;
148
149	dpavlin	1143	dump_yaml( 'inputs', $db->{input} );
150			dump_yaml( 'input names', map { $_->{name} } @{ $db->{input} } );
151
152	dpavlin	1132	print end_form;
153
154			if ( my $search = param('search') ) {
155
156	dpavlin	1135	print qq\|<div id="results">\|;
157	dpavlin	1132
158	dpavlin	1149	my $swish = SWISH::API->new( "$dir/../var/swish/$database" );
159			$swish->abort_last_error if $swish->Error;
160	dpavlin	1132
161	dpavlin	1138	param( 'entries_per_page', $entries_per_page ) unless param('entries_per_page'); # FIXME not needed?
162	dpavlin	1139	my $pager = Data::Page->new;
163			$pager->total_entries( param('current_page') * param('entries_per_page') );
164			$pager->$_( param($_) ) foreach ( qw/entries_per_page current_page/ );
165	dpavlin	1138
166	dpavlin	1139	dump_yaml( 'pager', $pager );
167
168	dpavlin	1155	my @search = ();
169	dpavlin	1142
170	dpavlin	1155	if ( $search =~ m{(=\|"\|AND\|OR)} ) {
171			push @search, $search;
172			} elsif ( my $op = param('attr_operator') ) {
173			my $attr = param('attr');
174			my $v = $search;
175			$v =~ s/^\s+//;
176			warn "-- v: $v\n";
177			sub rewrite {
178			my ( $whitespace, $v ) = @_;
179			warn "## filter $op $whitespace $v\n";
180			my $template = $op;
181			$template =~ s{Q}{$v};
182			$whitespace = " AND " if $whitespace;
183	dpavlin	1142
184	dpavlin	1155	return
185			$whitespace .
186			$attr . '="' . $template . '"';
187			;
188			};
189			$v =~ s{(\s*)(\S+)}{rewrite($1,$2)}ge;
190
191			push @search, $v;
192			} else {
193			push @search, "xml=$search";
194			}
195
196	dpavlin	1149	my @only_input = param('only_input');
197	dpavlin	1143
198	dpavlin	1149	push @search, '(' . join(') or (', @only_input) . ')' if @only_input;
199	dpavlin	1143
200	dpavlin	1149	my $q = '(' . join(') and (', @search) . ')';
201	dpavlin	1155	$q =~ s{\(\((.+)\)\)}{($1)};
202	dpavlin	1149	warn "# query: $q\n";
203			my $swish_results = $swish->query( $q );
204	dpavlin	1132
205	dpavlin	1149	dump_yaml( 'swish_results', $swish_results );
206	dpavlin	1138
207	dpavlin	1149	$pager->total_entries( $swish_results->hits );
208
209			if ( ! $pager->total_entries ) {
210	dpavlin	1155	my $no_results = 'No results for search <b>%s</b>';
211			$no_results = $swish->error_string . '<br><b>%s</b>' if $swish->error;
212			printf qq\|<div class="error">$no_results</div>\n\n\|, $q;
213	dpavlin	1132	} else {
214	dpavlin	1138
215	dpavlin	1153	my $results = "<b>%d</b> results for search <b>%s</b> showing results %d - %d";
216	dpavlin	1155	printf qq\|<div class="message">$results</div>\n\n\|, $pager->total_entries, $q, $pager->first, $pager->last;
217	dpavlin	1135
218	dpavlin	1141	my $pager_html = join("\n", show_pager( $pager ));
219	dpavlin	1140
220	dpavlin	1141	print qq\|<ul class="pager">$pager_html</ul>\n\n\| if $pager_html;
221
222	dpavlin	1138	my $start = $pager->first;
223	dpavlin	1141	print qq\|<ol start=$start>\n\|;
224	dpavlin	1138
225	dpavlin	1149	while ( my $result = $swish_results->next_result ) {
226			my $data = from_json $result->property('data');
227
228	dpavlin	1132	print qq\|<li>\|;
229	dpavlin	1137	foreach my $attr ( @attr ) {
230	dpavlin	1149	next unless defined $data->{$attr};
231			my $v = $data->{$attr};
232			if ( $html_markup && ! $html_markup_skip->{$attr} ) {
233	dpavlin	1137	eval "\$v = $html_markup->$attr( \$v );";
234			if ( $@ ) {
235			warn "disable html markup for $attr: $@";
236			$html_markup_skip->{$attr} = $@;
237			}
238			}
239			print qq\|<div><label>$attr</label><span class=$attr>$v</span></div>\n\|;
240			}
241	dpavlin	1132	print qq\|</li>\n\|;
242			}
243	dpavlin	1141	print qq\|</ol>\n\n\|;
244	dpavlin	1140
245	dpavlin	1141	print qq\|<ul class="pager bottom">$pager_html</ul>\n\n\| if $pager_html;
246	dpavlin	1132	}
247			print qq\|</div>\|;
248	dpavlin	1138
249			dump_yaml( 'pager', $pager );
250
251	dpavlin	1132	}
252
253	dpavlin	1135	dump_yaml( 'db', $db );
254	dpavlin	1137	dump_yaml( 'html_markup_skip', $html_markup_skip );
255	dpavlin	1132
256			print end_html;