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

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

Serving Software Downloads in 956 Categories, Downloaded 49.479.964 Times

Class::DBI::Plugin::FilterOnClick 1.0

  Date Added: January 18, 2010  |  Visits: 1.400

Class::DBI::Plugin::FilterOnClick

Report Broken Link
Printer Friendly Version


Product Homepage
Download (92 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::Template 2.9
HTML::Template module attempts to make using HTML templates simple and natural. HTML::Template library extends standard HTML with a few new tags for variables, loops, if/else blocks and includes. A file written with HTML and these new tags is...
62.46 KB  
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::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::WikiConverter::Oddmuse 0.52
HTML::WikiConverter::Oddmuse is a Perl module that can convert HTML to Oddmuse markup. SYNOPSIS use HTML::WikiConverter; my $wc = new HTML::WikiConverter( dialect => Oddmuse ); print $wc->html2wiki( $html ); This module contains rules for...
6.14 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  
NEW DOWNLOADS IN PROGRAMMING, LIBRARIES
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  -  Math::GMPf 0.29
Math::GMPf - perl interface to the GMP library's floating point (mpf) functions.
30.72 KB  
Programming  -  Net::Wire10 1.08
Net::Wire10 is a Pure Perl connector that talks to Sphinx, MySQL and Drizzle servers. Net::Wire10 implements the low-level network protocol, alias the MySQL wire protocol version 10, necessary for talking to one of the aforementioned...
30.72 KB  
Programming  -  logilab-common 0.56.2
a bunch of modules providing low level functionnalities shared among some python projects devel Please note that some of the modules have some extra dependencies. For instance, logilab.common.db will require a db-api 2.0 compliant...
174.08 KB  
Programming  -  OpenSSL for linux 1.0.0a
The OpenSSL Project is a collaborative effort to develop a robust, commercial-grade, full-featured, and Open Source toolkit implementing the Secure Sockets Layer (SSL v2/v3) and Transport Layer Security (TLS v1) protocols as well as a...
3.83 MB  
Libraries  -  wolfSSL 4.0.0
The wolfSSL embedded SSL/TLS library is a lightweight SSL library written in ANSI standard C and targeted for embedded and RTOS environments - primarily because of its small size, speed, and feature set. It is commonly used in standard operating...
3.88 MB  
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