Guriddo » guriddo.support's Replies

guriddo.support

Guriddo

Forum Replies Created

Viewing 15 replies - 631 through 645 (of 1,092 total)

← 1 2 3 … 42 43 44 … 71 72 73 →

Author

Replies

November 9, 2016 at 10:12 am in reply to: Ajax Success return data #125649

guriddo.support

Participant

Hello Christian,

There is a problem with ajax sync:false when used with jQuery, so the suggestion I have made will not work.

I can suggest you another approach.

The idea is simple

1. Determine at server that we are in add mode.
2. Check if the record exists
3. do the needt to insert if it not exists
4.disable the automatic add operation in grid.

This code can look like this (note that we do not try this):

....

if($grid-&gt;oper === &#039;add&#039;) {
    $data = jqGridUtils::Strip($_POST);
    // you have here $data[&#039;nom&#039;] and etc
    // Check here with your SQL if the record exists
    // suppose this is variable $recordexists
    if( !$recordexists ) {
       $grid-&gt;insert( $data );
    } else {
       $grid-&gt;errorMessage = &quot;Record exists&quot;;
       $grid-&gt;sendErrorHeader();
    }
}
// disable automatic add
$grid-&gt;add = false;

....

if($grid->oper === 'add') {

$data = jqGridUtils::Strip($_POST);

// you have here $data['nom'] and etc

// Check here with your SQL if the record exists

// suppose this is variable $recordexists

if( !$recordexists ) {

$grid->insert( $data );

} else {

$grid->errorMessage = "Record exists";

$grid->sendErrorHeader();

}

// disable automatic add

$grid->add = false;

Kind Regards
Will

Guriddo Support Team

November 9, 2016 at 10:00 am in reply to: Entry formula on input #125648

guriddo.support

Participant

Hello,

Thank you for the feedback. We don’t try this, so it is a good that you post this for the other users.

Thank you.

Kind Regards

Will

Guriddo Support Team

November 8, 2016 at 11:02 am in reply to: Entry formula on input #125642

guriddo.support

Participant

Hello,

It depend where you want to put this logic – server side or client side.

I think that one possible solution is toy use a javascript formula parser something like this one

The idea is to bind a change event to this field using dataInit function and maybe it is better to use two fields one for the formula another for result, but I think it can be done with one field too.

Kind Regards,
Will

Guriddo Support Team

November 7, 2016 at 9:04 am in reply to: Ajax Success return data #125640

guriddo.support

Participant

Hello,

Possible cuase is that in a case you do this, there are two ajax requests at the same time – your and the jqGrid one, which follow immediate after beforeSubmit

One possible resolution is the set is your request async : false in ajax settings

...
$.ajax({
  async : false, 
  type: &#039;GET&#039;,
  dataType: &#039;text&#039;,
  data: {q1:nom, q2:prenom, q3:datenaissance},
  url: &#039;g_nomprenomdate.php&#039;,
...

...

$.ajax({

async : false,

type: 'GET',

dataType: 'text',

data: {q1:nom, q2:prenom, q3:datenaissance},

url: 'g_nomprenomdate.php',

...

Kind Regards,
Will

Guriddo Support Team

November 7, 2016 at 9:02 am in reply to: Entry formula on input #125639

guriddo.support

Participant

Hello,

Could you please let us know where and how you do this. If previously you use jqGrid JavaScript, then you can do this in PHP too – just let us know the JavaScript way.

Kind Regards,

Will

Guriddo Support Team

October 28, 2016 at 1:42 pm in reply to: How to disable the publishing of some lines ? #125626

guriddo.support

Participant

”

In inline edit you should add class “not-editable-row” in form edit you should add class “ui-state-disabled” for jQueryUI and “ui-disabled” when using bootstrap.

“

Guriddo Support Team

October 28, 2016 at 11:26 am in reply to: How to disable the publishing of some lines ? #125624

guriddo.support

Participant

Read carefully this post Form beginning to the end.

Regards

Will

Guriddo Support Team

October 28, 2016 at 10:36 am in reply to: How to disable the publishing of some lines ? #125622

guriddo.support

Participant

Hello,

Dear @cvneo it seems to me you do not have carefully read my posts. The solution is in some of my previous posts – you just need to read them.

Regards,
Will

Guriddo Support Team

October 27, 2016 at 11:40 am in reply to: How to disable the publishing of some lines ? #125619

guriddo.support

Participant

Hello,

This behaviour is by default. I think you do something wrong. Records with ui-state-disabled are not selectable and not editable. Also the navigator button is disabled too if the next record is disabled.

See demo here

Kind Regards,
Will

Guriddo Support Team

October 24, 2016 at 9:08 am in reply to: How to disable the publishing of some lines ? #125617

guriddo.support

Participant

Hello,

As I say in may previous post if you set desired rows with the class ui-state-disabled, the rows are not editable. The small function in this case is easy to be written.

function isEditable( rowid ) {
   return  $(&quot;#rowid&quot;).hasClass(&quot;ui-state-disabled&quot;) ? true : false;
}

function isEditable( rowid ) {

return $("#rowid").hasClass("ui-state-disabled") ? true : false;

}

where the rowid is the id of the row.

Note that in this case the navigator buttons are disable autoamtically when you select the row with this class.

All you need is to set the desired class depending on your data

Regards

Will

Guriddo Support Team

October 20, 2016 at 4:26 pm in reply to: How do I update the summaryrow after inline editing? #125612

guriddo.support

Participant

Hello,

Sorry for the mistake.

If you use editor like NetBeans you can easy see the error.

a ” } ” is missing, Try this:

onselrow = &lt;&lt;&lt; ONSELROW
function(rowid, selected)
{
    if(rowid &amp;&amp; rowid !== lastSelection) {
        $(&quot;#grid&quot;).jqGrid(&#039;restoreRow&#039;, lastSelection);
        $(&quot;#grid&quot;).jqGrid(&#039;editRow&#039;, rowid, { aftersavefunc : function() {
           setTimeout( function() { $(&quot;#grid&quot;).trigger(&quot;reloadGrid&quot;); }, 10); }
        });
        lastSelection = rowid;
    }
}
ONSELROW;

onselrow = <<< ONSELROW

function(rowid, selected)

{

if(rowid && rowid !== lastSelection) {

$("#grid").jqGrid('restoreRow', lastSelection);

$("#grid").jqGrid('editRow', rowid, { aftersavefunc : function() {

setTimeout( function() { $("#grid").trigger("reloadGrid"); }, 10); }

});

lastSelection = rowid;

}

ONSELROW;

Regards,
Will

Guriddo Support Team

October 20, 2016 at 9:26 am in reply to: How do I update the summaryrow after inline editing? #125610

guriddo.support

Participant

Hello,

The syntax is correct, but you will need to put it in dblSelect Row

$grid-&gt;setGridOptions(array(
    &quot;hoverrows&quot;=&gt;false,
    &quot;footerrow&quot;=&gt;true,
    &quot;userDataOnFooter&quot;=&gt;true
));

$summaryrows = array(&quot;col1&quot;=&gt;array(&quot;col1&quot;=&gt;&quot;SUM&quot;), &quot;col2&quot;=&gt;array(&quot;col2&quot;=&gt;&quot;SUM&quot;));

onselrow = &lt;&lt;&lt; ONSELROW
function(rowid, selected)
{
    if(rowid &amp;&amp; rowid !== lastSelection) {
        $(&quot;#grid&quot;).jqGrid(&#039;restoreRow&#039;, lastSelection);
        $(&quot;#grid&quot;).jqGrid(&#039;editRow&#039;, rowid, { aftersavefunc : function() {
           setTimeout( function() { $(&quot;#grid&quot;).trigger(&quot;reloadGrid&quot;); }, 10);
        });
        lastSelection = rowid;
    }
}
ONSELROW;

$grid-&gt;setGridEvent(&#039;ondblClickRow&#039;, $onselrow);

$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, $summaryrows, null, true,true);

$grid->setGridOptions(array(

"hoverrows"=>false,

"footerrow"=>true,

"userDataOnFooter"=>true

));

$summaryrows = array("col1"=>array("col1"=>"SUM"), "col2"=>array("col2"=>"SUM"));

onselrow = <<< ONSELROW

function(rowid, selected)

{

if(rowid && rowid !== lastSelection) {

$("#grid").jqGrid('restoreRow', lastSelection);

$("#grid").jqGrid('editRow', rowid, { aftersavefunc : function() {

setTimeout( function() { $("#grid").trigger("reloadGrid"); }, 10);

});

lastSelection = rowid;

}

ONSELROW;

$grid->setGridEvent('ondblClickRow', $onselrow);

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

Regards,
Will

Guriddo Support Team

October 20, 2016 at 9:19 am in reply to: CSS changes in jQuery UI 1.12.1 affects icons colours on jqGrid #125609

guriddo.support

Participant

Hello,

Thank you very much for the information.

Kind Regards,

Will

Guriddo Support Team

October 19, 2016 at 11:40 am in reply to: How do I update the summaryrow after inline editing? #125606

guriddo.support

Participant

Hello,

There are a lot of solutions. The easy stable way without to write a lot of code is to reload the grid (trigger(‘reloadGrid’) ) after the save is done.

For this purpose you can use the aftresavefunc in editRow method. Please look into the docs here

Kind Regards

Will

Guriddo Support Team

October 18, 2016 at 11:30 am in reply to: Subgrid #125602

guriddo.support

Participant

Hello,

Check your code again. See the errors setting at top of the php script

ini_set(&quot;display_errors&quot;,1);
...

ini_set("display_errors",1);

...

Maybe when update is in action some variable in your script are not set causing the update to stop.

My suggestion is to check if your variables from the sentence are set

...
resultat=$sql-&gt;fetch();
$attestation_b= isset($resultat[‘attestation’]) ? $resultat[‘attestation’] : &quot;&quot;;
$top_verse_b=isset($resultat[‘top_verse’]) ? $resultat[‘top_verse’] : &quot;&quot;;
if ($top_verse_b == “O” &amp;&amp; $attestation_b == 1) {
...

...

resultat=$sql->fetch();

$attestation_b= isset($resultat[‘attestation’]) ? $resultat[‘attestation’] : "";

$top_verse_b=isset($resultat[‘top_verse’]) ? $resultat[‘top_verse’] : "";

if ($top_verse_b == “O” && $attestation_b == 1) {

...

Hope you get the point.

Kind Regards,
Will

Guriddo Support Team

Author

Replies

Viewing 15 replies - 631 through 645 (of 1,092 total)

← 1 2 3 … 42 43 44 … 71 72 73 →