SpoolTemplate PHP script

SPONSORED LINKS

    Specification

  • Version:
  • File size: 0 KB
  • File name:
  • Last update:
  • Platform: Windows / Linux / BSD
  • Language: PHP
  • Price:LGPL
  • Company: Andrioli Darvin (View more)

SpoolTemplate script description:




Publisher review:
SpoolTemplate is a report system based on templates. It allows to build reports from database queries using just few lines of code. 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.
SpoolTemplate is a PHP script for PHP Classes scripts design by Andrioli Darvin. It runs on following operating system: Windows / Linux / BSD.

Operating system:
Windows / Linux / BSD

Latest script and internet news

The new Firefox 37 comes with improved HTTP / 2 and superior HMTL5 compatibility with YouTube

The new Firefox 37 comes with improved HTTP / 2 and superior HMTL5 compatibility with YouTube

The popular browser Firefox reached version 37, bringing a series of news but not as significant as other versions.

Posted on: 03 Apr 2015 11:11 by A. Brown

The permanently active Push system offered by the new Google Chrome 42

The permanently active Push system offered by the new Google Chrome 42

Google Chrome version 42 comes with implementation of interesting options for software developers who want to turn their websites into complex Web applications: Push notification system which is permanently active.

Posted on: 17 Mar 2015 07:57 by A. Brown

Gamers, Microsoft presents the advantages of DirectX 12 and 11.3 platforms used by new games for Windows 10

Gamers, Microsoft presents the advantages  of DirectX 12 and 11.3 platforms used by new games for Windows 10

The Windows 10 preview event brought also to the attention of gamers a demonstration of the advantages of the new DirectX 12 API by Microsoft, which announced several technologies providing integration with Xbox One game consoles.

Posted on: 27 Jan 2015 09:15 by A. Brown

Android devices now have access to Google Chrome 40

Android devices now have access to Google Chrome 40

Finally was officially released version 40 of Chrome browser for Android devices, iOS and Windows PCs, coming up with an interesting range of bug fixes and optimizations.

Posted on: 23 Jan 2015 13:57 by A. Brown

SPREAD THE WORD

User Rating


Rating: 0.0 out of 5
Based on 0 ratings. 0 user reviews.

  • Currently 0.00 out of 5
  • 1
  • 2
  • 3
  • 4
  • 5