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

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>|,

;

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;
        
                my @only_input = param('only_input');
                push @search, '(' . join(') OR (', map { "input=$_" } @only_input) . ')' if @only_input;
        } else {
                push @search, "xml=$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');

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