ossp-pkg/quos/quos.cgi
1.5
#!/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;
# 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