Guriddo » bogdanm's Replies

bogdanm

Guriddo

Forum Replies Created

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

← 1 2

Author

Replies

October 11, 2016 at 2:53 pm in reply to: Unformat does not work when trying to change decimal separator #125587

bogdanm

Participant

Thanks, it worked.

I tried also to use a summary row, but the values there are not formatted according to the custom function I defined. Is there a way to have the numbers in the summary row shown with comma as decimal separator?

October 7, 2016 at 10:43 am in reply to: Unformat does not work when trying to change decimal separator #125582

bogdanm

Participant

Aha, what I need to do is something like this?


$grid-&gt;setColProperty(&#039;hourlyrate&#039;, array(&quot;label&quot;=&gt;&quot;Rate (&amp;euro;)&quot;, &quot;width&quot;=&gt;&quot;40&quot;, &quot;fixed&quot;=&gt;true, &quot;align&quot;=&gt;&quot;right&quot;, &quot;formatter&quot;=&gt;&quot;js:numFormat&quot;));

$custom = &lt;&lt;&lt;CUSTOM
function numFormat(cellvalue, options, rowObject){
        return cellvalue.replace(&quot;.&quot;,&quot;,&quot;);
}
CUSTOM;

$replacecomma = &lt;&lt;&lt;REPLACECOMMA
function replacecomma(){
   what do I put here?
}
REPLACECOMMA;

$grid-&gt;setNavEvent(&#039;edit&#039;, &#039;serializeEditData&#039;, $replacecomma);
$grid-&gt;setNavEvent(&#039;add&#039;, &#039;serializeEditData&#039;, $replacecomma);

$grid-&gt;setJSCode($custom);

$grid->setColProperty('hourlyrate', array("label"=>"Rate (&euro;)", "width"=>"40", "fixed"=>true, "align"=>"right", "formatter"=>"js:numFormat"));

$custom = <<<CUSTOM

function numFormat(cellvalue, options, rowObject){

return cellvalue.replace(".",",");

}

CUSTOM;

$replacecomma = <<<REPLACECOMMA

function replacecomma(){

what do I put here?

}

REPLACECOMMA;

$grid->setNavEvent('edit', 'serializeEditData', $replacecomma);

$grid->setNavEvent('add', 'serializeEditData', $replacecomma);

$grid->setJSCode($custom);

How do I create the function that changes just some columns?

This reply was modified 9 years, 7 months ago by bogdanm.

September 8, 2016 at 3:16 pm in reply to: What event do I need to use to reload another grid after add, edit, delete? #125529

bogdanm

Participant

Thank you guys, it worked based on your solution sent over email.

I’m posting here the relevant lines of code, so anyone faced with this issue and finding this thread can see the proper solution.


$balances=&lt;&lt;&lt;BALANCES
function()
{
    jQuery(&quot;#balances&quot;).trigger(&quot;reloadGrid&quot;);
    return [true,&#039;&#039;];
}
BALANCES;

$grid-&gt;setNavEvent(&#039;edit&#039;, &#039;afterSubmit&#039;, $balances);
$grid-&gt;setNavEvent(&#039;add&#039;, &#039;afterSubmit&#039;, $balances);
$grid-&gt;setNavEvent(&#039;del&#039;, &#039;afterSubmit&#039;, $balances);

$balances=<<<BALANCES

function()

{

jQuery("#balances").trigger("reloadGrid");

return [true,''];

}

BALANCES;

$grid->setNavEvent('edit', 'afterSubmit', $balances);

$grid->setNavEvent('add', 'afterSubmit', $balances);

$grid->setNavEvent('del', 'afterSubmit', $balances);

September 7, 2016 at 9:26 am in reply to: What event do I need to use to reload another grid after add, edit, delete? #125527

bogdanm

Participant

Where can I send you the files?

September 7, 2016 at 6:43 am in reply to: What event do I need to use to reload another grid after add, edit, delete? #125525

bogdanm

Participant

As I explained above, my html file has this:

  &lt;body&gt;
        &lt;?php
                echo &quot;&lt;div style=\&quot;clear:left\&quot;&gt;&quot;;
                echo &quot;&lt;p style=\&quot;font-size:12px;font-family:verdana,arial,sans-serif\&quot;&gt;&lt;b&gt;Cash (RON)&lt;/b&gt;&lt;/p&gt;&quot;;
                include (&quot;cashron-grid1.php&quot;);
                echo &quot;&lt;/div&gt;&quot;;
                echo &quot;&lt;div style=\&quot;clear:left;margin-left:350px\&quot;&gt;&quot;;
                echo &quot;&lt;br&gt;&lt;p style=\&quot;margin-left:120px;font-size:12px;font-family:verdana,arial,sans-serif\&quot;&gt;&lt;b&gt;Balances&lt;/b&gt;&lt;/p&gt;&quot;;
                include (&quot;cashron-grid2.php&quot;);
                echo &quot;&lt;/div&gt;&quot;;
        ?&gt;
   &lt;/body&gt;

<body>

<?php

echo "<div style=\"clear:left\">";

echo "<p style=\"font-size:12px;font-family:verdana,arial,sans-serif\"><b>Cash (RON)</b></p>";

include ("cashron-grid1.php");

echo "</div>";

echo "<div style=\"clear:left;margin-left:350px\">";

echo "<br><p style=\"margin-left:120px;font-size:12px;font-family:verdana,arial,sans-serif\"><b>Balances</b></p>";

include ("cashron-grid2.php");

echo "</div>";

</body>

And in cashron-grid1.php I have:

$balances=&lt;&lt;&lt;BALANCES
function()
{
    jQuery(&quot;#balances&quot;).jqGrid(&#039;setGridParam&#039;,{postData:{cashronid:rowid}});
    jQuery(&quot;#balances&quot;).trigger(&quot;reloadGrid&quot;);
}
BALANCES;
$grid-&gt;setGridEvent(&#039;afterSubmit&#039;, $balances);

$balances=<<<BALANCES

function()

{

jQuery("#balances").jqGrid('setGridParam',{postData:{cashronid:rowid}});

jQuery("#balances").trigger("reloadGrid");

}

BALANCES;

$grid->setGridEvent('afterSubmit', $balances);

So I need to refresh the grid in cashron-grid2.php when I add/edit/delete in cashron-grid1.php, but the above event does not work.

September 5, 2016 at 9:17 am in reply to: What event do I need to use to reload another grid after add, edit, delete? #125520

bogdanm

Participant

Hmm…, how do I paste code here? I tried the “code” in square brackets tags but they don’t work.

This reply was modified 9 years, 8 months ago by bogdanm.

September 5, 2016 at 9:11 am in reply to: What event do I need to use to reload another grid after add, edit, delete? #125518

bogdanm

Participant

I mentioned the “detail” example in the demo because I also have a page with 2 grids, but in my case the second grid does not need any rowid from the first grid.

I just need to refresh the second grid every time I add (or edit, delete) a row in the first grid.

Here is the code that I use:

The <body> section of the html file (actually it’s a .php file):

[code]

<body>
<?php
echo "<div>";
echo "<p style=\"font-size:12px;font-family:verdana,arial,sans-serif\"><b>Cash (RON)</b></p>";
include ("cashron-grid1.php");
echo "</div>";
echo "<div>";
echo "<br><p style=\"margin-left:120px;font-size:12px;font-family:verdana,arial,sans-serif\"><b>Balances</b></p>";
include ("cashron-grid2.php");
echo "</div>";

?>
</body>

[/code]

In cashron-grid1.php I have:

[code]

$balances=<<<BALANCES
function()
{
jQuery("#balances").jqGrid(‘setGridParam’,{postData:{cashronid:rowid}});
jQuery("#balances").trigger("reloadGrid");
}
BALANCES;
$grid->setGridEvent(‘afterSubmit’, $balances);

[/code]

The purpose is to refresh the grid in cashron-grid2.php every time I add/edit/delete in cashron-grid1.php.

Grid2 does not need a rowid from the changed row in grid1. It just calculates some totals, but with different WHERE statements in the SQL query.

This reply was modified 9 years, 8 months ago by bogdanm.

September 2, 2016 at 11:41 am in reply to: What event do I need to use to reload another grid after add, edit, delete? #125514

bogdanm

Participant

I use formedit.

September 2, 2016 at 11:06 am in reply to: What event do I need to use to reload another grid after add, edit, delete? #125512

bogdanm

Participant

I want to achieve something similar to your demo at:

http://www.guriddo.net/demo/demos/jqgrid/

in “Selection” -> “Master detail on select”.

There the “detail” grid gets refreshed every time a row is selected in the grid above.

What I need is the same refresh of the “detail” grid (in my case it’s called “balances”), only I need it to happen when a row is added or edited or deleted in the first grid.

The event “afterSubmit” does not seem to work for me. If I replace it with “onRowSelect”, it works on selects, so all the other code is correct, it’s just the event that needs to be changed, and I don’t know which is the correct one.

July 22, 2016 at 9:11 am in reply to: Buttons disappear after loading grid state #125426

bogdanm

Participant

Thanks, it worked!

July 21, 2016 at 11:33 am in reply to: Buttons disappear after loading grid state #125420

bogdanm

Participant

Sorry for not seeing the related information in that thread.

So, the code you posted in that thread is for jqGrid JS:

$(&quot;#grid&quot;).jqGrid({
...
storeNavOptions : true,
...
});

$("#grid").jqGrid({

...

storeNavOptions : true,

...

});

For PHP it is like this?

$grid->storeNavOptions = true;

Does it matter the position in the code for this line? Can I put it right after:

$jscode = &lt;&lt;&lt;CODE
$(&quot;#savestate&quot;).click(function(){
$.jgrid.saveState(&quot;grid&quot;);
});
$(&quot;#loadstate&quot;).click(function(){
$.jgrid.loadState(&quot;grid&quot;);
});
CODE;

$grid-&gt;setJSCode($jscode);

$jscode = <<<CODE

$("#savestate").click(function(){

$.jgrid.saveState("grid");

});

$("#loadstate").click(function(){

$.jgrid.loadState("grid");

});

CODE;

$grid->setJSCode($jscode);

This reply was modified 9 years, 10 months ago by bogdanm.
This reply was modified 9 years, 10 months ago by bogdanm.

February 19, 2016 at 9:22 am in reply to: What event triggers after inserting a new DB entry? #124878

bogdanm

Participant

Thanks, it worked!

Also, can you tell me if there’s an easy way to make the grey background (behind the add and edit panels) only cover the grid that is being added or edited? Right now it covers the entire page, including my second grid. (should I create a different thread for this?)

February 18, 2016 at 12:09 pm in reply to: What event triggers after inserting a new DB entry? #124871

bogdanm

Participant

I am displaying a second grid below the main one. The second grid show entries that were added that day and I need to use an event in the main grid to trigger a refresh of the second grid.

So in the main grid I tried to use the following:

$refreshtoday = <<<ENDTODAY
function()
{
jQuery(“#detail”).trigger(“reloadGrid”);
}
ENDTODAY;
$grid->setGridEvent(‘afterInsertRow’, $refreshtoday);

But the above triggers the refresh for every row the main grid displays (so if I have 20 rows per page, the event triggers 20 times). I wanted to trigger only when a new row is added (via the add panel).

This reply was modified 10 years, 3 months ago by bogdanm.

January 13, 2016 at 5:49 pm in reply to: Datepicker customization #124682

bogdanm

Participant

Thank you for the info.

For anyone having the same problem, here is how to do it:

$grid->setDatepicker(‘mycolumn’, array(“firstDay”=>”1”));

Author

Replies

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

← 1 2