Guriddo » Topic: Show/Hide export button

Show/Hide export button

Guriddo
Show/Hide export button

This topic has 5 replies, 2 voices, and was last updated 6 years, 6 months ago by guriddo.support.

Creator

Topic
January 22, 2016 at 5:57 pm #124720

kgrogers
Participant

Hi All:

When a user tries to export a grid that has more than $gSQLMaxRows the web page bombs out and generates a php memory exceeded error.

I am trying to hide or show the export icon on the pager using the following code:

[ code language=”php”]

$Recs =<<<RECS
function(data,status) {
var numrecs = data.records;
}
RECS;

$setNav =<<<SETNAV
function(numrecs) {
if (numrecs < 200000) {
$(‘#pager_excel’).hide();
} else {
$(‘#pager_excel’).show();
}
}
SETNAV;
$grid->setGridEvent(‘beforeProcessing’,$Recs);
$grid->setGridEvent(‘gridComplete’,$setNav);
$grid->setNavOptions(‘navigator’,array(‘add’=>false,’edit’=>false,’del’=>false,’view’=>true,”columns”=>true));
// Run the script
$grid->renderGrid(‘#grid’,’#pager’,true, null, null, true,true);

[/code]

Naturally it’s not working as I had hoped. If you could clue me in on the proper method I would appreciate it.

Ken
Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies

January 22, 2016 at 5:59 pm #124721

kgrogers

Participant

And if you could tell me how to show the code I posted as code I’d appreciate that too.

January 22, 2016 at 8:24 pm #124722

kgrogers

Participant

So I finally figured it out. Here’s what I did that worked:

I’d still like to know how to get code to show up as code after submitting a post though.

Ken

This reply was modified 6 years, 6 months ago by kgrogers.
This reply was modified 6 years, 6 months ago by kgrogers.
This reply was modified 6 years, 6 months ago by kgrogers.
This reply was modified 6 years, 6 months ago by kgrogers.
This reply was modified 6 years, 6 months ago by kgrogers.
This reply was modified 6 years, 6 months ago by kgrogers.

January 25, 2016 at 11:33 am #124731

guriddo.support

Participant

Hello,

To post a code you will need to

1.switch to text mode (see tabs the upper right corner (Visual/Text)

2. Copy paste you code.

3. Mark the code

4. Press code button

The source can look like this

//and finaly set it to the grid
$grid->datearray= array( "RequiredDate" );
// Enable filter toolbar searching
$grid->toolbarfilter = true;
// we set the select for ship city
$grid->setSelect("ShipCity", "SELECT DISTINCT ShipCity, ShipCity AS CityName FROM orders ORDER BY 2", false, false, true );
$grid->navigator = true;
$grid->setNavOptions('navigator', array("excel"=>false,"add"=>false,"edit"=>false,"del"=>false,"view"=>false, "search"=>false));
$onClearVal = <<< CLEAR
function (elem, coli, soptions, defval) {
	if(coli > 0) {
		var name = this.p.colModel[coli].name;
		if(name === 'ShipCity') {
			$(elem).val(defval);
			$(elem).multiselect('refresh');
			$(elem).siblings('button.ui-multiselect').css({
				width: "100%",
				marginTop: "1px",
				marginBottom: "1px",
				paddingTop: "3px"
			});
		}				
	}
}
CLEAR;

//and finaly set it to the grid

$grid->datearray= array( "RequiredDate" );

// Enable filter toolbar searching

$grid->toolbarfilter = true;

// we set the select for ship city

$grid->setSelect("ShipCity", "SELECT DISTINCT ShipCity, ShipCity AS CityName FROM orders ORDER BY 2", false, false, true );

$grid->navigator = true;

$grid->setNavOptions('navigator', array("excel"=>false,"add"=>false,"edit"=>false,"del"=>false,"view"=>false, "search"=>false));

$onClearVal = <<< CLEAR

function (elem, coli, soptions, defval) {

if(coli > 0) {

var name = this.p.colModel[coli].name;

if(name === 'ShipCity') {

$(elem).val(defval);

$(elem).multiselect('refresh');

$(elem).siblings('button.ui-multiselect').css({

width: "100%",

marginTop: "1px",

marginBottom: "1px",

paddingTop: "3px"

});

}

CLEAR;

Please let us know if you have difficulties with this.

Kind Regards,
Will

Guriddo Support Team

January 25, 2016 at 4:42 pm #124736

kgrogers

Participant

Oh ok. Let me try my last post above. This is what I ended up doing to show/hide the export button based on the number of records returned:

$grid->navigator = true;

$setNav =<<<SETNAV
function() {
    var numrecs = $('#grid').jqGrid('getGridParam','records');
    if (numrecs < 200000) {
        $('#pager_excel').show();
    } else {
        $('#pager_excel').hide();
    }
}
SETNAV; $grid->setGridEvent('gridComplete',$setNav);
$grid->setNavOptions('navigator',array('add'=>false,'edit'=>false,'del'=>false,'view'=>true,"columns"=>true));
// Run the script
$grid->renderGrid('#grid','#pager',true, null, null, true,true);

$grid->navigator = true;

$setNav =<<<SETNAV

function() {

var numrecs = $('#grid').jqGrid('getGridParam','records');

if (numrecs < 200000) {

$('#pager_excel').show();

} else {

$('#pager_excel').hide();

}

SETNAV; $grid->setGridEvent('gridComplete',$setNav);

$grid->setNavOptions('navigator',array('add'=>false,'edit'=>false,'del'=>false,'view'=>true,"columns"=>true));

// Run the script

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

This reply was modified 6 years, 6 months ago by kgrogers.

January 26, 2016 at 12:05 pm #124740

guriddo.support

Participant

Hello,

Thank you for sharing this solution.

Glad to see that publishing code is working fine.

Kind Regards,

Will

This reply was modified 6 years, 6 months ago by guriddo.support.

Guriddo Support Team

Author

Replies

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

Registered Users: 12,191
Forums: 7
Topics: 10,919
Replies: 23,056
Topic Tags: 315

14 Users Online

Users: 3 Guests, 11 Bots

Stay connected with us in your favorite flavor!

Show/Hide export button

Search Forum

Recent Replies

Forum Statistics

UserOnline