Hello,
As far as I remember our discussion was here.
In my post I note that we do not understand ZF1, but give you advice’s how to pass ZF1 connection to the jqGrid.
Now I will write it for second time:
1. To the grid we passed connection object.
2. If your adapter stores a PDO connection somewhere then you can easy pass it.
By example if you have:
|
1 2 3 4 5 6 7 8 |
... $dbAdapter = Zend_Db::factory($config->db->adapter, $dbOptions); Zend_Db_Table::setDefaultAdapter($dbAdapter); Zend_Registry::set('dbAdapter', $dbAdapter); $adapter = Zend_Registry::get('dbAdapter'); ... |
and your adapter stores the connection object to
$adapter->Connection , then you will need to pass this to the grid and not the adapter.
|
1 2 3 |
... $grid = new jqGridRender($adapter->Connection); ... |
Simple the reletion is this:
|
1 2 3 4 5 |
... $adapter->Connection = $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD); ... |
Of course in ZF1 this should have another name and this is just example.
What you need to know is where the ZF1 stores this object in its adapter.
Hope it is now clear
Kind Regards,
Will
Guriddo Support Team
Hello,
First of all sorry for the not updated documentation.
If you look carefully on the files you will see a file named Autoloader.php, which actaully is autoloader class.
If you load jqGrid.php all the needed files are loaded.
You will need to load additionally the db driver since the class does not know which database you want to use.
The config.php file is just a file which contain some database information.
We plan in the future to load one file only and set the database type, where the class will load it automatically.
Kind Regards,
Will
Guriddo Support Team
Hello,
Unfortunately we do not support such functionality.
After saving the cell (enter key) the user can press arrow down key to go to cell below and then press enter to edit it.
It is possible to mimik some fature after the cell is saved, but I’m not sure that this is exactly what you need.
Here is the code:
|
1 2 3 4 5 6 7 8 9 10 11 |
$("#grid").jqGrid({ ..., afterSaveCell : function(rowid, name, value, iRow, iCol){ setTimeout(function(){ e = $.Event('keydown'); e.keyCode= 40; var grid = $("#grid")[0]; $('#'+grid.p.knv).trigger(e); }, 10); }, ... |
With this code after the cell is modified and the user press enter the cursor is positioned on the cell bellow.
Kind Regards
Will
Guriddo Support Team
Hello,
Do you use jqGrid or use another grid?
If you use jqGrid you can use the methods as described into the example here
Kind Regards.
Will
Guriddo Support Team
Hello,
It is very difficult to say where the problem is.
This can be white space or maybe variable which is used into the script , but you have not publish it.
Please post you full PHP jqGrid code with includes variables and etc, so that we can see what is happen.
If it is not possible to publish it here, please send it to the support.
Kind Regards,
Will
Guriddo Support Team
Hello again,
It is a good idea to use the following definition to include all fields:
|
1 2 3 4 |
$grid->setColProperty('mycolumn', array("stype"=>"select", "searchoptions"=>array("clearSearch"=>false, "value"=>":All;1:1;0:0"))); $grid->toolbarfilter = true; |
Regards
Will
Guriddo Support Team
Hello,
As per MySQL documentation boolen type is defined as tinyint – ie:
These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true:
We have defined such values and used your definition. The search works perfectly.
If you need a demo we can prepare such one.
I recommend you to set the debug to true and look at the log file when you search this field what is happen.
Kind Regards,
Will
Guriddo Support Team
Hello,
It depend from where you download the version.
Since I do not point you from where to get the updated version it seems you get it from the download section of the site – this version does not contain the update.
You will need to obtain the updated version from GitHub.
Please use the following link to download the updated version and let us know if the updated version is working as per your requirement.
Kind Regards,
Will
Guriddo Support Team
Hello,
What you mean with format search field?
You can use the PHP setDatepicker function to use it in serch field formatting.
Please look at our demos:
Kind Regards,
Will
Guriddo Support Team
Hello,
Did you set the datearray, user abd database date something like:
|
1 2 3 4 5 6 7 |
$grid->setUserDate('d.m.Y H:i'); $grid->setUserTime('d.m.Y H:i'); $grid->setDbDate('U'); $grid->setDbTime('U'); $grid->datearray= array( "tdUnixtimestamp" ); |
Kind Regards
Will
Guriddo Support Team
Hello,
Thanks. We need to look if this was mistake into the docs or we forgot to set it to true we we do some changes in treegrid file
Kind Regards,
Will
Guriddo Support Team
Hello,
We have added option saveData in saveState function. If set to false the data will not be saved (a empty string is saved). To use it do:
|
1 2 3 |
... $.jgrid.saveState("jqGrid", {saveData : false }); ... |
If you have a data, but do not want to load it use restoreData : false in loadSate function
|
1 2 3 |
... $.jgrid.loadState("jqGrid",null,{restoreData: false}); ... |
This will not load the data instead that it may be saved.
Guriddo Support Team
Hello,
Can you please set for us a small example with data of course demonstrating what you want to achieve – i.e what you expect and what is happen?
Thank you
Kind Regards,
Will
Guriddo Support Team
Hello,
We hope to finish this end of March. Until this, please ask us questions if something is not clear.
Kind Regards,
Will
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top