In jqGrid PHP you can do:

require_once ABSPATH.”php/PHPSuito/DBdrivers/jqGridArray.php”;

Then rather than reading data from a database you can read it from an array, I wondered if TreeGrid also supported this and if it could build the tree based on a multidimensional array as in the example?

Many thanks, I will look forward to the next release.

Many thanks, I’ve downloaded the latest theme CSS and added this to the end which has appeared to have cleaned things up.

Many thanks, great support, I will check it out.

Hi Will,

Many thanks for the reply, I’ve taken a look at the site you selected and downloaded the code, but I’m having issues targeting it into Guriddo, I’ve tried the following:

1. Targeting gs_alert_time directly, the result works reasonably well, but I cannot seem to be able to submit the form
2. Inject the code into the gs_alert_time using appendTo, trouble is here that the code doesn’t get called

Any ideas?  It would be good to have this natively in the solution at some point as a feature request.

<script>
$.datepicker._defaults.onAfterUpdate = null;
var datepicker__updateDatepicker = $.datepicker._updateDatepicker;
$.datepicker._updateDatepicker = function( inst ) {
datepicker__updateDatepicker.call( this, inst );
var onAfterUpdate = this._get(inst, ‘onAfterUpdate’);
if (onAfterUpdate)
onAfterUpdate.apply((inst.input ? inst.input[0] : null),
[(inst.input ? inst.input.val() : ”), inst]);
}
$(document).ready(function() {
var cur = -1, prv = -1;
$(‘

<input id=”jrangeinput”>

‘).appendTo(‘#gs_alert_time’);

$(‘#jrange div’)
.datepicker({
//numberOfMonths: 3,
changeMonth: true,
changeYear: true,
showButtonPanel: true,
defaultDate: -10,
setDate: ’10-Jul-2016′,
maxDate: 0,
beforeShowDay: function ( date ) {
return [true, ( (date.getTime() >= Math.min(prv, cur) && date.getTime() <= Math.max(prv, cur)) ? ‘date-range-selected’ : ”)];
},
onSelect: function ( dateText, inst ) {
var d1, d2;
prv = cur;
cur = (new Date(inst.selectedYear, inst.selectedMonth, inst.selectedDay)).getTime();
if ( prv == -1 || prv == cur ) {
prv = cur;
//$(‘#jrange input’).val( dateText );
$(‘#jrange input’).val( $.datepicker.formatDate( ‘dd-M-y’, new Date(Math.min(prv,cur)), {} ));
} else {
d1 = $.datepicker.formatDate( ‘dd-M-y’, new Date(Math.min(prv,cur)), {} );
d2 = $.datepicker.formatDate( ‘dd-M-y’, new Date(Math.max(prv,cur)), {} );
$(‘#jrange input’).val( d1+’ to ‘+d2 );
}
},
onChangeMonthYear: function ( year, month, inst ) {
//prv = cur = -1;
},
onAfterUpdate: function ( inst ) {
$(‘<button type=”button” class=”ui-datepicker-close ui-state-default ui-priority-primary ui-corner-all” data-handler=”hide” data-event=”click”>Done</button>’)
.appendTo($(‘#jrange div .ui-datepicker-buttonpane’))
.on(‘click’, function () { $(‘#jrange div’).hide(); });
}
})
.position({
my: ‘left top’,
at: ‘left bottom’,
of: $(‘#jrange input’)
})
.hide();

$(document).ready(function(){
// Populate the inputbox by default
var dateload = $(‘#jrange div’).datepicker(‘getDate’);
var dateload2 = $.datepicker.formatDate( ‘dd-M-y’, dateload);

$(‘#jrange input’).val(dateload2);
});

$(‘#jrange input’).on(‘focus’, function (e) {
var v = this.value,
d;
try {
if ( v.indexOf(‘ to ‘) > -1 ) {
d = v.split(‘ to ‘);
prv = $.datepicker.parseDate( ‘dd-M-y’, d[0] ).getTime();
cur = $.datepicker.parseDate( ‘dd-M-y’, d[1] ).getTime();
} else if ( v.length > 0 ) {
prv = cur = $.datepicker.parseDate( ‘dd-M-y’, v ).getTime();
}
} catch ( e ) {
cur = prv = -1;
}
if ( cur > -1 )
$(‘#jrange div’).datepicker(‘setDate’, new Date(cur));
$(‘#jrange div’).datepicker(‘refresh’).show();
});
});
</script>

• This reply was modified 9 years, 9 months ago by trevrobwhite.
• This reply was modified 9 years, 9 months ago by trevrobwhite.

E-mailed you with a dropbox link to the code, many thanks for your help.

That works a lot better thanks, just a final piece of the puzzle to solve.

When loading this way the sorting and column widths don’t reload. I’d rather have all the information stored in the database, but tried using:

schema['colmodel'] = jQuery('#grid').jqGrid('getGridParam','colModel');

then

jQuery('#grid').jqGrid('setGridParam',{colModel:obj['colmodel']}).trigger("reloadGrid");

But it doesn’t seem to work, so plan B, use load storage:
$.jgrid.saveState("grid");

then
$.jgrid.loadState("grid");

I have a lot more success with this, as the grid loads all the preferences, but all the icons in the “pager” toolbar disappear, looking in the console there is a JavaScript error:

Uncaught TypeError: Cannot read property 'beforeProcessing' of undefined$.ajax.$.extend.success @ jquery.jqGrid.min.js:10j @ jquery.min.js:2k.fireWith @ jquery.min.js:2x @ jquery.min.js:4(anonymous function) @ jquery.min.js:4

Get this working then everything is good, thanks again for the extended support.