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 GEO下载数据的处理报错 :函数‘Meta’标签‘"data.frame"’找不到继承方法,如何解决?
      • ¥15 DLNM模型是否可以用二分类变量作为y变量
      • ¥15 android object box 一个实体多个表怎么写
      • ¥15 temux 启用docker 服务失败
      • ¥15 Flask 使用celery发送邮件出现‘目标计算机积极拒绝‘
      • ¥60 老人用的sd卡在手机里面不知道操作了什么,导致图片和视频变成了文件,取下sd卡连接电脑就是图中的样子,后缀改为.jpg才可以,需要用系统的画图软件才能打开,文件属性还是文件,有没有批量操作的解决办法
      • ¥15 超时跳出方法代码的返回值问题
      • ¥15 汇编语言程序设计设计,ascii码求数,再求数的BCD码
      • ¥30 Mask rcnn训练自己的数据集出现问题!
      • ¥20 研究人工智能时的几个问题