http://pear.php.net/bugs/search.php?cmd=display&package_name%5B0%5D=Structures_DataGrid Search Results en-us pear-webmaster@lists.php.net pear-webmaster@lists.php.net hourly 1 2000-01-01T12:00+00:00 http://pear.php.net/gifs/pearsmall.gif http://pear.php.net/bugs http://pear.php.net/bugs/16786 Structures_DataGrid Bug Reported by openmbox 2009-11-13T16:19:00+00:00 PHP: 5.3.0 OS: Xampp on Windows 2000 Package Version: 0.9.0 Description: ------------ when rendering (tried both HTML Renderer and the XML renderer) the output reports: Warning: get_class() expects parameter 1 to be object, string given in C:\xampp\php\PEAR\Structures\DataGrid.php on line 1446 Test script: --------------- <?php require 'Structures/DataGrid.php'; $datagrid =& new Structures_DataGrid(); $options = array('dsn' => 'mysql://user@localhost/test'); $test = $datagrid->bind('SELECT * FROM owl_log', $options); if (PEAR::isError($test)) { echo $test->getMessage(); } $test = $datagrid->render(XML); if (PEAR::isError($test)) { echo $test->getMessage(); } ?>]]> Structures_DataGrid Bug Reported by openmbox 2009-11-13T16:19:00+00:00 PHP: 5.3.0 OS: Xampp on Windows 2000 Package Version: 0.9.0 Description: ------------ when rendering (tried both HTML Renderer and the XML renderer) the output reports: Warning: get_class() expects parameter 1 to be object, string given in C:\xampp\php\PEAR\Structures\DataGrid.php on line 1446 Test script: --------------- <?php require 'Structures/DataGrid.php'; $datagrid =& new Structures_DataGrid(); $options = array('dsn' => 'mysql://user@localhost/test'); $test = $datagrid->bind('SELECT * FROM owl_log', $options); if (PEAR::isError($test)) { echo $test->getMessage(); } $test = $datagrid->render(XML); if (PEAR::isError($test)) { echo $test->getMessage(); } ?>]]> 2009-11-13T16:19:00+00:00 openmbox &#x61;&#116; hotmail &#x64;&#111;&#x74; com Structures_DataGrid Bug http://pear.php.net/bugs/16464 Structures_DataGrid Bug Reported by doconnor 2009-07-24T02:51:50+00:00 PHP: 5.2.5 OS: Package Version: CVS Description: ------------ You just need to: mkdir Services svn add Services svn mv DataGrid.php Services/ svn mv DataGrid Services/ and update your package.xml Happy to do this for you if you like Test script: --------------- clockwerx@clockwerx-desktop:~/pear-svn/packages/Structures_DataGrid/trunk$ php tests/AllTests.php Expected result: ---------------- Tests run Actual result: -------------- Warning: require_once(Structures/DataGrid.php): failed to open stream: No such file or directory in /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/DataGridTest.php on line 52 Call Stack: 0.0008 75132 1. {main}() /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/AllTests.php:0 0.0207 303832 2. require_once('/home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/DataGridTest.php') /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/AllTests.php:52 Fatal error: require_once(): Failed opening required 'Structures/DataGrid.php' (include_path='.:/usr/share/php:/usr/share/pear') in /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/DataGridTest.php on line 52 Call Stack: 0.0008 75132 1. {main}() /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/AllTests.php:0 0.0207 303832 2. require_once('/home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/DataGridTest.php') /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/AllTests.php:52]]> Structures_DataGrid Bug Reported by doconnor 2009-07-24T02:51:50+00:00 PHP: 5.2.5 OS: Package Version: CVS Description: ------------ You just need to: mkdir Services svn add Services svn mv DataGrid.php Services/ svn mv DataGrid Services/ and update your package.xml Happy to do this for you if you like Test script: --------------- clockwerx@clockwerx-desktop:~/pear-svn/packages/Structures_DataGrid/trunk$ php tests/AllTests.php Expected result: ---------------- Tests run Actual result: -------------- Warning: require_once(Structures/DataGrid.php): failed to open stream: No such file or directory in /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/DataGridTest.php on line 52 Call Stack: 0.0008 75132 1. {main}() /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/AllTests.php:0 0.0207 303832 2. require_once('/home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/DataGridTest.php') /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/AllTests.php:52 Fatal error: require_once(): Failed opening required 'Structures/DataGrid.php' (include_path='.:/usr/share/php:/usr/share/pear') in /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/DataGridTest.php on line 52 Call Stack: 0.0008 75132 1. {main}() /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/AllTests.php:0 0.0207 303832 2. require_once('/home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/DataGridTest.php') /home/clockwerx/pear-svn/packages/Structures_DataGrid/trunk/tests/AllTests.php:52]]> 2009-07-24T02:51:50+00:00 daniel &#x64;&#111;&#x74; oconnor &#x61;&#116; gmail &#x64;&#111;&#x74; com Structures_DataGrid Bug http://pear.php.net/bugs/16002 Structures_DataGrid Bug Reported by bbaumer 2009-03-09T19:27:22+00:00 PHP: 5.2.9 OS: Windoze Package Version: 0.9.0 Description: ------------ The ORDER clause of a SQL query is not stripped out when performing a SELECT COUNT(*) FROM ... operation in order to getRecordCount(). This causes the query to fail if the DataGrid is sorted by a column which is not actually a field present in the DB table. For example, this happens anytime you sort by a column that you have name using the AS construct. This is easily fixable by adding something like: $query = preg_replace('#ORDER\s+BY\s.+sc#', '', $query); to the function DataSource::count() right after you strip out the SELECT clauses. Also, the ORDER clause does not affect the number of rows returned, so there is no harm in doing this. Test script: --------------- $dg->bind("SELECT column as ColumnName FROM table ORDER BY ColumnName"); echo "You found ".$dg->getRecordCount()." records"; Expected result: ---------------- You found 47 records Actual result: -------------- You found MDB2 Error: no such field records]]> Structures_DataGrid Bug Reported by bbaumer 2009-03-09T19:27:22+00:00 PHP: 5.2.9 OS: Windoze Package Version: 0.9.0 Description: ------------ The ORDER clause of a SQL query is not stripped out when performing a SELECT COUNT(*) FROM ... operation in order to getRecordCount(). This causes the query to fail if the DataGrid is sorted by a column which is not actually a field present in the DB table. For example, this happens anytime you sort by a column that you have name using the AS construct. This is easily fixable by adding something like: $query = preg_replace('#ORDER\s+BY\s.+sc#', '', $query); to the function DataSource::count() right after you strip out the SELECT clauses. Also, the ORDER clause does not affect the number of rows returned, so there is no harm in doing this. Test script: --------------- $dg->bind("SELECT column as ColumnName FROM table ORDER BY ColumnName"); echo "You found ".$dg->getRecordCount()." records"; Expected result: ---------------- You found 47 records Actual result: -------------- You found MDB2 Error: no such field records]]> 2009-03-09T19:27:22+00:00 bbaumer &#x61;&#116; wesleyan &#x64;&#111;&#x74; edu Structures_DataGrid Bug http://pear.php.net/bugs/15769 Structures_DataGrid Bug Reported by mpgjunky 2009-01-25T13:12:02+00:00 PHP: 5.1.6 OS: Fedora 6 Package Version: 0.9.0 Description: ------------ Applies to both outputting the grid and the pager links: setting $datagrid->setUrlFormat('/page/:page/:orderBy/:direction') returns a clean query string like: http://blah.com/blah/page/1/somecole/asc However, if one clicks on the next page link, the url is re-formatted as: http://blah.com/blah/page/1/somecole/asc?page=2 Test script: --------------- Setup a grid with pager links and set url format to whatever you wish. You MUST click on the next page link to obtain the bad result. The default output (i.e. page 1) is always ok. Expected result: ---------------- the url query string should not contain normal style query string, i.e. ?page=[n]&orderBy.... Actual result: -------------- http://blah.com/blah/page/1/somecole/asc?page=2]]> Structures_DataGrid Bug Reported by mpgjunky 2009-01-25T13:12:02+00:00 PHP: 5.1.6 OS: Fedora 6 Package Version: 0.9.0 Description: ------------ Applies to both outputting the grid and the pager links: setting $datagrid->setUrlFormat('/page/:page/:orderBy/:direction') returns a clean query string like: http://blah.com/blah/page/1/somecole/asc However, if one clicks on the next page link, the url is re-formatted as: http://blah.com/blah/page/1/somecole/asc?page=2 Test script: --------------- Setup a grid with pager links and set url format to whatever you wish. You MUST click on the next page link to obtain the bad result. The default output (i.e. page 1) is always ok. Expected result: ---------------- the url query string should not contain normal style query string, i.e. ?page=[n]&orderBy.... Actual result: -------------- http://blah.com/blah/page/1/somecole/asc?page=2]]> 2009-01-25T13:12:02+00:00 michael &#x61;&#116; stellarent &#x64;&#111;&#x74; com Structures_DataGrid Bug http://pear.php.net/bugs/15435 Structures_DataGrid Feature/Change Request Reported by mpgjunky 2008-12-29T02:53:53+00:00 PHP: 5.1.6 OS: Fedora 6 Package Version: 0.9.0 Description: ------------ I am using jQuery + jQuery Tabs to display 2 grids on the same page, one grid per tab. I need to make sure each grid is using different request variables, both in paging and column headers. I am trying to add an anchor "#t_all" at the end of the request queries but I can't find any means of achieving this. The request should look like: Tickets.php?annon_orderBy=adate&annon_direction=ASC&annon_page=7#t_all I've tried using 'extraVars' option but that doesn't work since it's an array, and all attempts result in 0=#t_all or similar variations. Having a simple SetRequestSuffix(string) method would solve the problem, unless there's a different way that I have missed.]]> Structures_DataGrid Feature/Change Request Reported by mpgjunky 2008-12-29T02:53:53+00:00 PHP: 5.1.6 OS: Fedora 6 Package Version: 0.9.0 Description: ------------ I am using jQuery + jQuery Tabs to display 2 grids on the same page, one grid per tab. I need to make sure each grid is using different request variables, both in paging and column headers. I am trying to add an anchor "#t_all" at the end of the request queries but I can't find any means of achieving this. The request should look like: Tickets.php?annon_orderBy=adate&annon_direction=ASC&annon_page=7#t_all I've tried using 'extraVars' option but that doesn't work since it's an array, and all attempts result in 0=#t_all or similar variations. Having a simple SetRequestSuffix(string) method would solve the problem, unless there's a different way that I have missed.]]> 2008-12-29T02:53:53+00:00 michael &#x61;&#116; stellarent &#x64;&#111;&#x74; com Structures_DataGrid Feature/Change Request http://pear.php.net/bugs/14452 Structures_DataGrid Feature/Change Request Reported by mpgjunky 2008-08-04T05:51:56+00:00 PHP: 5.1.6 OS: Fedora 6 Package Version: 0.9.0 Description: ------------ A RowFormatter callback would be nice, identical to the Column formatter callback would be very useful. The RowFormatter should expose the recordset element to allow conditional formatting. For example, setting different Table Row classes or styles depending on field values. At present I have not found a clever / integrated method other than iterating through the recordset after a datagrid fill, but this is not very elegant or integrated. Thanks, Michael.]]> Structures_DataGrid Feature/Change Request Reported by mpgjunky 2008-08-04T05:51:56+00:00 PHP: 5.1.6 OS: Fedora 6 Package Version: 0.9.0 Description: ------------ A RowFormatter callback would be nice, identical to the Column formatter callback would be very useful. The RowFormatter should expose the recordset element to allow conditional formatting. For example, setting different Table Row classes or styles depending on field values. At present I have not found a clever / integrated method other than iterating through the recordset after a datagrid fill, but this is not very elegant or integrated. Thanks, Michael.]]> 2008-08-04T05:51:56+00:00 michael &#x61;&#116; stellarent &#x64;&#111;&#x74; com Structures_DataGrid Feature/Change Request http://pear.php.net/bugs/14427 Structures_DataGrid Bug Reported by vaneerd 2008-07-31T05:20:24+00:00 PHP: 5.2.5 OS: Independent Package Version: 0.9.0 Description: ------------ I use Structures_DataGrid with Structures_DataGrid_DataSource_DB(Query) & Structures_DataGrid_Renderer_HTML_Table. When the query provided in $datagrid->bind($sql, $options); returns no rows (because no rows matching the criteria where found) there is an error on line 870 in Structures/DataGrid/Renderer.php The function array_merge($this->_records, $chunk); leads to an error, as $chunk is not an array! My solution was to simply add if (!is_array($chunk)) { $chunk = array(); }]]> Structures_DataGrid Bug Reported by vaneerd 2008-07-31T05:20:24+00:00 PHP: 5.2.5 OS: Independent Package Version: 0.9.0 Description: ------------ I use Structures_DataGrid with Structures_DataGrid_DataSource_DB(Query) & Structures_DataGrid_Renderer_HTML_Table. When the query provided in $datagrid->bind($sql, $options); returns no rows (because no rows matching the criteria where found) there is an error on line 870 in Structures/DataGrid/Renderer.php The function array_merge($this->_records, $chunk); leads to an error, as $chunk is not an array! My solution was to simply add if (!is_array($chunk)) { $chunk = array(); }]]> 2008-07-31T05:20:24+00:00 vaneerd &#x61;&#116; gmail &#x64;&#111;&#x74; com Structures_DataGrid Bug http://pear.php.net/bugs/14269 Structures_DataGrid Feature/Change Request Reported by wiesemann 2008-06-30T14:52:31+00:00 PHP: Irrelevant OS: Irrelevant Package Version: CVS Description: ------------ User request: Change the regexp in the count() method of the SDG_DS_SQLQuery class so that only subqueries after the (first) FROM clause will be matched. Only such subqueries should affect the row count. (Needs to be verified, but the user and I can't think of any problematic case.) Advantage: Less queries that require the 'count_query' option or a query execution without a LIMIT clause.]]> Structures_DataGrid Feature/Change Request Reported by wiesemann 2008-06-30T14:52:31+00:00 PHP: Irrelevant OS: Irrelevant Package Version: CVS Description: ------------ User request: Change the regexp in the count() method of the SDG_DS_SQLQuery class so that only subqueries after the (first) FROM clause will be matched. Only such subqueries should affect the row count. (Needs to be verified, but the user and I can't think of any problematic case.) Advantage: Less queries that require the 'count_query' option or a query execution without a LIMIT clause.]]> 2008-06-30T14:52:31+00:00 wiesemann &#x61;&#116; php &#x64;&#111;&#x74; net Structures_DataGrid Feature/Change Request http://pear.php.net/bugs/12885 Structures_DataGrid Documentation Problem Reported by plabrie 2008-01-11T17:46:19+00:00 PHP: 5.1.6 OS: Windows ou Fedora 5 Package Version: 0.9.0 Description: ------------ Le Datagrid avec une colonne ajoutée lorsque rendu en XML: le libellé du tag XML porte le nom du parametre OrderBy plutot que celui du Field si le parametre OrderBy est utilisé. J'ai fait afficher ces mots pour retrouver l'ordre. Ce serait OrderBy qui semble être utilisé du moins dans le XML. Si on mets null pour OrderBy c'est le nom du Field qui apparait correctement alors dans le tag XML Cela fonctionne bien tout de même mais c'est embêtant. Structures_DataGrid_Renderer_XML-0.1.3 XML_Util-1.1.4 Félicitations pour l'ensemble du Datagrid! Je développe aussi en asp.Net et le dataGrid de PEAR est aussi performant. Test script: --------------- $datagrid->addColumn(new Structures_DataGrid_Column('Label', 'Field', 'OrderBy', null, null, 'AfficherRole()'),'after','Region'); function AfficherRole($params) { extract($params); return trim($record['Info']).$fieldName.$columnName.$orderBy; } Expected result: ---------------- <Field> Mercredi : 9 h à 12 h, 13 h à 16 h 30 FieldLabelOrderBy </Field> Actual result: -------------- <OrderBy> Mercredi : 9 h à 12 h, 13 h à 16 h 30 FieldLabelOrderBy </OrderBy>]]> Structures_DataGrid Documentation Problem Reported by plabrie 2008-01-11T17:46:19+00:00 PHP: 5.1.6 OS: Windows ou Fedora 5 Package Version: 0.9.0 Description: ------------ Le Datagrid avec une colonne ajoutée lorsque rendu en XML: le libellé du tag XML porte le nom du parametre OrderBy plutot que celui du Field si le parametre OrderBy est utilisé. J'ai fait afficher ces mots pour retrouver l'ordre. Ce serait OrderBy qui semble être utilisé du moins dans le XML. Si on mets null pour OrderBy c'est le nom du Field qui apparait correctement alors dans le tag XML Cela fonctionne bien tout de même mais c'est embêtant. Structures_DataGrid_Renderer_XML-0.1.3 XML_Util-1.1.4 Félicitations pour l'ensemble du Datagrid! Je développe aussi en asp.Net et le dataGrid de PEAR est aussi performant. Test script: --------------- $datagrid->addColumn(new Structures_DataGrid_Column('Label', 'Field', 'OrderBy', null, null, 'AfficherRole()'),'after','Region'); function AfficherRole($params) { extract($params); return trim($record['Info']).$fieldName.$columnName.$orderBy; } Expected result: ---------------- <Field> Mercredi : 9 h à 12 h, 13 h à 16 h 30 FieldLabelOrderBy </Field> Actual result: -------------- <OrderBy> Mercredi : 9 h à 12 h, 13 h à 16 h 30 FieldLabelOrderBy </OrderBy>]]> 2008-01-16T11:57:15+00:00 pierre &#x64;&#111;&#x74; labrie &#x61;&#116; servicesquebec &#x64;&#111;&#x74; gouv &#x64;&#111;&#x74; qc &#x64;&#111;&#x74; ca Structures_DataGrid Documentation Problem