Guriddo » guriddo.support's Replies

guriddo.support

Guriddo

Forum Replies Created

Viewing 15 replies - 31 through 45 (of 1,092 total)

← 1 2 3 4 … 71 72 73 →

Author

Replies

February 14, 2023 at 10:59 am in reply to: Cloning Pager to Top Loses Number of Pages #128104

guriddo.support

Participant

Hello,

We have send you e-mail.

Kind Regards,

Will

Guriddo Support Team

February 13, 2023 at 11:35 am in reply to: Cloning Pager to Top Loses Number of Pages #128101

guriddo.support

Participant

Hello Ken,

Thank you very much to point us of this problem.

We have found it and fixed it. It will be available in the next release.

If this is a showstopper, please let us know we will send you the fix.

Kind Regards,

Will

Guriddo Support Team

February 6, 2023 at 10:36 am in reply to: Add row to different table after insert #128098

guriddo.support

Participant

Hello,

Yes, there is a way to get the last inserted id, but only when the insert is done.

At the moment to do what you want some trick should be applied.

One possible way is to disable automatic add and at certain point of the code and perform some other operations

$grid->setTable('main_table');
// set the primary(uniquie) key
$grid->setPrimaryKeyId('OrderID');
if($grid->oper == 'add') {
    // obtain the data posted from the client
   $data = filter_input_array(INPUT_POST);
    // try to insert the data in the table
   if( $grid->insert($data) ) {
       $LastInsert = $grid->getLastInsertId();
        if($LastInsert) {
             $grid->setTable('child_table');
             $grid->setPrimaryKeyId('OtherKey');
             $grid->serialKey = false;
             $grid->insert(  array( "OtherKey"=>$LastInsert, .....) );
        }
   }
}
$grid->add = false;

$grid->setTable('main_table');

// set the primary(uniquie) key

$grid->setPrimaryKeyId('OrderID');

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

// obtain the data posted from the client

$data = filter_input_array(INPUT_POST);

// try to insert the data in the table

if( $grid->insert($data) ) {

$LastInsert = $grid->getLastInsertId();

if($LastInsert) {

$grid->setTable('child_table');

$grid->setPrimaryKeyId('OtherKey');

$grid->serialKey = false;

$grid->insert( array( "OtherKey"=>$LastInsert, .....) );

}

$grid->add = false;

Note setTable before if and $grid->add = false after the if.

You can do a lot variations using this approach.

In the upcoming release we will add a special word in which the last inserted id can be used in setAfterCrud (thank you for point us to add this feature)

Kind Regards

Will

Guriddo Support Team

February 3, 2023 at 1:42 pm in reply to: Grid Update Uses rowID instead of Primary Key #128097

guriddo.support

Participant

Hello,

To overcome such problems you can set PDO to use lower case or upper case.

By example if you do :

// Connection to the server
$conn = new PDO(DB_DSN."tinicum",DB_USER,DB_PASSWORD);
// Set the case in which to return column_names.
$conn->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);

// Connection to the server

$conn = new PDO(DB_DSN."tinicum",DB_USER,DB_PASSWORD);

// Set the case in which to return column_names.

$conn->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);

then no mater how you write your column names, but this depend on the needs and should be used with care.

Kind Regards,

Will

Guriddo Support Team

January 30, 2023 at 11:29 am in reply to: FilterInput – v5.8.0 Bug. #128086

guriddo.support

Participant

Hello,

It is not a bug. We just fix some not wanted behavior of the search property in colModel for this method

To continue use the search on all fields set searchAll option to true in the method.

... $("#jqGrid").jqGrid('filterInput', self.value, {searchAll: true}); ...

1	... $("#jqGrid").jqGrid('filterInput', self.value, {searchAll: true}); ...

We have fixed our code in the demo too.

We understand that this will maybe break other users and have revert the change back. This will be available in the upcoming 5.8.2 release.

Kind Regards,
Will

Guriddo Support Team

January 30, 2023 at 11:27 am in reply to: Grid Update Uses rowID instead of Primary Key #128085

guriddo.support

Participant

Hello,

It seems to me that you have a typo: In the select command you have

$grid2->SelectCommand = "
    select lo.LandownerID,
           lo.LandOwner,
           lo.LandOwnerNotes,
           ls.Status,
           case
               when lm.LastName = 'UNASSIGNED' then 'UNASSIGNED'
               else concat(lm.FirstName, ' ', lm.LastName)
           end CurrentlyAssignedTo,
           lo.LandOwnerAddress1,
           lo.LandOwnerAddress2,
           lo.LandOwnerCity,
           lo.LandOwnerState,
           lo.LandOwnerZip,
           lo.HowToContact,
           lo.MailingSalutation,
           lo.AddressedTo
    from tblLandOwners lo,
         tblLpcMembers lm,
         tblLandOwnerStatus ls
    where lo.CurrentlyAssignedTo = lm.LpcMemberID and
          lo.Status = ls.StatusID";
 
// Set output format to json

$grid2->SelectCommand = "

select lo.LandownerID,

lo.LandOwner,

lo.LandOwnerNotes,

ls.Status,

case

when lm.LastName = 'UNASSIGNED' then 'UNASSIGNED'

else concat(lm.FirstName, ' ', lm.LastName)

end CurrentlyAssignedTo,

lo.LandOwnerAddress1,

lo.LandOwnerAddress2,

lo.LandOwnerCity,

lo.LandOwnerState,

lo.LandOwnerZip,

lo.HowToContact,

lo.MailingSalutation,

lo.AddressedTo

from tblLandOwners lo,

tblLpcMembers lm,

tblLandOwnerStatus ls

where lo.CurrentlyAssignedTo = lm.LpcMemberID and

lo.Status = ls.StatusID";

// Set output format to json

but in the set primary Key you do

...
$grid2->setPrimaryKeyID('LandOwnerID');
..

...

$grid2->setPrimaryKeyID('LandOwnerID');

Try to set it like this:

..
$grid2->setPrimaryKeyID('LandownerID');
...

$grid2->setPrimaryKeyID('LandownerID');

...

Edit: Just in case you can force the primary key in script using the key=>true feature in colMode

...
$grid2->setColProperty("LandownerID", array("key"=>true,  "editable"=>false,"hidden"=>false));
...

...

$grid2->setColProperty("LandownerID", array("key"=>true, "editable"=>false,"hidden"=>false));

...

Kind Regards,

Will

This reply was modified 2 years, 9 months ago by guriddo.support. Reason: adding key=>true as option solution

Guriddo Support Team

December 16, 2022 at 9:55 am in reply to: disable some rows and checkall #128065

guriddo.support

Participant

Hello,

Everthing what you do is correct except that you use Bootstrap CSS Framework.

As per definition of this CSS the disabled class is named ui-diabled see the CSS object class in jqGrid definition, while the ui-state-disabled is for jQuery UI CSS. To have cross working booth class is recommended to be set

You code work if you do:

rowattr: function (rd) {
if (rd.Errori>0) {
return {
"class": "ui-disabled ui-state-disabled ui-jqgrid-disablePointerEvents"
};
}
},

rowattr: function (rd) {

if (rd.Errori>0) {

return {

"class": "ui-disabled ui-state-disabled ui-jqgrid-disablePointerEvents"

};

}

Kind Regards,

Will

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

Guriddo Support Team

November 10, 2022 at 1:24 pm in reply to: Combo grid #128061

guriddo.support

Participant

Hello Kris,

We apologize for the late answer.

We where able to create a experimental function comboGrid (all changes are in github) in which we implement some of your requested features.

Here is the demo – the combo grid is bound to ShipName edit field and for the demo purpose it returns the country name.

The function has 3 parameters – the input element; options which contain data parameter (can be a string or array) and return field – a field which should be returned when the user press enter or select with a click; the third parameter is a grid object parameter with colModel and etc.

There are some small problems, but I hope this will help you and other to use the grid as combo.

Please let us know if you have any recommendations, improvements or anything what you think it will be helpfully.

Kind Regards,

WIll

P.S. All the changes are in GitHub.

Guriddo Support Team

October 25, 2022 at 9:34 am in reply to: Combo grid #128058

guriddo.support

Participant

Hello Kris,

Thank you for the recommendation. We will see what we can do within this week.

There is already similar solution here

Having this code we can maybe reconstruct the it to be used as combo grid like in the demo shown from you.

Thank you very much again.

Kind Regards

Will

Guriddo Support Team

October 12, 2022 at 10:30 am in reply to: Set rowHeight with wrap #128056

guriddo.support

Participant

Hello,

I have simulated some long text in order to show you the solution.

Here is the demo code

Kind Regards,

Will

Guriddo Support Team

October 11, 2022 at 4:26 pm in reply to: Set rowHeight with wrap #128044

guriddo.support

Participant

Hello,

The solution you requested require to add html content to your data.

This is tested and works as per your requirement:

Add the following style definition:

<style>
.ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td { 
    white-space: normal !important;
    height: auto;
}
.mylongdata {
    height:90px;
    overflow-y:auto;
}
</style>

<style>

.ui-jqgrid .ui-jqgrid-btable tbody tr.jqgrow td {

white-space: normal !important;

height: auto;

}

.mylongdata {

height:90px;

overflow-y:auto;

}

</style>

after the jqgrid css.

Your long data when comes from the server or local array enclose in div tag with class mylongdata

so it look like:

<div class='mylongdata'>...your data here ...</div>

1	<div class='mylongdata'>...your data here ...</div>

You can adjust your height in mylongdata depending on your needs.

or simple use cell formatter to analyse its length and enclose it in that div with the class

If you have difficulties with using cell formatter, please let us know.

Kind Regards,

Will

Guriddo Support Team

October 4, 2022 at 10:57 am in reply to: Grid nav buttons #128042

guriddo.support

Participant

Hello Kris,

I think that the simplest way is to create your own function with parameters – the grid id and pager id and the conditionally add the needed buttons.

Something like this:

function myButtons( grid, pager, myparams) {
    if(myparams.excel) {
        // here navButtonAdd
        $(grid).jqGrid('navButtonAdd', pager, {/*here code to add excel*/}
    }
    if(myparams.pdf) {
        // similar code here
    }
    ....
}

function myButtons( grid, pager, myparams) {

if(myparams.excel) {

// here navButtonAdd

$(grid).jqGrid('navButtonAdd', pager, {/*here code to add excel*/}

}

if(myparams.pdf) {

// similar code here

}

....

}

and then call this function after the navigator

If you have maybe better idea, please let us know.

Kind Regards,

Will

Guriddo Support Team

October 4, 2022 at 10:47 am in reply to: PHP Suite v5.5.5 – Bootstrap Grid Defaults #128041

guriddo.support

Participant

Hello,

From what I understand you missed a grid parameter called autowidth – this parameter initially set the grid width to its parent.

Unfortunately we do not have a similar parameter for the height (we will try to create this in next release) which means that we need to write small code to fith the grid height to its parent. In the example provided we use onInitGrid event and setGridHeight method with second parameter set to true.

To have toppager only this is a little tricky – set toppager in grid parameter to true, disable creation of grid pager – the last param in renderGrid and then use cloneToTop set to true in navigator.

The whole example is here

If something is not clear, please do not hesitate to ask us.

Kind Regards,

Will

Guriddo Support Team

October 3, 2022 at 10:53 am in reply to: PHP Suite v5.5.5 – Bootstrap Grid Defaults #128037

guriddo.support

Participant

Hello,

In order to help you we need your code and html page where the grid renders.With other words – if you send us a demo demonstrating the problem, that would solve the problem in 80%.

Thank you

Kind Regards,

Will

Guriddo Support Team

September 15, 2022 at 10:24 pm in reply to: Inline edit focus event #128022

guriddo.support

Participant

Hello,

You can use dataEvents property in colModel editoptions. Here is possible to add any event supported by element.

For more information see here editoptions properties

If you have dificulties, please let us know.

Guriddo Support Team

Author

Replies

Viewing 15 replies - 31 through 45 (of 1,092 total)

← 1 2 3 4 … 71 72 73 →