+- 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 - 05-23-2011
[eluser]johnwbaxter[/eluser]
Hey Yusuf, that's real nice. I was thinking about this over the weekend and that is exactly how i would have implemented it. I think this functionality is required. It needs to be as flexible as possible.
Great work!
Ignited DataTables - El Forum - 05-23-2011
[eluser]ηυмвєяσηє[/eluser]
thanks,
v0.4.1beta
changes:
*added method 'edit_column',
*added support for callback functions in replacements (usable in both add_column and edit_column)
Code:
function list_all()
{
$this->datatables
->select('id, name, email, age')
->from('tbl_profile')
->using('id')
->join('tbl_local', 'country', 'tbl_profile.local_id = tbl_local.id')
->join('tbl_states', 'state', 'tbl_profile.state_id = tbl_states.id')
->add_column('edit', '<a href="' . base_url() . 'admin/profiles/edit/$1">Edit</a>', 'tbl_profile.id')
->add_column('delete', '<a href="' . base_url() . 'admin/profiles/delete/$1">Del</a>', 'tbl_profile.id')
->edit_column('tbl_profile.name' , '<a href="' . base_url() . 'admin/profiles/edit/$1">$2</a>', 'tbl_profile.id, tbl_profile.name') /// (make links)
->edit_column('tbl_profile.email' , '$1***@***', 'callback_substr(tbl_profile.email|0|4)'); // (show only the first 4 chars of emails)
$data['result'] = $this->datatables->generate();
$this->load->view('ajax', $data);
}Regards,
Yusuf
Ignited DataTables - El Forum - 05-24-2011
[eluser]johnwbaxter[/eluser]
Okay, great, i'll give this a go today. Nice work.
Ignited DataTables - El Forum - 05-25-2011
[eluser]ηυмвєяσηє[/eluser]
hello guys again.
I know it is out of topic,One of my friends asked and I've made a native php version of the library. http://bit.ly/j4zyMP
Someone else can find it useful
usage: (create a file that you are gonna call: ajax.php)
Code:
<?php
require_once('Datatables.php');
$datatables = new Datatables;
$config = array(
'user' => 'root',
'password' => '',
'db' => '',
'server' => 'localhost' );
$datatables->select('id, username, email, activated')
->from('users')
->using('id');
echo $datatables->generate($config);
?>Usage is very similar. Again it is for native php.
Regards.
Ignited DataTables - El Forum - 05-29-2011
[eluser]ηυмвєяσηє[/eluser]
latest usages in v.0.4.3 beta:
simple usage :
Code:
function list_all()
{
$this->datatables
->select('id, name as username, email, age')
->from('tbl_profile');
$data['result'] = $this->datatables->generate();
$this->load->view('ajax', $data);
}usage with joins:
Code:
function list_all()
{
$this->datatables
->select('id, name as username, email, age')
->from('tbl_profile')
->join('tbl_local', 'tbl_profile.local_id = tbl_local.id', 'left')
->select('country');
$data['result'] = $this->datatables->generate();
$this->load->view('ajax', $data);
}sample contains all the features:
Code:
function list_all()
{
$this->datatables
->select('id, name as username, email, age')
->from('tbl_profile')
->join('tbl_local', 'tbl_profile.local_id = tbl_local.id')
->select('country')
->join('tbl_states', 'tbl_profile.state_id = tbl_states.id')
->select('state')
->add_column('edit', '<a href="' . base_url() . 'admin/profiles/edit/$1">Edit</a>', 'id')
->add_column('delete', '<a href="' . base_url() . 'admin/profiles/delete/$1">Del</a>', 'id')
->edit_column('username' , '<a href="' . base_url() . 'admin/profiles/edit/$1">$2</a>', 'id, username')
->edit_column('email' , '$1***@***', 'callback_substr(email|0|4)');
$data['result'] = $this->datatables->generate();
$this->load->view('ajax', $data);
}edit : removed links, v0.5 will be released soon..
Regards,
Yusuf
Ignited DataTables - El Forum - 05-30-2011
[eluser]cryogenix[/eluser]
pushed the new codes to git already. wiki is being updated.
meanwhile, refer to yusuf's post #154 for usage guides...
Ignited DataTables - El Forum - 06-02-2011
[eluser]johnwbaxter[/eluser]
Hey Yusuf, sorry about the delay in testing this bu i had a project come up that i had to run off to!
How would you go about handling this?
Code:
->edit_column('timestamp', '$1', "callback_date(d-m-Y H:i|)");The second parameter needs to be the timestamp itself.
Ignited DataTables - El Forum - 06-02-2011
[eluser]ηυмвєяσηє[/eluser]
Code:
->edit_column('timestamp', '$1', "callback_date(d-m-Y H:i|timestamp)");thats it ^^
Ignited DataTables - El Forum - 06-03-2011
[eluser]johnwbaxter[/eluser]
That doesn't seem to work for me, it just gives me 01-01-1970 01:00 for all the dates. I had tried that but it didn't work out which was why i thought i must be missing something!
Ignited DataTables - El Forum - 06-03-2011
[eluser]ηυмвєяσηє[/eluser]
depending on http://php.net/manual/en/function.date.php, date function needs second parameter to be integer.
it should be in this format : callback_date(M-d-Y H:i
|1305927001)so this may work..
Code:
$this->load->helper('date');
..
..
->edit_column('timestamp', '$1', "callback_mysql_to_unix(timestamp)")
->edit_column('timestamp', '$1', "callback_date(d-m-Y H:i|timestamp)")btw, i've updated git.