Class: SpoolTemplate (print, report, printer, printing)

Name:	SpoolTemplate Support forum
Base name:	`sptpl`
Description:	Database report generation based on templates
Search tags:	print, report, printer, printing
Version:	`-`
Required PHP version:	`-`
License:	GNU Lesser General Public License (LGPL)
All time users:	4008 users
All time rank:	357
Week users:	11 users
Week rank:	513

	Supplied by		Groups		Detailed description		Freshmeat project

	User ratings		Applications		Related links		Files

Supplied by:

Name: Andrioli Darvin <e-mail contact>

Published packages: 5

Country: Italy - PHP jobs in Italy

Home page: http://www.andrioli.com/

Age: 41

All time rank: 75

Week rank: 124

Browse this author's classes

Groups:

HTML	HTML generation and processing	View top rated classes
Databases	Database management, accessing and searching	View top rated classes
Printing	Document generation and preparation for printing	View top rated classes

SpoolTemplate (SpTpl) is a report system based on templates. It allows to build reports from database queries using just few lines of code.

Main features:

- Based on XML configuration files (each report has its own configuration files)

- To build a single report it requires few lines of PHP code as it is mainly based on the configuration files

- Output type: text file, PDF, printer (only Windows box)

- It gets the data to print from query or from globals variables

- You may output the data from your custom function (optionally you may pass as parameter the fields returned by the query)

- Each report may contain many tables and each table may display data from different queries eventually from different databases

- It supports page header and page footer (with page numbering) and page and margin sizes

- The databases suported by the current version are: MySQL, MSSQL and ODBC. You may write the extension to support other databases and specify it in the configuration file

- Text alignment (left, center, right)

- You may set the font name, the font size and decoration for each row

This package generates a spool file holding the report. You may manage that file at your convenience (i.e. print it using printer spooler commands as lp or similar, send it by e-mail, etc..)

This package parses a configuration file holding the detail how to build the report. It executes the instructions listed in that file and write the report as spool file.

Inside the configuration file there are directives that specify what text write as page header and footer, where to output the data (the sources are database or global variables).

After you define the data source query, the module executes the query, saves the columns of the rows returned from the query as normal variables, that change their values row by row; so you may access those columns as normal variables without distinction from data coming from query or data from PHP script or predefined constant.

You may monitor the field values. If those fields change their values, you may define what is outputted before and after each table. This is useful to generate special headers or total rows when you generate several tables grouped by one or more query fields.

The outputted values may come from user function. You may define your own function and use the returned values in the report in the place of a regular query field. This function may get its parameters from the report query fields.

Freshmeat project:

Project record: sptpl

Popularity score: 356.50 (0.58%)

Popularity rank: 10,428 (PHP Classes: 76)

Vitality score: 6.94 (0.00%)

Rating: Not yet rated Please rate this class in Freshmeat

User ratings:

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (80.0%)`	`Good (80.0%)`	`Good (85.0%)`	`Good (85.0%)`	`-`	`-`	`Sufficient (65.0%)`	325
Month:	Not yet rated by the users

Applications that use this class:

No application links were specified for this class.

If you know an application of this package, send a message to the author to add a link here.
Related links:

Link Description

andrioli.com Class home page

Files:

File	Role	Description
`CXml2Array.php`	Aux.	Class Xml2Array source
`doc.css`	Data	Documentation CSS
`doc.html`	Doc.	Class documentation
`license.txt`	Lic.	License
`reference.html`	Doc.	Tag reference
`sptpl.inc`	Aux.	Class main include
`sptpl.php`	Class	SpoolTemplate source
`sptpl_clsBlock.php`	Class	Class CBlock source
`sptpl_clsColumn.php`	Class	CColumn source
`sptpl_clsCounter.php`	Class	Class CCounter source
`sptpl_clsDataStorage.php`	Class	DataStorage source
`sptpl_clsFont.php`	Class	Class CFont source
`sptpl_clsNewPage.php`	Class	Class CNewPage source
`sptpl_clsPageMgr.php`	Class	Manager source
`sptpl_clsPagePdf.php`	Class	Interface to R&OS PDF Class
`sptpl_clsPagePrinter.php`	Class	optional module to write the report to the printer
`sptpl_clsRow.php`	Class	CRow source
`sptpl_db.php`	Class	Db Abstraction class
`sptpl_db_mssql.php`	Class	MS SQL server support
`sptpl_db_mysql.php`	Class	Mysql class support
`sptpl_db_odbc.php`	Class	Interface to ODBC
`sptpl_db_pgsql.php`	Class	Interface to Postgresql
`sptpl_GlobalFunc.php`	Aux.	Global functions
`test1.php`	Example	Simple example
`test1.xml`	Data	Simple example, configuration file
`test2.php`	Example	Second example
`test2.xml`	Data	d example, configuration script
`test4.php`	Example	Another example
`test4.xml`	Data	Third example configuratin file

Download all files: sptpl.tar.gz sptpl.zip

NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

Class: SpoolTemplate

Supplied by:

Groups:

Detailed description:

Freshmeat project:

User ratings:

Applications that use this class:

Related links:

Files: