Spiders Code
Status: Alpha
Brought to you by:
cpkois
| File | Date | Author | Commit |
|---|---|---|---|
| reportFiles | 2007-04-03 | cpkois | [r1] |
| reportScripts | 2007-04-03 | cpkois | [r1] |
| README | 2007-04-03 | cpkois | [r1] |
| appConfig.ini | 2007-04-03 | cpkois | [r1] |
| client.php | 2007-04-03 | cpkois | [r1] |
| config.ini | 2007-04-03 | cpkois | [r1] |
| reports.php | 2007-04-03 | cpkois | [r1] |
Spiders v0.01 SQL - Perl/PHP Integrated DEvelopment Environment Reporting System
Copyright (c) March, 2007 by Christopher Kois.
http://www.christopherkois.com
All rights reserved. You may distribute this package under the
terms of GNU General Public License (GPL).
Welcome to Spiders, a SQL reporting package for Apache.
Spiders is intended to be a one-stop developer's package to generate
and script SQL reports using the Perl programming language with a PHP
front end. Spiders utilizes psRpt, which uses many different Perl
modules available at CPAN.org and SourceForge.net in an attempt to
compile a suite of tools for the developer generating the reports.
To begin generating reports, you must first identify a few things:
1.) Do you have Apache 2.0 installed?
2.) Do you have PHP 5 and Perl v5.8 installed?
3.) Do you have the appropriate PHP and Perl Apache libraries installed?
4.) What type of SQL server are you using?
- psRpt supports MS SQL Server, MySQL and PostgreSQL servers.
5.) You must have a valid SQL server username/password and you
must know what database you need to access.
6.) You must provide a valid SQL select statement.
psRpt offers 6 different report format options. These formats are
Excel, CSV, XML, HTML, PDF, and TEX (Latex). For v0.01 of Spiders,
Excel is the only report format that is supported. The Excel format
is generated independently with it's own report format generator.
I have made one sample report example available for you to get
acclimated with the functions that Spiders has available. The sample
report is in the reportScripts folder and is called SalesReport.pl.
The client script is client.php and has the sample report name in it.
The client script redirects to the report.php web service and passes
the name of the script using REST. The web service accesses the
appConfig.ini config file to get the variables of the report script.
In the SalesReport example, the variables are accessed directly. The
sample script should help get you started.
The best reason to use Spiders combined with the psRpt perl module is
"Your perl script is your report." This allows you to customize the
report exactly to your needs. By generating reports using perl scripts
instead of a GUI report generation tool, you have FULL control over how
you want your report to be presented.
Remember to visit the Spiders website at http://spiders.sourceforge.net
for the latest version and information.
You can find more information on psRpt at http://psrpt.sourceforge.net
I hope you find Spiders useful. This is the first release, so many of
the features haven't been fully built and tested. Good luck and have fun.