Thread

Hi,

$this->load->helper("Datatables"); // create datatables_helper.php in helpers folder
$this->load->library("Datatables");
..
..
->edit_column('jobstatus', "".base_url().", 'callback_getjobstatus(jobstatus)' )
->edit_column('level', "".base_url().", 'callback_getjoblevel(level)');

// add these functions to datatables_helper.php

function getjobstatus ($jobstatus) {
 if($jobstatus == "T")
   return "icons/accept.png";
 elseif($jobstatus == "A")
   return "ico_stop_16.png";
 else
   return "ico_inactive_16.png";
}

function getjoblevel ($level) {
      return ($level == "I")? "incBackup.png" : "fullBackup.png";
}

(strongly advised to do this in javascript, if you can)

About ‘GROUP BY’, I thought this before, However It is better to use the code below for some reasons.

you should use ‘GROUP BY’ in subqueries.

For Example :

$this->load->library("Datatables");

$this->datatables
 ->select('pages.id as pageid, title')
 ->from('(SELECT id,title,user_id FROM pages GROUP BY user_id) as pages')
 ->join('users', 'users.id = pages.user_id', 'left' )
 ->select('username');

echo $this->datatables->generate();

its not a very good example but i think u got the idea ^^

Regards,
Yusuf

How to override the Query string parameter in editable datagrid ?The default query string is generated by the datagrid(i.e adding an id parameter which has the value of the first column cell of the datatable).When i click on the specific row,and click on the delete button,the delete url is called as given in the code.This url is initialized in the code.What i want to ask is ,how do i override the url at runtime(i.e adding my row data specific query string in the url) ????

This is the code i am using…
————————————————————————————————————

$(document).ready( function () {
oTable=$('#example').dataTable({
"bProcessing": true,
"sAjaxSource": "http://localhost/questions/Test/listener",
"fnInitComplete": function (){
$(oTable.fnGetNodes()).click(function (){
var aPos = oTable.fnGetPosition( this );
var aData = oTable.fnGetData( aPos[0] );
});
                },
          aoColumns: [ { "bVisible": false} , null, null, null, null ]
                      }
                      ).makeEditable({
sUpdateURL: "UpdateData.php",
sAddURL: "AddData.php",
sAddHttpMethod: "GET",
sDeleteURL: "http://localhost/questions/Test/DeleteData",
sDeleteHttpMethod: "GET",
});
      } );
—————————————————————————————————-

Waiting for reply.

although your question is datatables specific, we’re kind enough to answer you 😉

take note of the submitdata parameter here: http://www.datatables.net/examples/api/editable.html

with that in mind, you can do some editing like this:

'submitdata':
        function(value, settings)
        {
          var k = -1, e = this, column;

          while(e){
            if('previousSibling' in e)
            {
              e = e.previousSibling;
              k = k + 1;
            }
            else
            {
              k = -1;
              break;
            }
          }

          switch(k)
          {
            case 1 : column = 'name'; break;
            case 2 : column = 'email'; break;
            default: column = 'password'; break;
          }

          return { 'column' : column, 'operator_id' : this[removed].firstChild[removed] }
        }

For the images what i did was this

$this->datatables->edit_column('job.level', '.base_url().', 'job.level');

and change the name of file.

For example i only have 2 types of jobs levels “I” and “F” so i change the filename from incBackup.png for I.png and F.png.

i think in this case its better than creating a database helper.

But it’s nice to know that is possible to create helpers and using functions.

thank you very much for you r reply

This is the code…

var oTable;
var aData;
var row;

$(document).ready(function() {

$('#example tbody tr').live('click', function (event) {

$(oTable.fnSettings().aoData).each(function (){
$(this.nTr).removeClass('row_selected');
});

        $(event.target[removed]).addClass(‘row_selected’); 
        aData = oTable.fnGetData(this); // get datarow
        row = $(this).closest(“tr”).get(0);
      });

        /* Add a click handler for the delete row */
          $(’#delete’).click( function() {
$.ajax({
type: "GET",
url: "<?php echo base_url(); ?>Test/DeleteData",
data: "id="+aData[0],
success: function(msg){
//oTable.fnDeleteRow(aData);
var anSelected = fnGetSelected( oTable );
oTable.fnDeleteRow( anSelected[0] );
oTable.fnDeleteRow(oTable.fnGetPosition(row));
}
        });   
          } );

        /* Init the table */
          oTable = $(’#example’).dataTable( {
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "<?php echo base_url(); ?>Test/Listener",
"sPaginationType": "full_numbers",
"iDisplayLength": 1,
"bSortClasses": false,
"aoColumns": [ { "bVisible": false} , null, null ]
          } ); 

        } ); 
        /* Get the rows which are currently selected */
        function fnGetSelected( oTableLocal )
        {
var aReturn = new Array();
var aTrs = oTableLocal.fnGetNodes();

for ( var i=0 ; i<aTrs.length ; i++ )
{
if ( $(aTrs).hasClass('row_selected') )
{
aReturn.push( aTrs );
}
          }
          return aReturn;
        }
What is happening :-
The server side data gets loaded when page is called for the first time.
The server side data gets deleted on clicking delete link.But the Datatable doesnt refresh after deleting a row on server.The usual “processing” message comes after deletion on server.It stays there.The UI row stays there highlighted with message “Processing” in the middle of the page