dongzaobei0942 2019-01-28 18:28
浏览 411

错误:DataTables警告:table id = DataTables_table_0 - Ajax错误。 在Laravel

I was using from a Laravel project well, But today, this error appears on one of the pages:

Error: DataTables warning: table id=DataTables_table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

The recourses codes:

@extends('admin.layouts.app')
@section('title', getOption('app_name') . ' - Orders')
@section('content')
    @php
        $status = $status ?? false;
        $dataURL = $status ? "/admin/orders-filter-ajax/$status/data" : "/admin/orders-ajax/data";
    @endphp
    <div class="row">
        <div class="col-md-12" style="margin-bottom: 5px;">
            <div class="btn-group">
                <button type="button" class="btn btn-info btn-sm hide" id="apply-all">Apply</button>
            </div>
            <div class="btn-group">
                <a href="{{ url('/admin/orders/') }}" class="btn btn-default btn-sm btn btn-default btn-sm {{ $status == false ? 'active' : '' }}">ALL</a>
                <a href="{{ url('/admin/orders-filter/pending') }}" class="btn btn-default btn-sm {{ $status == 'pending' ? 'active' : '' }}">Pending</a>
                <a href="{{ url('/admin/orders-filter/inprogress') }}" class="btn btn-default btn-sm {{ $status == 'inprogress' ? 'active' : '' }}">In Progress</a>
                <a href="{{ url('/admin/orders-filter/completed') }}" class="btn btn-default btn-sm {{ $status == 'completed' ? 'active' : '' }}">Completed</a>
                <a href="{{ url('/admin/orders-filter/partial') }}" class="btn btn-default btn-sm {{ $status == 'partial' ? 'active' : '' }}">Partial</a>
                <a href="{{ url('/admin/orders-filter/refunded') }}" class="btn btn-default btn-sm {{ $status == 'refunded' ? 'active' : '' }}">Refunded</a>
                <a href="{{ url('/admin/orders-filter/cancelled') }}" class="btn btn-default btn-sm {{ $status == 'cancelled' ? 'active' : '' }} ">Cancelled</a>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-12">
            <div class="panel panel-default">
                <div class="panel-body">
                    <form id="frm-apply-all" action="{{ url('/admin/orders-bulk-update') }}" method="post">
                        {{ csrf_field() }}
                    </form>
                    <div class="table-responsive">
                        <table class="table table-bordered mydatatable table-hover" style="width: 99.9%">
                            <thead>
                            <tr>
                                <th><input type="checkbox" class="input-sm checkbox-all"></th>
                                <th>@lang('general.order_id')</th>
                                <th>Api @lang('general.order_id')</th>
                                <th>@lang('general.user')</th>
                                <th>@lang('general.service')</th>
                                <th>@lang('general.package')</th>
                                <th>@lang('general.link')</th>
                                <th>@lang('general.amount')</th>
                                <th>@lang('general.quantity')</th>
                                <th>@lang('general.start_counter')</th>
                                <th>@lang('general.remains')</th>
                                <th>@lang('general.status')</th>
                                <th>@lang('general.date')</th>
                                <th class="text-center" width="5%">@lang('general.action')</th>
                            </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@push('scripts')
    <script>
        $(function () {

            $('.mydatatable').DataTable({
                processing: true,
                serverSide: true,
                pageLength: 25,
                order: [[1, 'desc']],
                ajax:'{!! url($dataURL) !!}',

                columns: [
                    {data: 'bulk', name: 'bulk', orderable: false, searchable: false},
                    {data: 'id', name: 'id'},
                    {data: 'api_order_id', name: 'api_order_id'},
                    {data: 'user.name', name: 'user.name'},
                    {data: 'package.service.name', name: 'package.service.name'},
                    {data: 'package.name', name: 'package.name'},
                    {data: 'link', name: 'link'},
                    {data: 'price', name: 'price', sortable: false, searchable: false},
                    {data: 'quantity', name: 'quantity', sortable: false, searchable: false},
                    {data: 'start_counter', name: 'start_counter', sortable: false, searchable: false},
                    {data: 'remains', name: 'remains', sortable: false, searchable: false},
                    {data: 'status', name: 'status'},
                    {data: 'created_at', name: 'created_at'},
                    {data: 'action', name: 'action', orderable: false, searchable: false},
                ]
            });

            $(document).on('click', '.checkbox-all', function () {
                $('.row-checkbox').trigger('click');
                $('#apply-all').removeClass('hide');
            });

            $(document).on('click', '.row-checkbox', function () {
                $('#apply-all').removeClass('hide');
                var t = $(this);
                if (t.is(':checked')) {
                    t.parents('tr').find('.row-edit').removeAttr('readonly');
                    t.parents('tr').attr('style', 'background-color:#dedede');
                } else {
                    t.parents('tr').find('.row-edit').attr('readonly', 'readonly');
                    t.parents('tr').removeAttr('style');
                }

            });

            $('#apply-all').on('click', function (e) {

                var form = $('#frm-apply-all');
                var isAnyRowSelected = false; // check if it shouldn't submit empty form

                bootbox.confirm({
                    message: "Confirm to apply bulk update?",
                    buttons: {
                        cancel: {
                            label: 'Cancel',
                            className: 'btn-default'
                        },
                        confirm: {
                            label: 'Confirm',
                            className: 'btn-primary'
                        },
                    },
                    callback: function (result) {
                        if (result) {
                            // Iterate over all checkboxes in the table
                            $('.row-checkbox').each(function () {

                                var t = $(this);

                                if (t.is(':checked')) {

                                    isAnyRowSelected = true; // Row selected

                                    // Order id
                                    $(form).append(
                                        $('<input>')
                                            .attr('type', 'hidden')
                                            .attr('name', t.attr('name'))
                                            .val(t.val())
                                    );
                                    // start count
                                    $(form).append(
                                        $('<input>')
                                            .attr('type', 'hidden')
                                            .attr('name', 'start_counter[' + t.val() + ']')
                                            .val($('input[name="start_counter[' + t.val() + ']"]').val())
                                    );
                                    // remains
                                    $(form).append(
                                        $('<input>')
                                            .attr('type', 'hidden')
                                            .attr('name', 'remains[' + t.val() + ']')
                                            .val($('input[name="remains[' + t.val() + ']"]').val())
                                    );
                                    // status
                                    $(form).append(
                                        $('<input>')
                                            .attr('type', 'hidden')
                                            .attr('name', 'status[' + t.val() + ']')
                                            .val($('select[name="status[' + t.val() + ']"]').find(':selected').text())
                                    );
                                }
                            });

                            if (isAnyRowSelected) {
                                form.submit();
                            }
                        }
                    }
                });

            });

        });
    </script>
@endpush

I didn't change any thing in my project today It worked yesterday well:(

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 求差集那个函数有问题,有无佬可以解决
    • ¥15 MATLAB动图问题
    • ¥15 【提问】基于Invest的水源涵养
    • ¥20 微信网友居然可以通过vx号找到我绑的手机号
    • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
    • ¥15 解riccati方程组
    • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
    • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
    • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
    • ¥50 树莓派安卓APK系统签名