ossp-pkg/quos/quos.cgi
1.6
#!/usr/opkg/bin/perl
##
## OSSP quos - Query On Steroids
## Copyright (c) 2004 Ralf S. Engelschall <rse@engelschall.com>
## Copyright (c) 2004 The OSSP Project <http://www.ossp.org/>
##
## This file is part of OSSP quos, a Web user interface for querying
## a database which can be found at http://www.ossp.org/pkg/tool/quos/.
##
## This program is free software; you can redistribute it and/or modify
## it under the terms of the GNU General Public License as published by
## the Free Software Foundation; either version 2 of the License, or
## (at your option) any later version.
##
## This program is distributed in the hope that it will be useful,
## but WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
## General Public License for more details.
##
## You should have received a copy of the GNU General Public License
## along with this program; if not, write to the Free Software
## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,
## USA, or contact Ralf S. Engelschall <rse@engelschall.com>.
##
## quos.cgi: web user interface
##
require 5.008;
use CGI;
use String::Divert;
use IO::File;
# internal handling of fatal errors
BEGIN {
$SIG{__DIE__} = sub {
my ($msg) = @_;
my $hint = '';
if ($msg =~ m|line\s+(\d+)|) {
my $line = $1;
my $io = new IO::File "<$0";
my @code = $io->getlines();
$io->close();
my $i = -1;
$hint = join("", map { s/^/sprintf("%d: ", $line+$i++)/se; $_; } @code[$line-2..$line]);
}
print STDOUT
"Content-Type: text/html; charset=ISO-8859-1\n" .
"\n" .
"<html>\n" .
" <head>\n" .
" <title>OSSP quos: GURU MEDITATION</title>\n" .
" <style type=\"text/css\">\n" .
" HTML {\n" .
" width: 100%;\n" .
" height: auto;\n" .
" }\n" .
" BODY {\n" .
" background: #cccccc;\n" .
" margin: 0 0 0 0;\n" .
" padding: 0 0 0 0;\n" .
" }\n" .
" DIV.canvas {\n" .
" background: #000000;\n" .
" border: 20px solid #000000;\n" .
" }\n" .
" DIV.error1 {\n" .
" border-top: 4px solid #cc3333;\n" .
" border-left: 4px solid #cc3333;\n" .
" border-right: 4px solid #cc3333;\n" .
" border-bottom: 4px solid #cc3333;\n" .
" padding: 10px 10px 10px 10px;\n" .
" font-family: sans-serif, helvetica, arial;\n" .
" background: #000000;\n" .
" color: #cc3333;\n" .
" }\n" .
" DIV.error2 {\n" .
" border-top: 4px solid #000000;\n" .
" border-left: 4px solid #000000;\n" .
" border-right: 4px solid #000000;\n" .
" border-bottom: 4px solid #000000;\n" .
" padding: 10px 10px 10px 10px;\n" .
" font-family: sans-serif, helvetica, arial;\n" .
" background: #000000;\n" .
" color: #cc3333;\n" .
" }\n" .
" SPAN.title {\n" .
" font-size: 200%;\n" .
" font-weight: bold;\n" .
" }\n" .
" TT.text {\n" .
" font-weight: bold;\n" .
" }\n" .
" </style>\n" .
" <script language=\"JavaScript\">\n" .
" var count = 0;\n" .
" function blinker() {\n" .
" var obj = document.getElementById('error');\n" .
" if (count++ % 2 == 0) {\n" .
" obj.className = 'error1';\n" .
" }\n" .
" else {\n" .
" obj.className = 'error2';\n" .
" }\n" .
" setTimeout('blinker()', 1000);\n" .
" }\n" .
" </script>\n" .
" </head>\n" .
" <body onLoad=\"setTimeout('blinker()', 1);\">\n" .
" <div class=\"canvas\">\n" .
" <div id=\"error\" class=\"error1\">\n" .
" <span class=\"title\">OSSP quos: GURU MEDITATION</span>\n" .
" <p>\n" .
" <tt class=\"text\">\n" .
" $msg<br>\n" .
" </tt>\n" .
" <pre>\n$hint</pre>\n" .
" </div>\n" .
" </div>\n" .
" </body>\n" .
"</html>\n";
exit(0);
};
}
# create objects
my $cgi = new CGI;
my $html = new String::Divert;
my $nr_lops = 4;
my $nr_rows = 7;
$html->overload(1);
#&printparams($cgi);
# generate outer canvas
$html .= "<div class=\"quos\">\n";
$html->fold("quos");
$html .= "</div>\n";
$html >> "quos";
# generate browse part
$html .= "<p>";
$html .= "<span class=\"browse\">";
$html .= "<span class=\"title\">Browse</span>\n";
$html->fold("browse");
$html .= "</span>\n";
$html .= "</span>\n";
# generate query part
$html .= "<p>";
$html .= "<span class=\"query\">";
$html .= "<span class=\"title\">Query</span>\n<br>";
$html->fold("query");
$html .= "</span>\n";
$html .= "</span>\n";
# generate view part
$html .= "<p>";
$html .= "<span class=\"view\">";
$html .= "<span class=\"title\">View</span>\n";
$html->fold("view");
$html .= "</span>\n";
$html .= "</span>\n";
# generate result part
$html .= "<p>";
$html .= "<span class=\"result\">";
$html .= "<span class=\"title\">Result</span>\n";
$html->fold("result");
$html .= "</span>\n";
$html .= "</span>\n";
# sample
$html >> "query";
$html .= "parametrize your query<br>";
$html .= $cgi->start_html("query on steroids");
$html .= $cgi->start_form;
$html .= "<table>";
$html .= '<table>';
for ($i = 0; $i < $cgi->param('nr_rows'); $i++) {
$html .= "<tr>";
for ($j = $cgi->param('nr_lops') -1; $j >= 0; $j--) {
$html .= "<td>";
$html .= $cgi->popup_menu(-name=>"logop$j-$i",
-values=>[' ','(',')','!','&','|'],
-default=>' ');
$html .= "</td>";
}
$html .= "<td>";
$html .= $cgi->popup_menu(-name=>"f_name-$i",
-values=>['name','description','foo'],
-default=>'name');
$html .= '</td>';
$html .= '<td>';
$html .= $cgi->popup_menu(-name=>"f_operator-$i",
-values=>['=','begins with','ends with'],
-default=>'=');
$html .= '</td>';
$html .= '<td>';
$html .= $cgi->textfield(-name=>"f_value-$i");
$html .= '</td>';
$html .= '<br>';
$html .= '</tr>';
}
$html .= "</table>";
$html .= '<table>';
$html .= '<tr>';
$html .= '<td>';
$html .= $cgi->popup_menu(-name=>"nr_lops",
-values=>[1..9],
-default=>'3');
$html .= '</td>';
$html .= '<td>';
$html .= $cgi->popup_menu(-name=>'nr_rows',
-values=>[1..9],
-default=>'4');
$html .= '</td>';
$html .= '<td>';
$html .= $cgi->submit('act_matrix_upd','update');
$html .= '</td>';
$html .= '<td>';
$html .= $cgi->submit('act_matrix_clear','clear');
$html .= '</td>';
$html .= '<td>';
$html .= $cgi->submit('act_matrix_submit','submit');
$html .= '</td>';
$html .= '</tr>';
$html .= '</table>';
$html .= '<table>';
$html .= '<tr>';
$html .= '<td>';
$html .= 'name of query';
$html .= '</td>';
$html .= '<td>';
$html .= $cgi->submit('act_matrix_clear','load');
$html .= '</td>';
$html .= '<td>';
$html .= $cgi->submit('act_matrix_submit','delete');
$html .= '</td>';
$html .= '</tr>';
$html .= '<tr>';
$html .= '<td>';
$html .= $cgi->textfield(-name=>'name_persquery');
$html .= '</td>';
$html .= '<td>';
$html .= $cgi->submit('act_matrix_clear','save');
$html .= '</td>';
$html .= '<td>';
$html .= 'hyperlink';
$html .= '</td>';
$html .= '</tr>';
$html .= '</table>';
$html .= '</table>';
$html .= $cgi->end_form;
sub printparams {
my($cgi) = @_;
my(@values,$key);
foreach $key ($cgi->param) {
$html .= "<strong>$key</strong> -> ";
@values = $cgi->param($key);
$html .= join(", ",@values)."<br>\n";
}
}
# my($cgi) = @=;
$html << 1;
# read HTML skeleton
my $io = new IO::File "<quos.html"
or die "unable to read HTML skeleton file \"quos.html\"";
my $skel = '';
$skel .= $_ while (<$io>);
$io->close();
$html->undivert(0);
$skel =~ s|\%BODY\%|$html|s;
$html = $skel;
# create HTTP response
my $http = $cgi->header(
-type => 'text/html',
-expires => '+10s'
);
$http .= $html;
print STDOUT $http;
__END__
=pod
=head1 NAME
B<OSSP quos> - Query On Steroids
=head1 DESCRIPTION
...FIXME...
=head1 LOGICAL LAYOUT
1. Browse
- Groups
. Hyperlinks
2. Query
- Groups
. Field (database schema)
. Operator (compare)
. Value (depends on compare)
3. View
- Selection predefined output format
- OSSP var based formatting string
- ordering
- save custom view
4. Result
- based on View
=cut