problem to get rows added

[Arnaud]

Hi guys,

I'm French boy then sorry for my english language level.

What I ask is simple :p. Once I have added all my lines via the grid, I want get all rows added but i don't found this .

Please, somebody can help me to act ?

Thank you


This is my code :
toolbar: {
         items: [
            //...
            { type: 'button', icon: 'ui-icon-disk', label: 'Add all rows', cls: 'changes', listener:
               { "click": function (evt, ui) {
                  console.log(this); console.log(evt); console.log(ui);
                  saveChanges(this, evt, ui);
               }
               },
               options: { disabled: false }
            }
         //...
}

[paramvir]

You have to implement saveChanges function as well as server side code to commit the changes to the server as shown in this demo:

http://paramquery.com/pro/demos/editing_batch

[Arnaud]

I have TypeError: grid.saveEditCell is not a function

function saveChanges() {
   
      console.log(grid);
   
      //attempt to save editing cell.
      if (grid.saveEditCell() === false) {
         return false;
      }
      
      if ( grid.isDirty() && grid.isValidChange({ focusInvalid: true }).valid ) {

         var changes = grid.getChanges({ format: "byVal" });
         
         console.log(changes);
         
         
      }
    }


------

var grid = $("#montableauecriture").pqGrid(obj);

[paramvir]

jQuery object is returned by $("#montableauecriture").pqGrid(obj);

Code: [Select]

var $grid = $("#montableauecriture").pqGrid(obj);

where as javascript widget instance is returned by call to  pq.grid( "#grid_editing", obj );

Code: [Select]

var grid = pq.grid( "#montableauecriture", obj );

And the latter is used in saveChanges function as can be seen from the syntax:

Code: [Select]

grid.saveChanges();


[Arnaud]

Thanks for your answer.

In fact, I want use jQuery Object because my code is implemented in jQuery.

Is it possible to have the function " saveChanges() " of http://paramquery.com/pro/demos/editing_batch in " jQuery " code please ?

I wish you a good day and I thank you for your attention .

Thank a lot of.

[paramvir]

Of course, alternative way of writing grid.saveChanges() is $grid.pqGrid( 'saveChanges' );

Both can be used interchangeably, it depends upon your preference and availability of required variable i.e., grid or $grid.

http://paramquery.com/pro/tutorial#topic-methods

[Arnaud]

Hello " paramquery ",

Thanks for your answers that help me strongly. I think that it will be more simple that you translate this " javascript code " in " jquery code " please. (My " jquery object " is grid : I prefer the variable name " grid " to " $grid " ).

I wish you a good day and an excellent week.


function saveChanges() {
   
      console.log(grid);
   
      //attempt to save editing cell.
      if (grid.saveEditCell() === false) {
         return false;
      }
     
      if ( grid.isDirty() && grid.isValidChange({ focusInvalid: true }).valid ) {

         var changes = grid.getChanges({ format: "byVal" });
         
         console.log(changes);
         
         
      }
    }

Arnaud.

[paramvir]

Arnaud

To repeat and make myself more clear, general syntax of widget instance is

Code: [Select]

instance.method_name( parameters );

and its jQuery equivalent is

Code: [Select]

$( ".selector" ).pqGrid( 'method_name', parameters );


Please check the below code in jQuery. Hope it helps.

Code: [Select]

function saveChanges() {
   
      console.log(grid);
   
      //attempt to save editing cell.
      if ($grid.pqGrid( 'saveEditCell' ) === false) {
         return false;
      }
     
      if ( $grid.pqGrid( 'isDirty' ) && $grid.pqGrid( 'isValidChange', { focusInvalid: true }).valid ) {

         var changes = $grid.pqGrid( 'getChanges', { format: "byVal" });
         
         console.log(changes);
                 
      }
    }


[Arnaud]

Re-hello,

I'm sorry to return to you but I'm on the end with the function " saveChanges " but I block on the " $grid manipulation " in data submission. Here are " console.log " :

console.log($grid) ==> Object { 0: <div#montableauecriture.pq-grid.panel.panel-default.pq-disable-select>, length: 1, context: HTMLDocument → ecriture, selector: "#montableauecriture" }

console.log($grid.pqGrid( 'saveEditCell' )) ==> undefined

console.log($grid.pqGrid( 'isDirty' )) ==> false

Can you help me to have " $grid.pqGrid( 'getChanges', { format: "byVal" }); " with datas please ?

Thanks.

Arnaud.

[paramvir]

Can you help me to have " $grid.pqGrid( 'getChanges', { format: "byVal" }); " with datas please ?

I'm not sure what is your question. Please look into the documentation for the getChanges method.

http://paramquery.com/pro/api#method-getChanges

For more details check its console.log

console.log ( $grid.pqGrid( 'getChanges', { format: "byVal" }) )

[Arnaud]

function saveChanges() {
      
      console.log('---');

      console.log($grid.pqGrid( 'getChanges', { format: "byVal" })); //return Object { updateList: Array[0], addList: Array[0], deleteList: Array[0], oldList: Array[0] } instead of an Object with the datas of my grid (here are 0 anywhere in " changes ").

      console.log('true ? ' + $grid.pqGrid( 'isDirty' )); //return false instead of true

      console.log('true ? ' + $grid.pqGrid( 'isValidChange', { focusInvalid: true }).valid); //return true ==> it works

      console.log('false ? ' + ($grid.pqGrid( 'saveEditCell' ) === false)); //return false ==> it works

      console.log('---');   
    }

[paramvir]

That means tracking is not working in your case.

Please ensure that you have turned on the below options:

1) trackModel: { on: true }, //to turn on the track changes.

2) dataModel: { recIndx: "dataIndx of primary key", ... } // http://paramquery.com/pro/api#option-dataModel-recIndx

[Arnaud]

THANKS !!!! IT WORKS !!!

I LOVE YOU SO MUCH !!

[paramvir]

You're welcome!