+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: Ignited DataTables (/showthread.php?tid=32173)
Ignited DataTables - El Forum - 10-05-2010
[eluser]nicusors[/eluser]
Great post and contributions.
I am at the point where have to build lots of reports and this looks like the best and easy way to accomplish it. Just found it today and I'm so happy. So I can't wait to see the joins development.
Thanks, nick
Ignited DataTables - El Forum - 10-05-2010
[eluser]nicusors[/eluser]
Hi ruizpi,
There is a small mistake on get_filtering. The search is not working. Here is the working updated version.
Code:
protected function get_filtering($columns, $where, $search)
{
$sWhere="";
$TieneParentesis=0;
if ($where!="")
{
$sWhere .=$where;
}
if($this->input->post("sSearch") != "")
{
if ($sWhere!="")
{
$sWhere.=" AND (";
$TieneParentesis=1;
}
for($i = 0; $i < count($columns); $i++)
$sWhere .= $columns[$i] . " LIKE '%" . $this->input->post("sSearch") . "%' OR ";
$sWhere = substr_replace($sWhere, "", -3);
if ($TieneParentesis==1)
$sWhere.=")";
}
if ($sWhere <>"")
$sWhere = "WHERE " . $sWhere;
return $sWhere;
}Ignited DataTables - El Forum - 10-05-2010
[eluser]ruizpi[/eluser]
hi nicusors,
I try to test your modification but when i use a group by select it doesn't work. Test it.
Ignited DataTables - El Forum - 10-05-2010
[eluser]ruizpi[/eluser]
At this point my code that i share with you works fine with querys. I try to filter for 1 column like some examples that create some boxes at the bottom of the table. It doesn't work with server side processing like my code do. Can anybody help me?
Ignited DataTables - El Forum - 10-12-2010
[eluser]cryogenix[/eluser]
hey guys, i updated the first post and added an initial draft for the "library" version... i haven't tested it out yet so i was hoping some kind soul can do the testing for me
i haven't added joins on this one yet as im still pretty much preoccupied... i did add a zip download too if you want...do send me feedbacks on this...
cheers
Ignited DataTables - El Forum - 10-22-2010
[eluser]Clooner[/eluser]
I used your code and with a regular request the json file seems fine however when using a post request the following error is generated
Code:
An Error Was Encountered.
The action you have requested is not allowed.It's my bedtime now. I'll dive into this tomorrow or maybe someone has a solution for me when I wake up
Ignited DataTables - El Forum - 10-23-2010
[eluser]cryogenix[/eluser]
that's a CI2 problem right? perhaps you could find your answer here: http://ellislab.com/forums/viewthread/163976/#786244
Ignited DataTables - El Forum - 10-23-2010
[eluser]Clooner[/eluser]
[quote author="cryogenix" date="1287845929"]that's a CI2 problem right? perhaps you could find your answer here: http://ellislab.com/forums/viewthread/163976/#786244[/quote]
Thanks that was the problem...
Is there anything already that takes care of queries with joins?
Ignited DataTables - El Forum - 10-23-2010
[eluser]Clooner[/eluser]
[quote author="Jeroen Schaftenaar" date="1287864864"][quote author="cryogenix" date="1287845929"]that's a CI2 problem right? perhaps you could find your answer here: http://ellislab.com/forums/viewthread/163976/#786244[/quote]
Thanks that was the problem...
Is there anything already that takes care of queries with joins?[/quote]
I found the joins version already on
http://ellislab.com/forums/viewthread/164729/
Ignited DataTables - El Forum - 11-03-2010
[eluser]Dermis[/eluser]
great works cryogenix,
i've tried your solution integrating CI with Datatables using server side processing. however i cant display pagination. It seems like your datatables library produce table with some bugs with your css.
Im using two_button pagination, but NEXT and PREVIOUS button didnot appear. I've imported css file correctly.
Any idea for me to debug this?