Ignited DataTables

[eluser]okbang[/eluser]
Mother's Day is arriving, making it the period given our budget in order to seem to invest in a reward together with exhibit the great absolutely adore and because of excellent favorite mommies. In spite of this, at this time achieve their objectives . reasonably nearly impossible to find the right mother daily things. A good number of our own new mothers continue to comply with the fashion; fot that reason, this kind items while tulips or sometimes lps are not to be pleasing enough to that lead. We have to amount most of the precious ought to have and select the most appropriate products.Now, My goal is to propose some kind of special and so designer christmas presents available for way and so hot and spicy parents.--------------
-----------------
-------------------------

[eluser]Unknown[/eluser]
I love this library! It's made my life so much easier over the past few days, I really appreciate all the work that went into it!

Everything is working wonderfully except for the search bar. I have to re-query the same table once I know what the User's Id is because users can belong to other users based on their roles. For instance, a User with a role of Agent has a GeneralAgent and and MarketingOrg. The GA and the MO are in the same table so I take the IDs and get the names from them.

Once this happens, the columns contain names instead of IDs. The search bar doesn't seem to be able to search the new column values. Is there a work around for this?

My Listener looks like this:

Code:

$this->load->helper('datatables');
        $this->datatables->select('Contracts.Id, Contracts.GeneralAgentID AS Ga, Contracts.AgentID AS Agent, Contracts.SellerID AS Seller, Locations.Name AS Location, Contracts.CoverageStartDate AS Date, Plans.PlanName, Plans.MOUnitCost')
                         ->where('Contracts.MarketingOrgID', $_SESSION['Id'])
                         ->from('Contracts')
                         ->join('Plans', 'Contracts.PlanID = Plans.Id')
                         ->join('Locations', 'Contracts.LocationID = Locations.Id')
                         ->edit_column('Ga', '$1', 'get_name_by_id(Ga)')
                         ->edit_column('Agent', '$1', 'get_name_by_id(Agent)')
                         ->edit_column('Seller', '$1', 'get_name_by_id(Seller)')
                         ->edit_column('Date', '$1', 'dateformat(Date)')

[eluser]samseko[/eluser]
Hi, how do i remove the pagination - that is, i want to show all items on the same page?!

I thought "sDom": 'f' or 't' did that in the html script area but it isnt doing anything?

[Edit] NM, i just commented $this->get_paging(); in the library.

[eluser]Seth Setiadha[/eluser]
guys, I'm using the code that written by saimaz
i'm wondering why it doesnt work, it only shows pop-up with text "processing"

the funny thing is that between the file that it's put in javascript from saimaz and the original file (from datatable website) has the same result

any ideas?

[eluser]cryogenix[/eluser]
[quote author="Seth Setiadha" date="1327477834"]guys, I'm using the code that written by saimaz
i'm wondering why it doesnt work, it only shows pop-up with text "processing"

the funny thing is that between the file that it's put in javascript from saimaz and the original file (from datatable website) has the same result

any ideas?
[/quote]

who or which code are you referring to (link please)? and can you show us your code?

[eluser]Seth Setiadha[/eluser]
http://ellislab.com/forums/viewthread/16...30/#833732

my javascript in header is as follow

[removed]
$(document).ready(function() {
$('#example').dataTable( {
"bProcessing": true,
"aaSorting": [[ 1, "desc" ]],
"bServerSide": true,
"sAjaxSource": "<?php echo base_url(); ?>poli/poliumumlist",
"sScrollY": 200,
"bJQueryUI": true,
"sPaginationType": "full_numbers"
} );
} );

function fnShowHide( iCol ) {
var oTable = $('#example').dataTable();

var bVis = oTable.fnSettings().aoColumns[iCol].bVisible;
oTable.fnSetColumnVis( iCol, bVis ? false : true );
}
[removed]


the result from /poli/poliumumlist is a below
{"sEcho":0,"iTotalRecords":"4","iTotalDisplayRecords":"4","aaData":[["7","24 Jan 2012","005000430","Sutono","L","41","Ya",null],["2","24 Jan 2012","005000110","Sudrajat","L","31","Ya","Mario"],["1","23 Jan 2012","005000120","Sutini","P","22","Ya","Isabel"],["6","23 Dec 2011","099000231","Agung","L","27","Ya","Mario"]]}

[eluser]cryogenix[/eluser]
and what is your controller code?

[eluser]Ferry Lukito[/eluser]
please help

why this code is work for me

Code:

$(document).ready(function()
    {
        $('#sortable_table').dataTable({
            "sScrollY": 430,
            "bJQueryUI": true,
            "sPaginationType": "full_numbers",
            "bProcessing": true,
            "bServerSide": true,
            "sAjaxSource": "<?php echo base_url(); ?>index.php/customers/getall"
        });
    });

and this code is'nt work

Code:

$(document).ready(function()
    {
        $('#sortable_table').dataTable({
            "sScrollY": 430,
            "bJQueryUI": true,
            "sPaginationType": "full_numbers",
            "bProcessing": true,
            "bServerSide": true,
            "sAjaxSource": "<?php echo base_url(); ?>customers/getall"
        });
    });

is there need setup the route ?
thanks.

[eluser]cryogenix[/eluser]
[quote author="Ferry Lukito" date="1328191875"]please help

why this code is work for me

Code:

$(document).ready(function()
    {
        $('#sortable_table').dataTable({
            "sScrollY": 430,
            "bJQueryUI": true,
            "sPaginationType": "full_numbers",
            "bProcessing": true,
            "bServerSide": true,
            "sAjaxSource": "<?php echo base_url(); ?>index.php/customers/getall"
        });
    });

and this code is'nt work

Code:

$(document).ready(function()
    {
        $('#sortable_table').dataTable({
            "sScrollY": 430,
            "bJQueryUI": true,
            "sPaginationType": "full_numbers",
            "bProcessing": true,
            "bServerSide": true,
            "sAjaxSource": "<?php echo base_url(); ?>customers/getall"
        });
    });

is there need setup the route ?
thanks.[/quote]

maybe you didn't setup aoColumns?

[eluser]ηυмвєяσηє[/eluser]
Probably he didnt / couldnt setup .htaccess file.