weixin_33709219 2016-02-12 13:41 采纳率: 0%
浏览 17

Yii2 + jQuery数据表+ Ajax

I am new to Yii and need some help.

I am using Yii2.

I have a page where I use DataTable trying to populate it with ajax from the database. The data returned from the controller does not display in the table.

I installed the DataTable extension. I installed yadcf

My html:

 <table class="table table-bordered" id='invoicesTbl'>
   <thead>
    <tr>
      <th>Customer</th>
    </tr>
  </thead>
</table>

My ajax controller has this function:

public function actionGetinvoices() {
    $company_id = isset($this->dataBody['company_id'])?$this->dataBody['company_id']:null;

    if ($company_id === null) 
        $this->sendResponse(501,array('error'=>'Invalid company found'));

    $output = array();
    $output['aaData'] = '';

    $invoices = InvoiceDiscountReport::getInvoices($company_id);

    $aColumns = array('invoice_discount_report__debtor__name');

    if(!empty($invoices))
    {
        foreach($invoices as $inv)
        {
            $row = array();
            for($i=0; $i<count($aColumns); $i++)
            {
                    $row[] = $inv[$aColumns[$i]];

            }

            $output['aaData'][] = $row;
        }
    }

    $this->sendResponse(200,$output);
}

My js file has this code:

var myTable = $('#invoicesTbl').DataTable({
    retrieve: true,
    paging: false,
    "language": {
        "emptyTable": "There are no invoices for the company",
    "bProcessing": true,
    "bDestroy": true,
    "sAjaxSource": '/api/dashboard/getinvoices&company_id=49',
    "bAutoWidth": true,
    "aaSorting": [[ 0, "asc" ]],
    "aoColumns": [
        { "bSortable": true, "sWidth": "100%" },
    ],
}
});

yadcf.init(myTable, [
{column_number : 0, filter_type: "text", text_data_delimiter: ","}
],'footer');
});

The data returned from my controller looks like this: {"aaData":[["SIGAL ZAHAVI"]]}

What I get is an empty table with: There are no invoices for the company.

Can someone please help me and tell what am I doing wrong?

Thank you

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
    • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
    • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
    • ¥30 3天&7天&&15天&销量如何统计同一行
    • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
    • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
    • ¥15 vs2019中数据导出问题
    • ¥20 云服务Linux系统TCP-MSS值修改?
    • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
    • ¥20 怎么在stm32门禁成品上增加查询记录功能