js datatable

<div class="dataTable_wrapper">
                <table class="table table-striped table-bordered table-hover" id="datatable">
                    <thead>
                        <tr>
                            <th>注册时间</th>
                            <th>用户名</th>
                            <th>电话号码</th>
                            <th>关注状态</th>
                            <th>所在区域</th>
                            <th>未提佣金</th>
                            <th>已提佣金</th>
                            <th>推荐人</th>
                            <th>操作</th>
                        </tr>
                    </thead>
                </table>
            </div>

 var table = $("#datatable").dataTable({
            "processing": true,
            "serverSide": true,
            "searching": false,
            "ordering": false,
            "bLengthChange": false, //去掉每页显示多少条数据方法
            "iDisplayLength": 10,
            "stateSave": true,
            "oLanguage": {//对表格国际化  
                "sLengthMenu": "每页显示 _MENU_条",
                "sZeroRecords": "没有找到符合条件的数据",
                //  "sProcessing": "<img src=’./loading.gif’ />",    
                "sInfo": "当前第 _START_ - _END_ 条　共计 _TOTAL_ 条",
                "sInfoEmpty": "木有记录",
                "sInfoFiltered": "(从 _MAX_ 条记录中过滤)",
                "sSearch": "搜索：",
                "oPaginate": {
                    "sFirst": "首页",
                    "sPrevious": "前一页",
                    "sNext": "后一页",
                    "sLast": "尾页"
                }},
            "columnDefs": [
                {"searchable": true, "targets": 1}
            ],
            "ajax": {
                "url": "<{spUrl c=proxyusermanager a=getlist}>",
                "dataSrc": "data",
                "data": function(d) {
                    //添加额外的参数传给服务器  
                    d.search_usernameorname = $("#search_usernameorname").val();
                    d.search_phone = $("#search_phone").val();
                    d.search_subscribe = $("#search_subscribe").val();
                    d.search_district = $("#search_district").val();
                    d.search_citycode = $("#search_citycode").val();
                    d.search_register_start = $("#search_register_start").val();
                    d.search_register_end = $("#search_register_end").val();
                    d.search_login_start = $("#search_login_start").val();
                    d.search_login_end = $("#search_login_end").val();
                    d.search_unpaycommission_start = $("#search_unpaycommission_start").val();
                    d.search_unpaycommission_end = $("#search_unpaycommission_end").val();
                    d.search_paidcommission_start = $("#search_paidcommission_start").val();
                    d.search_paidcommission_end = $("#search_paidcommission_end").val();
                    d.search_tuijian_usernameorname = $("#search_tuijian_usernameorname").val();
                    d.search_tuijian_phone = $("#search_tuijian_phone").val();
                    d.search_status = $("#search_status").val();
                    d.search_idcard_no = $("#search_idcard_no").val();
                }
            },
            "columns": [
                {"data": "register_date", "bSortable": false},
                {"data": "username"},
                {"data": "mobile"},
                {"data": "subscribe"},
                {"data": "districtname"},
                {"data": "unpay_commission"},
                {"data": "paid_commission"},
                {"data": "tuijianren_username"}

            ],
            "columnDefs": [
                {
                    "targets": [8],//表示要具体操作的目录列
                    "data": "id",//某一列数据对应的属性名
                    "render": function(data, type, full) {//返回需要显示的内容
                        return '<a class="edittrinfo" id="' + data + '" trid="' + data + '" href="javascript:void(0)">查看/编辑</a>';
                    }
                }
            ]
        });

 function getlist(){
        $this->checkpermission(array('e29f85d34be744d99b9812fd4e91ef27'));
        $draw=$_GET['draw'];
        $search_usernameorname=$this->spArgs("search_usernameorname");
        $id=$this->spArgs("id");
        $search_phone=$this->spArgs("search_phone");
        $search_subscribe=$this->spArgs("search_subscribe");
        $search_district=$this->spArgs("search_district");
        $search_citycode=$this->spArgs("search_citycode");
        $search_register_start=$this->spArgs("search_register_start");
        $search_register_end=$this->spArgs("search_register_end");
        $search_login_start=$this->spArgs("search_login_start");
        $search_login_end=$this->spArgs("search_login_end");
        $search_unpaycommission_start=$this->spArgs("search_unpaycommission_start");
        $search_unpaycommission_end=$this->spArgs("search_unpaycommission_end");
        $search_paidcommission_start=$this->spArgs("search_paidcommission_start");
        $search_paidcommission_end=$this->spArgs("search_paidcommission_end");
        $search_tuijian_usernameorname=$this->spArgs("search_tuijian_usernameorname");
        $search_tuijian_phone=$this->spArgs("search_tuijian_phone");
        $search_status=$this->spArgs("search_status");
        $search_idcard_no=$this->spArgs("search_idcard_no");

        $start=$this->spArgs("start",0);
        $length=$this->spArgs("length",10);
        
        $condition= " 1=1";
        if ($id) {
            $condition .= " and proxy_user.id = '".$id."'";
        }
        if ($search_usernameorname) {
            $search_usernameorname=  urldecode($search_usernameorname);
            $condition .= " and (proxy_user.username like '%".$search_usernameorname."%' or proxy_user.real_name like '%".$search_usernameorname."%')";
        }
        if ($search_phone) {
            $search_phone=  urldecode($search_phone);
            $condition .= " and proxy_user.mobile like '%".$search_phone."%'";
        }
        if ($search_subscribe) {
            $search_subscribe=  urldecode($search_subscribe);
            $condition .= " and proxy_user.subscribe='".$search_subscribe."'";
        }
        /*
        if ($search_district) {
            $search_district=  urldecode($search_district);
            $condition .= " and proxy_user.districtname like '".$search_district."%'";
        }*/
        if($search_citycode){
            $condition .= " and proxy_user.districtcode like '".$search_citycode."%'";
        }
        
        if ($search_register_start) {
            $search_register_start=  urldecode($search_register_start);
            $condition .= " and proxy_user.register_date >= '".$search_register_start."'";
        }
        if ($search_register_end) {
            $search_register_end=  urldecode($search_register_end);
            $condition .= " and proxy_user.register_date <= '".$search_register_end."'";
        }
        if ($search_login_start) {
            $search_login_start=  urldecode($search_login_start);
            $condition .= " and proxy_user.last_login_date >= '".$search_login_start."'";
        }
        if ($search_login_end) {
            $search_login_end=  urldecode($search_login_end);
            $condition .= " and proxy_user.last_login_date <= '".$search_login_end."'";
        }
        if ($search_unpaycommission_start) {
            $search_unpaycommission_start=  urldecode($search_unpaycommission_start);
            $condition .= " and proxy_user.unpay_commission >= '".$search_unpaycommission_start."'";
        }
        if ($search_unpaycommission_end) {
            $search_unpaycommission_end=  urldecode($search_unpaycommission_end);
            $condition .= " and proxy_user.unpay_commission <= '".$search_unpaycommission_end."'";
        }
        if ($search_paidcommission_end) {
            $search_paidcommission_end=  urldecode($search_paidcommission_end);
            $condition .= " and proxy_user.paid_commission <= '".$search_paidcommission_end."'";
        }
        if ($search_paidcommission_start) {
            $search_paidcommission_start=  urldecode($search_paidcommission_start);
            $condition .= " and proxy_user.paid_commission >= '".$search_paidcommission_start."'";
        }
        if ($search_status||$search_status==='-1') {
            $condition .= " and proxy_user.status='".$search_status."'";
        }
        if ($search_idcard_no) {
            $condition .= " and proxy_user.idcard_no like '%".$search_idcard_no."%'";
        }
        if ($search_tuijian_phone) {
            $search_tuijian_phone=  urldecode($search_tuijian_phone);
            $condition .= " and tuijianren.mobile like '%".$search_tuijian_phone."%'";
        }
        if ($search_tuijian_usernameorname) {
            $search_tuijian_usernameorname=  urldecode($search_tuijian_usernameorname);
            $condition .= " and tuijianren.username like '%".$search_tuijian_usernameorname."%'";
        }
        $lib_proxy_user=  spClass("lib_proxy_user");
        $results = $lib_proxy_user->findSql("select "
                . "proxy_user.id,"
                . "proxy_user.register_date,"
                . "proxy_user.username,"
                . "proxy_user.mobile,"
                . "proxy_user.subscribe,"
                . "proxy_user.districtname,"
                . "proxy_user.unpay_commission,"
                . "proxy_user.paid_commission,"
                . "tuijianren.username as tuijianren_username,"
                . "tuijianren.mobile as tuijianren_phone "
                . "from proxy_user as proxy_user left join proxy_user as tuijianren on proxy_user.parent_user_id=tuijianren.id "." where ".$condition." order by proxy_user.register_date desc limit $start,$length");
        $recordsTotal = $lib_proxy_user->findSql("select count(*) as recordsTotal from proxy_user");
        $recordsFiltered = $lib_proxy_user->findSql("select count(*) as recordsFiltered from proxy_user as proxy_user left join proxy_user as tuijianren on proxy_user.parent_user_id=tuijianren.id "." where ".$condition);
        $data=array(
            "draw"=>$draw,//请求次数
            "recordsTotal"=>intval($recordsTotal[0]['recordsTotal']),//总记录数
            "recordsFiltered"=>intval($recordsFiltered[0]['recordsFiltered']),//过滤后的总记录数
            "data"=>$results//具体的数据对象数组
        );
        
        echo json_encode($data);
        exit;
    }