Guriddo » trevrobwhite's Replies

trevrobwhite

Guriddo

Forum Replies Created

Viewing 14 replies - 16 through 29 (of 29 total)

← 1 2

Author

Replies

February 10, 2016 at 3:28 pm in reply to: Filter Toolbar Multi-Pick #124829

trevrobwhite

Participant

Hi Guriddo,
Sorry to bother you again, this solution was going really well, but when I started using it against a database which has new records added, when I press the Refresh button to bring in more records the filter isn’t respected and new records outside the filter appears in the grid.

Is there a way I can call an event to apply the filter after the grid reload from a jQuery call, basically simulate the onclick event of the filter.

Many thanks.

February 9, 2016 at 12:28 pm in reply to: Time Zone Conversion #124816

trevrobwhite

Participant

Hi Gruddio,
That works a treat, for users viewing this post I wanted to complete the knowledge. When you do:

$grid-&gt;setColProperty(&#039;datefield&#039;, array(
....
&quot;formatoptions&quot;=&gt;array(
&quot;srcformat&quot;=&gt;&quot;U&quot;,
&quot;newformat&quot;=&gt;&quot;m/d/Y&quot;, // or what you want
...
),
...
);

$grid->setColProperty('datefield', array(

....

"formatoptions"=>array(

"srcformat"=>"U",

"newformat"=>"m/d/Y", // or what you want

...

);

Make sure in your select (for MySQL) you do:

SELECT …. UNIX_TIMESTAMP(datefield) as datefield, …

This will convert your datefield into a UNIX (EPOCH) timestamp, however the problem is the column will now be called ‘UNIX_TIMESTAMP(datefield)’ so you need to do ‘as datefield’ to get its name back again so Guriddo can see the field.

The format I used is:
"formatoptions"=>array("srcformat"=>"U","newformat"=>"d-M-Y H:i:s T")

This is quite nice as it removes the confusion between European and US style dates which are opposite to each other and causes problems with the day/month.

Additionally if you are using the date picker you will need to add/change:

// Set the dates
$grid-&gt;setUserDate(&#039;d-M-Y&#039;);
$grid-&gt;setUserTime(&#039;d-M-Y H:i:s T&#039;);

$grid-&gt;setDbDate(&#039;U&#039;);
$grid-&gt;setDbTime(&#039;U&#039;);

$grid-&gt;setDatepicker( &quot;datefield&quot; );
$grid-&gt;datearray= array( &quot;datefield&quot; );

// Set the dates

$grid->setUserDate('d-M-Y');

$grid->setUserTime('d-M-Y H:i:s T');

$grid->setDbDate('U');

$grid->setDbTime('U');

$grid->setDatepicker( "datefield" );

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

Hope this helps.

January 29, 2016 at 1:03 pm in reply to: Filter Toolbar Multi-Pick #124759

trevrobwhite

Participant

Many thanks, this works well.
I did find it a pain naming all the multi selects manually so, modified the jQuery code slightly.

var items = jQuery(&quot;[aria-multiselectable=true]&quot;);
		jQuery.each(items,function () {
		    var obj = jQuery(&#039;#&#039; + this.id);
		    obj.multiselect(&#039;refresh&#039;);
		    obj.siblings(&#039;button.ui-multiselect&#039;).css({
			width: &quot;100%&quot;,
			marginTop: &quot;1px&quot;,
			marginBottom: &quot;1px&quot;,
			paddingTop: &quot;3px&quot;
		    });
		});

var items = jQuery("[aria-multiselectable=true]");

jQuery.each(items,function () {

var obj = jQuery('#' + this.id);

obj.multiselect('refresh');

obj.siblings('button.ui-multiselect').css({

width: "100%",

marginTop: "1px",

marginBottom: "1px",

paddingTop: "3px"

});

I’m sure the initial jQuery select can be tidied a bit so it returns an object not a string, but I struggled to get an object back.

January 28, 2016 at 11:14 am in reply to: Filter Toolbar Multi-Pick #124749

trevrobwhite

Participant

Correct, the grid is constructed, I set the filters, sort etc and hit save, this runs a jQuery to store the sorting/filtering/column widths etc.

Then the grid is fully loaded, the user presses “Load” and the grid is loaded with there setup.

However if there is an easier way to achieve the same thing by going a full page refresh that works for me.

Correct the toolbar is on, below is what is looks like (sorry I had to hide the data), I’m hoping in the action column to have a button or link to do some custom actions (I’m working on that part)

Layout

Many thanks.

This reply was modified 10 years, 5 months ago by trevrobwhite.

January 27, 2016 at 7:45 pm in reply to: Filter Toolbar Multi-Pick #124747

trevrobwhite

Participant

Is it possible to save and load the filters?

I’ve tried:

jQuery(&#039;#grid&#039;).jqGrid(&#039;getGridParam&#039;,&#039;colModel&#039;);
jQuery.post(&quot;alertprocessor_ajax.php?id=savelayout&quot;, { data: JSON.stringify(schema) })

1 2	jQuery('#grid').jqGrid('getGridParam','colModel'); jQuery.post("alertprocessor_ajax.php?id=savelayout", { data: JSON.stringify(schema) })

with:

var obj = JSON.parse(data);
jQuery(&#039;#grid&#039;).jqGrid(&#039;setGridParam&#039;,{colModel: obj}).trigger(&quot;reloadGrid&quot;);

var obj = JSON.parse(data);

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

and also
var schema = jQuery('#grid').jqGrid('getGridParam','postData');
with

var obj = JSON.parse(data);
jQuery(&#039;#grid&#039;).jqGrid(&#039;setGridParam&#039;,{postData: obj}).trigger(&quot;reloadGrid&quot;);

var obj = JSON.parse(data);

jQuery('#grid').jqGrid('setGridParam',{postData: obj}).trigger("reloadGrid");

But I cannot seem to get the layout to hold for the multi-select, is the data somewhere I can access so I can save the layout and reload it later?

In the background I stringify the data and store it in the database then reload using jQuery after sending through JSON.parse.

Many thanks.

January 25, 2016 at 4:43 pm in reply to: Filter Toolbar Multi-Pick #124737

trevrobwhite

Participant

Had a play around, this is looking great, many thanks.

January 25, 2016 at 1:13 pm in reply to: Filter Toolbar Multi-Pick #124733

trevrobwhite

Participant

Many thanks for this, I’m using Guriddo jqGrid PHP can you detail which files need to be replaced in here as there are more files in the jqGrid distribution compared to mine.

Or is replacing the jquery.jqGrid.min.js enough.

Again many thanks.

January 20, 2016 at 7:25 pm in reply to: Filter Toolbar Multi-Pick #124709

trevrobwhite

Participant

That looks like exactly what I need, the “all” looks a bit buggy but as you mention it’s work in progress.

Am I right to think that getGridParam will support the multi-select option when it’s done?

Thanks again for this effort.

January 19, 2016 at 11:10 pm in reply to: Filter Toolbar Multi-Pick #124702

trevrobwhite

Participant

Many thanks.

January 19, 2016 at 4:24 pm in reply to: 100% or Auto Height Creates a Huge Page #124698

trevrobwhite

Participant

Many thanks for this.

January 19, 2016 at 11:50 am in reply to: 100% or Auto Height Creates a Huge Page #124695

trevrobwhite

Participant

Many thanks. Do you have a guide anywhere how to pass the JavaScript height variable to the PHP backend script to assist me in this calculation.

Many thanks.

January 16, 2015 at 5:35 pm in reply to: jqForm connected to SQL Database #115367

trevrobwhite

Participant

Thank-you for fixing the code, any ideas on what I’m doing wrong?

This reply was modified 11 years, 5 months ago by trevrobwhite.

January 16, 2015 at 11:41 am in reply to: jqForm connected to SQL Database #115351

trevrobwhite

Participant

I’ve tried and tried and I can’t get your system to accept the code in a good format, even using your code screen.

January 16, 2015 at 11:35 am in reply to: jqForm connected to SQL Database #115347

trevrobwhite

Participant

Below is the PHP code I used, I can see that the query is being made because Firebug picks it up as POST command as soon as the page is loaded:

Here is the post (sorry can’t attached as a screen capture), sorry had to block the data:

Interestingly if I use the visual form builder I get the same issue.

<script src="includes/JQuery/jquery-1.10.2.min.js" type="text/javascript"></script><script src="includes/JQuery/jquery-ui-1.10.3.custom.min.js" type="text/javascript"></script><script src="includes/JQuery/jquery.validate.min.js" type="text/javascript"></script><script src="includes/JQuery/jquery.additional-methods.js" type="text/javascript"></script>{"id_satellite":"7","friendly_name":"XXXX","country":"XXXX","region":"XX","type":"XXXX","package":"XXXX","install_date":"2013-12-19","SPID":"XXXX","active":"1","beta":"1","current_version":"XXX","last_update":null,"comments":null}

// jQuery
echo "<script type='text/javascript' src='includes/JQuery/jquery-1.10.2.min.js'></script>" . PHP_EOL;
echo "<script type='text/javascript' src='includes/JQuery/jquery-ui-1.10.3.custom.min.js'></script>" . PHP_EOL;
echo "<script type='text/javascript' src='includes/JQuery/jquery.validate.min.js'></script>" . PHP_EOL;
echo "<script type='text/javascript' src='includes/JQuery/jquery.additional-methods.js'></script>" . PHP_EOL;
echo "<link type='text/css' href='includes/JQuery/jquery-ui-1.10.3.custom.min.css' rel='stylesheet' />" . PHP_EOL;

include_once 'includes/jqSuite/jqUtils.php';
include_once 'includes/jqSuite/jqForm.php';
include_once 'includes/jqSuite/jqGridPdo.php';

// Create Form
$form = new jqForm('satsetup', array ('method'=>'post', id => 'satsatup'));

$dbpdo = new PDO('mysql:host=localhost;dbname=servers;charset=utf8', $arrMYSQL['USER'], $arrMYSQL['PASSWORD']);
$form->setConnection($dbpdo);
$form->setUrl($_SERVER['PHP_SELF']);

$form->setFormHeader("Extended Server Details", "ui-icon-pencil");

$item = jqGridUtils::GetParam('id_satellite', '7');
$jqformparams = array ($item);

$form->SelectCommand = "SELECT id_satellite, friendly_name, country, region, type, package, install_date, SPID, active, beta, current_version, last_update, comments FROM extended_setup where id_satellite = ?";
$form->table = "ExtendedSetup";
$form->setPrimaryKeys("id_satellite, type, SPID");
//$form->setPrimaryKeys("id_satellite");
$form->setColumnLayout('twocolumn');
$form->setTableStyles('width:50%;','','');
$form->addElement("id_satellite", 'text', array('label' => 'Satellite ID', 'id' => 'form_id_satellite'));
$form->addElement("friendly_name", 'text', array('label' => 'Name', 'id'=>'form_friendly_name'));
// TODO Add other items
$elem_8[]=$form->createElement('newSubmit','submit', array('value' => 'Submit'));
$form->addGroup("newGroup",$elem_8, array('style' => 'text-align:right;', 'id' => 'newForm_newGroup'));

$form->setAjaxOptions( array('dataType'=>null,
'resetForm' =>null,
'clearForm' => null,
'iframe' => false,
'forceSync' =>false) );
//$form->demo = true;
echo $form->renderForm($jqformparams);

// jQuery

echo "<script type='text/javascript' src='includes/JQuery/jquery-1.10.2.min.js'></script>" . PHP_EOL;

echo "<script type='text/javascript' src='includes/JQuery/jquery-ui-1.10.3.custom.min.js'></script>" . PHP_EOL;

echo "<script type='text/javascript' src='includes/JQuery/jquery.validate.min.js'></script>" . PHP_EOL;

echo "<script type='text/javascript' src='includes/JQuery/jquery.additional-methods.js'></script>" . PHP_EOL;

echo "<link type='text/css' href='includes/JQuery/jquery-ui-1.10.3.custom.min.css' rel='stylesheet' />" . PHP_EOL;

include_once 'includes/jqSuite/jqUtils.php';

include_once 'includes/jqSuite/jqForm.php';

include_once 'includes/jqSuite/jqGridPdo.php';

// Create Form

$form = new jqForm('satsetup', array ('method'=>'post', id => 'satsatup'));

$dbpdo = new PDO('mysql:host=localhost;dbname=servers;charset=utf8', $arrMYSQL['USER'], $arrMYSQL['PASSWORD']);

$form->setConnection($dbpdo);

$form->setUrl($_SERVER['PHP_SELF']);

$form->setFormHeader("Extended Server Details", "ui-icon-pencil");

$item = jqGridUtils::GetParam('id_satellite', '7');

$jqformparams = array ($item);

$form->SelectCommand = "SELECT id_satellite, friendly_name, country, region, type, package, install_date, SPID, active, beta, current_version, last_update, comments FROM extended_setup where id_satellite = ?";

$form->table = "ExtendedSetup";

$form->setPrimaryKeys("id_satellite, type, SPID");

//$form->setPrimaryKeys("id_satellite");

$form->setColumnLayout('twocolumn');

$form->setTableStyles('width:50%;','','');

$form->addElement("id_satellite", 'text', array('label' => 'Satellite ID', 'id' => 'form_id_satellite'));

$form->addElement("friendly_name", 'text', array('label' => 'Name', 'id'=>'form_friendly_name'));

// TODO Add other items

$elem_8[]=$form->createElement('newSubmit','submit', array('value' => 'Submit'));

$form->addGroup("newGroup",$elem_8, array('style' => 'text-align:right;', 'id' => 'newForm_newGroup'));

$form->setAjaxOptions( array('dataType'=>null,

'resetForm' =>null,

'clearForm' => null,

'iframe' => false,

'forceSync' =>false) );

//$form->demo = true;

echo $form->renderForm($jqformparams);

For the binding part are you able to give me a bit of an example or point me to some documentation so I know what function to call

This reply was modified 11 years, 5 months ago by trevrobwhite. Reason: Bad system formatting
This reply was modified 11 years, 5 months ago by trevrobwhite.
This reply was modified 11 years, 5 months ago by trevrobwhite.
This reply was modified 11 years, 5 months ago by admin.
This reply was modified 11 years, 5 months ago by tony. Reason: fixing code publishing
This reply was modified 11 years, 5 months ago by tony.
This reply was modified 11 years, 5 months ago by tony.
This reply was modified 11 years, 5 months ago by tony.
This reply was modified 11 years, 5 months ago by tony.
This reply was modified 11 years, 5 months ago by tony.

Author

Replies

Viewing 14 replies - 16 through 29 (of 29 total)

← 1 2