Home › Forums › Guriddo jqGrid JS › Help › TableToGrid options available?
Hi!
I've generated a HTML table with PHP. Now I've figured out I can use TableToGrid.
});
Now a plain table is generated, but I would like to use the search function, the pagination, etc..
Is that still possible and if so, how can I do it?
Thanks!
Hello,
If you look into the docs you will see that to this function you can pass second parameter – this parameter can contain all the available options of the grid – i.e
$(document).ready(function(){
tableToGrid(”#table”, {width:500, pager:”#mypager”, caption:”Mycaption”});
});
Hope this help
Regards
Tony
Tony,
Can you also control how columns are sorted?
Hello,
After you create the grid with tableToGrid function use setColProp to define the sorttypes of the coulmns.
There is no automatic determination of the content of the columns.
Best Regards
Tony
Can you provide an example.
Hello,
After calling the tableToGrid do something like this:
$(”#” + myid).jqGrid('setColProp','mycoulmname',{sorttype:'int'});
// can be numeric, date and etc. see docs
Best Regards
Tony
Is the column name the same as the column header (
) element?Hello,
The name of the column is constructed as:
If the th element has id the name becomes the id, if this is not true the name is the html content of the th element.
You can see what names you have simple using getGridParam with colModel and print the names.
Best Regards
Tony
Thanks!
Hello,
Look at datefmt option in the docs
Regards
Tony
Thanks for the help.
I have tried setting the date to a normal date value like '1/9/2010' and I still get the “undefined” error message.
Hello,
The date format is a PHP like
try this
$(”#” + myid).jqGrid('setColProp', 'Created', { sorttype: 'date', datefmt: 'm/d/Y' });
Regards
Tony
Still getting the same error message (undefined).
Hello,
Could you please post or send me the code – the table data and the way you cal
Here is how I call the function (each table has the “grid_table” classname)
$(document).ready(
function(){
$(
“.grid_table”).each(function()
{
var myid = this.id;
var mycaption = getGridCaption(myid);
tableToGrid(
“#” + myid, { height: “auto”, caption: mycaption });
$(
“#” + myid).jqGrid('setColProp', 'Created', { sortable: false });
$(
“#” + myid).jqGrid('setColProp', 'Function Date', { sortable: false });
$(
“#” + myid).jqGrid('setColProp', 'Cost', { sorttype: 'currency' });
//$(“#” + myid).jqGrid('setColProp', 'Created', { datefmt: 'm/d/Y', sorttype: “date” });
//$(“#” + myid).jqGrid('setColProp', 'Created', { sorttype: 'date'});
});
});
Here is some of the table data (Raw):
1 2 3 4 5 6 7 |
<div class="sfcode"><pre id="line176"><h2>Â <u>Open Non Stock Requisitions</u></h2><table border="'0'" cellpadding="'2'" width="'100%'" cellspacing="'3'"><br /> <tr><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">ereq</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Creator</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Requestor</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Cost</span></td><br /> </tr></table> |
1 2 3 4 5 6 7 8 9 10 11 |
<td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Created</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Status</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Vendor</span></td><br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Justin Mobley</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Justin Mobley</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$4,074.00</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">1/22/2010 1:30:07 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Submitted</font></td><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'">US Appliance</font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$8.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">1/7/2010 1:04:18 PM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> </form></tr><br /> |
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$8.00</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">1/7/2010 1:02:35 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> </form></tr><br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$8.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">1/7/2010 11:25:23 AM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$82.00</font></td><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'">1/7/2010 11:22:39 AM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$8.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">1/7/2010 11:20:53 AM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.01</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">12/10/2009 1:36:27 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> </form></tr><br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">renee coffan</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">12/9/2009 3:03:49 PM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.01</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">12/9/2009 11:55:25 AM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$0.01</font></td><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'">12/9/2009 9:46:10 AM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">renee coffan</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">12/8/2009 2:33:56 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">renee coffan</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">12/8/2009 2:29:35 PM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> </form></tr><br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Renee Coffman</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">9/2/2009 11:30:45 AM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Renee Coffman</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$3,500.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">8/5/2009 9:51:15 AM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Renee Coffman</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> </form></tr> |
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'">7/28/2009 4:35:10 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">David Higginson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">dfg dfg</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">5/4/2009 12:50:57 PM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> </form></tr> |
1 2 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> |
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top