jqGrid and CI

[eluser]dobbler[/eluser]
Hi, Has anyone had any luck integrating jqGrid (http://www.trirand.com/blog/) with CI? I've been mucking about with it but can't get it going, would love some CI examples if anyone has managed it or is willing to try..

It looks great..

Cheers,

Rob.

[eluser]Unknown[/eluser]
Now I am in progressing to do JqGrid integration with CI, for the grid view it already done but still have problem with custom form integration because it's build-in form have limit ability to handle post new/edit data. Still can't post example for use it, maybe later.

[eluser]emsurban[/eluser]
are you able to integrate jqgrid with CI?

[eluser]jkarlen[/eluser]
Has anyone had any luck with this?

[eluser]mrcf[/eluser]
Well, I got the simple demo working within CI by:

1) Change the calling URL from example.php to index.php/xxxController/search

2) Change the calling type to POST

3) Adding search in the xxxController that calls the Xxx model

4) Have the model echo out the XML.

Good luck...

Now to figure out passing the query type....

[eluser]pmoroom[/eluser]
[quote author="mrcf" date="1249776388"]Well, I got the simple demo working within CI by:

1) Change the calling URL from example.php to index.php/xxxController/search

2) Change the calling type to POST

3) Adding search in the xxxController that calls the Xxx model

4) Have the model echo out the XML.

Good luck...

Now to figure out passing the query type....[/quote]

I'm getting there as well. I have it working to pull data and populate the grid. I have the double click functions all set up, sort works, and now i'm working on the search. The search is giving me some trouble. I can see it in firebug posting the data but I can't seem to grab the variable values.....it comes up blank. If I hard code a value it searches so I'm close.

Regards,
P

[eluser]mrcf[/eluser]
I'm trying to get advanced search to just show up on the page....

Have you tried using the $var = $_POST['_search']; // returns true of false.

if that comes up true I think the actual variable depends on the implementation.
M

[eluser]Zorancho[/eluser]
Try this one: http://www.flexigrid.info/
It's very much adjustable

[eluser]pmoroom[/eluser]
I spent so much time customizing and getting these grids to work how I want I ended up going back to just creating my own table and handling it that way. Sometimes the "old" school methods are still the best.

[eluser]internut[/eluser]
Anyone having any luck with searching? I'm struggling even getting the search like the URL below:

http://www.trirand.com/jqgridwiki/doku.p..._searching

to populate the search fields above the fields.

I have the grid populated via XML, sorting working, paging, I really really need to get searching working.

I'm just struggling big time.

My jqgrid code is as follows:

Code:

jQuery("#customers").jqGrid({

  url:'http://localhost/project/company/index.php?/admin/customers/customer_data',
  datatype: 'xml',
  mtype: 'POST',
  colNames:['ID #','First Name', 'Last Name','e-Mail Address','Manage'],
  colModel :[
    {name:'customer_id', index:'customer_id', width:15, align:'center'},
    {name:'firstname', index:'firstname', width:55, align:'left'},
    {name:'lastname', index:'lastname', width:60, align:'left'},
    {name:'email', index:'email', width:110, align:'left'},
    {name:'edit', index:'edit', width:20, align:'center'} ],
  pager: jQuery('#pg'),
  rowNum:15,
  height:225,
  width:780,
  scrollOffset:0,
  rowList:[1,5,10,15],
  sortname: 'customer_id',
  sortorder: 'asc',
  viewrecords: true,
  caption: 'Cartridge Depot Customer List'


  });

Code for table:

Code:

<table id="customers"></table>
      <div id="pg"></div>

Granted tons great documentation on the jqGrid site but I'm just struggling as I'm very new to this. Was excited to get the Grid pulling data, sorting, paging, # of rows per page working quickly. Now I'm finding myself stumped

Any help / guidence mucho appreciated.