General
-
New free-jqGrid and Jquery
Hello developers of phpgrid,
I've noticed the current version of free-jqgrid in phpgrid is 4.13.6. The newest version on github however is 4.15.3. Are there ideas to upgrade to that function?
Also the current jquery is 2.1.4, while the newest is 3.3.1, are there ideas to upgrade this too?
Thanks,
Sander
9 votes -
New free-jqGrid and Jquery
Hello developers of phpgrid,
I've noticed the current version of free-jqgrid in phpgrid is 4.13.6. The newest version on github however is 4.15.3. Are there ideas to upgrade to that function?
Also the current jquery is 2.1.4, while the newest is 3.3.1, are there ideas to upgrade this too?
Thanks,
Sander
9 votes -
1 vote
-
save position of columns
we would need a method to save the column position to database after users moved them using drag&drop. At least a method to keep this persistent would help.
1 vote -
It would be good to allow a boolean choice of yes/no or true/false as opposed to a checkbox
that only allows 1:0 when dealing with MySQL tinyint boolean values. This would make presentation more correct for users and searches.
1 vote -
In form only mode - redirect_after_cancel
In form only mode - redirect_after_cancel - currently we can redirect after submit - but on cancel we are left with a blnak page
1 vote -
Page-Reload-Persistent Search
It would be nice if there would be an option to make search/sort reload persistent ...
We got several Systems where the Users switch between different Lists / Pages ... and they have to execute the same searches again & again & again when going back and forth...So it would be really cool if the Search could be Page Reload Persistent ... ;-)
thx
Andreas Schnederle-Wagner39 votes -
Test ideas
Another idea?
1 vote -
Detail your export documentation
On your documentation to enable export ($dg->enable_export('PDF');) you show a live example where the user can pick the format he wants to export the grid in but you don't give the code for that.
(http://phpgrid.com/example/export-datagrid-to-excel-or-html/)I managed to recreate the code and made my own script:
Export:
<select id="export" onchange="exportfn()">
<option value="">Pick your format</option>
<option value="CSV">Excel</option>
<option value="PDF">PDF</option>
<option value="HTML">Webpage</option>
</select><script>
function exportfn() {
var x = document.getElementById("export").value;
window.location.href = './export.php?gn=Clears&export_type=' + x;
}
</script>But it would be nicer to have it on the footer like you had it on the live example.
Could you add…
2 votes -
Update notices: The site referenced to subscribe to hasn't been updated itself since 2014. How do we get updates when released?
How to get updates
1 vote -
Support for heredocs for subgrids
Heredocs are great. It would be VERY nice if subgrids would be able to use them....
1 vote -
sum, count avg a column for detail/subgrids
Enable at least details grids to be able to have a footer row that allows sum, count avg a column as in the example given for master grids. Be nice for subgrids too.
1 vote -
a formun where users can exchange knowledge and help those with problems with their coding
A forum where users ask and share knowledge with each other would be most helpful. It has been frustrating, very frustrating trying to resolve several issues and getting nowhere.
6 votes -
Oracle Primary Key must be in UPPER CASE
please add to your documentation that the constructor for accessing an ORACLE table must have the Key field in UPPER CASE...
Your documentation:
$dg = new C_DataGrid("SELECT * FROM emp", array("empno"), "emp");has to be:
$dg = new C_DataGrid("SELECT * FROM emp", array("EMPNO"), "emp");otherwise you get this error:
Notice: Undefined index: myid in C:\xampp\htdocs\phpGrid_Enterprise\server\classes\clNotice: Undefined index: empno in C:\xampp\htdocs\phpGrid_Enterprise\server\classes\cls_util.php on line 68It took me a long time to figure this out
1 vote -
dynalink too much hardcoded
Nice function set_col_dynalink() but why $dynaParam is so hardcoded? Someone could wish to put only value into url, not into hardcoded ?param=value. Just www.url.com/value not www.url.com/?param=value.
We are living in clean url`s world .)
3 votes -
Notifications....
Whenever the datagrid is updated there are a number of people who would like to be notified that changes have taken place.
I think that it would be useful if people on a mailing list (For example) would be notified that changes (Not necessarily precise) have taken place to the grid. Obviously the more precise the better but anything is better than nothing
Regards Paul5 votes -
Toggle integrated search to always on (2 methods)
There are actually two ways to do this: as posted on this site you can add the following just before the close of body tag:
<script type="text/javascript">
$(function() {
var grid = jQuery("#TABLE_NAME");
grid[0].toggleToolbar();
});
</script>OR
comment outthe following line in cls_datagrid.php. I like this method because I want to show this more times than I don't, so it is easier. Basically you are deciding the default behavior of the integrated search: leaving this un-commented makes it hidden by default which requires you to use script to toggle it on OR you can comment it out so it shows…
4 votes -
numbers do not sort correctly when using local array data source
Numbers do not sort correctly when using local array data source. Using the source below you'll notice that the numbers do not sort correctly. Values less than 10 do not sort above numbers greater than 10.
$gridData = array();
foreach( $players as $playerID => $playerName )
{
$floatNum = mt_rand(0, 10000) / 100;$data = array();
$data['Number'] = $floatNum;array_push($gridData, $data);
}$dg = new C_DataGrid($gridData);
$dg->enable_search(true);
$dg->set_caption('Stats');
$dg->set_row_color('#2F3C4E', 'transparent', 'transparent');
$dg->set_pagesize( sizeof($gridData) );
$dg->set_col_format('Number', 'number', array("thousandsSeparator" => ",", "decimalSeparator" => ".", "decimalPlaces" => '2', "defaultValue" => '0.00'));
$dg->enable_rownumbers(true);
$dg->set_dimension(950, '100%');
$dg->display();8 votes -
7 votes
-
Change "sel_col_readonly" to only show field content.
Suggest change to "sel_col_readonly" and only show the field content. No outlining box or part of the TAB sequence.
3 votes
- Don't see your idea?