PEAR is discontinued

This is a static archive preserving historical releases and metadata. No new packages or updates will be published. For updates to existing packages, or to publish new packages, please use Composer and Packagist.

Home » Structures » Structures_DataGrid

Render a data table with automatic pagination and sorting

This package is unmaintained.

Download latest release 0.9.3 (archived versions might be outdated)

License: New BSD

Description

This package provides a toolkit to generate data tables in HTML, CSV,
Excel, XML, Smarty, and other formats.
It retrieves data from a variety of data sources, including SQL, CSV,
XML, PDO, DB_DataObject, DB_Table, and others.
It can transparently page and sort the data, through optimized database
queries, by parsing/generating GET, POST requests and REST-like urls.
It is designed with modularity and extensibility in mind, using drivers
for all rendering and datasource formats.

Documentation

Manual

Maintainers

Dependencies

Required

Optional

Releases

Bugs

IDStatusTypeVersionDateSummary
#1023BogusBug2004-03-16Call-time pass-by-reference
#1024ClosedBug2004-03-16it's rendering empty lines
#1025ClosedBug2004-03-16SUGGESTION: use pager and data looper
#1063ClosedBug2004-03-24toHTML not supported
#1064SuspendedBug2004-03-24DataObject not fully supported
#1065ClosedBug2004-03-24DataGrid - Package Directory Structure
#1181ClosedBug2004-04-11Query string is not keep in data ordering
#1371ClosedBug2004-05-09Pager Factory
#1501ClosedBug2004-05-26Feature Requests and Code
#1544DuplicateBug2004-06-02undefined variable $result
#1545ClosedBug2004-06-02Undefined offset
#1584ClosedBug2004-06-08Column formatter does not work due to a typo
#1593No FeedbackBug2004-06-09Error in Core.php with multiple instances
#1739ClosedBug2004-06-29Not working Structures_DataGrid_Record_DataObject
#2003No FeedbackBug2004-07-28Undefined variable:
#2027ClosedBug2004-07-30Pager shouldn't be require'd by default
#2102ClosedReq2004-08-10render -> toHtml() or add getTable() method
#2123ClosedBug2004-08-14Record_DataObject does not recognize DataObject's grand-children
#2124ClosedBug2004-08-14Record_DataObject does not handle $fb_fieldsToRender
#2125ClosedBug2004-08-15GET parameters are intrusive and forbid using several DataGrids
#2128ClosedBug2004-08-15Record_DataObject does not return an error when passed junk
#2438ClosedBug2004-10-03toHTML does not work as expected
#2499ClosedBug2004-10-11Ampersands don't validate
#2500ClosedBug2004-10-11Filter function example code contains typo
#2501ClosedReq2004-10-11Ordering indicator
#2505ClosedBug2004-10-11Parameter in filter feature doesn't work
#2509ClosedBug2004-10-11Unnecessary bold tag added
#2871ClosedBug2004-12-01$this->_options['fields'] doesn't get generated when using bind() and DB result
#3028ClosedBug2004-12-26XUL Renderer does not convert XML entities
#3071BogusBug2004-12-30DataGrid doesnt work in PHP5
#3086ClosedBug2005-01-03Typo in Core.php
#3088ClosedBug2005-01-03Call to $this in static method.
#3089BogusReq2005-01-03Structures_DataGrid_Column::formatter() does not support static method callback
#3097ClosedBug2005-01-04typo in HTMLTable renderer
#3139ClosedReq2005-01-08columnformatter does not allow extra whitespace
#3140ClosedReq2005-01-08Add various FormBuilder inspired options to DataObject DataSource
#3151ClosedBug2005-01-10is_subclass_of
#3156ClosedBug2005-01-10HTMLTable renderer does nor print last page if # of record is < max size
#3157ClosedReq2005-01-10Use get* method(s) if available
#3170No FeedbackReq2005-01-11Add option for limiting field length
#3188ClosedReq2005-01-13Can the callbacks pass the DataGrid_Column?
#3191ClosedBug2005-01-13Structures_DataGrid_Renderer_Smarty::setTemplate()
#3229BogusReq2005-01-18Add ability to add Smarty template variables
#3244ClosedBug2005-01-19Paging not working anymore
#3274ClosedBug2005-01-23Extra fields no longer available
#3304ClosedBug2005-01-26requestPrefix still broken
#3305ClosedBug2005-01-26Syntax error in 0.6.1 after install
#3306ClosedBug2005-01-26Can't addColumn() after bind()'ing
#3314No FeedbackReq2005-01-27setRequestPrefix
#3316ClosedReq2005-01-27New datasource option : sort_default
#3523ClosedReq2005-02-18Allow custom headers ahead of header row
#3588ClosedReq2005-02-24Handle commas and doubel quotes in CSVs
#3601ClosedBug2005-02-25htmlentities needed for data
#3607ClosedBug2005-02-26Binding to null datasets causes fatal error
#3617ClosedBug2005-02-27array_multisort() - Argument #3 is expected to be an array
#3715ClosedBug2005-03-05Emtpy parameter list for formatter gives warning
#3769ClosedBug2005-03-10get* method not called
#3781ClosedBug2005-03-11wrong filename required in CSV.php
#3787No FeedbackBug2005-03-12Pager uses incorrect number of pages
#3847ClosedBug2005-03-16DB DataSource emits a notice if no records returned
#3859ClosedBug2005-03-17Setting useHeader as false still renders the header
#3887DuplicateBug2005-03-19notice php error into DataGrid :: Column.php file
#4022ClosedBug2005-03-31Record isn't passed into the formatter if () is not in the formatter spec
#4046BogusReq2005-04-04Use an object to define a "more intuitive" column formatter?
#4108No FeedbackReq2005-04-09sort national character
#4171BogusBug2005-04-17get{$field} feature in datagrid bug
#4254ClosedReq2005-05-01New DataSource driver (DB_Table)
#4350ClosedBug2005-05-15Structures_DataGrid_Renderer_XML constructor needs variable by reference
#4375ClosedBug2005-05-18Can't change colum links
#4379ClosedReq2005-05-18New DataSource driver (DBQuery)
#4394DuplicateBug2005-05-20Wrong include path in CSV.php
#4403ClosedBug2005-05-21Structures_DataGrid_sortRecordSet
#4415ClosedBug2005-05-24Docs directory goes into wrong directory
#4416ClosedReq2005-05-24Add "informative" functions to Core.php
#4421ClosedBug2005-05-24DataObject driver raises an error when link fields not set
#4434No FeedbackReq2005-05-25In some instances the fields in the record will be limited to displayed columns
#4454DuplicateBug2005-05-27No way to augment auto-generated columns with user defined columns
#4497ClosedReq2005-05-31New feature , flexy datagrid renderer
#4503ClosedBug2005-06-01CVS version of Array.php (1.13) does not count entries correctly
#4521ClosedBug2005-06-03Pager get's wrong value if there is no row limit
#4527ClosedBug2005-06-04allowEmptyRows adds one row too much
#4557ClosedBug2005-06-08Missing header in XLS renderer
#4558ClosedReq2005-06-08XLS renderer: add possibility to write spreadsheet to file
#4565ClosedReq2005-06-09Multiple field sort and record grouping
#4653ClosedReq2005-06-21Add Sub-Record displaying capabilities
#4675ClosedReq2005-06-24add option to specify attributes for header row
#4709ClosedReq2005-06-29add <thead>, <tfoot>, <tbody> to HTMLTable renderer
#4862BogusBug2005-07-19Structures_DataGrid crashes PHP on object creation
#4863ClosedBug2005-07-19Missing variable initialization
#4872ClosedBug2005-07-20Notice caused on formatter
#4874ClosedBug2005-07-21DB_DataObject getter function naming problem
#4891ClosedReq2005-07-22colums callback changing parameter
#5076ClosedReq2005-08-12Add PDO Driver for DataGrid
#5246ClosedReq2005-08-30Allow to append and/or prepend columns
#5255ClosedBug2005-08-31Instantiating the class kills the page
#5292ClosedBug2005-09-04Header links are created incorrectly
#5298ClosedReq2005-09-05new class for custom table headers and footers
#5300ClosedBug2005-09-05Some PHP notices shows when an callback function is used for col formatting
#5327ClosedReq2005-09-07Get rid of the extra space after the delimter when using CSV renderer
#5328BogusBug2005-09-07DataGrid Autofill Does Not Take Precedence Over Formatter
#5499BogusBug2005-09-22DB_Dataobject getMethods called improperly
#5534BogusBug2005-09-27Bad Path to include file
#5535ClosedBug2005-09-27XLS bad Column check
#5565Wont fixReq2005-09-29A new way to add Columns
#5585ClosedReq2005-10-03Add customize option when generate_columns = true
#5606BogusBug2005-10-05Structures_DataGrid fails sorting on joined tables
#5723ClosedBug2005-10-19Smarty Renderer Error
#5758ClosedReq2005-10-23Extra parameters for Structures_DataGrid_Column::formatter() callback
#5806ClosedReq2005-10-28XLS formatage des header automatique
#5808ClosedReq2005-10-28XLS rendering
#5829ClosedBug2005-10-31SDG 0.6.3 htmlentities make multibyte char unreadable
#5838ClosedReq2005-10-31Reversion of: Bug #3601
#5858ClosedBug2005-11-03do not use @ before include_once
#5859ClosedReq2005-11-03New renderer driver interface
#5886ClosedReq2005-11-07Passing default-encoding to htmlentities
#6031ClosedBug2005-11-21charset GB2312 display not correctly
#6032BogusBug2005-11-21DataSource/DataObject.php line 141 lost a "="
#6151ClosedReq2005-12-05Need to encode URL correctly in HTMLTable renderer
#6222ClosedReq2005-12-11Add more paging support to Smarty renderer
#6450ClosedBug2006-01-09sortRecordSet does not work if called after bind
#6522Wont fixReq2006-01-18Fix to determine proper row count instead of guessing
#6582ClosedBug-2006-01-25malfunction sort
#6607ClosedReq2006-01-27Support for table caption in table renderer
#6621ClosedReq0.6.32006-01-29get reference to column by name
#6624ClosedBug0.6.32006-01-29formatter doesn't handle parameters and object methods at the same time
#6670ClosedBug0.6.32006-02-02renderer_smarty can't display template (fix!)
#6720ClosedReq0.6.32006-02-07formatter with array parameters
#6779ClosedBug0.6.32006-02-14sort bug
#7039DuplicateBugCVS2006-03-06sortRecordSet with an array does not work
#7115ClosedBug2006-03-13Link to Trackback tutorial does not work
#7150ClosedBug0.6.32006-03-18Sorting tabular structure doesn't work
#7151BogusBug0.6.32006-03-18Missing HTML Directory
#7199ClosedReq0.6.32006-03-24Source Type Detection Fails on XML
#7333ClosedBugCVS2006-04-07Wrong params for work with MDB2 datasource
#7366ClosedBug0.6.32006-04-11Check if $column->fieldName is NULL
#7521ClosedBug2006-04-28Unknown Class passed Error for DataSource.php
#7534ClosedBug0.6.32006-05-01XLS Character encoding support
#7606ClosedBug0.6.32006-05-11DataGrid Renderer CSV
#7627ClosedBug0.6.32006-05-15Bad docblock for Structures_DataGrid_Column constructor
#7710ClosedBugCVS2006-05-23bind() interferes with rendering
#7746ClosedBug0.6.32006-05-29Doc Complex example uses CVS features
#7848ClosedReqCVS2006-06-09Rendering code review and corrections
#7925ClosedBugCVS2006-06-16formatter args ignored in Column->formatter()
#7927ClosedReqCVS2006-06-16pass row and col through to formatter function
#8004BogusReq0.7.12006-06-26Recordset array gets changed from assoc to numbered
#8005ClosedBug0.7.12006-06-26options from fill arent being passed through
#8040Wont fixReq0.7.12006-06-26Header Column Formatter
#8041ClosedReq0.7.12006-06-26Row Formatter / Color Switching
#8061ClosedReq0.7.12006-06-28Get data as an array
#8065Wont fixReq0.7.12006-06-29_detectSourceType(): CSV
#8089ClosedReqCVS2006-06-30Comment review
#8090ClosedReqCVS2006-06-30Questions after Code Review
#8091BogusReqCVS2006-06-30User defined formatters with automatically generated columns
#8210ClosedBug0.7.12006-07-13documented function getDataSource doesn't exist
#8317Wont fixReq0.7.12006-07-28natural sort
#8320ClosedReq0.7.12006-07-29new methode removeColumn() for existing addColumn()
#8353Wont fixReq0.7.12006-08-03A group by column would be very useful
#8392ClosedBug0.7.12006-08-08Handle sorting for multiple tables/page
#8490Wont fixReqCVS2006-08-17DataSource to produce a summary of the content of a DataObject
#8491ClosedBugCVS2006-08-17Minor comment change
#8651BogusBug0.7.12006-09-07Renderer HTMLTable_noHtmlEnt not installed
#8792BogusReq0.7.12006-09-26Use with Pager_Wrapper?
#9121ClosedBugCVS2006-10-21Use htmlspecialchars when you use PHP_SELF
#9160ClosedDoc2006-10-25wrong documentation
#9376ClosedBug0.7.22006-11-18Error at line 673
#9444Wont fixReq0.7.22006-11-24Sorting by fields not added as column
#9566ClosedReq0.7.22006-12-07Get defined columns
#9578DuplicateBug0.7.22006-12-07setRequestPrefix Broken
#9579ClosedBug0.7.22006-12-07New Warnings Showing up
#9820ClosedBug0.8.02007-01-13Unsupported operand types
#9873ClosedBug2007-01-18Structures_DataGrid FAQ example misleading
#9992ClosedBug0.8.12007-01-31orderBy=0 is lost in _parseHttpRequest()
#9994ClosedReq0.8.12007-01-31Clean URLs and parsing HTTP requests with Seagull
#9997ClosedDoc0.8.12007-02-01API change not mentioned in release notes
#10213ClosedBug0.8.12007-02-28Non-static call in static dataSourceFactory method
#10299BogusBug0.8.12007-03-07Multiple datagrids
#10590ClosedBug0.8.22007-04-02removeColumn may fail in php4
#11398BogusReq0.8.32007-06-21Renaming an existing column fieldName
#12254BogusBug2007-10-16Sorting tables when using Oracle Database does not work
#12885OpenDoc0.9.02008-01-11ordre des parametres inversé
#13025ClosedBug0.9.02008-01-31Quote Identifier incorrect when dealing with table.field
#13575ClosedDoc0.9.02008-04-03setDefaultSort should appear prior to bind in complex example
#14078ClosedBug0.9.02008-06-05PEAR::isError not returned when SQL fails
#14269OpenReqCVS2008-06-30Optimize subquery detection
#14427ClosedBug0.9.02008-07-31Empty SQL-Result + Array_Merge
#14452OpenReq0.9.02008-08-04RowFormtter Callback
#15334BogusBug0.9.02008-12-17count() and "EXTRACT" in query
#15369Wont fixDocCVS2008-12-21Parse errors in examples
#15435OpenReq0.9.02008-12-29Add method SetRequestSuffix()
#15436DuplicateBug0.9.02008-12-29Broken SQL
#15769ClosedBug0.9.02009-01-25setURLFormat method does not return clean query string intermittently
#16002ClosedBug0.9.02009-03-09ORDER clause not stripped in count()
#16325Wont fixReq0.9.02009-06-15convert to be zend framework complient - please!
#16464ClosedBugCVS2009-07-24Unit tests don't run from SVN
#16660BogusBug0.9.02009-09-30I keep getting this error
#16665DuplicateBug0.9.02009-10-01Now I get this error
#16744DuplicateBug0.9.02009-10-27little typo
#16786FeedbackBug0.9.02009-11-13warning message
#17102OpenBugCVS2010-02-14Unit tests broken in SVN
#17731ClosedBugSVN2010-08-17Patch: Avoid deprecations (favoring PCRE)
#18149FeedbackBug0.9.1dev12010-12-27Incorrect type check triggers other bugs
#18259OpenBug0.9.1dev12011-02-10sorting not working
#18952ClosedBug0.9.1dev12011-11-02PHP 5.3 Support
#19026ClosedBugSVN2011-11-14remove error_reporting (for PEAR QA team)
#19251ClosedBug0.9.22012-01-27Missing 'Structures/DataGrid/Exception.php'
#19841OpenBug2013-03-04Deprecated uses of pass-by-reference everywhere