Guriddo » guriddo.support's Replies

guriddo.support

Guriddo

Forum Replies Created

Viewing 15 replies - 406 through 420 (of 1,092 total)

← 1 2 3 … 27 28 29 … 71 72 73 →

Author

Replies

January 25, 2018 at 10:09 pm in reply to: datepicker in jqgrid #126599

guriddo.support

Participant

Look at this example

It works as expected.

Note that the conversion is done at PHP server and not at client, so the posting is correct according to the rules.

P.S. setUserDate format the date in the datepicker, so you do not need to to give other formats of the date. Note that the datepicker uses JS date formatting, while jqGrid uses PHP one and the conversion from PHP to JS in datapicker is done automatically from the script

Kind Regards,

Will

This reply was modified 8 years, 2 months ago by guriddo.support.

Guriddo Support Team

January 25, 2018 at 10:02 pm in reply to: Get reload grid reset search dialog to empty search criteria #126598

guriddo.support

Participant

Hello,

You clear the filter variables, but not the form fields, which by default are set to be not recreated.

To make this work, you will need to set recreateFilter property set to true, which by default is false.

This options should be set in searching options.

If you have difficulties, please let us know.

Please replay if the problem is resolved or not.

Kind Regards,

Will

Guriddo Support Team

January 25, 2018 at 9:55 pm in reply to: REQUEST form edit input type #126597

guriddo.support

Participant

Hello,

The html5 support is added in version 5.3 JS, which will be available in PHP version around 5-7 February.

Kind Regards,

Will

Guriddo Support Team

January 25, 2018 at 9:49 pm in reply to: Formating #126596

guriddo.support

Participant

Hello,

I’m not sure that I understand the question correct.

If you mean that the formatting of the field in grid can be different in form editing the answer is yes . Please let us know what exactly you want to do, so that we can give you the best answer.

Kind Regards,

Will

Guriddo Support Team

January 25, 2018 at 9:44 pm in reply to: Complete select statement with where clause that is passed to database #126595

guriddo.support

Participant

Hello,

There is a method called getSqlQuery() , but the dificulties is that it should be called after the main methods queryGrid, editGrid, renderGrid in order to get the right query.

I’m not sure that this will do the job. Actually the final query is generated on these three basic methods.

Kind Regards,

Will

Guriddo Support Team

January 22, 2018 at 10:17 pm in reply to: Is it possible to reload a grid without collapsing subgrids? #126589

guriddo.support

Participant

Hello,

Unfortunately there is no build in solution.

One possible solution is when you click the refresh button to get the data of the main grid in array and then use setRowData method to update the main gid.

In this case the subgrid stay in a state as it is.

Kind Regards,

Will

Guriddo Support Team

January 19, 2018 at 5:57 am in reply to: How to use rowid in script after successful Add/Edit (form) #126584

guriddo.support

Participant

Hello,

The afterSubmit event used in form editing accept 3 parameters:

– response is the data returned from the server (if any)
– postdata is the data sent to the server
– oper – determine in which mode is called – add when add row and edit when it is edited

If nothing is changed in the default settings of prmNames then the postdata rowid is stored in postdata.id property. In this case you can yse the following code to get the rowid in edit mode in case the datatype is not local

afterSubmit : function( response, postdata, oper) {
   if(oper === &#039;edit&#039;) { 
      var rowid = postdata.id;
   }
}

afterSubmit : function( response, postdata, oper) {

if(oper === 'edit') {

var rowid = postdata.id;

}

Kind Regards
Will

Guriddo Support Team

January 16, 2018 at 9:11 pm in reply to: Keep search dialog permanently visible #126581

guriddo.support

Participant

Hello,

In the same settings where you set showOnLoad try to to set the following option

...
showOnLoad=&gt;true,
overlay=&gt;0,
...

...

showOnLoad=>true,

overlay=>0,

...

The options is described here

Also you can play with the top and left property to position the dialog.

Kind Regards,
Will

Guriddo Support Team

January 15, 2018 at 1:42 pm in reply to: Problem with two "JS function" #126576

guriddo.support

Participant

Hello,

The setJSCode method should be called only once. If you call it more than one time (like you do) the last code will be executed only.

To work this you should put all your javascript code in one variable and call setJSCode.

Kind Regards,

Will

Guriddo Support Team

January 2, 2018 at 2:00 pm in reply to: setAfterCrudAction not happening #126534

guriddo.support

Participant

Hello,

Can you please send to the support (support at guriddo dot net) the code, the dump of the tables in the code and if possible some test data.

It is not possible for us to see what is really happen with these description, so please if possible prepare these.

Thank you very much.

Kind Regards,

Will

Guriddo Support Team

December 22, 2017 at 3:41 pm in reply to: setAfterCrudAction not happening #126532

guriddo.support

Participant

Hello,

There are a lot of ways. I can recommend to use beforeSubmitCell event, where you can get the needed fields and return a object, which automatically extend the posted data in cell editing.


$beforesubmit = &lt;&lt;&lt;BEFORESUBMIT
function( rowId, name, val, iRow, iCol ) {
    var value_one = $(this).jqGrid(&#039;getCell&#039;, rowId, &#039;post_name1&#039;);
    var value_two = $(this).jqGrid(&#039;getCell&#039;, rowId, &#039;post_name2&#039;);
    ...
    // this object automatically is extended with the post data
    return  { post_name1 : value_one, post_name2 : value_two,...};
}
BEFORESUBMIT;
$grid-&gt;setGridEvent(&quot;beforeSubmitCell&quot;,$beforesubmit);

$beforesubmit = <<<BEFORESUBMIT

function( rowId, name, val, iRow, iCol ) {

var value_one = $(this).jqGrid('getCell', rowId, 'post_name1');

var value_two = $(this).jqGrid('getCell', rowId, 'post_name2');

...

// this object automatically is extended with the post data

return { post_name1 : value_one, post_name2 : value_two,...};

}

BEFORESUBMIT;

$grid->setGridEvent("beforeSubmitCell",$beforesubmit);

Please let us know if the problem is solved

Kind Regards
Will

Guriddo Support Team

December 21, 2017 at 7:04 pm in reply to: setAfterCrudAction not happening #126528

guriddo.support

Participant

Sorry do not see the cell edit. With cell edit only two values are posted – the id of the row and the value of the edited cell.

If possible get all the varaibles that are posted and check them before the execution of the setAfterCud operation.

Guriddo Support Team

December 21, 2017 at 6:53 pm in reply to: setAfterCrudAction not happening #126527

guriddo.support

Participant

Hello,

As far as I see the Javascript code for posting rditing data is located maybe in the function : showQuestion

Can you please show the code of this function?

Thank you.

Kind Regards,

Will

Guriddo Support Team

December 21, 2017 at 4:07 pm in reply to: Subgrid – no data displaying #126525

guriddo.support

Participant

Hello,

I’m not sure that I understand the question. Did you mean to have a different labels in the subgrid headers instead of the names?

Please in the future post different topic when the question is different from the existing one.

Regards,

Will

Guriddo Support Team

December 21, 2017 at 3:46 pm in reply to: setAfterCrudAction not happening #126524

guriddo.support

Participant

In the script I do not see the table and the primarykeyId like this.

Please in the future when posting code switch in text mode (upper right corner of the editor) and the enclose the code with code tag like the code below:

$grid-&gt;table =&quot;orders&quot;;
$grid-&gt;setPrimaryKeyId(&quot;OrderID&quot;);

$grid->table ="orders";

$grid->setPrimaryKeyId("OrderID");

Regards,
Will

Guriddo Support Team

Author

Replies

Viewing 15 replies - 406 through 420 (of 1,092 total)

← 1 2 3 … 27 28 29 … 71 72 73 →