+- 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: Flexigrid CodeIgniter Implementation (/showthread.php?tid=11362)
Flexigrid CodeIgniter Implementation - El Forum - 07-07-2010
[eluser]HomersBrain[/eluser]
I've known the grid not to show when the link in the header has been to a dodgy jquery file, or there has been more than one. (when I say dodgy, I meant a file on my computer but for some reason it wasn't working).
Replace your jquery src in your header with
Code:
script src="http://cdn.jquerytools.org/1.1.2/full/jquery.tools.min.js"and see what happens.
Flexigrid CodeIgniter Implementation - El Forum - 07-07-2010
[eluser]danmontgomery[/eluser]
javascript might keep the grid from loading, but not the page. If nothing is loading, it's a PHP error.
Regardless, including jquery tools to get jquery is kind of silly, i would still use a more recent version of jquery... 1.4.1 or 1.4.2:
Code:
google.load("jquery", "1.4.2");Flexigrid CodeIgniter Implementation - El Forum - 07-07-2010
[eluser]HomersBrain[/eluser]
[quote author="noctrum" date="1278544242"]
Regardless, including jquery tools to get jquery is kind of silly, i would still use a more recent version of jquery... 1.4.1 or 1.4.2:
[/quote]
My bad. I cut and paste the wrong thing! I am using jquery tools in the project I'm working on. :red:
Flexigrid CodeIgniter Implementation - El Forum - 07-10-2010
[eluser]anthrotech[/eluser]
Okay, so it seems like it is in the PHP Json layer. I will try the non-JSON approach.
Flexigrid CodeIgniter Implementation - El Forum - 07-18-2010
[eluser]anthrotech[/eluser]
Still not working. At this point, I will pay someone to get this working with the technologies I've listed before. Please send me a private message if you can get this working in the next week. I will give you access to my SVN repository. Get it working and you'll get paid. Must work with all the technologies I listed, no exceptions. No excuses. Thanks in advance.
Flexigrid CodeIgniter Implementation - El Forum - 07-26-2010
[eluser]pendalpusher[/eluser]
hi all .. just got this working and i must say .. FANTASIC work.
my only issue, which i think might be a flexigrid issue is that columns will not expand or contract in IE 7..any suggestions??
Thanks,
C
Flexigrid CodeIgniter Implementation - El Forum - 07-28-2010
[eluser]pendalpusher[/eluser]
I was having some difficulty when doing complex querys. I also had problems with pagination because we are using postgres and not mysql. so the LIMIT 0,10 was not working properly. (I need to use LIMIT 10 OFFSET 0)
I just wanted to add to the list here and document what I changed in case anyone else runs across the same issues.
basically I am using the build_querys function in flexigrid.php library file.
I added this code around line 195
Code:
public function build_querys_complicated($querys)
{
$return['main_query'] = $querys['main_query'].' ORDER BY '.$this->post_info['sortname'].' '.$this->post_info['sortorder'].' LIMIT '.$this->post_info['rp'].' OFFSET '.$this->post_info['limitstart'];
$return['count_query'] = $querys['count_query'];
return $return;
}then in my ajax_model.php file I have querys that look something like this.
Code:
$sql = "SELECT * FROM quote_log WHERE
active = '1'
AND
(customer LIKE '%".$string."%'
OR quote_title LIKE '%".$string."%'
OR estimator LIKE '%".$string."%'
OR salesman LIKE '%".$string."%')";
$querys['main_query'] = $sql;
//then to cheat a bit I am just swapping the * with count(id) to get the row counts.
$querys['count_query'] = str_replace("*","count(id)",$sql);
$build_querys = $this->CI->flexigrid->build_querys_complicated($querys);
$return['records'] = $this->db->query($build_querys['main_query']);
$record_count = $this->db->query($build_querys['count_query']);
//etc..etc...etc..Anyway .. hope this helps someone someday.
These mods allowed me to run more complex querys and still maintain sorting and pagination.
Cheers,
C
Flexigrid CodeIgniter Implementation - El Forum - 09-22-2010
[eluser]anthrotech[/eluser]
And Suggestions for including Add and Edit Rows? I've been reviewing possible solutions via Flexigrid support forum and via Google, but nothing solid. Would be great to be able to add rows by clicking on the empty space at the end of the rows or click rows to edit values. Anyone done this? Seems like Flexigrid with Codeignitor at this time is more like RD rather than CRUD.
Flexigrid CodeIgniter Implementation - El Forum - 11-06-2010
[eluser]inp[/eluser]
I was include CRUD on CI-Flexigrid v0.36, but how i can share this source.., any body can help me??
i was added Edit and Add New item feature..
Flexigrid CodeIgniter Implementation - El Forum - 11-07-2010
[eluser]jasonjack[/eluser]
hey i got a good help form all of u wish i ll get more help in my problems