PHP Classes
Icontem

Class: SpoolTemplate


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend!
      Classes of Andrioli Darvin  >  SpoolTemplate  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Supplied by   Group folder image Groups   Detailed description   Freshmeat project  
  Rate classes User ratings   Applications   Related links   Files Files  
  • Supplied by:

    Picture of Andrioli Darvin
    Name: Andrioli Darvin <e-mail contact>
    Published packages: 5
    Country: Italy 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:

    Group folder image HTML HTML generation and processing View top rated classes
    Group folder image Databases Database management, accessing and searching View top rated classes
    Group folder image Printing Document generation and preparation for printing View top rated classes
  • Detailed description:

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

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products