datatables如何把列设置成hidden隐藏域？ 

官网：https://datatables.net/reference/option/
设置： visible: false
如下：


<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
 
    <script src="../../js/jquery-1.9.1.min.js"></script>
    <script src="../../js/layer/layer.js"></script> 
    <script src="../../js/public.js"></script>
     
    <script src="../../js/datatables/jquery.dataTables.min.js"></script>
   
</head>
 

<body>

<div align="center" style="width: 99%;">
    <table id="dataGrid" align="center"  border="1" style="width: 100%;">
        <thead>
        <tr>
            <th style="display: none">patrolRecordId</th>
            <th align="center" class="table_title">巡视班组</th>
            <th align="center" class="table_title">巡视人</th>
            <th align="center" class="table_title">巡视开始时间</th>
            <th align="center" class="table_title">巡视结束时间</th>
            <th align="center" class="table_title">图片</th>
        </tr>
        </thead>
        <tbody>
        </tbody>
    </table>
</div>

<div align="right">
    <button style="width:80px;background-color: #9CE6F2" onclick="window.history.back()" >关闭</button>
</div>

</body>

<script type="application/javascript">

document.addEventListener("deviceready", onDeviceReady, false);
function onDeviceReady() {
    console.log("页面初始化");
    if(mam.navigator){
        initData();
    }else {
        $(function() {
            initData();
        });
    }
}

function initData() {
    var recordParams = {};
    var queryKey = "";
    var queryType = getQueryVariable("queryType");
    if(queryType == "byFeedbackId"){
        queryKey = "PATROL_RECORD";
        var feedbackId = getQueryVariable("feedbackId");
        recordParams.feedbackId = feedbackId;
    }else if(queryType == "byFormId"){
        queryKey = "PATROL_RECORD_LIST";
        var warningFormId = getQueryVariable("warningFormId");
        var operationKey = getQueryVariable("operationKey");
        recordParams.warningFormId = warningFormId;
        recordParams.operationKey = operationKey;
    }


    var data = [];
    exAjax("postJSON",queryKey,recordParams,"WARN_DATA",function(e){
        if(notEmptyStr(e.recordList) && e.recordList.length > 0){
            data = e.recordList;
            // console.dir(data);

            var table = $('#dataGrid').DataTable({
                "scrollY" : $(document).height()*0.65,
                "scrollCollapse" : true,//滚动
                "paging" : false,
                "searching" : false,//去除搜索栏
                "language" : {
                    "info" : "",
                    // "zeroRecords"    : "没有找到记录",
                    "zeroRecords"    : " ",
                    "infoEmpty" : "没有查询到相关数据！"
                },
                "ordering": false,
                "drawCallback" : function(){
                    // this.api().column("photo:name").nodes().each(function(cell, i) {
                    //     cell.innerHTML = "<a onclick='patrolDocList(patrolRecordId)'>图片</a>"
                    // });

                    var dataTable = this.api();

                    this.api().rows().nodes().each(function(cell, i) {
                        var patrolRecordId = dataTable.cell(i,0).data();
                        cell.cells[4].innerHTML = "<a onclick=\"patrolDocList('"+patrolRecordId+"')\">图片</a>";//图片栏
                    });

                },

                data: data,
                columns: [
                    {
                        data: 'patrol_record_id',
                        visible: false
                    },
                    {
                        data: 'org_name',
                        width: "20%"
                    },
                    {
                        data: 'patrol_user_name',
                        width: "16%"
                    },
                    {
                        data: 'patrol_start_time',
                        width: "28%"
                    },
                    {
                        data: 'patrol_end_time',
                        width: "28%"
                    },
                    {
                        data: {},
                        name: 'photo'
                    }//图片
                ]
            });
        }

    });
}

 
function patrolDocList(patrolRecordId) {
    console.dir(patrolRecordId);
}



</script>
</html>

posted on 2018-08-15 15:22  小甜瓜安东泥  阅读(1186)  评论(0)  编辑  收藏  举报