如何在cakephp2.6中将json文件发送到dataTable

$ cake bake controller Json

public function sendJsonToDataTable() {
    // 设置响应类型为JSON
    $this->autoRender = false;
    $this->response->type('json');

    // 获取JSON数据
    $jsonData = $this->YourModel->find('all');

    // 将JSON数据转换为DataTable所需的格式
    $dataTableData = array();
    foreach ($jsonData as $data) {
        $dataTableData[] = array(
            $data['YourModel']['field1'],
            $data['YourModel']['field2'],
            // 添加更多字段...
        );
    }

    // 发送JSON数据到DataTable
    echo json_encode(array('data' => $dataTableData));
}

<table id="dataTable"></table>

<script>
$(document).ready(function() {
    $('#dataTable').DataTable({
        ajax: {
            url: '<?php echo $this->Html->url(array('controller' => 'json', 'action' => 'sendJsonToDataTable')); ?>',
            dataSrc: 'data'
        },
        columns: [
            { data: 'field1' },
            { data: 'field2' },
            // 添加更多字段...
        ]
    });
});
</script>