Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.542.425 Times

Class::DBI::Plugin::FilterOnClick 1.0

  Date Added: January 18, 2010  |  Visits: 778

Class::DBI::Plugin::FilterOnClick

Report Broken Link
Printer Friendly Version


Product Homepage
Download (74 downloads)



Class::DBI::Plugin::FilterOnClick is a Perl module to generate browsable and searchable HTML Tables using FilterOnClick in conjunction with Class::DBI. SYNOPSIS # Inside of your sub-class of Class::DBI add these lines: use Class::DBI::Plugin::FilterOnClick; use Class::DBI::Pager; use Class::DBI::AbstractSearch; use Class::DBI::Plugin::AbstractCount; use Class::DBI::Plugin::RetrieveAll; ..... # Inside your script you will be able to use this modules # methods on your table class or object as needed. use ClassDBIBaseClass; use URI::Escape; use CGI; my $cgi = CGI->new(); my %params; map { $params{$_} = uri_unescape($cgi->param("$_")) } $cgi->param(); my $filteronclick = Baseball::Master->filteronclick( -config_file => /srv/www/cgi-bin/baseball.ini, # -rows => $cgi->param(rows) || 15 , -on_page => $cgi->param(page) || 1, -params => %params ); $filteronclick->field_to_column( lastname => Last Name . $html->order_by_link(lastname), firstname => First Name . $html->order_by_link(firstname), bats => Bats, throws => Throws, ht_ft => Height Ft, ht_in => In, wt => Weight, birthyear => Birthyear, birthstate => Birthstate, _FilterOnClickCustom1_ => Other Data, _FilterOnClickCustom2_ => More Data ); FilterOnClickCustom $filteronclick->data_table->addRow( Last Name, First Name, Bats , Throws , Height (ft), (inches), Weight, Birth Year ); $filteronclick->params( $cgi->Vars; ); $filteronclick->exclude_from_url([ page ]); # indicate which columns to exclude, inverse of display above # can be set in config file as well $filteronclick->exclude_columns(); # indicate the base class to work with, this is optional, # if you should create you object via a call to # Class::DBI::Plugin::FilterOnClick vs. a Class::DBI sub class # this assures the correct sub class is used for data collection $filteronclick->cdbi_class( Baseball::Master ); # indicate the style of navigation to provide $filteronclick->navigation_style( both ); print qq~ Filter by First Letter of Last Name ~; print $filteronclick->string_filter_navigation( -column => lastname, -position => begins, ); print qq~ ~; $filteronclick->only(firstname); print $filteronclick->build_table( _FilterOnClickCustom1_ => sub { my $pid = shift; # pid = Primary ID of the record in the base table my @status_objects = Baseball::Allstars->search(lahmanid => $pid); if (@status_objects) { my $years; foreach my $st (@status_objects) { $years .= $st->year() . " "; } return $years; } return NA; }, _FilterOnClickCustom2_ => sub { my $pid = shift; # pid = Primary ID of the record in the base table my @status_objects = Baseball::Allstars->search(lahmanid => $pid); if (@status_objects) { my $teams; foreach my $st (@status_objects) { $teams .= $st->team() . " "; } return $teams; } return NA; }, ); my $nav = $filteronclick->html_table_navigation(); print qq! $nav n!; $filteronclick->add_bottom_span($nav); print $filteronclick->data_table; UPGRADE WARNING As of the .8 release there have been changes to the methods and how they work. It is likely that scripts built with older versions WILL break. Please read below to find specific changes that may negatively impact scripts built using the the releases prior to .8. The 1.0 release contains some minor modifications that could in some chases break your scripts, test carefully before upgrading in a production environment. The intention of this module is to simplify the creation of browsable and searchable HTML tables without having to write the HTML, either in your script or in templates. It is intended for use inside of other frameworks such as Embperl, Apache::ASP or even CGI. It does not aspire to be its own framework. If you are looking for a frameworks which allow using Class::DBI I suggest you look into the Maypole or the Catalyst module. See FilterOnClick below for more on the purpose of this module. Tables are created using HTML::Table. The use of HTML::Table was selected because it allows for several advanced sorting techniques that can provide for easy manipulation of the data outside of the SQL statement. This is very useful in scenarios where you want to provide/test a sort routine and not write SQL for it. The more I use this utility the less likely it seems that one would need to leverage this, but it is an option if you want to explore it. Feedback on this module, its interface, usage, documentation etc. is welcome..

Requirements: No special requirements
Platforms: Linux
Keyword: Cgi Classdbipluginfilteronclick Dbi Filteronclick Html Libraries Module Objects Perl Module Pid Print Programming Status Table
Users rating: 0/10

License: Freeware Size: 24.58 KB
USER REVIEWS
More Reviews or Write Review


CLASS::DBI::PLUGIN::FILTERONCLICK RELATED
Libraries  -  HTML::FormatNroff 0.11
HTML::FormatNroff is a Perl module that can format HTML as nroff man page. SYNOPSIS require HTML::FormatNroff; $html = parse_htmlfile("test.html"); $format_nroff = new HTML::FormatNroff(name => trial, project => MyProject); print...
12.29 KB  
Libraries  -  HTML::CGIChecker 0.90
HTML::CGIChecker is a Perl module to detect dangerous HTML code. SYNOPSIS use HTML::CGIChecker; $feedback = One column " Arrays & variables " Dough > Hi, how are you ?...
14.34 KB  
Libraries  -  HTML::HiLiter 0.13
HTML::HiLiter is a Perl module that can highlight words in an HTML document just like a felt-tip HiLiter. HTML::HiLiter is designed to make highlighting search queries in HTML easy and accurate. HTML::HiLiter was designed for CrayDoc 4, the Cray...
28.67 KB  
Libraries  -  HTML::EmbperlObject 1.3.6
HTML::EmbperlObject is a Perl module that extents HTML::Embperl for building whole website with reusable components and objects. SYNOPSIS PerlSetEnv EMBPERL_OBJECT_BASE base.htm PerlSetEnv EMBPERL_FILESMATCH ".htm.?|.epl$"...
358.4 KB  
Libraries  -  HTML::LoL 1.3
HTML::LoL is a Perl module that can construct HTML from pleasing Perl data structures. SYNOPSIS use HTML::LoL; &hl(sub { print shift }, [body => {bgcolor => white}, [p => Document body, ...], ...]); This module allows you to use Perl...
5.12 KB  
Libraries  -  HTML::Embperl 1.3.6
HTML::Embperl is a Perl module for building dynamic Websites with Perl. SYNOPSIS Embperl is a Perl extension module which gives you the power to embed Perl code directly in your HTML documents (like server-side includes for shell commands)....
358.4 KB  
Libraries  -  DBIx::HTML::ClientDB 1.05
DBIx::HTML::ClientDB is a Perl module to convert sql into a client-side db with keyed access. Synopsis use DBIx::HTML::ClientDB; my($object) = DBIx::HTML::ClientDB -> new ( dbh => $dbh, row_headings => Unit code,Unit code,Campus name,Unit...
11.26 KB  
Libraries  -  HTML::DWT 2.08
HTML::DWT is a Perl module with DreamWeaver HTML Template. INSTALLATION Unzip/tar the archive: tar xvfz HTML-DWT-2.08 Create the makefile perl Makefile.PL Make the module (must have root access to install) make make test make install...
17.41 KB  
Libraries  -  HTML::Widget 1.09
HTML::Widget is a Perl module with HTML Widget And Validation Framework. SYNOPSIS use HTML::Widget; # Create a widget my $w = HTML::Widget->new(widget)->method(get)->action(/); # Add a fieldset to contain the elements my $fs =...
67.58 KB  
Libraries  -  Pod::Html::HtmlTre 0.91
Pod::Html::HtmlTree is a Perl module to convert pod files to html tree. SYNOPSIS use Pod::Html::HtmlTree; use Data::Dumper; my $p = Pod::Html::HtmlTree->new; $p->indir ( /usr/lib/perl5/site_perl/5.8.3/Pod ); $p->outdir ( /tmp/pod );...
3.07 KB  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
Programming  -  FLEX-db Digital Asset Manager 3.0.9
FLEX-db - an enterprise Digital Asset Manager (DAM). It ingests and links metadata with files, creates thumbnails, and processes files using business rules. FLEX-db has a JSP client, Java app server for file input and output and an EJB metadata...
21.57 MB  
Programming  -  Libicom 0.9.0
The libicom library is a character based dynamicly linked library for Linux. It is used to remotely control the Icom IC-R8500 wide band receiver via an RS232 link. All call and return parameters to the control functions are character string based....
20.48 KB  
Programming  -  dotdesktop 0.3
Dotdesktop library provides ability to parse desktop entry file and access the information in a convenient way. Desktop entry file format is defined by freedesktop.org, it is used to describe information about an application such as the name and...
327.68 KB  
Programming  -  Cedalion for Linux 0.2.6
Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.
471.04 KB  
Programming  -  libyasl 0.2
Libyasl is a C++ class library to easily realize TCP/UDP/Multicast clientsand servers in IPv4 and IPv6 environments under GNU/Linux systems.
143.36 KB  
Libraries  -  EuGTK 4.8.9
Makes it easy to develop good- looking, fast, cross-platform programs that run on Linux, OS X, and Windows. Euphoria is a very fast interpreted/compiled language with straight-forward syntax. EuGTK allows programming in a clean, object-oriented...
10.68 MB  
Libraries  -  Linux User Group Library Manager 1.0
The LUG Library Manager is a project to help Linux User Groups start their own library. A LUG library is helpful to the community at large because it increases access to information, and gives everyone the opportunity to become more knowledgeable.
5.35 KB  
Libraries  -  Module::MakefilePL::Parse 0.12
Module::MakefilePL::Parse is a Perl module to parse required modules from Makefile.PL. SYNOPSIS use Module::MakefilePL::Parse; open $fh, Makefile.PL; $parser = Module::MakefilePL::Parse->new( join("", ) ); $info = $parser->required;...
8.19 KB  
Libraries  -  sqlpp 0.06
sqlpp Perl package is a SQL preprocessor. sqlpp is a conventional cpp-alike preprocessor taught to understand SQL ( PgSQL, in particular) syntax specificities. In addition to the standard #define/#ifdef/#else/#endif cohort, provides also...
10.24 KB  
Libraries  -  App::SimpleScan::Substitution::Line 2.02
App::SimpleScan::Substitution::Line is a line with optional fixed variable values. SYNOPSIS my $line = App::SimpleScan::Substitution::Line->new(" this "); # Use only this value when substituting " ". $line->fix(substituite =>...
54.27 KB